Excel Combine Worksheets

Combine data from worksheets into a new worksheet. Beginning with two worksheets containing fictitious data where both share a column… Read more Excel Combine Worksheets

SSAS: OLAP Schemas

Arranging Database Tables to Support Rich, Effective Analysis In traditional systems used for e-commerce or other common input/edit systems commonly… Read more SSAS: OLAP Schemas

SQL Server Analysis Services (SSAS)

SSAS:  An Overview of OLAP SSAS: Data Warehouse SSAS: Data Cube SSAS: OLAP Schemas SSAS: BIDS Cube Browser SSAS: Viewing… Read more SQL Server Analysis Services (SSAS)

SSAS: An Overview of OLAP

The Foundation of Business Intelligence (BI) Online Analytical Processing (OLAP) is the mechanism by which vast amounts of data is… Read more SSAS: An Overview of OLAP

SSAS: Data Cube

Designing OLAP Data Cubes OLAP Data cubes represent the primary logical object for providing critical, multidimensional analysis common to business… Read more SSAS: Data Cube