Introduction to Data Management & Reporting (Live Stream)
Mention the word “analytics” and images of pretty charts, complex analyses and/or pivotal insights come to mind. But those are only some of the more visible and sexy aspects of analytics; there is much more to the analytics value chain. The analytics value chain really starts with data; data that is curated and extracted across disparate sources, cleaned, validated, processed, and stored in a manner that is accessible for analytics. A lot of work goes into data management and processing before analytics can even start.
This workshop aims to provide a broad but practical overview of the entire analytics value chain, with a specific focus on data management and processing. Delegates will get the opportunity to get their hands “dirty” with large data sets and experience what it takes to process and manage data to deliver objective insights, which include the building and maintenance of interactive reports. This is targeted at professionals and managers in non-analyst roles but may be required to work with or manage data and reporting in their work.
Data Analytics Series Overview
There has been growing interest in analytics over the past decade; particularly how data can be leveraged to create value for organizations through analytics, by augmenting and improving the decision-making processes. To the point where many organizations have sought to build core competencies in analytics to fuel their growth. Contrary to popular belief, it takes more than hard data and technology capabilities to succeed in analytics; it takes the right combination of hard and soft skills to capitalize on the data advantage.
This is ONE of FOUR virtual workshops that make up a comprehensive curriculum on Analytics. Each workshop is modular in nature, addressing different aspects along the analytics value chain.
- Data Management and Reporting – focuses on processing and managing data to deliver insights
- Data Analysis – focuses on the technical aspects of mining data for objective insights
- Data Visualization – focuses on presenting data inaccessible forms to get the right message across using data visualizations
- Data Storytelling – focuses on presenting analyses and proposals in a concise, coherent, and compelling fashion to facilitate decision-making
- Develop a comprehensive understanding of the end-to-end analytics process applicable to problem-solving
- Appreciate the role of Data Management in the analytics value chain
- Develop technical skills in data management, data preparation and transformation to optimise the analysis process
- Equip yourself with data visualisation skills to build interactive dashboards and infographics
- Practice your data management and reporting skills on a business case during a facilitated capstone exercise
- Analysts or Professionals with data management and reporting responsibilities; and/or looking to pick up new tips and tricks to enhance their skills in data management and reporting
- All other professionals with a keen interest in developing strong foundations in data analytics
Participants are required to bring their own laptops with MS Excel and Powerpoint (version 2013 or later) to participate in the data and capstone exercise.
1. What is Analytics and what it takes to create a sustainable value chain
- This segment seeks to define what analytics is and isn’t, why it matters in today world and what it takes to build sustainable value.
- Delegates will also be introduced to the analytics value chain
Translating data to insights and insights into decisions
- This segment provides an overview of the six-step approach to conducting analytics. Delegates will see how the analytics process really works and seeks to dispel several myths about the process
Data Management: Preparation and Transformation
- This segment focuses on one of the precursors to any data analytics activities – data preparation. This is largely a hands-on session with multiple computer-aided exercises on a wide range of HR-related problems. Attendees will get to prepare sizable data sets for data analytics, which include
- Merging multiple data tables
- Understanding the use of system vs calculated data fields
- This will include the use and application of several key functions and tools within MS Excel
- Once the data is prepared and transformed, it needs to be ready for analytics. One very effective way to capitalize on data is through reports; more specifically interactive reports where users can see metrics and trends relevant to their areas.
- This is a computer-aided session to build the key skills to design and build interactive dashboards and infographics with MS Excel
- Principles of data visualization
- Design and build interactive data visualizations
- Demo: Data visualization tools (e.g. Tableau, PowerBI)
- Class exercise: Building interactive HR Dashboards with MS Excel
Data Expert: Michael Lee
Michael Lee is an associate of FYT Consulting Pte Ltd. An IT professional by training with more than 25 years of consulting & practical experience across many functions (sales, client management, business operations & customer service) throughout various roles (Vendor, Systems Integrator, Distributor and Enduser) in both the public & private sector.
Prior to joining FYT Consulting, Michael has done consultancy and process re-engineering for several SMEs. He has also conducted numerous training sessions on Virtual Teaming for international banks and corporations. In addition, he has made many speaking engagements in Customer & Partner events, as well as in major international Sales Conferences.
Michael has managed the Asia Pacific Sales Operations for Linksys, a division of Cisco Systems. His portfolio included the day-to-day operations within the Asia Pacific. He was also running the China sales for almost a year. Prior to that, Michael led the Asia Pacific Sales Operations for Cisco System and the Business Operations for Customer Service in Asia Pacific & Japan in Cisco. In addition, he headed a global Metrics & Business Intelligence team comprising members from the Asia Pacific, Europe and the Americas. Before joining Cisco, Michael worked for Peoplesoft, AT&T GIS, SAP and National Computer Systems (SCO). Michael holds a Bachelor’s degree in Computer Science & Mathematics as well as an MBA from the National University of Singapore
Data Expert: Joanna Tan
A seasoned leader in Human Resource Business Partnering with more than 25 years of diverse industry, Joanna has experience with reputable multinational and local corporations such as Sage Software, Hasbro, Apple, IBM, Rockwell Automation and Wing Tai Holdings. She has proven success in managing and rolling out major organization change initiatives involving various key stakeholders especially with the sales and marketing teams in driving revenue and margin optimization using business metrics and intelligence.
Joanna currently consults and leads engagements to help FYT clients build HR analytics capabilities across many sectors and regions, including technology, government, pharmaceutical, sales & finance across the Asia Pacific Region. She also has a strong background in talent management and development, organization design, change management as well as employee engagement. Joanna holds a Bachelor’s Degree in Arts with National University of Singapore and a Graduate Diploma in Business Administration with Singapore Institute of Management. In addition, she is accredited in Advanced Certificate in Training and Assessment (ACTA v5).
“Mike is very experienced and the entire course is very interactive. Mike also putting great effort to ensure the team is engaged. Recommended trainer as the entire course is not bored, useful material and there is video in between to refresh the mind.”
Lo Siew Khim, Advanced Micro Devices
“Michael is very engaging and takes the effort to solicit responses from all participants. He also makes the effort to take note of each participant’s progress through the course to ensure that all can follow. This course is useful for ministry executives who are new to data analytics.”
Esther Chan, Ministry of Social and Family Development
“Michael is very clear in his teaching, and is very patient! This is the first IT-related course I have attended where I did not feel like the instructor was impatient with people who may be slower in their progress.”
Nicole Hilary Teo, National Heritage Board
“Mr Michael Lee is very knowledgeable on the topic. The experience was beyond my expectation. I expected a lecture, but it was an interactive two way approach with hands on practise & exercises. There are many good takeaways from the session.”
Nur Zalifa Andeera Binte Fadzillah, MyLustre Pte Ltd