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

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

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.

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

Day 19: Combining JOINs and Aggregation @hertechtrail @phaibooboo @AtiJoshua @vicSomadina #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration

was used by client by using the condition of any channel that was used more than hundred thousand times is high performing channel. #20dayswithdata #hertechtrailacademy #HTTDataChallenge #SQLJoinAggregations #DataIntegration @hertechtrail @phaibooboo @vicSomadina @ImaNjokko