Full Advanced Data Analysis and BI Class - Power Query, Power Pivot, DAX, M Code, Power BI and Excel

Full Advanced Data Analysis and BI Class - Power Query, Power Pivot, DAX, M Code, Power BI and Excel

ExcelIsFun via YouTube Direct link

Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)

79 of 83
Previous
Next

79 of 83

Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Full Advanced Data Analysis and BI Class - Power Query, Power Pivot, DAX, M Code, Power BI and Excel

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Free Advanced Data Analysis & BI Course at YouTube (MSPTDA)
  2. 2 Microsoft Power Tools for Data Analysis: Dashboards & Reports. Class Introduction Video. MSPTDA #01.
  3. 3 MSPTDA #02: Data Analysis Business Intelligence Terms: Microsoft Power Tools for Data Analysis Class
  4. 4 MSPTDA 03: Power Query Introduction: Importing & Transformation Data in Excel & Power BI Desktop
  5. 5 MSPTDA 04: Power Query: Import Multiple Excel Files & Combine (Append) into Proper Data Set
  6. 6 Excel Power Query DataSource.NotFound: File or Folder: We couldn't find the folder. Solved! EMT 1662
  7. 7 MSPTDA 05: Power Query: Excel.CurrentWorkbook Function to Append All Excel Tables in Excel Workbook
  8. 8 MSPTDA 06: Power Query: Merge, Append, & UnPivot – 3 Important Transformations
  9. 9 MSPTDA 07: Power Query: 6 Types of Joins, 6 Types of Merges: 9 Examples
  10. 10 MSPTDA 08: Power Query Group By feature & Table.Group Function (5 Examples)
  11. 11 MSPTDA 08.5: Power Query Group By Unique List or Consecutive Occurrences
  12. 12 MSPTDA 09 Power Query Complete M Code Introduction: Values, let, Lookup, Functions, Parameters, More
  13. 13 Formula.Firewall Error in Power Query & Power BI: Rebuild This Data Combination Solved (MSPTDA 9.5)
  14. 14 MSPTDA 10: Power BI M Code for Moving Annual Total (MAT): Custom Function Power Query Custom Column
  15. 15 Power Query Get Previous Row? Stock Price Change Formula. M Code Lookup. Excel Magic Trick 1546
  16. 16 Two-Way Lookup in Power Query? M Code for Exact & Approximate Match Lookup. Excel Magic Trick 1554
  17. 17 MSPTDA 11: Power Query to Import from SQL Server Database in Excel or Power BI Desktop
  18. 18 MSPTDA 11.5 Which Power Query Steps Are Used in SQL Query Folding? “View Native Query” feature!
  19. 19 MSPTDA 12: Using Locale in Power Query Power BI: Import & Append Text Files from Different Countries
  20. 20 MSPTDA 13: Power Pivot Introduction #1: Relationships rather than VLOOKUP for PivotTable Report
  21. 21 MSPTDA 14: Power Pivot Intro #2: Amazing Columnar Database Importing Millions of Rows Data to Excel
  22. 22 MSPTDA 15: Comprehensive Introduction to Excel Power Pivot, DAX Formulas and DAX Functions
  23. 23 MSPTDA 16: Power BI Desktop Comprehensive Introduction: Power Query, DAX, Dashboards, Publishing
  24. 24 MSPTDA 17: Power BI Online: Dashboards, Reports, Excel Workbooks, Data Sets.
  25. 25 MSPTDA 18: DAX Iterators, Table Functions, Grain, Cardinality, Materializing Tables Excel & Power BI
  26. 26 MSPTDA 19: CALCULATE DAX Function & Filter Context & ALLSELECTED & KEEPFILTERS (50 Examples)
  27. 27 MSPTDA 31: DAX Studio to Time DAX Average Formulas: AVERAGEX or DISTICTCOUNT?
  28. 28 MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Query
  29. 29 MSPTDA 21: Power Query: Reduce Data Model Size, Transformations to Columnar Database Size
  30. 30 MSPTDA 22: DAX Data Modeling to Create Date & Time Dimension Tables, Server Downtime Visualizations
  31. 31 EMT 1493: Excel Formulas PivotTable: Allocate Invoice Header Amounts To Transaction Line Table
  32. 32 EMT 1493 Part 2: Excel Array Formulas Allocate Invoice Header Amounts To Transaction Line Table
  33. 33 MSPTDA 23: Two Fact Tables? DAX, Power Query or Worksheet Formulas to Convert to 1 Fact Table
  34. 34 MSPTDA 24: DAX Multiply / Divide Data Types Discrepancies Solved!
  35. 35 Power Query & DAX Formulas for Advanced Data Modeling to Sort Slicer by PivotTable Values. EMT1678.
  36. 36 MSPTDA 25: Budget vs Actual, Excel Formula Solution with SUMIFS & EOMONTH
  37. 37 MSPTDA 26: Budget vs Actual in Power Pivot & Power BI Desktop, DAX & Data Model
  38. 38 Excel Magic Trick 1405: Monthly Totals Report: Sales from Daily Records, Costs from Monthly Records
  39. 39 Excel Magic Trick 1407: Data Model & DAX Measures for Monthly Totals Report From Two Fact Tables
  40. 40 MSPTDA 27: SUMPRODUCT & SUMIFS Worksheet Array Formula to Add Units in Many To Many Relationships
  41. 41 MSPTDA 28: Build Power Query Bridge Table in Power BI & Power Pivot for Many To Many Relationship
  42. 42 MSPTDA 29: Order & Ship Date in Fact Table? Side-By-Side & Cross Tab Reports with Worksheet Formulas
  43. 43 MSPTDA 30: Order & Ship Dates in Fact Table: DAX Formulas and Data Modeling to Create Reports
  44. 44 MSPTDA 32: Slowly Changing Dimensions Team-Employee Report with Worksheet Formulas
  45. 45 MSPTDA 33: Data Modeling for Slowly Changing Dimensions with Power Query & PivotTable
  46. 46 MSPTDA 33 Part 2: Power Query & Standard PivotTable To Show All Employees Sales Or Not
  47. 47 MSPTDA 34: Data Modeling for Slowly Changing Dimensions with Power Query & Power Pivot
  48. 48 MSPTDA 35: Power BI & DAX Formula for Data Modeling with a Slowly Changing Dimensions
  49. 49 Excel Magic Trick 1393 PivotTable Show Values As: % Column Total, % Parent Total, % Parent Row Total
  50. 50 Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total
  51. 51 Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item
  52. 52 Excel Magic Trick 1395: DAX Measures for Show Values As % of Grand Total, Column Total, Parent Total
  53. 53 Excel Magic Trick 1449: DAX Measure % Change MOM & YOY Formulas For Incomplete Years
  54. 54 Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)
  55. 55 Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
  56. 56 Excel Magic Trick 1397 Part 2: Formulas: Monthly Revenue, Running Total & % Running Total & Chart
  57. 57 Excel Magic Trick 1397 Part 3: % Cumulative Frequency Formula & X Y Chart for Irregular Increments
  58. 58 Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks
  59. 59 Running Total in Column, Power Query, DAX or Worksheet Formula? Excel Magic Trick 1553
  60. 60 Excel Magic Trick 1417 Excel Functions Ranking Unit & Total Profit for Products within Manufacturer
  61. 61 Excel Magic Trick 1418: PivotTables Ranking For Unit & Total Profit for Products within Manufacturer
  62. 62 Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer
  63. 63 Excel Magic Trick 1420: Ranking in Power Query: Sort, Grouping, Indexes and Custom Columns
  64. 64 Excel Magic Trick 1429: Power Query Ranking with Index, Grouping and MIN Function!!!
  65. 65 Excel Magic Trick 1378: Average of Customer Total Sales by Product: Formulas, DAX or Array Formula?
  66. 66 Excel Magic Trick 1406: Calculate Moving Average with AVEARGEIFS & EOMONTH Functions
  67. 67 Excel Magic Trick 1408: DAX Measure: Moving 12 Month Average on Daily Sales (DAX Formatter too)
  68. 68 Excel Magic Trick 1424: Average, Moving Average at Different Granularity: DAX or Excel Formulas?
  69. 69 Average Last 3 Customer Sales: Power Query, DAX Measure or Worksheet Formula: Excel Magic Trick 1552
  70. 70 Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc
  71. 71 Excel Magic Trick 1404: Sales Per Working Day by Month Formulas For Three Year Dynamic Report
  72. 72 Excel Magic Trick 1443: DAX Formula for Sales Per Working Day: Power Pivot or Power BI Desktop
  73. 73 Excel Magic Trick 1430: DAX Functions XNPV & XIRR for Irregular Cash Flow Net Present Value & IRR
  74. 74 Excel Magic Trick 1432: 9 DAX Formulas to Build Confidence Intervals CONFIDENCE.T, STDEV.S…
  75. 75 Excel Magic Trick 1434: SAMPLE DAX Function to Take Random Stratified Sample from Data Set.
  76. 76 Excel Magic Trick 1437: DAX Query OR Logical Test IN Operator: Pull Sales Team Data to Excel Sheet
  77. 77 Excel Magic Trick 1439: DAX Measures to Create Cross Tabulated OR & AND Logical Test Sales Total
  78. 78 Excel Magic Trick 1440: OR Logical Test on 2 Columns using DAX IN Operator & DAX OR Function
  79. 79 Bring Tables from Different Excel Sheets into Single Table for PivotTable Report (EMT1622)
  80. 80 Combine Excel Worksheet Data (Not Excel Tables) Into PivotTable using Power Query (EMT 1626)
  81. 81 Power Query M Code Custom Function to Convert 12 Cross Tabulated Data Sheets to PivotTable. EMT 1621
  82. 82 MSPTDA 36: How To Build Sample File Parameter For A Custom Function to Transform 12 Cross Tab Tables
  83. 83 Excel Power Query Remove Blank Rows & Columns in All Excel Files During Import. EMT 1660.

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.