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.
- Course Duration: Minimum (24 hrs/1 module and 1 level), Max (240 hrs)
- Exams : From CompTIA, Microsoft, Oracle, Google (dep on modules taken)
- Approved by MQA/HRDC
- Course Materials and Online Content Provided
- Flexible Timetable
- Special Packages + Payment Facilities
BENEFITS OF THIS COURSE
There are many benefits in becoming a Pro Python Programmer
STUDENT REGISTRATION
Once you have completed this form, please contact us or come on site to complete the registration process.
RELATED COURSES - ARTICLES
THE BELBIN MODEL
The Belbin Model, also known as Belbin Team Roles, is a framework for understanding the roles individuals naturally adopt in a team setting. Developed in
Writing a Critical Appraisal
INTRODUCTION How do you write a critical appraisal? Many people find difficulties doing this at the end of their project or dissertation. A critical appraisal
PRIVACY IN THE MODERN WORLD
What is Privacy? It is the right of an individual to keep their personal information and activities from being disclosed to others without their consent. In our article, we shall review the following: What are the top risks to privacy today, What are the technical solutions to protect privacy, The legal aspect and what is GDPR, How privacy varies across cultures, How new technologies could challenge privacy in the future
