427 Data Analyst courses

Duration 2 Days 12 CPD hours This course is intended for This course is relevant to anyone who needs to work with and understand data including: Business Analysts, Data Analysts, Reporting and BI professionals Marketing and Digital Marketing professionals Digital, Web, e-Commerce, Social media and Mobile channel professionals Business managers who need to interpret analytical output to inform managerial decisions Overview This course will cover the basic theory of data visualization along with practical skills for creating compelling visualizations, reports and dashboards from data using Tableau. Outcome: After attending this course delegates will understand - How to move from business questions to great data visualizations and beyond How to apply the fundamentals of data visualization to create informative charts How to choose the right visualization type for the job at hand How to design and develop basic dashboards in Tableau that people will love to use by doing the following: Reading data sources into Tableau Setting up the roles and data types for your analysis Creating new data fields using a range of calculation types Creating the following types of charts - cross tabs, pie and bar charts, geographic maps, dual axis and combo charts, heat maps, highlight tables, tree maps and scatter plots Creating Dashboards that delight using the all of the features available in Tableau. The use of analytics, statistics and data science in business has grown massively in recent years. Harnessing the power of data is opening actionable insights in diverse industries from banking to tourism. FROM BUSINESS QUESTIONS TO DATA VISUALISATION AND BEYOND * The first step in any data analysis project is to move from a business question to data analysis and then on to a complete solution. This section will examine this conversion emphasizing: * The use of data visualization to address a business need * The data analytics process ? from business questions to developed dashboards INTRODUCTION TO TABLEAU ? PART 1 * In this section, the main functionality of Tableau will be explained including: * Selecting and loading your data * Defining data item properties * Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations * Creating basic visualizations * Creating a basic dashboard INTRODUCTION TO TABLEAU ? PART 2 * In this section, the main functionality of Tableau will be explained including: * Selecting and loading your data * Defining data item properties * Create basic calculations including basic arithmetic calculations, custom aggregations and ratios, date math, and quick table calculations * Creating basic visualizations * Creating a basic dashboard * KEY COMPONENTS OF GOOD DATA VISUALISATION AND THE VISUALISATION ZOO * In this section the following topics will be covered: * Colour theory * Graphical perception & communication * Choosing the right chart for the right job DATA EXPLORATION WITH TABLEAU * Exploring data to answer business questions is one of the key uses of applying good data visualization techniques within Tableau. In this section we will apply the data visualization theory from the previous section within Tableau to uncover trends within the data to answer specific business questions. The types of charts that will be covered are: * Cross Tabs * Pie and bar charts * Geographic maps * Dual axis and combo charts with different mark types * Heat maps * Highlight tables * Tree maps * Scatter plots INTRODUCTION TO BUILDING DASHBOARDS WITH TABLEAU * In this section, we will implement the full process from business question to final basic dashboard in Tableau: * Introduction to good dashboard design * Building dashboards in Tableau

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course is as follows: System Engineers System Administrators Architects Channel Partners Data Analysts Overview Upon completing this course, you will be able to meet these overall objectives: Describe how harnessing the power of your machine data enables you to make decisions based on facts, bot intuition or best guesses. Reduce the time you spend investigating incidents by up to 90%. Find and fix problems faster by learning new technical skills for real world scenarios. Get started with Splunk Enterprise, from installation and data onboarding to running search queries to creating simple reports and dashboards. Accelerate time to value with turnkey Splunk integrations for dozens of Cisco products and platforms. Ensure faster, more predictable Splunk deployments with a proven Cisco Validated Design and the latest Cisco UCS server. This course will cover how Splunk software scales to collect and index hundreds of terabytes of data per day, across multi-geography, multi-datacenter and cloud based infrastructures. Using Cisco?s Unified Computing System (UCS) Integrated Infrastructure for Big Data offers linear scalability along with operational simplification for single-rack and multiple-rack deployments. CISCO INTEGRATED INFRASTRUCTURE FOR BIG DATA AND SPLUNK * What is Cisco CPA? * Architecture benefits for Splunk * Components of IIBD and relationship to Splunk Architecture * Cisco UCS Integrated Infrastructure for Big Data with Splunk Enterprise * Splunk- Big Data Analytics * NFS Configurations for the Splunk Frozen Data Storage * NFS Client Configurations on the Indexers SPLUNK- START SEARCHING * Chargeback * Reporting * Building custom reports using the report builder APPLICATION CONTAINERS * Understanding Application Containers UNDERSTANDING ADVANCED TASKS * Task Library & Inputs * CLI & SSH Task * Understanding Compound Tasks * Custom Tasks OPEN AUTOMATION TROUBLESHOOTING * UCS Director Restart * Module Loading * Report Errors * Feature Loading * Report Registration REST API- AUTOMATION * UCS Director Developer Tools * Accessing REST using a REST client * Accessing REST using the REST API browser OPEN AUTOMATION SDK * Overview * Open Automation vs. Custom Tasks * Use Cases UCS DIRECTOR POWERSHELL API * Cisco UCS Director PowerShell Console * Installing & Configuring * Working with Cmdlets CLOUPIA SCRIPT * Structure * Inputs & Outputs * Design * Examples ADDITIONAL COURSE DETAILS: Nexus Humans Cisco Splunk for Cisco Integrated Infrastructure (SPLUNK) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Splunk for Cisco Integrated Infrastructure (SPLUNK) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data MODULE 1: INTRODUCTION TO DATA WAREHOUSING * Relational databases * Data warehousing concepts * The intersection of data warehousing and big data * Overview of data management in AWS * Hands-on lab 1: Introduction to Amazon Redshift MODULE 2: INTRODUCTION TO AMAZON REDSHIFT * Conceptual overview * Real-world use cases * Hands-on lab 2: Launching an Amazon Redshift cluster MODULE 3: LAUNCHING CLUSTERS * Building the cluster * Connecting to the cluster * Controlling access * Database security * Load data * Hands-on lab 3: Optimizing database schemas MODULE 4: DESIGNING THE DATABASE SCHEMA * Schemas and data types * Columnar compression * Data distribution styles * Data sorting methods MODULE 5: IDENTIFYING DATA SOURCES * Data sources overview * Amazon S3 * Amazon DynamoDB * Amazon EMR * Amazon Kinesis Data Firehose * AWS Lambda Database Loader for Amazon Redshift * Hands-on lab 4: Loading real-time data into an Amazon Redshift database MODULE 6: LOADING DATA * Preparing Data * Loading data using COPY * Data Warehousing on AWS * AWS Classroom Training * Concurrent write operations * Troubleshooting load issues * Hands-on lab 5: Loading data with the COPY command MODULE 7: WRITING QUERIES AND TUNING FOR PERFORMANCE * Amazon Redshift SQL * User-Defined Functions (UDFs) * Factors that affect query performance * The EXPLAIN command and query plans * Workload Management (WLM) * Hands-on lab 6: Configuring workload management MODULE 8: AMAZON REDSHIFT SPECTRUM * Amazon Redshift Spectrum * Configuring data for Amazon Redshift Spectrum * Amazon Redshift Spectrum Queries * Hands-on lab 7: Using Amazon Redshift Spectrum MODULE 9: MAINTAINING CLUSTERS * Audit logging * Performance monitoring * Events and notifications * Lab 8: Auditing and monitoring clusters * Resizing clusters * Backing up and restoring clusters * Resource tagging and limits and constraints * Hands-on lab 9: Backing up, restoring and resizing clusters MODULE 10: ANALYZING AND VISUALIZING DATA * Power of visualizations * Building dashboards * Amazon QuickSight editions and feature

Duration 5 Days 30 CPD hours This course is intended for This intermediate and beyond level course is geared for experienced technical professionals in various roles, such as developers, data analysts, data engineers, software engineers, and machine learning engineers who want to leverage Scala and Spark to tackle complex data challenges and develop scalable, high-performance applications across diverse domains. Practical programming experience is required to participate in the hands-on labs. Overview Working in a hands-on learning environment led by our expert instructor you'll: Develop a basic understanding of Scala and Apache Spark fundamentals, enabling you to confidently create scalable and high-performance applications. Learn how to process large datasets efficiently, helping you handle complex data challenges and make data-driven decisions. Gain hands-on experience with real-time data streaming, allowing you to manage and analyze data as it flows into your applications. Acquire practical knowledge of machine learning algorithms using Spark MLlib, empowering you to create intelligent applications and uncover hidden insights. Master graph processing with GraphX, enabling you to analyze and visualize complex relationships in your data. Discover generative AI technologies using GPT with Spark and Scala, opening up new possibilities for automating content generation and enhancing data analysis. Embark on a journey to master the world of big data with our immersive course on Scala and Spark! Mastering Scala with Apache Spark for the Modern Data Enterprise is a five day hands on course designed to provide you with the essential skills and tools to tackle complex data projects using Scala programming language and Apache Spark, a high-performance data processing engine. Mastering these technologies will enable you to perform a wide range of tasks, from data wrangling and analytics to machine learning and artificial intelligence, across various industries and applications.Guided by our expert instructor, you?ll explore the fundamentals of Scala programming and Apache Spark while gaining valuable hands-on experience with Spark programming, RDDs, DataFrames, Spark SQL, and data sources. You?ll also explore Spark Streaming, performance optimization techniques, and the integration of popular external libraries, tools, and cloud platforms like AWS, Azure, and GCP. Machine learning enthusiasts will delve into Spark MLlib, covering basics of machine learning algorithms, data preparation, feature extraction, and various techniques such as regression, classification, clustering, and recommendation systems. INTRODUCTION TO SCALA * Brief history and motivation * Differences between Scala and Java * Basic Scala syntax and constructs * Scala's functional programming features INTRODUCTION TO APACHE SPARK * Overview and history * Spark components and architecture * Spark ecosystem * Comparing Spark with other big data frameworks BASICS OF SPARK PROGRAMMING SPARKCONTEXT AND SPARKSESSION * Resilient Distributed Datasets (RDDs) * Transformations and Actions * Working with DataFrames SPARK SQL AND DATA SOURCES * Spark SQL library and its advantages * Structured and semi-structured data sources * Reading and writing data in various formats (CSV, JSON, Parquet, Avro, etc.) * Data manipulation using SQL queries BASIC RDD OPERATIONS * Creating and manipulating RDDs * Common transformations and actions on RDDs * Working with key-value data BASIC DATAFRAME AND DATASET OPERATIONS * Creating and manipulating DataFrames and Datasets * Column operations and functions * Filtering, sorting, and aggregating data INTRODUCTION TO SPARK STREAMING * Overview of Spark Streaming * Discretized Stream (DStream) operations * Windowed operations and stateful processing PERFORMANCE OPTIMIZATION BASICS * Best practices for efficient Spark code * Broadcast variables and accumulators * Monitoring Spark applications INTEGRATING EXTERNAL LIBRARIES AND TOOLS, SPARK STREAMING * Using popular external libraries, such as Hadoop and HBase * Integrating with cloud platforms: AWS, Azure, GCP * Connecting to data storage systems: HDFS, S3, Cassandra, etc. INTRODUCTION TO MACHINE LEARNING BASICS * Overview of machine learning * Supervised and unsupervised learning * Common algorithms and use cases INTRODUCTION TO SPARK MLLIB * Overview of Spark MLlib * MLlib's algorithms and utilities * Data preparation and feature extraction LINEAR REGRESSION AND CLASSIFICATION * Linear regression algorithm * Logistic regression for classification * Model evaluation and performance metrics CLUSTERING ALGORITHMS * Overview of clustering algorithms * K-means clustering * Model evaluation and performance metrics COLLABORATIVE FILTERING AND RECOMMENDATION SYSTEMS * Overview of recommendation systems * Collaborative filtering techniques * Implementing recommendations with Spark MLlib INTRODUCTION TO GRAPH PROCESSING * Overview of graph processing * Use cases and applications of graph processing * Graph representations and operations * Introduction to Spark GraphX * Overview of GraphX * Creating and transforming graphs * Graph algorithms in GraphX BIG DATA INNOVATION! USING GPT AND GENERATIVE AI TECHNOLOGIES WITH SPARK AND SCALA * Overview of generative AI technologies * Integrating GPT with Spark and Scala * Practical applications and use cases Bonus Topics / Time Permitting INTRODUCTION TO SPARK NLP * Overview of Spark NLP Preprocessing text data * Text classification and sentiment analysis PUTTING IT ALL TOGETHER * Work on a capstone project that integrates multiple aspects of the course, including data processing, machine learning, graph processing, and generative AI technologies.

Duration 3 Days 18 CPD hours This course is intended for This in an intermediate and beyond-level course is geared for experienced Python developers looking to delve into the exciting field of Natural Language Processing. It is ideally suited for roles such as data analysts, data scientists, machine learning engineers, or anyone working with text data and seeking to extract valuable insights from it. If you're in a role where you're tasked with analyzing customer sentiment, building chatbots, or dealing with large volumes of text data, this course will provide you with practical, hands on skills that you can apply right away. Overview This course combines engaging instructor-led presentations and useful demonstrations with valuable hands-on labs and engaging group activities. Throughout the course you'll: Master the fundamentals of Natural Language Processing (NLP) and understand how it can help in making sense of text data for valuable insights. Develop the ability to transform raw text into a structured format that machines can understand and analyze. Discover how to collect data from the web and navigate through semi-structured data, opening up a wealth of data sources for your projects. Learn how to implement sentiment analysis and topic modeling to extract meaning from text data and identify trends. Gain proficiency in applying machine learning and deep learning techniques to text data for tasks such as classification and prediction. Learn to analyze text sentiment, train emotion detectors, and interpret the results, providing a way to gauge public opinion or understand customer feedback. The Hands-on Natural Language Processing (NLP) Boot Camp is an immersive, three-day course that serves as your guide to building machines that can read and interpret human language. NLP is a unique interdisciplinary field, blending computational linguistics with artificial intelligence to help machines understand, interpret, and generate human language. In an increasingly data-driven world, NLP skills provide a competitive edge, enabling the development of sophisticated projects such as voice assistants, text analyzers, chatbots, and so much more. Our comprehensive curriculum covers a broad spectrum of NLP topics. Beginning with an introduction to NLP and feature extraction, the course moves to the hands-on development of text classifiers, exploration of web scraping and APIs, before delving into topic modeling, vector representations, text manipulation, and sentiment analysis. Half of your time is dedicated to hands-on labs, where you'll experience the practical application of your knowledge, from creating pipelines and text classifiers to web scraping and analyzing sentiment. These labs serve as a microcosm of real-world scenarios, equipping you with the skills to efficiently process and analyze text data. Time permitting, you?ll also explore modern tools like Python libraries, the OpenAI GPT-3 API, and TensorFlow, using them in a series of engaging exercises. By the end of the course, you'll have a well-rounded understanding of NLP, and will leave equipped with the practical skills and insights that you can immediately put to use, helping your organization gain valuable insights from text data, streamline business processes, and improve user interactions with automated text-based systems. You?ll be able to process and analyze text data effectively, implement advanced text representations, apply machine learning algorithms for text data, and build simple chatbots. LAUNCH INTO THE UNIVERSE OF NATURAL LANGUAGE PROCESSING * The journey begins: Unravel the layers of NLP * Navigating through the history of NLP * Merging paths: Text Analytics and NLP * Decoding language: Word Sense Disambiguation and Sentence Boundary Detection * First steps towards an NLP Project UNLEASHING THE POWER OF FEATURE EXTRACTION * Dive into the vast ocean of Data Types * Purification process: Cleaning Text Data * Excavating knowledge: Extracting features from Texts * Drawing connections: Finding Text Similarity through Feature Extraction ENGINEER YOUR TEXT CLASSIFIER * The new era of Machine Learning and Supervised Learning * Architecting a Text Classifier * Constructing efficient workflows: Building Pipelines for NLP Projects * Ensuring continuity: Saving and Loading Models MASTER THE ART OF WEB SCRAPING AND API USAGE * Stepping into the digital world: Introduction to Web Scraping and APIs * The great heist: Collecting Data by Scraping Web Pages * Navigating through the maze of Semi-Structured Data UNEARTH HIDDEN THEMES WITH TOPIC MODELING * Embark on the path of Topic Discovery * Decoding algorithms: Understanding Topic-Modeling Algorithms * Dialing the right numbers: Key Input Parameters for LSA Topic Modeling * Tackling complexity with Hierarchical Dirichlet Process (HDP) DELVING DEEP INTO VECTOR REPRESENTATIONS * The Geometry of Language: Introduction to Vectors in NLP TEXT MANIPULATION: GENERATION AND SUMMARIZATION * Playing the creator: Generating Text with Markov Chains * Distilling knowledge: Understanding Text Summarization and Key Input Parameters for TextRank * Peering into the future: Recent Developments in Text Generation and Summarization * Solving real-world problems: Addressing Challenges in Extractive Summarization RIDING THE WAVE OF SENTIMENT ANALYSIS * Unveiling emotions: Introduction to Sentiment Analysis Tools * Demystifying the Textblob library * Preparing the canvas: Understanding Data for Sentiment Analysis * Training your own emotion detectors: Building Sentiment Models OPTIONAL: CAPSTONE PROJECT * Apply the skills learned throughout the course. * Define the problem and gather the data. * Conduct exploratory data analysis for text data. * Carry out preprocessing and feature extraction. * Select and train a model. ? Evaluate the model and interpret the results. BONUS CHAPTER: GENERATIVE AI AND NLP * Introduction to Generative AI and its role in NLP. * Overview of Generative Pretrained Transformer (GPT) models. * Using GPT models for text generation and completion. * Applying GPT models for improving autocomplete features. * Use cases of GPT in question answering systems and chatbots. BONUS CHAPTER: ADVANCED APPLICATIONS OF NLP WITH GPT * Fine-tuning GPT models for specific NLP tasks. * Using GPT for sentiment analysis and text classification. * Role of GPT in Named Entity Recognition (NER). * Application of GPT in developing advanced chatbots. * Ethics and limitations of GPT and generative AI technologies.

Duration 3 Days 18 CPD hours This course is intended for Before taking this course delegates should already be familiar with basic analytics techniques, comfortable with basic data manipulation tools such as spreadsheets and databases and already familiar with at least one programming language Overview This course teaches delegates who are already familiar with analytics techniques and at least one programming language how to effectively use the programming language for three tasks: data manipulation and preparation, statistical analysis and advanced analytics (including predictive modelling and segmentation). Mastery of these techniques will allow delegates to immediately add value in their work place by extracting valuable insight from company data to allow better, data-driven decisions. Outcomes: After completing the course, delegates will be capable of writing production-ready R code to perform advanced analytics tasks enabling their organisations make better, data-driven decisions. Becoming a world class data analytics practitioner requires mastery of the most sophisticated data analytics tools. These programming languages are some of the most powerful and flexible tools in the data analytics toolkit. TOPIC 1 * Intro to our chosen language TOPIC 2 * Basic programming conventions TOPIC 3 * Data structures TOPIC 4 * Accessing data TOPIC 5 * Descriptive statistics TOPIC 6 * Data visualisation TOPIC 7 * Statistical analysis TOPIC 8 * Advanced data manipulation TOPIC 9 * Advanced analytics ? predictive modelling TOPIC 10 * Advanced analytics ? segmentation

Duration 2 Days 12 CPD hours This course is intended for This course is suited to marketeers, business analysts, and researchers who are interested in increasing their statistical knowledge. Overview After attending this course, delegates will understand how statistics can be used to provide valuable insight into their business, and be able to apply statistical methods to solve business problems. On returning to work delegates will immediately be able to make a difference to the way that their organisations make decisions. This course covers the statistical methods that analysts need to move from simple reporting on business problems to extracting insight to solve business problems. COURSE OUTLINE * The course will explore the following topics through a series of lectures and workshops: * Summary statistics for both continuous data and categorical data * Using and reporting confidence intervals * Using hypothesis tests to answer business questions * Using correlations to explore data relationships * Simple prediction models * Analysing categorical data ADDITIONAL COURSE DETAILS: Nexus Humans Data-driven Business Using Statistical Analysis training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Data-driven Business Using Statistical Analysis course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.