PROFESSIONAL DIPLOMA IN DATA ANALYTICS – INTRODUCTION

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

Professional Diploma in Data Analytics – Introduction 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 .”