What is data warehousing, What is data mining, What is BI?

Formula - Definition & meaning

A formula is a database object, which is a calculation, rule or other expression for manipulating the data within a multi-dimensional database. Formulae define relationships among members. Formulae are used by OLAP database builders to provide great richness of content to the server database. Formulae are used by end users to model enterprise relationships and to personalize the data for greater visualization and insight.

Home

OLAP Jargons

Formula - Definition & meaning

Latest blogs & articles

Pentaho Kettle - Data Integration - Tips to handle BIG data sets
Database capacity planning for a Data Warehouse
ETL Project - Prioritizing the requirements
ETL Project - Requirements gathering process
Metadata repository in Data Warehousing
Data Warehouse Architecture - Kimbal's Bottom-Up approach

ETL Tools

DW Guide

BI & DW - Interview questions | Insomnia articles | Job interview questions with answers

BI & DW - Quickstart tutorial

Free tutorials on fundamental concepts of business intelligence and data warehousing:

What is business intelligence(BI)?
Who are the leading BI technology vendors?
What are BI scorecards(balanced scorecard)?
Difference: Data mining vs Analytics
What is the use of BI & DW technologies?

Basics - Data warehousing

What is data warehouse?
What is data mining?
What is ETL process?
What is data modeling?
Data warehouse vs Datamart
Data warehousing vs Data mining
Database vs Data Warehouse

OLAP - Beginners guide

Define: Facts, Dimensions table
Difference: OLTP vs OLAP
What is star schema?
What is snowflake schema?
Star schema vs Snowflake schema
Difference: KPI vs Dashboard
Dashboard vs Scorecard