Wellington 6-7 December 2012 | Auckland 10-11 December 2012
This two-day course is designed to up-skill IT professionals on the BI capability of SQL Server 2012.
This seminar is appropriate for those interested in learning more about the following:
BI in SQL Server 2012
integration with SharePoint 2010
The new tabular project BI Semantic Model
Enhancements to the in-memory capabilities with PowerPivot
Reporting data alerts
The course will be led by BI consultant and trainer Peter Myers. Peter is an esteemed international speaker and holds the elite distinction of being a Microsoft SQL Server MVP specialising in BI.
The first day is classroom-based and covers theory, methodology and demos. The second day is hands-on labs. Both days will feature local case studies presented by Microsoft partners and customers.
The course level is 200-300 and is designed to be an “incremental” presentation. Attendees that have worked with some SQL Server 2008 R2 BI products will have an advantage, but those without background will still get value out of the course. The labs are level 300, but are well guided and informative for those with no background with SQL Server.
Microsoft SQL Server 2012, released on 2 April 2012, is a cloud-ready information platform that will help organisations unlock breakthrough insights across the organisation and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.
The price of the course is $900 (including GST). The price includes two full days of dedicated class time with industry experts, lunch, and materials for both days.
Contact Microsoftevents@avenues.co.nz for group discounts if you are registering with more than four people from the same organisation or are a Microsoft partner with a Gold Competency in BI.
Content in the first day includes the following:
• Business update from Microsoft on the latest BI industry trends, including big data, Data Hub and more and considerations for creating your BI strategy
• Overview of Business Intelligence in SQL Server 2012
• What's New in Integration Services for SQL Server 2012
• What's New in Master Data Services for SQL Server 2012
• Introducing Data Quality Services for SQL Server 2012
• What's New in Analysis Services for SQL Server 2012
• Developing and Deploying Tabular Project BI Semantic Models
• What's New in Data Analysis Expressions (DAX) for SQL Server 2012
• What's New in PowerPivot for SQL Server 2012
• What's New in Reporting Services for SQL Server 2012
• Introducing Power View in SQL Server 2012
• Producing Reporting and Analytic Solutions Based on the BI Semantic Model
• Working with Analysis Services Data Mining for SQL Server 2012
• Discussion around how it all fits together and what BI tools suit your style
• What’s hot right now – Analytics for Twitter and other cool reports to show your stakeholders
• SQL Server licencing basics
You’ll get to enjoy the chance to use the technology on the second-day with hands-on labs which focus on the following:
• Exploring SQL Server 2012 Integration Services
• Exploring SQL Server 2012 Master Data Services
• Exploring SQL Server 2012 Data Quality Services
• Developing a SQL Server 2012 Tabular BI Semantic Model with Visual Studio 2010
• Creating a SQL Server 2012 Tabular BI Semantic Model with PowerPivot
• Exploring Data Alerts with SQL Server 2012 Reporting Services
• Optimizing a SQL Server 2012 Tabular BI Semantic Model for Power View
• Exploring SQL Server 2012 Power View
• Creating Excel 2010 Reports Based on a SQL Server 2012 Tabular BI Semantic Model
• Creating a SQL Server Reporting Services Report based on a SQL Server 2012 Tabular BI Semantic Model
• Creating a PerformancePoint Services 2010 Dashboard based on a SQL Server 2012 Tabular BI Semantic Model
• Enhancing an E-Commerce Application with Analysis Services Data Mining
• Creating an executive dashboard
• Administration of your BI infrastructure
• Concept of security roles and how to implement them with Microsoft BI stack
• Considerations for your BI infrastructure sizing (keep workloads separate, etc.)
• Reports performance considerations
• Resources to take away