Data for Good: Tackling the Open Data Movement

Last month, I had the opportunity to attend O’Reilly’s Strata Conference as a representative of West Monroe’s Advanced Analytics team. Strata focuses on trends in Big Data and Analytics, two of the hottest topics in the technology world today. At Strata, I was exposed to emerging Big Data architectures and design patterns, and had the chance to meet passionate and influential technologists in...

Read More

Ready to Switch Reporting Platforms? It Doesn’t Have To Be a Headache

The nature of how we produce and consume data is constantly evolving, and with it our reporting tools evolve too. Advancements in reporting platforms allow companies to become more sophisticated in the way they interact with the information they use to make decisions about their business. Many firms have deliberated moving to a more advanced reporting platform better suited to their needs, but...

Read More

Beyond Decision Tree Segmentation for Banks

Customer segmentation is an essential and valuable exercise for marketers in the financial services industry. The many benefits of a customer segmentation program include the ability to target campaigns and products to the most profitable audiences, increase response rates, lower acquisition costs and increase retention and cross-sell rates.  Segmentation can also help banks compete with...

Read More

Is Cloudera’s Kudu the next generation analytic data platform?

Cloudera announced the Kudu project at Strata Hadoop World conference in New York in September 2015. What makes Kudu important among over 250 active Apache projects? It is aiming to improve the core foundation of Hadoop – HDFS (Hadoop Distributed File System). Hadoop has been around over 10 years with HDFS being its foundational component providing effective data distribution to support...

Read More

A Look Into the Life of an Advanced Analytics Intern at West Monroe Partners

As we approach the end of our 12 week internship with the Advanced Analytics practice at West Monroe Partners, we’re reflecting on the journey and what we learned during the summer. The two of us accepted our offer to join the Advanced Analytics team without knowing what all to expect. We both knew very little about consulting as a whole, but were very intrigued by the unique technology...

Read More

5 Things to Consider when using Datazen with a SQL Server Database

Microsoft’s recent acquisition of Datazen has brought it to the forefront of the conversation about data visualization, particularly with their plans to integrate Datazen with SQL Server 2016. Datazen is a data visualization platform that presents data integrated from multiple sources including Excel, SQL Server databases, OLAP, SharePoint, Web Services, ODBC, and others.…

Read More

Quirky Queries: How to Avoid a De-Duplication Nightmare

I came across this query the other day, and it led to quite a bit of head scratching. The goal of the query was to de-duplicate data using a row ranking algorithm, however, every time I ran it it returned random and unpredictable results! Needless to say, I couldn’t keep running a faulty query, so I had to get to the bottom of it.…

Read More

PowerShell and SSIS

I’ve been trying to learn more and more about PowerShell and how I can use it to be a better DBA.  This morning I came across the function Get-Filehash that came out with PowerShell version 4.0 and computes the hash value for a file by using a specified hash algorithm.  I wondered if this could have helped me with a problem I had at a prior client where a network problem was sporadically...

Read More

The Pitfalls of Big Data Analysis

The Power of Correlation Models One of the main reasons we model data is to better understand the relationship between variables. With the advent of Big Data, analysts gained access to a large pool of raw, historical, data, unlike anything they’ve had before. Modeling used to require some sort of hypothesis, followed by data collection, but Big Data has paved the way for correlation...

Read More
Tableau: Beyond the Buzzword – Part 1

Tableau: Beyond the Buzzword – Part 1

Tableau Software has created a lot of buzz within many mid-to-large-size organizations.  These companies are looking to make the most of their ever-increasing data, knowing that gaining insights into their business is crucial to their ongoing success. These goals often bring attention to data visualization tools like Tableau. Although it has been around since early 2003, many companies still...

Read More

Tips on supercharging your ETL

We live in the era of big data explosion with data volumes growing at exponential pace.  At the same time data driven organizations increasingly demand more real time data availability. Given these trends, ETL performance is quickly gaining business importance. Let’s look at a few approaches that could be considered to maximize performance of data processing.…

Read More

Manipulating SSRS Parameter Functionality

When it comes to report development it is difficult to accomplish perfection. In any development cycle, there are constant change requests and minor bugs to fix months after deployment and new visualizations and numbers that people would like to see. The good news, however, is that these changes almost always require relatively simple solutions and, if not, someone out there will almost always...

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