Archives: Assignments

Assignment: Data Validation with pandera Context In a real data engineering pipeline, you rarely trust raw data. Before

Data Set https://docs.google.com/spreadsheets/d/1QWDI9wSMEA4UXzskJYxVGZvouteMbs3bkPcazI1A82I/edit?usp=sharing Objective:Identify customers who purchased in 6 or more unique months — define them as “Loyal

Task 1:Using a sample dataset (Orders), create a calculated field: Total Value = [Sales] + [Profit]Drag it onto

Two libraries have overlapping and unique collections of books. Library A Harry Potter The Hobbit Dune Sherlock Holmes

🔧 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