Aditi Shaktawat | Data Analytics

Turned yesterday's dynamic array backend into a fully automated Department KPI Dashboard Engineered features: • Performance drift via conditional data bars • Dynamic median & female representation ratios • Complete schema scaling—zero hardcoding Next: Pivot Tables🔥💻 #Excel

@MrCharlesky Interested

Are you still a student or graduate? You can now earn $16 - $25/hr by completing simple tasks like image labelling, bounding box annotation or basic transcription... Open to everyone! If you applied 4 days ago, check your email. They're still accepting applications.

@Microsoft365 Appreciate the validation! Just deployed scatter plot matrices to visually segment high-value accounts from operational time-wasters. 🚀 To align with Microsoft’s enterprise vision—what’s the #1 data modeling feature in the 365 ecosystem I should integrate into my next sprint?

@as02774 Now that's impressive 🙌

Day 37/60: 🚀 Built an automated HR data engine using Excel Dynamic Arrays. 7 sheets of clean logic: • Dynamic arrays SORT(FILTER()) • Multi-criteria: Boolean * • Smart vectors: XLOOKUP & # Zero legacy formulas. Workbook & documentation live on GitHub! 💻 #Excel #DataAnalyst

Day 40/60: Stop using Excel just for simple tables. 🛑📊 Mapped Call Centre pivot data onto a Scatter Plot matrix today. Instantly segmented "High-Value" accounts from the "Time-Wasters".📈 Real analytics isn't summarizing data—it's driving action. 🚀 #BuildInPublic #Excel

@Microsoft365 Appreciate the nod, team! 🤝 Took those dynamic arrays a step further today and engineered a full department KPI reporting dashboard using the exact same logic.Pushing the limits of the modern Excel engine! 🚀

@as02774 Nicely done 👏

Check out the full M-code and documentation on my GitHub repository here: github.com/aditishaktawat…

Just built a live Olympic data scraping engine in Power Query! 🏅 • Fixed messy HTML row-spans via Table.FillUp • Blocked double-counting by filtering summary rows • Engineered a custom Weighted Performance Index Clean, automated, and ready for a dashboard. 📊🚀 #Excel

Day 35/60: 🚀 Today, I dove deep into Power Query to build an automated ETL pipeline for cleaning unstructured staff datasets. Cleaned text strings, enforced strict data types, and eliminated nulls. Moving away from manual cleaning to reproducible workflows! 📈 #PowerQuery #Data

Day 33-34/60: Back to the core architecture⚙️ SQL: Refreshed core SQL logic—ensuring base aggregations are airtight before scaling to complex CTEs.🛠️ Excel: Rule #1: The mouse is a liability. Mastered mouse-free navigation. Speed is a technical asset🚀 #SQL #Excel

Back to the data logic after a strategic reset. Reviving the SQL muscle memory on @DataLemurHQ today. The goal isn't just to get the 'green checkmark'—it's to write logic that scales in a production environment. #SQL #DataLemur #Resilence

While recovering, I moved beyond just solving SQL syntax.🧠 Instead of O(N) full table scans using EXTRACT(), I'm engineering for SARGability and O(log N) Index Range Scans. Next stop: Excel Mastery & building my first Analytical Syntax Vault.📊 #SQL #DataAnalytics #60DaySprint

Data isn't linear, and neither is progress. 📈 Last posted May 3. Today is May 8. I hit a wall with my health— an unplanned pitstop in my 60-day sprint. Setbacks aren't failures; they are recalibrations. Recovery is complete and the sprint resumes now. 🚀 #Resilience

Day 27/60: Recharged & Pivoting 📊 Took a 2-day offline breather to recover. Sometimes the best debugger is just rest! 🔋 Wrapped up SQL Views. Now, starting the Excel phase—but treating it as a relational data engine, not a calculator. 🚀 #SQL #Excel #BuildInPublic

Day 24/60: The Statistical Side of SQL 📊 Moved from raw ranks to true business percentiles today by mastering statistical Window Functions: ✅ NTILE (Data Bucketing/Quartiles) ✅ CUME_DIST ✅ PERCENT_RANK Window Functions are officially in the bag! #DataAnalytics #SQL

Day 23/60: The Surgical Side of SQL 🎯 Closed the loop on Window Functions today: ✅ FIRST_VALUE / LAST_VALUE ✅ NTH_VALUE ✅ Window Frames (ROWS BETWEEN) Sliding windows for moving averages isn't just code—it’s business intelligence. 🚀 #DataAnalytics #SQL #BuildInPublic

Day 21-22/60: Recalibrating 📉 Motivation is a feeling, but discipline is a system. Back in the sprint and mastered Advanced SQL: ✅ RANK/DENSE_RANK (Ranking logic) ✅ LEAD/LAG (Trend analysis) ✅ ROW_NUMBER Catching up to Day 23 tonight! ⚡ #DataAnalytics #SQL #WomenInTech

Day 20: Graduated from nested sub queries to CTEs (WITH clause). 📈 Resolved "Above Average Sales" query with cleaner code and added Buisness Insights to the logic. It's not just about the query; it's about retention and growth. 💼 #DataAnalytics #SQL # BuildInPublic

Day 19: Went deep into the "Inception" of SQL. 🌀 Practiced subqueries across SELECT, FROM, & HAVING. Learned exactly which commands allow nested logic thanks to @techTFQ Realized logic flow > syntax. Pushed the code to GitHub to keep the momentum alive. 💻 #SQL #60DaysofCode

Day 18: Entering the 'Inception' phase of SQL. 🌀 Learned Subqueries today. Also committed to a new habit: Refactoring one old query daily with fresh business insights. Technical growth is a marathon, not a sprint. 🚀 #DataAnalytics #SQL #BuildInPublic