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!!!!