Webinar Visual Analytics & Dashboards (Excel)
i2VSA: Creating actionable information and insights
- 4 dagen
- Datum en locatie
- 23, 25, 27, 30 november 2020 - Online
- 13:30 - 17:30, 13:30 - 17:30, 13:30 - 17:30, 13:30 - 17:30
- € 950,00 (leden) / € 1.100,00 (niet-leden)
- Performance Management, Finance Operations & Reporting, Online learning
- Bestemd voor
- Accountants in business, Overheidsaccountants, Overige financieel professionals, Controllers, Auditor
The course is in English, the Excel parts are based on the English version of Excel.
Als RC betaalt u het ledentarief
Finance professionals are dealing with increasing amounts of data and a growing demand for analytics to provide fresh insights and greater clarity for decision making. This online course teaches participants how to create and use advanced visual techniques to generate new insights, support better analysis and enable clearer decision making with better reports and 'one page/ one screen' dashboards.
In addition to its role in improving 'traditional' descriptive analytics, this course will also introduce the use of data visualisation as part of more advanced data analytics/ data science.
Participants successfully completing the optional post course project in dashboard design will be awarded an internationally recognised Certificate of Competency issued by the Institute of Business Analytics.
You will learn to:
prediction /regression models
Course outline The course is conducted in a highly participative workshop style, with practical group discussion and online break-out sessions.
The course is structured as follows:
Pre-course learning: Understanding the challenges of current reporting and information and what needs to be improved
Session 1: Actionable information and how to create it. How the mind and eye process information and how to be effective this should drive our choice of techniques, layout of charts, use of colour etc. Common techniques, problems and better alternatives. Data transformation and finding the right KPIs/ drivers. More advanced visual techniques for understanding, focus, insights, data exploration, and how to create them in Excel.
Session 2: Revision and practice with the new techniques. Extending the idea of data visualisation to dashboards on a page/screen. Types of dashboards and why they are useful, how to structure and create them.
Session 3: Dashboard design exercise in breakout groups Í to apply what has been learnt so far. Key Excel techniques to support dashboard design and visualisation.
Session 4: Introducing and delivering successful visualisation and more advanced dashboards into your organization. How to complete the optional post course project. Introduction to more advanced use of visualisation, for data exploration and simple predictive models. Showcase of past participants projects solving real business problems and transforming decision making (shared with their permission). Final Q&A and wrap up.
In between sessions: Participants will be given materials to practice building the new techniques. If participants require support/ demonstration this will be built in at the end of the online sessions. This enables participants to work on the Êhands onË at their own pace and get support if/ when they need it. Participants can also ask for help in between sessions or after the course.
Optional post course project - to apply the ideas learnt to build a dashboard for the participantÉs organisation. Successful completion will earn a certificate of competency in Visual Analytics and Dashboard design from the Institute of Business Analytics.
This course is for accounting, finance and other business professionals who want to:
De cursus vindt plaats in E-learning in Online