Data Analysis Portfolio Project # 3 | End-to-End SQL to Dashboard

Опубликовано: 24 Июль 2023
на канале: Absent Data

43,096

1.5k

In this video you will be evaluating an HR dataset about absenteeism and health. You will use your skills to provide a data driven approach to determine how to provide a bonus and incentive to healthy employees. You will also develop a database, SQL queries to answer questions and build a dashboard which meets a wireframe specification. This is an end-to-end project that you can use to improve your skill. #dataanalysis #datascience #sql #datavisualization

Video Contents
---------------------------------------------------------------------------------------------------
Data Analysis Task and Problem Statement 0:18
Connecting to Microsoft SQL Server and Database Creation 1:26
Uploading Data to the Database 3:08
Writing SQL Join Queries 9:38
SQL Query with Filters for Healthy Workers 15:38
Compensation Calculation Analysis with SQL 20:34
Optimize SQL Query and CASE Statements 25:50
Connecting Power BI to Database 36:46
Dashboard Development and Wireframe 40:02
Final Dashboard Design 48:05

Full Dashboard Step By Step if you want to see done in total:
• Step by Step Power BI Dashboard Build...

Find the datasets at AbsentData or Github
-------------------------------------------------------------------------------
https://absentdata.com/data-analysis/...

Download the dashboard from:
https://absentdata.com/data-analysis/...

https://github.com/Gaelim/work_incent...
--Just click RAW on each file to download them.

Download Microsoft SQL Server Studio:
https://learn.microsoft.com/en-us/sql...

Check out Data Analysis Porfilio Project 1:
• Data Analyst Portfolio Project #1 | B...

Contact me on linkedin
www.linkedin.com/in/gaelimholland

Learn SQL and practice online with case studies. Dive into the examples, answer the questions, and create your own solutions. Use the affiliate link below to start practicing!
______________________________________________________________________
Check out Data Camp: https://datacamp.pxf.io/KjO5ba
______________________________________________________________________

Смотрите видео Data Analysis Portfolio Project # 3 | End-to-End SQL to Dashboard онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Absent Data 24 Июль 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 43,096 раз и оно понравилось 1.5 тысяч людям.