Excel & Power BI Dashboard Projects for Beginners

Name: Excel & Power BI Dashboard Projects for Beginners
Rating: 4.6 (31 reviews)

Learn to Build Interactive Dashboards and Visual Reports from Scratch

Created bySamuel Okon

Last updated 12/2025

English

English [Auto],

What you'll learn

Clean, transform, and analyze datasets in Excel using formulas, pivot tables, and advanced functions to uncover actionable insights.
Build interactive dashboards in Excel and Power BI that communicate key trends and performance metrics effectively.
Connect, shape, and model data in Power BI using Power Query and DAX to create accurate, dynamic reports.
Visualize data with clarity and impact by applying best practices for charts, slicers, and drill-through pages.
Design and publish a professional portfolio website to showcase dashboards, reports, and analytical projects to potential employers or clients.

Course content

4 sections • 45 lectures • 4h 42m total length

Understanding Data Analysis: The Foundation of Every Insight2:33
Data analysis turns raw data into meaningful insights by collecting, cleaning, transforming, and interpreting data to support decision making, using descriptive, diagnostic, predictive, and prescriptive analysis.
From Descriptive to Predictive: Types of Data Analysis5:46
Explore the four main types of data analysis—descriptive, diagnostic, predictive, and prescriptive—and learn when to apply each with real-life sales examples.
Understanding the Role of a Data Analyst2:24
Data analysts collect, clean, and analyze data to turn information into insights using statistics and Power BI or Tableau. They communicate findings via reports and dashboards to guide sales decisions.
Free Video: Excel Dashboard Project Overview5:35
Explore a centralized dashboard that tracks revenue, sales, quantity, and customer demographics to monitor KPIs and guide data-driven decisions, including brand performance and weekly and monthly trends.
Free Video: Power BI Dashboard Project Overview5:15
Explore how the product preferences dashboard in Power BI reveals customer choices across car models, colours, body styles, engine types, and transmissions using percentage KPIs to guide inventory and marketing.

Setting up Microsoft Excel on Windows9:26
Learn how to download and install Microsoft Office and Excel on Windows, verify 2021 or newer, uninstall older versions, and activate the 2021 setup, with notes on Mac installation.
Importing Data into Excel Using the Get Data Feature2:05
Learn to import data from the local system into an Excel workbook using the Get Data dropdown, choose csv or workbook formats, and load via Power Query without transformation.

Dashboard Project Overview5:35
Launch a centralized sales and customer analytics dashboard that tracks key performance indicators such as total sales, revenue, quantity, average order value, growth rate, insights on demographics and top customers.
Microsoft Excel Project: Data Importation3:20
import data into excel using the data tab and get data, loading a csv file via power query to inspect for clean data before analysis.
Microsoft Excel Project: Data Cleaning And Transformation17:09
Explore and clean data in Power Query by correcting gender values, trimming spaces, and replacing data, then transform income into salary groups to analyze customer behavior.
Microsoft Excel Project: Data Modeling6:05
Master data modeling in Excel using a calendar table and relationships, PowerPivot included, to enable time intelligence calculations for growth rate comparing current year revenue to previous year revenue.
Microsoft Microsoft Excel Project: KPI 18:26
Learn how to calculate business KPIs in Excel using pivot tables to measure total quantity sold, total revenue, growth rate, and median-based average order value, with implicit and explicit functions.
Microsoft Excel Project: KPI 210:18
Learn to create KPI measures in Excel using dax, including median-based average order value and year-over-year growth with a calendar table and time intelligence.
Microsoft Excel Project: Analysis9:24
Analyze sales data with pivot tables to reveal gender impact, top customers, salary groups, and top five cars, then track weekly and monthly trends to spot seasonality.
Microdoft Excel Project: Data Visualization5:48
Explore visualization in Excel by turning datasets into actionable insights with pivot tables and charts such as pie, bar, column, and line charts to communicate trends to stakeholders via dashboards.
Microdoft Excel Project: Dashboard Background Design4:43
Create the dashboard background and standardize fonts, colors, and KPI visuals for the demography and sales trend dashboards. Prepare the workbook by hiding unused cells and applying a background color.
Microdoft Excel Project: Dashboard Template Design8:37
Design a dashboard template in Excel using shapes to build a sidebar and KPI panels, adjust size and colors, duplicate and align elements, and save progress.
Excel Project: Importing KPI To Dashboad 17:26
import and display KPIs in an Excel dashboard by linking cells from a pivot table, formatting values as currency and percentage, and styling KPI boxes for consistent alignment.
Microsoft Excel Project: Importing KPI To Dashboard 24:41
Bring in top performing KPIs to the dashboard by converting pivot table data into visible metrics, highlighting Chevrolet, Dodge, Ford, and Volkswagen with precise numeric insights.
Microsoft Excel Project: Design Title(Text Box) On Dashboard 114:35
Design dashboard titles using text boxes instead of default chart titles, format with color, size, alignment, and no fill or outline, and replicate formatting for consistent key performance indicators.
Microsoft Excel Project: Design Title(Text Box) On Dashboard 25:05
Design text boxes on the dashboard to display chart titles with clear formatting. Create titles for charts like top five customers by quantity and sales trend, plus a greeting.
Excel Project: How To Design And Format Column Chart 15:49
Import and design a column chart on your dashboard, copy and paste the chart, adjust gap width, customize color and font, remove axes, gridlines, and legend, and add data labels.
Excel Project: How To Design And Format Column Chart 25:44
Design and format a donut chart in Excel to show gender by percentage, customize colors, adjust the donut size, remove outlines, and add data labels for clear category labeling.
Excel Project: How To Design And Format Bar Chart3:11
Learn to design and format a bar chart in Excel to communicate salary grouped by quantity, adjust axes, use data labels, and refine visuals for dashboards.
Excel Project: How To Design And Format Line Chart5:42
Design and format a line chart to visualize the weekly quantity sales trend in a dashboard, applying smoothing, color, gridlines, font, and outline adjustments.
Microsoft Project: How Import Icon And Image11:45
Source and colorize icons for Excel dashboards, convert PNGs with online tools, remove backgrounds, and insert colorful icons into your two dashboards to visualize sales and demographics.
How To Create And Design Slicer9:42
Learn how to create and design an Excel slicer that filters pivot tables and charts, connects to multiple pivot tables, and customizes colors, fonts, headers, and layout.

Power BI Dashboard Project Overview5:14
1️⃣ Introduction – Problem Setup
Before we dive into the data, let’s take a step back and think like a business.
It’s not enough for a car company to simply know how many cars it sold.
The real question is — what do customers actually prefer?
Do they want SUVs more than sedans?
Do they prefer automatics over manuals?
Which colors or brands excite them the most?
These are the kinds of insights that truly help a business stay competitive — and that’s exactly what this dashboard is designed to uncover.
2️⃣ Objective of the Dashboard
The Product Preferences Dashboard gives stakeholders a clear understanding of customer choices across different aspects — car models, colors, body types, transmission types, and even engine preferences.
By tracking KPIs in percentages instead of raw sales numbers, we get a clearer picture of relative popularity — making it easy to compare products side by side.
Specifically, this dashboard helps us:
Identify market trends, like which models or body types are most in demand.
Understand customer behavior, such as their transmission or color preferences.
Support strategic decision-making — ensuring production and marketing focus on what customers truly value.
And benchmark brand performance by comparing each company’s market share.
3️⃣ Business Questions – Framing Curiosity
To really get value from this dashboard, we need to ask the right questions.
Here are the key business questions we’ll be answering:
Which car models are most preferred by customers?
What body styles are most in demand — SUVs, sedans, hatchbacks, or others?
Do customers show stronger preferences for certain engine types — like petrol, diesel, hybrid, or electric?
What’s the balance between manual and automatic transmissions?
Which colors are most popular among customers?
And finally, do product preferences vary by region, and how does each car company compare in terms of market share?
These questions set the stage for deeper insights.
4️⃣ Dashboard Walkthrough – Chart by Chart
Let’s now walk through the dashboard and interpret what each section tells us.
Sales by Car Company and Model:
Here we can see which car companies and models are most preferred.
This answers our first business question — which products lead the market and which ones might need a boost in marketing or design.
Sales by Body Style:
Next, we explore body style preferences — whether customers lean more toward SUVs, sedans, or hatchbacks.
This insight helps the company align production and inventory with real demand.
Sales by Engine Type:
Here we look at engine preferences — petrol, diesel, hybrid, or electric.
This is especially important for long-term strategy.
If hybrid or electric vehicles are gaining traction, it signals a need for investment in innovation and R&D.
Sales by Transmission (Manual vs Automatic):
This chart shows customer preference between manual and automatic transmissions.
It also helps dealerships plan inventory and gives insight into whether markets are shifting more toward automatic vehicles.
Sales by Color:
Next, we have color preferences.
Customers often have strong color choices — and knowing the top-performing colors can guide production planning and marketing campaigns.
Regional Revenue and Quantity:
Finally, we explore performance by region.
Which regions generate the highest revenue?
Are there specific areas where certain models or body types perform better?
This helps with regional strategy, from marketing to logistics and supply chain planning.
5️⃣ Wrap-up – From Insights to Strategy
So, what we’ve seen here is that dashboards aren’t just pretty visuals — they’re tools for decision-making.
The Product Preferences Dashboard transforms raw sales data into meaningful insights about what customers actually want.
And when businesses understand customer preferences clearly, they can make smarter decisions about production, marketing, and inventory management.
From a learning point of view, this dashboard demonstrates how KPIs like percentages, market share, and trend indicators can drive real-world business strategies.
Power BI Dashboad Project: Data Importation10:40
Import csv data into Power BI, clean and transform with Power Query, and show car model preferences with KPIs like total cars sold, revenue, and year to year growth.
Power BI Dashboard Project: Creating Calendar Table Using Dax5:43
Create a calendar table with DAX using min and max dates to avoid duplicates, add a year column, and relate it to the car sales table for time intelligence.
Power Bi Dashboard Project: Calculate Total Revenue (KPI)3:25
Power BI dashboard project teaches you to build a measures table, create a total revenue KPI by summing the price column, and manage measure destinations for accurate insights.
Power BI Dashboard Project: Calculate Total Quantity1:56
Learn to calculate total cars sold in Power BI by creating a measure that counts car IDs as transactions, showing how to use count to quantify sales.
Power BI Dashboard Project: Calculate Average Order Value (KPI)0:54
Learn to calculate the average order value in Power BI by creating a new measure avg__value, defined as total revenue divided by total number of cars sold, using existing measures.
Power BI Dashboard Project: Calculate Growth Rate (KPI)4:42
Compute growth rate in Power BI with time intelligence, comparing current year revenue to the previous year using total ytd and same period last year for a key performance indicator.
Power BI Dashboard Project: Remove Error in Growth Rate3:19
Learn to fix infinity in year-to-year growth by using iferror in Power BI dashboards. Resolve missing data issues for 2021 by returning zero and clean blanks in revenue visuals.
Power BI Dashboard Project: Remove Blank Error in Previous Year5:40
Remove blank errors in the previous year by using if and isblank to return zero, then store the revenue calculation in a var for a cleaner DAX Power BI solution.
Power BI Dashboard Project: Setting Up Background8:21
Design a Power BI dashboard by setting a white 16:9 canvas with zero transparency, then create template shapes, copy colors, add shadows, and arrange charts (three bars, two columns, pie).
Power BI Dashboard Project: How to Insert Text10:57
Learn how to insert and format text boxes in a Power BI dashboard, creating titles and KPI labels like car sales dashboard, total revenue, and year-over-year growth.
Power BI Dashboard Project: Calculate Percentage of Cars Sold5:05
Learn to build a Power BI dashboard metric that calculates the percentage of cars sold by dividing total cars sold by a defined denominator and visualizing it across years.
Power BI Dashboard Project: How to Design Card5:38
Design a Power BI dashboard card to visualize metrics and KPIs such as total cards sold, total revenue, and average order value with year to year growth.
Power BI Dashboard Project: How to Design Bar Chart6:16
Design a Power BI bar chart to show car model preferences, using the top five percentage of cardboard, with the y-axis for models and the x-axis for the metric.
Power BI Dashboard Project: How to Column Chart3:50
Design a Power BI column chart to visualize customers' transmission preferences, with transmission on the x axis and percentage on the y axis, and customize titles and data labels.
Power BI Dashboard Project: How to Design Doughnut Chart3:52
Design a Power BI donut chart to communicate color preferences by mapping categories to a legend and values to percentages, customizing colors, labels, and slicer settings for clear insights.
Power BI Dashboard Project: How to Design Slicer3:39
Design a slicer in Power BI to display the top five companies by the highest cardboard percentage. Configure the slicer style, background color, borders, and interactions to optimize clarity.
Power BI Dashboard Project: How to Insert Logo and Icon6:58
learn how to import a logo and create a custom icon for a Power BI dashboard, using insert image, Flat Icon, and color change steps to match branding.

Requirements

No prior experience with Excel or Power BI is required — this course starts from the basics and builds up to advanced concepts.
Access to a computer (Windows or Mac) with a stable internet connection to download and practice with the tools.
Microsoft Excel (2019 or later) and Power BI Desktop installed — both have free or trial versions available.
Willingness to learn by doing — you’ll get more out of this course if you follow along with the exercises and projects.
Basic computer literacy — knowing how to navigate files, folders, and install software will help you move faster.

Description

Unlock the power of data and turn it into actionable insights with hands-on Excel and Power BI dashboard projects! This beginner-friendly course is designed for anyone who wants to learn by doing and create professional, interactive dashboards that impress managers, colleagues, and clients.

Through step-by-step guided projects, you’ll master the essential tools and techniques for transforming raw data into visually appealing and insightful reports. You don’t need prior experience—this course will walk you through everything from connecting datasets to designing dashboards that clearly communicate key metrics.

What you’ll learn in this course:

Build interactive dashboards in Excel and Power BI from scratch
Use charts, graphs, and KPIs to visualize data effectively
Apply data modeling and aggregation techniques for meaningful insights
Work with real-world datasets to create projects you can showcase in your portfolio
Gain confidence in designing professional dashboards for business or personal use

Whether you’re a student, professional, or aspiring data analyst, this course will give you the skills and confidence to create dashboards that make data understandable, actionable, and visually stunning.

By the end of this course, you’ll be able to:

Design dashboards that highlight trends, comparisons, and patterns
Combine Excel and Power BI features to deliver interactive reports
Present data insights clearly to stakeholders or clients

Start your journey into data visualization and dashboard creation today and turn your data into powerful stories!

Who this course is for:

Beginners in data analysis who want to build a solid foundation using Excel and Power BI.
Students or recent graduates looking to develop job-ready analytical skills for internships or entry-level roles.
Professionals from non-technical fields who want to analyze data, create dashboards, and make data-driven decisions.
Career switchers aiming to break into analytics, business intelligence, or related tech roles.
Entrepreneurs and business owners who want to understand their numbers and track performance with interactive reports.

Excel & Power BI Dashboard Projects for Beginners

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 22min

Data sources and access2 lectures • 12min

Microsoft Excel Dashboard Project20 lectures • 2hr 33min

Microsoft Power Bi Dashboard Project18 lectures • 1hr 36min

Requirements

Description

Who this course is for: