Hello everyone,
Our dear friend and brother recently answered the call of his creator and we’re seeking funds to set up a charity project in his name.
Please like, retweet, and/or donate.
DONATE HERE:
https://t.co/52KSh8L1NR
OR
9325666832
MUBARAQMEMORI/QUADRISAHEED
WEMA BANK
@Olawaleonline@AsakyGRN "there is absolutely nothing wrong with her Nigerian look"
May they deport you so you'll come back and look like her Nigerian look
𝗧𝗵𝗶𝘀 𝗶𝘀 𝗺𝘆 𝗳𝗶𝗿𝘀𝘁 𝗣𝗼𝘄𝗲𝗿 𝗕𝗜 𝗽𝗿𝗼𝗷𝗲𝗰𝘁.
The dashboard on the right was built by one of my students.
Month four.
First structured data program they ever took.
Let that sink in.
At Data with Danny we do not just teach tools.
We set a standard and pull people up to it.
Our floor is most people’s ceiling.
And we are evolving.
AI-powered analytics is now built into the curriculum.
Not as a bonus.
Not as an afterthought.
But as part of how modern data professionals actually work.
The good news:
You can start for half the price.
Two installments.
Same program. Same standard.
No excuse left to wait.
𝗖𝗼𝗵𝗼𝗿𝘁 𝟵 𝘀𝘁𝗮𝗿𝘁𝘀 𝗝𝘂𝗻𝗲 𝟮𝟱𝘁𝗵.
Drop a comment.
What is the one data skill you wish you had right now?
https://t.co/CuWAr3lKo1
Or DM me.
#Datafam
𝗙𝗼𝘂𝗿 𝘀𝗲𝗻𝗶𝗼𝗿 𝘀𝘁𝗮𝗸𝗲𝗵𝗼𝗹𝗱𝗲𝗿𝘀.
𝗙𝗼𝘂𝗿 𝗱𝗶𝗳𝗳𝗲𝗿𝗲𝗻𝘁 𝘁𝗵𝗲𝗼𝗿𝗶𝗲𝘀.
𝗭𝗲𝗿𝗼 𝗼𝗳 𝘁𝗵𝗲𝗺 𝗵𝗮𝗱 𝗹𝗼𝗼𝗸𝗲𝗱 𝗮𝘁 𝘁𝗵𝗲 𝗱𝗮𝘁𝗮.
A company had a EUR 4.2 million contract on the line.
Their largest client filed a formal SLA breach notice.
62% on-time delivery rate against a contractual threshold of 85%.
Two consecutive quarters to fix it or lose the contract permanently.
This was the brief handed to Cohort 8.
Here is what the data actually said.
Amsterdam and Warsaw warehouses were running stock issue rates of 24-25%.
Berlin was at 6.3%.
When stock was not ready at dispatch, on-time delivery dropped from 74.5% to 47.4%.
One binary variable.
27 percentage points.
Van drivers assigned to cross-border routes were running at 41% on-time.
HGVs on domestic routes were running at 84.8%.
The vehicles existed.
The assignment logic was wrong.
Hartwell Group’s 62% on-time rate was not a client problem.
Every one of their 3,389 shipments ran through Amsterdam warehouse on a single cross-border route.
Fix Amsterdam and Hartwell recovers without a single client-specific intervention.
The Finance Director said it was a prioritisation problem.
The data disagreed.
Critical tier shipments were still 9.3 points below the contractual threshold.
That theory does not hold.
𝗧𝗵𝗲 𝗱𝗮𝘁𝗮 𝗽𝗼𝗶𝗻𝘁𝗲𝗱 𝗮𝘁 𝘁𝘄𝗼 𝘄𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗲𝘀 𝗮𝗻𝗱 𝗼𝗻𝗲 𝘀𝗰𝗵𝗲𝗱𝘂𝗹𝗶𝗻𝗴 𝗱𝗲𝗰𝗶𝘀𝗶𝗼𝗻.
Not drivers.
Not pricing.
Not city pairs.
Two warehouses.
One operational decision.
This is what Cohort 8 built.
A full SQL analytics investigation across six deliverables, six production-style Views, a star schema data model, and a prescriptive executive summary the COO could act on immediately.
Full project, SQL code, and executive summary on GitHub.
https://t.co/9KnqUd2c09
𝗧𝗵𝗶𝘀 𝗶𝘀 𝘁𝗵𝗲 𝘀𝘁𝗮𝗻𝗱𝗮𝗿𝗱 𝘄𝗲 𝗯𝘂𝗶𝗹𝗱 𝘁𝗼 𝗶𝗻𝘀𝗶𝗱𝗲 𝗗𝗮𝘁𝗮 𝘄𝗶𝘁𝗵 𝗗𝗮𝗻𝗻𝘆.
Cohort 9 starts June 25th.
https://t.co/CuWAr3midz
Or DM me.
#Datafam #SQL