Menu Icon

Available Training Rooms

  • PRIVATE BATCH
  • PUBLIC PROGRAM
  • ON DEMAND
  • BLENDED

Course Details

  • Course Overview
  • Skills Gained
  • Who Can Benefit
  • Prerequisites
  • Syllabus

In this course, you will learn how to implement business intelligence solutions (PowerPivot and tabular data models), create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining. This course incorporates materials from Implementing Data Models and Reports with Microsoft SQL Server 2012 (MS-10778) and covers the skills and knowledge measured by Exam 70-466. Along with on-the-job experience, this course helps prepare you for the exam.

Components, architecture, and nature of a business intelligence (BI)solution
Create reports with Reporting Services
Create reusable report items that simplify self-service reporting
Manage a reporting infrastructure
Create a multidimensional database with Analysis Services
Implement dimensions in a cube, and measures and measure groups in a cube
Use Multidimensional Expressions (MDX) Syntax
Customize a cube
Implement a tabular data model in PowerPivot
Use Data Analysis Expressions (DAX) to query a tabular model
Implement a tabular database
Use Power View to create interactive data visualizations
Use data mining for predictive analysis
Database professionals who need to fulfill a BI developer role to create analysis and reporting solutions
Database professionals responsible for:
Implementing reporting solutions by using SQL Server Reporting Services
Implementing multidimensional databases using SQL Server Analysis Services
Creating tabular semantic data models for analysis using SQL Server Analysis Services
Creating visualizations of data by using Power View
Creating data mining solutions using SQL Server Analysis Services
Knowledge of relational databases
Basic knowledge of Microsoft Windows operating systems and its core functionality

1. Business Intelligence and Data Modeling

  • BI
  • The Microsoft BI Platform

2. Implementing Reports with Reporting Services

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

3. Supporting Self-Service Reporting

  • Report Builder
  • Creating Reusable Report Items

4. Managing a Report Execution and Delivery

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

5. Creating Multidimensional Databases

  • Multidimensional Analysis
  • Creating Data Sources and Data Source Views
  • Creating a Cube
  • Cube Security

6. Working with Cubes and Dimensions

  • Configuring Dimensions
  • Attribute Hierarchies
  • Sorting and Grouping Attributes

7. Working with Measures and Measure Groups

  • Measures
  • Measure Groups

8. Multidimensional Expressions (MDX)

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

9. Customizing Cube Functionality

  • Implementing Key Performance Indicators
  • Implementing Actions, Perspectives, and Translations

10. Implementing a Tabular Data Model by Using Microsoft PowerPivot

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

11. Data Analysis Expression (DAX)

  • DAX Fundamentals
  • Using DAX to Create Calculated Columns and Measures in a Tabular DataModel

12. Implementing an Analysis Services Tabular Data Model

  • Analysis Services Tabular Data Model Projects
  • Implementing an Analysis Services Tabular Data Model Using SQL Server Data Tools

13. Creating Data Visualizations with Power View

  • Power View
  • Visualizing Data with Power View

14. Performing Predictive Analysis with Data Mining

  • Data Mining
  • Create and Validate a Data Mining Model
  • Using the Data Mining Add-In for Excel
  • Using a Data Mining Model in a Report

Lab 1: Report and Analyze Data

Lab 2A: Create a Report with Report Designer

Lab 2B: Enhance and Publish a Report

Lab 3: Implement Self-Service Reporting

Lab 4: Configure Report Execution and Delivery

Lab 5: Create a Multidimensional Database

Lab 6: Define Dimensions

Lab 7: Configure Measures and Measure Groups

Lab 8: Use MDX

Lab 9: Customize a Cube

Lab 10: Use PowerPivot for Excel

Lab 11: Create Calculated Columns and Measures by using DAX

Lab 12: Work with an Analysis Services Tabular Data Model

Lab 13: Create Interactive Reports with Power View

Lab 14: Use Data Mining to Support a Marketing Campaign


Audience

  • Database Developer
  • Database Administrator

Public Program Schedule

Course Name Duration Brochure Location Schedule Enroll
There is no upcoming Public Batch Schedule, you can ask for Private Batch or for On-Demand Learning

Download the syllabus

Download

The highest standard, The happiest learners

Our Enterprise Clients

FAQ

  • Why should I choose RPS?
  • I am working, is it possible to arrange the classes on weekends?
  • Please confirm if your office is open on weekends?
  • Can I get the courseware in advance before start of training?
  • What are the timings (class hours)?
  • How can I make the payment?
  • What is the mode of payment?
  • Candidate authorized RPS to charge $200. But the bank has charged $208. Why is this?
  • If we need training on one of the modules only how does that work?
  • How long before do we need to book the exams?
  • Where are your training centers available?
  • Can I pay the fee in installments?
  • What are the refund policies? Can i get my money back in case i am unable to attend the training?
  • Do you provide a bank loan facility?
  • 10+ years of Training Expertise
  • Gold Learning Partner for Microsoft
  • Certified instructors with industry standard experience
  • Tailor made training available
  • 6+ training Locations
  • 100000 + professional trained
  • Customer Satisfaction
  • Reliable and Most cost effective Training

Yes, we do offer weekend classes for professionals in group or 1-to-1 Training depending upon the technology.

The administrative and sales staff works on weekdays (Monday - Friday). System Admins and Operation team are available on all days.

Yes, after you have paid the booking amount (which will be non–refundable in this case). Booking amount depends on the technology selected.

Training timings are from 9 am to 5 pm.

You can send the deposit by any of the following methods:-

  • PayPal
  • Credit Card
  • Bank Transfer
  • Demand Draft
  • Cash
  • Purchase Order (in case of Corporates / Government).
  • If you are an International student, the registration amount of USD 200 can be paid by Bank Transfer or PayPal/PayUMoney . The balance amount has to be paid by traveler's cheque or cash after arrival in India. You can also pay the balance by PayPal. There is a surcharge of 4% in this case.
  • For Indian Resident students, the course fees including registration can be paid by Cash, Cheque, Demand Draft or Bank transfer.To Know more Please call +919883305050 or Email us at info@rpsconsulting.in for any of your queries.

Overseas credit card payments through PayPal involve a mark-up of up to 4% as surcharge.

We can provide customized 1-to-1 training for a technology as per your requirement.

Most exams can be booked once you are on the course (e.g. Microsoft, ITIL, VEEAM, EC-Council). Red Hat and some other exams have to be booked in advance.

Our training centers are available in Bangalore, Chennai, Hyderabad, Pune and Delhi.

We do not have facility to pay in installments

If the course fee has been paid for and RPS cancels the Course, a refund will be provided, else the courses are non-refundable.

We do not provide loan facility.

Other Related Courses

Related courses will be updated soon...