Skip to content

Latest commit

 

History

History
50 lines (50 loc) · 4.88 KB

README.md

File metadata and controls

50 lines (50 loc) · 4.88 KB
Raw

Power-BI-Visualization-Project

This repository contains Visualization Projects which is visualized through Power BI Software, by using the visualization we can gain multiple insights and strategies which helps to develop the business for gaining high profit margins and by the insights we can reduce the damages by accidents & calamities.

Data Professional Survey Analysis

The dataset is the survey data of 630 Data Professionals about their Job Role, Average Salary, Job Satisfaction, etc.

  • The data has the survey from 630 unique persons from different platforms about their Jobs, Personal Data such as Age, Gender, Ethnicity, Country.
  • The data also has the Academic Qualifications, Salary, Working Field, etc.
  • To verify the uniqueness one should sign in with their email but the email data is protected, it only creates virtually unique id for each unique email id.
  • This survey was taken by the year of 2022, so the data more based on that time-period. Maybe now its slightly varies.

E-Commerce Sales Analysis

The data is from US Based E-Commerce Sales Company about their Profits and Sales Revenue.

  • The data is broken down in two different datasets, by using relationship function the both datasets can be merged with appropriate relationship between the columns of the both datasets.
  • The Primary dataset has vast data such as Customer Id & Details, Product Category & Details, Order ID & Date, Delivery Status with Shipment Details.
  • The Primary data mainly holds the measure values such as Order Quantity, Sales per order, Profit per order which gives the Overall Revenue for the Sales.
  • The Secondary data has the Geological Codes such as Latitude, Logitude, State Name & Code.
  • Create a relationship between Customer State from Primary Data and Name in Secondary Data.

HR Attrition Data Analysis

The Reported Data collected from HR Department in a Reputed Firm which contains the Attrition Data.

  • The data is analyzed here to show various valuable insights.
  • The data has various factors such as Employee Detail, Department, Educational Qualification, Job Satisfaction Score, Working Experience at the Firm.
  • The data possess Salary Data of Each Employee, Hourly Rate, Salary Hike Percent.
  • Over-Time Working Hours, Standard Working Hours, Number of Companies Worked in Past, Total Number of Working Years can also extracted from the data.

Pizza Sales Analysis

The Data is from Pizza Store regarding their Sales and Revenue.

  • The Sales data is for the year of 2015 and contains 48,620 sales records.
  • The data has various factors such as pizza id, order id, pizza name id, quantity, order date, order time, unit price, total price, pizza size, pizza category, pizza ingredient and pizza name.
  • The Sales report is analysed to get further insights about sales and revenue.
  • Also, the founded insights is visualized through colourful dashboard units along with the insights statements.

Road Accident Report

The Data has Road Accident Report for the year 2021 and 2022 extracted from Ministry of Road Transport and Highways portal.

  • The data is analyzed to gain multiple insights which can be helpful for the Stakeholders.
  • The data insights can be used to reduce the accidents and to improve emergency rooms in hospitals based on severity.
  • The Possible Stakeholders who gain insights from the report are:
    • Ministry of Transport
    • Road Transport Department
    • Police Force
    • Emergency Services Department
    • Road Safety Corps
    • Transport Operators
    • Traffic Management Agencies
    • Public
    • Media

Rafik's Kitchen Data Analysis

The data is from the Fast-food Restaurant about their Sales and Expenses of the year 2022 which can be used to gain insights that helps business.

  • The collected data is of two datasets. Both the Sales and Expenses data are collected individually.
  • The Relationship is built between Sales and Expenses Data to gain proper and clear inisights for better understanding.
  • The Sales Data consists of the Sales Over a Year 2022 Except holidays which collectively has 38,157 records.
  • The Sales Data has details of Date, Order ID, Item Code, Item Name, Category, Quantity, Price, Total and Payment Mode.
  • The Expenses Data has the exact amount spend on every external expenses along with the discounts amd Store Names.
  • The Expenses Data has details of Date, Expenses Category, Amount, Discount, Final Amount after discount, Paid and Carry Forward.
  • The Sales Data helps to get clear idea about the Revenue and as far expenses data gives idea about expenses which helps to calculate profit and profit margins.