This course is designed to empower participants with the essential skills required to effectively communicate insights through data visualization using Microsoft Power BI. Participants will learn to craft compelling narratives from raw data, driving informed decision-making within their organizations. The course covers the end-to-end process going from raw data to delivering data insights to make well-informed decisions.
Skills Gained
By the end of this course, students should be proficient in the following skills:
- Understand effective data storytelling.
- Apply data storytelling best practices.
- Select and create compelling visualizations.
- Communicate complex insights effectively.
- Drive informed decisions from raw data.
- Delivering data insights using dashboards, scorecards/metrics, and apps.
Prerequisites
Familiarity with Excel and Power BI is useful but not necessary.
Course Outline
Chapter 1. Understanding Data Analytics and Power BI
- Understanding Data Analytics
- Distinguishing Between Descriptive, Diagnostic, Predictive, Prescriptive, and Cognitive Analytics
- Explore the different roles in data
- Identify the tasks that are performed by a data analyst
- Getting Started with Power BI
- Describe the Power BI landscape of products and services
Chapter 2. From Raw Data to Informed Decision-Making: The End-to-End Process
- Understanding the End-to-End Process
- Data Preparation: Transforming Raw Data
- Data Modeling: Structuring for Analysis
- Visualization: Crafting Compelling Data Stories
- Publishing Reports
- Creating Dashboards and Metrics/Scorecards
- Packaging as an Application
- Effective Distribution Strategies
- Consuming Insights and Making Informed Decisions
Chapter 3. Creating a Basic Report in Power BI
- Get data from various data sources.
- Using Data Profiler to identify errors.
- Implementing a basic data model using Star Schema
- Create a report.
- Publish the report to Power BI Service
- Explore the report on Power BI Service
Chapter 4. Performing Descriptive Analytics with Power BI
- Your story: summarizing historical data to provide insights into what has happened and to understand past trends and patterns.
- Presenting raw data and statistics.
- Summarizing categorical data and displaying frequencies.
- Tracking trends and changes over time.
- Displaying proportions and percentages.
- Displaying patterns and correlations.
Chapter 5. Performing Diagnostic Analytics with Power BI
- Your story: identifying the reasons behind past events and patterns by examining data in depth to uncover root causes and correlations.
- Identifying relationships and correlations between variables.
- Analyzing data distributions.
- Visualizing data variability and identifying outliers.
- Exploring details and root causes.
Chapter 6. Performing Predictive Analytics with Power BI
- Your story: make informed forecasts about future events and trends, enabling organizations to strategically plan.
- Utilizing predictive modeling for future trends.
- Predicting outcomes based on historical data.
- Segmenting data and identifying patterns.
- Identifying unusual data points.
Chapter 7. Performing Prescriptive Analytics with Power BI
- Your story: recommend specific actions that organizations should take to optimize outcomes and make data-driven decisions.
- Implementing scenario analysis and decision support.
- Identifying factors impacting a specific outcome.
- Visualizing paths and outcomes based on decisions.
- Optimization and goal-based analysis.
Chapter 8. Performing Cognitive Analytics with Power BI
- Your story: analyzing data, providing insights, and making predictions in a human-like manner.
- Interact with data using plain language.
- Using built-in AI visuals.
- Overview of Sentiment Analysis and Image Recognition.
Chapter 9. Enhancing Reports in Power BI
- Understanding conditional formatting options.
- Adding images and hyperlinks to a table.
- Working with databars, sparklines, and indicators.
- Working with sync slicers.
- Working with tooltip popup.
- Implementing bookmarks, buttons, and selections.
Chapter 10. Delivering Data Insights
- Publishing Reports.
- Creating Dashboards and Metrics/Scorecards.
- Packaging as an Application.
- Effective Distribution Strategies.
- Consuming Insights and Making Informed Decisions.