Intro

A Data Analyst skilled in the areas of SQL, Python, Tableau, Microsoft PowerBI, Microsoft Excel, and R Studio.

My primary objective as a data analyst is to steer the company towards higher profits by providing business insights that are generated from rigorous data analysis.

Thank you for your time in checking out this portfolio that I have created to help showcase my work in hopes to land a Data Analyst position at your company!

By the way, check out my awesome work!

SQL Projects

Using a .CSV file to create a MySQL Database, a MySQL Table, and a few sample SQL Queries for Data Analysis.

Using an ER diagram for a sample DVD Rental Company to create SQL code for a company report.

Using an ER diagram to author the code needed to create an SQL database for the Coffee Company.

Using an Bagel Company order form to build an ER Diagram for a SQL database.


Python Projects

This project analyzes A&B Test Results using Python.

Analysis of the TMDB-movies dataset with Python.

This project is about Data Modeling with Postgres using Python.

Supervised Machine Learning on US Census data for finding charity donors.

Gathering, Exploring, & Visualizing the WeRateDogs Twitter account.

Using Python to do a simple analysis of an online job posting dataset.


About

My name is John Bailey and I am a Data Analyst with a passion to continue expanding my knowledge in the field of Analytics. I currently have over 7+ years experience with exploratory data analysis and reporting, a Bachelor's Degree in Data Management/Data Analytics, and multiple certifications in the Data Analytics/Information Technology field. My previous employment as a data analyst was in Healthcare, but I am open to utilizing my skill set in any industry.

Elements

Text

This is bold and this is strong. This is italic and this is emphasized. This is superscript text and this is subscript text. This is underlined and this is code: for (;;) { ... }. Finally, this is a link.

Heading Level 2

Heading Level 3

Heading Level 4

Heading Level 5
Heading Level 6

Blockquote

Fringilla nisl. Donec accumsan interdum nisi, quis tincidunt felis sagittis eget tempus euismod. Vestibulum ante ipsum primis in faucibus vestibulum. Blandit adipiscing eu felis iaculis volutpat ac adipiscing accumsan faucibus. Vestibulum ante ipsum primis in faucibus lorem ipsum dolor sit amet nullam adipiscing eu felis.

Preformatted

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';

Lists

Unordered

  • Dolor pulvinar etiam.
  • Sagittis adipiscing.
  • Felis enim feugiat.

Alternate

  • Dolor pulvinar etiam.
  • Sagittis adipiscing.
  • Felis enim feugiat.

Ordered

  1. Dolor pulvinar etiam.
  2. Etiam vel felis viverra.
  3. Felis enim feugiat.
  4. Dolor pulvinar etiam.
  5. Etiam vel felis lorem.
  6. Felis enim et feugiat.

Icons

Actions

Table

Default

Name Description Price
Item One Ante turpis integer aliquet porttitor. 29.99
Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
Item Three Morbi faucibus arcu accumsan lorem. 29.99
Item Four Vitae integer tempus condimentum. 19.99
Item Five Ante turpis integer aliquet porttitor. 29.99
100.00

Alternate

Name Description Price
Item One Ante turpis integer aliquet porttitor. 29.99
Item Two Vis ac commodo adipiscing arcu aliquet. 19.99
Item Three Morbi faucibus arcu accumsan lorem. 29.99
Item Four Vitae integer tempus condimentum. 19.99
Item Five Ante turpis integer aliquet porttitor. 29.99
100.00

Buttons

  • Disabled
  • Disabled

Form