kurs >
Webprogrammering > Microsoft Business Intelligence BI: S...
Kurs: Microsoft Business Intelligence BI: SQL Server 2008 R2 and Office 2010
Programutvikling AS
Dette kurset har ikke oppført noen dato for studiestart. Bruk skjemaet under for å kontakte leverandør for nærmere informasjon.
Delivering the right information in the right format at the right time to all users in the organization—that is Microsoft’s Business Intelligence (BI) strategy and vision for enterprise information management. Microsoft’s integrated BI tools enable developers to create effective solutions that information workers use every day to find meaningful patterns in the vast sea of data they collect and to use that insight to quickly respond to changing business conditions.
On completion of this workshop attendees will be able to position different types of Business Intelligence solutions, from enterprise data warehousing to data marts to real–time operational reporting and analytics. Attendees will learn how to design and build powerful integrated solutions that provide users with rich reporting, analysis, visualization and performance management capabilities by targeting operational data from an existing line–of–business application using the Microsoft Business Intelligence platform.
Attendees will work through 28 practical hands–on labs to build a complete BI solution by the end of the workshop.
Target Audience
The presentations and labs have been designed specifically to give professional developers—those who work for an ISV, SI, or enterprise customer—the information they need to deliver integrated solutions on the Microsoft BI platform.
This course is also relevant and useful for those interested to understand and evaluate Microsoft’s Business Intelligence offerings.
Prerequisites
The following skills and knowledge will help attendees have a positive experience in the workshop:
- Active development experience with C# and⁄or VB.NET
- Basic understanding of SQL and relational database concepts
Please Note
This workshop is designed for professional developers with little or no experience building BI solutions. If you already have extensive experience building solutions on the Microsoft BI platform, you may find portions of this workshop to be a review of material that you are already familiar with.
The workshop focuses on a specific scenario: supplementing an existing line–of–business application with integrated reporting and analytics functionality using SQL Server, Excel, PowerPivot, ProClarity, and SharePoint (Excel Services and PerformancePoint Services). Other scenarios, such as developing custom reporting and analytic tools, or implementing enterprise data warehouses, are not covered in great detail.
Course Objectives
Through interactive presentations and concrete hands–on labs, attendees will learn:
- How to use Microsoft SQL Server 2008 R2 to build and manage data marts which provide a consolidated view of organizational data.
- How to use Office 2010 and SharePoint 2010 to deliver a rich data analysis, visualization and performance management experience to end users.
- How to use dimensional modeling techniques and Visio 2010 database modeling tools to create data models in SQL Server 2008 R2 for hosting consolidated BI information.
- How to build consolidated data marts using SQL Server 2008 R2 Integration Services to extract, transform, and load business–critical information into SQL Server 2008 R2 databases from disparate sources such as business applications and corporate databases.
- How to use SQL Server 2008 R2 Reporting Services to develop predefined and ad hoc relational reports that simplify access to business–critical information, and how to publish and share those reports using SharePoint 2010 libraries.
- How to use SQL Server 2008 R2 Analysis Services to create a Unified Dimensional Model that simplifies analytical access to business–critical data, and how to publish and collaborate on findings using SQL Server 2008 R2 Reporting Services and SharePoint 2010 Excel Services.
- How to use PowerPivot to load and prepare disparate data sources, and produce rich and responsive reports.
- How to publish and manage PowerPivot reports in SharePoint 2010.
- How to use SQL Server 2008 R2 Analysis Services to create data mining models that explore, uncover and predict patterns in a data.
- How to use Excel 2010 ProClarity Professional Desktop for advanced data analysis and visualization.
- How to build dashboards in SharePoint 2010 that expose business–critical information in compelling ways.
- How to use SharePoint 2010 PerformancePoint Services to provide integrated performance management solutions with scorecard and analysis functionality.
Course Outline Summary
Day 1
Module 01: Microsoft BI Strategy Overview
- Defining Business Intelligence (BI); Introducing the Microsoft BI Platform; Introducing the BI Developer’s Toolset; Introducing Adventure Works Cycles Company
Module 02: Introduction to Dmensional Modeling Techniques
- Designing the Dimensional Model; Introducing Additional Design Concepts
Lab 02A – Database Modeling (Creating the Reseller Sales Database Diagram)
Module 03: Introduction to ETL Using Integration Services
- Reviewing ETL Fundamentals; Introducing SSIS Components; Designing ETL Packages
Lab 03A – Control Flow (Loading the Sales Quota Fact Table, Part 1)
Lab 03B – Data Flow (Loading the Sales Quota Fact Table, Part 2)
Module 04: Advanced Integration Services Features
- Advanced Data Flow; Manageability Features; Programmability
Lab 04A – Slowly Changing Dimensions (Loading the Employee Dimension)
Day 2
Module 05: Introduction to Reporting Services
- Reporting Fundamentals; Introducing Reporting Services; Basic Report Design
Lab 05A – Managed Reports (Authoring a Report for Publication)
Module 06: Advanced Reporting Services Features
- Introducing Report Interactivity; Extending Reports with Custom Logic; Optimizing Report Execution; Securing Report Server Items and Data; Delivering Reports with Subscriptions
Lab 06A – Advanced Managed Reports (Enhancing the Report Design)
Lab 06B – Advanced Reporting Services Features (Managing and Distributing Reports)
Module 07: Enabling Self–Service Reporting
- Developing Report Models; Introducing Report Builder 1.0; Creating Reports with Report Builder 1.0; Introducing Report Builder 3.0
Lab 07A – Report Builder 1.0 (Self Service Reporting and Data Exploration)
Lab 07B – Report Builder 3.0 (Self–Service Reporting)
Module 08: Programming with Reporting Services
- Reviewing Report Deployment Options; Accessing Reports in SSRS; Accessing Reports Programmatically; Embedding Reports in .NET Applications
Lab 08A – Programmatic Report Deployment (Using the RS Utility)
Lab 08B – The ReportViewer Control (Embedded Reporting)
Day 3
Module 09: Developing and Managing a Unified Dimensional Model
- Reviewing OLAP Fundamentals; Understanding Database Components; Performance Tuning; Programming Analysis Services
Lab 09A – The Cube Wizard (Building the Reseller Sales Cube)
Lab 09B – Dimension Design and Dimension Usage (Enriching and Optimizing the Dimension Space)
Lab 09C – Calculations, KPIs and Actions (Enriching the Cube Space)
Lab 09D – Dimension and Cube Processing (Managing Data Processing)
Lab 09E – Cube Deployment (Developing an Installer Package)
Module 10: Reporting from the Unified Dimensional Model
- Accessing the UDM from Reporting Services; Accessing the UDM from Excel 2010; Accessing the UDM from ProClarity Desktop 6.3
Lab 10A – UDM Reporting with Reporting Services (Developing a Static Report for Reuse)
Lab 10B – UDM Reporting with Excel and Excel Services (Developing Interactive Reports for Reuse)
Lab 10C – UDM Reporting with ProClarity Desktop 6.3 (Advanced Data Analysis)
Day 4
Module 11: Analyzing and Reporting with PowerPivot
- Introducing PowerPivot; Loading and Preparing Data; Developing PowerPivot Reports; Introducing DAX; Managing PowerPivot Workbooks in SharePoint
Lab 11A – Loading and Preparing Data (Loading and Relating Disparate Data)
Lab 11B – Creating PowerPivot Reports (Developing an Interactive Report)
Lab 11C – Defining DAX Calculations (Enriching the PowerPivot Model)
Lab 11D – Managing PowerPivot Solutions in SharePoint (Sharing and Managing the PowerPivot Model)
Module 12: Introducing Analysis Services Data Mining
- Introducing Data Mining; Integration with SQL Server 2008 R2 Components; Data Mining Programmability
Lab 12A – Embedded Data Mining (Applied Mining for Meaning)
Lab 12B – Integrated Data Mining (Integrating Mining Results with SQL Server)
Day 5
Module 13: Building Dashboards in SharePoint 2010
- Reviewing Dashboard Fundamentals; Understanding the BI Features
Lab 13A – SharePoint Dashboard Design (Assembling Consolidated Information)
Module 14: Monitoring and Analyzing with PerformancePoint Services
- Reviewing Performance Management Fundamentals; Introducing PerformancePoint Services; Building Scorecards; Configuring Reports; Building and Deploying Dashboards
Lab 14A – PerformancePoint Monitoring (Defining KPIs and Scorecards)
Lab 14B – PerformancePoint Analyzing (Assembling and Deploying a Dashboard)
Stedsbeskrivelse
IT-Fornebu
Påmelding
Microsoft Business Intelligence BI: SQL Server 2008 R2 and Office 2010
Microsoft Business Intelligence BI: SQL Server 2008 R2 and Office 2010
Start her
100% sikkert skjema
Tar ett minutt å fullføre
Hurtig respons
Felt som er merket med * må fylles ut
Åpen deltakerdiskusjon om kurset eller emnet
Del gjerne din erfaring eller tanker om dette kurset eller temaet med andre!