Excel BI Power User
Our Excel power user courses show delegates who have an intermediate to
advanced knowledge of Excel how they can become power users simply by
mastering a series of powerful new features which have been available in Excel for
a few years now, but of which many users are still blissfully unaware. Now all your
staff can join the growing band of Excel users who are in the know.
Excel Power User Level 1 Excel Power User Level 2 Excel Power User Level 3
(1 day) (1 day) (1 day)
Overview Overview Overview
This course aims to show delegates
how to make the transition from
over-reliance on Excel’s VLOOKUP
function to working with tabular
information from multiple sources
using Excel’s supercharged Power
Query and Power Pivot tools.
Delegates will be introduced to the
Excel data model and will learn
how to create pivot tables and
dashboards which visualize data
from multiple related sources. This intermediate course shows
users how to connect to a wide
variety of data sources and create
data models which include DAX
calculated columns and measures.
Delegates will also be shown how
to create rules for transforming
data as it is added to the data
model and how to create Power
View reports. This advanced course provides
insights into the advanced aspects
of these powerful technologies.
Delegates will be shown how to
write their own functions in the M
language which underlies Power
Query; and to create complex DAX
formulas using advanced time
intelligence functions.
Audience Designed for experienced users
of Excel’s Power Pivot and Power
Query tools.
Audience
Aimed at intermediate and
advanced users of Excel who
are only familiar with Excel’s
“traditional” features.
Designed for users who are already
familiar with Excel’s Power Query
and Power Pivot tools.
Key Topics Covered
• Connecting to Data from outside
Excel
Key Topics Covered • Transforming Columns of Data
• Introduction • Transforming Rows
• Tabular data • Performing other Data
• The Excel Data Model
Transformations
• Tables Queries and Connections • Creating Calculated Columns
• Getting Started With Power Query • Creating Measures
• Query Basics • Understanding the DAX Language
• Modelling Data • Understanding the CALCULATE
• Creating Pivot Table Reports
• Creating Dashboards
Audience
Key Topics Covered
• Advanced Data Transformation
• The Power Query Formula Language
• Understanding Automatically
Generated M Code
• Creating custom functions in M
• Iteration Techniques
• Advanced DAX
• Hierarchies
• KPIs
• Creating 3D Map Reports
function
• Creating Power View Reports
“ Very well structured and informative. Enjoyed it very much. ”
Polina Natcheva
Finance Director, Sensus UK
- 7 -
G Com Solutions Limited
0800 998 9248
www.gcomsolutions.co.uk