Configuring Custom Render Formats for SQL Server Reporting Services in SharePoint-Integrated Mode

Configuring Custom Render Formats for SQL Server Reporting Services in SharePoint-Integrated Mode

SQL Server Reporting Services (SSRS) is a very versatile tool, allowing report users to export reports in many standard render formats, including Excel, PDF, CSV, and many others. However, there are many reasons why a user may need to export a report in a non-standard format. For example, a user may need to export data from an SSRS report in to a legacy application that requires a very...

Read More
Why You Should Blend Instead of Join in Tableau

Why You Should Blend Instead of Join in Tableau

Data blending in Tableau is the operation of combining multiple data sources into the same view by finding common fields between them to join on. Unlike an ordinary join, which combines data sources at the lowest granularity before any aggregation is done, a data blend can join data sources after aggregation is performed on the individual sources; ultimately limiting the number of records that...

Read More
How to Prepare for the Tableau Desktop Qualified Associate Exam for Free

How to Prepare for the Tableau Desktop Qualified Associate Exam for Free

I recently took the Tableau Desktop Qualified Associate Exam and passed it without spending anything on preparation materials. Having taken other certification exams before, I knew that study guides issued by exam providers don’t always provide the most thorough methods of preparation. In preparing for this exam, I was unsure about the best approach for studying, and ended up exhausting the...

Read More

New Year, New Metrics: Evaluating and Measuring Diversity & Inclusion at Your Firm

Consultants provide significant value to clients on each engagement because we can quickly survey and understand the current environment and processes at a company. Our knowledge of an organizational landscape and its procedures are the foundation for what changes we will recommend for implementation in the future. In fact, a significant portion of our understanding is from measurement and...

Read More

Storytelling: Tableau Story Points

Storytelling: Tableau Story Points As the business world is inundated with more data, people are creating more reports, dashboards, and models to comprehend what the data is telling them.  But what do you do when you are inundated with reports, dashboards, and models?  Simple – you create PowerPoint presentations. Although this sounds outlandish, it goes on everywhere. …

Read More

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

Chicago Energy Benchmarking Ordinance – Coming to a Building Near You

For years, the Chicago skyline has been known for its tall buildings. The Willis Tower, the John Hancock Building, Two Prudential Plaza, and the Trump Tower are all admired for their impressive size, unique architecture, innovative engineering, and beautiful interior aesthetics. Starting this year, these buildings, along with the rest of Chicago’s largest Class A buildings, will begin to be...

Read More

The Power of Transparency

Companies are facing increasing pressure to share information with the public about their internal processes, where (and how) they source their materials, and the impact on the environment.  Frequently accompanying this pressure is the underlying fear that the more information a company shares, the more likely they are to come under scrutiny from the public. …

Read More

Converting Transactional History Data into Snapshot Data (Part 1)

There are several scenarios where a developer may want to convert transactional history data into snapshot data. Sometimes an existing transactional solution has been storing transaction history data for years, requiring a migration to snapshot data for reporting purposes. Some customers may be paying a recurring service fee for disk storage and might want to keep disk space consumption down...

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
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