Online or onsite, instructor-led live Data Analysis (Analysis of Data or Data Analytics) training courses demonstrate through discussion and hands-on practice the programmeming languages and methodologies used to perform Data Analysis.
Data Analysis training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. The UK onsite live Data Analysis trainings can be carried out locally on customer premises or in NobleProg corporate training centres.
NobleProg -- Your Local Training Provider
Testimonials
I gained a good overview of the process editors, business rules and BPMS tools landscape. I highly recommend the practical BPMN for Business Analysts course, even for experienced analysts, with its excellent process scenarios and modeling practice it will position you a cut above the rest!.
Anees Baig
Course: BPMN 2.0 for Business Analysts
Very informative and gave a nice overall summary of the course outline.
Matthew Steptoe
Course: Contemporary Development Principles and Practices
I enjoyed all of Day 1.
Peter Mahaffey
Course: Contemporary Development Principles and Practices
The pace and progression was perfect to really understand things quickly.
Stephen Brewell
Course: BPMN 2.0 for Business Analysts
I like the exercises done.
Nour Assaf
Course: Data Mining and Analysis
The hands-on exercise and the trainer capacity to explain complex topics in simple terms.
youssef chamoun
Course: Data Mining and Analysis
The information given was interesting and the best part was towards the end when we were provided with Data from Durex and worked on Data we are familiar with and perform operations to get results.
Jessica Chaar
Course: Data Mining and Analysis
* Enjoyable exercises. * Quickly moved into more advanced topics. * Trainer was friendly and easy to get on with. * Customised course for needs of team.
Matthew Lucas
Course: Python Programming
Fast paced - good interaction - clearly very knowledgeable trainer.
Course: Business Process Analysis with UML and BPMN
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Tamil was held up helping other people, I could crack on with the next parts.
Luke Pontin
Course: Data and Analytics - from the ground up
Learning how to use excel properly.
Torin Mitchell
Course: Data and Analytics - from the ground up
The way the trainer made complex subjects easy to understand.
Adam Drewry
Course: Data and Analytics - from the ground up
Detailed and comprehensive instruction given by experienced and clearly knowledgeable expert on the subject.
Justin Roche
Course: Data and Analytics - from the ground up
Tamil is very knowledgeable and nice person, I have learned from him a lot.
Aleksandra Szubert
Course: Data and Analytics - from the ground up
I liked the first session. Very intensive and quick.
Digital Jersey
Course: Data and Analytics - from the ground up
I mostly liked the patience of Tamil.
Laszlo Maros
Course: Data and Analytics - from the ground up
I really was benefit from the real life practical examples.
Wioleta (Vicky) Celinska-Drozd
Course: Data and Analytics - from the ground up
I preferred the exercise and learning about the nooks and crannies of Python.
Connor Brierley-Green
Course: Python Programming
Joey has an infectious enthusiasm about programmeming. And he was very good at adapting to our needs and interests on the fly.
Randy Enkin
Course: Python Programming
Many examples made me easy to understand.
Lingmin Cao
Course: Python Programming
I mostly liked the knowledge of the Trainer.
Sripal S
Course: Understanding Business Process Modeling with BPMN 2.0
I generally enjoyed the way of delivering speech.
Bhaskar naidu
Course: Understanding Business Process Modeling with BPMN 2.0
Fact that customization was taken seriously.
jurgen linsen
Course: Python Programming
I genuinely enjoyed the trainer's helping.
Urszula Kuza
Course: Tableau Advanced
I get answers on all my questions.
Natalia Gladii
Course: Data Analytics With R
I liked the exercises as it's the only way to learn, by repetition.
David Rushe
Course: Tableau Advanced
I enjoyed the exercises, The training room, Tea kitchen.
Alisher Khaydarov
Course: BPMN 2 Fundamentals and Workshop
The examples given really helped me to understand some concepts. The trainer made sure that we were following the whole training and didn't hesitate to come back to a previous point of there was any doubt. The trainer adapted the training to our needs, giving focus to the items we would like to have more details. Practical exercises were good too.
Amanda Moscardini - Campinas Valley
Course: Understanding Business Process Modeling with BPMN 2.0
Debra made sure to understand my questions and answered them precisely. The suggestions on how to design diagrams under certain conditions were really good. I would like to reinforce how professional and efficient Debra was with us.
Leandro Antonio
Course: Understanding Business Process Modeling with BPMN 2.0
I liked the helpful and very kind.
Natalia Machrowicz
Course: Python Programming
We did practical exercises (the scripts we wrote can be used in our everyday work). It made the course very interesting. I also liked the way the trainer shared his knowledge. He did it in a very accessible way.
Malwina Sawa
Course: Python Programming
I thought that the information was interesting.
Allison May
Course: Data Visualization
I really appreciated that Jeff utilised data and examples that were applicable to education data. He made it interesting and interactive.
Carol Wells Bazzichi
Course: Data Visualization
Fast paced - good interaction - clearly very knowledgeable trainer.
Course: Business Process Analysis with UML and BPMN
Data Analysis Course Outlines
Course Name
Duration
Overview
Course Name
Duration
Overview
21 hours
Overview
This course has been created for business analysts who want to use BPMN 2.0 extensively in their projects.
It focuses on practical aspects of all BPMN 2.0 specification as well as implementations of common patterns.
It is a series of short lectures followed by exercises: the delegates will have a problem described in English, and will have to create a proper diagram for each problem. After that, the diagrams will be discussed and assessed by the group and the trainer.
This course doesn't cover execution part of BPMN, it focuses on analysis and process design aspects of BPMN 2.0.
It focuses on practical aspects of all BPMN 2.0 specification as well as implementations of common patterns.
It is a series of short lectures followed by exercises: the delegates will have a problem described in English, and will have to create a proper diagram for each problem. After that, the diagrams will be discussed and assessed by the group and the trainer.
This course doesn't cover execution part of BPMN, it focuses on analysis and process design aspects of BPMN 2.0.
14 hours
Overview
Audience
Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel.
Course Objectives
This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.
This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation are and how to overcome them.
Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel.
Course Objectives
This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.
This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation are and how to overcome them.
28 hours
Overview
This course is designed for those wishing to learn the Python programming language. The emphasis is on the Python language, the core libraries, as well as on the selection of the best and most useful libraries developed by the Python community. Python drives businesses and is used by scientists all over the world – it is one of the most popular programming languages.
The course can be delivered using the latest Python version 3.x with practical exercises making use of the full power. This course can be delivered on any operating system (all flavours of UNIX, including Linux and Mac OS X, as well as Microsoft Windows).
The practical exercises constitute about 70% of the course time, and around 30% are demonstrations and presentations. Discussions and questions can be asked throughout the course.
Note: the training can be tailored to specific needs upon prior request ahead of the proposed course date.
The course can be delivered using the latest Python version 3.x with practical exercises making use of the full power. This course can be delivered on any operating system (all flavours of UNIX, including Linux and Mac OS X, as well as Microsoft Windows).
The practical exercises constitute about 70% of the course time, and around 30% are demonstrations and presentations. Discussions and questions can be asked throughout the course.
Note: the training can be tailored to specific needs upon prior request ahead of the proposed course date.
21 hours
Overview
[R](http://www.r-project.org/) is a very popular, open source environment for statistical computing, data analytics and graphics. This course introduces R programming language to students. It covers language fundamentals, libraries and advanced concepts. Advanced data analytics and graphing with real world data.
Audience
Developers / data analytics
Duration
3 days
Format
Lectures and Hands-on
Audience
Developers / data analytics
Duration
3 days
Format
Lectures and Hands-on
7 hours
Overview
This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive
14 hours
Overview
Pandas is a Python package that provides data structures for working with structured (tabular, multidimensional, potentially heterogeneous) and time series data.
21 hours
Overview
Knowledge discovery in databases (KDD) is the process of discovering useful knowledge from a collection of data. Real-life applications for this data mining technique include marketing, fraud detection, telecommunication and manufacturing.
In this instructor-led, live course, we introduce the processes involved in KDD and carry out a series of exercises to practice the implementation of those processes.
Audience
- Data analysts or anyone interested in learning how to interpret data to solve problems
Format of the Course
- After a theoretical discussion of KDD, the instructor will present real-life cases which call for the application of KDD to solve a problem. Participants will prepare, select and cleanse sample data sets and use their prior knowledge about the data to propose solutions based on the results of their observations.
In this instructor-led, live course, we introduce the processes involved in KDD and carry out a series of exercises to practice the implementation of those processes.
Audience
- Data analysts or anyone interested in learning how to interpret data to solve problems
Format of the Course
- After a theoretical discussion of KDD, the instructor will present real-life cases which call for the application of KDD to solve a problem. Participants will prepare, select and cleanse sample data sets and use their prior knowledge about the data to propose solutions based on the results of their observations.
21 hours
Overview
It is estimated that unstructured data accounts for more than 90 percent of all data, much of it in the form of text. Blog posts, tweets, social media, and other digital publications continuously add to this growing body of data.
This instructor-led, live course centers around extracting insights and meaning from this data. Utilizing the R Language and Natural Language Processing (NLP) libraries, we combine concepts and techniques from computer science, artificial intelligence, and computational linguistics to algorithmically understand the meaning behind text data. Data samples are available in various languages per customer requirements.
By the end of this training participants will be able to prepare data sets (large and small) from disparate sources, then apply the right algorithms to analyze and report on its significance.
Format of the Course
- Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
This instructor-led, live course centers around extracting insights and meaning from this data. Utilizing the R Language and Natural Language Processing (NLP) libraries, we combine concepts and techniques from computer science, artificial intelligence, and computational linguistics to algorithmically understand the meaning behind text data. Data samples are available in various languages per customer requirements.
By the end of this training participants will be able to prepare data sets (large and small) from disparate sources, then apply the right algorithms to analyze and report on its significance.
Format of the Course
- Part lecture, part discussion, heavy hands-on practice, occasional tests to gauge understanding
35 hours
Overview
Participants who complete this instructor-led, live training in the UK will gain a practical, real-world understanding of Big Data and its related technologies, methodologies and tools.
Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class.
The course starts with an introduction to elemental concepts of Big Data, then progresses into the programming languages and methodologies used to perform Data Analysis. Finally, we discuss the tools and infrastructure that enable Big Data storage, Distributed Processing, and Scalability.
Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class.
The course starts with an introduction to elemental concepts of Big Data, then progresses into the programming languages and methodologies used to perform Data Analysis. Finally, we discuss the tools and infrastructure that enable Big Data storage, Distributed Processing, and Scalability.
14 hours
Overview
This instructor-led, live training in the UK is aimed at software developers who wish to build search and analytics solutions using Elasticsearch.
The training starts with a discussion of the Elasticsearch architecture, including its distributed model and search API. This is followed by an explanation of Elasticsearch's functionality and how to best integrate it into an existing application.
Hands-on exercises make up an important part of the training, and give participants a chance to put into practice their knowledge while receiving feedback on their implementation and progress.
The training starts with a discussion of the Elasticsearch architecture, including its distributed model and search API. This is followed by an explanation of Elasticsearch's functionality and how to best integrate it into an existing application.
Hands-on exercises make up an important part of the training, and give participants a chance to put into practice their knowledge while receiving feedback on their implementation and progress.
35 hours
Overview
In the first part of this training, we cover the fundamentals of MATLAB and its function as both a language and a platform. Included in this discussion is an introduction to MATLAB syntax, arrays and matrices, data visualization, script development, and object-oriented principles.
In the second part, we demonstrate how to use MATLAB for data mining, machine learning and predictive analytics. To provide participants with a clear and practical perspective of MATLAB's approach and power, we draw comparisons between using MATLAB and using other tools such as spreadsheets, C, C++, and Visual Basic.
In the third part of the training, participants learn how to streamline their work by automating their data processing and report generation.
Throughout the course, participants will put into practice the ideas learned through hands-on exercises in a lab environment. By the end of the training, participants will have a thorough grasp of MATLAB's capabilities and will be able to employ it for solving real-world data science problems as well as for streamlining their work through automation.
Assessments will be conducted throughout the course to gauge progress.
Format of the Course
- Course includes theoretical and practical exercises, including case discussions, sample code inspection, and hands-on implementation.
Note
- Practice sessions will be based on pre-arranged sample data report templates. If you have specific requirements, please contact us to arrange.
In the second part, we demonstrate how to use MATLAB for data mining, machine learning and predictive analytics. To provide participants with a clear and practical perspective of MATLAB's approach and power, we draw comparisons between using MATLAB and using other tools such as spreadsheets, C, C++, and Visual Basic.
In the third part of the training, participants learn how to streamline their work by automating their data processing and report generation.
Throughout the course, participants will put into practice the ideas learned through hands-on exercises in a lab environment. By the end of the training, participants will have a thorough grasp of MATLAB's capabilities and will be able to employ it for solving real-world data science problems as well as for streamlining their work through automation.
Assessments will be conducted throughout the course to gauge progress.
Format of the Course
- Course includes theoretical and practical exercises, including case discussions, sample code inspection, and hands-on implementation.
Note
- Practice sessions will be based on pre-arranged sample data report templates. If you have specific requirements, please contact us to arrange.
28 hours
Overview
In this instructor-led, live training in the UK, participants will learn advanced Python programming techniques, including how to apply this versatile language to solve problems in areas such as distributed applications, data analysis and visualization, UI programming and maintenance scripting.
42 hours
Overview
Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions:
What has happened?
- processing and analyzing data
- producing informative data visualizations
What will happen?
- forecasting future performance
- evaluating forecasts
What should happen?
- turning data into evidence-based business decisions
- optimizing processes
The course itself can be delivered either as a 6 day classroom course or [remotely](https://www.nobleprog.co.uk/instructor-led-online-training-courses) over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.
What has happened?
- processing and analyzing data
- producing informative data visualizations
What will happen?
- forecasting future performance
- evaluating forecasts
What should happen?
- turning data into evidence-based business decisions
- optimizing processes
The course itself can be delivered either as a 6 day classroom course or [remotely](https://www.nobleprog.co.uk/instructor-led-online-training-courses) over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.
21 hours
Overview
The aim of this course is to provide a clear understanding of the use of SQL for different
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
databases (Oracle, SQL Server, MS Access...). Understanding of analytic functions and the
way how to join different tables in a database will help delegates to move data analysis
operations to the database side, instead of doing this in MS Excel application. This can also
help in creating any IT system, which uses any relational database.
14 hours
Overview
Apache Kylin is an extreme, distributed analytics engine for big data.
In this instructor-led live training, participants will learn how to use Apache Kylin to set up a real-time data warehouse.
By the end of this training, participants will be able to:
- Consume real-time streaming data using Kylin
- Utilize Apache Kylin's powerful features, rich SQL interface, spark cubing and subsecond query latency
Note
- We use the latest version of Kylin (as of this writing, Apache Kylin v2.0)
Audience
- Big data engineers
- Big Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led live training, participants will learn how to use Apache Kylin to set up a real-time data warehouse.
By the end of this training, participants will be able to:
- Consume real-time streaming data using Kylin
- Utilize Apache Kylin's powerful features, rich SQL interface, spark cubing and subsecond query latency
Note
- We use the latest version of Kylin (as of this writing, Apache Kylin v2.0)
Audience
- Big data engineers
- Big Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
Datameer is a business intelligence and analytics platform built on Hadoop. It allows end-users to access, explore and correlate large-scale, structured, semi-structured and unstructured data in an easy-to-use fashion.
In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources.
By the end of this training, participants will be able to:
- Create, curate, and interactively explore an enterprise data lake
- Access business intelligence data warehouses, transactional databases and other analytic stores
- Use a spreadsheet user-interface to design end-to-end data processing pipelines
- Access pre-built functions to explore complex data relationships
- Use drag-and-drop wizards to visualize data and create dashboards
- Use tables, charts, graphs, and maps to analyze query results
Audience
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to use Datameer to overcome Hadoop's steep learning curve as they step through the setup and analysis of a series of big data sources.
By the end of this training, participants will be able to:
- Create, curate, and interactively explore an enterprise data lake
- Access business intelligence data warehouses, transactional databases and other analytic stores
- Use a spreadsheet user-interface to design end-to-end data processing pipelines
- Access pre-built functions to explore complex data relationships
- Use drag-and-drop wizards to visualize data and create dashboards
- Use tables, charts, graphs, and maps to analyze query results
Audience
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
Embedding Projector is an open-source web application for visualizing the data used to train machine learning systems. Created by Google, it is part of TensorFlow.
This instructor-led, live training introduces the concepts behind Embedding Projector and walks participants through the setup of a demo project.
By the end of this training, participants will be able to:
- Explore how data is being interpreted by machine learning models
- Navigate through 3D and 2D views of data to understand how a machine learning algorithm interprets it
- Understand the concepts behind Embeddings and their role in representing mathematical vectors for images, words and numerals.
- Explore the properties of a specific embedding to understand the behavior of a model
- Apply Embedding Project to real-world use cases such building a song recommendation system for music lovers
Audience
- Developers
- Data scientists
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
This instructor-led, live training introduces the concepts behind Embedding Projector and walks participants through the setup of a demo project.
By the end of this training, participants will be able to:
- Explore how data is being interpreted by machine learning models
- Navigate through 3D and 2D views of data to understand how a machine learning algorithm interprets it
- Understand the concepts behind Embeddings and their role in representing mathematical vectors for images, words and numerals.
- Explore the properties of a specific embedding to understand the behavior of a model
- Apply Embedding Project to real-world use cases such building a song recommendation system for music lovers
Audience
- Developers
- Data scientists
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
21 hours
Overview
kdb+ is an in-memory, column-oriented database and q is its built-in, interpreted vector-based language. In kdb+, tables are columns of vectors and q is used to perform operations on the table data as if it was a list. kdb+ and q are commonly used in high frequency trading and are popular with the major financial institutions, including Goldman Sachs, Morgan Stanley, Merrill Lynch, JP Morgan, etc.
In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q.
By the end of this training, participants will be able to:
- Understand the difference between a row-oriented database and a column-oriented database
- Select data, write scripts and create functions to carry out advanced analytics
- Analyze time series data such as stock and commodity exchange data
- Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed
- Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages
- Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring
Audience
- Developers
- Database engineers
- Data scientists
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to create a time series data application using kdb+ and q.
By the end of this training, participants will be able to:
- Understand the difference between a row-oriented database and a column-oriented database
- Select data, write scripts and create functions to carry out advanced analytics
- Analyze time series data such as stock and commodity exchange data
- Use kdb+'s in-memory capabilities to store, analyze, process and retrieve large data sets at high speed
- Think of functions and data at a higher level than the standard function(arguments) approach common in non-vector languages
- Explore other time-sensitive applications for kdb+, including energy trading, telecommunications, sensor data, log data, and machine and network usage monitoring
Audience
- Developers
- Database engineers
- Data scientists
- Data analysts
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
21 hours
Overview
Data science is the application of statistical analysis, machine learning, data visualization and programming for the purpose of understanding and interpreting real-world data. F# is a well suited programming language for data science as it combines efficient execution, REPL-scripting, powerful libraries and scalable data integration.
In this instructor-led, live training, participants will learn how to use F# to solve a series of real-world data science problems.
By the end of this training, participants will be able to:
- Use F#'s integrated data science packages
- Use F# to interoperate with other languages and platforms, including Excel, R, Matlab, and Python
- Use the Deedle package to solve time series problems
- Carry out advanced analysis with minimal lines of production-quality code
- Understand how functional programming is a natural fit for scientific and big data computations
- Access and visualize data with F#
- Apply F# for machine learning
Explore solutions for problems in domains such as business intelligence and social gaming
Audience
- Developers
- Data scientists
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn how to use F# to solve a series of real-world data science problems.
By the end of this training, participants will be able to:
- Use F#'s integrated data science packages
- Use F# to interoperate with other languages and platforms, including Excel, R, Matlab, and Python
- Use the Deedle package to solve time series problems
- Carry out advanced analysis with minimal lines of production-quality code
- Understand how functional programming is a natural fit for scientific and big data computations
- Access and visualize data with F#
- Apply F# for machine learning
Explore solutions for problems in domains such as business intelligence and social gaming
Audience
- Developers
- Data scientists
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
28 hours
Overview
R is a popular programming language in the financial industry. It is used in financial applications ranging from core trading programs to risk management systems.
In this instructor-led, live training, participants will learn how to use R to develop practical applications for solving a number of specific finance related problems.
By the end of this training, participants will be able to:
- Understand the fundamentals of the R programming language
- Select and utilize R packages and techniques to organize, visualize, and analyze financial data from various sources (CSV, Excel, databases, web, etc.)
- Build applications that solve problems related to asset allocation, risk analysis, investment performance and more
- Troubleshoot, integrate deploy and optimize an R application
Audience
- Developers
- Analysts
- Quants
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- This training aims to provide solutions for some of the principle problems faced by finance professionals. However, if you have a particular topic, tool or technique that you wish to append or elaborate further on, please please contact us to arrange.
In this instructor-led, live training, participants will learn how to use R to develop practical applications for solving a number of specific finance related problems.
By the end of this training, participants will be able to:
- Understand the fundamentals of the R programming language
- Select and utilize R packages and techniques to organize, visualize, and analyze financial data from various sources (CSV, Excel, databases, web, etc.)
- Build applications that solve problems related to asset allocation, risk analysis, investment performance and more
- Troubleshoot, integrate deploy and optimize an R application
Audience
- Developers
- Analysts
- Quants
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- This training aims to provide solutions for some of the principle problems faced by finance professionals. However, if you have a particular topic, tool or technique that you wish to append or elaborate further on, please please contact us to arrange.
21 hours
Overview
Apache Drill is a schema-free, distributed, in-memory columnar SQL query engine for Hadoop, NoSQL and other Cloud and file storage systems. The power of Apache Drill lies in its ability to join data from multiple data stores using a single query. Apache Drill supports numerous NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. Apache Drill is the open source version of Google's Dremel system which is available as an infrastructure service called Google BigQuery.
In this instructor-led, live training, participants will learn the fundamentals of Apache Drill, then leverage the power and convenience of SQL to interactively query big data across multiple data sources, without writing code. Participants will also learn how to optimize their Drill queries for distributed SQL execution.
By the end of this training, participants will be able to:
- Perform "self-service" exploration on structured and semi-structured data on Hadoop
- Query known as well as unknown data using SQL queries
- Understand how Apache Drills receives and executes queries
- Write SQL queries to analyze different types of data, including structured data in Hive, semi-structured data in HBase or MapR-DB tables, and data saved in files such as Parquet and JSON.
- Use Apache Drill to perform on-the-fly schema discovery, bypassing the need for complex ETL and schema operations
- Integrate Apache Drill with BI (Business Intelligence) tools such as Tableau, Qlikview, MicroStrategy and Excel
Audience
- Data analysts
- Data scientists
- SQL programmers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
In this instructor-led, live training, participants will learn the fundamentals of Apache Drill, then leverage the power and convenience of SQL to interactively query big data across multiple data sources, without writing code. Participants will also learn how to optimize their Drill queries for distributed SQL execution.
By the end of this training, participants will be able to:
- Perform "self-service" exploration on structured and semi-structured data on Hadoop
- Query known as well as unknown data using SQL queries
- Understand how Apache Drills receives and executes queries
- Write SQL queries to analyze different types of data, including structured data in Hive, semi-structured data in HBase or MapR-DB tables, and data saved in files such as Parquet and JSON.
- Use Apache Drill to perform on-the-fly schema discovery, bypassing the need for complex ETL and schema operations
- Integrate Apache Drill with BI (Business Intelligence) tools such as Tableau, Qlikview, MicroStrategy and Excel
Audience
- Data analysts
- Data scientists
- SQL programmers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
14 hours
Overview
AI is a collection of technologies for building intelligent systems capable of understanding data and the activities surrounding the data to make "intelligent decisions". For Telecom providers, building applications and services that make use of AI could open the door for improved operations and servicing in areas such as maintenance and network optimization.
In this course we examine the various technologies that make up AI and the skill sets required to put them to use. Throughout the course, we examine AI's specific applications within the Telecom industry.
Audience
- Network engineers
- Network operations personnel
- Telecom technical managers
Format of the course
- Part lecture, part discussion, hands-on exercises
In this course we examine the various technologies that make up AI and the skill sets required to put them to use. Throughout the course, we examine AI's specific applications within the Telecom industry.
Audience
- Network engineers
- Network operations personnel
- Telecom technical managers
Format of the course
- Part lecture, part discussion, hands-on exercises
21 hours
Overview
Dremio is an open-source "self-service data platform" that accelerates the querying of different types of data sources. Dremio integrates with relational databases, Apache Hadoop, MongoDB, Amazon S3, ElasticSearch, and other data sources. It supports SQL and provides a web UI for building queries.
In this instructor-led, live training, participants will learn how to install, configure and use Dremio as a unifying layer for data analysis tools and the underlying data repositories.
By the end of this training, participants will be able to:
- Install and configure Dremio
- Execute queries against multiple data sources, regardless of location, size, or structure
- Integrate Dremio with BI and data sources such as Tableau and Elasticsearch
Audience
- Data scientists
- Business analysts
- Data engineers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Notes
- To request a customized training for this course, please contact us to arrange.
In this instructor-led, live training, participants will learn how to install, configure and use Dremio as a unifying layer for data analysis tools and the underlying data repositories.
By the end of this training, participants will be able to:
- Install and configure Dremio
- Execute queries against multiple data sources, regardless of location, size, or structure
- Integrate Dremio with BI and data sources such as Tableau and Elasticsearch
Audience
- Data scientists
- Business analysts
- Data engineers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Notes
- To request a customized training for this course, please contact us to arrange.
14 hours
Overview
In this instructor-led, live training in the UK (onsite or remote), participants will learn how to combine the capabilities of Python and Excel.
By the end of this training, participants will be able to:
- Install and configure packages for integrating Python and Excel.
- Read, write, and manipulate Excel files using Python.
- Call Python functions from Excel.
By the end of this training, participants will be able to:
- Install and configure packages for integrating Python and Excel.
- Read, write, and manipulate Excel files using Python.
- Call Python functions from Excel.
14 hours
Overview
A business' marketing strategy is one of its most essential tools to ensure success. The rise in technology and advances in data gathering and analysis has led to a continuous transformation of marketing. Data analysis is now considered to be a crucial skill for marketers to learn. Likewise, applying data science to marketing principles is also important in helping data science professionals maximize their contributions.
In this instructor-led, live training, participants will learn how to gain valuable insights from large data sets and how to use these for marketing strategies.
By the end of this training, participants will be able to:
- Install and configure tools for data-driven marketing tools (Tableau, Google Analytics, Zarget, etc)
- Measure, test, and optimize the performance of their marketing strategies using data
- Use data to segment their customers and prospects
- Use predictive modeling to improve response rates
- Implement step-by-step data analytics to drive better marketing decisions
Audience
- Marketers
- Data scientists
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
In this instructor-led, live training, participants will learn how to gain valuable insights from large data sets and how to use these for marketing strategies.
By the end of this training, participants will be able to:
- Install and configure tools for data-driven marketing tools (Tableau, Google Analytics, Zarget, etc)
- Measure, test, and optimize the performance of their marketing strategies using data
- Use data to segment their customers and prospects
- Use predictive modeling to improve response rates
- Implement step-by-step data analytics to drive better marketing decisions
Audience
- Marketers
- Data scientists
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
35 hours
Overview
Participants who complete this training will gain a practical, real-world understanding of Data Science and its related technologies, methodologies and tools.
Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class.
The course starts with an introduction to elemental concepts of Data Science, then progresses into the tools and methodologies used in Data Science.
Audience
- Developers
- Technical analysts
- IT consultants
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
Participants will have the opportunity to put this knowledge into practice through hands-on exercises. Group interaction and instructor feedback make up an important component of the class.
The course starts with an introduction to elemental concepts of Data Science, then progresses into the tools and methodologies used in Data Science.
Audience
- Developers
- Technical analysts
- IT consultants
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
14 hours
Overview
Apache Arrow is an open-source in-memory data processing framework. It is often used together with other data science tools for accessing disparate data stores for analysis. It integrates well with other technologies such as GPU databases, machine learning libraries and tools, execution engines, and data visualization frameworks.
In this onsite instructor-led, live training, participants will learn how to integrate Apache Arrow with various Data Science frameworks to access data from disparate data sources.
By the end of this training, participants will be able to:
- Install and configure Apache Arrow in a distributed clustered environment
- Use Apache Arrow to access data from disparate data sources
- Use Apache Arrow to bypass the need for constructing and maintaining complex ETL pipelines
- Analyze data across disparate data sources without having to consolidate it into a centralized repository
Audience
- Data scientists
- Data engineers
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
In this onsite instructor-led, live training, participants will learn how to integrate Apache Arrow with various Data Science frameworks to access data from disparate data sources.
By the end of this training, participants will be able to:
- Install and configure Apache Arrow in a distributed clustered environment
- Use Apache Arrow to access data from disparate data sources
- Use Apache Arrow to bypass the need for constructing and maintaining complex ETL pipelines
- Analyze data across disparate data sources without having to consolidate it into a centralized repository
Audience
- Data scientists
- Data engineers
Format of the Course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
14 hours
Overview
About the Course:
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both Power BI on Line and Power BI desktop.
Audience:
This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.
At Course Completion
Upon completing this course, students will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned.
- Power BI
- Power BI Desktop
- Working with CSV, TXT, and Excel Worksheets
- Connecting to Databases
- Merging, Grouping, Summarizing, and Calculating Data
- Reporting
- Power BI Online
Microsoft Power BI transforms your company data into rich visuals that facilitate new ways of thinking about and organizing your data, so that you can focus on what is important to achieving your goals. This course covers both Power BI on Line and Power BI desktop.
Audience:
This course is intended for Business Managers, Report Developers, Analysts, Project Managers and Team Leads.
At Course Completion
Upon completing this course, students will have a basic understanding of the topics below, as well as an ability to utilize and implement the concepts learned.
- Power BI
- Power BI Desktop
- Working with CSV, TXT, and Excel Worksheets
- Connecting to Databases
- Merging, Grouping, Summarizing, and Calculating Data
- Reporting
- Power BI Online
7 hours
Overview
This instructor-led, live training in the UK (online or onsite) is aimed at persons who wish to use graphical and numerical techniques to better understand the structure of a dataset before commencing more formal analysis.
By the end of this training, participants will be able to:
- Identify variables that that indicate connections within the data.
- Identify unusual patterns in data.
- Generate visually appealing and easy to read graphics that provide insight into the data.
- Use exploratory analysis to pave the way for more complex statistical modeling.
By the end of this training, participants will be able to:
- Identify variables that that indicate connections within the data.
- Identify unusual patterns in data.
- Generate visually appealing and easy to read graphics that provide insight into the data.
- Use exploratory analysis to pave the way for more complex statistical modeling.
14 hours
Overview
This course is designed for those wishing to learn the Python programming language. The emphasis is on the Python language, the core libraries, as well as on the selection of the best and most useful libraries developed by the Python community. Python drives businesses and is used by scientists all over the world – it is one of the most popular programming languages.
Upcoming Data Analysis Courses
07-09-2021 09:30
Portsmouth - North Harbour
14 hours
20-09-2021 09:30
Portsmouth - North Harbour
14 hours
13-10-2021 09:30
Portsmouth - North Harbour
7 hours
13-10-2021 09:30
Portsmouth - North Harbour
21 hours
19-10-2021 09:30
Portsmouth - North Harbour
21 hours
Other regions
Other countries
Consulting
Online Data Analysis courses, Weekend Data Analysis courses, Evening Data Analysis training, Data Analysis boot camp, Data Analysis instructor-led, Weekend Data Analysis training, Evening Data Analysis courses, Data Analysis coaching, Data Analysis instructor, Data Analysis trainer, Data Analysis training courses, Data Analysis classes, Data Analysis on-site, Data Analysis private courses, Data Analysis one on one training
.png "university college london (ucl)"){kind=small}
.jpg "defence science and technology laboratory (dstl)")
.png "universities and colleges admissions service (ucas)"){kind=small}
.png "national health service (nhs)"){kind=small}
.png "chartered institute of marketing (cim)"){kind=small}
