Excel Business Intelligence Part 3: Power Pivot and DAX | Chris Dutton | LYNDA

Excel Business Intelligence Part 3: Power Pivot and DAX | Chris Dutton | LYNDA
English | Size: 763.99 MB
Category: Tutorial

Data Analysis Expressions (DAX) allow Microsoft Excel users to create powerful calculated fields in Power Pivot. In this course-the third and final installment of the Excel Business Intelligence series-experienced Excel trainer Chris Dutton spells out how to use the DAX language and Power Pivot to explore and analyze relational data models. Chris picks up where he left off in the previous installment of the series, demonstrating how to add calculated columns and measures to data models in Excel. He highlights the differences between calculated columns and DAX measures, covers common DAX formulas and functions, and discusses best practices for working with DAX and Power Pivot.
[Read more…]

Up and Running with Power Pivot and SharePoint 2013

Up and Running with Power Pivot and SharePoint 2013
English | Size: 115.24 MB
Category: Video Training


Learn how to combine the power of Excel’s Power Pivot and Power View tools with SharePoint 2013, to view, analyze, and manipulate large amounts of data. Neicole Crepeau guides you through the process of creating workbooks and dashboards to help your organization use big data to answer big questions. She shows how to connect to data sets and how to create relationships between them, plus how to use Power View to visualize the information. Then, moving on to SharePoint, Neicole explains how to create a Business Intelligence Center site and dashboards from your Excel workbooks.
[Read more…]

Lynda – Up and Running with Power Pivot and SharePoint 2013

Lynda - Up and Running with Power Pivot and SharePoint 2013

Title: Lynda – Up and Running with Power Pivot and SharePoint 2013
Video Format: MP4
File Size: 116 MB
[Read more…]