Design and manage analytics solutions using Power BI
This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show...
This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
Audience Profile
The audience for this course is data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted at those individuals who develop reports that visualize data from the data platform technologies that exist both in the cloud and on-premises.
Skills Gained
After completing this course, students will be able to:
Ingest, clean, and transform data
Model data for performance and scalability
Design and create reports for data analysis
Apply and perform advanced report analytics
Manage and share report assets
Prerequisites
Successful Data Analysts start this role with experience of working with data in the cloud. Specifically:
Understanding core data concepts.
Knowledge of working with relational data in the cloud.
Knowledge of working with non-relational data in the cloud.
Knowledge of data analysis and visualization concepts.
Course Details
Outline
Discover data analysis
Overview of data analysis
Roles in data
Tasks of a data analyst
Check your knowledge
Summary
Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
Knowledge check
Introduction to end-to-end analytics using Microsoft Fabric
Explore end-to-end analytics with Microsoft Fabric
Explore data teams and Microsoft Fabric
Enable and use Microsoft Fabric
Module assessment
Get started with Copilot in Power BI
Use Copilot in Power BI to prepare and model data
Create reports with Copilot in Power BI
Get your data ready for AI usage in Power BI
Module assessment
Get data in Power BI
Get data from files
Get data from relational data sources
Create dynamic reports with parameters
Get data from a NoSQL database
Get data from online services
Select a storage mode
Get data from Azure Analysis Services
Fix performance issues
Resolve data import errors
Exercise - Get data in Power BI
Check your knowledge
Clean, transform, and load data in Power BI
Shape the initial data
Simplify the data structure
Evaluate and change column data types
Combine multiple tables into a single table
Profile data in Power BI
Use Advanced Editor to modify M code
Exercise - Load data in Power BI Desktop
Check your knowledge
Choose a Power BI model framework
Describe Power BI model fundamentals
Determine when to develop an import model
Determine when to develop a DirectQuery model
Determine when to develop a composite model
Choose a model framework
Module assessment
Configure a semantic model
Configure relationships
Configure tables
Configure columns
Configure hierarchies
Configure measures
Configure parameters
Exercise - Configure a semantic model in Power BI Desktop
Check your knowledge
Write DAX formulas for semantic models
Understand DAX calculation types
Write DAX formulas
DAX data types
Work with DAX functions
Use DAX operators
Use DAX variables
Check your knowledge
Create DAX calculations in semantic models
Create calculated tables
Create calculated columns
Understand implicit measures
Create explicit measures
Use iterator functions
Exercise - Create DAX calculations
Check your knowledge
Modify DAX filter context in semantic models
Understand filter context
Modify filter context
Use filter modifier functions
Examine filter context
Perform context transition
Exercise - Modify DAX filter context
Check your knowledge
Use DAX time intelligence functions in semantic models
Use DAX time intelligence functions
Additional time intelligence calculations
Exercise - Use time intelligence functions
Check your knowledge
Create visual calculations in Power BI Desktop
Understand visual calculations
Create visual calculations
Use parameters in visual calculations
Exercise - Create visual calculations in Power BI Desktop
Module assessment
Optimize a model for performance in Power BI
Introduction to performance optimization
Describe semantic model optimization techniques
Review performance of measures, relationships, and visuals
Use variables to improve performance and troubleshooting
Reduce cardinality
Optimize DirectQuery models with table level storage
Create and manage aggregations
Check your knowledge
Scope report design requirements
Identify the audience
Determine report types
Define user interface requirements
Define user experience requirements
Explore designs in a Power BI report
Check your knowledge
Design Power BI reports
Design the analytical report layout
Design visually appealing reports
Use report objects
Select report visuals
Apply filters and slicers to reports
Understand filtering techniques and considerations
Case study - Configure report filters based on feedback
Exercise - Design Power BI reports
Check your knowledge
Enhance Power BI report designs for the user experience
Design reports to show details
Design reports to highlight values
Design reports that behave like apps
Work with bookmarks
Design reports for navigation
Work with visual headers
Design reports with built-in assistance
Tune report performance
Optimize reports for mobile use
Exercise - Enhance Power BI reports
Check your knowledge
Perform analytics in Power BI
Introduction to analytics
Explore statistical summary
Identify outliers with Power BI visuals
Group and bin data for analysis
Apply clustering techniques
Conduct time series analysis
Use the Analyze feature
Create what-if parameters
Use specialized visuals
Exercise - Perform analytics in Power BI
Check your knowledge
Manage workspaces in Power BI service
Understand Power BI service
Understand workspaces
Publish to Power BI service
Check your knowledge
Manage semantic models in Power BI
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Boost performance with query caching (Fabric or Premium capacity)
Use lineage and impact analysis
Check your knowledge
Choose a content distribution method
Understand sharing models
Create a Power BI app
Apply data governance principles
Track report or dashboard usage
Check your knowledge
Create dashboards in Power BI
Introduction to dashboards
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Set mobile view
Exercise - Create dashboards in Power BI
Check your knowledge
Secure data access in Power BI
Configure row-level security with the static method
Configure row-level security with the dynamic method
Pearson Vue Exam vouchers can be requested and ordered with your course purchase or can be ordered separately by clicking here.
Vouchers are non-refundable and non-returnable. Vouchers expire 12 months from the date they are issued unless otherwise specified in the terms and conditions.
Voucher expiration dates cannot be extended. The exam must be taken by the expiration date printed on the voucher.
Do Microsoft courses come with post lab access?
Most Microsoft official courses will include post-lab access ranging from 30 to 180 calendar days after instructor led course delivery. A lab training key in class will be provided that can be leveraged to continue connecting to a remote lab environment for the individual course attendee.
Does the course schedule include a Lunchbreak?
Lunch is normally an hour-long after 3-3.5 hours of the class day.
What languages are used to deliver training?
Microsoft courses are conducted in English unless otherwise specified.
Reviews
I found Scott Andrews to be very helpful in answering all our questions that were asked. He appeared to be very knowledgeable in Power BI.
Franz did an amazing job! He gave great insight on each material that was presented, provide detailed explanations for all questions that were asked, and found different resources to deepen our knowledge in specific topics. Overall GREAT instructor!
The instructor is an amazing resource: his knowledge is evident, he answered every question without hesitation, already having the answer at the tips of his fingers. He communicated clearly and made complex topics feel accessible. Amazing teacher.
Edgar is a great instructor
It is conductive, feel comfortable with the trainer and overall training technology and environment.
Ascendient Learning is the coming together of three highly respected brands; Accelebrate, ExitCertified, and Web Age Solutions - renowned for their training expertise - to form one company committed to providing excellence in outcomes-based technical training.
With our winning team, we provide a full suite of customizable training to help organizations and teams upskill, reskill, and meet the growing demand for technical development because we believe that when talent meets drive, individuals rise, and businesses thrive.