Search for a command to run...
Articles tagged with #8weeksqlchallenge
We are back on track and in the article we answer the questions for the 2. Digital Analysis focus area in the 6th case study: Case Study #6 - Clique Bait How many users are there? SELECT COUNT(DISTI
We are on 6 out of 8 case studies. It has been a journeeeyyyyyy and boy ooo boy it has not been easy. This is not the time to give up I can smell the bouquet of flowers at the end of all of these (I s
The final focus area in Case Study #5 - Data Mart where we solve the Bonus Question. Which areas of the business have the highest negative impact in sales metrics performance in 2020 for the 12 week b
The focus for this article: 3. Before & After Analysis is to now calculate the total sales and calculate the percentage change in sales amount. This technique is usually used when we inspect an import
Here we go with responses to questions in the second focus area: 2. Data Exploration of Case Study #5 - Data Mart What day of the week is used for each week_date value? SELECT DISTINCT DAYNAME(week_d
Welcome to Case Study #5 - Data Mart and the section 1. Data Cleansing Steps In a single query, perform the following operations and generate a new table in the data_mart schema named clean_weekly_sal