Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (eBook)

Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model (eBook)
🔍 Click to enlarge photo
List Price: $47.99 Our price: $40.79 You save $7.20! (15% OFF)
Product Type: Digital Product
Qty
Build agile and responsive Business Intelligence solutions

Analyze tabular data using the BI Semantic Model (BISM) in Microsoft SQL Server 2012 Analysis Services - and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you'll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on book shows you how the tabular model's in-memory database enables you to perform rapid analytics - whether you're a professional BI developer new to Analysis Services or familiar with its multidimensional model.

Discover how to:
  • Determine when a tabular or multidimensional model is right for your project
  • Build a tabular model using SQL Server Data Tools in Microsoft Visual Studio 2010
  • Integrate data from multiple sources into a single, coherent view of company information
  • Use the Data Analysis eXpressions (DAX) language to create calculated columns, measures, and queries
  • Choose a data modeling technique that meets your organization's performance and usability requirements
  • Optimize your data model for better performance with xVelocity storage engine
  • Manage complex data relationships, such as multicolumn, banding, and many-to-many
  • Implement security by establishing administrative and data user roles