Joseph Steiner | Data Analyst
​
Welcome to my portfolio
Hi, I'm a dedicated Data Analyst who delves into SQL and Python to drive transformative business insights. My work has directly boosted revenue for several businesses by turning vast data sets into clear, actionable plans. Beyond crunching numbers, I craft compelling data narratives using tools like pandas, numpy, and platforms such as Power BI and Tableau. With a focus on making data approachable, I aim to spark growth and inspire change. Let's discover the stories your data can tell!
My Skills and Expertise
As a data analyst, I possess expertise in data cleaning, data modeling, and statistical analysis. I have hands-on experience in SQL, Excel, Tableau, Python, and Power BI. My ability to translate complex data into insights and communicate findings to stakeholders is one of my fortes.
Data Cleansing
I have experience working with noisy data and identifying outliers in data sets
Statistical Analysis
I use various statistical models and machine learning techniques, i.e., regression, clustering, and decision trees to model data and generate business insights.
Data Visualization
I design custom intuitive and attractive Tableau dashboards that help stakeholders quickly understand and act on insights.
Projects I have worked on
Throughout my career, I have worked on several innovative and challenging projects. Here are some recent data analysis projects I have delivered.
-
Detailed analysis of product availability for the bikes and stations of Baywheels in San Francisco, Oakland, and San Jose.
-
Sorting data and analyzing data through tools such as PostGre SQL and Tableau
-
Made visualizations in Tableau and creating a spider map of the various station-to-station routes.
-
Created a time series breaking down the average ride time and another time series analyzing bike traffic at stations.
-
Performed high level analysis with visualizations detailing the wind market and the specific turbines, manufacturers, and operators that would be most beneficial to invest in.
-
Compared rotor size to energy efficiency using a tree map and a line graph.
-
Recommended the operators that would be best suited to receive an investment and left a variety of choices as to start a bidding war for ownership stake.
-
Identified the most explanatory MLB statistics that correlate to winning games through bar graphs and scatter plots.
-
Created Tableau reports about the winningest teams in the MLB’s steps to success, evaluating ERA, OPS, and more relative statistics.
-
Made a recommendation on which players to pursue if money was not an object based on their ERA+ and OPS+ numbers.
Tools and Technology I use
Excel
I use Excel for data cleaning, modeling and visualization of insights.
Tableau
I create custom dashboards and stunning visualization that allow stakeholders to understand and act upon insights better.
SQL
I use SQL to mine data from large datasets and generate reports and recommendation.
My approach to Data Analysis
Over time I have discovered what works best for me, I believe in well defined methodology that includes the steps
- Define the problem/question
- Collect, cleaning and processing data
- Exploring, visualizing and analyzing data
-Communicating finding and insights
-Iterating and refining the approach as much as needed
Phone
713-392-6665