How to write your SQL query in DAX?

Obviously, T-SQL and DAX are two different query languages and they serve entirely different purposes. However, as someone from database development background, when I learn DAX initially, I always started thinking SQL and tried to achieve same thing from DAX…

Introduction to Azure Data Factory V2

It was only a matter of time till the complete Microsoft on-premise Business Intelligence stack was moved to the Azure Paas service. With the introduction of Azure Data Factory (ADF) back in 2015 and the recent launch of ADF V2, which is in public preview for the moment…

Infor Business Intelligence Platform Components

Working on a couple of projects with Infor BI, I have been using various components of the product quite regularly. Despite it being a well- known product in our organization (Fortude), it is not known to many.

How to make your BI project a success

A few months ago, I wrote a blog post on why most BI projects end up in the trash. In it, I identified the reasons behind the high failure rate of BI projects. After reading the post, one of my colleagues asked me to write about how to make a BI project successful…

Calculating Month to Date using DAX in Power BI

Data Analysis Expressions (DAX) is a powerful formula language that can help you solve challenging problems and leverage the full potential of Power BI or Analysis Services Tabular when implementing business intelligence, data modeling, or analytics solutions.

Why do Business Intelligence Projects Fail?

According to Gartner, the famous technology research group, 70% to 80% of Business Intelligence (BI) and data warehousing (DW) projects end up in the trash bin. BI projects often fail, incurring colossal losses to organizations. Why do DW/BI projects fail? What can organizations do to avoid pitfalls that cause DW/BI projects to fail?

Implementing Dynamic Row-Level Security in a Tabular Model

Dynamic row-level security enables report authors to filter data based on the user roles. This prevents developers from having to maintain separate security matrices. This also avoids the complexity of maintaining users under different security roles.

Stock Movement Intelligence in Power BI

During the last few weeks, I have been getting myself acquainted with Power BI and its features. Finding data sources (to practice with), cleaning them, creating data models, and creating reports and dashboards have been very interesting.

Contact Us