The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.
At Course Completion
- Describe the components, architecture, and nature of a BI solution
- 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 database
- Use DAX to query a tabular model
- Use data mining for predictive analysis
Who is the target audience?
- Implementing multidimensional databases by using SQL Server Analysis Services
- Creating tabular semantic data models for analysis by using SQL Server Analysis Services
Microsoft Official Courses
Microsoft Official Courses On-Demand (MOC On-Demand) are authorized Microsoft official courses exclusively developed by Microsoft Certified Trainers. MOC on-demand delivers a comprehensive training experience comprising a merge of high-quality audiovisuals, academic readings, Microsoft labs online and knowledge check/assessments.
MOC on-demand is a self-paced training structured for IT Professionals and Developers which makes them proficient in the Microsoft technology and develop technical skills. It focusses on providing you a live, real-time environment for hands-on training while including all the interactive features with credible content that other On-demand offerings lack.
MOC On-Demand comprises a range of courses which are structured in a modular format consisting different modules that are further segregated into lessons, each of which contains questions to testify your knowledge.
MOC On-Demand - Features that make it the best
An online course structure which gives you utmost flexibility to learn.
Official Microsoft content
HD-quality streaming videos with interactive content delivered by expert instructors -“straight from the source”.
Digital Microsoft Official Curriculum
Access to the official curriculum anywhere & anytime.
Hands-on live labs
Microsoft Labs Online to work on your technical skills with integrated lab steps.
Knowledge check and instant feedback to mark your stand in the training process.
Microsoft-hosted mentors available to you round the clock via chat, email, & phone.
Authored by Microsoft certified experts
In-depth technical content structured by individuals who wrote the software and delivered by expert instructors.
Module 1: Introduction to Business Intelligence and Data Modeling
Module 2: Creating Multidimensional Databases
Module 3: Working with Cubes and Dimensions
Module 4: Working with Measures and Measure Groups
Module 5: Introduction to MDX
Module 6: Customizing Cube Functionality
Module 7: Implementing a Tabular Data Model by Using Analysis Services
Module 8: Introduction to Data Analysis Expression (DAX)
Module 9: Performing Predictive Analysis with Data Mining
What you’ll get in your subscription
Full access to the official Digital Microsoft Official Courseware (dMOC)
Microsoft’s HD-quality streaming videos
Access to Hands-On, Live Lab
Microsoft Training Support 24*7
Exercises, Readings and Knowledge checks
Experience of querying data using Transact-SQL