Name: James
Type: User
Company: Astrica
Bio: Problem solver, hack of a coder in Python, Scala and SQL. Oddly attracted to Data Science and Engineering that requires big data and problem solving.
Location: Charlotte, North Carolina
Blog: https://jkenney.dev
James's Projects
This project builds a pipeline from AWS S3 storage to a Redshift Cloud hosted Cluster where an ETL process extracts the staged data and creates a STAR Schema to allow business users to query the data easier for business intelligence.
AWS Pipeline examples from Udacity Date Engineering Nanodegree.
A python/django real estate website with fully dynamic web pages and a content management system. Check out the demo link and sign up to test out the features! This site features a CMS that allows the admin to upload new listings and realtors while also providing the customer with an account page/dashboard to view their inquiries. Contact inquiry form is functional as well. All data is stored via Postgres database.
A simple example of an HR database design using a PostgreSQL database with entity relationship diagrams (conceptual-physical), business requirements and technical requirements to guide the 3rd normal form modeling of an HR database for an organization.
ETL demo with Apache Cassandra
This project is a data engineering simulation where a JSON file is extracted, loaded and transformed into a STAR schema for business intelligence users. The project simulates what a big data pipeline would fundamentally require when extracting data from a application that is used by hundreds to millions of users.
Data engineering project with Azure and Databricks. This project is underway and is updated as it is worked on. There are parts that arte not included becasue they are completed with the Azure UI and not IAC. The data is using the Ergast API for formula 1 racing results since the 1950's to current.
A Python/Django blog that is open to all for user functionality testing. Sign up, log in, test the profile update (CRUD) features, add a profile pic and make a post! Visit the demo:
This is a Python application using Django framework. The purpose is to utilize API and database features to make a small Portfolio that allows the user to add stock by ticker symbols.
A simple to-do application utilizing bootstrap 4.4 for front end while utilizing SQL lite for back end task loading. Application is designed for easy user edits and as practice to connect front end to the database using python inside Django framework.
An application that displays the air quality by zip code using Python inside Django framework. A user enters their zip and the air quality is provided for that zip. It has simple functionality and is designed to use an API for its data output.
Capstone project for IBM Data Science Professional Certificate. Project uses the Foursquare API to analyze popular venues for dining. Python is then used to explore neighborhoods and pull in NYC outdoor dining data to explore some neighborhoods where restaurants have been opened for outdoor dining.
A front end web design using CSS3 and jQuery for scroll and easing effects. Fully mobile responsive with fully functional contact form. See demo below!
A simple parallax design
A simple user regsitration and authorization which directs the user to an account page.
A simple guide to using Pandas and its many features for data analysis.
A python repository for Supervised Machine Learning examples and projects. Will be continuously updated.
Just a bIt of practice with R. This is a demonstration of the various tools in R and to be used as a reference. More to be added in the future as it is accumulated. At some point it will be converted into Jupyter notebooks for easier reference to the concepts. My goal to is to make a really good and simple reference for some common scenarios we use in data science.
Simple Google product design to demonstrate slide in and scroll effects. Refactored with Bootstrap 4.4.1 and using JS/JQ to animate slide effects. Project is a Brad Traversy design from his Youtube channel @ Traversy Media. See demo link below:
This project uses flat JSON and CSV files through an ELT process and compares yelp reviews over a set date range with weather trends to analyze the effects of weather data on reviews. snowflake is used to import data from JSON and CSV files to merge data sets and conduct a comparative analysis. This IS NOT finished yet!