Search this site
Embedded Files
Yugin Dmitriy
  • Home
  • About
  • Articles
    • available browser data
    • establish visit attribution like Google Analytics
    • how to connect clickhouse to excel
    • how to write sql directly in excel
    • achievable goals
    • when pyramid principle don't work
    • about dataform bigquery
    • GA4 report misleading metrics set
    • boost data-driven approaches
    • tag manager bug fixing
    • gtm-template-datalayer-backup
  • Portfolio
    • sql scheduler with google docs
    • competitor analysis similarweb
    • functions and pub sub
    • data warehousing
    • data transfer bq
    • apps schedule
    • remote sql
    • adwords bq
    • bpmn
    • e2e funnel
    • gcs setup
    • cohort
    • gtm setup
    • reports in messenger
    • ad-hoc excel
    • cpa partners
    • email report
    • ga360 setup
    • ga360 custom funnels
    • ab test playground
    • power bi ad-hoc
    • AWS S3 data in Looker Studio
    • bigquery dataform
    • audience interest analytics
  • Contacts
Yugin Dmitriy
  • Home
  • About
  • Articles
    • available browser data
    • establish visit attribution like Google Analytics
    • how to connect clickhouse to excel
    • how to write sql directly in excel
    • achievable goals
    • when pyramid principle don't work
    • about dataform bigquery
    • GA4 report misleading metrics set
    • boost data-driven approaches
    • tag manager bug fixing
    • gtm-template-datalayer-backup
  • Portfolio
    • sql scheduler with google docs
    • competitor analysis similarweb
    • functions and pub sub
    • data warehousing
    • data transfer bq
    • apps schedule
    • remote sql
    • adwords bq
    • bpmn
    • e2e funnel
    • gcs setup
    • cohort
    • gtm setup
    • reports in messenger
    • ad-hoc excel
    • cpa partners
    • email report
    • ga360 setup
    • ga360 custom funnels
    • ab test playground
    • power bi ad-hoc
    • AWS S3 data in Looker Studio
    • bigquery dataform
    • audience interest analytics
  • Contacts
  • More
    • Home
    • About
    • Articles
      • available browser data
      • establish visit attribution like Google Analytics
      • how to connect clickhouse to excel
      • how to write sql directly in excel
      • achievable goals
      • when pyramid principle don't work
      • about dataform bigquery
      • GA4 report misleading metrics set
      • boost data-driven approaches
      • tag manager bug fixing
      • gtm-template-datalayer-backup
    • Portfolio
      • sql scheduler with google docs
      • competitor analysis similarweb
      • functions and pub sub
      • data warehousing
      • data transfer bq
      • apps schedule
      • remote sql
      • adwords bq
      • bpmn
      • e2e funnel
      • gcs setup
      • cohort
      • gtm setup
      • reports in messenger
      • ad-hoc excel
      • cpa partners
      • email report
      • ga360 setup
      • ga360 custom funnels
      • ab test playground
      • power bi ad-hoc
      • AWS S3 data in Looker Studio
      • bigquery dataform
      • audience interest analytics
    • Contacts

Yugin Dmitriy

Data/Web Analyst

book appointment

Professional Profile 


I passionate about technology, technology marketing and the use of technology in marketing. l prefer to work in an environment that has emphasis on ownership of campaigns, collaboration, learning, curiosity and a drive to continually improve myself / the team / the organisation. I also love to problem solve, get hands-on, experiment, measure and use automation to make daily life easier.


  1. I'm adept at evaluating questions strategically and defining the problems we're tackling.

  2. I prioritize problem-solving, even when faced with technical challenges.

  3. I'm self-sufficient when it comes to task execution.

  4. I proficiently gather data from various sources, including APIs, data warehouses, and databases.

  5. I have the knack for breaking down complexity into manageable steps.

  6. I excel at presenting findings in an understandable manner for both technical and non-technical colleagues.


Let's act on these skills and make a difference together!

Education

Chuvash State University (Top 1 ranked Universities in Chuvash Republick)

2003 — 2008 full-time department

Bachelor degree in Physics and Technology

Specialist in the field of quantum electronics

Advanced training endorsed by high-profile universities

HSE: Fundamentals of marketing

MISIS: Time menegment

POLITECH: Marketing

ITMO: Programming algorithms and data structures


Independent study

Online courses: Oracle SQL

Online courses: JavaScript

Online courses: Power BI & Excel for analyst

Google courses:  Adwords  and Campaign Manager

Google courses:  Analytics

Google courses:  Cloud Architecture Center


Tool Stack


data collect: MySQL,  BigQuery, CloudStorage, FireBase, ClickHouse

data analysing:  SQL, EXCEL, DataLab, SpreadSheet

visualisation:  DataStudio, Power BI

procces optimization: Cloud Function, Apps Script, Node JS

data architecture: UML, Jira, Confluence, BPMN2.0


Portfolio

Research: Plan and refine digital strategies

more details>>>

desired by: marketing team, product team, business owners

challenge: Creating a digital strategy can be tricky, especially when faced with gut feelings, competing needs, and differing viewpoints.  Focusing on your target audience's interests and what's optimal for them can be a powerful approach. However, to truly eliminate potential disputes and ensure buy-in from all stakeholders, data-driven decision making is crucial.

AWS S3 csv files analysing with Lookerstudio

more details>>>

desired by: marketing team, product team,hr teams etc 

challenge: looker studio very convenient for teams working remotely or in hybrid mode. It lets you check in on your all-important data anytime, anywhere – as long as you have internet. Unfortunately looker doesn't have native connector to S3 cloud file storage by AWS. Think about you have files in cloud that regularly updating. You want to create dashboard analyzing this files in Looker Studio. And you want to be up to date with those files updates.

A/B test prediction with visualisation in Lookerstudio

more details>>>

desired by: marketing team, product team, product owner, business owner

challenge: Imagine you're juggling AB tests with completely different goals, but you can only run one at a time. How do you choose? Here's where a powerful tool comes in. You need something that lets you play around with test parameters and see how each experiment might play out. Ideally, this tool should also integrate with Looker Studio so you can easily create dashboards to share your findings with stakeholders and colleagues.

A competitor analysis in Power BI

more details>>>

desired by: marketing department stakeholders, business owner

challenge: Imagine you're juggling AB tests with completely different goals, but you can only run one at a time. How do you choose? Here's where a powerful tool comes in. You need something that lets you play around with test parameters and see how each experiment might play out. Ideally, this tool should also integrate with Looker Studio so you can easily create dashboards to share your findings with stakeholders and colleagues.

BigQuery SQL data sample creating

more details >>>

desired by: organisation partners, clients


Google Analytics 360 customer journey analysis

more details >>>

desired by: product owner, cro specialist, seo specialist, marketing performance specialist


Google ADS reporting in BigQuery

more details >>>

desired by: marketing team


Advanced Email reporting with Google Apps Script

more details >>>

desired by: directors of departments, CEO, CFO


Excel: dashboards and OLAP

more details >>>

desired by: directors of departments, CEO, CFO


DataStudio + Bigquery: partners and fraud monitoring

more details >>>

desired by: marketing department stakeholders, business owner, partners


GA cohort report expanding with DataStudio

more details >>>

desired by: product owner, cro specialist, seo specialist, marketing performance specialist


The regular report in messenger

more details >>>

desired by: marketing team, product team


Power BI + BQ + DataStudio. E2E funnels

more details >>>

desired by: marketing team, VP of marketing

Advanced GA counter setup with Google Tag Manager

more details >>>

desired by: marketing team, product team


Analytics 360 precision adjustment

more details >>>

desired by: marketing team, product team


Cloud Storage architecture schema

more details >>>

desired by: marketing team, product team


The processes description using BPMN

more details >>>

desired by: marketing team, product team


© All rights reserved  Yugin Dmitriy 2024

Google Sites
Report abuse
Page details
Page updated
Google Sites
Report abuse