Freigeben über

SQL Academy Training for February and March

  • Artikel

SQL Acad

SQL Academy is a series of FREE Level 300 Technical ‘how to’ training seminars. Half-day instructor-led training seminars give attendees exclusive access to DEEP technical training delivered by the best of local and international subject matter experts.
Suitable for: IT pros, DBAs, Database Architects and Infrastructure Teams who are responsible for configuring SQL Server infrastructure

Location: Microsoft Ireland Building 2 (EPDC2), South County Business Park, Leopardstown, D18

 

SQL Academy Module III: SQL Server Analysis Services (16 February 2010)

Register @ https://www.tinyurl.ie/8c

‘SQL Server Analysis Services’ will follow on from the popular “101” session covering an introduction to analysis services. This session covers intermediate-level SQL Server Analysis Services 2008 topics and is suitable for BI developers and consultants who have some familiarity with basic Analysis Services concepts.
Agenda:

1. Modelling complex dimensions and measure groups with Analysis Services. In this session we’ll discuss how to handle more complex modelling scenarios in Analysis Services.

2. Security. This session will cover all aspects of Analysis Services security.

3. Implementing calculations with MDX. Last of all we’ll take a look at how you can improve the analytic capabilities of your cube by adding MDX calculations to it.

 

SQL Academy Module IV: SQL 2008 R2 – Next Generation Business Intelligence (23 March 2010)

Register @ https://www.tinyurl.ie/8d

‘SQL 2008 R2 – Next Generation Business Intelligence’, will provide demos and an overview of key Business Intelligence features included in SQL Server 2008 R2 which has just been released for the Community Technology preview (CTP).
Agenda:

1. Reporting Enhancements . This session focused on the new Report Builder 3.0 which is now available for download and demonstrations on the new functionality such as MAP based features and other enhancements such as Lookup functions, RDL sandboxing, data feeds and editing improvements.

2. Project Gemini I - Excel 14 BI Engine. In memory analytics is the fastest growing area within business intelligence. This session is a demo based walk through of radically different approach to business intelligence introduced with Project Gemini.

3. Project Gemini II – MOSS and Analysis Services. This session focuses on improvements in Analysis Services to support Project Gemini and publishing of business intelligence models to highly interactive and flexible portals. We will also demo how Analysis Services has been enhanced to allow for monitoring of In Memory data models.