Search Articles — Sudonull

Search Results

In this project

Offline BI in asapBI: Docker and ClickHouse

https://sudonull.com/offline-bi-in-asapbi-docker-and-clickhouse

Set up a local BI stack in asapBI for work without internet. Docker Compose, graphical Views, Git versioning. Instructions for developers: step by step.

BI system on DataLens and PostgreSQL for WB Ozon

https://sudonull.com/bi-system-on-datalens-and-postgresql-for-wb-ozon

Learn how to build a scalable BI system for marketplaces: from API export to optimized dashboards. Cost versioning, precalculations, automation. Instructions for developers.

Excel vs BI: when should companies switch

https://sudonull.com/excel-vs-bi-when-should-companies-switch

Learn Excel limits in analytics and signs of transition to BI systems. Comparison of approaches, cases and criteria for business. Optimize processes today.

Three Data Aggregation Errors in BI Systems

https://sudonull.com/three-data-aggregation-errors-in-bi-systems

Learn why BI systems lie: mathematical errors in averaging, count distinct, and snapshot metrics. How to build analytics without distortions.

Power Query from Excel: migration to BI and R7

https://sudonull.com/power-query-from-excel-migration-to-bi-and-r7

Learn how to extract M-code and dependencies from Excel for quick migration to BI or R7-Office. Automate audit and logic transfer without rewriting. Reduce analysis time by 6 times.

Trending Now