BI Bites 26: Introducing SQL Server Integration Services

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. [View:https://www.youtube.com/watch?v=jaaWqi6QQfo] This video is available for download from my SkyDrive.

1

BI Bites 25: Excel Web App

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. [View:https://www.youtube.com/watch?v=GJ9NaMsAfWM] This video is available for download from my…

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

BI Bites 19: Gauges

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. [View:https://www.youtube.com/watch?v=0IXWEVJMhvw] This video is available for download from my SkyDrive.

0

BI Bites 17: SQL Server Report Builder 3.0

This demo introduces another tool in the Microsoft BI stack: SQL Server Report Builder 3,0. Report Builder can be used to create rich reports. In this video, I show building a table using the inbuilt wizard to report on data from SQL Server. [View:https://www.youtube.com/watch?v=8mTBteyQrus] This video file is available for download from my SkyDrive.

0

BI Bites 16: Visio Services

This video continues my series of bite-sized BI demos. This follows on from the previous BI Bites video, where I showed how to connect a Visio 2010 diagram to data in Excel. In this video, I show how to publish a Visio diagram to SharePoint 2010 using the new Visio Services feature so display the…

0