Joy Kimaiyo – Medium

Joy Kimaiyo

Joy Kimaiyo

Backing up and Restoring SQL Databases in MySQL (using mysqldump)

Many things can happen to a database, such as accidental deletion or server crashes, so it’s crucial to back up your database regularly to…

Oct 17

Oct 17

Joy Kimaiyo

Data Analysis with Python, SQL, and Power BI

In this project, I am analyzing annual hotel operational data by importing data to SQL using Python, performing aggregation and merging the…

Jun 18

Data Analysis with Python, SQL, and Power BI

Jun 18

Joy Kimaiyo

A multi-page portfolio website for data analysis and deployment on GitHub Pages.

Showcasing your best projects to give potential employers or clients a glimpse of your capabilities is one step every data analyst must…

Jun 3

A multi-page portfolio website for data analysis and deployment on GitHub Pages.

Jun 3

Joy Kimaiyo

Beginner-Friendly Machine Learning Regression Analysis Portfolio Project: A Step-by-Step Guide

We will use the Toyota Corolla CSV dataset for this machine learning regression analysis project. Regression analysis is a form of…

May 31

Beginner-Friendly Machine Learning Regression Analysis Portfolio Project: A Step-by-Step Guide

May 31

Joy Kimaiyo

Importin data to SQL using Python

Importing files to SQL can sometimes be challenging, especially when dealing with multiple CSV files. However, using Python can simplify…

May 30

May 30

Joy Kimaiyo

Scraping Google Search Results with Python

A Search Engine Results Page (SERP) is the compilation of results presented by a search engine when prompted by a specific word or keyword…

May 27

Scraping Google Search Results with Python

May 27

Joy Kimaiyo

Data Analysis with SQL and Python Portfolio Project Part 2

Moving on to the Python analysis part, we’ll start by importing two essential modules: Pandas for data manipulation and SQLAlchemy for…

May 25

Data Analysis with SQL and Python Portfolio Project Part 2

May 25

Joy Kimaiyo

Data Analysis with SQL and Python Portfolio Project

In this project, we’ll utilize data from the Dataset for Renewable Energy Systems available at…

May 23

Data Analysis with SQL and Python Portfolio Project

May 23

Joy Kimaiyo

Joy Kimaiyo

Hey i'm Joy a data analyst, I document my learning on SQL, Python, excel and Machine learning here. Connect with me on github https://github.com/JoyKimaiyo

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams