Tag: Power BI

Understanding Key Terms and Tools in Microsoft Fabric

Posted on

Microsoft Fabric is a comprehensive and unified analytics platform that brings together various data services into a single ecosystem. It enables organizations to efficiently handle data engineering, analytics, machine learning, and business intelligence. Below, we explore the key terms and tools used in Microsoft Fabric to help you understand its capabilities. 1. Core Components Lakehouse A hybrid data storage architecture that merges the features of data lakes and data warehouses to provide scalable and flexible data management. Data Warehouse A structured data storage solution optimized for SQL-based analytics, supporting high-performance queries and data modeling. Data Factory A powerful ETL (Extract,… Read more


Microsoft Fabric

Posted on

Microsoft Fabric is an all-in-one analytics platform designed for organizations that covers everything from data storage and data movement to data science and real-time analytics. It’s a unified platform that brings together a diverse range of technologies and tools into a single solution. It offers a comprehensive suite of services, including data lake, data engineering, and data integration, all in one place. Components of Microsoft Fabric As part of the Microsoft Fabric trial, users can access six exciting services. One component called Data Activator is currently still in private preview but will likely become available soon, so keep an eye out for updates! Now… Read more



Types of Dimensions in Data warehouse

Posted on

What is Dimension? Dimension table contains the data about the business. The primary keys of the dimension tables are used in Fact tables with Foreign key relationship. And the remaining columns in the dimension is normal data which is the information about the Objects related to the business.Eg: Product,Customer,Orders,Company,Date etc. Slowly changing dimensions refer to how data in your data warehouse changes over time. Slowly changing dimensions have the same natural key but other data columns that may or may not change over time depending on the type of dimensions that it is.  Slowly changing dimensions are important in data… Read more