Videos uploaded by user “Rob Kerr”
Importing data from SQL Server to R Studio via ODBC
This lesson shows how to use ODBC to import data from SQL Server to R Studio directly using SQL.
Views: 30911 Rob Kerr
Basic Star Schema design
Among the most basic design skills in designing a data warehouse solution is the star schema design. What's a star schema? What are the characteristics of a good star design?
Views: 101539 Rob Kerr
Introduction to Power Map
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 reflects its place in the suite of Microsoft's self-service BI tools, Power BI. Power Map integrates with Power Pivot data models created in Excel, and leverages the Bing Maps service for visualization and geolocation. In this video we'll create layers of data on a 3D mapping surface. By combining several layers into a single, interactive visualization, our visualizations help lead to insights not possible using conventional visualizations. In the next video lesson, we'll take this visualization to the next level by adding an animated "tour" that walks information consumers through the story our data is telling.
Views: 268878 Rob Kerr
Automating cube processing
A simple approach to automating cube processing
Views: 11780 Rob Kerr
Schema on Write vs. Schema on Read
Schema on Write vs. Schema on Read
Views: 4212 Rob Kerr
SQL vs. Hadoop: Acid vs. Base
SQL vs. Hadoop: Acid vs. Base
Views: 5591 Rob Kerr
Creating a Tabular model in SQL Server Data Tools
Creating a Tabular model in SQL Server Data Tools
Views: 19717 Rob Kerr
Uploading to Windows Azure Blob Store usign C#
In this video we'll walk through creating a C# application to upload files from a local folder to a container in Windows Azure Blob Store.
Views: 16485 Rob Kerr
Using the CUBEVALUE function
Creating customized workbooks in Excel 2010 using Analysis Services Cubes as the data source.
Views: 23424 Rob Kerr
Connect Tableau to Analysis Services
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'll see how to make the data connection and then create a map visualization within Tableau using the SSAS cube data. For more videos visit http://msbiacademy.com
Views: 14182 Rob Kerr
Intro to Hadoop MapReduce with C#
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 Java, but Hadoop's streaming feature allows the use of non-Java languages to write MapReduce jobs. For HDInsight, Microsoft provides an easy to use MapReduce API accessible from C#, which is used in this lesson.
Views: 14725 Rob Kerr
Configuring HTTP access to Analysis Services
This video walks through the configuration of msmdpump.dll, which allows users to connect to SSAS Multidimensional or Tabular instances using HTTP or HTTPS. This configuration is typically used to enable secure connections from Internet/Extranet users to Analysis Services cubes or Tabular models. Users can use any client that supports the standard OLEDB driver, for example Microsoft Excel.
Views: 11309 Rob Kerr
Using Excel 2013 Apps for Office to create a Date Dimension
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.
Views: 4012 Rob Kerr
Cube Functions in Power Pivot
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 the basic syntax for adding CUBEVALUE functions in your worksheets, Javier shows how to connect to PowerPivot data model measures using Microsoft Excel 2013. This session is loaded with practical tips & tricks you probably won't find in the product documentation, and you'll have a long list of new ideas for unleashing your creativity as you create your own analytical views in Microsoft Excel using Power Pivot.
Views: 15152 Rob Kerr
Views: 9880 Rob Kerr
The DAX CALCULATE() Function
The DAX CALCULATE() Function
Views: 32811 Rob Kerr
Creating Hierarchies in BISM Tabular Models
Creating Hierarchies in BISM Tabular Models
Views: 4997 Rob Kerr
Slowly Changing Dimensions
What's a slowly changing dimension? How do I decide which type to use?
Views: 14278 Rob Kerr
Calculating over Time in DAX
Calculating over Time
Views: 6118 Rob Kerr
Demo of Apache Sqoop Import
Demo of Apache Sqoop Import
Views: 4276 Rob Kerr
Blending Google Analytics with SQL Data in Tableau
Table of Contents: 00:53 - Marker
Views: 2797 Rob Kerr
DAX RELATED() Function
DAX RELATED() Function
Views: 17649 Rob Kerr
Introduction to Apache Sqoop
Introduction to Apache Sqoop
Views: 2529 Rob Kerr
DAX Calculation Context
DAX Calculation Context
Views: 3187 Rob Kerr
Querying SSAS cubes in Excel 2010
How to access SSAS cubes using Excel 2010 pivot tables
Views: 12621 Rob Kerr
Named Queries in the SSAS DSV
Named Queries in the SSAS DSV
Views: 2450 Rob Kerr
SP BI Crash Course #15 - Configuring PerformancePoint Services
Configuring the PerformancePoint Services application in SharePoint 2013 is relatively simple, and builds on the previous security configurations we've done in prior videos.
Views: 5404 Rob Kerr
Big Data 101: MPP Made Easy
Big Data 101: MPP Made Easy
Views: 2158 Rob Kerr
Counting DISTINCT() Values with DAX
Counting DISTINCT() Values with DAX
Views: 7955 Rob Kerr
Using AzCopy to upload data to Windows Azure Blob Storage
When using HDInsight to analyze unstructured data, it's most common to land information in Windows Azure Blob storage, and run Hadoop Map/Reduce jobs directly against those files. Why? Three reasons: 1.Blob Storage is relatively inexpensive compared to other alternatives 2.It performs quite well 3.Any data stored in Blob Storage remains even if we de-provision our HDInsight clusters (e.g. to save cost when we don't need them or to redeploy a different topology) Because the APIs for moving files Blob Storage are well document, we have several options. We can write our own C# application--which we'll do in a later lesson. There are also GUI applications available via CodePlex (free) and commercial ISVs. In this lesson we'll focus on AzCopy, a command-line utility provided by Microsoft to move files to Blob Storage. This utility is relatively easy to use, but also contains many advanced features via command-line switches. Whichever Blob Storage ingest method you use in your application, AzCopy is sure to be one of the tools in your HDInsight tool chest.
Views: 12267 Rob Kerr
Demonstration of Apache Hive
Demonstration of Apache Hive
Views: 2643 Rob Kerr
ETL on Hadoop: Using Pig for log file Analysis on HDInsight Azure
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 "schema on read" approach when processing unstructured data. In data warehousing terms, reading data from a source system is known as ETL, or "Extract/Transform/Load". In MPP systems, it's typically more efficient to transpose the T and L letters and use the "Extract/Load/Transform" pattern. Why? Because this pattern allows data transformation to leverage the full breadth of distributed processing nodes, resulting in superior performance. Pig, which is implements the PigLatin data flow language for Hadoop, is the most commonly used ELT technology in Hadoop clusters. In this introduction-level lesson we'll look at a simple Pig script to process and transform IIS web logs. While this is shown on an HDInsight cluster within the Azure cloud platform, the process is identical for any Hadoop cluster. For more videos like this one visit http://msbiacademy.com
Views: 13409 Rob Kerr
BISM Tabular Model Role-Based Security
BISM Tabular Model Role-Based Security
Views: 2902 Rob Kerr
Creating KPIs with BISM Tabular Models
Creating KPIs with BISM Tabular Models
Views: 4448 Rob Kerr
Using Power Query to import Hadoop HDFS files
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 (HDFS). Power Query, the flexible querying component in the forthcoming Microsoft Power BI suite, directly provides this capability. In this lesson we'll use Excel 2013 to build a Power Pivot data model, and use Power Query to connect to the data. Two of the tables in the data model are simply external Excel tables, while two others are files stored in Hadoop's HDFS file system. The version of Power Query used in the video is the "preview" edition available at the time this video was produced, and can be freely downloaded from Microsoft's web site. See more instructional videos like this one at http://msbiacademy.com
Views: 6939 Rob Kerr
Partitioning BISM Tabular Model Tables
Partitioning BISM Tabular Model Tables
Views: 1920 Rob Kerr
Analyze Twitter data with HDInsight using C# MapReduce
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 interesting information is contained in the user tweet content itself--such as #Hashtags and @otheruser references. In this lesson we'll show how to parse the Twitter JSON data, and how to extract insight from the user typed content--a kind of analysis difficult to achieve at scale with traditional analytical tools. Prerequisite: If you're not familiar with using the MapReduce API, take a look at the previous lesson that walked through the process to setup a new MapReduce solution. That video describes the methods and interfaces, as well as the job submission process.
Views: 5500 Rob Kerr
Setting Impersonation Information for Multidimensional Cubes
Setting Impersonation Information for Multidimensional Cubes
Views: 4148 Rob Kerr
Creating a new Dimension and Cube
Creating a new Dimension and Cube
Views: 4027 Rob Kerr
Introduction to BISM 1 of 2
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
Views: 1830 Rob Kerr
SP BI Crash Course #13 - Claims to Windows Token Service
The Claims to Windows Token Service is a proxy service that makes implementing Kerberos delegation in a SharePoint BI farm relatively painless. While configuring and using this service is not difficult, it has very specific security configurations to make it work correctly. In this video we'll discuss the configuration requirements and walk through the configuration of this important service.
Views: 2671 Rob Kerr
SP BI Crash Course #11 - Create the Secure Store Service
A critical part of our BI infrastructure in SharePoint 2013 is the Secure Store Service. This service is like a password vault used by various BI service applications. In this video we'll walk through the steps to create this service.
Views: 1363 Rob Kerr
SP BI Crash Course #14 - Configure for for Kerberos Delegation
When delegating Active Directory credentials to your back-end database servers, you probably need to enable Kerberos delegation. In newer versions of SharePoint, this has become a lot easier through the use of the Claims to Windows Token service. This video builds on the last one (#13) by showing the SPNs and AD trusts needed to enable Kerberos delegation in the SharePoint 2013 BI Farm.
Views: 2877 Rob Kerr
Exporting reports from Power View
Exporting reports from Power View
Views: 13809 Rob Kerr
SP BI Crash Course #23 - PowerPivot Mid-Tier Services
In the last video (#22) we installed PowerPivot on a database server external to the SharePoint farm. In this video we'll enable more features for PowerPivot workbooks, including data refresh, BISM content types and the PowerPivot dashboard in Central Administration.
Views: 1803 Rob Kerr
Submitting C# MapReduce jobs on Windows Azure HDInsight
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 Hadoop infrastructure, which is covered in Deploying an HDInsight Cluster in Windows Azure. To learn to create a C# MapReduce from scratch, make sure you've seen the lesson on Intro to Hadoop MapReduce with C#. Microsoft's distribution of Hadoop, HDInsight, can be used on a local workstation as a development environment as we have done in prior videos. However Big Data jobs running against large data sets require a production-scale Hadoop cluster. Windows Azure HDInsight is Microsoft's elastic Hadoop infrastructure delivered on its cloud platform, Windows Azure. The process for developing MapReduce jobs that run in Azure HDInsight is the same as we have done previously. In this lesson we'll make a few changes so our MapReduce job will obtain and store data in the Azure Storage Vault (ASV), which provides an HDFS file system running on the economical Windows Azure Blob Storage infrastructure. At the conclusion of this lesson, your Visual Studio based MapReduce job will automatically upload itself to Azure HDInsight and run very much like it did on your local workstation--except it will now have access to a highly scalable cloud compute and storage environment! See more videos like this one at http://msbiacademy.com
Views: 4521 Rob Kerr
Creating the SSAS Multidimensional Solution
Creating the SSAS Multidimensional Solution
Views: 1015 Rob Kerr
How MapReduce Works
How MapReduce Works
Views: 4641 Rob Kerr
Date Range Filters in MDX
Date Range Filters in MDX
Views: 2745 Rob Kerr