Learn the basic principles of Power BI in two days
You may have heard of Power BI and already have seen a few examples in the form of visually appealing dashboards and reports. But how do you get started with it?
In this two-day course we will look at the various phases you need to cover. We will retrieve our data via queries, create a data model with the necessary relationships and calculations, build an interactive report and publish it in the cloud. Finally we will create a dashboard in the cloud that we can share with colleagues.
Choose a date and location
After completing this course you will be able to:
- Import data via queries
- Use queries to transform tables into usable, meaningful data
- Create a data model with relationships, custom sort orders, date dimension tables etc.
- Create reports in a Power BI Desktop environment
- Create reports and dashboards in a Power BI Service environment
- Share reports and dashboards with colleagues
Anyone wishing to gain a solid grounding in creating and sharing reports and dashboards via Power BI.
Prior knowledge of Power BI is not required. Familiarity with entering functions manually in Excel would be a bonus since you will not have a function wizard in Power BI.
Part 1: Power BI
- What are the components of Power BI?
- What is the difference between Power BI Desktop and Power BI Service?
Part 2: Queries
- Importing data
- Converting data (remove duplicates, delete records, filter, add columns, unpivot)
- Expanding tables with data from other tables (compare Vlookup)
- Comparing tables (What is common to them? What is only in table 1? What is the total of these 2 or more tables?)
- Arranging similar tables horizontally
Part 3: Data Modelling
- The different data types
- Relationships between tables
- Defining a date dimension table
- Defining custom sort orders
- Setting up data categories
- Hiding (auxiliary) columns from the model
- Calculated columns
- Measures (general functions, filter functions)
Part 4: Reports in Power BI Desktop
- Components of a report
- Working with tiles
- Standard visualisation options (stacked bar, stacked column, area, treemap, map, pie, slicers etc.)
- Ad hoc filters
- Filters in a report (visual level filters, page level filters, report level filters)
- Publication to Power BI Service
Part 5: Power BI Service
- Refreshing datasets
- Difference between reports and dashboards
- Creating dashboards
- Quick insights
- Q&A (ad hoc questions about the dataset)
- Publishing data from Excel directly to dashboards
Part 6: Sharing
- Sharing a dashboard with colleagues
- Embedding a report in e.g. a SharePoint page
Choose a date and location