Microsoft Excel Power Query
This course familiarises the participant with Microsoft Power Query, a revolutionary data tool for Excel that allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources for use in Excel and Microsoft Power BI. Power Query is a free add-in for Excel that enhances the self-service Business Intelligence experience in Excel. The course uses Excel 2016, however Power Query works with Excel 2010 and above.
Participants should be familiar with Excel and the concepts of datasets and basic reporting including the use of PivotTables.
Duration: 1 day course
Course topics include-
INTRODUCTION TO POWER QUERY
Power Query Interface
Understanding Data Types
WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Using Ranges in Excel
Understanding and Handling Special Situations
Working with Folders and Files
CONNECTING TO DATABASES
Understand working with relational data.
Understand and perform importing from SQL Server Analysis Services Multidimensional.
Understand and perform importing from SQL Server Analysis Services Tabular.
Understanding the Issues
Understand and utilize merges.
LOADING YOUR DATA
Loading into Excel
Loading into Power Pivot
Loading into Power BI Desktop
Importing, Transforming, and Loading Data into Excel and Power Pivot
Introduction to Power BI Desktop
GROUPING AND SUMMARISING WITH POWER QUERY
WORKING WITH THE POWER QUERY LANGUAGE “M”
Understand the M interface.
Understand Power Query formulas.
Email us about this courses
Telephone on 01952 305730