Microsoft Business Intelligence (BI)

SQL 2005/2008 BI Data and Report Analysts  SQL 2008 BI Implementation for IT Pros  SQL 2005 BI Implementation for IT Pros  SQL 2005 BI Architecture for IT Pros

PerformancePoint Server 2007for IT Pros  Crystal Reports 2008 BI Data and Report Analysts  Crystal Reports 11 BI Data and Report Analysts

SQL 2005/2008 BI for Data and Report Analysts

Building Reports & Analyzing Data Using MS SQL 2005/2008 Business Intelligence for Finance, Marketing, Report, and Data Analysts (SSAS, SSRS) (3 Days)

The purpose of this 3-day course is to teach Data and Report Analysts how to create dynamic reports, pivot tables and dashboards using Microsoft SQL 2005 Business Intelligence data.

After completing this course, students will be able to:

• Understand Business Intelligence and Cube Terminology as well as OLAP Data Flows, Dimensions and Dimensional Data
• Build Basic Cubes for Reporting using Microsoft Analysis Services
• Enhance cubes and reports using Cube Perspectives, Drillthough Actions, Calculated Measures and KPI’s
• Use MDX and SQL Queries to Build Reports using Microsoft Business Intelligence
• Development Studio Report Designer
• Use Table, Matrix and Chart Report Types in Reporting Services
• Use Office Excel 2007 to create Pivot Tables that use both Transact SQL queries and cubes as a data source
• Create a digital dashboard using Reporting Services and SharePoint 2007 as well as a web page using the Report Viewer Control in Visual Studio

Building SharePoint 2007 Dashboards using Microsoft SQL 2005/2008 Business Intelligence and Excel Services (MOSS, SSAS, SSRS) (3 days)

The purpose of this 3-day course is to teach Data and Report Analysts how to create dynamic digital dashboards using BI applications such as Microsoft Analysis Services 2005, Office SharePoint 2007, SQL Reporting Services, Excel 2007 and Excel Services. Using these applications, students will go through the entire KPI, dashboard and report building process—from identifying report data and building basic cubes to creating intuitive digital dashboards that use MDX, KPIs, OLAP reports, charts and calculated members within Office SharePoint and Excel 2007.

After completing this course, students will be able to:

• Build SharePoint Dashboards using multiple data sources that include MS Analysis Services cubes, SQL database queries and Excel workbooks.
• Understand Business Intelligence Dashboard and Cube Terminology.
• Build Cubes for KPI and dashboard Reporting using MS Analysis Services.
• Understand how to use Excel Services with SharePoint dashboards.
• Understand how to configure and secure SharePoint Excel Services
• Use and configure Excel 2007 ODC connections for use within SharePoint Dashboards, KPIs and Excel Services
• Use Office Excel 2007 to create Pivot Tables, Pivot Charts and KPIs that use MDX queries and cubes as a data source for SharePoint dashboards.
• Create Office Excel workbooks with OLAP based pivot tables and KPIs that can be viewed as a web page for distribution via Excel Services.
• Create a digital dashboard using MS Reporting Services (SSRS) and Office SharePoint 2007.
• Understand how to distribute reports when using MS Reporting Services (SSRS) with SharePoint.
• Understand how to track report views, report processing and dashboard use.

Building Actionable Business Intelligence using Microsoft SQL 2005/2008 Analysis Services for Corporate Network Security and Law Enforcement Personnel (SSAS, SSIS) (4 days)

The purpose of this 4 day course is to teach Corporate Network Security personnel and Law Enforcement investigators how to build actionable intelligence from unstructured enterprise and non enterprise data sources. Using Microsoft Analysis Services, Integration Services, Data mining and MDX, students will go through the entire data analysis process.

After completing this course, students will be able to:

• Use Microsoft SQL Analysis Services (SSAS), Data Mining and Microsoft SQL Server to build Actionable Intelligence from loosely coupled data and analyze data for criminal and/or case investigations.
• Use Microsoft SQL Server Integration Services (SSIS) for manipulating, importing and updating structured and unstructured case data received from public and private sources.
• Build data flow diagrams for Analysis Services Cubes using server logs, call trace logs, public information and other network resources.
• Build Analysis Services Cubes based on firewall, router and transit logs for packet tracking and analysis.
• Convert, correlate and understand IIS (Internet Information Services) web site logs, services, security and application logs as they pertain to data and database connections
• Use SSIS to import and correlate unstructured data relationships using data from Active Directory domain security logs, firewall logs and other sources.
• Import geospatial data into Mapping software for better correlation and analysis
• Build Basic Data Mining Models using Cube, database and imported data sources for use in Data Analysis.
• Use Analysis Services and Office Excel 2007 Data Mining tools to Analyze data
• Create Pivot Tables, Pivot Charts and KPIs that use Analysis Services MDX queries and cubes as a data source.
• Create Key Case Indicators (KPIs) using MDX that will give you automatic notifications for specific triggers.
• Publish Cube based Case Data securely for analysis by security personnel

Building & Writing MDX Queries, Calculated Members, and KPI's using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)

The purpose of this Learn IT! exclusive 3-day course is to teach Data and Report Analysts how to create dynamic digital dashboards using BI applications such as Microsoft Analysis Services 2005, Office SharePoint 2007, SQL Reporting Services, Excel 2007 and Excel Services.

After completing this course, students will be able to:

• Understand Business Intelligence and Cube Terminology as well as OLAP Data Flows, Dimensions and Dimensional Data
• Build Basic Cubes for KPI Reporting using Microsoft Analysis Services
• Create Business based Key Performance Indicators (KPIs)
• Create Calculated Members within Microsoft Analysis Services and use Calculated Members to enhance KPIs
• Use MDX functions such as ParallelPeriod and PrevMember to enhance reports and KPIs
• Enhance cubes and reports using Drillthrough Actions
• Use MDX syntax and queries to Build Reports using Microsoft Business Intelligence Development Studio Report Designer
• Use Office Excel 2007 to create Pivot Tables, Pivot Charts and KPIs that use MDX queries and cubes as a data source
• Create Excel workbooks with OLAP based pivot tables and KPIs that can be viewed as a web page for distribution via Excel Services and Office SharePoint 2007
• Create a digital dashboard using Reporting Services and Office SharePoint 2007 as well as a web page using the Report Viewer Control in Visual Studio

back to top

SQL 2008 BI Implementation for IT Pros

6234/2791 - Implementing and Maintaining MSSQL Server 2008 Analysis Services Custom Course (4 Days)

This four-day instructor-led course teaches students how to implement an Analysis Services solution in an organization.

After completing this course, students will be able to:

• Describe how SQL Server Analysis Services can be used to implement analytical solutions
• Create multidimensional analysis solutions with SQL Server Analysis Services
• Implement dimensions and cubes, measures and measure groups in an Analysis Services solution
• Query and maintain a multidimensional Analysis Services solution
• Customize an Analysis Services cube
• Deploy and secure an Analysis Services database
• Implement a Data Mining solution

6235/2792 - Implementing and Maintaining MS SQL Server 2008 Integration Services (3 Days)

This three-day instructor-led course teaches students how to implement an Integration Services solution in an organization.

After completing this course, students will be able to:

• Describe SQL Server Integration Services and its tools
• Create an Integration Services package
• Implement control flow, data flow, and logging in an Integration Services package
• Debug and implement error handling in an Integration Services package
• Implement checkpoints and transactions in an Integration Services package
• Deploy, manage, and secure an Integration Services package

6236/2793 - Implementing and Maintaining MS SQL Server 2008 Reporting Services Intense (2 Days)

This two-day instructor-led course teaches students how to implement a Reporting Services solution in an organization.

• After completing this course, students will be able to:
• Describe SQL Server Reporting Services and its components
• Create and enhance a Reporting Services report
• Create and manipulate data sets
• Use report models to implement reporting for business users
• Configure report publishing and execution settings
• Implement subscriptions for reports
• Administer Reporting Services
• Implement custom Reporting Services applications

back to top

SQL 2005 BI Implementation for IT Pros

MCDBA 2791A - Implementing and Maintaining MS SQL Server 2005 Analysis Services Custom Course (4 Days)

This four-day instructor-led Learn IT! exclusive course teaches students how to implement an Analysis Services solution in an organization.

After completing this course, students will be able to:

• Describe how SQL Server Analysis Services can be used to implement analytical solutions
• Create multidimensional analysis solutions with SQL Server Analysis Services
• Implement dimensions, measures and measure groups in an Analysis Services solution
• Query and maintain a multidimensional Analysis Services solution
• Customize an Analysis Services cube
• Deploy and Secure an Analysis Services database
• Implement a Data Mining solution

MCDBA 2792A - Implementing and Maintaining MS SQL Server 2005 Integration Services (3 Days)

This three-day instructor-led course teaches students how to implement an Integration Services solution in their organizations.

After completing this course, students will be able to:

• Describe SQL Server Integration Services and its tools
• Create an Integration Services package
• Implement control flow, data flow, and logging in an Integration Services package
• Deploy, debug and implement error handling in an Integration Services package
• Implement checkpoints and transactions in an Integration Services package
• Manage and secure an Integration Services package

MCDBA 2793A - Implementing and Maintaining MS SQL Server 2005 Reporting Services Intense (2 Days)

This two-day instructor-led course teaches students how to implement a Reporting Services solution in their organizations.

After completing this course, students will be able to:

• Describe SQL Server Reporting Services and its components
• Create enhance, and administer a Reporting Services report
• Create and manipulate data sets
• Use report models to implement reporting for business users
• Configure report publishing and execution settings
• Implement subscriptions for reports
• Implement custom Reporting Services applications

back to top

SQL 2005 BI Architecture for IT Pros

MCDBA 2794 - Designing a Business Intelligence Solution Architecture for the Enterprise Using MS SQL Server 2005 (2 Days)

The purpose of this two-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a BI solution architecture.

After completing this course, students will be able to:

• Capture the business and technical requirements for a Business Intelligence solution architecture
• Describe the major stages and requirements of a Business Intelligence project lifecycle
• Determine Business Intelligence development requirements and implement a Business Intelligence development project
• Assess and design a Business Intelligence infrastructure
• Describe and plan Business Intelligence operations and their management

MCDBA 2795 - Designing an ETL Solution Architecture Using MS SQL Server 2005 (2 Days)

The purpose of this 2-day instructor-led course is to teach Business Intelligence (BI) professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution.

After completing this course, students will be able to:

• Plan data transfer and staging solutions for an ETL operation
• Plan an SSIS Solution
• Design and implement data flows
• Incorporate logging, error handling, and reliability into a package
• Optimize an SSIS solution
• Deploy and operate an SSIS solution

MCDBA 2796 - Designing an Analysis Solution Architecture Using MS SQL Server 2005 Analysis Services (3 Days)

The purpose of this three day course is to teach business intelligence (BI) professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution.

After completing this course, students will be able to:

• Capture the business and technical requirements for an analysis solution
• Design and implement a logical Online Analytical Processing (OLAP) solution architecture
• Design physical storage for a multidimensional solution
• Create calculated members and named sets
• Implement Key Performance Indicators (KPIs), actions, and stored procedures
• Design the infrastructure for an OLAP solution
• Deploy and secure an Analysis Services solution in a production environment
• Monitor and optimize an Analysis Services solution
• Implement a data mining solution

MCDBA 2797 - Designing a Reporting Solution Architecture Using MS SQL Server 2005 Reporting Services (2 Days)

The purpose of this 2 day course is to teach Business Intelligence (BI) professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution.

After completing this course, students will be able to:

• Design a reporting solution
• Develop a reporting solution
• Collaborate with application developers to complete reporting and analytical interfaces
• Deploy and manage a Reporting Services solution
• Design security for a Reporting Services solution
• Optimize report execution performance

back to top

PerformancePoint Server 2007 for IT Pros

Microsoft Performance Management allows customers to monitor, analyze, and plan their business as well as drive alignment, accountability, and actionable insight across the entire organization. It allows all of the functionality that is needed for performance management including scorecards, dashboards, management reporting, analytics, planning, budgeting, forecasting, and consolidation. The application reaches all employees, across all business functions (finance, operations, marketing, sales, and human resources). 

50141 - Microsoft Office PerformancePoint Server 2007 Technical Training (4 days)

This four-day, instructor-led workshop provides students with the knowledge and skills to architect and build Business Intelligence (BI) solutions by using Microsoft Office PerformancePoint Server 2007

After completing this course, you will be able to:

• Recognize where PerformancePoint Solutions fit into the Microsoft BI Solution stack
• Create end-to-end planning applications
• Create end-to-end M&A applications
• Integrate PerformancePoint Server applications with other BI technologies
• Build scorecards and dashboards

back to top

Crystal Reports 2008

Crystal Reports 2008 Design I (2 days)

Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2008 enhances report building and report processing techniques with a slew of features that add value to your presentation. In this course, you will create a basic report by connecting to a database and modifying its presentation.

After completing this course, students will be able to:

• Explore the Crystal Reports interface.
• Create a basic report and modify it.
• Use formulas for filtering data.
• uild a parameterized report.
• Group report data.
• Enhance a report.
• Create a report using data sourced from an Excel database.
• Distribute data.

Crystal Reports 2008 Design II (2 days)

Until now, you have used Crystal Reports to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, you will create complex reports and data sources using Crystal Reports' tools. You will not only create more sophisticated reports including subreports and cross-tabs, but you will also increase the speed and efficiency of your reports by using SQL queries.

After completing this course, students will be able to:

• Create automatic and manual running totals.
• Work with cross-tab reports.
• Add subreports.
• Create drill-downs in a report.
• Use SQL statements in report processing.
• Create complex formulas.
• Add charts to reports.
• Enhance report functionality.

back to top

Crystal Reports 11

Crystal Reports 11 Design I (2 days)

Level 1 is the primary recommended course you should take if your job responsibilities require you to obtain output from databases. It is also the first course in the Crystal Reports XI series. In this course, you will build basic list and group reports that work with almost any database.

After completing this course, students will be able to:

• Create a report by using data from an existing database.
• Use a report to present specific data in the desired order.
• Create groups to summarize report data.
• Build formulas to calculate and display data.
• Format reports.
• Add and modify elements in a report.
• Create single data series charts.
• Distribute report data.

Crystal Reports 11 Design II (2 days)

Now that you have completed the first course, or are familiar with the basics of building and modifying reports, you're ready to move ahead to create complex reports and data sources using Crystal Reports' tools. In this course, you'll not only learn how to create more sophisticated reports including subreports and cross-tabs, but you'll also learn how to increase the speed and efficiency of your reports by using SQL queries.

After completing this course, students will be able to:

• Create running totals in a report.
• Build cross-tabs in your report.
• Add subreports to a report.
• Design a report that uses a drill-down.
• Improve processing speed in your reports.
• Chart single and multiple data series.
• Report from Excel data.
• Implement report prompts.
• Enhance report functionality.

back to top

Contact Us

about our courses.
for your team.

Live Chat by LivePerson

San Francisco: 415.693.0250
Santa Clara: 408.200.0953