Data Visualization Project : Sales Data - PowerBI

-

In this project we have displayed the comparison of Current Year Sales with Previous Year sales and YoY sales growth%. We have displayed the Budgeted Sales data along with Budget Variance%. We have Power BI Tooltip to display Product Level comparison of Sales and Month wise Budget Variance%. We have created the Sales forecast also.


Data link : https://docs.google.com/spreadsheets/d/1Ap1S4IIUJCPN80aT2YSIhVZ2HaK7nDlP/edit?usp=sharing&ouid=109399052699278618880&rtpof=true&sd=true

Final output

So here we go...................

Step 1 : Here we have uploaded Excel file in power BI via Home - Getdata- Excel navigator

Step 2 : Sorting data with Year / Month / Quarter  as mentioned below

Year Dim = Year = 'Date Dim'[Date].[Year]

Month Dim = Month = 'Date Dim'[Date].[Month]

Quarter Dim = Quarter = 'Date Dim'[Date].[Quarter]


Step 3 - Adding the column to the database to analyse the data for creating charts

Step 4 - Interrelate the Database, based on the requirement as we have described date , month, years, we have disable the Date, Product Id section in the Interrelation Tree




Step 5 : I have created new measure in order to make the visualization easir to understand and analyze




STARTING THE VISUALIZATTION

1 ) Adding Colour rule for based on percentage number . (Green for % >0 & Red % <0)  


 
2 ) Adding Slicer and creating a drop-down



3) Creating a Donut chart Category VS Sales



3) Creating a Scattered W.R.T Product  VS  Year on Year % Sales 



4) Creating a Area Chart Sales Vs Budget of the Month


5) Creating a Sales future 30 days sales forecast plot - using Forecast navigator



6) Adding a matrix for Total Sales Visibility




Assigning a Tool Tip Function ( This is done to get a detailed analysis after hovering cursor on the specific data as shown below







Collecting all the above charts in a dashboard for sales analysis.


Doing the forecasting for 2014



Overveiw of entire Sales dashboard





 
















































                                    


Comments

Post a Comment

Popular posts from this blog

Docker

-
Image
  What is Docker ? Docker is a containerization platform that provides easy way to containerize your applications, which means, using Docker you can build container images, run the images to create containers and also push these containers to container registries such as Docker Hub, Quay.io and so on. In simple words, you can understand as  containerization is a concept or technology  and  Docker Implements Containerization . Docker Architecture ? The above picture, clearly indicates that Docker Deamon is brain of Docker. If Docker Deamon is killed, stops working for some reasons, Docker is brain dead :p (sarcasm intended). Docker LifeCycle We can use the above Image as reference to understand the lifecycle of Docker. There are three important things, docker build -> builds docker images from Dockerfile docker run -> runs container from docker images docker push -> push the container image to public/private regestries to share the docker images. Understandin...
Read more

Data Analytics for Healthcare Industry

-
Image
Data Analytics for Healthcare Industry: Transforming Patient Outcomes The healthcare industry generates vast amounts of data every day, including patient records, medical images, and clinical trials. This data holds immense potential to improve patient outcomes, but it can also be overwhelming to analyze without the right tools and expertise. That’s where data analytics comes in - it allows healthcare providers to turn raw data into meaningful insights and drive better decision-making. Here’s a closer look at how data analytics is transforming the healthcare industry: Improving Diagnosis and Treatment Data analytics can help providers to identify trends and patterns in patient data that might not be immediately obvious. For example, data analysis can reveal correlations between certain symptoms and diagnoses, or help doctors identify which treatments are most effective for specific patients. This can lead to more accurate diagnoses and personalized treatment plans, resulting in better ...
Read more

Employees Salary Prediction Using Linear Regression - KNIME ANALYTICS PLATFORM

-
Image
Here I will be using the KNIME to forecast the employee's salaries with respect to their year of experience by training and testing data in ML using Linear Regression. Step 1 : Reading the data set with KNINE - File Reader Node 1                                         Step 2: Adding the data filter node to remove the Null Values Setting up the pattern match to N/A Step 3: Adding Node 2.1 Partitioning for Data sorting to Train & Test for Machine learning Algo. Here we set 70% of total data to Train & 30% to Test Step 4:  Training data for linear regression Note: After training the data, we have concluded that our model shows ~95% Accuracy , as we have selected the Random samples from the training data to maintain the efficiency of the model. Step 5: Adding the Linear Regression Node run Trained & Test Data Step 6: Once we have trained and tested data, we have got the ...
Read more