Business Intelligence

Designing an Analytical Flow

  • To propose and design a data story based on client needs, these will be the steps for success:
    • Understand client needs and objectives: Begin by discussing the client’s goals, challenges, and expectations. Identify the key questions they want to answer or the insights they are seeking. Make sure you have a clear understanding of the business context and industry to make your analysis relevant and actionable.
    • Gather and analyze data: Obtain relevant data from the client or other sources that can help address the client’s needs. Perform data cleaning, preprocessing, and exploration to understand the structure, relationships, and patterns within the data. Identify key variables and metrics that will drive your analysis.
    • Develop initial hypotheses: Based on your understanding of the client’s needs and the data, formulate initial hypotheses or questions to guide your analysis. These should be focused on the client’s objectives and should help you determine the most relevant analytical approaches to use.
    • Select analytical methods and tools: Choose appropriate analytical methods and tools to address your hypotheses and answer the client’s questions. This could include descriptive statistics, data visualization, predictive modeling, clustering, or other techniques depending on the problem and data.
    • Perform the analysis: Conduct the analysis using your chosen methods and tools, carefully documenting your process and results. Be prepared to iterate and refine your analysis as needed based on new insights, data limitations, or feedback from the client.
    • Identify key insights and patterns: Summarize the findings from your analysis, highlighting the most important insights, trends, and patterns that address the client’s needs. Ensure that these findings are relevant, actionable, and supported by the data.
    • Design the data story: Organize your insights and findings into a coherent narrative or analytical flow. This should guide the audience through the data, addressing the client’s questions, and presenting the insights in a clear and logical manner. Use appropriate visualizations and clear language to communicate the findings effectively.
    • Iterate and refine the story: Share your initial data story with the client and gather feedback. Be prepared to iterate and refine your story based on their input, making sure it aligns with their objectives and effectively communicates the insights.
    • Present and communicate the data story: Present the final data story to the client, using clear visuals, concise language, and a compelling narrative to engage the audience and communicate the insights. Be prepared to answer questions, provide additional context, or offer recommendations based on your analysis.
    • Measure success and follow up: After presenting the data story, work with the client to measure the success of the project and determine any follow-up actions or next steps. This could include monitoring the impact of the insights on the client’s business, refining the analysis based on new data, or exploring additional questions and opportunities.

Key Performance Indicators

As a Business Intelligence Analyst, you will be trying to optimize the performance of different businesses.

  • For this purpose, understanding and creating KPI’s will be an important part of your work.
    • Step 1 – Identify your organization’s strategic objectives
    • Step 2 – Define the criteria for success
    • Step 3 - Develop key performance questions
    • Step 4 - Collect supporting data
    • Step 5 - Determine what to measure and how frequently you should measure
    • Step 5 - Develop the KPIs. As we will be aiming to certain goal in each of the KPI’s, be sure to follow the S.M.A.R.T criteria.
      • Specific: Your goals should be clear and well-defined. Instead of setting a vague objective like “improve data analysis,” make it specific by stating “develop a new data visualization dashboard to track key performance indicators.”
      • Measurable: Establish criteria to measure your progress and determine when you have achieved your goal. This can involve quantifiable metrics or observable outcomes. For example, you could measure the success of your data visualization dashboard by tracking the increase in user engagement or the time saved in generating reports.
      • Achievable: Ensure that your goals are realistic and attainable. Consider the resources, skills, and time available to you. It’s essential to set challenging goals, but they should still be within reach. For instance, if you have limited programming experience, setting a goal to build a complex AI algorithm from scratch may be unrealistic.
      • Relevant: Your goals should align with your overall objectives and be relevant to your role as a business intelligence professional. They should contribute to the growth and success of your organization. Prioritize goals that have a direct impact on key business areas, such as improving data accuracy, optimizing decision-making processes, or enhancing data security.
      • Time-bound: Set a specific timeframe or deadline for achieving your goals. This helps create a sense of urgency and provides a clear target.

UI and Visualizations in Analytics

You will need to form the ability of making the data tell the business users a story.

Your job will be to find the patterns and present the insights in a way that the stakeholders can understand it and take actions/decide next steps upon it.

Let’s Prototype

UI prototyping is an essential part of any project, allowing designers to visualize and test user interfaces before development.

  • We have a couple of options for UI Prototypes:
    • Static prototyping involves creating static representations of screens or wireframes, providing a visual guide to the layout and structure of the user interface.
    • Dynamic prototyping goes a step further by adding interactivity and user flows, allowing stakeholders to experience the interface’s behavior and functionality in a more realistic manner.

Both static and dynamic prototyping help refine designs, gather feedback, and ensure the final user interface meets the project’s requirements and user expectations.

User Journey Map

A user journey map (also known as a customer journey map) is a diagram that visually illustrates the user flow through your site, starting with initial contact and ending with the desired outcome.

It is a visual representation of how a user interacts with your product or service, and is used to identify areas of friction and user pain points in the customer experience.

A user journey map shows the different steps a user takes to complete a task, including the emotions, motivations, and behaviors that occur along the way. It also shows the various touchpoints and channels a user might use to interact with your business, such as website, mobile app, email, and physical stores.

By understanding the user journey, organizations can better optimize their customer experience and create more successful interactions.

UI prototyping on the project: static and dynamic prototyping.

Working w/end users and PO on prototypes.


Software for BI’s

  • PowerBI
  • Tableau
  • Looker
  • Microstrategy

You can check the updated trends at Gartner