Latest Videos

Introduction to Power View in SQL Server 2012 Reporting Services (requires full access membership)

Introduction to SQL Server 2012 Reporting Services Power View

This 75-minute video, the third module of this course, introduces the newest addition to the Microsoft Business Intelligence platform: Power View, which is part of SQL Server 2012 Reporting Services, which runs on SharePoint Server 2010. You will hear explanations of the fundamental concepts of Power View, such as Measures, and you will see all of its key features, including visualizations, in 17 hi-def demos. As with all our video content, make good use of the very responsive Jump to a chapter links, allowing you to follow this video tutorial your way.

18 April 2012
958 views

Introduction to BI Semantic Model & SQL Server 2012 Analysis Services (requires full access membership)

Using SQL Server Data Tools to Create a New Tabular Project

The fourth module of this course focuses on the new BI Semantic Model (BISM), and its implementation as a tabular model hosted by SQL Server 2012 Analysis Services (SSAS) Tabular Mode. This 1 hour 20 minutes video includes discussions, slides, and diagrams, and an in-depth, 35 minute demo block, showing you the key BISM and SSAS Tabular Mode principles in 13 detailed, hi-resolution demonstrations, which you can select, follow, pause and repeat at any time, by using Jump to a chapter links, shown on the right.

27 March 2012
1213 views

Introduction to PowerPivot for SQL Server 2012 (requires full access membership)

The second module in this online training course, oﬀers a 1 hour introduction to PowerPivot for SQL Server 2012, sometimes referred to as PowerPivot “2”. This module is of importance to those who need to model tabular data for analytics, or who simply want to explore a data set, before making a decision if it is worthwhile analysing it further. Also, if you plan on learning about BI Semantic Model, you need to know about PowerPivot “2”, as Tabular Mode of SSAS, and BI Semantic Model, make extensive use of the new PowerPivot features, extending them to enterprise needs. This module is presented as a series of slides, graphics, discussions, and 15 demos, recorded in high-resolution, so that you can follow the steps yourself.

12 March 2012
1358 views

Introduction to SQL Server 2012 Business Intelligence (Video) (requires full access membership)

In this ﬁrst, 45-minute module of our training course introducing Microsoft Business Intelligence technologies, we focus on Microsoft SQL Server 2012. The main objective of this video is to introduce the big picture of Microsoft’s data platform engine, released in 2012. This module discusses its 10 key BI innovations: BI Semantic Model (BISM), Analysis Services Tabular Mode, PowerPivot for SQL Server 2012, Power View, Self-Service Data Alerts, Big Data and Apache Hadoop integration, Columnstore Indexes (xVelocity for Data Warehousing), Spatial Data, Unstructured Data, and, brieﬂy, Data Quality Services. Through a number of slides, graphics, and a short demo showing Power View in PowerPoint, you will learn how to take advantage of the newest abilities of SQL Server in your own BI projects.

12 March 2012
1815 views

Power View and BISM: A Short Introduction

Power View Scatter Plot (Animated Bubble Chart)

This is a short 10-minute introduction to Power View and BISM. If you are looking for an in-depth video tutorial on Power View, have a look at the 75-minute video Introduction to Power View, which is part of our full-length SQL Server 2012 BI online course. Similarly, the full-length, 80-minute Introduction to BI Semantic Model can be found here.

11 January 2012
3492 views

Spatial Reporting with Microsoft SQL Server and SharePoint Server

Spatial Reporting with SQL Server Report Builder and SharePoint Server

Spatial reports can be created using Report Builder, which comes with SQL Server. They execute in SQL Server Reporting Services (SSRS) and they can be hosted in SharePoint Server. This video shows the steps you need to take to create a simple bubble report that displays customer numbers, taken from a cube, on a map of the United States. You will also see how to share that report with co-workers using SharePoint.

29 December 2011
890 views

Multidimensional Analysis with Microsoft Excel and SQL Server

For most people, the easiest tool for opening and navigating a multidimensional (OLAP) cube is Microsoft Excel. In this short demo you can also see how to perform basic slice-and-dice analysis, drill into and ﬁlter using dimensions, and summarise trends with a sparkline.

28 December 2011
713 views

Data Warehousing and Integration with Microsoft SQL Server

Data Warehousing and Data Integration with Microsoft SQL Server

This video outlines basic concepts of Data Warehousing and Data Integration using Microsoft SQL Server, focussing on its Integration Services (SSIS) component.

27 December 2011
671 views

Dashboards and Scorecards with Microsoft SQL Server and SharePoint Server

Dashboards and Scorecards Using Microsoft SharePoint Server and SQL Server

From an attractive, composite dashboard consisting of performance management scorecards, and reports, to the highly visual PivotViewer, this video introduces the world of dashboards running on Microsoft BI platform, focussing on SharePoint Server PerformancePoint Services and SQL Server.

21 October 2011
2177 views

Self-Service Data Mash-ups with Microsoft PowerPivot and SharePoint Server

Creating a Relationship Using Microsoft PowerPivot

This video shows data being mashed-up from multiple sources using Microsoft PowerPivot and DAX, all by the end user, in a self-service way.

18 September 2011
976 views