Recently my Excel and data analysis skill was put to the test with a series of Data set. In this post, I will show you how I was able to conquer. Let’s go The data set you gave me has IF, Nested IFS, Round, Look UP, SumIF, Pivot, Bonus I…

Recently, I had the opportunity to analyze the dataset of one the busiest train light railways in London to draw insight into the reason for canceled departures and how to mitigate it. The task is as follows; The “data” sheet contains an extract from the Docklands Light Railway’s KESTREL database…

Hi People, long time no analysis So a friend reached out to me to help her analyze her accounts for the month of October to help her draw insights from her business. I told her to send the Excel sheet and got to work. …

I embarked on an enlightening journey to unravel HR data using the powerful tool, Tableau. In this post, I’ll share my experience and insights gained from analyzing HR data, showcasing how visualization transformed raw numbers into meaningful narratives. For this task, the objective is simple How many people are in…

I decided to learn a business intelligence tool as part of my effort toward becoming a Data/Business Analyst. In this project, I used Tableau business intelligence software to analyze sales data. The objective is to find The highest-selling country The highest-selling staff The highest-selling product The first thing I did…

I was recently given a set of customer success data with the following instructions to analyze Background You are a Customer Success Manager for a luxury hotel chain. Your primary responsibility is to ensure that guests have exceptional experiences during their stay. …

In this project, I will be joining two tables together using the INNER JOIN function. Now the table I will be joining together is the Employee Details and Employee Salary I created earlier. Missed it? Read about it here. SQL Basics: Creating Employee Details and Salary Tables Using Create And Insert Function Introductionmedium.com The first thing I will do is select the two tables…

In today’s data-driven world, understanding payroll data is vital for any organization. In this hands-on project, we will explore a payroll dataset using Excel and SQL to uncover valuable insights about employee salaries. Let’s dive in! Creating the Payroll Dataset Using Excel, I created a comprehensive payroll dataset containing information…

Imagine you have a massive dataset containing information about customers and their purchases. To make sense of this data, you need to extract specific details. This is where the SELECT statement shines. It allows you to choose particular columns from a table, making your data more manageable and relevant. …