Scribd
Upload
692 views3 pages

Business Analytics With Excel PDF

The Business Analytics Certification Training course covers various analytic areas including customer, industry-focused, financial, performance, and risk analytics. It includes lessons on Excel functions, data analysis with pivot tables, dashboard creation, and the use of Power BI tools. The course aims to equip participants with practical skills in data analysis and visualization using Excel and Power BI.

Uploaded by

projects.aumraj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
692 views3 pages

Business Analytics With Excel PDF

The Business Analytics Certification Training course covers various analytic areas including customer, industry-focused, financial, performance, and risk analytics. It includes lessons on Excel functions, data analysis with pivot tables, dashboard creation, and the use of Power BI tools. The course aims to equip participants with practical skills in data analysis and visualization using Excel and Power BI.

Uploaded by

projects.aumraj
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Business Analytics Certification Training

With Excel - Course Agenda


Lesson 1: Introduction to Business Analytics

 What is Analytics?

 Overview of different - 2 Analytic Areas

 Customer Analytics

 Industry-focused Analytics

 Financial Analytics

 Performance Analytics

 Risk Analytics

Lesson 2: Formatting, Conditional Formatting, and Important Functions

 Formatting

 Conditional Formatting

 Logical Functions

 And, If, Not, Or, True, False

 Vlookup/Hlookup, Index, Match, Offset

 Statistical and Mathematical Functions

 Rank, Quartile, Decile, Percentile

 Standard Deviation, Correlation, Mean, Median, Sum, Count, Sumifs, Countifs

© Copyright 2015-2016, Simplilearn, All rights reserved.


Lesson 3: Analyzing Data with Pivot Tables

 Pivot Table Creation

 Grouping for different - 2 data types

 Show and Summarize Values

 Calculated Field and Calculated Items

 Slicer

Lesson 4: Dashboarding

 What is Dashboards and Excel Dashboard.

 Overview of Chart types, Chart Formatting

 Active X Form Controls

 Principle of great dashboard design

 Selecting Correct Chart to display data

 Interactive Charts with Form Controls

 Combo box, Check Box, Scroll Bar and Radio Button

 Interactive Dashboard with Form Controls

Lesson 5: Analytics with Excel

 Histogram

 Solver Add-In

 Goal Seek

 Scenario Manager

© Copyright 2015-2016, Simplilearn, All rights reserved.


 Data Table

 Descriptive Statistics

Lesson 6: Data Analysis Using Statistics

 Descriptive Statistics

 ANOVA

 Moving Average

 Testing Hypothesis

 Measuring Covariance and Correlation

 Distribution

 Regression

Lesson 7: Power BI

 Power Pivot

 Power View

 Power Query

 Power Map

For information on the course, visit: http://www.simplilearn.com/big-data-and-analytics/business-analytics-certification-training

© Copyright 2015-2016, Simplilearn, All rights reserved.

You might also like