Power BI Level 3 - Advanced 1 Day
Course Overview
Power BI Level Advanced DURATION: 1 day This 1-day course is intended for delegates who want to take their Power BI skills to the next level producing more informative interactive reports. The first module will explore importing data from more exotic sources, such as the Internet, along with examining the benefits of connecting to an already published semantic model. You will then extend your knowledge of Power Query by getting acquainted with the Power Query Expression Language, better known simply as the M language, thus enabling you to create more versatile and robust queries. Error handling will also be covered in this module.
INTRODUCTION
This 1-day course is intended for delegates who want to take their Power BI skills to the next level producing more informative interactive reports.
The first module will explore importing data from more exotic sources, such as the Internet, along with examining the benefits of connecting to an already published semantic model.
You will then extend your knowledge of Power Query by getting acquainted with the Power Query Expression Language, better known simply as the M language, thus enabling you to create more versatile and robust queries. Error handling will also be covered in this module.
Modules three and four will round off your knowledge of the semantic model and delve deeper into the functionality of the DAX expression language to create more complex calculations.
Having already utilised most of the commonly used visuals in your reports, module five will provide you with the necessary skills to enhance the user experience by implementing maps, drillthrough reports, and bookmarks.
The final session will consider just some of the ways in which published reports can be shared with your users and also examine how to keep the data your reports are dependent on up to date. The potential use of data gateways will finish off proceedings.
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” and “Power BI Level 2 – Intermediate” courses or possess equivalent knowledge.
This course should be considered a technical course. There are some elements of coding involved in the training and delegates should feel comfortable with basic coding concepts as might be the case from working with macros in Microsoft Excel or other alternate functional/scripting language.
Upon successful completion of this course, students will be able to:
- Load Data from Internet Resources
- Connect to Data in a Published Semantic Model
- Gain an Understanding of the Power Query M Language
- Handle Errors Gracefully in Queries
- Enhance a Semantic Model
- Create Custom Groups of Data
- Create More Complex DAX Expressions
- Implement Maps in Reports
- Utilise What-If Parameters
- Create a Drillthrough Report
- Create and Implement Bookmarks
- Manage and Secure Content in the Power BI Service
- Create and Distribute Workspace Apps
- Keep Data in the Published Semantic Model up to Date
COURSE OUTLINE
|
1. Loading Data Loading Data from the Internet Loading Data from Other Sources Connecting to a Published Semantic Model 2. Power Query and the M Language Introduction to the M Language Create a User Defined Function with M Error Handling 3. Enhancing the Semantic Model Group and Bin Data Sorting Columns Organise Content with Display Folders 4. Advanced DAX Techniques Create Custom Groups Create Measure Tables Iterator Functions Using the FILTER Function |
5. Enhancing the User Experience Implement Reports as Tooltips Use the Small Multiples Feature Use the Analyse Feature Categorise Data Implement Maps What-If Parameters Drillthrough Reports Implement Bookmarks Bookmark Navigation Show and Hide Content 6. The Power BI Web Service Power BI Licensing Share Content and Workspaces Subscriptions Create and Distribute Workspace Apps Refresh Datasets Understand Data Gateways |
Power BI Level 3 - Advanced 1 Day
Course Overview
Power BI Level Advanced DURATION: 1 day This 1-day course is intended for delegates who want to take their Power BI skills to the next level producing more informative interactive reports. The first module will explore importing data from more exotic sources, such as the Internet, along with examining the benefits of connecting to an already published semantic model. You will then extend your knowledge of Power Query by getting acquainted with the Power Query Expression Language, better known simply as the M language, thus enabling you to create more versatile and robust queries. Error handling will also be covered in this module.
INTRODUCTION
This 1-day course is intended for delegates who want to take their Power BI skills to the next level producing more informative interactive reports.
The first module will explore importing data from more exotic sources, such as the Internet, along with examining the benefits of connecting to an already published semantic model.
You will then extend your knowledge of Power Query by getting acquainted with the Power Query Expression Language, better known simply as the M language, thus enabling you to create more versatile and robust queries. Error handling will also be covered in this module.
Modules three and four will round off your knowledge of the semantic model and delve deeper into the functionality of the DAX expression language to create more complex calculations.
Having already utilised most of the commonly used visuals in your reports, module five will provide you with the necessary skills to enhance the user experience by implementing maps, drillthrough reports, and bookmarks.
The final session will consider just some of the ways in which published reports can be shared with your users and also examine how to keep the data your reports are dependent on up to date. The potential use of data gateways will finish off proceedings.
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” and “Power BI Level 2 – Intermediate” courses or possess equivalent knowledge.
This course should be considered a technical course. There are some elements of coding involved in the training and delegates should feel comfortable with basic coding concepts as might be the case from working with macros in Microsoft Excel or other alternate functional/scripting language.
Upon successful completion of this course, students will be able to:
- Load Data from Internet Resources
- Connect to Data in a Published Semantic Model
- Gain an Understanding of the Power Query M Language
- Handle Errors Gracefully in Queries
- Enhance a Semantic Model
- Create Custom Groups of Data
- Create More Complex DAX Expressions
- Implement Maps in Reports
- Utilise What-If Parameters
- Create a Drillthrough Report
- Create and Implement Bookmarks
- Manage and Secure Content in the Power BI Service
- Create and Distribute Workspace Apps
- Keep Data in the Published Semantic Model up to Date
COURSE OUTLINE
|
1. Loading Data Loading Data from the Internet Loading Data from Other Sources Connecting to a Published Semantic Model 2. Power Query and the M Language Introduction to the M Language Create a User Defined Function with M Error Handling 3. Enhancing the Semantic Model Group and Bin Data Sorting Columns Organise Content with Display Folders 4. Advanced DAX Techniques Create Custom Groups Create Measure Tables Iterator Functions Using the FILTER Function |
5. Enhancing the User Experience Implement Reports as Tooltips Use the Small Multiples Feature Use the Analyse Feature Categorise Data Implement Maps What-If Parameters Drillthrough Reports Implement Bookmarks Bookmark Navigation Show and Hide Content 6. The Power BI Web Service Power BI Licensing Share Content and Workspaces Subscriptions Create and Distribute Workspace Apps Refresh Datasets Understand Data Gateways |
