Newest Videos

Analyzing Google Analytics Data in Real Time with Azure Stream Analytics

1.30K Views0 Comments

Analyzing streaming data in real time has always been a challenging task. With the growth of the Internet of Things, it has become more important than ever to build applications capable of dealing with streaming data....

Analyzing CRM Data with Power BI and OData Feeds

2.68K Views0 Comments

Many organizations use tools like Microsoft CRM to track their customer activity. Analyzing data in these systems can be a challenge because it can be hard to get the data out. The OData protocol makes it easy to cons...

Displaying multiple metrics on a Power View Map

2.17K Views0 Comments

Power View maps are a powerful tool in Excel Power BI that allow users to analyze their data visually on a map. Out of the box, Power View maps will only allow you to plot a single metric to determine bubble size...

Using UDF’s with Pig

3.69K Views0 Comments

User defined functions extend the capabilities of Pig Latin. The PiggyBank is a community supported library of UDF's that contain a variety of commonly needed capabilities. In this video, Chris Campbell shows you how ...

Introduction to Calculations in Power Pivot

9.39K Views0 Comments

This video is an Introduction to Calculations in Power Pivot. DAX calculations can significantly enhance the information available from a data model, and are an important skill for any Power Pivot data modeler. This v...

Turbocharging Hive #2 of 2 – Comparing Hive MR, Tez, Tez + ORC File

4.16K Views0 Comments

With the delivery of HortonWorks HDP 2.1, Hive has begun its evolution from a purely MapReduce-based data processing tool to a highly performant SQL query engine. The addition of ORC File storage optimizations and que...

Turbocharging Hive #1 of 2 – Deploying HD Insight 3.1 in Azure

3.54K Views0 Comments

With the delivery of HortonWorks HDP 2.1, Hive has begun its evolution from a purely MapReduce-based data processing tool to a highly performant SQL query engine. The addition of ORC File storage optimizations and que...

Enhancing web analytics — blending Google Analytics and SQL data with Tableau

12.54K Views0 Comments

One of the most common scenarios for self-service BI users is to combine data sources. Many companies use Google Analytics to measure how their web sites are used, but site usage is often only part of the story. To fi...

Migrating a SQL Azure DB between database servers

2.84K Views0 Comments

In this video we'll walk through the process of taking a copy of an Azure SQL Database from one Azure database server and restoring it to a new Azure database server. Restoring a snapshot of a database to a new ser...

Excel CUBEVALUE Functions – Advanced Introduction

3.85K Views0 Comments

In this Lesson Javier Guillen provides an advanced introduction to using CUBEVALUE functions in Microsoft Excel. If you've never used these uber-useful functions before, this is a must watch. In addition to showing...

Importing SQL Server data to R Studio via ODBC

6.93K Views1 Comments

In this lesson we'll learn how to use ODBC to import data from SQL Server directly into R Studio.  The lesson shows step-by-step how to create a valid ODBC connection to SQL Server, install and activate RODBC and quer...

Importing Folders with Power Query

3.72K Views0 Comments

[Transcript Follows] If you’ve ever had to import a folder full of ASCII data files with the same record layout, you know how frustrating it can be to design a smooth process to iterate over the files and import th...

Most Viewed

Using Power Query to import Hadoop HDFS files

33.96K 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...

SP BI Crash Course #3 – Planning Service Accounts

28.83K Views2 Comments

In this lesson we discuss the service accounts SharePoint 2013 needs to run in a distributed farm.  Once we define and create our service accounts we can start installing SharePoint!

Creating a SQL Server Data Warehouse Environment Using Microsoft Azure IaaS

24.05K 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...

Creating a Power Map Tour

23.47K 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...

Exporting reports from Power View

21.91K Views0 Comments

Calculating over Time in DAX

21.22K Views0 Comments

Most Liked

Using Excel 2013 Apps for Office to create a Date Dimension

3.79K 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...

Creating a date dimension table using Excel Formulas

9.86K 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...

Power View vs. other BI Tools

20.81K 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...

Introduction to BISM 1 of 2

11.21K Views2 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 ...

Using Power Query to import Hadoop HDFS files

33.96K 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...

Introduction to DAX

7.94K 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...