Build your first, free training! (2nd)

If someone is looking for free quality training to become Business intelligence developer, just keep on reading this post.

I felt the material contained in the Build your first BI solution on R2 IA  bit lacking of the basis about Dimensional Modeling Techniques e general introduction on BI…

Well the problem is solved, just found that Microsoft learning is giving for free the previous version tailored for SQL 2008 (not R2). Apart from the new features introduced on R2, the

https://www.microsoftelearning.com/eLearning/courseDetail.aspx?courseId=166270&offerPriceId=288485&tab=details

is a great start! (you need to login to download and access the content)

The content can be accessed online or through the off-line player

image

Unluckily the UI is not great specially when the movie/demos are played, so a good way is to

– download all the course online

– open the video with your favorite media player

they are located in

%LOCALAPPDATA%\Element K\Offline Course Player\content\166270\plo_content\ORG6024\COURSE166270\media

(thanks sysinternals Eye rolling smile)

That’s the list of the content… a lot are demo/video easy to follow, the target is level 200…

Introduction to Microsoft SQL Server 2008 Business Intelligence for Developers

Module Overview

Introduction to Microsoft SQL Server 2008 Business Intelligence for Developers

Datasheet: Intro to BI for Developers

Intro to SQL Server 2008 BI Solution Development Track Introduction Video

Microsoft® Business Intelligence Strategy Overview

Module Overview

Microsoft® Business Intelligence Strategy Overview

Overview, review of integration challenges, support for ADO.NET sources

Demo: Delivering information to decision makers with Microsoft BI

BI solution scenarios, integrated reporting and analytics, source systems

Microsoft’s BI strategy, integrating with the Microsoft BI Platform

Introduction to SQL Server 2008 tools, documentation and AdventureWorks 2008

Demo: SQL Server Management Studio and SQL Server BI Development Studio

Demo: AdventureWorks 2008 Sample Databases

Introduction to Dimensional Modeling Techniques

Module Overview

Introduction to Dimensional Modeling Techniques

Designing a dimensional model, star schemas, designing dimensions

Snowflake dimensions, defining hierarchies, defining dimension primary keys

Designing fact tables, designing fact table foreign keys

Date and time dimensions, parent-child hierarchies

Slowly changing dimensions, integrating with the Microsoft BI Platform

Demo: Introducing the AdventureWorks 2008 DW Dimensional Model

Introduction to ETL Techniques Using SSIS

Module Overview

Introduction to ETL Techniques Using SSIS

Module overview, data integration challenges, business scenarios, SSIS

Introducing SSIS components, architecture, SSIS packages, connection manager

Process and communication tasks, SQL Server tasks, analysis services task

Demo: developing control flow tasks in SSIS – Part I

Demo: developing control flow tasks in SSIS – Part II

Demo: developing control flow tasks in SSIS – Part III

Data flow tasks, data flow sources, data flow destinations, row transformations

Demo: developing data flow tasks in SSIS – Part I

Demo: developing data flow tasks in SSIS – Part II

Designing ETL Packages, orchestrating the ETL process

Slowly changing dimension transformation

Introduction to SQL Server Reporting Services

Module Overview

Introduction to SQL Server Reporting Services

Module overview, reporting business scenarios, traditional reporting challenges

Report server, report manager, report builder, report designer, model designer

Managing reports, delivering reports, customization extensions, deploy scenarios

Designing SSRS reports, creating a report server project, defining data sources

Table data region, matrix data region, list data region, chart data region

Report items: Textbox, line, rectangle, image, subreport

Demo: designing a basic report

Query parameters, report parameters, configuring report parameters

Report interactivity, toggling visibility, adding links to a report

Adding a document map, interactive sorting, extending reports with custom logic

Demo: adding interactivity to a report

Publishing and Accessing Reports with Reporting Services

Module Overview

Publishing and Accessing Reports with Reporting Services

Understanding report deployment, deploying reports from BIDS

Accessing reports in SSRS, report configuration properties

BI solution scenarios, integrated reporting and analytics, source systems

Demo: deploying a report to the report server from BIDS, Report Builder

Introducing the UDM

Module Overview

Introducing the UDM

Module overview, review of OLAP fundamentals, querying a cube

OLAP business scenarios, SSAS OLAP component vs. SSAS Data Mining component

Demo: designing, deploying and browsing an Analysis Services cube

Analysis Services data sources, data source views, and cubes

Analysis Services dimensions

Demo: designing an Analysis Services date dimension in BIDS

Analysis Services calculations and Key Performance Indicators (KPI’s)

Analysis Services programmability and API’s

Introduction to MDX

Module Overview

Introduction to MDX

Module introduction, introduction to MDX, using MDX, MDX and UDM, learning MDX

Comparing TSQL and MDX query structures and concepts

Demo: comparing Transact-SQL and MDX queries, Part I

Demo: comparing Transact-SQL and MDX queries, Part II

MDX query techniques, defining an axis, creating a set

MDX query techniques, functions and keywords, defining asymmetrical queries

Demo: writing MDX queries in SQL Server Management Studio

Using MDX formulas to create calculated values, multidimensional coordinates

Complete and partial tuples, tuples and unspecified hierarchies

Understanding calculated members, creating calculations, MDX tuples

Examples of calculated members, PrevMember function, ParallelPeriod Function

Accessing the UDM from SSRS and Excel Services

Module Overview

Accessing the UDM from SSRS and Excel Services

Module overview, accessing the Analysis Services UDM from Reporting Services

Demo: Developing an Analysis Services report with Reporting Services

Accessing the Analysis Services UDM from Excel 2007

Excel 2007 report components, PivotTable examples and options, PivotTable design

Accessing the Analysis Services UDM from Microsoft Office SharePoint Server 2007

Demo: Accessing the Analysis Services UDM from Microsoft Excel 2007

Introducing SSAS Data Mining Models

Module Overview

Introducing SSAS Data Mining Models

Intro to Data Mining Presentation Part I

Preparing data for data mining, data mining process overview

Data mining integration with SQL Server Integration Services, programming

Demo: Creating a SQL Server 2008 Analysis Services Data Mining Model

Demo: Visualizing the results of a SQL Server 2008 Analysis Services Data Mining

Building Dashboards in PerformancePoint Server 2007

Module Overview

Building Dashboards in PerformancePoint Server 2007

Module overview, performance management fundamentals, business scenarios

Microsoft Office PerformancePoint Server 2007 architecture, dashboard designer

Building a Office PerformancePoint Server 2007 scorecard, adding data source

Demo: Building a Microsoft Office PerformancePoint Server 2007 Dashboard Part 1

Demo: Building a Microsoft Office PerformancePoint Server 2007 Dashboard Part 2

Demo: Building a Microsoft Office PerformancePoint Server 2007 Dashboard Part 3

Demo: Building a Microsoft Office PerformancePoint Server 2007 Dashboard Part 4

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s