Power BI Level 2 - Intermediate 1 Day
Course Overview
Power BI Level 2 - Intermediate 1 day This 1-day course is intended for delegates who want to build more robust Power BI reports and dashboards. The training will delve into the more technical aspects of cleaning, transforming, and structuring data, as well as creating well designed semantic models that more advanced features in Power BI rely upon. The module on the DAX expression language explains the use and implementation of measures, how to modify the current filter context to perform more interesting calculations, and how to perform calculations over time periods.
INTRODUCTION
This 1-day course is intended for delegates who want to build more robust Power BI reports and dashboards.
The training will delve into the more technical aspects of cleaning, transforming, and structuring data, as well as creating well designed semantic models that more advanced features in Power BI rely upon.
The module on the DAX expression language explains the use and implementation of measures, how to modify the current filter context to perform more interesting calculations, and how to perform calculations over time periods.
The fifth module on visualising data allows us to explore card visuals, gauges, and scatter charts, amongst others, to allow us to both gain insights into our data and to provide high level information on various metrics. As part of this module, we’ll also explore how to conditionally format report content to draw readers attention to specific data points. Fuller coverage on interactive filtering is also provided.
Last, but not least, we return to the Power BI web service to examine the use and creation of dashboards.
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience.
Due to the ever-changing nature of this technology, course content may vary to keep the training as relevant and up to date as possible.
PREREQUISITES
Delegates should have previously attended the “Power BI Level 1 – Introduction” course or possess equivalent knowledge.
Attendees should be able to demonstrate a good level of computer literacy and skills. You will have a good understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
- Discover and Load Data from Multiple Files
- Discover and Load Data from Databases
- Improve and Enhance Data Quality
- Transform Data
- Restructure Datasets
- Combine Data from Multiple Sources
- Implement a Semantic Model
- Create and Manage Relationships
- Understand How Filters Propagate Through a Semantic Model
- Implement and Work with Measures
- Implement Time Intelligence
- Implement Conditional Formatting
- Implement Gauges
- Implement Slicers and Filters
- Understand Cross Visual Interactions
- Create and Manage Dashboards
COURSE OUTLINE
|
1. Loading Data Load Multiple Files from a Folder Load Data from Databases (Microsoft SQL Server) Compare Import and DirectQuery Storage Modes 2. Transforming Data Transform Data Shape Datasets Merge and Append Data 3. Creating a Semantic Model Data Modelling Concepts Fact and Dimension Tables Create and Manage Relationships Understand Filter Propagation 4. The DAX Expression Language Create Explicit Measures Manipulate the Filter Context Create a Date Table Analyse Data over Time (Time Intelligence) |
5. Visualising Data Review Power BI Visuals Use the Card Visual Gauges Scatter Charts and Bubble Charts Conditionally Format Visual Content Use Tooltips Slicers Revisited The Filters Pane Cross-Filtering and Cross-Highlighting Field Parameters 6. Power BI Dashboards Create and Manage Dashboards Dashboard Themes Set up Data Alerts |
Power BI Level 2 - Intermediate 1 Day
Course Overview
Power BI Level 2 - Intermediate 1 day This 1-day course is intended for delegates who want to build more robust Power BI reports and dashboards. The training will delve into the more technical aspects of cleaning, transforming, and structuring data, as well as creating well designed semantic models that more advanced features in Power BI rely upon. The module on the DAX expression language explains the use and implementation of measures, how to modify the current filter context to perform more interesting calculations, and how to perform calculations over time periods.
INTRODUCTION
This 1-day course is intended for delegates who want to build more robust Power BI reports and dashboards.
The training will delve into the more technical aspects of cleaning, transforming, and structuring data, as well as creating well designed semantic models that more advanced features in Power BI rely upon.
The module on the DAX expression language explains the use and implementation of measures, how to modify the current filter context to perform more interesting calculations, and how to perform calculations over time periods.
The fifth module on visualising data allows us to explore card visuals, gauges, and scatter charts, amongst others, to allow us to both gain insights into our data and to provide high level information on various metrics. As part of this module, we’ll also explore how to conditionally format report content to draw readers attention to specific data points. Fuller coverage on interactive filtering is also provided.
Last, but not least, we return to the Power BI web service to examine the use and creation of dashboards.
The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises to enhance the learning experience.
Due to the ever-changing nature of this technology, course content may vary to keep the training as relevant and up to date as possible.
PREREQUISITES
Delegates should have previously attended the “Power BI Level 1 – Introduction” course or possess equivalent knowledge.
Attendees should be able to demonstrate a good level of computer literacy and skills. You will have a good understanding of your business needs to collect, cleanse, and analyse data, in order to be able to visualise and gain insights into that data.
COURSE OBJECTIVES
Upon successful completion of this course, students will be able to:
- Discover and Load Data from Multiple Files
- Discover and Load Data from Databases
- Improve and Enhance Data Quality
- Transform Data
- Restructure Datasets
- Combine Data from Multiple Sources
- Implement a Semantic Model
- Create and Manage Relationships
- Understand How Filters Propagate Through a Semantic Model
- Implement and Work with Measures
- Implement Time Intelligence
- Implement Conditional Formatting
- Implement Gauges
- Implement Slicers and Filters
- Understand Cross Visual Interactions
- Create and Manage Dashboards
COURSE OUTLINE
|
1. Loading Data Load Multiple Files from a Folder Load Data from Databases (Microsoft SQL Server) Compare Import and DirectQuery Storage Modes 2. Transforming Data Transform Data Shape Datasets Merge and Append Data 3. Creating a Semantic Model Data Modelling Concepts Fact and Dimension Tables Create and Manage Relationships Understand Filter Propagation 4. The DAX Expression Language Create Explicit Measures Manipulate the Filter Context Create a Date Table Analyse Data over Time (Time Intelligence) |
5. Visualising Data Review Power BI Visuals Use the Card Visual Gauges Scatter Charts and Bubble Charts Conditionally Format Visual Content Use Tooltips Slicers Revisited The Filters Pane Cross-Filtering and Cross-Highlighting Field Parameters 6. Power BI Dashboards Create and Manage Dashboards Dashboard Themes Set up Data Alerts |
