Power BI: Data Analysis Professional
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 the 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.
What You`ll Learn on This Course
-
- 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
This course comes with:
Curriculum
- 2 Sections
- 0 Lessons
- 26 Weeks
Expand all sectionsCollapse all sections
- Lesson Plan
Introduction
- Course Description
- How to Use This Course
- Course-Specific Technical Requirements
2 Analyzing Data with Self-Service BI
- Topic A: Data Analysis and Visualization for Business Intelligence
- Topic B: Self-Service BI with Microsoft Power BI
- Summary
3 Connecting to Data Sources
- Topic A: Create Data Connections
- Topic B: Configure and Manage Data Relationships
- Topic C: Save Files in Power BI
- Summary
4 Performing Data Cleaning, Profiling, and Shaping
- 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
5 Visualizing Data with Power BI
- Topic A: Create Visualizations in Power BI
- Topic B: Chart Data in Power BI
- Summary
6 Enhancing Data Analysis
- Topic A: Customize Visuals and Pages
- Topic B: Incorporate Tooltips
- Summary
7 Modeling Data with Calculations
- Topic A: Create Calculations with Data Analysis Expressions (DAX)
- Topic B: Create Calculated Measures and Conditional Columns
- Summary
8 Creating Interactive Visualizations
- Topic A: Create and Manage Data Hierarchies
- Topic B: Filter and Slice Reports
- Topic C: Create Dashboards
- Summary
9 Using Advanced Analysis Techniques
- Topic A: Create Calculated Tables, Variables, and Parameters
- Topic B: Enhance Visuals with Statistical Analysis
- Topic C: Perform Advanced Analysis
- Summary
10 Enhancing Reports and Dashboards
- Topic A: Enhance Reports
- Topic B: Enhance Dashboards
- Summary
11 Publishing and Sharing Reports and Dashboards
- Topic A: Publish Reports
- Topic B: Create and Manage Workspaces
- Topic C: Share Reports and Dashboards
- Summary
12 Extending Power BI Beyond the Desktop
- Topic A: Use Power BI Mobile
- Topic B: Extend Access with the Power BI API
- Summary
0 - Hands-on LAB Activities
Analyzing Data with Self-Service BI
- Interacting with Visualizations in Power BI
2 Connecting to Data Sources
- Creating a Data Connection
- Configuring and Managing Data Relationships
- Saving and Exporting Files in Power BI
3 Performing Data Cleaning, Profiling, and Shaping
- Cleaning, Transforming, and Loading Connected Data
- Profiling Data in Power BI
- Shaping Data for Analysis
- Using the Transpose Feature
4 Visualizing Data with Power BI
- Creating Visualizations
- Charting Data in Power BI
5 Enhancing Data Analysis
- Customizing Visuals in Power BI
- Incorporating Tooltips to Enhance Data Analysis
6 Modeling Data with Calculations
- Creating Calculations with DAX
- Creating Calculated Measures
- Creating Conditional Columns
7 Creating Interactive Visualizations
- Creating and Managing Data Hierarchies
- Filtering and Slicing Reports
8 Using Advanced Analysis Techniques
- Creating a Calculated Table
- Enhancing Visuals with Statistical Analysis
- Performing Advanced Analysis
9 Enhancing Reports and Dashboards
- Enhancing Reports
- Enhancing Dashboards
10 Publishing and Sharing Reports and Dashboards
- Publishing Reports and Refreshing Data
- Configuring Row-level Security
11 Extending Power BI Beyond the Desktop
- Configuring the Mobile Layout
- Reviewing Custom Visuals and Apps
0
