tylerengalla
Projects done through The University of Texas Data Analytics Bootcamp. Technology used: Excel, VBA, Python, Javascript, Tableau, R, and SQL.
Austin, Tx
Pinned Repositories
Belly_Button_Dashboard
Week 12 Project: used JavaScript, Plotly, D3.json() to fetch external data, such as CSV files and web APIs and create an interactive dashboard.
Mapping_Earthquakes
Week 14 Project: Mapping GeoJSON data on an interactive map. Learned how to create new branches and merge those branches back to the main one in GitHub for code iterations. Retrieve data from GeoJSON files. Make API requests to a server to host geographical maps. Populate those maps with the data using JavaScript and the Data-Driven Documents (D3) library. Using Leaflet adding multiple map layers and control plugins to add user interface controls. Use JavaScript ES6 function to add GeoJSON data, features, and interactivity to maps. And render maps on a local server.
Mission-to-Mars
Week 10 Project: BeautifulSoup, Splinter, Pandas, MongoDB, HTML, and Flask. Gain familiarity with and use HTML elements, as well as class and id attributes, to identify content for web scraping. Use BeautifulSoup and Splinter to automate a web browser and perform a web scrape. Create a MongoDB database to store data from the web scrape. Create a web app with Flask to display the data from the web scrape. Use Bootstrap components to polish and customize.
Pewlett-Hackard-Analysis
Week 7 Project - SQL, Postgres. Design an ERD that will apply to the data. Create and use a SQL database. Import and export large CSV datasets into pgAdmin. Practice using different joins to create new tables in pgAdmin. Write basic-to intermediate-level SQL statements.
PyBer_Analysis
Week 5 Project - Jupyter Notebook, Matplotlib, Python, and Pandas. Created line, bar, scatter, bubble, pie, and box-and-whisker plots using Matplotlib. Determine mean, median, and mode using Pandas, NumPy, and SciPy statistics.
UFOs
Week 11 Project: JavaScript. Built and deploy JavaScript functions, including built-in functions. Convert JavaScript functions to arrow functions. Build and deploy forEach (JavaScript for loop). Create, populate, and dynamically filter a table using JavaScript and HTML.
bikesharing
Week 15 Project - Tableau. Created and styled worksheets, dashboard, and stories.
Election-Analysis-Challenge
Week 3 Project - Python. Create scripts that read, write, and store data from files such as CSVs or in arrays. Use of decision statements, logical operations for complex comparisons, repetition statements, boolean and logical operators to write data to an output file and print it.
kickstarter_analysis_challenge
Week 1 Challenge during my UT Data Bootcamp utilizing Excel: pivot tables, filters, conditional formatting, formulas. Calculate summary statistics such as measures of central tendency, std dev, and variance. Perform analysis with visualizations.
Movies-ETL
Week 8 Project: ETL - Extract, Transform, Load. Create an ETL pipeline from raw data into a SQL database. Extract data from disparate sources using Python. Clean and transform data using Pandas. Use regular expressions to parse data and to transform text into numbers. Load data with PostgreSQL.
tylerengalla's Repositories
tylerengalla/resume
tylerengalla/Mission-to-Mars
Week 10 Project: BeautifulSoup, Splinter, Pandas, MongoDB, HTML, and Flask. Gain familiarity with and use HTML elements, as well as class and id attributes, to identify content for web scraping. Use BeautifulSoup and Splinter to automate a web browser and perform a web scrape. Create a MongoDB database to store data from the web scrape. Create a web app with Flask to display the data from the web scrape. Use Bootstrap components to polish and customize.
tylerengalla/Neural_Network_Charity_Analysis
tylerengalla/Final_Project
tylerengalla/tylerengalla
Config files for my GitHub profile.
tylerengalla/Cryptocurrencies
tylerengalla/Credit_Risk_Analysis
tylerengalla/Amazon_Vine_Analysis
tylerengalla/MechaCar_Statistical_Analysis
tylerengalla/WeatherPy
Week 6 Project - Python APIs. Perform tasks using new Python libraries and modules. Retrieve and use data from an API "get" request to a server. Retrieve and store values from a JSON array. Use try and except blocks to resolve errors. Create scatter plots using the Matplotlib library, and apply styles and features to a plot. Perform linear regression, and add regression lines to scatter plots. Create heatmaps, and add markers using the Google Maps API.
tylerengalla/Mapping_Earthquakes
Week 14 Project: Mapping GeoJSON data on an interactive map. Learned how to create new branches and merge those branches back to the main one in GitHub for code iterations. Retrieve data from GeoJSON files. Make API requests to a server to host geographical maps. Populate those maps with the data using JavaScript and the Data-Driven Documents (D3) library. Using Leaflet adding multiple map layers and control plugins to add user interface controls. Use JavaScript ES6 function to add GeoJSON data, features, and interactivity to maps. And render maps on a local server.
tylerengalla/bikesharing
Week 15 Project - Tableau. Created and styled worksheets, dashboard, and stories.
tylerengalla/Belly_Button_Dashboard
Week 12 Project: used JavaScript, Plotly, D3.json() to fetch external data, such as CSV files and web APIs and create an interactive dashboard.
tylerengalla/practice
tylerengalla/UFOs
Week 11 Project: JavaScript. Built and deploy JavaScript functions, including built-in functions. Convert JavaScript functions to arrow functions. Build and deploy forEach (JavaScript for loop). Create, populate, and dynamically filter a table using JavaScript and HTML.
tylerengalla/portfolio
tylerengalla/Pandas-Data-Science-Tasks
Set of real world data science tasks completed using the Python Pandas library
tylerengalla/surfs_up
Week 9 Project: Python, SQLAlchemy, and Flask. Explain the structures, interactions, and types of data of a provided dataset. Differentiate between SQLite and PostgreSQL databases. Use SQLAlchemy to connect to and query a SQLite database. Use statistics like minimum, maximum, and average to analyze data. Design a Flask app using data.
tylerengalla/Movies-ETL
Week 8 Project: ETL - Extract, Transform, Load. Create an ETL pipeline from raw data into a SQL database. Extract data from disparate sources using Python. Clean and transform data using Pandas. Use regular expressions to parse data and to transform text into numbers. Load data with PostgreSQL.
tylerengalla/Pewlett-Hackard-Analysis
Week 7 Project - SQL, Postgres. Design an ERD that will apply to the data. Create and use a SQL database. Import and export large CSV datasets into pgAdmin. Practice using different joins to create new tables in pgAdmin. Write basic-to intermediate-level SQL statements.
tylerengalla/PyBer_Analysis
Week 5 Project - Jupyter Notebook, Matplotlib, Python, and Pandas. Created line, bar, scatter, bubble, pie, and box-and-whisker plots using Matplotlib. Determine mean, median, and mode using Pandas, NumPy, and SciPy statistics.
tylerengalla/School_District_Analysis
Week 4 Project - Jupyter Notebook and Pandas. Skills used were reading an external CSV file into a dataframe for formatting and analysis. Merge, filter, slice, and sorting of data. Use of groupby() function and multiple methods to perform a function on a dataframe.
tylerengalla/Election-Analysis-Challenge
Week 3 Project - Python. Create scripts that read, write, and store data from files such as CSVs or in arrays. Use of decision statements, logical operations for complex comparisons, repetition statements, boolean and logical operators to write data to an output file and print it.
tylerengalla/Election_Analysis
tylerengalla/newrepo
tylerengalla/stock-analysis
Week 2 Project of Bootcamp: Create a VBA macro that can trigger pop-ups and inputs, read and change cell values, and format cells. Use for loops and conditionals to direct logic flow. Use nested for loops.
tylerengalla/kickstarter_analysis_challenge
Week 1 Challenge during my UT Data Bootcamp utilizing Excel: pivot tables, filters, conditional formatting, formulas. Calculate summary statistics such as measures of central tendency, std dev, and variance. Perform analysis with visualizations.
tylerengalla/kickstarter-analysis
Performing analysis on Kickstarter data to uncover trends