Management
Star icon
Most Popular
Hands on Training icon
Hands On Training
Star icon
Hands on Training icon

Power Pivot Fundamentals

Course Cover

5

(3)

compare button icon
Course Report - Power Pivot Fundamentals

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Course Features

icon

Duration

7 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

7 hours

Course Description

This course will show you how to create a business intelligence dashboard using Excel Power Pivot. This course will teach you the best practices and key functions for creating a dashboard. As you move through the course you will be able to apply what you have learned to a real-world example with data that we provide. You'll be able to create your own Excel dashboards and track KPIs.

Course Overview

projects-img

Personlized Teaching

projects-img

Case Based Learning

projects-img

Post Course Interactions

projects-img

Case Studies,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

There is no prerequisities available but having computer science degree is plus

What You Will Learn

Create a Power Pivot table by drawing data from several different tables

Develop simple calculated metrics with consistent formatting

Assemble multiple pivot tables, charts, and dimensions into a dashboard that provide us with different angles of analysis

Apply DAX formula language to create measures and columns

Manipulate context to calculate more advanced metrics

Utilize DAX Advanced Time Intelligence to create period comparisons and KPIs

Target Students

Business Intelligence Analyst

Data Scientist

Data Visualization Specialist

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover