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

Business 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

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

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

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