Business Analytics with Excel

Description

This course enables business users to understand the capability of excel and BI tools to perform Analytical actions. You will understand Excel analytics tools & functions, learn how to analyze complex datasets using Pivot Tables, Slicers and Timelines and get introduced to the latest Microsoft Power BI tools i.e. Power Pivot and Power Query. You will able to use different tools to do statistical analysis and forecasting and Represent your findings using Charts and Dashboards.

Additional information

Day 1

Session 1:Introduction
Session 2 & 3:Pivot Tables
Session 4:Connecting with External Data Sources

Day 2

Session 1 & 2:Data Modeling with Power Pivot
Session 3 & 4:Power Query

Day 3

Session 1, 2 & 3:Statistical Analysis and Forecasting
Session 4:What-If Analysis

Day 4

Session 1, 2 & 3:Dashboarding
Session 4:Putting It All Together

Reviews

There are no reviews yet.

Be the first to review “Business Analytics with Excel”

Your email address will not be published. Required fields are marked *