DAX analytics and dashboard results in Excel (60545064) - Recorded webinar

This recorded webinar will show you how to create a report which brings together knowledge learnt in the following CPA Australia recorded webinars:       

• An Introduction to big data and business analytics    
• Business modelling using big data       

The webinar will outline how to organise the report and manage new data. Using practical exercise for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals. 

Key topics:            

• Review source data provided and create three primary tables to form the report   
• Join the tables and create a calculated measure   
• Add a Power Map and learn to get data into a 2D and 3D map   
• Create three PowerPivot reports to feed the dashboard

As part of this webinar you will  receive:

• Downloadable worksheets with practical tasks to embed the knowledge 
• A learning manual with step by step instructions 

This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.

Course updated: 2020

• Apply your learning by working through complex DAX examples  
• Create a report structure, manage tables and incorporate new data into the report from an external source  
• Create and compare performance matrices and summarise them into a dashboard style report  
• Generate global location-based results to identify trends and patterns on a 3D scale with Power Map