SSRS Security
An overview of SQL Server Reporting Services (SSRS) security and the options available.
Excel « CubeValue » Function
How to use the CubeValue function in Excel to extract an aggregated value from an Analysis Services Cube.
Benefits of a Datamart and Analysis Services Cubes
Why you need to have a datamart and cubes as part of your data solution.
HR Turnover Reporting
Discover the various ways organizations are reporting on Turnover and how Dashboard Gear can help make the process much easier.
How to Build a P&L on Infor S3 (Lawson) Data with Crystal Reports
Join Rich Bendickson of Dashboard Gear as he explains how to build a P&L from your Infor S3 (Lawson) Data using Crystal Reports.
SQL Aggregations, Unions, and Grouping
Join Rich Bendickson of Dashboard Gear as he concludes our 3-part SQL series. We’ll cover various advanced SQL topics such as Aggregations, Unions, and Grouping.
How to Join Tables in SQL
In this session, we will cover why and how to use joins in your SQL statements so you can bring in data from multiple tables.
SQL Statement Basics
Learn the basics of a SQL statement. In this session, Rich Bendickson discusses how statements are written and how databases use them to process requests.
Using an Excel Slicer with a SSAS Cube
Discover Excel’s powerful filtering mechanism – the slicer. Join Rich Bendickson of Dashboard Gear as he walks through how and when to use a slicer with your SSAS cube data.
Intro to SQL Server Reporting Services (SSRS) Parameters
Join Rich Bendickson of Dashboard Gear as he discusses why to use SSRS parameters and how to add them to new and existing reports.