Related resources for OLAP
  • Understanding OLTP and OLAP for Effective Data Management4/19/2024 6:03:17 AM. This article explores OLTP and OLAP, two crucial systems for data management. OLTP handles real-time transactions, while OLAP analyzes historical data to uncover valuable insights. Learn how they work
  • Getting Started with SQL Server 2022 SSDT 17.812/7/2023 6:12:21 AM. It breaks down complex concepts into easy-to-understand terms: SSDT, SSIS, SSAS, SSRS, ETL, SSOX, MDS, TDS and OLAP.
  • OLAP ETL Tasks In RavenDB8/23/2023 9:56:53 AM. What are OLTP and OLAP? Where is each appropriate? This article explains the difference between OLAP and OLTP, why would you want to use cloud OLAP services over a SQL reporting database, and the func
  • Designing and implementing a Data Warehouse: Part 37/27/2023 5:18:50 AM. This is the third article of a series of articles that I want to write in order to share my knowledge and experience in this subject matter. In this part and the next one, we will see how to implement
  • SQL Server Analysis Services (SSAS) : Part 12/20/2023 7:29:56 AM. This article describes the Microsoft Business Intelligence (BI) suite that provides a very powerful technology called SQL Server Analysis Services (SSAS) to deliver OnLine Analytical Processing (OLAP)
  • Creating an OLAP Cube (SSAS)2/20/2023 5:56:49 AM. Here you will see how to create an OLAP Cube (SSAS).
  • 11 Important Database Designing Rules1/6/2023 12:10:40 PM. This article will discuss 11 important database designing rules.
  • Filters in MDX Queries10/30/2020 4:53:25 AM. This article explains filter conditions in MDX queries. There are so many conditions in MDX since we have SQL.
  • Tools of Business Intelligence in QlikView5/30/2014 8:23:04 PM. This article provides an introduction to business intelligence and also describes various tools of business intelligence.
  • Creating SQL Cubes5/19/2012 7:25:52 AM. An OLAP (OnLine Analytical Processing) cube is a data structure that allows fast analysis of data. It can also be defined as the capability of manipulating and analyzing data from multiple perspectives.
  • Accessing OLAP Server Data with ADO .NET 3/9/2010 11:47:43 PM. In this article I will explain accessing OLAP Server Data with ADO .NET.
  • MDX Query Bulider8/31/2006 6:00:52 AM. In this article we will be developing a MDX Query Builder.This is similar to the MDX sample application operations, which carry out the transfer of blocks from the secondary memory to the main memory and vice versa.