Author1
Author Archives: Author1

Excel Power Query: Exploring Data Transformation Magic

Imagine you have a magical data transformation tool that can be your personal time-saver for all things related to data. You know those moments when you find yourself dealing with repetitive tasks like copying, pasting, and column mixing? Well, Power Query jumps in and says, ‘Hey, let me handle that for you!’ So, let’s explore […]

Excel #SPILL! error: A quick and easy fix

In this blog post we’ll talk about spill errors and describe how to fix them. We’ll also see how to prevent spill errors and manage them when they do happen. This blog post is beneficial for both beginners and experienced Excel users! What is #SPILL error in Excel? When a dynamic array formula generates more […]

How to Make Gantt Charts in Excel

Every Excel user is familiar with charts and how to generate them easily using templates. However, the Gantt chart is one graph type that many people still find confusing because there is no built-in template for Gantt Chart. So, in this blog, we’ll comprehensively cover all aspects of the Gantt Chart. What is Gantt Chart? […]

Tableau Prep – The Cleaning Step, Group and Replace

Introduction Data is like blood flowing through an organization and, just like blood quality is directly linked with the health of the body, organizations only function effectively when the quality of their data meets the minimum quality standards. In real life, data that is used for visualization is typically sourced from a variety of different […]

Tableau Prep – The Profile Pane and Pivot Step

Introduction and Significance Exploring data is probably one of the first things a data analyst would do when dealing with a new data set. It is important to understand the profile or the characteristics of the data before you start analyzing and visualizing it. Case Study For this article, let’s use a hypothetical case study […]

Getting Started with Tableau Prep

Many data scientists have heard the line – “People spend 80% of their time prepping data and only 20% of their time analyzing it.” And now, as an overload of data becomes available, dealing with untidy data becomes excessively difficult. Cleaning data is known as one of the most tedious jobs in a data scientist’s […]

The Tableau Prep Interface and the Input Step

Welcome back to the articles on Tableau Prep. Today we’ll be discussing the interface of Tableau, how to use it, and the Input step In Tableau. The Start Screen and Connecting to Data When we open Tableau, we begin on the start screen. At the far right, we have the discover pane, which shows education […]

Waffle Chart in Tableau

Definition: Waffle chart is a 10 X 10 cell grid in which each cell represents 1 percentage point summing up to total 100%. Waffle charts can be represented with conditional formatting where cells are  highlighted with different colors based on the percentage value of that KPI. There are following used cases of Waffles chart: To […]

Pareto Chart in Tableau

Pareto chart is basically based on the theory of “80-20” phenomena, where it means that 80% of the output is being generated by the 20% of the input. In terms of retail data, we can also say like this that 80% of revenue is from 20% of customers. Pareto chart is a combination of both […]