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...
SQL Server Business Intelligence – Modern Tools and Technologies
This article talks about the modern business intelligence (BI) tools and technologies related to the Microsoft platform. Additionally, the...
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,...
Centralized Data Modeling Using Power BI Templates
The centralized data modeling approach is really helpful in many practical scenarios. This article focuses on achieving it using Power BI...
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...