Category: Data Analytics

write a company analysis outlining the strength and weaknesses of cocola company

write a company analysis outlining the strength and weaknesses of cocola company and the reason behind its success

Objective: Build a comprehensive relational database with tables, forms, queries

Objective: Build a comprehensive relational database with tables, forms, queries, and reports for the gym clothing brand YOUNGLA. The database should help the company and improve the way that they handle their data. The records
in the tables can be fictitious.
Your Access database should contain at least the following features:
a) Minimum of four tables with at least 10 records in each table. Tables should be designed properly, and
data types should be properly selected.
b) Minimum of four queries. At least two queries should be grouped query (sum, count, average, etc.)
c) Minimum of four forms. Each form should be properly formatted for the best user experience.
d) Minimum of four reports. Two reports should have totals, and/or sub-totals for some financial data.
e) When you open the database, it should populate a menu and the user should be able to navigate
through the database using the menu items.

Please reflect on the challenges and successes of your MSBAN degree program. Ple

Please reflect on the challenges and successes of your MSBAN degree program. Please discuss your confidence and ability to:
a) Provide a substantive and relevant business analytics solution to a business problem.
b) Apply the skills acquired in this course (statistical, operational, software, predictive modeling, and others) to provide an analytical solution to a real-world problem.
c) Communicate the findings of analytical research effectively in both written and oral presentations to management.https://broad.msu.edu/masters/business-data-scienc…
Please refer to the discussion forum rubric
Initial discussion forum is due by Tuesday and responses to two of your classmates are due by Friday.
Each week to earn full points on the discussion forums, make sure to include outside sources to support your discussion

[SQL Dashboard Queries] SQL Recreation of the Excel PivotTable Supporting the Pi

[SQL Dashboard Queries] SQL Recreation of the Excel PivotTable Supporting the PivotChart Recreation of the Combination Charts in the ATTOM Article

NoTable is a furniture store in Halfway, Oregon, that manufactures custom-design

NoTable is a furniture store in Halfway, Oregon, that manufactures custom-designed wooden tables of exceptional quality. Most of their customers are collectors, including several movie stars. Their business model is simple: a customer contacts them, they work with the customer on a design, build the table, and deliver it to the customer’s residence. NoTable just hired you as an intern for their accounting department. They hope your data analytics skills can help them with some of the decisions they face. They provide you with an Excel file that contains several worksheets with data generated from their ERP system. The underlying data model is shown here, followed by a data dictionary.
NoTable’s management would like to include additional information about credit risk in their financial report. They ask you to explore accounts receivable and provide some insights. They provide you with sales orders and payment data generated by their ERP system. You can find these data in the SalesOrders and Customer worksheets. The following is some additional information regarding NoTable’s credit policy:
All payments are due within 30 days.
Early payments: There is a 3% discount for all orders paid in full within 2 weeks (15 days).
On time payments: There is no discount or no penalty for sales orders paid on time.
Late payments: There is a 3% penalty for all sales orders with a late payment.
a. Explore whether NoTable’s credit policy works. For orders that already have been paid, compare early, on time, and late payments.
b. For the orders that have not been fully paid yet, explore the aging of the outstanding balances. What insights can you collect?
c. Analyze accounts receivable by customer. Explore whether there is an issue with accounts receivable concentration.
I have attached all info for the question. As well as a powerpoint for extra help on the topic. Please upload an excel file showing how you solved it as well as a sperate word file answering the questions

my topic is Museums in the state of Oklahoma USA, my research target is to know

my topic is Museums in the state of Oklahoma USA, my research target is to know what kind of museums do people visit and enjoy the most and what is it that they like the most about museums, the main goal is to understand the public opinion on the Museums of Oklahoma in order to increase the Museums visitors.
1- collect data from google reviews/or Twitter (which ever you think is best ) from Apify using the keyword Museum (make sure the location is Oklahoma), you could use different key word if you think something else works better for better results
2- Sentiment analysis using RStudio, Data visualization using Tableau for the Sentiment analysis results
3- Topic modeling using RStudio get the couple graphs that you think are important for the topic
4- write a report including:
Title page (i.e., title of the project, your name and affiliation, and date of submission)
Abstract (no more than 150 words) and keywords (3 to 6 keywords)
Main body (no more than 2,000 words)
References (APA 7th style): Please include all the sources that you cite.
Tables and/or figures. This part is beyond the 2,000 words limi
make sure you analyst each graph you include in the report
5- create ppt slides for the project presentation

D*Tunes policy is to keep group classes only when there is a net revenue of at l

D*Tunes policy is to keep group classes only when there is a net revenue of at least $150 after paying the instructor. Currently, the price paid by students for a group class is $40. Explore the following two questions.
a. Create an information model to determine how many students are required per lesson to breakeven, and which lessons have not yet reached that goal
b. Generate a report that shows which classes are not meeting the breakeven point. What classes would you suggest canceling?
I have attached all the additional info needed for plus powerpoint from the class for additional help

ISM 4403 – Fall 2023
Final Project
Due December 09, 2023
Data Analytics Project

ISM 4403 – Fall 2023
Final Project
Due December 09, 2023
Data Analytics Project Assignment: Enhancing Sports Team Performance
In this project, you will step into the role of a business analyst recruited by a sports team of your choice. Imagine being part of the team’s strategy to elevate national ratings for the upcoming 2024 season. The team’s CEO has entrusted you with the task of leveraging data insights to assist coaches and players in achieving this goal. Your mission involves comprehensive research, strategic thinking, and hands-on application of data analytics techniques.
Your Task:
Identify and Collect Data:Locate a dataset related to the sports team you are investigating. The dataset should comprise a minimum of 500 records and include at least 8 attributes.
CRISP Model Approach: Utilize the CRISP (Cross-Industry Standard Process) Model Approach for effective analysis.
Business Model Narrative:Craft a 2-3 paragraph narrative describing the business model of the sports team. Provide insights into its structure, goals, and key strategies.
Data Understanding and Strategic Objectives:Explain and discuss your understanding of the dataset concerning the team’s strategic objectives. How does the data align with the team’s goals?
Data Preparation:Apply data cleansing techniques discussed in class to prepare the dataset. Elaborate on the process undertaken for data cleaning and why it is crucial for accurate analysis.
Model Development:Develop models using Linear Regression, CART Model, C4.5, and K-Means Algorithm. Choose 4-5 attributes for your models, justifying your selection based on relevance and significance.
Model Testing with Confusion Matrix:Employ the Confusion Matrix Approach to test each model. Evaluate their performance and discuss the results.
Model Comparison and Findings:Compare the developed models and discuss your findings. Highlight strengths, weaknesses, and potential areas for improvement.
Conclusion:Summarize your findings and provide a conclusion. Reflect on the implications of your analysis for the sports team’s 2024 season.
Submission Details:
Deadline: December 09, 2023
Report Length: Minimum 8 pages adhering to APA formatting guidelines (1.5 line spacing, title, header, page numbering, etc.)

All the information and instructions about the project are on the attached PDF F

All the information and instructions about the project are on the attached PDF File. Please read them carefully. Thank you

see 3 attached files
See attached Lift Charts for an explanation of Gains and Li

see 3 attached files
See attached Lift Charts for an explanation of Gains and Lift Charts
also for ideas see http://www2.cs.uregina.ca/~dbd/cs831/notes/lift_chart/lift_chart.html
As in previous HW, you need to read the .doc file and answer the questions. The data is the .xls files and give your answers in two .xls files and one .doc explaining all.
Do all the exercises in chapter 10 please!
In chapter 11 try to do only the first (#1).