Microsoft Power BI Advanced DURATION 2 Days
Course Overview
This advanced 2-day course is intended for anyone who has existing experience working with Power BI and who wants to extend and enhance their knowledge beyond the basics. You will gain deeper insights into the inner workings of Power BI by implementing your own code in Power Query using the M language, further enhance the data model using the DAX expression language and get a better understanding of your data using advanced capabilities and features in Power BI. In addition to understanding the technical workings of Power BI, it is also intended to demonstrate best practices and highlight practical solutions to common data analytic scenarios. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.
With the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.
Full course breakdown available – training@jcstraining.com
PREREQUISITES
Delegates should have previously attended the 2-day “Power BI Introduction” course or possess equivalent knowledge and experience of Power BI.
Upon successful completion of this course, students will be able to:
- Load Data from a Database
- Process Multiple Files in a Folder
- Understand Supported Storage Modes
- Match Imported Data to Master Data
- Prepare Data for Modelling
- Understand M Language Data Types
- Enhance Transforms with M
- Implement and Optimise a Data Model
- Resolve Common Modelling Problems
- Review the DAX Expression Language
- Address Common Scenarios with DAX
- Implement Custom Data Grouping
- Use Built-In Analytics Features
- Implement Advanced Filters
- Implement Drillthrough Reports
- Work with the Q&A Feature
- Implement Custom Visuals and Slicers
- Share Content in the Power BI Service
- Secure Data
- Secure Objects
- Refresh Data
- Manage Changing Data
COURSE OUTLINE
|
Part 1: Power Query Advanced Techniques 1. Loading Data Load Data from Relational Databases Process Multiple Files Storage Modes Load Data from the Internet Connect to a Published Dataset 2. Transforming Data Profile Data Improve Performance with Query Folding Fuzzy Lookups Split a Table into Multiple Tables Structure and Manage Queries View Query Dependencies Getting Acquainted with the M Language Tweak Existing M Language Formulae Create User Defined Functions with M Invoke Custom Functions Create Date and Time Tables with M Best Practices Part 2: Advanced Data Modelling and DAX 3. Data Modelling Data Modelling Revisited Fact and Dimension Tables Many-to-Many Relationships Resolving Some Common Data Modelling Issues 4. Enhancing the Data Model with DAX Getting up to Speed with DAX Calculated Columns and Measures Manipulating the Filter Context Creating Calculated Tables Use Variables Create a Date Table with DAX Time Intelligence Revisited Useful DAX Querying Techniques Organise Content with Display Folders |
Part 3: Enhance Reports and Visuals 5. Enhanced Data Visualisation Report Themes Use the Small Multiples Chart Option Sparklines Implement Reports as Tooltips Continuous v Categorical Axis Custom Grouping Use the Analytics Pane Forecasting & Anomaly Detection Visual, Page, and Report Level Filters Synchronise Slicers across Pages Analyse Data with Decomposition Trees Analyse Data with Key Influencers Drillthrough Reports What-If Parameters Field Parameters Implement and Manage Q&A Custom Visuals and Slicers Mobile Report Layout Part 4: Manage Content in the Power BI Service 6. The Power BI Web Service Set up Data Alerts Share Content and Workspaces Create and Distribute Apps Promote & Certify Content Secure Data with Row Level Security (RLS) Object Level Security Refresh Datasets Understand Data Gateways Incremental Refresh Quick Insights Analyse in Excel Export Reports |
Microsoft Power BI Advanced DURATION 2 Days
Course Overview
This advanced 2-day course is intended for anyone who has existing experience working with Power BI and who wants to extend and enhance their knowledge beyond the basics. You will gain deeper insights into the inner workings of Power BI by implementing your own code in Power Query using the M language, further enhance the data model using the DAX expression language and get a better understanding of your data using advanced capabilities and features in Power BI. In addition to understanding the technical workings of Power BI, it is also intended to demonstrate best practices and highlight practical solutions to common data analytic scenarios. Also, as Power BI Desktop and the Power BI Service are continually evolving, this course is regularly reviewed and updated to keep the delivered content as fresh and relevant as possible, thus ensuring maximum productivity from the learning experience.
With the course structure being fully modularised, customised versions of this course can be devised and delivered to suit individual requirements – just ask for details.
Full course breakdown available – training@jcstraining.com
PREREQUISITES
Delegates should have previously attended the 2-day “Power BI Introduction” course or possess equivalent knowledge and experience of Power BI.
Upon successful completion of this course, students will be able to:
- Load Data from a Database
- Process Multiple Files in a Folder
- Understand Supported Storage Modes
- Match Imported Data to Master Data
- Prepare Data for Modelling
- Understand M Language Data Types
- Enhance Transforms with M
- Implement and Optimise a Data Model
- Resolve Common Modelling Problems
- Review the DAX Expression Language
- Address Common Scenarios with DAX
- Implement Custom Data Grouping
- Use Built-In Analytics Features
- Implement Advanced Filters
- Implement Drillthrough Reports
- Work with the Q&A Feature
- Implement Custom Visuals and Slicers
- Share Content in the Power BI Service
- Secure Data
- Secure Objects
- Refresh Data
- Manage Changing Data
COURSE OUTLINE
|
Part 1: Power Query Advanced Techniques 1. Loading Data Load Data from Relational Databases Process Multiple Files Storage Modes Load Data from the Internet Connect to a Published Dataset 2. Transforming Data Profile Data Improve Performance with Query Folding Fuzzy Lookups Split a Table into Multiple Tables Structure and Manage Queries View Query Dependencies Getting Acquainted with the M Language Tweak Existing M Language Formulae Create User Defined Functions with M Invoke Custom Functions Create Date and Time Tables with M Best Practices Part 2: Advanced Data Modelling and DAX 3. Data Modelling Data Modelling Revisited Fact and Dimension Tables Many-to-Many Relationships Resolving Some Common Data Modelling Issues 4. Enhancing the Data Model with DAX Getting up to Speed with DAX Calculated Columns and Measures Manipulating the Filter Context Creating Calculated Tables Use Variables Create a Date Table with DAX Time Intelligence Revisited Useful DAX Querying Techniques Organise Content with Display Folders |
Part 3: Enhance Reports and Visuals 5. Enhanced Data Visualisation Report Themes Use the Small Multiples Chart Option Sparklines Implement Reports as Tooltips Continuous v Categorical Axis Custom Grouping Use the Analytics Pane Forecasting & Anomaly Detection Visual, Page, and Report Level Filters Synchronise Slicers across Pages Analyse Data with Decomposition Trees Analyse Data with Key Influencers Drillthrough Reports What-If Parameters Field Parameters Implement and Manage Q&A Custom Visuals and Slicers Mobile Report Layout Part 4: Manage Content in the Power BI Service 6. The Power BI Web Service Set up Data Alerts Share Content and Workspaces Create and Distribute Apps Promote & Certify Content Secure Data with Row Level Security (RLS) Object Level Security Refresh Datasets Understand Data Gateways Incremental Refresh Quick Insights Analyse in Excel Export Reports |
