How to Build a Simple Data Warehouse in Azure Part 3
This is the final part of the three-part article which aims to help both beginners and...
How to Build a Simple Data Warehouse in Azure – Part 2
This is the second part of the three-part article which aims to help both beginners and professionals in designing a simple but fully...
How to Build a Simple Data Warehouse in Azure – Part 1
The current article is the first part of the series about designing a simple data warehouse business intelligence solution in Azure from...
A Cartesian Product in SQL – Work Scenario Application
A Cartesian Product is a product of two sets of elements where each element in one set is...
Learn to Use Time Intelligence in Power BI
Time intelligence is a smart way of analyzing time period-based data, such as sales according to dates, using built-in time intelligence...
Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages
In professional work scenarios, we often need to load data from one report to several destinations, such as Excel files and SQL databases....
Centralized Data Modeling Using Power BI Templates
The centralized data modeling approach is really helpful in many practical scenarios. This article...
Power BI Date Table Template Tutorial
What is the right way of using Date Templates in Power BI reports and dashboards? This article will clarify the question and help to...
Power BI: How to Create Date Tables Using Dax Format Functions
To utilize the time intelligence built-in features and functions in Power BI reports, you can use multiple Date tables. This article is...
Create and Use Custom Date Hierarchies in Power BI
Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this...