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

Time Activity 8:30 hrs. - 09:00 hrs. Arrival and Registration + tea/coffee Opening ceremony: Prayer 09:00 hrs. - 09:30 hrs. Welcome addresses by: USEA Chairman & USEA CEO Introduction of consortium participants . Agenda 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 onui & Silvia Francioso, GOGLA

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

Key Stakeholders USEA USEA Members UNCDF GOGLA Dalberg Overall owner of the Funding and staffing • • • Support throughout • T echnical support to Data Provision • exercise (Innocent) to support based on global make the data collection Beneficiaries of • locally experience (both happen • Relationship with reporting process- and content- respondents/members • Coordination and Data Governance and • project management wise) • Beneficiary of reporting Security

Scoping for Uganda Solar Sector Data Collection By Joyce Nkuyahaga

• 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 Key • Eligible products for the market sales data pilot points to • Scoping Outcomes – what data is under scope and how we aim address to segment it • Timeline and Next Steps • Feedback round!

Data Collection Rationale • Need for more robust evidence and information about the contribution of solar energy to Uganda’s electrification status. • More granular data collection than the global one by GOGLA and Solar Lighting Global. Local Data with special details of the country Sector • Interest from investors , government , Ministry , REA and other stakeholders • Members to understand their individual contribution to the sector and benchmark themselves against the sector. • Grow membership value • Have strong evidence to support advocacy USEA • Understand the socio-economic impact of solar products on the general population • Build capacity and strenghten skills for its members

Benefits of Data Collection • National Association can base For Members For USEA • Improved data on the Status of the their advocacy on sound Market (e.g. more granular evidences in a sustainable way. geographically, more companies • Conversation with the members involved) enable deeper understanding of • Understand their market share in needs and motivations comparison to all USEA members • Trust between association and • Companies can base strategic members is strengthened decision on robust and detailed • National Association can build information strengthen and extend its skills • Relationships builder with association • Attract new members

Eligible Products Data will not be The focus of the Complete systems are collected on single exercise is on off-grid considered; the components in this first solar system with products sold should pilot (e.g. panels sold wattage no more than include at least a without a battery, 5kWp battery pack and a battery sold without a panel of a fixed size. panel, inverters or charge controller) – inclusion of such products may be scoped in future rounds.

Scoping Outcomes - Questionnaire 37 80% 40% 60% 86% 100% Solar Have Have never Engaged in Agreed to Agreed to . companies comprehensive participated in GOGLA or participate further Participated in records, with the a formal data PAUESA Data in a data discuss, to the survey rest undergoing collection Collection collection if address data processes to before conducted security establish it by USEA concerns

Pilot - Expected Outcomes RESPONDENTS METHOD WHAT DATA • all USEA members selling • GOGLA advised on the • Sales data for 2018 complete off-grid solar methodology • Data segmented in first and system (appliances or • DDI provides technical second half of 2018 component- based won’t be support • Regional breakdown of the in the scope of this first pilot) sales (Central, Eastern, Northern and Western) PRODUCT HISTORICAL OUTCOMES • Product specifications to aid • Sales for 2017, 2016 and • Online reporting tools with segmentation E.g. portable 2015. aggregated and company lanterns, multi-light systems dashboards • If available and solar home systems

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 5 th of April PDF Version of the questionnaire shared for companies to prepare data 5 th of April Data Governance Protocol shared to companies for reference 12 th of April Online data collection launch and account management 26 th of April Submission Deadline 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 OPT IN Lucio Melito Silvia Francioso Data Scientist Data Analyst Joyce Namakoye  content support for data CEO  Perform data processing quality check NEWS  Produce data reporting  technical assistance for FEED members ’ support  Support to Members Innocent Kwagala Julius Magala Project Supervisor Project Manager PLATFORM OWNERSHIP AGGREGATED => Access to platform and REPORTS credentials  content support for data quality check  account mgmt assistance for members ’ support NDA NDA PROTOCOL LEGALLY PROTECT COMPANY DATA PRIVACY & SECURITY under THE STRICT PURPOSES ABOVE

III. DATA GOVERNANCE – OVERVIEW ACCESS *Limited Access to Aggregated Data: Per specific request basis to USEA THREE-DATA POINT METHODOLOGY • Min. 3 manufacturers per region and product category • If < 3: NO public results

I. DATA SECURITY - OVERVIEW MEMBERS SUPPORT INFRASTRUCTURE #2 COMPANY DATA PROVIDE MARKET INFO MARKET INFO QUALITY CONTROL DATA FILL IN PROCESSING QUESTIONNAIRE AGGREGATED AGGREGATION DATA METHODOLOGY COMPANY 1 CONTENT AGGREGATED MENU REPORTING SECTOR REPORT LEVERAGE ALIGNED ACTIONS INFORMATION COMPANY 2 …. INFRASTRUCTURE # 1 INVESTORS COMPANY 3 PLATFORM USER ACTIVITY INFRASTRUCTURE #3 OUTPUT DESIGNATED MEMBER VIEW DATA RIGHTS EDITING DATA RIGHTS COMPUTING DATA RIGHTS

IV. DATA SECURITY - OVERVIEW INFRASTRUCTURE #2 INFRASTRUCTURE # 1 INFRASTRUCTURE #3

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

V. DATA REPORTING – QUESTIONNAIRE SAMPLE Figure 1: Data Collection Questionnaire Screenshot