- Table View
- List View
This is a practical tutorial for Analysis Services that shows readers how to solve problems commonly encountered while designing cubes, and explains which features of Analysis Services work well and which should be avoided. The book walks through the whole cube development lifecycle, from building dimensions, cubes and calculations to tuning and moving the cube into production. This book is aimed at Analysis Services developers who already have some experience but who want to go into more detail on advanced topics, and who want to learn best practices for cube design.
An easy-to-follow guide full of hands on examples of real-world Analysis Services cube development tasks. Each topic is explained and placed in context, and for the more inquisitive reader, there also more in-depth details of the concepts used. If you are an Analysis Services cube designer wishing to learn more advanced topic and best practices for cube design, this book is for you.You are expected to have some prior experience with Analysis Services cube development.
Your guide to quickly turn data into results. Transform your skills, data, and business--and create your own BI solutions using software you already know and love: Microsoft Excel. Two business intelligence (BI) experts take you inside PowerPivot functionality for Excel® 2013, with a focus on real world scenarios, problem-solving, and data modeling. You'll learn how to quickly turn mass quantities of data into meaningful information and on-the-job results--no programming required! Understand the differences between PowerPivot for Self Service BI and SQL Server Analysis Services for Corporate BI Extend your existing data-analysis skills to create your own BI solutions Quickly manipulate large data sets, often in millions of rows Perform simple-to-sophisticated calculations and what-if analysis Create complex reporting systems with data modeling and Data Analysis Expressions Share your results effortlessly across your organization using Microsoft SharePoint®
Transform your skills, data, and business--with the power user's guide to PowerPivot for Excel. Led by two business intelligence (BI) experts, you'll learn how to create and share your own BI solutions using software you already know and love: Microsoft Excel. Discover how to extend your existing skills, using the PowerPivot add-in to quickly turn mass quantities of data into meaningful information and on-the-job results--no programming required. The book introduces you to PowerPivot functionality, then takes a pragmatic approach to understanding and working with data models, data loading, data manipulation with Data Analysis Expressions (DAX), simple-to-sophisticated calculations, what-if analysis, and PowerPivot patterns. Learn how to create your own, "self-service" BI solutions, then share your results effortlessly across your organization using Microsoft SharePoint®. A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to email@example.com.
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
Get comprehensive guidance for using the Microsoft Language Integrated Query (LINQ) Project--with in-depth insights from two experienced developers. Data-rich applications can be difficult to create because of the tremendous differences between query languages used to access data and the programming languages commonly used to write applications. This practical guide covers the intricacies of LINQ, a set of extensions to the Visual C# and Visual Basic programming languages. Instead of traversing different language syntaxes required for accessing data from relational and hierarchical data sources, developers will learn how to write queries natively in Visual C# or Visual Basic--helping reduce complexity and boost productivity. Written by two experienced developers with strong ties to the developer teams at Microsoft, this book describes the LINQ architecture and classes, details the new language features in both Visual C# and Visual Basic, and provides code samples in both languages.
Dig into LINQ -- and transform the way you work with data. With LINQ, you can query data from a variety of sources -- including databases, objects, and XML files -- directly from Microsoft Visual Basic® or C#. Guided by data-access experts who've worked in depth with LINQ and the Microsoft development teams, you'll learn how .NET Framework 4 implements LINQ, and how to exploit it. Clear examples show you how to deliver your own data-access solutions faster and with leaner code. Discover how to: Use LINQ to query databases, object collections, arrays, XML, Microsoft Excel® files, and other sources Apply LINQ best practices to build data-enabled .NET applications and services Manipulate data in a relational database with ADO.NET Entity Framework or LINQ to SQL Read, write, and manage XML content more efficiently with LINQ to XML Extend LINQ to support additional data sources by creating custom operators and providers Examine other implementations, such as LINQ to SharePoint® Use LINQ within the data, business, and service layers of a distributed application Get code samples on the Web