Browse by Tags

This demo starts a new series of videos showing some of the capabilities of Microsoft's BI stack in bite sized chunks. This video shows how easy it is to add a simple chart to a table by using the new Sparkline feature of Excel 2010.

SharePoint is part of the Microsoft product stack. This doesn’t mean that it’s just another item on a Microsoft price list. What it means is that it’s designed to work with the other products Microsoft produces. In other posts, I’ve talked about using InfoPath and SharePoint together, but that’s not...

What is metadata? The simple definition is that it’s data about data. In the case of SharePoint, it’s information about files and documents stored within SharePoint. There are some bits of metadata that are included as standard, such as who created a document, who last edited it, where in SharePoint...

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 from my SkyDrive .

Previously in this series, I’ve talked about general Office documents, which might be Word files, PowerPoint slide decks and so on. In this post, I’m going to go a bit more specific. I’m going to talk about data connection libraries and how they are they can accessed using Excel 2007.
A data connection...

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 version of Excel.
This video is available...

Given that I spent a ridiculously long time trying to get an InfoPath form to interact with a spreadsheet published through Excel Services, I thought this was a suitable subject for a blog post. If I stop someone else feeling like they want to beat themselves to death with their own keyboard, I will...

It’s time to have a play.
The public beta has launched and now you can get hold of Office 2010 and SharePoint 2010. You can download it from www.microsoft.com/2010 and try out some of the new features such as:
· Conversation threading in Outlook
· Improved rules management in InfoPath
· The...

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 demos showing the Microsoft BI offering in bite sized chunks. In this video, I show how to publish items in an Excel workbook to Excel Services in Microsoft SharePoint Server 2010.

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

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

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

If you're a UK higher education student or staff member, you can get Microsoft Office Ultimate 2007 for the ridiculously cheap price of £38.95 - if you buy before 30th June 2009.
Just go to The Ultimate Steal , register with your academic email address and buy online.

A version of Office Web Apps is now available to SkyDrive users for free!
If you log into your SkyDrive, you’ll now see a little section informing you that you can create new Office documents with the familiar client logos.
Clicking on one of these takes you to a new page to name your...

This video continues my series of demos showing Microsoft BI features in bite sized chunks. This demo shows one of the improvements to conditional formating in Microsoft Excel 2010: negative data bars.

Continuing this series of blog posts, I’m going to talk about document workspaces. The idea behind these is that sometimes a document needs multiple people working together on it. A document workspace is a site in SharePoint that can be used for collaboration. The standard template for this site includes...