Project Botticelli

Status message

Video playback issues? See tips for supported browsers. Clearing cookies and cache often helps.

Most Popular

How to Make Enterprise Dashboards in Excel

Carmel Shows a Finished Enterprise Dashboard Made in Excel

Carmel Gunn is a Data Management Specialist from Prodata. Let her show you Excel as an enterprise-grade BI client in this short video, in which she builds a fully fledged enterprise dashboard—in under 30 minutes!—and then shares it with others, even on mobile devices, such as an iPad, iPhone, Android, or a Surface.

Presentations (PPTs)

Over 50 of the popular PPTs (not PDFs) on: Artificial Intelligence, Azure ML, Azure AI (incl Cognitive Services and Bots), Data Science, Power BI, Microsoft R and ML Servers, R in general, and advanced analytics. Includes Microsoft Ignite, Data Science Summit and the Advanced Analytics and Data Science Roadshows, as well as various keynotes and roadshows focused on the future of data and databases from global conferences from this and the past years are available here.

Power View and BISM: A Short Introduction

Power View Scatter Plot (Animated Bubble Chart)

Power View, part of SQL Server 2012 Reporting Services, and the BI Semantic Model (BISM) are briefly introduced in this 10-minute video. The demo shows how to create the animated bubble chart (scatter plot) from your data.

Microsoft SQL Server 2012 Business Intelligence (Article)

SQL Server 2012 Logo

This article, by Rafal, discusses pivotal BI aspects of Microsoft SQL Server 2012: BI Semantic Model (BISM), PowerPivot 2, Data Analysis Expressions (DAX), the future of OLAP Cubes and MDX (Multidimensional Expressions), and, briefly, it touches on the role of the Cloud for analytics.

Geospatial Data Exploration with Excel Power View and SharePoint

Bing Map Showing Data from Excel Using Power View

Create zoomable world maps that show your data using Power View in Excel 2013, and Bing! Rafal also shows geospatial aggregations, and a SharePoint dashboard with an animated bubble chart, in this free, 16-minute video.

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.

Introduction to SQL Server 2012 Business Intelligence (Video)

Big Data

In this first, 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, briefly, 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. If you would like to deepen your skills, make sure you also watch the remaining modules in this series, which focus on: the new release of PowerPivot for SQL Server 2012, Power View, and the BI Semantic Model and Analysis Services Tabular Mode.

Books about BI

This article lists books about BI, Statistics, Data Warehousing and Management, which we recommend in conjunction with our courses and seminars.

Introduction to BI Semantic Model & SQL Server 2012 Analysis Services

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

Microsoft Business Analytics with Office 2013, SharePoint 2013 and SQL Server 2012

Microsoft Business Analytics with Office 2013, SharePoint Server 2013, and SQL Server 2012

Microsoft Business Analytics combines Business Intelligence with Data Warehousing and Big Data Analytics. This 1-hour 20-minute video by Rafal Lukawiecki introduces this concept by showing you how real-world analytics, created by a power user in Excel 2013, can be shared with others in a company, using SharePoint Server 2013, and subsequently scaled-up to the needs of an enterprise, by means of a SQL Server 2012 SP1 Analysis Services Tabular Model. Rafal covers the entire subject broadly, showing you some of the new Excel and SharePoint 2013 BI features, such as: the new Power View, Interactive Geospatial Maps, Data Models, Quick Explore, Timelines, and many more, in an extensive, 9-part, 55-minute, high-def demo, focusing on the enterprise lifecycle of user-created analytics, which forms the core of this video tutorial.

Introduction to Power View in SQL Server 2012 Reporting Services

Introduction to SQL Server 2012 Reporting Services Power View

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. You will hear explanations of the fundamental concepts of Power View, such as Measures, and you will see all of its key features, including data visualizations, such as the animated Bubble Charts, in 17 hi-def easy-to-follow demos. You will hear how to source data for Power View, and how to share your reports by exporting them to PowerPoint, as a presentation, with slides that literally come alive in front of your audience!

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.

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.

Irish Economic Crisis Visualised in Power BI

Where Did Ireland Get The Money From?

Carmel Gunn and Bob Duffy explore the Irish Economic Crisis using Power Query, Power Map, Power View and Q&A in this 40-min video. Could Power BI prevent a small country run a shocking €200bn debt?

Online Courses