Excel Is Fun

Excel Magic Trick 1386

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 >>>]

Excel Is Fun

Excel Magic Trick 1385

DESCRIPTION See how to : Import Tables from SQL Server Database into Power Pivot or Power BI Data Model using Power Query. WORKBOOKS

Excel Is Fun

Highline Excel 2016 Class 01

DESCRIPTION In this video learn about these Excel Fundamentals for Excel Highline Excel 2016 Class: (00:33) Prerequisites for class (01:04) Excel Professional 2016 (01:50) Install Com Add-in Power Pivot (02:54) Examples of Effective and Efficient [Read More >>>]

Excel Is Fun

Excel Magic Trick 1367

DESCRIPTION How to make Calendar Table in Power BI Desktop? See how to create three types of Calendar Tables in Power BI Desktop using the CALENDAR Function and various other functions: (00:02) Files to Download [Read More >>>]

Excel Is Fun

Excel Magic Trick 1366

DESCRIPTION Full Lesson on Power BI Desktop to build Product Analysis for Gross Profit with Average, Standard Deviation, Coefficient of Variation and Histogram Calculations and Visualizations: (00:04) Files to download (00:12) Introduction (04:42) Import Related [Read More >>>]

Excel Is Fun

Excel Magic Trick 1365

DESCRIPTION See how to import an Excel Power Pivot Data Model with tables, relationships and DAX Measures into Power BI Desktop using the File (Upper Left icon), Import, Excel Workbook option in Power BI Desktop. [Read More >>>]

Excel Is Fun

Excel Magic Trick 1364

DESCRIPTION See how to: 1. Open Power BI Desktop 2. Import Excel File with image URL web addresses 3. Select Column with URL, and in Modeling Ribbon Tab, in the Properties group, Data Category drop-down, [Read More >>>]

Excel Is Fun

Excel Magic Trick 1360

DESCRIPTION See how to use Power BI Desktop to import, clean and transform Sales Tables from Multiple Excel Files and consolidate into a Single Proper Data Set that can be linked in a Relationship to [Read More >>>]