Key points about this course
Duration: 3 Days*
Support: 24/7Dates & Prices Enquire
Send us your message.X
We have your course. Please kindly fill below your contact details to receive full course information and pricing.
Available delivery methods for this course
This 3-day course is intended for delegates who want to learn to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.
This Analysing and Visualising Data with Microsoft Excel course is fully accredited by Microsoft through the Microsoft Silver Partnership held by The Knowledge Academy.
After completing this course, delegates will be able to:
This course includes the following modules:
Module 1: Data Analysis in Excel
This module looks at the classic Excel dashboard and at ways to extend it.
Lab: Building a Classic Excel Dashboard
Module 2: The Excel Data Model
This module looks at the classic Excel data model and at ways to extend it.
Lab: Explore an Excel Data Model
Module 3: Importing Data from Files
This module looks at pre-formatting and importing CSV files.
Lab: Importing Data from a CSV File
Module 4: Importing Data from Databases
This module looks at how to import data into Excel from a SQL Server database.
Lab: Import Data from Multiple Sources
Module 5: Importing Data from Excel Reports
This module describes how to import data from a report.
Lab: Importing Data from a Report
Module 6: Creating and Formatting Measures
This module describes how to create and format measures.
Lab: Creating Measures using Advanced DAX Functions
Module 7: Visualising Data in Excel
This module describes how to visualise data in Excel.
Lab: Data Visualisation in Excel
Module 8: Using Excel with Power BI
This module describes how to use Excel with Power BI.
Lab: Creating a Power BI Dashboard with Excel
This course is intended for delegates who are experienced in data analysis with Excel and who wish to add BI techniques.
The course will likely be useful to SQL Server report creators who are interested in alternative methods of presenting data.
Before attending this course, delegates should possess or be able to demonstrate:
The Knowledge Academy does not provide an examination for this course. Delegates will be given access to:
Duration: 3 Days*
Support: 24/7View dates & prices
Select your preferred delivery method
Choose a Region
Choose a Location
Choose a Month
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Trusted & Approved
Microsoft Silver Learning Partner
Various delivery methods
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
"...the trainer for this course was excellent. I would definitely recommend (and already have) this course to others."
Diane Gray, Shell