ACCT 307 FINAL EXAM QUESTIONS AND ANSWERS WITH COMPLETE SOLUTIONS VERIFIED

ACCT 307 FINAL EXAM QUESTIONS AND ANSWERS WITH

COMPLETE SOLUTIONS VERIFIED


Predictive Analysis

generating a forecast of future revenues and expenses

SQL Query Template

Select

From

On

Where

Group By

Order By

ETL abbriveation

Extract

Transform

Load

Table Chart

the fields that you want displayed in the resulting table

Matrix chart

-the fields across which you will aggregate data

-the field you wish to aggregate

Bar Chart

, -the field specifying different groups

-the field you wish to compare across groups

Line Chart

-the time/date field if you wish to examine trends

-the field you want to examine over time

Scatter Chart

- any field that appropriately specifies the unitr of observation

-two fields to compare in a multivariate analysis

Maps

Whatever geospatial data field that Power Bi will recognize and use to create a map

Exploratory Data Visualization

to understand the data, to develop and assess a hypothesis or question or find a pattern

in the data

Explanatory Data Visualization

shows specific relationships in data, such as link between causes and results

Gestalt Principles

-Proximity

-similarity

-enclosure

-connection

-symmetry

-continuity