Updated March 4, 2019
The 1990’s called, they want their OLAP back.In 1992, Arbor Software shipped the first version of Essbase. Which stands for Extended Spreadsheet Database. In 1998, Microsoft shipped Microsoft SQL Server Analysis Services. The time of multi-’dimensional’ databases had come into full being and almost 30 years later…
Updated March 4, 2019
TECH TALK: SQL-on-Hadoop Benchmark: A Bit of a Tortoise and Hare StoryTrystan here, Software Engineer and doer of all things technical at AtScale. Which SQL-on-Hadoop engine performs best? We get this question all the time! We looked around and found that no one had done a complete and impartial benchmark test…
Updated March 4, 2019
TECH TALK: Solving the Unrelated Dimension Dilemma. A Connect the Dots Story of Sorts.Wouldn’t it be great if you could load all of your data from a single file into an Excel pivot table for easy analysis? Unfortunately, this approach isn’t usually viable when dealing with complex business analytics and big data. Take…
Updated March 4, 2019
TECH TALK: Scale-Out Business Intelligence with HadoopThe growing popularity of big data analytics coupled with the adoption of technologies like Spark and Hadoop have allowed enterprises to collect an ever increasing amount of data - in terms of breadth and volume. At the same time, the…
Updated March 4, 2019
TECH TALK: Multi-Level Metric Analysis. Uncover the Hidden RelationshipsI’ve asked it before and I’ll ask it again. Wouldn’t it be great if you could easily analyze ALL your data from a Excel single file? We all know this isn’t feasible; especially when dealing with big data and complex…
Updated March 4, 2019
TECH TALK: First-Child & Last-Child Measures in HadoopAs more and more enterprises adopt Hadoop as their next generation data platform, the demands of traditional enterprise workloads, including support for Business Intelligence use cases, are creating challenges. While Hadoop excels at low-cost distributed storage and parallel data processing,…
Updated March 4, 2019
TECH TALK: BI Performance Benchmarks with BigQuery from GoogleIn the world of Business Intelligence and Big Data there continue to be a number of exciting innovations as new and improved options for processing large data sets appear on the market. You may be familiar with AtScale’s BI-on-Hadoop Benchmarks…
Updated March 4, 2019
Supercharge Your Percentile Calculations for Big Data (Part I)Additional contribution by: Santanu Chatterjee, Trystan Leftwich, Bryan Naden. A new and powerful method of computing percentile estimates on Big Data is now available to you! By combining the well known t-Digest algorithm with AtScale’s semantic layer and smart aggregation…
Updated March 4, 2019
Supercharge Your Percentile Calculations for Big Data (Part II)Additional contribution by: Santanu Chatterjee, Trystan Leftwich, Bryan Naden. In the previous post, we discussed typical use cases for percentiles and the advantages of percentile estimates. In this post, we illustrate how to model percentile estimates with AtScale and use…
Updated March 4, 2019
Supercharge Your Percentile Calculations for Big Data (Part III)Additional contribution by: Santanu Chatterjee, Trystan Leftwich, Bryan Naden. In the previous post we demonstrated how to model percentile estimates and use them in Tableau without moving large amounts of data. You may ask, "how accurate are the results and…
