Course Description

Diploma in Data Analytics – Introduction: 26th of January

City Colleges



Course Dates

Next Course Commencing:
26th January 2021
Duration:
11 weeks, 1 evening per week from 6.30 to 9.30pm

Course Award

Award: City Colleges Diploma

Course Fee

Classroom:
€1,095 (€1,195 if paying in instalments)
Online:
€695 (€795 if paying in instalments)
International/Non-EU:
Call +353 1 4160034

Power Business Intelligence without Coding

Diploma in Data Analytics

Course Overview

“Excel is the only business software that ever worked!”
It is a fact that over the next two years 76% of companies are planning to increase their investment in data analytics. Data analytics is the science of analysing raw data in order to draw conclusions about that information and being able to analyse that data is a powerful skill that will help you make better informed decisions.
Learn Microsoft Excel in our Diploma in Data Analytic. Excel is one of the best tools for data analysis and indeed it’s built-in pivot tables are arguably the most popular analytic tool.

In this Diploma in Data Analytics you will learn how to:

  • Filter, Sort and Format Data
  • Apply the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel
  • Visually represent Data using a Pivot Table
  • Use Pivot Tables and Pivot Charts to Create a Dashboard
  • Use Calculated Fields within Pivot Tables to Calculate Profitability and find any Abnormalities
  • Use Formulas to Aggregate the Data as an Alternative to Pivot Tables for more Flexible Reports

*This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.

Requirements

A basic understanding of Microsoft Excel


College Name City Colleges
Course Category Computers & IT (Information Technology)
Course Location Dublin, Ireland
Location Postcode Dublin 2
Course Start Date 26th January 2021
Course Fee Classroom: €1,095 (€1,195 if paying in instalments) Online: €695 (€795 if paying in instalments)
Course Duration 11 weeks
For information about City Colleges, please visit our college page on www.nightcourses.com by clicking here.

Course Provider

City Colleges



Wicklow House, 84-88 South Great George’s Street, Dublin, Republic of Ireland

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to City Colleges.




Captcha code        I confirm I have read the Privacy Policy, Terms and Conditions & Cookie Information and agree to join the Nightcourses.com community.
 

Map

City Colleges
Wicklow House, 84-88 South Great George’s Street, Dublin, Republic of Ireland

Comments, Questions & Reviews

Submit A Comment, Question or Review About
Diploma in Data Analytics – Introduction: 26th of January
at City Colleges

Your email address will not be published. Required fields are marked *

Click to Rate

We'd love to send you the latest news and articles about evening classes, further learning and adult education by email. We'll always treat your personal details with the utmost care and will never sell them to other companies for marketing purposes.

Comments and Reviews Policy