Course Outline
Introduction
- New Excel capabilities in Business Intelligence
- What is Power Query?
- What is Power Pivot?
- What is Power View?
- What is Power Map?
- What is Power Query?
- What is Solver?
- Installing add-ins
Power Query Add-in
- Importing and transforming file-based data sources
- Importing and transforming web-based data sources
Introduction to Power Pivot and Data Handling
- Overview of slicer controls
- Data filtering
- Cell formatting
- Changing data types
- Customizing data sheets
Importing Data from Various Sources into Power Pivot
- Importing data from databases
- Importing data from Microsoft Excel
- Importing data from TXT files
- Importing data via Copy-Paste
- Creating linked tables
Creating Pivot Tables Using Power Pivot
- Creating a pivot table
- Reorganizing pivot tables
- Adding calculated measures to pivot tables
- Changing pivot table function types
Creating Pivot Charts Using Power Pivot
- Creating a pivot chart
- Reorganizing pivot charts
Refreshing Data in Power Pivot Sheets
Creating and Managing Relationships in Power Pivot
Introduction to DAX (Data Analysis Expressions)
- Overview of DAX
- Function types
- Operators
- Calculated columns and measures
- Error handling
Power View Sheets
Tables:
- Sorting
- Filtering
- Charts
- Maps
Solver Add-in
- Problems solvable with the add-in
- Configuration overview of the tool
- Optimization examples
Inquire Add-in
- Overview of the add-in concept
- Workbook project review
Requirements
Proficiency with the Windows operating system and a basic understanding of Microsoft Excel operations.
Testimonials (4)
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
he was well prepared - and he is very sympathetic
Oliver - Post CH AG
Course - Splunk Fundamentals
Used good examples, good pace of the training and covered most things
