How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]
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!
Support the channel on Patreon:
https://www.patreon.com/data360yp
Data Analytics Course Link:
http://ipidata.teachable.com/
GitHub Files:
https://github.com/Pitsillides91/SQL-for-Data-Analyst/tree/master/CSV%20to%20SQL%20to%20Excel%20Automation
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
Excel Tutorial Links:
a. https://www.youtube.com/watch?v=RbG8c-nT3mU&feature=youtu.be
b. https://www.youtube.com/watch?v=2XgxBvHvgFY&feature=youtu.be
c. https://www.youtube.com/watch?v=4lvZfcauM-M&feature=youtu.be
Excel Dashboard creation:
• https://youtu.be/2u6QcizAHvQ
•
SQL Tutorial Links:
d. https://www.youtube.com/watch?v=SlFPgggt5_4
e. https://www.youtube.com/watch?v=E0HvPk_Q5aU
f. https://www.youtube.com/watch?v=Yy-ykWlvwAM
SQL most common queries:
- https://youtu.be/8pfE57Y8TnM
How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]
Yiannis Pitsillides on Social Media:
https://twitter.com/pitsillides91
https://www.instagram.com/ypexists/?hl=en
https://www.pinterest.co.uk/pitsillides91/boards/
https://www.facebook.com/groups/1500092413449073/
Tags:
how to link sql to excel
Видео How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation] канала Data 360 YP
Support the channel on Patreon:
https://www.patreon.com/data360yp
Data Analytics Course Link:
http://ipidata.teachable.com/
GitHub Files:
https://github.com/Pitsillides91/SQL-for-Data-Analyst/tree/master/CSV%20to%20SQL%20to%20Excel%20Automation
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
Excel Tutorial Links:
a. https://www.youtube.com/watch?v=RbG8c-nT3mU&feature=youtu.be
b. https://www.youtube.com/watch?v=2XgxBvHvgFY&feature=youtu.be
c. https://www.youtube.com/watch?v=4lvZfcauM-M&feature=youtu.be
Excel Dashboard creation:
• https://youtu.be/2u6QcizAHvQ
•
SQL Tutorial Links:
d. https://www.youtube.com/watch?v=SlFPgggt5_4
e. https://www.youtube.com/watch?v=E0HvPk_Q5aU
f. https://www.youtube.com/watch?v=Yy-ykWlvwAM
SQL most common queries:
- https://youtu.be/8pfE57Y8TnM
How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]
Yiannis Pitsillides on Social Media:
https://twitter.com/pitsillides91
https://www.instagram.com/ypexists/?hl=en
https://www.pinterest.co.uk/pitsillides91/boards/
https://www.facebook.com/groups/1500092413449073/
Tags:
how to link sql to excel
Видео How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation] канала Data 360 YP
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Dynamic Power BI reports using Parameters](https://i.ytimg.com/vi/iiNDq2VrZPY/default.jpg)
![How to Extract Data and Create Reports Automatically in Excel with Multiple If Statments](https://i.ytimg.com/vi/jrUTPKjYoEQ/default.jpg)
![How to easily automate boring Excel tasks with Power Query!](https://i.ytimg.com/vi/L4BuUzccLpo/default.jpg)
![Querying SQL Server Data in Excel with a Parameter](https://i.ytimg.com/vi/KqHFDhPAG98/default.jpg)
![Learn Excel Reporting Automation For Beginners with Excel VBA (Code Included)](https://i.ytimg.com/vi/Yk5LwbvUl5I/default.jpg)
![How to Use SQL with Excel using Python](https://i.ytimg.com/vi/71zkSuzkJrw/default.jpg)
![](https://i.ytimg.com/vi/gixQHcCHbBM/default.jpg)
![Connect SQL Server from Excel and retrieve data](https://i.ytimg.com/vi/h1ljz9uVW4c/default.jpg)
![SQL export data to csv (Automatically)](https://i.ytimg.com/vi/LVpzDoCWi1I/default.jpg)
![Automate Multiple Sheet Excel Reporting - Python Automation Tutorial | Full Code Walk Through (2019)](https://i.ytimg.com/vi/1Kcco6koC34/default.jpg)
![Excel Alternative: How to use SQL to perform EXCEL tasks (SQL for Data Analysis)](https://i.ytimg.com/vi/i7BjHjRafU8/default.jpg)
![Fully Automated Excel dashboard with multiple source files | No VBA used](https://i.ytimg.com/vi/qPJMrwtYSDc/default.jpg)
![How to create a Export to Excel / CSV button in Power BI](https://i.ytimg.com/vi/BnTipbooeP0/default.jpg)
![Import and Export Excel with SQL Server](https://i.ytimg.com/vi/_YMS74ZIPVs/default.jpg)
![Introduction to SQL Programming for Excel Users - SQL Server Windows Setup](https://i.ytimg.com/vi/VnJAgND_iLc/default.jpg)
![Tableau KPI dashboard Design for Business Dashboards](https://i.ytimg.com/vi/WT-8TLEXpF4/default.jpg)
![Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)](https://i.ytimg.com/vi/fHFUh6EhBcw/default.jpg)
![Power Query Overview - Automate Data Tasks in Excel & Power BI](https://i.ytimg.com/vi/vq9AgAtSvQg/default.jpg)
![SQL Tutorial for Beginners - Everything you need to know for Data Analytics - Part 1](https://i.ytimg.com/vi/SlFPgggt5_4/default.jpg)
![How to Combine Excel Tables or Worksheets with Power Query](https://i.ytimg.com/vi/HcfKOusOJhA/default.jpg)