Implementing Data Models and Reports with Microsoft SQL Server 2012
BeschrijvingBusiness intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution.
This course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations…
This course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multidimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.
At Course Completion
After completing this course, students will be able to:
- Describe the components, architecture, and nature of a BI solution.
- Create reports with Reporting Services.
- Create reusable report items that simplify self-service reporting.
- Manage report execution and delivery.
- Create a multidimensional database with Analysis Services.
- Implement dimensions in a cube.
- Implement measures and measure groups in a cube.
- Use MDX Syntax.
- Customize a cube.
- Implement a Tabular Data Model in PowerPivot.
- Use DAX to query a tabular model.
- Implement a Tabular Database.
- Use PowerView to create interactive data visualizations.
- Use Data Mining for Predictive Analysis.
The Cert kit has it all: In-depth e-learning content, exam quizzes, practice test, tips and information on the exam,and even online coaching from certified professionals that know how to pass the exam. This comprehensive product saves time and money by enabling you to access all your learning tools…with one login!
- Customized e-Learning – focused on the specific certification
- Exam Quizzes – an easy way to test your knowledge
- Online Mentor – chat or mail with a technical specialist with the same certification*
- Tips & Tricks – portal of notes, tips, articles, links to communities, etc.
Efficient, kostenbewust, innovatief, met hoogste slagingspercentage opleiden bij @The Academy!