Project information

  • Category: Microsoft Power BI
  • Description: Community Project
  • Project date: July, 2022
  • Project URL: Github

Assets Data Analysis of Javaglonema Millenials.

The Aglonema Farmers Group named Javaglonema Millennial which is located in Paten, Tridadi, Sleman, DI Yogyakarta. Javaglonema Milenial already has 83 farmer members.

Microsoft Power BI:
  1. Extract Data: csv, excel, spreadsheet.
  2. Transform Data: filter, rename, add, remove query table.
  3. Load Data: analyze transformed data.
  4. Data storytelling: visualize and get the insight of data analytics.
Step:
  1. Extract Data

    2. Tools: Microsoft Excel/Google Spreadsheet
    Extract data from data retrieval in July 2022 with xls/csv format.

  2. Transform Data

    3. Tools: Microsoft Power BI
    Explore data to transform data according to analysis requirements.

  3. Load Data

    4. Tools: Microsoft Power BI
    Take selected data for the data analysis process.

  4. Data storytelling

    5. Tools: Microsoft Power BI
    Visualize and get the data analysis insights.
    Slide 1: The total plant assets owned by all farmer members in July 2022 are 1704 plants. Farmer members who have the 5 most plants are Nurul Amin, Johan Enry, Sri Widayati, Endah Darwanti, and Didik Sriyanto. Other members visualized in light blue are members have met the target of 25 plants. It is hoped that the member's assets will not decrease. Meanwhile, farmer members visualized in gray are farmer members who have not reached the target, meaning that they do not have at least 25 plants yet.

    Slide 2: Based on data analytics, it can be seen that the most aglonema plant production assets are Legasi Merah with a total of 344 plants. Followed by the types of plants Red Anjamani, Suksom, Red Queen, and Dud White. The least number of aglonema production was red cherry with total 12 plants.

    Slide 3: Types of plants favored by members of the farmer are Legasi Merah planted by 75 members, followed by Suksom, Red Queen, Red Anjamani, and Dud White. While Red Cherry is only planted by 9 members. This is validated by the members because legasi merah is easy to maintain and the market is good. Meanwhile, red cherry is the most sensitive type of aglonema and is difficult to treat, so it is vulnerable to death. This can be considered in determining the selling price when the plants begin to be marketed.