Written and presented by industry experts, this intensive five-day workshop gives professional developers the information and hands-on experience they need to deliver state-of-the-art, integrated reporting and analytics solutions using Microsoft Business Intelligence. 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 realtime 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 32 practical hands-on labs to build a complete BI solution by the end of the workshop. Ingen planlagte afholdelser Nr.: 88879 A DKK 27.950,- ekskl. moms Deltagerprofil This workshop is designed for professional developers with little or no experience building BI solutions. It is for professional developers who work for an ISV, SI, or enterprise customer or those interested to understand and evaluate Microsoft's Business Intelligence offerings. If you already have extensive experience building solutions on the Microsoft BI platform, you may find parts of this workshop to be a review of material that you are already familiar with. You are recommended to have active development experience with C# and/or VB.NET, basic understanding of Excel, SQL and relational database technology. 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, 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. Indhold Module B01: Defining Business Intelligence (BI) - Introducing the BI Platform, the BI Developer's Toolset, and Adventure Works Cycles Company - Designing the Dimensional Model; Introducing Additional Design Concepts Module B02: Designing ETL Solutions with Integration Services - Reviewing ETL Fundamentals; Introducing Integration Services Components; Designing ETL Packages Module B03: Introducing Advanced Integration Services Features - Advanced Data Flow; Manageability Features; Programmability Module C01: Developing Analysis Services Cubes and Dimensions - Reviewing OLAP Fundamentals; Understanding Database Components Module C02: Processing and Deploying Analysis Services Solutions - Performance Tuning; Programming Analysis Services Module C03: Developing Analysis Services Data Mining Models - Introducing Data Mining; Integration with SQL Server 2008 R2 Components; Data Mining Programmability Module D01: Introducing Reporting Services - Reporting Fundamentals; Introducing Reporting Services Module D02: Authoring Reporting Services Reports - Basic Report Design; Introducing Report Interactivity; Extending Reports with Custom Logic; Introducing Report Builder 3.0 Module D03: Delivering Ad Hoc Reporting With Report Builder 1.0 - Developing Report Models; Introducing Report Builder 1.0; Creating Reports with Report Builder 1.0 Module D04: Managing and Delivering Reporting Services Reports - Optimizing Report Execution; Securing Report Server Items and Data; Delivering Reports with Subscriptions Module D05: Programming Reporting Services - Accessing Reports in Reporting Services; Accessing Reports Programmatically; Embedding Reports into .NET Applications Module E01: Creating and Sharing Reports with Excel - Introducing the Excel analytic features; Working with PivotTables and PivotCharts; Introducing the CUBE functions; Working with Excel Services Module E02: Working with PowerPivot - Introducing PowerPivot; Loading and Preparing Data; Developing PowerPivot Reports; Introducing DAX; Managing PowerPivot Workbooks in SharePoint Module E03: Creating Dashboards with PerformancePoint Services - Reviewing Performance Management Fundamentals; Introducing PerformancePoint Services; Building Scorecards; Configuring Reports; Building and Deploying Dashboards Module E04: Creating SharePoint Dashboards - Reviewing Dashboard Fundamentals; Introducing the SharePoint BI Features Module E05: Advanced Cube Analysis with ProClarity Desktop Professional - Accessing the UDM from ProClarity Desktop 6.3 Dejan Sarka Dejan Sarka is a Solid Quality Mentor and holds many industry distinctions including MCP, MCDBA, MCT, MCTS SQL Server, MCITP Database Administrator, MCITP Database Developer, and SQL Server MVP. As a trainer and consultant, he has assisted many CPLSs and development companies in Slovenia and around the world. In addition to this, he continuously works on OLTP, OLAP and Data Mining projects, especially at the design stage. He is a speaker at many important international conferences such as TechEd, PASS and MCT conference. He is the founder of the Slovenian SQL Server Users Group and collaborates with Microsoft TechNet meetings, NT conferences and many other events in Central and Eastern Europe. Dejan has teamed up with Itzik Ben-Gan to author chapters in two books; "Inside Microsoft SQL Server 2005" and "T-SQL Querying and Inside Microsoft SQL Server 2005 - T-SQL Programming". Dejan has also developed two courses for Solid Quality Mentors, Data Modeling Essentials and Data Mining with SQL Server 2005. He also regularly writes articles for Red Gate Simple Talk. For yderligere information kontakt Produktansvarlig, Mette Hougaard Holm Email: mette.holm@teknologisk.dk Godkendt: 18. januar 2011 |
