Accessing ClickHouse from Excel using Mondrian ROLAP engine

Accessing ClickHouse from Excel using Mondrian ROLAP engine

ClickHouse is a very powerful database for analytics. Microsoft Excel is one of the world’s most popular business applications. There are several ways to bring ClickHouse data to Excel spreadsheets. In this article we will explain how to connect Excel…

Connecting Excel to ClickHouse using the Windows ODBC driver

Connecting Excel to ClickHouse using the Windows ODBC driver

Many years ago a wise customer once said, “every report wants to be an Excel spreadsheet when it grows up!” I have always had a soft spot for Excel–it’s one of the most useful programs that Microsoft ever released. To…