You searched "Excel"
       10 videos of 308 results
video –

Microsoft PowerPivot Excel 2013 in Action

Microsoft Excel 2013 and Business Intelligence: a marriage made in heaven. PowerPivot and Power View, the two most exciting BI tools in the Microsoft stack are now integrated into Excel 2013, providing the perfect environment to build self-service BI solutions.…  Watch now

video –

Microsoft PowerPivot Excel 2013 in Action

Microsoft Excel 2013 and Business Intelligence: a marriage made in heaven. PowerPivot and Power View, the two most exciting BI tools in the Microsoft stack are now integrated into Excel 2013, providing the perfect environment to build self-service BI solutions.…  Watch now

video –

How to Calculate with Hierarchies in DAX?

Marco Russo discusses ratio-to-parent measures, which use DAX hierarchies, in this short video. You will see how to create such a calculation and how to use it in a Pivot Table (00:30). DAX does not have an internal mechanism for…  Watch now

video –

What is Time Intelligence?

ime Intelligence simply means doing BI calculations over periods of time, or over dates. For example, a common request in many reports is to show a value, such as Sales, aggregated month-by-month, from the beginning of each year—so that you…  Watch now

video –

DAX Time Intelligence

Alberto begins this video with a brief introduction to Time Intelligence, before showing you how to create a calendar table, which is needed for any time intelligence function to work. It can be created using Excel, or by loading it…  Watch now

video –

Create a Data Model in BISM Tabular

The new BISM Tabular model in Analysis Services offers a new way to create a data model for your Business Intelligence solution. This data model has a learning curve that is better than BISM ultidimensional (formerly known as UDM) and…  Watch now

video –

DAX Patterns in PowerPivot

DAX (Data Analysis Expressions) is the language for the definition of calculation expressions in PowerPivot for Microsoft Excel. It has syntax similar to Excel, but it also offers a set of functions that are specific to PowerPivot features. This session…  Watch now