Just combine the two of it using power query and power pivot.. i'm using sql to store and clean up my data. Also to do heavy calculation with a lot of data then connect it to excel for data manipulation and data visualization and more complex calculation but with smaller data.
Truth is that both tools are powerful in their own ways and can be useful in different environments so its a matter of learning as much as you can and use the appropriate tool..
What are some examples of situations where it’s better to use SQL over excel and vice versa? From what I understand SQL seems to be more efficient when you want to access data whereas Excel is better for data visualization and table creation.
SQL can be used to extract data, analyze data and load data to any other source. Whereas, Excel is primarily used to view and analyze data (ofcourse you can do other things as well like visualization but there are better tools for visualization). Loading large dataset in excel will make it very slow (almost unusable) whereas SQL can easily handle huge amounts of data. Excel can be great tool when you want to share small data with your team members but if you need to share large dataset with team member then better share SQL queries. There are so many more differences btw these 2 which I may not be able to explain in this comment here but in general both have their own use case..
Hi al i have a burning questiob. I started using more sql instead of excel as an analyst within our organisation. However, everytime I provide colleagues with a power bi report or data from SQL, they want me to send an excel file of the data. They all want to be able to filter etc themselves in excel. So despite that i summarize lots of data using sql my coworkers hate it because they want theor data in excel. How to deal with this
Hi, i think this happens in many companies.. More people are familiar and comfortable with Excel rather than SQL. And not everyone realizes the advantages of using SQL. Having said that, SQL is very useful for data analysis, extracting and loading data but when it comes to presenting your report to other colleagues or business users (who may or may not have access to SQL or who may just not be comfortable in SQL), it's better you provide them both the options of using Excel as well as SQL (share SQL query and also the steps to regenerate it) Also may be add a single line at the end of your email stating the advantages of SQL. I believe if you do this over a period of time, people will gradually start noticing SQL and perhaps start using it over Excel. But I also believe that both SQL and Excel are here to stay so both will be used. Just that for some scenarios, it's better to use SQL and in some scenarios using Excel would be more efficient.
What about when you want to delete rows in excel which have duplicate values in one column (out of for example 10 columns)…. In Excel I can press delete duplicate rows and unselect all columns except the one with the duplicates. This gives me just the first row for each unique value in the relevant column. I have tried to do this in sql using a combination of cte and row_num() over partition by but have not managed to imitate excel. I am relatively new to sql. Is this something you might cover in a video? 🙏
Hi there, I just pasted your question into chat gpt and the following. Yes, it's possible to delete rows with duplicate values in one column using SQL, similar to how you would in Excel. Here's a basic example of how you can achieve this using a Common Table Expression (CTE) and the `ROW_NUMBER()` function: ```sql WITH CTE AS ( SELECT *, ROW_NUMBER() OVER (PARTITION BY your_column ORDER BY (SELECT NULL)) AS row_num FROM your_table ) DELETE FROM CTE WHERE row_num > 1; ``` In this example: - Replace `your_table` with the name of your table. - Replace `your_column` with the column that contains duplicate values. This code assigns a unique row number to each row within each partition of the specified column. Rows with a `row_num` greater than 1 are considered duplicates and are deleted.
Yes right but then I wanted to keep the video as short as possible and cover the most widely used functions in excel as per my research.. but definitely a point to remember for any future video’s Thanks for the feedback 🙏🏼☺️
very reasonable video ........ he delivered it 100% .... good knowledge and worthy video . good work
Thank you so much for the feedback..
Much appreciated..
Glad you liked it..🙏🏼
This video is very clear and good for Excel users to appreciate SQL. Good job
I've been looking / searching what sql can do better / more than excel and this is actually the best one I've seen so far. Thanks buddy :)
Very much needed Video....simple & clear comparision....It cleared my doubts on Ecxcell v/s SQL........Thanks a ton brother.....
Just combine the two of it using power query and power pivot.. i'm using sql to store and clean up my data. Also to do heavy calculation with a lot of data then connect it to excel for data manipulation and data visualization and more complex calculation but with smaller data.
Truth is that both tools are powerful in their own ways and can be useful in different environments so its a matter of learning as much as you can and use the appropriate tool..
Useful to many.. clear, concise and accurate. Keep doing your great work of helping people by sharing your knowledge.
Thank you for your support 🙏☺️
Excellent comparing. Thanks!
What are some examples of situations where it’s better to use SQL over excel and vice versa? From what I understand SQL seems to be more efficient when you want to access data whereas Excel is better for data visualization and table creation.
SQL can be used to extract data, analyze data and load data to any other source.
Whereas, Excel is primarily used to view and analyze data (ofcourse you can do other things as well like visualization but there are better tools for visualization).
Loading large dataset in excel will make it very slow (almost unusable) whereas SQL can easily handle huge amounts of data.
Excel can be great tool when you want to share small data with your team members but if you need to share large dataset with team member then better share SQL queries.
There are so many more differences btw these 2 which I may not be able to explain in this comment here but in general both have their own use case..
@@techTFQ thanks!
Your welcome 🙏🏼
Sql reminded me to lotus 123 and excel. Thank you for clarifying.
Your welcome Dame :)
Glad it helped..
It's really helpful for me... Thanks
You're welcome
Hi Thoufiq! Thank for very clear explanation. very helpful! continue with the good work :)
Thank you so much 😊
Glad you liked it...
What about SUMIFS?
Nice... Presentation Superb.. Clarity Superb.. Thanks for Sharing... Next time do show ua face while explaining...
Thank you..
Noted on your feedback 😊
Nice, Please make more videos
Thanks a lot.. sure will do..🙏🏼
Makes sense 😊
Hi al i have a burning questiob. I started using more sql instead of excel as an analyst within our organisation. However, everytime I provide colleagues with a power bi report or data from SQL, they want me to send an excel file of the data. They all want to be able to filter etc themselves in excel. So despite that i summarize lots of data using sql my coworkers hate it because they want theor data in excel. How to deal with this
Hi, i think this happens in many companies.. More people are familiar and comfortable with Excel rather than SQL.
And not everyone realizes the advantages of using SQL.
Having said that, SQL is very useful for data analysis, extracting and loading data but when it comes to presenting your report to other colleagues or business users (who may or may not have access to SQL or who may just not be comfortable in SQL), it's better you provide them both the options of using Excel as well as SQL (share SQL query and also the steps to regenerate it)
Also may be add a single line at the end of your email stating the advantages of SQL.
I believe if you do this over a period of time, people will gradually start noticing SQL and perhaps start using it over Excel.
But I also believe that both SQL and Excel are here to stay so both will be used. Just that for some scenarios, it's better to use SQL and in some scenarios using Excel would be more efficient.
@@techTFQ Thanks a lot! This really helps. Keep up the good work! ( Y )
Glad I could help.. all the best and thanks again for appreciating my work ☺️🙏🏼
Bravo❤... may i get the datasets of the two tables you are using.
Good information
Thank you 😊
How to import Excel file in to SQL
Hi. Convert the excel file into .csv format, and then load it into DB for querying using SQL.
What about when you want to delete rows in excel which have duplicate values in one column (out of for example 10 columns)…. In Excel I can press delete duplicate rows and unselect all columns except the one with the duplicates. This gives me just the first row for each unique value in the relevant column. I have tried to do this in sql using a combination of cte and row_num() over partition by but have not managed to imitate excel. I am relatively new to sql. Is this something you might cover in a video? 🙏
Hi there, I just pasted your question into chat gpt and the following.
Yes, it's possible to delete rows with duplicate values in one column using SQL, similar to how you would in Excel. Here's a basic example of how you can achieve this using a Common Table Expression (CTE) and the `ROW_NUMBER()` function:
```sql
WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY your_column ORDER BY (SELECT NULL)) AS row_num
FROM your_table
)
DELETE FROM CTE
WHERE row_num > 1;
```
In this example:
- Replace `your_table` with the name of your table.
- Replace `your_column` with the column that contains duplicate values.
This code assigns a unique row number to each row within each partition of the specified column. Rows with a `row_num` greater than 1 are considered duplicates and are deleted.
Can I learn SQL without or No knowledge of MS Excel.. please guide..
Means, I have no option except practicing SQL?
anyone can tell me about the function of " , " at the first and " S " qt the end?
It would have been more comparable for Substr to be related to the excel "mid" function.
Yes right but then I wanted to keep the video as short as possible and cover the most widely used functions in excel as per my research..
but definitely a point to remember for any future video’s
Thanks for the feedback 🙏🏼☺️
There is an inconvinience to work with regexp in excel ...
yeah thats true..
Thank you for this informative video👍🏻 Indeed very useful👏🏻 Keep going
Thank you 😊 😊
Great Efforts sir 👍
0:28
2:00
What’s this about Pedro ? 🤔
@@techTFQ I use this to review next time. Bookmark.
Ohh ok .. cool .. happy learning bro 🙏🏼🙂
Hi did you see my question?
Which question?
👍👍
Thank you Nourish.. 😊
Waste of time...not useful ...both have their own perks...