No More SQL! – How Drop-Downs become a Query

Explore Analytics empowers user to understand information through advanced analytics using an intuitive, self-service user-interface.

It does this by allowing non-technical users to generate powerful visualizations using drag-and-drop selections and drop-down choices, rather than needing scripts, code, or database work.

For many who’ve worked with business intelligence tools in the past, this may be a conceptual adjustment. As such, I’m frequently asked the question, “Where do I put the SQL?” In fact, Explore Analytics makes it even easier — allowing you to do a lot of what you did before in SQL using an intuitive graphical interface.

To show you what I mean, we’ll walk through an example that shows how we build queries easily, and how you can shift away from writing code to getting information.

Continue reading

Comparing Year-over-Year – Tips & Tricks

Analytics illuminates patterns and behaviors not just by showing information, but by providing context. There are a lot of ways that you can reformat your reports to provide additional context, and in this post we’re going to take a deep look at Year-over-Year reporting.

Year-over-year reporting tries to help you place the current trends in context of trends in previous years. For example, if you’re seeing a spike in incidents, is this a seasonal spike, or specific to this year? Are you on track to have a better or worse year than last year for your KPIs?

Continue reading