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

Eliminating underperforming channels and redirecting resources to high-performing ones. #hertechtrailacademy #HTTDataChallenge #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: 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

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: Combining Joins and Aggregation 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