MS SQL Power BI Data Analysis Portfolio Project | Beginner to Expert | Power BI Dashboard

Thank you sir for bringing this project.

Sir really good videos make more videos python project for data analysis please

Hi. Now I have another issue. when I imported csv into Power B.I, it didn't update the query it had been created on SQL.

Do you have any e-mail to sent to you my screenshot even file, please?

While getting the age group distribution , you put a condition WHERE new_termdate IS NULL. Theres a problem with this condition. What if the termdate of the person is not yet happened and is in future? You have also excluded those person by saying WHERE new_termdate IS NULL.

Nice it's helpful tq so much

Thank you so much

Hi Guys. Does anyone else could help me?

I ran this code " UPDATE hr_data SET termdate = FORMAT(CONVERT(DATETIME, LEFT(termdate, 19), 120), 'yyyy-MM-dd');" but at the end, it came up with " Conversion failed when converting date and/or time from character string."

Help me, please

Thank you.

Please check those case statements again. The lower boundary of the conditions in the WHEN statement will result in duplication of counts(for 31-40 and 41-50 age_group).

To highlight my point, see this -----> Assuming the ages we are working with are (25, 36, 22, 28, 33) We want the query to return the count of age_group 21-30 as 3 and age_group 31-40 as 2. This should be the correct thing.
But based on how you put the condition, it will return age_group 31--40 as 5.
I think this may be solved if the WHEN conditions are modified as follows;

WHEN age>=21 AND age<=30 THEN '21 - 30'
WHEN age>=31 AND age<=40 THEN '31 - 40'
WHEN age>=41 AND age<=50 THEN '41 - 50'


Please correct me if i am wrong/mixing anything up. Thank you.

Does anyone know how to restore termdate to the initial content and datatype.

how did you resolve future dates in termdate column bcoz i am getting min(age) in negative value i.e -41

Would not it be easier and safe to creating new columns, transforming data in Power BI instead of using SQL Database server? In Power Query you can transform all data with a few clicks and if you insert any new column and data, you can see the applied steps for tracing and monitoring purposes.

i dont understand what he did in termdate

HI great video just 1 question where did you get the data from ???

good job...

Very nice explanation. I have one question sir, who gives the questions for which you have written all those sql, customer or self designed in a IT company? Thanks for answering.

Awesome tutorial! Intersecting very same project and dataset from close sources her data and his data!
I am newbbie to SQL and data analytics, but I understand that the convulse the code the better. For the New column age, why so mamy code lines to create and update de age column?
Why not
Select difffunction(year, dob, getday()) as age.
In MySQl it works out like
SELECT timestampdiff(year, birth_date, curdate())
FROM hr_data
Ok, I am aware this does not affect the orginal dataset, only for the current visualization

Thanks for the detailed explanation. One question, why don't use direct power query / DAX instead of SQL first?

subscribe you

I appreciate your work. I have one question. Do we work in this way in companies? Will the workflow be similar?

Hello it's really helpful
Can you tell me who you get the data