Skip to content
View lanavirsen's full-sized avatar

Block or report lanavirsen

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

Hello, I'm Lana - Data Analyst with a master's degree in Mechanical Engineering, relocated to Sweden in 2021.

My top skills

  • Querying
  • Data Cleaning
  • Exploratory Data Analysis
  • Advanced Data Analysis
  • Data Visualization
  • Basic Machine Learning
  • Automation

Tools

  • Python, and its data-related libraries:
    • pandas
    • NumPy
    • scikit-learn
    • Matplotlib
    • seaborn
  • SQL
  • Power BI / Tableau
  • Excel / Google Sheets

Projects

Project link Completion Date Tools Techniques Project Description
🔄 Google Web Analytics Data Pipeline May 2024 Python, APIs, OAuth2.0 Fetching and writing data via APIs, data transformation, logging, automating and scheduling Python script Automated web analytics data pipeline for streamlined reporting.
💬 Analyzing Chat Messages for Future Automation April 2024 Python, pandas, NLTK, scikit-learn, Matplotlib Data preprocessing, K-means clustering Analysis of chat messages to identify opportunities for future automation.
🎟️ Texas Lottery Sales Analysis March 2024 Python, Dask, SoQL, Tableau, pandas, Matplotlib, seaborn API querying, data preprocessing, trend analysis, data visualization Texas Lottery sales analysis: API querying, Python/Dask data analysis, and Tableau visualization.
⛽ Iowa Motor Fuels Sales Analysis March 2024 Python, pandas, GeoPandas, scikit-learn, Matplotlib, seaborn Data cleaning, EDA, trend analysis, correlation analysis, prediction analysis (linear regression), data visualization Analysis of Iowa's fuel sales trends and biofuel adoption.

Mini-projects

Project link Completion Date Tools Techniques Project Description
🐾 Visualization: Animal Rights by Country July 2024 Python, Tableau Data preprocessing, data visualization Visualization of animal rights worldwide using data from Wikipedia.

Pinned Loading

  1. Google-Web-Analytics-Data-Pipeline Google-Web-Analytics-Data-Pipeline Public

    Automates the collection, transformation, and presentation of web analytics data from Google Analytics 4 and Google Search Console into Google Sheets for streamlined reporting and analysis.

    Python 2

  2. Texas-Lottery-Sales Texas-Lottery-Sales Public

    This project analyzes the Texas Lottery sales data using SoQL for API querying, Python and Dask for data processing, and Tableau for interactive visualizations.

    Jupyter Notebook

  3. Iowa-Motor-Fuel-Sales Iowa-Motor-Fuel-Sales Public

    The State of Iowa set a goal to replace 25% of petroleum in Iowa with biofuel by 2020. Did they succeed? The answer, as well as the analysis of fuel sales in the State in 2012-2022 years, are here …

    Jupyter Notebook

  4. Analyzing-Chat-Messages-for-Future-Automation Analyzing-Chat-Messages-for-Future-Automation Public

    Analyzing chat messages in virtual services to identify opportunities for future automation and improve communication efficiency.

    Jupyter Notebook