Data analysis is evaluating datasets using statistical tools to reveal information so that you can make decisions. Data analytics essentially examines large datasets to uncover not easily recognisable 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, Python and Tableau, and how to apply these to real-world datasets and examples.
Why Data Analysis?
- 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
Data Analysis is a process of inspecting, cleaning, transforming and modelling data to discover useful information, suggesting conclusions and support-driven decision-making. The significant data analysis approaches are −
- Data Mining
- Statistical Analysis
- Predictive Analytics
- Text Analytics
- Business Intelligence
- Overview of Data Analysis, Data Mining, Statistics Analysis, Business Intelligence, Metrics, and KPIs
- Data Sources, Relational Databases and SQL
- Structuring data and data wrangling (cleaning data)
- Statistics and Statistical Analysis
- Working with Time Series, Cross-Sectional and Panel Data
- Identifying Trends and Patterns with Regression and Correlation
- Data Analysis Functions in Excel
- Analysing Data in Excel with IF, VLOOKUP and Text Functions
- Creating Pivot Tables, Pivot Charts and Advanced Visualisations in Excel
- Using Python Pandas/NumPy for Analytics
- Building and Publishing Dashboards with Tableau
- Data Science and Machine Learning Algorithms
A basic understanding of Microsoft Excel and proficiency with basic maths
Students will be required to have 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.
*This course is intended for anyone who wants to take the data analysis technologies in Excel and other Analytics Tools beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.
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 firstname.lastname@example.org 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.