logiicon


EDA Training


Key Features


Learn from an Industry Expert

This course is designed by industry experts with ten years of IT experience in analytics.

Video Lectures

These sessions will give you the flexibility to plan your learning journey based on your schedule.

Case-Studies

Get more practice with case studies specially designed to put all your learning into practice.

Real-life Project

Apply your learning in a real-life project for the sales performance of Mega Mart, a leading supermarket chain. Find more details in the section below.

Module-wise Practice
Questions(Flexi-Pass)

Learning theory and not putting it into practice is not a good way of learning. You will get a range of practice questions for each module to reinforce the concepts that you learn.



Course Objectives

This course will help you develop employable data analysis skills, making it apt for professionals looking to enter the field of analytics without getting into coding. Experts use Excel for advanced analytics, and now you can too! The key learnings are:

  • Understand data analysis and how businesses use it.
  • Learn how to clean collected data and prepare data for analysis.
  • Different techniques of exploratory data analysis and visualization.
  • Analyze data using PivotTables and PivotCharts.
  • Creating interactive dashboards.
  • Merging Data from different sources.
  • Advanced-Data Analysis
  • Work on real-life case studies and projects to derive data-driven insights.

Why learn EDA?

Microstrategy report states that 94% of enterprises say data is essential to business growth.
According to Glassdoor, the average salary for a Data Analyst with Microsoft Excel skills is $73,824 per year in the United States.
Data and AI show the highest growth rate at 41% per year as per the World Economic Forum’s “Jobs of Tomorrow.”

Who is eligible for this course?


This course will help anyone interested in deriving valuable insights from data and using them to improve business decision-making. Excel is an affordable self-service Business Intelligence tool for EVERYONE. This is not an MS Excel course, and we will study only the basic Excel functions needed for data analysis. Macros and VB scripts are not part of the scope. This course will be ideal for:

ulmark Professionals who work in IT or any core industries like finance, sales, supply chain, CRM, etc.
ulmark Professionals who want to learn business analytics but have no prior knowledge of analytics, statistics.
ulmark Professionals who want to begin their journey in Data Science, Business Analytics, or Data Visualization.
ulmark Fresh graduates who must demonstrate their proficiency in data analysis skills upon entering the workforce.

Skills Covered

Data Analysis Data Analysis
Project Planning Project Planning
Data Visualization Data Visualization
Pivot Table Pivot Table
Data Cleansing Data Cleansing
Data Cleaning Data Cleaning
Microsoft Excel Microsoft Excel
Power Query Power Query
Exploratory Data Analysis Exploratory Data Analysis

...View More


Course Curriculum


Course Syllabus


Module 1: Overview of Data Analysis
1 Data-driven Management in Organizations
2 What is Data?
3 Need for Data Analysis
4 Data Analysis Process & Examples
5 Introduction to Excel, Pros, and Cons
6 Using Excel for Data Analysis
Module 2: Collect and Prepare Data
1 Data Collection for Analysis
2 Importing Data into Excel
3 Data Types
4 Data Types in Excel & Formatting
5 Data Preparation before Analysis
6 Excel Tables
7 Filtering Data
8 Sorting Data
9 Analytical Functions
Module 3: Data Analysis & Visualization
Creating Cross-Tabulated Reports using:
1 Excel Formulae
2 Dynamic Arrays
3 Pivot Tables
Module 4: Data Merging
1 Need for Data Merging
2 Using the VLOOKUP() Function
3 Using Power Query
Module 5: Advanced Data Analysis
Data Analysis using the Analysis ToolPak:
1 Histogram
2 Rank & Percentile
3 Descriptive Statistic
4 Correlation
5 T-Test


Case Studies And Projects


Card-image

Netflix Content Descriptive Analysis

  • Netflix is the world's leading streaming entertainment service with 204 million paid memberships in over 190 countries, enjoying TV series, documentaries, and feature films across a wide variety of genres and languages.
  • This descriptive analysis case study for Netflix focuses on discovering popular content on Netflix, top countries actively preparing content, movie and TV show trends, average movie duration, and other business insights.
Card-image

Superstore Low Profits Diagnostic Analysis

  • As part of the finance team of the Super Store, you noticed that there were some profit problems for some inventory categories.
  • You decide to investigate which sub-category has profit problems, where the problems are happening, for which products, and the reason.
  • This diagnostic analysis aims to find the root cause for low profits in sub-categories.
Card-image

Mega Mart Sales Performance Analysis

  • The management wants to look at the key metrics: sales, profit, and profit ratio and the proportion of sales across cities. They also want to analyze the top sold products to promote further and increase sales.
  • In this capstone project, you will analyze key metrics, derive insights to formulate the sales strategy, and build an interactive dashboard for Mega Mart.

Case Studies And Projects


Course

Netflix Content Descriptive Analysis

• Netflix is the world's leading streaming entertainment service with 204 million paid memberships in over 190 countries, enjoying TV series, documentaries, and feature films across a wide variety of genres and languages.
• This descriptive analysis case study for Netflix focuses on discovering popular content on Netflix, top countries actively preparing content, movie and TV show trends, average movie duration, and other business insights.

Couse

Superstore Low Profits Diagnostic Analysis

• As part of the finance team of the Super Store, you noticed that there were some profit problems for some inventory categories.
• You decide to investigate which sub-category has profit problems, where the problems are happening, for which products, and the reason.
• This diagnostic analysis aims to find the root cause for low profits in sub-categories.

Course

Mega Mart Sales Performance Analysis

• The management wants to look at the key metrics: sales, profit, and profit ratio and the proportion of sales across cities. They also want to analyze the top sold products to promote further and increase sales.
• In this capstone project, you will analyze key metrics, derive insights to formulate the sales strategy, and build an interactive dashboard for Mega Mart.




Course Certification

Every course participant will receive a course completion certification from Techcanvass. The course certification:

  • Proves that you have gained considerable knowledge on performing
  • EDA with Excel.
  • It is a significant step forward towards your career growth.
  • Certifies your course completion.
  • Provides an opportunity to go ahead and share your achievement on
  • Proves that you have gained considerable knowledge on performing LinkedIn, Facebook, etc., add it to your resume, tell your friends!
EDA-Certificate




Course Author


Priya Telang Priya Telang

Priya Telang

Priya Telang is a senior data analyst. She is an influential, result-oriented, and self-motivated leader with excellent analytical and critical skills. She has a diversified professional experience of 10 years in IT, the public sector, and curriculum development. ...Read More Her journey started with Business Intelligence and analytics in Accenture with prominent clients in retail, finance, media & telecommunication, followed by a fellowship with Teach for India and curriculum development. She is passionate about using data analysis and machine learning to solve problems. She is a certified IIBA Business Data Analyst and certified Tableau Desktop Specialist. Read Less


EDA Course fees

(Please Select Currency)

  
Exploratory Data Analysis Using Excel

₹ 2,673

₹ 2,970

(10% OFF )

[GST Extra]

Expires in 01 D 11 H 09 M 25 S


Self-paced Course

  • Self-paced Course
  • Course Certification
  • End of Chapter Quizzes
  • Real-life Project
  • Email Support from the Expert

To get Group Discount Click Here


Have questions? Call the learning advisor or join the Whatsapp community for career Q&A, expert guidance and more

Corporate and Group Training

Let us know about your company training requirements, we can also customize the program to suit your needs.

Special discounts available for a group of 3 or more.

Corporate Training Enquiry

Frequently Asked Questions (FAQ)


Is knowledge of excel basics a prerequisite?

Basic knowledge of Excel is not necessary but helpful. Even if you are new to Excel, this course covers the basic Excel concepts. So, learning Excel will not be difficult.

What is exploratory data analysis?

Exploratory data analysis (EDA) is performed before the actual data analysis, and it helps to understand the nature of the data set. It is used to check if the data is making sense in the context of the business problem, look at the data summary, identify data quality issues, identify outliers, find data patterns, and much more.

How is Excel used for data analysis?

In the simplest terms, Excel organizes raw data into a readable format to draw insights. You can even add calculations and summary statistics, customize fields, merge or segment, and visualize data. This will help to explore data, draw patterns, understand correlations, and much more.

What types of analysis can you do with Excel?

Data Analysis helps you evaluate business data by inspecting, cleaning, transforming, and modeling for effective business decision-making. You can do a comparison, trend, part-to-whole, correlation, distribution analysis, and much more.

Which built-in features of Microsoft Excel can be used for analysis?

Data Analysis using the Analysis ToolPak:

Features like pivot tables, power pivot, data analysis Toolpak, and the What-if analysis can be used for analysis.


Related Courses


Data-Analytics-Certification-Course

Data Analytics Certification Course

Power-BI-Certification-Training

Power BI Certification Training

Tableau-Training

Tableau Training

Data-Analytics-Certification-Course

Data Analytics Certification Course

Power-BI-Certification-Training

Power BI Certification Training

Tableau-training

Tableau Training

whatsapp

Copyright © Techcanvass | All Rights Reserved