Analyst in Action

You must be aware of the purpose and significance of Vlookup in Excel. But when it comes to Microsoft Power BI there is no Vlookup in it. Power BI provides you Related and Lookupvalue which is quite similar to Vlookup in Excel. If you aren't familiar with the Vlookup kindly refer to our blog . Let's get started with the purpose of both functions. You will be shocked to know that both of them will give you the same result. Because it follows the same principle of Vlookup i.e. searching for a particular value in a column and returns a value from a different column (different table). In this blog, we will showcase how and when to use related and lookup values. We will be using Sample Superstore data. The question that comes to my mind is when to use the related functions? So there are certain criteria to be met before creating a column with related. One of the conditions is that both the tables (one where we are creating a column and the other will be from where the value will com...

In today's blog, we will deep dive into the Power query editor. The interface of the power query editor is a replica of an excel spreadsheet but in the former things are much easier as compared to excel. Power query editor offers a lot of features which we have discussed in the guide to power query editor blog .  In this blog, we will focus on one of the features i.e. add columns. You can find it next to the transform tab in the power query editor. We will be working with the sample superstore data. The idea is to explore the add column tab. Let's start with duplicating the column which is just a click away feature available in the power query editor. You just need to select the column of which you need to make a duplicate and select the duplicate column tab available on the top. Unlike in Excel, you need to apply shortcuts to achieve the same. The power query editor is all about making your life easier. From duplicating the columns we will move to index the columns which can b...

 Are you bored of using a basic Pie chart in your visualization? Then this blog is for you. In today's blog, we will discuss step-by-step procedures to create a donut chart. Along with the donut chart, there is a much more so stick around. Let's start with a basic donut chart which proves to be the best alternative to the pie chart. A donut chart is a type of Pie chart where the center is carved out so that you display text in the carved-out space.  Pro Tip -: Donut chart can be used to display your KPIs and you can use it to display ratios and percentages. But if you are trying to visualize more than 5 categories try to avoid the donut chart because it will hamper the quality of visualization. The stakeholders expect to see clear visualization where the graphs tell their story by themselves. ( For more pro tips do follow our blog   ) So let's get started!!!! To create the donut chart we are using the sample superstore data and will highlight all the steps from scratch....

Let's continue where we left in the last blog. As we are quite familiar with the concept of parameters in Tableau Public ( Creating Parameter in Tableau ). In today's blog, we are going to create parameters in Power BI. Parameter is one of the most used features in Power BI as it saves time and makes the dashboard more dynamic in nature. You can easily create parameters in Power BI just by selecting the transform data and on top of that window you can see "Manage Parameter".  In this blog, the main objective is to see how parameter works and how it can improve the reports. To start off I am taking the Global Sample Superstore data into account. Before using parameters if we select regions and sales together we get a simple bar graph. Along with it if I add states then you can see all the states and their sales in the bar graph. It looks great as a method of representation but if your focus is data visualization then it looks really primitive in nature and not easy to ...

Let's start today's blog with some questions. Are you greatly indulge in creating data visualization? Do you want to come up with scenarios that aren't available in the data? If yes then this is the blog you really want to read. Parameters allow you to create features or scenarios which help the user to control the data in a much better way. You must be wondering how the users get a better control so mainly parameters allow the user to test different what-if scenarios that aren't available in the dataset. It is like some value that helps you to tailor your visualization according to the dataset. Options where you can use parameters in tableau- use it with calculated field or you can use it by combining with sets. We will look at both aspects in this blog. We can make the parameters more interactive and intuitive in nature by using parameter actions that allow users to change the value just by a click As mentioned, we are considering two basic aspects for creating parame...

Want to retain your customers then you are at the right place. It can be achieved by Cohort Analysis but the question is how this analysis helps in achieving it. Let's get started by understanding it. Cohort Analysis is used by the analyst to determine the user engagement of customers over time. To be more precise it helps to know whether our user engagement is increasing or decreasing over a period of time. It is done to know the level of user engagement and the customer churning rate in any organization.  In marketing, the cohort is referred to as the group which possesses similar characteristics or traits, and this analysis helps us to divide customers based on their behavior. To get a better understanding of your audience you need to perform such analysis on regular basis. It can be performed in almost every analytical tool mostly organizations prefer Google Analytics but I have done it in Tableau.  This analysis is done in Tableau. Let me walk through it and explain what ...