Data Analytics and Data Science Training

Trends-2018

For an organisation to become really analytics-driven a philosophy of data-driven decision-making must be ingrained at every level. In order for this to happen, analytics training must be provided at every level.

New Horizons Ireland has teamed up with several partners who are experts in Data Analytics to provide focused training courses in all aspects of analytics from the strategic managerial level, to advanced implementation techniques. Places can be taken on our regular scheduled courses or bespoke courses can be delivered in-house, and tailored to the very specific needs of your organisation.

Course list

{{value[0].Version}}

Analyzing Data with Excel

After completing this course, students will be able to:

  • Explore and extend a classic Excel dashboard.
  • Explore and extend an Excel data model.
  • Pre-format and import a .CSV file.
  • Import data from a SQL Server database
  • Import data from a report.
  • Create measures using advanced DAX functions.
  • Create data visualizations in Excel.
  • Create a Power BI dashboard with Excel.

3 day course Normally runs 14:00 to 22:00 Live Online Can be run in person.
Contact us
for details.

Course Starts Location Price
20779 Analyzing Data with Excel 18-08-2021 Dublin, Ireland
20779 Analyzing Data with Excel 23-08-2021 Dublin, Ireland
20779 Analyzing Data with Excel 08-09-2021 Dublin, Ireland
20779 Analyzing Data with Excel 27-09-2021 Dublin, Ireland

DA-100 Analyzing Data with Microsoft Power BI

Learning Objectives

After completing this course, students will be able to:

  • Ingest, clean, and transform data
  • Model data for performance and scalability
  • Design and create reports for data analysis
  • Apply and perform advanced report analytics
  • Manage and share report assets
  • Create paginated reports in Power BI

4 day course Live Online Can be run in our Dublin Classrooms We can send our Instructor to your premises

Course Starts Location Price
DA-100T00 - Analyzing Data with Microsoft Power BI 03-08-2021 Dublin, Ireland
DA-100T00 - Analyzing Data with Microsoft Power BI 03-08-2021 Dublin, Ireland
DA-100T00 - Analyzing Data with Microsoft Power BI 09-08-2021 Dublin, Ireland

Google Analytics - Foundation

Upon successful completion of this course, you will be able to implement Google Analytics and perform analysis using standard reports.

You will:

  • Implement Google Analytics
  • Configure Google Analytics
  • Configure goals, funnels, and filters
  • Configure monitoring and alerting
  • Analyze website traffic
  • Analyze behavior and conversion

1 day course Normally runs 14:00 to 22:00 GMT Live Online Can be run in person.
Contact us for details.

Course Starts Location Price
Google Analytics - Foundation 08-10-2021 Dublin, Ireland
Google Analytics - Foundation 10-12-2021 Dublin, Ireland
Google Analytics - Foundation 11-04-2022 Dublin, Ireland

Programming and Data Wrangling with VBA and Excel®

In this course, you will develop and deploy VBA modules to solve business problems. You will:

  • Identify general components of VBA and their appropriate use in solving business solutions.
  • Record VBA macros to automate repetitive tasks.
  • Use reference tools built into Excel to get help on VBA programming language and objects used in the Excel VBA environment.
  • Write VBA code to create a custom worksheet function.
  • Eliminate, avoid, or handle errors in VBA code, and optimize its performance.
  • Control how and when macros run.
  • Develop UserForm objects to create custom dialog boxes and windows.
  • Use VBA to read and write data from local files and cloud services.
  • Use VBA to clean and transform data.
  • Run programs and commands outside of Excel and share VBA projects with other users

3 day course Normally runs 14:00 to 22:00 GMT Live Online Can be run in person.
Contact us for details.

DP-100 Designing and Implementing a Data Science Solution on Azure

Gain the necessary knowledge about how to use Azure services to develop, train, and deploy, machine learning solutions. The course starts with an overview of Azure services that support data science. From there, it focuses on using Azure's premier data science service, Azure Machine Learning service, to automate the data science pipeline. This course is focused on Azure and does not teach the student how to do data science. It is assumed students already know that.

This role is responsible for solving the business problem that initiated the project. While the Data Engineer will prepare the data to be used for the models, the Data Scientist determines what data is needed for model training, creates model features from the data, determines what machine learning model to use, trains and evaluates the model, and often has involvement in model deployment. Often the data scientist needs to evaluate multiple models to determine which performs the best.


3 day course Normally runs 14:00 to 22:00 GMT Live Online Can be run in person.
Contact us for details.

Using Data Science Tools in Python®

In this course, you will use various Python tools to load, analyze, manipulate, and visualize business data.

You will:

  • Set up a Python data science environment.
  • Manage and analyze data with NumPy arrays.
  • Manipulate and modify data with NumPy arrays.
  • Manage and analyze data with pandas DataFrames.
  • Manipulate, modify, and visualize data with pandas DataFrames.
  • Visualize data with Matplotlib and Seaborn

2 day course Normally runs 14:00 to 22:00 GMT Live Online Can be run in person.
Contact us for details.

Course Starts Location Price
Using Data Science Tools in Python (v1.0) 05-08-2021 Dublin, Ireland
Using Data Science Tools in Python (v1.0) 03-11-2021 Dublin, Ireland
Using Data Science Tools in Python (v1.0) 08-03-2022 Dublin, Ireland