Hi – I am trying to put the lessons into application while using coronavirus data from Johns Hopkins. It motivates me to try to use what I learn.
I have no idea how to copy and paste here, control c doesn’t work and I can’t take a snippet and attach it…. so… If you guys might be patient help me anyways if you read this that would be great!
—————————————————————————————————————————————————————————————————————–
There are a bunch of attributes for date column headers spanning 3 months of individual dates along with Country Region State or Province:
1/22/20 – 1/23/20 – 1/24/20
I want to flip it like a pivot and put it into one column attribute called month. I started to build a table named Month and insert dates, but I can’t think how best I could join this with my core data.
I would need a primary key identifier to join them and I can’t think it through. I googled and got you can pivot in transformation of data set, but it doesn’t make sense to me. Can anyone help me think through the best way to do this and give me simple steps to follow? I want to be able to use my Months as a dimension as populate the numbers inside it as count and sum by Month, which is why I want to put it into a dimension.
Yes, guys- sites already have it, but how better to learn your new skills after your class than by using real data to do practical things and motivating yourself? What’s more motivating than coronavirus data at the moment?
#LoveinthetimeofCholera #LoveinthetimeofCoronavirus #PayitForwardWheneverYouCan
AS
Hey Christina,
Please provide link to the data so I can help you out.
I am not sure which one are you looking at @Christina Crouch, if you can show me your dataset I can tell you how to organize your data inside Power BI so you can put your knowledge into practice.
I can’t publish a link if you are wanting to view my data set. However, if you just want to see the data for yourself to play around, you can see it in GitHub. I downloaded it last week, but obviously there are a number file sets they are aggregating. Plus, clearly they are updating. Then they have a “research” data set if you wan to try to run it on big data – rather just relational databases. So there is numbers based data and a research data set of videos, articles, stats, etc.. If you google coronavirus data, data science you can find the data repositories they are publicizing. Even if my country gets it under control, I’m sure many countries that could possibly use that data to help themselves.
@dimitar Shutev – I take it for granted that the knowledge is public with in reason. There’s a lot of talent on this website that is probably also driven.. you can get it on GitHub and see if you come up with something. It’s probably the largest repository of any public data.. any country can pull it.