Glintool Academy

In this course, participant will understand data management principles, the motivation for Data Management, considerations and recommendations for each stage of the data life-cycle to ensure high quality data and stakeholder requirement within relevant laws, policies and regulations. Participant will be able to organize data, and identify tools, considerations and recommendations for data creation and other stages of the data life cycle.

• Module 0: Motivation for Data Management
  • Necessitate  the need for data management.
• Module 1: Data Management: Principles, Life-cycle, Protection and Regulation
  • Outline the data life cycle, provide considerations and recommendations for each stage, and understand data use and protection with consideration for regulations.
• Module 2: Data Creation
  • Master tabular data, the various elements, tools, considerations and recommendations for data creation.
• Module 3: Data Technology Ecosystem
  • Discuss various data-related technologies and their use cases.
• Module 4: Presenting with Data
  • Provide an overview of options for presenting with data.

4 Weeks

100% Online

Interactive contents

Complementary virtual sessions

Certificate

$25.0

In this course, participants will understand database schema design, avoid update and deletion anomalies and minimize redundancies. Participant will be able to create and use tables, relationships, validation, forms, queries, reports, and ensure security.

• Module0: Microsoft Office Access
  • Become familiar with the Microsoft Office Access application, interface, preferences and objects..
• Module1: Tables and Relationships
  • Design and create schema involving tables with relationships.
• Module2: Forms
  • Design, create and use forms.
• Module3: Queries and Reports
  
• Design, create and run query to generate reports.
• Module4: Data, Performance and Security
  • Understand measures to ensure performance and security of an Access database application.

6 Weeks

100% Online

Interactive contents

Complementary virtual sessions

Certificate

$25.0

This course covers basic, intermediate and advanced use of Microsoft Office Word in content, document and page formatting, referencing and mail merge, collaboration and review. Participant will master features, tools, options, terms and their use cases in professional, technical and legal document created in Word. Participant will also understand concepts around documents and their application to enrich communication.

• Module 0: Microsoft Office Word
  • Introduce Microsoft Office Word application, interface, features and preferences.
• Module 1: Contents Formatting
  • Use various content types and formatting options..
• Module 2: Document and Page Formatting
  • Use concepts around documents and make choices that enhance document.
• Module 3: Referencing and Mail Merge
  • Use advanced features and options for managing referencing, making a document navigable and more.
• Module 4: Collaboration and Review
  • Manage collaboration and review involving remote teams.

6 Weeks

100% Online

Interactive contents

Complementary virtual sessions

Certificate

$25.0

This course covers basic, intermediate and advanced use of Microsoft Office Excel. Participant will master Excel terms, options, tools and features and their application in data entry, data analysis, data presentation, collaboration and review.

• Module 0: Microsoft Office Excel
  • Introduce Microsoft Office Excel application, interface, features and options.
• Module 1: Data Entry
  • Use tools, options and features to ensure high quality data.
• Module 2: Data Analysis
  • Process data with formulas, functions, the data analysis tool pack, goal seek, data tables and more.
• Module 3: Data Presentation
  • Present useful summaries and use visualization with consistent style.
• Module 4: Collaboration and Review
  • Setup worksheets and workbooks for collaboration and review and manage the process involving remote teams.

6 Weeks

100% Online

Interactive contents

Complementary virtual sessions

Certificate

$25.0

This course builds on advanced Excel concepts and tools. Participants will learn to deliver Excel data visualization in reports and dashboards that builds on analysis that depends upon the data model. Participant will also be able to draw meaning from data visualization in reports and dashboards that others judiciously create. We deliver this course online as instructor-led virtual sessions.

• Module 0: Introduction
  • Identify principles and recommendations for generating effective reports and dashboard from data models.
• Module 1: Creating reports and dashboards
  • Create reports, use dashboard elements in Excel and identify best practices for communicating insights with visualization.
• Module 2: Advanced Excel options
  • Apply advanced options that make reports and dashboards an interactive, engaging and immersive experience for users.

4 Weeks

100% Online

Live instructor-led virtual sessions on schedule

Quizzes, assignment, questionnaires and feedback

Certificate

$79.99

In this course, participant will understand the purpose and use of each power tool, how they contribute to make Power BI and the various ways to access and use Power BI and Power BI tools. At the end of the course, participant should be able to apply Power BI tools for data visualization in reports on Excel, Power BI Desktop and dashboards on Power BI Services. We deliver this course online as instructor-led virtual sessions.

• Module 0: Excel, Power Tools and Power BI
  • Understand the relationship between Excel, Power Tools and Power BI
• Module 1: Power BI Environment
  • Outline the features and limitations of various Power BI Environments (Excel, Desktop, Services and Mobile).
• Module 2: Power BI Desktop
  • Get started with Power BI Desktop
• Module 3: Common Data Sources and Connection
  • Connect to data sources.
• Module 4: Power Pivot and The Data Model
  • Master Power Pivot and the Data Model.
• Module 5: Power Query
  • Master Power Query.
• Module 6: Computing with Data
  • Use calculated columns and measures with DAX.
• Module 7: Views and Reports
  • Create reports and visualization on Power BI.
• Module 8: Power BI Services
  • Create and share dashboards on Power BI Services and discuss data refresh.

4 Weeks

100% Online

Live instructor-led virtual sessions on schedule

Quizzes, assignment, questionnaires and feedback

Certificate

$79.99

This course presents the R Programming language for statistical computing and demonstrates most of the data structures and packages required to be productive with R. In addition, we also identify best practices in organizing a project to simplify data management and ensure reproducible analysis. Participant will be able to use R in reproducible analysis and manage projects involving version control, data cleaning, processing, visualization, documentation and sharing among others.

• Module 0: Starting with R
  • Setup R and RStudio, Introduce RStudio interface, features and options.
• Module 1: Data and Data Structures
  • Use R data types, data structures, and functions, and extend R with packages.
• Module 2: R Projects
  • Organize data and resources in a project, use document, reproduce analysis and version control.
• Module 3: Functions and Getting Data
  • Create and use functions and read data to R.
• Module 4: tibble
  • Use tibble, a tabular data structure.
• Module 5: tidyr
  • Use tidyr to tidy messy data
• Module 6: dplyr
  • Use dplyr for data manipulation.
• Module 7: ggplot2
  • Use ggplot2 graphic system.
• Module 8: R Markdown
  • Weave text with interactive code to generate reproducible reports.

6 Weeks

100% Online

Interactive contents

Complementary virtual sessions

Certificate

$79.0

This course focuses on Python 3. By the end of this course, participant will gain deep knowledge of core datatypes, functions, control flow, OOP, classes and more. Participant will be empowered to deploy this dynamically typed, general purpose, object-oriented programming (OOP) language to a range of applications including web application programming and data science.

• Module 0: Getting Started with Python
  • Setup Python and introduced various program units.
• Module 1: Python Objects
  • Create and interact with core objects in Python.
• Module 2: Program Flow Control and Documentation
  • Use program flow control, sequence operations, comprehension and documentation
• Module 3: Files, Functions and Lambdas
  • Use files, functions and lambdas
• Module 4: Functional Programming and Exceptions
  • Use functional programming and exceptions.
• Module 5: Classes, Modules and Packages
  • Use classes, object oriented programming, modules and packages.

6 Weeks

100% Online

Interactive contents

Complementary instructor-led virtual sessions on schedule

Certificate

$25.0

This course builds on a knowledge of the Python programming. In this course, participant will learn to deploy Python in data science applications involving getting and cleaning data, data analysis and data visualization.  Participant will be able use numpy, pandas and matplotlib and deliver reproducible and interactive data analysis  with various output formats.

• Setup
  • Setup required software and packages on a local computer
• Introduction to Python programming
  • Provide an overview of basic programming concepts in Python
• Numpy
  • Use numpy multidimensional array and vectorization
• Pandas
  • Use Series and DataFrames to get, clean, analyze and visualize
• Matplotlib
  • Use matplotlib for data visualization
• Jupyter Notebook
  • Use Jupyter Notebook for interactive and reproducible analysis with markdown
• Demo project
  • Live instructor-led session demonstrating application of relevant concepts in the analysis process
• Practice project
  • Complete a graded data analysis project.

 4 Weeks

100% Online

Interactive contents on demand

Live instructor-led virtual sessions on schedule

Certificate

$79.99

In this course, participant will understand Git/GitHub, a distributed version control system. Participant will be able to manage changes to project files on local and remote repositories.

• Module 0: Version Control Systems
  • Introduce version control systems, common types and use cases.
• Module 1: Git
  • Setup and introduce Git for version control.
• Module 2: Local Repository
  • Use local repository on Git.
• Module 3: Remote Repository
  • Use remote repository on GitHub.

4 Weeks

100% Online

Interactive contents

Complementary virtual sessions

Certificate

$25.0