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

Multidimensional Query Language - Definition & meaning

A computer language that allows one to specify which data to retrieve out of a cube. The user process for this type of query is usually called slicing and dicing. The result of a multi-dimensional query is either a cell, a two-dimensional slice, or a multi-dimensional sub-cube.

Home

OLAP Jargons

Multidimensional Query Language - 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