IBATLive
IBATLive

Online Data Analytics Professional

Training Program for Data Analysts

Duration:
10 Months Part-time (evening)
Start Date:
Sept 2021
Days:
Tuesdays and Thursdays (6.30pm-9.30pm)
Certification:
INT DIPLOMA
Reference Code:
OINTDA1P
Normal Price:
€2,000

Why Data Analysis Professional

Data Analysts aim to discover how data can be used to answer questions and solve problems through the use of technology.  In the last two decades, the spread of the internet and interconnected devices has exponentially increased the data we produce. The amount of data available to us is Overwhelming and Unprecedented. Obtaining, transforming and gaining valuable insights from this data becoming valuable and in-demand skill.

In this course, you'll learn how to use Data, Analytics, Statistics, Probability, and basic Data Science using Python to give an edge in your career and everyday life. you will examine real-world data sets and show how to obtain meaningful insights. You'll learn how to create Dashboards, tell stories with Data and Visualizations, make Predictions, Analyze experiments and more. 

  • SkillsIreland estimates that there will be a demand for Big Data/Analytics roles to the tune of 49,000-62,000 in Ireland by this year 2020. 
  • According to the World Economic Forum, Data Analysts are expected to be in the Top Ten Jobs in Demand by 2020.
  • There is a significant skills shortage for this profession in Ireland with over an 8% growth in demand for more data analysts. Ireland needs to create 21,000 jobs in data by 2020.
  • 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
    area in ICT skills.



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
Image
Image

Course Content


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
Image

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
Image

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
Image

STAGE 4 - Big Data and Cloud (40 Hours)

  • Big Data fundamental concepts
  • Hadoop basics
  • Spark
  • Microsoft Azure services
  • AWS
  • Google Cloud Platform
  • Use cases
Ongoing Project (55 Hours)

Career Opportunities

According to Brian Mooney (Irish Times, 07 March 2017)

Data analytics was the fastest-growing skill in demand in 2015 and demand is set to continue in the years ahead.

Data Analysts are in strong demand in industries as diverse as: pharmaceuticals, marketing, finance and insurance, as well as cloud computing.=

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 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.

How to Apply

Don’t miss out because you’re unsure.

You can contact or apply to us directly using the the "Contact Us" or "Apply Online" options below or at the top of the page, this will reserve your place and also give us the key details to start your application, a member of our admissions team will then contact you with further details, or alternatively you can simply "Ask us a Question" using the form below.

You can also "Book a One-to-One" with one of our course specialists who will provide you with additional guidance on your application, you can set up a meeting by:

  • Calling us at:  +353 1 8075 055 
  • Email us at:  This email address is being protected from spambots. You need JavaScript enabled to view it.  

We also have flexible payment plans, please contact 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.

We look forward to meeting you.

Why IBAT College?

Career Potential
Maximise your career potential as you remain working while obtaining a professionally relevant, career enhancing, qualification at the same time.

Excellent Lecturing Staff
Learn from friendly and highly qualified academic staff, with industry experience, in small class-sizes, and guest lecturers who are experts in their fields.

Student Experience
Being part of a culturally diverse student nationality mix at IBAT College Dublin, with learners from over 30 different countries, gives you the opportunity to learn culturally different working methods first-hand, and the fundamentals to succeed in a globally connected network once you graduate.

City Centre Location
With our campus located in Dublin city centre, in Temple Bar, you are close to all major transport hubs making it easy to attend classes in between work and home.

Programme Material
Printed course notes are supplied for the first lecture. All subsequent notes are then available to download/view/print through the student virtual learning (Moodle) platform.

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. 

0%
Percentage of high-performing companies using real-time Predictive Analytics.
0,000
Starting Salary for entry-level Data Analyst.
0
Hottest skills ranking for 2020, Statistical Analysis and Data Mining - LinkedIn Ireland.

Apply now to reserve your place.

Contact us and one of our course specialists will be able to speak to you one-on-one about your needs by phone, email or in person.

Question? Ask us.

Discuss your needs with one of our course specialists.

Student Benefits

Discover the additional support services and facilities we have to help you thrive; from IT Labs, a Career Service, Networking Evenings and more..

IBAT goes live with real-time, online professional diploma courses

Make the most of the next few weeks to upskill, retrain and revitalise your career.

Take the first step

Contact us and one of our course specialists will be able to speak to you one-on-one about your needs by phone, email or in person.