Prerequisites

• Knowledge of writing basic formulas and fucntion in Excel or completed Excel Intermediate course.

Learning Objectives

By the end of the course, you should be able to:

• Access the Power Pivot add-in
• Load data from various source
• create a dashboard
• Develop data model
• Use Relationships tool to build relationship between tables
• Use Power Query
• Grouping data

Topics

• Working with Data Analysis Tools
• Creating Scenarios
• Using What If analysis
• Using Goal Seek
• Using Solver
• Generating report with alternate solutions
• Introduction to Pivot Table
• Formatting Pivot Table
• Calculating PivotTable Values
• Updating PivotTable Data
• Introduction to PowerPivot
• Using Data Model Tool
• Using Power Query to acess data from various sources
• Getting data from Web page, Excel, XML and Access Database
• Building data model
• Managing Relationships
• Writing Formula for Calculation
• Grouping Data
• Creating Hierarchy
• Adding column to Hierarchy
• Using Slicer
• Creating Dashboard
• Visualize data using Power Map and Power View
• Use Power View to create interactive charts
• Using cloud-based PowerBI Tool

Schedule