Zigya Academy Program | Analytics Boot Camp

ZIGYA ACADEMY
BEING RELEVANT

Foundation Programs

Optimal decision-making requires trade-off analysis; justification of the allocation of scarce financial resources to attain performance goals; and evaluation of policies for organizational benefit. This process can be daunting if your actions aren’t root

Basic Programs

provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission

Advanced Programs

provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission principles, best practices, and powerful tools.

Bootcamp Programs

provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission

Specialization Programs

provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission.

Certification Programs

provides a model for organizing facts, assumptions, estimates, and findings to align your decisions with your organization’s goals and mission

Expert Programs

Expert program is well suited to businesses and individuals who provide retail services and support to clients, implement point of sale and retail management systems, or are IT or Apple specialists. But anyone interested in expanding their services portfolio, earning revenue share, and providing ongoing support to retail clients is invited to apply.

Analytics Boot Camp

Insight into sound business strategy is critical to problem-solving and decision-making within a mission-critical organization. Developing a strong foundation in data analysis techniques can lead to this gained insight. You will learn numerous analytical techniques, including data preparation, integration, statistical analysis. Working collaboratively through real-world scenarios using Microsoft Excel, you’ll be prepared to perform the most relevant, mission-critical analyses.

  • Category

    Delivery

    Class Room | Online
  • Availability

    Individual

    Duration

    48 hours

Methodology

Student Presentations
Situation Analysis
Concept and Visual Presentations
Introspective Fill-Outs
Videos
Periodic Assignments
  • Topics
    Program Topics
  • Objectives
    Learning Objectives

Introduction to Data Analysis

The Importance of Data Analysis.
Using Excel for Data Analysis.

Designing Effective Data Visuals

Processing Visual Information Best Practices for Data Visualization Design

Analyzing Trends and Patterns

Showing Distributions Uncovering Relationships

Introduction to Data Analysis

The Importance of Data Analysis. The Importance of Data Analysis.

The Importance of Data Analysis

Range References Anchoring References Named Ranges Data Tables

Sorting and Filtering

Sorting Data Filtering Data

Pivot Tables

Overview of the Pivot Table Tool Creating a Pivot Table Report

Importing Data for Analysis

Importing Text Files for Analysis Importing Data from a Database Refreshing the Data

Data Retention and Integration

Curating and Retaining Data Sets Data Integration Linking Data between Sets Data Integration Functions

Text Manipulation

Overview of Text Manipulation Functions Using Text Manipulation Functions

Charting Data

Levels of Measurement Introduction to Charting Data Formatting Charts Chart Types and Applications

Introduction to Statistics

Statistics Overview

Descriptive Statistics

Measures of Central Tendency Measures of Variation Analysis ToolPak Descriptive Statistics

Frequency Distribution

What Is a Frequency Distribution? Creating Histograms

Probability

Probability in Practice Counting Outcomes

Probability Distributions

Binomial Distribution Normal Distribution

Statistical Sampling and Confidence Intervals

Overview of Statistical Sampling Methods of Statistical Sampling Statistical Error and Sample Size Sampling Distribution of the Mean Confidence Intervals

Correlation and Regression

Correlation Analysis and Applications Linear Regression Analysis and Applications

Who should take this course

Insight into sound business strategy is critical to problem-solving and decision-making within a mission-critical organization. Developing a strong foundation in data analysis techniques can lead to this gained insight. You will learn numerous analytical techniques, including data preparation, integration, statistical analysis. Working collaboratively through real-world scenarios using Microsoft Excel, you’ll be prepared to perform the most relevant, mission-critical analyses.