Power BI skills for analysts: five areas to practise
Build a report you can explain and check. Explore five Power BI skill areas with a tiny exercise covering filters, shares and missing amounts.
Knowledge base / Power BI
Power BI: reports, data model and DAX
Articles on Power BI: Power Query, the data model, DAX and report design. Short entries are in preparation.
4 articles
Power BI combines several layers of work: preparing data in Power Query, a model with relationships between tables, DAX measures and a report that someone should understand without your commentary. Each layer has its own pitfalls, and a mistake in the model can look like a mistake in a chart.
Short entries for this section are still in preparation. Below you will find articles on the Power BI skills worth practising, how Power Query works and how to design a dashboard. If you already know Excel, a lot carries over directly: tables, data types and filtering. The new parts are the data model and filter context in DAX.
Articles on this topic
Short entries for this section are still in preparation. In the meantime, these articles cover the most important parts of the work.
How Power Query works: from a raw file to a repeatable process
Power Query remembers how to prepare data. I explain what it repeats, how to verify the result and why a new source file can still require a change to the rules.
Designing a data dashboard that helps someone make a decision
An attractive dashboard can still suggest the wrong conclusion. I use delivery data to connect the reader's question, correct measures and a clear layout with a practical usability test.
Tableau or Power BI? How to choose as a beginner
Start with your goal and audience. Understand free editions, local work and publication, then compare the tools through one consistent exercise.
