Data Analysis with SQL, Python, and Tableau Training Course

This course explores human perception and demonstrates how to harness it to deliver impactful insights. Participants will become familiar with design theory, covering Gestalt Laws, pre-attentive attributes, and inclusive design practices. The curriculum clarifies the distinctions and overlaps between exploratory and explanatory analysis. Learners will explore chart usage and develop the skills to select the most appropriate visualizations for specific contexts. By the end of the course, participants will know how to apply design principles to visualizations created using Tableau software.

Throughout the course, you will acquire the following skills:

This is a beginner-level Tableau course designed for individuals who wish to work with data. It aims to help you master the core functionalities of Tableau.

• Connect to your data.
• Edit and save data sources.
• Understand Tableau terminology.
• Use the Tableau interface and paradigm to effectively create powerful visualizations.
• Create basic calculations, including arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations.
• Represent your data using the following visualization types:
  • Cross tabs
  • Geographic maps
  • Heat maps
  • Tree maps
  • Pie charts and bar charts
  • Dual axis and combined charts with different mark types
  • Highlight Tables
  • Scatter Plots
• Build dashboards to share visualizations.

This instructor-led, live training in Portugal (online or onsite) targets beginner-level professionals who wish to utilize Tableau for creating data visualizations and interactive dashboards.

By the end of this training, participants will be able to connect to data sources, build visualizations, design dashboards, and apply basic data analysis techniques.

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

This instructor-led live training in Portugal (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 using learning algorithms in R.
• Structure and visualise R functions in Tableau.
• Make data driven decisions for business operations.

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

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.

In this instructor-led, live training in Portugal, participants will learn how to extend the capabilities of Tableau to fit the specific needs of their organization.

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

• Install and configure Tableau (Desktop, Server, Online.)
• Understand the fundamentals of developing with Tableau.
• Create and publish data visualizations and interactions with Tableau.
• Use Tableau's developer tools and APIs to customize and extend the capabilities of Tableau for their organization.

By the conclusion of this training, participants will be equipped to:

This instructor-led, live training in Portugal (online or onsite) is designed for intermediate-level digital forensic and cybersecurity professionals seeking a thorough understanding and practical expertise in using Tableau Forensic Imager for digital forensic purposes.

• Comprehend the role and significance of digital forensic imaging in investigations.
• Operate Tableau Forensic Imager to acquire forensically sound images.
• Apply best practices in handling and preserving digital evidence.
• Navigate the software interface to configure, execute, and manage imaging tasks.
• Analyze and validate forensic images to ensure integrity and admissibility in court.

This instructor-led live training in Portugal (online or onsite) is targeted at data analysts and data scientists who aim to search, analyze, and visualize data using Tableau.

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

• Connect to your data.
• Edit and save a data source.
• Understand Tableau terminology.
• Use the Tableau interface / paradigm to effectively create powerful visualizations.
• Create calculations including arithmetic calculations, custom aggregations and ratios, date math, and table calculations.
• Represent your data using different visualization types.
• Build dashboards to share visualizations.

This instructor-led, live training in Portugal (online or onsite) is aimed at data analysts who wish to prepare and shape data using Tableau Prep Builder.

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

• Install Tableau Prep.
• Understand and implement a Data Science Workflow.
• Read data from a variety of sources, such as Excel and databases.
• Prepare, shape and sample data for analysis in Tableau Desktop.
• Explore and validate data.
• Create and publish Tableau Prep flows.

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner to intermediate data analysts who wish to gain practical knowledge of Tableau Prep Builder and the essential mapping functionalities in Tableau to address data preparation and visualization challenges.

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

• Connect to a variety of data sources, including cloud-based and local files, and manage live and extracted data connections.
• Perform data fusion and combination using advanced joining techniques to merge multiple datasets from different sources for better analysis.
• Create calculated fields and perform operations to manipulate and analyze data dynamically.
• Publish and update prepared data to Tableau Server or Tableau Online, enabling automated updates and scheduling.
• Create basic and advanced maps with geographic data, including filled maps, density maps, and dual-axis maps.
• Apply mapping techniques to solve real-world business problems by creating interactive, detailed geographic visualizations.

Tableau is a leading business intelligence and data visualization platform. Python is a versatile programming language that supports a broad spectrum of statistical and machine learning techniques. By harnessing Tableau's powerful visualization capabilities alongside Python's advanced machine learning functionalities, developers can rapidly construct sophisticated data analytics applications tailored to diverse business requirements.

During this instructor-led live training, participants will learn how to seamlessly integrate Tableau and Python to perform advanced analytics. This integration is facilitated through the TabPy API.

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

• Integrate Tableau and Python using the TabPy API
• Leverage the combined power of Tableau and Python to analyze complex business scenarios with minimal Python code

Audience

• Developers
• Data scientists

Format of the course

• A blend of lectures, discussions, exercises, and extensive hands-on practice

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

This instructor-led, live training in Portugal (online or onsite) is aimed at intermediate to advanced-level data architects who wish to learn skills for installing, configuring, managing, and maintaining a Tableau server.

• Gain an in-depth understanding of the Tableau Server architecture.
• Understand Tableau Server processes and functions.
• Utilise Tableau Server to automate tasks.
• Configure and manage the Tableau Server.
• Set up Tableau Server for high availability and scalability.

This instructor-led, live training in Portugal (online or onsite) is aimed at beginner to intermediate-level data scientists and analysts who wish to learn how to utilise Tableau tools for data visualisation and analysis. By the end of this training, participants will be able to: Connect multiple sources of data. Create basic data visualisations. Use basic to advanced calculations for data analysis. Learn best practices for using graphs and visualisations.

This course is ideal for learners new to Tableau or those needing a refresher. It takes you through the essential steps to build your first visualization from scratch. You will also acquire knowledge on applying key design principles to your Tableau visualizations. By the end of the course, you will be capable of creating and sharing your insights with a broad audience.