Excel Data Modelling and Data Analysis
Course Description
This course provides a solid introduction to using Excel as a Data Analyser to connect to data, create data models, create visualisations, query the data and publish reports. It is designed to introduce Excel users to report generation and visualisation using Data Analytic techniques and refreshing data from many data sources using Excel’s built-in M programming in Power Query.
1 day
€395.00
Who should attend
Participants should have at least Intermediate Excel and database user skills. They need:An understanding of basic data concepts
Ability to create and format chart outputs
Ability to understand formulas and functions
Learning Objectives
By the end of this course, participants will be able to:Understand Excel data analysis concepts and main features
• Evaluate Data sources compatible with Excel
• Connect to data and create data models
• Create advanced and automated data visualisations
• Create and publish detailed visual reports
• Create Time Intelligence Tables for different time periods
Summary content
Understanding Data Models and visualising data• Manipulating data from any source
• The features of Power Query
• The M-Language and creating an automated Excel import system
• Data Connectivity and refreshing visuals
• Data Modelling – relationship-based data models from multiple sources
• Using Data Analysis Expressions (DAX) in an Excel report
• Analysing Data with Excel Visuals
• Creating Visuals from Linked Data
• Advanced Reporting features
Advanced ExcelMicrosoft ExcelMS ExcelExcel 365Excel 2021Microsoft Excel 2021