GIS Mapping Visualization and Spatial Analysis using QGIS and PowerBI
Details
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;
- Understand the basic concepts of GIS mapping, visualization, and spatial analysis.
- Learn how to use QGIS software for spatial data management, analysis, and visualization.
- Learn how to import and convert different types of spatial data into QGIS software.
- Learn how to apply different spatial analysis techniques using QGIS software.
- Learn how to create attractive and informative maps using QGIS software.
- Learn how to apply advanced mapping techniques such as web mapping, animated and interactive maps using QGIS software.
- Learn how to use Power BI for data visualization, analysis, and reporting.
- Learn how to connect to different data sources using Power BI.
- Learn how to create different types of visualizations using Power BI, including spatial visualizations and mapping.
- 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:
- GIS professionals and practitioners who want to deepen their understanding of GIS mapping and spatial analysis using QGIS and Power BI.
- Data analysts who want to integrate spatial data into their analysis and reporting.
- Environmental scientists, geologists, urban planners, and other professionals who work with spatial data.
- Students and researchers who want to learn GIS mapping, visualization, and spatial analysis techniques using QGIS and Power BI.
- 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.
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.
- 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.
Payments are due upon registration. Payment should be sent to our Bank account before the commencement of training and proof of payment sent to us
Outline
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
Special Offer
Schedules
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Weekdays | 09:00 AM — 04:00 PM |
Kincaid Development Center provides skill and career development for professionals across various industries. Driven to fill the knowledge gap in gaining quality results, we provide consultancy services to our local and international clients ranging from mid and end-term project evaluations, gaps assessments, and capacity building.
This is steered by distinct teams of dynamic partners with vast knowledge and a wealth of experience in their fields. Our teams provide tailored training and capacity building in Research, Monitoring and Evaluation, Data Analysis, Technology, Geographical Information System (GIS), Agriculture, Health and Business.
Change is constant, so is growth. In the era of technological advancements, the urgent need to grow and develop is paramount. We are here to ensure that you are ahead of the game. The training we offer in all our courses are tailored to give you a competitive advantage in your field.
Mission: To equip you with skills and knowledge for quality results in every endeavour through professional training. Vision: To be the partner of choice for professionals and organisations seeking to be leaders in their field.