Thank you for visiting my GitHub page.

• Data analyst with a background in business management, marketing, and culinary
• I am passionate about transforming raw data into useful formats and telling stories through powerful visualizations and meaningful reports 📈📉
• I recently graduated from Data Analytics BootCamp from UC Berkeley Extension ✨🎓✨🎓 and Udacity Data Analyst Nanodegree Program where I gained technical programming and analytical skills and developed essential industry ingenuity through real-world projects and team collaborations. Feel free to take a look at my repositories 👇
• I continue to work on projects and honing my skills through online classes and exploring an amazing field of Data Science! 🧐

• 📫https://www.linkedin.com/in/andrejach/

PinnedLoading

1. Data_Analyst_Nanodegree_Program_PortfolioData_Analyst_Nanodegree_Program_PortfolioPublic

   Udacity Data Analyst Nanodegree (DAND) Projects Portfolio. This repository is dedicated to Udacity’s Data Analyst Nanodegree Program (DAND). It contains all major projects, completed in the program.

   1

2. election-analysiselection-analysisPublic

   In this analysis, I wrote a Python script that generates a vote count per candidate and per county and creates a report for U.S. congressional race in a Colorado precinct.

   Python

3. stock-analysisstock-analysisPublic

   VBA stock-market analysis. For this data analysis I am using Microsoft Visual Basic for Applications as a tool, including conditional statements, for loops, static and conditional formatting, and n…

4. kickstarter-analysiskickstarter-analysisPublic

   For this data analysis, I am using MS Excel, including interactive pivot tables and charts, conditional formatting, advanced filters, VLOOKUPs, Box and Whiskers Charts, and other advanced Excel for…

5. Pewlett-Hackard-AnalysisPewlett-Hackard-AnalysisPublic

   In this project, I am using ERDs and Schemas to design databases and writing intermediate-level SQL queries to answer important business questions for the company’s HR department. The result is a w…

   3 3

6. Movies-ETLMovies-ETLPublic

   For this project I am creating an ETL (Extract, Transform, and Load) pipeline using Python, RegEx, and SQL Database. The goal is to retrieve data from different sources, clean and transform it into…

   Jupyter Notebook 27 7