Skip to content
View Outis09's full-sized avatar
12 followers · 3 following
Block or Report

Block or report Outis09

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Please don't include any personal information such as legal names or email addresses. Maximum 100 characters, markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Outis09/README.md

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
LinkedIn Badge Medium Badge Twitter Badge

Tools 👨‍💻

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

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

GitHub Streak

Blog posts

Pinned

  1. 8-Week-SQL-Challenge 8-Week-SQL-Challenge Public

    Analyzing and solving various business problems using PostgreSQL

    9 3

  2. Property-Pricing-Analysis Property-Pricing-Analysis Public

    Analysis of property pricing using Python

    HTML

  3. Data-Wrangling-and-Analysis Data-Wrangling-and-Analysis Public

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

    HTML

  4. Investigating-medical-appointment-show-no-show Investigating-medical-appointment-show-no-show Public

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

    HTML

  5. Superstore-Sales-Report Superstore-Sales-Report Public

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

    1

  6. Ford-GoBike Ford-GoBike Public

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

    HTML