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.
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)?
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?
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.
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 .
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.
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
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
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.
I have learnt so much from you and i really appreciate the effort you put into this work
Thank your support. I'm glad you enjoy the content. Please share it with anyone you think it will help
Great one ! Would love to see more advanced dashboards curated specially for experienced professionals resume selection 😊
subscribing with the hope of getting a video on a more difficult level sql project
There other more difficult ones on the channel, check it out
amayzing video i learn allots of new things
Glad you learned from the video
amazing website, a lot of thought i seen behind it
Thanks
Merci ce cour est super complet🙏
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)?
Yeah this is a solid point. I didn't notice this until after the upload
Alternatively the custom at 1:00:11 column should just be yearly budget since you are splitting a 2 year budget number in half
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?
this is happening to me too. i keep getting a '(' error. i tried several times and no way around this error. need help
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..)
Yeah I know its not exactly a data analyst tool. However I am considering making a series on it.
Why using one big table instead of start schema?
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.
just wow!
That's a great compliment
great vid!
Just want to know why we are multiplying the budget by 0.5.
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 .
Sounds good like a good idea,
How do I start with this? I know about API stuff, but I haven't used it with Power BI.
When the data is different in the files that you're working with compared to what you upload it's hard to follow.
Which files are different?
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.
OK sure
I was enjoying the video , until he threw that stunt and I got lost
What stunt?@@oriasotiekessinghton3494
much complex projects are appricated
You can check the channel for this. There are others.
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
Very nice!