Hi, I'm a data analyst with a bachelor's degree in psychology from the University of Southern Maine. I discovered my passion for working with data during my studies and enjoyed creating visualizations. After completing the Google Data Analytics Certification, I gained expertise in SQL, R, PowerBI, and Tableau, along with skills in data cleaning, manipulation, analysis, and visualization. Professionally, I established a system of SQL-based daily map updates for my team in their respective region. I'm constantly eager to learn new tools and enhance my skills.

This is a repository to showcase my skills and projects in the data analytics and data science field.

• About
• Portfolio Projects
  • Divvy Bikeshare Rider Differences (R)
  • Sales Insights (SQL)
  • COVID-19 Statistics (SQL)
  • LinkedIn Web Scrape Project (Python)
• Certifications
• Contacts

In this section, I will list data analytics projects and briefly describe the tools and skills used for analysis.

Code & Report: Kaggle
Technology: R and various packages (tidyverse, validate, ggmap, data.table)
Skills: Data cleaning, manipulation, analysis, heatmapping, and visualization.
Results: Gathered multiple insights and created multiple visualizations on how annual members and casual riders use Divvy differently. Recommendations to the marketing analyst team were presented targeting these differences. I also had recommendations for improved data collection to improve future analysis.

Code: Sales Insights.sql
Dashboard: Sales Insights BI.pdf
Technology: SQL, MySQL, Power BI
Skills: Data cleaning, manipulation, analysis, visualization, star schema creation, and DAX.
Results: Created a dashboard that provides insights on the company's top/bottom markets and customers with date adjustable functionality. If you'd like to see the functionality, feel free to send me an email.

Code: COVID Portfolio Project Queries.sql
Dashboard: Tableau
Technology: SQL, Tableau, Excel
Skills: Data extraction, manipulation and visualization.
Results: A dashboard that accurately represents present day COVID-19 data with projections for the future.

Code: LinkedInWebScraper.ipynb
Technology: Python, HTML, BeautifulSoup
Skills: Data scraping and manipulation.
Results: A CSV file that includes data from all jobs in a filtered search on LinkedIn.

Google Data Analytics Certification (Oct 2022) (Google Career Certificates)

• LinkedIn: @jeremiah-sanville
• E-mail: [email protected]