MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop

Download Excel START File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-ImportSQLIntoPowerQuery-Start.xlsx
Download Excel FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-ImportSQLIntoPowerQuery-Finished.xlsx
Download Power BI Desktop FINISHED File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MPSTDA-PowerBIDesktop-GetSQL-Data.pbix
Download pdf Notes about Power Query: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-PowerQueryImportSQLData.pdf
Practice Problems: Assigned Homework:
Download homework file (Practice Problems) : https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-Homework-Start.xlsx
Example of Finished Homework: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/PowerQuery/011-MSPTDA-Homework-Finished.xlsx

link to Microsoft Notes on Direct Query: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

In this Video learn how to connect to an SQL Server Database and extract and transform data using Power Query in Excel and Power BI Desktop.

Topics:
1. (00:16) Introduction
2. (00:32) What is an SQL Server Database
3. (02:19) The Goal of our Queries and a look at the end result reports in Excel
4. (03:04) Comparing and Contrast using 1) Using Power Query User Interface or 2) Writing SQL Code in Power Query
5. (04:46) Example 1: Use Power Query User Interface to connect to SQL Server and Extract, Transform and Load Data.
6. (11:27) Example 2: Write SQL Code to connect to SQL Server and Extract, Transform and Load Data.
7. (14:44) Example 3: Using Power BI Desktop to connect to SQL Server and Import multiple Tables.
8. (18:29) Summary

Comprehensive Microsoft Power Tools for Data Analysis Class, BI 348, taught by Mike Girvin, Excel MVP and Highline College Professor.

The Power Query logo used in this video is copyright of and used with the express permission of https://powerquery.training
Thanks to Ken Puls and Miguel Escobar for letting me use their logo!!!!

Видео MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop канала ExcelIsFun