Excel PowerPivot
Data Modelling

Intensiv-Seminar

Startseite > Seminarübersicht > Business Intelligence mit Excel > Excel PowerPivot Data Modelling

DEU ENG

Dynamic data models for time-saving reporting

Linking and analysing data sources from different systems
Implementing Business Intelligence with DAX functions
Graphically presenting KPIs in dynamic management reports

Dieses Seminar ist als 0-tägiges Präsenz-Seminar buchbar.

Do you use dynamic data models for time-saving reporting? Get the know-how to do this in our 2-day Excel PowerPivot intensive seminar. Use PowerPivot to connect data from disparate systems for the first time. The focus of the seminar is the linking of database, text and Excel files to dynamic data models and management reports. Using DAX measures (Data Expression Formulas) and KPI (Key Performance Indicators), you will develop dynamic data models for powerful controlling.

Exellent

4,7 / 5

Die Schulung ist super um ein Gespür für das Tool Excel zu erhalten. Die Referentin geht auf individuelle Fragen und Probleme ein und versucht gemeinsam eine Lösung zu finden

MEHR ERFAHREN

Excel PowerPivot Data Modelling als Firmenseminar anfragen

Who’ll be taking part in the seminar?

You often work with complex data evaluations which you create on the basis of various data sources. Based on your already well-founded Excel know-how, you now want to create data models, which go far beyond the known possibilities of pivot tables. The new working techniques and calculation functions allow you to condense large amounts of data and to use KPIs to create powerful reports.

By the end of the seminar, you will be able to

merge different types of data in a report and evaluation;
apply DAX functions of corporate data;
use DAX functions to visualise the current status by means of KPIs;
fade out data that is not required from data models and integrate additional data in the form of linked Excel spreadsheets;
analyse data stocks from several spreadsheets with the click of a mouse;
integrate advanced calculations on the basis of the PowerPivot's own calculation functions.

Seminar schedule
Access to the data sources
- Creating a connection to the data source
- Access to database files, Excel or CSV files
- Linked Excel spreadsheets as an alternative to reference functions
- Selection of relevant data fields and data sets
- Updating of the data connections
Building a data model step by step
- Linking various data tables with relationships
- Adding calculations with DAX functions
- Applying frequently used DAX functions in the data model
- Creating additional tables and adding these to the model
- Setting up the chart view of the model
- Making efficient use of the user interface in the PowerPivot window
Creating and setting up the date table as the most important spreadsheet
- Creating a date table with DAX functions, Excel standard tools or PowerQuery
- Applying the most important date functions for the monthly and annual evaluation
- Identifying a spreadsheet in the PowerPivot data model as a date table
- Organising day and month texts in the calendar sequence
- Creating a relationship between the data table and the data model
Improving the PowerPivot data model
- Designing the data model for the user in a clear fashion
- Setting up hierarchies
- Collating data tables
- Fading out unnecessary measures, columns, or tables
- The use of explicit and mutually constructive measures
- Creation of measures with absolute and percentage results
Analysis and data evaluation with PivotTable and PivotChart
- Creating various PivotTable reports
- Creation of Pivot Charts
- Conversion of a PivotTable report into cube functions
- Access to the data model with cube functions
- Creating a dashboard with data interface and time axis
- Set-up and visualisation of KPIs

Diese Seminare könnten Sie auch interessieren

Jetzt anmelden

Alle Informationen zum Excel PowerPivot Data Modelling Kurs finden Sie hier im Überblick als PDF
Download Broschüre Cover of the information brochure: Excel PowerPivot Data Modelling

Cover of the information brochure: Excel PowerPivot Data Modelling

Hilfe bei der Auswahl. Sie wissen nicht, welche Schulung für Sie die richtige ist? Rufen Sie uns an unter der kostenfreien Nummer 0800 – 4200 500 oder schreiben Sie uns eine E-Mail an kundenservice@confex.de - wir unterstützen Sie gerne, das optimale Seminar für Ihren Bedarf zu finden.
Rückrufwunsch angeben

Unsere Treueprämie. Viele unserer Kundinnen und Kunden kommen wieder, weil sie die Vielfalt und die Aktualität unseres Kursangebotes schätzen. Darüber freuen wir uns sehr und schenken jedem Teilnehmenden nach der Schulung als Dankeschön einen Gutschein im Wert von 100 Euro.

Unser Schulungs-Team. Nur zusammen sind wir erfolgreich. Dank der unterschiedlichsten beruflichen Hintergründe unserer Referent*innen können wir auf Ihre individuellen Anforderungen eingehen. Werfen Sie doch einen Blick auf unser Team an Dozentinnen und Dozenten.
Alle Trainer*innen

Excel PowerPivot
Data Modelling

Dynamic data models for time-saving reporting

Registration

Who’ll be taking part in the seminar?

By the end of the seminar, you will be able to

Seminar schedule

Diese Seminare könnten Sie auch interessieren

Cookie – Einstellungen

Excel PowerPivotData Modelling

Dynamic data models for time-saving reporting

Registration

Who’ll be taking part in the seminar?

By the end of the seminar, you will be able to

Seminar schedule

Diese Seminare könnten Sie auch interessieren

Cookie – Einstellungen

Excel PowerPivot
Data Modelling