OVERVIEW

In today’s data-driven world, the ability to extract valuable insights and make data-informed decisions is a critical skill. Infoclub Ltd’s Data Analytics and Data Science courses are designed to empower individuals with the knowledge and tools required to excel in these dynamic fields. Whether you’re a seasoned professional seeking to deepen your expertise or a newcomer eager to embark on a data-centric journey, our courses offer a comprehensive learning experience that covers the following key areas:

COURSES WE OFFER IN DATA SCIENCE

1. Data Preparation with SQL/NOSQL

This course will be conducted using either SQL Server, Oracle SQL, MySQL or PostgreSQL

Level 1:
Relational database concepts and SQL;
Data Types;
Create/Amend tables;
Modify data using INSERT, UPDATE, and DELETE statements;
Data/Entity/Relational Integrity;
Retrieve data with SELECT;
Sorting and filtering data;
SQL functions;
Joining tables, Subqueries and nested queries;
Sequences, Views, and indexes Managing database security and user access;
Import/Export Data (TXT, CSV formats) Collecting, Cleaning and processing data

Level 2:
T-SQL or PL/SQL syntax;
Advanced functions, Regular expressions, Complex data type;
Sub-Queries Stored procedures, functions, and triggers;
Advanced joins, GROUP BY, HAVING;
Data Analytics tools(PIVOT, CUBE);
Transactions and concurrency control;
Importing and exporting data (XML, JSON);
Optimizing SQL queries for performance.;
Partitioning, parallel query, replication, and full-text search;
Designing and developing data models, ETL (Extract, Transform, Load) processes
Note : the NOSQL (MongoDB) Syllabus is not included here

2. ADV EXCEL/VBA

Advanced Excel: Ranges, cells, worksheets; IF and VLOOKUP, PivotTables; Adv chart types, Conditional formatting, Date and time functions, Data Validation, Goal Seek and Solver; Macrosto automate tasks; PowerPivot and PivotTable reporting; Regression analysis and ANOVA; Data cubes and Power Query

Excel Programming: VBA and VBE; Programming concepts: variables, data types, operators, and control structures; Using functions and procedures; Forms and controls; Excel objects and automate tasks in Excel

3. R PROGRAMMING

R Studio, Basic syntax, data types;
Control structures, functions, and loops;
Input/output, Data wrangling(dplyr/tidyr);
Data visualization(ggplot2);
Advanced data manipulation and analysis(plyr/reshape2);
Basic statistical analysis(descriptive statistics, hypothesis testing, linear regression);
Data frames and matrices, Lists and vectors;
Adv statistics(ANOVA, logistic regression, and time series analysis);
Use SQL, Work with APIs, Web scraping;
Machine learning and predictive analytics;

4. PYTHON, SAS

We have a wide range of course in Python covering Machine Learning, Big Data, IOT and other aspects – please check the other pages

We also run courses on SAS on demand

5. POWER BI

Power BI and its capabilities
Data sources and connections
Data modeling (relationships, hierarchies DAX expressions)
Data transformation and cleansing using Power Query Editor
Creating and formatting visualizations (tables, charts, maps, and gauges)
Advanced visualization(visuals, R/Python integration); Power BI dashboards and reports; Sharing and collaborating
Data exploration and analysis using Power BI Q&A and NLP
Measures, calculated columns, and calculated tables in DAX, Data in real-time
Integration with other Microsoft tools
Managing users & licenses

Note : Instead of POWERBI, we can also run course using TABLEAU (conditions apply)

AUDIENCE FOR THESE COURSES

• Those completing BSc/MSc/PhD
• People involved in Research
• Candidates wishing to work as data scientists or data analystsin a number of sectors(Financial Services, Technology companies, Healthcare, Government agencies, Marketing and advertising, Retail and e-commerce, Energy and utilities, Transportation and logistics)
• Entry requirements may apply for some modules

COURSE ORGANISATION & TIMING

We have created a schedule for these courses to match with most availabilities.

BENEFITS OF THIS COURSE

There are many benefits in becoming a Pro Python Programmer

In-Demand Skillset: Machine learning and Python programming are highly sought-after skills in today's job market. Completing this course equips you with expertise in both areas, making you a valuable asset to employers in various industries.

Career Advancement: Whether you're looking to enter the field of data science, enhance your current role, or transition to a new career, this course provides you with the knowledge and skills needed to advance your career in technology and data-driven industries.

Hands-On Experience: The course emphasizes practical, hands-on learning. Through real-world projects and coding assignments, you gain valuable experience that can be directly applied in your job or future projects.

Comprehensive Curriculum: The course covers a wide range of topics, from mastering Python fundamentals to advanced machine learning concepts. You'll acquire a well-rounded education, ensuring you're well-prepared for the challenges of the field.

STUDENT REGISTRATION

Once you have completed this form, please contact us or come on site to complete the registration process.

OVERVIEW

COURSES WE OFFER IN DATA SCIENCE

1.

Data Preparation with SQL/NOSQL

2.

ADV EXCEL/VBA

3.

R PROGRAMMING

4.

PYTHON, SAS

5.

POWER BI

AUDIENCE FOR THESE COURSES

COURSE ORGANISATION & TIMING

BENEFITS OF THIS COURSE

STUDENT REGISTRATION

RELATED COURSES - ARTICLES

Why IT Kids?

THE BELBIN MODEL

Writing a Critical Appraisal