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, it is now possible to orchestrate complex […]
As a business analyst, what exactly should we know to be able to convert the requirements of end users into Power BI reports? What should we learn to be good at using Power BI? These were questions directed at me by two business analysts (BA) at a recent meetup. They were getting into Power BI […]
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. Great idea! […]
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. So, in this blog post, I will demonstrate a useful DAX trick we used to address a challenge […]
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. Since most organizations have the required information about users in their databases, implementing dynamic-row level severity will be an […]
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? Influenced by […]
There are many ways to write DAX code to implement measures in the tabular model but writing improper DAX code may slow down the performance of the tabular model. I have encountered this problem during a recent tabular project implementation where, when you use conditional checking commands in DAX against a large number of rows, […]
In this blog post, Madushan Dahanayake talks about how he self-acquainted the features of Power BI as he was looking forward to a career in business intelligence. Madushan joined Fortude as an Associate BI Consultant in 2017 March after graduating from University at Buffalo, New York. During the last few weeks, I have been getting […]
Processes and Agility are vital for any software development company, irrespective of the maturity level; however, organizations sometimes lose the real Purpose of processes and agility, which is bringing Business Value to the organization. Let’s see how Processes, Agility, Purpose & Business Value come in to play in an ideal scenario. Processes World-leading companies bring […]