Analyst in Action

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...

Let's consider a scenario where you get the unstructured data and you need to derive the insights using it. This sounds so baffling to me and considering it for data-driven decision-making is one of the mistakes. This scenario can be intervened by a basic step i.e. data cleaning. As the name suggests it is the prior step you need to take before deriving insights and creating visualizations out of it.  In other words, it is a prerequisite for data visualization. In my novice experience, I have handled data that arrived from a variety of sources also entered manually which can escalate the chances of getting duplicate values and wrong values which is needed to be removed before taking it further. All these steps may include eliminating some values or replacing some data so that the data is befitted for further visualization. In today's blog, I will take into account 6 basic steps which prove out to be useful for me in every data cleaning step. All these steps are quite extensivel...

Source You must be aware of various customer segmentation techniques and analyses. Let's discuss one of the most important analyses today i.e. RFM Segmentation. What is this 3 letter term can do? The answer is it can do wonders let's get to know more about it. RFM analyses are the method of separating your customers based on RFM scores which will help you in identifying your best customers and lost customers. RFM is an acronym for Recency, Frequency, and Monetary. The main idea behind this analysis is to understand your customers well because it will separate your customers based on how recently your customer made any purchase, how often they are buying, and what is the average cost of their orders. RFM analyses can be performed in various analytical and programming tools such as Python, R, and Excel. I have done it in Excel on sample data. How to do it in Excel?   Select the right data and insert a pivot table and select the pivot table field accordingly in my case I have se...

Source Does excel qualify as a Business Intelligence tool? Excel is a spreadsheet tool but it offers features such as graphs, charts, pivot tables, and a programming language called Visual Basics for Application (VBA). What kind of tools are considered BI tools? The primitive answer is the tools that help in collecting data and analyzing it to help in informed decision making. According to this excel qualify as a BI tool. But when you compare excel and other BI tools such as Microsoft Power BI it offers much more than excel. But professionals will argue that excel is always a go-to tool for analysis. If you compare a BI dashboard against the excel final reports you can easily gaze that the latter one is not that intuitive in nature which is a key feature that BI tools offer. Other than that excel reports can do the same work but in today's world, it looks obsolete in nature. BI dashboard is much more interactive in nature. Power BI sample dashboard Sample excel report As a user mys...