The virtual experience programme is provided by Tata iQ or Tata Insights and Quants. I discover how passionate, multidisciplinary experts utilise data visualisation technologies like Tableau and Power BI to take on some of the most difficult business problems and uncover fascinating insights buried in the mountains of produced data. The programme demonstrates the kind of issues dealt with by Tata Insights and Quants every day and makes an effort to imitate the difficulties an individual could have.
There are 4 modules in this virtual experience programme.
♦ Framing the Business Scenario
♦ Choosing the Right Visuals
♦ Creating Effective Visuals
♦ Communicating Insights and Analysis
To prepare for your meeting, you need to draft questions that you think will be important and relevant to the CEO and CMO. This preparation will be your guide as you develop your presentation. For this task, you are only required to draft the questions. Make sure to think both quantitatively and qualitatively. You’ve been provided a dataset in the resources below to use as the basis for your exploration. Review this data, taking note of what information has been provided, what insights you can garner, and what is relevant to both the CEO and CMO respectively. Create a set of four questions that you anticipate each business leader will ask and want to know the answers to. Make sure you differentiate your questions, as both the CEO and CMO view business decisions through different lenses.
- Which region is generating the highest revenue, and which region is generating the lowest?
- What is the monthly trend of revenue, which months have faced the biggest increase/decrease?
- Who are the top customers and how much do they contribute to the total revenue? Is the business dependent on these customers or is the customer base diversified?
- Which months generated the most revenue? Is there a seasonality in sales?
- What is the percentage of customers who are repeating their orders? Are they ordering the same products or different?
- For the repeat customers, how long does it take for them to place the next order after being delivered the previous one?
- What revenue is being generated from the customers who have ordered more than once?
- Who are the customers that have repeated the most? How much are they contributing to revenue?
In this task, you will be required to read the questions carefully and understand that business requirement. Once you have an idea of what is required from the perspective of the CEO and CMO, you will need to come up with the perfect visual which will illustrate what the senior managers are looking for in each scenario. Remember, data can be presented in multiple types of charts, but you are required to select the visual that would best display the information which is being presented.
In this task you have to create visuals either on Power Bi or Tableau and show your findings to the CEO and CMO.
Develop a script and record a video presenting your findings to the CEO and CMO based on the four questions they asked and the visuals you created in the previous tasks. You can use your work or the model answer from the previous task to develop your presentation.