Data Analysis using Power Pivot and DAX
Details
DATA ANALYSIS USING POWER PIVOT AND DAX
Data analysis is the bedrock to develop information required for decision making. MS Excel users can generate information to help make an informed decision. However, when data is contained in or obtained from various tables (dimension & fact tables), analysis becomes very difficult. Users have to look up facts and merge tables which becomes cumbersome. To make data analysis by Excel users more user – friendly, Microsoft launched Power Pivot and its DAX functions (Data Analysis expression). With Power Pivot, Excel users can now do data analysis with much ease across tables. They are no longer restricted to pivot on one table. Excel users can now easily create relationships between tables by point & click then drag & drop. Models and modelling become the order of the day. Creating Measures with DAX makes analysis very simple but sophisticated.
Learning Outcome
At the end of this course, participants would be able to:
- Highlight the insights introduced to data analysis and execution by Power Pivot
- Understand Data Modelling and creating Relationships between facts and dimension tables
- Show how Power Pivot and DAX helps in developing adequate Decision-Making reports
- Provide the techniques needed for mastering Power Pivot and DAX capabilities
- Develop skills for data mining using DAX.
Instructor-led hands-on training. Each participant must be present with a computer for practice. Audio-visual aids to help. There will be Class projects to demonstrate understanding at the end of each module.
Outline
*What is Power Pivot?
*Pivot Table versus Power Pivot
*Introduction to Data Modelling
- Creating Relationships between Tables
- Creating Calculated Columns
- Creating Measures
*Introduction to DAX (Data Analysis expression)
- Lookup Tables & Data Tables
- Table structures & Schemas
- Working in various views
*DAX basic functions
- The Aggregators: SUM, COUNT, DIVIDE functions, etc.
- Understanding: CALCULATE and CALCULA TABLES
- The Iterators: SUMX, AVERAGEX, CONCATENATE, etc.
- Logical, Table, Statistical functions, etc.
- Date and Time Intelligence functions
- Table functions: ALL, FILTER, SUMMARIZE, VALUES, etc.
*DAX Concepts: Understanding
- The DAX Engine
- Evaluation Contexts
- Row context
- Filter Context
- Filter Propagation
- Disconnected Tables
Special Offer
20% Discount applicable on registration of a minimum of 4 participants.
Both offers are mutually exclusive
The course fee covers tuition, course materials, certificate and meals
Autusbridge Consulting Ltd is a leading training provider in Nigeria. We offer training programs in Sales, Marketing, Business Management, Microsoft Office tools and Data Analytics, Leadership, Finance and Financial Modelling Courses. We are an authorised training partner to the Institute of Sales Management, UK and Cambridge Professional Academy, UK; for the provision of Sales, Marketing and Business Operations certifications in Nigeria. Our certification programs are globally recognised for professional practice and career growth.
Our fast-growing clientele cuts across multinationals/blue chips, MSMEs and SMEs, governments and not-for-profit organisations. Our highly professional, technology-enhanced and industry-focused training contents and delivery methodology give us greater advantage amongst our peers. We have a rich faculty of training facilitators with relevant training and hands-on background from academia and professional practice.
Related Courses
