Google Data Analytics Project - Using Python and Excel смотреть онлайн

Hi everyone,
This is my first Data Analytics Project. It took a lot of effort to achieve, and it probably isn't perfect but I am quite happy with it being a first attempt.

The information as well as the data base for this project was obtained from the GOOGLE Data Analytics module 8 - Capstone project.

Although the certificate teaches spreadsheets, BigQuery and R, I chose to self-teach python, because it is the most popular language being used here in Australia, and also popular in job descriptions.

So, this is what I achieved in 1 week of python tutorials; special thanks to all the content creators that make so interesting and useful videos! I have left a special thanks in the coding to each one of them as comments at the end of the cleaning and organizing data phase.

If you were as frustrated as I was at the start of the project trying to figure out how to do it, and how to manipulate such a big data set (spoiler alert, I couldn't do it with excel, it is too big!) I tried a bit of visual basic & power query but perhaps my level of advanced excel is not enough. I suggest using query languages or programming languages for this project.

Link to my github repository for this project, where you can have a look at the coding I used for python in this project. Hopefully this can help you get some ideas and pass the roadblocks ahead.

https://github.com/BKSDA/BKSDA.github.io

For the graphs in the presentation, I exported the filtered tables from python into excel to do graphs a bit nicer using a tool I was more familiar with.

The rest is all done with PowerPoint.

Thank you everyone for watching, this is just the beginning!