Python App / Database - ( Inventory )
econ_img Open Project In New Tab
Link :
DB_UI_img
  • SUMMARY : Full Stack Database Inventory System.

  • Created relational database for inventory mgmt w/ one-page UI web interface, one click data reporting & upload. (To See UI feature screenshots & detailed summary CLICK upper right Link )

  • Wrote versatile Python ETL script to ingest and transform online XML or local CSV data, with DB upload & error log reporting.

  • Automated ETL - with duplicate filtering, data formatting, writing to offline logs, and bulk data uploads

  • JavaScript implemented to listen, and process user HTML query requests to and from REST API.

  • DB results dynamically output to formatted HTML tables, with CSV & PDF download options.

  • Database (SQLITE3) - w/ automated triggers (conditional / procedural) saved views/queries for client ease

  • Tech Stack: Python, SQL, SQLite3, SQLAlchemy, Flask, JavaScript, D3, HTML, CSS, REST API

  • To See UI feature screenshots CLICK upper right Link




Tableau Analysis - (City Bike Rentals)
econ_img Open Project In New Tab
Link :
Tableau Story
  • SUMMARY : Analyzed 15 million rows of NY City Bike Share data using Tableau

  • Created & Deployed Online Visual Tableau Story & Dashboard. (Click Link Above to View Online)

  • Visualized trends in bike usage by age, gender, time of year, bike id

  • Created bike route path taken by single bike across NY area on given day--at a glance profound insights are visually interpreted

  • Technology Utilized : Tableau









econ_img
  • SUMMARY : Deployed HTML Interactive Visualization. (Click Link Above to View Online)

  • Collaborated with small team to produce "global map" via interactive webpage, with countries color coded by economic categories

  • Provided full stack development, ETL for GEOJSON automated updating, created a database & queries w/ flask API integration, front end user control, JavaScript JSON pointers, map color formatting by category, tooltip info by country.

  • Technology Utilized : VS Code, JavaScript, HTML,Leaflet,D3,GEOJSON,Python Flask & Pandas,SQL Alchemy,SQLite,DB Browser



Statistical Analysis - (Health Care Costs)
git_img Open Git Hub Repo In New Tab
Link :
health_img
  • SUMMARY : Statistical Visualization Null Hypothesis

  • Collaborated with a small team to analyze specific healthcare costs across all hospitals in three states with Medicare data

  • With ETL, categorized, binned, merged, cleaned, organized data for statistical evaluation/visualization, automated the visualization & statistical testing of null hypothesis for cost variance correlations.

  • Technology Utilized : Python Pandas Jupyter Notebook : Numpy, Plotly, github


Visualization - (Health Care)
econ_img Open Project In New Tab
git_img Open Git Hub Repo In New Tab
Links :
health image
  • SUMMARY : HTML interactive chart of healthcare factors by state. (Click Link Above to View Online)

  • Interactive Axis category selector, responsive axis values, animated transitions, tooltips, screen responsive

  • Technology Utilized : D3 JavaScript, HTML, CSS



Weather API Project
  • SUMMARY : Interactive visual dashboard with charts displaying common belly button bacteria data points. (Click Link Above to View Online)

  • Drop down menu to select various test samples

  • Multiple charts and legends fit nicely together to display information, from database

  • Technology Utilized : Python Flask, D3 JavaScript Visualization, JavaScript API, Pandas SQL Alchemy, Heroku deployed


Visualization / API - (Weather)
econ_img Open Project In New Tab
git_img Open Git Hub Repo In New Tab
Links :
Weather API Project
  • SUMMARY : Evaluated weather conditions of 600 random cities spread across the globe for Temperature, Humidity, Cloudiness, and Wind Speed. (Click Link Above to View Online)

  • Used Bootstap elements to construct multi-page navigation site, with interactive toolbars, visualizations and screen size responsiveness

  • Used automated API based data collection method in Pandas Jupyter Notebook

  • Generated scatter plot visualizations of weather data

  • Technology Utilized : Python Pandas Jupyter Notebook, API, HTML, CSS


Machine Learning (Image) - Food Snap
git_img Open Git Hub Repo In New Tab
Link:
Food_Snap_img
  • SUMMARY : HTML Interactive Machine Learning Image Detection

  • Collaborated with a small team to use Machine Learning to detect ingredients in user photo image and produce recipes /calories

  • Provided Full Stack Development - Overall Site Integration : with HTML template, JavaScript, Python Flask

  • Created the user interface as HTML template with Bootstrap elements, and extensive CSS Style Sheet

  • Integrated the trained Image Detection Model and Tensor Session into Flask route to automate image retrieval & save associated result image

  • Utilized ETL - to clean and format, output list from Image Detection Model results

  • Used Flask for various API calls to perform tasks (such as image placement and Running ML Model) based on User input (clicking submit buttons)

  • D3 JavaScript: to listen to events in the HTML, gather values from HTML, and Insert certain HTML elements (such as the checkboxes)



Game GIF
  • SUMMARY : Created & Deployed a fully functional (single player) PC game app. Created all visual graphics, audio, and game design. (Click Link Above to View Online)

  • Created scripts that used script to script communication, script object self awareness, were optimized, modular, pausible

  • Scripts created for: user input, obj /enemy ai behavior & controllers, menus, sequenced events, analytics reporting & audio

  • Technology Utilized : Unity 3D Engine, Mono Development, 95% JavaScript, 5% C#


Link 4 - Python Game
git_img Open Git Hub Repo In New Tab
Link :
link4_img
  • SUMMARY : A simple interactive game using Python, and simple text based graphics

  • Playable in Bash Terminal, user vs user, user input, automated rapid list comprehension to determine horizontal, vertical, or diagonal win solutions of match four in a 6x6 array grid, with looped states.

  • Random bot vs bot with game summary data extraction via csv, 1000 games play in 1 minute. Basic developer testing controls.

  • Next steps: Machine Learning AI opponent. HTML interface with Flask.




COPYRIGHT BRANDON STEINKE (C) 2020