Sql Case Study Pdf In this tutorial we will work on a case study of sql where you will analyze the sales and performance of a business. check our data science & analytics cour. Data mart is a new venture and the ceo wants to analyze the sales performance of this venture. in june 2020 — large scale supply changes were made at data mart. all data mart products.
Sql Case Study Pdf Using sql, i cleansed and explored the dataset to draw meaningful insights. key tasks included identifying missing data, calculating metrics like sales and transactions, and deriving insights based on demographic trends, platforms, and regions. Case study #5 data mart – 8 week sql challenge – start your sql learning journey today! data mart is danny’s latest venture and after running international operations for his online supermarket that specialises in fresh produce danny is asking for your support to analyse his sales performance. For this case study, postgresql v13 will be used for analysis. before we begin the cleaning and transformation, let’s see the current state of our weekly sales table. An online sql database playground for testing, debugging and sharing sql snippets.
Sql Case Study Pdf For this case study, postgresql v13 will be used for analysis. before we begin the cleaning and transformation, let’s see the current state of our weekly sales table. An online sql database playground for testing, debugging and sharing sql snippets. This is a case study and is part of a 8 part series of 8 different case studies that focus on different aspects of a business. in this case study we will answer the following:. Case study #5 data mart – 8 week sql challenge – start your sql learning journey today! free download as pdf file (.pdf), text file (.txt) or read online for free. Which week numbers are missing from the dataset? 2. how many total transactions were there for each year in the dataset? 3. what are the total sales for each region for each month? 4. what is the total count of transactions for each platform. 5. what is the percentage of sales for retail vs shopify for each month? 6. Our beginner friendly sql course (and the professional sql certification that comes with it) is applicable to mysql, sql server, and postgresql. you can switch from one to the other with ease thanks to the universal skills that our course will teach you.
Comments are closed.