Build Your First Power BI Dashboard (Hands‑On with Excel)
Stop reading about Power BI. Today you’ll connect a real Excel file, clean it, create three visuals, and publish your first live dashboard — in under 20 minutes.
Let me ask you something. How many times have you watched a tutorial, nodded along, and then closed the tab feeling like you learned nothing? That ends today. In Day 01 we explored the Power BI ecosystem. Today you become a builder. By the end of this post, you’ll have a fully functional Power BI dashboard published to the cloud — one you can show to your boss, add to your portfolio, or use as proof that you actually know this stuff.
I’ll give you the exact sample data to use, every click you need to make, and even five tricky interview questions hiring managers ask about Power BI fundamentals. If you only ever read one Power BI tutorial, make it this one.
A regional sales manager sends you a messy Excel file with last quarter’s sales data. Columns are misnamed, there are duplicate rows, and the numbers are stored as text. She needs a clean dashboard showing total sales, sales by region, and a detailed transaction table — by lunch.
1. Prepare Your Environment (2 minutes)
If you haven’t already, download Power BI Desktop from the Microsoft Store (search “Power BI Desktop”). It’s free. Open it. You’ll see the start screen with a “Get data” option. That’s all you need right now.
Get the Sample Data
Create a new Excel file named SalesData_Day02.xlsx. Copy the table below into Sheet1. This is intentionally a bit messy — just like real life.
| TransactionID | Region | Product | SalesAmount | Date |
|---|---|---|---|---|
| 1001 | North | Widget A | 500 | 2026-01-05 |
| 1002 | South | Widget B | 300 | 2026-01-06 |
| 1003 | North | Widget A | 450 | 2026-01-07 |
| 1004 | East | Widget C | 700 | 2026-01-08 |
| 1005 | South | Widget B | 300 | 2026-01-09 |
| 1005 | South | Widget B | 300 | 2026-01-09 |
| 1006 | West | Widget A | 800 | 2026-01-10 |
| 1007 | North | Widget C | 250 | not a date |
Notice the duplicate row (1005) and the wrong date in row 8. Save the file.
2. Connect to Excel and Load Data (3 minutes)
In Power BI Desktop, click Home → Get Data → Excel. Browse to your SalesData_Day02.xlsx file and open it. The Navigator window appears. Check the box next to Sheet1 and click Transform Data — we want to clean this before loading.
Always click “Transform Data” when the data might need cleaning. It opens Power Query Editor, which records every transformation step. If the source file updates, these steps re‑apply automatically.
3. Clean and Transform in Power Query Editor (7 minutes)
The Power Query Editor shows your data in a table. Let’s fix the issues.
3.1 Remove Duplicates
Select the TransactionID column, then go to Home → Remove Rows → Remove Duplicates. The duplicate row 1005 disappears.
3.2 Fix the SalesAmount Column
Check the data type of SalesAmount (look at the small icon next to the column header). If it says “ABC” (text), click the icon and change it to Whole Number or Decimal Number. If an error appears because of non‑numeric values, replace them first (our data is fine).
3.3 Fix the Date Column
The last row has “not a date”. Select the Date column. Click Replace Values (or right‑click → Replace Values). Replace “not a date” with a valid date, e.g., “2026-01-11”. Then change the column type to Date.
3.4 Rename Columns
Double‑click column headers to rename them clearly: “Transaction ID”, “Region”, “Product”, “Sales Amount”, “Order Date”.
3.5 Add a Simple Custom Column (Optional but impressive)
Go to Add Column → Custom Column. Name it “Sales with Tax” and use the formula: [Sales Amount] * 1.1. This shows how easily you can extend data.
Click Close & Apply in the top‑left corner. Power BI loads the cleaned data into the model.
4. Build the Dashboard – Three Must‑Know Visuals (6 minutes)
You’re now looking at the Report canvas. On the right, the Fields pane shows your table and columns.
4.1 KPI Card – Total Sales
In the Visualizations pane, click the Card icon (a rectangle with a number). Drag Sales Amount to the Fields well. A card appears showing the total sum. Click the card, go to the Format pane (paint roller), and change the Data label color, add a title “Total Sales”, and increase the font size.
4.2 Bar Chart – Sales by Region
Click a blank area, then select the Stacked Bar Chart visual. Drag Region to the Axis field, and Sales Amount to the Values field. You instantly see which region generated the most sales. Format it: change colors, add data labels.
4.3 Table – Transaction Details
Add a Table visual. Drag Transaction ID, Product, Region, Sales Amount, and Order Date into the Values well. Resize it. Turn on Conditional formatting for the Sales Amount column (Format pane → Conditional formatting → Background color) to highlight high‑value transactions.
5. Add a Slicer for Interactivity (2 minutes)
Click a blank area, choose the Slicer visual, and drag Region into the Field. Now click any region in the slicer — watch the bar chart and table filter instantly. This is the interactive power that Excel can’t match.
6. Publish to Power BI Service (2 minutes)
Go to Home → Publish. Sign in with your Power BI account (the free one you created yesterday). Choose a workspace (My Workspace is fine). Once published, click the link to view your dashboard in the browser. You can now share it with others.
Take a screenshot of this dashboard and add it to your LinkedIn profile or resume. A live dashboard is worth a thousand bullet points.
7. 5 Tricky Power BI Interview Questions (With Answers)
Now that you’ve built something real, let’s prepare you for the questions recruiters love to ask.
Q1: What is the difference between Power BI Desktop, Power BI Service, and Power BI Mobile?
Answer: Desktop is the free Windows application used to connect, model, and create reports. Service is the cloud platform (app.powerbi.com) for sharing, collaboration, and scheduled refresh. Mobile is the iOS/Android app for consuming dashboards on the go. Think of them as the workbench, the gallery, and the pocket viewer.
Q2: What is Power Query and why is it important?
Answer: Power Query is the ETL (Extract, Transform, Load) engine inside Power BI. It allows you to connect to data sources, clean and reshape data (remove duplicates, change types, merge tables) before loading it into the model. All transformations are recorded as steps, ensuring repeatability and auditability.
Q3: Why did you use “Transform Data” instead of “Load” directly?
Answer: Real‑world data is rarely clean. Loading raw data directly would bring errors (wrong types, duplicates) into the model, causing broken visuals or incorrect calculations. Cleaning in Power Query ensures the data model is accurate and performs well.
Q4: What is the difference between a measure and a calculated column?
Answer: A calculated column is computed row‑by‑row during data refresh and stored in the table (e.g., Sales with Tax). A measure is calculated on‑the‑fly based on the current filter context (e.g., Total Sales). Measures are dynamic and responsive to slicers; calculated columns are static.
Q5: How do you handle a situation where the source Excel file changes structure (e.g., new columns added)?
Answer: Power Query steps are applied in order. If a column name changes, the step that references it will break. To handle dynamic changes, you can use Power Query’s “Unpivot” or dynamic column selection, or design the query to use column positions sparingly. Regularly test refreshes and set up alerts in the Power BI Service.
8. Your Day 02 Action Plan
- Build the dashboard exactly as described above with the sample data.
- Experiment: Change the bar chart to a column chart. Add a donut chart showing sales by product.
- Publish and view it on your phone via the Power BI Mobile app.
- Answer the five interview questions in your own words — write them down.
- Share your creation in a comment or on LinkedIn using #PowerBI #Day02 — let the community see your progress.
🚀 On to Day 03
Tomorrow we dive into Power Query like never before — handling missing data, splitting columns, and preparing a dataset that’s truly analysis‑ready. You’ve built the foundation. Now we go deeper.
📌 Follow @FreeLearning365 for Day 03. | 🛠️ Tech Partner: @techbook24
 | Part - 02 | FreeLearning365){kind=link}
0 Comments
thanks for your comments!