The ability to visualize a dashboard and develop a simple dataset is a priority for all small and midsize businesses–and the cost-effectiveness of Power BI has made this possible for many SMBs. With a multitude of licensing models, businesses can only use what they need, making Power BI less expensive than other analytics tools. Business […]
I recently spoke about Goals in Power BI at the local Power BI meetup. The feature is currently in preview, introduced some eight months ago, and has quite a lot of promise. I find Power BI Goals particularly exciting since we are working with a large customer who is a perfect candidate for this. So, […]
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 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 […]
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 […]
- 1
- 2