In this course we will learn tips and tricks to add onto your prior knowledge of Power BI.

The emphasis is on tips and tricks that can help the participants take the next step in their Power BI journey as well as best practices in Power Query, data modelling and reporting.

We will cover more advanced techniques in Power Query, data modelling best practices, report design and storytelling techniques.

Power BI comes in two different versions, free and paid. This course will use the free version so there is no need to have any kind of Power BI license to attend the course.

The participants need to come with their own laptop with Power BI Desktop installed.

The course contains the following:

Ingesting data in Power BI Desktop

• Importing data from folder
• Pivot and Unpivot
• Add columns
• Functions
• Append and Merge queries
• Last updated date
• SharePoint and OneDrive for Business as source
• Organizing queries

Modelling in Power BI

• Star schema
• Different cardinality
• Relationships
• Modelling views
• Auto Date/Time Hierarchies
• Row level security

Reporting

• Power BI Theming
• Background images
• Custom visualizations
• Storytelling with bookmarks, drillthrough, report page tooltip and DAX

Data flows

• What is Power BI data flows?
• Reusing your logic
• Dependencies
• Scheduling and sharing

What you gain from the course:

• Advance your Power BI skills
• Learn best practices
• Learn tips and tricks when importing data
• Learn to present more compelling reports

Who should attend this course:

This course is best suited for users with some Power BI knowledge that want to take the next step in their Power BI journey. It is assumed that the participants know the basics of Power BI and how some experienced in using it.