Changing data types, for example, a number to a currency value will help report readers to quickly focus on the key points of interest. So, it’s worth spending a little time on data types.

DAX empowers us to ask incisive and powerful questions of data. You define your question once and you can then slice your data by as many different fields as you want. An example would be time-based calculations.

Calculated tables allow you exact data of interest from several tables to create a new table from which you can answer questions and in turn, generate reports you couldn’t do any other way.   

There will be occasions when you will want to analyse data over time, for example by year, quarters, months and days. Thankfully using Power BI this is relatively easy as fields can be automatically generated.

There may be occasions when you have been working within Excel and you would like to copy the worksheet to create a new table in Power BI. This video will show you how you can manually type in the data or paste data into a new Power BI table.

The workshop is an important opportunity for you to confirm what you do or don’t understand. Mistakes are often a better learning experience than getting everything right the first time so if you do make mistakes no one needs to know. On the positive side, you are unlikely to repeat your error. Good luck.