Creating a Power BI data model from a flat file source hosted on SharePoint or Azure Data Lake Store can be cumbersome. I recently found this out trying to create a simple data model for a demo, which involved files sized over 3 gigabytes. Every time I performed a transformation in Power Query and hit Close […]
Welcome to the second blog of my two-part blog series on Enhancing KPI indicators and visuals in Power BI. As a recap, Part 1 focused on displaying a green ‘up’ or a red ‘down’ arrow indicator for our KPI card visualization based on a pre-defined threshold. Another common request by business users is the ability to see at-a-glance […]
In the September 2018 release of Power BI Desktop, Microsoft introduced a new game-changing feature in the world of data analytics: “Aggregations”. I feel that Aggregations will provide much flexibility when it comes to handling large data sets in Power BI. With this new feature, users can define detail-level and aggregate-level information separately and Power BI […]
On the surface, Power BI might seem like a simple reporting tool offering a set of common visuals and capabilities to transform data into insights. But once you start exploring the tool, you will find that it’s the magic wand to unlock those amazing reporting features every business has been looking for. All you need […]
As part of Fortude’s weekly “tech talk” series, Madushan Dahanayake, Associate Consultant – BI at Fortude, took Fortudites on a fascinating journey deep into the world of machine learning. What is machine learning? Machine Learning is the use of algorithms to find patterns in data. It then uses those patterns to predict the future on […]
Obviously, T-SQL and DAX are two different query languages and they serve entirely different purposes. However, as someone from a database development background, when I learnt DAX initially, I started thinking SQL and tried to achieve the same thing from DAX. The reason for that thinking process is that it is always easy to learn something new when we […]
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 […]
- 1
- 2