Newest Videos

Creating Document Libraries In Power BI

526 Views0 Comments

Creating a SQL Server Data Warehouse Environment in the Cloud

4,381 Views0 Comments

Hardware environments for a high-performance data warehouse can be challenging and expensive to build. Coupling the Microsoft Fast Track Reference Architecture with Windows Azure gives you the ability to kick the tire...

Using Power Query to import Hadoop HDFS files

13,722 Views0 Comments

While we may often use SQL queries and Hive to import Hadoop data into Excel and Power Pivot data models, sometimes we may need to directly access data files store in the underlying Hadoop Distributed File System (HDF...

Apache Hive on HDInsight for Windows Azure

1,250 Views0 Comments

The most common way to connect traditional Business Intelligence tools to data stored in Hadoop is using Apache Hive.  What is Hive?  In short, in Hadoop 1.0, Hive is a middleware layer that lets us write queries in S...

ETL on Hadoop: Using Pig for log file Analysis on HDInsight Azure

4,462 Views0 Comments

One of the reasons to use Hadoop as part of your data warehouse strategy is to take advantage of its ability to process data in a distributed way--massively parallel processing, or MPP.  Another is to leverage its "sc...

Creating a Power Map Tour

4,503 Views3 Comments

In the previous lesson we learned how to create stunning geospatial visualizations with Microsoft's Bing Maps powered Excel add-in, Power Map. Power Map is a key visualization tool included with Microsoft's self-servi...

Introduction to Power Map

3,043 Views0 Comments

In this lesson we'll learn how to use Power Map, Microsoft's new Excel add-in used to create 3D geospatial visualizations. During the product development cycle, Power Map was known by the name "GeoFlow".  Its new name...

Connecting Tableau to SQL Server Analysis Services

3,569 Views0 Comments

In this lesson we take a look at connecting Tableau to SQL Server Analysis Services cubes.  Tableau is a popular 3rd-party data visualization front-end tool that can connect to many data sources. In this video we'l...

Submitting C# MapReduce jobs on Windows Azure HDInsight

1,821 Views0 Comments

In this lesson we'll take the skills we've learned developing Hadoop MapReduce jobs using C# and Visual Studio, and apply them to the cloud. To run jobs on the Azure HDInsight, first you need to provision a cloud H...

Analyze Twitter data with HDInsight using C# MapReduce

1,441 Views4 Comments

This video shows how to use the MapReduce .NET API to develop a C# MapReduce job that analyzes Twitter data stored in JSON format. Twitter data contains a mixture of structured and unstructured data.  Much of the i...

Intro to Hadoop MapReduce with C#

2,545 Views2 Comments

This lesson shows how to develop a very basic MapReduce job in C# for processing by HDInsight for Windows.  Later videos will focus on specific patterns for MapReduce processing. In Hadoop, MapReduce jobs run in Ja...

Most Viewed

Configuring the Dell Quickstart Data Warehouse Appliance

22,713 Views0 Comments

The Dell Quickstart Data Warehouse Appliance provides a predictable, easy to stand up, turnkey solution for deploying a high-performing data warehouse based on Microsoft SQL Server built on 12th Generation Dell hardwa...

Using Power Query to import Hadoop HDFS files

13,722 Views0 Comments

While we may often use SQL queries and Hive to import Hadoop data into Excel and Power Pivot data models, sometimes we may need to directly access data files store in the underlying Hadoop Distributed File System (HDF...

Power View vs. other BI Tools

12,566 Views0 Comments

Transcript [00:00:00.00] There was a time with Microsoft BI when the only thing we really had at our disposal was Reporting Services. This was quite some time ago. But when all we had was reporting services we...

Defining BISM Tabular Model Perspectives

12,084 Views0 Comments

Power View Filters, Slicers and Highlighting

11,273 Views0 Comments

Creating User Hierarchies in the UDM

10,330 Views0 Comments

Most Liked

Using Excel 2013 Apps for Office to create a Date Dimension

1,644 Views0 Comments

In this video lesson we'll create a date dimension table using a free "App for Office" within Excel 2013.  Then once created we'll add it to a new PowerPivot data model. If using a previous version of Excel, you ca...

Power View vs. other BI Tools

12,566 Views0 Comments

Transcript [00:00:00.00] There was a time with Microsoft BI when the only thing we really had at our disposal was Reporting Services. This was quite some time ago. But when all we had was reporting services we...

Creating a date dimension table using Excel Formulas

3,357 Views1 Comments

Analysis of data over date ranges is one of the most common use cases for data analysis.  In this Video Chris Campbell demonstrates an easy method to create a date table in Microsoft Excel.  The resulting table can be...

Introduction to BISM 1 of 2

7,700 Views0 Comments

Synopsis What is a BI Semantic Model?  This lesson covers the basics of what BISM is, where it fits in the BI architecture and what technologies are used to create and deploy BI Semantic Models   Transcript ...

Introduction to DAX

5,863 Views0 Comments

Transcript [00:00:00.00] When we introduced the BI Semantic Model, we talked about its architecture having three fundamental components: 1. The Data Model 2. Business Logic & Queries 3. Data Acces...

SP BI Crash Course #13 – Claims to Windows Token Service

1,942 Views0 Comments

The Claims to Windows Token Service is a proxy service that makes implementing Kerberos delegation in a SharePoint 2013 BI farm relatively painless.  While configuring and using this service is not difficult, it has v...