Video

If u can upload data for script and Question for the same in caption, It will be helpful

Amazing so true I recommend

Great content always 😍. Can you please upload advanced level complete Data Analytics projects in Power BI, Excel & SQL

Awesome project! You just ignited my interesting in ML.

Thank you! Great content. 👏

Hi, thanks a lot for the video. i'm having some issue to calculate the revenue. everytime I try I have this message "Operand data type nvarchar is invalid for multiply operator" . i try to change the data type even if I can see number in the price riders column but then the price column is not regnized. Do you have an idea ? thank you

Thank you for your video. It clarifies what a data analyst will possibly work on the job.

Could you have used window function instead of subquery

This tutoria was quite grannular. I now have a better understanding of Cohort Analysis. Thank you

Awesome as always. I find your shorts informative. In order to pretify or beautify the percentage values we could just nestle or wrapp up the field into format( ) in this way format(sum(sales)/(select sum(sales) from trial_data), "p") ❤

Hi thanks for vedio. I am having trouble in interview to write sql query, any suggestions

This probably.one of my favorites which ive completednand updated and edited and improved on. Kimdly help me though with the meaning of the column 'Son' and 'Pet' and their import to this project. Thanks

Hi Gaelim, I'm Gad. I've successfully completed this project using an addition case for 'Age' thus creating five pie icons instead of 4. Kindly help me with the meaning of the word 'Son' - I don't know what it means it's import and how it relates to every other thing. For the Season Names. I used Transform and new column to change 'Unknown' to 'Select All'. To make become the first among the Tile list on the Slicer Icon. I created a table on Data View, called 'SeasonSortOrder', then created to columns called Season_Names and SortOrder.. Used the Model View to link the Season_Names Columns for both tables together. Then added a new slicer and took out the old one. I still need help to know the meaning of the 'Son' Column and it's purpose I didn't get that in the two videos. Please ........

Another masterpiece, you always deliver great content. Question, should profit margin be revenue - cogs which gives gross profit or profit margin, then divide gross profit by revenue to get profit margin%? Thank you.

I didn't understand how did you calculate the price settings, please clarify

Great explanation 🎉

Hi, thank you for sharing this cool project! I use Mac M1 and have to download Azure data studio instead. Azure couldn't map the dteday column as datetime format and the files couldn't be imported. I had to format that column as string instead and it went through fine. I am wondering if there's any other way to import the file with the dteday properly imported as datetime with Azure?

Great video i love it! One thing if the price is per rider the cost should be per rider as well on the revenue. Minute 22:21. Thank you so much for the video

Great video walkthrough on using SQL and Power BI. I learned so much!

i pray you are muslim and go to heaven.u are so amazing job

I need the link of your giphy animation...

Thank you so much. This video has given me great insight on a real-life project as I transition into data analysis. I appreciate this. 🙌

Great presentation. I have stuck with SUM issue. When I perform Measure = (SUM(Query1[revenue]-SUM(Query1[profit])/SUM(Query1[profit] function, the error pops up "The SUM function only accepts a column reference as an argument." Ive tried different approaches without success. Also, there is a message "cannot find parameter [revenue] Please help.

Is it necessary to remove outliers?

I use linux , so what should i be downloading?? can anyone help me setup everything in linux please

Great video, thank you.

Your videos are very helpful. thank you sir

Bravo for this exceptional and very informative content! I have searched everywhere for content that thoroughly covers the business and recommendation aspects, and I must say you are the best. Keep up the great work!

Please for god's sake improve your mic's quality, the video and the project is great, but the voice/mic is not 😭

Select count(shipment_id), month(shipment_date from shipments group by shipment_date order by shipment_date asc;

Thank you so much!

Hello sir, in the weekday column, what days do the numbers 0 to 6 represent?

Thanks!

One tip, you should make a course on Udemy

Hello, during this project I am facing an issue to load data into power bi from sql server. I tried several ways to resolve it but unable to solve. error occurs when I load the data into power bi in the last tab by selecting "Use Current credentials" after this step the error message is " We couldn't authenticate with the credentials provided. Please try again." IF anyone can help me with this it will be very helpful for me.

i hope its rows between current row and 1 following

Im having trouble downloading the csv file from GitHub. I tried ctrl + s but it showed only webpage option from the drop-down list. Could you please walk me through it? Thank you

Can i become a data analyst with a degree in Applied Mathematics?

Please keep uploading more Data/Business Analysis Case Study (using SQL or Python)

what is SON?

This is truely awesome. Interesting and challenging query. Step 1. Create two new variables (weekday and period). Extract weekday from the timestamp, Create a new grouping column as period bases on the timestamp using conditional statment case when then. Easy! Step2. From the resulting query in step 1, Count the records based on the weekday and period, and rank them by the total count in descending order. Easy, just like taking breakfast in the morning! Step 3. Select and display the results from the previous step2. Voila.

Can we make the AVG of the avg_price as sub query??

i love your videos it's so simple

I love your videos. Learning something new with every video

Awesome, thanks!

Hi, getting ready for upcoming test case for interview, learned A lot of useful things by watching all of your case projects!

I like you approach very much to keep it simple!

Thank you for this video I love it. but when I try to import data, the columns in the temp and atemp sections don't have dots (.) why? even though the data type is already float. Please reply