Designing Business Intelligence Solutions With Microsoft SQL Server 2012 (M20467) Training
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
5 Days
-
Start date
Different dates available
The Knowledge Academy Courseware Book
Exam preperation Manual Certificate Experienced Instructor Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 8 years
Subjects
- Basic
- Server
- IT
- Basic IT training
- SQL
- Basic IT
- Planning
- Business Intelligence
Course programme
Our 5-day Designing Business Intelligence Solutions with Microsoft SQL Server 2012 course enables delegates to learn how to design and implement a BI infrastructure.
Pre-Requisites
Before attending this course, students must have:
- A basic understanding of dimensional modeling (star schema) for data warehouses.
- The ability to create Integration Services packages that include control flows and data flows.
- The ability to create a basic multidimensional cube with Analysis Services.
- The ability to create a basic tabular model with PowerPivot and Analysis Services.
- The ability to create Reporting Services reports with Report Designer.
- The ability to implement authentication and permissions in the SQL Server database engine, Analysis Services, and Reporting Services.
- Familiarity with SharePoint Server and Microsoft Office applications, particularly Excel.
Students who attend this training can meet the prerequisites by attending the following courses, or obtaining equivalent knowledge and skills:
- 10777A: Implementing a Data Warehouse with Microsoft SQL Server 2012
- 10778A: Implementing Data Models and Reports with Microsoft SQL Server 2012
Course Outline
- Module 1: Planning a BI Solution
- Module 2: Planning SQL Server Business Intelligence Infrastructure
- Module 3: Designing a Data Warehouse
- Module 4: Designing an ETL Solution
- Module 5: Designing Analytical Data Models
- Module 6: Planning a BI Delivery Solution
- Module 7: Designing a Reporting Services Solution
- Module 8: Designing a Microsoft Excel-Based Reporting Solution
- Module 9: Planning a SharePoint Server BI Solution
- Module 10: Monitoring and Optimizing a BI Solution
- Module 11: Operating a BI Solution
Exam to be taken after completing the 5 day Designing Business Intelligence Solutions with Microsoft SQL Server 2012 (M20467) course:
- Exam 70-467 - Designing Business Intelligence Solutions with Microsoft SQL Server 2012
Additional information
- Microsoft accredited training provided by the Largest Training Company Globally
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Our Microsoft training courses are fully accredited by Microsoft using latest hardware and software
- All Microsoft courses include exclusive Microsoft exam preparation guidance, course materials and pre & post course support
- Get the Career Advantage you deserve in just
- Minimise your time off work and maximise your future income by 25%
- Flexibility on dates, so book on a date that suits you!
- Microsoft certifications delivered by world class Microsoft instructors in luxury venues
- Book Online or Call 01344 203 999 to speak to a Microsoft Training advisor
Designing Business Intelligence Solutions With Microsoft SQL Server 2012 (M20467) Training