This content originally appeared on DEV Community and was authored by Ramya .C
Today, I explored a mix of SQL and Power BI concepts. Let me break down what I learned:
🔹 SQL Concepts
- AUTO INCREMENT → Automatically generates unique IDs for new rows.
- ADD COLUMN → Helps in adding new fields to an existing table without rewriting it.
- REMOVE ROWS & REMOVE DUPLICATES → Essential for cleaning messy datasets.
🔹 Power BI Concepts
- Data Modeling → Building relationships between tables to analyze data effectively.
- Link Table → Used to connect datasets and establish many-to-many relationships.
- DAX (Data Analysis Expressions) → Learned how to use formulas, constants, and expressions for advanced calculations.
- Data Calculator Table → Creating calculated tables for additional insights.
- RANK & DENSE RANK → Functions that help order data and handle ties differently.
🔹 Practice Dataset
I also worked with a Restaurants dataset to apply these concepts practically. It really helped me see how data cleaning, modeling, and ranking functions come together in real-world scenarios.
💡 Each day, I feel one step closer to becoming a professional Data Analyst.
Consistency and practice are making the concepts more natural 🚀
📌 Follow my journey as I continue learning Data Analytics step by step!
#DataAnalytics #SQL #PowerBI #DAX #LearningJourney
This content originally appeared on DEV Community and was authored by Ramya .C
Ramya .C | Sciencx (2025-09-18T14:26:38+00:00) 🚀 Day 39 of My Data Analytics Journey !. Retrieved from https://www.scien.cx/2025/09/18/%f0%9f%9a%80-day-39-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.