E-commerce Analytics with Python

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.