Discover millions of ebooks, audiobooks, and so much more with a free trial

Only $11.99/month after trial. Cancel anytime.

QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense
QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense
QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense
Ebook1,166 pages11 hours

QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

Rating: 0 out of 5 stars

()

Read preview

About this ebook

Unlock the meaning of your data with QlikView

The Qlik platform was designed to provide a fast and easy data analytics tool, and QlikView Your Business is your detailed, full-color, step-by-step guide to understanding Qlikview's powerful features and techniques so you can quickly start unlocking your data’s potential. This expert author team brings real-world insight together with practical business analytics, so you can approach, explore, and solve business intelligence problems using the robust Qlik toolset and clearly communicate your results to stakeholders using powerful visualization features in QlikView and Qlik Sense.

This book starts at the basic level and dives deep into the most advanced QlikView techniques, delivering tangible value and knowledge to new users and experienced developers alike. As an added benefit, every topic presented is enhanced with tips, tricks, and insightful recommendations that the authors accumulated through years of developing QlikView analytics.

This is the book for you:

  • If you are a developer whose job is to load transactional data into Qlik BI environment, and who needs to understand both the basics and the most advanced techniques of Qlik data modelling and scripting
  • If you are a data analyst whose job is to develop actionable and insightful QlikView visualizations to share within your organization
  • If you are a project manager or business person, who wants to get a better understanding of the Qlik Business Intelligence platform and its capabilities
What You Will Learn:

The book covers three common business scenarios - Sales, Profitability, and Inventory Analysis. Each scenario contains four chapters, covering the four main disciplines of business analytics: Business Case, Data Modeling, Scripting, and Visualizations

The material is organized by increasing levels of complexity. Following our comprehensive tutorial, you will learn simple and advanced QlikView and Qlik Sense concepts, including the following:

Data Modeling:

  • Transforming Transactional data into Dimensional models
  • Building a Star Schema
  • Linking multiple fact tables using Link Tables
  • Combing multiple tables into a single fact able using Concatenated Fact models
  • Managing slowly changing dimensions
  • Advanced date handling, using the As of Date table
  • Calculating running balances
Basic and Advanced Scripting:
  • How to use the Data Load Script language for implementing data modeling techniques
  • How to build and use the QVD data layer
  • Building a multi-tier data architectures
  • Using variables, loops, subroutines, and other script control statements
  • Advanced scripting techniques for a variety of ETL solutions
Building Insightful Visualizations in QlikView:
  • Introduction into QlikView sheet objects — List Boxes, Text Objects, Charts, and more
  • Designing insightful Dashboards in QlikView
  • Using advanced calculation techniques, such as Set Analysis and Advanced Aggregation
  • Using variables for What-If Analysis, as well as using variables for storing calculations, colors, and selection filters
  • Advanced visualization techniques - normalized and non-normalized Mekko charts, Waterfall charts, Whale Tail charts, and more

Building Insightful Visualizations in Qlik Sense:

  • Introducing Qlik Sense - how it is different from QlikView and what is similar?
  • Creating Sense sheet objects
  • Building and using the Library of Master Items
  • Exploring Qlik Sense unique features — Storytelling, Geo Mapping, and using Extensions

Whether you are just starting out with QlikView or are ready to dive deeper, QlikView Your B

LanguageEnglish
PublisherWiley
Release dateJul 22, 2015
ISBN9781118949573
QlikView Your Business: An Expert Guide to Business Discovery with QlikView and Qlik Sense

Related to QlikView Your Business

Related ebooks

Enterprise Applications For You

View More

Related articles

Reviews for QlikView Your Business

Rating: 0 out of 5 stars
0 ratings

0 ratings0 reviews

What did you think?

Tap to rate

Review must be at least 10 words

    Book preview

    QlikView Your Business - Oleg Troyansky

    IHdbook_preview_excerpt.html۲&*NTIU:ٙ,۱^U} h}}ߕ~~<7 7}VIotOwO?HǺoDzs/qݾ*PjwPtijvUs۲z(&#>yZ/Mv}U=?+&SSwqgڔ,Uڭ<[]Q>>ҝbeZ}%x+n} SoG>XuwbCG|jc7 Ks>FyFhW˱Xiwv]q{]uY4݈;rÇcE{:dֱ27,kQGe[N/r=,0d#2޺`+92X=WPr&w(evgbCwjjX<[ EUXcUmw1?}ۏ7zӗ\O'9+Ooa\P(g)KYUŦ8q~ơV'c7eSNOve[R!9Fz-t$_o=FJv_fҳeꍐqnԭi˅{2Usġù"Y?7UٷB[0:/n/}| XM A 9ip/#~R&Д UW9v(`fաRޡS"؜N WN%zc}u{cN-UCM%}UVȽ;-1xn&:rcsSԜaȮ4yUI# d;dBG[o@e{hmԵf}A =+*d]ak!zP R׃{ dRd\:ۅl/oc7\ r\9 ( Z UNɏMcrrĔx6W/ G!o$VTTe O~%rCj~#|bobJjP9 ;R8UNu cu :6?0>ay(֑#ۈjJw9V$LlL6Ao]CZ˥jaɎբ_M=^|_ԫ}Ggwe[8qd]eR(S-2x?+nP}*@!ؼ^׈|$=e"$T ul\6s*>G\1 [BWs8U'C[G'{NsUJRIN>]ꪄ#]BC%\E+vV83tnb SIwb$N/ۏ^D@u5ۺb8eP ؉,i?jLdV%y~G!Bmqc:WM̍d q,WxJoߨ4?pOH> @MN(+fJc; z2-/ `Un܌sb4i}zT]Q6aoԄ1您RQ'نQE^֥v}MԌqiateLџq'>ȟU5ʴ?fwU7! +ѡV>涐d6 ew"e8VTwZeێ6! $OMKŵ7_Vq1g=|1k g)*UA8TDXXmt;(/h00]-)5a%ucVHϢ$fSP}I)rYi}!jϏ݄*TO᪞!?ԇ f;U{.<څ•mHUoy {39}8xy'\)=w; S~5DaE2tE"-l3`/:lGOdf0v,Z^|CѦZNCm%j"Pkڋ[^9E2 v .^I? e,8uzJ.LVN`q+341qEw΢62":MFo) ֟0fU]x; ͎r~be@U#W=v'{fR´ٯ.?14F^Uʧ@*O:~w6僯N/Fc(ofR'Kv@~p'3A y@<(hd Nmӭ߫K~,KDYqf&' @G$ŎG>?@vXٶIǻ; !79( ~va EXmV5T@+J4껲Ӡyӯ!#2*{z#$(2@iLDX*Ûnq2Ȑu?0%px1!K}Z0Dl:U`;a?|wPTL}m,P]b=ɖ6KFk,"v*U ]N/*_ k,r4CSMٞ]!7+`܉D F>b[nXv2DDq _B˓I|z":z.6/ErvśzɕcE5e6HF0 Yk$G&>ek0#w3B/'8lN=i`=߭Qʄd5< Yɕ %md/>_^܌]=DO&ճVH87@^,nmF8#~ MK͖td1=2MO~㳿z&!!jn x+&,mJA?:4e7@Dsg8YAYF@( 8SMz@g?}u(|.]TXC?#y+7f + *wVt|MvۙGN6 ܝ4ؔ1l;xg1J35 >!_~&܊ [f[t;)hwa)#.c*qQQѹ)F#] a~E #XA%Nĩb$3SА~]ЌJRW5QWs+pd;ɼn߹-"7sX9nJ7`QИ0b%^ƴdazVtQ3] -g %8m b8LMύa0wes (ٵx^D ͝1Q!~.iUZ?۶Syw5d% XJ (Wrs;[~"շ9Br_U9n̮l]vL!(w; scEW 'j[/kSƀ2exxm3,  PY#SלwS^=b0n!gUY}wY܌y\#Ԍ;B+Zl0'j>@ 36c)nsB܂_?VUD1A؋Tb0+KaVPڃBB ̥&V(ڙey%''2!} ?qtQ S>9Tf'6;P{C]aQ"3%#B) kTft@EZT1Tޜj*U[Pce{|k|*zE$?7գvARǨ]j%ZowH8 M ȼ2Zֽ J*Լ8مGߧǓ-CE,)qBr,ҜQXܭ$\Q#L݇ba)>?vtJ2Qʻ Al1}稆35UA{'ﶣ{S4krJ~pESmvU2-CG(F pӨxNC@!hF&ÜGЩjJVhMW,6".!4!+щ}ic-iBv-|:Wtk*dݧHAl[]M4v.Jҕ(3;Ǣ|uEP|Q~CU^'H'FFR*6V_!qwp*?c^cӺNC1SzMGTxxeQmr4ơO:b<\Xw#zHNaOW l\x駏oz+Zj.kSt=E / )o\_ᅯaݙgp(#P!͠<#H1SDDq͵vu E:Btu!U6.]5`r*CTCR>$*Pr=J ߻FB=JBr.GHI2 ᯦(ۈ?M˾ !¹V;[r4bg)&ωhȟ EQy=Ņg]g)ԙN#DH4~en(~Mpݧ9/Hgi:L mw[ 7eг=kИJJ1jja41-O.8"O] (!d=4!Q1$VdDKȓ5 [f]U*dC&(hg8t/r`i&1Ϡ۞.2:mEHY N[7xNG,P%6nL.V9q,q\{̭hOzK9T_?>˭gnI i 8R0(}L{ ]|NbgBW_5JILA=͂ll.%wLLi 0[rS$<KSmĴqHHB#1Fl6h`L}Mm)SIme]`!0<fNP)[P = *J;bݩ1(ʘ͐(yZyL۽/Ӻp2Ab*=iO i.'J+J33v"&z?i  pu->oA37p6һ[ٔepۮN9 @91# _2oƔn )\}(lPgyҎM7#þApLSsyW uSȍOJR֥=X7SVeuF-4s}5a׼B@#(vKg#3傛.1-0.gaWܨ9B0lEEbD7G˸U+M6(H+M|aYtX(̏v̾ "@;On,W29rG۵K(3'L Nyh' Le_Ўe͈EMr{Kw I}c8))HMH~`1z,tPʇ,aZB|b7 PI4򯁘ȵ-rBWtYgEy!Pw(m %7$|ģMy\9/Q~  1:$dqn"l1ԃF[/-t| 5 P@l=/ݹUQX|dlWiY`{e#Mi?JKfR K(/w6tI]%BM5:cY.)ZÕd|҂ Q"H:4Kb>}%{SQo,~C"U`ԯjVeBs'LZE^1>Z$Cu,MQϥlɳx-q,Xq!FC:B'bo4Z 0EHZå*k; >_";C:a23Xߕ5kD.qkǡ2#[)^@*,tf":҄2Sx0l& C1;EХ1ƪDNml~L0̀&u1gί&(1:GNA|Hzאy0F_)C5^u#2turS>ƈPC,o* orNhk9L˯Z_ 42sDEO@t`MHϊjMT,8剨frA΢L"ښS&իBEP,r 񙺚^LC|KS;'& N陧&R#h Ky:  ea[I48)n4jkM.d,'jWl_CY`o)Jm&~҃8L`l iJ@]c_-†HF%Q[u F^iU ,\Jb=U!5^WͲQGvjܦ.LNt}Cvۑ4V!:4\ռ?ᔬRnA!+#+ܙʲ9Q xs0&mY2' ,V!gQ2I0SU? T``4^sB-FhsA%W'i] w/ uS| R;O1/!\//AD:B&EY=2q6K¶R\i(fU[ktFOɔʙ Z: %4"*V4{Y/Z(e+:A@ 79h+1~5M8=: .&לx7Ͽ8o`*uͅX 9 ךd (~1#@|C5l5Θ#bvQBOv5cPSz*R4oZP/jȉ]ݥ6n ' 6s'!g(%a4&.psT׆%W4FkȁF7h|}OVB0foI,X\L\E J6f|o'5):IlS_50[MrTx&c׶JgfTg\R iUbMfF츹VY AM* qxHG(^7_*&myچ\9]f [qt:e(F1W[?Dn,2dIe0s]Xe{ނP/%rM*~'k` 1uLOl]j, 0% .~OV=OGL3GaanV{;Dz 큖Us)$g﵄TP=!/}9m5 GH gN,״Y Tv)Ο'0;V} nܣK/M=+eՔ<1ЇۗW}_xof\K tҊY BNRw0µ%iȄP[kv LX-UH[S%/WP #*!_8~.[L>ܓW*hDQ[# _4ɯI{\wmmrחk-\&IOSKc w~bȥ`!_Wq[a5)7~8Lu5! :(Ą.2!C}LM<ϜJ؇AФ >wT4Љ?MDБEqy5'`T#&4IZ=7aIeUZG;`u;MוEIp̻b5jo܂KU+JxI mM,jKķ>Crcb ݿ1_^WwD#tPu|tL[tV6cVh-K[^j,HaH:hnu*e.;Du"Tܕlu!W0C4 uJ(*1aԌS%302'ursիd]( ^I.:ĩXS%9ry(fkaOFah'}fUUax-Ymon8rzǘm]k.[T=&jz[Yzɘ&MBQʓO?TCw'?,k=`":<+YV?|b$^zG?`4%Q% PMԹn3-F#f2*LFś}ޣd2]fD$l-h8q+.4 NkAfcbnP9u٘L('okMQdkjuG*7wA=nDH!.~)޸I-!m$P~b~1$H#T=3\\^A{jC_ Ĝv'8/LX/#MЂWS %)aB-=wV Zf/@Ҹ3Cu`L2U (sah4d%1,Z"K !LhP;-;~8COcl0W;3dEm8$/AJ0:-`_-1 BsnC{qzغzUTоpH҈~!KS/1u.0SȲJ#)5zC\C6ƈY3HwPd< /p^U+U VT:LυNv0!ȽG8c7x Қ4m/itǧb&hsk ^S[ʞ`++cJ:AHm!b q +M-p_S*ݩ,BU[ !wh=I |?"$C0m+#4 a߳Y2;p-l2+P÷s)72`'@$Q{${H>X<=/Fq]"V,?KNȂëlH!4W1v@VQx">EՓSZe/er4~U=hPUU1jt< = ͚.KFA' /il Hejía?g|AmH-,Xpb>߮ 'jiwUE;U[h"oV\71ۿ[k%mc&u5~KU An$&WY|7%o#KK\c?;F#TCO.ї.գ֏@Dv [2T!ٿYRsg>'a݊A1TUQF()Qhk*>cJqhKK!-_0K 'b8 kpg#Lm$.Tބް7i\C(\]+jTzzIHemDRV/.Y+׆E!C~O&ذ2nB/f\X"Q~>e糧^6 L.sf`1߳8 AbUTJKM-FR?zhٺ @QQ^jw[](>E)}S`u_BTL_ =`jDYX,nIUB`HmU`Mpdnox,i( rG#[1“@~exv2鈒ɮx=w4^*C^28Zc+'(C3_=` ߦږ¯tuZJ^&,jK(?PR4z`H fEƧeorahfW! e3/z2 vj׿ G^Wq+rv"@9P]nQ|͐\2ف(4 jihU4V`Y b0DE1J^nQGFNy8WVm%rEbv; M rJےn6CX'ۄGjХ1KÙWYS}o3Q.4F~lhPE.%>q:$Q8 m+}0QDpSV#4޽7+%1EtX9I7H.,od׾2w}y~,:ڬ!<uك0'ojstgjzWXū>4:sp,/44޷"ߊ'\iW{dt&6lOMHj+Ǖ5;YiKYdgm*c,beّMy G[eDfS>7C%Xj*Uz52_)?-bGaY",hVn._le?d1%YEab @/jQvQ|Z͢ᖢ9B`ZL)hxU9<확6b"? W`HE ;xEToaKPw-=%|B s=# 'ĸ-+&\.O+ۺɆTd4(s* Ã:t. ځz f Nn_a$(ϽabO&yҰcɁwD hpE2/X ;r¹W2Fk+Sߡ~xĚC ]hO$|+'#.nݒ9 `KX]{Hr6X%KBtWU`W|FQaUU$qF!J7F ?P6:ʙi.4lM.3ctNqNfHAVAnFF ;[HPy9`ƭ}5r\N j%!juhJEeeoCfFpz$ Xyh>#te]w7qE&S799*ѰL" "7QB=?yj<Vn._iB_.)y0c#c,O\h Wi< 'ɇ)24W_kev7W2ޜi1XѯXMU ڬ{.nF9eb=?G-j2:+jd[5{D6}UOtνh J -7#9{i^&؏_]4 h}_^KyQ< -i*9|zοYu{e}X:ſeڽ^!ײ2;a~\\{D%#Tse 3ș 9,4`ΐ/M@~Y2̓δzslnX͵*,fCVP/LaZrA=94w36J Tr}aE:NK ҮH$Ëb{KfkǙu<ȷnQ̺N.҇A[nH?KA=jX8vojOԉZQ o/' v`̛æKI&MXxB1`w˥!V$jt"-%kE i9c[OS /(GڪiHø|1"# mXd1D6Ӱ1Ip3&){ JzYۿ|$RvH@5 ZL_tC) Ũм0mu> zhڹ=W?tb lDj<׃7F; 7A~oC0&IyEGͺgy^-Ҳe^þ8a߶A\v @iVM1 Dڴmoyuuđs"mK;Hu%eUڱ7W6UG!tb@@Qz }laٹ~=PuΤKu܅joݮj@=--yХ eaV [-7-a BIt(aUܢSR64ՂzFx8ݸ a9 4`bDy{~w$=1Ǡi88^v\L9Y3XQO4= < jZu\:u3X?iFeo0 e;#^TsP&ZRJk>.rkuHB3B.f04S|Oi'[A1ʺd_;VGu"ǴҦZ㺬{fOc}D|v!''f=ٴ ;W6֧y0.'7%'Ǧ4B\S-By47zyl#7^4 P +pmTڏ|d&%hFjT!lH$O]JQiܻu+ƘY<i *NJ~#i!vвzPv>"1Cnǣ;ot PCK9D̪ZXAֹش 5ߒji΃ue?X8qیjLsO.0ygU__x{66!$a9Х5z-sH}i Mcԧx CX|RVxxGʺ ,oԲ_4*Ő*zu5s kzL}Cem8{, Fhy 9I?\g|@ޟe+j!܏~__Zu S73Ǻ݀.̹2 N^U_bTv<̕8y&?Q Fg: (u"v+S.B(F=ڸ=vUK%b{ڪ4]#D>Ynp2nSE"ka({j2OoZ*M>]_WһtViҕ9|gg+uυwHNsf& ;JyEfVߣp.X0. 9 '4er&tEao6é'` 쎅s pY̰Z [mBmϤ*7{)cIm^PiSoZwm\մƧ!=%gmbmdN$fǟhe4&s*y&ylǣuRyڐ@s0K$WAlYNeE+͸!MaROƭ0;GĞL+&bt@EtyMĸ 6$xR:FTe6iYoJ> .,'u}ه)% WZ1Ubi޲W^?& +㵯f#N6 JЇ+)5w{ÝY,3|#f_ڭ ^@H$QV'gP@9\"MOÌh"i|9PL8Ͽ&_#Nv9*_9X0S M$f(#}.;0j2<*Br- e-34)42 JM׾H:!]ۆE=L*տSV7uEC ~Ժ[Bz ^CJh?M7XȎ:K cD{:Ч@+179'A׷CscҺSד^,ݐr,GhzߢMUЫ_"0HCso_N(뵜6ۘRdƊ5/:c :n+qP'KagL0VЏ<O9)E*73 7Q1`8Z6bUqH課!;j2'0BpYTʹ}&"Iv8AX兴䕏/;CR(5,$P4kv"Lb|pM芢:PBH#`t(Nb4CƜXNRB~™SjZz#o@@86|u% .bjd͔khdjLD/R`~@1F(qg]/_" ϻahc&@}/Vv+p哐qf?mHc' ŋ8m؉U>7nP<Ycgn`>z!ߡbXOUiJnb<s/GbuSOIpA7ݥlK0 bCHԲۦT3p!|6Baqd~MBRAd3jKXFaضl}!$5MkZp{W6ne4%rޗ4) zlT 1^Q$)+1SZ5џW%Hz:qNuER7@,~6+6r IԜ:>[ !@f9aGDE1a6u=3u{+=O\[tRT $zޚ{si~+xtR)kڡHríkZ&ZN>E聊}k%9bibl;\PF<,):&=mCLĉ ]S CIW(`槺F5Fӣ["lRݤgekI03q6>4+x!:Omu"^RQf'k|n~6>%*j (+6~G/i?FgB<,AE}Ug1\<Շe֐e*q+z0L3ɼ:A%`Kv"m 2 +{Pwy'%N))pOGյAcb1Xh/A]oC",i69E2pέv2@bݿ}(Fi3X%~aRb=8db04x⡢>JZ 6ciQ9(g2K9#.%)0̘AKfؠQ )l9YC&6,V5<ލ;"Ռw+ ,28?0аL)adYU͘[%ؚ{56 "n5vRs;(콽ɼե\^91NysJgD㊀$Գ&E ?}Cྺ!tƫ[->'DYg`u^\`J%oLN* h_NܫKCE3*#m@dfzPҺ2 ]ףE+wwG8Bԍhjww8`SG A}4 _`1&P,Qn:({l Ex|{p6FA%smbu,q 80l>Om_wq&=2,Ptq+?Yxʛm{yYt_%̪/^6F='ĉe@;\1bʾL0ɑ[jO69*lO5߳\f9d9X {b8'@k[d!ڑ oy!Uln쑉Ѯ4?\v/rtV38POzthSXTN4Ur
    Enjoying the preview?
    Page 1 of 1