Insights and visualization of real life data by a beginner in Data Science.

Hello guys today I am going to share my experience of working on a data set, getting the insights about the data and visualizing the data using Power BI.

I worked on data set of a US based cab service. I got the raw data in csv file format. I used excel initially to filter the data. The major fields in the data were Trip_ID, Duration, Start_Date, Start_Station, Subscribe_type (Subscriber or customer).Following are the challenges I faced and then how I overcome those challenge.

The data had date and time together in same Start_Date column and I had to take out day in form of weekdays and time in HHMM separately. To do I used TEXT() function in excel and made two new columns containing day and time.

When imported the data in PowerBI there were certain columns whose data type was not correct. To fix this i went into query editor and then transformed the type of the columns i wanted and applied the changes.

I also performed filter operation to filter certain rows.

After visualizing the data and plotting certain number of charts and then applying filter to it I got certain insights which are as follows:

1) The overall number of subscribers were much more than total number of customers.

2) The customers who were using this cab service on working days i.e from Mon to Fri were mostly subscribers and very few customers but on the weekends there was a drastic change in this number and the number of customers were higher than number of subscriber.

3) The peak hours of cab service from Mon to Fri ranged from 8 to 10 in the morning and then 5 to 7 in the evening.

4) The peak hours of similar cab service were completely different on weekends and they ranged from 12 P.M. to 6 P.M.

These were certain insights which I got and I was able to do this within couple of days.

I am also attaching a couple of screenshots which will give you a better idea of my work.

I hope this was helpful for you guys and I will keep on posting these kind of articles about the work which I am doing and tools which I am learning while getting trained in Data Science at AIC by professionals from Stockbay Partners.

#DataScience #AI #AIC