(6.30pm-9.30pm)
Thursday
This course is starting in Feb 2025
- Why study Data Analysis?
- Course Details
- Career Opportunities
- How to Apply
- Experience Virtual Learning
Why study Data Analysis?
A data analyst professional discovers how data can be used to answer questions and solve problems using technology. In the last two decades, the spread of the internet and interconnected devices has exponentially increased the data we produce.
As such, understanding how to transform and gain valuable insights from this data has become an invaluable and in-demand skill across every industry.
Throughout this data analytics course, you'll learn how to use data, analytics, statistics, probability and basic data science using Python to give an edge in your career. During your data analyst training, you’ll examine real-world data sets and translate them to meaningful insights as well as learn how to create dashboards and make predictions based on your findings.
- Gain the skills required for data analyst roles with this eight-course professional certificate from IBM and position yourself competitively in the thriving job market for data analysts, which is expected to see a 20% growth by 2028 (U.S. Bureau of Labor Statistics).
- SkillsIreland estimates that there will be a demand for Big Data/Analytics roles to the tune of 49,000-62,000 in Ireland in 2021.
- Industries such as finance, insurance, professional services and IT are the ones most desperately seeking data analysts.
- According to Future Jobs Ireland 2019 report, the refreshed priority themes and areas for 2018 to 2023 include Data Analytics as one of the priority skills for business success.
"Data analytics is now the fastest-growing skill in demand and this is likely to continue in the years ahead. The combination of data and marketing skills is perhaps the most highly sought-after combination."
Future-proofing in a pandemic-hit jobs market - Irish Times - May 2021
"An in-depth analysis of the most in-demand skills from webscraping over 15,000 Data Scientist job postings show that Data Analytics is the most in-demand skills for Data Scientists and Data Analysists in 2021."
The Most In-Demand Skills for Data Scientists in 2021 - Toward Data Science - March 2021
Course Overview
Main Topics:
- SQL
- Database Structures
- Python programming
- Visualization
- Data Analysis using Python
- Data analysis with Pandas
- Data Analysis using Excel
- Power BI & Big Data and cloud
Each one of main topics is covered in detail within the progessive stages below:
- STAGE 1 - SQL & Databases
- STAGE 2 - Python Programming
- STAGE 3 - Data Analysis and Visualization
- STAGE 4 - Big Data and Cloud
Assessment
All assignments will be individual and consists of four tests and an ongoing project.
The tests will be conducted after each of the course’s four stages, each of the four tests will contribute 10% torwards the overall grade.
The ongoing project will start at the beginning of the course and will contribute 60% torwards the overall grade.
STAGE 1 – SQL & Databases (125 Hours)
STAGE 1 – SQL & Databases (125 Hours)
Module 1 – Basic data analysis using SQL (50 Hours)
- Basic select statements
- Filtering and sorting the results Scalar Functions
- Group Functions
- Join methods
- Sub Queries
- Add, modify, or remove data from a table Creating new tables
Module 2 – Advanced SQL for data analysts (50 Hours)
- Complex scalar functions
- Advanced techniques for filtering and sorting values
- Working with analytical functions
- Advanced use of Group Functions
- Working with complex Subqueries
- Use of CTE and recursive CTE
- Advanced tables integration using JOIN, UNION and CROSS APPLY
- XML techniques for solving complex problems
- Working with PIVOT and UNPIVOT
Module 3 – Developing programs using MSSQL (15 Hours)
- Variables
- Conditions & Loops
- Using Cursors
- Error Handling
- Using Stored Procedures
- Using Functions
- T-SQL Triggers
Module 4 - Database Structures (10 Hours)
- Database structure - logical and physical
- Intro to Indexes and Execution Plans
- Data Warehouse basics (ETLs, Cubes, and Reporting layer)
- Relational & NoSQL Databases
- Working with unstructured data
STAGE 2 – Python Programming (50 Hours)
STAGE 2 – Python Programming (50 Hours)
- Printing in Python, using Literal Expressions
- Variables
- Strings and Numbers
- Printing data from users
- Working with data types
- Slicers
- Control structures
- Data Structures
- Functions
- Working with data types o Collections
- Error Handling
- OOP
- Threads
- Python standard library
STAGE 3 – Data Analysis and Visualization (130 Hours)
STAGE 3 – Data Analysis and Visualization (130 Hours)
Module 1 – Data Analysis using Python (40 Hours)
- Printing in Python, using Literal Expressions
- Variables
- Strings and Numbers
- Printing data from users
- Working with data types
- Slicers
- Control structures
- Data Structures
- Functions
- Error Handling
- NumPy Basics
- Generating Data Using NumPy
- Numpy Arrays
- Array operations
- Filtering Data
- Numpy Linear algebra
- Working with matrixes
- Introduction to SciPy
- Statistics
- Polynomial operations
- Interpolations
- Types of matplotlib charts
- Basic customizations
- Advanced customizations
- 3d graphing
Module 2 - Data analysis using Pandas (25 Hours)
- Basic Select Operations
- Filtering & Sorting
- Applying Scalar Functions
- Aggregative Functions
- SET Operations
- JOIN Operations
- Schema Modifications
- Pandas Indexes
- Pivot operations
- Input / Output Operations
- Working with Analytic Functions
- Data Exploration and Basic ML
Module 3 – Data Analysis using Excel (15 Hours)
- Working with built-in tables and functions
- Conditions
- Data connectivity
- Data integration
- What-If analysis
- Spreadsheet Application
- Protecting Excel
- Macros
- Pivot Tables
- Powerpivot for Excel
Module 4 – Business Intelligence and Data visualization using Power BI (50 Hours)
- Introduction to Power BI
- Power BI Architecture
- Working with Power BI
- Development
- Visualizations
- Integrating python
- Data Security
- Sharing and Deployment
STAGE 4 - Big Data and Cloud (40 Hours)
STAGE 4 - Big Data and Cloud (40 Hours)
- Big Data fundamental concepts
- Hadoop basics
- Spark
- Microsoft Azure services
- AWS
- Google Cloud Platform
- Use cases
Career Opportunities
"Data analytics is now the fastest-growing skill in demand and this is likely to continue in the years ahead. The combination of data and marketing skills is perhaps the most highly sought-after combination."
Future-proofing in a pandemic-hit jobs market - Irish Times - May 2021
"An in-depth analysis of the most in-demand skills from webscraping over 15,000 Data Scientist job postings show that Data Analytics is the most in-demand skills for Data Scientists and Data Analysists in 2021."
The Most In-Demand Skills for Data Scientists in 2021 - Toward Data Science - March 2021
Prospective employers, therefore, include any company that requires detailed, robust analysis of data sets; some examples include:
- ICT companies (e.g. Google, eBay, Facebook, Amazon, Paddy Power),
- The pharmaceutical industry (e.g. Jansen, Merck, GSK),
- The financial services industry (e.g. Bank of Ireland, AXA, EY, Accenture, Deloitte)
Who Should Attend
This programme is suited for individuals with a variety of different experience levels, and while there is no academic requirement for entry, a basic computer literacy and analytical thinking ability would be required.
This course is for beginners who are eager to pursue a career as a Data Analyst Data Analysis, or college graduates to support or enhance their specialised field (Business Management, Industrial Engineering, Economics, Computer Science), or Software Developers/Engineers who would like to move into a Data Analyst career.
Entry Requirements
This programme is suited for individuals with a variety of different experience levels, and while there is no academic requirement for entry, a basic computer literacy and analytical thinking ability would be required.
This programme is suitiable for both beginners who are eager to pursue a career as a data analytics professional or software developers/engineers who wish to gain data analytical skills to support their current role.
How to Apply
Click on ‘Find out More’ or ‘Book Now’ to reserve your place or enquire more about this course.
You can also book a one to one with one of our course specialists by calling us at: +353 1 8075 055 or emailing us at:This email address is being protected from spambots. You need JavaScript enabled to view it.
We also have flexible payment plans, please ‘Find out More’ or call us to discuss your options or visit the college anytime and our course specialists will be more than willing to discuss any queries you may have.
IBAT is now offering 100% interactive learning via virtual classrooms, all at an affordable price. We’re adapting along with the rest of the world, to the new normal. With an increasing shift towards online learning and as jobs become harder to find, now is the time to take initiative and upskill by gaining a diploma from the comfort of your own home.
Benefit from live sessions with our expert tutors who are teaching in real-time and can therefore engage with you directly. Seize this opportunity to boost your prospects and stay ahead of the competition.
A Digital Certificate will be issued upon successful completion of four tests for each stage and an ongoing project, in addition, you will also receive a Digital Badge.
What is a Digital Badge?
A micro-credential is a compact credential that verifies the achievement of a skill or knowledge gained. A Digital Badge is a visual representation of having earned a micro-credential which can be shared on various online platforms to showcase the earner’s achievement.
Why have a Digital Badge?
Your Digital Badge and Certificate can be shared on social media channels such as LinkedIn and Facebook. Digital Badges can also be added to email signatures, displayed on resumes or added to recognised achievement platforms such as Badgr, Credly and OpenBadges. These are a great way to communicate your knowledge and skills, and highlight your commitment to Continuing Professional Development (CPD).
IBAT goes live with real-time, online professional diploma courses
Student Benefits
STUDENT EXPERIENCE
The course is no less than perfect! Exactly what I expected.