Briefly explain explanatory and predictive analytics

Assignment Help Computer Engineering
Reference no: EM131172991

1. Using ch10_abc_markets database, write the SQL code to select the invoice year from inv_date with the column name invoiceYear, the invoice month from inv_date with the column name invoiceMonth, the invoice day from inv_date with the column name invoiceDay, and the sum of the invoice total with the column name invoiceTotal from the invoice table. Group the results by year, month, and day using the ROLLUP subclause.

QUESTION: What does the rollup subclause provide in terms of grouping and how does it differ from the CUBE subclause?

2. Using ch10_abc_markets database and invoice table, write the SQL code to select the invoice number, line number and the sum of the line price as sumLP. Group the results using grouping sets of invoice number and line number to show the sumLP by invoice number order.

QUESTION: What is the purpose of the GROUPING SETS subclause and what is its primary use?

3. What is data analytics? Briefly explain explanatory and predictive analytics.

Reference no: EM131172991

Questions Cloud

Explain the existing security situation in the organization : Explain the design approach and rationale. Prove that the design meets the data rate requirements. Analyze the existing security situation in the organization. Identify the predominant electronic and physical threats to communications networks.
Part of a new project that the firm is planning : The following activities are part of a new project that the firm is planning. If the project is planned using the critical path method, how would the network look? What is the critical path? Also, estimate the completion time for this project.
Determine the force on each of the four bolts : Four bolts in the holes shown in the Figure hold the window in place. If the windows are to be installed with their centers at a depth of 3 ft below the surface of the water, determine the force on each of the four bolts.
How do manager apply evidence based management : how do manager apply evidence-based management, which seems to suggest that managers should rely on facts and data?
Briefly explain explanatory and predictive analytics : What is the purpose of the GROUPING SETS subclause and what is its primary use? What is data analytics? Briefly explain explanatory and predictive analytics.
Determine the total force exerted on the wall : A wealthy eccentric is interested in having an entire interior wall of his home converted to a seawater aquarium. Determine the total force exerted on the wall and location of its resultant if the wall is 3 m high and 7 m long.
Stage of the strategic process : How are evaluation and control different for each stage of the strategic process (planning, implementations, evaluation and control)?
Calculate the force available to extend and retract cylinder : To retract, air is supplied to the "rod end" pushing on the piston, except for where the rod attaches. Calculate the force available to extend and to retract the cylinder if the piston bore has a diameter of 3 in and the diameter of the rod is 7 /..
Differences between the two : Often in management, we discuss evaluation and control as if they are one process. What are the differences between the two? Should they be so closely related?

Reviews

Write a Review

Computer Engineering Questions & Answers

  Mathematics in computing

Binary search tree, and postorder and preorder traversal Determine the shortest path in Graph

  Ict governance

ICT is defined as the term of Information and communication technologies, it is diverse set of technical tools and resources used by the government agencies to communicate and produce, circulate, store, and manage all information.

  Implementation of memory management

Assignment covers the following eight topics and explore the implementation of memory management, processes and threads.

  Realize business and organizational data storage

Realize business and organizational data storage and fast access times are much more important than they have ever been. Compare and contrast magnetic tapes, magnetic disks, optical discs

  What is the protocol overhead

What are the advantages of using a compiled language over an interpreted one? Under what circumstances would you select to use an interpreted language?

  Implementation of memory management

Paper describes about memory management. How memory is used in executing programs and its critical support for applications.

  Define open and closed loop control systems

Define open and closed loop cotrol systems.Explain difference between time varying and time invariant control system wth suitable example.

  Prepare a proposal to deploy windows server

Prepare a proposal to deploy Windows Server onto an existing network based on the provided scenario.

  Security policy document project

Analyze security requirements and develop a security policy

  Write a procedure that produces independent stack objects

Write a procedure (make-stack) that produces independent stack objects, using a message-passing style, e.g.

  Define a suitable functional unit

Define a suitable functional unit for a comparative study between two different types of paint.

  Calculate yield to maturity and bond prices

Calculate yield to maturity (YTM) and bond prices

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd