MISSION

supervised and delivers only the official training programs for more than 3000 Courses and 480 Certificates, through 30 dedicated Learning Centers in Egypt, Kuwait, and UAE.....

Read more   

learning process

partner of the most world's technology leaders such as: Microsoft, Cisco, Math-Works, CompTia, WiMax, CWNP, Oracle, EC-Council, CIW, Symantec, ETS, Parametric, PearsonVUE, and more ...

Read more   

Warm welcome

WE aimed to improve and develop the human resources to be qualified for job Opportunities. By assure quality through the four basic elements of learning process (Official curriculum, Expert Teaching Staff, Hand-ON labs, Suitable Environment)...

Read more   

Quality assurance

our quality control and montoring system is added value, allow our customers watching the secure cams 24/7, performance and evaluate the training progress. ...

Read more   
Nada Youssef
Date: 2012-11-10
nice site... More...
Ahmed Ali
Date: 2012-11-10
I like the site design, it's sweet .. simple ... well organized. Hope to see next projects... More...
Maha el Said
Date: 2012-11-11
Very Helpful and very organized company...it opens its doors for people who are willing to learn and develop their designing abilities.... More...
mohamed saad
Date: 2012-11-28
it\'s very nice website go ahead..... More...

  • Category: Microsoft Office
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Adobe
    Date: 2012-11-12
                                    Play

  • Category: Entercaps Traning Center
    Date: 2012-11-11
                                    Play
  • Photoshop CS5-The Missing Manual
    Photoshop CS5-The Missing Manual
    DOWNLOAD
  • Photoshop CS6 For Dummies
    A dobe Photoshop is one of the most impo
    DOWNLOAD
  • Pro .NET Best Practices
    Pro .NET Best Practices
    DOWNLOAD
  • Hardening Cisco Routers
    Hardening Cisco Routers
    DOWNLOAD
   Implementing Data Models and Reports with Microsoft SQL Server 2012

Admission

This course is intended for database professionals who need to fulfill a Business Intelligence Developer role to create analysis and reporting solutions. Primary responsibilities include:

•Implementing reporting solutions by using SQL Server Reporting Services.

•Implementing multidimensional databases by using SQL Server Analysis Services.

•Creating tabular semantic data models for analysis by using SQL Server Analysis Services.

•Create visualizations of data by using PowerView.

•Create data mining solutions by using SQL Server Analysis Services.


Implementing Data Models and Reports with Microsoft SQL Server 2012
Exam # Duration Language Level Type Classroom Code Fees
70-466 45 English Professional Course Classroom Cs203 0 LE
Description :

Business intelligence (BI) is becoming increasingly important for companies of many different sizes and types because of the competitive edge it can help to give them. The combined capabilities of Microsoft SQL Server 2012 and Microsoft SharePoint 2010 make it easier than ever for companies to develop a BI solution that meets their specific needs, provides reduced total cost of ownership (TCO), and achieves a faster time to solution. This five-day 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 PowerView and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.



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.
  • Use Data Mining for Predictive Analysis.


Topics :

Introduction to Business Intelligence and Data Modeling

  • Introduction to Business Intelligence
  • The Microsoft Business Intelligence Platform

Implementing Reports with SQL Server Reporting Services

  • Introduction to Reporting Services
  • Creating a Report with Report Designer
  • Grouping and Aggregating Data in a Report
  • Showing Data Graphically
  • Filtering Reports by Using Parameters
  • Publishing and Viewing a Report

Supporting Self Service Reporting

  • Introduction to Self Service Reporting
  • Shared Data Sources and Datasets
  • Report Parts

Managing Report Execution and Delivery

  • Managing Report Security
  • Managing Report Execution
  • Subscriptions and Data Alert
  • Troubleshooting Reporting Services

Creating Multidimensional Databases

  • Introduction to Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Overview of Cube Security

Working with Dimensions

  • Configuring Dimensions
  • Defining Attribute Hierarchies
  • Sorting and Grouping Attributes

Working with Measures and Measure Groups

  • Working with Measures
  • Working with Measure Groups

Introduction to MDX

  • MDX Fundamentals
  • Adding Calculations to a Cube
  • Using MDX to Query a Cube

Customizing Cube Functionality

  • Working with Key Performance Indicators
  • Working with Actions
  • Working with Perspectives
  • Working with Translations

Implementing a Tabular Data Model with Microsoft PowerPivot

  • Introduction to Tabular Data Models and PowerPivot Technologies
  • Creating a Tabular Data Model by Using PowerPivot for Excel
  • Sharing a PowerPivot Workbook and Using PowerPivot Gallery

Introduction to DAX

  • DAX Fundamentals
  • Using DAX to Create Calculated Column and Measures in a Tabular Data Model

Implementing an Analysis Services Tabular Data Model

  • Introduction to Analysis Services Tabular Data Model Projects
  • Developing an Analysis Services Tabular Data Model in SQL Server Data Tools

Creating Data Visualizations with Power View

  • Introduction to Power View
  • Visualizing Data with Power View

Performing Predictive Analysis with Data Mining

  • Overview of Data Mining
  • Creating a Data Mining Solution
  • Validating a Data Mining Solution
  • Consuming a Data Mining Solution




Recommended Knowledge :

Before attending this course, the student should have:

•At least 2 years’ experience of working with relational databases, including: ?Designing a normalized database. ?Creating tables and relationships. ?Querying with Transact-SQL.

•Some basic knowledge of data warehouse schema topology (including star and snowflake schemas).

•Some exposure to basic programming constructs (such as looping and branching).

•An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable.

Recommended Course(s) :

Training Materials :

Microsoft Official Courseware (MOC)


Labs :

This course includes several labs to ensure you will gain the targeted skills and experience


Credential :
Category :
DataBase


The Instructor: