Data Analyst Portfolio Project: Employee Performance Analysis using Google Big Query & Google Looker Studio

In this video, I'll walk you through a comprehensive data analyst portfolio project focused on employee performance analysis and HR analytics. Using a Kaggle dataset with 5 files, I demonstrate how to preprocess and clean the data in Google BigQuery. Afterward, I upload the cleaned data into Google Looker Studio (formerly Google Data Studio) to create an insightful dashboard.

You'll learn key steps in the process, from data preprocessing to building a professional dashboard, including how to define a business problem statement and how I used ChatGPT to assist with some tasks.

This tutorial covers essential topics for data analysts, such as Google BigQuery basics, Google Looker Studio dashboards, and portfolio project creation. It's ideal for anyone looking to build their own data analyst portfolio or to learn more about HR analytics.

Key sections:

Dataset overview and business problem definition
Data preprocessing in Google BigQuery
Dashboard creation in Looker Studio
Key insights and analysis
Here is the link to all required resources: [ Ссылка ]

Don’t forget to like, subscribe, and share if you find this video helpful!

свернуть