SSAS 2012 2008 Introduction to SQL Server Analysis Services for beginners and scenarios to use SSAS
- SSAS 2012 is the technology that is provided by SQL Server to create cubes.
- Organizations use cubes to manage large volumes of data so that complex queries
can be retrieved in a more efficient manner than if the queries were to be
executed against a relational database.
- With cubes, there is also the ability
to preaggregate data and store them in the cube for faster retrieval of summary
information.
- The most underused aspect of SSAS is data mining
that enables a business to perform trend analysis and identify relationships
between data that may not be immediately apparent to end users when looking at
the data.
- Analysis Services is a fantastic tool that can host the data in a
central point as information
- SQL Server Analysis Services provides the ability to efficiently query
multidimensional data. It also provides the capability to use data mining to
extrapolate trends and patterns within data.
- There are core components that you
should be aware of to create a cube.
- At its core, data sources must be defined to provide connection information
to the source data for the cube. You can then define data source views to
define the specific tables on which the cube is based. This will typically
involve dimension tables and fact tables from a data warehouse.
- You can then define dimensions within the cube against dimension tables
within the data warehouse. The dimensions will provide contextual information
and act as the axis for the cube. For improved readability, you can also define
hierarchies to allow the user to drill down into the dimension data.
- On completing the creation of the dimensions, we can then run the cube
wizard to create the cube. The wizard allows you to create a cube using
existing dimensions or from data from a table.
- You can also create an empty
cube if you do not have the data available. Once the cube is created, you can
configure cube partitions. This enables you to spread the data over multiple
physical disks to improve the performance of cube processing and querying data
in the cube.
- SQL Server Analysis Services also provides additional OLAP objects
to extend the functionality of the cube, including calculated members, KPIs, actions
and translations.
- For data mining, you can use new or existing data sources and data source
views to point to the source data. The source data for data mining can be an
existing cube or data from a table or a view.
- You can then create a data mining
structure that integrates the source data with a data mining algorithm, known
as a data mining model in order to find patterns in the data using the data
mining model. On completing this, you have the ability to view and validate the
results that are returned back to the data mining viewer.
SSAS 2012 Scenarios for Using SQL Server Analysis Services
- Analysis Services enables you to analyse large quantities of data. With it,
you can design, create and manage multidimensional structures that contain
detail and aggregated data from multiple data sources.
- Scenarios that SSAS can help with include:
- The
analysis of large volumes of data efficiently.
- The
ability to define server level KPIs that can be created and maintained
centrally.
- Add value
to cubes by creating calculations by using multidimensional expressions.
0 comments:
Post a Comment