Business Intelligence Course Descriptions
SF 1029 - Introduction to Data Warehousing and T-SQL Review
Course Length: 40 hours
This class will review data warehousing systems including backend tools for extracting, cleaning and loading data from Online Transaction Processing 9OLTP) Databases and historical repositories of data. Concepts on the data warehouse and data marts and front end tools for mining, querying, reporting on data will be explained. In addition, Transact-SQL will be reviewed.
· Intro to Transact-SQL
· Retrieving Data
· Grouping Data
· Joining tables
· Subqueries
· Modifying Data
· Dimensional Modeling Primer
· Retail Sales
· Inventory
· Procurement
· Order Management
· Customer Relationship Management
· Accounting
· Human Resources Management
· Financial Services
SF 1026 Microsoft SQL Server Integration Services
Course Length: 40 hours
This course will enable technology professionals with little or no ETL experience and minimal exposure to SQL Server 2005 and Visual Studio 2005 to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. You will be introduced to the Business Intelligence Development Studio (BIDS) and working with Control Flow and Data Flow. You will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.
· Guided tour of SSIS
· Introduction to Control Flow
· Introduction to Data Flows
· Variables and Configurations
· Advanced Control Flow
· Error logging and handling
· Advanced Data Flow
· Package Deployment
· Package Management
· Introduction to scripting and custom components
· Best Practices
· Beyond ETL – Other scenarios for SSIS
SF 1027 - Microsoft SQL Server Analysis Services
Course Length: 40 hours
In this course, you will learn how to use Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%.
· What is Business Intelligence?
· OLAP Modeling
· Creating Data Sources
· Intermediate SSAS
· Advanced SSAS
· Cube Storage and Aggregation
· Beginning MDX
· Intermediate MDX
· SSAS Administration
· Introduction to Data Mining
· Introduction to SSAS clients
· Office 2007 integration with SSAS
SF 1005 - MDX Queries
Course Length: 40 hours
This course shows data warehouse developers what they need to know to build effective multidimensional data warehouses. After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the class moves directly to providing practical examples of MDX in use.
The material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 Also it covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions.
· Introduction to MDX
· Calculated Members and Named Sets
· Common Calculations and Selections
· MDX Query Context and Execution
· Named Sets and Set Aliases
· Sorting and Ranking in MDX
SF 1003 - Microsoft SQL Server Reporting Services
Course Length: 40 hours
In this course, you will learn how to use SQL Server 2005 Reporting Services to create, execute, and manage reports. You will learn how to create tabular, matrix (cross-tab), and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. You’ll explore creating reports with groups, expressions, conditional formatting, and parameters. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll explore the deployment and printing of reports and the export of reports to PDF, Excel, and other formats. You’ll gain a thorough understanding of Reporting Services security, report snapshots, subscriptions, and the use of custom assemblies. You’ll also discover how to integrate reports into your ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API, without requiring users to use Internet Explorer. Finally, you’ll learn how to empower your users to create ad-hoc reports using Report Builder and Report Model projects.
· Introduction to SSRS
· Basic Report Creation
· Intro to Relational Data Sources
· Intro to OLAP Data Sources
· Report Calculations, Formatting and Miscellaneous Report Editing
· SSRS configuration, Deploying reports, URL syntax, and exporting
· Report Globals
· Report Parameters
· Report Expressions and Dynamic Formatting and Images
· Report Grouping and Sorting
· Advanced Relational Data Sources (using T-SQL and Stored Procs)
· Advanced OLAP Data Sources (using MDX)
· Other Data Sources (XML services)
· Matrix Control
· Basic Charting
· Advanced Charting
· SubReports
· Advanced Page Layout control
· Extending with Code
· Report Manager Overview
· Report Manager: Roles and Security
· Report Manager: Snapshots and Subscriptions
· Sharepoint Integration
SF 1037 - Business Intelligence with SharePoint and PerformancePoint Server
Course Length: 40 hours
· Introduction to PerformancePoint Server
· Performance Management
· Creating Scorecards
· Creating Reports and Scorecards
· Importing SSRS Reports
· Creating a SharePoint Site Collection
· Incorporating SSRS reports into SharePoint
· Incorporating Excel spreadsheets into SharePoint via Excel Services
· Incorporating Excel spreadsheets into PerformancePoint
For details and pricing information, click here.