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 ...
Find the datasets at AbsentData or Github
-------------------------------------------------------------------------------
absentdata.com...
Download the dashboard from:
absentdata.com...
github.com/Gae...
--Just click RAW on each file to download them.
Download Microsoft SQL Server Studio:
learn.microsof...
Check out Data Analysis Porfilio Project 1:
• Data Analyst Portfolio...
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: datacamp.pxf.i...
______________________________________________________________________

[@absentdata]

This is the full dashboard build here kzbin.info/www/bejne/hqCydKaZopqbircsi=3XO2cn-K6U0nTORr

[@JW-pu1uk]

I am a Data Analyst and I can certify that this is REALLY good. Thanks for taking the time to do this.

[@absentdata]

I really appreciate it!

[@user-cc2ke1in5o]

You convinced me! Can you also recommend other good project that mimic the real world?

[@faaz12356]

The best way to learn data analysis is through projects thank you sir, plz keep doing similar videos

[@absentdata]

Yes projects help you to learn fast

[@victorbegnini5754]

Wow! I'm amazed by the high-quality and assertiveness I found here! You've got yourself a new subscription. Thanks for taking the time and effort to do this, man. Really helpful.

[@absentdata]

Thanks alot! I really appreciate the comment and subscription!!

[@jonnythebaddy]

Loved the project! I think it is unique and simple to understand. However, would appreciate if you could just do a tutorial on how you built the dashboard. It will be a huge help to everyone. Thanks!

[@absentdata]

I will be releasing this later

[@88mrjones]

I have watched this twice this morning, I love the wireframe and the final design.

[@88mrjones]

I've never used the power BI narrative but I will now!

[@andrei607]

I appreciate the time and effort you exert in creating this video and the rest of your contents. Thank you for sharing your expertise, please keep on creating the same content.

[@absentdata]

My pleasure! Please share this with anyone you think it will help!

[@Thekingslayer-ig5se]

Very useful for people like me. I was expecting this type of content for a long time since I am quite proficient in MySQL and power bi Great job

[@absentdata]

I'm glad it was valuable for you.

[@batoolalshareef9456]

Thanks a lot for sharing such as this project tutorials, It's valuable and simple explanation, great efforts and work, 👍👍👍.

[@absentdata]

Awesome! I'm glad you enjoyed!

[@user-qh5fr3yo1w]

Очень хорошее видео. Прям образец как нужно проводить анализ данных.

[@PreplyshortVid]

This probably.one of my favorites which ive completednand updated and edited and improved on. Kimdly help me though with the meaning of the column 'Son' and 'Pet' and their import to this project. Thanks

[@abrilgonzalez7892]

I loved the video, thanks you. ¿Is there any other video in which you show us how to create the final dashboard? I would love to see It!!!

[@absentdata]

The dashboard building link video is in the description

[@abrilgonzalez7892]

@@absentdata thank you🙏🏻

[@gabrielroomvm6209]

Good tutorial but a cool part is watching you how to build the dashboard, maybe next time.

[@absentdata]

Noted!

[@yustusbryan7770]

Thank you for the video 🔥🔥🔥🔥

[@absentdata]

My pleasure!

[@tarekhusam]

Amazing, thank you ❤

[@absentdata]

You're welcome 😊

[@AmarjeetSingh-rk5ig]

Thank you so much ❤❤❤❤...

[@absentdata]

You're welcome 😊

[@ridwanfarah8288]

@Absentdata Would you be able to do a walkthrough as to how to compile the dashboard to look that way - for us newbie's we don't our way around power bi to build such reports - absolutely love it btw 🙂

[@absentdata]

Sure Ill do it at some point soon

[@randommagic3073]

Great video ! Can you tell me how to describe this project in my resume and its title. Please

[@datascientist6233]

Superb..

[@absentdata]

Thanks 🤗

[@bodymohmed6493]

Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)" why??

[@shaikachrone6248]

experiencing the same issue, the server and database name are correct but the same error messages keeps popping up

[@Tapas_777]

A humble request can you please discuss sql interview questions for experienced candidates?

[@absentdata]

This may be helpful absentdata.com/analytics/9-sql-interview-questions-level-1-mysql/

[@yashjajoria]

one video for making power bi dashboard - all filter labels all charts*

[@absentdata]

This video is in the description

[@absentdata]

This is in the description

[@lakmina2002]

greate video . how you got 983,221 allocated budgect ? could you tell it pls (Video 21.50)

[@absentdata]

It's in the intro and problem statement section. Go back and watch the beginning

[@papybudagu3056]

hi, I have an issue ('Absenteeism time in the hours ' column is a varchar data type ) it throws me an error when I calculate the average. How did you manage at your end? I tried to convert varchar to numeric SQL server does not let me do it and help

[@thipetebogo]

change to tinyint

[@ARTHIK21]

Please show the full procedure of making the dashboard. Please, its a humble request.

[@absentdata]

Yes I will after some time

[@mohammadalhussein5739]

Hello thanks for this video , my question is on the second join of the reasons table , I expected the join to be on a common column but you joined on another , wondering why!!....thanks

[@absentdata]

Everything was joined on common values in the columns. The column names don't need to be the same. They just need matching values

[@aydashadkam277]

Can I download the dashboard? I mean the template of the dashboard you prepared.

[@absentdata]

It's in the description or find it here: absentdata.com/data-analysis/where-to-find-data/

[@jordanconnolly1046]

this is great would you have any suggestions on where you would display a portfolio for potential employers

[@absentdata]

You can try Github to display and upload your dashboard to Power BI gallery

[@jordanconnolly1046]

@@absentdata Thanks for the tip

[@yashjajoria]

video for making dashboard step by step

[@absentdata]

Its in the description: kzbin.info/www/bejne/hqCydKaZopqbircsi=rWkthwubBauH1fRG

[@TheeGirl-]

Hi. Why is the workload in thousands?

[@yinkabanjo3934]

Is there a link i can use to interact with this dashboard

[@absentdata]

Yiu can download the dashboard

[@victoriathomas71]

Would you be able to show us how you made this dashboard?

[@absentdata]

Will do this at 10,000 views

[@victoriathomas71]

Hi quick question. When I added in the slicer for season, a fifth tile called 'unknown' was populated. How would I get rid of that?@@absentdata

[@aidanthompson5053]

i should do this on desktop

[@absentdata]

You can complete this on laptop also

[@aidanthompson5053]

@@absentdata but the server name on SQL management studio is empty, how do i find it on laptop?

[@utsabsarkar4462]

if we not including legends on pie charts then it could difficult for viewers to understand what each dataseries represents

[@absentdata]

Good point!

[@vanshgrover_19]

I want to do this visualization in Tableau. Please help!

[@absentdata]

You should be able to do it by just following the video and translating the steps into Tableau

[@user-vw1gf9fp9l]

i am having issues accessing the link to download the dataset

[@absentdata]

Press CTRL + J , your browser is probably downloading it automatically after clicking it and its sitting in your download folder.

[@therestfulmedia363]

Where projects 2

[@absentdata]

Here is the playlist bro :) kzbin.info/aero/PLi5spBcf0UMXfbMt1X2bHQkk7mHXkTUhs

[@emastehr]

Can I use MySQL workbench for this project?

[@absentdata]

Yes you could

[@kostantinaorselli1093]

Can you show us step-by-step how you created your dashboard?

[@absentdata]

Let's see if there is enough interest. If so, I will record one

[@Bjellica]

@@absentdata sup, would highly appreciate. 🙏

[@kumarvishal_506]

@@absentdata Sir!! please make videos on dashboard

[@absentdata]

@@kumarvishal_506 It's in the description.

[@pl7771]

Dude for real? where is full??

[@absentdata]

You can download the dashboard from the description if you that is what you are asking.

[@yashjajoria]

reason table add mising

[@absentdata]

Not sure what you mean