If you need to analyse data then this is the course for you.
Many people use Excel to analyse data, and this works well for simple data sets that can be represented by a single table with less than a million rows. Even then Excel doesn't make it easy to produce good looking and easily shareable reports and dashboards.
Whether the data source is spreadsheet, database or involves pulling data from several different files or systems, then Power BI will make your life easier. Building reports and dashboards from this data and subsequently sharing the results is exactly what it's designed to do.
Getting Started with Power BI Desktop
- Power BI Concepts and Overview
- Introduction to Main Features
- Imports
- Visualizations
- Filters and Queries
- Reports
Connecting to Data Sources with Power BI Desktop
- Data Sources Power BI Desktop will connect to
- Data Types and Properties in Power BI Desktop
- Import and Enter Data
- Get Data and Query Editor
- Introducing the Query Editor
- Using the Query Editor to Connect to Data
- Combining Data Sources as a Mash Up
- Working with Relationships in Data
Data Visualizations
- Overview of Data Visualizations
- Tables and Matrix Views
- Applying Conditional Formats
- Charts
- Interactive Data and Date Slicers
- Drill Visualizations to see underlying data
- Create Reusable Field Hierarchies
- Record Grouping and Binning in Visualizations
- Drill Visualizations with using Dates
- Clustering
- Analytics and Forecast Lines in Visualizations
- Creating Role Based Views
- Data Categories, Geo-Data and Maps
Querying and Shaping the Data
- Common Activities using Query Editor
- Filters
- Transforms
- Pivot and Group By
- Creating Custom Calculated Columns
- Adding Conditional Columns
- Introduction to DAX Expressions
- Histograms
Reports and Output Options
- Report Elements and Options
- Working with Pages
- Adding Graphics
- Visual and Filter Settings
- Export Power BI Data to CSV
- Create a Power BI Template
The course runs from 9:30am through to 4:30pm.
You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.
Included with your course
We provide the following with online and training centre delivered courses.
- Course notes
- Certificate of attendance
- 90 days post course support
Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.
- See Virtual / Remote training information for more details
- Contact us if you'd like to test the platform before the morning of the course
- You can be located anywhere in the world with an internet connection and your computer
Our Training Centres
For training courses run at one of our training centres we include.