Category: Data Analytics

Go through the steps listed in “Type 2 – Market-Sizing & Guesstimate of the Case Interview Questions. MConsulting Prep” (https://mconsultingprep.com/case-interview-questions)
Answer the below questions:
– How many mini shampoo bottles are made in a year?
– Will, there be more made next year, and five years from now?
– For the clarifying steps, list what questions you had and make and record your assumption on the answer.
– If you do not agree with the number presented to you. What adjustments or recommendations would you make?
Correct APA in-text citations and references are used.

Pick a decision you make and turn it into a decision tree with at least four nodes. Make some assumptions and label the probability of each branch and result.
What are your thoughts on the decision tree and the probability assigned to the nodes? What would you add, if anything, in terms of branches?
Resources:
How To Do A Decision Tree In Word. (n.d.). How200.
http://how2oo.com/how-to-do-a-decision-tree-in-word/
Decision tree examples: Problems with solutions. (n.d.). Intellspot.
https://www.intellspot.com/decision-tree-examples/
Correct APA in-text citations and references are used.

Analyzing Patriots Sales Data for Strategic Insights
Background:
Patriots Corporation is a nationwide company operating across multiple states and regions in the United States. The company has provided three key datasets containing monthly sales, sales by state, and regional sales data over a 15-year period. The goal of this case study is to leverage Tableau and advanced data visualization techniques to generate key insights, assist decision-makers, and improve sales strategies for the upcoming fiscal year.
Objective:
Following the steps outlined in Appendix 2.2, “Creating and Modifying Charts with Tableau,” of the textbook, complete the assignments below by analyzing the provided sales data using Tableau. Your task is to create various visualizations, modify them based on given criteria, and analyze data trends to provide actionable insights for Patriots Corporation.
The attached “Sales” file contains a sheet titled “Sales by Month,” which shows Patriots Corporation sales data for twelve months.
1. Begin by creating a column chart in Tableau with the sales amount on the vertical axis and the months on the horizontal axis, following the example in Figure T2.3.
Modify the chart as follows:
Adjust the axis range by setting the Fixed start to 0 and the Fixed end to 50,000, ensuring the peak sales value fits comfortably within this range.
Label the horizontal axis as Sales Month and the vertical axis as Sales Amount.
Standardize the font size across all textual elements by setting it to size 11.
Update the chart title to “Patriots Sales by Month.”
Remove any unnecessary grid lines from the chart.
2. Recreate a similar graph, but this time with the sales amount on the horizontal axis and the sales months on the vertical axis, following the layout shown in Figure T2.5.
Modify the chart as follows:
Adjust the axis range by setting the Fixed start to 0 and the Fixed end to 50,000, ensuring the peak sales value fits comfortably within this range.
Label the horizontal axis as Sales Month and the vertical axis as Sales Amount.
Standardize the font size across all textual elements by setting it to size 11.
Update the chart title to “Patriots Sales by Month.”
Remove any unnecessary grid lines from the chart.
The attached “Sales” file contains a sheet named “Sales by States,” which contains Patriots Corporation sales data across 25 U.S. states.
1. Create a scatter plot using the “Sales by States” data, with the average price on the vertical axis and the sales amount on the horizontal axis, following the layout shown in Figure T2.8.
Modify the chart as follows:
Label the axes, with the horizontal axis labeled as Sales Amount and the vertical axis as Average Price.
Adjust the axis range so that the peak sales value comfortably fits within the chart.What would you recommend for the Fixed Start and Fixed End?
Standardize the font size for all textual elements to size 11.
Update the chart title to “Patriots Sales by State.”
Remove any unnecessary gridlines from the chart.
2. Using the same dataset, create a scatter chart for sales, including data labels with state names. Refer to Figure T2.9 in the textbook for guidance.
Modify the chart as follows:
Label the axes as follows: the horizontal axis as the Sales Amount and the vertical axis as the Average Price.
Adjust the axis range to ensure that the peak sales value fits comfortably within the chart.What would you recommend for the Fixed Start and Fixed End?
Standardize the font size for all text elements to size 11.
Update the chart title to “Patriots Sales with Data Labels for States.”
Remove any unnecessary gridlines from the chart.
3. Using the same dataset, create a Choropleth Map, following the format shown in Figure T2.24.
Modify the chart as follows:
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Choropleth Map Sales.”
Remove any unnecessary gridlines from the chart.
4. Using the same dataset, create a bubble chart for sales with data labels displaying the state names. Refer to Figure T2.11 in the textbook as an example.
Modify the chart as follows:
Label the axes as follows: the horizontal axis as the Sales Amount and the vertical axis as the Average Price.
Adjust the axis range to ensure that the peak sales value fits comfortably within the chart.
What would you recommend for the Fixed Start and Fixed End?
Standardize the font size for all text elements to size 11.
Update the chart title to “Patriots Sales with Data Labels for States.”
Remove any unnecessary gridlines from the chart.
The attached “Sales” file contains a sheet titled “Sales by Region,” which contains 15 years of regional sales data.
1. Create interlaid line charts for the two regions, similar to the example in Figure T2.18.
Modify the chart as follows:
Label the axes with the horizontal axis as years and the vertical axis as sales amount.
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Sales by Region.”
Remove any unnecessary gridlines from the chart.
2. Using the same dataset, create a Clustered Column Chart following the format shown in Figure T2.21.
Modify the chart as follows:
Label the axes with the horizontal axis as years and the vertical axis as sales amount.
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Sales Clustered by Regions.”
Remove any unnecessary gridlines from the chart.
3. Using the same dataset, create a Stacked Column Chart, following the example in Figure T2.22.
Modify the chart as follows:
Label the axes with the horizontal axis as years and the vertical axis as sales amount.
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Sales Stacked by Regions.”
Remove any unnecessary gridlines from the chart.
Policy Implications and Strategic Decision-Making:
Based on the data analysis and visualizations you create, what are the potential policy implications for Patriots Corporation regarding its sales strategies across different states and regions? Consider how regional performance trends, state-specific sales, and monthly fluctuations might influence strategic decision-making. What policies could Patriots Corporation implement to enhance sales performance, and how should leadership adjust its approach to allocating resources, developing targeted marketing campaigns, or addressing underperforming regions?
Submission Requirements:
All assignments must be submitted in a well-formatted and clearly presented Word file.
Ensure that the file includes all visualizations, a written summary of key insights, strategic recommendations, and suggested policy actions.
Charts and graphs should be properly labeled and formatted as described in each task.
The document should be professional and easy to follow, with headings and sections clearly defined.

Applying the Structure to Survey Questions (Your Final Deliverable):
1. Usage Frequency
✍🏾
Task: Create a slide that shows how often respondents use their wireless speakers.
Title: “Daily Use of Wireless Speakers Indicates High Engagement”
Graph/Chart: Bar chart showing frequency of use (Daily, Several times a week, etc.)
Insight Explanation: Note the percentage of daily users and what it implies about engagement.
Caption: Briefly describe the main takeaway from the chart.
2. Audio Quality
✍🏾
Task: Create a slide about the audio quality ratings of wireless speakers.
Title: “High Ratings for Audio Quality Reflect Consumer Satisfaction”
Graph/Chart: Pie chart showing ratings (Excellent, Good, etc.)
Insight Explanation: Highlight the positive ratings and what they suggest.
Caption: Summarize the key finding from the chart.
3. Important Features
✍🏾
Task: Create a slide ranking the most important features in a wireless speaker.
Title: “Sound Quality and Battery Life are Top Priorities”
Graph/Chart: Bar chart or ranked list of features.
Insight Explanation: Explain why these features are prioritized by consumers.
Caption: Briefly describe the chart’s key points.
4. Preferred Brands
✍🏾
Task: Create a slide showing brand preferences.
Title: “Brand Loyalty is Strong Among Consumers”
Graph/Chart: Bar chart showing brand preferences.
Insight Explanation: Discuss the popularity of specific brands.
Caption: Summarize the key finding from the chart.
5. Purchase Motivation
✍🏾
Task: Create a slide on factors influencing purchase decisions.
Title: “Recommendations and Reviews Drive Purchase Decisions”
Graph/Chart: Likert scale chart.
Insight Explanation: Highlight the importance of recommendations and reviews.
Caption: Briefly describe the chart’s key points.
6. Overall Satisfaction
✍🏾
Task: Create a slide on overall satisfaction.
Title: “High Satisfaction Levels Among Wireless Speaker Users”
Graph/Chart: Pie chart showing satisfaction levels.
Insight Explanation: Discuss the high satisfaction levels.
Caption: Summarize the key finding from the chart.
7. Improvement Suggestions
✍🏾
Task: Create a slide summarizing improvement suggestions.
Title: “Consumers Seek Enhanced Features and Performance”
Graph/Chart: Word cloud or bar chart of suggestions.
Insight Explanation: Highlight common themes in the suggestions.
Caption: Briefly describe the main takeaway from the suggestions.

Applying the Structure to Survey Questions (Your Final Deliverable):
1. Usage Frequency
✍🏾
Task: Create a slide that shows how often respondents use their wireless speakers.
Title: “Daily Use of Wireless Speakers Indicates High Engagement”
Graph/Chart: Bar chart showing frequency of use (Daily, Several times a week, etc.)
Insight Explanation: Note the percentage of daily users and what it implies about engagement.
Caption: Briefly describe the main takeaway from the chart.
2. Audio Quality
✍🏾
Task: Create a slide about the audio quality ratings of wireless speakers.
Title: “High Ratings for Audio Quality Reflect Consumer Satisfaction”
Graph/Chart: Pie chart showing ratings (Excellent, Good, etc.)
Insight Explanation: Highlight the positive ratings and what they suggest.
Caption: Summarize the key finding from the chart.
3. Important Features
✍🏾
Task: Create a slide ranking the most important features in a wireless speaker.
Title: “Sound Quality and Battery Life are Top Priorities”
Graph/Chart: Bar chart or ranked list of features.
Insight Explanation: Explain why these features are prioritized by consumers.
Caption: Briefly describe the chart’s key points.
4. Preferred Brands
✍🏾
Task: Create a slide showing brand preferences.
Title: “Brand Loyalty is Strong Among Consumers”
Graph/Chart: Bar chart showing brand preferences.
Insight Explanation: Discuss the popularity of specific brands.
Caption: Summarize the key finding from the chart.
5. Purchase Motivation
✍🏾
Task: Create a slide on factors influencing purchase decisions.
Title: “Recommendations and Reviews Drive Purchase Decisions”
Graph/Chart: Likert scale chart.
Insight Explanation: Highlight the importance of recommendations and reviews.
Caption: Briefly describe the chart’s key points.
6. Overall Satisfaction
✍🏾
Task: Create a slide on overall satisfaction.
Title: “High Satisfaction Levels Among Wireless Speaker Users”
Graph/Chart: Pie chart showing satisfaction levels.
Insight Explanation: Discuss the high satisfaction levels.
Caption: Summarize the key finding from the chart.
7. Improvement Suggestions
✍🏾
Task: Create a slide summarizing improvement suggestions.
Title: “Consumers Seek Enhanced Features and Performance”
Graph/Chart: Word cloud or bar chart of suggestions.
Insight Explanation: Highlight common themes in the suggestions.
Caption: Briefly describe the main takeaway from the suggestions.

Hi, need support with the following:
You have asked to prepare an executive report ( which should be presented to the management very quarter ) as following:
You are working in construction company in procurement department. You are asking to prepare a report covering the status of the work ( Volume of work ) total purchase requestions, total Purchase orders.. Total money ( SAR ) spent LOCAL, and total spend in Europe, Total in China, total in USA…..act.
Your company current is receiving a lots of new projects, and your executive management are working to increase the manpower ( procurement engineers, materials expeditors, data enters… ). The company has two main discipline ” Energy sector” and ” Building” and the team are divided between these two sectors. Some people work at the head office, and the rest of the team working from the sites ( Projects ).
The requirements:
1- Prepare a strategic report for the executive management as main template to be use very Quarter.. So they can just put the presentations, statistical numbers based on the progress.
2- The presentation report should cover the volume of the work the department worked on during the past quarter ( Total Purchase requestions, total Purchase orders).. Total work in Mechanical department, total work in Electrical department, total work in Civil, and total work in consumable materials ).
3- The report should have a well professional statistical chapter about the manpower ( How many new joiners per the discipline ). How much curses as part of the development we have done for the team ? How much curses we have done for the local vendors, as part of our strategic support to the local content ?
4- In the report, you should have a chapter for the total spent ” Statistical”.. How much locally, and how much overseas.. You use the same data from the excel sheet. This is very important chapter. You need to create it in very professional ( Business manner ).
5 – You have to prepare an index.
I am expecting 6 to 8 pages on the PPT, by excluding the cover page and last page. Make sure to ask if you seek for any clarification because if you don’t meet the requirement, I might ask you to correct it.. and if you meet the requirement, I will proceed with very good tip.. Thank you

Regression is an analytical technique used to make a relationship between input variables and continuous outcome variables.
A sample of data on cars is provided for this assignment. The file contains data on sales of used cars with 1436 records containing details. The attributes of the data include Age (Age in years), KM (Accumulated Kilometers on the odometer), HP (horsepower), CC (Cylinder Volume in cubic centimeters), Doors (Number of doors), Weight (Weight in Kilograms), and Price (Price of Cars). Run a multiple regression with the outcome variable Price and the predictor variables Age, KM, HP, CC, Doors, and Weight.
Before performing the analysis.
Perform descriptive analysis.
Perform correlational analysis and describe the analysis.
Apply standardization to the data.
Perform correlational analysis.
Split the data into a training set and a testing set of the data.
Perform multiple regression on the training set!
Perform
Explain the linear regression coefficient and intercept.
Specify the linear regression equation.
Perform model evaluation – Mean Squared Error (MSE)
Include a brief description of each step and the screen print of your Python codes in your paper (Word file).
Submit your assignment.

For this assignment, be sure to watch the following tutorial video on how to look at customer journeys and pathing analysis in Google Analytics 4:
For this assignment, go into the demo account of Google Analytics 4 you have access to and create 3 different pathing analysis views for practice and showcase your ability to run this type of analysis.
For each pathing analysis, pick at least one different segment for each, then pick at least one dimension, then up to 3 steps/events in the order of that segment and dimension journey.
In your submission, take a screenshot of the 3 different pathing analyses and then provide a one-page written summary for each pathing analysis and what you see.
Answer the following in your analysis:
What seems to be popular webpages in the demo store?
What seems to be the engagement of the segment and dimension in each step.
Explain what you see in the visualization as if you were describing it to someone.
In the final page, recap the experience running the pathing analysis process. What did you learn in the process? Which of the 3 pathing analyses you conducted did you find to be the most engaging and why?
Formatting Guidelines:
This paper should be double spaced, APA format, Times New Roman, 12pt Font. The entire paper with screenshots should be 4-5 pages in length. A title page and references page are expected. The title and reference page do not count towards the 4-5 page minimum.

For this assignment, be sure to watch the following tutorial video on how to look at customer journeys and pathing analysis in Google Analytics 4:
For this assignment, go into the demo account of Google Analytics 4 you have access to and create 3 different pathing analysis views for practice and showcase your ability to run this type of analysis.
For each pathing analysis, pick at least one different segment for each, then pick at least one dimension, then up to 3 steps/events in the order of that segment and dimension journey.
In your submission, take a screenshot of the 3 different pathing analyses and then provide a one-page written summary for each pathing analysis and what you see.
Answer the following in your analysis:
What seems to be popular webpages in the demo store?
What seems to be the engagement of the segment and dimension in each step.
Explain what you see in the visualization as if you were describing it to someone.
In the final page, recap the experience running the pathing analysis process. What did you learn in the process? Which of the 3 pathing analyses you conducted did you find to be the most engaging and why?
Formatting Guidelines:
This paper should be double spaced, APA format, Times New Roman, 12pt Font. The entire paper with screenshots should be 4-5 pages in length. A title page and references page are expected. The title and reference page do not count towards the 4-5 page minimum.

I have an existing Lucid chart, which I want to convert in 2 different formats. The lucid chart is on “page 1”. I want it converted into page 2 and page 3 format (use the given format only).In addition to formatting, extend the NIR blue box to Trade compliance. remove the very first doc control swimlane ( keep the other doc control swimlane). Below is the link for the Lucid chart