Whelp☹️... Day 14 of @hertechtrail #HTTDataChallenge task is to retrieve the total sales for each channel from which clients access the company. Highlight high value and low value channels. #SQLJoinAggregations #DataIntegration

Types of Joins #sqljoinaggregations

My query calculates total sales per channel, categorizing them as high-value or low-value (using a $100M threshold) to aid resource allocation and marketing strategy. #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration @ogbonna42449096 @som_nnamani

I used the case statement to achieve this result: Case Statements are conditional expressions which allows you perform different actions based on specified conditions. #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration

I wrote an SQL query to retrieve the total sales for each channel used by clients to access the company, I categorized each channel either as a high value channel or a low value channel based on this #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration

Eliminating underperforming channels and redirecting resources to high-performing ones. #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration.

Day 14: Combining Joins and Aggregations on SQL I was tasked with retrieving the total sales for each channel from which clients access Parch and Posey, highlighting high value and low value channels. #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #Datalntegration

#hertechtrailacademy #SQLJoinAggregations #DataIntegration

Day 19: Combining JOINs and Aggregation Retrieve the total sales for each channel from which clients access the company. Highlight high value and low value channels. #20dayswithdata #SQLJoinAggregations #DataIntegration

Day19 of #20dayswithdata Retrieve total sales for each channel then highlight high value and low value channels. High value channel is the direct channel with close to 200,000 orders, the other channels are less than 100,000 orders. #SQLJoinAggregations #DataIntegration

Day 19 JOINs and Aggregation I wrote a SQL query to retrieve the total sales for each channel from which clients access the company. Highlight high value and low value channels. #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration.

Day 19: Combining JOINs and Aggregation I wrote an SQL query to retrieve the total sales for each channel from which clients access the company. Significantly more sales were made through the direct channel (640 million) compared to the other channels. #SQLJoinAggregations

The lowest sales channels were Twitter($51 million) and banners($48 million). To improve sales, aggressive Twitter ads and cost-profit analysis of banners can be used to reach a larger audience and redirect expenses elsewhere. #20dayswithdata #SQLJoinAggregations #DataIntegration

Observation: The direct channel had the highest number of total sales while the banner channel had the list number of total sales. #20dayswithdata, #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration.

Day 19 of 20 Task: Write an SQL query to retrieve the total sales for each channel from which clients access the company. Highlight high value and low value channels. #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration

Day19 #20dayswithdata Wrote an SQL query to retrieve the total sales for each channel from clients accessing the company. Highlighting high-value and low-value channels. #SQLJoinAggregations #DataIntegration.

$640,000,000. ➕ The use of banner had the minimum effect with total order of 7916299 and sales of $48,000,000. #hertechtrailacademy #HTTDataChallenge @hertechtrail @phaibooboo , @fresh_gb , @vicSomadina , @AtiJoshua , @OMOTOSHOOLAMI15 #SQLJoinAggregations #DataIntegration.

Day 19 I retrieved the Total sales for the different channels customers access the company. Using the case statements I was able to highlight the High value and Low value channels. #SqlJoinAggregations #Dataintegration #20dayswithdata

Day 19. Directly speaking with Parch and Posey clients was observed to bring in the highest number of paper sales (102,408,010) and the highest amount in sales ($640 million). Another highly valuable channel is the Facebook channel, which made 16,682,255 in paper sales quantity and about $103 million in sales amount. The use of a banner was not a really effective option when compared to the other access channels, and only about $48 million was generated by the company over a 3-year period. Another low value channel is Twitter (X), which brought in about $51 million over the 3-year span. The cost of putting out banners and the resulting profit from sales needs to be reviewed to determine if continuing with that channel is a great idea. Aggressive marketing on the Twitter platform will be a way to attract new clients on the platform. #20dayswithdata #SQLJoinAggregations #DataIntegration

Day 19. I just realised the post i put up yesterday did not show up, so this is just a re-post. Using multiple tables, lets highlight sales by the various access channels used by Parch and Posey paper company. Lets gooooo!!! You can use the hashtags #20dayswithdata #SQLJoinAggregations #DataIntegration