Project 2 - Supply and Demand Gap Analysis

I ATTACHED THE WORD DOCUMENT BELOW THE FILE.

I ATTACHED THE POWERBI FILE BELOW THE FILE.

I ATTACHED THE POWERPOINT BELOW THE FILE.

This project is created by :

Pazzuri Srikanth Goud

Email-id: [email protected]

Deliverables of this project:

• Detailed Documentations (attach a word file and also paste in the text box)
• Power BI Report / .PBIX file
• Present the project like a Case Study using Power Point

• In this project i have used the data formatting chats, graphs ,slicers &Etc..

Table of content

• Aim
• Introduction
• Problem statement
• Methodology
• Analysis (Data sheets pertaining to it)
• Insights
• Recomendations.
• Conclusions

Aim: This project aims to analyze data in detail on Wine industry sales by coutry wise and growth of the coming years.

Introduction: Wine is an alcoholic drink typically made from fermented grapes. Yeast consumes the sugar in the grapes and converts it to ethanol and carbon dioxide, releasing heat in the process. Different varieties of grapes and strains of yeasts are major factors in different styles of wine

Problem Statement:

• We can find sum of Fright Expense by Region.
• Sum of Returns by segment and sum of Revenue by city.

Methodology:

• Data Cleaning: In data cleaning we can clean the data transformation in power BI query Editor, B y using Transforming the data we can avoid the duplicates values in that dataset.
• Data Interpretation: In this interpretation step, I found out some important information about the data set. The dataset was almost completed and clear. In this dataset we can have 9367 rows, and 24 colums.
• Visualization: in visualization,I too the help of powerbi desktop software to make graphs and charts here some relevant graphs and charts are attached here.

Analysis:

In the observation found some interesting points that are mentined below.

• According to our data on wine industry total sales in a country.
• The dataset is available is from 2010 to 2013.
• Total wine industries by the country shown in map visualization.
• Average of margin is 0.51.
• Average of revenue is 949.23.
• Average of discount percent is 0.05.
• Sum of unit price is 826.35k.
• Growth for coming year based on before year.
• Sum of freight expenses and sum of unit price by region.
• Sum of freight expenses by segment.
• Sum of unit price by segment and unique id.
• Sum of freight expenses by region.
• Sum of revenue by city.

Insights:

• We can take a look at the final report for furture industry analyisis.
• Total countries are fully segment by the revenue and region.

Recommendations:

• We can collect good dataset for industry analysis.
• We can analyse the data of the overall world.
• We can work on large dataset and analyse them with the proper format of the chart.

Conclusion:

• In the conclusion, we can take a look at final report for furture industry analyse.
• As we can see in the report,sum of revenue by city and unit price by segment.
• Sum of freight expenses by segment.