Archives: Assignments

🔧 Scenario: You’re working as a data analyst for a retail company. Your team collects customer data from

🧩 Scenario: You are working as a Data Engineer for a retail company using Snowflake for all analytics

Exercise 1: Rewrite Product Reviews as Marketing Quotes Objective: Use COMPLETE() to turn honest reviews into positive marketing

Free Dataset Example: OpenCorporates Sample Data Provider: OpenCorporatesListing: OpenCorporates Sample DatasetsDescription: OpenCorporates offers the world’s largest open database

SnowSQL Commands to Use Here’s a list of useful SnowSQL commands to explore and manage your data: 🔹

🎯 Learning Outcomes: Practice SQL joins, aggregations, and filters using realistic business datasets. Query system metadata to analyze

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