Author: Haroon Ashraf

Haroon's deep interest in logic and reasoning at an early age of his academic career paved his path to become a data professional. He began his professional life as a computer programmer more than 10 years ago working on his first data venture to migrate and rewrite a public sector database driven examination system from IBM AS400 (DB2) to SQL Server 2000 using VB 6.0 and Classic ASP along with developing reports and archiving many years of data. His work and interest revolves around Database-Centric Architectures and his expertise include database and reports design, development, testing, implementation and migration along with Database Life Cycle Management (DLM).

How to Build a Simple Data Warehouse in Azure – Part 1

05:23 Azure, Cloud

The current article is the first part of the series about designing a simple data warehouse...
Read More

SQL Server Business Intelligence – Modern Tools and Technologies

13:13 Business intelligence • One Comment

This article talks about the modern business intelligence (BI) tools and technologies related to the Microsoft platform. Additionally, the...
Read More

Learn to Use Time Intelligence in Power BI

11:05 Business intelligence, 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...
Read More

Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages

10:26 Business intelligence, SSIS

In professional work scenarios, we often need to load data from one report to several destinations,...
Read More

Centralized Data Modeling Using Power BI Templates

11:36 Business intelligence, Power BI • One Comment

The centralized data modeling approach is really helpful in many practical scenarios. This article focuses on achieving it using Power BI...
Read More

Power BI Date Table Template Tutorial

10:24 Business intelligence, Power BI

What is the right way of using Date Templates in Power BI reports and dashboards? This article will clarify the question and help to...
Read More

Power BI: How to Create Date Tables Using Dax Format Functions

14:32 Business intelligence, Power BI

To utilize the time intelligence built-in features and functions in Power BI reports, you can use...
Read More

Create and Use Custom Date Hierarchies in Power BI

14:51 Microsoft Power BI

Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this issue. The current article focuses on the...
Read More

Creating the Date Table in Power BI Desktop Using DAX Function

14:30 Business intelligence, Power BI

The time intelligence functions for the data models or databases running behind a Power BI report are really helpful. To make the most use...
Read More

SQL Server Business Intelligence (BI) – Traditional Tools and Technologies

12:15 Business intelligence, Power BI, Tools & technologies

If Business Intelligence (BI) is in your focus, you need two things to be a success. They are the...
Read More