Welcome to Katie’s data portfolio! This article serves as your gateway to understanding data projects that showcase skills in various data-related fields. Here you will learn about the projects, tools utilized, and additional guides that enhance data analysis and programming skills.
Table of Contents
Data Engineering
This section covers various projects related to data engineering, the tools used, and their completion dates.
| Project Link | Completion Date | Tools | Project Description |
|---------------|-----------------|-------|---------------------|
| [Uber Taxi](https://github.com/katiehuangx/data-engineering/tree/main/Uber%20Project) | May 2023 | Python, GCP (Storage, Compute Engine, BigQuery), Mage, Looker Studio | Developed and implemented an end-to-end ETL pipeline for processing NYC Trip Record data... |
| [Dog Adoption](https://github.com/katiehuangx/data-engineering/tree/main/Dog%20Adoption) | Mar 2023 | Python, PostgreSQL, Jupyter Notebook | Designed, created, and deployed a custom data model for a dog adoption dataset... |
SQL
This section highlights various SQL challenges and analyses undertaken.
| Project Link | Area of Analysis | Project Description |
|---------------|-----------------|---------------------|
| [8-Week SQL Challenges](https://github.com/katiehuangx/8-Week-SQL-Challenge) | Data analysis, data cleaning, data transformation | This repo serves as the solution for the 8 case studies from the [#8WeekSQLChallenge](https://8weeksqlchallenge.com)... |
| [Health Analytics Case Study](https://github.com/katiehuangx/Serious-SQL-Apprenticeship/blob/main/Health%20Analytics%20Mini%20Case%20Study.md) | Health analysis | I answer business questions related to patients' data... |
Python
Python plays a crucial role in data analysis, and this section showcases various projects that utilize Python and its libraries.
| Project Link | Area | Project Description | Libraries |
|---------------|------|---------------------|-----------|
| [CS50P - Ongoing](https://github.com/katiehuangx/CS50P/blob/main/README.md) | Programming | This repo contains the solution to the problem sets in [Harvardx CS50P Introduction to Programming with Python](https://www.edx.org/course/cs50s-introduction-to-programming-with-python)... | - |
| [TMDb Movie Analysis](https://github.com/katiehuangx/Udacity-Data-Analyst-Nanodegree/blob/main/Project%202%20-%20TMDB%20Movie%20Analysis.ipynb) | Data Wrangling & EDA | I analyzed more than 10,000 TMDb movies... | pandas, matplotlib |
Tableau
Visualizations using Tableau bring data to life. Here are some projects completed using Tableau.
| Project Description | Dashboard Link |
|---------------------|----------------|
| [Maven Unicorn Challenge](https://github.com/katiehuangx/Maven-Unicorn-Challenge) | Cleansed and transformed data on privately-owned companies (start-ups) valued at over $1 billion... | [Dashboard](https://public.tableau.com/app/profile/katie.huang/viz/UnicornCompanies_16502745371460/Unicorns?publish=yes) |
Katie’s Guides
If you are looking for resources and guides to improve your skills in data analysis or programming, check out the following:
- SQL Resources – A list of free SQL resources compiled for aspiring data analysts.
- Transition into Data Analytics Guide – Essential resources for developing skills in SQL, Python, and Tableau.
- How to Create a GitHub Portfolio – Step-by-step guide to showcasing your projects on GitHub.
Troubleshooting Ideas
If you encounter any challenges while navigating through the projects, consider these troubleshooting steps:
- Ensure that all links provided are correctly formatted and accessible. Sometimes, outdated links can lead to a dead end.
- Check that you have the necessary permissions or access rights, particularly if working with repositories containing sensitive data.
- If you have queries regarding a specific project, reach out to the creator through their GitHub profile for insights.
For more insights, updates, or to collaborate on AI development projects, stay connected with fxis.ai.
At fxis.ai, we believe that such advancements are crucial for the future of AI, as they enable more comprehensive and effective solutions. Our team is continually exploring new methodologies to push the envelope in artificial intelligence, ensuring that our clients benefit from the latest technological innovations.