Data Analytics and Business Intelligence 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

Data Analysis and Visualization with Microsoft Excel

In this course, you will analyze and visualize data using Microsoft Excel and associated tools. You will:

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas and functions.
  • Analyze data with PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis.
  • Get and transform data.
  • Model and analyze data with Power Pivot.
  • Present insights with reports.

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

Power BI: Dashboard in a Day

A one-day, hands-on workshop for business analysts that covers the full capabilities of Power BI

    At the end of the day, attendees will better understand how to:

  • Connect to, import, and transform data from a variety of sources.
  • Define business rules and KPIs.
  • Explore data with powerful visualization tools.
  • Build stunning reports.
  • Share dashboards with their team and business partners, and publish them to the web.

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

Course Starts Location Price

Microsoft Power BI: Data Analysis Practitioner

    In this course, you will analyze data with Microsoft Power BI. You will:

  • Analyze data with self-service BI.
  • Connect to data sources.
  • Perform data cleaning, profiling, and shaping.
  • Visualize data with Power BI.
  • Enhance data analysis by adding and customizing visual elements.
  • Model data with calculations.
  • Create interactive visualizations.

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

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.

Course Starts Location Price

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