INTRODUCTION

This course is designed to provide you with a comprehensive understanding of the fundamentals of GIS mapping, spatial data visualization, and analysis, using two popular software applications: QGIS and Power BI.

Geographic Information Systems (GIS) are used for managing and analyzing geographic information. GIS enables users to create, display, and analyze spatial data, and derive insights from them. GIS is used in a wide range of applications such as urban planning, natural resources management, environmental assessment, and disaster management.

QGIS is a free and open-source GIS software, widely used for spatial data management and analysis. Power BI, on the other hand, is a popular business intelligence tool provided by Microsoft, used for data visualization, analysis, and reporting.

In this course, you will learn the fundamental concepts of GIS and how to apply them to spatial data management, analysis, and visualization. You will learn how to use QGIS for spatial data management and analysis, including mapping, cartography, and spatial queries. You will also learn how to use Power BI for data visualization, reporting, and analysis, including spatial data visualization and mapping.

By the end of this course, you will have the skills and knowledge to manage, analyze, and visualize spatial data using QGIS and Power BI, and apply them to real-world applications. We hope that you find this course valuable and engaging, and we look forward to your participation.

Participants who successfully complete the course will receive Certificate of Participation. Please note that we extend post-training support for up to 6 months after training.

OBJECTIVES

By the end of this course, participants will;

1.    Understand the basic concepts of GIS mapping, visualization, and spatial analysis.

2.    Learn how to use QGIS software for spatial data management, analysis, and visualization.

3.    Learn how to import and convert different types of spatial data into QGIS software.

4.    Learn how to apply different spatial analysis techniques using QGIS software.

5.    Learn how to create attractive and informative maps using QGIS software.

6.    Learn how to apply advanced mapping techniques such as web mapping, animated and interactive maps using QGIS software.

7.    Learn how to use Power BI for data visualization, analysis, and reporting.

8.    Learn how to connect to different data sources using Power BI.

9.    Learn how to create different types of visualizations using Power BI, including spatial visualizations and mapping.

10. Learn how to create interactive dashboards using Power BI.

DURATION

10 days

WHO SHOULD ATTEND?

This training course is designed for professionals who are interested in working with spatial data and want to develop their skills in GIS mapping, visualization, and spatial analysis. Some of the potential participants who would benefit from this course include:

1.    GIS professionals and practitioners who want to deepen their understanding of GIS mapping and spatial analysis using QGIS and Power BI.

2.    Data analysts who want to integrate spatial data into their analysis and reporting.

3.    Environmental scientists, geologists, urban planners, and other professionals who work with spatial data.

4.    Students and researchers who want to learn GIS mapping, visualization, and spatial analysis techniques using QGIS and Power BI.

5.    Anyone interested in developing their skills in GIS mapping, spatial analysis, and data visualization.

Participants are not required to have any prior experience with QGIS or Power BI software, but some basic knowledge of data management and visualization will be helpful. The course is designed to provide a comprehensive understanding of the fundamental concepts and techniques of GIS mapping, visualization, and spatial analysis using QGIS and Power BI.

COURSE OUTLINE

The course is delivered through the following Modules:

Module 1: Introduction, cartography and GIS, and creating maps in QGIS

Gain a basic conceptual understanding of cartography, GIS, and mapping

Gain familiarity with geographic data and information, and how it's encoded within computer files

Gain a basic familiarity with the QGIS interface

Gain awareness of spatial reference and projection issues

Practice opening a variety of geographic data with QGIS and viewing their attributes within QGIS

Perform basic map styling

Create and export a basic map as a static image file

Module 2: Thematic data mapping, Geocoding and point in polygon analysis

Load shape files and CSV data into QGIS

Data transformation

Create classed choropleth map

Adjust the legend to help the map tell a clearer story

Load tabular CSV data into QGIS and performing a tabular join

Obtaining and working with US Census data

Understand and perform geocoding of tabular data

Learn about some of the geocoding tools available online

Understand and perform a point in polygon analysis

Module 3: Heat maps, creating and editing vector Geometries

Map point data

Create a 'heat map' representation of the data

Georeferencing

Digitizing data

Digitizing data with Open Street Map in QGIS

Introduction to Open Street Map

Importing OpenStreetMap data

Importing OpenStreetMap data: Spatial Lite Database

Data filtering and extraction

Exporting layers to a local CRS

Module 4: Geoprocessing

Introduction to Geoprocessing

Geoprocessing with a buffer analysis

Extracting and preparing thematic OSM data

Filtering OSM data to create desired features

Managing CRSs in a Geoprocessing Workflow

Extracting attribute types of interest

Creating a buffer around a Polyline feature

Clipping features within a buffer

Geoprocessing functions

Using the Graphical Processing Modeler to automate workflows

Module 5: Intergrating QGIS with CartoDB, advanced mapping techniques with QGIS and CartoDB

Creating a CartoDB account and exploring the documentation and interface

Loading data into CartoDB

Using the QGIS CartoDB plugin

Pulling data down into QGIS for processing

Pushing data backup to CartoDB

Making a thematic map in CartoDB

Using SQL in CartoDB

Data symbolization and analysis in CartoDB

Creating an unclassed proportional symbol map in CartoDB

Creating shareable and interactive web maps with QGIS

Module 6: Introduction to Power BI

Overview of Power BI and its capabilities

Connecting to data sources

Creating data models and relationships

Module 7: Visualization Basics with Power BI

Introduction to Power BI visualizations

Creating charts and tables

Applying basic formatting and customizing visuals

Module 8: Advanced Visualizations with Power BI

Mapping and spatial visualizations in Power BI

Creating dashboards

Applying filters and slicers

Module 9: Data Analysis with Power BI

Introduction to data analysis with Power BI

Applying statistical and mathematical functions

Creating calculated fields and measures

Module 10: Final Project and Review

Putting it all together: final project combining QGIS and Power BI skills

Review of course concepts and discussion of next steps

Q&A and closing remarks

General Notes

·      The instructor led trainings are delivered using a blended learning approach and comprises of presentations, guided sessions of practical exercise, web-based tutorials and group work. Our facilitators are seasoned industry experts with years of experience, working as professional and trainers in these fields.

·      The participants should be reasonably proficient in English as all facilitation and course materials will be offered in English.

·      Upon successful completion of this training, participants will be issued with a certificate.

·      The training will be held at Kincaid Training Centre. The course fee covers the course tuition, training materials, two break refreshments and lunch.

·      All participants will additionally cater for their, travel expenses, visa application, insurance, and other personal expenses.

·      Accommodation and airport pickup are arranged upon request. For reservations contact the Training coordinator at Email: training@kincaiddevelopmentcenter.org or Tel: +254 724592901

·      This training can also be customized to suit the needs of your institution upon request. You can have it delivered in our Kincaid Training Centre or at a convenient location.

For further inquiries, please contact us on Tel: +254 724592901 or send mail to training@kincaiddevelopmentcenter.org.

Payments are due upon registration. Payment should be sent to our Bank account before commencement of training and proof of payment sent to training@kincaiddevelopmentcenter.org.