Skip to content
View k10sj02's full-sized avatar
πŸ˜„
πŸ˜„

Block or report k10sj02

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
k10sj02/README.md

Hi there πŸ‘‹πŸ½

I'm Stann, a passionate Data Analyst leveraging my strategic finance and politics background to unlock data insights.

πŸ™‹πŸ½β€β™‚οΈ About Me

  • πŸ‘¨πŸ½β€πŸ’» Currently diving deep into SQL, Python, Data Visualization, and Analytics Engineering. Open to full-time and consulting opportunities in Data Analytics/Science.
  • πŸ’» I have been honing my skills through various self-guided data projects that I will be displaying on my Github.
  • πŸ§‘πŸ½β€πŸ”¬πŸ₯Ό Trained as a Political Statistician (MSc Political Science).
  • πŸ‡ΊπŸ‡ΈπŸ‡«πŸ‡·πŸ‡ͺπŸ‡Έ Fluent in English, French, and Spanish.

πŸ› οΈ Languages and Tools

  • SQL (PostgreSQL - Docker, pgAdmin4 for spatial SQL), Transact-SQL - Microsoft SQL Server, SQL Server Management Studio (SSMS) & Azure Data Studio, MySQL, Google BigQuery, Redash, SQLite, IBM DB2, ANSI SQL)
  • Data Prep OpenRefine
  • Visualization Tableau, PowerBI, Google Analytics, Microsoft Excel, Flourish, Datawrapper
  • Spreadsheets Microsoft Excel, GSheets
  • Python (Libraries - SQLAlchemy, NumPy, pandas, matplotlib, seaborn, scikit-learn, NLTK, geopandas, BeautifulSoup, RapidFuzz)
  • R (Packages - dplyr, ggplot2, tidyr, data.table, caret, tidyverse)
  • GIS (Mapping) QGIS, PostGIS
  • Data Engineering Apache Airflow, dbt
  • DevTools Git, Terminal, Visual Studio, vim, Docker, Docker Compose, Github Actions
  • Cloud Computing Microsoft Azure, GCP
  • Front-End HTML/CSS, Wordpress, Hugo
  • CRM Salesforce
  • Document Preparation LaTeX

πŸ“š Articles

  • Understanding the Cohort Table: A Step-by-Step Guide The article delves into cohort tables, showcasing their role in understanding customer behavior. It explores reading methods and insights derived from the data, highlighting opportunities and limitations for business decisions.

πŸ“ˆ Projects

This is my project portfolio.

SQL-based Projects

  • SQL Web Analytics for Political Advocacy Utilized SQLite for in-depth exploratory data analysis, covering user behavior, device segmentation, and referral sources. Employed Joins, Window Functions, and comparison operators to derive actionable insights and guide strategic decisions.
  • SQL Online Commerce Cohort Analysis Utilized SSMS and Azure Data Studio to uncover insights into customer behavior, including cohort retention analysis and percentage breakdowns over time for online commerce database. Techniques such as CTEs, Temporary Tables, Window Functions, and the PIVOT function are employed to handle data transformation, calculation, and presentation. Created cohort dashboard in Tableau. Ideal for understanding online commerce trends and optimizing business strategies.
  • Global Covid Tracking Project Utilized MySQL and MySQL Workbench to implement an ETL pipeline. Leveraged SQLAlchemy in Python to transform, clean, and upload data to a MySQL data warehouse. Conducted exploratory data analytics to uncover global COVID-19 trends from the data warehouse. Created dashboard in Tableau
  • 8 Week SQL Challenge (Data with Danny) PostgreSQL with Docker: Utilised PostgreSQL to clean and analyze eight different data from banking and sales, to name a few. Implemented various SQL techniques including window functions and CTEs. Incomplete

Tableau-based Projects

  • Real Estate Analytics for King County, WA: Housing Sales Dashboard Built an interactive dashboard with calendar widget as main filter and multiple visuals including a line chart, histograms, a map, and a heatmap. Compiled a report detailing insights of each visual component of dashboard.
  • Online Commerce Cohort Dash Loaded data from Azure Data Studio to build dashboard that visualizes the time-series retention rates and dynamic percentage breakdowns of customer cohorts, enabling stakeholders to identify trends and patterns in customer retention, engagement, and churn.
  • Global Covid Tracking Dashboard Integrated SQL server data into a dynamic dashboard featuring a diverse array of visualizations, including interactive line charts, histograms, and geographic maps, illustrating COVID-19 trends.

Python-based Projects

  • Predicting Gender Self-Perception: An Analysis of American Masculinity Preprocessed national US masculinity survey dataset, including data loading, mapping, cleaning, and exploration. Employed predictive analytical methods such as regression analysis, random forest, and XGBoost as well as advanced machine learning techniques such as feature engineering, hyperparameter tuning to predict gender self-perception of respondents. Packages utilized include: pandas, matplotlib, sklearn, geopandas.

R-based Projects

  • British Columbia Labor Market Research Imported, cleaned, and merged CSV datasets on Canadian provincial labor market statistics. Visualized monthly employment changes across Canadian provinces, with a focus on sectors like accommodation, food services, and retail trade. Packages utilized include: tidyverse, dplyr, lubridate.

Microsoft Excel-based Projects

  • Pending

Visualizations

Degree, Certification, Courses

SQL

Python

Microsoft Excel

Tableau

  • Tableau A-Z: Hands-On Tableau Training for Data Science Certificate

Salesforce

  • Salesforce Administrator Course, AchΔ“v

Data Analytics

  • Data Analytics Bootcamp, General Assembly
  • Strategy & Operations Bootcamp, The Commons
  • Strategic Finance Bootcamp, The Commons

Degree

  • Microcredential, Data Science, Sheridan College, Toronto, Canada πŸŽ“πŸ“Š
  • MSc, Political Science, Universitat Pompeu Fabra, Barcelona, Spain πŸŽ“πŸŒ
  • BA, International Studies, Kalamazoo College, Kalamazoo, USA πŸŽ“πŸŒ

🀝 Connect with Me

Career Journey

From Humanitarian Impact to Data-Driven Insights: πŸŒπŸ“Š

My career journey began in the world of social impact, where I leveraged financial and accounting expertise to support diverse organizations across the Middle East, Latin America, and the Caribbean. This included working with:

  • 🌱 Social impact investing organizations: Assisting them in analyzing investments that create positive social and environmental change.
  • πŸ•ŠοΈ Human rights campaigning organizations: Utilizing data to amplify their voices and drive impactful advocacy. My work even contributed to documentary film projects, which won prestigious awards like the Oscars (The White Helmets) and BAFTA Awards (For Sama), highlighting the power of storytelling and data combined.

Transitioning to Data - Bridging the Gap: πŸš€

Drawing on this diverse experience, I transitioned to the world of data. My proven ability to optimize business initiatives:

  • πŸ” Blends technical skill with business acumen: I'm proficient in Excel, SQL, Python, and R, alongside a strong understanding of UX/UI design principles and mastery of Tableau.
  • 🀝 Bridges the gap between stakeholders: I effectively communicate insights to diverse audiences, empowering business leaders to make data-driven decisions.
  • 🌟 Fosters collaboration: My collaborative nature, proactive approach, and high emotional intelligence enable me to seamlessly integrate into dynamic teams.

Impactful Results - Driving Growth and Sustainability: πŸ’Όβœ¨

My passion for utilizing data for good has yielded tangible results. Through dynamic financial and data analysis, I've:

  • πŸ’° Designed business initiatives raising over USD$120 million for 300+ tech startups and nonprofits.
  • πŸ‘₯ Contributed to the creation of 5,000+ jobs and positively impacted over 19 million lives across multiple regions.

Popular repositories Loading

  1. word-statistics word-statistics Public

    Analyze word frequency in text with Python. Clean text, count word occurrences, and export results to CSV. Simple, efficient, and customizable.

    Python

  2. us_views_of_masculinity us_views_of_masculinity Public

    The dataset originates from a joint survey by 538 and WNYC, polling 1600 men to assess #MeToo's influence on their views of masculinity. It provides insights into evolving attitudes, reflecting soc…

    Jupyter Notebook 1

  3. forked_fivethirtyeight-data forked_fivethirtyeight-data Public

    Forked from fivethirtyeight/data

    Data and code behind the articles and graphics at FiveThirtyEight

    Jupyter Notebook

  4. forked_Public-Policy-Analytics-Landing forked_Public-Policy-Analytics-Landing Public

    Forked from urbanSpatial/Public-Policy-Analytics-Landing

    All the data for the Public Policy Analytics book by Ken Steif can be downloaded from this repo

    R

  5. forked_Applied-Geospatial-Data-Science-with-Python forked_Applied-Geospatial-Data-Science-with-Python Public

    Forked from PacktPublishing/Applied-Geospatial-Data-Science-with-Python

    Applied Geospatial Data Science with Python, published by Packt

    Jupyter Notebook

  6. serious-sql serious-sql Public

    Query responses to Serious SQL online course by Danny Ma, illustrating practical applications and skills in SQL for data analysis and management.

    SQL