Tableau Data Analysis Project: Sales Insights : 1 - Problem Statement

with this video we are starting a project series in tableau called sales insight tableau is an industry standard when it comes to bi tools it is probably the most popular bi tool and if you are planning to make a career in data analysis or data science tableau is something you have to learn you need to learn one bi tool either tableau or power bi and this project series will give you experience on how the data analysis projects are executed in big corporation let's say you you want to learn tableau and if you just watch those tutorial videos it can give you some knowledge but when you work on a real project like this so in this project uh we will be having sales data for a company and we'll have more than 150 000 transactions so it's like a real database and when you work on this project not only you learn technical skills related to tableau and mysql by the way we are covering mysql tableau both so not only you learn technical skills but we'll go over the scenarios where when these projects are executed in big corporate how the meetings are held how they do project management using things like aims and how different teams such as data analyst data engineer data scientists interact with each other so we'll go over all of that my friend heman very well who is a data analyst manager working for a company in uk he helped me with this project so i want to thank him uh for his help and also i have another friend kasim bhatti who is a top rated data analyst freelancer on upwork i did a video with him recently he all he helped with the converting this project in tableau so i already did a power bi series with hemanon earlier i'm going to provide a link in the video description so if you want the same project series in power bi that series is already there but custom helped me in converting this project into tableau and that's what we'll be uh doing in this series now in terms of um overall structure of these videos i will go over some project planning phase first we will look at problem statement then we'll go over project planning then we'll build a nice dashboard in tableau step by step now let's talk about problem statement so ethic hardware is a company and i just manufactured this name uh it's a company uh which supplies the hardware peripherals to different clients such as nomad stores excel stores search tools these are all the clients and this is a hardware company which will supply computers other peripheral networking equipment to them and they have a head office in let's say delhi india and they have regional offices in different states of india and berwin patel is a sales director of this company and he's managing the business from the head office but then you have regional managers per state or per region or district and what's happening with this company is the sales are declining for this company and bobby and patel as a sales director is having a lot of struggle tracking where the business is failing because when the business is smaller let's say you're 10 employees small business you can manage but when your business is bigger and you have multiple offices it's hard to manage actually you don't get a right picture and that's when data analysis can help you so for bob and patel when he talks with the regional managers or regarding the business in their areas the managers have a tendency to paint a rosy picture so sometimes they you know sometimes they don't lie but they put sugar coating around the facts and as a sales director barwin doesn't have any idea on what is actually happen at a ground level you know he doesn't have data inside so that's the challenge that he goes through and when he calls this regional managers they will give him this big excel files you know and these excel files as humans we're not good at consuming so many numbers you know we want simple insights so he's frustrated because these managers are giving him so many excel files and he's like why the hell you're giving me 69 excel files i don't understand i have to merge those files and get the insights myself and it's very tedious and excel is kind of a boring tool so what he wants is some simple answers you know like he wants to know what are my top five customers what are my two weakest regions where sales are declining what is my aggregate revenue in last 365 days it is called year-to-date revenue all these simple answers are hard to get but there is a saying call a picture is worth thousand words so what if he has a nice visualization you know where you can click on a every region and you can get numbers for that particular region you can also see revenue trends or expense trends declining going down so once you have this kind of visualization which is hooked up to a real database the data that you're feeding is not what your managers are telling you it is the real transactional data coming up from your softwares so data do not lie so data will tell you the right picture and all bowen has to do is he opens a tableau and looks at this dashboard and he will get a complete idea on what's going on so this way you have a lot of transparency in the business you also get a lot of insights for example you have two regions which are where sales are declining maybe you can run a special discount you know to attract more customers so tableau provides you the business insights which is this is called like a descriptive statistics like it tells you where the sales is declining where it is going up who is my top customer and so on and based on these insights as a sales director berwin can make a business decision he can say okay in orissa i want to offer five percent more discount because sales are declining there so that decision is called the business decision that is based on the real data analytics and that is the goal that barwin is having and with that uh he can basically once he has this dashboard working on this computer he doesn't have to call anyone he can just look at the dashboard call someone if the if it is not performing the way it should perform the business in that area he can also configure tableau so that it sends him a daily or less a monthly report in less a pdf format which has different diagrams and charts and revenue trends so that you know all these things are automated and that is one of the reason why uh tableau is getting very very popular tableau power bi and other bi tools because they give you real time data analytics okay so that was all about problem statement in the next video we will be talking about uh aims grid which is used to use for defining a certain projects and we'll also talk about data discovery

Channel: codebasics

Views: 46,464

Rating: 4.9528561 out of 5

Keywords: yt:cc=on, data analysis project using tableau, data analyst project, tableau project, data analysis projects for beginners, data analyst project example, data analytics project examples, tableau project tutorial, tableau tutorial, tableau project for practice, tableau project for beginners, tableau live project, tableau project ideas, tableau projects, tableau data science project, tableau visualization projects, tableau real life project, tableau data visualization

Id: CCNd2fUfFkk

Length: 7min 56sec (476 seconds)

Published: Tue Dec 15 2020