PowerPivot: Sort by column

Sometimes there are measures which have an intrinsic order to them, such as days of the week or month of the year. However, this order is not always known by the technology being used to represent data by those values. For example, if I was to create a pivot table plotting some value against month…

17

How to Pitch Webinars

Ever wondered how to position different parts of the Microsoft Business Intelligence stack? We have a range of different tools that can be applied in a range of different situations for a range of different purposes. In this webcast series, I will be describing how to position and sell the various key elements of the…

0

Unleash the Power of PowerPivot

Donald Farmer, the rock star of Microsoft BI, is delivering a series of webinars on the subject of PowerPivot next week. These online workshops are being run in conjunction with Microsoft Gold Partner Panorama. Donald is a great presenter so I would definitely urge anyone interested in this subject to register. If that’s not incentive…

0

BI Bites 24: PowerPivot Management Console

This video continues my series of short business intelligence screencasts. In this demo, I show the Management Dashboard for PowerPivot in Microsoft SharePoint Server 2010. [View:https://www.youtube.com/watch?v=tNy3y5aCFrA] This video is available for download from my SkyDrive.

0

BI Bites 23: PowerPivot Data Connections

This video continues my series of demos showing Microsoft’s Business Intelligence technologies. In this demo, I show how to create a data connection to a SQL table from a PowerPivot file and how to use that data in a pivot chart containing information from other sources. [View:https://www.youtube.com/watch?v=02_pB6Rcq_M] This video is available for download from my SkyDrive.

0

BI Bites 22: PowerPivot Charts

This video continues my series of demos showing Microsoft’s Business Intelligence offerings in bite-sized chunks. This demo shows a PowerPivot application in Excel 2010 and how to build a pivot chart based on data in a range of sources. [View:https://www.youtube.com/watch?v=0Eb-2XfRnx0] This video is available for download from my SkyDrive.

4

BI Bites 21: PowerPivot Gallery

This video continues my BI Bites series, showing bite-sized demos of Microsoft’s Business Intelligence solutions. Here I show the PowerPivot gallery feature of the PowerPivot add-in for SharePoint Server 2010. [View:https://www.youtube.com/watch?v=Q-2wfcBHc9I] This file is available for download from my SkyDrive.

0

BI Bites 20: Introducing PowerPivot

In this video in my BI Bites series, I introduce the new in-memory analytics tool from Microsoft: PowerPivot. I show the Excel add-in and the new tab as well as introducing the range of data sources that can be used in a PowerPivot application. [View:https://www.youtube.com/watch?v=wOecO36nMe8] This file is available for download from my SkyDrive.

0