Analyzing Data with Microsoft Power BI
Published by Pearson
Prepare, Model, Visualize, and Analyze Data Effectively
- Learn to effectively and efficiently use Microsoft Power BI to analyze data
- Grow in your career as a data analyst
- Prepare for new Exam PL-300: Power BI Data Analyst, required to earn Microsoft Power BI Data Analyst Associate certification
This Live Training is about how you can use Power BI to analyze your data. The training starts with getting your data into Power BI Desktop, then looks at creating a data model and writing your own calculations using DAX, building reports, and sharing them with others online.
Power BI is part of the Microsoft business intelligence platform, which has seen dramatic progress in the recent years. Gartner has recently named Microsoft a leader in the BI and analytics space. Power BI increasingly becomes a platform of choice for many organizations, and knowing how to work with Power BI becomes an important skill in the current job market.
What you’ll learn and how you can apply it
- Connect to various data sources and perform transformations on your data
- Create data models and enrich them with DAX measures, calculated columns, and calculated tables
- Create reports and share them through Power BI service
This live event is for you because...
- You want to learn how to get data, transform it, and load in Power BI
- You want to know how to enrich your reports with your own measures
- You want to get an overview of how you can share your reports with others
Prerequisites
- Basic experience with Excel
- Basic familiarity with relational databases (especially relationships)
- Basic understanding of what Power BI is
Course Set-up
- Download Power BI Desktop from the official website and follow the installation prompts
Recommended Preparation
- Watch: Introduction to Microsoft Power BI (video)
Recommended Follow-up
- Read: Exam Ref PL-300 Microsoft Power BI Data Analyst by Daniil Maslyuk
- Watch: Exam PL-300 Microsoft Power BI Data Analyst (Video) by Chris Sorensen
- Read: Analyzing Data with Power BI and Power Pivot for Excel by Alberto Ferrari and Marco Russo
- Read: The Definitive Guide to DAX: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel, 2nd Edition, by Alberto Ferrari and Marco Russo
Schedule
The time frames are only estimates and may vary according to how the class is progressing.
Course overview (5 minutes)
Prepare the Data (40 minutes)
- Get data from different data sources
- Profile the data
- Clean, transform, and load the data
- Q&A
Break: 5 minutes
Model the Data (45 minutes)
- Design a data model
- Develop a data model
- Create measures by using DAX
- Optimize model performance
- Q&A
Break: 10 minutes
Visualize the Data (35 minutes)
- Create reports
- Create dashboards
- Enrich reports for usability
- Q&A
Break: 5 minutes
Analyze the Data (30 minutes)
- Enhance reports to expose insights
- Perform advanced analysis
- Q&A
Break: 5 minutes
Deploy and Maintain Deliverables (25 minutes)
- Manage datasets
- Create and manage workspaces
Course wrap-up (5 minutes)
Your Instructor
Daniil Maslyuk
Daniil Maslyuk is an independent business intelligence consultant and trainer who specializes in Microsoft Power BI. Daniil is the author of the official Microsoft Power BI exam reference books. For his community contributions, he has been recognized as a Microsoft Most Valuable Professional (MVP). Daniil blogs at xxlbi.com and posts on X as @DMaslyuk.