Skip to main content Skip to navigation
Mauricio Featherman Marketing Analytics

Basic BI Review

1http://www.youtube.com/watch?v=7gQKCi3tPQASelf-service BI
2http://www.microsoft.com/en-us/bi/LearningCenter/BIVideos.aspxMSFT BI Videos
3Part 1: http://www.youtube.com/watch?v=qC21ojup4O8

Part 2: http://www.youtube.com/watch?v=kgSKzkdr2RI
What is SSIS, SSAS, SSRS. What is ETL? Includes demo of ETL process
4Part1: http://www.youtube.com/watch?v=HUlvMRYxvoM

Part 2: http://www.youtube.com/watch?v=7bnJIE-JfAQ
BI 101 - PC TeachMe - goes into cubes
5http://www.youtube.com/watch?v=MibLE2ErVkcOverview of BI Stack and BISM
MSFT MVP: Kevin Goff:
6http://www.youtube.com/watch?v=HAR7uXwn0OI
7Miscrosoft Bism Model

Microsoft BI Tool Choices
Microsoft Bism Model: Paper (pg 4-9)
White Paper: Microsoft BI Tool Choices
8Microsoft Teched 2013 VideosMicrosoft TechEd 2013
Presentation Videos
9http://www.youtube.com/watchv=Y4qTxSAYsOsMSFT BI Overview
10http://www.youtube.com/watchv=39EpDjEj22AMSFT BI Tools Overview w/ Tabular Model

T-SQL

1http://www.youtube.com/watch?v=2-1XQHAgDsM&list=PL6EDEB03D20332309&index=1Wise Owl Tutorials - writing SQL Queries

Business Analytics

1http://www.youtube.com/watch?v=_SaVw8jjUy0&feature=youtu.beBi Analytics Video from IBM
2http://www.youtube.com/watch?v=eRlr83AfrL8Wiki Article on BA. Discusses some questions that BA can help to answer

Excel Connection to SQL Server Analysis Service Cubes

1http://projectbotticelli.com/knowledge/multidimensional-analysis-microsoft-excel-and-sql-serverWorking with Cubes in Excel
2http://www.youtube.com/watch?v=me7OYOJ8r-EConnecting Excel to SSAS Data cube (Start at 2:30)

SSAS Tabular Model

1http://channel9.msdn.com/posts/SQL11UPD06-REC-02Developing an SSAS Tabular Model - Peter Myers
2http://channel9.msdn.com/posts/SQL11UPD06-REC-03More on tabular Models from Peter Myers
3http://www.code-magazine.com/Article.aspx?quickid=1301071Article Creating Tabular Model
4SSAS Tabular Part 1 http://www.youtube.com/watch?v=eeCHagddHyc&feature=c4-overview&playnext=1&list=TL8GEWphu6-Kc
Kevin Goff - Part 1
5http://www.youtube.com/watch?v=KgWAIyW2essKevin Goff - Part 2
6http://msdn.microsoft.com/en-us/library/hh212940.aspxMSFT White paper Tabular Model vs. OLAP
7http://www.youtube.com/watch?v=91lP8UZcLuYTabular Model vs OLAP video 1 of 5
8http://www.youtube.com/watch?v=qTN9RmjgmMUTabular Model vs OLAP video 2 of 5
9http://www.youtube.com/watch?v=jsN9FwZtQ-oTabular Model vs OLAP video 3 of 5
10http://www.youtube.com/watch?v=SqH4aAtbaW0Tabular Model vs OLAP video 4 of 5
11http://www.youtube.com/watch?v=Ti_gwZ_UzcsTabular Model vs OLAP video 4 of 5
12http://www.youtube.com/watch?v=VoH2kK7_9F8Ferrari - Tabular Model vs OLAP
13http://www.sqlbi.com/Ferrari & Russo Website
14http://www.prologika.com/Books/0976635356/Video/amas2012.htmlMultitude of videos
15http://sqlblog.com/blogs/marco_russo/archive/tags/Analysis+Services/default.aspxMarco Russo's blog
16http://cwebbbi.wordpress.com/Chris web's Blog
17http://sqlblog.com/blogs/alberto_ferrari/

http://www.sqlbi.com/articles/author/alberto-ferrari/
Alberto Ferrari's blog
18http://www.youtube.com/watch?v=JF2oD7gpMbkDAX queries
19http://www.youtube.com/watchv=q2oPc7vXDI8DAX - Kevin Goff
20http://www.youtube.com/watchv=tA0ciTsTBw8File Table Enhancement (Pt. 3)
21http://channel9.msdn.com/posts/SQL11UPD06-REC-04Dax Improvements - Peter Myers

SSAS Data Mining & Predictive Analytics

1http://www.youtube.com/watch?v=tRjugx_xjh8SSAS Data Mining - Peter Myers
2http://projectbotticelli.com/knowledge/predictive-analysis-microsoft-sql-server-excelPredictive Analysis
3http://technet.microsoft.com/en-us/library/bb522456.aspxSSAS Implementing Data Mining
4http://www.slideshare.net/idigdata/excel-sql-server-data-mining-overviewSlideshows

SQL Server Reporting Services (SSRS)

1http://www.youtube.com/watch?v=kTPJBAtv29k&list=PL7A29088C98E92D5F&index=1Wise Owl video series
2http://www.youtube.com/watch?v=XIFChOguvQgCreating reports
3http://www.youtube.com/watch?v=DfLnnB7fAukDeploying reports
4http://www.youtube.com/watch?v=A2gH0r_Pz8QFormatting reports
5http://www.youtube.com/watch?v=WSH5sMXMMHoReport parameters
6http://www.youtube.com/watch?v=Nv7f5GVsuxcSorting in reports
7http://channel9.msdn.com/posts/SQL11UPD06-REC-05SSRS Improvements - Kevin Goff
8http://www.youtube.com/watch?NR=1&v=o2N3ZCinpPs&feature=endscreenSSAS Cube datasource
9http://www.youtube.com/watch?v=vMHCY6Urta8SSRS Integration with Sharepoint - Kevin Goff
10http://www.youtube.com/watch?v=o2N3ZCinpPsSSRS on a cube
11http://www.youtube.com/watch?v=x0wzWPTCZHEDeploying SSRS to SQL Report Server
12http://denglishbi.wordpress.com/2010/12/31/using-reporting-services-report-ssrs-with-performancepoint-services-pps/Blog entry: Using Reporting Services Report (SSRS) with PerformancePoint Services (PPS)
13http://www.mssqltips.com/sqlservertip/2704/developing-a-ssrs-report-using-a-ssas-data-source/SSRS Report on a SSAS cube
14http://channel9.msdn.com/posts/SQL11UPD06-REC-06Configuring data alerts - Peter Myers
15http://www.mssqltips.com/sqlservertip/2926/ssrs-data-specific-report-drill-through-to-bing-maps/SSRS drill-thru to Bing Maps
16Examples Pt.1

Examples Pt.2
Writing Expressions
17http://projectbotticelli.com/knowledge/spatial-reporting-microsoft-sql-server-and-sharepoint-serverSpatial reporting
18http://www.youtube.com/watch?v=k_WQ4a7J7VYReport variables and group variables

POWERVIEW (new reporting tool for exploration - built into Sharepoint and excel)

1http://www.microsoft.com/en-us/bi/Products/PowerView.aspxSlimmed-down self-service BI reporting tool
2http://channel9.msdn.com/posts/SQL11UPD06-REC-07Powerview - Peter Myers
3http://channel9.msdn.com/posts/SQL11UPD06-REC-08Powerview - Peter Myers
4http://www.youtube.com/watch?feature=player_embedded&v=gz2N7S6pgksPowerView Intro
5http://technet.microsoft.com/en-us/library/hh213579.aspxTool inside Sharepoint to create SSRS reports
6http://www.youtube.com/watch?v=DP1DPTTRMmsPowerView
7http://projectbotticelli.com/knowledge/power-view-and-bism-introduction

Base Sharepoint

1http://www.youtube.com/watch?v=KTI5dxbQaqo
2http://www.youtube.com/watch?v=7c-6GrWuwbQSharepoint and Visual Studio
3http://www.youtube.com/watch?v=DP1DPTTRMms
4http://www.youtube.com/watch?v=1KHFxLs5vHk
5Part 1: http://www.youtube.com/watch?v=gYOTudcwCAY

Part 2: http://www.youtube.com/watch?v=VxIicSbBCf4
What is Sharepoint?
Discussion & Demo

Sharepoint for BI and Performance Point

1http://channel9.msdn.com/posts/SharePoint-2013-BISharepoint 2013 BI
2Creating and Using a Sales dashboardWhite Paper: Creating and Using a Sales dashboard
3Document: learn about PerformancePoint Scorecards
4http://projectbotticelli.com/knowledge/dashboards-and-scorecards-microsoft-sql-server-and-sharepoint-serverDashboards and Scorecards
5http://www.youtube.com/watch?v=cArVjEpC1xsFrontend Protocols for Sharepoint
6http://www.youtube.com/watch?v=JCqZtKG9XtQDeveloping scorecard from KPI in SSAS Cube
7http://www.youtube.com/watch?v=t86Q7dkzQlIReports and Dashboards with PerformancePoint
8http://www.youtube.com/watch?v=f9cDiDaFdK0Filter, Report and Interactive Dashboard in PerformancePoint
9http://www.youtube.com/watch?v=a9rxjZGbeQ4BI Support, Excel Services in Sharepoint
10http://www.youtube.com/watch?v=PQoK5qEkKNI
11http://www.youtube.com/watch?v=xHkGDJmHxYo
122013 IntroThemesTime IntelligenceCreating KPI'sPerformance Point Blog entries
13http://www.youtube.com/watch?v=xA0poJsc48MTeEchEd talk, Sharepoint lists
14http://www.youtube.com/watch?v=22pwJiuMtBEPerformancePoint Dashboard BI
15http://www.youtube.com/watch?v=Syy0P7000ukPerformancePoint Dashboards - from O'Reilly
16http://www.youtube.com/watch?v=ZgenXIUHJIoDeploying Powerpivot to Sharepoint
17http://www.youtube.com/watch?v=xIMi6hii-zs

http://www.youtube.com/playlist?list=PL65A0CC2623ACD579
Performance Point Dashboard

PowerPivot (Excel add-in that leverages SSAS)

1http://www.youtube.com/watch?v=30I7dcT1TcPowerPivot Demo
2http://www.youtube.com/watchv=mmUJswQ1I_kPivot tables on SSAS cubes
3http://www.youtube.com/watchv=FK1azVzg9IIImporting data
4http://www.youtube.com/watch?feature=player_embedded&v=awnZjX5xt-wSlicers
5http://www.youtube.com/watchv=ODvV9kuR58PowerPivot and PowerView
6http://www.youtube.com/watch?v=nJyfpEykgYcMSFT Video
7http://www.microsoft.com/en-us/bi/LearningCenter/BIVideos.aspx4 MSFT videos
8http://www.youtube.com/watch?feature=player_embedded&v=z06Dn71b2iMFrom MSFT
9http://www.youtube.com/watch?v=l65tXvvBej0Kevin Goff - Part 1
10http://www.youtube.com/watchv=3TBlmKAstHAKevin Goff - Part 2
11http://www.youtube.com/watchv=VlOsAiMx7w4
12http://www.youtube.com/watchv=7gQKCi3tPQAPowerPivot - Self-service BI
13http://www.youtube.com/watchv=dOJvKz8QWk8PowerPivot Intro
14http://www.youtube.com/watchv=d6h8YJKEb2wPublishing a PowerPivot workbook using Sharepoint
15http://www.youtube.com/watchv=hPTkKYpvvRYPowerPivot with Sharepoint 2013
16http://office.microsoft.com/en-us/excel-help/whats-new-in-powerpivot-in-excel-2013-HA102893837.aspxNew changes in 2013
17Using PowerPivot to show Azure data
18Microsoft TechEd - Excel\Sharepoint LabExcel & Sharepoint integration lab from MSFT TechEd 2013
19Sample Data Files for Ferrari & Russo book.zip

Statistics

1http://www.youtube.com/watch?v=7W5RIb8a8DI&feature=c4-overview&list=UUmGwvRo2XZW4jidpvIOz_-gStats in Excel
2http://social.technet.microsoft.com/wiki/contents/articles/684.powerpivot-dax-statistical-functions.aspxDAX Statistical functions
3http://www.youtube.com/watch?v=BmoaPwzs0kgSSAS - Detect Categories
4http://www.youtube.com/watch?v=Bq5sQoNtabUSSAS - Detect key influences
5http://www.bidn.com/blogs/DustinRyan/bidn-blog/4133/the-whaty-what-of-data-mining-algorithms-in-ssasSSAS Data mining
6http://www.mssqltips.com/sqlservertip/2915/sql-server-analysis-services-period-over-period-variance-analysis/SSAS Variance Analysis

Siverlight PivotViewer (currently in development and integration @ MSFT)

1http://www.codeproject.com/Articles/91552/Working-With-Silverlight-PivotViewerFour Live PivotViewer samples
2http://www.microsoft.com/silverlight/pivotviewer/Pivot Viewer Demo Videos
3http://www.youtube.com/watch?v=BZuFUZpEZ-AFrom MSFT Live Labs
4http://www.youtube.com/watch?v=lVGNXCLDjg0
5http://visualstudiomagazine.com/articles/2012/09/01/semantic-zoom.aspxStep by step implementation