Design A Fact Table, homework help Assignment Help

Design A Fact Table, homework help Assignment Help. Design A Fact Table, homework help Assignment Help.


(/0x4*br />

(QUESTION 1) #1) From the Data Model that was created back on week 1 (ATTACHED BELOW), now please
create a “FACT” Table. Fact Table Elements should be data that can be
used as a metric or for measure’s – i.e. GPA, Grading Scale (100-95),
Course Credit Hours…

Your Fact Table should also contain the Primary Keys within your Dimension Table(s) from Week #1 (ATTACHED BELOW)

.#2) Insert your Fact Table as a center point within your Data Model so it depicts a Star Schema. (USE MICROSOFT ACCESS TO DO THIS ASSIGNMENT. DO NOT COMBINE QUESTION 1 AND 2 ON THE SAME ACCESS)

(QUESTION 2.) CREATING AND POPULATING THE FACT TABLE FROM DIMENSION TABLES. For this assignment, please use the internet to research the SQL Code to perform the following:

1) Create a Dimension Table (this table can be created from the excel attached below. i.e same information can be used to create the dimension table in access)

2) Create a Fact Table

3) Load Data into the Fact Table referencing the Dimension Tables

Please do not reference any Database Tool’s Wizards on completing this exercise. I’m looking for the actual SQL Code. (USE MICROSOFT ACCESS TO DO THIS ASSIGNMENT. DO NOT COMBINE QUESTION ONE AND TWO ON THE SAME ACCESS)

Design A Fact Table, homework help Assignment Help[supanova_question]

Artisan Shutter Company, accounting homework help Business Finance Assignment Help

When the California real estate market crashed, Artisan Shutter Company encountered severe cash flow problems. Half of the company’s customers started making late payments. Eventually, the company had to lay off 15% of its employees due to insufficient cash inflows.

The primary purpose of the statement of cash flows is to provide details on the sources of case inflows and the uses of the firm’s cash that result from operating, investing, and financing activities over a period of time (month, quarter, annual). The operating activities include the cash effect of all transactions that result in revenues and expenses and determine the firm’s net income (if for-profit) and net assets (if non-profit). Investing activities refer to the sources and uses of cash resulting from the purchase or disposal of long-term assets or the lending of capital to other companies. Finally, the financing activities include obtaining cash from issuing debt (bonds and notes) or raising capital through the sale of equities on the primary market or declaring and paying dividends to stockholders; redeeming long-term debt or engaging in a stock buyback; executing call options on corporate bonds. Now, as a management official, it’s important to realize the connection between a company’s product life cycle and the statement of cash flows. There are four (4) phases in the life cycle of a product: 1) introduction, 2) growth, 3) maturity, and 4) decline. The phases within the life cycle don’t change based on the product, but the rate in which products move through the four phases may vary considerably based on changes in supply and demand which are brought about by new entrants in to a market (substitutes), economic downturns, changes in production costs to mention a few. While the product life cycle curve does a reasonably good job approximating sales and profits as products move through the four phases, it wouldn’t be prudent for management to rely solely on the life cycle to predict sales and profits. When a product is in the introductory phase, the cash from operating activities and cash from investing are negative whereas cash from financing is positive. As the product enters the growth phase, the cash provided by operating activities become positive; however, is not adequate to cover the investing needs of the firm. As the product enters the maturity phase, cash from operating activities exceed the firm’s investment needs which, in turn, permit the retirement of debt. When entering the final phase, decline, the cash from operating activities becomes negative; however, cash from investing activities becomes positive since it is assumes that the firm with sell off assets and the financing activities become more negative. Financial data from the statement of cash flow coupled with data contained within the balance sheet and income statement can be used to evaluate a company’s liquidity and solvency position, not to mention it’s free cash flow (FCF) which can be used to expand the business.

Source:

Garrison, R., Noreen, E., & Brewer, P. (2014). Managerial accounting (15th ed.). Columbus, OH: McGraw-Hill Education.

Unit Learning Outcomes

ULO 4. Use the statement of cash flows to support management decision-making. (CLO 4 and 7)

DIRECTIONS

The Artisan Shutter Company, like many companies that relied on the construction industry, took a financial hit when “housing bubble” burst in late 2007. Lenders were making subprime mortgage loans to borrowers who really couldn’t afford the principle and interest (P&I) payments and subsequently defaulted on their loans. This was followed, in 2008, by the collapse of Lehman Brothers, a global bank, which almost brought down the world’s financing system. Due to tighter banking regulations, many individuals and companies found it extremely challenging to secure loans. Despite the government’s decision to implement quantitative easing as a means of stimulating the economy, unemployment, personal and corporate bankruptcies increased. Looking at The Artisan Shutter Company and imagine that you were a member of the leadership team and noticed that the cash flow position of the company was being severely weakened by what economists perceived to be a pro-longer economic downturn. The owners are understandably concerned about the long-term viability of the firm.

Prepare a position paper that outlines strategies to improve cash position of the company as it tries to “weather the storm” and experiences a normalizing of the economy.

In order to formulate your position paper, you may want to carefully consider the problem (reflecting back to 2008 recession), collect relevant data and information, critically evaluate the alternatives, and document your recommendations using sound arguments that are well supported, properly vetted, and logically presented.

It is important that management carefully consider any potential ethical implications associated with their stated position. If there are any potential ethical concerns associated with your position, they should be identified and discussed in the position paper.

If you prepared your response in Word, the document should be prepared consistent with the APA writing style (6th edition) and reflect higher level cognitive processing (analysis, synthesis, and or evaluation).

[supanova_question]

Completing Homework : P and G Japanese market case 1970~1980 Business Finance Assignment Help

Our team is making P&G Japanese market case, 1970~1980. Problem is, we already made Introduction & Summary and conclusion, but it is hard to complete main part. Consider the context of the introduction and conclusion, please complete the text. I’m attaching table that basis of scoring and reference rules that professor gave to us. Please fulfill our report perfectly!

Scoring Basis is most! important part. Like minimum 15 references and footnotes, etc.

I have some papers and books about Japanese case. If you demand it, I’ll send you.

“No plagiarism.” Professor and our team will use plagiarism testing program. After professor’s evaluation, Your own content will pay much.

After finishing the homework, Me and our team consultation and will give you a bonus as much as possible.

[supanova_question]

Economics of the Environment Economics Assignment Help

Hey, I have answered question 1-4 and need someone to answer question 5 and go through my answers for question 1-4 and add any details I may be missing. I need detailed answers to the questions. Please only bid if you know how to do these questions. Do not bid if you are unsure how to do the following questions below. My answers are attached (questions doc) and two tutorial notes.


Thanks

It is sometimes claimed that free trade improves welfare. These questions explore this proposition. The model we will be using for trade is a simple supply and demand diagram where any amount can be brought or sold at the world price. If the world price is above the ‘no trade’ (autarky) price, there are exports, and if it is below there are imports. There is a good explanation at [but apologies for the sexual reference in first slide]

Question 1 (3 marks) Suppose Demand is P=100-3Q and supply is P=Q. Draw this demand and supply diagram for a closed economy (no imports or exports are possible) with the standard axes (P vertical, Q horizontal). Mark carefully on the diagram (for one mark each) the demand curve, the supply curve, and then work out the equilibrium (the numbers are required, not just showing the point).

Question 2 (5 marks) Mark on a new diagram a world price of 30 (1 mark); explain why no goods will be bought or sold at the autarky price (1 mark); how much is demanded at price 30? (1 mark); how much is supplied (1 mark); explain what happens to the difference between supply and demand at that price (1 mark).

Question 3 (5 marks) Mark on a new diagram a world price of 20 (1 mark); explain why no goods will be bought or sold at the autarky price (1 mark); how much is demanded at price 20? (1 mark); how much is supplied (1 mark); explain what happens to the difference between demand and supply at that price (1 mark).

Question 4 (2 marks) Mark on two new diagrams what the supply and demand curves look like (i) in the presence of a negative consumption externality with a constant value of 20 for every unit consumed and seperately (ii) in the presence of a negative production externality with a constant value of 20 for every unit consumed.

Question 5 (7 marks) Consider a market described by these demand and supply curves with the production and consumption externalities described in Question 4, and exploring the cases when the world price is 20 or 30. Does free trade always improve welfare? (1 mark) To answer this question do the following welfare calculations (1 mark for each) and see if the trade situations have higher welfare than the autarky situation. (Remember, when free trade is allowed, the world price might be above, or below, the autarky price, which is why we have to consider both cases if we want to generalize about free trade.)

For the production externality case calculate welfare in the following cases: (i) no trade with only a production externality vs (ii) importing with only a production externality and (iii) exporting with only a production externality . Then consider the consumption externality case by calculating welfare in the following cases (again, 1 mark each) (iv) no trade with only a consumption externality vs (v) importing with only a consumption externality and (vi) exporting with only a consumption externality. Your measure of welfare should always be Consumer Surplus (CS, i.e. area below demand above price) + Producer Surplus (PS, i.e. area above supply curve and below price) + any externality (which is negative in both cases).

[supanova_question]

Statistics for the Behavioral and Social Sciences, psychology homework help Humanities Assignment Help

Focus of the Final Exam

The purpose of the Final Exam is to assess your understanding of
the main statistical concepts covered in this course and to evaluate
your ability to critically review a quantitative research article. The
exam will consist of two parts: Part I includes three essay questions
and Part II includes a research critique. All of your responses should
be included in a single Word document for submission.

Please include the following general headings for each section of the written exam within your Word document:

Part I: Essay Questions

  1. Essay 1
  2. Essay 2
  3. Essay 3

Part II: Research Study Critique

  1. Introduction
  2. Methods
  3. Results
  4. Discussion

Your complete Word document must include a title page with the following:

  1. Student’s name
  2. Course name and number
  3. Instructor’s name
  4. Date submitted

Part I: Essay Questions

There are three essay questions in this section. You must answer
all three questions. The length of each essay should be one to two
double-spaced pages (excluding title and reference pages). Use 12-point
font and format your paper with regular 1-inch margins. Do not include
the essay prompt in your document. It will not count toward the length
requirement for your essays.

Essay 1

A group of researchers conducted an experiment to determine which
vaccine is more effective for preventing getting the flu. They tested
two different types of vaccines: a shot and a nasal spray. To test the
effectiveness, 1000 participants were randomly selected with 500 people
getting the shot and 500 the nasal spray. Of the 500 people were treated
with the shot, 80 developed the flu and 420 did not. Of the people who
were treated with the nasal spray, 120 people developed the flu and 380
did not. The level of significance was set at .05. The proportion of
people who were treated with the shot who developed the flu = .16, and
the proportion of the people who were treated with the nasal spray was
.24. The calculated p value = .0008.

For this essay, describe the statistical approaches (e.g., identify
the hypotheses and research methods) used in this excerpt from a
research study. Interpret the statistical results and examine the
limitations of the statistical methods. Finally, evaluate the research
study as a whole and apply what you have learned about hypothesis
testing and inferential statistics by discussing how you might conduct a
follow-up study.

Your essay must address the following points:

  • Describe the research question for this experiment.
    • What were the null and alternative hypotheses?
    • Were the results of this test statistically significant?
    • If so, why were they significant?

  • Would the researchers reject or fail to reject the null hypothesis?
  • Do the results provide sufficient evidence to support the alternative hypothesis?
  • Was the sample appropriate for this study? Explain your answer.
  • What are some possible limitations to this study?
  • Discuss how you would conduct a follow up study to this one. Explain your answer.
  • Describe the difference between practical and statistical significance.

Essay 2

A researcher has investigated the relationship between IQ and grade point average (GPA) and found the correlation to be .75.

For this essay, critique the results and interpretation of a correlational study.

  • Evaluate the correlational result and identify the strength of the correlation.
  • Examine the assumptions and limitations of the possible connection between the researcher’s chosen variables.
  • Identify and describe other statistical tests that could be used to study this relationship.

Your essay response must address the following questions:

  • How strong is this correlation?
    • Is this a positive or negative correlation?
    • What does this correlation mean?

  • Does this correlation imply that individuals with high Intelligence Quotients (IQ) have high Grade Point Averages (GPA)?
  • Does this correlation provide evidence that high IQ causes GPA to go higher?
    • What other variables might be influencing this relationship?

  • What is the connection between correlation and causation?
  • What are some of the factors that affect the size of this correlation?
  • Is correlation a good test for predicting GPA?
    • If not, what statistical tests should a researcher use, and why?

Essay 3

A researcher has recorded the reaction times of 20 individuals on a
memory assessment. The following table indicates the individual times:

2.2

4.7

7.3

4.1

9.5

15.2

4.3

9.5

2.7

3.1

9.2

2.9

8.2

7.6

3.5

2.5

9.3

4.8

8.5

8.1

In this essay, demonstrate your ability to organize data into
meaningful sets, calculate basic descriptive statistics, interpret the
results, and evaluate the effects of outliers and changes in the
variables. You may use Excel, one of the many free online descriptive
statistics calculators, or calculate the values by hand and/or with a
calculator.

Next, separate the data into two groups of 10; one group will be
the lower reaction times, and the second group will be the higher
reaction times. Then, address the following points in your essay
response:

  • Calculate the sum, mean, mode, median, standard deviation, range, skew, and kurtosis for each group.
  • How do the two groups differ?
  • Are there any outliers in either data group?
  • What effect does an outlier have on a sample?

Lastly, double each sample by repeating the same 10 data points in
each group. You will have a total of 20 data points for each group.
After completing this, address the following in your essay response:

  • Calculate the following for the new data groups: sum, mean, mode, median, standard deviation, range, skew, and kurtosis.
  • Did any of the values change?
  • How does sample size affect those values?

Part B: Research Study Critique

In this second portion of the Final Exam, you will identify and
critically evaluate a quantitative research article based on a social
science topic. Your selected article must include a research
question(s) and/or hypothesis(es) and utilize statistical analyses
covered in the course. The article must be peer-reviewed and published
within the last 10 years.

In the body of your critique, describe the statistical approaches
used, the variables included, the hypothesis(es) proposed, and the
interpretation of the results. In your conclusion, suggest other
statistical approaches that could have been used and, if appropriate,
suggest alternative interpretations of the results. This process will
allow you to apply the concepts learned throughout the course in the
interpretation of actual scientific research. Your critique must include
the following sections:

  • Introduction: This section will include a general introduction of the quantitative study from a peer-reviewed source published within the last 10 years. The research questions and/or hypothesis(es) as well as the purpose of the study should be clearly defined.
  • Methods: Describe and evaluate the procedures and methods of data collection, measures/instruments used, the participants and how they were selected, and the statistical techniques used.
  • Results: In this section describe and critique the results presented in the study.
  • Discussion: Discuss and evaluate the efficacy

    of the results presented in the study. Address, the strengths,

    weaknesses, and limitations of the study, and suggest future research

    directions. Include additional forms of statistical analyses as part of

    the suggestions for future research.

    [supanova_question]

    [supanova_question]

    Case Study Business Finance Assignment Help

    Conduct a case study analysis on the different characteristics of the supply chain of a company you choose and, in 800–1000 words, respond to a series of questions regarding the company’s supply chain strategy.

    All operational activities begin with an estimate of what customer demands will be. Production schedules, modes of transportation, warehouse space, and other supply chain activities are all dependent on the accuracy of the company’s demand forecasting. The information management system must provide thorough, accurate, and timely information so that supply chain managers can prepare and execute short and long-term plans. Satisfying the customer is the No. 1 challenge for all demand forecasters.

    Case Study Business Finance Assignment Help[supanova_question]

    Historical Case Study Humanities Assignment Help

    Select a well documented historical case study of an individual who experienced a neurological disorder, disease, or accident that resulted in an interruption in his or her vision, hearing, or motor control.

    Prepare a 7- to 10-slide Microsoft® PowerPoint® presentation addressing the following questions:

    • What neurological disorder, disease, or accident took place to interrupt this individual’s ability?
    • What behaviors were exhibited by this individual following the disorder, disease, or accident?
    • What were the individual’s deficits as a result of this disorder, disease, or accident?
    • What treatments did the individual seek? Were any available at the time?
    • What are the research implications of the case study? How did this help scientists and doctors better understand the disorder or disease? How did this case help scientists and doctors better understand how the brain works?

    Note:

    • Online students: Include substantive speaker notes.
    • Ground students: Present a 10- to 15-minute presentation along with your Microsoft® PowerPoint® slides.

    Format your presentation consistent with APA guidelines.

    [supanova_question]

    the urban world, political science homework help Humanities Assignment Help

    You will also write an eight-ten-page paper examining a contemporary urban issue. This paper will be based on the reading of at least five newspaper articles that were published during the last five years about the issue, as well as a minimum of five academic sources (academic journals or books). Your paper must include proper documentation of your sources. This includes citations in the text of your paper and a list of references at the end of your paper. You must submit with your paper copies of the newspaper articles that you consulted. You should apply concepts and ideas advanced in this course to the issue that you examine.

    Palen, The Urban World, 10h Edition

    [supanova_question]

    Proof read ad edit the paper Business Finance Assignment Help

    Our team is
    making P&G Japanese market case, 1970~1980. Problem is, we already
    made Introduction & Summary and conclusion, but it is hard to
    complete main part. Consider the context of the introduction and
    conclusion, please complete the text. I’m attaching table that basis of
    scoring and reference rules that professor gave to us. Please fulfill
    our report perfectly!

    Scoring Basis is most! important part. Like minimum 15 references and footnotes, etc.

    I have some papers and books about Japanese case. If you demand it, I’ll send you.

    “No
    plagiarism.” Professor and our team will use plagiarism testing
    program. After professor’s evaluation, Your own content will pay much.

    After finishing the homework, Me and our team consultation and will give you a bonus as much as possible.

    [supanova_question]

    two parts(python). 1- class for binary tree, 2- class to output HTML, computer science homework help Computer Science Assignment Help

    In all the classes for this assignment, use of the following Python language features is mandatory:

    It is strongly recommended to read and understand http://docs.python.org/py3k/reference/datamodel.ht… and http://www.cafepy.com/article/python_types_and_obj….

    1. Define a class that can be used to output an HTML report regarding word frequencies in an input text file. The report must identify the shortest word, the longest word, the most frequently used word, the least frequently used word, and a histogram of all the words used in the input file. The class, at a minimum, must have the following interface:
      • A constructor
      • Add a word
      • Write a report to file named `filename`

      The remainder of the class definition is left up to you.

    2. Write one or more classes that define a binary tree which can be used with the following main function.
      import random
      import sys

      def main( ):
      if len(sys.argv) < 2:
      print('Please provide the number of keys to enter.')
      sys.exit(1)
      s = int(sys.argv[1])
      parts = int(s/3)
      t = Tree( )
      r = list(range(1,s+1))

      print('Randomly inserting the numbers from 1 to {}.'.format(len(r)))

      random.shuffle(r)

      for i in r:
      print('inserted {}'.format(i))
      t.insert(i)
      f = open('a.dot', 'w')
      writeTree(t, f)
      f.flush( )
      f.close( )
      random.shuffle(r)

      for n in range(1, 3):
      m = r[(n-1) * parts : (n * parts)]
      print(len(m))
      for i in m:
      print('removed {}'.format(i))
      v = t.remove(i)
      if v:
      print('tcompleted.')
      else:
      print('terror.')
      c = chr(n + 97)
      filename = str(c) + '.dot'
      f = open(filename, 'w')
      writeTree(t, f)
      f.flush( )
      f.close( )

      The output of the program is a file in DOT syntax. The output of your program must be passed to the program `dot`, part of Graph Viz, to create an visualization of your tree. An example output file is the following:

      digraph BST{
      node [fontname="Helvetica"];
      7 -> 2;
      2 -> 1;
      null1 [shape=point];
      1 -> null1;
      null2 [shape=point];
      1 -> null2;
      null3 [shape=point];
      2 -> null3;
      7 -> 9;
      null4 [shape=point];
      9 -> null4;
      null5 [shape=point];
      9 -> null5;
      }

    [supanova_question]

    Design A Fact Table, homework help Assignment Help

    Design A Fact Table, homework help Assignment Help

    × How can I help you?