During our annual Dev & IT Pro Days we will have 6 sessions that will have a SQL Server 2005 and Business Intelligence (BI) focus.
SQL / BI Sessions Day 1:
Microsoft Business Intelligence overview
Microsoft BI offering consists of SQL Server as the BI platform, and Office as the information delivery platform. This presentation will provide an overview of all of the components of the Microsoft BI offering, architectural overview, and a demonstration to provide context for the in depth session that follow.
Creating high impact Data Warehouse with Integration Services and Analysis Services
SQL Server Integration Services is a robust, scalable, high performance ETL tool in SQL Server 2005. In this session, we’ll show you how you can use Integration Services in a wide range of applications to solve large scale data integration and transformation challenges. In this session, we’ll also show you best practices for upgrading to SQL Server 2005 Analysis Services, and how to design your Analysis Services objects for enterprise scalability and performance. We will also cover a lot of new management abilities introduced in this version that will help you more easily manage your production servers.
Enterprise Reporting with SQL Server Reporting Services
SQL Server Reporting Services is the most widely used reporting system in the world. In this session, we’ll cover best practices for upgrading your reports and report server to new version, security models for managed reports as well as Report Builder. In this session you will also learn how to set up your reporting server for high availability and high performance, how to monitor your reporting production system, and learn tips and tricks of running reporting in enterprise environment.
Designing and deploying Performance Management applications with Office OBA
Office Business Applications is a set of new products focusing on performance management, built on top of SQL Server BI platform. Learn more about building and managing scorecards with Business Scorecard Manager, enabling advanced analytics with Proclarity Analytics Server. Finally, we will talk about PerformancePoint Server, the new product coming to market in summer of 2007 that will integrate scorecarding, analytics, with budgeting and planning capabilities. Attendees will learn about the roadmap and best practices for managing and deploying performance management applications.
The speakers for those sessions are:
Program Manager – Microsoft Corp
Ashvini Sharma is a Program Manager in SQL Server’s Strategy team where he’s working on various forward-looking projects. Prior to this role, Ashvini was with the SQL Server Business Intelligence team and has contributed as a tester, developer and development lead to SQL Server 7.0, 2000 and 2005, respectively. Ashvini graduated from Carnegie Mellon University in 1994.
Product Manager in the Office Business Applications – Microsoft Corp
Jake Zborowski is a Product Manager in the Office Business Applications (OBA) group responsible for the core readiness for the breadth of the Microsoft Business Intelligence product offering. Jake joined Microsoft with the acquisition of ProClarity Corporation in May 2006. Jake spent three years as a Product Marketing Manager with ProClarity Corporation in charge of product messaging and sales readiness. Jake holds a bachelor of economics degree from Albertson College and an MBA from the College of Business and Economics at Boise State University.
SQL – MOSS/BI Sessions Day 2:
MOSS 2007 Configuration of Excel Services, SSO & Data Connections – The Mac Guyver Techniques !
The new Excel Services in Microsoft Office SharePoint Server 2007 puts Excel spreadsheet calculation and rendering on the server. Excel Services enables managed and secure distribution of Excel reports, and the ability to incorporate spreadsheets into business intelligence dashboards and portals, protect the proprietary information in spreadsheets and build custom applications with Excel-based logic. This session explains Excel Services’ basic concepts and architecture in combination with Single Sign On (SSO) & Centrally managed Data Connections. After this session you will be able to understand the concepts so that you will be able to set up a Excel Services in a secure & well managed way. This session includes a conceptual introduction & Live Demo
SQL Server in 2007: Working with Vista and SQL Server SP2
SQL Server service pack 2 introduces a number of functional improvements and is required to work with the new Windows Vista operating system. This session is meant to get you up to speed quickly when working with SQL Server on the new operating system. I’ll also highlight the interesting performance and maintainability improvements in the latest service pack and demonstrate how to apply these in existing systems.
Technology Advisor – Microsoft
Director of Developer Skills – SQLskills
Bob Beauchemin is a database-centric application practitioner and architect, instructor, course author, writer, and Director of Developer Skills for SQLskills. Over the past two years he’s been teaching his SQL Server 2005 course to 500 students worldwide through the Ascend program. He is lead author of the books “A Developer’s Guide to SQL Server 2005” and “A First Look at SQL Server 2005 For Developers”, author of “Essential ADO.NET” and has written articles on SQL Server and other databases, database security, ADO.NET, and OLE DB for MSDN, SQL Server Magazine, and others.
Bob will also be available for a book signing session after his session!