Business Intelligence Training in Calgary

WrenAI enables organizations to move beyond static dashboards toward conversational analytics and embedded generative BI. This transition requires careful adoption planning, migration of assets, and effective change management practices.

This instructor-led, live training (online or onsite) is aimed at intermediate-level BI and data platform professionals who wish to modernize legacy BI systems with WrenAI.

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

• Evaluate legacy BI environments and identify modernization opportunities.
• Plan and execute migrations from static dashboards to WrenAI.
• Adopt conversational analytics and embedded GenBI capabilities.
• Lead organizational change management for BI modernization.

Format of the Course

• Interactive lecture and discussion.
• Hands-on exercises with migration and adoption planning.
• Practical labs on conversational analytics and embedded GenBI.

Course Customization Options

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

This instructor-led, live training in Calgary (online or onsite) is aimed at intermediate-level data professionals who wish to learn how to use Datameer to prepare, analyze, and visualize data using modern techniques, guided workflows, and the latest Datameer interface.

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

• Create and manage data projects within Datameer's workspace.
• Connect to modern data platforms including Snowflake, cloud storage, and databases.
• Perform data transformation using visual, code-free workflows or SQL.
• Collaborate with teams using metadata management and project sharing.
• Use visual exploration tools to profile and understand datasets.
• Create and share rich data visualizations and dashboards.

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

Pentaho Data Integration is a comprehensive platform for designing enterprise-grade ETL and data pipelines.

This instructor-led, live training (online or onsite) is aimed at advanced-level engineers who wish to master high-performance, enterprise-scale, and highly automated PDI solutions.

After completing this course, learners will be equipped to:

• Architect large-scale ETL pipelines with advanced orchestration.
• Optimize complex transformations for high performance.
• Implement scripting, automation, and hybrid integration patterns.
• Design robust, maintainable, production-ready workflows.

Format of the Course

• Expert-led demonstrations and architectural discussion.
• Extensive lab work on advanced real-world ETL challenges.
• Hands-on development in a production-like environment.

Course Customization Options

• Contact us if you require a customized version of this training.

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.

Alteryx Designer is a visual data preparation and analytics platform that enables users to blend, transform, and automate data workflows with minimal coding.

This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to learn practical Alteryx skills for data preparation, blending, basic analytics, and workflow automation.

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

• Build Alteryx workflows for common data preparation tasks.
• Combine and parse data from multiple sources and formats.
• Create and use standard macros to encapsulate reusable logic.
• Organize and automate workflows using best-practice techniques.

Format of the Course

• Interactive lecture and demonstration.
• Hands-on exercises using Alteryx Designer and sample data.
• Practical mini-projects and workflow automation tasks.

Course Customization Options

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

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.

Pentaho Data Integration is a data extraction, transformation, and loading platform.

This instructor-led, live training (online or onsite) is aimed at intermediate-level practitioners who wish to enhance their PDI skills for more complex transformation scenarios.

Upon completing this training, participants will be able to:

• Design multi-step transformations with improved performance.
• Work with variables, parameters, and reusable components.
• Integrate PDI with databases, APIs, and external systems.
• Apply best practices for maintainable and scalable ETL pipelines.

Format of the Course

• Interactive demos and instructor explanations.
• Guided exercises and scenario-based practice.
• Hands-on work in a real-world ETL project environment.

Course Customization Options

• If you need a tailored version of this course, please contact us to customize it.

Qlik Cloud is a SaaS-based analytics platform that enables developers to build, automate, and manage data-driven insights across cloud environments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level developers who wish to design, build, and deploy scalable analytics solutions using Qlik Cloud.

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

• Deploy and manage data models and visualizations in Qlik Cloud.
• Use Qlik Application Automation for workflow and process automation.
• Integrate APIs and external data sources with Qlik Cloud.
• Implement governance, security, and collaboration features in a multi-tenant environment.

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.

This instructor-led, live training in Calgary (online or onsite) is aimed at developers and system administrators who wish to learn and use Sisense for big data manipulation and visualization.

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

• Learn the fundamental concepts of Sisense and how it works.
• Create a Sisense dashboard to visualize big data and execute data-driven business decisions.
• Merge and manage data from multiple sources.
• Utilize Sisense for quick data manipulation and visualization.

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.

WrenAI enables SaaS providers to embed generative business intelligence (GenBI) directly into customer-facing products. This course equips SaaS teams with the skills to integrate Wren AI through its Embedded API, configure white-label analytics, and manage multi-tenant deployments.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level SaaS product leaders, data engineers, and full-stack developers who wish to deploy WrenAI as an embedded analytics solution in SaaS environments.

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

• Integrate WrenAI using the Embedded API for customer-facing applications.
• Implement white-label conversational BI with branding and customization.
• Design secure and scalable multi-tenant deployments.
• Monitor usage, optimize performance, and ensure compliance in SaaS environments.

Format of the Course

• Interactive lecture and discussion.
• Hands-on labs using WrenAI Embedded API.
• Workshop: design and deploy a white-label analytics feature for a SaaS use case.

Course Customization Options

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

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

Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations.

In this instructor-led, live training, participants will learn how to use Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle and maximize the value of data within their organization.

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

• Create, preview, and run basic data transformations containing steps and hops
• Configure and secure the Pentaho Enterprise Repository
• Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format.
• Provide results to third-part applications for further processing

Audience

• Data Analyst
• ETL developers

Format of the course

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

Qlik Sense Enterprise is a scalable, enterprise-grade analytics platform for data visualization, exploration, and embedded analytics.

This instructor-led, live training (online or onsite) is aimed at intermediate-level to advanced-level developers who wish to build, manage, and extend analytics applications using Qlik Sense Enterprise.

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

• Design and develop interactive dashboards and visualizations using Qlik Sense Enterprise.
• Implement and optimize data models and scripting for large-scale datasets.
• Automate data reloads, manage security rules, and integrate APIs.
• Deploy and maintain enterprise-level Qlik environments with performance and governance best practices.

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.

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

WrenAI is a conversational analytics platform that translates natural-language queries into reliable analytics, enabling non-technical teams to generate insights quickly and consistently.

This instructor-led, live training (online or onsite) is aimed at intermediate-level product managers, analysts, and data champions who wish to adopt conversational analytics and build self-service BI capabilities with WrenAI.

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

• Design conversational analytics workflows that surface reliable product insights.
• Create and maintain a standardized metrics layer for consistent reporting.
• Use natural-language to SQL features effectively to answer product questions.
• Embed WrenAI-driven self-service dashboards and guardrails in product workflows.

Format of the Course

• Interactive lecture and discussion.
• Hands-on labs with Wren AI and sample datasets.
• Workshop: build a self-service dashboard and conversational query set.

Course Customization Options

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

This comprehensive training course equips participants with the foundational knowledge and practical skills required to build, manage, and analyze business intelligence (BI) solutions using modern Microsoft technologies. The course focuses on SQL Server (2017/2019/2022 features) and Azure Analysis Services (AAS), covering the entire data analytics pipeline from data ingestion to visualization.

Participants will learn to design and implement modern data warehousing solutions, build robust ETL/ELT pipelines using SQL Server Integration Services (SSIS), create powerful analytical models using SQL Server Analysis Services (SSAS - Tabular) and Azure Analysis Services, and develop insightful reports and visualizations. Emphasis is placed on leveraging in-memory technologies, cloud integration, and modern query languages.

This instructor-led, live training in Calgary (online or onsite) is aimed at data analysts, data scientists and data engineers 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.

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

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

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

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 these volumes of Big Data requires 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 resumes to connect job candidates with hiring managers.

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 data analysts who wish to program with R in SAS for cluster analysis.

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

• Use cluster analysis for data mining
• Master R syntax for clustering solutions.
• Implement hierarchical and non-hierarchical clustering.
• Make data-driven decisions to help to improve business operations.

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

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

• Preapre data with Alteryx to visualize later.
• Perform ETL operations with zero code.
• Leverage Alteryx to improve business intelligence and business analytics.

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

KNIME Analytics Platform is a leading open source option for data-driven innovation, helping you discover the potential hidden in your data, mine for fresh insights, or predict new futures. With more than 1000 modules, hundreds of ready-to-run examples, a comprehensive range of integrated tools, and the widest choice of advanced algorithms available, KNIME Analytics Platform is the perfect toolbox for any data scientist and business analyst.

This course for KNIME Analytics Platform is an ideal opportunity for beginners, advanced users and KNIME experts to be introduced to KNIME, to learn how to use it more effectively, and how to create clear, comprehensive reports based on KNIME workflows

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.

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

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.

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

In this instructor-led, live training in Calgary (online or onsite), 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.

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.

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