Course Outline
This course has been written to give delegates with existing skills in Data Warehousing with SQL Server a framework of best practises. Delegates will gain a deep understanding of Cubes, Star Schemas, and Data Mining, using SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS).
Course Content
Our hands-on Advanced Business Intelligence with SSAS and SSIS training course has been developed with real-world, commercial scenarios in mind by our expert instructors. See below for detailed syllabus. If you have a technical question, please email sales@jbinternational.co.uk
Available as a public or closed course at our London training centre, delivered on-site as a bespoke, customised training course.
What you will learn
- Cube design best practises and security
- A deep understanding of MOLAP / ROLAP / HOLAP
- MDX Queries and Scripts
- Learn how to use XMLA to create, process and back-up Cubes
- Effective Data Mining
- Creating Business Rules
- Developing Dashboards
- Configuring Dimensions and Models
- Building Add-In Forms and Reports for Excel
Advanced Business Intelligence with SSAS and SSIS Training Course Outline
Using SSIS with SSAS
Star schema stored procedures in an SSIS package
SSAS cube processing in SSIS
Deploying and scheduling an SSIS package
Using SSRS with SSAS
Introduction to SSRS report wizard
Generating MDX queries to report on a cube
Generating DMX queries to report on a data mining model
Cube design
Creating a data source
Creating a data source view
Creating simple dimensions and measures
Dimension design
Building standard dimensions
Time dimensions
Role-playing dimensions
Parent-child dimensions
Measure group design
Adding measures
Configuring dimension usage (for multiple fact table cubes)
Aggregation functions
Calculated measures
Measure formatting
Aggregation design - MOLAP/ROLAP/HOLAP
MOLAP/ROLAP/HOLAP
Degree of aggregation
Optimising aggregations
Query log
Hierarchies design
Attribute hierarchies
Natural hierarchies
Report hierarchies
Multiple hierarchy dimensions
MDX language
Creating calculated members and measures
MDX queries introduction
MDX scripts
KPIs (key performance indicators)
SSAS stored procedures overview
Localising cubes
Currency conversion
Local language cube captions
Local language cube dimension members
Folders and perspectives
Organising large cubes into folders
Segmenting large cubes with perspectives
Cube actions
Drill through (as opposed to drill down)
Displaying reports directly from cube in a pivot table
Writing values back into the cube
Cube security
Dimension security
Cell-level security
Administration and user roles
Cube storage and processing
More on MOLAP/ROLAP/HOLAP
Creating partitions
Incrementally updating partitions
Pro-active caching (real-time cubes!)
Slowly changing dimensions
Cube deployment and administration
Backing up and restoring cubes
Deployment and processing options
XMLA and AMO languages
Introduction to XMLA
XMLA to create cubes
XMLA to back up cubes
XMLA to process cubes
AMO to control cubes
Data Mining
Overview of data mining
Building mining models
Processing mining models
Building Microsoft Office Excel Add-In Forms and Reports
Build an Excel Add-In report.
Configure an Excel Add-In report as a form.
Configure report filters.
Format an Excel Add-In report.
Developing Dashboards
Create a report by using the Dashboard Designer.
Add a data source connection.
Add a new Web page report.
Configure a Key Performance Indicator (KPI) by using the Dashboard Designer.
Create a scorecard.
Build a dashboard.
