Your personal footprint

/in /by

  1. Summarize and discuss your personal footprint? (include the three (3) screen capture images here *Please be neat and crop/orient/place them appropriately) (12 marks)

a. What are your thoughts on your footprint? Does it make sense? Why? Why not?

b. Was it lower than you expected? Was it what you expected? Or was it higher than you thought?

c. Do you think your carbon footprint will vary throughout the year? Why?

d. What do you think of the impact you are having on the environment?

e. How does your carbon footprint compare to the national average?

  1. Why is the concept of a carbon footprint an important ides for the Canadian Public to be aware of and to understand? (4 marks)
  2. Identify and explain two (2) actions that you can undertake to reduce your carbon footprint? Why did you select these two options? (4 marks)

Sample Solution

The post Your personal footprint appeared first on homework handlers.

Income Statements Exercise

/in /by

Build a financial model for valuation of a company.

You’ll start with using historical income statements and build a ten year forecast using the information (attached in the document). This probably sounds easier than it is. I would suggest that you start with the unit growth (compounded) and forecast the units first. From there you have to calculate what you will charge per unit for general revenue and guess what you want to do with Management revenue. From here, you’ll need to decide what expenses are fixed and what are variable and how the forecast should be calculated.

Sample Solution

The post Income Statements Exercise appeared first on homework handlers.

Data analysis projects.

/in /by

Cite the references and provide the references?

  1. The collection of data is not the onset of data analysis projects. A data analysis project begins with a purpose, problem, and research questions.

Find one scholarly research paper with an excellent example of:

Problem statement

Research questions

The example shall relate to a practical, real-world work environment in the information technology field. After finding the research, discuss the following:

What makes this example excellent in the topics that initiate a data analysis project?

What relates this example to a practical, real-world work environment in the information technology field?

Do the research questions meet the criteria defined in the lecture in week one?

What is the generalizability of this research?

  1. Check out this website called The 25 Best Data Visualizations of 2019 https://visme.co/blog/best-data-visualizations/. Select one data visualization example that appeals to you the most. Using your own words, answer the following questions:

Why do you think it was identified as one of the 25 best?

How many dimensions of information were captured?

Do you find the data useful?

What do you like most about it?

What do you like least?

Sample Solution

The post Data analysis projects. appeared first on homework handlers.

Mysql online data base

/in /by

Must develop and ERD diagram for an Online retail business of choice. The retail business must be able to collect CC payments. At minimum the developed relational database must collect and store the following information;
    Stock
    Customer Details
    Orders
    Suppliers
    Payments
    Returns

Using the ERD diagram that was developed earlier in Part A now expand upon the original ERD and develop and populate a real life Relational Database to hold their business data and ALSO a Data Mart to support the reporting requirements of the retail company.

In order to implement this Data Mart students are required to automate the loading of the data from the live production database to the Data Mart. This should be done by scripting.

Project Report Document
a.    Background Information Document and relevant graphs connected via Excel to 2 reports of YOUR CHOICE
b.    Script File to Create the Data Mart database and tables and the following reports
c.    The Data Mart SHOULD ONLY CONTAIN results only from Views  (Questions 1, 3 and 4 ONLY)

1. Create a View showing all transactions for a given week in your business.
2. Create a trigger that stores stock levels once a sale takes place.
3. Create a View of stock (by supplier) purchased by you.
4. Create a View of Total stock sold to general public (group by supplier).
5. Detail and total all transactions (SALES) for the month-to-date. (A Group By with Roll-Up)
6. Detail and total all SALES for the year-to-date. (A Group By with Roll-Up)
7. Detail & total transactions broken down on a monthly basis for 1 year. (A Group By with Roll-Up)
8. Display the growth in sales/services (as a percentage) for your business, from the 1st month of opening until now.
9. Use Excel to create a graphical representation of any 2 of the queries of YOUR CHOICE, for example Q1 & Q4. (Any type of graph)
10. Add both the SQL statements and graphs into a Word document report (Your SQL code and the screenshots and relevant graphs & ERD Diagram). The Word document must show the results of your queries when run (Screen shot of the Output).