Emerging BI applications easily enable data discovery and visualization on any device

If you’ve been happily working in Microsoft SQL and Excel for your business intelligence and reporting solutions, you may not have had much motivation to look at the offerings outside of the Microsoft stack. But if you find that not everyone wants to work in Excel, or that Reporting Services and Power BI (including Power View) disappoints when it comes to rich visualizations or ease of use...

Read More

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 Moving Averages with EARLIER

Sometimes reporting data values day-by-day can create the impression of dramatic ups and downs, when really what we want to see is the general trend of changes over time.  We need, in other words, to create a chart based on moving averages.  Such a measure is commonly used in tracking the price of stocks, but there are many other cases where showing, for example, 7-day moving averages is...

Read More

Favorite Quick & Easy DAX: Lookup Values

The more I work in Power Pivot, the more I’m amazed at what can be done using DAX in Excel, Microsoft’s powerful expression language for creating custom calculations, aggregations, and references within and across data entities. In this post, I take a look at the very useful LOOKUP VALUE expression, for when you want to scan any table in your data model, find a specific value, and relate that...

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

Creating Pivots From Excel Exports of Reports Made With the Report Wizard

There is an error generated when users try to pivot on an Excel export generated from a report made with Ad Hoc report wizard in CRM: “The PivotTabIe field name not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTabIe field, you must type a new name for the field.” To reproduce the...

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