How to create a rating visual in Power BI using DAX!
Power BI
In my previous blog post, I’ve explained how you can display images and icons on the axis and in the slicers, leveraging a very simple technique using UNICHAR() DAX function. Now, I wish to expand on that, and show how you can create ratings visual, using simple DAX! Let me be immodest and say – using this trick you can freely say that …
How to make Histograms in Power BI to answer business questions
Power BI
A histogram is a common tool in statistics to describe the distribution of values across a dataset. They can show you the most common values, the outliers, and the spread of your values, all at a single glance. Histograms can be useful not just within statistics, but also for answering business questions. However it’s not immediately obvious how to set …
Power BI Project Good and Best Practices
Power BI
Preface: This post is set set of guidelines that address many aspects of new projects. Although I feel strongly that many of my recommendations are correct and applicable in most uses cases, other experienced practitioners have valuable ideas and I welcome their input. Please post your comments, links to other resources and ideas that may be different than mine. This …
How many join many to many with a bridge table in power bi
Power BI
One of the greatest values of data visualization tools is being to connect different types of data tables to calculate results, illustrate trends, or discover outliers. Relationships between your tables are necessary to create these connections. Relationships in Power BI Relationships in Power BI have multiple configurations, including cardinality and cross-filter direction, which determine the way that your tables connect …
The Architecture of Power BI
Power BI
The main element of the drive to be agile, competitive, and efficient is business intelligence. As companies develop, the regular generation of information becomes very hard to handle. This, in turn, generates a road-block for data-driven businesses that want to use their data to drive company decision-making. In addition, the siloing impact and biased reporting structures across companies generate a …
15 Major Benefits of Power BI
Power BI
Power BI is a cloud-based business analytic solution, which is used to analyze data from a wide range of data sources. It is simple to use as well as user-friendly. The insights obtained can be shared across an organization and can be rooted in the organization’s app or website. With Power BI, you can create as well as productive with …
Differences Between Power BI and Tableau: Power BI Vs Tableau Comparison
Power BI
Power BI is a Data Visualization and Business Intelligence tool provided by Microsoft. It can collect data from different data sources like Excel spreadsheets, on-premise database, cloud database and convert them into meaningful reports and dashboards. Its features such as creating quick insights, Q&A, Embedded Report, and Self Service BI made it top among all BI tools. It is also …
SSRS Vs Power BI
Power BI
SSRS and Power BI are both Business Intelligence tools specially designed to present data to the end user. Since both are part of the Microsoft BI stack, they are equipped with a different set of audiences and applied in different practices. Before we discuss the differences between the two, let’s first understand each of these clearly. What is SSRS? SQL …
Limitations of Power BI
Power BI
Very business wishes to establish its brand in the market as well as grow exponentially. This is where business intelligence plays a crucial role, as it is a very important factor in the process of branding and other decision-making processes. To help you with an effective decision-making process and get down to conclusions, Microsoft presents with a very riveting analytics …