Location analytics and geospatial data on Snowflake

Uli Bethke Snowflake

What is Geospatial / GIS data? Geospatial data and location analytics Geospatial Data can be defined as data with a geographic component, e.g. Address, ZipCode, latitude / longitude etc. These components help us to understand the location of the object, phenomenon or event, e.g. the location of a mall, the property prices in a particular area, the changing location of ...

UK Census Data

Uli Bethke Uncategorized

Each table provides information about a single census topic like sex, dwellings, hours worked etc. Data present in the table is at the census ward level. Electoral Wards are key building blocks of UK administration. They are spatial units used to elect councillors at various levels across the UK. The Wards resulting from a policy which minimizes the statistical impact ...

ecobee chooses Flexter to make valuable IoT data in XML accessible to BigQuery users for analytics

Uli Bethke BigQuery, XML

The challenge A world leader in smart home devices that introduced the world’s first smart thermostat, ecobee has expanded rapidly in the last decade. Naturally, with company growth has come a surge in the amount of data generated by the company, particularly from their sensor devices – and subsequently, the need for clean data, analytics, and standardized reporting across the ...

The Data Marketplace. A missing piece in modern data architecture

Uli Bethke Snowflake

What is a Data Marketplace? Data Marketplaces are a relatively recent phenomenon in data management. They bring together providers and buyers of data. Organisations were able to buy data from third parties in the past. However, Data Marketplaces make it significantly easier to find and buy data. They also cut out the middleman and bring providers and consumers of data ...