🚀 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.

Co…


This content originally appeared on DEV Community and was authored by Ramya .C

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


This content originally appeared on DEV Community and was authored by Ramya .C


Print Share Comment Cite Upload Translate Updates
APA

Ramya .C | Sciencx (2025-09-21T03:16:41+00:00) 🚀 Day 40 of My Data Analytics Journey !. Retrieved from https://www.scien.cx/2025/09/21/%f0%9f%9a%80-day-40-of-my-data-analytics-journey/

MLA
" » 🚀 Day 40 of My Data Analytics Journey !." Ramya .C | Sciencx - Sunday September 21, 2025, https://www.scien.cx/2025/09/21/%f0%9f%9a%80-day-40-of-my-data-analytics-journey/
HARVARD
Ramya .C | Sciencx Sunday September 21, 2025 » 🚀 Day 40 of My Data Analytics Journey !., viewed ,<https://www.scien.cx/2025/09/21/%f0%9f%9a%80-day-40-of-my-data-analytics-journey/>
VANCOUVER
Ramya .C | Sciencx - » 🚀 Day 40 of My Data Analytics Journey !. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2025/09/21/%f0%9f%9a%80-day-40-of-my-data-analytics-journey/
CHICAGO
" » 🚀 Day 40 of My Data Analytics Journey !." Ramya .C | Sciencx - Accessed . https://www.scien.cx/2025/09/21/%f0%9f%9a%80-day-40-of-my-data-analytics-journey/
IEEE
" » 🚀 Day 40 of My Data Analytics Journey !." Ramya .C | Sciencx [Online]. Available: https://www.scien.cx/2025/09/21/%f0%9f%9a%80-day-40-of-my-data-analytics-journey/. [Accessed: ]
rf:citation
» 🚀 Day 40 of My Data Analytics Journey ! | Ramya .C | Sciencx | https://www.scien.cx/2025/09/21/%f0%9f%9a%80-day-40-of-my-data-analytics-journey/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts