Data-based problem solving with Power BI & storytelling in finance

The finance function in transition: data analytics & performance measurement

• The main finance processes and their significance.
• Measurement dimensions such as quality, time and costs.
• Key performance indicator (KPI) systems and the advantages and disadvantages of company management with KPIs.
• The different reporting types and rhythms.
• Management reporting: structure and information.
• The effective report: attachments, graphics, tables, diagrams.

Structuring complex problems

• The different types of problems.
• Hypothesis-based working method: Definition, verification, measurement criteria and interpretation of results.
• Using SCQ (Situation, Complication, Question) and SOGI (Sector, Organization, Group, Individual) to structure problems and communicate solutions clearly.
• Completeness and freedom from overlaps in problem structuring ("MECE" principle).
• Development of analysis grids as a tool for analyzing, synthesizing and solving problems.

Big Data Analytics with Microsoft Power BI (basic training, no prior knowledge required)

• Overview of Microsoft Office 365 tools including their integration options.
• Introduction to Power Query.
• Automated data queries from tables and folders.
• Connection of different data sources and formats.
• Power Query Basics: Data connection and automated data preparation and cleansing.
• Basics of the DAX programming language.
• Creation of table relationships (incl. date tables).
• Data visualization and reporting design.
• Publish reports - Set up user groups.

Financial storytelling - communicating results effectively and with a suitable story

• Effective communication according to the pyramid principle.
• Specify vs. justify.
• Development of a structured decision template and presentation.
• Meaningful key statements.
• The background to storytelling.
• Storyboards for presentations.