Home     Trainings & Seminars     Project Management     Managing IT Outsourcing    Email Marketing    PHP Programming    Introduction to MySQL    MS SQL Server BI    Data Interpretation & Analysis    Article Library Master Trainer Vinai's articles are published in books, magazines & newspapers  7 Ways to Succeed as a Project Manager appeared in the Recruit Section of The Straits Times	Business Intelligence Using SQL Server Home > Trainings & Seminars > SQL Server for Business Intelligence   Course Date: 9-11 February, 2009 & 8-10 April, 2009 Course Duration: 3 Days - Full Time Course on SQL Server 2005 Course Contents: Using SQL Server for Strategic Business Intelligence With SQL Server 2005, you can now streamline your reporting, and derive increased benefits from advanced analysis, data mining and reporting services enterprise wide. Exploit the new features for Business Intelligence for your enterprise. Course Synopsis: This 3 days deep dive, hands on workshop focuses on companies looking to exploit the full features of SQL Server 2005. It will feature hands on sessions on understanding and using the Integration Services (SSIS), analysis features of SSAS, and the Reporting features of SSRS. The objective of the workshop is to give you an in-depth understanding of the rich BI capabilities in SQL Server 2005: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) & SQL Server Reporting Services (SSRS), and make you aware of the advanced concepts in deployment, & implementation. After this workshop, you would have gained the necessary skills and knowledge to build, manage and integrate Data Analysis, Data Mining and Advanced Reporting capabilities in your organization. Course Agenda Day 1 Effective Decision Making Introduction to Business Intelligence and SQL Server 2005 Data Marts, Dimensional Modeling, Unified Dimensional Model Introduction to Integration Services, SSIS Architecture Creating, Building and Populating Data Marts Migrating from DTS to SSIS Day 2 SQL Server Analysis Services Overview Creating Cubes Analyzing Cube Content Special features of OLAP Cubes Writing MDX Queries, MDX Scripting Data Mining Creating Data Mining models, Exploring with Data Mining Upgrading or Migrating to SS Analysis Services Day 3 Reporting Services Architecture Report Creation using Report Builder Using Reports Manager, Model Designer Managing reports on the Report Server Ad Hoc Reporting Considerations Reporting with Excel Pivot Tables and Pivot Charts Upgrading to Reporting Services Who Should Attend: Companies initiating a Business Intelligence Project SMEs planning to deploy a database for operations, reporting or decision making Companies currently on SQL Server 2000 and planning to migrate Companies using Access, Excel, Crystal Reports, etc. for Reporting Project managers, IT Product Leads, Database administrators and Programmers who are using SQL 2005, but are not aware of the full features, or are not using the rich feature set provided. Certification: Certificate of attendance would be given to participants. Materials: Notes in folders will be provided. Class Size: 8-12 participants Course Dates: Custom Courses schedule is available upon request. Profile of Intellisoft Systems and Trainer Vinai Prakash Founded in 2003, Intellisoft Systems has been providing consultancy to businesses, and training at local colleges and private institutions.  Vinai Prakash holds an MBA from Australia .  Armed with 22 years of solid management experience, he is the CEO of 2 companies in the Intellisoft Systems Group.              As the seasoned professional and master trainer at Intellisoft Systems, Vinai helps companies to improve their skills in Application Development, Databases, Business Intelligence, Project Management, IT Outsourcing & Electronic Marketing.  He does this through his Group Training and one-to-one consultation programs.   Vinai is an expert at Database programming, Database Design and teaching MySQL. He has been developing database applications since 1986 and is an expert at Microsoft SQL Server database management system & business Intelligence using MS SQL Server.     Call (65) 6296-2995 or (65) 9877-3485 to enquire about the Microsoft SQL Server 2005 training course for Business Intelligence, or email to training@intellisoft.com.sg	Subscribe to our Learning for Life Newsletter Get Exclusive Articles & Resources Not available elsewhere. Plus Training News for seminars & workshops sent direct to your mailbox  Email: Name: Our Management articles have been published in Today's Manager, a Singapore Institute of Management publication.
Telephone: (65) 9877 3485   email: info@intellisoft.com.sg   © Intellisoft Systems, 2003-2009