Create a Data Model. Manage the Data Model. Create simple calculations.
Content:
Definitions
Data Model, Measures and Dimensions
Solutions for large volumes
The issue
OLAP, BI, Data cubes?
The PowerPivot approach
Benefits
Limitations
Controversy
First use
The PowerPivot tab and window
Importing data: overview of the different sources available.
Import from a relational database.
Create an analysis quickly
Go further in the analysis
Principles of aggregation
Subtotals and grand totals
Filter the displayed data
Simple calculations
Basic layout
Manipulations of the "Data Model"
- Full program on the web page
- Training in French: 07.08.2020, 14.09.2020
- Training in English: 17.09.2020,28.09.2020
- Price: 315 EUR
- Prerequisite: Very good knowledge of Excel.
- A certificate of presence can be issued upon request
of the participant at the end of the training.
Béatrice Simon
Lifelong Learning
65
Avenue de la Gare
1611 Luxembourg
Luxembourg
find out about all the networking events and trainings tailored for you!
find out about all the networking events and trainings tailored for you!
With you consent, we collect data such as your advertising ID and your IP address.
They allow us to provide our services 100% free of charge and to continue improving them so that we provide you with relevant content.
For more information, please refer to our data privacy policy
To check your Favorites, connect to your account!
To check your Favorites, connect to your account!
Sign in to get access to your preferences!
Sign in to follow this category!
Sign in to follow this Good Address!
Sign in to follow this business!
Yes I want to delete it
