Microsoft Power BI Super User (55400)

This 2-day course will take students who have little to no knowledge of Power BI to the point where they can create, publish and share rich reports and dashboards.

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 modeling related tasks.

1. An Introduction to Power BI
   1. What is business intelligence?
   2. Introducing Power BI
   3. Power BI tools and services
   4. Power BI Report Server
   5. Power BI (Online)
   6. Power BI Desktop
   7. Case studies
   8. Support and information
   9. Data stories
   10. Lab: Getting Ready
       1. Sign in to Office 365
       2. Download course files
       3. Place data sources into OneDrive
       4. Create further user accounts
2. Requirements Gathering
   1. Welcome to House Rules Board Games
   2. Beginning a BI project
   3. Grain statements
   4. Data discovery
   5. Refining information
   6. Modeling data
   7. Building reports
   8. Roles
   9. Publishing
   10. Creating dashboards
   11. Choosing workspaces
   12. Create and share a report in Power BI
   13. Lab: Build a report in Power BI web
       1. Connect to an Excel spreadsheet
       2. Build visualizations
       3. Create a dashboard for desktop and mobile users
       4. Share your report and dashboard
3. Extract, transform and load data
   1. Creating a project with Power BI desktop
   2. Pinning an active project
   3. What is in a PBIX file?
   4. Connecting to data sources
   5. Managing data connections
   6. Refine data with Power Query
   7. Applied steps
   8. M code language
   9. Designing your query
   10. Choose columns
   11. Rename columns
   12. Moving columns
   13. Formatting columns
   14. Replacing values
   15. Expanding related columns
   16. Star schemas
   17. Merge columns
   18. Split columns
   19. Custom and conditional columns
   20. Lab: Starting a project in Power BI desktop
       1. Creating a new PBIX project file
       2. Connecting to data sources
       3. Use the query editor to refine data
       4. Review the table relationships
       5. Optional – Connect to an Azure SQL database
4. Creating a data model
   1. Understanding relationships
   2. Cardinality
   3. Cross filter direction
   4. Hiding tables and columns
   5. Formatting columns
   6. Introducing DAX
   7. Designing calculated columns
   8. Creating measures
   9. Adding lookup tables
   10. Structuring data with dimensional hierarchies
   11. Roles and row level security
   12. Lab: Designing a data model
       1. Hide and format table columns
       2. Create calculated columns
       3. Create measures
       4. Using geographical data and lookup tables
       5. Create a dimensional hierarchy
5. Designing Reports
   1. Adding pages and navigation buttons
   2. Using shapes, text and images
   3. Creating a theme
   4. Adding visualizations
   5. Using filters and slicers
   6. Controlling filters
   7. Adding drill throughs
   8. Adding custom visualizations
   9. Configure phone layouts
   10. Report tips
   11. Lab: Creating a report
       1. Creating new pages and adding basic content
       2. Adding and configuring visualizations
       3. Design slicers
       4. Create bookmarks and navigational buttons
6. Using workspaces and dashboards
   1. Power BI licensing
   2. My workspaces
   3. App workspaces
   4. Premium capacity workspaces
   5. Creating a new workspace
   6. Publishing a project
   7. Parallels with Microsoft Excel
   8. Publishers and viewers
   9. Reconnecting with data sources
   10. Introducing the on-premises data gateway
   11. Scheduling the data refresh frequency
   12. Assigning security roles
   13. Creating and populating dashboards
   14. Customizing dashboard tiles
   15. Creating tiles using Q&A and quick insights
   16. Creating a mobile dashboard
   17. Sharing reports and dashboards
   18. Publishing apps in a workspace
   19. Publishing content to websites
   20. Lab: Publish and share reports and dashboards
       1. Publish your project to Power BI
       2. Create a dashboard
       3. Use quick insights and pin visuals
       4. Use Q&A to query your data source
       5. Share your dashboard with marketing

Each student receives a comprehensive set of materials, including course notes and all class examples.

Experience in the following is required for this Microsoft Business Intelligence class: