Alex-The-Analyst-Bootcamp

KO | EN

gitlite — search

#javascript #python #hacktoberfest #react #ai #typescript #llm #go #golang #android #machine-learning #rust #deep-learning #linux

Alex-The-Analyst-Bootcamp

(★ 40)

This repository contains all the portfolio projects I made while completing Alex The Analyst's Bootcamp on YouTube

Alex-The-Analyst-Bootcamp Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# Alex The Analyst Bootcamp
This repository contains all the portfolio projects I made while completing Alex The Analyst's Bootcamp on YouTube.

## SQL

I own a Mac so I am using MySQL Workbench to complete the SQL projects. For this reason, I have adapted my code so that it works in MySQL. I ran into errors for some of the code which I have commented on, tried to solve myself and found alternative queries. Hope this repository helps anyone else out there doing this bootcamp also using MySQL :)

## Excel

For the Excel Full Project, I created a dashboard on bike sales and you can see the output below for reference. I plan to work on creating a different or expanding on this dashboard to test my skills in the future.

## Tableau

For the Tableau Full Project, I created a dashboard on 2016 Seattle Airbnb data and you can see the output below for reference. I plan to work on using a different dataset to visualise data in Tableau in the future.

![Dashboard 2](https://user-images.githubusercontent.com/119052310/222602000-371f0de8-ee29-4e0e-b809-dc052d7c700f.png)

## Power BI

For Power BI, I used [Parallels Desktop](https://www.parallels.com/) to access Windows to download Power BI Desktop to complete the project on my Mac. Parallels Desktop provides a 14 Day Free Trial and I recommend using this to learn Power BI for Mac users. For the Full Project, I created a dashboard to analyse data on Data Professional Survey collected by Alex and below is the output. I plan to make use Power BI again to make my own visualisations and dashboard.

![Data-Professional-Survey-Final-Project](https://user-images.githubusercontent.com/119052310/222852357-7acba5ed-0264-456e-aef8-e950dd5840ad.png)

## Python

For the Python Data Analyst Projects, I completed both using an IDE that I use personally - PyCharm, instead of Jupyter Notebooks that Alex recommended. I had experience doing webscraping and using APIs to pull data prior to completing the projects through this bootcamp. The projects were a good recap of these skills and I started to learn seaborn and matplotlib to visualise data with the Crypto API project. I plan to expand my python knowledge using DS related libraries such as pandas, matplotlib, plotly, numpy etc. Below is a data visualisations I created to show the Bitcoin's price change over 90 days. You can also find more python projects I have completed on my repository: [100 Days of Code Python](https://github.dev/denisecodes/100-Days-of-Code-Python).

![Figure_1](https://user-images.githubusercontent.com/119052310/222988583-6e62b73b-881b-4db6-86b3-a0d6640368e7.png)

Alex-The-Analyst-Bootcamp

Alex-The-Analyst-Bootcamp Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Alex-The-Analyst-Bootcamp

Alex-The-Analyst-Bootcamp Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README