Dundas BI Services Training Support

Dundas BI is business intelligence (BI) and data visualization software that includes customizable dashboards, reporting and visual data analytics. According to the vendor, their solution is the most flexible BI platform, with seamless integration into the user’s business applications, allowing them to deliver real-time visual access and analytics for their data, information and results for better decisions and faster insights.

Show Unsupported Features

Dundas BI Features

BI Platform features

Administration via Web Interface
Live Connection to External Data
Snapshot of External Data
In-memory data model
OLAP (Pre-processed cube representation)
ROLAP (SQL-layer querying)
Multi-Data Source Reporting (Blending)
Data warehouse / dictionary layer
ETL Capability
ETL Scheduler

Supported Data Sources Features

Data sources that can be consumed by the application.

MS Excel Workbooks
Text Files (CSV, etc)
Oracle
MS SQL Server
IBM DB2
Postgres
MySQL
ODBC
Cloudera Hadoop
Hortonworks Hadoop
EMC Greenplum
HP Vertica
ParAccel
SAP Hana
Teradata
Sage 500
Salesforce
SAP
Google Analytics

BI Standard Reporting Features

Standard reporting means pre-built or canned reports available to users without having to create them.

Pixel Perfect reports
Customizable dashboards
Report Formatting Templates

Ad-hoc Reporting Features

Ad-Hoc Reports are reports built by the user to meet highly specific requirements.

Drill-down analysis
Formatting capabilities
Predictive modeling
Integration with R or other statistical packages
Report sharing and collaboration

Report Output and Scheduling Features

Ability to schedule and manager report output.

Publish to Web
Publish to PDF
Output Raw Supporting Data
Report Versioning
Report Delivery Scheduling

Data Discovery and Visualization Features

Data Discovery and Visualization is the analysis of multiple data sources in a search for pattern and outliers and the ability to represent the data visually.

Pre-built visualization formats (heatmaps, scatter plots etc.)
Location Analytics / Geographic Visualization
Predictive Analytics
Integration with R or other statistical packages

Access Control and Security Features

Access control means being able to determine who has access to which data.

Multi-User Support (named login)
Role-Based Security Model
Multiple Access Permission Levels (Create, Read, Delete)
Report-Level Access Control
Table-Level Access Control (BI-layer)
Field-Level Access Control (BI-layer)

Mobile Capabilities Features

Support for mobile devices like smartphones and tablets.

Responsive Design for Web Access
Dashboard / Report / Visualization Interactivity on Mobile

Additional Features

Customizable Data Visualizations, Dashboards and Reporting
Visual Interactive Data Analytics
Browser-based, single, unified experience across all data sources and all devices
Embeddable BI with seamless integration
One Flexible Platform

The BI life cycle spans a continuum that begins with large amounts of disparate data and stretches to encompass people, technology, information, analysis, and decision making. The benefits of BI are substantial: new business capabilities for insight, forecasting, planning, agility, and strategy execution.
Realizing benefits is challenging. With many moving parts—infrastructure, technology, data, integration, analytics, applications, metrics, reports, dashboards, scorecards—putting the pieces together in the most effective way is difficult. Learn the basics of BI from end to end, with special attention to two of the most important factors for BI success: planning and collaboration. You are most able to chart a course for BI success when teams and stakeholders share common concepts, use consistent terminology, and contribute collectively to the BI vision.

You Will Learn

Meaningful and actionable definitions of BI
Effective ways to deliver BI: Web, mobile, desktop, etc.
Common kinds of BI reporting: ad hoc, published, enterprise, and operational
Performance management principles, including dashboards, scorecards, and KPIs
Business analyst principles, including OLAP, analytic modeling, and data visualization
Advanced analytics concepts for data mining, predictive analytics, and text analytics
Data management practices, including profiling, cleansing, and quality management
Data integration practices, including consolidation, virtualization, and data warehousing

Geared To

Anyone with a role in BI/DW programs who needs to understand the concepts and the full life cycle of BI
BI/DW managers and leaders seeking to increase the value and business impact of a BI program
Business andtechnical people who need to work together to implement BI
Teams that need to develop a common base of concepts and terminology for BI