Learn how to fully automate your Reports in Excel using SQL in order to minimize any manual work. First, we go through how to automate your data import from CSV to SQL. Then, we explain how to create an SQL view selecting the data you need. Afterwards, we explain how to create an SQL store procedure with all the steps needed. Then we go through how to schedule SQL jobs in order to run themselves. Finally, we explain how to connect SQL with Excel and build an automated Excel Dashboard. Hope you enjoy this video!

Overview:
• How to fully automate Excel reports using SQL
• How to automate SQL imports
• How to create a view in SQL
• How to create a store procedure in SQL
• How to schedule jobs in SQL
• How to connect Excel with SQL – via a view
• How to create an automated Excel Dashboard

GitHub Files:

https://github.com/Pitsillides91/SQL-…

Subscribe: https://www.youtube.com/c/Data360YP/featured

#excel #sql