Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube -- Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube -- Credits -- About the Author -- About the Reviewer -- www.packtpub.com -- Support files, eBooks, discount offers and more -- packtlib.packtpub.com -- Why Subscribe? -- Free Access for Packt account holders -- 1. Instant Microsoft SQL Server Analysis Services 2012 Dimensions and Cube -- So, what are SSAS 2012 dimensions and cube? -- What is SSAS? -- Why do we need SSAS? -- SSAS 2012 architecture -- The tabular model -- The multidimensional model -- The future of Analysis Services -- What's new in SSAS 2012? -- Ease of use -- Compatibility with PowerPivot -- Processing performance characteristics -- What is SSAS dimension? -- What is SSAS cube? -- Installation -- Step 1 - designing the installation -- Step 2 - deploying SQL Server 2012 -- What do we need? -- Deployment of SQL Server 2012 -- Step 3 - confirming the security considerations before a SQL Server deployment -- Firewalls -- Enlarging physical security -- Running individual services -- Disabling the NetBIOS and SMB -- Use NTFS for a secure filesystem -- Step 4 - checking security considerations during or after deployment of SQL Server -- Quick start - getting started with the peripherals of SSAS 2012 -- SQL Server 2012 supplementary peripherals -- Analysis Services -- Deploying and configuring Analysis Services -- The tabular model -- The multidimensional and data mining model -- Reporting Services -- Deploying and building Reporting Services -- Administrating and creating a SQL Server instance -- General -- Memory -- Processors -- Security -- Connections -- Database Settings -- Advanced -- Permissions -- Administrating user management and server roles -- SQL login -- SQL Server Authenticated login -- The Windows Authentication login.

Certificate authentication -- Asymmetric keys -- Developing dimensions in a SQL Server scenario -- Creating a dimension in a SQL Server development scenario -- The attribute relationship -- Developing cubes in a SQL Server scenario -- Creating a cube in a SQL Server development scenario -- Cube attribute properties -- Top 5 features you need to know about -- Always-on availability group -- Column index store -- Big data support -- Contained databases -- Power View -- People and places you should get to know -- Official sites -- Articles and tutorials -- Community.