🚀 Day 40 of My Data Analytics Journey !

Today was a mix of SQL clarifications and Power BI exploration. I’m slowly connecting the dots between data storage and visualization.

🟢 SQL Learnings:

• Local vs Global Variables → Understood how scope works in SQL for query execution.
• Composite Key → Learned how multiple columns together can act as a unique key in relational databases.

🔵 Power BI Learnings:

From my handwritten notes today 📒, I explored:

• Measures → How to generate and use them effectively.
• RankX → Expression to rank data based on filters.
• Date Table → Creating a calendar table using CALENDAR() and adding columns like Year, Month, etc.
• KPI → Learned that sample KPIs are already available, useful for yearly reports.
• Variables in DAX → Using them improves performance and makes queries readable.
• Data Shaping & Modeling → Key step before visualization.
• Publishing Reports → Explored Microsoft login usage for publishing dashboards.

⚡ Optimization Insight:

• Optimizing model performance is crucial for handling large datasets.
• DAX Studio helps in debugging and checking performance.

---

📊 Each day, I feel my foundation in SQL + Power BI is getting stronger. Excited to dive deeper into DAX queries and performance tuning next! 🚀

#DataAnalytics #SQL #PowerBI #DAX #LearningJourney