Data Analysis Portfolio Project # 3 | End-to-End SQL to Dashboard скачать в хорошем качестве

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:    • Step by Step Power BI Dashboard Build -- P...   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 | Build ...   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 ______________________________________________________________________