Відео

You can still calculate the speed in km/h when you multiply the speed in km/min by 60. It depends on which method you wish to use. However, you are correct regarding the question for each runner and each delivery. I missed out on that part. Thanks for pointing out.

My assumption is that you are asking about question number 5. You can use the same query in MySQL as well. It will run similar to how it runs on SQL server.

I am yet to upload a video on that. It involves a few steps. You can checkout this video from Brian: ua-cam.com/video/GXG0glzzIqE/v-deo.html

Thanks for your response. The question says "not just sushi". Hence, while you assign points to products purchased in 1st week, you will need to continue to consider points for sushi products as in the previous questions.

Thanks for the encouraging feedback :) I'm glad you found the video helpful!

Hi, I'll try to do a detailed video on how to manage pages efficiently in the future. For the time being, you can refer to any other UA-cam video on the same topic. Thanks!

Sure, you can try keyboard shortcuts as well. It's totally up to you. Thanks for the input.

Good question. In the table, the purchases are arranged in order of product_id. So for the same day, product_id 1 and 2 are available. You can take 1 as the product_id and answer the query since we do not have a timestamp given in the table.

It could occur mostly if you are using an older version of Excel. Here are a few alternatives you can try: 1. Go to Data > Get Data > From File > From Folder, then select your PDF file 2. Use Adobe Acrobat to convert the PDF to Excel format first 3. Copy and paste data from the PDF into Excel (if the PDF allows text selection) 4. Use a third-party PDF to Excel converter

😊 Glad you enjoyed the video. Do subscribe to receive similar videos in the future. Cheers!

In my video, I have covered just the basics of file conversion to PDF. If you need help fixing tiny PDFs, please checkout this video from Leila Gharani: ua-cam.com/video/5hD5xqokDeQ/v-deo.html

Thanks for the feedback. I'm glad you loved the video! Yes, you are correct, the process of data cleaning might be a bit long sometimes via SQL. I myself am still learning SQL every single day. I am sure better techniques to handle strings will come up soon as I explore more.

You are most welcome! I'm glad it was helpful to you :)

I'm glad you liked it. Stay tuned for more such projects!

It's a good question. Thoroughly describe the goals of your project (in this case, it is to analyze the data from a fictional diner to help the owner, Danny, understand his customers' behaviors and preferences.), the SQL queries you executed, and the insights you derived (these are the results of each query). This documentation demonstrates your analytical thinking and ability to communicate effectively. From next video onwards, I will also showcase how you can document your findings. This information can be presented in any form you wish, but a PDF is highly recommended. Just upload your SQL queries onto your github repository as that will be the best source of your portfolio.

Hi, appreciate your request, but I'm presently unavailable for a 1:1 training. I would recommend taking a 1:1 training through an established training center near you (or online) as you are interested in a particular domain.

Where r u from ,,,

@@lenkaladivya5707 :: Vijayawada

You are most welcome! Stay tuned for more such projects.

Thank you! Cheers!

Thanks, glad you enjoyed the video :)

Thanks. Glad to know you liked it. More videos coming out soon.

Appreciate your feedback. Glad it was helpful!

Thanks, Gana! Glad you liked it :)

Thanks, Ravi. Glad you liked it! Subscribe for more such videos.

You are welcome! Glad you liked the video. More projects coming very shortly. Please subscribe and hit the bell icon to stay updated!

Thanks. I'm glad you enjoyed the video!

I hope u can bring more project like this ❤​@@TurnToData

Definitely. More SQL Projects will be uploaded in the coming days 👍

Glad you liked it!

You would need to be signed in to use all Microsoft 365 apps.

Glad you liked it :)

Glad it was helpful!

You are most welcome! I'm glad you enjoyed the video :)

Welcome! Glad you liked the video :)

Glad you liked the video :)

You are most welcome! Do subscribe to the channel to receive more helpful videos on Excel and other data topics.

@@TurnToData sure

You're most welcome. I'm glad you liked it :)

Thanks for the feedback.

That's correct. XLOOKUP is much more convenient and advanced than VLOOKUP & INDEXMATCH. Just one thing to note is that "IndexMatch" is available in all Excel versions and is helpful for anyone using an older Excel version. XLOOKUP is available in Excel versions 2021 and above. We'll cover XLOOKUP soon :)

Glad you liked the video :) I use Boya By M1 at the moment. It is beginner friendly. Here's the Amazon link in case you wish to take a look: amzn.to/3HcF6cb

@@TurnToData Keep uploading!