Results
● The user evaluation feedback was broken down into 5 key themes
● Following the user evaluation was a dashboard enhancement phase
Background to the Project
● Came of interest during my internship with Baker Hughes
● Gained understanding of the company’s problem situation
● Baker Hughes made a commitment in 2019 to half their emissions by 2030 and achieve carbon net-zero by 2050
● Company lacks visibility in tracking their facilities energy consumption
● Beneficial to work on a real-life project with a client and requirements
Project Aims
1. Develop a data platform to capture and display the energy usage values in an easily read and distributed format
2. Conduct a user evaluation to ensure the product meets the clients’ requirements
3. Provide a tool which can be used to determine recommendations on how the company can reduce their carbon emissions.
Project Objectives
1. Conduct literature review to investigate and analyse visualisation platforms, current systems used, data transformation/mining and dashboard design/best practices
2. Research the global problem of energy
3. Perform data transformation as part of the data analysis
4. Develop a data platform where the data can be stored
5. Develop a dashboard allowing the values to be filtered by site and by energy type, with tags for country and region.
6. Perform a series of think-aloud studies to collect qualitative feedback
7. Adapt to feedback and comments from the client throughout the project
8. Map out the energy usage across all PPS sites
9. Provide recommendations for the company in terms of future improvements in data reporting
Research
Literature Review
● The Global Problem Of Climate Change
● Business Intelligence
● Dashboard Best Practices
● Analysis Of Visualisation Platforms
● Relevant Examples Of Dashboards
● Baker Hughes Problem
Methodology
● Theoretical Method Used
● Quantitative Analysis – Energy Data
● Qualitative Analysis – User Evaluation Data
● Data Collection Techniques
● Thematic Analysis
● Inductive, Bottom Up Approach
Dashboard Implementation
● Practical work began by gathering, cleansing and transforming the data
● Chosen visualisation platform was PowerBI
● Most appropriate dashboard structure was to display the data regionally
● Layout followed an F shape - the most emphasised areas on a page
● Dashboard follows best practices as researched during the literature
● Colours and fonts had to follow Baker Hughes brand palette
Investigation - User Evaluation
● Think-aloud studies with participants from Baker Hughes
● Participants had varied levels of experience and different departments
● Saturation was met after the 3rd session / participant
● Sessions were recorded, transcribed, printed, annotated and coded
● Themes and patterns were identified and analysed
Evaluation
Practical Work
Strengths Weaknesses/ Areas for future work
● Mapped energy usage
● Saturation reached
● Positive feedback from users
● Dashboard enhancement phase
Project Process
● Data processing is still a manual process
● Dashboard only allows region comparison
● Lack of data from previous years
● PowerBI interface
I have developed a variety of skills throughout the project including:
● Project management
● Data cleansing
● Dashboard design
● Communication
● Identifying in scope and out of scope enhancements
● Requirements gathering
● Using initiative
Conclusions/Future Work
● Overall, the project was a success with the aims and objectives met, and the dashboard aligned with the clients’ requirements.
● The dashboard allows the business to make more formalized decisions going forward by implementing initiatives in sites according to initiatives that have been successful in other sites
● Future work could involve automating the data processing, and getting data from previous years to have more granularity.
Bibliography
• Baldwin, D. and Stirrup, J. (2016) Visualization Best Practices and Dashboard Design, in Mastering Tableau. United Kingdom: Packt Publishing, Limited.
• Han, J., Kamber, M. and Pei, J. (2012) Data Mining: Concepts and Techniques. Waltham, Ma: Morgan Kaufmann.
• Pickard, A.J. (2017) Research methods in information. Facet
Using Business Intelligence to quantify, track and produce reporting to support carbon reduction at Baker Hughes Process and Pipeline Services (PPS).
Ellie Langdown, Information Technology Management for Business, Department of Computer and Information Sciences