What data visualization, business intelligence, reporting, or dashboard tools can I use?
You have a lot of great and affordable choices these days! Tools like Tableau Software, Looker, Mode Analytics, and Microsoft Power BI are just a few options to consider.
Take a look at the full list of tools or read our DZone article about creating an objective 10-point business intelligence tool checklist to help narrow the field. If you have questions, feel free to reach out to us.
How do I transform my data?
We are considered an Extract, Load, and Transform (ELT) platform with the "T" happening in external tools. Openbridge believes in increasing the velocity of data access, which means we focus on quickly delivering "analytics ready" data.
In most cases, additional transformations are not needed. As a result, we do not provide direct tooling or software to transform data. We suggest the use of best-in-class "transform" tools like Tableau Data Prep, Alteryx, or Trifacta, offering attractive and cost-effective solutions.
Can I Use Standard SQL?
Yes, using standard SQL is supported. Amazon Redshift, Amazon Redshift, Amazon Amazon Redshift, and others support familiar SQL constructs. There may be some limitations or best practices for the specific use case, but the rule of thumb is that SQL is available.