PWR-BI.AD1
Power BI: Data Analysis Professional
Learn to manipulate data with Power BI, turning numbers into easy-to-read visuals and insights.
- Practice in 26 Hands-On Labs — nothing to install
- 12 Interactive Lessons and 42 topics mapped to the official exam objectives
- 87 Practice Test Questions
Beginner Self-paced · 1 year access 4.9/5 (285 Reviews)
26 Hands-On LiveLabs
Practice real IT tasks in guided environments.
- Real environments
- Auto-graded
- No installation
12Interactive Lessons
42Topics
26LiveLab
87Practice Test Questions
100Flashcards
100Glossary of terms
01 / Skills you'll get
What you will be able to do
Try Free →
No credit card required
In this Power BI Data Analytics course, you’ll learn how to transform raw data into clear, actionable insights through dynamic reports and visualizations. From connecting to various data sources and clearing data to creating interactive dashboards, you’ll leverage full range of Power BI’s features. By the end of this course, you’ll have strong grip on data modeling using DAX for advanced calculations, build custom visuals, and learn how to share your reports with others.
- Connect to various data sources and manage data relationships in Power BI
- Clearn, shape, and transform data using Power BI’s Query Editor
- Analyze and profile data to ensure accuracy and quality
- Create compelling charts, graphs, and visuals to present data effectively.
- Use Data Analysis Expressions (DAX) for complex calculations and creating calculated columns/measures
- Create and personalize dynamic, interactive dashboards and reports
- Conduct in-depth statistical analysis and use calculated tables and parameters
- Publish reports, oversee workspaces, and share dashboards among teams or organizations
- Extend Power BI capabilities to mobile devices and customize layouts for on-the-go access
- Collaborate with on reports, configure row-level security, and control access with Power BI API
Course Highlights
-
12 Structured Lessons Comprehensive coverage of core course objectives
-
26 Hands-On LiveLabs Interactive guided scenarios with instant evaluation
-
87 Practice Questions Assessment tests with detailed answer rationales
-
1 Year Full Access Self-paced learning accessible anytime on all devices
02 / Lessons & labs
See exactly what you will learn and practice
Lessons
12 Interactive Lessons · 42 topics01 Introduction 3 topics +
- Course Description
- How to Use This course
- Course-Specific Technical Requirements
02 Analyzing Data with Self-Service BI 3 topics · 1 LiveLab +
- Topic A: Data Analysis and Visualization for Business Intelligence
- Topic B: Self-Service BI with Microsoft Power BI
- Summary
1 LiveLab in this lesson — see the labs panel →
03 Connecting to Data Sources 4 topics · 3 LiveLab +
- Topic A: Create Data Connections
- Topic B: Configure and Manage Data Relationships
- Topic C: Save Files in Power BI
- Summary
3 LiveLab in this lesson — see the labs panel →
04 Performing Data Cleaning, Profiling, and Shaping 5 topics · 4 LiveLab +
- Topic A: Clean, Transform, and Load Data with the Query Editor
- Topic B: Profile Data with the Query Editor
- Topic C: Shape Data with the Query Editor
- Topic D: Combine and Manage Data Rows
- Summary
4 LiveLab in this lesson — see the labs panel →
05 Visualizing Data with Power BI 3 topics · 2 LiveLab +
- Topic A: Create Visualizations in Power BI
- Topic B: Chart Data in Power BI
- Summary
2 LiveLab in this lesson — see the labs panel →
06 Enhancing Data Analysis 3 topics · 2 LiveLab +
- Topic A: Customize Visuals and Pages
- Topic B: Incorporate Tooltips
- Summary
2 LiveLab in this lesson — see the labs panel →
07 Modeling Data with Calculations 3 topics · 3 LiveLab +
- Topic A: Create Calculations with Data Analysis Expressions (DAX)
- Topic B: Create Calculated Measures and Conditional Columns
- Summary
3 LiveLab in this lesson — see the labs panel →
08 Creating Interactive Visualizations 4 topics · 2 LiveLab +
- Topic A: Create and Manage Data Hierarchies
- Topic B: Filter and Slice Reports
- Topic C: Create Dashboards
- Summary
2 LiveLab in this lesson — see the labs panel →
09 Using Advanced Analysis Techniques 4 topics · 3 LiveLab +
- Topic A: Create Calculated Tables, Variables, and Parameters
- Topic B: Enhance Visuals with Statistical Analysis
- Topic C: Perform Advanced Analysis
- Summary
3 LiveLab in this lesson — see the labs panel →
10 Enhancing Reports and Dashboards 3 topics · 2 LiveLab +
- Topic A: Enhance Reports
- Topic B: Enhance Dashboards
- Summary
2 LiveLab in this lesson — see the labs panel →
11 Publishing and Sharing Reports and Dashboards 4 topics · 2 LiveLab +
- Topic A: Publish Reports
- Topic B: Create and Manage Workspaces
- Topic C: Share Reports and Dashboards
- Summary
2 LiveLab in this lesson — see the labs panel →
12 Extending Power BI Beyond the Desktop 3 topics · 2 LiveLab +
- Topic A: Use Power BI Mobile
- Topic B: Extend Access with the Power BI API
- Summary
2 LiveLab in this lesson — see the labs panel →
Hands-On Labs Our edge
26 LiveLabs- Interacting with Visualizations in Power BI
- Creating a Data Connection
- Configuring and Managing Data Relationships
- Saving and Exporting Files in Power BI
- Cleaning, Transforming, and Loading Connected Data
- Profiling Data in Power BI
- Shaping Data for Analysis
- Using the Transpose Feature
- Creating Visualizations
- Charting Data in Power BI
- Customizing Visuals in Power BI
- Incorporating Tooltips to Enhance Data Analysis
- Creating Calculations with DAX
- Creating Calculated Measures
- Creating Conditional Columns
- Creating and Managing Data Hierarchies
- Filtering and Slicing Reports
- Creating a Calculated Table
- Enhancing Visuals with Statistical Analysis
- Performing Advanced Analysis
- Enhancing Reports
- Enhancing Dashboards
- Publishing Reports and Refreshing Data
- Configuring Row-level Security
- Configuring the Mobile Layout
- Reviewing Custom Visuals and Apps
Labs run in your browser — nothing to install.
03 / FAQs
Questions before you start
Who should take this course?+
This course is ideal for data analysts, business intelligence professionals, or anyone looking to enhance their data visualization and analysis skills using Power BI.
Do I need prior Power BI experience to enroll in this course?+
No prior Power BI experience is needed. This course addresses topics ranging from fundamental concepts to advanced techniques, making it ideal for newcomers.
How can Power BI professional skills benefit my career?+
Power BI skills are in high demand across industries, helping you stand out as a data-driven professional. These skills will enable you to transform data into valuable insights, improving decision-making and opening doors to roles in data analysis, business intelligence, and reporting.
Is it possible to use Power BI with alongside other Microsoft tools?+
Absolutely! Power BI integrates seamlessly with other Microsoft tools like Excel, Azure, and Sharepoint, improving your workflow and data analysis capabilities.
Become a Data Analysis Expert
In this hands-on training course, clean and sort data in Power BI to produce impressive visualizations and interactive dashboards.
- 1 year of full access
- 26 LiveLab included
- Certificate of completion
No credit card required