This repository contains the solutions to the tasks that were completed as a part of the TATA Data Visualization Virtual Internship Program. The program was hosted on Forage and the solutions provided here are intended to serve as a reference for anyone looking to learn data visualization or PowerBI.
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. Submit your eight questions in total (4 for the CEO and 4 for the CMO) in the text submission box below.
- Can you provide a revenue trend analysis to determine whether retail sales are seasonal?
- Which countries have the most potential for growth and what steps can be taken to further seize those markets?
- Who are the top consumers making the most purchases from the business, and what is their contribution to the company's overall revenue?
- Which regions are producing the greatest revenue and what strategies can be implemented to expand sales in untapped markets?
- What marketing strategies have been most effective in driving sales and increasing revenue?
- How has customer demographic data influenced the business's marketing decisions, and what insights can be gleaned from that data to further optimize marketing efforts?
- Are there any notable differences in purchasing behavior across different customer segments, and how can marketing efforts be tailored to those differences?
- What metrics are being used to measure the effectiveness of marketing campaigns, and how can those metrics be improved to better inform marketing decisions?
- Revenue trend analysis to determine whether retail sales are seasonal
- Countries with the most potential for growth
- Top consumers making the most purchases from the business
- Regions producing the greatest revenue
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.
When writing your script, you should speak about your entire process, including the initial data load and clean-up steps so that your leaders know you’ve done your due diligence in providing error-free analysis. Data analysis provides heaps of information but remember to focus on the information that is most important to your leaders.
Your video should be approximately 5 minutes in length. You can record your video in the browser or upload a video from your device below.
Remember, this is not just a read out of your visuals, you’re presenting to the CEO and CMO and need to provide context for each scenario and how it relates to their questioning.
You do not need to submit your script or talking points for this deliverable.
Hello, I am Shovit Nepal and I appreciate the opportunity to share with you some insights on your company based on your queries. Your specific questions were helpful in guiding me towards the analysis that you need. I assure you that the analysis is based on accurate and up-to-date data. I made sure to clean the data by removing records with negative quantities and unit prices to provide you with useful insights.
Firstly, I would like to address your query regarding the revenue trend to determine if retail sales are seasonal. Based on the data, there are specific months where sales are significant. The first eight months, from January to August, show stable revenue with an average of $685K per month. Revenue starts to increase in September, with a 40% growth compared to the previous month. This trend continues until November, with the highest revenue of $1.5 million for the entire year. Unfortunately, there is insufficient data for December to make inferences. This demonstrates that seasonality affects retail store sales, with the trend happening mainly in the last four months of the year.
Secondly, I identified the top 10 countries with the most potential for growth, excluding the UK since it already has high demand. The data shows that the Netherlands, Ireland, Germany, and France have high sales of units and income. I recommend focusing on these nations to seize the potential for growth.
Thirdly, I analyzed the top 10 consumers who made the most purchases from the company. There are not many differences in the purchases made by these consumers, and the highest revenue-generating consumer only spent 17% more than the second highest. This indicates that the company does not solely rely on a small number of consumers to generate income, and negotiations with consumers are limited, indicating a positive state of business.
Lastly, I created a map chart that compares the places that generated the most revenue to those that did not, with the exception of the UK. The data shows that the Netherlands, Ireland, Germany, France, and Australia generate high profits, and the company should invest more in these nations to increase product demand. The map also reveals that most sales occur in the European zone, with only a few in the American region. There is no market for the products in Africa or Asia, along with Russia. Implementing a fresh strategy in these areas may increase sales revenue and profitability.
Thank you for your time, and please do not hesitate to ask me any questions or request additional analysis after reviewing the material.
The solutions in this repository were created using PowerBI.
To use the solutions provided in this repository, you will need to have PowerBI installed on your computer. PowerBI can be downloaded from the official website (https://powerbi.microsoft.com/en-us/).
The solutions in this repository can be used as a reference for learning data visualization or for completing similar tasks. The folders are organized by task number and include both the task description and the corresponding solution.
At the moment, there are no known issues or bugs in the solutions provided in this repository.
If you would like to contribute to this repository, please follow these guidelines:
Fork this repository Create a new branch (e.g. feature/your-feature-name) Make changes to the new branch Submit a pull request