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

🔸Netflix ML Architecture🔸

-
Image
Hey Guys, Have you wondered how netflix recommends you the videos you might ne intrested to watch. Let me show you have it workss Stayy tunned .............. 👉In Netflix videos are recommended based on members interests using ML algorithms 👉Here let us have a look at the important components of Netflix ML Architecture. 👉 Axion Fact Store: Axion fact store is part of Netflix Machine Learning Platform, the platform that serves machine learning needs across Netflix. First part of below image shows how Axion interacts with Netflix’s ML platform. 👉 Fact: A fact is data about the members or videos. An example of data about members is the video they had watched or added to their My List. An example of video data is video metadata, like the length of a video. 👉Compute application: These applications generate recommendations for the members. They fetch facts from respective data services, run feature encoders to generate features and score the ML models to eventually generate recommendatio...
Read more