Data Analytics with Excel, VBA and Python - From the Ground Up Training Course
Data analytics is a vital asset in today's business landscape. This course is dedicated to building practical, hands-on data analysis skills. Its primary objective is to empower participants to provide evidence-based answers to key business questions:
What has happened?
- processing and analyzing data
- producing informative data visualizations
What will happen?
- forecasting future performance
- evaluating forecasts
What should happen?
- turning data into evidence-based business decisions
- optimizing processes
Course Outline
Basic Excel
- Navigation
- Manipulating data
- Working with formulas and addresses
- Charts
Advanced Excel
- Logical functions
- Scenario analysis
- Solver
- Macros
- First glimpse of code: VBA
VBA
- Data types
- Writing a function
- Controlling a program: conditional evaluation and loops
- Debugging techniques
Data Analytics with Python
- Introducing Python
- Variables and types
- Data manipulation in Python using Pandas
- Writing functions
- Data visualization using Matplotlib and Seaborn
- Data wrangling with Pandas
Introduction to Machine Learning with Python
- Linear Regression using scikit-learn
- Classification and regression trees with Python
- Classification using Support Vector Machines and Random Forests
- Clustering techniques using scikit-learn
Requirements
There are no specific requirements needed to attend this course.
Need help picking the right course?
southafrica@nobleprog.co.za or +27 (0)10 005 5793
Data Analytics with Excel, VBA and Python - From the Ground Up Training Course - Enquiry
Testimonials (2)
Doing Exercise
Joe Pang - Lands Department, Hong Kong
Course - QGIS for Geographic Information System
Hands-on examples allowed us to get an actual feel for how the program works. Good explanations and integration of theoretical concepts and how they relate to practical applications.
Ian - Archeoworks Inc.
Course - ArcGIS Fundamentals
Related Courses
ArcGIS for Spatial Analysis
14 HoursThis instructor-led, live training in Kenya (online or onsite) is aimed at field ecologists and conservation managers who wish to create data spatial projects in ArcGIS.
By the end of this training, participants will be able to:
- Output spatial data as visualizations.
- Conduct geostatics on actual data.
- Implement spatial data analysis, data processing, and mapping with ArcGIS.
- Analyze spatial data for projects in ArcGIS.
ArcGIS from Basic to Advanced
35 HoursThis instructor-led live training in Kenya (available online or onsite) is designed for GIS professionals and analysts, from beginner to advanced levels, who wish to learn how to effectively utilize ArcGIS for data visualization, spatial analysis, and geospatial project management.
Upon completion of this training, participants will be able to:
- Effectively navigate and employ ArcGIS tools for managing geospatial data.
- Design and tailor maps by utilizing layers and attributes.
- Execute sophisticated spatial analysis and geoprocessing operations.
- Streamline workflows through the use of ModelBuilder and Python.
ArcGIS Enterprise for Technical Support
14 HoursThis instructor-led, live training in Kenya (online or on-site) is designed for beginner-level IT support professionals looking to provide strong support for ArcGIS Enterprise, effectively handling any system anomalies or failures.
By the end of this training, participants will be able to:
- Understand the architecture and components of ArcGIS Enterprise.
- Learn to install, configure, and manage ArcGIS Enterprise.
- Gain skills in troubleshooting and resolving common issues.
- Develop proficiency in monitoring and maintaining ArcGIS Enterprise environments.
- Master the techniques for backup, recovery, and performance optimization.
ArcGIS Fundamentals
14 HoursThis instructor-led, live training in Kenya (online or onsite) is aimed at beginner-level professionals who wish to learn the fundamental concepts and tools of ArcGIS.
By the end of this training, participants will be able to:
- Understand the basic concepts of GIS and spatial data.
- Navigate the ArcGIS interface.
- Create and manage spatial data.
- Perform basic spatial analysis.
- Create maps and visualizations.
ArcGIS Professional Plus: Advanced GIS Data Management and Analysis
14 HoursArcGIS Professional Plus serves as an enhanced version of ArcGIS Pro, providing extended capabilities for geospatial data analysis, 3D modeling, automation, and enterprise collaboration.
This instructor-led live training, available online or onsite, is designed for intermediate-level GIS professionals looking to deepen their expertise in spatial data analysis, automation, and data sharing using ArcGIS Professional Plus tools.
Upon completion of this training, participants will be equipped to:
- Utilize ArcGIS Pro Plus tools for effective data visualization and analysis.
- Develop 2D and 3D maps employing advanced symbology and geoprocessing techniques.
- Automate workflows through ModelBuilder and Python scripting.
- Integrate ArcGIS with external data services and enterprise systems.
Course Format
- Interactive lectures and discussions.
- Extensive exercises and practical activities.
- Hands-on implementation within a live-lab environment.
Course Customization Options
- To arrange customized training for this course, please contact us.
Advanced ArcGIS Pro for Spatial Analysis
35 HoursThis instructor-led, live training in Kenya (online or onsite) is aimed at advanced-level GIS professionals who wish to use ArcGIS Pro to enhance their spatial analysis capabilities, conduct comprehensive geostatistical analysis, and apply advanced 3D modeling techniques for more effective decision-making and problem-solving in real-world scenarios.
By the end of this training, participants will be able to:
- Develop advanced skills in spatial analysis techniques using ArcGIS Pro.
- Utilize Python scripting for automation and complex data processing.
- Apply spatial modeling for problem-solving in real-world scenarios.
- Conduct geostatistical analysis for advanced data interpretation.
- Integrate external data sources and leverage 3D spatial data analysis.
Advanced Power Systems and GIS Integrated Solutions
70 HoursIn the dynamic energy landscape, merging electrical transient analysis with accurate geographic information is a strategic imperative. Currently, depending on disjointed data creates substantial operational risks. This intensive 14-day course, held in Melbourne, aims to close the divide between electrical engineering and geospatial management.
Advanced Geographic Information Systems (GIS)
21 HoursThis instructor-led, live training in Kenya (online or onsite) targets intermediate-level geographers looking to deepen their expertise in spatial analysis, data management, and GIS applications.
By the end of this training, participants will be able to:
- Apply advanced spatial analysis techniques to solve complex geographical problems.
- Manage large spatial databases and perform data quality control.
- Create dynamic and interactive maps and visualizations for various applications.
- Utilize programming and automation to streamline GIS workflows.
Google Maps API for Developers
14 HoursThis instructor-led, live training in Kenya (online or on-site) is designed for developers who wish to enhance their websites or web applications by adding geo-location functionality through Google Maps.
By the end of this training, participants will be able to:
- Embed a map into a new or existing website or web application.
- Display live data that synchronizes with the current location.
- Create a mashup that includes Google Maps.
- Apply good CSS and JavaScript coding practices
- Create a custom map for an application.
Insurance in the Digital Era
14 HoursInsurance in the Digital Era offers a practical overview of how digital transformation is reshaping products, operations, and customer engagement within the insurance industry.
This instructor-led live training (available online or onsite) is designed for intermediate-level insurance professionals seeking to understand and apply digital technologies, data-driven strategies, and innovation frameworks to modernize their insurance offerings and operations.
By the end of this training, participants will be able to:
- Explain the role of AI, Big Data, IoT, and automation in modern insurance workflows.
- Identify InsurTech trends and their impact on the insurance ecosystem.
- Design customer-centric strategies enabled by digital tools and data insights.
- Apply data-driven approaches to risk management and decision-making.
- Develop an innovation and change management approach suitable for insurers.
- Assess real-world case studies and translate lessons into local initiatives.
Format of the Course
- Interactive lecture and discussion.
- Case study analysis and group workshops.
- Practical exercises and action planning for participants’ organizations.
Course Customization Options
- To request a customized training for this course, please contact us to arrange.
IREB CPRE – Foundation Level (Extended): Practical Requirements Engineering and Certification Preparation
14 HoursRequirements Engineering (RE) serves as a pivotal discipline in software and systems development, concentrating on identifying, documenting, and managing stakeholder needs and constraints to guarantee project success.
This instructor-led, live training, available online or onsite, targets intermediate-level professionals looking to deepen their grasp of practical Requirements Engineering while preparing for the IREB CPRE – Foundation Level certification exam.
Upon completing this training, participants will be able to:
- Comprehend and apply the core concepts and terminology outlined in the IREB CPRE Foundation syllabus.
- Identify and elicit requirements using effective and context-appropriate techniques.
- Model, document, and validate requirements for real-world projects.
- Manage requirements changes, traceability, and prioritization throughout the project lifecycle.
- Utilize Requirements Engineering tools and best practices to enhance communication and project outcomes.
- Be fully prepared to take and pass the IREB CPRE – Foundation Level certification exam.
Format of the Course
- Interactive lecture and discussion.
- Case-based exercises and collaborative workshops.
- Exam preparation sessions and practice questions.
Course Customization Options
- Additional modules or industry-specific case studies can be added on request.
Python for ArcGIS and QGIS for Earth Sciences and Engineering Professionals
35 HoursThis instructor-led, live training in Kenya (online or onsite) is designed for beginner-level earth sciences and engineering professionals who aim to leverage Python for geospatial analysis in both ArcGIS and QGIS environments.
Upon completion of this training, participants will be able to:
- Master Python syntax and control structures to execute geospatial tasks efficiently.
- Employ Pandas, Numpy, and Matplotlib for data analysis and visualization within GIS contexts.
- Manipulate and analyze vector data using the Geopandas, Arcpy, and PyQGIS libraries.
- Automate geospatial processes and workflows through Python scripting in ArcGIS and QGIS.
- Create custom Python-based geoprocessing tools for ArcGIS and QGIS to enhance task efficiency.
QGIS for Geographic Information System
21 HoursA Geographic Information System (GIS) is a framework built to capture, store, manipulate, analyze, manage, and present spatial or geographic data. The term GIS is occasionally used to denote Geographic Information Science (GIScience), referring to the academic discipline that studies these systems, which forms a significant part of the broader field of geoinformatics.
QGIS operates as GIS software, enabling users to analyze and edit spatial information, as well as compose and export graphical maps. It supports both raster and vector layers; vector data is stored as point, line, or polygon features. The software accommodates various raster image formats and can georeference images. In summary, it empowers users to create, edit, visualize, analyze, and publish geospatial data across Windows, Mac, Linux, and BSD platforms.
In the first phase, this course introduces the QGIS interface for general usage. The second phase covers PyQGIS, the Python libraries of QGIS, which allow the integration of GIS functionalities into your Python code or applications. This enables you to develop your own Python plugins tailored to specific GIS functionalities.
Requirements Analysis
21 HoursThis instructor-led live training in Kenya (online or onsite) targets individuals seeking to understand requirements analysis and perform it efficiently and accurately using appropriate techniques for their projects.
By the end of this training, participants will be able to:
- identify various types of requirements.
- understand the overarching concepts and activities within requirements analysis.
- become familiar with the methodology governing requirements analysis.
- utilize different requirements analysis techniques to their benefit.
- structure requirements to enable efficient communication with architects and developers through an iterative requirement gathering process.