A beginner's step-by-step guide to building a Power BI dashboard: getting and cleaning data, building a data model, writing simple DAX measures, choosing visuals and publishing it.
Short answer: to build a Power BI dashboard, load your data in Power BI Desktop, clean it in Power Query, connect the tables in a simple star-shaped model, create a few DAX measures, add four to six visuals that answer one business question, then publish it to the Power BI service and pin the key visuals to a dashboard.
Before you start
- Install Power BI Desktop (free, Windows).
- Pick a dataset with sales or orders, dates, products and regions. A public sample sales dataset is ideal for practice.
- Write down the one question your dashboard answers, for example "Which products and regions drive revenue growth this year?"
Step 1: Get the data
Choose Get data and load your Excel or CSV files. Load each table separately: orders, products, customers, regions.
Step 2: Clean it in Power Query
- Set the right data types (dates as dates, amounts as decimals).
- Remove empty rows and duplicates, and fix inconsistent names (for example "Chennai" and "chennai").
- Rename columns to plain words; your future self will thank you.
Step 3: Build the model
In the Model view, connect the fact table (orders) to the dimension tables (products, customers, regions, dates) through their ID columns. This "star schema" keeps reports fast and measures correct. Add a separate date table and mark it as the date table.
Step 4: Write a few DAX measures
| Measure | DAX |
| Total Sales | Total Sales = SUM(Orders[Amount]) |
| Orders | Orders = DISTINCTCOUNT(Orders[OrderID]) |
| Average Order Value | Avg Order = DIVIDE([Total Sales], [Orders]) |
| Sales Last Year | Sales LY = CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date])) |
| Growth % | Growth % = DIVIDE([Total Sales] - [Sales LY], [Sales LY]) |
Use measures rather than calculated columns for totals; they respond to filters and slicers.
Step 5: Choose the visuals
- Cards across the top: Total Sales, Orders, Average Order, Growth %.
- A line chart of sales by month, this year against last year.
- A bar chart of sales by product category.
- A map or bar chart by region.
- Slicers for date and region so users can filter.
Keep it to one page that answers your question. Use one accent colour for what matters and grey for the rest.
Step 6: Publish and share
Publish to the Power BI service, set a scheduled refresh if the data source allows it, and pin the most important visuals to a dashboard. In Power BI, a report is the interactive pages; a dashboard is a single page of pinned tiles for a quick overview.
Turn it into a portfolio project
Add a short write-up: the question, the data, how you cleaned it, what you found and what you recommend. Two or three dashboards like this are one of the strongest things a fresher analyst can show. See the other skills employers look for in Data analyst skills in 2026.
Follow the free Power BI learning path, or learn with a mentor and real datasets in our Data Analytics with AI course or the Power BI and Tableau course.
Frequently asked questions
Is Power BI free?
Power BI Desktop is free. Sharing reports with others in an organisation usually needs a paid licence.
Do I need to learn DAX?
Yes, at least the basics. A few measures like the ones above cover most beginner dashboards.
Power BI or Tableau?
Both are good. Power BI is more common in Indian job posts and integrates closely with Excel and Microsoft tools.