DataPalooza 2021

ADVANCED METRIC FUNCTIONS

DISTRICT 1

DISTRICT 2

DISTRICT 3

DISTRICT 4

DISTRICT 5

Maine

Minnesota West Virginia

North Dakota Washington South Dakota Montana

New Hampshire

Missouri

Virginia

Vermont

Iowa Ohio

Virgin Island of the U.S.

Wyoming Nebraska Colorado

Idaho

Massachusetts New Jersey New York Pennsylvania

North Carolina South Carolina

California

Wisconsin Michigan

Nevada Oregon

Tennessee Arkansas Louisiana

New Mexico

Indiana Illinois

Kansas

Utah

District of Columbia

Oklahoma

Arizona Alaska Hawaii

Delaware Maryland

Kentucky

Florida

Texas

Mississippi

Connecticut Rhode Island Puerto Rico

Alabama Georgia

Guam

Federated States of Micronesia

Figure 22 – Districts

REFERENCE LINE / TREND LINE / FORECASTING The objective of this exercise is to show that different lines can be used to show the performance of a metric against a constant.

REFERENCE LINE

EDITOR & FILTER Add Quarters and Bank Cert to the Rows of our Visualization. For our metric we will add E013 Net Income / Percent of Average Assets YTD. Add Bank Cert to the Filter panel. We will want to sort by only one bank. For this exercise we will use Bank Cert 14. PLOT Once our Visualization is finished change it over to a line chart. When the Line Chart is selected then click over to the Format panel. There is a Drop down under Visualization 1, lets select that and pick Reference Lines.

30 | P a g e