You are previewing Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube.
O'Reilly logo
Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube

Book Description

Learn how to build dimensions and cubes in the SQL Server 2012 development environment

  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results.

  • Create your own SQL Server development environment

  • Full of practical tutorials on cube design and development

  • Learn how to efficiently administrate and manage your SQL Server instance

In Detail

Microsoft SQL Server Analytical Services, or SSAS, is an analytical processing OLAP tool which allows users to analyze business data quickly and easily.

In this book you will get started with SQL Server cube development. You will start by learning how to install SQL Server 2012 and create a development environment. You will then finish by diving into the development and design of dimension and cubes in SQL Server.

This book starts by jumping into the new and important features of Microsoft SQL Server 2012. Afterwards we will run through the installation of SQL Server then how to check the validation of SQL Server and security consideration during and after installation.

After you have SQL Server running, you will get started with SQL Server cube development, first by creating a development environment, then by developing and designing dimensions and cubes in SQL Server.

Moving on to administration and user management of SQL Server 2012 you will then build your own SQL Server development environment and create your own dimensions and cubes. You will then finish with a journey through further tutorials and guidance on continuing and progressing with SSAS cube development.

Table of Contents

  1. Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
    1. Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
    2. Credits
    3. About the Author
    4. About the Reviewer
    5. www.packtpub.com
      1. Support files, eBooks, discount offers and more
    6. packtlib.packtpub.com
      1. Why Subscribe?
      2. Free Access for Packt account holders
    7. 1. Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube
      1. So, what are SSAS 2012 dimensions and cube?
        1. What is SSAS?
        2. Why do we need SSAS?
        3. SSAS 2012 architecture
          1. The tabular model
          2. The multidimensional model
        4. The future of Analysis Services
        5. What's new in SSAS 2012?
          1. Ease of use
          2. Compatibility with PowerPivot
          3. Processing performance characteristics
        6. What is SSAS dimension?
        7. What is SSAS cube?
      2. Installation
        1. Step 1 – designing the installation
        2. Step 2 – deploying SQL Server 2012
          1. What do we need?
          2. Deployment of SQL Server 2012
        3. Step 3 – confirming the security considerations before a SQL Server deployment
          1. Firewalls
          2. Enlarging physical security
          3. Running individual services
          4. Disabling the NetBIOS and SMB
          5. Use NTFS for a secure filesystem
        4. Step 4 – checking security considerations during or after deployment of SQL Server
      3. Quick start – getting started with the peripherals of SSAS 2012
        1. SQL Server 2012 supplementary peripherals
          1. Analysis Services
            1. Deploying and configuring Analysis Services
            2. The tabular model
            3. The multidimensional and data mining model
          2. Reporting Services
            1. Deploying and building Reporting Services
        2. Administrating and creating a SQL Server instance
          1. General
          2. Memory
          3. Processors
          4. Security
          5. Connections
          6. Database Settings
          7. Advanced
          8. Permissions
        3. Administrating user management and server roles
          1. SQL login
            1. SQL Server Authenticated login
            2. The Windows Authentication login
            3. Certificate authentication
            4. Asymmetric keys
        4. Developing dimensions in a SQL Server scenario
          1. Creating a dimension in a SQL Server development scenario
          2. The attribute relationship
        5. Developing cubes in a SQL Server scenario
          1. Creating a cube in a SQL Server development scenario
          2. Cube attribute properties
      4. Top 5 features you need to know about
        1. Always-on availability group
        2. Column index store
        3. Big data support
        4. Contained databases
        5. Power View
      5. People and places you should get to know
        1. Official sites
        2. Articles and tutorials
        3. Community