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

http://www.code-magazine.com/Article.aspx?quickid=1304071Basics of Data Warehouses - Goff
http://www.youtube.com/watch?v=A-G5UVohwQQExploring dimensional modeling
Columnstore Indexes .pdfColumn Store Indexes - saving storage space in the cube

SSIS - loading the OLTP data into the Data Warehouse

http://www.youtube.com/watch?v=9Akvz2x0az4&list=TLsli72tzpsGALearn it First SSIS ETL Process
http://www.youtube.com/watch?v=hJjH42P427oworkflows and dataflows
http://www.youtube.com/watch?v=dzfZJlN4nzIData and date conversions
http://www.youtube.com/watch?v=lo3w6pFSOdQSSIS Packages
http://www.youtube.com/watch?v=PQ1eM0TUdl0SSIS Lookups
http://www.youtube.com/watch?v=ylV1M1WTpMoSSIS fuzzy lookups
http://www.youtube.com/watch?v=i8Y_puInmpISSIS variables
http://www.youtube.com/watch?v=mPYVXnCqgTESSIS variables - detail
http://www.youtube.com/watch?v=Tsyq1wwhepESSIS data viewers
http://www.youtube.com/watch?v=0rOL4xIzvIcSSIS for each loop
http://www.youtube.com/watch?v=pa5AKIvpaL8New capabilities of SSIS (Pt. 4)
http://www.youtube.com/watch?v=fqVxQugBmoUCovers .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)
http://www.youtube.com/watch?v=C75p1199pmQ
http://www.youtube.com/watch?v=9Akvz2x0az4ETL Process
http://www.youtube.com/watch?v=3cPq9FXk-RA&list=PLNIs-AWhQzcmPg_uV2BZi_KRG4LKs6cRs&index=1SSIS Wise Owl Tutorials
http://www.jessicammoss.com/publications.html

http://jessicammoss.blogspot.com/
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
http://projectbotticelli.com/knowledge/multidimensional-analysis-microsoft-excel-and-sql-serverWorking with Cubes in Excel
http://www.youtube.com/watch?v=me7OYOJ8r-EConnecting Excel to SSAS Data cube (Start at 2:30)
http://www.youtube.com/watch?v=pFwRIdc1enESSAS Intro 1 of 6
http://www.youtube.com/watch?v=b_iTzhLWmwQSSAS Intro 2 of 6
http://www.youtube.com/watch?v=mqHCGpmJqgoSSAS Intro 3 of 6
http://www.youtube.com/watch?v=J9_pLmVmqYESSAS Intro 4 of 6
http://www.youtube.com/watch?v=slPl6IXUdjkSSAS Intro 5 of 6
http://www.youtube.com/watch?v=Io612SWqmf0SSAS Intro 6 of 6
Short version http://www.youtube.com/watch?v=gvEqsJbAGKU

Long version http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/WebinarDetails.aspx?ResourceID=358
Dimensional Modeling
http://channel9.msdn.com/posts/SQL11UPD06-REC-01BISM Model - Peter Myers
http://www.youtube.com/watch?v=pyUsp8qc7hgIntro 01
http://www.youtube.com/watch?v=n98gZmneiysDatasources 02
http://www.youtube.com/watch?v=FAPY4Q-TrhMDatasource Views 03
http://www.youtube.com/watch?v=qoUnTHs5ajkCube creation 04
http://www.youtube.com/watch?v=aglwqC8irMACreating a cube
http://www.youtube.com/watch?v=ctUiHZHr-5MLearn it first - Cube creation
http://www.youtube.com/watch?v=QVEvK7qZf_MDimensions 05
http://www.youtube.com/watch?v=Js4sEkm05ZADimension hierarchies 06
http://www.youtube.com/watch?v=88De9IIPAyoDimension attribute relationships 07
http://www.youtube.com/watch?v=gIc5Smj3S-oDimension storage 08
http://www.youtube.com/watch?v=byja6RvVGbkDimension discretization 09
http://www.youtube.com/watch?v=ErHUpVUyue0Parent child dimensions 10
http://www.youtube.com/watch?v=ewX1nsjX-uAStar and snowflake 11
http://www.code-magazine.com/Article.aspx?quickid=1308091Tabular vs. OLAP
http://www.youtube.com/watch?v=12WMPhSm5rULearn it First MDX query intro
http://www.youtube.com/watch?v=tA0ciTsTBw8File Table Enhancement (Pt. 3)
http://channel9.msdn.com/posts/SQL11UPD06-REC-01SSAS Improvements - Peter Myers
http://www.mssqltips.com/sqlservertip/2877/sql-server-analysis-serviceslead-lag-openingperiod-closingperiod-time-related-functions/SSAS Lag and Lead
http://www.mssqltips.com/sqlservertip/2915/sql-server-analysis-services-period-over-period-variance-analysis/SSAS Variance Analysis

MDX Programming in SSMS

http://msdn.microsoft.com/en-us/library/ms145514.aspxMDX queries
http://msdn.microsoft.com/en-us/library/ms144785.aspxMDX queries
http://msdn.microsoft.com/en-us/library/ms145514.aspxMDX queries
http://msdn.microsoft.com/en-us/library/ms144785.aspxMDX queries
http://www.youtube.com/watch?v=QZrErVoSd-8MDX queries

Pretty Technical Data Warehousing Content

http://www.youtube.com/watch?v=siS_7pcj0yIPrepping for the MSFT MSA exam. Start at the 9 minute mark

KPI Corner 2.0

http://technet.microsoft.com/en-us/library/ms166869.aspxKPI Syntax
http://www.youtube.com/watch?v=ymPDKnmreDISSAS 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

http://www.microsoft.com/learning/en-us/companion-moc.aspx
10774A - Running T-SQL queries

10775A - Data Base Management Admin

10776A - Developing databases

10777A - Implementing a Data warehouse

10778A - Implementing Data Models and reports
10774A-ENU-Companion.zip

10775A-ENU-Companion.zip

10776A-ENU-Companion.zip

10777A-ENU-Companion.zip

10778A-ENU-Companion.zip

10778A-ENU-Companion.zip

10774A-ENU-Allfiles.exe

10775A-ENU-Allfiles.exe

10776A-ENU-Allfiles.exe

10777A-ENU-Allfiles.exe
http://www.youtube.com/watch?v=wFpkOJ0xBA8SQL SELECT
http://www.youtube.com/watch?v=dlAkVqX7BC8SQL WHERE
http://www.youtube.com/watch?v=gdtRK_jCDH8SQL UNION
http://www.youtube.com/watch?v=14qSQUpPoTQSQL GROUP BY
http://www.youtube.com/watch?v=14qSQUpPoTQ&feature=c4-overview-vl&list=PL66AB4C0574A2E3D2SQL GROUP BY
http://www.youtube.com/watch?v=K2mFsfhLckwSQL GROUP BY
http://www.youtube.com/watch?v=KBYU5bAR0_gSQL Keys
http://www.youtube.com/watch?v=vlCDrjtr60MSQL JOINS
http://www.youtube.com/watch?v=Aft2m0aBZkQSQL LIKE
Books 24-7 - log in first with zzusis

http://skillport.books24x7.com/toc.aspx?bookid=49812
Look for SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach Brimhall, Dye et al.
T_SQL Recipes available on Books 24x7
http://www.youtube.com/watch?v=KIxWKl0WjXEColumn store Index (Pt. 1)
http://www.youtube.com/watch?v=5HBDGg-ABd8T-SQL Enhancements in SS2012 (Pt 2)
http://www.youtube.com/watch?v=5HBDGg-ABd8&list=TL8GEWphu6-KcT-SQL Enhancements in SS2012 (Pt 3)
http://www.youtube.com/watch?v=ASeF-bo6xW0
http://www.youtube.com/watch?v=K7zaBb4mxWIT-SQL Queries
http://www.youtube.com/watch?v=ygfikznRjpwNormalization
http://www.code-magazine.com/Article.aspx?quickid=1112061T-SQL Tips - Goff
http://www.code-magazine.com/Article.aspx?quickid=1208111TSQL Tips - Goff
http://www.code-magazine.com/Article.aspx?quickid=1206021TSQL Tips - Goff

MSFT BI Videos

http://www.microsoft.com/en-us/bi/LearningCenter/BIVideos.aspx

SQL project files from MSFT that are used in the Official training
http://www.microsoft.com/learning/en-us/companion-moc.aspx


Material from MSFT MVP Kevin Goff

imgC

Part 1: Columnstore Index:
* Video http://www.youtube.com/watch?v=KIxWKl0WjXE
* White paper (use ColumnStore Indexes for DW not OLTP DB)

Part 2 T-SQL enhancements: http://www.youtube.com/watch?v=5HBDGg-ABd8

Part 3 File Table enhancements: http://www.youtube.com/watch?v=tA0ciTsTBw8

Part 4 SSIS Part 1 http://www.youtube.com/watch?v=pa5AKIvpaL8

Part 5 SSIS Part 2 http://www.youtube.com/watch?v=fqVxQugBmoU

Part 6 BI Semantic Model http://www.youtube.com/watch?v=MibLE2ErVkc

Part 7 SSAS Tabular Part 1 http://www.youtube.com/watch?v=eeCHagddHyc&feature=c4-overview&playnext=1&list=TL8GEWphu6-Kc

Part 8 SSAS Tabular Part 2 http://www.youtube.com/watch?v=KgWAIyW2ess

Part 9 PowerPivot Part 1 http://www.youtube.com/watch?v=l65tXvvBej0

Part 10 PowerPivot Part 2 http://www.youtube.com/watch?v=3TBlmKAstHA

Part 11 DAX http://www.youtube.com/watch?v=q2oPc7vXDI8

Part 12 SSRS Integration with Sharepoint 2010 http://www.youtube.com/watch?v=vMHCY6Urta8

Part 13 PowerView http://www.youtube.com/watch?v=DP1DPTTRMms

Programming
http://www.youtube.com/watch?v=aqDMFQMlvq0 Using Stored Procedures

Andrew Brust http://www.microsoft.com/en-us/download/details.aspx?id=24293

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.

Data

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

Languages:

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