Archives: Assignments

Tableau Assignment: Stories and Their Uses 🎯 Objective: Understand how to create and use Stories in Tableau to

🧑‍💼 Business Scenario: You’ve just joined a retail company as a Data Analyst Intern. Your manager wants you

🔍 Objective: Use the existing cohort analysis to explore deeper trends in customer retention, engagement, and cohort behavior

🧑‍🏫 Objective: Analyze product returns using pandas to find return rates by product, category, and store. 🛠 Dataset

https://docs.google.com/spreadsheets/d/1_acGG2Aj8kNvnS280p8tlswsZCbETnUA/edit?usp=drive_link&ouid=106646332626919912310&rtpof=true&sd=true Data looks likes this below: Year,Country,Literacy Rate,Internet Penetration Rate,Mobile Subscriptions2015,USA,99.0,87.5,1102015,India,72.3,27.0,742015,Germany,99.1,89.0,1252016,USA,99.1,88.4,112 Tasks Import into Tableau. Pivot from columns

Overview In this assignment, you will work with an e-commerce dataset to develop and analyze customer churn indicators.

🧠 Assignment Tasks ✅ Task 1: Quarterly Sales by Category Objective: Group sales data by year, quarter, and

📦 Example: Category Hierarchy Traversal (Recursive Query) 🧾 Table: categories category_id category_name parent_category_id 1 Electronics NULL 2 Computers

📘 SQL Assignment: Customer Lifetime Value and Engagement Segmentation 🧠 Context: You’re working as a data analyst for

📘 SQL Assignment: Sales Performance Analysis 📝 Context: You’re working as a data analyst at a company analyzing