Microsoft 70-466: Implementing Data Models & Reports With Sql Server 2012
Original price was: £295.00.£99.00Current price is: £99.00.
Course Description
Microsoft SQL Server 2012 is the one of the latest versions of Microsoft SQL Server, the extremely popular and widely used database system in the world.
This course prepares students for the 70-466: Implementing Data Models and Reports with SQL Server 2012 exam. The course focuses on creating managed enterprise BI solutions and covers how to implement multidimensional and tabular data models, delivering reports with Microsoft SQL Server Reporting Services, creating dashboards with Microsoft SharePoint Server Performance Point Services, and discovering business insights by using data mining.
Who is this course aimed at?
This course is intended for database professionals who need to fulfil a Business Intelligence Developer role to create analysis and reporting solutions.
By choosing online learning instead of a classroom based course, it eliminates the need for time away from work, saving you valuable time and money. It is ideal for those with tight schedules as our online courses give you 12 months unlimited access to all the course materials, so you can study at a pace that suits you. Allowing you to easily resume your studies whenever you have the time. All you need is internet connection to study, so you can study from the comfort of your home or any environment that suits you.
What is included in this course?
When you enrol, you’ll not only gain powerful, career-enhancing skills but also receive exclusive benefits, including:
Course Assessment Process
In order to earn your certification, you’ll have to sit an exam after completing your course with us. To prepare you for your exam, we provide interactive quizzes after each module and a mock exam at the end of your course to ensure you’re fully prepared for the real thing. Once you’ve passed with at least 85%, you’ll be ready to book your exam as a private candidate.
Booking your exam is pretty simple, just purchase your exam voucher and schedule your exam. To make life easier, we can help you find an appropriate exam centre and give you all the information you need to secure your place.
Please note that the exam fees aren’t included in the course price.
Got a question about exams? Contact one of our course advisors. We’re happy to help!
Requirements
Our training works on all devices including Mobile phones, IPad’s, Android tablets, Macs and PC’s.
For the best viewing experience on our state-of-the-art eLearning platform we recommend an internet connection of 10Mbps or better. Please also use Google Chrome or Mozilla Firefox as your browser with Adobe Flash Player.
Career Path
We’ve put together a list of relevant job titles you can apply for after achieving the Microsoft 70-466: Implementing Data Models & Reports with SQL Server 2012 certification (note that some careers may require further study, training and/or work experience):
- Database Administrator
- Database Developer
- Database Analyst
Course Outline
Module 1: Introduction to Business Intelligence and Data Modeling
- 1.1 Introduction to Business Intelligence and Data Modeling Part 1
- 1.2 Introduction to Business Intelligence and Data Modeling Part 2
- 1.3 The Microsoft Business Intelligence Platform Part 1
- 1.4 The Microsoft Business Intelligence Platform Part 2
- 1.5 The Microsoft Business Intelligence Platform Part 3
- 1.6 The Microsoft Business Intelligence Platform Part 4
Module 2: Implementing Reports The SQL Server Reporting Services
- 2.1 Implementing Reports the SQL Server Reporting Services Part 1
- 2.2 Implementing Reports the SQL Server Reporting Services Part 2
- 2.3 Implementing Reports the SQL Server Reporting Services Part 3
- 2.4 Implementing Reports the SQL Server Reporting Services Part 4
- 2.5 Implementing Reports the SQL Server Reporting Services Part 5
- 2.6 Implementing Reports the SQL Server Reporting Services Part 6
- 2.7 Implementing Reports the SQL Server Reporting Services Part 7
- 2.8 Implementing Reports the SQL Server Reporting Services Part 8
Module 3: Supporting Self Service Reporting
- 3.1 Supporting Self Service Reporting Part 1
- 3.2 Supporting Self Service Reporting Part 2
Module 4: Managing Report Execution and Delivery
- 4.1 Managing Report Execution and Delivery
- 4.2 Managing Report Execution
- 4.3 Subscriptions and Data Alerts
Module 5: Creating Multidimensional Databases
- 5.1 Creating Multidimensional Databases
- 5.2 Creating Data Sources and Data Source Views
- 5.3 Creating and Browsing a Cube
Module 6: Working with Cubes and Dimensions
- 6.1 Working with Cubes and Dimensions
- 6.2 Sorting and Grouping Attributes
Module 7: Working with Measures and Measure Groups
- 7.1 Working with Measures and Measure Groups
Module 8: Introduction to MDX
- 8.1 Introduction to MDX
- 8.2 Adding Calculations to A Cube
Module 9: Customizing Cube Functionality
- 9.1 Customizing Cube Functionality Part 1
- 9.2 Customizing Cube Functionality Part 2
- 9.3 Customizing Cube Functionality Part 3
Module 10: Implementing A Tabular Data Model
- 10.1 Implementing A Tabular Data Model Part 1
- 10.2 Implementing A Tabular Data Model Part 2
Module 11: Introduction to DAX
- 11.1 Introduction to DAX
- 11.2 Demonstration Making a Tabular Model Part 1
- 11.3 Demonstration Making a Tabular Model Part 2
- 11.4 Using DAX
Module 12: Implementing an Analysis Services Tabular Data Model
- 12.1 Implementing an Analysis Services Tabular Data Model Part 1
- 12.2 Implementing an Analysis Services Tabular Data Model Part 2
- 12.3 Deploying A Tabular Data Model
Module 13: SQL Analysis Services
- 13.1 SQL Analysis Services Part 1
- 13.2 SQL Analysis Services Part 2
Module 14: Creating Data Visualizations with Power View
- 14.1 Creating Data Visualizations with Power View
Module 15: Supporting Self Service Reporting
- 15.1 Supporting Self Service Reporting
Module 16: Performing Predictive Analysis with Data Mining
- 16.1 Performing Predictive Analysis with Data Mining
- 16.2 Using the Data Mining Wizard
Module 17: Predictive Analytics
- 17.1 Predictive Analytics Part 1
- 17.2 Predictive Analytics Part 2
Payment Options
Pay securely online by debit or credit card or PayPal. Buying for your team? Talk to us about team training.
Student Reviews
There are no reviews for this course yet.
