Data Analysis with SQL, Python, and Tableau Training Course

This instructor-led, live training session in South Korea (available online or onsite) targets intermediate-level database administrators, developers, and analysts who wish to master advanced SQL functionalities for complex data operations and database management.

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

• Perform advanced querying techniques using unions, subqueries, and complex joins.
• Add, update, and delete data, tables, views, and indexes with precision.
• Ensure data integrity through transactions and manipulate database structures.
• Create and manage databases efficiently for robust data storage and retrieval.

This course explores the science of human perception and demonstrates how to leverage it to generate powerful insights. You will gain proficiency in design theory, covering Gestalt laws, pre-attentive attributes, and inclusive design practices. The curriculum also clarifies the distinctions and overlaps between exploratory and explanatory data analysis. You will learn how to select the most appropriate chart types for specific data scenarios. By the conclusion of the course, you will be equipped to apply effective design principles to visualizations created within the Tableau software.

Throughout this course, you will gain the ability to:

Designed as an introductory course for Tableau users, this program is tailored for anyone interested in working with data. It aims to help you master the core functionalities of Tableau.

• Establish connections with your data.
• Edit and save data sources.
• Grasp Tableau-specific terminology.
• Leverage the Tableau interface and paradigm to create impactful visualizations.
• Develop basic calculations, such as fundamental arithmetic, custom aggregations, ratios, date operations, and quick table calculations.
• Utilize the following visualization types to represent your data:
  • Cross tabs
  • Geographic maps
  • Heat maps
  • Tree maps
  • Pie charts and bar charts
  • Dual axis and combined charts with various mark types
  • Highlight Tables
  • Scatter Plots
• Construct dashboards to effectively share your visualizations.

Upon completing this training, participants will gain the ability to:

This instructor-led live training in South Korea (available online or onsite) is targeted at data scientists who wish to program R for Tableau.

• Integrate R-based analytics into Tableau.
• Return values to Tableau using R's machine learning algorithms.
• Organize and visualize R functions using Tableau.
• Drive business operational decisions through data analysis.

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

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

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

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

This instructor-led live training, available either online or onsite, targets beginner to intermediate business users eager to explore, filter, and interact with data using the Tableau Explorer role in Tableau Cloud.

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

• Confidently navigate Tableau dashboards and shared workbooks.
• Apply filters, drill down into details, and export data directly from dashboards.
• Create saved views and establish custom alerts triggered by data changes.
• Collaborate effectively with team members through comments, subscriptions, and shared views.

Course Format

• Interactive lectures paired with live demonstrations.
• Practical exercises utilizing shared dashboards and published content.
• Real-time practice in Tableau Cloud with guided exploration.

Customization Options

• To arrange a customized version of this course, please contact us to discuss your needs.

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

This instructor-led, live training in South Korea (online or onsite) is designed for intermediate-level digital forensic and cybersecurity professionals who wish to develop a comprehensive understanding and practical skills in using Tableau Forensic Imager for digital forensic purposes.

• Understand the role and importance 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, available in South Korea (online or onsite), targets data analysts and data scientists who aim to explore, analyze, and visualize data using Tableau.

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

• Establish connections with various data sources.
• Edit and save data sources efficiently.
• Gain a thorough understanding of key Tableau terminology.
• Navigate the Tableau interface and leverage its paradigms to create impactful visualizations.
• Develop complex calculations, including arithmetic operations, custom aggregations and ratios, date functions, and table calculations.
• Represent data effectively using a variety of visualization types.
• Construct interactive dashboards to share and present visual insights.

This instructor-led, live training in South Korea (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 South Korea (online or onsite) is aimed at beginner-level to intermediate-level 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 serves as a prominent business intelligence and data visualization platform, while Python is a versatile programming language that supports a broad spectrum of statistical and machine learning methods. By leveraging Tableau's robust visualization capabilities alongside Python's powerful machine learning functions, developers can swiftly construct sophisticated data analytics solutions tailored to diverse business requirements.

Through this instructor-led live training, attendees will discover how to effectively merge Tableau and Python for advanced analytical tasks. The integration between these two tools is facilitated via the TabPy API.

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

• Integrate Tableau and Python using the TabPy API
• Utilize 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 mix of lectures, discussions, exercises, and extensive hands-on practice

Upon completion of this training, participants will gain the ability to:

This instructor-led, live training in South Korea (available online or onsite) is designed for intermediate to advanced-level data architects who wish to acquire the skills necessary for installing, configuring, managing, and maintaining a Tableau Server.

• Gain a comprehensive understanding of Tableau Server architecture.
• Grasp the core processes and functions of Tableau Server.
• Leverage Tableau Server to automate operational tasks.
• Configure and oversee the Tableau Server environment.
• Establish Tableau Server configurations for high availability and scalability.

Ideal for beginners or those seeking a refresher, this program guides learners through the foundational steps of creating their first visualization from scratch. Participants will also acquire essential design principles to enhance their Tableau dashboards. Upon completion, you will possess the skills to craft and disseminate impactful insights to a broader community.

This instructor-led, live training in South Korea (online or onsite) is aimed at advanced-level data professionals who wish to use Tableau to build complex visualizations, optimize dashboards, and perform advanced data analysis.

By the end of this training, participants will be able to: install and configure Tableau for advanced use, create advanced calculations, design interactive dashboards, and optimize performance.

This engaging four-day course is designed for individuals new to Tableau. Participants will become proficient in all Tableau functionalities and learn how to create and share data visualizations. The curriculum guides you through every step of the process, from connecting to data sources, creating calculations, selecting appropriate chart types, building dashboards, to publishing your final work.

The course structure consists of lectures focused on specific topics, followed by practical exercises. It concludes with a 30-minute knowledge test and a 60-minute hands-on project assignment.

Course milestones:

• Get familiar with the Tableau interface.
• Connect to and work with your data.
• Utilize Tableau's key features.
• Build insightful visualizations.
• Share your work with a broader audience.

Course format:

• Interactive lectures and discussions.
• Ample exercises and practice opportunities.
• Hands-on implementation in a live-lab environment.
• Knowledge assessment and hands-on project at the course conclusion.