Welcome to my Data Analyst / Analytics Engineer Portfolio repository! This portfolio showcases my skills in data analysis, data processing, and visualization through hands-on showcases.
I’m a data expert with over 10 years of experience in data preparation, transformation, modeling, and visualization. I work with tools like dbt, SQL, BigQuery, Looker, Looker Studio, Tableau, and Python to build efficient workflows and deliver insights that matter.
I’ve worked across platforms — Snowflake, MS SQL Server, Sybase IQ, PostgreSQL, Excel, and Google Sheets — and adapt quickly to new environments.
I created this portfolio to demonstrate how I work with data, since most of my real-world projects are under NDA. Here you'll find examples of the approaches and solutions I typically use.
Feel free to explore the showcases — and reach out if you’d like to connect.
This portfolio includes the following showcases, each highlighting different tools, workflows, and analytical approaches.
📁 data-analyst-portfolio
├── 📁 showcase_local_coffee_shop # Showcase 1: BigQuery + dbt + Looker + GCP
│ ├── 📁 dataset_generation # Python scripts for synthetic data
│ ├── 📁 dataset_upload # GCS upload logic
│ ├── 📁 dbt_models # dbt project (models, tests, macros, etc.)
│ ├── 📁 google_cloud_run # Cloud automation with GCP (Cloud Run + Functions)
│ └── 📄 README.md # Detailed showcase description
├── 📁 showcase_TBD # Showcase 2: (Coming Soon) – Public API + Tableau
│ └── 📄 README.md # Detailed showcase description
├── 📄 README.md # Overview of the portfolio (this file)
├── 📄 LICENSE # License for the code
└── 📄 .gitignore # Excluded files
A full-stack analytics workflow for a fictional coffee shop chain, built to simulate real-world reporting and automation needs. The project demonstrates my ability to handle everything from raw data generation to business-ready dashboards.
- Data Generation: Python
- Data Transformation: dbt (BigQuery)
- Data Storage: Google BigQuery
- Visualization: Looker Studio
- Automation: Cloud Scheduler, Cloud Run, Cloud Functions (GCP)
This upcoming showcase will focus on working with real-world data extracted from public APIs. The goal is to demonstrate:
- API data extraction using Python
- Lightweight data processing and cleanup
- Building engaging dashboards with Tableau
📁 (Placeholder folder — stay tuned!)
If you have questions, suggestions, or opportunities, feel free to reach out!
- LinkedIn: Vadym Demchenko
- UpWork: Vadym Demchenko
Thank you for exploring my portfolio!