วีดีโอ

Hi, I would check the object name (as the error points out) first? It should have the same nam e in the database as in the Script to be able to fetch it through SQL. Ali

Hi, I would check that the relationship is correct and the format on the column is integer? Those are some thoughts top of mind!

@@aliahmad1987 The relationship between which columns? And what columns should be integer?

@@timilehinfalusi4234 I want to help, but no point giving away the answers. Take a look at the data model and think about it logically, which tables has to be connected and verify that. After that ask yourself which column is being summed and if that looks correct. I am sure you will figure it out :)

@@aliahmad1987 I haven't been able to do figure it out. Could I reach out to you privately.

@@mankiratsingh8494 Hi, I have created it in Python and SQL Server. Ali

Hi, Yes - I don't see why not :) You can use it to learn and showcase!

@Sweetzee-v9q Hi, Yes, sure, why not? If it makes sense and fits in then go for it! Just make sure it isn't considered cheating etc. of course 😎

Hi Peter, Yes I have the same! There are some customer_journey rows which only has 1 event. When I think about it, a part of the project could have been to handled this also as I see a lot of the events are "Checkout". Could also indicate that they have gone directly to the Check Out page. Either way, an average function over a blank row will return average :) If you want to you can adjust this one: COALESCE(Duration, avg_duration) AS Duration -- Replaces missing durations with the average duration for the corresponding date to COALESCE(Duration, avg_duration, 0) AS Duration -- Replaces missing durations with the average duration for the corresponding date And it will replace the Duration NULL value with a 0, and then you can take it out the measure in Power BI if you want to do an average of that. Does that make sense? Thanks for pointing it out btw and thanks for watching!

Hi Ali, Thank you very much. Sorry for this late reply. Now understand. I will checknit it and try all of them. Thank you again. Peter Thank you!

@@peterkadar7754 You are welcome!

You are welcome! No, you don't. The purpose or thought behind is this statement is that you notice it, and then do something about it and I was just using some SQL concepts how to do it practically. An idea, depending on how motivated you are ;) is to still write the statement and use it as a test to see if you can do it, and verify through SQL statement and an output that there aren't any duplicates. In the project I made though, it is only an issue in one table.

Sorry you didn't enjoy the video, but I still hope you learned something!

@@aliahmad1987 I learned a lot and still learning thank you, just the music makes some distraction if you can make future videos clean

Hi there, Yes - I would just update it like that, by just updating the dates in the spreadsheet with a basic replace on the dates. I'll see if I can do it this weekend as I've thought about it a couple times now. Thanks for watching! Ali

@@aliahmad1987 thank you for the quick response!

Hi Gurvinder, First of all thank you for watching and supporting. I would recommend looking into SQLBI. They have some really good DAX videos. My focus will be on projects as I find it somwhat challenging and fun to make. DAX is still very important, so again, SQL BI would be an excellent source for you. Wish you all the best in your learnings brother! Ali

Thank you! I will keep your suggestions in mind as I think of new projects. I am already playing around with some ideas. It makes me happy to hear you have found some value in the work and thank you for watching! // Ali

Thank you for the kind words :) It gives me an extra boost to keep sharing and creating. Wish you a continued great day! Ali

Hi again, I really appreciate it. Gives me motivation to keep going and create more :) Stay on the lookout for new series with new topics. Maybe Retail will be the topic of the next one? Will see. Thanks again and keep learning! Ali

@@aliahmad1987 Dear Ali, I apologise if I previously addressed you by your last name. 😅 While retail is an interesting area, my interests are leaning more towards healthcare data analysis.

No worries about the last name. I will note it down, it is a good segment to also look into for me. THanks for the suggestion!

Hi Soheil, Thank you for the kind words. I think my main focus for the rest of the year will be on portfolios as I enjoy the mixture of the soft and technical parts, but I will take your input down and keep it in mind. Keep up the good work learning and thanks for watching!

Hi, I'm not sure what you mean here? Ali

Thank you for sharing Navid! I'm sure it will be useful for others working on this in 2024. Cheers, Ali

You are welcome! Glad you enjoyed it :)

Thank you! Out on Wednesday 👍🏽. Will be moving into Power BI then, which I think a lot will enjoy. Have a great weekend and thanks for watching! Ali

Hello Brandon! Thank you for watching and the kind words! I am very happy to hear you enjoyed it. That is a great suggestion! I will note it down among some ideas I have. I think that I will moe onto another segment next though. Any suggestions? I haven't thought about mixing Power BI / R yet in one project, but time series analysis is something that I have on the block. Thank you again for watching! Ali

@@mkrtie Hi, It is on GitHub, all files for the project is there. Best, Ali

@@aliahmad1987 thanks so much! in my downloaded dataset the latest date is 2024, thats why I was wondering if there is an updated version. Thank you for your work!!

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, First of all - thank you for watching and supporting. Yes - I will add more projects with other segments / indstries with Finance being one of them :) I think towards the end of this one I will run a poll on it, but top of mind I have planned Retail, Customer Service, Supply Chain, Finance and maybe another one on Sales, but a bit more advanced one. Wish you a continued great day! // Ali

@@aliahmad1987 Thank you in advance for all your efforts and everything.

Hi, I am unsure how to use a .bak file with PostgreSQL. Why not use it with MSSQL Server? Thanks for watching! // Ali

Hi, We will build it in Part 4 in Power BI using the SQL statements. Soon ready 😎. How did you find this part?

@@ayajaidi9250 which one are you looking for?

@@aliahmad1987 Adventure work backup file. there are so many of them. need the specific one you have on your desktop.

@@omarisawesome365 I will make more after this one is finished. Are there any special segments or industries you are interested in?

Thank you so much! I’ve completed many courses, but I haven’t had practical experience or job opportunities to use SQL for data analysis, as my country doesn’t commonly use SQL for this purpose. I’m passionate about learning and eager to deepen my understanding and skills further.

@@walachanel3838 you are welcome! Happy the examples are useful! // Ali

Hi, No! I lost this footage while traveling. Sorry! // Ali

That sounds weird, when you say empty? What kind of error are you getting? I'll double check the file tonight too, but would be great to know. Thanks for letting me know! Ali

​@@aliahmad1987 The error I get says, "The volume on device 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS04\MSSQL\Backup\Episode 2 - PortfolioProject_MarketingAnalytics.bak' is empty. RESTORE HEADERONLY is terminating abnormally. (Microsoft SQL Server, Error: 3254)" I believe because the file I downloaded from github is an empty file. I may be downloading the wrong file or taking the wrong steps when trying to get the .bak file. The steps I took on github was click, "Episode 2 - PortfolioProject_MarketingAnalytics.bak." Then I clicked download raw file. Let me know if I am trying to download the wrong file on git. Thanks for making this video and for the help!

I've updated it now. Please check the version here, and let me know if you have any issues with this one? github.com/aliahmad-1987/DataAnalystPortfolioProject_PBI_SQL_Python_MarketingAnalytics/blob/main/Episode%202%20-%20PortfolioProject_MarketingAnalytics.bak

@@aliahmad1987 It works, thank you for your help!

Out now ;) Check it out and let me know what you think! Thanks for watching // Ali

That's great! Can't wait to learn from your videos, it helps me a lot.

@gauravpatil9652 second part coming out today! Thanks for watching and let me know what you think of that one also 😎 Ali

@parmisjv5022 thank you! Hopefully you will also enjoy part #2 which comes out tomorrow. Thanks for watching and all the best. // Ali

Hi, What do you mean link? Best, Ali

Hi, All the files should be there. Which one is the one you can't find? Best, Ali

@@aliahmad1987 Hi, I'm having trouble running the script for the 'Cleansed DIM_Customers Table' using the AdventureWorks 2022 database. The script doesn't seem to work properly. Could you provide some guidance or a solution for this issue?

Hello! What is the error you are getting? Maybe I can help. Ali

@@brandonmartinez8558 Hi Brandon, Maybe - it depends what the issue is? Ali

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

Be on the lookut on Wednesday :) Part 2 comes out then. Keep up the good work and let me know if you have any questions! // Ali

It is indeed. Excited to share it with you! Ali

Thank you Aliou! Excited to hear what you think about it! Ali

Will be ready on Wednesday :) Thank you for watching and supporting! Ali

Hi, Yes to publish you need a school or work account in Power BI. Best, Ali

@@aliahmad1987 then, I will have a tonight😪😓💔

@@ChraXoshnaw-u9p Sorry to hear that :/ Hope you figure it out!

Hi, You have to put the values (measure) on one axis, and dimension on other. Do some testing here and I am sure it'll be an easy thing to find out for you. Best, Ali

@@aliahmad1987 ow ok, I will put them on x axis and y axis, maybe it solves.

You are welcome, my friend :) Obrigado for the sub ;)

Hi, Thank you for the comment. I am working on some more videos. I am unsure how advanced you fill find them, but hopefully you will learn something from them also. Continued great day! Ali

Hi, I just upload them on GitHub, or what do you mean? It is just an upload of files? Best, Ali

@@aliahmad1987 ow, thank you so much, I will just upload manually then. best regards.

@@ChraXoshnaw-u9p Sounds good. Keep up the good work!