June 5, 2020Excel with Google BigQuery
Google BigQuery revolutionized data warehouses with its cloud based, serverless, fully managed data platform. Turn BigQuery into a massively parallel, multi-dimensional powerhouse with AtScale. AtScale and Google BigQuery together provide a cost effective, business friendly, analytics solution that includes a universal semantic layer, predictable performance, data governance and security all in one.
Keep Your Data in BigQuery
With AtScale, you don’t need to export data out of Google BigQuery to get the interactivity your users demand. Get rid of data extracts and unnecessary ETL and leave all your data where it landed in Google BigQuery. AtScale will deliver lightening fast queries on large and small data sets without any manual tuning or data movement. Leverage BigQuery’s managed columnar storage and massively parallel execution without needing to manually flatten your data. With AtScale, your traditional star schemas will work just as well (or better) in BigQuery as they do in your traditional relational data warehouses like Teradata and Oracle.
See how AtScale create dimensions from Google nested data types without ETL (2 min video):
Make Microsoft Excel Work “Live” on Google Cloud Platform
AtScale delivers the world’s only “live” Microsoft Excel connection to the Google Cloud. Any user with Excel on their desktop can query data using live Excel pivot tables on Google BigQuery. There are no client drivers to install so any one of the billion Excel users can perform interactive analysis with the same security and governance without the need for additional, expensive BI tools.
See Excel work live with Google BigQuery (1.5 min video):
Stop Worrying about Runaway Queries or Compute Costs
AtScale delivers fast, predictable queries on Google BigQuery. The AtScale Adaptive Cachetm automatically optimizes your BigQuery data warehouse using machine learning guided by user query behavior. Choose whatever BigQuery pricing model makes the most sense for you since AtScale delivers consistent performance with predictable compute consumption no matter the size or granularity of your data.
See how AtScale cuts the bytes scanned by almost 10x (3.5 min video):
Turn BigQuery into a Scale-out Multi-dimensional BI Engine
The AtScale’s Universal Semantic Layer transforms raw BigQuery data into business-friendly measures and dimensions. With AtScale, you can define all your business logic in one place and translate BigQuery’s JSON and nested data types into business ready consumption instantly without ETL or data engineering. Do you have custom calendar dimensions, non-additive metrics like distinct counts or time intelligence requirements for time series comparisons and moving averages? AtScale’s MDX engine makes Google BigQuery the world’s most scalable OLAP engine.
See how AtScale can create time relative calculations using MDX instantly (1.5 min video):
AtScale + BigQuery for Better BI
BigQuery and AtScale together deliver a modern, scalable and affordable data warehouse without all the fuss of data management and tuning. See for yourself how AtScale can leverage your BigQuery investment and democratize data access for everyone who needs it.