Trends and Takeaways from SQL PASS

Trends and Takeaways from SQL PASS

I recently attended SQL PASS Summit in Seattle, a conference focusing on Microsoft Data Platform users. The conference brings over 4000 people from around the world who all get excited about data to one place. This year, Microsoft unveiled a handful of new products and a slew of upgrades and new features to existing products.…

Read More
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
Transparent Data Encryption with the Azure Key Vault

Transparent Data Encryption with the Azure Key Vault

In last week’s post, we covered a BitLocker implementation for Azure virtual machines. But as mentioned in that post, because BitLocker doesn’t fully satisfy the Payment Card Industry Data Security Standard (PCI DSS) requirement (specifically, 3.4 and 3.5.2) for data encryption at rest, we also implemented SQL Transparent Data Encryption (TDE) for all databases.…

Read More
Partly Cloudy with a Chance of Compliance

Partly Cloudy with a Chance of Compliance

As advisors to our 100+ private equity clients who use M&A activity to provide positive returns to their investors, WMP helps establish platforms, processes, and technology that can enable rapid EBITDA growth. Within the world of M&A, carve-outs and divestitures are some of the most complex situations when it comes to quickly getting the newly acquired business on the right track...

Read More
Refining Your SQL Wizardry

Refining Your SQL Wizardry

Consulting in data analytics is a demanding profession that requires both broad and deep technical knowledge in a variety of tools and technologies. One key skillset expected of just about any analytics consultant is the ability to retrieve data from a source system and manipulate it to fit the client’s needs.…

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

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

Data to Dashboard: Making sense of Big Data

Our Advanced Analytics  team’s obsession with the NFL led us on an ambitious journey to collect NFL Twitter data with the hopes to gather some useful insights. As the weeks went by, millions of tweets were collected. With this data being amassed, we established the arduous objective to understand the type of events that surround large influxes of tweets.…

Read More

Converting Transactional History Data to Snapshot Data (Part 2)

In my previous business intelligence blog, “Converting Transactional History Data to Snapshot Data – Part 1“, we reviewed three challenges involved with converting transactional history data to snapshot data: The First Challenge – Data Uniqueness : Dealing with multiple records for an Entity with the exact same timestamp.  We needed a way to uniquely identify these...

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