USEA Data Collection Workshop Promoting industry-led off-grid solar - - PowerPoint PPT Presentation

Off-Grid Solar USEA Data Collection Workshop

Promoting industry-led off-grid solar market development through reliable and accurate market data in Uganda

.Agenda

Time Activity 8:30 hrs. - 09:00 hrs. Arrival and Registration + tea/coffee 09:00 hrs. - 09:30 hrs. Opening ceremony: Prayer Welcome addresses by: USEA Chairman & USEA CEO Introduction of consortium participants 09:30 hrs. – 10:15 hrs. Introduction Round Participants and Participatory Exercise 10:15 hrs. - 10:45 hrs. Presentation Scoping for a Uganda Sales Data Collection 10:45 hrs. – 11.30 hrs. Facilitated discussion amongst members addressing comments, questions and remarks 11:30 hrs. – 12 hrs. TEA/COFFEE BREAK 12:00 hrs. – 12:30 hrs. Presentation Technical Part for a Uganda Sales Data Collection 12.30 hrs. – 13:15 hrs. Facilitated discussion amongst members addressing comments, questions and remarks 13:15 hrs. – 13:30 hrs. Thanks & Closing remarks 13:30 hrs. – 14:30 hrs. LUNCH BREAK & CLOSURE

Introduction of the consortium

Emmy Kimbowa – Chairman, USEA Board

Joyce Nkuyahaga – CEO, USEA

Julius Magala, UNCDF

Innocent Kwagala, UNCDF

Patrick T

• nui & Silvia Francioso, GOGLA

Astrid Van Lierde & Lucio Melito Dalberg Data Insights (DDI)

USEA

USEA Members UNCDF GOGLA

• Overall owner of the

exercise

• Relationship with

respondents/members

• Beneficiary of reporting

Key Stakeholders

• Data Provision
• Beneficiaries of

reporting

• Funding and staffing

(Innocent) to support locally

• Coordination and

project management

• Support throughout

based on global experience (both process- and content- wise)

Dalberg

• T

echnical support to make the data collection happen

• Data Governance and

Security

Scoping for Uganda Solar Sector Data Collection

By Joyce Nkuyahaga

Key points to address

• Rationale for Data Collection – why USEA is proposing this pilot
• Benefits of participation for USEA and its members
• Roles Outlined – what each partner is bringing to the table
• Eligible products for the market sales data pilot
• Scoping Outcomes – what data is under scope and how we aim

to segment it

• Timeline and Next Steps
• Feedback round!

Solar Sector

• Need for more robust evidence and information about the contribution
• f solar energy to Uganda’s electrification status.
• More granular data collection than the global one by GOGLA and

Lighting Global. Local Data with special details of the country

• Interest from investors, government, Ministry , REA and other

stakeholders

• Members to understand their individual contribution to the sector and

benchmark themselves against the sector.

USEA

• Grow membership value
• Have strong evidence to support advocacy
• Understand the socio-economic impact of solar products on the general

population

• Build capacity and strenghten skills for its members

Data Collection Rationale

Benefits of Data Collection

For Members

• Improved data on the Status of the

Market (e.g. more granular geographically, more companies involved)

• Understand their market share in

comparison to all USEA members

• Companies can base strategic

decision on robust and detailed information

• Relationships builder with association

For USEA

• National Association can base

their advocacy on sound evidences in a sustainable way.

• Conversation with the members

enable deeper understanding of needs and motivations

• Trust between association and

members is strengthened

• National Association can build

strengthen and extend its skills

• Attract new members

Eligible Products

The focus of the exercise is on off-grid solar system with wattage no more than 5kWp Complete systems are considered; the products sold should include at least a battery pack and a panel of a fixed size.

Data will not be collected on single components in this first pilot (e.g. panels sold without a battery, battery sold without a panel, inverters or charge controller) – inclusion of such products may be scoped in future rounds.

Scoping Outcomes - Questionnaire

. Have comprehensive records, with the rest undergoing processes to establish it Engaged in GOGLA or PAUESA Data Collection Solar companies Participated in the survey Agreed to participate in a data collection if conducted by USEA Agreed to further discuss, to address data security concerns Have never participated in a formal data collection before

37 80% 40% 60% 86% 100%

Pilot - Expected Outcomes

RESPONDENTS

• all USEA members selling

complete off-grid solar system (appliances or component-based won’t be in the scope of this first pilot) METHOD

• GOGLA advised on the

methodology

• DDI provides technical

support WHAT DATA

• Sales data for 2018
• Data segmented in first and

second half of 2018

• Regional breakdown of the

sales (Central, Eastern, Northern and Western) PRODUCT

• Product specifications to aid

segmentation E.g. portable lanterns, multi-light systems and solar home systems HISTORICAL

• Sales for 2017, 2016 and

2015.

• If available

OUTCOMES

• Online reporting tools with

aggregated and company dashboards

Data Security & Privacy

• Data confidentiality and trust between USEA Secretariat and

the members are the key of the success of this exercise.

• Company data will be only reviewed during the quality control

and data processing by a limited amount of individuals identified and highlighted in the Data Governance Protocol and Non Disclosure Agreements that will be developed by Dalberg Data Insights (DDI).

A Data security presentation will be given after the tea/coffee break by DDI!

Timeline and Next Steps

ACTIVITY MONTH PDF Version of the questionnaire shared for companies to prepare data 5th of April Data Governance Protocol shared to companies for reference 5th of April Online data collection launch and account management 12th of April Submission Deadline 26th of April Quality Control and Data Processing April - May

Feedback Round I

• 1. Let’s imagine that the questionnaire is ready and online. What would make you fill the survey

tomorrow? And what would stop you?

• 2. Eligible products for this pilot are complete solar systems with a battery and a panel of less than 5
• kWp. Is it clear?
• 3. After you heard all of that, is there anything you wish to be included? We will note all the points for

minor improvements of this pilot and future rounds. Please hold your thoughts/comments on data security as they will be discussed right after the next presentation!

• I. DATA GOVERNANCE – PROCESS OVERVIEW

• II. DATA GOVERNANCE – ACCESS OVERVIEW

• II. DATA GOVERNANCE – COMPANY DATA ACCESS FOR DATA

PROCESS PURPOSES

• II. DATA GOVERNANCE – COMPANY DATA ACCESS FOR DATA

PROCESS PURPOSES

AGGREGATED REPORTS NEWS FEED

Silvia Francioso Data Analyst

 content support for data quality check  technical assistance for members’ support

OPT IN

Lucio Melito Data Scientist

 Perform data processing  Produce data reporting

Joyce Namakoye CEO

 Support to Members

Innocent Kwagala Project Manager

 content support for data quality check  account mgmt assistance for members’ support

Julius Magala Project Supervisor PLATFORM OWNERSHIP => Access to platform and credentials

LEGALLY PROTECT COMPANY DATA PRIVACY & SECURITY under THE STRICT PURPOSES ABOVE

NDA NDA

PROTOCOL

• III. DATA GOVERNANCE – OVERVIEW ACCESS

THREE-DATA POINT METHODOLOGY

• Min. 3 manufacturers per region

and product category

• If < 3: NO public results

*Limited Access to Aggregated Data: Per specific request basis to USEA

• I. DATA SECURITY - OVERVIEW

ACTIVITY OUTPUT FILL IN QUESTIONNAIRE

MARKET INFO

PROVIDE MARKET INFO PLATFORM USER DESIGNATED MEMBER LEVERAGE INFORMATION

VIEW DATA RIGHTS EDITING DATA RIGHTS

….

COMPUTING DATA RIGHTS QUALITY CONTROL

DATA PROCESSING AGGREGATION METHODOLOGY

INFRASTRUCTURE # 1 INFRASTRUCTURE #2

MEMBERS SUPPORT

INVESTORS

INFRASTRUCTURE #3

• IV. DATA SECURITY - OVERVIEW

INFRASTRUCTURE # 1 INFRASTRUCTURE #2 INFRASTRUCTURE #3

DATA BACKUP HOSTING DATA UPLOADING DASHBOARDS DESIGN COMPUTATION & AGGREGATION DASHBOARDS VISUALISATION ACTIVITIES INFRASTRUCTURE  PRIVATE LINK  RESTRICTED ACCESS  PRIVATE NETWORK  USERNAME  PASSWORD  FIREWALL  ENCRYPTED KEY ACCESS  FIREWALL  USERNAME  PASSWORD  USER ACCOUNT  PASSWORD  CREDENTIAL S  SEPARATE PORTAL ACCESS SECURITY & PRIVACY MEASURES  FIREWALL  USERNAME  PASSWORD QUESTIONNAIR E DDI SERVER DATABASE TABLEAU DDI PORTAL

INFRASTRUCTURE #1 INFRASTRUCTURE #2 INFRASTRUCTURE #3

• IV. DATA SECURITY - INFRASTRUCTURE

• V. DATA REPORTING – QUESTIONNAIRE SAMPLE

Figure 1: Data Collection Questionnaire Screenshot

• V. DATA REPORTING – PLATFORM MOCKUPS 1/4 *

Data Collection Platform

Off Grid Solar System

ALL COMPANIES MY COMPANY NEWSFEED

2015 2016 2017 2018 2019 2020

DOWNLOAD MY COMPANY DASHBOARD

*For reference only – final design and features workmap of the dashboards will be elaborated after data collection

Data Collection Platform

Off Grid Solar System

ALL COMPANIES MY COMPANY NEWSFEED

2015 2016 2017 2018 2019 2020

DOWNLOAD MY COMPANY DASHBOARD

MARKET PERFORMANCE

*For reference only – final design and features workmap of the dashboards will be elaborated after data collection

• V. DATA REPORTING – PLATFORM MOCKUPS 2/4 *

Data Collection Platform

Off Grid Solar System

ALL COMPANIES MY COMPANY NEWSFEED 2015 2016 2017 2018 2019 2020

DOWNLOAD ALL COMPANIES DASHBOARDS

*For reference only – final design and features workmap of the dashboards will be elaborated after data collection

• V. DATA REPORTING – PLATFORM MOCKUPS 3/4 *

Data Collection Platform

Off Grid Solar System

Joyce Namakoye

ALL COMPANIES MY COMPANY NEWSFEED

Posted on the 6th of February 2019 Hi Community! Check this interesting article:

John

Posted on the 2nd of February 2019 Hi Community! USEA is organizing a workshop on data sales collection on the 8th of February 2019. Please register here if interested to participate

• V. DATA REPORTING – PLATFORM MOCKUPS 4/4 *

*For reference only – not part of the scope of the pilot

• VI. PLATFORM SUSTAINABILITY – LONG TERM

VISION

OBJECTIVES:

• Scale Up data collection for all the off-grid solar companies in Uganda
• Maintain the platform on the long term for better decision making by providing

insights on current situation vs previous and measure impact

• Increase chances for the sector to receive more adapted support and investment

(financial, capacity building, ressources…)

• Build a strong relationship among USEA’s members and USEA’s secretariat

PROCESS:

• Provide training to USEA to maintain the platform
• Enhance data collection process ( e.g: questionnaire embedded within the platform,

automatized data quality control) to increase collection round frequency over time and decrease effort level required

• Enhance platform features through user-centric design

BUILD A SUSTAINABILITY PLAN BASED ON PILOT SUCCESS

Feedback Round II

Guideline questions for discussion:

• 1. Do you feel more confident now that the environment where your data will be collected is

safe and secure? And will protect your data privacy?

• 2. Do you think about other measures we could deploy to make you feel more confident?
• 3. Do you feel the data privacy is sufficiently addressed?

. . Thank you

For More Information Contact us at:

+256200923345 info@useaug.org

Please do not forget to fill in the evaluation form!