Turning Data into information and information into Business Intelligence.

DIPLOMA IN DATA ANALYTICS – INTRODUCTION

  • Live & fully online training with real-time instructor-student interaction.
  • Archived for Review
  • Choose to study at your own pace or with our timetabled classes.
  • Choose to sign up with a deposit on our Instalment Plan options
ENROLLING NOW

Prices Starting At €895

(Instalment Price: €995)

Starts: 8th February 2023

11 weeks, 1 evening per week from 6.30 to 9.30pm GMT

Data analysis is evaluating datasets using statistical tools to reveal information so that you can make decisions. Data analytics essentially examines large datasets to uncover not easily recognisable patterns, correlations, and other insights.

We’ll start by looking at the principles of the Data Analysis process and the types of data you’ll be working with. Then we’ll examine the business aspects of analytics, the stakeholders and the Key Performance Indicators they use for decision-making.

We then take a hands-on approach to guiding you through the tools that Data Analysts use every day; Excel, Python and Tableau, and how to apply these to real-world datasets and examples.

Why Data Analysis?

  • Data Analyst base salary in Ireland is €47,500 (Lead data analysts can make up to €105K)
  • Skilled data analysts are some of the most sought-after professionals in the world

Data Analysis is a process of inspecting, cleaning, transforming and modelling data to discover useful information, suggesting conclusions and support-driven decision-making. The significant data analysis approaches are −

  • Data Mining
  • Statistical Analysis
  • Predictive Analytics
  • Text Analytics
  • Business Intelligence
  • Overview of Data Analysis, Data Mining, Statistics Analysis, Business Intelligence, Metrics, and KPIs
  • Data Sources, Relational Databases and SQL
  • Structuring data and data wrangling (cleaning data)
  • Statistics and Statistical Analysis
  • Working with Time Series, Cross-Sectional and Panel Data
  • Identifying Trends and Patterns with Regression and Correlation
  • Data Analysis Functions in Excel
  • Analysing Data in Excel with IF, VLOOKUP and Text Functions
  • Creating Pivot Tables, Pivot Charts and Advanced Visualisations in Excel
  • Using Python Pandas/NumPy for Analytics
  • Building and Publishing Dashboards with Tableau
  • Data Science and Machine Learning Algorithms

A basic understanding of Microsoft Excel and proficiency with basic maths

Students will be required to have Office software downloaded onto their devices for the duration of this course

See the price for monthly Microsoft subscription here: https://bit.ly/3n9stFT

A pass grade on the written assignment will be required for awarding of the Diploma.

Similarly, the Project must be handed in on the due date unless a sound reason for lateness is provided. In such instances, an extension may be awarded at the discretion of the lecturer.

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

Brian Rogers

Brian Rogers is a highly experienced IT Trainer, Full Stack Software Developer, and Systems Administrator with broad experience in the most widely used software development domains. He has advanced Database/SQL skills, Data Analysis, Business Intelligence systems and Cloud Management skills. Brian is proficient in Python, Java, .Net, Web, JavaScript and Mobile development (iOS and Android), PHP, Ruby and more.  He is very proactive in keeping his skills current, as seen from his extensive range of software vendor accreditations.

As an IT technical trainer with 37 years of experience, he provides a wide range of courses and mentoring for software developers and other IT professionals, from novice to experienced senior software professionals. His software development and training work complement and enhance each other. He has worked on development projects ranging from small one-person development projects to multi-million euro projects for businesses and government organisations.

Course Award

A City College’s Professional Diploma Course is a focused, practical programme designed and delivered by an industry practitioner, that consolidates, upskills or reskills learners in a professional area. They are stand-alone qualifications that indicate that you have been trained in a particular area or specific subject matter.

City College Diplomas are suitable for career minded learners wishing to advance their professional skills and prospects. They are widely accepted by employers and many students are sponsored to study here by their organisation.

Corporate Training

In addition to our scheduled Professional Diploma courses, City Colleges can provide bespoke training over 3 – 4 days, please contact paul.noone@citycolleges.ie for further details.

Learning Outcomes

In this Data Analytics Course, you will be introduced to the key statistical concepts essential for all Data Analysts.  You will study both descriptive and inferential Statistics.

You will learn how to apply statistical concepts through the hands-on use of various industry datasets and explore how your analysis of these can enable and support decisions making.

You will learn how to deploy and use various popular tools for analysing data, including Microsoft Excel, and Python Pandas. Finally, you will study how to present data by creating and publishing dashboards using Web-based tools such as Tableau.

Related Courses

Diploma in Artificial Intelligence

Diploma in Data Protection

Why City Colleges?

Study options that Suit your Schedule

Study where you want when you want. On Campus, Live Online, and On Demand.

Industry Expert-Led Courses

100+ courses, across subject areas in Business, IT, Psychology, Criminology, Law, Media, Arts & Science with over 16,000 graduates

World Class Teaching

City Colleges Lecturers are industry leaders in their chosen fields

Our commitment to student experience

Our Programme Teams engage, support, and guide our students throughout their programme to ensure that their learning experience is a positive one and prepares them to use their new skills in the workplace.

Cutting Edge Programme Content

Our students enjoy some of the most contemporary and industry-relevant course content, developed by our industry-based practitioners to close skills gaps in the global workforce

Premium courses at affordable prices

City Colleges is committed to ensuring that our education and training programmes are accessible and affordable.