Microsoft Power BI Mastery: From Beginner to Intermediate

Master data analysis in Power BI and learn how to create stunning dashboards with this beginner to intermediate course!

Created by: Simon Sez IT
990,000+ Students, 290+ Courses, Learners in 180+ Countries

What Will I Learn?

• How to create stunning, interactive dashboards with Power BI
• How to share your analysis and dashboards using Power BI Online
• Importing Excel, Text, and CSV files into Power BI Desktop and combining files
• All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
• How to create amazing visuals, such as clustered column charts, maps, and trend graphs
• Using slicers and filters and applying design elements to your reports
• How to edit the interactions between your visualizations and filter at visualization, page, and report level
• How to import and transform data in Power Query
• How to enable/disable load and report refresh and resolving data import errors
• Data Modelling, relationship types, and troubleshooting relationship issues
• Measures vs Calculated Columns and creating additional and conditional columns
• How to use ROUNDUP and SUMX
• Creating Quick Measures and a Key Measures Table
• Using column, line, and map charts and gauge and card visualizations
• Creating a Shared Workspace in Power BI Service
• Creating reports and dashboards, pinning visualizations to the dashboard, and setting up scheduled refreshes

Requirements

• A good knowledge of MS Excel is advised but not necessary
• Power BI Desktop installed on your machine is required to take the practice exercises

Target audience

• Advanced Excel users
• Business Intelligence Analysts