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 2

Azure, Cloud, Microsoft Azure

This is the second part of the three-part article which aims to help both beginners and...
Read More

A Cartesian Product in SQL – Work Scenario Application

SQL Server

A Cartesian Product is a product of two sets of elements where each element in one set is multiplied by every other element of the other...
Read More

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

Azure, Cloud

The current article is the first part of the series about designing a simple data warehouse business intelligence solution in Azure from...
Read More

SQL Server Business Intelligence – Modern Tools and Technologies

Business intelligence • One Comment

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

Learn to Use Time Intelligence in Power BI

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

Business intelligence, SSIS

In professional work scenarios, we often need to load data from one report to several destinations, such as Excel files and SQL databases....
Read More

Centralized Data Modeling Using Power BI Templates

Business intelligence, Power BI • One Comment

The centralized data modeling approach is really helpful in many practical scenarios. This article...
Read More

Power BI Date Table Template Tutorial

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

Business intelligence, Power BI

To utilize the time intelligence built-in features and functions in Power BI reports, you can use multiple Date tables. This article is...
Read More

Create and Use Custom Date Hierarchies in Power BI

Microsoft Power BI

Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this...
Read More
Close