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 [email protected] or via:

Tools 👨‍💻

SQL (PostgreSQL, MySQL)
MS Excel
Power BI
Python (Numpy, Pandas, Matplotlib, Seaborn)

Featured Projects

Project	Tools	Description
8 Week SQL Challenge	PostgreSQL	Wrote SQL queries to find solutions to various business questions in various industries including: health analytics marketing analytics people analytics financial markets fast moving consumer goods digital marketing
Data Wrangling and Analysis	Python (NumPy, Pandas, Matplotlib) Power BI	Gathered and analyzed tweets on dog ratings by WeRateDogs. Activities include: gathering data from 3 sources assessing data cleaning data statistical analysis and visualizations deriving insights visualising insights on a Power BI report
Investigating Show/NoShow to a medical appointment	NumPy Pandas Matplotlib	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	NumPy Pandas Matplotlib Seaborn	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

Blog posts

Samuel Ayer's Projects

8-week-sql-challenge

Analyzing and solving various business problems using PostgreSQL

blossom-academy-assignments

This repo contains my submission for assignments given as part of my data analytics fellowship with Blossom Academy

corruption-perception-index

Analyzing Ghana and Africa's corruption perception index over the last decade

data-engineering-zoomcamp

This repo contains files I am using to learn data engineering in the data engineering zoomcamp by DataTalks Club

data-wrangling-and-analysis

Udacity project: gathering and cleaning data from the tweet archive of a Twitter user that rates dogs and analyzing to derive insights

ford-gobike

Analysis of Ford GoBike System data using NumPy, Pandas, Matplotlib and Seaborn

games

Repo for Microsoft 365 development purposes

investigating-medical-appointment-show-no-show

Udacity project: Analyzing variables that can be used to predict whether a patient will show up for their medical appointment

outis09

Config files for my GitHub profile.

property-pricing-analysis

Analysis of property pricing using Python

samuelayer.github.io

Files for my portfolio website

superstore-sales-report

Analysis of sales of a superstore over a period of four years and developing reports to summarize insights and display KPIs.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.

Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

TensorFlow

An Open Source Machine Learning Framework for Everyone

Django

The Web framework for perfectionists with deadlines.

Laravel

A PHP framework for web artisans

D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

web

Some thing interesting about web. New door for the world.

server

A server is a program made to process requests and deliver data to clients.

Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

Visualization

Some thing interesting about visualization, use data art

Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.

Microsoft

Open source projects and samples from Microsoft.

Google

Google ❤️ Open Source for everyone.

Alibaba

Alibaba Open Source for everyone

D3

Data-Driven Documents codes.

Tencent

China tencent open source team.

outis09 Goto Github PK