{"repo":"totalhack/zillion","free":true,"listed":false,"github":"https://github.com/totalhack/zillion","clone":"git clone https://github.com/totalhack/zillion.git","description":"Make sense of it all. Semantic data modeling and analytics with a sprinkle of AI. https://totalhack.github.io/zillion/","language":"Python","stars":208,"topics":["warehouse","data-warehousing","datasources","query-builder","reporting","analytics","data-analysis","python","sql","ai"],"license":"MIT","category":"analytics","readme_excerpt":"Zillion: Make sense of it all ============================= Introduction ---------------- Zillion is a data modeling and analytics tool that allows combining and analyzing data from multiple datasources through a simple API. It acts as a semantic layer on top of your data, writes SQL so you don't have to, and easily bolts onto existing database infrastructure via SQLAlchemy Core. Zillion also includes an agentic question-answering workflow for planning and executing one or more reports from natural language. With Zillion you can: Define a warehouse that contains a variety of SQL and/or file-like datasources Define or reflect metrics, dimensions, and relationships in your data Run multi-datasource reports and combine the results in a DataFrame Flexibly aggregate your data with multi-level rollups and table pivots Customize or combine fields with formulas Apply technical transformations including rolling, cumulative, and rank statistics Apply automatic type conversions - i.e. get a \"year\" dimension for free from a \"date\" column Save and share report specifications Utilize ad hoc or public datasources, tables, and fields to enrich reports Plan and answer warehouse questions with a natural language agent Table of Contents --------------------- Installation Primer Metrics and Dimensions Warehouse Theory Query Layers Warehouse Creation Executing Reports Natural Language Querying Zillion Configuration Example - Sales Analytics Warehouse Configuration Reports Advanced Topics Subrepor","default_branch":null,"files":null,"tree":[],"storefront":"/r/totalhack","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/totalhack/zillion/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}