MS Office Excel Training - PowerPivot (Power BI) in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.
850.-/d
ID : 1074
Goal : This training allows you to take control of the PowerPivot add-in of Microsoft Excel and is part of a comprehensive approach ranging from data modeling to building dashboards using more complex dynamic PivotTables and interactive charts. The current problematic limitations of the tool will also be known by the trainees as a result of the training. This training is a prerequisite for the DAX functions course.
Audience : Anyone who already has the master PivotTables and wishing to discover what PowerPivot can possibly bring in addition to the traditional tools to accelerate the controlling. This traning is also dedicated to people who have reached the limits of the VLOOKUP, XLOOKUP or INDEX/MATCH functions of Microsoft Excel.
Prerequisites : Having followed the training on the pivot tables and master the fundamental concepts of the modeling of relational databases are the prerquisites.
Goals :
- Introduction
- PowerPivot Architecture (xVelocity Engine: BISM Tabular)
- Benefits of PowerPivot (table size, data compression, links between tables from different sources, DAX formulas, images, SearchV uselessness, formula mode,
- Disadvantages of PowerPivot (up-and-down accounting, functionality not available in PowerPivot TCD, readability, documentation)
- Recommended Technical Configuration
- Converting * .xlsx files to *.xlsb to improve performance
- Activating / Installing the PowerPivot Add-in
- Converting an Excel List to an Excel Table and add a table to the Data Model
- Discovering the Interface
- Aligning PowerPivot tables-based slicers
- Create a PVT from a PowerPivot table
- Load data from external sources (XL, Access, CSV, Webservice, SQL Server, OpenData, SharePoint depending on the installation of the training room)
- Test reactivity to large masses of data
- Associate one or more tables with the link manager
- Observer l'effet du renommage des colonnes liées sur les liaisons elles-mêmes
- Requêtes SQL/T-SLQ ou procédures stockées en ligne lors de connexions à des bases de données
- Creating tables in the data model by copying / pasting and adding data by copying / pasting
- Rename tables and table columns
- Creating a date table for grouping
- Rename sources and redefine sources
- ...
Pedagogical method : This training is 90% practice oriented with predefined exemples and exercices choosed by the trainer.
Suggested duration for presentiel training (days) : 2
Suggested duration for on-line training (days) : 2.4
Daily price in face-to-face : 850 CHF
Daily price in remote : 408 CHF
Daily price in remote for students : contact us (only if student card!)
Daily price in remote (with recording) : 4250 CHF
Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).
Tags : ms excel powerpivot training, powerpivot course, power pivot course, powerpivot training, powerpivot, dax, mdx, power bi, pivot tables, dashboards, control board, business scorecards, sharepoint, office 365, Business Intelligence.