DESCRIPTION In this video learn how to Transform Two Fact Tables (Header Invoice and Invoice Line Item Tables) with Dimension Tables into a Proper Star Schema using Power Query inside Power BI Desktop. The Power [Read More >>>]
DESCRIPTION In this video learn how to take Invoice Shipping and Discount Amounts from an Invoice Level (Header) Transaction or Fact Table and allocate those amounts to the Invoice Line Item Level Fact Table so we [Read More >>>]
DESCRIPTION In this video learn how to take Invoice Shipping and Discount Amounts from an Invoice Level (Header) Transaction or Fact Table and allocate those amounts to the Invoice Line Item Level Fact Table so we [Read More >>>]
DESCRIPTION In this video learn how to take Invoice Shipping and Discount Amounts from an Invoice Level (Header) Transaction or Fact Table and allocate those amounts to the Invoice Line Item Level Fact Table so [Read More >>>]
DESCRIPTION In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for [Read More >>>]
DESCRIPTION Learn about how to take a rainfall data set with Time-Date Stamps and add rain totals for each day and have the ability to change the definition of the 24 hour period by subtracting [Read More >>>]
DESCRIPTION Topics in this Video: (00:01) Introduction to Power Query and the examples in this video (02:50) Difference between Data Ribbon Tabs in Office 365 Excel 2016 and Non-Office 365 Excel 2016 (04:32) Example #1: [Read More >>>]
DESCRIPTION See how to use Power Query to analyze a group of customers who have been given coupons to three stores. Our goal is to count how many customers used coupons in one of eight [Read More >>>]
DESCRIPTION In this video see how to use an Left Anti Join in Power Query to Extract Items in List 1 that are NOT in List 2. WORKBOOKS
DESCRIPTION See how to use Excel 2016 to take a 900,000 row table and a 1,000,000 roe table and combine them into one in order to make a PivotTable Report. See how to use the [Read More >>>]
EXCEL is a registered trademark of the Microsoft Corporation. MasterExcel is not sponsored by nor affiliated in any way with the Microsoft Corporation.