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 London 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}}

Foundational

Start here. You should take either Excel 2019 – Part 3 or Data Analysis and Visualization with Microsoft Excel.

Excel 2019 - Part 1
Excel 2019 - Part 2
Excel 2019 - Part 3 or
Data Analysis and Visualization with Microsoft Excel
Tableau® Desktop - Part 1
Tableau® Desktop - Part 2
20778 Analyzing Data with Power BI


Python

You should take “Python Programming - Advanced” before continuing to Job Role training.

Python Programming - Introduction
Python Programming - Advanced
Using Data Science Tools in Python® (v1.0)


Job Role

Database Management

Database Design - A Modern Approach
SQL Querying Fundamentals - Part 1
SQL Querying Fundamentals - Part 2

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 London Classrooms We can send our Instructor to your premises

Microsoft Power BI - Data Analysis Practitioner

In this course, you will explore and visualize data with Power BI.

Learning Objectives:

  • Analyze data with self-service BI.
  • Connect to data sources.
  • Perform advanced data modeling and shaping.
  • Visualize data with Power BI.
  • Enhance data analysis.
  • Model data with calculations.
  • Create interactive visualizations.

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

Introduction to DAX for Excel 2016 Users – Level 3

Learning Objectives

This course is built for Power BI for Excel Designers that will be responsible for taking basic PowerPivot data models turning them into power business intelligence solutions.

This course takes an in depth approach to the DAX language, teaching designers how to build models that extend the capabilities of source data for more in-depth, customized business intelligence solutions. Specific topics covered include proper understanding of DAX evaluation, controlling evaluation context, understanding relational functions, error handling within the data model, working with complex time intelligence calculations, creating advanced DAX dashboards and report elements using Slicers.


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

Course Starts Location Price
Introduction to DAX for Excel 2016 Users – Level 3 07-12-2020 London

Data Analysis using Excel 2016 – Level 1

Power BI Report Writers will learn everything they need to create highly effective PivotTable and Pivot Chart reports using data models created by more advanced Power BI Designers.

  • Day one topics covered include an overview of PowerPivot, creating effective and professional reports, creating data driven narratives, effectively applying different chart styles, using data hierarchies, and creating simple custom data calculations.
  • Day two topics include learning how to use the Power View, Power Map, and Power Query add-ins.
  • Power BI Report Writers will learn how to use
  • Power View to create highly effective interactive reports using data models created by more advanced Power BI Designers.
  • Students will also learn how to build 3D geospatial reports using Power Map as well as how to transform and query data sources using Power Query.

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

Course Starts Location Price
Data Analysis using Excel 2016 – Level 1 10-12-2020 London

Data Analysis and Visualization with Microsoft Excel

Learning Objectives

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 Live Online Can be run in our London Classrooms We can send our Instructor to your premises

Course Starts Location Price