Data + Intelligence

Background Microsoft Excel is a popular and preferred spreadsheet solution for quick daily use reporting by the majority corporations and businesses in the world. Many times, corporate users need access to organization’s data in Excel for further development of MIS Reports. Power Query is a powerful tool embedded in Excel which can connect to internal […]

Have you ever had a scenario where you need to use part of your calculation multiple times? You might go and create a table or column for that and then re-use it. However, there are times that you just need that calculation to be re-used multiple times within one place. DAX variables can help you […]

In this article, I am going to explain how we can create data source parameters in Power BI. If you have different environments like Development, QA (UAT), and Production, and you want to check your reports on those environments without spending too much time changing the data sources. So, that time you need to create […]

Tooltips in Power BI are a simple feature that is often underutilized. One of the easiest ways to impress your audience with Power BI is a tooltip. This simple idea can provide incredible value to the report readers and elevate your work to next level. In this blog, I will take you through the required […]

In this blog, we’ll go through a quick overview of all the options available in the user interface of DAX Studio. These include the panes and each button in the ribbon. We’ll discuss how using these features will help improve your performance in DAX Studio. Familiarizing yourself with the purpose and function of each feature […]

What is Machine Learning? Machine learning means predicting outcomes using artificial intelligence based on previous data patterns. It is a computer program that can learn and adapt new data without human involvement. Machine learning is a subset of artificial intelligence (AI), and it’s the study of algorithms that gives computers the ability to learn and […]

What are Calculation Groups and Why these are so important? Imagine you have the Data Model, and you created couple of measures let’s say 2 measures and then suddenly the requirement changes, now you need to create Month to Date (MTD), Year to Date (YTD), Previous Year Calculation and Year Over Year Calculation (YOY). What […]

The truth is that being an analyst is all about balancing quality versus speed. This manifests itself in finding good tools which help make you more efficient. If there is one thing that analysts all agree upon, it is that no single tool does everything great. One piece of my advice to analysts is to […]

Showing the last refresh date and time in a Power BI report let you know how to refresh your report data, as sometimes the report viewer can not remember the last date and time when report data was refreshed. Just in case, when you never refresh the report, Power BI keeps showing existing data until […]

What is Bravo for Power BI? Bravo studio is a design before, no code tool which allows you to turn your app designs and prototypes into real publishable mobile apps (both iOS and Android). You can use Bravo to build even complex apps by connecting your design to external tools via APIs. In this blog, […]

Images as a Filter As technology is evolving so, the reporting standards need to be in sync with the current trend. Nowadays, looking at the numbers is not only the purpose of the dashboard but how your dashboard looks in terms of the colour, graphs, filter position, etc. Also, users are leaner toward the interactive […]

Dynamic Data Source in Power BI Power BI is a very powerful tool, and we can do wonders with it, but when it comes to changing the source, most of us are afraid of it. This is because by doing so, we may need to make many changes related to a data model, DAX, visualizations, […]