You can go from zero to a published Power BI report in seven days with about an hour or two a day: install Desktop, load one dataset, clean it, build five visuals, add three simple calculations, polish the page and share it. The secret is to use a single small dataset all week, so you learn the tool and not a new dataset every day.
This plan assumes you know basic Excel. If you want the bigger picture first, read what Power BI is and what it is used for, and when you finish, move on to building your first Power BI dashboard.
The Seven-Day Plan at a Glance
| Day | Goal | What you will do | Time |
|---|---|---|---|
| 1 | Get set up | Install Desktop, create a Microsoft account, take a tour | 60 min |
| 2 | Load and clean data | Import Excel, fix types, remove blanks in Power Query | 90 min |
| 3 | Build a model | Add a second table, make a relationship, add a date table | 90 min |
| 4 | Make visuals | Cards, bar, line, table, slicer | 90 min |
| 5 | Add calculations | Three DAX measures | 90 min |
| 6 | Design the page | Layout, colour, titles, tooltips | 60 min |
| 7 | Share and review | Publish, set refresh, get feedback | 60 min |
Day 1: How Do You Install Power BI and Find Your Way Around?
Download Power BI Desktop from the Microsoft Store or Microsoft’s download page. It runs on Windows only, so on a Mac, use a Windows virtual machine or a cloud PC. Open it and look at the three views on the left: Report (where you build), Table (where you view data) and Model (where you link tables). Create a free Microsoft work or school account if you want to publish later; personal email addresses are often blocked for publishing.
Pick your dataset today. Good choices are Microsoft’s sample “Retail Analysis” file, a simple sales or expenses Excel sheet, or an export from a store you know. Pick something you understand, so mistakes are easy to spot.
Day 2: How Do You Load and Clean Data in Power Query?
Click Get Data, choose Excel, select your file and pick Transform Data. This opens Power Query. Check that each column has the right type: dates as Date, amounts as Decimal Number, IDs as Text. Remove empty rows, trim spaces from text, and rename columns in plain words. Every step is recorded on the right, so you can undo or change it later.
A beginner habit that saves hours: never edit the source file by hand. Do all cleaning in Power Query so the steps repeat when the data refreshes. Click Close and Apply when done.
Day 3: How Do You Build a Simple Data Model?
A model links tables so that filters flow correctly. Add a second small table, such as Products, and connect it to Sales using a shared key like ProductID in the Model view. Drag from one column to the other and check that the relationship is one-to-many, with the “one” side on the Products table.
Then create a date table. In Power BI you can use a DAX formula such as Date = CALENDARAUTO(), mark it as a date table, and link it to your sales date. This is one of the most important habits in Power BI, and it makes time calculations work later. Avoid linking many tables at once on the first day.
Day 4: Which Visuals Should You Build First?
Start with five. A card showing total sales, a clustered bar chart of sales by category, a line chart of sales by month, a table of top ten products and a slicer for region or year. Click a bar and watch the other visuals filter. This cross-filtering is the moment many beginners fall in love with the tool.
| Visual | Best for | Beginner tip |
|---|---|---|
| Card | One headline number | Keep the number large |
| Bar or column | Comparing categories | Sort from high to low |
| Line | Change over time | Use date, not text, on the axis |
| Table | Exact values | Limit to 10 rows |
| Slicer | Filtering | Place at the top or left |
| Pie or donut | Parts of a whole | Only with five slices or fewer |
Day 5: Which DAX Formulas Should You Learn First?
Learn three. Total Sales as SUM(Sales[Amount]). Total Orders as DISTINCTCOUNT(Sales[OrderID]). Average Order Value as DIVIDE([Total Sales],[Total Orders]). Create each as a measure by right-clicking the table and choosing New Measure. That is enough to feel how DAX works. Our full reference, Power BI DAX basics: formulas every analyst uses, covers the next ten.
Day 6: How Do You Make the Page Look Professional?
Give the page a clear title and a one-line subtitle that says what the report answers. Put the most important number top left. Use two or three colours, not ten. Align visuals on a grid, give them the same spacing and delete the borders you do not need. Rename the axes to plain words. Our dashboard design checklist is a good guide for this step.
Day 7: How Do You Publish and Share Your Report?
Click Publish and choose a workspace in the Power BI service. Open the report in the browser and check that filters work. To refresh automatically, you need a gateway if your data is on your computer or a database, and a licence if you share with others. Ask one colleague what the report tells them in 10 seconds, and note where they get confused. That feedback is worth more than another tutorial.
What Should You Do After Week One?
Repeat the build with a second dataset, learn time intelligence (this year vs last year), then start Microsoft Learn’s free Power BI Data Analyst path. Check our list of the best Power BI courses and certifications when you want a structured course. If you also learn SQL or Python later, our guide to machine learning for business analysts shows a next step.





