July, 2010

This video continues my series of short Microsoft Business Intelligence demos. Here I introduce SQL Server Integration Services, SSIS, in Microsoft SQL Server 2008 R2. I show how to perform a simple data import from a flat file to a SQL database. ...

This video continues my series of Business Intelligence bite-sized demos. In this demo, I show how to create a gauge in SQL Server Report Builder 3.0. This video is available for download from my SkyDrive .

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. ...

Salmon, a UK SharePoint Gold Partner have produced a case study of the solution they built for Endsleigh Insurance. This is a powerful web portal delivering a customised view to their customers and allowing Endsleigh to work with partner organisations...

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. This file is available for download...

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. This video...

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...

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. This video is available for download from my SkyDrive .

This video continues my series of Microsoft Business Intelligence demos. In this demo, I show the Excel Web App, the browser-based version of Excel available through SharePoint and Windows Live. I show some of what you can and can't do in this cloud-based...