Professional Diploma in Data Analytics Course – Live Online

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

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.

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.

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.