๐๐๐ ๐๐๐ ๐ฏ ๐๏ฟฝ๏ฟฝ๏ฟฝ๏ฟฝ ๐๐๐ฉ๐ ๐๐ง๐ ๐๐๐๐ค๐ข๐๐ฃ๐ ๐ฐ.
Data Analytics.
Data Science.
Data Engineering.
Analytics Engineering.
As AI makes data consumption easier, I believe building reliable data systems becomes increasingly valuable.
Iโm betting on Data Engineering and Analytics Engineering.
Hereโs why.
#Datafam #AnalyticsEngineering
๐๐๐๐ฉ ๐ฉ๐๐ ๐๐๐จ๐จ๐ ๐ซ๐จ ๐๐ค๐ฃ๐๐ก๐๐ค ๐๐๐๐๐ฉ๐ ๐ฉ๐๐๐๐๐๐จ ๐ช๐จ ๐๐๐ค๐ช๐ฉ ๐๐๐ฉ๐ ๐๐ฃ๐๐ก๐ฎ๐ฉ๐๐๐จ.
Total goals vs. goals per game.
Total goal contributions vs. G/A per 90.
Same players, different metrics, different conclusions.
Numbers without context can be misleading, even when theyโre correct.
And yes, Iโm still picking Messi.
#Datafam #Data
Funny how the project that helped me land my first data analyst job was about The Real Housewives of Lagos. ๐
I analysed over 170K tweets, built a Power BI dashboard and shared it online.
And when I started going for interviews, this was what they wanted to talk about. Not my certificates. ๐
Donโt just build projects because everyone else is building them. Find something youโre genuinely interested in and explore it.
#DataAnalytics #PowerBI #DataAnalyst
"๐ ๐๐ค๐ช๐ก๐ ๐ฃ๐๐ซ๐๐ง ๐๐ช๐๐ก๐ ๐ฉ๐๐๐ฉ."
that is what most people think when they see work like this.
here is the part you don't see. the students who built these dashboards said the same thing before they started.
what they had on day one was a question they couldn't answer yet. that's all. then came the weeks of showing up, getting it wrong, and fixing it until the numbers told the truth.
๐ฉ๐๐ ๐๐๐ฅ ๐ฌ๐๐จ ๐ฃ๐๐ซ๐๐ง ๐ฉ๐๐ก๐๐ฃ๐ฉ. ๐๐ฉ ๐ฌ๐๐จ ๐ ๐จ๐ฉ๐๐ง๐ฉ ๐๐๐ฉ๐.
cohort 10 has two.
ai-powered data analytics starts saturday 5 december. โฆ89,999 / $89.99
register: https://t.co/nJ8pDJEc6e
analytics engineering starts friday 20 november. โฆ150,000 / $150
register: https://t.co/kFln0Sj4cm
#Datafam
๐ฟ๐๐ฉ๐ ๐๐ฃ๐๐ก๐ฎ๐จ๐๐จ ๐๐๐ฃ ๐๐๐ฉ๐ช๐๐ก๐ก๐ฎ ๐๐ ๐๐ช๐ฃ!
Hereโs a walkthrough of our final Power BI project with DWD Cohort 9.
From understanding the business problem to building an interactive dashboard that tells a story.
Did we cook? Let me know what you think.
#Datafam #PowerBi
The power BI section of cohort 9 has been purely value packed in all rounds.
To be frank, I didn't paid close attention to my tool(power BI) throughout the classes because knowledge comes first.
But when I eventually touch the tool, it will rain fire works.
๐ข๐๐ง๐๐ช๐จ ๐๐๐จ ๐ฉ๐๐ง๐๐ ๐ค๐ฃ-๐ฉ๐๐ข๐ ๐ง๐๐ฅ๐ค๐ง๐ฉ๐จ ๐๐ฃ๐ ๐ฉ๐๐ง๐๐ ๐๐๐๐๐๐ง๐๐ฃ๐ฉ ๐ฃ๐ช๐ข๐๐๐ง๐จ.
he runs operations at harborline distribution, a fictional company from our cohort 9 guided project. his monthly average hasn't moved in three years. his store managers insist deliveries are getting worse.
someone is wrong. our students had to find out who.
first they had to clean the data: three yearly files, shaped like real erp extracts. the nastiest problem raised no error. one supplier wrote dates day first, and 274 of them converted to the wrong date without a word. a received date can't come before the order date. that one rule caught them.
then the average. by year, on-time was 84.0%, 83.6% and 82.7%. nothing to see. by month, january to october ran at 86.7%, november at 73.1% and december at 64.3%, every year.
transit stayed at 2.5 days. warehouse dispatch went from 1.38 days to 1.84. the delay was never on the road.
fixing the warehouse in peak season is worth three times more than fixing the two failing carrier lanes.
๐ฉ๐๐ ๐จ๐ฉ๐ค๐ง๐๐จ ๐ฌ๐๐ง๐๐ฃ'๐ฉ ๐ฌ๐ง๐ค๐ฃ๐, ๐๐ฃ๐ ๐ฃ๐๐๐ฉ๐๐๐ง ๐ฌ๐๐จ ๐ฉ๐๐ ๐๐ซ๐๐ง๐๐๐. ๐ฉ๐๐ ๐๐ซ๐๐ง๐๐๐ ๐๐ช๐จ๐ฉ ๐๐ค๐ช๐ก๐๐ฃ'๐ฉ ๐จ๐๐ ๐ฃ๐ค๐ซ๐๐ข๐๐๐ง.
we built it with ai, on dummy data, on purpose. the ai read the model's structure, wrote and tested the measures, and checked results with read-only queries. it never touched a real company's data, because there wasn't one.
then we did what you would do for a client, with a second dummy dataset standing in. we repointed one folder path and refreshed. on-time moved from 70.4% to 83.4%, every title and alert rewrote itself, and a dataset with nothing to find became the story above. for a real client the rule is the same, with one addition: close the ai connection before their data goes in.
every title on the dashboard states a finding and rewrites itself when the data changes. open it and click around:
https://t.co/HMPft8Eca1
๐ฌ๐๐ฃ๐ฉ ๐ฉ๐ค ๐ก๐๐๐ง๐ฃ ๐ฉ๐ค ๐๐ช๐๐ก๐ ๐ฉ๐๐๐จ?
new to data? ai-powered data analytics starts 5 december. โฆ89,999 / $89.99. practical projects like this one.
register: https://t.co/nJ8pDJEJVM
already write sql and python? analytics engineering starts friday 20 november. โฆ150,000 / $150. you build the pipeline that feeds a dashboard like this.
register: https://t.co/kFln0SjC1U
#Datafam #Powerbi
8 Laws of Harvest - Apostle Michael Orokpo, PhD.
(Full Message Title: Laws of Harvest)
For the full sermon, download The Encounter Jesus App on Google Play Store
Weโre about to kick off our Python series as we gradually wrap up Cohort 9.
But before then, weโre working on one more Power BI project.
The data model is ready. The dashboard wireframes are done. Now itโs time to bring everything to life.
๐ ๐ผ๐ฑ๐ฒ๐น๐น๐ถ๐ป๐ด ๐ฎ๐ป๐ฑ ๐๐ถ๐ฟ๐ฒ๐ณ๐ฟ๐ฎ๐บ๐ถ๐ป๐ด ๐ฐ๐ผ๐บ๐ฝ๐น๐ฒ๐๐ฒ๐ฑ. ๐๐ถ๐ป๐ฎ๐น ๐ฟ๐ฒ๐๐๐น๐๐ ๐ฐ๐ผ๐บ๐ถ๐ป๐ด ๐๐ผ๐ผ๐ป.
And if youโve been following what weโre building at Data With Danny, registrations for Cohort 10 are currently open.
Whether youโre starting with Data Analytics or advancing into Analytics Engineering, thereโs a programme for you.
Send me a DM if youโre interested.
#Datafam
๐ฌ๐๐๐ฉ ๐๐๐ฃ ๐ฎ๐ค๐ช ๐๐๐ฉ๐ช๐๐ก๐ก๐ฎ ๐๐ช๐๐ก๐ ๐๐๐ฉ๐๐ง ๐ ๏ฟฝ๏ฟฝ๐๐ฌ ๐ข๐ค๐ฃ๐ฉ๐๐จ ๐ค๐ ๐ก๐๐๐ง๐ฃ๐๐ฃ๐ ๐๐๐ฉ๐?
not another certificate or another list of tools on your cv. something you can open, explain and defend.
first image: a logistics analytics dashboard built by one of our students in a previous programme.
three pages. shipment performance, carrier operations, delivery costs, warehouse performance, operational issues.
what matters is the thinking behind it. why do some carriers perform better than others? where do shipments get delayed or lost? what should management investigate first?
second image: reviews from people who've been through our training.
one student was sceptical before enrolling. two months in, she said she'd already had her money's worth, and the training wasn't over.
another made the point i keep repeating:
๐ ๐ฃ๐ค๐ฌ๐๐ฃ๐ ๐๐ญ๐๐๐ก, ๐จ๐ฆ๐ก ๐ค๐ง ๐ฅ๐ค๐ฌ๐๐ง ๐๐ ๐๐ค๐๐จ๐ฃ'๐ฉ ๐๐ช๐ฉ๐ค๐ข๐๐ฉ๐๐๐๐ก๐ก๐ฎ ๐ข๐๐๐ฃ ๐ฎ๐ค๐ช ๐๐๐ฃ ๐ฌ๐ค๐ง๐ ๐๐จ ๐ ๐๐๐ฉ๐ ๐๐ฃ๐๐ก๐ฎ๐จ๐ฉ ๐๐ฃ ๐ ๐ง๐๐๐ก ๐๐ช๐จ๐๐ฃ๐๐จ๐จ.
you have to understand the problem, ask better questions, validate your results and explain what the numbers mean.
after 8 cohorts and 500+ graduates, cohort 10 opens with two programmes.
ai-powered data analytics, if you're new to data.
starts 5 december 2026. 4 months. โฆ89,999 / $89.99
register: https://t.co/nJ8pDJEc6e
analytics engineering, if you already know sql and python.
databricks, delta lake, dbt, github actions and power bi, with an end-to-end project.
starts 20 november 2026. 22 weeks, 66 live sessions. โฆ150,000 / $150
admission includes a technical assessment, so register before 20 november.
register: https://t.co/kFln0Sj4cm
i want you to be able to explain your work and defend your decisions. that's the standard.
๐๐ค๐๐ค๐ง๐ฉ ๐ญ๐ฌ ๐ง๐๐๐๐จ๐ฉ๐ง๐๐ฉ๐๐ค๐ฃ ๏ฟฝ๏ฟฝ๐จ ๐ค๐ฅ๐๐ฃ.
not sure where to start? dm me and i'll help you choose.
#Datafam
Where You're Standing Matters - Apostle Michael Orokpo, PhD.
(Full Message Title: Capacity Building)
For the full sermon, download The Encounter Jesus App on Google Play Store
The Power of Wealth and Resources - Apostle Michael Orokpo, PhD.
(Full Message Title: Capacity Building)
For the full sermon, download The Encounter Jesus App on Google Play Store
@iam_daniiell Your Excel function(s) knowledge is transferable when it comes to writing DAX in Power BI.
As you can see every function in the DAX can be found in Excel.
For the Format it's Text in Excel while Quarter is coded like this: ="Q"&ROUNDUP(MONTH(A2)/3,0) in Excel.
Day 3 of Learning SQL๐ป
Today, I learnt how to create tables in MySQL and understand their structures.
Hereโs what I covered:
- What tables are and how they organise data.
- How to use CREATE TABLE.
- Understanding SQL data types: INT, VARCHAR, CHAR, DATE, DECIMAL and FLOAT.
- How to use SHOW TABLES to view tables.
- How to use DESCRIBE to inspect table structures.
- How to use SHOW COLUMNS to view table columns.
I also learnt that a database can contain multiple tables
#30DaysOfSQL #LearningSQL #DataAnalytics