Hi there 👋, I'm Samuel Ayer
- A data analyst leveraging SQL, MS Excel, Power BI and Python to extract actionable insights from data
- Skills include:
- Data Collection and Consolidation
- Data Assessment and Cleaning
- Data Modelling
- Data Analysis and Visualization
- Report Writing and Insights Communication
- 📝 I write blogs on my projects and Data Analytics on Medium
- 📫 Reach me via email at ayersamuel210@gmail.com or via:
- SQL (PostgreSQL, MySQL)
- MS Excel
- Power BI
- Python (Numpy, Pandas, Matplotlib, Seaborn)
| Project | Tools | Description |
|---|---|---|
| 8 Week SQL Challenge | PostgreSQL | Wrote SQL queries to find solutions to various business questions in various industries including:
|
| Data Wrangling and Analysis |
|
Gathered and analyzed tweets on dog ratings by WeRateDogs. Activities include:
|
| Investigating Show/NoShow to a medical appointment |
|
Performed exploratory data analysis to identify factors that are important to predict if a patient will show up for their medical appointment. |
| Ford GoBike System Data Analysis and Visualization |
|
Performed exploratory data analysis by analyzing and visualizing univariate, bivariate and multivariate relationships between the variables in the data. Generated explanatory data visuals by formatting visuals to tell a story using the insights discovered during exploratory data analysis. Prepared a slide deck to display explanatory visuals. |
| Superstore Sales Report | Power BI | Analysis of the sales of a superstore over a period of 4 years |