Importing Data – Building Reports – Dashboards

This one-day course is intended to empower users with the skills to create pivot tables for effective data analysis in Excel. Throughout the course, participants will learn how to utilise Power Query to connect to various data sources, transform and cleanse data, and ultimately develop a functional data model. This model can be used to generate pivot tables, dashboards, and comprehensive reports.

Course Objectives:

• Understand the core functionalities of Power Query and Power Pivot
• Learn how to import, clean, and transform data using Power Query
• Build data models and relationships in Power Pivot
• Apply the tools to create meaningful reports and insights

Pre-requisites

Participants are encouraged to have completed a level 2 or level 3 excel training course or possess a strong familiarity with the majority of the features and functions covered in that curriculum.

Course Content

Introduction to Advanced Power Query and Power Pivot

• Differences between Power Query, Power Pivot, and Pivot Tables
• How these tools fit into Excel and their importance for data analysis

Power Query

• What is Power Query?
• Importing Data
• Data Transformation
  • Removing duplicates, filtering, and sorting
  • Unpivoting and pivoting data
  • Splitting and merging columns
• Loading Data into Excel

Introduction to Advanced Power Pivot

• What is Power Pivot?
• Importing Data into Power Pivot
  • Loading data from Excel and Power Query into Power Pivot
  • Creating and managing relationships between tables
  • Overview of data types and structure

Building Reports with Power Pivot and Power Query Data

• Creating Pivot Tables from the Data Model
  • Building Pivot Tables with multiple tables
  • Filtering and sorting your reports
• Creating Charts & Dashboards
  • Visualizing your data using Pivot Charts
  • Tips for building interactive reports with slicers and timelines

Who should attend?

This course will be of huge benefit to anyone in public or private sector who has experience with excel and needs a more advanced level of training focusing on pivots & power query.

Certification

On completion of this one-day training course, you will receive your Certificate of Attendance. Please note certificates are issued at the close of the training course to participants on completion of the course.

This course may qualify for CPD points. Please check directly with your association or awarding body to see how many points they will award.

Cost

An ‘Early Bird’ discounted rate of €499 is currently available. This training course normal rate is €599. Places are limited and are allocated on a first come first served basis. PLEASE NOTE THE EARLY BIRD RATE CLOSES 3 WEEKS PRIOR TO COURSE DATE. The course cost includes all course documentation and Certificate of Attendance.