Filter
Exclude
Time range
-
Near
Everything looks like a priority until you move the benchmark 14/15 #HTTDataChallenge#FMCGNigeria #SQLAggregations #PostgreSQL
1
4
18
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
2
3
17
Day 13 of @hertechtrail #HTTDataChallenge task: find customers who have made orders above the average order value. @phaibooboo @it_is_reel @precy_oma @Ogbonna42449096 @AtiJoshua #SQLSubqueries #DataAnalysis
3
3
40
Day 12 of the @hertechtrail @HTTDataChallenge task is to calculate total sales and average order value by region using SUM(), AVG(), COUNT() and chained JOINs across 4 tables. N/B I used ROUND() on your AVG() to reduce my decimal places. #SQLAggregation #DataAnalytics
2
5
30
Precision > Volume Today's focus: SQL Aggregations Used SUM and AVG to rank revenue generators. Identifying the primary accounts helps to prioritize resources effectively. Day 12 of #HTTDataChallenge#FMCGNigeria #DataAnalytics #SQL
2
18
Day 10 of the @hertechtrail #HTTDataChallenge is to join two tables and retrieve 3 columns each from them I joined accounts and orders table, and retrieved 3 columns each using SQL query. #SQLJoining #DataIntegration
2
25
If you can't link customers to revenue, you're flying blind. Today: Data Integration using SQL JOINS to bridge the 'Accounts' & 'Orders' tables. Result: 6,912 transactions mapped to names/POCs. Day11 of #HTTDataChallenge @hertechtrail #FMCGNigeria #SQL #DataAnalysis
4
6
54
Day 10 of the @hertechtrail #HTTDataChallenge was to retrieve customer names in alphabetical order using SQL query. SELECT name (retrieves only the name column) FROM accounts (your customer names are in the accounts table) ORDER BY & ASC (sorts in ascending order ) #SQLQuery
1
1
32
If the team can't find data quickly, you are losing money. Day 10 of #HTTDataChallenge: Using SQL to automate the order of the accounts table. No more manual sorting; just clean, searchable results ready for the next business move. #SQLSorting #DataManipulation #FMCGNigeria
4
32
I’m early today😂🤭 Day 9 of the @hertechtrail #HTTDataChallenge task is to retrieve all column from any specific table I used the commands SELECT * FROM region; Result = 4 rows and 2 columns SELECT * FROM accounts; Result = 351 rows and 7 columns #SQLQuery #SQLBasics
1
4
22
A busy manager shouldn't have to "study" a chart to find the answer. For Day 8, I highlighted the top performer: Skechers. Instead of a cluttered graph, I used a clean bar chart to tell the story. Clarity over clutter, every time. #HTTDataChallenge #FMCG #SalesAnalysis
4
7
62
Day 8 of the @hertechtrail #HTTDataChallenge and today’s task is to create a bar chart showing brand sales distribution on a shoes dataset. From the chart you can see that: Sketcher got $269,169 New Balance $261,632 Adidas $257,039 Reebok $238,827 Puma $233,750 Nike $192,770 👇🏾
4
8
51
Day 7 of @hertechtrail #HTTDataChallenge and today’s task is data validation(making sure that only valid entries make it into the dataset. I made use of the brand column which only accepts 6 approved brands: Adidas, New Balance, Nike, Puma, Reebok & Sketchers. 👇🏾#DataValidation
1
3
21
Sales over the year are inconsistent,with clear peaks in months like February, July, and October, while months like May and August show lower performance.This shows sales are influenced by timing or seasonal demand rather than steady growth.#HTTDataChallenge #hertechtrailacademy
1
2
9
Yesterday was Day 6 of the @hertechtrail #HTTDataChallenge (I missed 🫠) I analyzed sales trend overtime of the shoe data set. This is what stood out for me: -Q4 is the strongest quarter at $404k -Q3 is the weakest (August and September went too low) 👇🏾👇🏾 #DataAnalysis
2
3
14
Building on "the what", I dove into the "why“ for Day 6. • Q3 Revenue dip: Needs mid-quarter restocking. • Nike: Low volume, top-tier revenue. • Online: High efficiency. • UAE: Market leader. Findings & Solutions in the screenshot #HTTDataChallenge #RetailAnalysis
1
5
56
Omo, Day 5 of the #HTTDataChallenge tried to be funny with me today 😂 It was a bit of a challenge getting 3 different pivot tables stay consistent while slicing data. But the clarity at the end? Worth it. Revenue and Units analyzed. We move🥳🥳 #PivotTables #DataAnalysis
1
6
47
Day 4 #HTTDataChallenge: I had to put in a bit of analytics here. Set a $3k benchmark to find the hidden driving force of the total revenue. It's one thing to see numbers, it's another to see the story they're telling. #DataAnalytics #LagosTech #WomenInTech
3
7
97
Day 3 of the #HTTDataChallenge @hertechtrail was all about using Excel formulas to to calculate: 
Total Sales using =SUM(Revenue_USD)
Found Average Order Value using =AVERAGE(Revenue_USD)
Also calculated Total Units Sold using =SUM(Units_Sold) #HerTechTrailAcademy #Excel
2
5
40
Day 3 #HTTDataChallenge Moving past the cleaning phase guys🙌🏼 Transitioned from data cleaning to business metrics today ✅ Calculated Total Sales & AOV 💡Key takeaway: AOV reveals the story behind sales growth #DataAnalysis #ExcelFormulas #WomenInTech
2
8
78