Data Analysis Portfolio Project # 3 | End-to-End SQL to Dashboard
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:
Find the datasets at AbsentData or Github
-------------------------------------------------------------------------------
Download the dashboard from:
--Just click RAW on each file to download them.
Download Microsoft SQL Server Studio:
Check out Data Analysis Porfilio Project 1:
Contact me on linkedin
1 view
1497
458
1 month ago 00:39:32 1
Data Analysis Shows Huge Pro-War Spin Of German Mass Media | Prof. Harald Welzer & Leo Keller
1 month ago 00:25:44 1
Music Analysis | Ado - Aishite Aishite Aishite
1 month ago 00:19:57 1
A Prank Exposes How IOC and EU Plotted Against BRICS Games
1 month ago 00:08:44 1
America’s Big Chipmaking Blunder
1 month ago 00:09:32 1
Google Maps Data Scraping with Business Emails | Supports Multiple Keywords at Once!
1 month ago 00:10:10 1
The Origin Of The Karen Meme
1 month ago 00:07:17 1
The problems with Helion Energy - a response to Real Engineering
1 month ago 00:08:22 1
Best FREE Speech to Text AI - Whisper AI
1 month ago 00:01:53 1
What Applications are ideal for 3D Laser Scanning?
1 month ago 00:25:15 1
Why California Has So Many Problems
1 month ago 00:13:49 1
The Chironic Eclipse
1 month ago 00:11:08 1
Why is it Impossible for LONDON to Save Its Economy? 🌆💰 | Worldview Analysis 🌍🏦
1 month ago 00:10:28 1
Two Megastructures Were Just Found After They Sent A Signal To Us 2,000 Miles Below Earth’s Surface
1 month ago 00:08:15 1
Italy’s Shores in CRISIS Due to Migrants
1 month ago 01:09:36 1
Midnight Flow Music — Night Bass
1 month ago 00:01:00 1
A Gun That Knows Who’s Pulling the Trigger
1 month ago 00:24:02 1
Inside Mind-Reading AI | Exponentially with Azeem Azhar
1 month ago 00:12:31 1
「ロックマンX8」Rockman X8 Playthrough (JAP) — Part 4, Metal Valley - Earthrock Torirovich