Data Analysis and Visualization with Power BI
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you will learn report design and formatting in Power BI, which offers extraordinary visuals for building reports and dashboards. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 30 hours
- Course by Microsoft
-
Offered by
About
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you will learn report design and formatting in Power BI, which offers extraordinary visuals for building reports and dashboards. Additionally, you will learn how to use report navigation to tell a compelling, data-driven story in Power BI. You will explore how to get a statistical summary for your data and how to create and export reports in Power BI. You will also perform advanced analytics in Power BI to get deeper and more meaningful data insights. After completing this course, you'll be able to: ● Recognize the different types of visualizations in Power BI ● Add visualizations to reports and dashboards ● Apply formatting choices to visuals ● Add useful navigation techniques to the Power BI report ● Design accessible reports and dashboards ● Use visualizations to perform data analysis This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.Modules
Welcome to the Course
-
2
Videos
-
9
Readings
-
1
Discussion
1
Discussions
- Discussion prompt: What do you hope to learn?
2
Videos
- Course introduction
- Analysis for Business Intelligence
9
Readings
- Course syllabus
- How to be successful in this course
- How to open an image in a new tab
- Setting up your Power BI environment
- Setting up Power BI Service
- New name for Power BI datasets
- Business intelligence cheatsheet
- How to locate your downloaded files
- Additional resources: Key concepts
Introducing Visualizations
-
4
Videos
-
7
Readings
-
2
Assignment
2
Assignment
- Self-review: Create a sales report
- Knowledge check: Introducing Visualizations
4
Videos
- What are visualizations?
- Common visualizations
- Creating a basic report
- Table visualization
7
Readings
- Explore business report types
- Report Editor in Power BI
- Visualizations pane
- Exercise: Create a sales report
- Exemplar: Create a sales report
- Pinning visualizations
- Additional resources: Introducing Visualizations
Basic Visualizations
-
5
Videos
-
4
Readings
-
1
Assignment
1
Assignment
- Knowledge check: Basic Visualizations
5
Videos
- Bar and column charts
- Line and area charts
- Combo charts
- Pie and donut charts
- Treemaps
4
Readings
- Activity: Using bars, columns, and lines
- Activity: Enhance the report with brand information
- Targeted use of charts
- Additional resources: Basic Visualizations
Specialist Visualizations
-
5
Videos
-
4
Readings
-
1
Discussion
-
3
Assignment
3
Assignment
- Self-review: Indicating business performance
- Knowledge check: Specialist Visualizations
- Module quiz: Creating Reports
1
Discussions
- How would visualizing data help in business scenarios?
5
Videos
- Displaying Key Performance Indicators
- Ribbon and waterfall charts
- Funnel charts
- Scatter charts
- Module summary: Creating Reports
4
Readings
- Exercise: Indicating business performance
- Exemplar: Indicating business performance
- Matrix visualization
- Additional resources: Specialist Visualizations
Designing an Accessible Report
-
5
Videos
-
4
Readings
-
1
Assignment
1
Assignment
- Knowledge check: Designing an Accessible Report
5
Videos
- Accessibility in reports
- Formatting and configuring visualizations
- Conditional formatting
- Working with themes
- Adding custom tooltips
4
Readings
- Design best practices
- Activity: Creating an accessible report
- Activity: Improving accessibility with tooltips
- Additional resources: Designing an Accessible Report
Report Navigation and Filtering
-
4
Videos
-
2
Readings
-
1
Assignment
1
Assignment
- Knowledge check: Report Navigation and Filtering
4
Videos
- Report hierarchies
- Report drillthrough
- Sorting and filtering data in reports
- Cross-filter and cross-highlight
2
Readings
- Activity: Sorting and filtering a report
- Additional resources: Report Navigation and Filtering
Interactive Report
-
6
Videos
-
4
Readings
-
1
Discussion
-
3
Assignment
3
Assignment
- Self-review: Creating an interactive report
- Knowledge check: Interactive Report
- Module quiz: Navigation and Accessibility
1
Discussions
- What type of reports will you create for the different types of users that you interact with?
6
Videos
- Adding slicers
- Adding buttons
- Adding bookmarks
- Group and layer visuals
- DAX filter context in visualizations
- Module summary: Navigation and Accessibility
4
Readings
- Adding URLs
- Exercise: Creating an interactive report
- Exemplar: Creating an interactive report
- Additional resources: Interactive Report
Creating Dashboards
-
4
Videos
-
4
Readings
-
2
Assignment
2
Assignment
- Self-review: Building a dashboard
- Knowledge check: Creating Dashboards
4
Videos
- What is a dashboard?
- Creating a dashboard
- Improving usability in dashboards
- Limitations of pinned visuals
4
Readings
- Activity: Preparing a simple workspace
- Exercise: Building a dashboard
- Exemplar: Building a dashboard
- Additional resources: Creating Dashboards
Sharing with Stakeholders
-
2
Videos
-
5
Readings
-
2
Assignment
2
Assignment
- Self-review: Sharing a report
- Knowledge check: Sharing with Stakeholders
2
Videos
- Publishing reports
- Pagination and exporting reports
5
Readings
- Report page properties
- Exercise: Sharing a report
- Exemplar: Sharing a report
- Activity: Analyze in Excel
- Additional resources: Sharing with Stakeholders
Optimizing Reports
-
5
Videos
-
4
Readings
-
1
Discussion
-
3
Assignment
3
Assignment
- Self-review: Improving DAX performance
- Knowledge check: Optimizing Reports
- Module quiz: Bringing Data to the User
1
Discussions
- How will you use Power BI to share your data effectively?
5
Videos
- Introduction to the Performance Analyzer
- Resolving performance issues in DAX
- Using variables for performance
- Using variables for troubleshooting
- Module summary: Bringing Data to the User
4
Readings
- Tuning report performance
- Exercise: Improving DAX performance
- Exemplar: Improving DAX performance
- Additional resources: Optimizing Reports
Perform Analytics in Power BI
-
6
Videos
-
3
Readings
-
1
Assignment
1
Assignment
- Knowledge check: Perform Analytics in Power BI
6
Videos
- Introduction to analytics
- Statistical summary
- Group and bin data for analysis
- Histograms and Top N
- Clustering techniques
- Continuous and categorical axes
3
Readings
- Statistics cheatsheet
- Activity: Performing an analysis
- Additional resources: Perform Analytics in Power BI
Analytical Tools in Power BI
-
4
Videos
-
7
Readings
-
2
Assignment
2
Assignment
- Self-review: Explaining the increase
- Knowledge check: Analytical Tools in Power BI
4
Videos
- Using the Analyze feature
- Conducting a time series analysis
- Creating reference lines
- Forecasting
7
Readings
- Time series analysis
- Activity: Using the Play Axis visualization
- Error bars
- Exercise: Explaining the increase
- Exemplar: Explaining the increase
- Activity: Forecasting sales
- Additional resources: Analytical Tools in Power BI
Working with AI Visuals
-
3
Videos
-
4
Readings
-
1
Discussion
-
3
Assignment
3
Assignment
- Self-review: Root cause analysis
- Knowledge check: Working with AI Visuals
- Module quiz: Identifying Patterns and Trends
1
Discussions
- How will you use data visualization to bring your data to life?
3
Videos
- Key Influencers
- Decomposition trees
- Module summary: Identifying Patterns and Trends
4
Readings
- Q&A visualization
- Exercise: Root cause analysis
- Exemplar: Root cause analysis
- Additional resources: Working with AI Visuals
Final project and assessment: Data Analysis and Visualization with Power BI
-
1
Videos
-
3
Readings
-
2
Assignment
2
Assignment
- Self-review: Adventure Works executive summary
- Course quiz: Data Analysis and Visualization with Power BI
1
Videos
- Course recap: Data Analysis and Visualization with Power BI
3
Readings
- About the final project and assessment: Data Analysis and Visualization with Power BI
- Exercise: Adventure Works executive summary
- Exemplar: Adventure Works executive summary
Wrap-up: Data Analysis and Visualization with Power BI
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Congratulations
1
Readings
- Next steps
Auto Summary
Unlock the potential of data analysis with "Data Analysis and Visualization with Power BI." This foundational course, part of the Microsoft Power BI Analyst Professional Certificate, is ideal for beginners aiming for a career in data science. Led by expert instructors, you will master report design, formatting, and advanced analytics in Power BI. Over 1800 minutes, you'll learn to create compelling visuals, navigate reports, and prepare for the Microsoft PL-300 exam. Available on Coursera with a Starter subscription, this course is perfect for aspiring data analysts.
Microsoft