mgmt 600 IP2

For this assignment, you will need to become familiar with specialized business intelligence (BI) software, and then download the software. Complete the following steps to begin:
Step 1: Watch an instructional video on the BI software.
Step 2: Review various BI Software options, including Tableau and Excel. Search the CTU Library and the Internet to learn about optional software.
Step 3: If you choose Tableau, download the Tableau BI software. After you select the link, look for the orange icon in the middle portion of your screen to begin the download or use any BI software to create a graph illustrating comparison between the United States and zip code data.
Consider the following scenario, continued from Unit 1 Individual Project:
Big D Incorporated needs to prepare an assessment regarding the feasibility of making a recommendation for expansion into another market. As the business analyst, your assignment is to prepare a short presentation for the Board of Directors that apply concepts learned in Unit 1 and concepts from Unit 2 to make the necessary recommendations and justifications for those recommendations. You will need to compare and contrast the varying markets to make the best recommendation possible. Complete the following:
Download the reports for the United States from this Web site. The Web site provides free demographical services where one can choose from a variety of criteria and generate reports based on the U.S. Census data. This particular file contains 4 reports: General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary (based on the entire United States)

Download the reports for zip code 60614 from this Web site. This particular file contains 4 reports: General Summary
Census Trend 1980 to 2000 Summary
Occupation and Employment Summary
Income Summary based on the U.S. zip code 60614

Using all 4 demographic reports (General Summary, Census Trend 1980 to 2000 Summary, Occupation and Employment Summary, and Income Summary) for the United States and zip code 60614, prepare a 1-page summary slide explaining how your territory differs from the national profile. Feel free to note anything that you found surprising in the data.
Use the BI software you choose to depict information from these reports.
Prepare a presentation of 4–5 slides of your major findings. You may group a category of data from the Total United States and zip code 60614, and create a graph to show how they differ. The presentation should have at least 2 graphs and a headline that summarizes a key takeaway from the graph.
Your presentation should include 5–6 slides in PowerPoint, plus title and reference slides with speaker notes (75-word minimum per slide).
For assistance with the usage of Tableau for analysis and reporting, review and use the instructions below. Those should be helpful if you are having problems with the software usage or data. However, you do not need to use Tableau. For BI software usage such as Excel, resort to using the Help functions and other resources on the Internet and in videos to learn how to use Excel to create graphical presentations including table usage.
The instructions to create a bar graph in Tableau (optional) or in another BI software are as follows.
Open the assignment CTU instructions.
Download the BI software.
Create your Tableau Public Account.
Click the download link for the 60614 file (file will open in Excel).
Click the download link for the U.S. file (file will open in Excel).
The following are some options: Create separate demographical worksheets (e.g., Educational Attainment or Household Income). Include zip code and U.S. data. See a sample of the file available with column headings and extraneous blanks.

Household IncomeChicagoU.S.198019901980 to 199020001990 to 20001980Median Household Income18,43841,2271.23669,3110.68116,902Average household Income24,24567,6071.788114,6150.69520,382Per Capita Income13,56438,5181.8463,7910.6567,321
See a sample of the file available with column headings and extraneous blanks.
2000 Educational AttainmentU.S.ChicagoCollege: Associates Degree6.3%1.9%College: Bachelor’s Degree15.5D.2%College: Graduate Degree8.94.0%College: Some College, no Degree21.1%8.7%School: 9th to 11th grade, no diploma12.1%3.2%School: Grade K-96.1%2.0%School: High School Graduate28.6%5.6%
Create a file with data organized without extraneous rows and columns but including headings.
The idea is to clean up the file before usage. Separating files and worksheets may be the best way to make this happen
Note that in the real situation, when using BI software, you will want to ensure that your data are clean and that you have similar data in your files.
Save the file(s) on your computer.
Open Tableau. Then do a File > Open > Open on your saved file.
At the bottom of the screen on the left, click on the little box next to Sheet 1 (looks like a bar graph with a plus in the top left corner).
Under “Measures” (on the left), you should see “Chicago” and “U.S.” Click on “U.S.,” and pull it into rows at the top of the screen. Then, click on Chicago and pull it over into rows.
Under “Dimensions” on the left, you should see “Household Income.” Click on “Household Income,” and pull it into column.
In the second column from the left, you should see “Measures.”
In the top right corner, you should see a “show me” box illustrating ways you can view the data based on the values you have chosen. To do side-by-side comparisons, put your cursor over the rightmost picture on the third line with the side-by-side blue and orange bars. Click on it. Your graph should appear on the page. You can play around with how you want to portray your data.
To save in Tableau Public, click File > Save to Tableau Public as… > give the file a descriptive name. You will be asked to log into Tableau Public using your e-mail and password.
When your graph is saved in public, at the bottom right, there is a download button. Decide how you will save the file. (You can create an image and name the .png file. It will be saved in Tableau Public.)
After the file is saved, open the .png file, and edit or copy the graph.
Open your PowerPoint file, and then paste (special) it on the slide. You can adjust the size.
Repeat the same in Tableau opening of any other prepped and cleaned file.
Note: Measure values are your number fields; measure names are the descriptors.
For more information on creating PowerPoint Presentations, please visit the Microsoft Office Applications Lab.
Additional Resources to Use
Igines. (2012, December 9). How to make a line graph in Excel (Scientific data) [Video]. YouTube. https://www.youtube.com/watch?v=Xn7Sd5Uu42A
Microsoft. (2021). Create a chart from start to finish. https://support.office.com/en-us/article/Create-a-chart-from-start-to-finish-0baf399e-dd61-4e18-8a73-b3fd5d5680c2  
References
Pak, A. [Anthony Pak]. (2013, August 12). Tableau public – Overview and applications [Video]. YouTube. http://youtu.be/PnkMiHocqRw  
Tableau. (2018). Tableau public. http://www.tableausoftware.com/public/  
Please submit your assignment.
For assistance with your assignment, please use your text, Web resources, and all course materials.

MGMT600 IP1

5-6 slides with speaker notes (75 word minimum per slide) 
Big data is everywhere, and various businesses around the world are driven by big data. While some businesses rely on big data for organizational decision making, this does not mean that the implications and applications of big data are properly used to ensure optimal effectiveness for the organization
For this scenario, you have been appointed as a business analyst for Big D Incorporated, charged with providing authoritative recommendations to the Board of Directors. As the business analyst, the recommendations that you provide will be based upon data calculated from statistically appropriate formulas. Be reminded that you are not the company’s statistician yet. However, as the business analyst, you are therefore responsible for interpreting statistical data and making the appropriate recommendations.
Big D Incorporated was offered a series of business opportunities, and it is your job as the business analyst to provide expert insight and justification for recommendations regarding these potential prospects.
Assignment Details
Big D Incorporated has a business opportunity to provide two different types of information to a new client. As the business analyst, you are tasked to assess the financial feasibility of this opportunity. The new client is a retailer and looking to expand its product offerings. However, the client is requesting Big D Incorporated to assist in the decision-making process.
Prepare a presentation that addresses the following:
Explain the difference between nominal and ordinal data.
List 3 qualitative attributes of outdoor sporting goods that the client may want to ask consumers. Make sure 1 of the qualitative attributes is nominal.
For each ordinal attribute, assign names for the endpoints of a 5-point rating scale.
Explain the difference between interval and ratio data.
List 2 quantitative attributes of outdoor sporting goods that market researchers might want to measure.
Explain the difference between a population and a sample.

DB unit 5 MGMT 600

Primary Task Response: Within the Discussion Board area, respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas.
Big D Incorporated is nearing completion of its portfolio of recommendations for the outdoor sporting goods company. There are a wide range of measures that could be of value to the Board of Directors to consider.
Think of each measure as being a paint stroke in a corporate picture. By itself, it may not have much value. However, when combined with others, a picture is formed. The more variables examined regression, the clearer the picture. For example, consumer age, income, gender, background, industry, and interests could provide guidance to the best marketing approach to take.
Although past data are used to indicate the future, the social and economic impact of the coronavirus needs to be considered. What are the impacts to unemployment, income disruption, and recovery plan by each state?
Clearly state variables that you would utilize in your path that you are recommending. Utilize a regression model to determine if the recommendation is to expand into the new market or to not expand. Ensure that you provide adequate justification for your recommendations. The Board of Directors requires your input based upon your previous exercises from Units 1, 2, and 3. 

Finance Management Discussion

She needs to allocate her funds to reflect a balanced monthly budget. Jenny’s main expense categories include rent, utilities, and groceries.
How would Jenny best allocate her income for the month?
What categories and in what amounts should Jenny allocate her funds to reflect a balanced monthly budget? Include the main categories as well as examples of other categories. 

Finance Management Discussion

She needs to allocate her funds to reflect a balanced monthly budget. Jenny’s main expense categories include rent, utilities, and groceries.
How would Jenny best allocate her income for the month?
What categories and in what amounts should Jenny allocate her funds to reflect a balanced monthly budget? Include the main categories as well as examples of other categories. 

who can do this question in 5 days

  Develop a 12-15 item test/instrument on the construct of interest you selected during Step One and Step Two (e.g. depression, anxiety, self-esteem, marital satisfaction, social persuasion, job satisfaction, etc.). Construct the items and response choices for the instrument (can either be in multiple choice, true/false, rating scale, and/or open ended question format). Include an introduction to the instrument (e.g. what the test is proposing to measure and why) and explicit instructions on how the instrument should be completed by the participants. Use the Diem (2002), Derrington (2009), and Siebert (2002) websites to assist you in your item and test construction. Information gathered from sources must be appropriately cited on the References page, following APA guidelines. Your test submission should include a title page and a References page (if sources were used
part 2
Students should be working on completing their Test Development Proposal, which is the final course assignment and is due in Week Six.  In previous weeks’ assignments, students have selected a construct of interest, discussed the purpose for developing an assessment to measure the construct, developed a research question(s), conducted a literature review and critique on current assessments used to measure the construct, and constructed a 12-15 test to measure the construct.
During Week Five, students should begin administering their tests to 3-5 family members, friends, co-workers, etc. As mentioned in Week 4, please ensure that each participant reviews the consent form (which should include the instructor’s information and student’s name) provided in the Week 4 Assignment folder See Participant Consent Form.doc). Since this proposal is completely anonymous, you will not be required to return the consent forms, but will receive credit during Week 6 for acknowledging that you presented this to your participants.
Although the testing is completely anonymous, students will need to write a brief summary about the Methods used, including non-identifying information about the participants (e.g. age, gender, occupation, education level, etc.) and how the test was administered (e.g. the setting, was it administered in person or via a computer, etc.). Thus, when administering the test to each participant, please be sure to record non-identifying information about the participant, as well as document how the test was administered to the participant.
Part 3a)  A title page (final paper) b)  Abstract c)  Rationale/Problem Statement: Explain your construct of interest. Make a case for why this construct is important to you, the field of psychology, or your specialization area. What specifically about your construct are you wanting to assess? Are there different characteristics or behaviors that can be assessed within your construct? For example, if measuring depression as a construct, would you want to measure the severity of depression or the symptoms related to depression? What are all the characteristics of depression? Would you be assessing all of the characteristics? d)  Research Question: Develop a research question addressing what you will be assessing.Literature Review: Taken from Step Two, along with any required edits. Write a 7-8 page literature review on your construct of interest and the 5-7 instruments used to assess it. Thus, the literature review should explain your construct of interest thoroughly, as well as provide thorough reviews of the 5-7 instruments used to measure it. This is slightly different from other literature reviews, whereby the idea is to review and critique the study and findings. For this literature review you are not reviewing the study but rather are reviewing and critiquing the instrument based on what studies and other research have found. The idea here is review the instrument and its usefulness in measuring your construct. Thus, what does the instrument measure, how reliable and valid is it, and what are its strengths and weaknesses?  What is lacking in the instrument which paves the way for the necessity of your newly developed instrument? How are these instruments different from what you will develop? Use 5-7 scholarly resources, including mostly research studies and articles related to your construct and the instruments used to measure it. Information should be drawn from appropriate sources, such as professional journals, test publisher websites, and dissertations. Information gathered from sources must be appropriately cited, following APA guidelines. Please be sure to include the following in your literature review:
·  A thorough discussion of each instrument you review for your construct, including the name of the test, what the test is used for, whether the test is appropriate for this area, what the reliability and validity of the test is, and what reviewers say about the strengths and weaknesses of it with regard to assessing this construct
·  What, in general, appears to be adequately assessed on each test with respect to the construct that you selected?
·  What does not appear to be adequately assessed?
·  Your literature review should justify your development of an assessment—is there a hole in what is currently being assessed that you can fill with your test? Make a case for why your proposed test would address an area that is not already well assessed.
      e)   Methodology: Provide detailed information regarding the scale that you developed, who the participants were, and how the scale was administered. Include the following:
·  Participant Selection: Explain who your participants were (e.g. total number, gender, age, etc.) and how you selected them. Be as specific as possible, as if you were giving directions to someone on how to choose and obtain the participants.  Include instructions on how informed consent was provided to the participants. Be sure to indicate whether each participant received and reviewed the consent form provided.
·  Measures: Discuss the instrument you developed, including what the instrument measures, how many items were developed, what type of scale it is (e.g. rating scale, observation, multiple choice, etc.), and how you developed the instruments (e.g. did you use examples from pre-existing scales, etc.).  Include a copy of the instrument in the Appendix.
·  Data Collection: Discuss how and where the data was collected (e.g. was the data collected via an internet survey, a group setting, individualized administrations, etc.). Was the data collected in an office setting, house, etc.? Were the participants provided with explicit instructions on how to complete the scale?
            f)  Discussion: Include the following information, using at least 2-3 scholarly sources to support your discussion:
·  Strengths and Weaknesses: Provide a thorough critique of your scale. What do you believe are the strengths of your scale? The weaknesses? Regarding test construction, are there any items that appear to be problematic or vague? Are the response choices clear and appropriate? Does the scale appear to measure the construct you have selected? How could you increase the validity of your scale?
·  Ethical Considerations: Could your participants be harmed by your scale, either in taking it or after it is finished? Address this and other possibly relevant questions of ethics.
·  Limitations: No research covers everything.  What are the obvious limitations to this study/proposal?

who can do this question in 5 days

  Develop a 12-15 item test/instrument on the construct of interest you selected during Step One and Step Two (e.g. depression, anxiety, self-esteem, marital satisfaction, social persuasion, job satisfaction, etc.). Construct the items and response choices for the instrument (can either be in multiple choice, true/false, rating scale, and/or open ended question format). Include an introduction to the instrument (e.g. what the test is proposing to measure and why) and explicit instructions on how the instrument should be completed by the participants. Use the Diem (2002), Derrington (2009), and Siebert (2002) websites to assist you in your item and test construction. Information gathered from sources must be appropriately cited on the References page, following APA guidelines. Your test submission should include a title page and a References page (if sources were used
part 2
Students should be working on completing their Test Development Proposal, which is the final course assignment and is due in Week Six.  In previous weeks’ assignments, students have selected a construct of interest, discussed the purpose for developing an assessment to measure the construct, developed a research question(s), conducted a literature review and critique on current assessments used to measure the construct, and constructed a 12-15 test to measure the construct.
During Week Five, students should begin administering their tests to 3-5 family members, friends, co-workers, etc. As mentioned in Week 4, please ensure that each participant reviews the consent form (which should include the instructor’s information and student’s name) provided in the Week 4 Assignment folder See Participant Consent Form.doc). Since this proposal is completely anonymous, you will not be required to return the consent forms, but will receive credit during Week 6 for acknowledging that you presented this to your participants.
Although the testing is completely anonymous, students will need to write a brief summary about the Methods used, including non-identifying information about the participants (e.g. age, gender, occupation, education level, etc.) and how the test was administered (e.g. the setting, was it administered in person or via a computer, etc.). Thus, when administering the test to each participant, please be sure to record non-identifying information about the participant, as well as document how the test was administered to the participant.
Part 3a)  A title page (final paper) b)  Abstract c)  Rationale/Problem Statement: Explain your construct of interest. Make a case for why this construct is important to you, the field of psychology, or your specialization area. What specifically about your construct are you wanting to assess? Are there different characteristics or behaviors that can be assessed within your construct? For example, if measuring depression as a construct, would you want to measure the severity of depression or the symptoms related to depression? What are all the characteristics of depression? Would you be assessing all of the characteristics? d)  Research Question: Develop a research question addressing what you will be assessing.Literature Review: Taken from Step Two, along with any required edits. Write a 7-8 page literature review on your construct of interest and the 5-7 instruments used to assess it. Thus, the literature review should explain your construct of interest thoroughly, as well as provide thorough reviews of the 5-7 instruments used to measure it. This is slightly different from other literature reviews, whereby the idea is to review and critique the study and findings. For this literature review you are not reviewing the study but rather are reviewing and critiquing the instrument based on what studies and other research have found. The idea here is review the instrument and its usefulness in measuring your construct. Thus, what does the instrument measure, how reliable and valid is it, and what are its strengths and weaknesses?  What is lacking in the instrument which paves the way for the necessity of your newly developed instrument? How are these instruments different from what you will develop? Use 5-7 scholarly resources, including mostly research studies and articles related to your construct and the instruments used to measure it. Information should be drawn from appropriate sources, such as professional journals, test publisher websites, and dissertations. Information gathered from sources must be appropriately cited, following APA guidelines. Please be sure to include the following in your literature review:
·  A thorough discussion of each instrument you review for your construct, including the name of the test, what the test is used for, whether the test is appropriate for this area, what the reliability and validity of the test is, and what reviewers say about the strengths and weaknesses of it with regard to assessing this construct
·  What, in general, appears to be adequately assessed on each test with respect to the construct that you selected?
·  What does not appear to be adequately assessed?
·  Your literature review should justify your development of an assessment—is there a hole in what is currently being assessed that you can fill with your test? Make a case for why your proposed test would address an area that is not already well assessed.
      e)   Methodology: Provide detailed information regarding the scale that you developed, who the participants were, and how the scale was administered. Include the following:
·  Participant Selection: Explain who your participants were (e.g. total number, gender, age, etc.) and how you selected them. Be as specific as possible, as if you were giving directions to someone on how to choose and obtain the participants.  Include instructions on how informed consent was provided to the participants. Be sure to indicate whether each participant received and reviewed the consent form provided.
·  Measures: Discuss the instrument you developed, including what the instrument measures, how many items were developed, what type of scale it is (e.g. rating scale, observation, multiple choice, etc.), and how you developed the instruments (e.g. did you use examples from pre-existing scales, etc.).  Include a copy of the instrument in the Appendix.
·  Data Collection: Discuss how and where the data was collected (e.g. was the data collected via an internet survey, a group setting, individualized administrations, etc.). Was the data collected in an office setting, house, etc.? Were the participants provided with explicit instructions on how to complete the scale?
            f)  Discussion: Include the following information, using at least 2-3 scholarly sources to support your discussion:
·  Strengths and Weaknesses: Provide a thorough critique of your scale. What do you believe are the strengths of your scale? The weaknesses? Regarding test construction, are there any items that appear to be problematic or vague? Are the response choices clear and appropriate? Does the scale appear to measure the construct you have selected? How could you increase the validity of your scale?
·  Ethical Considerations: Could your participants be harmed by your scale, either in taking it or after it is finished? Address this and other possibly relevant questions of ethics.
·  Limitations: No research covers everything.  What are the obvious limitations to this study/proposal?

can you do this base on attachment and what is stated below

docx
part1
This assignment is the third step toward completing your Test Development Proposal in Week 6.  Develop a 12-15 item test/instrument on the construct of interest you selected during Step One and Step Two (e.g. depression, anxiety, self-esteem, marital satisfaction, social persuasion, job satisfaction, etc.). Construct the items and response choices for the instrument (can either be in multiple choice, true/false, rating scale, and/or open ended question format). Include an introduction to the instrument (e.g. what the test is proposing to measure and why) and explicit instructions on how the instrument should be completed by the participants. Use the Diem (2002), Derrington (2009), and Siebert (2002) websites to assist you in your item and test construction. Information gathered from sources must be appropriately cited on the References page, following APA guidelines. Your test submission should include a title page and a References page (if sources were used
part 2

Students should be working on completing their Test Development Proposal, which is the final course assignment and is due in Week Six.  In previous weeks’ assignments, students have selected a construct of interest, discussed the purpose for developing an assessment to measure the construct, developed a research question(s), conducted a literature review and critique on current assessments used to measure the construct, and constructed a 12-15 test to measure the construct.
During Week Five, students should begin administering their tests to 3-5 family members, friends, co-workers, etc. As mentioned in Week 4, please ensure that each participant reviews the consent form (which should include the instructor’s information and student’s name) provided in the Week 4 Assignment folder See Participant Consent Form.doc). Since this proposal is completely anonymous, you will not be required to return the consent forms, but will receive credit during Week 6 for acknowledging that you presented this to your participants.
Although the testing is completely anonymous, students will need to write a brief summary about the Methods used, including non-identifying information about the participants (e.g. age, gender, occupation, education level, etc.) and how the test was administered (e.g. the setting, was it administered in person or via a computer, etc.). Thus, when administering the test to each participant, please be sure to record non-identifying information about the participant, as well as document how the test was administered to the participant.
Part 3a)  A title page (final paper) b)  Abstract c)  Rationale/Problem Statement: Explain your construct of interest. Make a case for why this construct is important to you, the field of psychology, or your specialization area. What specifically about your construct are you wanting to assess? Are there different characteristics or behaviors that can be assessed within your construct? For example, if measuring depression as a construct, would you want to measure the severity of depression or the symptoms related to depression? What are all the characteristics of depression? Would you be assessing all of the characteristics? d)  Research Question: Develop a research question addressing what you will be assessing.Literature Review: Taken from Step Two, along with any required edits. Write a 7-8 page literature review on your construct of interest and the 5-7 instruments used to assess it. Thus, the literature review should explain your construct of interest thoroughly, as well as provide thorough reviews of the 5-7 instruments used to measure it. This is slightly different from other literature reviews, whereby the idea is to review and critique the study and findings. For this literature review you are not reviewing the study but rather are reviewing and critiquing the instrument based on what studies and other research have found. The idea here is review the instrument and its usefulness in measuring your construct. Thus, what does the instrument measure, how reliable and valid is it, and what are its strengths and weaknesses?  What is lacking in the instrument which paves the way for the necessity of your newly developed instrument? How are these instruments different from what you will develop? Use 5-7 scholarly resources, including mostly research studies and articles related to your construct and the instruments used to measure it. Information should be drawn from appropriate sources, such as professional journals, test publisher websites, and dissertations. Information gathered from sources must be appropriately cited, following APA guidelines. Please be sure to include the following in your literature review:
·  A thorough discussion of each instrument you review for your construct, including the name of the test, what the test is used for, whether the test is appropriate for this area, what the reliability and validity of the test is, and what reviewers say about the strengths and weaknesses of it with regard to assessing this construct
·  What, in general, appears to be adequately assessed on each test with respect to the construct that you selected?
·  What does not appear to be adequately assessed?
·  Your literature review should justify your development of an assessment—is there a hole in what is currently being assessed that you can fill with your test? Make a case for why your proposed test would address an area that is not already well assessed.
      e)   Methodology: Provide detailed information regarding the scale that you developed, who the participants were, and how the scale was administered. Include the following:
·  Participant Selection: Explain who your participants were (e.g. total number, gender, age, etc.) and how you selected them. Be as specific as possible, as if you were giving directions to someone on how to choose and obtain the participants.  Include instructions on how informed consent was provided to the participants. Be sure to indicate whether each participant received and reviewed the consent form provided.
·  Measures: Discuss the instrument you developed, including what the instrument measures, how many items were developed, what type of scale it is (e.g. rating scale, observation, multiple choice, etc.), and how you developed the instruments (e.g. did you use examples from pre-existing scales, etc.).  Include a copy of the instrument in the Appendix.
·  Data Collection: Discuss how and where the data was collected (e.g. was the data collected via an internet survey, a group setting, individualized administrations, etc.). Was the data collected in an office setting, house, etc.? Were the participants provided with explicit instructions on how to complete the scale?
            f)  Discussion: Include the following information, using at least 2-3 scholarly sources to support your discussion:
·  Strengths and Weaknesses: Provide a thorough critique of your scale. What do you believe are the strengths of your scale? The weaknesses? Regarding test construction, are there any items that appear to be problematic or vague? Are the response choices clear and appropriate? Does the scale appear to measure the construct you have selected? How could you increase the validity of your scale?
·  Ethical Considerations: Could your participants be harmed by your scale, either in taking it or after it is finished? Address this and other possibly relevant questions of ethics.
·  Limitations: No research covers everything.  What are the obvious limitations to this study/proposal?