Introduction to Power BI In this session, learners will explore the Power BI ecosystem, gaining insight into its core components, including Power Query Editor, Power BI Desktop, and Power BI Service. Learners will be introduced to the concept of how to extract, transform, and load (ETL) data, build a structured data model, and design interactive […]

Overview of Power BI The purpose of this training day is to give participants a good grounding in all the components of the Power BI ecosystem. Provide a list of questions and answers so participants can self-quiz. This will be a hands-on introduction so they must have their hardware to participate. We will create a […]

The Power of Query Editor: Beyond the Standard The purpose of this training day is to give students an understanding of the Power Query Editor, beyond the standard transformations (removing columns etc.) A special emphasis will be placed on: The M-language Future proofing a query Re-using steps in other queries. Complex transformations This training day […]

Data Modeling (2-Day Session) The purpose of these training days is to give participants a strong understanding of data modeling. This is one of the central skills in Power BI, and participants should be able to discuss and create strong data models. Students should be able to articulate the advantages and disadvantages of a particular […]

Data Modeling (2-Day Session) The purpose of these training days is to give participants a strong understanding of data modeling. This is one of the central skills in Power BI, and participants should be able to discuss and create strong data models. Students should be able to articulate the advantages and disadvantages of a particular […]

DAX (2-Day Session) The purpose of these training days is to give participants a working knowledge of DAX to create calculated columns, measures, tables, security roles. Participants will also understand and use filter and row context. Learners will be versed in the syntax and principles of the DAX language. They will have hands-on experience writing […]

DAX (2-Day Session) The purpose of these training days is to give participants a working knowledge of DAX to create calculated columns, measures, tables, security roles. Participants will also understand and use filter and row context. Learners will be versed in the syntax and principles of the DAX language. They will have hands-on experience writing […]

Building a Report The purpose of this training day is to give participants a full knowledge of the features and functionality used when creating a report. Students will be asked […]

Working in the Power BI Service The purpose of this training day is to give participants a strong understanding of the Power BI Service. Learners will be able to articulate […]

Creating Efficiencies The purpose of this training day is to show students how to use datasets and dataflows to eliminate re-work. It will also include creating a composite model (online […]