Font size:

Microsoft SQL Server 2014 - Designing BI Solutions video collection

165 videos    $99.00
Title Author Info
Designing a Recovery Strategy Aaron Sampson 5 minutes
Aggregation Performance Design Aaron Sampson 5 minutes
AlwaysON Availability Groups and Interoperability Aaron Sampson 5 minutes
Analytical Data Models and Reporting Aaron Sampson 9 minutes
Authentication Mechanisms Aaron Sampson 7 minutes
Backing Up and Restoring the SSIS Catalog Aaron Sampson 4 minutes
Backing Up SSAS Databases Aaron Sampson 5 minutes
Backing Up SSRS Databases Aaron Sampson 4 minutes
BI Infrastructure Upgrade Considerations Aaron Sampson 6 minutes
Business Intelligence Semantic Models Aaron Sampson 6 minutes
Choosing the Appropriate Schema for a Data Model Aaron Sampson 7 minutes
Common Reporting Scenarios for BI Solutions Aaron Sampson 7 minutes
Configuring Binding Options for Partitions Aaron Sampson 7 minutes
Configuring Data Compression on Fact Table Partitions Aaron Sampson 8 minutes
Configuring Data Refresh for PowerPivot Aaron Sampson 6 minutes
Configuring External Access to SSAS (Part 1) Aaron Sampson 5 minutes
Configuring External Access to SSAS (Part 2) Aaron Sampson 7 minutes
Configuring External Access to SSAS (Part 3) Aaron Sampson 8 minutes
Configuring Logging in an ETL Process Aaron Sampson 6 minutes
Configuring Memory Setting for Reporting Services Aaron Sampson 6 minutes
Configuring Package and Project Deployment Security Aaron Sampson 6 minutes
Configuring PowerPivot Aaron Sampson 7 minutes
Configuring Relationships Between Tables Aaron Sampson 8 minutes
Configuring SSAS for Trusted Delegation Aaron Sampson 6 minutes
Configuring SSAS to Allow for Impersonation Aaron Sampson 5 minutes
Create and Publish a Report to SharePoint Aaron Sampson 7 minutes
Creating a Cube for a Multidimensional Model Aaron Sampson 5 minutes
Creating a Data Alert Aaron Sampson 6 minutes
Creating a Data Source for Analytical Models Aaron Sampson 5 minutes
Creating a Package Deployment Utility Aaron Sampson 4 minutes
Creating a Subscription for SSRS in SharePoint Mode Aaron Sampson 5 minutes
Creating and Managing Schedules in Native Mode Aaron Sampson 8 minutes
Creating Datasets Using Query Parameters Aaron Sampson 5 minutes
Creating Indexes and Assess their Performance Aaron Sampson 8 minutes
Creating Package Configuration Files Aaron Sampson 9 minutes
Creating Partitions for a Cube Aaron Sampson 6 minutes
Creating Query-Scoped Calculated Members Aaron Sampson 5 minutes
Creating Roles for Access at Different Levels Aaron Sampson 6 minutes
Creating Session-Scoped Calculated Members Aaron Sampson 5 minutes
Creating Shared and Embedded Data Sources Aaron Sampson 5 minutes
Creating Stored Credentials Aaron Sampson 4 minutes
Creating Tables in a Tabular Model Part 1 Aaron Sampson 7 minutes
Creating Tables in a Tabular Model Part 2 Aaron Sampson 6 minutes
Customizing Data Acquisition Using DAX Aaron Sampson 3 minutes
Data Warehouse and ETL Solution for a BI Infrastructure Aaron Sampson 8 minutes
Data Warehouse Database Design Aaron Sampson 4 minutes
Defining Measure Groups Aaron Sampson 6 minutes
Defining Measures Aaron Sampson 4 minutes
Designing a Data Acquisition Strategy Aaron Sampson 7 minutes
Designing a Relational Model for a Data Mart Aaron Sampson 7 minutes
Designing Aggregations for Partitions Aaron Sampson 5 minutes
Designing AlwaysON Availability Groups Aaron Sampson 6 minutes
Designing an AlwaysON Failover Cluster Instance Aaron Sampson 7 minutes
Designing and Configuring Dimensions Aaron Sampson 8 minutes
Designing and Configuring Write Back for a Cube Aaron Sampson 5 minutes
Designing and Creating a Drill-through Report Aaron Sampson 7 minutes
Designing and Creating a Report with a Map Aaron Sampson 8 minutes
Designing and Creating Aggregations Aaron Sampson 9 minutes
Designing and Creating Linked Reports Aaron Sampson 5 minutes
Designing and Creating Report Templates Aaron Sampson 6 minutes
Designing Cubes for Drill-Through Aaron Sampson 7 minutes
Designing Data Retention Aaron Sampson 5 minutes
Designing Data Sources and Data Sets Aaron Sampson 5 minutes
Designing Data Sources for Analytical Models Aaron Sampson 6 minutes
Designing Dimension Keys; Attributes; and Hierarchies Aaron Sampson 7 minutes
Designing Dimension Modeling and Documentation Aaron Sampson 7 minutes
Designing for High Availability Aaron Sampson 5 minutes
Designing for Specific Types of Reports Aaron Sampson 6 minutes
Designing Indexes and Index Views for Processing Aaron Sampson 6 minutes
Designing MDX Calculations Aaron Sampson 6 minutes
Designing Multidimensional Cubes Aaron Sampson 7 minutes
Designing Partition Strategies for a Cube Aaron Sampson 5 minutes
Designing Proactive Caching within SSAS Aaron Sampson 7 minutes
Designing Scaling for a BI Solution Aaron Sampson 6 minutes
Designing Self-Referencing Dimension Tables Aaron Sampson 6 minutes
Designing Slowly Changing Data and Unknown Values Aaron Sampson 7 minutes
Designing Time Dimension Tables Aaron Sampson 6 minutes
Determining Storage Requirements Aaron Sampson 5 minutes
Enabling Logging for Package Execution in SSIS Aaron Sampson 4 minutes
Enabling Report Server Content Types to a Library Aaron Sampson 4 minutes
Estimate MCR; CPU and Memory Requirements Aaron Sampson 7 minutes
ETL Data Flow Architectures Aaron Sampson 6 minutes
Examining the Source Data for the ETL Solution Aaron Sampson 9 minutes
Handling Errors and Audit Information Aaron Sampson 9 minutes
Handling Invalid Rows Aaron Sampson 10 minutes
Identifying Common MDX Functions Aaron Sampson 5 minutes
Implementing Change Data Capture Aaron Sampson 8 minutes
Implementing Data Compression Aaron Sampson 8 minutes
Implementing Dynamic Dimension Security Aaron Sampson 9 minutes
Implementing Slowly Changing Dimensions Aaron Sampson 8 minutes
Installing Packages to the File System or Instance Aaron Sampson 9 minutes
Installing PowerPivot for SharePoint Aaron Sampson 7 minutes
Installing Reporting Services in SharePoint Mode Aaron Sampson 9 minutes
Installing the PowerPivot for SharePoint Add-in Aaron Sampson 5 minutes
Installing the Reporting Services Add-in for SharePoint Aaron Sampson 5 minutes
Loading Partitioned Fact Tables Aaron Sampson 9 minutes
Managing Data Rights and Security for a Data Set Aaron Sampson 6 minutes
Managing Datasets Using Stored Procedures Aaron Sampson 5 minutes
Managing Scope and Context Aaron Sampson 8 minutes
Managing the SSIS Catalog Aaron Sampson 6 minutes
Microsoft Products Roles in the BI Infrastructure Aaron Sampson 7 minutes
Monitoring a Data Warehouse Using Performance Monitor Aaron Sampson 7 minutes
Optimizing SSRS Performance Using Caching and Snapshots Aaron Sampson 6 minutes
Overview of Building a BI Project Aaron Sampson 5 minutes
Overview of SharePoint Integration Mode Features Aaron Sampson 4 minutes
Performing a Searched Case Statement Aaron Sampson 5 minutes
Performing a Simple Case Statement Aaron Sampson 6 minutes
Planning a Subscription Strategy Aaron Sampson 5 minutes
Planning Data Compression Aaron Sampson 5 minutes
Planning Data Refresh for PowerPivot Aaron Sampson 7 minutes
Planning Database File Storage Aaron Sampson 7 minutes
Planning for Data Alerts Aaron Sampson 4 minutes
Planning for Incremental Loads and Full Loads Aaron Sampson 5 minutes
Planning for Report Delivery Aaron Sampson 5 minutes
Planning for the Size and Workload Aaron Sampson 6 minutes
Planning Indexes for Queries Aaron Sampson 7 minutes
Planning Schedules for Report Processing Aaron Sampson 7 minutes
Planning Security for Report Processing Aaron Sampson 4 minutes
Planning Table Partitioning Aaron Sampson 10 minutes
Planning Views Aaron Sampson 6 minutes
Publishing and Accessing a Workbook Using PowerPivet Aaron Sampson 7 minutes
Reducing Load Times and Plan Extraction Windows Aaron Sampson 7 minutes
Reporting and Analysis Design in a BI Solution Aaron Sampson 4 minutes
Requirements for SSRS Configurations Aaron Sampson 3 minutes
Restoring SSAS Databases Aaron Sampson 4 minutes
Restoring SSRS Databases Aaron Sampson 5 minutes
Setting Processing Options for Reports Aaron Sampson 5 minutes
Setting Up a Server Environment for a Project Aaron Sampson 7 minutes
SharePoint Infrastructure Design in a BI Solution Aaron Sampson 8 minutes
SQL Server BI Topologies Aaron Sampson 4 minutes
SQL Server High Availability Solutions Aaron Sampson 7 minutes
Testing for Impersonated or Delegated Identity Aaron Sampson 4 minutes
The BI Infrastructure Data Sources Aaron Sampson 9 minutes
The Infrastructure and Personnel to Build a BI Project Aaron Sampson 4 minutes
The MDX Query Structure Aaron Sampson 6 minutes
The Project Deployment Model Aaron Sampson 7 minutes
The Reporting Requirements for a BI Solution Aaron Sampson 4 minutes
The Reporting Services Infrastructure Aaron Sampson 4 minutes
The Reporting Services Modes Aaron Sampson 6 minutes
Tools Used for Report Creation and Delivery Part 1 Aaron Sampson 5 minutes
Tools Used for Report Creation and Delivery Part 2 Aaron Sampson 5 minutes
Transformations in an ETL Solution Aaron Sampson 7 minutes
Types of Columns for a Fact Table Aaron Sampson 5 minutes
Types of Measures Stored and Common Fact Tables Aaron Sampson 6 minutes
Understanding the SharePoint Server Integration Steps Aaron Sampson 3 minutes
Using Catalog Stored Procedure and Views for Logging Aaron Sampson 6 minutes
Using Data Collector to Gather Performance Data Aaron Sampson 7 minutes
Using DAX Queries in Datasets Aaron Sampson 7 minutes
Using MDX Set Functions (Part 1) Aaron Sampson 9 minutes
Using MDX Set Functions (Part 2) Aaron Sampson 6 minutes
Using MDX to Extract Data Aaron Sampson 5 minutes
Using MDX Tuple Functions Aaron Sampson 10 minutes
Using Parameters in Packages Aaron Sampson 9 minutes
Using Performance Monitor to Monitor SSRS Aaron Sampson 6 minutes
Using Performance Monitor to Troubleshoot SSAS Aaron Sampson 5 minutes
Using Resource Governor to Balance Load Resources Aaron Sampson 10 minutes
Using SQL Server Profiler to Monitor DAX Queries Aaron Sampson 4 minutes
Using SQL Server Profiler to Monitor MDX Queries Aaron Sampson 5 minutes
Using the Balanced Data Distributor Transformation Aaron Sampson 6 minutes
Using the Integration Service Deployment Wizard Aaron Sampson 6 minutes
Viewing Log Entries in the Log Events Windows Aaron Sampson 4 minutes
Viewing Package Execution Reports Aaron Sampson 6 minutes
Choosing the Appropriate BISM Aaron Sampson 6 minutes
Creating a Subscription for SSRS in Native Mode Aaron Sampson 5 minutes
Creating and Managing Schedules in Native Mode Aaron Sampson 4 minutes
Register Now
Microsoft SQL Server 2014 - Designing BI Solutions video collection
  • Course ID:
    262620
  • Duration:
    n/a
  • Price:
    $99