In this video, we’ll take a close look at the episde in our data analyst portfolio project that serves as the foundation and problem statement for our series. This data analyst project is designed to help you build your skills and experience in a real-world scenario. We’ll discuss how to approach a business case from a data analyst perspective, highlighting key areas to focus on as we move into more technical aspects later in the series.
This is an interactive exercise where you can follow along and apply what you learn directly to your own data analyst projects. Whether you’re building your data analyst portfolio or just starting out, this series will provide valuable insights and practical experience.
Timestamps:
00:00 - Intro
00:27 - Series Overview
01:37 - Introduction to Business Problem
05:00 - Email from Marketing Manager
06:55 - Email from Customer Experience Manager
08:55 - Key Performance Indicators (KPIs)
09:39 - Data Sources and Tables
10:30 - Goals
13:03 - What's Next
Resources and Downloads:
Data Analyst Portfolio Practice Environment Setup:
https://youtu.be/N-XUrnCOIYo
Marketing Analytics Business Case - https://github.com/aliahmad-1987/DataAnalystPortfolioProject_PBI_SQL_Python_MarketingAnalytics
Series Overview:
Data Analyst Project - Solving a Business Problem - Power BI, SQL & Python
Data Analyst Project - Cleaning Data with SQL for Insights - Power BI, SQL & Python -
https://youtu.be/IW3k_aQjMMI
Data Analyst Project - Advanced Sentiment Analysis with Python - Power BI, SQL & Python -
https://youtu.be/xO5vjx8a1R4
Data Analyst Project - Building an Interactive Dashboard in Power BI - Power BI, SQL & Python - Ep 4 -
https://youtu.be/UbtrQPvs0Yw
Data Analyst Project - Presenting Data For Stakeholders | Power BI, SQL & Python -
https://youtu.be/R8bBXqlvepY
📩 Let’s stay in touch:
LinkedIn – https://www.linkedin.com/in/aliahmad1987/