Придбаний [Power Query Academy] Transform your Data into Information and gain a competitive edge [Ken Puls, Miguel Escobar]

[Gadzhi]

[Power Query Academy] Transform your Data into Information and gain a competitive edge [Ken Puls, Miguel Escobar]



What if You Could Master Data Cleaning and Transformation to Completely Automate Business Intelligence and Reporting?

Power Query is the most important data analysis tool since PivotTables
It allows you to clean, reshape, and combine your data with ease, no matter where it comes from.

Learning to use Power Query means less time spent manipulating data and more time analyzing it to gain powerful insights and make better decisions.

Until now, building BI solutions has been a painful, repetitive process requiring a great deal of manual effort to clean, filter, and format data before it can even be used.

And updates have been tedious and error prone.

Power Query will save you hours of time gathering and preparing your data before loading it into your data model.

Скрытое содержимое.

0. Introduction

• Video 1: Welcome to Power Query Academy!
• Module 0 Handout (PDF Download)
• 'M is for Data Monkey' eBook [1st Edition] (Multiple Formats Download)
• Power Query Recipes v1902 - released Feb 2019 (PDF Download)
• Module 0 Quiz

1. Importing Basic Data

• Module 1 Sample Files (ZIP Download)
• Module 1 Handout (PDF Download)
• Video 2: Connecting to Data in Excel Workbooks
• Video 3: Connecting to Data in the Current Excel Workbook
• Video 4: Connecting to Non-Delimited Flat Files (*.txt, *.prn)
• Module 1 Quiz

2. Query Settings

• Module 2 Sample Files (ZIP Download)
• Module 2 Handout (PDF Download)
• Video 1: Step Settings
• Video 2: Choosing Query Load Destinations
• Video 3: Query Error Auditing
• Video 4: The Importance of Defining Data Types
• Module 2 Quiz

3. Simple Transformation Techniques

• Module 3 Sample Files (ZIP Download)
• Module 3 Handout (PDF Download)
• Video 1: Unpivoting Columns
• Video 2: Pivoting Columns
• Video 3: Split Columns into Other Columns
• Video 4: Split Columns into Rows
• Video 6: Sorting Data
• Video 7:Transforming and Adding Columns Based on Existing Columns
• Module 3 Quiz

4. Combining Data

• Module 4 Sample Files (ZIP Download)
• Module 4 Handout (PDF Download)
• Video 1: Appending Tables Individually
• Video 2: Appending Tables in the Current Workbook
• Video 3: Appending Worksheets in an External Workbook
• Video 4: Combine All Flat Files in a Folder
• Video 5: Combine a Named Worksheet from Multiple Workbooks
• Video 6: Combine All Worksheets in Multiple Workbooks
• Video 7: Merging Tables - Basics
• Video 8: Merging Tables - Join Types
• Video 9: Merging Tables - Cartesian Products
• Video 10: Merging Tables - Approximate Match
• Module 4 Quiz

5. Miscellaneous Data Sources

• Module 5 Sample Files (ZIP Download)
• Module 5 Handout (PDF Download)
• Video 1: Getting Data from Exchange
• Video 2: Web Data - Webpage with Table Tags
• Video 3: Web Data - Files Publicly hosted on the Web
• Video 4: Web Data - Reading HTML Document
• Video 5: SharePoint Data - Introduction
• Video 6: SharePoint Data - Lists
• Video 7: SharePoint Data - All Files from Site
• Video 8: SharePoint Data - the From Folder Experience
• Video 9: Connecting to a JSON File
• Module 5 Quiz

6. Data from Relational Sources

• Module 6 Sample Files (ZIP Download)
• Module 6 Handout (PDF Download)
• SQL Azure Database Credentials and Information
• Video 1: Connecting to an Access Database
• Video 2: Connecting to a SQL Database
• Video 3: Connecting to SQL Server Analysis Services
• Video 4: Credentials and Privacy Settings on Data Sources
• Video 5: Direct Connectivity in Power BI Desktop
• Module 6 Quiz

7. Reshaping Tabular Data

• Module 7 Sample Files (ZIP Download)
• Module 7 Handout (PDF Download)
• Video 1: Grouping and Summarizing Data
• Video 2: Pivoting Stacked Data
• Video 3: Unpivot Subcategorized Data
• Video 4: Pivoting Vertical Pairs
• Video 5: Pivoting Horizontal Pairs
• Module 7 Quiz

8. Managing Queries

• Module 8 Sample Files (ZIP Download)
• Module 8 Handout (PDF Download)
• Video 1: Automating Refresh in Excel
• Video 2: Sharing Queries
• Video 3: Query Organization
• Module 8 Quiz

9. Formulas and Conditional Logic

• Module 9 Sample Files (ZIP Download)
• Module 9 Handout (PDF Download)
• Video 1: Using Power Query Formulas
• Video 2: Conditional Logic Basics
• Video 4: Conditional Logic - Handling Errors
• Video 5: Conditional Logic - Working With Multiple Conditions
• Video 6: Conditional Logic Against the Next or Previous Row
• Video 7: Creating Columns from Examples
• Module 9 Quiz

10. M Deep Dive

• Module 10 Sample Files (ZIP Download)
• Module 10 Handout (PDF Download)
• Video 1: Power Query Values
• Video 3: M Functions - Integrated Samples and Documentation
• Video 4: Current Row Context
• Video 5: Navigation or Drill-Down
• Video 6: Tokens (Identifiers, Keywords, Literals, and Punctuation)
• Video 7: Advanced Row Context
• Module 10 Quiz

11. Parameters and Custom Functions

• Module 11 Sample Files (ZIP Download)
• Module 11 Handout (PDF Download)
• Video 1: Manual Creation of Custom Functions
• Video 2: Debugging Custom Functions
• Video 3: UI Assisted Parameters and Functions
• Video 4: Parameter Tables - Extracting a single value
• Module 11 Quiz

12. Advanced M Techniques

• Module 12 Sample Files (ZIP Download)
• Module 12 Handout (PDF Download)
• Video 1: Dynamically Creating a List of Headers
• Video 2: Advanced Table Append
• Video 3: Pagination and DO/WHILE in M
• Module 12 Quiz

13. Date & Time Techniques

• Module 13 Sample Files (ZIP Download)
• Module 13 Handout (PDF Download)
• Video 1: What is a Calendar Table?
• Video 2: Basic Calendar Tables - From Start Date to End Date
• Video 3: Basic Calendar Tables - From Start Date + x Days
• Video 4: Extending Calendar Table Columns
• Module 13 Quiz

14. Query Optimization

• Module 14 Sample Files (ZIP Download)
• Module 14 Handout (PDF Download)
• Video 1: Optimizing Power Query Settings
• Video 2: Leveraging Buffer Functions
• Video 3: Reducing Development Lag
• Module 14 Quiz

Ссылка на сайт
Скрытое содержимое.

https://academy.powerquery.training/courses/power-query-academy

Стоймость по текущему курсы ЦБ