Scribd
Upload
47 views8 pages

Assignment 2

The document summarizes the steps taken to clean and visualize data in Power BI. It describes cleaning the data by removing remarks, changing date columns to the date type, and replacing missing data. It then discusses visualizing the cleaned data to understand meaningful information, finding that maximum investment was in quarter 3 of 2015 and quarters 1 and 2 of 2017. Bangalore was the most preferred location for investment, followed by New Delhi and Mumbai. The most preferred industry was consumer internet, followed by e-commerce and technology. Softbank was the top investor, followed by Microsoft and Steadview Capital. Paytm was the most funded startup, followed by Flipkart and Ola.

Uploaded by

Sheikh Zain Uddin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
47 views8 pages

Assignment 2

The document summarizes the steps taken to clean and visualize data in Power BI. It describes cleaning the data by removing remarks, changing date columns to the date type, and replacing missing data. It then discusses visualizing the cleaned data to understand meaningful information, finding that maximum investment was in quarter 3 of 2015 and quarters 1 and 2 of 2017. Bangalore was the most preferred location for investment, followed by New Delhi and Mumbai. The most preferred industry was consumer internet, followed by e-commerce and technology. Softbank was the top investor, followed by Microsoft and Steadview Capital. Paytm was the most funded startup, followed by Flipkart and Ola.

Uploaded by

Sheikh Zain Uddin
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 8

ASSIGNMENT -2

POWER BI
Made by:
Zain Uddin
PGDM HR
DM18A60
TEXT

BEGINNING
▸ First the data cleaning is done

▸ The remark column was removed as most of the data was not
available.

▸ Date column type was changed from text to date.

▸ Missing data was replaced from most of the column

▸ Data ambiguity was also removed

▸ After cleaning the data we started with data visualisation so to


understand to get the meaningful information from the given data
TEXT

MAXIMUM INVESTMENT IS SEEN IN QUARTER-3 OF 2015, FOLLOWED BY


QUARTER-2 AND QUARTER-1 OF 2017
TEXT

BANGALORE IS THE MOST PREFERRED LOCATION, FOLLOWED BY NEW DELHI


AND THEN MUMBAI
TEXT

CONSUMER INTERNET IS THE MOST PREFERRED INDUSTRY, FOLLOWED BY E-COMMERCE


AND THEN TECHNOLOGY
TEXT

SOFTBANK IS THE TOP INVESTOR, FOLLOWED BY MICROSOFT AND THEN STEADVIEW CAPITAL.
TEXT

PAYTM IS THE MOST FUNDED STARTUP COMPANY, FOLLOWED BY FLIPKART AND THEN OLA
THANK
YOU

You might also like