A-Passion-For-Data

Data Portfolio

---

Project maintained by davidjayjackson Hosted on GitHub Pages — Theme by mattgraham

Contact Information

• [Email: ] (davidjayjackson@gmail.com)
• [Facebook Messenger:] (davidjayjackson)
• YouTube: Caribou Data Science

Certification and Training

• Google Data Analytics Certification
• The Complete Oracle SQL Certification Course
• Data Analysis with Google Big Query
• Master SQL For Data Science(PostgresSQL)

Data Analytic Skills:

• Talend Open Studio(Data Integration):
• Possess a strong working knowledge of Talend| including the ability to work with diverse file formats and employ advanced functions such as aggregate, filterRow, and Filter Columns.

• Tableau, Power BI: Proficient in Tableau and Power BI, with expertise in data cleaning, web scraping, database connectivity, and creating impactful visualizations, dashboards, and stories. Skilled in using Power Query for efficient data preparation.

• Excel: Power Query | Pivot Tables | Data Model and Dashboard | Data Cleaning | Database Connectivity | and Web Scraping |Slicers | Timelines
• SQL (Server 2019, Oracle, PostgreSQL, T-SQL): Joins and Views | Common Table Expression (CTEs) | Window Functions | Rollup and Cube Function | VS Code
• R Programming Language (and packages): RStudio | Tidyverse | GGplot2 | Lubridate |Janitor | Forecast
• Integrated Development Environment (IDE): RStudio | VS Code | SQL Server Management Studio | Pg Admin (PostgreSQL).

Google Data Analytics Capstone Projects

Cyclist Bike Share Case Study

• Data analytic Tools: R/Tidyverse/Rstudio/ggplot2 and Tableau

• YouTube: How-to and Tutorial

• GITHUB:R CODE
• Tableau Dashboard and Stories:
• Case Study Version 1

Case Studies: Our World In Data

“Research and data to make progress against the world’s largest problems”

• Our World In Data

Illicit Drug Use

“Illicit drugs are drugs that have been prohibited under international drug control treaties. The main groups of illicit drugs used in international statistics are opioids, cocaine, amphetamines and cannabis”.

• GITHUB/R CODE
• Opioid Death Rate)
• Opioid Deaths Rate by County
• Drug Overdose Deaths: Opioid, Cocaine, Amphetamine
• Worldwide Drug Overdose Deaths
• USA vs World Drug Overdose Deaths

Diet Fruit Consumption per capita

• GITHUB/R CODE
• Countries with Highest Consumption of Fruit Per Person:part 1
• Per Capita Fruit Consumption Part 2
• Worldwide/US : Fruit Consumption By Fruit Type:1961 - 2013
• Fruit Consumption by Fruit Type: Part 3

Diet Vegetable Consumption per Capita

• GITHUB/R CODE

Cereals Consumption by Commodity

• GITHUB/ R CODE