Source for training course on environmental data analysis and processing for the XI Simbioma 2022. Each topic will have a code, data or file example, with a related video on youtube.
- Environmental Data Basics and Resources
- Database, Dataset and Software
- Dataset Setup, Clean and LOG
- Data collection and selection
- Hypothesis and tools
- Share and show
- Act data-driven
- Open Data -Sources and formats
- Scientific collection and biodiversity network
- Google BigQuery
- Tableau Online
- Google DataStudio
- Wiki constelation
- GitHub / R-Markdown / Jupyter Notebooks
- Qgis -Processing R
- Qgis -Legend (levels, scale, constrast)
- CAR/IBGE/SNUC -Brasil national spatial sources
- Geobases -Espirito Santo Spatial resource
- MapBiomas -Environmental historic data
- Suggested Course on Spatial Data (portuguese) -SPU
- Suggested Course on Data Analytics (english) -Google Coursera
- Ask (Environmental Data Basics and Resources)
- Prepare (Database, Dataset and Software)
- Clean (Dataset Setup, Clean and LOG)
- Process (Data collection and selection )
- Analyse (Hypothesis and tools )
- Share (Share and show )
- Act (Act data-driven)
- Sources and relations
- Time, deadline and expectation
- Resources for environemntal information and raw data
- Database understanding and structure
- Dataset definition
- Software for dataset and database.
- Relationship over data, time and space
- SpreadSheet - Excel/Google
- R-CRAN/R-Studio - Libraries
- Structured Query Language (SQL) / Geography Information System (GIS) database
- Visual validation
- Registering changes, sources and assumptions (LOG)
- Fields, Keys, conventions (Tidy-R)
- Data validation
- Qgis - Plugins, processing, add-ons, python
- Spatial data validation (topology check)
- Business Problem, objectives and target needs
- Expected steps and duration
- Data type, volume and timeframe
- Filtering data (Spreadsheet, R-studio, SQL)
- Data group, parts and cross relation
- Summary and report
- Initial hypothesis, problem definition
- Graphs and charts for a start
- Maps and tests to keep track
- Description and explanation
- Analysis and pictures/images
- Presenting results
- Positioning, Slide usage, information transmition
- 5 second rule
- Highlight, focus and importance scaling
- Dashboard, Business Inteligence, Update window
- Conclusions
- Proposals
- Listen and amplify
- Correct and enhance