Implementing and Maintaining Microsoft SQL Server Analysis Services New Horizons Egypt

    Course details

    About this Course Elements of this syllabus are subject to change. This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

    Objectives

    At Course Completion

    After completing this course, students will be able to:

    • Describe how SQL Server Analysis Services can be used to implement analytical solutions.
    • Create multidimensional analysis solutions with SQL Server Analysis Services.
    • Implement dimensions and cubes in an Analysis Services solution.
    • Implement measures and measure groups in an Analysis Services solution.
    • Query a multidimensional Analysis Services solution.
    • Customize an Analysis Services cube.
    • Deploy and secure an Analysis Services database.
    • Maintain a multidimensional Analysis Services solution.
    • Implement a Data Mining solution.

    Prerequisites

    Before attending this course, students must have:
    • Conceptual understanding of OLAP solutions.
    • Experience navigating the Microsoft Windows Server environment.
    • Experience with Windows services (starting and stopping).
    • Experience creating service accounts and permissions.
    • Experience with Microsoft SQL Server, including:
    • SQL Server Agent.
    • SQL Server query language (SELECT, UPDATE, INSERT, and DELETE).
    • SQL Server System tables.
    • SQL Server accounts (users and permissions).

    Course Outline

    • Module 1: Introduction to Microsoft SQL Server Analysis Services
    • Module 2: Creating Multidimensional Analysis Solutions
    • Module 3: Working with Cubes and Dimensions
    • Module 4: Working with Measures and Measure Groups
    • Module 5: Querying Multidimensional Analysis Solutions
    • Module 6: Customizing Cube Functionality
    • Module 7: Deploying and Securing an Analysis Services Database
    • Module 8: Maintaining a Multidimensional Solution
    • Module 9: Introduction to Data Mining
    Updated on 08 November, 2015

    About New Horizons Egypt

    Founded and headquartered in Anaheim, California, New Horizons Learning Centers was named the world's largest independent training company by IDC.

    The Company is both an operator and franchisor of training centers that offer a broad range of Technical Training, Desktop Application, Business Skills and English Language courses for all levels of users in multiple delivery methods and formats.

    New Horizons provides approximately three million student days of instruction annually with location around the globe.

    New Horizons sets the pace of innovative training programs that meet the changing needs of the industry. With 2400 qualified instructors in over 2100 classrooms at 300 centers in 60 counters around the world.

    New Horizons offers more courses, at more times, in more delivery methods than any other training company.

    See all New Horizons Egypt courses
    Are you from New Horizons Egypt ? 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