The Microsoft Business Intelligence 2010 Stack

This five-day instructor-led course 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.

After completing this course, students will be able to:

  • Describe the entire Microsoft Business Intelligence (BI) 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 (SSAS) 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 visualisation 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, Key Performance Indicators (KPI) 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

BI Project managers, BI Developers, IT 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 BI/Online Analytical Processing (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.

Elevator Pitch:

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 organisation an unmatched competitive edge. 

Before attending this course, students should have:

  • A working knowledge of Relational Database Management System (RDBMS)
  • A working knowledge of BI Studio
  • A working knowledge of Excel and the Office Ribbon
  • Understanding of the goals of BI

All our public scheduled training courses offer delegates the following facilities which are all included at no extra cost: 

  • Mini Continental Breakfast, with a choice of Croissants, Pastries, Cereals, Juices, and of course Tea and Coffee
  • Buffet Lunch
  • A Selection of Soft Beverages are available throughout the Training Day
  • Full Course Manual (Official Curriculum Courseware for Technical Courses where Designated)
  • Course Exercise Files on CD\DVD or Online
  • Course Stationery Pack (Pen, Pencil and Paper)
  • Course Certificate (Vendor Accredited where Designated)
  • FREE Internet Access during your visit (Wi-Fi as Available)

There are no records to display

Email This Page to a Friend
module by Spiral

Course Details:

Duration: 5 Days
Delivery: Instructor led
Type: Course
Setting: Classroom
Language: English
Audience: IT Professionals
Code: MS50511
Exam: -
Level: 200

Don't be Left Disappointed

The earlier you book the cheaper it is! That's our policy. The earlier you book a course online, the more likely the course is to run! We don't offer discounts for last minute bookings in fact quite the opposite. Book late and you'll end up paying the FULL price!!!

Late bookings mean we have to order extra manuals, which we have to pay express delivery charges for, additional food, that means our purchasing power is reduced, and reconfiguring rooms, which means extra time. Unfortunately all these unforeseen changes cost money which you end-up paying.

Just look how much you can save on our online listed prices the earlier you book!

  • 45 working days or more attracts an 8% reduction
  • Less than 45 working days = Full Price

Secure your place early and get a great reduction!

Early booking discounts apply to our publicly scheduled Microsoft Technical IT training courses held at our own premises. This discount will be applied to online booking(s) registrations only. Not to be used in conjunction with any other offer.
 

Get instructor-led, technical classroom training from Microsoft certified training partners.

With Software Assurance Training Vouchers you get authorised instructor-led technical training by our very own Microsoft qualified certified trainers. Using only courseware developed by Microsoft experts, these in-depth courses are designed to help your IT staff deploy, manage and support new software.

Your SA Training Vouchers are reserved for technical courses only. Examples of courses include:

  • MS10174 - Configuring and Managing Microsoft SharePoint 2010
  • MS10774 - Querying Microsoft SQL Server 2012
  • MS10135 - Configuring, Managing and Troubleshooting Microsoft Exchange Server 2010

After you complete your course, we will processes your voucher and are reimbursed by Microsoft. Unless the length of your training exceeds the training days available to you through SA, you will not be asked for payment

Need to know more about SATV’s visit: http://www.microsoft.com/licensing/software-assurance/training-vouchers.aspx Or give us a call on 0845 600 6061

Associate Microsoft Trainer

Associate with Nexgenn

As a Microsoft Certified Learning Partner we have a commitment to our customers to provide the highest level of training standards possible. To this end we continue to seek out talented individuals with a natural flair for communicating technical subject matter to a wide variety of audiences.

With customers both here in the UK and Europe, we deliver classess in native english covering a wide spectrum of products.

We are always looking to add to our existing portfolio of trainers. You must already have achieved your MCT qualification and have some commercial training delivery experience. Perhaps you may have already chosen a specialist subject to focus on such as Microsoft SharePoint Server, SQL Server, System Center, Exchange Server or generalise in Windows Server – We’d like to hear from you.

In the first instance please send us your CV to our Human Resources department. Please also include a link to your online transcript.

Need to know more about our associate program, give us a call on 0845 600 6061