This update contains number of bug fixes for PowerPivot for Excel 2010.

Amazon US Amazon UK Amazon Canada

Over 50 tips and tricks for analytical modeling using Business Intelligence Semantic Models with SQL Server 2012 and PowerPivot

Overview

• Develop tabular models for personal use
• Learn about the modeling techniques which are required to overcome commonly encountered problems and master advanced modeling scenarios
• Understand the techniques required to promote personal models to corporate enterprise environments and manage the models in a corporate environment
• Learn tips and tricks for querying tabular models and learn how to access the data within them for dynamic reporting including the development of interactive workbooks

Amazon US Amazon UK Amazon Canada

Build better business intelligence with this practical guide to creating Excel data models with PowerPivot

Overview

• Learn something new in an Instant! A short, fast, focused guide delivering immediate results
• Detailed, step-by-step interactive tutorial guide to learning PowerPivot
• Carefully organized topics for users of all levels
• Learn how to make your data accessible and attractive

In Detail

Microsoft PowerPivot is a free software designed to enhance Microsoft Excel. It allows the user to make extensive use of his/her computer’s powers to draw data from various sources, do analysis across millions of rows of data, and present results in a very unique format.

Instant Creating Data Models with PowerPivot How-to to is a concise and to-the-point guide that helps you get a jump start on using this strong business intelligence tool, while still working in an environment similar to Excel. You will begin with data generation and manipulation, learning a new feature at each step by building onto the old file, and ultimately creating a comprehensive file.  

Instant Creating Data Models with PowerPivot How-to to will guide the user through database installation, importing data from various sources, creating pivot charts and tables, utilizing a unique feature of PowerPivot called slicers,adding custom columns, and setting custom relationships between data to generate the ultimate customized dataset for analysis. By the end of the book and all the sections of Microsoft PowerPivot for Excel, the reader will be fully experienced and ready to utilize this powerful software.

What you will learn from this book

• Install a database and import/export data freely
• Collect and combine data across various sources and formats
• Understand relationships between various data
• Develop complex tables and models for future analysis
• Design meaningful charts and tables easy for everyone to understand
• Write custom codes to modify data to a required form
• Extend PowerPivot with external programs for further collaboration

Amazon US Amazon UK Amazon Canada

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®

Attendees will be exposed to an unparalleled range of information about business analytics—with over 60 sessions to choose from—covering data discovery, data exploration and visualization, predictive analytics, content management and architecture, collaboration, information strategies, and much more. You’ll develop invaluable new connections with peers and experts. And you’ll walk away with a deeper and broader understanding of Microsoft’s accessible and collaborative platform, including Excel, SharePoint, and SQL Server.

Over 1,200 business analysts, data scientists, line-of-business managers, and IT pros are expected to take part in the inaugural PASS BA Conference, which will deliver the real-world insights, prescriptive guidance, best practices, and strategic vision for successfully analyzing, managing, and sharing business information and insights through Microsoft’s collaborative BA platform.

SSAS-Info.com and PowerPivot-Info.com website users can use code BAC187BL to get 150$ discount of the current conference rate (discount is only for those who haven't already registered - it can't be used retroactively).

More info and register here...

Amazon US Amazon UK Amazon Canada

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world’s foremost PowerPivot blogger and practitioner, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce and include lessons on the difference between calculated columns and measures, how formulas can be reused across reports of completely different shapes, how to merge disjointed sets of data into unified reports, how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not, and how to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar. The “pattern-like” techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide.

Microsoft SQL Server 2012 service packs are cumulative updates and upgrade all editions and service levels of SQL Server 2012 to SP1. This service pack contains SQL Server 2012 Cumulative Update 1 (CU1) and Cumulative Update 2 (CU2).

For most SQL Server components, SP1 is just a collection of patches and bug fixes, but for Business Intelligence scenarios, SP1 is much more than just a service pack. SQL Server 2012 SP1 is specifically released to accompany the release of Office 2013 and SharePoint 2013.

In brief summary, here are the highlights for BI in Excel 2013 and SQL Server 2012 SP1:

• Self-service BI capabilities natively integrated into Excel 2013: The xVelocity in-memory analytics engine that underpins PowerPivot for Excel 2010 and SQL Server 2012 Analysis Services is now natively integrated into Excel 2013. Without using the PowerPivot add-in, users can start in Excel and import hundreds of millions of rows of data from multiple data sources, mash them up, and perform analysis using pivot tables, pivot charts and slicers in Excel. The PowerPivot add-in is also installed with Excel 2013 and can then be used to further enrich the Data Model powered by the xVelocity engine. PowerPivot also includes a new data categorization and recommendation capability and a new improved DataMarket import experience. Moreover, Excel users can now create stunning, interactive reports and visualizations using Power View, which is also installed with Excel 2013. Both PowerPivot and Power View now support 40 languages, including right-left languages, which truly helps to bring our BI capabilities to a broader audience.
• Flexible SharePoint integration Excel Services leverages Analysis Services and Reporting Services to provide data analysis and exploration interactivity in the browser, sharing, collaboration and data refresh of workbooks with xVelocity data and Power View reports. A redesigned PowerPivot for SharePoint architecture gives IT organizations more control over the deployment of BI capabilities in each farm. Also, SharePoint 2013 supports corporate deployments and significantly improves governance and compliance over the self-service BI assets. SQL Server 2012 SP1 is required for server side compatibility.

Beyond the integration with Office, Power View in Reporting Services offers cool new capabilities, ranging from new visualizations, such as Bing maps and pie charts, new formatting abilities, such as backgrounds and themes, and better support for images and URLs. Hierarchies and KPIs enrich the analytical capabilities

List of fixes related to PowerPivot:

This update contains hotfixes for issues that were fixed after the release of SQL Server 2012. This build number of this cumulative update package is 11.0.2332.0.

List of fixes related to SQL Server Analysis Services / Powerpivot 2012:

This update contains hotfixes for issues that were fixed after the release of SQL Server 2012. This release has separate download for SQL Server 2012 PowerPivot.

Note: This build number of this cumulative update package is 11.0.2316.0.

List of fixes related to SQL Server 2012 PowerPivot:

Download this release here...

To learn more about PowerPivot check SQL Server Virtual Launch event on March 7th, 2012. This event has 20min session "Rapid Data Exploration: Powerful Self-Service Analysis with PowerPivot".