Implementing Data Models and Reports with Microsoft SQL Server 2012 New Horizons Singapore

    Course details

    This course describes how to empower information workers through self-service analytics and reporting. Students will learn how to implement 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.

    Course Outline

    • Lesson 1: Introduction to Business Intelligence and Data Modeling
    • Lesson 2: Implementing Reports with Reporting Services
    • Lesson 3: Supporting Self-Service Reporting
    • Lesson 4: Managing a Reporting Infrastructure
    • Lesson 5: Creating Multidimensional Databases
    • Lesson 6: Working with Cubes and Dimensions
    • Lesson 7: Working with Measures and Measure Groups
    • Lesson 8: Introduction to MDX
    • Lesson 9: Customizing Cube Functionality
    • Lesson 10: Implementing a Tabular Data Model by Using Microsoft PowerPivot
    • Lesson 11: Introduction to Data Analysis Expression (DAX)
    • Lesson 12: Implementing an Analysis Services Tabular Data Model
    • Lesson 13: Creating Data Visualizations With Power View
    • Lesson 14: Performing Predictive Analysis with Data Mining

    Prerequisites

    In addition to their professional experience, students who attend this training should have technical knowledge equivalent to the following course:

    • 10774A: Writing Queries with Microsoft SQL Server Transact-SQL
    Updated on 08 November, 2015

    About New Horizons Singapore

    Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business

    See all New Horizons Singapore courses
    Are you from New Horizons Singapore ? Claim your course!
    Courses you can instantly connect with... Do an online course on SQL Server starting now. See all courses

    Is this the right course for you?

    Rate this page

    Didn't find what you were looking for ?

    or