This project is about some specific Automobile brands. It contains data of cars like Alto, Beat, Santro, Hawk, Maruti 800 etc., its total sale, sold price, manager, dealers, consumer preference, zone, state and city in which it was sold of 2018-19. This makes easy to do comparison between these cars and where it is mostly sold. lastly it shows the top three and bottom three cars, states, and managers where quantities sold is highest or lowest. It covers the skill sets like Power BI as it is the best platform for data visualization in the most interactive ways. Also it shows various effective chart visuals which makes the dashboard easy to understand and attractive for the viewers. This will help the customers to compare between the best car brands and it will help the Car Companies to focus on those States where sale is higher than other States and plan for the future products according to that.
- Data Import : Connected data from the File and Transform it by ensuring accurate Data Type.
- Data Cleaning and Processing : Ensured data accuracy and consistency and by preventing duplicate data by using techniques in Power BI Query.
- Performing Data Analysis and Interpretation : Created meaningful Measures and additional calculated columns to have qualitative insights from the data.
- Data Visualization : Created various meaningful insights from Visualization Field and customized chart formatting.
- Creation of Interactive Dashboard : Arranged all the customized chart in the meaningful format with some additional features of the Dashboard like Buttons and Filters.
In this Project, the measures display total quantity sold of the cars is 9673, total revenue generated is 313M, total State Tax paid is 4.29M and total Car Insurance paid is 28.45M. These are show in the form of KPI.
- In which month there is maximum sale with the maximum revenue ?
- Which manager has done the maximum sale with the maximum revenue ?
- Which Zone is contributing maximum sales with the maximum revenue ?
- Which Category of the Car is maximum in sale with highest revenue ?
- How much difference is there from Targeted Sale to Current Sale ?
- Which Car is commonly popular in all the Zones and States with highest sale ?
- Which State has contributed highest sale with the maximum revenue ?
- Which Dealer has contributed the highest than others in cases of Sales and Revenue ?
- Which City has generated maximum revenue and does it belong to the same highest contributor State ?
- Which Car has generated maximum revenue than others ?
- Does there is any kind of relationship between sold price and car insurance and which State has maximum car insurance and state tax ?
- Which are the Top 3 Managers contributing to the Sales and the Bottom 3 Managers with worst performance ?
- Which are the Top 3 States contributing to the Sales and the Bottom 3 State with the least contribution ?
- Which are the Top 3 Cars highly popular in the market and the Bottom 3 Cars with the low sale ?
In this project we have three Dashboards for more detailed analysis Quantity Based Dashboard, Revenue Based Dashboard and Top-Bottom Base Dashboard
-
In this Project, the first filter is month-wise which is there on the Revenue-Based Dashboard. Through the filters I got that in January, quantity sold and sold price together are high followed by February month whereas both are low in July month.
-
In this Project, the second filter is Manager-wise which is on the Manager-Based Dashboard. Through the filters I got that Rajat Mrig has done high sales than others but generated lesser revenue than others and Ajay, Ishal Waliya, Ranjit Singhand Venkata Rao has generated highest revenue than others whereas Ruby Bhatia has done low sales than other and Pranay Seth has generated lowest revenue than others.
-
(a) From this Pie Chart of Zone, I came to know that West Zone has highest sale of Cars i.e. 3k followed by South whereas East Zone has lowest sale of Cars i.e. 1k.
- (b) In this I have used Funnel Chart which shows that West side has generated highest revenue followed by South whereas North and East has generated least revenue.
- I have used Line Chart for this data in which it shows that Basic Cars are mostly sold also followed by Luxury one whereas Extra Class Cars are least sold.
- Total quantity sold within period 2018-19 is 9673 Cars and crossed the target i.e. 8500 Cars, for which I have used Gauge Chart to display it clearly. The difference between the Target and Current Sale is 1173.
- In case of Cars where Alto is on the top for maximum Sales followed by Santro whereas Punto is at the last position for total sales.
- (a) In this Project, I got that Punjab has highest sale of cars followed by Rajasthan and Andhra Pradesh whereas Assam has lowest sale of cars. In case of Revenue generated Punjab is on the top followed by Chandigarh and Haryana whereas Assam is on the lowest position.
- (b) In this Project, I got that in case of Revenue generated Punjab is on the top followed by Chandigarh and Haryana whereas Assam is on the lowest position.
- On the basis of Dealers in which Bulward is on the top position followed by Nike whereas Mitushi is at the bottom position.
- In case of City-wise in which Patiala which exist in Punjab State only is on the top position followed by Sector 29 and Dwarka whereas Goalpara is the least revenue generator.
- In this I have used Area Chart from which I came to know that Santro is on the Top in generating revenue followed by US18 whereas Maruti 800 is the last one followed by Hawk.
- I have used Line Chart for presenting this relation in which I got that Car Insurance and Sold Price are directly-positive correlated means as Sold Price increases Car Insurance also increases in the same way and vice-versa. Car Insurance is highest in Punjab whereas least in Rajasthan and when we talk about State Tax, it is high in Punjab followed by Chandigarh and Karnataka whereas least in Rajasthan.
- Here in this Bar Chart the top 3 Managers are Rajat Mrig, Ajay and Venkta Rao whereas the bottom 3 Managers are Pranay Seth, Ranjit Singh and Ruby Bhatia.
- Here in this Bar Chart the top 3 States are Punjab, Rajasthan and Andhra Pradesh whereas the bottom 3 States are Delhi, Haryana and Assam.
- Here in this Bar Chart the top 3 Cars are Alto, Santro and Beat whereas the bottom 3 Cars are US18, Maruti 800 and Punto.
This project is helpful for both customers as well as companies. For customer, it will help them to know which brand is highly sold and which brand has affordable rate. For companies, it will help them to know which dealer can generate higher profit, which state has high rate of sales and which has low rate of sales, in which state different categories are sold and in what amount so that they can plan the strategy for maximizing their profit with lesser cost. They can also check that in which of the state, State Tax is higher and in which it is affordable in order to plan the minimum transportation cost. We can derive more information from this dashboard according to our requirement.
- @Ritika821
- Ritika - Data Analyst