Course Features

  • Lectures 0
  • Quizzes 0
  • Duration 10 week
  • Skill level All levels
  • Language English
  • Students 112
  • Assessments Yes


0 Review
112 students

Duration: 10 hours

Key features:

  • Instructor led training
  • Exercises/ Project
  • Post workshop support
  • Completely Hands-on workshop

Why Power Pivot:

This is Microsoft Excel’s most powerful data modeling and Business Intelligence (BI) tool. You will encapsulate business logic using calculated columns/ measures. It provides reporting feature in the familiar environment of Excel. You will be able to perform sophisticated and powerful data analysis.

Objectives of this workshop:

  • Understanding the workflow
  • When to use Power Pivot
  • Understanding Power Query
  • Exploring Power Query options and Editor
  • Applying Basic table transformations
  • Power Query: Text tools
  • Power Query: Number tools
  • Power Query: Date/ Time tools
  • Power Query: Conditional Columns
  • Merging/ Appending queries
  • Connecting to Folder of files
  • Exploring Data model
  • Data normalization
  • Creating table relationships
  • Creating Power Pivot
  • Introduction to Data Analysis Expression (DAX)
  • Working with DAX calculated columns
  • Exploring DAX measures
  • DAX formula syntax
  • DAX: Math functions
  • DAX: Logical functions
  • Iterating functions SUMX/ RANKX

After this workshop:

  • You will be able to work on data models
  • Build pro-quality business intelligence tools
  • Blend and analyze data from multiple sources

 Who should do this workshop:

  • Excel users who want to learn advanced data modeling and Business Intelligence tools.
  • Students looking for comprehensive approach to Excel workshop.
  • People who want to pursue career in Data Analytics and Business Intelligence.
  • This course is ideal for reporting/ MIS professionals

 Prerequisite: Basic knowledge of Excel

Curriculum is empty

User Avatar

Mrs. Harshal V. is an avid blogger and reader. She has vast experience (15+ years) of training in the field of IT and soft skills. Harshal owns an institute HV Training in Pune. HV could be “High Voltage” but here it stands for “Harshal Varkhedkar”. HV Training is a brainchild of Harshal. (BE, MBA, Six Sigma Green Belt, Certified Digital Marketer, PMP, Prince 2, Microsoft Office Specialist, NLP Practitioner).Empower yourself: Don’t wait around, TAKE ACTION!! Take responsibilities for your own improvements! Set the right kind of goals!! We bridge the gap between the skills required for doing a job and the skills that you currently possess. Learn the skills that will increase your efficiency and effectiveness.We provide effective training/ workshops for MS Excel, MS Word, MS PowerPoint, MS Project, PMP, Presentation skills, Public speaking skills, Leadership etc. HV Training (IT, Project Management and soft skills training) carries 15+ years of experience. The main focus of our training is to empower you.

0.00 average based on 0 ratings

5 Star
4 Star
3 Star
2 Star
1 Star

Leave a Reply

Enquire Now