“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.”
|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=1304071||Basics of Data Warehouses - Goff|
|http://www.youtube.com/watch?v=A-G5UVohwQQ||Exploring dimensional modeling|
|Columnstore Indexes .pdf||Column Store Indexes - saving storage space in the cube|
SSIS - loading the OLTP data into the Data Warehouse
SSAS Multi-dimensional modeling
MDX Programming in SSMS
Pretty Technical Data Warehousing Content
|http://www.youtube.com/watch?v=siS_7pcj0yI||Prepping for the MSFT MSA exam. Start at the 9 minute mark|
KPI Corner 2.0
MSFT BI Videos
SQL project files from MSFT that are used in the Official training
Material from MSFT MVP Kevin Goff
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
|http://www.youtube.com/watch?v=aqDMFQMlvq0||Using Stored Procedures|
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.
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