Course Description:

Data is all around us. Visualisation is the first step in receiving value from your data and enabling Enterprise Performance Management (EPM) within the organisation. Understanding how to conduct descriptive analytics, however, is the first significant step towards using business intelligence and enabling enhanced management decision-making.

KPMG Learning Academy (Malta) has teamed up with KPMG Academy Cyprus to co-host this webinar, where the two trainers who will deliver the webinar are passionate about analytics and possess solid experience in the field, as well as considerable qualifications. This is a-not to be missed-webinar for those who deal with data analytics and seek to make a difference in their profession. The webinar aims to reveal the power of data and its necessity in today’s business world.

This webinar will provide the basic knowledge of tools and concepts necessary to develop descriptive analytics skills, in order to get better insight from data within organisations. By attending the webinar, participants will also improve their management decision-making skills and support the development of enterprise performance management in the organization.

IMPORTANT NOTICE-TRAINING’S REQUIREMENTS:

During the webinar BI concepts will be demonstrated through well-known technologies like PowerBI, SAS VA and AWS QuickSight. Therefore, participants are required to arrange the Power BI desktop application to be installed on their computer prior to the training’s date. Participants can download the latest version of Power BI desktop application in English for free here. In addition, participants are required to download the data files that will be sent to them via email in advance, for the training’s purposes.

Target Audience:

The session is aimed for company owners and managers, executives tasked with data analytics within organisations, chief executive officers, chief operating officers, chief commercial officers and other related professionals.

Learning Outcomes:

By the end of the session, participants will:

• Identify important KPIs and determine how to find necessary data related to those indicators
• Acknowledge the difference between look up and data tables
• Describe what hierarchies are and create relationships between datasets.
• Explain how to improve decision making, compare and contrast results and reach better, well informed decisions
• Utilize and visualize KPI targets
• Implement descriptive analytics for their organisations, in order to improve management decision- making
• Explain the subject of management reporting and descriptive analytics
• Verify changes in measured metrics
• Appreciate the importance of descriptive analytics
• Intend to participate in strategic discussions concerning management decision making.

Agenda:

1. Descriptive analytics and Enterprise Performance Management (1 hr)

• Where is descriptive analytics placed on the journey towards becoming data- driven
• Explanation of the term descriptive analytics and benefits
• What is EPM and why is it important?
• What tools can we use?

2. Data quality and preparation (1 hr)

• What is data quality?
• Selecting data for KPI visualization
• Preparing data for visualisation tools
• Lookup tables vs Data tables
• Why do we need lookup tables?
• Practical demonstration

3. Getting started (1 hr)

• Overview of the tool
• Connecting to a data file
• Navigating through your tool
• Creating relationships between tables
• Creating charts
• Drilling down and up in hierarchies
• Adding colours
• Adding calculated columns
• Adding labels and formatting

4. KPIs, time series, aggregation and filters (1hr & 30 min)

• Setting targets and KPI monitoring
• Working with time series
• Understanding aggregation and granularity
• Creating an area chart & learning about highlighting
• Filters and slicers

5. Maps, scatterplots and interactive BI (Business Intelligence) reports (1hr & 30 min)

• Calculated columns vs calculated measures
• Creating a scatter plot
• Combining charts, filters and slicers
• Adding a donut chart

6. Using custom visuals & Cloud (30 min)

• Installing a custom visual for Power BI
• Power BI Pro functionality and Cloud functionality demo

7. Beyond descriptive analytics (30 min)

• Predictive analytics in Enterprise Performance Management and beyond.

Trainers:

Vanja Radivojevic, Senior Manager, Management Consulting, KPMG in Cyprus

Vanja is a Senior Manager leading the Data & Analytics service line, IT Advisory of KPMG in Cyprus. She holds a BBA (Finance and Investments) from Baruch College, City University of New York and an MSc in Business Intelligence and Data Analytics from CIIM. Since she joined KPMG in 2018, Vanja participated, amongst other, in Data Analytics projects in the finance, insurance, aviation, consumer products, oil & gas, shipping industries etc. She is responsible for delivering advanced analytics and business intelligence solutions to companies in Cyprus, the CIS region and Africa.

Vanja has extensive prior experience in the field of finance and investments, having worked in Private Wealth Management with Goldman Sachs & Co. in New York. She also possesses broad experience in structuring and originating debt instruments in the emerging markets, as well as in sales and marketing of financial products in Europe and New York. Her prior experience also includes production management liaising with counterparts in Asia and the Middle East to ensure quality delivery and execution of products.

Antreas Antoniou, Assistant Manager, Management Consulting, KPMG in Cyprus

Antreas is an Assistant Manager in the Data & Analytics Group, IT Advisory of KPMG in Cyprus. He holds a BBA (Business Administration, Management Science Specialisation) from the University of Cyprus. Antreas has been with KPMG in Cyprus since 2020 and has been involved, among others, in Data Analytics projects in the finance, insurance, consumer products and retail industries. He is responsible for providing advanced analytics and business intelligence solutions to companies in Cyprus.

Antreas possesses prior experience in the field of insurance, thus has an understanding of all relevant data sources, potential sources of error or bias and important KPIs. More specifically, Antreas’ experience focused in business intelligence, predictive algorithms, segmentation analysis, customer lifetime value analysis and process optimisation.

Discover more courses from our KPMG Learning Suites.

Is your employer paying for your CPE seminars? Contact us on kla@kpmg.com.mt to discuss how the employer can benefit from our offers.

Terms and conditions.