This repository encapsulate case study solutions to #8WeekSQLChallenge.
In this project, I took up the role of a business analyst to modify existing schema and answer questions related to product and sales analytics request from different sectors of stakeholders and team members with the end result to help decision makers make informed strategied decisions.
To access each Introduction of task, Entity Relationship Diagram, Schema and Case Study Questions on Data With Danny website. Click each of the table of content below. All solutions were queried using PostgreSQL.
| Case Study | Solution Status |
|---|---|
| Case study #1: Danny's Diner | Completed |
| Case study #2: Pizza Runner | Completed |
| Case study #3: Foodie-Fi | Completed |
| Case study #4: Data Bank | Completed |
| Case study #5: Data Mart | Completed |
| Case study #6: Clique Bait | Completed |
| Case study #7: Balanced Tree Clothing Co. | Completed |
| Case study #8: Fresh Segments | Completed |
In this SQL challenge, I queried the database to answer business questions using the SQL syntax such as CTEs(Common Table Expression), subqueries, joins(inner, outer, self left, right, cross), string manipulation functions, window functions and frames(lag, lead, unbounded preceeding, rank, row_number), combinatorics math, date function, summarize statistics, explore, pre-process, optimize and analyse the dataset of different sector.