PROFESSIONAL DIPLOMA IN DATA ANALYTICS – INTRODUCTION
Prices Starting At €895
(Instalment Price: €995)
Starts: 26th April 2023
11 weeks, 1 evening per week from 6.30 to 9.30pm GMT
“Turning Data into information and information into Business Intelligence.”
Data analysis 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 .”
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.
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.
In addition to our scheduled Professional Diploma courses, City Colleges can provide bespoke training over 3 – 4 days, please contact email@example.com for further details.
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.
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.