Providing Technology Training and Mentoring For Modern Technology Adoption
This instructor-ledcourse provides students with the knowledge and skills to develop Microsoft End-to-End business solutions using SQL Server 2008 R2 in an integrated environment with SharePoint 2010 and Office 2010. The course introduces the students to Microsoft Unified Data Model, SQL 2008 R2 Analysis Services, Integration Services, Reporting Services, Report Builder 3.0, SharePoint 2010 Integration, and the Business Intelligence Center, PerformancePoint Services, Business Connectivity Services, Dashboard Designer, Excel Services, Power Pivot and Data Mining.
The intention of this course is to allow a business to more accurately understand the scope of a BI project, the resources, the potential pitfalls, and the state of the art and perhaps most importantly understand why it may produce for an organization an unmatched competitive edge.
After completing this course, students will be able to:
BI Project managers, BI Developers, I.T. Professionals, end-user ombudsman, BI analyst
This course was designed from the perspective of team immersion drawing on the author’s 20 plus years in IT and over 10 years in Business Intelligence/OLAP Reporting and dashboard design. This course will expose team members to all aspects of the Microsoft BI stack from the source data through the reporting of the data be it in a subscribed report or through an interactive digital dashboard.
Before attending this course, students should have:
Lab : The Business Intelligence Stack
Lab : Unified Data Model
Lab : Lab SSIS Projects
Lab : Lab SQL Server Analysis Services
Lab : Lab SQL Server Reporting Services
Lab : MDX (Optional Module)
Lab : PerformancePoint Services 2010
Lab : Excel Services 2010
Key Terms in Data Mining
Lab : Lab Excel 2010 and Data Mining BI
Utilize the Excel Data Mining Tools