Hi, I'm

SATHVIK AITHALA

Business & Data Analyst


Welcome to my page!


Stick around to get to know me, check out my projects, view my blog, and get in touch.





Sathvik Aithala

About Me

My name is Sathvik, and I'm a business and data analyst with a passion for helping businesses explore, utilize, and visualize their data to drive decisions.

Throughout my career, I have worked in business, research, medical, engineering, and service-sector environments. Through these varied experiences, I have always been intrigued by the power of data, and by how many companies are either unable or unwilling to unleash this power to guide their business decisions.

I believe that, with a little effort and a deep understanding of the data available, businesses can be taken from good to great.


Skills & Tools:

PowerBI, Tableau, R
Python, SQL, Matlab, VBA
JavaScript, HTML, CSS
Excel, PowerPoint, Word
Data Pipelining (ETL)
Machine Learning
Big Data
Technical Report Writing
Customer Experience Enhancement
Survey Design, Deployment, and Analysis


Portfolio

Here are a few of my favorite projects.

Check out my Blog for detailed write-ups! You can also find more projects at my GitHub Repository.

Craigslist Used Car Dashboard


Creating a relational database of US-based Craigslist used vehicle listings, and building a dashboard to visualize the data.

Tools & Skills Used: SQL, ETL, Python, PowerBI

Blog Post Code

Sample Device Testing Dashboard


Project designed to showcase my company's ability to build a dashboard for a device manufacturing company. Allows the user to track their testing process for multiple devices in various stages of production.

Tools & Skills Used: Python, SQL, SQLite, Database Design, PowerBI

Blog Post

Predicting Housing Prices


Visualizing information that is designed to help someone looking to move to a new city understand the housing market, income, top industry, and quality of life metrics. This tool also includes a near-future price prediction, based on a linear regression machine learning model.

The project was designed to showcase the ETL process, using AWS to create and host a database, testing various machine learning models to try and predict future housing prices, and our ability to visualize and present the information in a dashboard.

Tools & Skills Used: Tableau, Machine Learning, ETL, Python, SQL, AWS

Blog Post Code

Analyzing Cryptocurrencies with PCA Clustering


Analyzing various cryptocurrencies that are currently trading using Unsupervised Machine Learning. Preprocessed data from CryptoCompare for use with the machine learning model, then performed PCA analysis, predicted clusters, and plotted results.

Tools & Skills Used: PCA, SKLearn, Unsupervised Machine Learning

Blog Post Code

Movie Database


Working through the Extract, Transform, and Load (ETL) process to clean and combine three data large sources, generating an extensive SQL database of movies.

Tools & Skills Used: ETL, SQL, Python

Blog Post Code

Mapping Earthquakes


Using JavaScript to visualize the differences between the global earthquakes recorded in the past seven days, including tectonic plate overlays and multiple map views.

Tools & Skills Used: JavaScript, Leaflet, D3

Blog Post Code

Weather Analysis


Building a travel itinerary for a user based on their weather preferences. In order to accomplish this, I used Google Maps APIs to build a database of cities around the world, including their weather descriptions.

Tools & Skills Used: Python, APIs, Mapping

Blog Post Code

Building This Professional Portfolio Website


Building a website to showcase my resume, skills, projects, and contact information.

Tools & Skills Used: HTML, CSS

Blog Post Code

Education

The University of California, Berkeley

Data Analytics Boot Camp | 2020

The University of Texas at Austin

B.S Physics, Radiation Physics and Nuclear Engineering | 2012 - 2016

Contact Me