Claudio Lira, PhD
Digital Marketing Analyst
- Over 10 years of experience with data analysis (MS Excel and Google Sheets).
- Reports automation with PowerQuery.
- Digital analytics implementation services using Tag Manager, Google Analytics, and Data Studio.
- Business Intelligence dashboards in spreadsheets, Data Studio, Tableau and PowerBI.
Portfolio
A sample of my client work and personal projects
Data Studio
Ecommerce Calculator
Personal Project
This calculator was created to demonstrate the use of Data Studio parameters to a group of landing page creators. The template was shared with the group and users present it to their clients during discovery calls, which helps them set goals and close more deals.
Data Studio
Google Analytics Audit
Client Work
This audit dashboard was created for a digital marketing agency to assess the Google Analytics account of their prospects. The dashboard is separated into sections where the client receives feedback on areas for improvement, as well as guides the agency on defining the scope of the work with the prospect.
Data Studio
Google Ads Report
Client Work
This Google Ads dashboard was created for a marketing agency. It is used by their client to track ads performance, ad spend, and conversions. The dashboard has summary data as well as daily breakdowns. The agency plans to have a page per year plus a summary page, so the dashboard will keep getting improved throughout 2022.
Google Sheets
Ecommerce Report
Client Work
This e-commerce client wanted several breakdowns and reports from the cart data. With each product data cleaned up and relevant metrics calculated, I created a dashboard with breakdowns by product, country, state, and month. The client actively uses this dashboard to analyze trends and manage their store
Experiences and Milestones
Overview of data analysis career progression
