There are 100 machines in a factory. Every machine has different test frequency. In a given month, not every machine is tested but we still have the last known rating (from some previous month) of that machine. We have to show the latest rating of each machine for each month in a stacked column chart. […]
Read More →
{ 2 Comments }
Assume a simple 4 column dataset as shown below. This data shows which ID had which type of subscription in which year. So ID A, which started as a “Free” subscriber in 2018 switched to a “Premium” subscriber in 2019 and then churned out in 2020. Likewise, ID D which started as a “Pro” subscriber […]
Read More →
Assume a simple dataset as shown in the image below (the input data is in columns A and B only. The desired outcome is in columns C and D). The objective is to calculate the 7 days rolling sum and average (as shown in columns C and D) ignoring blank cells. So in cell C8, […]
Read More →
{ 2 Comments }
Here is a Sales dataset of 8 columns and 29 rows. It basically details the revenue earned and cash collected by service type, Customer, Country and Period. For a selected Country and time period, there could be customers availing of both services or of any 1 service. There are 2 broad questions that one may […]
Read More →
Imagine a dataset like this. This dataset shows vendors that submitted proposals for supplying various parts to a Company. There is one column for each of the twelve months. Via a simple Pivot Table, one can determine the lowest bidding vendor per product (part) for any chosen month. However, one may also want to know […]
Read More →
{ 30 Comments }
Visualise Sales Data of a Non-Alcoholic Beverage Company with basic columnar information such as Date of Sale, Time of Sale, Brand, Stock Keeping Unit (SKU), State, City, Quantity sold, Unit Price and Salesman Code. In this sales dataset, each line item represents one visit for one SKU. If nothing is sold in a certain visit, then the SKU […]
Read More →
{ 0 Comments }
Visualise an MS Excel file with two worksheets: Employee headcount – a multi column dataset with information such as Employee code, Date of Joining, Age, Division, Department and Location. Each row represents data for one employee. The number of rows on this worksheet is approximately 700. Training Data – a multi column dataset with information […]
Read More →
{ 6 Comments }
With Power Business Intelligence (BI) tools of Excel 2013, one can metamorphose raw data and/or results of complex calculations into stunning and interactive visualizations. Power View (one of the four components of Power BI) allows one to create a PPT like flow in Excel thus allowing one to weave a story. To be able to interact with/create visualizations, […]
Read More →
Determine latest condition of each equipment and show a month wise count
{ 1 Comments }