mining - Business Intelligence (BI) in Python, OLAP

  •        9

If you use Mac OSX you can install all dependencies using HomeBrew. For example, to connect to a PostgreSQL database make sure you install a driver like psycopg2. OpenMining supports all databases that the underlying ORM SQLAlchemy supports.

https://github.com/mining/mining

Tags
Implementation
License
Platform

   




Related Projects

RapidMiner -- Data Mining, ETL, OLAP, BI

  •    Java

No 1 in Business Analytics: Data Mining, Predictive Analytics, ETL, Reporting, Dashboards in One Tool. 1000+ methods: data mining, business intelligence, ETL, data mining, data analysis + Weka + R, forecasting, visualization, business intelligence

ReportServer - The Business Intelligence Suite

  •    Java

ReportServer is a modern and versatile business intelligence platform. It supports Pixel-perfect reporting, Ad-hoc analyses, Excel and Word reporting, Integrates with Jasper, Eclipse Birt and Crystal report, Multidimensional OLAP analytics also integrates with Mondrian OLAP, an OLAP server written entirely in Java and optimized for performance even on large datasets. ReportServer comes with a great selection of powerful tools.

Business Intelligence LAB

  •    

Business Intelligence LAB is a Microsoft Business Intelligence Framework that is developped based on real life needs. This repository hosts a set of development done upon SQL Server Business Intelligence Stack. This covers : - Data Access - Sample Cube - Sample OLAP Viewer - ...

SpagoBI - Business Intelligence Suite

  •    Java

SpagoBI is the only entirely open source Business Intelligence suite. It covers all the analytical areas of Business Intelligence projects, with innovative themes and engines. SpagoBI offers a wide range of entirely open source analytical tools like Reporting, OLAP, Chart, Data mining, Real-time monitoring console, ETL.

Pentaho

  •    Java

Pentaho is the open source business intelligence leader. Thousands of organizations globally depend on Pentaho to make faster and better business decisions that positively impact their bottom lines. Download the Pentaho BI Suite today if you want to speed your BI development, deploy on-premise or in the cloud or cut BI licensing costs by up to 90%.


OLAP Spend Controlling (OLAP-SC)

  •    

OLAP-SC is a business intelligence application for spend + savings transparency, strategic sourcing, procurement / purchasing controlling. IT provides an olap cube model, a relational db model and controlling reports. See: http://www.orpheus-it.com

InfiniDB - Scale-up analytics database engine for data warehousing and business intelligence

  •    C++

InfiniDB Community Edition is a scale-up, column-oriented database for data warehousing, analytics, business intelligence and read-intensive applications. InfiniDB's data warehouse columnar engine is multi-terabyte capable and accessed via MySQL.

OpenReports - Powerful Reporting Solution

  •    Java

OpenReports supports a variety of open source reporting engines, including JasperReports, JFreeReport, JXLS, and Eclipse BIRT, to provide support for a wide range of reporting requirements and capabilities. OpenReports also includes QueryReports and ChartReports, easy to create SQL based reports that do not require a predefined report definition. OpenReports also supports OLAP via Mondrian and JPivot.

Pinot - A realtime distributed OLAP datastore

  •    Java

Pinot is a realtime distributed OLAP datastore, which is used at LinkedIn to deliver scalable real time analytics with low latency. It can ingest data from offline data sources (such as Hadoop and flat files) as well as online sources (such as Kafka). Pinot is designed to scale horizontally, so that it can scale to larger data sets and higher query rates as needed.

JMagallanes - Dynamic Reports in Java

  •    Java

JMagallanes is an end user application for Olap and Dynamic Reports written in Java/J2EE. It combines static reports (based on JasperReports), a Swing pivot table for OLAP analysis, and charts (based on JFreeChart). It reads from many data sources as SQL, Excel, XML, and others, and produces many outputs as PDF, XML, and application specific files for later off-line visualization of reports.

Kylin - Extreme OLAP Engine for Big Data

  •    Java

Apache Kylin is an open source Distributed Analytics Engine designed to provide SQL interface and multi-dimensional analysis (OLAP) on Hadoop supporting extremely large datasets, original contributed from eBay Inc. It is designed to reduce query latency on Hadoop for 10+ billions of rows of data. It offers ANSI SQL on Hadoop and supports most ANSI SQL query functions.

MDX Parser,Builder,DOM and OLAP visual controls with Writeback for Silverlight

  •    CSharp

It is component library for OLAP, .NET & Silverlight (C#). * MDX DOM, Parser, Generator, Query Designer * Description of supported MDX Syntax * Dynamic Pivot Grid - Pivot Table with Writeback * OLAP metadata choice controls See also: http://code.google.com/p/ranet-uilibrary-olap/

NBi

  •    

NBi is a testing framework (add-on to NUnit) for Microsoft Business Intelligence platform and Data Access.

Postgres-XL - Scalable Open Source PostgreSQL-based Database Cluster

  •    C

Postgres-XL is a horizontally scalable open source SQL database cluster, flexible enough to handle varying database workloads like OLTP, Business Intelligence requiring MPP parallelism, Key value store, GIS Geospatial and lot more.

OpenI: OLAP Data Visualization Plugin

  •    Java

OpenI plugin for Pentaho CE provides a simple and clean user interface to visualize data in OLAP cubes. It supports both direct Mondrian and xmla based connections like Microsoft SQL Server Analysis Services (SSAS), plus provides add-on features like Explore Cube Data, custom SQL for drillthrough data, publishing drillthrough data to external web services etc.

SSIS Event Log Business Intelligence

  •    

The SSIS Event Log Business Intelligence package is a complete BI project focused around SSIS Event Log data. Components include: - 9 SSRS Reports - ETL Data Mart - SSIS packages to load ETL Data Mart - Analysis Services Cube - PerformancePoint Dashboard

Lens - Unified Analytics interface

  •    Java

Lens provides an Unified Analytics interface. Lens aims to cut the Data Analytics silos by providing a single view of data across multiple tiered data stores and optimal execution environment for the analytical query. It provides a simple metadata layer which provides an abstract view over tiered data stores.

ADempiere - ERP Business Suite

  •    Java

ADempiere is an open source ERP business suite. It has full support for Maintenance Management, Project Management, Manufacturing, Customer Relationship Management (CRM), POS, ecommerce, Human Resource, Accounting, Sales and Purchasing. It is well integrated with OLAP Business Intelligence, Financial Reporting and JasperReports.