Data Analytics Projects

Data Analytics Projects

Learning Objective

  • Identify the stages involved in preparing for a data analytics project.

Introduction

  • The 'Data in Business' course emphasized leveraging data analytics to enhance business value.

  • Development of a data culture is pivotal for placing data at the core of decision-making.

  • Focus is on management's role to ensure value from specific data analytics projects.

  • Distinction between analytics done by finance professionals and those requiring IT specialists.

  • Importance of finance professionals’ understanding, even if they are not directly performing the analytics.

Critical Thinking for Data Analysis

  • Definition: Critical thinking is disciplined reasoning; it involves logically forming conclusions, judgments, or inferences from facts.

  • Core skill for finance professionals.

  • According to Dzuranin, Geerts, and Lenk in Data and Analytics in Accounting: An Integrated Approach, critical thinking is vital during data analytics projects, encompassing six elements remembered by the mnemonic SPARKS.

SPARKS Elements

  1. Stakeholders: Understand expectations from the analysis to provide context for planning and communication of findings.

    • Internal stakeholders: Managers and employees involved in business operations.

    • External stakeholders: Investors, creditors, regulators, business partners, community members.

  2. Purpose: Clarify why the analysis is being performed to define specific questions and ensure focus.

  3. Alternatives: Identify options available for the analysis to make informed choices.

    • Consider various angles to answer the core questions.

    • Rank alternatives for optimal selection.

  4. Risks: Identify potential risks at the onset, mitigating them effectively.

    • Risks may include:

      • Incorrect data selection.

      • Incomplete or erroneous datasets.

      • Data biases.

      • Assumptions inherent in data choices.

      • Analytical method errors.

      • Incorrect analysis performance.

      • Misinterpretation of results.

  5. Knowledge: Assess the knowledge base needed for analysis.

    • Ensure proficiency in relevant tools and contextual understanding of data factors.

  6. Self-Reflection: Reflect on past project issues to inform current analyses.

    • Learn lessons from previous projects to improve future outcomes.

Preparing for a Data Analytics Project

  • Preparation is crucial for delivering on project goals to provide reliable and actionable insights.

  • Key steps in preparation require collaboration from finance professionals:

    1. Defining project objectives.

    2. Framing the problem.

    3. Evaluating business capabilities.

    4. Gathering specific requirements.

    5. Developing a data analytics strategy.

Example: SGC Company Case Study

  • Background: SGC is a medium-sized enterprise planning a revenue growth analysis.

  • Meeting scheduled in six weeks to discuss findings.

  1. Defining the Objectives:

    • Clarity on business goals is essential for meaningful outcomes.

    • Objectives identified include:

      • Understanding drivers of current revenue levels.

      • Identifying data-driven solutions for growth.

      • Producing future revenue forecasts within a timeframe.

      • Communicating findings to stakeholders.

    • Validation by stakeholders post-definition.

  2. Framing the Problem:

    • Understand stakeholder motivations to define project scope.

    • Investigate key stakeholder expectations to ensure relevant analysis.

    • Proposed questions include:

      • What exactly needs to be known?

      • Previous solutions and their satisfaction levels?

      • Required accurate answer levels?

      • Presentation formats for findings?

      • Action plans for obtained answers?

    • Supplemental data considerations include industry, legal, socio-economic, political, and environmental factors.

  3. Evaluating Existing Capabilities:

    • Data:

      • Audit of current data resources and identify needs.

      • Stakeholder identification for data access.

    • Analytics:

      • Assess the adequacy of existing analytic setups.

      • Determine needs for further investments in analytics tools based on costs vs. insights.

    • Cost-Benefit Analysis:

      • Assess if insights gained will outweigh costs.

      • Costs to consider include software, data preparation, computing resources, and interpretation of findings.

    • Illustrative questions for SGC’s analytics team to consider regarding data and analytics capabilities.

  4. Gathering Specific Requirements:

    • Clarity on the analysis scope allows drilling down into stakeholder requests.

    • Specific questions aimed at clarifying the precise formats of the answers should be validated by management.

    • Ethical constraints and operational parameters should be woven into project requirements.

    • Agreements on timeframes, performance metrics, and result presentation formats are essential at this stage.

  5. Developing a Data Analytics Strategy:

    • Stage for deciding datasets, resources, and analytical processes.

    • Forms of analytics could include descriptive, diagnostic, and predictive analytics.

    • Specific tools determined for data interpretation and analysis.

    • Allocation of time towards ensuring objectives are achieved post-analysis.

Conclusion

  • Ensuring thorough preparation for data analytics projects lays the groundwork for successful analysis outcomes and the generation of business value.

  • Upcoming topics will explore how best to present findings to stakeholders, focusing on data visualization tools and techniques.