POWER BI – The basics
  • Collaboration and relationship management - Social awareness and social relationship - Nonverbal language - Mentoring & coaching - Ability to challenge results -Influencing others – Assertiveness - Raising alert.
  • Data analytics, statistics, data analysis - Fundamental knowledge of statistics, data analysis (including correlation, regression and categorizing) and forecasting methods - Growth (decline) - Index calculations.
  • Financial Communication - Financial communication: organizing a shareholder meeting, a roadshow, writing a financial communication document, media strategy
  • Modelling, simulation, scenarios - Know business modeling, simulation, optimization, what-if analysis

Target audience

- Auditeurs internes
- Consolidation and Accounting Directors
- Financial managers
- Management controllers

2 day

New training

Prerequisites

it is recommended an intermediate to expert level in Excel. Please bring your laptop with Power BI Desktop installed.

Objectives

– Discover Microsoft’s new data visualization tools and the concept of multidimensional analysis
– Learn to use Power BI (connecting, formatting the information, creating report, etc.)
– Take advantage of the power of data visualization by creating new types of reports
– Know how to present relevant analysis and synthesis

Detailed content

> Introduction

– Data revolution and controlling
– What is Business Intelligence (BI)? What are the tools and their purpose?
– Interest of Power BI
– Vocabulary: dimension, hierarchy, fact table, measures, granularity

> PowerBi

– Presentation of the different modules
– Data acquisition
– Link with Excel and Power Pivot

> Data modeling: the key

– Concevoir et identifier les sources de données
– Importer et contrôler ses données
– Création et gestion du modèle de données : affichage en mode diagramme
– Relations et hiérarchies

> Building visual and interactive reports

– Reports building
– Displaying data
– Using visualization for better decision-making
– Importing pictures, adding filters or KPIs

Why should you attend?

Welcome to the new data age! Data revolution is coming to companies at remarkable speed and volume. Understanding data analytics is an essential skill for the Finance function. Acting as a « Business Partner » now means to better understand how to use data and analytics to help make better predictions or identify the cause of certain events.
This training will walk you through discovering Microsoft « self-service » Data visualization tool – Power BI and using it with a practical approach to help you manipulate large amounts of data and communicate your findings.

Training methods and assessment

A lively and concrete training program. Mix of fundamental skills and illustrations with many examples drawn from the practical experience of the trainer.
Assessment questionnaire.
A training certificate is delivered at the end of the session.

The trainer is available by e-mail to answer any follow-up questions participants may have.

Price

1630 € Excl. VAT –  1956 € Incl. VAT

Médias

Témoignages

Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.

Jonathan C.
Entreprise
Formation