Search for a command to run...
In about a month's time, the summer begins and by now, most companies are already out with good deals on their products. Unfortunately, my fictional company was dealing with other issues, so they are
PS: Moved all articles in this series to Four-Eyed Insights Series' Articles - DEV Community as according to Hashnode 2 articles in these series are not technical and developer-focused enough. They ha
Welcome to the first article in the series where I breakdown my thinking and working process for a data analysis project. In this article, I want to talk about the following: Why start with ecommerce
"Starting this new year, I am looking at getting involved with challenges." the first line typed on Wednesday, 4th February 2026. The goal then was simple, to get involved in challenges and I started
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