🚀Day 45 of Data analytics journey!

Today I explored and practiced the following in Power BI & Data Modeling:

• 🔧 Fixed Power BI Map Visual Issue
  (Solution: Chrome → Power BI Admin Portal → Tenant Settings → Integration Settings → Enable)

• 📊 Dimension Modeling

  • Fact Table → Stores measurable business data (sales, revenue, etc.)
  • Dimension Table → Stores descriptive attributes (customer, product, time, etc.)
  • Attributes → Properties that describe dimensions (customer name, product category, etc.)

• 🌟 Schema Types

  • Star Schema → Fact table connected directly to dimensions (simple & fast).
  • Snowflake Schema → Dimensions further normalized into sub-dimensions (complex but reduces redundancy).

• 🗂 Conceptual Model
  
  → High-level design that shows entities, relationships, and flow of business data.

• 🌍 Geo Data
  
  → Data that contains location info (like country, state, city) used for map visuals.

• ➕ Create New Table
  
  → Done using Modeling > New Table in Power BI (with DAX formula).

• ⚡ X Language (DAX)
  
  → Data Analysis Expressions, a formula language in Power BI for creating measures, calculated columns, and tables.

PowerBI #DataAnalytics #Day45