This course delivers an instructor-led breakdown of Microsoft Power BI. Students will be taught how to design reports that will work with a variety of data sources. Power BI lends something to everyone from beginners who wish to leverage existing data sources to build engaging dashboards right up to knowledgeable users who may query data sources and construct data models to fuel business reports. We will take users through a selection of well-crafted lessons to help them build new reporting capabilities for their business.
Audience
This course is for students that are looking to learn how to use the range of Microsoft Power BI tools to refine and model their data into a visual and interactive format. Students considering adopting this course are not required to have any prerequisite knowledge of Power BI or experience working on data modelling related tasks.
| Module | Topics |
| Module 1: An introduction to Power BI | What is business intelligence?
Introducing Power BI Power BI tools and services Case studies Data stories Support and information |
| Module 2: Requirements gathering | Welcome to House Rules Board Games
Beginning a Power BI project Grain statements Data discovery Refining information Modelling data Building reports Creating dashboards Choosing workspaces Create and share a report in Power BI |
| Module 3: Extract, transform and load data | Creating a project with Power BI desktop
What is a PBIX file? Connecting to data sources Managing data connections Refine data with the query editor Applied steps M code language Designing your query Choose columns Rename columns Moving columns Formatting columns Replacing values Expand related columns Star schemas Mere columns Custom and conditional columns |
| Module 4: Creating a data model | Understanding relationships
Cardinality Cross filter direction Hiding tables and columns Formatting columns Introducing DAX Designing calculated columns Creating measures Adding lookup tables Structuring data with dimensional hierarchies Roles and row level security |
| Module 5: Designing reports | Adding pages and navigation buttons
Using shapes, text and images Creating a theme Adding visualisations Using filters and slicers Adding drill throughs Adding custom visualisations Configure phone layouts Report tips |
| Module 6: Using workspaces and dashboards | Power BI licensing
My workspaces App workspaces Premium capacity workspaces Publishing a project Parallels with Microsoft Excel Publishers and viewers Reconnecting with data sources Scheduling the data refresh frequency Introducing the on-premises data gateway Assigning security roles Creating and populating dashboards Customising dashboard tiles Creating tiles using Q&A and quick insights Creating a mobile dashboard Sharing reports and dashboards Publishing apps in a workspace Publishing content to websites |
