How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]
Learn how to fully automate your Reports in Power BI 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 Power BI and build an automated Power BI 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/Power-BI-raw-data/tree/master/SQL%20to%20Power%20BI
Overview:
• How to fully automate Power BI 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 Power BI with SQL – via a view
• How to create an automated Power BI Dashboard
Power BI Tutorial Links:
• https://youtu.be/wWPY8onnvs8
Power BI Dashboard creation:
• https://youtu.be/gUywyH1DVOE
• https://youtu.be/XjKNxgc4Is4
• https://youtu.be/8uQ8CbScyrM
SQL Tutorial Links:
a. https://www.youtube.com/watch?v=SlFPgggt5_4
b. https://www.youtube.com/watch?v=E0HvPk_Q5aU
c. https://www.youtube.com/watch?v=Yy-ykWlvwAM
SQL most common queries:
- https://youtu.be/8pfE57Y8TnM
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 connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]
Видео How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI] канала 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/Power-BI-raw-data/tree/master/SQL%20to%20Power%20BI
Overview:
• How to fully automate Power BI 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 Power BI with SQL – via a view
• How to create an automated Power BI Dashboard
Power BI Tutorial Links:
• https://youtu.be/wWPY8onnvs8
Power BI Dashboard creation:
• https://youtu.be/gUywyH1DVOE
• https://youtu.be/XjKNxgc4Is4
• https://youtu.be/8uQ8CbScyrM
SQL Tutorial Links:
a. https://www.youtube.com/watch?v=SlFPgggt5_4
b. https://www.youtube.com/watch?v=E0HvPk_Q5aU
c. https://www.youtube.com/watch?v=Yy-ykWlvwAM
SQL most common queries:
- https://youtu.be/8pfE57Y8TnM
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 connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI]
Видео How to connect POWER BI with SQL and build an AUTOMATED Dashboard [SQL to Power BI] канала Data 360 YP
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Power BI Get Data: Import vs. DirectQuery vs. Live (2021)](https://i.ytimg.com/vi/-ip7mKUdwRg/default.jpg)
![Power BI Tutorial From Beginner to Pro ⚡ Desktop to Dashboard in 60 Minutes ⏰](https://i.ytimg.com/vi/AGrl-H87pRU/default.jpg)
![Mastering Microsoft Power BI - Create Power BI Report in 5 mins](https://i.ytimg.com/vi/grX-r4nxEXM/default.jpg)
![](https://i.ytimg.com/vi/p0LLUoy3Vho/default.jpg)
![Power Query Overview - Automate Data Tasks in Excel & Power BI](https://i.ytimg.com/vi/vq9AgAtSvQg/default.jpg)
![Learn Basic SQL in 15 Minutes | Business Intelligence For Beginners | SQL Tutorial For Beginners](https://i.ytimg.com/vi/kbKty5ZVKMY/default.jpg)
![Power Automate Tutorial - Refresh Power BI Dataset](https://i.ytimg.com/vi/HzvsQ_CYF88/default.jpg)
![MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop](https://i.ytimg.com/vi/igCkhNkkRvI/default.jpg)
![Get started with the Power BI Gateway](https://i.ytimg.com/vi/Vlv1tbuZNcM/default.jpg)
![7 Tips & Tricks for Stunning Power BI Reports!](https://i.ytimg.com/vi/i1kCHZEhnEY/default.jpg)
![How Power Query Will Change the Way You Use Excel](https://i.ytimg.com/vi/6lBqYInBldk/default.jpg)
![How to Automate Excel Reports Using SQL [CSV to SQL to Excel Automation]](https://i.ytimg.com/vi/2cZ-Z_j11EE/default.jpg)
![Import vs DirectQuery in Power BI](https://i.ytimg.com/vi/tDIsCVB7mnI/default.jpg)
![Secrets to Building Excel Dashboards in Under 15 Minutes!](https://i.ytimg.com/vi/9p6tWCHbtPQ/default.jpg)
![5 IDEAS to take Power BI reports to the NEXT LEVEL](https://i.ytimg.com/vi/k9LGRfREuIk/default.jpg)
![Conditional Navigation is an INSANE AMAZING way to change pages in Power BI Desktop](https://i.ytimg.com/vi/-kaUnBXvvGo/default.jpg)
![2 ways to reduce your Power BI dataset size and speed up refresh](https://i.ytimg.com/vi/c-ZqToc85Yc/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)
![Power BI Tutorial: 4 Ways To Get Data](https://i.ytimg.com/vi/sxx-z5hm-aE/default.jpg)
![Build a Slicer Panel in Power BI and take it to the next level](https://i.ytimg.com/vi/xy9nmSQeUWg/default.jpg)