Posts - mwilmot


Power BI: Using Power Query and Power View[MP4] [0:16:54] [2014/01/17]
Solving complex data problems on gapminder.org / Hans Rosling with Power Query and Power View.


Geospatial Reporting with Microsoft Reporting Services[MP4] [0:42:27] [2014/01/09]
How to use SQL Server Reporting Services to create geospatial representations of your data. Based on work by David Gollob at youtube GOVMSE site here: http://www.youtube.com/user/10MinCollege …


Visualizing Information with Excel 2013 and Power Map - Nuclear Testing[MP4] [0:06:04] [2013/12/10]
Using Microsoft BI to visualize nuclear tests - Lara Rubbelke and Mike Wilmot. Based on Japanese artist Isao Hashimoto's amazing youtube video: http://www.youtube.com/watch?v=9U8CZAKSsNA and this…


Self-service BI with Power BI - nuclear testing[MP4] [0:25:40] [2013/12/07]
Using Microsoft Power BI to create nuclear test visualizations - Lara Rubbelke and Mike Wilmot. Based on Japanese artist Isao Hashimoto's amazing youtube video:…


Power BI:PowerQuery for European Airports[MP4] [0:04:01] [2013/10/25]
Using Power Query (part of Power BI) to query European Airport data sets.


Power BI: Tracking Hurricane Sandy[MP4] [0:23:21] [2013/10/25]
Using Power Map (part of Power BI) to track Hurricane Sandy by Lara Rubbelke.


Power BI: Understanding World Health data with Power Query and Power View[MP4] [0:17:10] [2013/10/25]
Understanding a Hans Rosling data set for world fertility and mortality rates using global data from Hans Rosling (gapminder.org).


Power BI: Understanding Napoleon's March with Power Map[MP4] [0:06:14] [2013/10/25]
Making sense of Napoleon's march into Moscow using Power Map. Originally done by Edward Tufte from data by Charles Minard.


Microsoft Power BI[MP4] [0:50:19] [2013/10/05]
Power BI includes new technologies in Excel that include Power Query, Power Map, Power View and Power Pivot. The files for this presentation are here: http://sdrv.ms/1a2xTDj (Hurricane Sandy,…


Master Data Managment[MP4] [0:16:12] [2013/10/01]
Master Data Management in SQL Server 2012 and Excel. Here are the supporting Power Point, SSIS and spreadsheets: http://sdrv.ms/19W6Dqb Mike Wilmot John McAllister (Profisee)


SQL Server In-Memory OLTP (was Hekaton)[MP4] [0:24:02] [2013/06/27]
SQL Server In Memory OLTP (formerly known as Hekaton) takes advantage of steadily declining memory price, stalling cpu clock rates, many core processors and lowering TCO. It uses memory optimized data…


SQL 2012 AlwaysOn Availability Groups[MP4] [0:20:25] [2013/04/03]
What are SQL Server 2012 AlwaysOn Availability Groups and how can they help you with a HA/DR Strategy.


SQLShorts: Big Data and Twitter[MP4] [0:33:23] [2012/12/18]
StreamInsight is a SQL Server Complex Event Processing Engine (.NET) that can be leveraged for manufacturing or financial applications. It can manage and mine data for different trend, conditions…


SharePoint 2013 BI[MP4] [0:14:19] [2012/09/25]
How to create modern BI solutions using Microsoft SharePoint 2013, PowerPivot and Power View in Excel 2013.


StreamInsight [MP4] [0:26:10] [2012/06/09]
Microsoft StreamInsight™ is a powerful platform that you can use to develop and deploy complex event processing (CEP) applications. Its high-throughput stream processing architecture and the Microsoft…


SQLShorts: SQL 2012 Power View on SharePoint 2010[MP4] [0:10:39] [2012/01/17]
Overview of the Power View feature of SharePoint 2010 SP1. Here is a brief description from : http://social.technet.microsoft.com/wiki/contents/articles/3726.power-view-overview.aspx Power View, a…


SQLShorts: Installing and Configuring PowerPivot, Power View, and the BI Semantic Model in Azure (…[MP4] [0:24:12] [2012/01/15]
This video by Matt Smith (@smithmattc) covers the main issues that you face in installing PowerPivot and Power View on SharePoint 2010 SP1. There are many nuances to address such as software needed…


SQLShorts : AlwaysOn Availability Group Configuration for SQL 2012[MP4] [0:15:10] [2011/12/14]
Today's SQLShort is on how to configure SQL 2012 Availability Groups and some gotchas. An availability group supports a failover environment for a discrete set of user databases, known as availability…


SQLShorts: SQL 2012 Apollo Column Store[MP4] [0:04:06] [2011/12/11]
The SQL Server columnstore index feature, code-named Apollo, stores data by columns instead of by rows, similar to a column-oriented DBMS. The columnstore index speeds up data warehouse query…


SQLShorts: PowerPivot and Power View Lifecycle and BI Semantic Model (BISM) Overview[MP4] [0:11:00] [2011/12/11]
This video is a demo of a full lifecycle of the BI Semantic Model (BISM) starting with PowerPivot and ending with Power View in SQL Server 2012.


SQLShorts : AlwaysOn Availability Groups for SQL 2012[MP4] [0:04:46] [2011/12/10]
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary…