End to End Microsoft BI with SQL 2008 R2 and SharePoint 2010
50511AC (Class Pack)
Course Duration: 5 Days
About This Course
At Course Completion
- Describe the entire Microsoft Business Intelligence stack and the role of each component so that a better informed estimate of resources might be made in the BI project.
- Explain the concept of the Unified Data Model, understand its limitations and practical implementations and when it might be appropriate to use in a fast and low cost BI deployment.
- Explain what SQL 2008 and the R2 release change in Microsoft BI and how best to leverage these technologies.
- Gain a good working knowledge of SQL Integration Services and with that knowledge understands why the Extract Transform and Load process may go through 40 percent or more of the entire project budget.
- Finally get an explanation of Multidimensional space in SQL Server Analysis Services that can be comprehended by us mere mortals and with that knowledge learn how to get the domain experts such as HR or Marketing to communicate what they really need to know about the business.
- Learn to plan for the on-going maintenance and changing nature of BI projects and then their rapid expansion across the enterprise.
- Data without visualization is of limited value. In this course you will experience the terrific new report design interface Report Builder 3.0 and also the PerformancePoint Services one-click application Dashboard designer.
- You will learn to use these tools to design reports in either ad-hoc mode or for distribution once or scheduled on subscriptions.
- You will explore the Dashboard designer and see the ease of which you can create scorecards, filters, KPIs and dashboards.
- Understand the roll of PowerPivot in Microsoft BI. PowerPivot is the big development with Excel 2010 and SQL Server 2008 R2. You will learn where it fits, how to use it and what effect it will have on the present and future of your Microsoft BI investment.
- Excel rules the land of the MBA! Here we will explore Excel Services 2010 and you will be able to successfully implement a “Single version of the Truth workbook” deployment.
- The course ends with a walk through Data Mining which could easily be a standalone five day course. You will learn where to use which Microsoft Algorithm to solve which type of a business problem.
- A working knowledge of RDBMS
- A working knowledge of Business Intelligence Studio
- A working knowledge of Excel and the Office Ribbon
- Understanding of the goals of Business Intelligence
|Course OutlineModule 1: The Business Intelligence StackLessons
To help you prepare for this class, review the following resources: