Analytics

This blog describes how to use and interpret the information provided by the Power BI Performance Analyzer, finding the bottlenecks in slow reports. What is the Power BI Performance Analyzer? The Power BI Performance Analyzer is a feature included in the May 2019 release of Power BI Desktop that simplifies how you can collect the […]

This blog in our series on Atlassian Optimizing JIRA will cover personalizing JIRA settings to make JIRA best for you. (Read the previous post here on JIRA Best Practices). Moving on, we will consider optimizing JIRA also by personalizing JIRA settings. While your JIRA admin or team leader sets up many customizations, there are few […]

In this blog, we will show a GIF as a report page tooltip when hovering over a visual. This cool technique allows you to display instructional GIFs or videos for our end users. Steps for Creating GIFs: App to record gifs Adding gifs to Power BI Adding Tooltip Integrating with button App to Record GIFs: […]

Power BI Performance Tuning Whenever we start developing reports in Power BI three important things always come to mind these are data accuracy, data security, and report performance. If the report performance is not up to the mark, then there is no meaning of how much effort we have put into it, we have to […]

What is a Data Warehouse? A data warehouse, or enterprise data warehouse (EDW), is a system to aggregate your data from multiple sources, so it’s easy to access and analyze. Data warehouses typically store large amounts of historical data that can be queried by data engineers and business analysts for business intelligence. Instead of only having […]

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