Date: 20 March 2019 | Venue: IDR Training Center
Without data, you’re just another person with an opinion
W. Edwards Deming
No matter if you work at a large corporation, a small independent business, or a non-profit, if you have a reasonably functioning finance office, then you will probably be generating (at least) quarterly reports.
However, while generating these reports is standard, actually comprehending these reports is a different matter. This is why financial dashboards matter. Financial dashboards are reports that illustrate key pieces of data, often in a graphical format. They open the door for a more collaborative environment in which easy-to-interpret data is more readily shared and can be accessed by anyone with permission to view the dashboard.
Why Financial Dashboards Matter?
- Dashboards encourage storytelling
- Dashboards ensure shared financial comprehension and engagement
- Dashboards define measures of success
The key to making sound decisions with the aid of financial reports is having clear, accurate, and up-to-date information. On top of that, financial dashboards come in handy as well.
With financial dashboards, the management is presented with information that is needed for the practical implementation of strategies. It gives you a complete picture of your business promoting transparency and profitability.
*click on the session below to expand the details
- Overview of training aim, objectives and agenda
- What is a dashboard?
- Purpose and benefits of dashboards
- Understanding dashboard design principles
- Layout, colour and display
- Common mistakes when building dashboards
- Understanding your data
- Organising data
- Tools and tricks to clean data before using it to build a report or dashboard
- Choosing the right data visualisation to communicate information effectively
- Displaying trends with charts
- When to use a secondary axis
- Combining two chart types
- Creating sparklines – line, column and win/loss
- Sparkline formatting and options
- Sparkline tips and tricks
- Applying conditional formatting
- Data bars, colour scales and icon sets
- Conditional formatting options
- Naming cells and ranges
- Creating Excel tables
- Applying table names
- Using structured references in formula
- Refreshing tables with new data
- Understanding Slicers
- Creating and formatting a slicer
- Using Slicers as Form Control
- Create Dashboard that incorporates key elements of financial health
- Recommending strategies to improve the financial health of the organization
At the end of the programme, participants will be able to:
- Contruct, customised financial dashboard using MS Excel
- Visualise and present financial information in more meaningful and easily understandable manner
- Advise the top management more professionally in daily
Who Should Attend
- Financial Controllers
- Finance Managers
- Accounts Supervisors
- Business Owners
- Sales & Business Development Managers
- Dashboard Project
Abdul Qadir Osman Aros is a Chartered Accountant with over 20 years of industry experience in auditing, accounting, consulting and strategy. Among the key positions he has held are Managing Director, Chief Financial Officer and Chief Operations Officer in consulting firm, government-linked companies, and public listed companies. He graduated in 1997 from Australia with a Degree in Accountancy. He member of Malaysian Institute of Accountants (MIA), Chartered Institute of Management Accountants (CIMA) and Chartered Global Management Accountants (CGMA).
He holds an MBA in Strategic Management from Universiti Teknologi Malaysia where he received the Best Student Award. He was trained at the Royal Military College where he learned the values of teamwork, leadership, mental fitness and personal discipline. His areas of expertise are in training and coaching, strategy development, financial management and business turnaround management. His aspiration is to be a business turnaround specialist.