Act as a Data Analyst for a non-profit organization on a mission to reduce deforestation around the world and which raises awareness about this important environmental topic.
Prepare a report for the executive team to understand the global deforestation overview between 1990 and 2016. Identifying the most concerning regions and countries experiencing severe drop in forest area to determine where to concentrate efforts to combat deforestation.
Techniques used: Create View, Table; Boolean Operators; Aggregations, Window Functions, Joins, CASE Statements
- Execute core SQL commands to define, select, manipulate, control access, aggregate and join data tables.
- Understand when and how to use subqueries, window functions as well as partitions to complete complex tasks.
- Clean data, optimize SQL queries and write select advanced JOINs to enhance analysis performance.
- Explain which cases to use particular SQL commands and apply query results to address business problems.