now we can just simply do df.to_excel("filename",index= 1/0)

Much appreciated

13 minute video for 5 lines of code 💀

Thank you sooo much!! My brain was hurting 😂. New subscriber!🎉

great video

I can't seem to find the file, I already pasted it into the Backup folder :( I also checked the file permission and everything seems to be ok.

It was really difficult for me to locate the file. Thank you so much for this.

the music is extremely annoying, regardless of the content, I had to close this video after a few seconds of that music

what happened after downloading icon map??? how you got that icon in powerbi????

Thank 🎉

Made it SIMPLE, at all !!

Who has came frm aiml section

file > save copy in github?

don't jump steps - how did you get to this interface? kzbin.info/www/bejne/i4nNqYqjr71reac This is the key part and how did you get there?

Very clever - Thanks!

Anything to be done from SQL db side if Power query is loading data very slow ?

git repo please

THANKS

Thank you, that was great

Bravo Sir! 👏 What a valuable mini-project using SQL! 🎉 Comments: 1. MySQL: No need to specify INNER word in MySQL syntax (i.e. JOIN means INNER JOIN) 2. Type of JOINS: In the real world; INNER JOIN & LEFT JOIN are the most frequently used types of joins 3. Data Cleansing: Handling missing data (i.e. NULLs) using COALESCE (Column_ name, a specified value) function is a MUST. Congrats sir for such informative SQL demo! 🎉🎉🎉🎉

where you add scrollbar?

Thank you bro very important Project

bro you are using older modules like pdfFileReader. This moduile is not available in today's time. and if available then particular functionality isn't working

Sir, email automation not working...

Helpful video thanks. BUT get rid of the annoying and distracting music.

using SUM() over partition was briliant, learnt something new today! thanks a lot man!

Great video, thank you. I can't stand SSMS anymore - so NOT user friendly. VS Code is King!

Thank you so much Brother

It would be helpful if you demonstrated how to link to other files in the same repository from this notebook.

The first two answers are incorrect and do NOT SHOW A RUNNING TOTAL IN ACCORDANCE TO ASCENDING MONTHS (just look at the answers). Since the Month field is a VARCHAR, you've ordered the running total alphabetically ('Apr' first month, 'Sep' last month). A solution as follows could be used to overcome that: SELECT *, SUM(Revenue) OVER (ORDER BY CASE WHEN Month= 'Jan' THEN 01 WHEN Month= 'Feb' THEN 02 WHEN Month= 'Mar' THEN 03 WHEN Month= 'Apr' THEN 04 WHEN Month= 'May' THEN 05 WHEN Month= 'Jun' THEN 06 WHEN Month= 'Jul' THEN 07 WHEN Month= 'Aug' THEN 08 WHEN Month= 'Sep' THEN 09 WHEN Month= 'Oct' THEN 10 WHEN Month= 'Nov' THEN 11 WHEN Month= 'Dec' THEN 12 END ASC) FROM Revenue

DROP TABLE IF EXISTS Employee; CREATE TABLE Employee ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, HireDate DATE NOT NULL, Salary DECIMAL(10,2) NOT NULL ); INSERT INTO Employee (EmployeeID, FirstName, LastName, HireDate, Salary) VALUES (1, 'John', 'Smith', '2019-01-01', 75000), (2, 'Jane', 'Doc', '2019-02-15', 80000), (3, 'Bob', 'Johnson', '2019-03-30', 90000), (4, 'Sarah', 'Lee', '2019-04-15', 85000), (5, 'Mike', 'Brown', '2019-05-01', 95000), (6, 'Lisa', 'Davis', '2019-06-15', 100000), (7, 'Tom', 'Wilson', '2019-07-30', 110000), (8, 'Ann', 'Jones', '2019-08-15', 120000), (9, 'Peter', 'Parker', '2019-09-01', 125000), (10, 'Mary', 'Kim', '2019-10-15', 130000); DROP TABLE IF EXISTS Revenue; CREATE TABLE Revenue ( Year INT NOT NULL, Month VARCHAR(3) NOT NULL, Revenue DECIMAL(10,2) NOT NULL); INSERT INTO Revenue (Year, Month, Revenue) VALUES (2021, 'Jan', 50000), (2021, 'Feb', 75000), (2021, 'Mar', 90000), (2021, 'Apr', 65000), (2021, 'May', 80000), (2021, 'Jun', 95000), (2021, 'Jul', 110000), (2021, 'Aug', 120000), (2021, 'Sep', 100000), (2021, 'Oct', 90000), (2021, 'Νον', 75000), (2021, 'Dec', 60000);

Great video, Big Help.. Thank you. Could you please provide the hex code for Background color and Green one too.

Seu video me inspirou para fazer um dashboard

not working with sql 2014 ?

How do we do the same thing for the walking time?

Nice trick, but it doesn't work when you have columns without data (i.e. sales for Aug/Sep/Oct/Noc/Dec when you are still in July) that are forced with "Show items with no data"

thankk you for this. I was searching for this. now i need to do something else per row get the absolute varainace/sum( total absolute variance column) how would you do that?

The demos of this look nice but I've tried it on UK geojsons and haven't get it working.

Thank you so much for sharing your knowledge and experience.

how to open a epxlorer window of a certain size in a certain location?

so helpful thanks boss

Pls continue

your video helped me, thanks bro!

I am in tension how to achieve total and subtotal in sql query. But this video make me free from tension. I believe everything is possible in sql. Thanks

Has anyone tried this in 2024? I've tried to troubleshoot this for 30 mins and mine still isn't working >.< I think to do with google not allowing me to login using the SMTP? Thanks for any help.

How can you make the table you added be more dynamic for all employees? Will this work on Groups?

Sorry, but how did you manage to insert line breaks in text inside the buttons?

Great Workaround. so simple. I have another challenge on advanced filtering and can't find a solution. I want to filter on certain phrases: e.g. "today is a great day" and "today is the best day". How can I filter on exactly these phrases if they're a part of a longer text block?

Dear sir you show google sign up without phone number automation

This was helpful and very well explained. Thank you for sharing this video.