That Data Analytics Guy

I was introduced to data analysis mid last year, and in December I decided to fully commit to the journey. It hasn’t been easy, but I’m taking it one step at a time. I created this account to document every stage of my learning journey—serving as a journal, a future portfolio

@Johnsontaiwo_ @techiehub_28 I’m doing that I don’t know it is not going through

@DataOb4321 @techiehub_28 Send a DM.

If you're a Data Analyst, Operations Analyst, or aspiring Supply Chain & Logistics Analyst who wants to move from reporting dashboards to driving real supply chain decisions, read this: Dashboards are not enough. Modern supply chain teams promote analysts who can: • Forecast demand under uncertainty • Optimise inventory and release working capital • Model cost-to-serve and margin impact • Quantify supplier and operational risk • Simulate stockouts and lost-sales exposure • Design efficient distribution and network flows Most analysts track KPIs. Very few understand capital and operational impact. So I built the >>Supply Chain Capital Intelligence Blueprint << to move you from metric reporting to operational decision intelligence. A system with two parts: >>1. Supply Chain & Capital Intelligence Framework Learn how real supply chains actually operate: • Working capital & inventory optimisation • Cost-to-serve and margin dynamics • Supplier & concentration risk • Multi-echelon inventory logic • Transport cost volatility • Network design and expansion strategy • Executive operational communication >>>2. The 12-Week Practical Supply Chain Analytics Roadmap Build 10 real-world projects: • Inventory optimisation (capital-focused) • Cost-to-serve modelling • Stockout and lost-sales simulation • Supplier risk analysis • Network optimisation • Demand variability modelling • Capacity and fulfilment analysis • Capital allocation modelling • Service level vs cost trade-offs • Operational KPI system (decision-focused) This is not decorative analytics. This is institutional-level operational intelligence. If you want the roadmap: ➡️Like ➡️Repost ➡️Comment ROADMAP ➡️send me a DM, I’ll share it

@Olabode_designs 😒😒😒

Single ❌ Taken ❌ God please answer my prayers ✅

@fabiolauria92 I think that would be consistency . It will make every process of a journey look seamlessly and you will definitely evolve even it is the minimum everyday it will result into a big impact.

Welcome back! 🎯 The real test begins when initial momentum fades. After working with 25,000+ community members, I've learned that consistency outperforms intensity. Businesses extracting genuine value from their data show up daily, not just during sprints. What was your biggest takeaway from the thirty days?

Good morning, everyone, Although I’ve completed the 30-day challenge, I haven’t been very active recently because I had an important matter to attend to. Now that it’s resolved, I’m fully back. Finishing the challenge doesn’t change my commitment to posting—

While it may not be every single day, you can definitely expect to see more projects across all the tools. I’m also open and excited to collaborate on anything that will help me grow and sharpen my skills in this space. Happy new month! 🚀

Day 30 - Online store analysis Today I worked on analysing a retail store dataset using SQL. Here’s what I focused on: ✅ Identified top-selling products ✅ Analysed total revenue by category ✅ Tracked monthly sales trends ✅ Found high-value customers

@Olabode_designs Amen my bro

I just secured a $10K gig 🎉🎉🎉 Yes, that will be me soon …I’ll be back to quote this 🫰

I used column profiling (Valid / Error / Empty ) to check data quality and ensure clean transformation before loading to the model Power Query is not just about importing data it’s about shaping it correctly before visualization or SQL modeling. #DataAnalytics #PowerQuery

Land Value & Building Value – Property valuation breakdown Sale Date & Sale Price – Transaction data Property Address & Owner Name – Ownership details Tax District & Land Use – Property classification

Day 29 - Data Cleaning in Power Query Nashville Housing Dataset Today I worked on transforming the Nashville Housing dataset inside Power Query Editor and focused on proper data preparation before analysis. Here’s what I did:

#SQL #DataAnalytics #WindowFunctions #MySQL #100DaysOfCode

Day 28 - Lead & Lag oday I practiced LEAD() and LAG() window functions in MySQL 💻 ✅ LEAD() → Looks at the next row’s value ✅ LAG() → Looks at the previous row’s value ✅ Used ORDER BY InvoiceDate to track invoice trends

Day 27 - SQL Contd Today I worked on the final part of analyzing a music store database using SQL 🎧 ✅ List Employees and the Customers They Support ✅ Find Customers Who Haven’t Made Any Invoice Yet Every query brings me closer to mastering SQL 💪 #SQL #DataAnalytics

Day 26 - SQL JOIN One way to master any function is to practice it constantly. Some of the tasks I worked on – Connected tables using JOIN – Retrieved customer names – Pulled track names with their genres – Filtered records using conditions Repetition builds confidence. #SQL

JOIN allows us to combine rows from multiple tables based on a related column. This is how databases reflect real-world relationships. #SQL #DataAnalytics #LearnWithMe

Day 25 - SQL Join In the real world, data doesn’t live in just one table. -Customer details might be in one table. -Orders in another. -Payments in a different one. To analyze relationships between them, we use JOIN in SQL.

✅ Defined data types like INT and VARCHAR() ✅ Inserted multiple records using INSERT INTO ✅ Updated records using UPDATE + WHERE I also learned why the WHERE clause is important — it prevents updating every row accidentally 👀 #SQL #MySQL #DataAnalytics #LearningInPublic

Day 24 - Building a database Today I built my own database from scratch using MySQL Workbench Here’s what I practiced: ✅ Created a new database (CREATE DATABASE Bode_store;) ✅ Used USE to select the database ✅ Created tables with PRIMARY KEY