Data Analysis using Excel

4 Scenarios

4 Hours

Industry

e-commerce

Skills

data-wrangling

data-visualization

approach

Tools

excel

Learning Objectives

Learn skills to perform text processing in Excel

Learn skills to perform date processing in Excel

Learn skills to perform math processing in Excel

Learn skills to perform data operations (Filter, Group By - Aggregate, Merge, Pivot etc.) in Excel

Overview

Amazon, an E-Commerce company, understands the importance of data-driven decision making. With over 2000 customers and 5000+ orders, they rely on plain Excel for managing their business transactions.

Excel serves as their go-to tool, despite their limited data analysis capabilities. By maintaining their data in Excel, Amazon recognizes the need to unlock its full potential for extracting insights and driving business growth.

With Excel, Amazon wants to gain the ability to organize and analyze their data effectively. This will help them generate reports, track performance metrics, and visualize trends using charts and graphs. This in turn will empower them to make informed decisions, identify opportunities, and optimize their operations.

So, in this Self-paced module, we'll discover the following :

How to use the text, date and math processing functions in Excel?
How to prepare reports from multiple datasets?
How to summarize data?

Prerequisites

Understanding of Data Quality issues