Analysts, Data Engineers and all data crew are always eager to offer the best set of analytical tools, qualified data, a good performance and agility when delivering data products to the user areas. And when it comes to KPI’s, the interest is a bit higher, because if you’re not tracking your indicators correctly, you may […]
Yeah. Yep. Big hero moment. (Captain Marvel 59:58) Good news is hard to come by these days, so it's nice when we have something to celebrate. The world, despite the doom, does go on. So when we got the news that Stewart Bryson (CEO of Red Pill Analytics) had been given the title of Data [...]
I recently downloaded Oracle Analytics Desktop (OAD)12.2.5.4 to check in on what's new. The last time I used Oracle's desktop tool, it was called Data Visualization Desktop; I figured they must have made some updates over the last few years. I was not terribly impressed with the original application (at least early versions of it), [...]
Matches (Advanced) Filters I’m constantly impressed with the advanced filter functionality in Looker. It’s so convenient…and fairly intuitive, once you get the hang of the syntax. As always, if you run into an issue or need more context, Looker’s documentation is a great place to start. Advanced filters allow you to specify an expression for [...]
This blog, Deploying Kafka Streams and KSQL with Gradle – Part 3: KSQL User-Defined Functions and Kafka Streams was originally posted on the Confluent Blog on July 10, 2019. See the original source here. Building off part 1 where we discussed an event streaming architecture that we implemented for a customer using Apache Kafka, KSQL, and Kafka Streams, and part 2 where we discussed how [...]
This blog, Deploying Kafka Streams and KSQL with Gradle – Part 2: Managing KSQL Implementations, was originally posted on the Confluent Blog on May 29, 2019. See the original source here. In part 1, we discussed an event streaming architecture that we implemented for a customer using Apache Kafka®, KSQL from Confluent, and Kafka Streams. Now [...]
This blog, Deploying Kafka Streams and KSQL with Gradle – Part 1: Overview and Motivation, was originally posted on the Confluent Blog on May 15, 2019. See the original source here. Red Pill Analytics was recently engaged by a Fortune 500 e-commerce and wholesale company that is transforming the way they manage inventory. Traditionally, this [...]
It’s that time of the year again. Kscope19, one of the best Oracle User Group conferences of the year, is merely weeks away. If you’re only going to one conference this year, definitely take this one into consideration. Why Kscope? If you are heading to Kscope, you're probably already an Oracle aficionado. This is where [...]
By offering an impressive and ever-growing library of connectors, Fivetran has become a leading choice for extracting data from source applications and loading it in a cloud data warehouse. With reusability as a primary requirement, Fivetran has taken on the challenge of building out source system connectivity and established a core pattern of applying […]
Parameters in Looker increase interactivity for users and provide flexibility from the front end perspective without having to write custom code for each and every field the user asks for. A parameter creates a filter-only field that can be added as a filter when exploring, but cannot be added to the result set. The parameter [...]
