Learning path

Data Visualization in Power BI and Excel

For beginners ready to move from basic charts to polished, decision-ready visuals. You will build and format charts, KPI cards and finance comparisons in Power BI and Excel.

What you’ll learn

  • Build and format common chart types in Power BI with clear titles and colours
  • Design KPI cards with previous-year and budget comparisons and variance colouring
  • Recreate Economist-style stacked bar and dumbbell charts in Excel
  • Build an actual vs budget vs forecast chart with variance for finance audiences

Lessons

  1. ZAINAB TECH LAB 5 min Beginner

    Start here: a gentle orientation to the workspace and terminology before any chart building.

    An introduction to the Tableau workspace, its terminology and basic functions, covering Experiment 1 of the VTU Data Visualization Laboratory (BAI504) syllabus. Aimed at students starting Tableau for the first time.

  2. ZAINAB TECH LAB 13 min Beginner

    Adds your first hands-on Power BI charts, plus title and colour formatting and filters.

    This video covers Experiments 7 and 8 of the VTU Data Visualization Laboratory (BAI504). It shows how to create reports and different chart types in Power BI, format chart titles and colours, and add filters and formatting to dashboards. It is aimed at students preparing for lab exams and vivas.

  3. MyOnlineTrainingHub 16 min Beginner

    Adds layout and styling techniques that make the charts you built easier to read.

    Shows four design techniques for making Power BI reports more visually engaging and clearer to read. The example file is provided so viewers can follow along.

  4. Leila Gharani 16 min Intermediate

    Adds KPI cards with previous-year and budget reference labels and red or green variance.

    Shows how to build KPI cards with Power BI's card visual, adding reference labels for previous year and budget, red or green variance formatting, and tile, table or grid layouts. It also covers a manager card built with hero images.

  5. Leila Gharani 19 min Intermediate

    Brings chart design into Excel, with Economist-style stacked bar and dumbbell charts.

    Leila Gharani rebuilds three Economist-style charts in Excel: a 100% stacked bar chart with linked text boxes, a dumbbell chart built from a scatter plot with error bars, and a color-coded table made from shapes in cells. Each is set up to update automatically when source data changes. The color-coded table requires Microsoft 365.

  6. Bas Dohmen | Data Training 24 min Intermediate

    Brings it together in a decision-ready chart: actual, budget and forecast with variance.

    A Power BI tutorial on designing a chart that compares actual, budget and forecast figures for a CFO audience, with scenario analysis and variance. It suits people who already build reports in Power BI.

  7. ZAINAB TECH LAB 8 min Beginner

    Optional: adds maps and a full interactive dashboard, using Tableau rather than Power BI.

    A VTU Data Visualization Laboratory (BAI504) experiment that analyses GDP data using symbol maps, bar, pie and scatter charts, and an interactive dashboard. It is aimed at students preparing for lab exams and viva.

  8. Bas Dohmen | Data Training 17 min Intermediate

    Optional: shows how AI can help build Power BI charts once you have built them by hand.

    Shows how to give AI a Power BI skill by saving a report in PBIP format, writing a SKILL.md file with Claude Code from a before and after example, and testing it on a different dataset. Aimed at Power BI users who build report visuals.

When you've finished

Next path: Designing Data Visualizations for Real Audiences (Intermediate)

All paths in Data Visualization

Search and sort within Data Visualization in Power BI and Excel

All paths
  • Learning pathBeginnerData Visualization

    Data Visualization

    For beginners, this path teaches how to choose the right chart, strip clutter, avoid common mistakes and tell a clear story with data. You will learn to effectively communicate data insights.

    7 lessons · 46 min

  • Learning pathIntermediate → AdvancedUI

    Designing Clear Dashboards: Layout, Charts and Colour

    For designers who know the basics and want dashboards that are easy to read and use. You will learn to plan a layout around its users, choose suitable charts and colours, and spot common enterprise mistakes.

    9 lessons · 1 hr 38 min, plus 1 optional