Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.
Download Excel File: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/001-MSPTDA-IntroToClass.xlsx
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/001-MSPTDA-IntroToClass.pdf
This video introduces the topics that will be covered in this Highline College BI 348 Class:
Name of Class:
BI 348 – Microsoft Power Tools for Data Analysis:
• Power Query
• Power Pivot
• DAX
• Power BI Desktop
• Excel
For Creating:
• Data Models, Reports, Dashboards and Analytics
Taught by Mike excelisfun Girvin, Excel MVP 2013-2018
• A class about connecting to multiple source of data, transforming the data into a refreshable & dynamic data model, and building reports and dashboards to provide insightful and actionable information.
Prerequisites for this class:
• Busn 216: Excel Basics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
• Busn 218: Advanced Excel, https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw
• Busn 210: Business Statistics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj
What Version of Excel:
• Office 365 (updated each month)
What Version of Power BI Desktop:
• Free Tool we will download (update each month)
Over View of Topics for the class:
1. Data Analysis / Business Intelligence terms and concepts that we will learn in this class:
• Proper Data Set
• Fact Table
• Dimension Tables
• Relationships
• Star Schema
• ETL
• Measures
• Dashboards
• SQL
• Data Warehousing
2. Learn how to use Excel Power Query:
• Import Data from multiple sources
• Clean and Transform Data
• Create Data Components for Star Schema Data Models
• Load Data To Excel, the Data Model and Connection Only
• Replace Complicated Excel Solutions with Power Query Solution
• Use the Power query User Interface to create Power Query Solutions
• Learn about the Case Sensitive, Function-based M Code Language that is behind the scenes in Power Query
3. Learn how to use Excel Power Pivot:
• Excel Power Pivot provides:
i. Data Model where we can have multiple tables, formulas and relationships (Star Schema)
ii. Columnar Database to hold "Big Data" and process quickly over that "Big Data"
iii. New Formula Language called DAX:
1. Many More Calculations than in Standard PivotTable
2. Build One Formula that can work in many reports
3. Add Number Formatting to Formulas
• Excel Power Pivot to:
i. Replace VLOOKUP Formulas and Single Flat PivotTable Data Source with Multiple Tables, Relationships in the Data Model to create more efficient Reports & Dashboards
ii. Use Power Pivot Columnar Database to hold millions of rows of data
iii. DAX formulas have more Power than Standard PivotTable Calculations
4. Learn about Building Star Schema Data Models:
a. Why they are important in Power Pivot and Power BI Desktop
b. How to build them using:
i. Power Query
ii. Power Pivot
iii. DAX
iv. Power BI Desktop
5. Learn how to author DAX Formulas for Excel’s Power Pivot & Power BI Desktop:
a. Calculated Column Formulas for Data Model
b. Measure Formulas for PivotTables
c. DAX Functions like SUMX, CALCULATE, RELATED, and Much More…
d. Lean why we must create Explicit rather than Implicit formulas
e. Learn how Row Context works in formulas
f. Learn how Filter Context works in formulas
g. Learn about Scalar & Table Functions
h. Use DAX Studio to visualize and analyze DAX Formulas
6. Learn how to use Power BI Desktop:
a. Power Query to import, clean, transform and create Star Schema Data Models
b. Create Relationships
c. Create DAX Formulas
d. Build Interactive Visualizations
e. Build Dashboards
7. Learn how to use Excel:
• Spreadsheet Formulas & Functions
• Standard PivotTables
• Power Query
• Power Pivot
• Build Data Model PivotTables and the resultant Reports, Dashboards and Analytics
8. Building Refreshable, Insightful Dashboards
a. Build Excel Dashboards
b. Build Power BI Dashboards
9. Case Studies to practice using Power Pivot & Power BI Desktop for Reporting, Building Dashboards and Building Business Analytics Solutions
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!!!!
Видео Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01. канала ExcelIsFun
Download pdf Notes: https://people.highline.edu/mgirvin/AllClasses/348/MSPTDA/Content/Intro/001-MSPTDA-IntroToClass.pdf
This video introduces the topics that will be covered in this Highline College BI 348 Class:
Name of Class:
BI 348 – Microsoft Power Tools for Data Analysis:
• Power Query
• Power Pivot
• DAX
• Power BI Desktop
• Excel
For Creating:
• Data Models, Reports, Dashboards and Analytics
Taught by Mike excelisfun Girvin, Excel MVP 2013-2018
• A class about connecting to multiple source of data, transforming the data into a refreshable & dynamic data model, and building reports and dashboards to provide insightful and actionable information.
Prerequisites for this class:
• Busn 216: Excel Basics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
• Busn 218: Advanced Excel, https://www.youtube.com/playlist?list=PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw
• Busn 210: Business Statistics, https://www.youtube.com/playlist?list=PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj
What Version of Excel:
• Office 365 (updated each month)
What Version of Power BI Desktop:
• Free Tool we will download (update each month)
Over View of Topics for the class:
1. Data Analysis / Business Intelligence terms and concepts that we will learn in this class:
• Proper Data Set
• Fact Table
• Dimension Tables
• Relationships
• Star Schema
• ETL
• Measures
• Dashboards
• SQL
• Data Warehousing
2. Learn how to use Excel Power Query:
• Import Data from multiple sources
• Clean and Transform Data
• Create Data Components for Star Schema Data Models
• Load Data To Excel, the Data Model and Connection Only
• Replace Complicated Excel Solutions with Power Query Solution
• Use the Power query User Interface to create Power Query Solutions
• Learn about the Case Sensitive, Function-based M Code Language that is behind the scenes in Power Query
3. Learn how to use Excel Power Pivot:
• Excel Power Pivot provides:
i. Data Model where we can have multiple tables, formulas and relationships (Star Schema)
ii. Columnar Database to hold "Big Data" and process quickly over that "Big Data"
iii. New Formula Language called DAX:
1. Many More Calculations than in Standard PivotTable
2. Build One Formula that can work in many reports
3. Add Number Formatting to Formulas
• Excel Power Pivot to:
i. Replace VLOOKUP Formulas and Single Flat PivotTable Data Source with Multiple Tables, Relationships in the Data Model to create more efficient Reports & Dashboards
ii. Use Power Pivot Columnar Database to hold millions of rows of data
iii. DAX formulas have more Power than Standard PivotTable Calculations
4. Learn about Building Star Schema Data Models:
a. Why they are important in Power Pivot and Power BI Desktop
b. How to build them using:
i. Power Query
ii. Power Pivot
iii. DAX
iv. Power BI Desktop
5. Learn how to author DAX Formulas for Excel’s Power Pivot & Power BI Desktop:
a. Calculated Column Formulas for Data Model
b. Measure Formulas for PivotTables
c. DAX Functions like SUMX, CALCULATE, RELATED, and Much More…
d. Lean why we must create Explicit rather than Implicit formulas
e. Learn how Row Context works in formulas
f. Learn how Filter Context works in formulas
g. Learn about Scalar & Table Functions
h. Use DAX Studio to visualize and analyze DAX Formulas
6. Learn how to use Power BI Desktop:
a. Power Query to import, clean, transform and create Star Schema Data Models
b. Create Relationships
c. Create DAX Formulas
d. Build Interactive Visualizations
e. Build Dashboards
7. Learn how to use Excel:
• Spreadsheet Formulas & Functions
• Standard PivotTables
• Power Query
• Power Pivot
• Build Data Model PivotTables and the resultant Reports, Dashboards and Analytics
8. Building Refreshable, Insightful Dashboards
a. Build Excel Dashboards
b. Build Power BI Dashboards
9. Case Studies to practice using Power Pivot & Power BI Desktop for Reporting, Building Dashboards and Building Business Analytics Solutions
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!!!!
Видео Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01. канала ExcelIsFun
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![MSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Class](https://i.ytimg.com/vi/IOl3qlCwmEs/default.jpg)
![](https://i.ytimg.com/vi/8qpVKiMiWmU/default.jpg)
![MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop](https://i.ytimg.com/vi/BLl7DpL7JrI/default.jpg)
![MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set](https://i.ytimg.com/vi/rSQwZ1d3b1g/default.jpg)
![MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report](https://i.ytimg.com/vi/uEgFzdx-bhE/default.jpg)
![MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI](https://i.ytimg.com/vi/_DHeTnDa2Q4/default.jpg)
![MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query](https://i.ytimg.com/vi/0NX-GctfZuU/default.jpg)
![](https://i.ytimg.com/vi/09ETeBtWcgk/default.jpg)
![Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546](https://i.ytimg.com/vi/sOsw_d1-y8w/default.jpg)
![Excel Data Analysis Class 02: Power Pivot, DAX Formulas, Relationships, Data Modeling & Much More!](https://i.ytimg.com/vi/eIaKC6zLmb0/default.jpg)
![How to use Power Pivot in Excel](https://i.ytimg.com/vi/rB_IiYbOo7w/default.jpg)
![Power BI Update - February 2022](https://i.ytimg.com/vi/vNK4xygN8Xw/default.jpg)
![MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)](https://i.ytimg.com/vi/wQT3vbNpETc/default.jpg)
![PQB: Power Query Basics From A to Z - Full Course, 5 hours, 17 topics, 25+ Examples](https://i.ytimg.com/vi/jBEFaDCXB34/default.jpg)
![MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables](https://i.ytimg.com/vi/SFgYwVVeqPA/default.jpg)
![E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations](https://i.ytimg.com/vi/VsCdU0e4Hcg/default.jpg)
![Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662](https://i.ytimg.com/vi/3Bjc-cF6NFg/default.jpg)
![How to use Microsoft Power Automate - Tutorial for Beginners](https://i.ytimg.com/vi/dDO4Y4aDYXw/default.jpg)
![MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries](https://i.ytimg.com/vi/JGppsnepJFo/default.jpg)
![Excel Data Analysis Class 03: Power BI Desktop, DAX Formulas, Relationships, Data Modeling& Visuals](https://i.ytimg.com/vi/vBLM3usYRF4/default.jpg)