Data Modelling in Power Bi

Short summary

Power BI is Microsoft's analytics platform with Desktop, Service, and Mobile components for data work. Data modeling organizes table relationships (one-to-many, one-to-one, many-to-many) using Star or Snowflake schemas for optimized reporting. DAX functions like SUM, AVERAGE, and RANKX enable calculations and measures for analysis.

• •Power BI has three components: Desktop (local work), Service (cloud), Mobile (monitoring)
• •Data modeling uses relationships and schemas (Star for speed, Snowflake for normalization)
• •DAX functions enable calculations; tutorial covers SUM, AVERAGE, COUNT, IF, RANKX, ISBLANK, NOW

Generated with AI, which can make mistakes.