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

No video

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

Рет қаралды 38,946

Жыл бұрын

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...
______________________________________________________________________

Пікірлер: 86

@absentdata 8 ай бұрын

This is the full dashboard build here kzfaq.info/get/bejne/htV_dtaU0pvMhIk.htmlsi=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 11 ай бұрын

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 8 ай бұрын

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 8 ай бұрын

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

@88mrjones 2 ай бұрын

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

@88mrjones 2 ай бұрын

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

@jonnythebaddy 10 ай бұрын

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 10 ай бұрын

I will be releasing this later

@Thekingslayer-ig5se 10 ай бұрын

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 10 ай бұрын

I'm glad it was valuable for you.

@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!

@user-qh5fr3yo1w Ай бұрын

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

@batoolalshareef9456 10 ай бұрын

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

@absentdata 10 ай бұрын

Awesome! I'm glad you enjoyed!

@PreplyshortVid 19 күн бұрын

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

@gabrielroomvm6209 Жыл бұрын

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

@absentdata Жыл бұрын

Noted!

@abrilgonzalez7892 2 ай бұрын

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 2 ай бұрын

The dashboard building link video is in the description

@abrilgonzalez7892 2 ай бұрын

@@absentdata thank you🙏🏻

@yustusbryan7770 Жыл бұрын

Thank you for the video 🔥🔥🔥🔥

@absentdata Жыл бұрын

My pleasure!

@datascientist6233 Жыл бұрын

Superb..

@absentdata Жыл бұрын

Thanks 🤗

@tarekhusam Жыл бұрын

Amazing, thank you ❤

@absentdata Жыл бұрын

You're welcome 😊

@randommagic3073 4 ай бұрын

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

@AmarjeetSingh-rk5ig Жыл бұрын

Thank you so much ❤❤❤❤...

@absentdata Жыл бұрын

You're welcome 😊

@ridwanfarah8288 11 ай бұрын

@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 10 ай бұрын

Sure Ill do it at some point soon

@bodymohmed6493 4 ай бұрын

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 4 ай бұрын

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/

@lakmina2002 3 ай бұрын

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

@absentdata 3 ай бұрын

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

@ARTHIK21 11 ай бұрын

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

@absentdata 11 ай бұрын

Yes I will after some time

@mohammadalhussein5739 7 ай бұрын

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 7 ай бұрын

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

@yashjajoria 10 ай бұрын

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

@absentdata 10 ай бұрын

This video is in the description

@absentdata 10 ай бұрын

This is in the description

@aydashadkam277 Жыл бұрын

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

@absentdata 11 ай бұрын

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

@papybudagu3056 2 ай бұрын

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

@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 10 ай бұрын

video for making dashboard step by step

@absentdata 10 ай бұрын

Its in the description: kzfaq.info/get/bejne/htV_dtaU0pvMhIk.htmlsi=rWkthwubBauH1fRG

@aidanthompson5053 9 ай бұрын

i should do this on desktop

@absentdata 9 ай бұрын

You can complete this on laptop also

@aidanthompson5053 9 ай бұрын

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

@victoriathomas71 11 ай бұрын

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

@absentdata 11 ай бұрын

Will do this at 10,000 views

@victoriathomas71 10 ай бұрын

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

@yinkabanjo3934 10 ай бұрын

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

@absentdata 10 ай бұрын

Yiu can download the dashboard

@TheeGirl- 9 ай бұрын

Hi. Why is the workload in thousands?

@utsabsarkar4462 5 ай бұрын

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

@absentdata 5 ай бұрын

Good point!

@vanshgrover_19 5 ай бұрын

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

@absentdata 5 ай бұрын

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

@emastehr Жыл бұрын

Can I use MySQL workbench for this project?

@absentdata Жыл бұрын

Yes you could

@kostantinaorselli1093 11 ай бұрын

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

@absentdata 11 ай бұрын

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

@Bjellica 11 ай бұрын

@@absentdata sup, would highly appreciate. 🙏

@kumarvishal_506 8 ай бұрын

@@absentdata Sir!! please make videos on dashboard

@absentdata 8 ай бұрын

@@kumarvishal_506 It's in the description.

@user-vw1gf9fp9l 5 ай бұрын

i am having issues accessing the link to download the dataset

@absentdata 5 ай бұрын

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

@therestfulmedia363 10 ай бұрын

Where projects 2

@absentdata 10 ай бұрын

Here is the playlist bro :) kzfaq.info/sun/PLi5spBcf0UMXfbMt1X2bHQkk7mHXkTUhs

@yashjajoria 10 ай бұрын

reason table add mising

@absentdata 10 ай бұрын

Not sure what you mean

@pl7771 10 ай бұрын

Dude for real? where is full??

@absentdata 10 ай бұрын

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