Business Intelligence Training in Calgary

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level financial analysts who wish to integrate AI effectively into their data analysis processes.

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

• Understand the application of AI in data analysis specific to the financial industry.
• Develop skills to build predictive and prescriptive models for financial analysis.
• Learn how to implement machine learning algorithms for financial data processing.
• Enhance data visualization and interpret complex AI-driven insights for decision-making.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level data and business analysts who wish to create, manage, and administer dashboards using Amazon QuickSight.

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

• Understand the benefits, use cases, and key features of Amazon QuickSight.
• Learn to connect QuickSight to multiple data sources and author interactive data visualizations and dashboards.
• Apply security and access controls in QuickSight.
• Utilize machine learning capabilities built into QuickSight for enhanced data insights.
• Design, create, and customize QuickSight dashboards to extract and visualize business insights.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level data and business analysts who wish to use BIRT to effectively create and deploy business intelligence reports.

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

• Understand the architecture and components of the BIRT framework.
• Design and create informative, dynamic reports using BIRT Report Designer.
• Use BIRT’s scripting capabilities to add business logic to reports.
• Optimize and deploy BIRT reports within web applications and standalone applications.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to leverage Oracle BI to extract valuable insights from their data.

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

• Navigate and utilize the Oracle BI interface effectively.
• Create and customize reports and dashboards tailored to business needs.
• Conduct ad-hoc analysis using various BI tools.
• Utilize advanced features for comprehensive data exploration.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to harness the power of SAS BI to extract meaningful insights from data.

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

• Navigate and utilize the SAS BI interface effectively.
• Create customized reports and dashboards tailored to business needs.
• Conduct ad-hoc analysis using various BI tools.
• Leverage advanced features for comprehensive data exploration.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level to intermediate-level data analysts who wish to use Tableau Desktop to transform raw data into meaningful insights through graphical representations such as charts, graphs, maps, and tables.

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

• Connect to multiple types of data sources (Excel, CSV, databases, cloud-based) and understand the distinctions between live and extract connections.
• Prepare and clean data for analysis, including renaming fields, handling null values, and combining datasets through joins and blends.
• Create basic visualizations such as tables, bar charts, line charts, and maps, and apply filters to refine data presentations.
• Develop intermediate visualizations including geographic maps, dual-axis charts, and use hierarchies, groups, and sets to enhance analysis.
• Build calculated fields and parameters to create dynamic and customized visualizations based on user inputs and logic functions.
• Design interactive dashboards and stories, incorporating multiple visualizations and filters to tell a cohesive narrative.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level business analysts and data analysts who wish to acquire essential skills in using SAP BusinessObjects BI to transform raw data into meaningful insights.

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

• Navigate and use the SAP BusinessObjects BI interface.
• Create and customize business reports and dashboards.
• Perform ad-hoc analysis using various BI tools.
• Utilize advanced features for in-depth data exploration.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level participants who wish to master advanced data integration and visualization techniques in Looker Studio, and learn how to connect diverse data sources, design compelling dashboards, and automate reporting workflows to drive better business decisions.

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

• Connect and integrate multiple data sources into Looker Studio.
• Create custom metrics and calculated fields for tailored analysis.
• Design advanced visualizations, including interactive filters and charts.
• Automate reporting workflows for real-time data updates.
• Apply best practices for visual storytelling and report customization.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level to advanced-level consultants and finance professionals who wish to prepare for the Cognos Analytics certification and gain expertise in financial data analysis, including modules for accounts payable, treasury, and expenses.

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

• Navigate and utilize the Cognos Analytics interface efficiently.
• Develop and customize financial reports and dashboards.
• Manage data models and optimize queries.
• Prepare for the Cognos Analytics certification exam.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

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

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level IT administrators who wish to use Plunk to profile and manage IT infrastructure, optimize system architecture, troubleshoot effectively, and leverage Splunk’s capabilities for comprehensive data analysis and real-time monitoring.

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

• Understand and manage the complete Splunk infrastructure.
• Master Splunk architecture and components.
• Troubleshoot common and advanced issues effectively.
• Utilize Splunk to its full potential for data analysis, monitoring, and reporting.
• Administer data inputs, user management, and system configurations.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level database professionals who wish to enhance their skills to create complex reports, customize report templates, and integrate JasperReports with other systems.

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

• Design complex, multi-page reports with advanced layouts, fixed forms with variable sections, and dynamic content.
• Create advanced charts, graphs, and pivot tables to visualize data, and integrate subreports and grouping for detailed data representation.
• Implement security measures, manage user permissions, and utilize JasperReports Server for report scheduling and distribution.

This instructor-led, live training in Calgary (online or onsite) is aimed at data scientists and data analysts who wish to learn how to use each tool in the developer tool palette in Alteryx Designer.

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

• Learn to use and configure all the tools in the developer tab.
• Design efficient workflows in Alteryx using the dynamic, validation, and testing tools.
• Learn how to use API tools to download and parse web data.
• Use Alteryx scripting tools, including Python and R.

This instructor-led, live training in Calgary (online or onsite) is aimed at data analysts or anyone who wishes to use AWS QuickSight data analysis and visualization.

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

• Understand the basic concepts of AWS QuickSight.
• Use AWS QuickSight to create data analysis, reports, and insights.
• Use AWS to create relationships between data for enhanced analysis.
• Learn different types of visualizations in understanding data.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level data analysts who wish to understand the theoretical aspects of Cognos 11 and also learn how to use it effectively.

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

• Understand the differences and enhancements in Cognos 11 compared to Cognos 10.
• Utilize the improved data module and data management features for more efficient data handling.
• Implement best practices for a smooth transition and optimal use of Cognos 11.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level data professionals who wish to implement a lakehouse solution using Microsoft Fabric.

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

• Understand the architecture and components of Microsoft Fabric.
• Configure and manage a Lakehouse using Microsoft Fabric.
• Ingest and transform data using Apache Spark.
• Utilize Delta Lake tables for versioning and managing data.
• Implement data ingestion pipelines with Dataflows Gen2.
• Orchestrate data pipelines using Data Factory.

This instructor-led, live training in Calgary (online or onsite) is aimed at data analysts who wish to use Google Sheets for data analysis.

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

• Build spreadsheets with Google Sheets.
• Use formulas that work both in Google Sheets and Excel.
• Format and analyze any data.
• Create data visualizations with charts and graphs.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level to intermediate-level participants who wish to build foundational skills for data visualization and reporting using Looker Studio, and learn how to connect data sources, visualize information effectively, and gain actionable insights.

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

• Understand the core features of Looker Studio and its use cases.
• Set up Looker Studio and connect to various data sources.
• Create engaging dashboards with charts, graphs, and filters.
• Customize reports for specific audiences and business needs.
• Collaborate on and share dashboards effectively.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level data analysts who wish to deepen their understanding of Splunk and build upon their foundational knowledge acquired in Splunk Fundamentals 1.

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

• Conduct advanced searches using Splunk's powerful search commands and capabilities.
• Utilize subsearches, statistical commands, and evaluation functions to analyze data.
• Create sophisticated reports and dashboards with advanced visualization options.
• Implement alerts and scheduled reports for monitoring and notification purposes.

This instructor-led, live training in Calgary (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.

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level to advanced-level computer science professionals who wish to leverage Stata for statistical analysis and integrate it with R.

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

• Effectively use Stata for data analysis and statistical modeling.
• Compare Stata’s functionalities with SPSS and R.
• Integrate Stata with R for seamless statistical computing.
• Develop and automate workflows using Stata and R.

This instructor-led, live training in Calgary (online or onsite) is aimed at beginner-level to intermediate-level system administrators who wish to set up and manage Apache Superset for their organizations.

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

• Install and configure Apache Superset.
• Understand the architecture and features of Superset.
• Manage user access and security settings.
• Monitor and optimize the performance of Superset instances.
• Troubleshoot common issues and perform regular maintenance.

The "Big Data and AI in Banking" training program is designed to equip professionals in the banking industry with essential skills and knowledge to harness the power of Big Data and artificial intelligence. Participants will explore foundational concepts, technologies, and practical applications of Big Data and AI within the banking sector. The training will encompass a blend of theoretical instruction, case studies, hands-on sessions, and discussions on regulatory implications, ethical considerations, and best practices.

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

1. Understand Key Concepts: Provide participants with a foundational understanding of Big Data and AI, including their significance in the banking sector.
2. Explore Technologies: Familiarize attendees with core Big Data technologies, including Hadoop and Spark, and the relevance of NoSQL databases.
3. Leverage Data Sources: Teach participants to identify and utilize various internal and external data sources for effective banking operations.
4. Applications of AI: Illustrate the use of AI techniques in bank examinations, such as risk assessment, fraud detection, and predictive modeling.
5. Implement Data Analytics: Equip participants with the skills to apply data analytics methods for trend identification and risk management in banking contexts
6. Address Ethical Considerations: Discuss the ethical implications of using Big Data and AI in banking and the importance of compliance with regulations
7. Prepare for Future Trends: Prepare participants to navigate future innovations in technology and develop strategies for the integration of Big Data and AI into banking practices

In this instructor-led, live training in Calgary, 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.

This instructor-led, live training in Calgary (online or onsite) is aimed at business analysts who wish to use IBM Cognos for data analysis and reporting.

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

• Analyze and share insights about data.
• Visualize business performance.
• Use AI-assisted preparation to cleanse and combine data sources.
• Uncover hidden patterns in data with IBM Cognos Analytics built in AI features.

In this instructor-led, live training in Calgary, participants will learn to use JasperReports to view and interact with business data as well as create and design reports and dashboards that are viewable on phones and tablets.

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

• Set up and configure a JasperSoft ETL project
• Design and run an ETL job
• Use iReport to generate charts, images, sub-reports, and cross tabs

This instructor-led, live training in Calgary (online or onsite) is aimed at data analysts and data scientists who wish to use Metabase to collect, query, and visualize data for business intelligence analysis and reporting.

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

• Set up and install Metabase to start building data visualizations and dashboards.
• Learn how to query, aggregate, and visualize data in Metabase.
• Use the features and tools in Metabase to write SQL queries.
• Build analytics charts and dashboards to get business insights.
• Know the best practices and tips on using Metabase and resolving common issues.

In this instructor-led, live training in Calgary (online or onsite), participants will learn how to use MicroStrategy to access various data sources, then generate reports and dashboards for analysis.

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

• Install and configure MicroStrategy.
• Use MicroStrategy to perform predictive analytics on large data sets.
• Access and analyze data from data warehouses, Excel files, and Apache Hadoop.
• Create elaborate reports and dashboards.

This instructor-led, live training in Calgary (online or onsite) is aimed at developers who wish to use MicroStrategy to build, customize, and embed MicroStrategy analytics into web and mobile applications through REST APIs and SDKs.

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

• Set up the necessary development environment to start developing custom apps with MicroStrategy.
• Understand the MicroStrategy features, architecture, and core programming concepts.
• Learn how to use the MicroStrategy Web APIs and SDKs to customize analytical applications.
• Integrate MicroStrategy functionalities into web and mobile applications.
• Execute RESTful API commands to embed MicroStrategy with external applications.
• Get some tips on how to troubleshoot and fix coding issues.

This instructor-led, live training in Calgary (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 Calgary (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 Calgary (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.

This instructor-led, live training in Calgary (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 datasets, ready for data analysis.

This instructor-led, live training in (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.

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

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

• 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.