Business Intelligence Course Descriptions
SF9001 - Querying and Programming using MS SQL Server 2008 Transact SQL
Course Length: 40 hours
This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008. It also provides students with the knowledge and skills to create views and stored procedures in a Microsoft SQL Server 2008 database.
• Retrieving Data
• Grouping Data
• Joining tables
• Sub queries
• Modifying Data
• Implementing Data Integrity by Using Constraints and Triggers
• Implementing Views
• Implementing Stored Procedures
SF9002 - Advanced Querying and Programming using MS SQL Server 2008 Transact SQL
Course Length: 40 hours
The course focuses on writing and tuning queries and programming with T-SQL in SQL Server 2008. Advanced features such as recursive querying, database encryption and spatial data are discussed.
• SQL 2005 new features workshop
• SQL 2008 new features workshop
• Hierarchies and recursive querying
• Working with dates
• Concurrency and locking
• Query performance tuning
• Database security and encryption
• Spatial data
SF9004 - Microsoft SQL Server 2008 Integration Services
Course Length: 40 hours
This course will enable technology professionals with little or no ETL experience to be comfortable and productive with the SSIS tools and technologies. In this course you will learn about the Business Intelligence Development Studio (BIDS) and working with Control and Data Flows to build workflows to extract, transform, and load data using a variety of data sources, transformations, and destinations. 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
• Control Flow
• Data Flows
• Variables and Configurations
• Advanced Control Flow
• Error logging and handling
• Advanced Data Flow
• Package Deployment
• Package Management
• Scripting and custom components
• Best Practices
• Going Beyond ETL
SF9003 - Data Warehousing Fundamentals
Course Length: 40 hours
The course primarily focuses on dimensional modeling, considerations and common pitfalls in the design process. Case studies from several industries will be discussed from a design perspective to give the participants a broad framework of understanding of the dimensional modeling process.
• Dimensional Modeling Primer
• Retail Sales
• Inventory
• Procurement
• Order Management
• Customer Relationship Management
• Accounting
• Human Resources Management
• Financial Services
SF9006 - Microsoft SQL Server 2008 Analysis Services
Course Length: 40 hours
In this course, you will learn how to use Microsoft SQL Server 2008 Analysis Services (SSAS) to design and implement On Line 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 2008 developer the tools to build data cubes and forecasting solutions. This course also provides information on end-user tools including Microsoft Excel 2007, Office Visio 2007 Professional Edition.
• What is Business Intelligence?
• OLAP Modeling
• Using SSAS in BIDS
• Intermediate SSAS
• Advanced SSAS
• Cube Storage and Aggregation
• Introduction to MDX Queries
• MDX Expressions
• Introduction to Data Mining
• SSAS Administration
• Advanced Administration and Optimization
• Introduction to SSAS clients
SF9007 - 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. It also 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
SF9009 - Microsoft SQL Server 2008 Reporting Services
Course Length: 40 hours
In this course, you will learn how to use SQL Server 2008 Reporting Services, explore its basic architecture and gain a basic understanding of the components of SSRS 2008. You’ll then explore tabular and list reports that employ datasets and data regions. As you progress you’ll learn to add custom expressions, custom functions and format your reports using Visual Studio 2008 and SQL Server 2008 Business Intelligence Studio. The reports you create in the course will employ shared data sources, interactive sorting, and drill-down capabilities. You’ll then understand how Reporting Services parameters work and create parameters in ad-hoc SQL. Next you’ll be building Matrix reports and charts then explore the use of Reporting Services gauges. The deployment of Reporting Services projects follow using a variety of formats and client-side printing. You’ll gain knowledge of SSRS Security in managing user roles and accounts. You’ll also discover how to view reports 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.
• Introducing SQL Server Reporting Services
• Creating Tabular and List Reports
• Calculation and Formatting
• Grouping and Sorting
• Working with Parameters
• Creating Matrix Reports and Charts
• Managing Reporting Services
• Security
• Programming Reporting Services
• Advanced Reporting Services Programming
• Snapshots and Subscriptions
• Ad-Hoc Reporting with Report Builder 2.0
SF9013 - Integrating BI and PowerPivot with SharePoint 2010
Course Length: 40 hours
This course provides a foundation of the different ways to render SQL Server relational and OLAP data into SharePoint 2010. The course will demonstrate using PerformancePoint Services for creating SharePoint dashboards, KPI scorecards, analytic charts and analytic reports/grids. You will learn how to publish reports, charts, and maps created using SQL Server Reporting Services 2008R2 (including Report Builder 3.0) in SharePoint 2010. You will learn how to create Excel PivotTables and PivotCharts using Excel Services 2010, create self-service BI applications using PowerPivot 2010 and publish the content to SharePoint 2010.
• SharePoint Administration and configuration steps for PerformancePoint Services, Reporting Services Integration, Excel Services Integration, and PowerPivot integration
• PerformancePoint Services Scorecards
• PerformancePoint Services Analytic Reports, Charts, Filters, Dashboard pages, and deployment
• Creating SSRS Reports and charts using Business Intelligence Development Studio
• Creating SSRS Reports and charts and maps using Report Builder 3.0 in SQL Server 2008R2
• Deploying reports to SharePoint
• Scheduling SSRS reports for automatic delivery (subscriptions and data-driven subscriptions)
• Excel Services 2010
• Creating PowerPivot content
• PowerPivot DAX Formula Expressions
• Deploying PowerPivot to SharePoint
• SharePoint PowerPivot Galleries
For details and pricing information, click here.