Course Details
Course Outline
1 - Introduction to Business Intelligence and Data Modeling
Define the Basics of Business Intelligence Get to Know the Microsoft Business Intelligence PlatformLab: Explore a BI Solution
2 - Creating Multidimensional Databases
Apply Multidimensional AnalysisCreate Data Sources and Data Source ViewsDeploy a CubeLearn About Cube SecurityLab: Create a Multidimensional Database
3 - Working with Cubes and Dimensions
Configure DimensionsDefine Attribute HierarchiesSort and Group AttributesLab: Work with Cubes and Dimensions
4 - Working with Measures and Measure Groups
Work with MeasuresPractice Using Measure GroupsLab: Configure Measures and Groups
5 - Introduction to MDX
Navigate the Fundamentals of MDXAdd Calculations to a CubeQuery a Cube Using MDXLab: Work with MDX
6 - Customizing Cube Functionality
Implement Key Performance IndicatorsApply Actions, Perspectives and TranslationsLab: Customize a Cube
7 - Implementing a Tabular Data Model by Using Analysis Services
Define and Create Tabular Data ModelsWork with an Analysis Services Tabular Model in an Enterprise BI SolutionLab: Work with an Analysis Services Tabular Data Model
8 - Introduction to Data Analysis Expression (DAX)
Master the Basics of DAXUse DAX to Create Calculated Columns and Measures in a Tabular Data ModelLab: Create Calculated Columns and Measures using DAX
9 - Performing Predictive Analysis with Data Mining
Gain an Introduction to Data MiningNavigate the Data Mining Add-In for Excel Create a Custom Data Mining SolutionValidate a Data Mining ModelConnect to and Consume a Data Mining SolutionLab: Practice Data Mining
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
Target Audience
If you’re a BI developer responsible for creating enterprise BI solutions, this course is perfect for you. You’ll also benefit from this course if you are a power information worker or data analyst.
Other Prerequisites
We want you to get the most value possible out of your SQL Server training. To maximize your time taking this course, you should have a basic understanding of the Microsoft Windows operating system and its core functionality. You should also have experience working with Transact-SQL and relational databases.
If you don’t feel ready to jump into this course quite yet, we suggest that you complete 20761 Querying Data with Transact SQL before taking this course.