Enqurious LogoTM

Use coupon code 'ENQURIOUS25' to get 10 credits for FREE

Ending in
0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds
Go back

E-commerce Analytics with Python

14 Inputs
1 Hour
Beginner
item card poster cover image
Free
5 credits
Industry
e-commerce
Skills
approach
data-wrangling
programming
problem-understanding
Tools
python

Learning Objectives

Understanding Python Programming Building Blocks
Understanding Data Types in Python
Comprehensive understanding of loops and their usage
Implement conditional statements (if, elif, else) to build decision-making logic for data categorization and rule-based processing.
Handle user input and present data clearly using Python's output capabilities for actionable reporting.
Perform basic string processing and character-level analysis
Effectively use Python variables and operators to perform data manipulation and calculations from raw business data.

Overview

GlobalMart is a fledgling startup in the burgeoning E-Commerce space with a presence in the North America region.

It has a presence across 120 markets and primarily deals with 3 lines of businesses :

  • Technology
  • Office Supplies
  • Furniture

Being in the early stages of their business, GlobalMart has touched more than 1000 customers placing 5000+ orders till date. The company maintains its business transactions in plain Excel as of now. It also relies on Excel for all data analysis, reporting and visualization requirements.

However, off late, the Data Analysts at the company are facing a number of challenges :

  • Lot of manual and repetitive tasks have made working in Excel very difficult
  • Frequent duplicate records, missing values, incorrect data types issues in Excel
  • Lots of functions being maintained across sheets. Any change in any function can have cascading impact leading to opening of a pandora’s box of problems
  • VBA has become an old school way of automating repetitive data analysis tasks. Need something modern and easy way for performing data analysis
  • Visualization options in Excel are good to start. However, the options are limited when it comes to statistical analysis. Also, presenting visuals in a neat dashboard is always a challenge

As a newly joined Data Analyst at GlobalMart, your mission is to transform these challenges into opportunities. Your Data Team Head has recognized Python as the modern, versatile, and easy-to-learn tool that can solve these pain points, enabling quick, fast, and easy data analysis and visualization.

This hands-on will take you on a practical learning journey where you'll solve real-world problems inspired by Globalmart's daily operations. Each task is designed to solidify your Python fundamentals, moving you from a beginner to a confident data professional ready to drive impactful change.

Prerequisites

  • A foundational understanding of Python syntax.
  • Familiarity with Python's basic data types (integers, floats, strings, booleans)
  • Knowledge of arithmetic and comparison operators in Python.
  • Basic experience with input/output operations (input(), print()).