Power BI Tabular Model Development tips

Power Query 1. Import or DirectQuery: Before your start developing the Tabular model, decide which data Connectivity mode suits your requirement. Read through the Microsoft documentation to understand the differences. Tip: DirectQuery mode can be changed into Import mode. However, the vice versa is not possible. 2. Disable auto date/time option: In Power BI Desktop, … Continue reading Power BI Tabular Model Development tips →

DAX formula to obtain the count from SCD type-2 dimension records

Data source used for this post is the ‘Reseller Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server data warehouse. The ‘DimEmployee’ table in the data mart is clearly a SCD type-2 dimension, which means any update to the employee record is created as a new row with a new start date and the old employee … Continue reading DAX formula to obtain the count from SCD type-2 dimension records →

Dealing multiple date relationships with the fact table in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. During the data modelling in Power BI, although one could create multiple relationships between two tables, enabling a second relationship as ‘Active’ raises an error. Therefore, it could become difficult to measure the fact data in terms … Continue reading Dealing multiple date relationships with the fact table in Power BI →

Part 4: Data Vault for beginners

This is the final article of the four articles written to easily understand the Data Vault architecture. Part four describes on how the information mart is derived and then loaded from the Data Vault. Information mart ER diagram designed through Dimensional Modelling techniques Dimension load Descriptive data used to measure the facts are basically loaded … Continue reading Part 4: Data Vault for beginners →

Part 3: Data Vault for beginners

This article is one of the four articles written to easily understand the Data Vault architecture. Part three covers the step by step loading of the Data Vault key entities with examples. Hub load Loading hub is the first and the important step in the data vault loading as hubs hold the business keys of … Continue reading Part 3: Data Vault for beginners →

Part 2: Data Vault for beginners

This article is one of the four articles written to easily understand the Data Vault architecture. Part two covers the Data Vault Staging environment, Hash Key computations and preparation of the staging data for the Data Vault loading. Overview of the Data Vault Staging The main purpose of the staging environment is to reduce the … Continue reading Part 2: Data Vault for beginners →

Part 1: Data Vault for beginners

This article is one of the four articles written to easily understand the Data Vault architecture. Part one covers the Data Vault overview, Data Vault architecture and the OLTP source that has been used for the Data Vault design. Please note that the OLTP, Staging, Vault and InfoMart databases developed for this series are all … Continue reading Part 1: Data Vault for beginners →