Hyperion

(1)

Hyperion Training Program

S

.

N

o

T

o

p

i

c

D

u

r

a

t

i

o

n

(

H

o

u

r

s

)

1

1 Data Warehousing Fundamentals

Data Warehousing Fundamentals

4

2

2 Hyperion Analytics

Hyperion Analytics

Services (Essbase),

Essbase Integrati

on

Services, Essbase Studio, S!, AS!

25

3

3 Hyperion Web Analysis (Analy"er)

Hyperion Web Analysis (Analy"er)

3

4

4 Hyperion #lanning $A%ter Essbase&

Hyperion #lanning $A%ter Essbase&

15

15 Deliverable:

Deliverable:

1.

1. St

St

ud

en

ts Gu

id

e

s.

2. 2. Lab Guide.

Lab Guide.

3.

3. Video

Video

Tut

orial

s recor

ded s

ession

or m

issing

classe

s.

4.

4. !er

!er

ti

ica

tio

n

"ue

sti

ons

5. 5. #ssbase application $

#ssbase application $

Sales Order processing

%.

&.

&. Planning 'pplication implementation $

Planning 'pplication implementation $

Work force Effective

%

ontact

!oint

:

aloo"a#$%a&oo.co'

earn&%perion.ordpress.co'

*'its&ar'air.ordpress.co'

+ispsolutions.ordpress.co'

(2)

Session , Date and Ti'e *rea of -ocus Session Topics  Da% Duration / Hours 0nderstanding funda'entals of Data are&ousing

DATA WAREHOUSE OVERVIEW

a. Overview b. Typical uses

DEFINITION, ARCHITECTURE AND CONCEPTS

c. Enterprise Data Model

d. Operational vs. historical data e. Extract Transform Load (ETL) f. Metadata

. Data warehouse vs. data mart h. Data minin

i. OL!" vs. OLT"

#. Massive si$e implementation %. Loical desin vs. physical desin l. &ormali$ation vs. denormali$ation m. 'eferential constraints

DATA MODELLING OPTIONS

n. Entity model o. tar schema p. nowfla%e schema

DATA MODELLING DEVELOPMENT LIFE CYCLE

. 'euirements analysis r. 'euirements atherin s. chema desin

t. *arehouse desin u. +mplementation v. ,ollow-up and review

# Da%

1 Hours Self earning

Developing candidates understanding b% reading case

studies and e2ploring latest treads in current scenario.

1

Developing une!"#$ning $%ou# D$#$ &$!e'ou"e (un$)en#$l" $n l$#e"#

#e*'ni+ue".

) Explorin current trends and techniues.

')

'eadin case studies(/isitin ,orums01ase

studies).

(3)

1 Da%#

Duration  Hour 3ui4 ,  5 Discussion Data Ware&ousing -unda'entals 3ui4.

- .ui/ #o ien#i(0 #'e 'o& ($! *$ni$#e" $!e *o)(o!#$%le &i#' D$#$ &$!e'ou"ing

(un$)en#$l" une!"#$ning 1

I-6 Da%#

Duration 6 Hours

DIMENSIONAL MODELLING DESIGN

w. Overview

x. Metadata properties y. tar schema

$. nowfla%e schema aa. 1ubes

bb. Measures and facts

cc. !ttributes and relationships dd. Dimension

ee. 2ierarchies ff. 3oins

. ummary tables and areation hh. Exercises IMPLEMENTATION OPTIONS ii. Overview ##. Top down %%. 4ottom up ll. i$in mm. 1leanin

nn. "opulatin the data warehouse

E2TRACT, TRANSFORM 3 LAOD 4ETL5 CONSIDERATIONS

oo. Definition and scope pp. Extract options . Transform options rr. Load options

ss. urroate %ey concepts

tt. lowly 1hanin Dimensions (1D)

/ Da%#

Self earning

# Hours 0nderstanding advance DWH oncepts

Developing DHW e"igning

*on"#!$in#"-5) 6nderstandin D*2 Desin constrains and techniues.

)

'eadin case studies (/isitin ,orums01ase studies).

(4)

7 Da%#  &our

Session ending 3ui4 , #

5 Discussion - .ui/ #o ien#i(0 #'e 'o& goo *$ni$#e i"

D$#$ &$!e'ou"ing De"ign *on"#!$in#" $n DWH une!"#$ning 1 II

(5)

Hyperion Ebae '.( %"n&amental

Loa&in$ ata "in$ )"le %ile

!ritin$ *alc"lation Script *reatin$ +"lti&imenional Database

)etrie,in$ ata -in$ )eport

)eportin$ -in$ !eb Analyi St"&io

A&,ance& Sprea&heet )eportin$

*reatin$ atabae O"tline

ei$nin$ an& +ana$in$ Sec"rity olicie

Optimiin$ Analytical

er,ice

imenion b"il& "in$ )"le 0ile Ebae Inte$ration Ser,ice an& Ebae St"&io

*reatin$ A$$re$ate Stora$e

atabae

Loa&in$ an& A$$re$atin$

ata

+ana$in$ A$$re$ate

Stora$e atabae an&

!ritin$ + cript

(6)

Session , Date and Ti'e *rea of -ocus Session Topics

 Da%1

 Hour

0nderstanding t&e O*! funda'entals it& respect to

Essbase

Online An$l0#i*$l P!o*e""ing Ove!vie&

1. Data Transformation.

2. Multidimensional View of Information

3.Multidimensional Data Model and Data

Analysis Technique.

4. OA! "olutions

# Da%1

 Hours

H%perion s%ste' 8 overvie and concept building for

*nal%tical services

An$l0#i* Se!vi*e" Ove!vie&

1. #usiness !erformance Mana$ement

2. %y&erion "ystem ' O(er(iew

3. %y&erion Analytic "olution

4. Analytic "er(ices

). Analytic Administration "er(ices

1 Da%1

6 Hour

0nderstanding 9ultidi'ensional Database design i'plications.

Defining Di'ensions and its 'e'bers.

C!e$#ing Mul#ii)en"ion$l D$#$%$"e" 3

Appli$#ion-1. ife ycle of the +ss,ase Analytics

Data,ase Desi$n

2. *reatin$ +ss,ase Analytics A&&lications

and Data,ases

3. *reatin$ and Mana$in$ Data,ase

Outlines

4. *reatin$ Time- Accounts- and "cenario

Dimensions

Da% 1

# Hours 3ui4  Discussion 5 Self earning 0nderstanding 9ulti Di'ensional Database concepts. Essbase Overvie. Essbase funda'entals

6 Da% 6

1 Hours

P!$*#i*e 6

• C!e$#ing )ul#ii)en"ion$l D$#$%$"e (o! "$)ple $ppli*$#ion-• De(ining Di)en"ion #0pe" (o! "$)ple

$ppli*$#ion-• Re$l #i)e i""ue" u!ing D$#$%$"e 3 $ppli*$#ion

*!e$#ion-Da% 6  Hour

Essbase -unda'entals 3ui4 , _{E""%$"e .ui/ #o ien#i(0 *$ni$#e" *o)(o!#}

level $# MDD (un$)en#$l" $n E""%$"e

(7)

ove!vie&-6

Da% 6 # Hours

;'ple'entation of Di'ensions and 'e'bers in Essbase

Outline

En'$n*ing D$#$%$"e Ou#line"

1. *reatin$ #usiness(iew Dimensions

2. "&ecifyin$ *onsolidation O&erators

and Definin$ *alculations

3. "ettin$ Time #alance !ro&erties

4. *reatin$ a,elOnly and "hared

Mem,ers

). Definin$ Du&licate Mem,er /ames

and Mem,er Aliases

0. *reatin$ Attri,ute Dimensions

Da% 6  Hours

Self earning 5 Discussion _{Une!"#$n E""%$"e Ou#line, Di)en"ion",}

Me)%e!" $n Me)%e! #0pe- Ien#i(0 gene!$l i""ue"7e!!o! o**u!" u!ing ou#line

*!e$#ion-/

Da% /  Hours

P!$*#i*e 68

o C!e$#ing D$#$%$"e ou#line (o! "$)ple $ppli*$#ion-o De(ining Di)en"ion $n i#"

)e)%e!"-o De#e!)ining Di)en"ion #0pe $n "e##ing )e)%e!

p!ope!#ie"-o I""ue" &'ile *!e$#ing )e)%e!" $n "e##ing i#" p!ope!#ie"

-Da% /  Hour

Essbase 3ui4 ,# 5 Discussion _{E""%$"e .ui/ #o ien#i(0 *$ni$#e" *o)(o!#}

level $# MDD (un$)en#$l" $n E""%$"e

ove!vie&-Da% / # Hours

0nderstanding needs of D%na'ic Di'ension +uilding

using <ule files.

C!e$#ing 9$"i* Di)en"ion" 9uil Rule" File"

*

Data !re& +ditor o(er(iew

2. *reatin$ Dimensions usin$ ules iles

3. "electin$ Dimension #uild Method

4. Definin$ ield !ro&erties

). Validatin$ Dimension #uild ules iles

0. *onfi$urin$ Dimension Maintenance

"ettin$s

Da% / 1 Hours

*n introduction to E;S _{C!e$#ing Di)en"ion $n lo$ing $#$}

u"ing

EIS-1. Desi$nin$ OA! Model usin$ +I".

2 #uildin$ Metaoutlin$.

3 #uildin$ Dimension and loadin$ data.

Da% /

# Hour

Self earning _{Une!"#$ning 0n$)i* i)en"ion %uiling}

(8)

Ei#o!-Da% 7 # Hours

P!$*#i*e 6:

Di)en"ion *!e$#ion u"ing o&n !ule (ile 4u"e! e(ine5 (o! #'e "$)ple

$ppli*$#ion-Run#i)e *'$nging Di)en"ion 3 i#" )e)%e! p!ope!#ie"-I""ue" involve u!ing Rule (ile *!e$#ion $n

e;e*u#ion-7 Da%7

# Hours

&anging Di'ension and 9e'ber t%pe d%na'icall%

C!e$#ing Av$n*e Di)en"ion 9uil Rule" File"

1. *reatin$ "hared Mem,ers

2. Mani&ulatin$ ields

3. *reatin$ serDefined Attri,utes

Da% 7 # Hours

*ttribute di'ension overvie

C!e$#ing A##!i%u#e Di)en"ion"

1. Addin$ Attri,ute Dimensions to Outlines

2. Desi$n *onsiderations for Attri,ute

Dimensions

3. *reatin$ Attri,utes with ules iles

Da% 7 # Hours

Self earning 5 Discussion

_{"cannin$ forums and identifyin$ common}

issues and errors while creatin$

Dimensions- Mem,ers and outlines.

Da% 7

# Hours

P!$*#i*e 6<

• Se##ing )e)%e! $v$n*e p!ope!#ie" u"ing !ule (ile" (o! "$)ple

$ppli*$#ion-• Co))on e!!o! $n i""ue" &'ile Di)en"ion

%uiling-Mul#iple C'oi*e .ue"#ion" 4D$0 :1 D$0 =5

• OLAP (un$)en#$l"

• An$l0#i*$l Se!vi*e" 4E""%$"e5-• H0pe!ion S0"#e) >

• Mul#ii)en"ion$l D$#$%$"e *on*ep# • E""%$"e D$#$%$"e

Ou#line-• 9$"i* ope!$#ion" on D$#$%$"e ou#line-• V$!iou" #0pe" o( Ou#line

• Rule (ile" (o! D0n$)i* Ou#line p!ep$!$#ion

• Me)%e! p!ope!#ie"4S'$!e, Neve! S'$!e, UDA5 • A##!i%u#e Di)en"ion

= Da%>

Hours 6

oading data into outlines and dealing issues during data

loading.

Lo$ing D$#$

1. Data oad O&tions

2. oadin$ Data from lat iles

3. !erformin$ reeorm Data oads

4. oadin$ Data with ules iles

(9)

Da% > Hours #

P!$*#i*e 6?

• De(ining ne& Di)en"ion $" $##!i%u#e #0pe u"ing Ou#line ei#o! • De(ining ne& Di)en"ion $" $##!i%u#e #0pe u"ing Rule File" • F!ee (o!) lo$ing

$#$-• Lo$ing $#$ u"ing Rule (ile"4&i#' Mul#iple "*en$!io5 in S$)ple 9$"i* $ppli*$#ion

• Lo$ing $#$ (!o) S.L Sou!*e

• De$ling &i#' e!!o! (ile"- I""ue" !el$#e lo$ $#$

($il-Da% > Hour #

Se""ion en +ui/, Sel( Le$!ning 3 Di"*u""ion

Vi"i#ing #o #'e (o!u)" $n ien#i(0ing v$!iou" )e$n" #o uplo$ $#$ in#o

E""%$"e- Op#i)i/ing #'e lo$ p!o*e"" $n v$!iou" #e*'ni+ue" #o lo$ $#$ u"ing !ule $n (!ee (o!)

lo$ing-8 Da%=

6 Hours

0nderstanding 5 ;'ple'enting +usiness <ules using alc Script

C$lul$#ing #'e E""%$"e An$l0#i"

D$#$%$"e

1. Outline *alculations

2. *alculation "cri&ts

3. Two!ass *alculations

4. Dynamic *alculations

). Dynamic Time "eries

Da% =

# Hours

P!$*#i*e 6=

• W!i#ing %$"i* *$l* "*!ip#-• W!i#ing Ou#line *$l* "*!ip#-• Developing

(o!)ul$"-• C$l*ul$#ing Ti)e Se!ie" D$#$ • Developing C$l*ul$#ion S*!ip#"

• Co))on e!!o! &'ile &!i#ing *$l* "*!ip#"

Da% = # Hours

Ien#i(0ing *o))onl0 u"e (o!)ul$" $n i""ue" $""o*i$#e &i#'

#'e)-Mul#iple C'oi*e .ue"#ion" 4D$0 @1 D$0 5

• Lo$ing $#$ une! v$!iou" "*en$!io" 4F!ee (o!) $n Rule File"5-• D0n$)i* Ou#line *!e$#ion &i#' lo$ing

$#$-• 9uiling "i)ple *$l*ul$#ion "*!ip#"-• Av$n*e *$l*

(10)

"*!ip#"-? Da%8 Hours 6

Navigating Data using report script and s'art vie(s&ort cut)

Re#!ieving D$#$

1. "mart View O(er(iew

2. *onnectin$ to the Analytic "er(er

3. etrie(in$ Multidimensional Data into

Twodimensional "&readsheet

e&orts

4. /a(i$atin$ Throu$h "&readsheet

e&orts

). Mani&ulatin$ Multidimensional Data

0. "mart View O&tions.

5. e&ort "cri&ts.

Da% 8 # Hours

P!$*#i*e 6@

W!i#ing Repo!# "*!ip#" 4E""%$"e !epo!#" "*!ip#5 (o! "$)ple 9$"i*

D$#$%$"e-W!i#ing %$"i* Sp!e$ S'ee# !epo!#"4U"ing D!ill Do&n, D!ill UP, Pivo#"5

9$"i* Sp!e$ S'ee# Repo!#"

I""ue" $n *o))on e!!o! o**u!" u!ing $#$

!e#!iev$l-Da% 8 # Hour

Vi"i#ing (o!u)" $n "eeing "$)ple !epo!#", i-e Top BN An$l0"i", D!ill Do&n, Roll Up, Pivo#ing

+ue!ie"-Da% ? 1 Hours

+uilding reports using 9S E2cel it& H%perion Essbase client.

Av$n*e Sp!e$"'ee# Repo!#ing

1. &datin$ Data on the Analytic "er(er

2. *reatin$ reeorm e&orts

3. "electin$ Mem,ers

4. *reatin$ eusa,le ueries

). +6tendin$ the "&readsheet

0. +n(ironment with Visual +6&lorer

Da% ?

# Hours

0nderstanding basic securit% policies and user 'anage'ent

De"igning $n M$n$ging Se*u!i#0

Poli*ie"

1. ser Mana$ement and "ecurity

2. ontrollin$ Access to Data,ase ells

Da% ? # Hours

P!$*#i*e 6

• D$#$ lo$ing u"ing Sp!e$

S'ee#-• W!i#ing F!ee (o!) !epo!#" (o! "$)ple %$"i* $ppli*$#ion • W!i#ing Sp!e$ S'ee#

(11)

!epo!#"-Da% ?  Hours

Se""ion en +ui/, Sel( Le$!ning

3 Di"*u""ion

Vie&ing $n i)ple)en#ing "p!e$ "'ee# !epo!#" $n

Da%  # Hours

P!$*#i*e 6

• C!e$#ing u"e!" 3 g!oup"-• Se##ing $**e""

pe!)i""ion"-• De(ining "e*u!i#0 poli*ie" (o! D$#$%$"e

Da%  1 Hours 0nderstanding various tec&ni@ues to en&ance *nal%tical Services !erfor'ance.

Moni#o!ing Pe!(o!)$n*e

* Im&ro(in$ Analytic "er(ices

!erformance.

'* O&timi7in$ Analytic "er(ices

*aches.

+* O&timi7in$ Data,ase estructurin$.

* O&timi7in$ Data oads.

* O&timi7in$ *alculations.

-* O&timi7in$ e&orts and Other Ty&es

of etrie(al.

Da%  1 Hours

Se""ion en +ui/, Sel(

Le$!ning 3 Di"*u""ion

Une!"#$n #'e $#$ lo$, Repo!#"

_{!e#!iev$l op#i)i/$#ion}

#e*'ni+ue"-Con"ie!ing v$!iou" !e$l #i)e

"*en$!io"-I""ue" $n e!!o!" nee #o e$l &'ile

i)ple)en#ing

op#i)i/ing-Mul#iple C'oi*e .ue"#ion" 4D$0 >1 D$0 5

• D$#$ !e#!iev$l u"ing "p!e$ "'ee# !epo!#" • D$#$ lo$ing u"ing Sp!e$ S'ee#

(12)

Topic # ( Hyperion !eb Analyi 3Analyer4

Hyperion Analyer O,er,ie5

*reatin$ )eport

A&,ance )eportin$ Techni6"e

)elational 7 *"tom )eport

(13)



Da% #

Hours 1

0nderstand t&e installation steps and creating basic reports.

;nstallation of H%perion

Analy"er Setting up

environment*

Hyperion Analy"er !vervie.*

'

Da% #

Hour 

Designing eb reports reating +asic reports

Da% # Hours #

!ractice , 

• De"igning %$"i* !epo!#" • Repo!# &i#' (il#e!"

Da% # Hours 

Self learning

_{/isiting %orums and identi%ying}

the real time implementation o%

Hyperion Analy"er reporting*

Designing basic reports and

sample reports*

Da% # Hours 

3ui4 5 Discussion. _{Ien#i(0ing #'e nee" o(}

eveloping An$l0/e! !epo!#" $n in#eg!$#ing &i#' E""%$"e

D$#$%$"e-+

Da% 1

Hour #

Designing usto' <eports

_{Designing #inboards, 0ustom}

reports, H123 Web 0lients

Da% 1

Hours 

Designing *dvance <eports

_{Designing Advance and}

4elational reports*

Da% 1

Hours 

Aeneral *nal%4er *d'inistration

_{Administration 1ools}

Da% 1 Hours # P!$*#i*e6 • Cu"#o)i/ing !epo!#" • De"igning pin%o$!" • HTML We% *lien#"

• De"igning Av$n*e $n Rel$#ion$l !epo!#"-• Repo!#

A)ini"#!$#ion-Da% 1 Hours 

Self earning _{Ien#i(0ing #e*'ni*$l i""ue"}

$n "$)ple *$"e

"#u0-Da% 1 Hours 

Tec&nical Discussion

_{Discussion about common issues}

and techni5ue %ollo.s .hile

report creation*

Mul#iple C'oi*e .ue"#ion" 4D$0 81 D$0 :5 • H0pe!ion An$l0/e! Con*ep#"

• De"igning &e% !epo!#"

(14)

66667ote 8 1his case study is no. part o% Essbase 1raining*

Topic # 8 Ebae *ae St"&y Sale Trac9in$

-n&ertan&in$ B"ine )e6"irement

Analyin$ the c"rrent ytem an& plan 0or the atabae O"tline

roce 0or &ei$nin$ a atabae

ei$nin$ +"lti&imenional atabae O"tline

*"tomiin$ *alc"lation cript Loa&in$ ata 0rom %lat 0ile/)B+S

!ritin$ Sprea& Sheet 7 !eb )eport

Ebae Ser,er A&minitration

Ebae Ser,er Optimiation an& +onitorin$ per0ormance

(15)

Seion # ate an& Time Area o0 %oc" Seion Topic



Da% 6

Hours #

0nderstanding +usiness

<e@uire'ents

E9plaining sales trac:ing system process %lo.

_{diagram, various entities involved Dra. E4}

Diagram*

'

Da% 6

Hours 7

*nal%4ing t&e current s%ste' and plan for t&e

Database Outline

Writing S4S and process %lo. diagram* 1echnical

documentations(H3D 33D)

+

Da% / Hours 6



Da% / Hours 6 Di'ensional 9odeling +asics

!rocess for designing a Database

Design Data 2odel* Identi%ying Dimensions,

2embers, 2easures (Fact 1able), DWH !perations*

Writing documentations %or the all the above*



Da% 7

Hours =

Designing 9ultidi'ensional Database Outline

5

oading Data fro' -lat files

2apping DWH concept and design model .ith real

time Essbase !utline designing* 3oading data %rom

Data Source*

-

Da% >

Hours 6

usto'i4ing alculation

script

Writing basic calculations scripts %or rollup, Actual,

_{udget, /ariance , 2argin, 4evenue, 0!;S, Sales ,}

2onthly<=uarterly<>early !pening<0losing

Inventory ,E9pense calculation, 0ommission,

payroll, discount, %inancial calculations*

?

Da% >

6 Hours

Writing Spread S&eet

_{Writing spear sheet reports %or 1op @7 Analysis,}

Sales<4evenue<2argin<E9pense reports based on

time and mar:et analysis*

B

Da% =

6 Hours

Web <eports

_{Writing .eb reports %or !nline Analysis}

C

Da% =

# Hours

Essbase Server

*d'inistration

ac:ing up, restoring users, groups creation



Da% =

# Hours

Essbase Server Opti'i4ation and 9onitoring

perfor'ance

Writing 2D scripts to optimi"e the data load<0alc

script*

(16)

Topic # : Hyperion lannin$

Planning Overview, Dimensions and Data Storage Overview

Creating & Customizing Data Forms and Folders

Entering Data on the Web & Smart iew

Mana$in$ the A&&ro(al !rocess and *reatin$ Tas8 ists

Creating !usiness "ules and !uilding "untime Prom#ts, $dding Formulas

Creating !asi% "e#orts

$dding $uto Cal%ulations and athemati%al Fun%tions

Creating, ani#ulating and Distributing Web $nal'sis Do%uments

Setting (# the Period, S%enario, and ersion Dimension

Setting (# Entit' and $%%ount Dimension,

)oading etadata *rom a File and though EP$ Dimension librar' +

(17)

 Da% 8

Hours 

!lanning Overvie Di'ensions and Data

Storage Overvie

!lanning Overvie

%y&erion "ystem ' O(er(iew %y&erion "ystem ' !lannin$

elationshi& #etween !lannin$ and +ss,ase Analytics

+ss,ase Analytics Terminolo$y /a(i$atin$ the !lannin$ 9e, *lient

2 Da% 8

Hour 

!lanning Di'ensions and Data Storage Overvie

!lannin$ Dimensions O(er(iew equired Dimensions

serDefined Dimensions Dense Dimensions

"&arse Dimensions

Data #loc8 *reation !rocess

"electin$ A$$re$ation- Data "tora$e- And *alculation O&tions

3 Da% 8

Hour 

Di'ension creation Setting 0p t&e !eriod Scenario and Bersion Di'ension

• Time !eriods O(er(iew • !eriod and :ear Dimensions • "ettin$ u& Dynamic Time "eries • *hoosin$ %ow Data is "tored • "cenario Dimension and *reatin$

"cenarios

• Version Dimension and *reatin$

Versions

- Da% 8

Hour 

oading 9etadata oading 9etadata fro' a -ile

• Time !eriods O(er(iew • !eriod and :ear Dimensions • "ettin$ u& Dynamic Time "eries • *hoosin$ %ow Data is "tored • "cenario Dimension and *reatin$

"cenarios

• Version Dimension and *reatin$

Versions

. Da% 8

Hour 

reating and usto'i4ing Data -or's and -olders

Writing Data Forms

Data orms and olders O(er(iew

*reatin$ older "tructures for Data orms Data orms equirements

Assi$nin$ Access i$hts to Data orms. Mana$in$ ser Varia,les

"ettin$ & ser !references

/ Da% 8

Hours #

Entering Data on t&e Web Entering Data T&roug& S'art

Bie

Entering Data

"u,mittin$ Data sin$ Data orms Ad;ustin$ and Annotatin$ !lan Data

*alculatin$ Data in Data orms "mart View O(er(iew

(18)

!lannin$ and "mart View /a(i$atin$ Data orms

+nterin$ and *alculatin$ Data Accessin$ Data Offline

+ss,ase Analytics and "mart View !erformin$ Ad %oc Analysis

Da% 8 Hours #

Pra%ti%e 0 

Creating sam#le a##li%ation+

Creating and %ustomizing Data Forms Entering Data using Smart iew and Web

1 Da% 8

Hours 

Self earning 3ui4 and discussion.

 Da% #?

Hours #

reating 5 +uilding <unti'e +usiness <ules

Creating !usiness "ules

#usiness ules O(er(iew /a(i$atin$ #usiness ules

#usiness ules *reation !rocess

aunchin$ #usiness ules from the 9e, !rintin$ #usiness ules

untime !rom&ts O(er(iew Addin$ untime !rom&ts

 Da% #?

Hours #

*dding -or'ulas to +usiness <ules

!rocess 9anage'ent

Writing Formulas

Addin$ Auto *alculations to Data ows and *olumns

Mathematical unctions and !ro&erties Mathematical O&erators in +6&ressions ormula ows- *olumns- and *ells *ommon Mathematical unctions !rocess Mana$ement O(er(iew

Mana$in$ e(iew *ycles for !lannin$ nits *o&yin$ Data #etween Versions

4 Da% #?

Hours #

Pra%ti%e 0 2

• !uilding !usiness "ules • $dding *ormulas

 Da% #?

Hours #

Self earning and 3ui4

2 Da% #

Hours 6

reating <eport ObCects *dding Te2t -unctions

Creating "e#orts

e&ort O,;ects O(er(iew

*reatin$ Te6t #o6es and Addin$ Ima$es "a(in$ and Insertin$ e&ort O,;ects in8in$ e&ort O,;ects

Desi$nin$ %eaders and ooters Te6t unctions O(er(iew

Insertin$ Te6t unctions in Te6t #o6es-%eadin$s- and Te6t *ells

*reatin$ Dynamic Values with *urrent <eywords

(19)

3 Da% # Hours #

<evieing !lanning Data it& Web *nal%sis reating 9anipulating and

Distributing Web *nal%sis Docu'ents

5ntegrating With Web $nal'zer

9e, Analysis Architecture <ey #enefits of 9e, Analysis <ey *once&ts

/a(i$atin$ 9or8s&ace and 9e, Analysis "tudio

9or8s&ace and 9e, Analysis "tudio Tas8s Definin$ ueries

"ettin$ Document ormat O&tions *reatin$ *hart Views

/a(i$atin$ Documents Mani&ulatin$ Data

Distri,utin$ 9e, Analysis *ontent anaging the $##roval

Pro%ess and Creating 6as7 )ists

anaging the $##roval Pro%ess and Creating 6as7 )ists

Mana$in$ the e(iew *ycle for !lannin$ nits

*o&yin$ Data #etween Versions *o&yin$ Data

/a(i$atin$ Tas8 ists Tas8 ist *reation !rocess

#uildin$ Tas8 ists and Assi$nin$ Access to Tas8 ists

Validatin$ Tas8 ists e&ortin$ on Tas8 ists

- Da% #1

Hours #

Pra%ti%e 0 3 Creating "e#orts

• 8avigating using Web $nal'sis+

. Da% #1

Hours #

Self earning Visitin$ forums and identifyin$ common issues and errors durin$

Mul#iple C'oi*e .ue"#ion" 4D$0 >1 D$0 85 • Pl$nning Ove!vie&

• Di)en"ion" $n D$#$ S#o!$ge Ove!vie&

• C!e$#ing $n Cu"#o)i/ing D$#$ Fo!)" $n Fole!" • En#e! D$#$ u"ing We%7S)$!# Vie&

• 9uiling 9u"ine"" Rule" • In#eg!$#ion Wi#' We% An$l0"i"