Micro Business Intelligence

Self BI, data warehouse, reports building software.

Data Modelling

Data Integration

Ryn Data Integration»

Data Analysis

RynData Excel Addins 2013/2016

Download MS Office RynData Addins »

10 Steps to create BI
  1. Create Model

    Set model as working default

    Go to Data Modeling

    Setup Dimension

    Setup Fact or measure

    Setup Formula in MDX

    Assign Cube and add fact and dimension tot the cube.

    Generate DW and staging database schema

    Load Data is staging tables and move to DW

    Deploy cube

    Create Reports

Data models for reference:

Name Description Domain CreatedOn
Default BI Model Quick BI Business administration 7/19/2020 12:39:11 PM Preview
Adidasler Retail Planning OTB Solution Retail 7/19/2020 12:41:52 PM Preview
Retail Planing Planing retail BI 7/19/2020 3:57:47 PM Preview
Manish Sahani Check Check.in 7/21/2020 6:04:18 PM Preview
JCR Traning OTB Planning Open to Buy Software Preperation 7/21/2020 9:13:49 PM Preview
Covid Corona Data analysis, time and geographical database Heathcare, Social engineering 7/25/2020 3:48:09 PM Preview
POS Intelligence Business Intelligence for point of sale data. Retail industry 7/26/2020 1:51:10 PM Preview
MES BI Manufacturing intelligence, OEE, Yield, Downtime defect analysis Manufacturing 7/30/2020 6:14:44 PM Preview
MittelSchule BI Ausbuiilding Intelligence Education 8/1/2020 11:47:38 PM Preview
Fashion Store Fashion Store BI 8/3/2020 10:06:36 AM Preview
OTB Calculator Open to buy planning Merchandise planning 8/19/2020 12:25:44 AM Preview
Infra BI Monitor servers availability across world Data Center 10/4/2020 9:32:16 PM Preview
AbhiTestModel Testing Demo 11/14/2020 5:08:49 PM Preview
Test Test Test 11/18/2020 11:08:18 PM Preview
World Economy- GDP Analysis (USD) Counties economy progress analysis year by year. GDP at purchaser's prices is the sum of gross value added by all resident producers in the economy plus any product taxes and minus any subsidies not included in the value of the products. It is calculated without making deductions for depreciation of fabricated assets or for depletion and degradation of natural resources. Data are in current U.S. dollars. Dollar figures for GDP are converted from domestic currencies using single year official exchange rates. For a few countries where the official exchange rate does not reflect the rate effectively applied to actual foreign exchange transactions, an alternative conversion factor is used. Social Engineering 11/20/2020 9:16:01 PM Preview
JCR OTB OTB Guidance Retail Fashion 3/31/2021 5:17:15 PM Preview
OTB Planning Fashion Store Report jcr.com 4/1/2021 6:03:40 PM Preview
Crypto Trading Bot Trading strategy performance analysis. Help traders to track strategy performance. Finance, Trading, Binance, Crypto 4/1/2021 6:51:03 PM Preview
StoreBI Store Sales Analysis jcr.com 4/3/2021 1:45:24 PM Preview
DemoBI Store sales Demo Reatil 4/3/2021 2:57:56 PM Preview
Retail Store India Reatil 4/4/2021 2:07:49 PM Preview
Superstore Data Superstore Fashion Reatil 4/4/2021 2:44:35 PM Preview
JCR Data Annual Business Plan jcr.com 4/8/2021 10:02:03 PM Preview
Tet Hhu Vb 12/8/2021 8:28:01 AM Preview

Data Modelling

Learn more »

ETL Setup

Learn more »

Dimension Design

Attributes Heirarchy Setup

Learn more »

Define Facts

Learn more »

Design Cubes

List Dimension and active for Cube

List Facts and active for Cube

List Filters and active for Cube

Learn more »