Dmitrii Aladiev
Analytics Engineer
I am analytics engineer with experience in developing architectural solutions and creating dashboards for informed business decisions. I also have a strong background in internet marketing, which complements my analytics skills.
LATEST PROJECTS
Kimball's Dimensional Data Modeling
A project has been implemented to create a logical star model using the Kimball methodology with the use of DBT tool and BigQuery database. The aim of the project was to create a unified data model that could combine data from different sources and provide more efficient analysis.Technology: DBT, BigQuery
RFM analysis
In this project, I used dbt and SQL to create a data warehouse, based on which I calculated RFM metrics for customer analysis. Then, I loaded this data warehouse into Looker and created a dashboard to visualize the analysis results.My project allows to evaluate the importance of each customer for the business and provides data that can be used to make decisions on optimizing marketing strategies. I am confident that this project can be useful for any company looking to improve their business.Technology: DBT, BigQuery, Looker
Project "Stock screener"
The stock analysis project is designed to help investors make data-driven decisions. It includes analyzing financial indicators of companies and other data that can help you make informed decisions about investing in stocks.
Technology: GCS, BigQuery, Linux OS, Python, Prefect.
Project "Zoomcamp"
A tutorial project in which I created an architectural solution for analysing taxi trip data
Technology: GCS, BigQuery, Linux OS, Python, Prefect.