This course is specifically for participants to gain the knowledge and skills for making the appropriate job role decisions around implementing data models and reports with Microsoft SQL Server 2012.
This course is designed for BI Developers who most-likely focus on hands-on work creating the BI solution including implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making. Primary responsibilities may include but are not limited to:
•Working with large data sets across multiple database systems•Cube/warehouse/views fundamentals•Data model decisions: Unified Dimension Model (UDM) versus Business Intelligence Semantic Model (BISM)•Develop Cubes and Multidimensional Expressions (MDX) queries to support analysts•Online Analytical Processing (OLAP) cube performance•Building pivot tables from cubes•Building PowerPivot solutions•Design and test report models, layouts and templates•Manage reporting system: configuration and subscriptions•Using report builder to create reports•Develop complex SQL queries for reports•Building reports Using CrescentThis training course on implementing data models and reports with Microsoft SQL Server 2012 prepares participants for the Microsoft Exam 70-466.
This course will provide all the skills and knowledge for the following areas:
•Designing dimensions and measures•Implementing and configuring dimensions in a cube•Designing a schema to support a cube architecture•Creating measures•Implementing a cube•Creating Multidimensional Expressions (MDX) queries•Implementing custom logic in a data model•Implementing storage design in a multidimensional model•Selecting an appropriate model for data analysis•Analyzing data model performance•Processing data models•Troubleshooting data analysis issues•Deploying SSAS databases•Installing and maintaining an SSAS instance•Configuring permissions and roles in a Business Intelligence Semantic Model (BISM)•Implementing a tabular data model•Implementing business logic in a tabular data model•Implementing data access for a tabular data model•Designing a report•Implementing a report layout•Configuring authentication and authorization for a reporting solution•Implementing interactivity in a report•Troubleshooting reporting service issues•Managing a report environment•Configuring report data sources and datasetsWe create the highest quality course curriculum possible, ensuring you receive the training and knowledge needed to succeed.
