Choose software▼
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