252 Data Structure courses

Duration 3 Days 18 CPD hours This course is intended for This course is aimed at anyone who wants to harness the power of data analytics in their organization. Overview After completing this course delegates will be capable of writing effective R code to manipulate, analyse and visualise data to enable their organisations make better, data-driven decisions. This course teaches delegates with no prior programming or data analytics experience how to perform data manipulation, data analysis and data visualisation in R. COURSE OUTLINE * Becoming a world class data analytics practitioner requires mastery of the most sophisticated data analytics tools. The R programming language is one of the most powerful and flexible tools in the data analytics toolkit. This course teaches delegates with no prior programming or data analytics experience how to perform data manipulation, data analysis and data visualisation in R. 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. The course will explore the following topics through a series of interactive workshop sessions: * What is R? * Basic R programming conventions * Data structures in R * Accessing data in R * Descriptive statistics in R * Statistical analysis in R * Data manipulation in R * Data visualisation in R ADDITIONAL COURSE DETAILS: Nexus Humans Beginning Data Analytics With R 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 Beginning Data Analytics With R 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 2 Days 12 CPD hours This course is intended for This course is designed primarily for customer engineers and systems engineers in the following job roles: Automation architect Automation engineer Consulting systems engineer DevOps engineer Network administrator Network architect Network consulting engineer Network design engineer Network engineer Network operator Network reliability engineer Sales engineer Site reliability engineer Systems engineer Technical solutions architect Overview After taking this course, you should be able to: Articulate the role network automation and programmability play in the context of end-to-end network management and operations Define and differentiate between waterfall and agile software development methodologies Interpret and troubleshoot Python scripts with fundamental programming constructs built for network automation use cases Describe how DevOps principles, tools, and pipelines can be applied to network operations Understand the role of network automation development environments and associated technologies such as Python virtual environments, Vagrant, and Docker Understand and construct HTTP-based API calls to network devices Articulate the differences among and common use cases for XML, JSON, YAML, and protobuf Construct and interpret Python scripts using the Python requests module to automate devices that have HTTP-based APIs Understand the role YANG plays in network automation Understand that a number of tools exist to simplify working with YANG models Describe the functionality of RESTCONF and NETCONF and the differences between them Construct Ansible playbooks to configure network devices and retrieve operational state data from them Build Jinja2 templates and YAML data structures to generate desired state configurations The Introducing Automation for Cisco Solutions (CSAU) v1.1 course gives you a broad overview of network automation skills. Through a combination of lecture and hands-on labs, you will learn the fundamentals of automation such as working on model-driven programmability solutions with Representational State Transfer Configuration Protocol (RESTCONF) and Network Configuration Protocol (NETCONF) protocols. The course also covers data formats and types, including Extensible Markup Language (XML), JavaScript Object Notation (JSON), Yaml Ain?t Markup Language (YAML), and Yet Another Next Generation (YANG), and their value in network automation, along with DevOps tools such as Ansible and Git. COURSE OUTLINE * Examining Network Management and Operations * Exploring Software Development Methodologies * Using Python for Network Automation * Describing NetDevOps: DevOps for Networking * Managing Automation Development Environments * Introducing HTTP Network APIs * Reviewing Data Formats and Data Encoding * Using Python Requests to Automate HTTP-Based APIs * Exploring YANG * Using YANG Tools * Automating Model-Driven APIs with Python * Introducing Ansible for Network Automation * Templating Configurations with Jinja2

Duration 4 Days 24 CPD hours This course is intended for This course is the first in a series of two courses designed for programmers who are new to RPG IV. Basic programming experience is required. The student should have attended at least an introductory course to programming such as one of those available at technical colleges. The student is not taught the concepts of programming. Experienced programmers who are new to the Power System with IBM i should also attend this course. Examples of other programming languages are BASIC, COBOL, or RPG II. This course focuses entirely on the features of the RPG IV Version 7 compiler and the techniques that this compiler provides. Features of V7 are discussed. Previous techniques and the maintenance of programs that are written using legacy techniques, such as fixed format calculations, are not covered in the classroom. Some additional material and the bibliography will assist the new RPG IV programmer in the maintenance of legacy applications. Overview Write RPG IV version 7.1 programs to produce reportsWrite simple RPG IV version 7.1 inquiry programs that interact with displaysReview compilation listing, find and correct compilation errorsMaintain existing applications written in the RPG IV Version 7.1 languageUse many popular RPG IV built-in functions This course is a comprehensive exposure to the basic features and functions of RPG IV for Version 7. COURSE OUTLINE * RPG IV introduction * Coding specifications for RPG IV * Data representation and definition * Manipulating data in calculations * Using printer and display files in an RPG IV program * Structured programming, error handling, subprocedures, and subroutines * Using arrays, data structures, and data areas * Accessing the DB2 database using RPG IV * What's next? ADDITIONAL COURSE DETAILS: Nexus Humans AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i 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 AS06 IBM RPG IV Programming Fundamentals Workshop for IBM i 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 2 Days 12 CPD hours This course is intended for This is an Intermediate and beyond-level Tableau course geared for experienced Tableau users who wish to leverage Tableau's more advanced capabilities. Overview This skills-focused course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert facilitator, students will learn how to: Understand what data works best with Tableau Desktop and how to shape and clean it appropriately to get Learn how to maximize flexibility from Tableau Desktop. Learn how Tableau Prep folds into the analytic cycle, and when to prep data in Tableau Prep vs. Tableau Desktop. Understand the terminology used in Tableau Prep. Know how Tableau Prep approaches data sampling. Create and understand data prep flows that address common scenarios encountered in data preparation, as applied to common data use cases Know how to view data prepared in Tableau Prep using Tableau Desktop. Understand data exploration and validation in Tableau Prep and Tableau Desktop. Geared for experienced Tableau Users, Tableau Prep Building (Tableau Data Prep) for Experienced Users is a two-day hands-on course designed to provide you with the tools and knowledge of how to prepare and shape data in Tableau Prep. It?s best suited for people who have 3-6 months experience in Tableau Desktop and are somewhat familiar with writing calculations. Throughout the course, our instructors will take you from conceptual data preparation material to creating useful Tableau Prep flows that can be output to Tableau Desktop for analysisNOTE: The Tableau Training Series is independent-format training that can be tuned and adjusted to best meet your needs. Our materials are flexible, comprehensive, and are always instructed by a senior instructor with a deep understanding of Tableau and its most current features, benefits and functionality in a wide array of uses. This is not Official Tableau Training. COURSE OUTLINE * Introduction to the workspace * Introduction to the workflow * Data literacy concepts * Connecting to and configuring data * Exploring data * Cleaning data * Preferred data structures in Tableau * Shaping data * Combining data * Opening a data sample and creating an output file * Best practices for data preparation * Complex flows * Starting with a question * Hands-on data preparation ADDITIONAL COURSE DETAILS: Nexus Humans Tableau Prep Building (Tableau Data Prep) for Experienced Users (TTDTAB010) 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 Tableau Prep Building (Tableau Data Prep) for Experienced Users (TTDTAB010) 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 2.75 Days 16.5 CPD hours This course is intended for Complete beginners who have never programmed before to experienced developers coming from another programming language. Overview You will learn how to leverage the power of Python to solve tasks. You will build games and programs that use Python libraries. You will be able to use Python for your own work problems or personal projects. You will create a portfolio of Python based projects you can share. Learn to use Python professionally, learning both Python 2 and Python 3! Create games with Python, like Tic Tac Toe and Blackjack! Learn advanced Python features, like the collections module and how to work with timestamps! Learn to use Object Oriented Programming with classes! Understand complex topics, like decorators. Understand how to use both the Jupyter Notebook and create .py files Get an understanding of how to create GUIs in the Jupyter Notebook system! Build a complete understanding of Python from the ground up! Our Introduction to Python course is designed to take complete beginners or experienced developers up to speed on Python?s capabilities, setting up students for success in using Python for their specific field of expertise. Whether you have never programmed before, already know basic syntax, or want to learn about the advanced features of Python, this course is for you! In this course we will teach you Python 3. Learn how to use Python for real-world tasks, such as working with PDF Files, sending emails, reading Excel files, scraping websites for information, working with image files, and much more! This course will teach you Python in a practical manner and provides a full coding screencast and a corresponding code notebook to review the concepts and exercises conducted in class. Please note, this course is able to be offered in either 3 full day sessions or 5 partial day sessions. See the schedule below. This course includes 6-months access to the full course content in on-demand format to support post-class reference and review. * Command Line Basics * Python System Setup * Jupyter Notebooks * Python Data Types * Key Data Structures * Logic and Control Flow * Functions * Debugging * Modules * Object Oriented Programming * File I/O * Testing * Decorators * Generators * Automation of Tasks * Web Scraping * Graphical User Interfaces ADDITIONAL COURSE DETAILS: Nexus Humans Introduction to Python 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 Introduction to Python 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 4 Days 24 CPD hours This course is intended for The audience includes System administrators, IT administrators, Maintenance personnel, Procurement personnel, Inventory personnel, Asset managers and work managers. The audience also includes consultants that are looking to gain an understanding of Maximo Asset Management 7.6.x. Overview After completing this course, you should be able to perform the following tasks: Describe the Asset Management Lifecycle in Maximo Query and Retrieve Data Describe options available for various applications Describe and use the different Maximo applications and functions as they relate to business processes Enter core data elements and data structures This course helps clients to make informed business decisions with the design and planning of their implementation. Consultants gain a foundation on which to build their product knowledge and skill set. The foundation also helps in working with clients to obtain optimal value from the product. It provides the fundamental concepts and setup considerations of the various business areas that Maximo supports and, as a bonus section, the new Work Center functionality. This course consists of lectures, demonstrations, and labs that cover applications, processes and interrelationships within Maximo. IBM MAXIMO ASSET MANAGEMENT OVERVIEW * This unit provides a high-level overview of IBM Maximo Asset Management framework architecture and its key element and components. You learn about strategic asset management with IBM Maximo Asset Management to manage assets through their life cycle. You also discuss implementation considerations and system configuration as they pertain to integrations, reporting, and business processes. ITEM PLANNING AND SETUP * This unit focuses on the planning and setup of inventory item and asset configurations. You use the applications to set up inventory items and asset configurations in Maximo. ASSETS * This unit focuses on the creation of assets and how they are used in Maximo Asset Management. You will learn the applications that can create assets, associate assets to people and locations and learn how to move assets between locations. WORK MANAGEMENT * This unit focuses on learning to use Maximo for work management with the generation and processing of work orders to completion. This unit will include the new Work Centers that came available in Maximo 7.6.0.5. Work Centers are made available for Business Analyst, Supervisors and Workers complete the work order tasks. We will also look at the new Inspection Form tool. PURCHASING * This unit focuses on learning to use Maximo for procurement, starting with generating purchase requests, then processing them, and completing them. DEVELOPER AND SYSTEM ADMINISTRATION * Each lesson in this unit focuses on different aspects of entering records into the database. This unit is also an overview of the different applications and setup options that are available with IBM Maximo Asset Management. The focus is on using applications that are primarily used for building (setting up) the database. ADDITIONAL COURSE DETAILS: Nexus Humans U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x 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 U5TR572 - IBM Maximo Asset Management Fundamentals v7.6.x 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 2 Days 12 CPD hours This course is intended for Data Modelers Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data. INTRODUCTION TO IBM COGNOS DYNAMIC CUBES * Define and differentiate Dynamic Cubes * Dynamic Cubes characteristics * Examine Dynamic Cube requirements * Examine Dynamic Cube components * Examine high level architecture * IBM Cognos Dynamic Query * Review Dimensional Data Structures * Dynamic Cubes caching * CREATE & DESIGN A DYNAMIC CUBE * Explore the IBM Cognos Cube Designer * Review the cube development process * Examine the Automatic Cube Generation * Manual development overview * Create dimensions * Model the cube * Best practice for effective modeling DEPLOY & CONFIGURE A DYNAMIC CUBE * Deploy a cube * Explore the Estimate Hardware Requirements * Identify cube management tasks * Examine Query Service administration * Explore Dynamic Cube properties * Schedule cube actions * Use the DCAdmin comment line tool ADVANCED DYNAMIC CUBE MODELLING * Examine advanced modeling concepts * Explore modeling caveats * Calculated measures and members * Model Relative Time * Explore the Current Period property * Define period aggregation rules for measures ADVANCED FEATURES OF CUBE DESIGNER * Examine multilingual support * Examine ragged hierarchies and padding members * Define Parent-Child Dimensions * Refresh Metadata * Import Framework Manager packages * Filter measures and dimensions OPTIMIZE PERFORMANCE WITH AGGREGATES * Identify aggregates and aggregate tables * In-memory aggregates * Use Aggregate Advisor to identify aggregates * User defined in-memory aggregates * Optimize In-Memory Aggregates automatically * Aggregate Advisor recommendations * Monitor Dynamic Cube performance * Model aggregates (automatically vs manually) * Use Slicers to define aggregation partitions DEFINE SECURITY * Overview of Dynamic Cube security * Identify security filters * The Security process - Three steps * Examine security scope * Identify scope rules * Identify roles * Capabilities and access permissions * Cube security deep dive MODEL A VIRTUAL CUBE * Explore virtual cubes * Create the virtual cube * Explore virtual cube objects * Examine virtual measures and calculated members * Currency conversion using virtual cubes * Security on virtual cubes INTRODUCTION TO IBM COGNOS ANALYTICS * Define IBM Cognos Analytics * Redefined Business Intelligence * Self-service * Navigate to content in IBM Cognos Analytics * Interact with the user interface * Model data with IBM Cognos Analytics * IBM Cognos Analytics components * Create reports * Perform self-service with analysis and Dashboards * IBM Cognos Analytics architecture (high level) * IBM Cognos Analytics security * Package / data source relationship * Create Data modules * Upload files ADDITIONAL COURSE DETAILS: Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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 B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) 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 Analyst End User Implementer Manager Overview Create a Work Breakdown Structure Define roles and resources Assign roles Assign resources Analyze resources Optimize the project plan Understand data structures Create a project Add activities View calendars Create relationships Schedule the project Assign constraints Create reports Format schedule data Execute the project Enrolling in this course will help you understand P6 Professional's basic features and functionality so you can apply them to your organization's project management processes. You'll also learn how to manage projects on time and within budget UNDERSTANDING P6 DATA * Describing Enterprise and Project-Specific data * Logging In * Opening an Existing Project * Opening and Customizing Layouts ENTERPRISE PROJECT STRUCTURE * Describing Components of EPS CREATING A PROJECT * Create a project * Navigating in the Projects Window * Viewing Project Details CREATING A WORK BREAKDOWN STRUCTURE * Defining a Work Breakdown Structure * Creating the WBS Hierarchy ADDING ACTIVITIES * Describing an Activity and its Components * Describing Activity Types * Adding Activities * Adding a Notebook Topic * Adding Steps to an Activity * Assigning Activity Codes CREATING RELATIONSHIPS * Viewing a Network Logic Diagram * Relationship Types * Creating Relationships SCHEDULING * Performing a Forward and Backward Pass * Describing Float ASSIGNING CONSTRAINTS * Applying an Overall Deadline to a Project * Apply a Constraint to an Activity USING REFLECTION PROJECTS * Creating a Reflection Project * Merging Changes FORMATTING SCHEDULE DATA * Grouping Activities * Sorting * Filtering ROLES AND RESOURCES * Describing Roles and Resources * Viewing Dictionaries ASSIGNING ROLES * Assigning Roles to an Activity * Assign Rates on Roles ASSIGNING RESOURCES * Assigning Resources * Adjusting Budgeted Units/Time ANALYZING RESOURCES * Displaying the Resource Usage Profile OPTIMIZING THE PROJECT PLAN * Analyzing Schedule Dates * Shortening a Project Schedule * Analyzing Resource Availability BASELINING THE PROJECT PLAN * Creating a Baseline Plan * Display Baseline Bars on the Gantt Chart PROJECT EXECUTION AND CONTROL * Describing Methods for Updating the Schedule * Using Progress Spotlight * Statusing Activities * Rescheduling the Project REPORTING PERFORMANCE * Describing Reporting Methods * Running a Schedule Report * Creating a report with the Report Wizard ADDITIONAL COURSE DETAILS: Nexus Humans Primavera P6 Professional Fundamentals Rel 19 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 Primavera P6 Professional Fundamentals Rel 19 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 geared for Python-experienced attendees who wish to be equipped with the skills you need to use pandas to ensure the veracity of your data, visualize it for effective decision-making, and reliably reproduce analyses across multiple datasets. Overview Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Understand how data analysts and scientists gather and analyze data Perform data analysis and data wrangling using Python Combine, group, and aggregate data from multiple sources Create data visualizations with pandas, matplotlib, and seaborn Apply machine learning (ML) algorithms to identify patterns and make predictions Use Python data science libraries to analyze real-world datasets Use pandas to solve common data representation and analysis problems Build Python scripts, modules, and packages for reusable analysis code Perform efficient data analysis and manipulation tasks using pandas Apply pandas to different real-world domains with the help of step-by-step demonstrations Get accustomed to using pandas as an effective data exploration tool. Data analysis has become a necessary skill in a variety of domains where knowing how to work with data and extract insights can generate significant value. Geared for data team members with incoming Python scripting experience, Hands-On Data Analysis with Pandas will show you how to analyze your data, get started with machine learning, and work effectively with Python libraries often used for data science, such as pandas, NumPy, matplotlib, seaborn, and scikit-learn. Using real-world datasets, you will learn how to use the powerful pandas library to perform data wrangling to reshape, clean, and aggregate your data. Then, you will be able to conduct exploratory data analysis by calculating summary statistics and visualizing the data to find patterns. In the concluding lessons, you will explore some applications of anomaly detection, regression, clustering, and classification using scikit-learn to make predictions based on past data. Students will leave the course armed with the skills required to use pandas to ensure the veracity of their data, visualize it for effective decision-making, and reliably reproduce analyses across multiple datasets. INTRODUCTION TO DATA ANALYSIS * Fundamentals of data analysis * Statistical foundations * Setting up a virtual environment WORKING WITH PANDAS DATAFRAMES * Pandas data structures * Bringing data into a pandas DataFrame * Inspecting a DataFrame object * Grabbing subsets of the data * Adding and removing data DATA WRANGLING WITH PANDAS * What is data wrangling? * Collecting temperature data * Cleaning up the data * Restructuring the data * Handling duplicate, missing, or invalid data AGGREGATING PANDAS DATAFRAMES * Database-style operations on DataFrames * DataFrame operations * Aggregations with pandas and numpy * Time series VISUALIZING DATA WITH PANDAS AND MATPLOTLIB * An introduction to matplotlib * Plotting with pandas * The pandas.plotting subpackage PLOTTING WITH SEABORN AND CUSTOMIZATION TECHNIQUES * Utilizing seaborn for advanced plotting * Formatting * Customizing visualizations FINANCIAL ANALYSIS - BITCOIN AND THE STOCK MARKET * Building a Python package * Data extraction with pandas * Exploratory data analysis * Technical analysis of financial instruments * Modeling performance RULE-BASED ANOMALY DETECTION * Simulating login attempts * Exploratory data analysis * Rule-based anomaly detection GETTING STARTED WITH MACHINE LEARNING IN PYTHON * Learning the lingo * Exploratory data analysis * Preprocessing data * Clustering * Regression * Classification MAKING BETTER PREDICTIONS - OPTIMIZING MODELS * Hyperparameter tuning with grid search * Feature engineering * Ensemble methods * Inspecting classification prediction confidence * Addressing class imbalance * Regularization MACHINE LEARNING ANOMALY DETECTION * Exploring the data * Unsupervised methods * Supervised methods * Online learning THE ROAD AHEAD * Data resources * Practicing working with data * Python practice

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. INTRODUCTION TO DATA ON THE GOOGLE CLOUD PLATFORM * Highlight Analytics Challenges Faced by Data Analysts * Compare Big Data On-Premises vs on the Cloud * Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud * Navigate Google Cloud Platform Project Basics * Lab: Getting started with Google Cloud Platform BIG DATA TOOLS OVERVIEW * Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools * Demo: Analyze 10 Billion Records with Google BigQuery * Explore 9 Fundamental Google BigQuery Features * Compare GCP Tools for Analysts, Data Scientists, and Data Engineers * Lab: Exploring Datasets with Google BigQuery EXPLORING YOUR DATA WITH SQL * Compare Common Data Exploration Techniques * Learn How to Code High Quality Standard SQL * Explore Google BigQuery Public Datasets * Visualization Preview: Google Data Studio * Lab: Troubleshoot Common SQL Errors GOOGLE BIGQUERY PRICING * Walkthrough of a BigQuery Job * Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs * Optimize Queries for Cost * Lab: Calculate Google BigQuery Pricing CLEANING AND TRANSFORMING YOUR DATA * Examine the 5 Principles of Dataset Integrity * Characterize Dataset Shape and Skew * Clean and Transform Data using SQL * Clean and Transform Data using a new UI: Introducing Cloud Dataprep * Lab: Explore and Shape Data with Cloud Dataprep STORING AND EXPORTING DATA * Compare Permanent vs Temporary Tables * Save and Export Query Results * Performance Preview: Query Cache * Lab: Creating new Permanent Tables INGESTING NEW DATASETS INTO GOOGLE BIGQUERY * Query from External Data Sources * Avoid Data Ingesting Pitfalls * Ingest New Data into Permanent Tables * Discuss Streaming Inserts * Lab: Ingesting and Querying New Datasets DATA VISUALIZATION * Overview of Data Visualization Principles * Exploratory vs Explanatory Analysis Approaches * Demo: Google Data Studio UI * Connect Google Data Studio to Google BigQuery * Lab: Exploring a Dataset in Google Data Studio JOINING AND MERGING DATASETS * Merge Historical Data Tables with UNION * Introduce Table Wildcards for Easy Merges * Review Data Schemas: Linking Data Across Multiple Tables * Walkthrough JOIN Examples and Pitfalls * Lab: Join and Union Data from Multiple Tables ADVANCED FUNCTIONS AND CLAUSES * Review SQL Case Statements * Introduce Analytical Window Functions * Safeguard Data with One-Way Field Encryption * Discuss Effective Sub-query and CTE design * Compare SQL and Javascript UDFs * Lab: Deriving Insights with Advanced SQL Functions SCHEMA DESIGN AND NESTED DATA STRUCTURES * Compare Google BigQuery vs Traditional RDBMS Data Architecture * Normalization vs Denormalization: Performance Tradeoffs * Schema Review: The Good, The Bad, and The Ugly * Arrays and Nested Data in Google BigQuery * Lab: Querying Nested and Repeated Data MORE VISUALIZATION WITH GOOGLE DATA STUDIO * Create Case Statements and Calculated Fields * Avoid Performance Pitfalls with Cache considerations * Share Dashboards and Discuss Data Access considerations OPTIMIZING FOR PERFORMANCE * Avoid Google BigQuery Performance Pitfalls * Prevent Hotspots in your Data * Diagnose Performance Issues with the Query Explanation map * Lab: Optimizing and Troubleshooting Query Performance ADVANCED INSIGHTS * Introducing Cloud Datalab * Cloud Datalab Notebooks and Cells * Benefits of Cloud Datalab DATA ACCESS * Compare IAM and BigQuery Dataset Roles * Avoid Access Pitfalls * Review Members, Roles, Organizations, Account Administration, and Service Accounts