Data Analysis Project | SQL & Power BI 2024 | Create a Database | Novice Friendly

Welcome to this end-to-end data analysis project! You'll step into the shoes of a data analyst to create a dashboard using real project data. Don't worry, I've got you covered with all the data files and step-by-step video instructions. You'll learn how to clean, analyze, and visualize the data in a straightforward way. Let's dive in and build something awesome!
Table of Contents
0:33 Workflow
0:40 Requirements from Stakeholders
1:52 Dashboard Preview
2:25 Downloading the Database Software
5:12 Install and Setup Server
9:13 Creating your Database
16:05 Writing SQL Queries
28:50 Connecting Database to Power BI
32:20 Dashboard Build
1:14:11 Final Dashboard
Correction:
To get he capital = you can double the salary or multiply the department budget by 0.5. You don't need to do both.
You can find the files here:
absentdata.com...
#dataanalysis
#sql
#powerbi

[@sharonayodele]

The added column, you can cal it profit or expenditure = budget*.5 - (salary cost + project cost ). Alternatively,you can multiple the salary by 2- while making no adjustment to the budget.

[@CarlosVolpe-w1n]

Great one ! Would love to see more advanced dashboards curated specially for experienced professionals resume selection 😊

[@amarjithore8848]

subscribing with the hope of getting a video on a more difficult level sql project

[@absentdata]

There other more difficult ones on the channel, check it out

[@htelleurtv7852]

Merci ce cour est super complet🙏

[@oskarlindberg4869]

Love your demos. Would be really cool to se dbt used for transformation in an upcoming vid (i know it's not really related to data analyst role..)

[@absentdata]

Yeah I know its not exactly a data analyst tool. However I am considering making a series on it.

[@junaidahmed2969]

amazing website, a lot of thought i seen behind it

[@absentdata]

Thanks

[@joebeadles112]

Alternatively the custom at 1:00:11 column should just be yearly budget since you are splitting a 2 year budget number in half

[@X4XP11]

Thank you for the video. Shouldn't the new calculated column 'Capital' be calculated without multiplying the salary by 2 years since you have already multiplied the 'Budget' by 0.5 (annual budget)?

[@absentdata]

Yeah this is a solid point. I didn't notice this until after the upload

[@IfitWasntForThoseKids]

great vid!

[@moseadegoke]

Hi guys, am having issues with the CTE WITH CTE_Project as ( SELECT project_id, project_name, project_budget from [upcoming projects] UNION ALL select project_id, project_name, project_budget FROM completed_projects) SELECT * FROM CTE_Project I couldn't join this CTE as or is anything wrong with this code above?

[@pratikjugantmohapatra18]

Highly aprreciate but lets do some projects usng API fetching beause API is something which is very very essestiala and will make u stand out of crowd .

[@absentdata]

Sounds good like a good idea,

[@mrbartuss1]

Why using one big table instead of start schema?

[@absentdata]

Its better to let the database do the heavy lifting. A database administrator doesn't not want to replicate the database in Power BI by just bring in all the tables. When requested data access, you are often asked to provide an optimized query. However, its possible to do this in some cases.

[@zsomborb1065]

When the data is different in the files that you're working with compared to what you upload it's hard to follow.

[@absentdata]

Which files are different?

[@RealEchos]

Your sneaky edits to avoid explaining something that stumped you makes it very difficult to follow. Too many errors and mistakes. For someone new and trying to learn, I would say that they are able to complete a partial dashboard that serves no purpose and can't be applied to a portfolio, but might learn a few things.

[@absentdata]

OK sure

[@mahiaslam6738]

much complex projects are appricated

[@absentdata]

You can check the channel for this. There are others.

[@OlaobajuOluwajoba-y6i]

SELECT a.employee_id, a.first_name, a.last_name, a.job_title, a.salary, d.Department_Name, d.Department_Budget, pa.project_id, p.project_name, p.project_budget, CASE WHEN end_date > CONVERT(DATE, GETDATE()) THEN 'Upcoming' ELSE 'Completed' END AS status FROM employees a JOIN departments d ON a.department_id = d.Department_ID JOIN project_assignments pa ON a.employee_id = pa.employee_id JOIN projects p ON pa.project_id = p.project_id; My SQL code

[@absentdata]

Very nice!