How to Resolve ID and Name Mismatch in Tabular Model Databases in Analysis Services

If you’ve been deploying tabular models to Analysis Services, at some point you may find you needed to have two different named instances on a server – one for test, and one for production.  And once done with testing, you just used the Rename right-click menu option on the database in order to rename it as the production instance. …

Read More

New to PowerPivot? Five Simple Tips for New PowerPivot Users

PowerPivot is a powerful tool which gives users the ability to pivot data on the fly from multiple data sources. However, using PowerPivot can be a little daunting at first, especially if you haven’t used pivot tables before. Here are 5 simple tips for users new to PowerPivot. Tip #1. Client Software required to build PowerPivot Cubes from Excel Excel 2010 or Excel 2013 is required to connect...

Read More

Favorite Quick & Easy DAX: Calculate Percent of Total Scenario

One of the greatest benefits of creating a PowerPivot or tabular model is the ability to easily build custom calculations, using Data Analysis Expressions (DAX). With DAX, you can create custom calculations using mathematical and other functions, inserted in a new column. DAX supports most of the formulas familiar to Excel users (such as SUM, COUNT, AVERAGE), but also enables look ups and...

Read More

The Top 3 Reasons to Deploy PowerPivot to SQL Server Analysis Services (SSAS)

Microsoft’s PowerPivot add-in to Excel (2010 and 2013) is a powerful tool for business users to combine multiple types of data sources into a single pivot table. Leveraging technology shared by Microsoft SQL Server Analysis Services (SSAS) OLAP solutions, PowerPivot provides aggregated data filterable by a common set of attributes, which can be designed by users without having to engage an IT...

Read More

Self-Service BI. Really?

I’m pretty skeptical of BI marketing pitches, (working as I do as a consultant in the trenches somewhere between business leaders, end users, and IT developers). But after hands-on experience with Microsoft’s latest BI tools – Power Pivot and Power View for SharePoint—I feel persuaded that “self-service BI” are not just buzz words. …

Read More
Phone: 312-602-4000
222 W. Adams
Chicago, IL 60606
Show Buttons
Share On Facebook
Share On Twitter
Share on LinkedIn
Hide Buttons