Online or onsite, instructor-led live Business intelligence (BI) training courses demonstrate through hands-on practice how to understand, plan and implement BI within an organization.
BI training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Onsite live Business Intelligence training can be carried out locally on customer premises in Canada or in NobleProg corporate training centers in Canada.
NobleProg -- Your Local Training Provider
Testimonials
I genuinely enjoyed the trainer's helping.
Urszula Kuza
Course: Tableau Advanced
I liked the exercises as it's the only way to learn, by repetition.
David Rushe
Course: Tableau Advanced
Offering a more in-depth scope about Power BI more than any training institute that I came across to.
Mohammed Al Ameer
Course: Power BI
Exercises, additional tips from the trainer, flexibility to add more insights when requested.
Anna Alechno
Course: Power BI
I mostly enjoyed the power BI possibility.
British American Shared Services Europe
Course: Power BI
I genuinely enjoyed the visualization part.
Alexandra Grigoriu
Course: Power BI
Good coverage of all Power BI themes relevant and useful for creating reliable dashboards and reports as a beginner.
Gabriel Purghel
Course: Power BI
I liked the focus and the emphasis on self-learning, playing and reading on external resources. No Application can be taught in 2 days and self-study is very important.
Vlad Andrei Bucur
Course: Power BI
The trainer was open to answer questions and provide solutions to our real examples.
British American Shared Services Europe
Course: Power BI
I genuinely was benefit from working with DAX and reporting.
Marine Benefits, Inc.
Course: Power BI for Business Analysts
The last part which is security.
Marine Benefits, Inc.
Course: Power BI for Business Analysts
I really enjoyed the training exercise.
Edward Dan Dree Manalad - Marine Benefits, Inc.
Course: Power BI for Business Analysts
Knowledge of Tableau was "built up" in a solid way, it was clear that the trainer knew how best to introduce newbies to Tableau, this made it seem very easy.
Siemens Gamesa c/o Hemsley Fraser
Course: Tableau Fundamentals
Trainer went away and found out answers to the questions we had that he didn't know.
Siemens Gamesa c/o Hemsley Fraser
Course: Tableau Fundamentals
I genuinely was benefit from the subject matter.
Bristol City Council
Course: Power BI
The knowledge of the trainer was really good, and they were able to answer any questions asked about the product.
Bristol City Council
Course: Power BI
I mostly was benefit from learning about Gantt charts.
Sarah Drummond - Siemens Gamesa c/o Hemsley Fraser
Course: Tableau Advanced
Trainer is refined, he was able to play around with our data using his vast knowledge of the course, despite the 0 background with our work.
Mc Gyver Pascua - Sykes Asia, Inc.
Course: Power BI
I enjoyed the experience in learning Power BI.
Sykes Asia, Inc.
Course: Power BI
I liked the preparation of the raw data before layout.
Ayie Delos Santos - Sykes Asia, Inc.
Course: Power BI
I like most the DAX function topic as well as the Trainer's eagerness to resolved inappropriate output, he speak based on his audience level of understanding.
Anabelle Anore - Sykes Asia, Inc.
Course: Power BI
I enjoyed the about the actual application of the lectures provided by the Jonathan.
Sykes Asia, Inc.
Course: Power BI
The tool is very interesting.
Pernod Ricard Hong Kong Limited
Course: Power BI for Business Analysts
Very practical, using our internal data to practice.
Pernod Ricard Hong Kong Limited
Course: Power BI for Business Analysts
Clear and organized on the training topics. Good for people with who have never used PowerBI to be able create sensible dashboards and reports.
Pernod Ricard Hong Kong Limited
Course: Power BI for Business Analysts
I was benefit from the good Explanation and ability to Switch Topics when requested by the trainee.
McArthurGlen
Course: Power BI
I mostly enjoyed the very lively and ease.
Rey Jasper Matias - Sykes Asia, Inc.
Course: Power BI
The trainer listened to the needs of his audience as best as possible and we were able to train relevant to our needs, Costas prepared material specifically around questions asked on the basic training for the advanced training, a lot of effort and work had been put in and it was appreciated.
Chloe Horton - Siemens Gamesa c/o Hemsley Fraser
Course: Tableau Advanced
In terms of product knowledge, he’s really knowledgeable and very open to answer questions.
Cherry Espinili - Infinit-O Manila
Course: Tableau Fundamentals
I mostly was benefit from the exercises and sample cases.
Ann Olano - Infinit-O Manila
Course: Tableau Fundamentals
Training adjust the training according to our needs and knowledge. He understood participants experience with Power BI.
Cristian Tudor - Gilbarco ACIS SRL
Course: Creating Dashboards Using Microsoft Power BI
It is exciting to learn a new product although it has similarity with MS Excel it is of course different in many aspects
Recep Köroglu - European Patent Office
Course: Tableau Fundamentals
exercises
Giorgos Savorgiannakis - European Patent Office
Course: Tableau Fundamentals
Good pace and knowledge demostrated by trainer. Exercises and examples were relevant for our line of work.
Tania Crespo - Grafton Merchanting GB
Course: Creating Dashboards Using Microsoft Power BI
The DAX logic, very useful to know more about it
Illya Teideman - Grafton Merchanting GB
Course: Creating Dashboards Using Microsoft Power BI
The exercises were great, really engaging and very hands on which allowed more of the information to be absorbed
Rajiv Pattar - Grafton Merchanting GB
Course: Creating Dashboards Using Microsoft Power BI
Everything
Sykes Asia Inc.
Course: Power BI
training itself
John Denver Virtucio - Sykes Asia Inc.
Course: Power BI
was really helpful and was willing to listen and provide what was needed. Provided card for questions to help once we use with our own data
shazad Yasin - Grafton Merchanting GB Ltd
Course: Creating Dashboards Using Microsoft Power BI
Costas covered all of the key areas of Power BI. He was very willing to spend additional time focusing on areas that were key to our business.
Dominic Harte - Grafton Merchanting GB Ltd
Course: Creating Dashboards Using Microsoft Power BI
As I was the only delegate on my course, the trainer was able to pace accordingly which meant we could cover more ground on each day.
KNOWLEDGEPOOL GROUP LIMITED
Course: Creating Dashboards Using Microsoft Power BI
The visualisation power BI is able to create with such ease!
Tom Darley - Grafton Merchanting GB Ltd
Course: Creating Dashboards Using Microsoft Power BI
covered basics as well as more advanced features. Finished a bit ahead of scheduled which allowed some time for real world questions from participants
Philip Morris Products SA OC Division
Course: Power BI for Business Analysts
Relevant info and tips
Bandeira Adrien - Philip Morris Products SA OC Division
Course: Power BI for Business Analysts
The knowledge of trainor about the tool.
Kendrick Bacani - Thakral One Inc.
Course: Data analysis with Tableau
I generally was benefit from the power bi web- Q.
Cristina Palii
Course: Power BI
I really liked the dax.
Chris Amaza - Marine Benefits, Inc.
Course: Power BI for Business Analysts
Dax
Kristian Paul Lugtu - SYKES ASIA INC
Course: Power BI
exercices
European Patent Office
Course: Tableau Fundamentals
NA
SYKES ASIA INC
Course: Power BI
Some of our clients
.png "canadian radio-television and telecommunications commission (crtc)")
Business Intelligence Subcategories in Canada
Business Intelligence Course Outlines in Canada
Course Name
Duration
Overview
Course Name
Duration
Overview
7 hours
This instructor-led, live training in Canada (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.
By the end of this training, participants will be able to:
- Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
- Use DAX formulas in Power BI for complex calculations.
- Create and use visualizations and charts for particular analysis cases.
- Import with Power View to move from Excel based Power BI to independent Power BI.
By the end of this training, participants will be able to:
- Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
- Use DAX formulas in Power BI for complex calculations.
- Create and use visualizations and charts for particular analysis cases.
- Import with Power View to move from Excel based Power BI to independent Power BI.
35 hours
Advances in technologies and the increasing amount of information are transforming how business is conducted in many industries, including government. Government data generation and digital archiving rates are on the rise due to the rapid growth of mobile devices and applications, smart sensors and devices, cloud computing solutions, and citizen-facing portals. As digital information expands and becomes more complex, information management, processing, storage, security, and disposition become more complex as well. New capture, search, discovery, and analysis tools are helping organizations gain insights from their unstructured data. The government market is at a tipping point, realizing that information is a strategic asset, and government needs to protect, leverage, and analyze both structured and unstructured information to better serve and meet mission requirements. As government leaders strive to evolve data-driven organizations to successfully accomplish mission, they are laying the groundwork to correlate dependencies across events, people, processes, and information.
High-value government solutions will be created from a mashup of the most disruptive technologies:
- Mobile devices and applications
- Cloud services
- Social business technologies and networking
- Big Data and analytics
IDC predicts that by 2020, the IT industry will reach $5 trillion, approximately $1.7 trillion larger than today, and that 80% of the industry's growth will be driven by these 3rd Platform technologies. In the long term, these technologies will be key tools for dealing with the complexity of increased digital information. Big Data is one of the intelligent industry solutions and allows government to make better decisions by taking action based on patterns revealed by analyzing large volumes of data — related and unrelated, structured and unstructured.
But accomplishing these feats takes far more than simply accumulating massive quantities of data.“Making sense of thesevolumes of Big Datarequires cutting-edge tools and technologies that can analyze and extract useful knowledge from vast and diverse streams of information,” Tom Kalil and Fen Zhao of the White House Office of Science and Technology Policy wrote in a post on the OSTP Blog.
The White House took a step toward helping agencies find these technologies when it established the National Big Data Research and Development Initiative in 2012. The initiative included more than $200 million to make the most of the explosion of Big Data and the tools needed to analyze it.
The challenges that Big Data poses are nearly as daunting as its promise is encouraging. Storing data efficiently is one of these challenges. As always, budgets are tight, so agencies must minimize the per-megabyte price of storage and keep the data within easy access so that users can get it when they want it and how they need it. Backing up massive quantities of data heightens the challenge.
Analyzing the data effectively is another major challenge. Many agencies employ commercial tools that enable them to sift through the mountains of data, spotting trends that can help them operate more efficiently. (A recent study by MeriTalk found that federal IT executives think Big Data could help agencies save more than $500 billion while also fulfilling mission objectives.).
Custom-developed Big Data tools also are allowing agencies to address the need to analyze their data. For example, the Oak Ridge National Laboratory’s Computational Data Analytics Group has made its Piranha data analytics system available to other agencies. The system has helped medical researchers find a link that can alert doctors to aortic aneurysms before they strike. It’s also used for more mundane tasks, such as sifting through résumés to connect job candidates with hiring managers.
High-value government solutions will be created from a mashup of the most disruptive technologies:
- Mobile devices and applications
- Cloud services
- Social business technologies and networking
- Big Data and analytics
IDC predicts that by 2020, the IT industry will reach $5 trillion, approximately $1.7 trillion larger than today, and that 80% of the industry's growth will be driven by these 3rd Platform technologies. In the long term, these technologies will be key tools for dealing with the complexity of increased digital information. Big Data is one of the intelligent industry solutions and allows government to make better decisions by taking action based on patterns revealed by analyzing large volumes of data — related and unrelated, structured and unstructured.
But accomplishing these feats takes far more than simply accumulating massive quantities of data.“Making sense of thesevolumes of Big Datarequires cutting-edge tools and technologies that can analyze and extract useful knowledge from vast and diverse streams of information,” Tom Kalil and Fen Zhao of the White House Office of Science and Technology Policy wrote in a post on the OSTP Blog.
The White House took a step toward helping agencies find these technologies when it established the National Big Data Research and Development Initiative in 2012. The initiative included more than $200 million to make the most of the explosion of Big Data and the tools needed to analyze it.
The challenges that Big Data poses are nearly as daunting as its promise is encouraging. Storing data efficiently is one of these challenges. As always, budgets are tight, so agencies must minimize the per-megabyte price of storage and keep the data within easy access so that users can get it when they want it and how they need it. Backing up massive quantities of data heightens the challenge.
Analyzing the data effectively is another major challenge. Many agencies employ commercial tools that enable them to sift through the mountains of data, spotting trends that can help them operate more efficiently. (A recent study by MeriTalk found that federal IT executives think Big Data could help agencies save more than $500 billion while also fulfilling mission objectives.).
Custom-developed Big Data tools also are allowing agencies to address the need to analyze their data. For example, the Oak Ridge National Laboratory’s Computational Data Analytics Group has made its Piranha data analytics system available to other agencies. The system has helped medical researchers find a link that can alert doctors to aortic aneurysms before they strike. It’s also used for more mundane tasks, such as sifting through résumés to connect job candidates with hiring managers.
35 hours
Overview
Communications service providers (CSP) are facing pressure to reduce costs and maximize average revenue per user (ARPU), while ensuring an excellent customer experience, but data volumes keep growing. Global mobile data traffic will grow at a compound annual growth rate (CAGR) of 78 percent to 2016, reaching 10.8 exabytes per month.
Meanwhile, CSPs are generating large volumes of data, including call detail records (CDR), network data and customer data. Companies that fully exploit this data gain a competitive edge. According to a recent survey by The Economist Intelligence Unit, companies that use data-directed decision-making enjoy a 5-6% boost in productivity. Yet 53% of companies leverage only half of their valuable data, and one-fourth of respondents noted that vast quantities of useful data go untapped. The data volumes are so high that manual analysis is impossible, and most legacy software systems can’t keep up, resulting in valuable data being discarded or ignored.
With Big Data & Analytics’ high-speed, scalable big data software, CSPs can mine all their data for better decision making in less time. Different Big Data products and techniques provide an end-to-end software platform for collecting, preparing, analyzing and presenting insights from big data. Application areas include network performance monitoring, fraud detection, customer churn detection and credit risk analysis. Big Data & Analytics products scale to handle terabytes of data but implementation of such tools need new kind of cloud based database system like Hadoop or massive scale parallel computing processor ( KPU etc.)
This course work on Big Data BI for Telco covers all the emerging new areas in which CSPs are investing for productivity gain and opening up new business revenue stream. The course will provide a complete 360 degree over view of Big Data BI in Telco so that decision makers and managers can have a very wide and comprehensive overview of possibilities of Big Data BI in Telco for productivity and revenue gain.
Course objectives
Main objective of the course is to introduce new Big Data business intelligence techniques in 4 sectors of Telecom Business (Marketing/Sales, Network Operation, Financial operation and Customer Relation Management). Students will be introduced to following:
- Introduction to Big Data-what is 4Vs (volume, velocity, variety and veracity) in Big Data- Generation, extraction and management from Telco perspective
- How Big Data analytic differs from legacy data analytic
- In-house justification of Big Data -Telco perspective
- Introduction to Hadoop Ecosystem- familiarity with all Hadoop tools like Hive, Pig, SPARC –when and how they are used to solve Big Data problem
- How Big Data is extracted to analyze for analytics tool-how Business Analysis’s can reduce their pain points of collection and analysis of data through integrated Hadoop dashboard approach
- Basic introduction of Insight analytics, visualization analytics and predictive analytics for Telco
- Customer Churn analytic and Big Data-how Big Data analytic can reduce customer churn and customer dissatisfaction in Telco-case studies
- Network failure and service failure analytics from Network meta-data and IPDR
- Financial analysis-fraud, wastage and ROI estimation from sales and operational data
- Customer acquisition problem-Target marketing, customer segmentation and cross-sale from sales data
- Introduction and summary of all Big Data analytic products and where they fit into Telco analytic space
- Conclusion-how to take step-by-step approach to introduce Big Data Business Intelligence in your organization
Target Audience
- Network operation, Financial Managers, CRM managers and top IT managers in Telco CIO office.
- Business Analysts in Telco
- CFO office managers/analysts
- Operational managers
- QA managers
Communications service providers (CSP) are facing pressure to reduce costs and maximize average revenue per user (ARPU), while ensuring an excellent customer experience, but data volumes keep growing. Global mobile data traffic will grow at a compound annual growth rate (CAGR) of 78 percent to 2016, reaching 10.8 exabytes per month.
Meanwhile, CSPs are generating large volumes of data, including call detail records (CDR), network data and customer data. Companies that fully exploit this data gain a competitive edge. According to a recent survey by The Economist Intelligence Unit, companies that use data-directed decision-making enjoy a 5-6% boost in productivity. Yet 53% of companies leverage only half of their valuable data, and one-fourth of respondents noted that vast quantities of useful data go untapped. The data volumes are so high that manual analysis is impossible, and most legacy software systems can’t keep up, resulting in valuable data being discarded or ignored.
With Big Data & Analytics’ high-speed, scalable big data software, CSPs can mine all their data for better decision making in less time. Different Big Data products and techniques provide an end-to-end software platform for collecting, preparing, analyzing and presenting insights from big data. Application areas include network performance monitoring, fraud detection, customer churn detection and credit risk analysis. Big Data & Analytics products scale to handle terabytes of data but implementation of such tools need new kind of cloud based database system like Hadoop or massive scale parallel computing processor ( KPU etc.)
This course work on Big Data BI for Telco covers all the emerging new areas in which CSPs are investing for productivity gain and opening up new business revenue stream. The course will provide a complete 360 degree over view of Big Data BI in Telco so that decision makers and managers can have a very wide and comprehensive overview of possibilities of Big Data BI in Telco for productivity and revenue gain.
Course objectives
Main objective of the course is to introduce new Big Data business intelligence techniques in 4 sectors of Telecom Business (Marketing/Sales, Network Operation, Financial operation and Customer Relation Management). Students will be introduced to following:
- Introduction to Big Data-what is 4Vs (volume, velocity, variety and veracity) in Big Data- Generation, extraction and management from Telco perspective
- How Big Data analytic differs from legacy data analytic
- In-house justification of Big Data -Telco perspective
- Introduction to Hadoop Ecosystem- familiarity with all Hadoop tools like Hive, Pig, SPARC –when and how they are used to solve Big Data problem
- How Big Data is extracted to analyze for analytics tool-how Business Analysis’s can reduce their pain points of collection and analysis of data through integrated Hadoop dashboard approach
- Basic introduction of Insight analytics, visualization analytics and predictive analytics for Telco
- Customer Churn analytic and Big Data-how Big Data analytic can reduce customer churn and customer dissatisfaction in Telco-case studies
- Network failure and service failure analytics from Network meta-data and IPDR
- Financial analysis-fraud, wastage and ROI estimation from sales and operational data
- Customer acquisition problem-Target marketing, customer segmentation and cross-sale from sales data
- Introduction and summary of all Big Data analytic products and where they fit into Telco analytic space
- Conclusion-how to take step-by-step approach to introduce Big Data Business Intelligence in your organization
Target Audience
- Network operation, Financial Managers, CRM managers and top IT managers in Telco CIO office.
- Business Analysts in Telco
- CFO office managers/analysts
- Operational managers
- QA managers
14 hours
Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion.
In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources.
By the end of this training, participants will be able to:
- Create, curate, and interactively explore an enterprise data lake
- Access business intelligence data warehouses, transactional databases and other analytic stores
- Use a spreadsheet user-interface to design end-to-end data processing pipelines
- Access pre-built functions to explore complex data relationships
- Use drag-and-drop wizards to visualize data and create dashboards
- Use tables, charts, graphs, and maps to analyze query results
Audience
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources.
By the end of this training, participants will be able to:
- Create, curate, and interactively explore an enterprise data lake
- Access business intelligence data warehouses, transactional databases and other analytic stores
- Use a spreadsheet user-interface to design end-to-end data processing pipelines
- Access pre-built functions to explore complex data relationships
- Use drag-and-drop wizards to visualize data and create dashboards
- Use tables, charts, graphs, and maps to analyze query results
Audience
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
35 hours
Advances in technologies and the increasing amount of information are transforming how law enforcement is conducted. The challenges that Big Data pose are nearly as daunting as Big Data's promise. Storing data efficiently is one of these challenges; effectively analyzing it is another.
In this instructor-led, live training, participants will learn the mindset with which to approach Big Data technologies, assess their impact on existing processes and policies, and implement these technologies for the purpose of identifying criminal activity and preventing crime. Case studies from law enforcement organizations around the world will be examined to gain insights on their adoption approaches, challenges and results.
By the end of this training, participants will be able to:
- Combine Big Data technology with traditional data gathering processes to piece together a story during an investigation
- Implement industrial big data storage and processing solutions for data analysis
- Prepare a proposal for the adoption of the most adequate tools and processes for enabling a data-driven approach to criminal investigation
Audience
- Law Enforcement specialists with a technical background
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn the mindset with which to approach Big Data technologies, assess their impact on existing processes and policies, and implement these technologies for the purpose of identifying criminal activity and preventing crime. Case studies from law enforcement organizations around the world will be examined to gain insights on their adoption approaches, challenges and results.
By the end of this training, participants will be able to:
- Combine Big Data technology with traditional data gathering processes to piece together a story during an investigation
- Implement industrial big data storage and processing solutions for data analysis
- Prepare a proposal for the adoption of the most adequate tools and processes for enabling a data-driven approach to criminal investigation
Audience
- Law Enforcement specialists with a technical background
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
28 hours
Pentaho Open Source BI Suite Community Edition (CE) is a business intelligence package that provides data integration, reporting, dashboards, and load capabilities.
In this instructor-led, live training, participants will learn how to maximize the features of Pentaho Open Source BI Suite Community Edition (CE).
By the end of this training, participants will be able to:
- Install and configure Pentaho Open Source BI Suite Community Edition (CE)
- Understand the fundamentals of Pentaho CE tools and their features
- Build reports using Pentaho CE
- Integrate third party data into Pentaho CE
- Work with big data and analytics in Pentaho CE
Audience
- Programmers
- BI 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.
In this instructor-led, live training, participants will learn how to maximize the features of Pentaho Open Source BI Suite Community Edition (CE).
By the end of this training, participants will be able to:
- Install and configure Pentaho Open Source BI Suite Community Edition (CE)
- Understand the fundamentals of Pentaho CE tools and their features
- Build reports using Pentaho CE
- Integrate third party data into Pentaho CE
- Work with big data and analytics in Pentaho CE
Audience
- Programmers
- BI 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.
14 hours
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.
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.
14 hours
Learn how to Get & Transform Data to Prepare Interactive Dashboards
Power BI is one of the most popular Data Visualization tool, and a Business Intelligence Tool. Power BI is a collection of data connectors, apps, and software services, which are used to get data from different source, transforms data, and produce beautiful reports.
Power BI also allows you to publish them for your organization so that you can access them using mobiles, tablets etc. In this Power BI Tutorial, we will show you the step by step approach to connect with multiple data sources, data transformations, and creating reports like charts, tables, matrix, maps, etc
Power BI is one of the most popular Data Visualization tool, and a Business Intelligence Tool. Power BI is a collection of data connectors, apps, and software services, which are used to get data from different source, transforms data, and produce beautiful reports.
Power BI also allows you to publish them for your organization so that you can access them using mobiles, tablets etc. In this Power BI Tutorial, we will show you the step by step approach to connect with multiple data sources, data transformations, and creating reports like charts, tables, matrix, maps, etc
7 hours
This instructor-led, live training in Canada (online or onsite) is aimed at content managers who wish to optimize and update company content with IRIS.
By the end of this training, participants will be able to:
- Improve business reports using IRISXtract.
- Use IRISPowerscan to file documents automatically.
- Process purchase orders, accounts payable, automate email extraction, and more with solution packages.
By the end of this training, participants will be able to:
- Improve business reports using IRISXtract.
- Use IRISPowerscan to file documents automatically.
- Process purchase orders, accounts payable, automate email extraction, and more with solution packages.
14 hours
This instructor-led, live training in Canada (online or onsite) is aimed at data analysts and web developers who wish to develop associative models in Qlik Sense.
By the end of this training, participants will be able to:
- Apply Qlik Sense in data science.
- Use and navigate the Qlik Sense interface.
- Build a data literate workforce with AI interaction.
- Create a data-driven enterprise with Qlik Sense.
By the end of this training, participants will be able to:
- Apply Qlik Sense in data science.
- Use and navigate the Qlik Sense interface.
- Build a data literate workforce with AI interaction.
- Create a data-driven enterprise with Qlik Sense.
14 hours
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
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.
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
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.
14 hours
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
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
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
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
14 hours
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.
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.
21 hours
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.
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.
14 hours
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.
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.
14 hours
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.
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.
28 hours
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.
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.
28 hours
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.
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.
21 hours
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.
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.
14 hours
This instructor-led, live training in Canada (online or onsite) is aimed at data scientists and developers who wish to use and integrate SQL, Python, and Tableau to perform complex data analysis, processing, and visualization.
By the end of this training, participants will be able to:
- Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
- Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
- Get a refresher on the fundamentals of Python and SQL.
- Perform data pre-processing techniques in Python.
- Learn how to connect Python and SQL for data analysis.
- Create insightful data visualizations and charts with Tableau.
By the end of this training, participants will be able to:
- Set up the necessary environment to perform data analysis with SQL, Python, and Tableau.
- Understand the key concepts of software integration (data, servers, clients, APIs, endpoints, etc.).
- Get a refresher on the fundamentals of Python and SQL.
- Perform data pre-processing techniques in Python.
- Learn how to connect Python and SQL for data analysis.
- Create insightful data visualizations and charts with Tableau.
14 hours
Dashbuilder is an open-source web application for visually creating business dashboards and reports.
In this instructor-led, live training, participants will learn how to create business dashboards and reports using Dashbuilder.
By the end of this training, participants will be able to:
- Visual configure and personalize dashboards using drag-and-drop
- Create different types of visualizations using charting libraries
- Define interactive report tables
- Create and edit inline KPIs (Key Performance Indicators)
- Customize the look and feel of metric displayers
Audience
- Managers
- Analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to create business dashboards and reports using Dashbuilder.
By the end of this training, participants will be able to:
- Visual configure and personalize dashboards using drag-and-drop
- Create different types of visualizations using charting libraries
- Define interactive report tables
- Create and edit inline KPIs (Key Performance Indicators)
- Customize the look and feel of metric displayers
Audience
- Managers
- Analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
7 hours
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
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
21 hours
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.
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.
28 hours
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.
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.
14 hours
About the Course:
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both Power BI on Line and Power BI desktop.
Audience:
This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.
At Course Completion
Upon completing this course, students will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned.
- Power BI
- Power BI Desktop
- Working with CSV, TXT, and Excel Worksheets
- Connecting to Databases
- Merging, Grouping, Summarizing, and Calculating Data
- Reporting
- Power BI Online
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both Power BI on Line and Power BI desktop.
Audience:
This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.
At Course Completion
Upon completing this course, students will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned.
- Power BI
- Power BI Desktop
- Working with CSV, TXT, and Excel Worksheets
- Connecting to Databases
- Merging, Grouping, Summarizing, and Calculating Data
- Reporting
- Power BI Online
Last Updated:
Upcoming Business Intelligence Courses in Canada
Data Analysis with Tableau and Python
14-02-2022 09:30
14 hours
Tableau for Developers
14-02-2022 09:30
21 hours
Tableau Advanced
17-02-2022 09:30
14 hours
Visual Reporting and Analysis with Tableau
02-03-2022 09:30
14 hours
Tableau Fundamentals
07-03-2022 09:30
14 hours
Other regions in Canada
Other countries
Consulting in Canada
Online Business Intelligence courses, Weekend Business Intelligence courses, Evening Business Intelligence training, Business Intelligence boot camp, Business Intelligence instructor-led, Weekend Business Intelligence training, Evening Business Intelligence courses, Business Intelligence coaching, Business Intelligence instructor, Business Intelligence trainer, Business Intelligence training courses, Business Intelligence classes, Business Intelligence on-site, Business Intelligence private courses, Business Intelligence one on one training