Analytics

Inventory management with BigQuery and Cloud Run

Many people think of Cloud Run just as a way of hosting websites. Cloud Run is great at that, but there's so much more you can do with it. Here we'll explore how you can use Cloud Run and BigQuery together to create an inventory management system. I'm using a subset of the Iowa Liquor Control Board data set to create a smaller inventory file for my fictional store. In my inventory management scenario we get a csv file dropped into Cloud Storage to bulk load new inventory.

Using SQL to democratize streaming data

Streaming analytics is crucial to modern business – it opens up new product opportunities and creates massive operational efficiencies. In many cases, it’s the difference between creating an outstanding customer experience versus a poor one – or losing the customer altogether. However, in the typical enterprise, only a small team has the core skills needed to gain access and create value from streams of data.

4 reasons why the BI industry has run out of ideas

While there has been some incremental improvements in the last few years, there has been nothing significant recently - and I think there are four clear reasons for that. Firstly, there has been a lot of consolidation in the industry recently. When that happens, behemoth vendors focus far more on selling than building new products that are going to disrupt the industry.