Create a Report Page

We start with a real sales dataset from Excel, connect it directly into Power BI, and build a complete report page — asking business questions and choosing the right visual to answer each one.

---

Step 1 — Connect & Load

The dataset is a single Excel table called Sales. The data is already clean, so we connect and load directly — no transformations needed.

---

Step 2 — Check Data Types

Before building any visual, confirm that Power BI has correctly detected each column's data type. Wrong data types are the most common source of errors in reports.

---

Step 3 — Ask Questions, Choose Visuals

Every visual should answer a specific business question. We start by writing the questions first, then decide which visual type answers it best.

---

The Report Page

Here is how the completed report page looks — all five questions answered with the right visuals, arranged on a single page.