|
Business Intelligence Fundamental Learning Objectives: Knowledge of Business Intelligence fundamentals, how to assess opportunities to enhance an enterprise business intelligence, and understand the key facets of business cases for a successful Business Intelligence initiative. Learn the six steps to launching a successful Business Intelligence project, along with techniques to avoid typical pitfalls (with tips in Schema choice, Data sourcing, Vendor selection, performance tuning, Data mining, Extranets, etc). Understanding of techniques to manage data quality, privacy and security Bill Chadwick, PMI 40 hours |
Report Development and Deployment using Open Source Open Source Reporting allows organizations to easily access, format, and distribute information to employees, customers, and partners. Reporting provides access to information in relational, OLAP, or XML-based data sources, and delivers output in popular formats including Adobe PDF, HTML, Microsoft Excel, Rich Text Format, or plain text. Comprehensive formatting capabilities give report designers the ability to highlight exceptions, create groupings, and add totals and subtotals. The course focuses on the knowledge and hands-on skills needed to create, customize, deploy and secure reports. Labs emphasize report layout and organization, data source parameterization, grouping, calculations, conditional formatting and charting. Doug Vucevic, M. Eng 40 hours | |
|
Microsoft Data Warehouse Using SQL 2005 Server The goal of the course is to teach how to design and build a successful Microsoft DW/BI system. The course will provide Microsoft-specific detailed guidance for working through the data warehouse lifecycle, from requirements gathering and design through the ETL system, relational data warehouse, OLAP and data mining applications, to reporting and other BI applications. SQL Server 2005, Microsoft provides a complete suite of tools to build data warehouse and business intelligence systems. This course prepares students to deal with the many facets of developing, deploying, operating, and growing the Microsoft data warehouse system Doug Vucevic, M. Eng 40 hours |
Building Analytic Solutions with Open Source OLAP-based applications form the core of most business intelligence solutions, providing decision-makers throughout an organization with access to relevant summarized information and a convenient method of navigation. This course provides students with the practical knowledge needed to design, build and implement OLAP-based solutions using open source Kettle, Mondrian and BI platform. The focus is on development of essential skills, including the ability to design a basic star schema and populate it using Kettle ETL, the knowledge required to create an OLAP schema definition as well as the techniques required to configure end-user access over the web and through Excel. The basics of OLAP security and performance optimization and more... Doug Vucevic, M. Eng 40 hours | |
|
Textbooks:
| ||