Find Jobs
Hire Freelancers

Deforestation project

$30-250 USD

Đang triển khai
Đã đăng vào hơn 3 năm trước

$30-250 USD

Thanh toán khi bàn giao
Introduction You’re a data analyst for ForestQuery, a non-profit organization. on a mission to reduce deforestation around the world and which raises awareness about this important environmental topic. Your executive director and her leadership team members are looking to understand which countries and regions around the world seem to have forests that have been shrinking in size, and also which countries and regions have the most significant forest area, both in terms of amount and per cent of total area. The hope is that these findings can help inform initiatives, communications, and personnel allocation to achieve the largest impact with the precious few resources that the organization has at its disposal. You’ve been able to find tables of data online dealing with forestation as well as total land area and region groupings, and you’ve brought these tables together into a database that you’d like to query to answer some of the most important questions in preparation for a meeting with the ForestQuery executive team coming up in a few days. Ahead of the meeting, you’d like to prepare and disseminate a report for the leadership team that uses complete sentences to help them understand the global deforestation overview between 1990 and 2016. Steps to Complete Create a View called “forestation” by joining all three tables - forest_area, land_area and regions in the workspace. The forest_area and land_area tables join on both country_code AND year. The regions table joins these based on the only country_code. In the ‘forestation’ View, include the following: All of the columns of the origin tables A new column that provides the per cent of the land area that is designated as forest. Keep in mind that the column forest_area_sqkm in the forest_area table and the land_area_sqmi in the land_area table are in different units (square kilometres and square miles, respectively), so an adjustment will need to be made in the calculation you write (1 sq mi = 2.59 sq km). Instructions You will be creating a report using complete sentences for the executive team. You can use the provided template and work through each section. There are 5 parts to the report you will be working on completing. Global Situation Regional Outlook Country-Level Detail Recommendations Appendix: SQL queries used You will be submitting a PDF version of your report for review.
Mã dự án: 27899823

Về dự án

2 đề xuất
Dự án từ xa
Hoạt động 3 năm trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
2 freelancer chào giá trung bình $145 USD cho công việc này
Avatar người dùng
Hi I have done many programming and technical projects. Kindly contact to share more details about your project in chat. Thank you
$40 USD trong 7 ngày
4,9 (3 nhận xét)
4,6
4,6
Avatar người dùng
I can efficiently develop required reports for each of researching parts. I am Senior SQL/BI Developer with 10+ years of exceptional experience and having strong expertise in professional development of complex queries and reports.
$250 USD trong 2 ngày
5,0 (28 nhận xét)
4,6
4,6

Về khách hàng

Cờ của SAUDI ARABIA
Dammam, Saudi Arabia
5,0
2
Phương thức thanh toán đã xác thực
Thành viên từ thg 10 1, 2019

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.