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
Top comments (0)