Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 3

Part 2 finished with the deployment of a scalable Tabular 1400 model in Azure Analysis Services on top of Azure Blob storage. Part 3 continues the story by attempting to load up to 1 TB of TPC-DS source data into the model–hosted on the largest server that Azure Analysis Services offered at the time of… Read more

Evaluating Shared Expressions in Tabular 1400 Models

In our December blog post; Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services, we mentioned SSDT Tabular does not yet support shared expressions, but the CTP 1.1 Analysis Services engine already does. So, how can you get started using this exciting new enhancement to Tabular models… Read more

Released: Twitter Analytics for Excel 2013

Back in 2011, we released a great PowerPivot sample application to query Twitter and analyze tweets within Excel 2010. This was a joint venture between Microsoft and ISV Gold BI partner Extended Results, and the great news is that Extended Results has finished an updated version that now also works in Excel 2013! For all… Read more

Supporting Multiple PowerPivot Versions

Since the release of SQL Server 2012, users can choose between two different versions of PowerPivot for Excel: SQL Server 2008 R2 and SQL Server 2012. Both PowerPivot versions are free of charge, but the 2012 add-in includes more features than its predecessor and offers several improvements to the user interface, so it’s reasonable to… Read more

Whitepaper and Samples Released: Data Analysis Expressions (DAX) In the Tabular BI Semantic Model

Happy New Year 2012, everybody! With the release of SQL Server 2012 ante portas, this is going to be a very exciting year. So, let’s start this year with a release announcement: An updated version of the whitepaper “Data Analysis Expressions (DAX) In the Tabular BI Semantic Model” is available for download at Authors… Read more

Tips and Tricks: Mapping Data to the World in a PowerPivot Workbook

Last week I came across a stunning PowerPivot solution that visualizes research data on top of a world map, as illustrated in the following screenshot. What’s particularly stunning about this solution is that it works even in the browser despite the fact that Excel Services doesn’t support custom shapes or background images for country objects… Read more

How to Build a VSTO-Based PowerPivot Workbook

Microsoft Visual Studio Tools for Office (VSTO) is an awesome development suite for building advanced Office solutions, such as Excel applications that go above and beyond default features and capabilities. Even our PowerPivot for Excel add-in is based on VSTO. However, it is important to note that VSTO does not define application programming interfaces (APIs)… Read more

Released: Denali CTP3 Samples and TechNet Wiki

This was a big announcement week for us. Let’s finish it with a note about our new Denali CTP3 samples. JuanPablo already introduced the AMO sample in his Creating a Tabular Model with AMO blog post, but wait there’s more: SQL Server Samples Readme on the TechNet Wiki   Ties all samples together and provides step-by-step installation… Read more

Creating a Tabular Model with AMO – New Version SQL 2012

With the release of SQL Server 2012 we have included a complete set of database samples in the data warehousing field, to help you get started understanding almost all product features. In addition to all sample data, we delivered a developer’s sample to programmatically create a Tabular model using the AMO API, in C#.  This… Read more