Course Outline
Introduction
- new Excel capabilities in Business Intelligence
- what is Power Query
- what is PowerPivot
- what is Power View
- what is Power Map
- what is Power Inquire
- what is Solver
- installation of add-ins
Power Query Add-in
- import and transformation of file source data
- import and transformation of web source data
Introduction to PowerPivot and data work
- overview of slicer controls
- data filtering
- cell formatting
- changing data type
- adapting the data sheet
Downloading data from various sources to PowerPivot
- downloading data from databases
- downloading data from MS Excel
- downloading data from TXT files
- Copy-Paste data download
- creating linked tables
Creating pivot tables using PowerPivot
- creating a pivot table
- reorganizing a pivot table
- adding calculated measures to the pivot table
- changing the type of pivot table functions
Creating pivot charts using PowerPivot
- creating a pivot chart
- reorganizing a pivot chart
Refreshing data in the PowerPivot sheet
Creating and managing relationships in PowerPivot
Introduction to DAX (Data Analysis Expressions)
- overview of DAX
- types of functions
- operators
- calculated columns and measures
- error handling
Power View Sheets
tables:
- sorting
- filtering
- charts
- maps
Solver Add-in
- problems that can be solved thanks to the add-in
- overview of tool configuration
- optimization examples
Inquire Add-in
- overview of the add-in concept
- project of the sheet overview
Requirements
Knowledge of the Windows system and basic Microsoft Excel usage.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 2600 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (3)
Abhi has excellent knowledge of Alteryx and he explained things very clearly. He understood our goals and created bespoke demo datasets that were relevant to our organisation, which was very impressive. The training was well-structured and delivered at a good pace, with time for questions.
Samuel Taylor - Manchester Metropolitan University
Course - Alteryx for Data Analysis
Deepthi was super attuned to my needs, she could tell when to add layers of complexity and when to hold back and take a more structured approach. Deepthi truly worked at my pace and ensured I was able to use the new functions /tools myself by first showing then letting me recreate the items myself which really helped embed the training. I could not be happier with the results of this training and with the level of expertise of Deepthi!
Deepthi - Invest Northern Ireland
Course - IBM Cognos Analytics
Clear explanations with good examples so i could relate to my own line of work.
