article thumbnail

Simplify Online Analytical Processing (OLAP) queries in Amazon Redshift using new SQL constructs such as ROLLUP, CUBE, and GROUPING SETS

AWS Big Data

Solution overview Online Analytical Processing (OLAP) is an effective tool for today’s data and business analysts. You can remove this filter in your test to view data for all regions. This allows us to measure the performance of the database as opposed to its ability to serve results from cache.

article thumbnail

Master Your Power BI Environment with Tabular Models

Jet Global

As a security measure, Microsoft is closing off direct database access to live Microsoft Dynamics ERP data. It updates a dedicated database against which you can perform reporting and analytics. If you have a substantial library of existing reports and dashboards, reviewing and testing them all will take time.