Power BI can look intimidating the first time you open it. In reality, you can build your first Power BI dashboard from an Excel file in an afternoon. Here’s the route I take beginners through. For the official download and documentation, see Microsoft’s Power BI Desktop page.
1. Install Power BI Desktop
Power BI Desktop is free to download from Microsoft. It runs on Windows only, so Mac users will need a Windows laptop or a virtual machine.
2. Get your data
Choose Get data, Excel workbook and pick your file. Select the tables or sheets you want, then click Transform Data rather than Load. This opens Power Query, where you can check column names and data types and tidy anything that looks wrong before it reaches your report.
3. Check how your tables connect
If you have more than one table, for example Sales and Products, open the Model view. Power BI often spots relationships automatically, linking the product code in Sales to the product code in Products. If it hasn’t, drag one field onto the other to create the link. Getting this right is what makes your filters work properly later.
4. Create your first measure
Measures are calculations written in a language called DAX. Start with a simple total:
Total Sales = SUM(Sales[Amount])Measures are better than dragging raw columns into visuals, because you can reuse them everywhere and build on them later.
5. Add a few visuals
- A card showing Total Sales.
- A column chart of Total Sales by month.
- A bar chart of Total Sales by product.
- A slicer for region, so people can filter the whole page.
Click a bar in one chart and watch the others filter. That interactivity is what makes Power BI so powerful.
6. Keep the design simple
- Put the most important number in the top left, where people look first.
- Stick to three to five visuals per page.
- Use one accent colour to highlight what matters, and keep everything else neutral.
- Give every visual a clear title that says what it shows.
7. Share it
When you’re happy, click Publish to send the report to the Power BI Service online. Sharing reports with colleagues usually needs a paid Power BI licence, so check what your organisation has before you promise anyone access.
My Power BI Foundations course takes you through all of this, step by step, live and in a small group. No previous experience needed.