Analytics

Optimizing JIRA for yourself is, customizing JIRA and making it like your own application. This blog in our series on Jira will cover JIRA best practices. (Read the first post here.) Starting on optimizing JIRA with some best practices on JIRA Issues. Optimizing JIRA – Issues Best Practice Straightaway, we start in JIRA by creating […]

Dashboards are a great way to display essential data necessary to achieve a particular objective. A good dashboard design will provide complex data visualization most comprehensively. But to create an operational dashboard, you need to know basic dashboard design principles that will guide you to the best design you can build yourself. This blog will […]

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 […]

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 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 […]

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, […]

The Challenge in Supply Chain Let’s face it. You and your suppliers are linked together and what they do affects you. So if your supplier data is fragmented across dozens or even hundreds of systems, it’s probably costing you. What is causing these supply chain leaks? Data stored in various places like supply chain management […]