Skip to main content Skip to navigation
Mauricio Featherman Data Management/BI

Data Management/BI Video Library

“Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism,
comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.”

Power BI

Getting started with Power Query - Part 1
TechEd North America - Excel based BI
TechEd North America talk - Power Query

Implementing a Data Warehouse of Data Warehouses - Goff dimensional modeling
Columnstore Indexes .pdfColumn Store Indexes - saving storage space in the cube

SSIS - loading the OLTP data into the Data Warehouse it First SSIS ETL Process and dataflows and date conversions Packages Lookups fuzzy lookups variables variables - detail data viewers for each loop capabilities of SSIS (Pt. 4) .csv data loads, for each looks, variables, writing to temp storage database table, sending GMAIL. Features great coverage of MERGE T_SQL Statement - (Pt. 5) Process Wise Owl Tutorials
Blog from MSFT MVP

SSAS Multi-dimensional modeling

(Tabular Modeling content here)
BI Semantic Model - Explained
Semantic model explained
Modeling white paper
Semantic modeling paper
Older white paper
Hands-on Content with Cubes in Excel Excel to SSAS Data cube (Start at 2:30) Intro 1 of 6 Intro 2 of 6 Intro 3 of 6 Intro 4 of 6 Intro 5 of 6 Intro 6 of 6
Short version

Long version
Dimensional Modeling Model - Peter Myers 01 02 Views 03 creation 04 a cube it first - Cube creation 05 hierarchies 06 attribute relationships 07 storage 08 discretization 09 child dimensions 10 and snowflake 11 vs. OLAP it First MDX query intro Table Enhancement (Pt. 3) Improvements - Peter Myers Lag and Lead Variance Analysis

MDX Programming in SSMS queries queries queries queries queries

Pretty Technical Data Warehousing Content for the MSFT MSA exam. Start at the 9 minute mark

KPI Corner 2.0 Syntax KPI's

T-SQL 2.0

Microsoft DownloadsDatabase and sample project downloads
Companion code and db's for MSFT Courses
Use to study for Certification Exams
10774A - Running T-SQL queries

10775A - Data Base Management Admin

10776A - Developing databases

10777A - Implementing a Data warehouse

10778A - Implementing Data Models and reports




Books 24-7 - log in first with zzusis
Look for SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach Brimhall, Dye et al.
T_SQL Recipes available on Books 24x7 store Index (Pt. 1) Enhancements in SS2012 (Pt 2) Enhancements in SS2012 (Pt 3) Queries Tips - Goff Tips - Goff Tips - Goff

MSFT BI Videos

SQL project files from MSFT that are used in the Official training

Material from MSFT MVP Kevin Goff


Part 1: Columnstore Index:
* Video
* White paper (use ColumnStore Indexes for DW not OLTP DB)

Part 2 T-SQL enhancements:

Part 3 File Table enhancements:

Part 4 SSIS Part 1

Part 5 SSIS Part 2

Part 6 BI Semantic Model

Part 7 SSAS Tabular Part 1

Part 8 SSAS Tabular Part 2

Part 9 PowerPivot Part 1

Part 10 PowerPivot Part 2

Part 11 DAX

Part 12 SSRS Integration with Sharepoint 2010

Part 13 PowerView

Programming Using Stored Procedures

Andrew Brust

Data Modeling Developer tools:

 Data Tools (formerly BIDS) – create cubes, create tabular projects, configure deployment, debug, develop.  Bread and Butter for cube development.

SSMS (Management Studio) – administer, automate, configure security of databases, cubes, projects, instances, tables etc. DBA/IT Pro tool.

PowerPivot 2.0 (Excel) – available as a client, or in Sharepoint – “PowerUser” friendly, but good for local and personal BI development.

Report development tools:

Report Designer – the “heavy lifter” in Data Tools.  Robust set of features, visual studio derivative.  Available for SSRS Native or Sharepoint.

Report Builder – more consice version of the above, hosted in SharePoint, “ClickOnce” isntall  Not available in Native.  Power User / “Tech Savvy” End User-ish.

Self Service Tools:

Excel – SQL data sources, PowerPivot, Data Mining, etc.

PowerView – Requires a tabular instance (created in data tools) – information work and end-user friendly.  Highly visual.

SharePoint Report Viewer / Report Parts – See reports other users or designers have created.

PerformancePoint – Component of Sharepoint – create dashboards, scorecards, KPIs.  SSRS integrated.

Other Tools:

SharePoint 2010 SP1 or 2013 – integrated with SSRS, provides collaboration, source control, change and version control, highly suited to BI.


List of tools by end user function:

Strategic (SMEs, execs, Power Users, regional managers) – Need high-level views, dashboards: PerformancePoint

Tactical (Analysts, Advanced Users, Managers, SMEs) – need drill-down and slice/dice capability: PowerPivot or PowerView

Operational (Field Personnel) – need limited, ad-hoc, or repeated reports – SSRS and Report Builder with Sharepoint Integration


T-SQL – all-purpose SqlServer language.  ETL, administration, insert update delete,

MDX – used to query or expose multidimensional data.  Industry standardized.

DAX – expression editor for PowerPivot and Tabular modeling.  Formulaic, function-based.

DMX – Data Mining Expressions – used to query a data mining structure/model