Using MariaDB ColumnStore with Power BI for Visualization and Reporting

on YouTube ↗17m

" summary

MariaDB ColumnStore runs as a pluggable columnar engine that uses distributed storage and MPP to run analytics on billions of rows; the demo connects Power BI via the MariaDB ODBC connector and uses direct query so millions of historical BTS flight rows (1990s–present) stay on the server and Power BI receives only result sets. The engine adds an insert cache 4,700× faster for many small inserts, deletes run ~6× faster, bulk loads use CPMImport, and scaling has no CPU limit across nodes.

AI-written summary · about

" chapters (10)

1. 0:00Start
2. 0:23Intro
3. 0:53About MariaDB ColumnStore
4. 3:11Row-oriented vs. column-oriented
5. 4:39How indexes work on columns
6. 5:48Latest Release Enhancements
7. 9:32Connect to PowerBI: ODBC driver
8. 11:00Connect PowerBI
9. 14:38Exploring MariaDB ColumnStore data inside PowerBI
10. 15:34Visualizing MariaDB ColumnStore data inside PowerBI

" related talks

• 18mBuilding Data Lake with MariaDB ColumnStoreSasha Vaniachine · Percona Live Online 2020
• 42mColumnar Storage + Python: Powering Modern Data Science and AnalyticsRob Hedgpeth · Data Con LA 2021
• 47mDistributed high-load BI engine for Google Data Studio and Microsoft Power BIA.Serbul · Saint HighLoad++ 2022
• 41mHTAP with MariaDB PlatformTodd Stoffel · Data Con LA 2019
• 25mThe future of databases: Combining operational and analytical data at massive scaleRob Hedgpeth · Big Data & AI Toronto 2021
• 37m"Charge Up" or CDC from MariaDB and Postgres into MariaDB Columnstore AnalyticsRoman Nozdrin · HighLoad++ Moscow 2018
• 57mBillions of records: the real success story using Microsoft Power BI EmbeddedIrina Dragunova · NDC Oslo 2020
• 58mIntroducing ScaleDB, the New Clustered, Distributed Storage Engine for MySQL (Part 1)Ivan Zoratti · Percona Live Open Source Database Conference 2017