How Power BI Can Change Your (Data) Life [Part 3]

Learning Power BI will change your (data) life as you can update reports and get insights with just a few clicks. Part 3 of this series recommends where you can start your Power BI journey given your job profile and needs. As the different Power BI elements address different challenges at each phase of your data analytics workflow, you don’t need to learn Power BI end-to-end to benefit!

Read More

How Power BI Can Change Your (Data) Life [Part 2.3]

Learning Power BI will change your (data) life as you can update reports and get insights with just a few clicks. Part 2.3 of this series finds out how Power BI’s and Excel’s visualisations make your reports interactive and fun to explore. Power BI goes one step further in sharing by making your reports available online and via a mobile app.

Read More

How Power BI Can Change Your (Data) Life [Part 2.2]

Learning Power BI will change your (data) life as you can update reports and get insights with just a few clicks. Part 2.2 of this series finds out how Power BI’s and Excel’s Power Pivot data model and DAX greatly improves your reporting and analytics workflow by making calculations fast, flexibly, and reliable.

Read More

How Power BI Can Change Your (Data) Life [Part 2.1]

Learning Power BI will change your (data) life as you can update reports and get insights with just a few clicks. Part 2.1 of this series finds out how Power BI’s and Excel’s Power Query greatly improves your reporting and analytics workflow by automating your steps.

Read More

How Power BI Can Change Your (Data) Life [Part 1]

Learning Power BI will change your (data) life as you can update reports and get insights with just a few clicks. Part 1 of this series deconstructs your typical data analytics workflow using Excel into 3 key phases and explores the challenges of each phase.

Read More

[5/5] Power Pivot's Data Model and DAX formula in a nutshell (The Power Series Way, Part 2)

How to:

  1. Create relationships between tables.

  2. Write formulas exclusive to Power Pivot that simplifies the formula-writing process for L12M, L12M_Avg, YTD and FTYD figures.  

[30 min read]

Read More

[1/5] How to set up a reference date table and summarise figures to get absolute and Year-On-Year (YOY) monthly figures

How to:

  1. Get dates into a readable format that allows for easy referencing further on in the set-up process.     

  2. Set-up a date table that automates the updating of time period parameters.   

  3. Sum up figures based on specific criteria (i.e. time period / product category).

  4. Manage situations where an error value is returned.

[9 min read]

Read More