Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Entry
- new possibilities Excelaw Business Intelligence
- what is Power Query
- what is PowerPivot
- what is Power View
- what is Power Map
- what is Power Inquire
- what is solver
- installing add-ons
Power Query Add-in
- import and transformation of file sources
- import and transformation of Internet sources
Introduction to PowerPivot and working with data
- overview of slicer controls
- data filtering
- cell formatting
- changing data type
- datasheet customization
Downloading data from various sources into PowerPivot
- downloading data from databases
- downloading data from MS Excel
- downloading data from TXT files
- downloading Copy-Paste data
- creating linked tables
Create pivot tables using PowerPivot
- creating a pivot table
- reorganizing the pivot table
- adding calculated measures to a pivot table
- changing the type of pivot table functions
Create pivot charts using PowerPivot
- creating a pivot chart
- reorganizing a pivot chart
Refreshing data in a PowerPivot worksheet
Creating and managing relationships in PowerPivot
Introduction to DAX expressions (Data Analysis Expressions)
- DAX overview
- types of functions
- operators
- calculated columns and measures
- Error handling
Power View Sheets
tabels:
- sorting
- filtration
- charts
- maps
Solver Add-in
- problems that can be solved with an add-on
- tool configuration overview
- optimization examples
Inquire add-on
- discussion of the concept of the add-on
- sheet design review
Requirements
Knowledge of Windows and knowledge of the basics of the program Microsoft Excel.
14 Hours
Testimonials (3)
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
The instructor's ability to explain clearly and their robust knowledge
JOSE FERNANDO MELO - MCGRAW-HILL INTERAMERICANA
Course - Alteryx Advanced
Machine Translated
The practical exercises, the course order, and the explanations were clear.
Cristina Morales - SOFI de Chihuahua SA de CV
Course - Alteryx for Data Analysis
Machine Translated
