"Advanced SQL Server 2005 Analysis Services SSAS DURATION 3 days List price £1250 excl VAT Course code SQL0100 Course Objectives This course has been written to give delegates with existing s"
Advanced SQL Server 2005 Analysis Services (SSAS) DURATION 3 days List price £1250 (excl. VAT) Course code SQL0100 Course Objectives What You Will Learn This course has been written to give delegates with 1. Cube design best practises and security existing skills in Data Warehousing with SQL Server a framework of best practises. 2. A deep understanding of MOLAP / ROLAP / HOLAP Delegates will gain a deep understanding of Cubes, 3. MDX Queries and Scripts Star Schemas, and Data Mining, using SQL Server 2005 Analysis Services (SSAS). 4. Learn how to use XMLA to create, process and back-up Cubes Delegates should have attended our 3-day introduction to SSAS, or have equivalent commercial experience. 5. Effective Data Mining Schedule SQL Server 2005 Analysis Services – A audience Pre-requisite skills: schedule Freephone 0800 028 6400 Closer Look Understand Table, column, data for public schedule, or see type design, and write SQL Select www.jbinternational.co.uk SQL Server 2005 Analysis Services is statements within any relational Microsoft’s premier Business Intelligence database; product and is rapidly overtaking Cognos and Business Objects long-held dominant Write SQL Server stored onsite Onsite / Customised skills procedures. Available as a customised position as market leader. A product any course for your company. serious developer cannot afford to ignore. Populate a Star Schema; Design, Delivered onsite or at our build and deploy simple SSAS London offices. cubes with the Cube Wizard. Advanced SSAS Course Using SSIS with SSAS Cube actions Star schema stored procedures in an Syllabus Aggregation design Drill through (as opposed to drill down) SSIS package MOLAP/ROLAP/HOLAP Displaying reports directly from cube in a SSAS cube processing in SSIS Degree of aggregation pivot table Deploying and scheduling an SSIS Optimising aggregations Writing values back into the cube package Query log Cube security Using SSRS with SSAS Hierarchies design Dimension security Introduction to SSRS report wizard Attribute hierarchies Cell-level security Generating MDX queries to report on a Natural hierarchies Administration and user roles cube Report hierarchies Generating DMX queries to report on a Multiple hierarchy dimensions Cube storage and processing data mining model More on MOLAP/ROLAP/HOLAP MDX language Creating partitions Cube design Creating calculated members and Incrementally updating partitions Creating a data source measures Pro-active caching (real-time cubes!) Creating a data source view MDX queries introduction Slowly changing dimensions Creating simple dimensions and MDX scripts measures KPIs (key performance indicators) Cube deployment and administration SSAS stored procedures overview Backing up and restoring cubes Dimension design Deployment and processing options Building standard dimensions Localising cubes Time dimensions Currency conversion XMLA and AMO languages Role-playing dimensions Local language cube captions Introduction to XMLA Parent-child dimensions Local language cube dimension XMLA to create cubes members XMLA to back up cubes Measure group design XMLA to process cubes Adding measures Folders and perspectives AMO to control cubes Configuring dimension usage (for Organising large cubes into folders multiple fact table cubes) Segmenting large cubes with Data mining Aggregation functions perspectives Overview of data mining Calculated measures Building mining models Measure formatting Processing mining models