This recorded webinar will show you how to structure data to create reports that feed into a dashboard using Excel.
Overview
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
Objectives
- 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
Audience
Professionals working in SME or Corporate entities in specialist or analyst roles, and mid-level career roles working in job functions such as external reporting, financial control and management accounting.