Excel Video 475 Loading Data into the Excel Data Model from create sql table query Watch Video
Preview(s):
Gallery
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)
Description: Loading data into the Excel Data Model is the first step to taking advantage of the power of this new tool, and that’s the subject of Excel Video 475.Excel has a new tool called Power Query that can load data into the Excel Data Model and transform the data to meet requirements you may have.We’ll discuss Power Query in future Excel Videos.Today I’ll introduce three of the most common ways to get data into the Excel Data Model through PowerPivot that should at least get you started.nn
Play Video: (Note: The default playback of the video is HD VERSION. If your browser is buffering the video slowly, please play the REGULAR MP4 VERSION or Open The Video below for better experience. Thank you!)