Training Course:sql server 2005 business intelligence: integration services and analysis servicesSchool/Trainer:hands on technology transfer, inc.
chelmsford, ma, united states
Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Term: 5 days
Fee: $2495
Course Description:
'' this hands-on course walks students through the complete data warehousing and data mining process. students will design and create data warehouses using microsoft sql server 2005. then the business intelligence development studio (bids) will be used to create sql server integration services (ssis) routines to move records from a relational database into the data warehouse. once the data warehouse is populated, the data will be explored using sql server analysis services (ssas). bids will again be used to create cubes to support business decisions. hands-on exercises will use the cubes to develop key performance indicators (kpi) and custom performance measures. additional exercises will demonstrate how to update and manage cubes. analysis service’,s support of data mining is also covered, and hands-on labs will configure data mining algorithms to search for patterns and trends in the data. in addition to using ssis to support data warehouses, students will also complete labs that demonstrate how to use the etl utility to move data in and out of sql servers. this includes exercises that import and export data between excel spreadsheets, access databases, xml files, flat files and sql server. techniques to clean data will also be demonstrated, such as finding duplicate records or performing look-ups in5?s. other exercises will merge data from multiple sources, as well as splitting data to multiple destinations. troubleshooting and security configurations for these business intelligence services are incorporated throughout the course. ...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.traininghott.com
Phone:1-800-413-0939
School Address/Venue(s):
14 fletcher street
1 village square, suite 8
Jobs & Resumes: chelmsford
Houses & Roommates: chelmsford
Search other schools for sql server 2005 business intelligence: integration services and analysis services training resources.
Other training courses offered by hands on technology transfer, inc.:
Microsoft Transact-SQL Programming
Java Programming
ASP.NET 3.5 Programming Using VB.NET
Windows Forms 3.5 Programming Using Visual Basic.NET
Advanced .NET Framework Programming Using VB.NET
Advanced ASP.NET Application Development Using VB.NET and AJAX
Microsoft SQL Server 2008 Administration
sql server 2005 reporting services
SQL Server 2005 Business Intelligence Application Development (SSRS, SSIS, SSAS)
Windows Server 2008 Administration
Windows Server 2008 Active Directory and Security Design
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed. |
|
|
