Business Intelligence Training in Évora

Power BI is a robust business intelligence and data visualization solution that enables users to connect, transform, and visualize data from various sources.

This instructor-led, live training (available online or onsite) is designed for beginner to intermediate users who want to learn how to conduct data analysis and create interactive dashboards using Power BI.

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

• Understand key concepts of data analysis and data-driven decision-making.
• Prepare, clean, and transform data using Power Query.
• Create visually appealing dashboards and interactive reports.
• Publish and share dashboards securely with stakeholders.

Format of the Course

• Interactive lecture and discussion.
• Hands-on practice with Power BI using sample data sets.
• Guided exercises and live demonstrations.

Course Customization Options

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

Power BI serves as a business intelligence platform enabling users to connect with data sources, transform and analyse data, and generate interactive reports and dashboards. Oracle Database, a widely adopted enterprise database solution, integrates seamlessly with Power BI to facilitate corporate reporting.

This instructor-led live training, available either online or onsite, is designed for intermediate-level data professionals seeking to link Oracle databases with Power BI to design, analyse, and present actionable insights tailored to corporate requirements.

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

• Connect Power BI to Oracle databases and other data sources.
• Execute data cleansing, consolidation, and transformation.
• Utilise Power Query and Pivot for ETL processes.
• Apply DAX and M formulas for data modelling and analysis.
• Design professional reports and executive presentations within Power BI.
• Leverage advisory support to meet corporate reporting requirements.

Format of the Course

• Instructor-led lectures and discussions.
• Hands-on labs involving Power BI and Oracle.
• Practical exercises addressing real-world reporting needs.
• Advisory support sessions.

Course Customization Options

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

Power BI serves as a robust business analytics platform designed for visualizing financial and operational data.

This instructor-led live training, available online or on-site, targets intermediate-level finance and HR professionals seeking to leverage Power BI for the effective analysis and visualization of cash flow and payroll data.

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

• Connect Power BI to various financial and payroll data sources.
• Develop dashboards to monitor cash inflows and outflows.
• Construct interactive payroll reports featuring key HR and cost metrics.
• Model time-based data to assess trends and variances.
• Automate and distribute finance reports across the organization.

Course Format

• Interactive lectures and discussions
• Practical lab exercises using sample payroll and cash flow datasets
• Real-world projects focused on report creation and automation

Course Customization Options

• To arrange a customized training session for this course, please get in touch with us.

WrenAI empowers organizations to move beyond static dashboards, embracing conversational analytics and embedded generative BI. This shift demands meticulous adoption planning, the migration of existing assets, and robust change management strategies.

This instructor-led, live training (available online or onsite) is designed for intermediate-level BI and data platform professionals looking to modernize their legacy BI systems using WrenAI.

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

• Assess legacy BI environments and pinpoint opportunities for modernization.
• Plan and execute the migration from static dashboards to WrenAI.
• Implement conversational analytics and embedded GenBI capabilities.
• Lead organizational change management efforts related to BI modernization.

Course Format

• Interactive lectures and discussions.
• Hands-on exercises focused on migration and adoption planning.
• Practical labs covering conversational analytics and embedded GenBI.

Course Customization Options

• For customized training requests regarding this course, please contact us to arrange details.

This instructor-led, live training in Évora (online or onsite) is designed for beginner-level financial analysts aiming to integrate AI effectively into their data analysis processes.

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

• Grasp the application of AI in data analysis within the financial industry.
• Acquire the skills necessary to build predictive and prescriptive models for financial analysis.
• Learn to implement machine learning algorithms for processing financial data.
• Improve data visualization techniques and interpret complex AI-driven insights to support decision-making.

This instructor-led live training in Évora (online or onsite) is aimed at beginner-level financial analysts who wish to learn how to use Power BI for data analysis, reporting and dashboard creation, and prepare for Power BI certification (PL-300).

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

• Navigate and use Power BI Desktop and Power BI Service.
• Connect to various data sources and transform data using Power Query.
• Create interactive dashboards and reports.
• Use DAX (Data Analysis Expressions) for calculations and data modeling.
• Publish and share reports securely within an organization.
• Prepare for Power BI certification (PL-300: Microsoft Power BI Data Analyst).

This instructor-led, live training in Évora (online or onsite) is tailored for 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 Évora (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.

Tableau Explorer is a specific license tier within Tableau Cloud, tailored for users who engage with dashboards, apply filters, create views, and collaborate with teams using published data sources.

This instructor-led training, available either online or onsite, is designed for business users ranging from beginner to intermediate levels who wish to explore, filter, and interact with data through Tableau Explorer in Tableau Cloud.

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

• Navigate Tableau dashboards and shared workbooks with confidence.
• Apply filters, drill down into data, and export information directly from dashboards.
• Create saved views and custom alerts triggered by data changes.
• Collaborate effectively with team members via comments, subscriptions, and shared views.

Format of the Course

• Interactive lectures combined with live demonstrations.
• Practical exercises utilizing shared dashboards and published content.
• Real-time practice within Tableau Cloud, guided by structured exploration.

Course Customization Options

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

This instructor-led, live training in Évora (online or onsite) is tailored for beginner-level business and data analysts seeking to utilise Oracle BI to extract valuable insights from their data.

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

• Effectively navigate and utilise the Oracle BI interface.
• Develop and tailor reports and dashboards to meet specific business requirements.
• Perform ad-hoc analysis using a variety of BI tools.
• Leverage advanced features for in-depth data exploration.

This instructor-led, live training session in Évora (online or onsite) is designed for 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 Évora (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 Évora (online or onsite) is aimed at beginner-level professionals who wish to clean and analyze data, make statistical projections, and create insightful visualizations using these tools.

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

• Understand the basics of Python, R, Power Query, and Power BI for data analysis.
• Clean and organize datasets using Python and Power Query.
• Perform statistical analysis and projections with R.
• Create professional dashboards and reports with Power BI.
• Integrate and analyze data from multiple sources effectively.

Qlik Cloud is a SaaS-based analytics platform that empowers developers to create, automate, and oversee data-driven insights across cloud environments.

This instructor-led live training (available online or on-site) targets intermediate to advanced developers looking to design, build, and deploy scalable analytics solutions using Qlik Cloud.

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

• Deploying and managing data models and visualizations within Qlik Cloud.
• Utilizing Qlik Application Automation for workflow and process automation.
• Integrating APIs and external data sources with Qlik Cloud.
• Implementing governance, security, and collaboration features in a multi-tenant environment.

Course Format

• Interactive lectures and discussions.
• Numerous exercises and practice sessions.
• 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 Évora (online or onsite) is aimed at intermediate-level IT administrators who wish to use Splunk 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 empowers SaaS providers to embed generative business intelligence (GenBI) directly within their customer-facing applications. This course equips SaaS teams with the expertise required to integrate Wren AI via its Embedded API, configure white-label analytics, and effectively manage multi-tenant deployments.

This instructor-led, live training session (available online or onsite) is designed for intermediate to advanced SaaS product leaders, data engineers, and full-stack developers looking to deploy WrenAI as an embedded analytics solution within SaaS environments.

Upon completing this training, participants will be able to:

• Integrate WrenAI using the Embedded API to enhance customer-facing applications.
• Implement white-label conversational BI, including specific branding and customization.
• Architect secure and scalable multi-tenant deployments.
• Monitor usage metrics, optimize performance, and ensure compliance within SaaS environments.

Course Format

• Interactive lectures and discussions.
• Practical hands-on labs utilizing the WrenAI Embedded API.
• Workshop: Design and deploy a white-label analytics feature tailored to a SaaS use case.

Course Customization Options

• To request a customized training version of this course, please contact us to arrange the details.

This instructor-led, live training in Évora (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 Évora (available online or onsite) targets data analysts and anyone interested in utilizing AWS QuickSight for 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.

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

This instructor-led training session, available online or onsite, targets intermediate to advanced developers looking to build, manage, and extend analytics applications using Qlik Sense Enterprise.

Upon completing this course, participants will be able to:

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

Course Format

• Interactive lectures and discussions.
• Numerous exercises and practical activities.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• For a customized training arrangement, please contact us to discuss your needs.

This instructor-led, live training in Évora (online or onsite) is aimed at intermediate to advanced 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.

The "Big Data and AI in Banking" training program is designed to empower banking professionals with the essential skills and insights needed to leverage Big Data and artificial intelligence. Participants will delve into foundational concepts, key technologies, and practical applications relevant to the banking sector. The curriculum combines theoretical teaching, real-world case studies, hands-on workshops, and discussions on regulatory implications, ethical considerations, and industry best practices.

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

1. Grasp Key Concepts: Gain a solid foundational understanding of Big Data and AI, recognizing their critical role in the banking industry.
2. Explore Technologies: Become familiar with core Big Data technologies, including Hadoop and Spark, and understand the importance of NoSQL databases.
3. Leverage Data Sources: Learn to identify and utilize diverse internal and external data sources to enhance banking operations.
4. Apply AI Techniques: Understand how AI techniques are used in bank examinations, such as for risk assessment, fraud detection, and predictive modeling.
5. Implement Data Analytics: Acquire the skills to apply data analytics methods for identifying trends and managing risk within banking contexts.
6. Address Ethical Considerations: Discuss the ethical implications of using Big Data and AI in banking and emphasize the importance of regulatory compliance.
7. Prepare for Future Trends: Equip participants to navigate future technological innovations and develop strategies for integrating Big Data and AI into banking practices.

Technological advancements and the exponential growth of information are fundamentally reshaping business operations across various sectors, including the government sector. The volume of data generated and digitized by governments is increasing rapidly, driven by the proliferation of mobile devices and applications, smart sensors, cloud computing solutions, and citizen-facing digital portals. As digital information expands and grows more complex, the management, processing, storage, security, and disposal of that information also become more challenging. Emerging tools for capture, search, discovery, and analysis are enabling organizations to derive valuable insights from unstructured data. The government sector is reaching a critical juncture, recognizing information as a strategic asset. To better serve citizens and fulfill mission requirements, governments must protect, leverage, and analyze both structured and unstructured data. As government leaders work to evolve their organizations into data-driven entities, they are establishing the foundation to correlate dependencies across events, personnel, processes, and information.

High-impact government solutions are being developed by integrating the most disruptive technologies:

• Mobile devices and applications
• Cloud services
• Social business technologies and networking
• Big Data and analytics

Big Data represents an intelligent industry solution that empowers governments to make superior decisions by acting on patterns identified through the analysis of vast volumes of data—whether related or unrelated, structured or unstructured.

However, achieving these outcomes requires more than just accumulating large amounts 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 significant step toward helping agencies identify these technologies by establishing the National Big Data Research and Development Initiative in 2012. This initiative allocated over $200 million to maximize the potential of the Big Data explosion and the tools required to analyze it.

The challenges posed by Big Data are as formidable as its potential benefits are encouraging. Efficient data storage is one key challenge. With budgets remaining tight, agencies must minimize the cost per megabyte of storage while ensuring data remains easily accessible so users can retrieve it whenever and however they need it. Backing up these massive data volumes further intensifies the challenge.

Effective data analysis is another major hurdle. Many agencies utilize commercial tools that allow them to sift through vast amounts of data, identifying trends that enhance operational efficiency. (A recent study by MeriTalk found that federal IT executives believe Big Data could help agencies save over $500 billion while also meeting mission objectives.)

Custom-developed Big Data tools are also enabling agencies to meet their data analysis needs. For instance, the Oak Ridge National Laboratory’s Computational Data Analytics Group has made its Piranha data analytics system available to other agencies. This system has helped medical researchers identify links that can alert doctors to aortic aneurysms before they occur. It is also used for routine tasks, such as sifting through resumes to match job candidates with hiring managers.

In this instructor-led live training in Évora, participants will learn the mindset required to approach Big Data technologies, assess their impact on existing processes and policies, and implement these technologies to identify criminal activity and prevent crime. Case studies from law enforcement organizations worldwide will be examined to gain insights into their adoption approaches, challenges, and results.

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

• Integrate Big Data technology with traditional data gathering processes to construct a narrative during an investigation.
• Implement industrial big data storage and processing solutions for data analysis.
• Prepare a proposal for adopting the most suitable tools and processes to enable a data-driven approach to criminal investigation.

In this instructor-led live training held in Évora, participants will learn to use JasperReports to view and interact with business data, as well as create and design reports and dashboards that can be viewed on mobile 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

Discover how to acquire and transform data to build interactive dashboards.

Power BI stands as one of the most widely adopted data visualization and business intelligence tools. It comprises a suite of data connectors, applications, and software services designed to extract data from various sources, transform it, and generate visually compelling reports.

Furthermore, Power BI enables you to publish these reports for your organization, allowing access via mobile devices, tablets, and other platforms. In this Power BI tutorial, we guide you through a step-by-step process to connect with multiple data sources, perform data transformations, and create reports featuring charts, tables, matrices, maps, and more.

This instructor-led live training in Évora (online or onsite) is intended for data analysts who wish to use SAS for advanced data management, data analysis, and 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.

SSAS (SQL Server Analysis Services) is a Microsoft SQL Server tool designed for Online Analytical Processing (OLAP) and data mining, enabling the analysis of data across multiple databases, tables, or files. The semantic data models provided by SSAS serve as a foundation for client applications such as Power BI, Excel, Reporting Services, and various data visualization tools.

In this instructor-led live training (available onsite or remotely), participants will learn how to utilize SSAS to analyze large volumes of data stored 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 Évora (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:

• Build statistical models to predict 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 statistical models for predicting key interest variables and events.
• Generate descriptive visualizations, summary tables, frequencies, and more.
• Manage and structure large databases to prepare for data analysis.