Implementing Data Models and reports with Microsoft SQL Server Course overview
This course teaches students how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server Performance Point Services, and discover business insights by using data mining.
Instructor Led Learning
Duration: 5 Days
Registration Open Now!
Video Learning
Duration: 5 Days
Registration Open Now!
What you will learn
- Lesson 1 : Introduction to Business Intelligence and Data Modeling
- Lesson 2 : Exploring a BI Solution
- Lesson 3 : Creating Multidimensional Databases
- Lesson 4 : Creating a Multidimensional Database
- Lesson 5 : Working with Cubes and Dimensions
- Lesson 6 : Defining Dimensions
- Lesson 7 : Working with Measures and Measure Groups
- Lesson 8 : Introduction to MDX
- Lesson 9 : Using MDX
- Lesson 10 : Enhancing a Cube
- Lesson 11 : Implementing an Analysis Services Tabular Data Model
- Lesson 12 : Introduction to DAX
- Lesson 13 : Implementing Reports with SQL Server Reporting Services
- Lesson 14 : Enhancing Reports with SQL Server Reporting Services
- Lesson 15 : Managing Report Execution and Delivery
- Lesson 16 : Delivering BI with SharePoint PerformancePoint Services
- Lesson 17 : Performing Predictive Analysis with Data Mining
Basic computer skills
Introduction to Microsoft SQL Server
FULL COURSE OUTLINE
Join Over 10,000 Students that have studied with MasterGrade IT Now
Become Part of MasterGrade IT to Further Your Career.
