Basket Login

Data Analytics

City Colleges’ Professional Diploma
  • Turning Data into information and information into Business Intelligence
  • Live & fully online training with real-time instructor-student interaction
  • Choose to study at your own pace or with our timetabled classes
  • 11 weeks, 1 evening per week from 6.30 to 9.30pm GMT
  • Choose to sign up with a deposit on our Instalment Plan options
  • Starting September 2024

Enrolling Now

Price from €795
Call Enquire Request Callback Enrol

Live Online

Live online training with real-time instructor-student interaction.
Price from €895
  • Live & fully online
  • Archived for review
  • 11 Weeks, 1 evening per week
  • Starting September 2024
  • 6.30 to 9.30pm
Pay in full & get €100 off listed price

On Demand

A flexible online approach developed to allow you to learn at your own pace.
Price from €795
  • Fully online
  • Pre Recorded
  • Start Anytime
  • Suit your own Schedule
  • Access for 10 weeks
  • 12 -13 weeks to send in the assignment
Loading…

“Turning Data into information and information into Business Intelligence.”

Professional Diploma in Data Analytics is evaluating datasets using statistical tools to reveal useful and understandable information. Data analytics essentially examines datasets to uncover 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, SQL/Databases, Python and Tableau, and how to apply these to real-world datasets and examples.

Why Data Analysis?

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

  • Statistical Analysis
  • Descriptive, Diagnostic, Predictive and Prescriptive Analytics
  • Business Intelligence
  • Using data Analysis tools including spreadsheets, databases, Python programming and visualisation tools (Tableau)
  • 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
  • Overview of Data Analysis, Statistics, Business Intelligence, Metrics, and KPIs
  • Statistics and Statistical Analysis
  • Data Analysis Functions in Spreadsheets (Excel)
  • Analysing Data in Excel with IF, VLOOKUP, Text Functions, Statistical Functions.
  • Creating Pivot Tables, Pivot Charts and Visualisations in Excel
  • Data Sources, Relational Databases and SQL
  • Using Python Pandas/NumPy for Analytics
  • Building and Publishing Dashboards with Tableau

An intermediate understanding of Microsoft Excel or other Spreadsheet and proficiency with basic maths.  Basic computer skills.

Students will be required to have Microsoft 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.

No prior qualification in data analysis is necessary for applicants, but you should possess an understanding of how Excel formulas work. Basic computer skills are required along with the ability to install software from online websites.

This course will suit someone looking to launch a career in data analytics, a professional looking to strengthen their profile with much sought-after skills, or a business owner looking to gain a competitive advantage.

*This course is intended for anyone who wants to use statistical methods to use the data analysis tools in Excel, SQL/Database, Python and Tableau or similar Analytics Tools .”

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

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.