Data Analyst Project - Solving a Business Problem - Power BI, SQL & Python

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:

Series Overview:
Data Analyst Project - Solving a Business Problem - Power BI, SQL & Python

📩 Let’s stay in touch:

[parmisjv]

I’m impressed ! I’m customer experience analyst and this video is completely based on my job

[soheilpalermo]

You are doing a great job really and I think your videos could help so many Data analysts who are looking to do some hands-on projects. Your content and the quality are perfect. I have just found your channel and I think I could watch one video per day from now on ✅👍🏽 thanks, Ahmad.

[alioufaucher]

Great video Ali! Looking forward to doing this project and adding it to my portfolio

[gauravpatil]

Absolutely hooked to this banger project !

[AbdulGhaffarBuriro]

Starting working on this, hope we will get all parts

[krishsharma]

00:04 Marketing analytics project overview
01:34 Understanding marketing analytics business case is crucial for solving data analyst project.
03:20 Identifying challenges in online retail business
04:59 Marketing manager requesting data analysis expertise for improving marketing campaigns
06:44 Analyze customer feedback for improving engagement
08:30 Decoding feedback and key performance indicators (KPIs)
10:13 Analyzing customer movements, feedback, and setting business goals.
11:57 Setting project goals and introducing the business case.