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

Published: 24 July 2023
on channel: 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
______________________________________________________________________


Watch video Data Analysis Portfolio Project # 3 | End-to-End SQL to Dashboard online without registration, duration hours minute second in high quality. This video was added by user Absent Data 24 July 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 43,096 once and liked it 1.5 thousand people.