Using Excel as a Data Source

This video will show you how to use Microsoft Excel as a data source for your dashboard. You will also learn best practices for using Excel as a shared corporate data source for your dashboards.

An introduction to basic ETL using data cubes. You will learn how to perform joins across data sources and the overall concept behind a data cube.

This video goes into more detail about the functions available in a data cube for performing cleansing stepwise operations. You will learn how to transform your data in order to prepare it to be used on a dashboard.

This video introduces the concept of hierarchies based upon categories. You will learn how to group your data in order to provide organization and readability on the dashboard.

This video introduces the concept of time hierarchies. Time hierarchies help you to organize your data and facilitate drill down.

This video teaches the purpose and use of cube perspectives. If your OLAP cubes are complex and have vastly more information than your users can consume, this video will help.

This video describes the concepts behind date mapping in order to support date-based operations in an OLAP cube.

An introduction to the concept of metric sets within Dundas BI. You will learn why and how to create your own metric sets in order to help with the sharing of data.