Hi guys, I've gotten some questions regarding the update date script so I wanted to write some additional instructions. 1) Make sure that you are right clicking the correct database when running the query. You want to do it on AdventureWorksDW2019 2) Make sure you are copying the entire script. 3) The correct link for the script is found here: github.com/techtalkcorner/SampleDemoFiles/blob/master/Database/AdventureWorks/Update_AdventureWorksDW_Data.sql if there are any questions about that. 4) Make sure to set encryption to optional, if you have issues connecting. If all else fails, I have updated a .bak (database backup file) where all dates have already been updated which can be found here www.sendspace.com/file/z2s0gv
Hi Ali Ahmed, thank you for this project. I am unable to fully restore the database as it is giving me the error below 'An exemption occurred while executing a transact- SQL statement or batch' Please assist with the same.
OMG you are a life saver. I just got out of a Data Analysis boot camp and they didn't teach us anything about portfolios or the importance. I just want to say thank you.
@@aliahmad1987 Hi Ali ahmad. I am basic to SQL and powerBi. Is this knowledge enough to walkthrough in this series or should I improve my skills then go for it?
Wow, this is exactly what I need as someone without ANY Data analysis work experience looking to get a job as a data analyst. I salute you with both hands. You got me bro!
I am glad to hear you find value in it. If you are brand new, there will be some concepts that are unknown, as anything is when it is new, but still beneficial to go through the process and expose yourself to it! Let me know if you have any questions!
Thank you so much for this series Ali! Currently graduating and planning to pursue a position as Analyst, I feel like this videos will help me a lot! Cheers from Stockholm!
That's great to hear Minorka 😊! Things get much more hands on at video #3 and forward so hopefully it'll give you some practice and an end product you will be happy with showing 😊👌🏽
I am here for next project 🖐🖐 Btw thank you for this video, Ali. Still left for storytelling for another excel power bi last time. But here I am... And seems I will dig your other playlist too. I just know you had many meat video learning. Like basic, etc. Thank for all of them. And thanks God 🤲🤲 you use SQL Server too. I just can install that in my low spec laptop. Edit : Seems I cant do this cause my SQL server 2014 cant reload database. Seems I can just watch this SQL series then just upload CSV files 🙏🙏
@@aliahmad1987 Hi Ali, I have a question: how to build DW from OLTP of AdventureWork Database? can you explain for me about it process? Thank you so much
@@MINHNHITOWN Hi Minh! What you are looking for is more towards data engineering and heavier data modelling. I would look into kimball data modelling and specifically how to create fact and dimension tables. This article and video shows a graphical example, but you would want to learn doing in SQL I guess? Still it gives an idea. docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/adding-fact-tables-and-dimension-tables-data-model.html#GUID-0BE51FD6-9FA9-453C-B747-E1A4E96E3E6B
Also a good source! Dimension tables: radacad.com/basics-of-modeling-in-power-bi-what-is-a-dimension-table-and-why-say-no-to-a-single-big-table Fact tables: radacad.com/basics-of-modeling-in-power-bi-fact-tables
Thank you Piyush! Maybe later this year, I have to plan them and next I think I want to try and do SQL, Python and Power BI, but it does take planning!
thankyou for this series. btw one thing if some one while connecting to Database in SSMS faces error related to SSL certificate, keep encryption as optional. thought to put it here since i have wasted my 3-4hrs in it :)
Mashallah Ali, I came across your videos by chance and they are truly excellent and very useful. I have a question: which country are you from? May Allah bless you and benefit others through you. --- If you need any further assistance or additional translations, feel free to ask!
Thank you for this series. I got this error while working with the series and I've try to check through the script but I couldn't sort it. Here is the error message "Msg 3728, Level 16, State 1, Line 56 'FK_FactCurrencyRate_DimDate' is not a constraint. Msg 3727, Level 16, State 0, Line 56 Could not drop constraint. See previous errors." Thank you
Hi. If you are trying to run the script, add this at the beginning "USE AdventureWorksDW2019". Probably you had some other data bases loaded in SSMS and it didn't recognize which one to use.
Hi Ali, I need your help please, at 4;36 , you mentioned something about connecting to a server. In my pc , it does not have the option to connect to the database that you purpose.
Awesome video! Just a small query, why are we adding the data to the backup folder instead of connecting it with sql using something like new database/import database? I am new to sql!
Hi Ali, I am not getting the Backup folder below location- C:\Program Files\Microsoft SQL Server Under the Microsoft me on thus. SQL server folder----80/90/110/150/Client SDK folder is available. Please help me on this.
Hi Ali, I am looking for a descent project to get started with data analysis .I know basic sql and I am planning to learn power BI. Would you suggest me this playlist of yours on data analyst Portfolio Project? Will this be helpful in my case ?
Please help me out, your project is good to polish skills in data analytics. How to use this.bak file in postgreSQL server i try almost every tutorial available YT
love this bro. very easy to grasp. however, pls the link for the adventure files isn't opening, so i couldn't practice along. is there any fix to this? thanks
Hi, That depends what you are trying to do? An enterprise ready data viz / data analysis tool they aren't even in the same sphere. Power BI all the way. // Ali
Hi, your project is amazing. But I have a question. At 5:38, when you paste .bak file to backup folder, I cannot open the folder because I do not have permission to open it. How can I resolve it? Thank you.
Hi Ali, Thank you for this awesome project. i want to do this project with you, but every time i tries downloading the AdventureWorks.bak file it downloads as an internet explorer file and i can not find the .real bak file in anywhere??? can you help me why this is happening. i already had ssms installed in my computer and connected to a different server. i used every link that you noted there but i couldn't find the adventureWorks.bak file :(
Hello Ali, once I paste the database files in the program files, I am not able to see that while I am adding it to the sql server. Can you please help me out on this.
Hi Syed, I am not sure if I understand entirely where you are, but it sounds like the step where you restore the .bak file to SQL Management Studio. Have a look here: ruclips.net/video/ntsigyCkCas/видео.html Hopefully that helps, otherwise feel free to clarify and I will try and help. Best, Ali
Hey Ali. This has been a really helpful series. Having followed along on this guided project, I am trying to create another one using some of the sales tables provided in the AdventureWorks2019 database. Any idea if/how I can update the data as you have done for AdventureWorksDW2019?
Very helpful channel with great content Ali! Loving this series, although I am running into an issue in this step. When I attempt to migrate the CSVs files into power BI, the column names all show up the first row and not formatted. I've gone into the power query editor and tried making the first row as the column names, no luck. Tables generates flawlessly in SQL Management Studio. Happens for every table. Anyone have a solution for this? Thanks!
Wow great video!! I got a problem when I was trying to update the data thou. When I tried to update the data with the script from the link above, it was showing me errors the first time I ran it on SQL. So I compared the current version of the script with the one that was used in the video and they seemed a bit different. Now when I run the same script, it shows that the "commands are completed successfully". However, I found that the years have not been updated at all. Is there a way to fix this, or do you think I can follow the series without updating the data. Thanks!
Hi Jude, It is a bit hard to know order of sequence here, but I would delete the database now, restore it before you made the changes and try again. Or else you can go here: www.sendspace.com/file/z2s0gv where I have uploaded a .bak file with the dates already updated and use that. Hope that helps and that the project gives you some value! All the best, Ali
Bro Ali... This tutorial rocks and I want to get to the bottom of all this by learning this stuff from you. But before downloading these, I got a question: I have SQLite already installed on my Mac. Honestly I don’t want to bother with the Microsoft server thing but I don't know if that’s going to be a requirement down the way. So would SQLite be alright to keep up with your series? Thanks.
Hi, I am glad you like it! I actually haven't used SQLite, but the question is if you can restore the database into that, and practice the further steps, that is the key here. I did a quick search on it and it seems like it, but I don't have experience with that :\ I hope you can still do it though! Best, Ali
Hello Ali, I’m working on a sales dashboard for my dissertation project. The company I’m working with said that I would need to use sample data from somewhere else. Is it possible for me to edit the data from this series to best suit the company I’m working with?
Hi, Yes that is possible, but depends on what you want to edit? Of course you can edit the values in the different data, but it will make it a bit more complex. An approach is to extract the data from tables you want, and then in excel change it and then continue the project, but as you get into different parts later, it won't be as easy to follow. Best, Ali
Hi, I've been learning business intelligence for some months now. I can use Excel in an advanced way, I'm intermediate in Power Bi and beginner in Sql. I need more practice work. Can anyone help, I don't mind working for free if it'd help me learn
Hi Ali, thank you so much for creating inspiring content on your channel. I am currently making a career change to BI/Data Analysis and I really found your videos helpful. However, I have a quick question - I am using a MacBook (with BigSur OS) and I am running into certain compatibility issues with MySQL. Would you consider buying a windows laptop a valuable investment for me? Also, are most data analysis/BI companies running Mac OS or Windows? Thank you.
Hi there! You are welcome :) Bit late here due to some travelling but I would say usually Windows is the way to go, but of course it depends on company. As you get omre into the field, there are other softwares that you might use that do smaller things (troubleshooting, optimizing etc.) and I find a lot of those are Windows based. I will you best of luck with your journey! :) // Ali
Hi Ali, I copied two backup files through the path that Microsoft mentioned. unfortunately I do not have permission in my SQL to add them to restore Database. I appreciate if you help me to solve this problem.
Hi, thank you very much for creating this video! Could you please advise where can I get the query that you have used to update the AdventureWorksDW2019 database??
Hi Ali, I want to let you know I'm well now. I reinstalled it and everything went smoothly. I appreciate your support, and your videos are great. Thanks for all the good work
Hi Snehal, I am not sure where you are looking, but you need to get the SQL server instance name, look through the video one more time for that section as I do it there, bit hard to explain here, but you need the SQL server instance name! I hope you find it out. Best, Ali
i have an issue to update the database the code doesn't work for all the rows Msg 515, Level 16, State 2, Line 124 Cannot insert the NULL value into the column 'SpanishDayNameOfWeek', table 'AdventureWorksDW2022.dbo.DimDate'. This column does not accept NULL values. INSERT failed.
Sir I can't login to power BI desktop with my personal account and i'm not working right now so i don't have work account. hence I'm not able to publish my project to web... please please help me how can i login to power bi desktop without pro version. i really need to upload my project to my portfolio fast. please help sir
Hi David! I would use an emulator then or else the only option I would recommend is to use a different SQL manager and try and re-do the steps there. Of course you can't follow a long then, but the actual SQL statements etc will be the same. Let me know how you get on! // Ali
when at starting it shows my laptop name instead of server express when asking for connecting server what should I do to come to express at the name of my laptop name pz reply
@@aliahmad1987 Thank you for reply bro.. i just started learning Power Bi and on the path to become Data Analyst.. Your videos motivate me.. Thank you so much Bro .. Hugs :)
Hi Vitor, I had another person ask me something and he commented with a screenshot on GitHub, but make sure you copy paste right and that you run the query on the right database. Best, Ali
Hi again Vitor, I have tested this and it works fine, but you can also download an updated version of the database with new dates from here: www.sendspace.com/file/z2s0gv I just added it. Best of luck with the project! // Ali
Hello. I am new in this field. and I have just downloaded and followed your video. however, the server is not connected automatically like your video.. whats wrong is it?
Hi, I am unsure as I can't see what you have done so far, but if you have installed the Instance AND the Management Studio then copy the name of the instance and use this as database. Maybe look through the video a bit slower? Let me know how it goes Farah! // Ali
Hi Elizabeth, uhm I don't think I will do that, as it is such a small part of this original video. You can try this link though which will initiate the download: aka.ms/ssmsfullsetup I hope that helps you out :)
Hi guys,
I've gotten some questions regarding the update date script so I wanted to write some additional instructions.
1) Make sure that you are right clicking the correct database when running the query. You want to do it on AdventureWorksDW2019
2) Make sure you are copying the entire script.
3) The correct link for the script is found here: github.com/techtalkcorner/SampleDemoFiles/blob/master/Database/AdventureWorks/Update_AdventureWorksDW_Data.sql if there are any questions about that.
4) Make sure to set encryption to optional, if you have issues connecting.
If all else fails, I have updated a .bak (database backup file) where all dates have already been updated which can be found here www.sendspace.com/file/z2s0gv
I found out why it wasnt working, However I might need help later for something else so please check on me
Hi Ali Ahmed, thank you for this project. I am unable to fully restore the database as it is giving me the error below
'An exemption occurred while executing a transact- SQL statement or batch' Please assist with the same.
OMG you are a life saver. I just got out of a Data Analysis boot camp and they didn't teach us anything about portfolios or the importance. I just want to say thank you.
Hi Kenny! You are welcome and I happy to hear you are finding this useful.
// Ali
@@aliahmad1987 Hi Ali ahmad. I am basic to SQL and powerBi. Is this knowledge enough to walkthrough in this series or should I improve my skills then go for it?
I´ve been working 4 years as a DA and this is really cool
Cheers! Cool to hear that from such an experienced guy Fabrizio!
Wow, this is exactly what I need as someone without ANY Data analysis work experience looking to get a job as a data analyst. I salute you with both hands. You got me bro!
I am glad to hear you find value in it. If you are brand new, there will be some concepts that are unknown, as anything is when it is new, but still beneficial to go through the process and expose yourself to it! Let me know if you have any questions!
Thank God for this series bro, you just added a professional dimension to my data analyst job search.
Just woke up here in Norway and read this comment. Going to make my day 😁😁. Glad you find value in it and wish you all the best in your job pursuit!
best series i ever seen i wrote it before watch cause od the concept. it is perfect
Hi Emre,
Thank you! :)
// Ali
Thank you so much for this series Ali! Currently graduating and planning to pursue a position as Analyst, I feel like this videos will help me a lot! Cheers from Stockholm!
Glad it was helpful! And look forward to hear more about your journey!
I followed step by step and everything seems fine
Glad to hear! :)
Enjoy the series!
// Ali
Thanks for these golden series!
Thank you! :)
Best,
Ali
This is going to be a great series, I am definitely practicing along with you. Looking forward to part 2 already. 🙌🏽🙌🏽
Happy to have you on Emmanuel! Don't hold back on the feedback so that I can make it as good as possible 👌🏽👌🏽😉
@@aliahmad1987 sure Ali..
Great Content Ali. Starting the series
Thank you! Hope you like it :)
This is an Amazing Series!! I am watching from Bangladesh
Hi Ahasan!
I am glad you are enjoying it and finding it valuable. Glad to have you on board from Bangladesh brother :)
// Ali
Congratulations for posting this type of content.
Thank you very much!
This is amazing, I’ll be creating mine by following you. Thank you so much .
That's great to hear Minorka 😊!
Things get much more hands on at video #3 and forward so hopefully it'll give you some practice and an end product you will be happy with showing 😊👌🏽
This is really great really excited to follow along with you.keep up the good work.👍
Hi Raj!
Glad to hear :) I hope you find it useful and don't hesitate to give feedback on it.
Have a great weekend!
// Ali
I am here for next project 🖐🖐 Btw thank you for this video, Ali. Still left for storytelling for another excel power bi last time. But here I am... And seems I will dig your other playlist too. I just know you had many meat video learning. Like basic, etc. Thank for all of them. And thanks God 🤲🤲 you use SQL Server too. I just can install that in my low spec laptop.
Edit : Seems I cant do this cause my SQL server 2014 cant reload database. Seems I can just watch this SQL series then just upload CSV files 🙏🙏
Hi Syaoran!
Glad you figured out how you can do it and thank you for your support!
Best,
Ali
Thanks a lot Ali, This really important for me.
No worries
Glad you liked it!
Thank you very much for such a great learning, you are putting it into practice on my channel😊
My pleasure 😊
Thank you so much, wish you a lot of success with your channel. Looking forward to the other part about Data.
Thank you for the kind words and all the best to your data analysis progress! 👌🏽😊
@@aliahmad1987 Hi Ali, I have a question: how to build DW from OLTP of AdventureWork Database? can you explain for me about it process? Thank you so much
@@MINHNHITOWN Hi Minh! What you are looking for is more towards data engineering and heavier data modelling. I would look into kimball data modelling and specifically how to create fact and dimension tables.
This article and video shows a graphical example, but you would want to learn doing in SQL I guess? Still it gives an idea.
docs.oracle.com/en/cloud/paas/bi-cloud/bilpd/adding-fact-tables-and-dimension-tables-data-model.html#GUID-0BE51FD6-9FA9-453C-B747-E1A4E96E3E6B
Also a good source!
Dimension tables: radacad.com/basics-of-modeling-in-power-bi-what-is-a-dimension-table-and-why-say-no-to-a-single-big-table
Fact tables: radacad.com/basics-of-modeling-in-power-bi-fact-tables
Many thanks for this!
Amazing and very useful video!
Glad you find it useful Igancio!
Best,
Ali
Sir we want more projects, your explanation is amazing..
Thank you Piyush! Maybe later this year, I have to plan them and next I think I want to try and do SQL, Python and Power BI, but it does take planning!
Setup successfully installed. Thank you
Good start Muhammad :) Now you have to work through and you can use this as a setup for practice! And thank you for supporting.
Simply amazing, thabk you!
Glad you liked it!
thankyou for this series. btw one thing if some one while connecting to Database in SSMS faces error related to SSL certificate, keep encryption as optional. thought to put it here since i have wasted my 3-4hrs in it :)
Hi,
Thank you for watching and thank you for sharing this!
I have added it to my pinned post so this will help others.
Cheers,
Ali
so clear and useful , thanks
Glad to hear that Alice!
Best,
Ali
Awesome thank you so much sir
You are wlecome!
Mashallah Ali,
I came across your videos by chance and they are truly excellent and very useful. I have a question: which country are you from?
May Allah bless you and benefit others through you.
---
If you need any further assistance or additional translations, feel free to ask!
Thank you so much!
I am originally from Pakistan, but born and raised in Oslo, Norway.
Best,
Ali
Thank you my indian friend, one sub from Brasil!!!1
You are welcome, my friend :)
Obrigado for the sub ;)
Great work.
Sir what is the impact of your analysis for business or can you improve the business sale please
Hi,
Not sure if I understand what you mean?
Best,
Ali
Thank you for this series. I got this error while working with the series and I've try to check through the script but I couldn't sort it. Here is the error message "Msg 3728, Level 16, State 1, Line 56
'FK_FactCurrencyRate_DimDate' is not a constraint.
Msg 3727, Level 16, State 0, Line 56
Could not drop constraint. See previous errors." Thank you
Hi,
I have to be honest, I don't recognize that FK...
Been a while since I looked at this though! Did you figure it out?
// Ali
Hi. If you are trying to run the script, add this at the beginning "USE AdventureWorksDW2019". Probably you had some other data bases loaded in SSMS and it didn't recognize which one to use.
Excellent, thanks!
Thank you!
// Ali
Hey Ali
Why am I not able to select top 1000 rows
It’s showing nothing after selecting
I am not sure :) Hope you found out though!
Hii, I was trying to follow the instructions there but I dont have the sql express folder.
Can you advice me on what to do next?
Hi,
Not sure if I follow?
Great initiative sir will be quite insightful
Thank you very much :) Enjoy it!
thank you so much for this. you are the best
You are welcome Azhari!
:)
شكرااا يا علي
Just got a like and an automatic subscription.
Thank you for the support 😊🙏🏽
Hello Ali. I've followed all the steps but I can't seem to filter from the year 2019. I only have years from 2005 to 2014. Could you please help me?
make sure you use the update script to renew the dates :)
Nice, looking forward to the next part.
Glad you liked it 😊
Great video serie!!! Thanks!
I am happy you find it useful 😊🙏🏽
Hi Ali, I need your help please,
at 4;36 , you mentioned something about connecting to a server. In my pc , it does not have the option to connect to the database that you purpose.
Hi,
I am unsure what you have done then, but you have to connect to a database, yes.
¡Qué buenos videos, eres excelente! Saludos desde México
Gracias!
Best,
Ali
I can’t download the adventureworks data warehouse or light weight. Please help me
Please check the links :) Should still bee available!
Awesome video! Just a small query, why are we adding the data to the backup folder instead of connecting it with sql using something like new database/import database? I am new to sql!
Hi,
Often you want the business logic in the datwarehouse, so that it can be used other places also :) Does that make sense?
Best,
Ali
Hi Ali,
I am not getting the Backup folder below location-
C:\Program Files\Microsoft SQL Server
Under the Microsoft me on thus. SQL server folder----80/90/110/150/Client SDK folder is available.
Please help me on this.
Hi,
Not sure if I understand this one?
@@aliahmad1987 yes there is some typing mistake here. Let me watch this video again and will let you know.
backup folder is not opening ..can anyone help
Would you be able to do another tutorial for SQL Server 2022, thank you!
Hi,
Ahhh I might in the future hah, haven't done tutorials for a while!
// Ali
Hi Ali, I am looking for a descent project to get started with data analysis .I know basic sql and I am planning to learn power BI. Would you suggest me this playlist of yours on data analyst Portfolio Project? Will this be helpful in my case ?
Hi,
Yes - try it out and lets hope it helps Aaryan!
Let me know afterwards :)
Please help me out, your project is good to polish skills in data analytics. How to use this.bak file in postgreSQL server i try almost every tutorial available YT
Hi,
I am unsure how to use a .bak file with PostgreSQL. Why not use it with MSSQL Server?
Thanks for watching!
// Ali
love this bro. very easy to grasp. however, pls the link for the adventure files isn't opening, so i couldn't practice along. is there any fix to this? thanks
Hello!
Glad you like it :) Which link exactly are you trying?
Best,
Ali
It's the warehouse and lightweight data stuff... It isn't downloading at all. Cheers
@@michaelesho4765 Just checked it and it worked fine :) Please add the direct links here?
Hello ali can you please tell me which more better anaconda 3 or power bi? I am confused now😅
Hi,
That depends what you are trying to do? An enterprise ready data viz / data analysis tool they aren't even in the same sphere.
Power BI all the way.
// Ali
Hi, your project is amazing. But I have a question. At 5:38, when you paste .bak file to backup folder, I cannot open the folder because I do not have permission to open it. How can I resolve it? Thank you.
Hi,
Hmmm - I am bit unsure. Did you figure it out?
// Ali
great video, congratulations.
Thank you Marcelo! :)
Hi Ali, Thank you for this awesome project. i want to do this project with you, but every time i tries downloading the AdventureWorks.bak file it downloads as an internet explorer file and i can not find the .real bak file in anywhere??? can you help me why this is happening. i already had ssms installed in my computer and connected to a different server. i used every link that you noted there but i couldn't find the adventureWorks.bak file :(
Hi,
I am not sure if I understand, but the files should all be there and then you restore them into SQL Server?
Best,
Ali
HI Ali , I have installed SQl management studio in my personal laptop, unable to connect to the server. Does it work on our laptop just to practice
Yes, it should work.
Did yu also install SQL Express Server?
could I use mysql instead? thanks !
Hi,
I don't think you can as you need to restore the .bak file, and that doesn't work in MySQL.
At least not as far as I know!
:\
Hello Ali, once I paste the database files in the program files, I am not able to see that while I am adding it to the sql server. Can you please help me out on this.
Hi Syed,
I am not sure if I understand entirely where you are, but it sounds like the step where you restore the .bak file to SQL Management Studio.
Have a look here: ruclips.net/video/ntsigyCkCas/видео.html
Hopefully that helps, otherwise feel free to clarify and I will try and help.
Best,
Ali
Hi brother
I am facing the same issue are you able tk solved this one?
Hey Ali. This has been a really helpful series. Having followed along on this guided project, I am trying to create another one using some of the sales tables provided in the AdventureWorks2019 database. Any idea if/how I can update the data as you have done for AdventureWorksDW2019?
Hi,
When you say update, which parts do you want to update?
Glad you like the project!
// Ali
Very helpful channel with great content Ali!
Loving this series, although I am running into an issue in this step. When I attempt to migrate the CSVs files into power BI, the column names all show up the first row and not formatted. I've gone into the power query editor and tried making the first row as the column names, no luck. Tables generates flawlessly in SQL Management Studio. Happens for every table.
Anyone have a solution for this?
Thanks!
Hello Brandon!
Thank you very much. I'm a bit unsure if I fully understand though. Did you resolve it?
Where did you get a budget xls file?
Thank you so much for this sir, pls what sound track is playing at the background... It's so soothing
I have no idea haha, don't remember :)
@@aliahmad1987 Ok, I do go back to the video just for the background track
Thank you, where have you being before l started my Uni?.
You are welcome! I'm not sure If I understand? Where I went to school?
Wow great video!!
I got a problem when I was trying to update the data thou. When I tried to update the data with the script from the link above, it was showing me errors the first time I ran it on SQL. So I compared the current version of the script with the one that was used in the video and they seemed a bit different. Now when I run the same script, it shows that the "commands are completed successfully". However, I found that the years have not been updated at all. Is there a way to fix this, or do you think I can follow the series without updating the data.
Thanks!
Hi Jude,
It is a bit hard to know order of sequence here, but I would delete the database now, restore it before you made the changes and try again. Or else you can go here: www.sendspace.com/file/z2s0gv where I have uploaded a .bak file with the dates already updated and use that.
Hope that helps and that the project gives you some value!
All the best,
Ali
Bro Ali... This tutorial rocks and I want to get to the bottom of all this by learning this stuff from you. But before downloading these, I got a question: I have SQLite already installed on my Mac. Honestly I don’t want to bother with the Microsoft server thing but I don't know if that’s going to be a requirement down the way. So would SQLite be alright to keep up with your series?
Thanks.
Hi,
I am glad you like it! I actually haven't used SQLite, but the question is if you can restore the database into that, and practice the further steps, that is the key here. I did a quick search on it and it seems like it, but I don't have experience with that :\
I hope you can still do it though!
Best,
Ali
@@aliahmad1987 Will do. Thanks my friend.
Hello Ali, I’m working on a sales dashboard for my dissertation project. The company I’m working with said that I would need to use sample data from somewhere else. Is it possible for me to edit the data from this series to best suit the company I’m working with?
Hi,
Yes that is possible, but depends on what you want to edit? Of course you can edit the values in the different data, but it will make it a bit more complex.
An approach is to extract the data from tables you want, and then in excel change it and then continue the project, but as you get into different parts later, it won't be as easy to follow.
Best,
Ali
Hi, I've been learning business intelligence for some months now. I can use Excel in an advanced way, I'm intermediate in Power Bi and beginner in Sql. I need more practice work. Can anyone help, I don't mind working for free if it'd help me learn
hello sir i want to know if I can use this portfolio project on LinkedIn?
Yes!
Why not?
Hi Ali, thank you so much for creating inspiring content on your channel.
I am currently making a career change to BI/Data Analysis and I really found your videos helpful. However, I have a quick question - I am using a MacBook (with BigSur OS) and I am running into certain compatibility issues with MySQL. Would you consider buying a windows laptop a valuable investment for me? Also, are most data analysis/BI companies running Mac OS or Windows? Thank you.
Hi there!
You are welcome :) Bit late here due to some travelling but I would say usually Windows is the way to go, but of course it depends on company. As you get omre into the field, there are other softwares that you might use that do smaller things (troubleshooting, optimizing etc.) and I find a lot of those are Windows based.
I will you best of luck with your journey! :)
// Ali
Can this work with SQL Server express 2022
Yea,
As long as you can import the database then you are good 2 go! :)
// Ali
ASSALAMOALAIKUM SIR ALI AHMAD, I FACE A LITTLE BIT PROBLEM WHEN I EXCEUTE MY QUERY,ONLY HEADERS ARE SHOWN ,NOT A SINGLE ROW IS SHOWN?...
Hi,
Sounds like there is an issue with your query then, bit hard for me to say, but I hope you figure it out!
// Ali
both the files are not opening in my system,,please help
Hi,
Please go online and look at how to restore .bak files, or watch the videos again and it should be all good to go!
Best,
Ali
I can't install SQL server in my windows 11, does this project can also works using mySQL?
Hi,
Concept is the same, but I am not doing it in MySQL so you'll have to go with it as best as you can.
Best,
Ali
Why my backup file is not opening
I am not sure :) hope you find out though.
Best,
Ali
Can I do the same thing in sql workbench? Please reply
Hi,
I don't know :) Try? If it takes .bak files, then yes!
Hi Ali, I copied two backup files through the path that Microsoft mentioned. unfortunately I do not have permission in my SQL to add them to restore Database. I appreciate if you help me to solve this problem.
Hi Maryam,
I am not sure if I fully understand by permission. Maybe run it as an admin?
Hi, thank you very much for creating this video! Could you please advise where can I get the query that you have used to update the AdventureWorksDW2019 database??
Please check the description :)
can you help me with the error "Restore of database 'AdventureWorksDW2022' failed, it just keeps popping up and I don't know how to fix this =(
Hi,
Does it say anything else? I haven't had this issue so bit unsure, but is that all it says?
Hi Ali, I want to let you know I'm well now.
I reinstalled it and everything went smoothly. I appreciate your support, and your videos are great. Thanks for all the good work
@nguyenbathuat5044 happy go hear and enjoy learning!
Best,
Ali
Hi Ali, Thank you for these series. Can I make use of this project as part of my data portfolio? I will mention the inspiration was your channel.
Hi Deepak,
Yes you can, but I would HIGHLY recommend to try and make more personal where you can.
// Ali
@@aliahmad1987 Thanks, sure I will do my best to customized it
Hi , i was trying to add SQL server, but not able to do so. Can you please guide me how to add server details and can able log in successfully ?
Hi Snehal,
I am not sure where you are looking, but you need to get the SQL server instance name, look through the video one more time for that section as I do it there, bit hard to explain here, but you need the SQL server instance name!
I hope you find it out.
Best,
Ali
Cant find setting filter the horizontal list.
Never mind, i find it. It becomes Tile slicer.
Good stuff Achmad :)
i have an issue to update the database the code doesn't work for all the rows Msg 515, Level 16, State 2, Line 124
Cannot insert the NULL value into the column 'SpanishDayNameOfWeek', table 'AdventureWorksDW2022.dbo.DimDate'. This column does not accept NULL values. INSERT failed.
can i open this .bak file in MySQL
Hi Abhinav,
I think Google is your best friend here ;)
// Ali
Hi sir,
where can i get the salesbudget excel file
Hello!
It is on GitHub :)
Best,
Ali
Sir I can't login to power BI desktop with my personal account and i'm not working right now so i don't have work account. hence I'm not able to publish my project to web... please please help me how can i login to power bi desktop without pro version. i really need to upload my project to my portfolio fast. please help sir
Hi,
You could use a temp mail which acts like a work or student account and do it!
Best,
Ali
How to improve ranking(profile) on Kaggle while working as a data analyst
Hi Honey!
I take it you mean this as a video suggestion? Or is it more a question?
Ali
Should I save all the sql query executed in my system everytime.
Hi,
Uhm not sure if I entierly follow, you could save it and just overwrite it? Or?
Best,
Ali
@@aliahmad1987 while I'm pressing ctrl+s then it prompts to save sql query file to my PC's internal storage in the form of .sql library.
The data still does'nt upload I tried to but it doesnt work what to do
Hi,
Bit unsure where you are stuck?
Hi, I am new to this so please can you explain me that what you have updated with the code?
Hi,
Been a while since I made this, but believe I updated dates in the data so that it was newer and more up to date.
Best,
Ali
@@aliahmad1987 thanks 😊 you replied the same day, you don’t know what value you are providing 🤗keep up the work👍
Thanks!
What if I have an Apple Mac? sql server express does not work
Hi David!
I would use an emulator then or else the only option I would recommend is to use a different SQL manager and try and re-do the steps there. Of course you can't follow a long then, but the actual SQL statements etc will be the same.
Let me know how you get on!
// Ali
when at starting it shows my laptop name instead of server express when asking for connecting server what should I do to come to express at the name of my laptop name pz reply
Hi,
Which step are you on? Not sure if I follow...
// Ali
ALI Bro I have a question.. Am very beginner and want to know do I have to learn SQL first to follow along with this video?
Hi Zaid,
No you don't, BUT, it will make it easier to follow the later parts.
This can help you setup practice environment!
// Ali
@@aliahmad1987 Thank you for reply bro.. i just started learning Power Bi and on the path to become Data Analyst.. Your videos motivate me.. Thank you so much Bro .. Hugs :)
When i execute the update SQL script it results in some errors and doesn't show changes in my Dim.date table, can you help me?
Hi Vitor,
I had another person ask me something and he commented with a screenshot on GitHub, but make sure you copy paste right and that you run the query on the right database.
Best,
Ali
Hi again Vitor,
I have tested this and it works fine, but you can also download an updated version of the database with new dates from here: www.sendspace.com/file/z2s0gv I just added it.
Best of luck with the project!
// Ali
Hello. I am new in this field. and I have just downloaded and followed your video. however, the server is not connected automatically like your video.. whats wrong is it?
Hi,
I am unsure as I can't see what you have done so far, but if you have installed the Instance AND the Management Studio then copy the name of the instance and use this as database. Maybe look through the video a bit slower?
Let me know how it goes Farah!
// Ali
@@aliahmad1987 thank you Ali for your reply. I have fixed it. :)
It is possible to change .bak to .csv?
I don't know Dominik :) You tell me :P?
// Ali
thank you sir.....
Most welcome
how to use it in Mysql?
Hi,
It would be similar, but the videos are using MSSQL here, but I think oyu can import the data there also and somewhat ofllow a long.
why my backup file is empty?
Hi,
I am not sure? Hard to say...also not sure what you mean by "Empty"?
Best,
Ali
can you make a detailed video on how to download the sql server management studio
Hi Elizabeth, uhm I don't think I will do that, as it is such a small part of this original video. You can try this link though which will initiate the download: aka.ms/ssmsfullsetup
I hope that helps you out :)
@@aliahmad1987 done. thank you
Hello Ali, thanks a lot for the video, can you please send me the git hub for the updated data
Hi,
No worries!
Links in description :)
Best,
Ali