Business Intelligence Training in Hsinchu

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

Designed for intermediate data and business analysts, this live, instructor-led training on Hsinchu—delivered either online or on-site—focuses on the creation, management, and administration of dashboards using Amazon QuickSight.

Upon completion, participants will be equipped to:

• Grasp the core benefits, practical applications, and key capabilities of Amazon QuickSight.
• Establish connections between QuickSight and diverse data sources while crafting interactive visualizations and dashboards.
• Apply effective security frameworks and access control mechanisms within the platform.
• Harness integrated machine learning capabilities to derive more profound insights from data.
• Design and customize comprehensive QuickSight dashboards that effectively communicate business insights.

This live, instructor-led training in Hsinchu, offered online or on-site, is designed for intermediate-level data and business analysts who aim to effectively create and deploy business intelligence reports using BIRT.

By the end of this program, participants will have the ability to:

• Comprehend the architecture and key components of the BIRT framework.
• Develop informative and dynamic reports using the BIRT Report Designer.
• Utilize BIRT’s scripting features to integrate business logic into reports.
• Optimize and deploy BIRT reports for use in web and standalone applications.

This instructor-led, live training in Hsinchu (available online or onsite) targets beginner-level business and data analysts seeking to leverage Oracle BI for extracting valuable insights from their data.

By the end of the 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 Hsinchu (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 Hsinchu (online or onsite) is designed for beginner to intermediate data analysts who wish to utilize 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 Hsinchu (online or onsite) targets 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.

Upon completion of this training, participants will be capable of:

• Navigating and effectively using the SAP BusinessObjects BI interface.
• Creating and customizing business reports and dashboards.
• Conducting ad-hoc analysis utilizing various BI tools.
• Leveraging advanced features for in-depth data exploration.

This instructor-led, live training in Hsinchu (online or onsite) is designed for intermediate-level participants who aim to master advanced data integration and visualization techniques in Looker Studio. Participants will learn how to connect diverse data sources, design compelling dashboards, and automate reporting workflows to facilitate 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 Hsinchu (online or onsite) targets beginner to advanced consultants and finance professionals preparing for the Cognos Analytics certification while acquiring specialized skills in financial data analysis, covering accounts payable, treasury, and expense modules.

Upon completing this training, participants will be able to:

• Efficiently navigate and use the Cognos Analytics interface.
• Create and tailor financial reports and dashboards.
• Manage data models and optimize queries.
• Prepare for the Cognos Analytics certification exam.

This instructor-led, live training in Hsinchu (online or onsite) is designed for professionals at beginner to intermediate levels who aim to boost their productivity and efficiency by harnessing the advanced capabilities of Excel and Google Sheets for organizing, analyzing, and collaborating on data.

Upon completion of this training, participants will be able to:

• Navigate and effectively use the core features of Excel and Google Sheets.
• Conduct data analysis and generate actionable insights through advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets to enable seamless teamwork.
• Develop reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Hsinchu (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 Hsinchu (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 Hsinchu (online or onsite) targets data scientists and 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 Hsinchu (online or onsite) is aimed at data analysts or anyone who wishes to use AWS QuickSight for data analysis and visualization.

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

• Understand the fundamental concepts of AWS QuickSight.
• Utilize AWS QuickSight to create data analyses, reports, and insights.
• Use AWS to establish relationships between data for enhanced analysis.
• Learn various types of visualizations to better understand data.

This instructor-led, live training in Hsinchu (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 live, instructor-led training—delivered either online or onsite in Hsinchu—is designed for intermediate data professionals aiming to implement a lakehouse architecture using Microsoft Fabric.

By the conclusion of this program, participants will be capable of:

• Comprehending the structure and elements of Microsoft Fabric.
• Configuring and overseeing a Lakehouse environment within Microsoft Fabric.
• Ingesting and transforming data streams with Apache Spark.
• Leveraging Delta Lake tables for data versioning and control.
• Establishing data ingestion pipelines using Dataflows Gen2.
• Managing and automating data pipelines via Data Factory.

This instructor-led, live training in Hsinchu (online or onsite) is designed for data analysts seeking 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 Hsinchu (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 Hsinchu (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 Hsinchu (online or onsite) is designed for data scientists and developers who wish to utilize 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 Hsinchu (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 Hsinchu (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 empower banking professionals with the essential skills and knowledge needed to leverage the potential of Big Data and artificial intelligence. Participants will delve into the foundational concepts, technologies, and practical applications of these innovations within the financial sector. The curriculum combines theoretical instruction, real-world case studies, hands-on exercises, and discussions on regulatory implications, ethical considerations, and industry best practices.

Upon completion of this training, participants will be able to:

1. Grasp Core Concepts: Gain a solid foundational understanding of Big Data and AI, including their critical role in the banking industry.
2. Explore Essential Technologies: Become familiar with key Big Data technologies, such as Hadoop and Spark, and understand the significance of NoSQL databases.
3. Utilize Data Sources: Learn to identify and effectively use various internal and external data sources to enhance banking operations.
4. Apply AI Techniques: Examine how AI techniques are utilized in bank examinations, including risk assessment, fraud detection, and predictive modeling.
5. Execute Data Analytics: Acquire the skills to apply data analytics methods for identifying trends and managing risks in banking contexts.
6. Navigate Ethical Issues: Discuss the ethical implications of using Big Data and AI in banking, emphasizing the importance of regulatory compliance.
7. Anticipate Future Trends: Prepare for future technological innovations by developing strategies to integrate Big Data and AI into banking practices.

In this instructor-led live training in Hsinchu, 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 Hsinchu (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 Hsinchu, 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 Hsinchu (online or onsite) is designed for data analysts and data scientists who want to use Metabase to collect, query, and visualize data for business intelligence analysis and reporting.

Upon completing this training, participants will be able to:

• Install and configure Metabase to begin creating data visualizations and dashboards.
• Master the techniques for querying, aggregating, and visualizing data within Metabase.
• Utilize Metabase’s features and tools to author SQL queries.
• Construct analytics charts and dashboards to derive actionable business insights.
• Apply best practices and troubleshooting tips for using Metabase and resolving common issues.

In this instructor-led live training held in Hsinchu (online or onsite), participants will learn how to utilize MicroStrategy to access various data sources and subsequently 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 Hsinchu (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:

• Configure the necessary development environment to begin building custom apps with MicroStrategy.
• Gain a solid understanding of MicroStrategy features, architecture, and core programming concepts.
• Learn how to use MicroStrategy Web APIs and SDKs to customize analytical applications.
• Integrate MicroStrategy functionalities into web and mobile applications.
• Execute RESTful API commands to embed MicroStrategy within external applications.
• Receive practical tips on troubleshooting and resolving coding issues.

This instructor-led, live training in Hsinchu (online or onsite) is designed for data analysts who wish to program in SAS for advanced data management, analysis, and other related tasks.

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 Hsinchu (online or onsite) is aimed at data analysts and data scientists who wish to search, analyze, and visualize data using Splunk.

Upon completion of this training, participants will be able to:

• Install and configure Splunk.
• Collect and index various types 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 Hsinchu (online or onsite) is designed for engineers who wish to ingest data into Splunk Indexers and manipulate data in Splunk.

Upon completion of this training, participants will be able to:

• Utilize various data input methods and sources.
• Install, configure, manage, and monitor Forwarders.
• Manipulate raw data within Splunk.
• Generate a Splunk Diag.

This instructor-led live training in Hsinchu (online or onsite) is designed for data analysts who wish to analyze large datasets using Stata.

Upon completion of this training, participants will be able to:

• Develop statistical models to predict key variables of interest and events.
• Produce descriptive visualizations, summary tables, frequency distributions, and more.
• Organize and structure large datasets to prepare them for analysis.

This instructor-led live training, available online or onsite, targets data analysts who wish to use Stata and R to perform statistical analysis on big data.

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

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

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

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