Choose software▼
- .NET manuals
- Access manuals
- Business Intelligence manuals
- C# manuals
- Excel manuals
- Microsoft Office manuals
- Power Apps manuals
- Power Automate manuals
- Power BI manuals
- Power Platform manuals
- Programming manuals
- Python manuals
- Report Builder manuals
- SQL manuals
- SSAS manuals
- SSIS manuals
- SSRS manuals
- VBA manuals
- Visual Basic manuals
Analysis Services courseware and training manuals
Our courseware covers both areas of SQL Server Analysis Services (that is, multi-dimensional model SSAS and tabular model SSAS):
You can see details of how to license our Analysis Services courseware (including volume requirements) here.
SSAS - Tabular model courseware
Here is a list of all of our SSAS - Tabular model manual chapters (you can download the ones marked):
Chapter | Sections | Subsections |
---|---|---|
Overview of SSAS Tabular (4 pages) | What Tabular Models Do | |
Deployed Tabular Models | ||
Tabular or Multi-dimensional Models? | The Two Types of Model ; Similarities between the Two Model Types ; Why you should Use Tabular Models ; Why you should Use Multi-dimensional Models | |
Adding a Tabular Model Instance (2 pages) | Installing a Tabular Model Instance | |
Creating Projects in Visual Studio (7 pages) | Ensuring Analysis Services is Running | |
Running Visual Studio | Visual Studio Versions and Names ; Running Visual Studio | |
Configuring Visual Studio | Changing Start-up Options ; Changing the Default Server Location | |
Creating a Project | Files and Folders Created ; Projects and Solutions ; Creating Separate Folders for Solutions | |
Visual Studio Windows | Moving and Auto-Hiding Windows ; Solution Explorer and Properties | |
Models (10 pages) | Working with Models | Adding Models ; Editing Models |
Adding Data | ||
The Workspace Database | Changing the Workspace Server | |
Deploying your Database | Checking the Production Server Used ; Deploying a Model ; Viewing Deployment Progress ; Viewing the Deployed Database | |
Viewing your Model’s Data | Analysing a Model in Excel ; Browsing a Model in SSMS ; Creating a Pivot Table Based on a Model | |
Generating Measures | Using Generated Measures | |
Model tables (15 pages) | The Make-a-Mammal Database | |
Loading Tables | Step 1 – Choose to Load Tables ; Step 2 – Connecting to the Database ; Step 3 – Choosing Data Tables ; Step 4 – Loading the Data ; Step 5 – Saving your Model | |
Importing More Tables using an Existing Connection | ||
Filtering Rows and Columns on Import | Ignoring Columns ; Filtering Rows | |
Data and Diagram View | Zooming In and Out in Diagram View | |
Hiding Columns and Tables | The Need to Hide Columns/Tables ; Hiding Tables ; Hiding Columns ; Choosing not to Display Hidden Columns and Tables | |
Renaming Tables and Columns | Renaming Columns ; Renaming Tables | |
Changing what you’ve Imported for a Table | ||
Relationships | Editing Relationships ; Creating Relationships ; Editing and Creating Relationships Manually | |
Pivot Tables in Excel (16 pages) | Creating the Model and Measures | |
Creating a Pivot Table | ||
Drill Down | ||
Quick Explore | ||
Working with Pivot Tables | Renaming Fields ; Refreshing Changes to the Model ; Changing Number Formatting ; Moving Rows and Columns ; Sorting Pivot Tables | |
Filtering | ||
Slicers | Creating Slicers ; Removing Slicers (or their Filters) ; Changing the Number of Slicer Columns ; Changing the Style of a Slicer ; Aligning Slicers | |
Controlling Multiple Pivot Tables with Slicers | First Rename your Pivot Table ; Getting a Slicer to Control Multiple Pivot Tables ; An Alternative Method – Telling a Pivot Table which Slicers Control it | |
Formatting Pivot Tables | ||
Choosing what to Display | Hiding Field Captions ; Inserting Blank Rows ; Subtotals and Totals ; Changing Report Layout ; Repeating Item Labels | |
OLAP Tools | ||
Other Data Sources (11 pages) | Formats Supported | |
Starting to Import from Other Sources | Using 32-bit Excel or Access Data Sources on 64-bit Computers | |
Linking to Access | ||
Importing Excel Workbooks | ||
Importing Text or CSV Files | ||
Importing from the Clipboard | Creating a New Table from the Clipboard ; Appending Existing Data from the Clipboard | |
Importing from Reporting Services | ||
Importing from Analysis Services | Importing from Multi-Dimensional Models ; Designing the Cube Query in MDX ; Importing from Tabular Models using MDX ; Importing from Tabular Models using DAX | |
Calculated Columns (8 pages) | What are Calculated Columns? | Differences between Calculated Columns and Excel Formulae |
Creating Calculated Columns | An Alternative Method, using the Keyboard | |
Working with Calculated Columns | Moving Calculated Columns ; Sorting by Calculated Columns | |
The Function Wizard | ||
Using RELATED to Link Tables | ||
The BLANK Function | Blank Arithmetic | |
Aggregator Columns and SWITCH | The IF Function ; The SWITCH Function | |
Power View Introduction (11 pages) | What is Power View? | |
Enabling the Power View Add-in | ||
Creating a Connection to your Model | Step 1 – Starting to Create a Connection ; Saving a Connection for Reuse ; Creating a Power View Report | |
Basic Visualisations (Tables) | Starting a Table ; Adding Fields to a Visualisation ; Removing Fields ; Changing Column Order ; Changing Aggregation Methods ; Sorting a Table or Visualisation ; Showing or Hiding Totals | |
Selecting, Resizing, Moving and Deleting | Resizing Tables and Fields ; Moving Tables and Fields ; Selecting and Deleting Objects | |
Power View Window Settings | Controlling what’s on Screen ; Popping Out Windows | |
Formatting | Tools on the POWER VIEW Ribbon Tab ; Number Formatting | |
Text Boxes and Images | Text Boxes ; Images | |
Filtering in PowerView (5 pages) | Types of Filter in Power View | |
Slicers | ||
Tiles | Types of Tile ; Creating Tiles ; Removing Tiles ; Adding Visualisations to Tiles | |
Filters | Setting Report-Level Filters ; Filters for a Specific Table, Chart or Matrix ; Applying Filters | |
Matrices and cards (2 pages) | About Matrices and Cards | Matrices ; Cards and Callouts |
Drill-down for Matrices | ||
Charts in PowerView (8 pages) | Introduction to Charts | |
Creating Charts | Step 1 – Create a Basic Table ; Step 2 – Make this into a Chart ; Step 3 – Make this a Multiple Chart ; Step 4 – Setting the Title and Legend ; Step 5 – Filtering the Chart | |
Drill Down in Pie Charts | ||
Scatter and Bubble Charts | Scatter Charts ; Colouring and Labelling Scatter Charts ; Bubble Charts ; Playing Bubble or Scatter Charts | |
Measures (7 pages) | Calculated Columns vs. Measures | Calculated Columns are Row-Based ; Measures are Aggregated ; Pivot Table Placement ; Note on Differences from PowerPivot |
Creating Measures | Step 1 – Choosing a Host Table ; Step 2 – Choosing a Cell ; Step 3 – Creating the Measure ; Step 4 – Naming your Measure ; Step 5 - Changing the Default Formatting ; Step 6 - Applying Filters to Test your Measure ; Step 7 - Testing your Measure in Excel | |
Filter Context | ||
DAX Editors (6 pages) | Summary of Alternate Editors | Shortcomings of the Built-in Editor ; Third-Party Tools Available |
DAX Studio | Installing DAX Studio ; Connecting to your Model ; Refreshing your Model ; Hints on Using DAX Studio ; Copying Measure Formulae into SSAS | |
DAX Editor | Installing and Running DAX Editor ; Using DAX Editor ; Connecting to the Right Database ; Problems with DAX Editor | |
Measure Syntax (5 pages) | Basic Syntax Rules | Data Types ; Symbols you can Use |
Aggregation Functions | Aggregating a Column ; Aggregating an Expression (X-Suffix Functions) | |
Calculating Ratios | Counting Rows using the COUNTROWS Function ; Creating Ratios: the Fields Needed ; The Final Pivot Table ; Summing Ratios wouldn’t Work | |
The CALCULATE Function (5 pages) | Syntax of the CALCULATE Function | |
Replacing Individual Filters | Replacing a Single Filter ; Replacing More than One Filter | |
Removing Filters Using ALL | Removing a Single Filter ; Removing Multiple Filters ; Removing All Filters bar One | |
Using VALUES to Edit a Constraint | On its own, VALUES is pointless ; Amending the Filter Context Filter | |
The FILTER Function (3 pages) | Syntax of the FILTER Function | |
Filtering to Show Subsets of Data | ||
Removing Filters using ALL | Removing and Partially Reinstating Filters | |
The EARLIER Function (4 pages) | Overview of the EARLIER Function | Our Three Worked Examples ; What the EARLIIER Function Does |
Case Study: Running Totals | ||
Case Study: Ranking using EARLIER | ||
Case Study: Group Averages | ||
Banding (3 pages) | What is Banding? | Creating a Banding Table |
Creating a Banding Formula | ||
Sorting the Bands | ||
Ranking (4 pages) | The RANKX Function | Syntax of the Rank Function ; Entering RANKX in a Calculated Column |
Using RANKX in Measures | Step 1 – Creating the Measure to Rank ; Step 2 – using ALL | |
Customising Ranking | Changing the Sort Order ; Dealing with ties ; Hypothetical sorting | |
Calendars (11 pages) | The Need for a Separate Date Table | The Excel Approach – Date Functions ; The Tabular Approach – Create a Separate Table |
Creating your Dates Table | Creating a Calendar Table in Excel ; Creating a Calendar Table in SQL Server | |
Creating Relationships | Changing Column Data Types in Preparation ; Creating Relationships ; Using Integer Date Keys | |
Announcing your Date Table to the World | ||
Using Calendars in Pivot Tables | Sorting Months (and Other Fields) | |
Managing Date Granularity | ||
Timelines | ||
Creating New Aggregator Columns | A Bad Solution ; The Better Solution: a Bank Holiday Table ; Creating a Relationship for the Bank Holiday Table ; Creating a Calculated Column for Working Days | |
Multiple Calendar Tables (4 pages) | The Problem, and Two Solutions | Repeat the Table or the Relationship? |
Solution One: Duplicate the Calendar Table | ||
Solution Two: Duplicate the Relationship | The CALCULATETABLE Function ; The USERELATIONSHIP Function ; Our Measures | |
Date Functions (11 pages) | Contents | |
Period to Date | Using DATESYTD (and how Date Functions Work) ; TOTALYTD, TOTALQTD and TOTALMTD ; Changing the Financial Year End | |
Comparing with Previous Periods | The SAMEPERIODLASTYEAR Function ; Using DATEADD to Compare with any Previous Period | |
Parallel Periods | ||
Moving Averages | ||
Semi-Additive Measures | Opening and Closing Balances – the Problem ; A Partial Solution using the LastDate/FirstDate Function ; Using LastNonBlank or FirstNonBlank | |
Using PERIOD Tables | Step 1 – Create a Period Dimension ; Step 2 – Create the Date Measures ; Step 3 – Create the Necessary Dimension Measure ; Step 4 – Creating your Pivot Table | |
KPIs
(5 pages)
Download this chapter |
About KPIs | Three Parts of a KPI |
Creating a KPI | Step 1 – Create the Calculated Fields Needed ; Step 2 – Starting to Create the KPI ; Step 3 – Customising your KPI ; Step 4 – Displaying the KPI in Excel | |
Absolute Targets | ||
Hierarchies (9 pages) | Using Hierarchies | Advantages and Disadvantages of Hierarchies |
Creating Hierarchies | Step 1 – Getting the Correct Fields in a Single Table ; Step 2 – Creating the Hierarchy ; Step 3 – Including Fields in your Hierarchy ; Step 4 – Using a Hierarchy | |
Parent-Child Hierarchies | What is a Parent-Child Hierarchy? ; Step 1 – Create a List of Parent Ids (the PATH Function) ; Step 2 – Working out the Path Depth (the PATHLENGTH Function) ; Step 3 - Finding Managers at Each Level (the PATHITEM Function) ; Step 4 – Returning each Manager’s Name (the LOOKUPVALUE Function) ; Step 5 – Creating a Hierarchy ; Step 6 – Dealing with Blanks ; Step 7 – Suppressing Extra Levels (the ISFILTERED Function) | |
Perspectives (4 pages) | What are Perspectives? | |
Creating Perspectives | ||
Using Perspectives | Switching Perspectives in a Model ; Choosing a Perspective when Analysing Data in Excel ; Choosing Perspectives for Data Connections ; Changing the Perspective for an Existing Pivot Table | |
Prototyping in PowerPivot (8 pages) | Enabling PowerPivot | |
Using PowerPivot | ||
Summary of Differences between PowerPivot and SSAS Tabular | Different Pivot Table Field List ; Implicit Measures ; Creating Measures in the Client ; Linked Excel Tables | |
Uploading PowerPivot Models into Tabular | Preparation: SQL Server 2012 Updates ; Preparation: Remove Linked Tables? ; Importing a PowerPivot Model | |
Using DAX and MDX Queries (12 pages) | Comparing DAX and MDX | Which Packages Support which Language? |
Querying Data in Management Studio | Management Studio Queries using MDX ; Management Studio Queries using DAX | |
Creating SSRS Reports | Creating a Shared Data Source and Starting a Dataset ; Querying for SSRS using MDX ; Querying for SSRS Using DAX | |
DAX (or MDX) in PowerPivot | ||
Integration Services Data Sources | Step One – Creating a Data Source and Connection ; Step Two – Choose a Provider ; Step Three – Choosing a Database ; Step Four – Pasting your DAX or MDX Query | |
DAX and MDX for Excel | Step 1 – Starting to Create the Connection ; Step 2 – Finishing the Connection ; Step 3 – Make your Connection use a Query ; Step 4 – Using this Connection ; Step 5 – Setting the Query | |
Writing DAX Queries (11 pages) | DAX Studio | |
SQL versus DAX Querying | ||
Listing Tables (EVALUATE) | Listing All Rows ; Ordering Rows ; Starting at a Particular Row ; Returning N Rows Only ; Sampling Rows | |
Summarising | Summarisation Syntax ; Examples of Summarisation ; Using ROLLUP to get All Combinations | |
Filtering in DAX Queries | Example: Summarising Sales for Birds Only ; Example: Summarising Centre Size for Selected Towns | |
Adding Columns | Example: Counting Rows ; Example: Transaction Statistics by Town ; Defining Measures First | |
Combining Table Results | GENERATE and GENERATEALL | |
Other Useful Functions | Using ROW to Display One Row of Data ; Using CONTAINS to Check if a Field Value Exists | |
Processing (10 pages) | Column Storage | Row versus Column Storage ; Data Compression |
Ways to Speed up Processing | Sort Tables First ; Omit High-Cardinality Columns where Possible ; Avoid Calculated Columns ; Avoid Expensive Queries ; Use Server Timings ; Don’t Store DateTime Columns ; Consider Splitting Id Columns | |
Processing Concepts | What Processing Involves (Data/Metadata) ; Two Stages of Processing ; Types of Processing ; The Most Efficient Strategy | |
Processing in SSDT | Processing an Individual Table ; Processing All Tables for a Given Connection ; Processing an Entire Model ; Changing Processing Options for Deployment | |
Processing in SSMS | Processing an Entire Database ; Processing Tables | |
Partitions (5 pages) | Partitions | |
Partitions in SSDT | Processing Partitions in SSDT | |
Partitions in SSMS | Processing Partitions in SSMS | |
DirectQuery (5 pages) | What is DirectQuery? | How Normal Tabular Models Work ; How DirectQuery Works |
Enabling DirectQuery | Limitations of DirectQuery ; Enabling DirectQuery Mode for a Model ; Dealing with Errors ; Working in DirectQuery Mode | |
Deploying DirectQuery Models | The Four Possible Query Modes for Deployment ; Switching Query Mode after Deployment | |
Security (11 pages) | Overview of Security | Types of Role in SSAS Tabular ; Levels of Database Access |
Server Administrators | ||
Managing Roles | Managing Roles in SSDT ; Managing Roles in Management Studio | |
Controlling Data Access (Row Filters) | Row Filters in SSDT ; Row Filters in SSMS | |
Three Ways to Test Row Filters | Testing using Excel ; Testing using Connection Strings ; Testing by Running as a Different User | |
Creating a Permissions Table | ||
Dynamic Security | Two DAX Functions Needed ; Using CustomData for Dynamic Security ; Incorporating a Test for the User Name |
SSAS - Multi-dimensional courseware
Here is a list of all of our SSAS - Multi-dimensional manual chapters (you can download the ones marked):
Chapter | Sections | Subsections |
---|---|---|
Multidimensional BISM (6 pages) | Types of Data Storage Structures | Relational Databases ; Multidimensional Model |
Comparison of the Two Storage Methods | OLTP and OLAP ; A Diagram Showing OLAP versus OLTP | |
Cubes | Cubes as Pivot Tables ; Cubes as SQL Query Results ; Cube Size | |
Summary of Jargon | Dimensions, Measures and Facts | |
Creating multidimensional projects (6 pages) | Your Choice of Project | A Summary of the Differences between the Two Models |
Data Tools / Visual Studio | SQL Server Data Tools and Visual Studio ; Configuring SQL Server Data Tools ; Running Visual Studio | |
Configuring Visual Studio | Changing the Start-Up Options ; Changing how Windows Appear | |
Creating a Project | ||
Data Sources (2 pages) | Creating a New Connection | |
Connecting to a Data Source | ||
Data Source Views (12 pages) | What is a Data Source View? | |
Creating a Data Source View | Choosing Tables ; Filtering Tables ; Choosing Related Tables ; Finishing the Data Source View Wizard | |
Editing Data Source View Layout | Working with Diagrams ; Adding Tables to a Diagram or Data Source View ; Adding Relationships ; Adding Logical Primary Keys ; Changing to Diagonal Layout ; Finding Tables ; Zooming In ; Selecting and Moving Tables ; Showing Tables of Data | |
Named Queries | Named Queries versus Views ; Creating a Named Query | |
Calculated Columns | ||
Dimensions (18 pages) | Our Example | |
Creating a Dimension | Specifying the Dimension Table and Columns ; Finishing the Dimension Wizard | |
Dimension Attributes | Primary Key Attribute ; Non-Key Attributes ; Adding an Attribute after the Wizard has Finished ; Hierarchies | |
Deploying Dimensions | Deploying a Project | |
Browsing a Dimension | ||
Making Changes to a Dimension | Editing a Dimension ; Changing How Attributes are Listed ; Renaming Dimensions and Attributes ; Changing the Column Displayed ; Changing the Sort Order ; Removing Ordering to Speed Up Processing ; Renaming the Top Node of a Dimension ; Renaming the Unknown Value | |
Displaying Other Columns (AttributeHierarchyEnabled) | How to Display Additional Columns ; The Problem - Attribute Hierarchies are Exposed ; Method 1 - Disabling Browsing when Creating a Dimension ; Method 2 - Disable the AttributeHierarchyEnabled Property | |
Grouping and Banding | Using Discretization ; Using your Own Groups | |
Publishing Dimensions and Cubes (12 pages) | The Stages of Publication | The Stages (Building, Deployment and Processing) |
Building a Project | Differences between Build and Rebuild ; Differences between Building a Project and Solution | |
Deploying a Project | Setting the Target Server and Other Properties ; Deploying ; Changing How Deployment Affects Processing | |
Processing a Dimension or Cube | ||
Browsing a Dimension or Cube | ||
Deployment Warning and Error Messages | Viewing Deployment Messages ; Dismissing Specific Warnings ; Dismissing Warnings Permanently | |
Viewing the Analysis Services Database | ||
Typical Problems (and their Solutions) | Do a Full Process on your Dimensions ; Deleting the Analysis Services Database | |
Cubes (12 pages) | Cubes Overview | Example Used for this Chapter ; Terms Used for Cubes |
Using the Cube Wizard | Step 1 – Starting the Wizard ; Step 2 – Choosing Measure Groups ; Step 3 – Choosing Measures ; Step 4 – Choosing Dimensions ; Step 5 – Finishing your Cube | |
The Cube Designer | Displaying Measures in a Grid ; Editing Dimensions from Cube Designer | |
Deploying and Browsing Cubes | Deploying a Cube | |
Choosing What to Display in a Cube | The Parts of the Browser Window ; Showing Cube Data ; Analysing Cube Data in Excel | |
Filtering a Cube | ||
Star and snowflake schemas (4 pages) | Snowflake Schemas | An Example of a Snowflake Schema ; How Snowflake Schemas Work ; Advantages and Disadvantages of Snowflake Schemas |
Star Schemas | Example of a Star Schema ; Retrieving Data in a Star Schema ; Advantages and Disadvantages of Star Schemas ; Characteristics of Star Schema Tables | |
Hierarchies and relationships
(12 pages)
Download this chapter |
Dimension Hierarchies Explained | Our Example ; Default Primary Key Attribute Hierarchy ; Natural Hierarchies ; Unnatural or User-Defined Hierarchies |
Creating a Hierarchy | The Hierarchies Created by Default ; The Hierarchy for this Worked Example ; Step 1 - Adding the Necessary Attributes ; Step 2 - Creating the Hierarchy ; Step 3 - Adding Levels ; Step 4 - Renaming the Hierarchy and its Levels ; Step 5 - Testing your Hierarchy | |
Using Hierarchies within Cubes | Hiding Dimensions (AttributeHierarchyVisible Property) | |
Creating Attribute Relationships | Attribute Relationships Warning Messages for Hierarchies ; The Attribute Relationships Pane ; Creating a Relationship by Drag and Drop ; Creating a Relationship Manually ; Rigid and Flexible Relationships | |
Hierarchies for a Snowflake Schema | Creating our dimension ; Creating Snowflake Schema Hierarchies | |
Parent-Child Hierarchies (8 pages) | What is a Parent-Child Hierarchy? | |
Creating a Parent-Child Hierarchy | Creating a Self-Join on the Trainer Table ; Starting the Dimension Wizard ; Choosing Attributes ; Parent and Key Attributes ; Deploying and Browsing the Parent-Child Dimension | |
Tidying Up a Parent-Child Dimension | Removing the All Level ; Showing Who is Boss ; Hiding the Unknown Member ; Showing Organisational Level Names | |
Limitations of Parent-Child Hierarchies | ||
Time Dimensions (14 pages) | Overview | |
Issues to Consider for Time Dimensions | Three Ways to Create Time Dimensions ; Choice of Primary Key ; Reasons to Use your Own Time Dimension ; SQL Procedure to Generate your Own Time Dimension | |
Time Dimensions Using Tables you’ve Created | Step 1 – Check your Tables ; Step 2 – Create your Data Source ; Step 3 – Start to Create your Dimension ; Step 4 – Choose your Dimension Attributes ; Step 5 – Creating Calendar Hierarchies ; Step 6 – Creating Attribute Relationships ; Step 7 – Renaming Attributes ; Specifying a Dimension as a Time Dimension | |
Autogenerating Time Dimensions | Step 1 – Choosing where to Store your Dimension ; Step 2 – Configuring the Dimension ; Step 3 – Generating the Table ; Step 4 – Viewing the Final Dimension ; Step 5 – Making Changes to the Final Dimension | |
Measures (6 pages) | Working with Measures | Choosing Measures within a Cube ; Adding New Measure Groups and Measures ; Renaming Measures and Measure Groups ; Creating Measure Folders |
Formatting Measures | Syntax of Formatting Strings | |
Aggregating Measures | Basic Aggregations (Sum, Min, Max) ; Counting ; Other Functions | |
Multiple Fact Tables (6 pages) | Our Example | |
Creating a Cube with Multiple Measure Groups | ||
Unrelated Dimension Settings | ||
Dimension Usage | ||
Creating Measure Groups from Dimension Tables | ||
Advanced Dimensions (4 pages) | Role-Playing Dimensions | |
Referenced Dimensions | When to Use a Reference Dimension ; Our Example ; Creating a Reference Dimension | |
Error Configuration | Controlling When and How Dimension Errors are Reported ; Controlling MDX Error Messages | |
Calculations (6 pages) | Our Example | The Base Cube |
Creating Calculations | ||
Fine-Tuning Calculations | Formatting Calculations ; Choosing Display Folders for Calculations ; Non-Empty Behaviour Box ; Conditional Formatting | |
Calculated Measures using MDX (4 pages) | What is MDX? | Types of MDX |
Viewing Calculations as Script | ||
Typing in MDX Expressions | Typing in a Calculation ; Using MDX Calculations in Cubes ; Viewing MDX Script in Form View Again ; Basic Syntax | |
Writing MDX Queries (12 pages) | Our Example | Our Example Dimensions |
Creating a Basic Query | ||
Axes | Number and Order of Axes ; Examples of Queries Using Axes | |
Using the Query Editor | Commenting Queries ; Commenting Out Instructions ; Running Part of a Query | |
Measures in MDX Queries | The Default Measure Aggregation ; Changing the Default Measure and Aggregation ; Displaying Multiple Measures ; What the Simplest Query will Display | |
Referring to Individual Members | Basic Syntax ; Using Names or Keys | |
Sets of Members | Ranges of Members ; Named Sets | |
Tuples | ||
WHERE Clauses | ||
Examples of MDX Expressions (12 pages) | Year to Date | How the YTD Function Works ; Pre-Requisite: a Time Dimension of Type Year ; Creating the YTD Measure |
Ratios | Our Example Hierarchy ; Calculating the Ratio against the Immediate Parent ; Calculating the Ratio against an Ancestor ; Avoiding Top-Level Errors ; Avoiding Divide-By-Zero Errors | |
Previous Period Comparisons | The PrevMember Function ; The ParallelPeriod Function | |
Ranking | An Example of the Rank Function ; ASC/DESC versus BASC/BDESC | |
Conditional Formatting | ||
Aggregating Members of a Dimension | ||
KPIs (8 pages) | What are KPIs? | Our Example KPIs |
Parts of a KPI | Possible Values for Status and Trend | |
Creating KPIs | Creating the Necessary Calculated Members ; Creating a KPI ; Assigning a Value and Goal to the KPI ; Setting the Status Expression ; Setting the Trend Expression ; Browsing your KPIs | |
Using KPIs in Client Tools | ||
Using KPI Functions | ||
Using Client Software (8 pages) | Using Excel as a Client | Creating a New Connection to SSAS ; Linking to SSAS Using an Existing Connection ; Creating a Pivot Table in Excel |
Using Reporting Services as a Client | Creating a Data Source ; Creating a Dataset ; Creating a Report | |
Cube Actions (6 pages) | Types of Action Available | URL Actions ; Drill-Through Actions |
Adding a URL Action | Creating a URL Action ; Decide on the Scope of your Action ; Choosing a Target for your Action ; Applying a Condition ; Setting the URL ; Customising the Caption ; Viewing your Menu | |
Adding a Drill-Through Action | ||
Mining Models (20 pages) | Introduction | Our Example Data ; Mining Models and Mining Structures ; Creating a Project and Data Source View |
Creating a Mining Model | Step 1 – Starting the Mining Structure Wizard ; Step 2 – Choosing Tables ; Step 3 – Choosing the Key, Input and Predictable Columns ; Step 4 – Making Initial Data Type Choices ; Step 5 – Allocating Data between Testing and Validation ; Step 6 – Finishing the Wizard ; Step 6 - Changing Content Types ; Step 7 - Fine-Tuning the Mining Model ; Step 8 – Deploying the Mining Model | |
Viewing Mining Model Results | ||
Reviewing the Accuracy of the Model | Step 1 - Choosing Data for your Accuracy Testing ; Step 2 – Charting the Accuracy of your Model (Lift Charts) ; Viewing Summary Accuracy Figures | |
Using the Model Results | DMX | |
Adding a Model to an Existing Mining Structure | Adding a Model ; Using the Added Clustering Model ; Comparing Clusters Visually ; Looking at Individual Clusters ; Comparing Two Clusters | |
Data Mining Algorithms (6 pages) | Data Mining Algorithms | Association Rules Algorithm ; Decision Trees ; Clustering Algorithm ; Neural Networks ; Logistic Regression ; Linear Regression ; Naive Bayesian ; Sequence Clustering Algorithm ; Time Series Algorithm |
When to Use Which Algorithm | ||
SSAS 2008 R2 Considerations (2 pages) | Browsing Cubes | |
The Cube Browser LocaleIdentifier Language Problem |
Notes:
- Since Wise Owl print courseware double-sided to save trees, the number of physical pages in each chapter is roughly half of the number of sides quoted.
- Downloads are provided as examples only, and should not be used or distributed in any way or form without the prior written permission of Wise Owl.
This page has 0 threads
Add post