Jobs White Papers Tutorials Articles Case Studies Tools and Calculators Training Publications Contact
RDBMS - Database Design Articles, Tutorials, Whitepapers, Case Studies and Content
Most Recent Articles/Tutorials
Regimented Business with Business Analytics
Business Analytics is widely used in the various industries, organizations and corporate in a number of ways. For example Business analytics is used in banks to predict and prevent credit fraud. In retail industry it is used predict the best location for stores and how to stock them. In Pharmaceutical industry business analytics is used to invent new drugs. Even in sports like cricket business analytics is used to determine the strategy of the game and analyze the performance of a player. It is also used for players’ segmentation. In steel sector business analytics can be used to invent new variety of steels and also for better Quality Control.
Benefits attained from Business Analytics
By this Analytical approach companies attain the following:
- identify their most profitable customers
- accelerate product innovation
- optimize supply chains and pricing
- identify the true drivers of financial performance
- Better Quality Control.
MDX (Multi Dimensional eXpressions) Tutorial
- MDX stands for Multi Dimensional Expressions. This is a Microsoft proprietary language used to define and manipulate multidimensional cubes.
- MDX is similar to SQL , but not an extension of the SQL language.
- Typical MDX query has a SELECT clause, a FROM clause, and WHERE clause (filter).
- MDX expressions are used to extract required portions of data from a cube for analysis.
- MDX also supplies a robust set of functions for the manipulation of retrieved data as well as the ability to extend MDX with user-defined functions.
- MDX, like SQL, provides data definition language (DDL) syntax for managing data structures.
- There are MDX commands for creating and deleting cubes, dimensions, measures, and their subordinate objects.
Microsoft Analysis Services Tutorial
Introduction
The Microsoft Analysis Services is a feature of SQL Server which enables one to design and build powerful data warehouses and OLAP cubes on top of SQL Server based relational databases. Microsoft Analysis Services comes with powerful reporting and cube browsing features and supports dimensional model.
The Microsoft Analysis Services (also known as SQL Server 2000 Analysis Services) Tutorial is made by KnowledgeHills.com.
This is Analysis services tutorial is unofficial and is neither endorsed nor approved by Microsoft.
For the most recent and authentic tutorial, please refer to the Analysis Services Product Documentation.
This Tutorial is for educational purposes only.
Dimensional Modeling (DM) tutorial with OLAP and data warehouse design concepts
This dimensional modeling tutorial is intended for people with basic SQL and relational database design skills.
Data Management - Dimensional Modeling Definition
Dimensional modeling is the design concept used by many data warehouse designers to build their data warehouse. Dimensional model is the underlying data model used by many of the commercial OLAP products available today in the market. In this model, all data is contained in two types of tables called Fact Table and Dimension Table.