Power BI – Reactor – Last Year’s Sales

This post is to support my virtual session at London Microsoft Reactor on 1st Feb 2021. The session is an introduction to Power BI using sales data for 2020 from an imaginary gift shops.

YouTube Recording

Resources

The Excel file used as the data can be found at
https://hatfullofdata.blog/wp-content/uploads/2021/01/Sales.xlsx

The back ground image used in the demo can be found at
https://hatfullofdata.blog/wp-content/uploads/2021/01/Gift-Background.png

The page from SQLBI used to create the calendar table can be found at
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Useful Resources Mentioned in the Session

Create a calendar in Power Query by Radacad.
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns

Guy in a Cube
https://www.youtube.com/channel/UCFp1vaKzpfvoGai0vE5VJ0w

Chris Hamill’s Backgrounds
https://alluringbi.com/2020/05/05/themeable-backgrounds-for-power-bi/

Next Session

The next session will be 22nd Feb 2021, when we will look at UK population data. Closer to the date you’ll be able to find joining instructions at https://www.meetup.com/Microsoft-Reactor-London/