Analyst in Action

Finally, we are back with new blogs. The idea of all the blogs is to share the problem of the week which I faced and provide a solution to it. So, as Business Intelligence Analyst one of my major responsibilities is to design an optimized data model and avoid many to many relationships. The primitive approach to such a problem is to create bridge tables out of a big flat table and create one to many relationships in that process. Creating bridge tables can be achieved in the Power Query Editor. There are mainly two ways to achieve that one is to take reference tables and the other is to create a duplicate table out of the big flat table. So what is the difference between duplicate and reference? Let's dig deeper into it. If you see both of them create a copy of the main table but in duplicate, it will copy the changes applied to the main table whilst in the reference the bridge table will be isolated from all the changes applied to the main table. The reference query always points

As a tableau enthusiast, I always see similar questions on the tableau community and in today's blog, we will address that. If you are new to tableau then you must be perplexed about the use of groups and sets in tableau. It troubled me a lot in the beginning and after using tableau for a significant period I realized that it's not that difficult and you can identify the purpose after using it. Let's dwell around it and highlight the differences.  Before highlighting the differences we will understand what is a group in tableau? As the name suggested you can group different members into a particular group without any condition associated with it and it will create a new dimension every time. The definition can be confusing at times so let's dig deep into it by taking a closer look at how a group works in the Tableau public. I am using sample superstore data. Before creating a group let's understand the idea behind it. I am taking the subcategory and we are looking t

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 looking forward to dealing with large datasets in excel? If that's the case then you must consider pivot tables. If you are a novice in this data world then you must focus on the pivot tables as they will be a stepping stone for you as a data analyst. So what is a pivot table? The pivot table allows you to understand the data where you can generate certain tables and graphs. I consider it as a baseline for business intelligence tools. If you look at the features of the pivot table it is quite similar to BI tools with limited options. It is an integral part of many analyses in excel and at our blogs, we have worked in-depth with pivot tables in RFM segmentation . In today's blog, the focus will be on exploring features that a pivot table can offer for a data analyst. Let's dwell around with it!!! I will be using the Sample Superstore data for the analysis. As you must be aware of inserting a pivot table. You need to select the dataset completely and in the insert tab

What if I told you there's no need to write laborious DAX expressions in Power BI? Doesn't that sounds great? I personally enjoy writing the DAX expressions from scratch because it helps to get to know the data well and you can tailor your calculations. But if you don't like writing the DAX expressions from square 1 then you should consider "Quick Measures". Power BI always makes your task easy in visualizing your data and quick measures are something that helps you to create measures in few seconds. Doesn't that sound amazing? Yeah!! As the name suggests creating measures just by dragging and dropping is an accentuating feature of quick measures. I consider it to be the future of measures in Power BI. In this blog, I will showcase step by step process to create quick measures. I will be working on the Sample Superstore data. You can find the quick measures right next to the new measure on the top or else you can right-click any of the available table options