How to Build Pivot Tables in BigQuery Fast and Easy
A Fast Approach to Building Pivot Table / Transpose Functionality into BigQuery Background Transposing or pivoting a table is a common operation in data analysis, however, BigQuery does no [...]
Insights
Solving the World's Unsolved Problems
SAS Grid Performance Benchmarking with Lustre and SPDS on Microsoft Azure
How to Benchmark the Performance of a SAS Cloud Migration using Lustre & SPDS on Microsoft Azure Background As organizations migrate analytic workloads to the cloud, their roadmap need [...]
Google Big Query Storage API Benchmark
How to Benchmark and Increase the Performance of BigQuery Using the BQ Storage API Why BQ Storage API? Google Big Query (BQ) is a serverless, highly scalable and cost-effective Cloud Data [...]
Auto Scale EMR to Unleash Business Analysts’ Capabilities
Auto Scale EMR: Enables Analysts to Cut Through the Flood of Data Introduction Business analysts are increasingly tasked to analyze large volumes of analytic data and share insights to hel [...]
Large Scale Reporting Solution for Franchise Business
Customized Reporting for Franchise Store Managers We recently deployed a large-scale reporting project for a major client who had 1000’s of weekly, monthly and annual reports that were vita [...]