Page 62 - Finanancial Management_2022

LEARNING RESOURCES
industry presented in the sidebar
“Interactive Visualisation for Assessment
of Distribution and Correlation” are
Data Visualization Certificate necessary for these tasks but should not
Learn fundamental types of visualisation techniques and be used in end-user reporting. High
explore a sampling of the most common reporting tools for analytical skills are needed to derive
producing meaningful visualisations. information from a parallel coordinates
plot, placing an unnecessary burden on
Find this course in the AICPA store and in the CGMA store. the decision-maker. This task should be
COURSE performed by trained management
accountants or data scientists, and the
understanding gained should be
Microsoft Power BI: Power BI Series transformed to a simpler format so that
This nine-part self-study online series will help you develop the decision-maker can act on it (eg, if Y
the skills necessary to use Microsoft Power BI tools, which [order intake] predicts X [revenue], then
will allow you to perform enhanced data analysis. reporting should focus on Y, to increase
the manager’s ability to take action by
COURSE indicating problems very early on).

Step 5: Use user-friendly design and
Power BI — Use PBI Desktop to Create Reports and appropriate visualisation types for
Dashboards interactive dashboards
Power BI Desktop is a new standalone tool that adds The optimal tool for managerial
visualisation to your data. This webcast focuses on learning decision-making is a dashboard. One
the Power BI Desktop interface, connecting to data sources, definition of a dashboard — by authors
and creating the visualisations.
Ogan M. Yigitbasioglu and Oana
VIDEO Velcu-Laitinen — is a “visual and
interactive performance management
tool that displays on a single screen the
Power BI — Introduction to MS Power BI Tools most important information needed to
This webcast provides an overview of the various Microsoft achieve one or several individual and/or
Power BI tools and should be your first step in learning the organisational goals, allowing the user
complete set of Power BI tools. By the end of this webcast to identify, explore, and communicate
you will have a thorough understanding of what each tool can problem areas that need corrective
accomplish. action”. Thus, a dashboard should only
feature standard visuals known to
VIDEO
management such as bar, column,
waterfall, or line charts, which will
clearly emphasise deviations from the
plan that indicate a need for course-
correction. Management can only take
sources should be carefully chosen with highly complex, or for an initial appropriate action if deviations stand
respect to their potential to contribute to analysis of the data with a limited out early on.
the company’s strategic goals. For example, number of variables, visual analytics Visual choices should follow general
while for stores in a shopping mall low can be used, as they present more design recommendations, such as in
customer flow simply follows good intuitive ways to understand large Hichert and Faisst’s International Business
weather, financial service providers need amounts of data. Their inherent goal is Communication Standards, but also
to draw up customer profiles allowing to present the whole dataset within one represent the data structure and allow for
them to assess and predict a customer’s frame to uncover insights that might adjustments by users (such as filtering,
potential for default by combining otherwise be missed. panning, and drill-through). In addition to
personal information (eg, credit records bar, column, line, waterfall, and scatterplot
and information on their income and fixed Step 4: Integrate new insights charts, visualisation types such as the
costs) and general market information (eg, into reporting to enhance sunburst, which is a development of a pie
information on industries, interest rates). decision-making chart, and the choropleth presented in the
Steps 2 and 3 identify early-warning sidebar “Useful Interactive Visualisation in
Step 3: Identify new insights and indicators or new insights in the a Dashboard” are helpful in a dashboard
correlations from big data company’s business logic. Visuals such as display. They transmit information in an
Earlier identification of indicators a parallel coordinates plot that can present understandable format while condensing
gives management more decision- multiple attributes in one chart or the heat a lot of data either in a hierarchy or by
making leeway. When algorithms are map using example data from the wine location.

22 I FM MAGAZINE I April 2022