Course Details

Course Description

Course Overview

Data Analytics for Business & Research Institutions is a comprehensive course designed to equip learners with the skills needed to harness the power of data in making informed decisions. Taught by industry experts, this course covers a wide range of data analytics techniques, from basic data processing to advanced statistical analysis and predictive modeling, tailored specifically for business environments and research institutions.

Delivered online, this course offers the flexibility to learn at your own pace, making it suitable for both beginners and professionals looking to enhance their data analytics capabilities. The curriculum is rich with practical exercises, case studies, and real-world projects, allowing students to apply their knowledge in analyzing complex datasets, identifying trends, and making data-driven decisions.

Students receive ongoing mentorship from experienced data analysts throughout the course, ensuring they fully grasp the concepts and tools necessary to excel in data analytics. This mentorship helps learners transition from theory to practice, enabling them to effectively apply data analytics in their organizations, whether for business optimization or academic research, and become proficient in turning data into actionable insights.

Course Outline

Module One: Microsoft Excel

1. Overview of MS Excel
2. Getting Started with MS Excel
3. Data Entry in MS Excel
4. Relative & Absolute Referencing in MS Excel
5. Moving Data Across Sheets
6. Basic Shortcuts in MS Excel
7. Autofill in MS Excel
8. Displaying formula in MS Excel status bar
9. Conditional Formatting in MS Excel
10. Table Styles
11. Cell Styles
12. Inserting Smart Art
13. Goal Seek
14. Scenarios
15. Data Table & Sensitivity Analysis
16. Forecasting in MS Excel
17. Tracing Precedents & Dependents
18. Comments in MS Excel
19. Inserting Charts in MS Excel
20. Pivot Table
21. Text to Column & Concatenation
22. Flashfill in MS Excel
23. Checking & Removing Duplicates
24. Data Consolidation
25. Tables in MS Excel
26. Grouping Data in MS Excel
27. SUMIF,SUMIFS,COUNTIF,COUNTIFS
28. Data Validation & Dropdown List
29. VLOOKUP & HLOOKUP
30. IFERROR
31. MS Excel IF
32. Named Ranges
33. Understanding MS Excel Errors
34. MS Excel Form
35. marking a Workbook as Final
36. Protecting MS Excel Workbook
37. Module Conclusion & Reflections
38. MS Excel Quiz & Assignments

Module Two: Microsoft Power Business Intelligence (Power BI)

1. Overview of Power BI
2.  Loading Data to Power BI
3. Components of Power BI
4. Charts & Visualizations
5. Data Interactions in Power BI
6. Data Models & Relationships
7. Data Cleanup
8. Data Analysis Expressions (DAX)
9. Formatting Power BI Visuals
10. Conditional Formatting
11. Inserting Titles & Pictures
12. Trends & Forecasting in PBI
13. Building Dashboards in PBI
14. Module Conclusion & Reflections  
15. MS Power BI Quiz & Assignments

Module Three: MYSQL

1. Overview of SQL & Database
2. Introduction to Data
3. Introduction to Primary Keys
4. Introduction to Foreign Keys
5. Getting Started with MYSQL
6. Creating Database & Tables
7. SQL Syntax
8. SQL Insert Into 
9. SQL Select From
10. SQL Conditions
11. SQL Order By
12. SQL Null Values
13. SQL Update
14. SQL Delete
15. SQL Select Top
16. SQL Min & Max Values
17. SQL Sum
18. SQL Count
19. SQL Like
20. SQL IN  
21. SQL Between
22. SQL Aliases
23. SQL Joins
24. SQL Group By
25. SQL Exists
26. Date Part
27. SQL Having
28. SQL Data Import
29. SQL Data Export
30. Module Reflections & Conclusion
31. SQL Quiz & Assignments  

Module Four: Statistical Package for Social Sciences

1. Overview of SPSS
2. Installation of SPSS Software
3. Getting Started with SPSS
4. Descriptive Statistics in SPSS
5. Knowledge Transformation, Hypothesis & Decision Rule in SPSS
6. Linear Regression in SPSS
7. Correlations in SPSS
8. One Way ANOVA in SPSS
9. ANCOVA in SPSS
10. Independent T-Test in SPSS
11. Paired T-test in SPSS
12. Chi-Square in SPSS
13. Forecasting in SPSS
14. Quality Control in SPSS
15. Test for Reliability
16. Module Conclusion & Reflections
17. SPSS Quiz & Assignments

Course Benefits

1. 100% practical course from industry experts.
2. Internship opportunities for best performing students
3. 1 hour free google meet session for better interaction with tutors.
4. Certification from a reputable and well recognised IT firm in Nigeria.
5. Real business case studies and projects used in the courses.
6. You get to learn at your own pace. You can also set time frames to motivate you complete the course  if you need to.

7. Learn & Earn Opportunities. You earn money by referring friends & family to enroll in our Courses.

Who Needs This Course?

1. Anyone willing to take-up a career in Data Analytics.
2. Students, graduates, Freelancers and Start-ups who need a digital skill.
3. Beginners in Data Analytics who wish to advance and polish their skills.
4. Individuals who wish to boost productivity at their work places.
5. Corporate bodies willing to train and develop their staff for better productivity & results.
6. People seeking to travel abroad and need Tech skills for better opportunities.