You searched "powerpivot"
       11 videos of 288 results
video –

Budgeting with PowerPivot

Power BI offers new features for creating dashboards on the cloud. In this session, you will learn how to create data models, display visualizations and synchronize cloud data with on premise data sources. In order to use these new features,…  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 –

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 –

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

video –

PowerPivot Advanced Data Modeling

During this session we are going to analyze common business problems that require and advanced usage of DAX functions and data modeling. Examples include banding of price in ranges, advanced simulation with the usage of many-to-many relationships, usage of dynamic…  Watch now

video –

Modern Data Warehousing Strategy

The recent introduction of new technologies like PowerPivot, BI Semantic Model, columnstore indexes in SQL Server and the more general trend of advances in Self-Service BI and Big Data might be considered threats to the classic data warehouse ecosystem. In…  Watch now

video –

Querying with DAX

The Data Analysis Expressions (DAX) language is commonly used to define measures and calculated columns in PowerPivot and in tabular models. However, you can also write queries in DAX, and in this 46-minute video Marco Russo explains what tools and…  Watch now

video –

DAX in Action!

See the power of Data Analysis Expression (DAX) language in PowerPivot, and in SQL Server Data Tools (SSDT), in this free, 20-minute video.  Watch now