Implementing Data Models and Reports with Microsoft SQL Server 2012 Computek Training Center
Price: TBA

Course details

This instructor-led 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 Power View and SQL Server Reporting Services, and discover business insights by using data mining.

Course objectives

  • 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

Course Modules

  • Module 1: Introduction to Business Intelligence and Data Modeling
  • Module 2: Implementing Reports with SQL Server Reporting Services
  • Module 3: Supporting Self Service Reporting
  • Module 4: Managing Report Execution and Delivery
  • Module 5: Creating Multidimensional Databases
  • Module 6: Working with Dimensions
  • Module 7: Working with Measures and Measure Groups
  • Module 8: Introduction to MDX
  • Module 9: Customizing Cube Functionality
  • Module 10: Implementing a Tabular Data Model with Microsoft PowerPivot
  • Module 11: Introduction to DAX
  • Module 12: Implementing an Analysis Services Tabular Data Model
  • Module 13: Creating Data Visualizations with Power View
  • Module 14: Performing Predictive Analysis with Data Mining

About Computek Training Center

It is the first and largest provider of computer software and hardware training in Egypt.

We_They is fast growing training provider over 20 years of experience in the delivery of computer training.

Our organization is dedicated to provide education excellence to meet the needs of each technology, simultaneously, as customer expand designed solutions to meet his particular organization's business needs.

Also Compuek is aimed by great companies and institutions for training their human resources looking for their progress and growth, and to make HR learn this promising technology at that time. For 20 years, the center is supplying the career market by highly qualified HR members who having broad minded, acquired with high technique and capable to work on the most difficult systems by all easiness and facility.

Computek is distinguished by its remote sighted management that enjoyed advanced thinking and firmness in order to enable the trainees to get as much training as possible by easy and simple way and in fine, splendid, and very organized training halls acquired with high capability PCs that are continuously upgraded to maintain high performance.

See all Computek Training Center courses

Contact information not available.

Are you from Computek Training Center ? Claim your course!
Courses you can instantly connect with...
Querying Microsoft SQL Server New Horizons Egypt MCTS: SQL Server 2008, Database Development Helper Learning MCTS: SQL Server 2005 Helper Learning

Is this the right course for you?

Rate our content

Didn't find what you were looking for ?