DESCRIPTION In this video learn about a free download called Power BI Desktop that is a single program that does all that Excel’s Power Query & Power Pivot can do, and more. Comprehensive example of [Read More >>>]
DESCRIPTION In this video learn about: (00:16) Introduction to Entire Project, including what type of start files we have and what the final report looks like. (03:36) What is Data Modelling? Steps to creating a [Read More >>>]
DESCRIPTION In this video learn about how to import multiple Excel files using Power Query (Get & Transform): (00:15) Introduction (01:32) Files used for Import (02:46) Multiple Excel Workbooks with Multiple Sheets (03:50) Get “City” [Read More >>>]
DESCRIPTION In this video learn about: (00:15) Overview: Clean & Transform & Import Multiple Excel Files with 1 Sheet Each & Create PivotTable Report (03:00) Step 1: Import Multiple Excel Files, 1 Sheet Each, including [Read More >>>]
DESCRIPTION See how to perform Case Sensitive Unique Count with Power Query: (00:15) Introduction and examples of Remove Duplicates ans Data Model PivotTable Disnict Count Function will not perform Case Sensitive Unique Count. (01:34) Case [Read More >>>]
DESCRIPTION Using Power Query (or Query in Power BI Desktop) see how to Import Big Data Text File & Append to Bottom of Data Model Fact Table. We use Excel Power Pivot Data Model in [Read More >>>]
DESCRIPTION In this video learn about how to build Excel Dashboard based on Data Model and see first DAX Measure (Formula): (00:22) Introduction (02:43) Power Query to Clean, Transform & Import Text Files (From Folder [Read More >>>]
DESCRIPTION See how to : Import Tables from SQL Server Database into Power Pivot or Power BI Data Model using Power Query. WORKBOOKS
DESCRIPTION Compare and Contract importing a Proper Data Set from either an Excel Sheet or an Excel Table using the Excel Table feature. See that the Excel Table is more robust because it will exclude [Read More >>>]
DESCRIPTION See how to convert non-proper data set (records that are listed in a single column) into two Top 3 Reports (Including Ties for Third) for Domestic Sales and Agriculture Sales. Many Amazing Power Query [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.