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
Adidasler Retail Planning OTB Solution Retail 7/19/2020 12:41:52 PM
Retail Planing Planing retail BI 7/19/2020 3:57:47 PM
Manish Sahani Check Check.in 7/21/2020 6:04:18 PM
JCR Traning OTB Planning Open to Buy Software Preperation 7/21/2020 9:13:49 PM
Covid Corona Data analysis, time and geographical database Heathcare, Social engineering 7/25/2020 3:48:09 PM
POS Intelligence Business Intelligence for point of sale data. Retail industry 7/26/2020 1:51:10 PM
MES BI Manufacturing intelligence, OEE, Yield, Downtime defect analysis Manufacturing 7/30/2020 6:14:44 PM
MittelSchule BI Ausbuiilding Intelligence Education 8/1/2020 11:47:38 PM
Fashion Store Fashion Store BI 8/3/2020 10:06:36 AM
OTB Calculator Open to buy planning Merchandise planning 8/19/2020 12:25:44 AM
Infra BI Monitor servers availability across world Data Center 10/4/2020 9:32:16 PM
AbhiTestModel Testing Demo 11/14/2020 5:08:49 PM
Test Test Test 11/18/2020 11:08:18 PM
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
JCR OTB OTB Guidance Retail Fashion 3/31/2021 5:17:15 PM
OTB Planning Fashion Store Report jcr.com 4/1/2021 6:03:40 PM
Crypto Trading Bot Trading strategy performance analysis. Help traders to track strategy performance. Finance, Trading, Binance, Crypto 4/1/2021 6:51:03 PM
StoreBI Store Sales Analysis jcr.com 4/3/2021 1:45:24 PM
DemoBI Store sales Demo Reatil 4/3/2021 2:57:56 PM
Retail Store India Reatil 4/4/2021 2:07:49 PM
Superstore Data Superstore Fashion Reatil 4/4/2021 2:44:35 PM
JCR Data Annual Business Plan jcr.com 4/8/2021 10:02:03 PM

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 »