wenbin-billy-zhao
Sr. Data Analyst and BI Specialist with 14 Years of Experience in Finance and Operation Data Reporting, ERP, and Project Management Tasks. Coding and Web Design
LegalZoomAustin, Texas
Pinned Repositories
New-York-City-Bike-Share-Data-Analysis
Property-Values-and-Diversity-of-Austin
This project will examine the relationship between property values and racial demographics in the zip codes areas of Austin, TX from 2011-2017.
Python_API_WeatherPy_Project
This project utilizes OpenWeatherMap API to analyze 500+ world wide cities and their current day weather info
Python_Visualization_Challenge
By utilizing Python's Pandas, Numpy, and Matplotlib modules to produce visually stunning graphs and plots
Spotify_API_Data_Analysis
Team Project of Spotify Data Analysis
Tableau-Excel-Python-PowerBI
This is a project that show the same visualization accomplished by four popular visualization tools
Tensorflow2-Keras-Image-Effect-Transfer
A project that utilizes Tensorflow 2 / Keras Machine Learning tools to generate a pattern/effect transfer from a model image to another
troop70atx-website
Troop70atx Website Project
US-Census-Data-ETL-Project
Python ETL project to extract US Census data to single DataFrame for evaluation
Zillow-Data-ETL-Project
By clean and extract zillow's median home value per zip code, new data set is created for research purposes.
wenbin-billy-zhao's Repositories
wenbin-billy-zhao/Python_Visualization_Challenge
By utilizing Python's Pandas, Numpy, and Matplotlib modules to produce visually stunning graphs and plots
wenbin-billy-zhao/US-Census-Data-ETL-Project
Python ETL project to extract US Census data to single DataFrame for evaluation
wenbin-billy-zhao/Property-Values-and-Diversity-of-Austin
This project will examine the relationship between property values and racial demographics in the zip codes areas of Austin, TX from 2011-2017.
wenbin-billy-zhao/Python_API_WeatherPy_Project
This project utilizes OpenWeatherMap API to analyze 500+ world wide cities and their current day weather info
wenbin-billy-zhao/Tableau-Excel-Python-PowerBI
This is a project that show the same visualization accomplished by four popular visualization tools
wenbin-billy-zhao/Zillow-Data-ETL-Project
By clean and extract zillow's median home value per zip code, new data set is created for research purposes.
wenbin-billy-zhao/Austin-Home-Value-Diversity-School-Rating-Analysis
wenbin-billy-zhao/AustinGraniteDirect-Web
wenbin-billy-zhao/easy_example
wenbin-billy-zhao/Excel_Pivot_Table_Challenge
wenbin-billy-zhao/Google-Map-API-Food-Finder
Use google API to find food
wenbin-billy-zhao/GreatSchools.org-API-to-Dataframe-Python
As part of the ETL project, this sub-project download and process GreatSchool.org API Json objects based on Austin metro area zip codes.
wenbin-billy-zhao/Heros-Of-Pymoli
Based on sales report of gaming series, I created a comprehensive report showing sales stats and summaries
wenbin-billy-zhao/HTML5-GHOST-BLOG
This is my first attempt to use the new Ghost packages to build a dynamic website. I am changing from Wordpress to Ghost.
wenbin-billy-zhao/moderate_example
wenbin-billy-zhao/myapptest
test learning git
wenbin-billy-zhao/Python-Challenge
This repo contains two Python projects: PyBank and PyPoll. Both are projects to be completed from UT Data Analytics Boot Camp
wenbin-billy-zhao/Python-Pandas-Dropna-Function-Examples
This example code show how to use Dropna() function in Pandas to manipulate dataframe
wenbin-billy-zhao/VBA_Challenge
Excel VBA Challenge
wenbin-billy-zhao/VBA_Challenge_2
homework for 2.1-2.2 VBA