Prerequisites

• Access to Power BI Desktop
• Basic knowledge of Power BI (optional)
• Familiarity with data visualization concepts (Optional)

Course Outline

1. Introduction

• 1.1 Introduction to the Course
• Course objectives
• Overview of Power BI interface
• 1.2 Importance of Data Visualization
• Benefits of using graphs
• Key considerations for effective visualizations

2. Basic Graphs

• 2.1 Bar and Column Charts
• When to use bar and column charts
• Creating a basic bar/column chart
• Customizing colors, labels, and axis
• 2.2 Line Charts
• Use cases for line charts
• Creating a line chart
• Formatting lines, markers, and axes
• 2.3 Pie and Donut Charts
• Best practices for pie charts
• Creating pie and donut charts
• Customizing segments and labels
• 2.4 Practical Activity: Create a dashboard with bar, column, line, and pie charts using a sample dataset.

3. Intermediate Graphs

• 3.1 Area Charts
• Understanding area charts
• Creating area and stacked area charts
• Customization options
• 3.2 Combo Charts
• Combining different chart types
• Creating a combo chart (e.g., line and column)
• Formatting and dual-axis customization
• 3.3 Scatter and Bubble Charts
• Use cases for scatter and bubble charts
• Creating and customizing scatter/bubble charts
• Adding trend lines and play axis for time series
• 3.4 Practical Activity: Design a dashboard incorporating area, combo, and scatter charts.

4. Advanced Graphs

• 4.1 Tree Maps and Sunburst Charts
• Visualizing hierarchical data
• Creating and customizing tree maps and sunburst charts
• 4.2 Waterfall Charts
• Understanding the waterfall chart
• Creating a waterfall chart to show changes in data
• 4.3 Funnel Charts
• Use cases for funnel charts
• Creating and customizing funnel charts
• 4.4 Gauge and KPI Visuals
• Monitoring key metrics
• Creating and customizing gauges and KPIs
• 4.5 Practical Activity: Build a dashboard with tree maps, waterfall, funnel, and gauge charts.

5. Interactivity and Customization

• 5.1 Slicers and Filters
• Adding and configuring slicers
• Using visual-level filters
• 5.2 Drill through and Cross-Filtering
• Setting up drill through actions
• Enabling and using cross-filtering between visuals
• 5.3 Custom Visuals
• Exploring Power BI marketplace for custom visuals
• Importing and using custom visuals
• 5.4 Practical Activity: Enhance a dashboard with slicers, drill through, and custom visuals.

6. Final Project and Q&A

• 6.1 Final Project
• Create a comprehensive dashboard using a variety of graphs covered in the course
• Apply customization and interactivity features.
• 6.2 Q&A Session
• Address any questions or challenges faced by participants.
• Provide additional tips and best practices.

​