This course is a comprehensive program that takes you from a data novice to a confident BI professional. As students work through the curriculum, they learn how to connect to real-world data sources, clean and transform messy datasets, and build interactive dashboards that turn numbers into actionable insights.
Going beyond the basics, this masterclass dives deep into data modeling, DAX formulas, and enterprise-level features that separate intermediate users from true Power BI experts. You'll also learn to design reliable relational data models, implement Row-Level Security to control access across your organization, and create flexible reports using parameters and custom hierarchies.
What You Will Learn
- Import and clean data from Excel, CSV, and other sources using Power Query, then design polished reports with charts, maps, cards, and slicers
- Create measures, calculated columns, and custom aggregations to unlock deeper analytical capabilities in your reports
- Master table relationships, cardinality, cross-filter direction, and filter flow to build dynamic, filterable reports that are free of common modeling mistakes
- Create reusable fiscal and calendar date tables to power time-based analysis and comparisons across your reports
- Control who sees what data using both static and dynamic security roles, ensuring your reports are enterprise-ready
- Set up dashboards in the Power BI Service, schedule data refreshes, manage reusable datasets, and collaborate with stakeholders across your organization
Program Courses
Power BI Bootcamp
Learn how to use Power BI, a powerful data visualization tool, to create interactive and aesthetically pleasing charts, graphs, and maps. Learn how to connect to datasets, analyze and structure data, customize visualizations, and publish reports.
Power BI Advanced
This advanced Power BI course focuses on building more reliable data models using proper relationships, filter flow, fiscal and calendar date tables, Row-Level Security, and more.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.