Business Intelligence Training Courses in Canada

Training is dedicated to the basics of create a data warehouse environment based on MS SQL Server 2008.

Course participant gain the basis for the design and construction of a data warehouse that runs on MS SQL Server 2008.

Gain knowledge of how to build a simple ETL process based on the SSIS and then design and implement a data cube using SSAS.

The participant will be able to manage OLAP database: create and delete database OLAP Processing a partition changes on-line.

The participant will acquire knowledge of scripting XML / A and MDX.

This instructor-led, live training (online or onsite) is aimed at data analysts and data scientists who wish to explore, organize, and visualize data using Apache Superset.

By the end of this training, participants will be able to:

- Install and configure Apache Superset.
- Combine data from different databases.
- Visualize large datasets.
- Create and share complex dashboards.

Format of the Course

- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.

Course Customization Options

- This training is based on the latest version of Apache Superset.
- To request a customized training for this course, please contact us to arrange.
- To learn more about Apache Superset, please visit: https://superset.incubator.apache.org

In this instructor-led, live training in Canada, participants will learn how to use Power BI to develop custom software solutions for the Power BI and Azure platforms.

By the end of this training, participants will be able to:

• Configure real-time dashboards.
• Create custom visualizations.
• Integrate rich analytics into existing applications.
• Embed interactive reports and visuals into existing applications.
• Access data from within an application.
• Master Power BI Portal, Desktop, Embedded and Rest API.
• Integrate R Scripts into Power BI Desktop.

QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.

In this instructor-led, live training, participants will learn how to use QlikView to support decision making in their organization.

By the end of this training, participants will be able to:

- Install and configure QlikView
- Analyze and display data using QliKView
- Use data discoveries from QlikView to support decision making

Audience

- Managers
- Business users

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice

Note

- To request a customized training for this course, please contact us to arrange.

QlikView is a platform that provides organizations self-service business intelligence. QlikView's clean, straightforward, and simple interfaces allow users to easily analyze data and use data discoveries to support decision making.

In this instructor-led, live training, participants will learn how to start developing with QlikView.

By the end of this training, participants will be able to:

- Install and configure QlikView
- Transform data from various sources through QlikView scripting
- Build data models with QlikView

Audience

- Developers

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice

Note

- To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts who wish to program in SAS for advanced data management, data analysis, and more.

By the end of this training, participants will be able to:

• Master macros to write efficient SAS programs.
• Train a model and make predictions on unseen data with predictive modeling.
• Create charts and plots for data visualization.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts and data scientists who wish to search, analyze, and visualize data using Splunk.

By the end of this training, participants will be able to:

• Install and configure Splunk.
• Collect and index all kinds of machine data.
• Implement real-time search, analysis and visualization of large datasets.
• Create and share complex dashboards and reports.

This instructor-led, live training in Canada (online or onsite) is aimed at engineers who wish to get data into Splunk Indexers and manipulate data in Splunk.

By the end of this training, participants will be able to:

• Use different data input methods and sources.
• Install, configure, manage and moniter Forwarders.
• Manipulate raw data in Splunk.
• Create a Splunk Diag.

SSAS (SQL Server Analysis Services), is a Microsoft SQL Server transactional processing (OLAP) and data mining tool for analyzing data across multiple databases, tables or files. The semantic data models provided by SSAS are used by client applications such as Power BI, Excel, Reporting Services, and other data visualization tools.

In this instructor-led, live training (onsite or remote), participants will learn how to use SSAS to analyze large volumes of data in databases and data warehouses.

By the end of this training, participants will be able to:

- Install and configure SSAS
- Understand the relationship between SSAS, SSIS, and SSRS
- Apply multidimensional data modeling to extract business insights from data
- Design OLAP (Online Analytical Processing) cubes
- Query and manipulate multidimensional data using the MDX (Multidimensional Expressions) query language
- Deploy real-world BI solutions using SSAS

Audience

- BI (Business Intelligence) professionals
- Data Analysts
- Database and data warehousing professionals

Format of the Course

- Interactive lecture and discussion
- Lots of exercises and practice
- Hands-on implementation in a live-lab environment

Course Customization Options

- This training is based on the latest version of Microsoft SQL Server and SSAS.
- To request a customized training for this course, please contact us to arrange.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts who wish to analyze large data sets with Stata.

By the end of this training, participants will be able to:

• Create statistic models for predicting key interest variables and events.
• Generate descriptive visualizations, summary tables, frequencies, and more.
• Manage and structure large databases, ready for data analysis.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts who wish to use Stata and R to analyze big data for statistical analysis.

By the end of this training, participants will be able to:

• Create statistic models for predicting key interest variables and events.
• Generate descriptive visualizations, summary tables, frequencies, and more.
• Manage and structure large databases to preapare for data analysis.

This is a Tableau user beginners course; it is intended for anyone who is looking to work with data and is designed to help you use the main functions in Tableau.

During the course you will be able to:

- Connect to your data.
- Edit and save a data source.
- Understand Tableau terminology.
- Use the Tableau interface / paradigm to effectively create powerful visualizations.
- Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations.
- Represent your data using the following visualization types:

- Cross tabs
- Geographic maps
- Heat maps
- Tree maps
- Pie charts and bar charts
- Dual axis and combined charts with different mark types
- Highlight Tables
- Scatter Plots

- Build dashboards to share visualizations.

Microsoft Power BI is a free Software as a Service (SaaS) suite for analyzing data and sharing insights. Power BI dashboards provide a 360-degree view of the most important metrics in one place, updated in real time, and available on all of their devices.

This instructor-led, live training (online or onsite) is aimed at business managers, business analysts, data analysts, report developers, and team leads who wish to design a perfect Power BI dashboard.

By the end of this training, participants will be able to:

- Design beautiful and efficient dashboards following the critical rules.
- Choose the right charts based on the kind of data for display.

Format of the Course

- Interactive lecture and discussion.
- Lots of exercises and practice.
- Hands-on implementation in a live-lab environment.

Course Customization Options

- To request a customized training for this course, please contact us to arrange.

Tableau helps people see and understand data.

This instructor-led, live training in Canada (online or onsite) is aimed at data scientists who wish to program in R for Tableau.

By the end of this training, participants will be able to:

• Implement Tableau analytics with R.
• Return values to Tableau with learning algorithms in R.
• Structure and visualize R functions in Tableau.
• Make data driven decisions for business operations.

In this instructor-led, live training in Canada, participants will learn how to extend the capabilities of Tableau to fit the specific needs of their organization.

By the end of this training, participants will be able to:

• Install and configure Tableau (Desktop, Server, Online.)
• Understand the fundamentals of developing with Tableau.
• Create and publish data visualizations and interactions with Tableau.
• Use Tableau's developer tools and APIs to customize and extend the capabilities of Tableau for their organization.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts and data scientists who wish to search, analyze, and visualize data using Tableau.

By the end of this training, participants will be able to:

• Connect to your data.
• Edit and save a data source.
• Understand Tableau terminology.
• Use the Tableau interface / paradigm to effectively create powerful visualizations.
• Create calculations including arithmetic calculations, custom aggregations and ratios, date math, and table calculations.
• Represent your data using different visualization types.
• Build dashboards to share visualizations.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts who wish to prepare and shape data using Tableau Prep Builder.

By the end of this training, participants will be able to:

• Install Tableau Prep.
• Understand and implement a Data Science Workflow.
• Read data from a variety of sources, such as Excel and databases.
• Prepare, shape and sample data for analysis in Tableau Desktop.
• Explore and validate data.
• Create and publish Tableau Prep flows.

Tableau is a business intelligence and data visualization tool. Python is a widely used programming language which provides support for a wide variety of statistical and machine learning techniques. Tableau's data visualization power and Python's machine learning capabilities, when combined, help developers rapidly build advanced data analytics applications for various business use cases.

In this instructor-led, live training, participants will learn how to combine Tableau and Python to carry out advanced analytics. Integration of Tableau and Python will be done via the TabPy API.

By the end of this training, participants will be able to:

- Integrate Tableau and Python using TabPy API
- Use the integration of Tableau and Python to analyze complex business scenarios with few lines of Python code

Audience

- Developers
- Data scientists

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice

This instructor-led, live training in Canada (online or onsite) is aimed at system administrators who wish to set up and manage Tableau Server.

By the end of this training, participants will be able to:

• Install and configure Tableau Server.
• Set up users, roles and permissions to get a team up and running.
• Access various data sources, manage content and access to the content by users.
• Automate administrative tasks, including monitoring and log management.
• Deploying Tableau Server to cluster.

Tableau helps people see and understand data.

In this instructor-led, live training in Canada, participants will learn how to use the Talend ETL tool to carry out data transformation, data extraction, and connectivity with Hadoop, Hive, and Pig.

By the end of this training, participants will be able to

• Explain the concepts behind ETL (Extract, Transform, Load) and propagation.
• Define ETL methods and ETL tools to connect with Hadoop.
• Efficiently amass, retrieve, digest, consume, transform and shape big data in accordance to business requirements.
• Upload to and extract large records from Hadoop (optional), Hive (optional), and NoSQL databases.

Tableau helps people see and understand data.

In this instructor-led, live training in Canada (onsite or remote), participants will learn how to use Microsoft Power BI to analyze and visualize data using a series of sample data sets.

By the end of this training, participants will be able to:

• Create visually compelling dashboards that provide valuable insights into data.
• Obtain and integrate data from multiple data sources.
• Build and share visualizations with team members.
• Adjust data with Power BI Desktop.

Power BI is a business analytics service created by Microsoft.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts and data scientists who wish to carry out advanced data search, analytics, and visualization using Splunk.

By the end of this training, participants will be able to:

• Create a Splunk application and a technology add-on.
• Use different data input methods and sources.
• Implement advanced search, analysis and visualization of large datasets.
• Customize and share dashboards and reports.

Dashbuilder is an open-source web application for visually creating business dashboards and reports.

In this instructor-led, live training, participants will learn set up, configure, integrate and deploy Dashbuilder.

By the end of this training, participants will be able to:

- Extract data from heterogeneous sources such as JDBC databases and text files
- Use connectors to connect to third-party systems and platforms such as jBPM
- Configure roles, permissions and access controls for users
- Deploy Dashbuilder to a live production environment

Audience

- Developers
- IT and system architects

Format of the course

- Part lecture, part discussion, exercises and heavy hands-on practice

This instructor-led, live training in Canada (online or onsite) is aimed at business analysts who wish to automate trade with algorithmic trading, Python, and R.

By the end of this training, participants will be able to:

• Employ algorithms to buy and sell securities at specialized increments rapidly.
• Reduce costs associated with trade using algorithmic trading.
• Automatically monitor stock prices and place trades.

This instructor-led, live training in Canada (online or onsite) is aimed at data analysts who wish to use Alteryx for data processing and data visualization.

By the end of this training, participants will be able to:

• Leverage Alteryx to improve business intelligence and business analytics.
• Perform ETL operations with zero code.
• Visualize data with a data analytical suite, such as Excel.

This instructor-led, live training in Canada (online or onsite) is aimed at data scientists who wish to use Alteryx for data analysis.

By the end of this training, participants will be able to:

• Prepare data in Alteryx to later visualize in Power BI or Excel.
• Create and Perform ETL operations with little to no code.
• Embed custom R code inside Alteryx.