Professional Diploma in Data Analytics Course

To get the most from this Data Analytics Course, we advise that you have an intermediate understanding of Microsoft Excel or other related spreadsheet software. We also recommend a strong foundation in basic mathematics. You should also be proficient in using a computer to successfully take this course.

You will need to have Microsoft Office installed on your computer for the duration of the course. If you don’t have this, see the cost annual or per month of Microsoft Office subscription.

1. Foundations of Data Analytics
   Overview of Data Analysis, Data Architecture, Data Modelling & Business Intelligence
2. Statistics and Statistical Analysis
   Core statistical concepts and techniques for data interpretatio
3. Data Analysis with Spreadsheets (Excel)
   Using functions like IF, VLOOKUP, text functions, and statistical tools for analysi
4. Data Visualisation in Excel
   Creating Pivot Tables, Pivot Charts, and effective visualisation
5. Data Sources and SQL for Analytics
   Understanding data sources, relational databases, and querying with SQ
6. Python for Data Analytics
   Using Pandas and NumPy for data manipulation and analysis
7. Building Dashboards with Tableau
   Designing, building, and publishing interactive dashboard
8. Emerging Technologies in Analytics
   Automation, Robotic Process Automation (RPA), and Agentic AI

*Course content is subject to review after each intake and may be updated in line with industry standards.

A pass grade on the written assignment is required to earn your diploma through this data analytics course.

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.

A Data Analytics course can open the door to a wide range of career opportunities across industries including finance, technology, healthcare, and business.

On completion of this Data Analytics course, you will be equipped with the practical skills needed to pursue roles such as:

• Data Analyst
• Business Analyst
• Reporting Analyst
• Junior Data Analyst
• Data Visualisation Specialist

As organisations continue to rely on data to inform decision-making, demand for data analytics professionals in Ireland remains strong. This course provides a solid foundation for entering the field, as well as progressing into more specialised or senior roles over time.

For those looking to advance further, you can continue your studies with our Higher Diploma in Data Analytics, building deeper expertise in areas such as advanced analytics, machine learning, and data modelling.

Data analysis is the backbone of informed decision-making. It is essential to provide the data in a specific way to help this process. This involves inspecting, cleaning, transforming, and modelling data to extract valuable insights and support evidence-based conclusions.

Key areas covered in this course include:

• Statistical Analysis
• Descriptive, Diagnostic, Predictive, and Prescriptive Analytics
• Business Intelligence
• Hands-on experience with data analysis tools, including spreadsheets, databases, Python programming, and visualisation tools like Tableau.

With a base salary of €47,500 for Data Analysts in Ireland, and up to €105,000 for senior roles, this data analytics course prepares you for success in one of the most sought-after and lucrative career paths today.

Whether you choose to study in class or online, this data analytics course provides flexible options to suit your schedule.

*If you are looking for a more advanced Data Analytics Course, check out our Higher Diploma in Data Analytics.

This Data Analytics course is open to anyone, including those with no previous qualifications or experience in data analysis. The prerequisites include basic Excel formula knowledge, general computer skills, and ability to download/install software from the internet.

This data analytics course is designed for:

• Anybody seeking to pursue a career in data analytics, wishing to gain fundamental skills in one of today’s most in-demand fields.
• Professionals interested in building up their portfolio of skills and seeking an added advantage in the labor market through hot data analysis competencies;
• Entrepreneurs and business people who want to unlock data insights for business competitive advantage and to drive decision-making.

Whether you want to master statistical methods or learn the use of different tools for analytics, including Excel, SQL/Databases, Python, and Tableau, this course will give hands-on experience and the knowledge needed to be successful in today’s data-driven world.

You’ll begin this data analytics course by exploring the fundamentals, including data types, quality, architecture, and modelling. As you progress, you’ll build a strong foundation in statistical analysis, learning how to interpret data and uncover patterns that inform strategic thinking.

This data analytics course emphasises practical application, with modules focused on industry-standard tools such as Excel, SQL, Python, and Tableau. You’ll learn to:

• Perform data analysis and visualisation in Excel, using functions, pivot tables, and charts.
• Query and manage relational databases using SQL.
• Manipulate and analyse data with Python, leveraging libraries like Pandas and NumPy.
• Design and publish interactive dashboards with Tableau.

A City College Dublin’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 Dublin 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.

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