Mastering QlikView :: unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence /
If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-m...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, UK :
Packt Publishing,
[2014]
|
| Schriftenreihe: | Professional expertise distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics. |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (1 volume) : illustrations |
| ISBN: | 9781782173304 1782173307 1782173293 9781782173298 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn899291733 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr unu|||||||| | ||
| 008 | 150107s2014 enka o 001 0 eng d | ||
| 040 | |a UMI |b eng |e rda |e pn |c UMI |d DEBBG |d DEBSZ |d EBLCP |d IDEBK |d YDXCP |d E7B |d S4S |d COO |d N$T |d OCLCF |d B24X7 |d OCLCQ |d D6H |d OCLCO |d AGLDB |d ICA |d LIV |d OCLCQ |d MERUC |d OCLCQ |d VNS |d VTS |d CEF |d OCLCQ |d UKMGB |d OCLCQ |d STF |d AU@ |d UKAHL |d OCLCQ |d NLW |d OCLCQ |d OCLCO |d OCLCQ |d QGK |d OCLCO |d OCLCL | ||
| 015 | |a GBB6K9071 |2 bnb | ||
| 016 | 7 | |a 018005571 |2 Uk | |
| 019 | |a 897642122 |a 966358655 |a 1259143287 | ||
| 020 | |a 9781782173304 | ||
| 020 | |a 1782173307 | ||
| 020 | |a 1782173293 | ||
| 020 | |a 9781782173298 | ||
| 020 | |z 9781782173298 | ||
| 035 | |a (OCoLC)899291733 |z (OCoLC)897642122 |z (OCoLC)966358655 |z (OCoLC)1259143287 | ||
| 037 | |a CL0500000521 |b Safari Books Online | ||
| 050 | 4 | |a HD30.213 | |
| 072 | 7 | |a COM |x 018000 |2 bisacsh | |
| 082 | 7 | |a 005.758 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Redmond, Stephen, |e author. |0 http://id.loc.gov/authorities/names/nb99183948 | |
| 245 | 1 | 0 | |a Mastering QlikView : |b unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / |c Stephen Redmond. |
| 246 | 3 | 0 | |a Unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence |
| 264 | 1 | |a Birmingham, UK : |b Packt Publishing, |c [2014] | |
| 264 | 4 | |c ©2014 | |
| 300 | |a 1 online resource (1 volume) : |b illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 490 | 1 | |a Professional expertise distilled | |
| 588 | 0 | |a Online resource; title from cover page (Safari, viewed December 17, 2014). | |
| 500 | |a Includes index. | ||
| 505 | 0 | |a Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Performance Tuning and Scalability; Reviewing basic performance tuning techniques; Removing unneeded data; Reducing the number of rows; Reducing the number of columns; Replacing text keys with numbers; Resolving synthetic keys; Reviewing the basics; Generating test data; Generating dimension values; Generating Fact table rows; Understanding how QlikView stores its data; A great primer; Looking at things from a simple level; Exporting the memory statistics for a document. | |
| 505 | 8 | |a Strategies to reduce the data size and improve performanceOptimizing field values and keys; Optimizing data by removing keys using ApplyMap; Optimizing performance by removing keys by joining tables; Optimizing memory by removing low cardinality fields; Testing chart performance for different load options; Turning the cache off; Examining chart calculation time for different scenarios; Optimizing performance by creating counter fields; Optimizing performance by combining fact tables?; Optimizing your numbers; Optimizing chart calculation times; The QlikView calculation engine. | |
| 505 | 8 | |a Creating flags for well-known conditionsSorting for well-known conditions; Using Direct Discovery; Direct Discovery restrictions; Direct Discovery syntax; Looking at an example Direct Query; Testing scalability with jMeter; Obtaining the scalability tools; Installing jMeter; Installing the scalability tools; About the scalability tools; Running an example execution; Summary; Chapter 2: QlikView Data Modeling; Reviewing basic data modeling; Associating data; Automatically associating tables; Understanding synthetic keys; Creating composite keys. | |
| 505 | 8 | |a Realizing that facts are calculated at the level of their tableJoining data; Understanding Join and Keep; Concatenating rows; Reviewing Concatenate; Mapping data with ApplyMap; Reviewing the basic functionality of ApplyMap; Mapping numbers; Dimensional data modeling; Differentiating between facts and dimensions; Understanding the grain; Understanding star schemas; Summing with facts; Discovering more about facts; Transaction fact tables; Periodic snapshot fact tables; Factless fact tables; Dealing with nulls in fact tables in QlikView; Designing dimension tables. | |
| 505 | 8 | |a Denormalizing dimensions and conformed dimensionsUnderstanding surrogate keys; Dealing with missing or late arriving dimension values; Defining the Kimball four-step dimensional design process; Selecting the business process; Declaring the grain; Identifying the dimensions; Identifying the facts; Learning some useful reusable dimension methods; Creating a calendar dimension; Unwrapping hierarchies; Creating parent associations with HierarchyBelongsTo; Creating dimensional facts; Handling slowly changing dimensions; Taking the most recently changed record using FirstSortedValue. | |
| 520 | |a If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics. | ||
| 546 | |a English. | ||
| 650 | 0 | |a Management information systems. |0 http://id.loc.gov/authorities/subjects/sh85080359 | |
| 650 | 0 | |a Business intelligence |x Computer programs. | |
| 650 | 2 | |a Management Information Systems |0 https://id.nlm.nih.gov/mesh/D008331 | |
| 650 | 6 | |a Systèmes d'information de gestion. | |
| 650 | 7 | |a COMPUTERS |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Management information systems |2 fast | |
| 758 | |i has work: |a Mastering QlikView (Text) |1 https://id.oclc.org/worldcat/entity/E39PCGXrD963CKHdxDKm9Rg8vd |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Redmond, Stephen. |t Mastering QlikView. |d Birmingham : Packt Publishing, ©2014 |z 9781782173298 |
| 830 | 0 | |a Professional expertise distilled. |0 http://id.loc.gov/authorities/names/no2015143013 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=918168 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH27254829 | ||
| 938 | |a Books 24x7 |b B247 |n bks00093171 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL1874282 | ||
| 938 | |a ebrary |b EBRY |n ebr10992760 | ||
| 938 | |a EBSCOhost |b EBSC |n 918168 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis30193739 | ||
| 938 | |a YBP Library Services |b YANK |n 12185907 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn899291733 |
|---|---|
| _version_ | 1816882298972274688 |
| adam_text | |
| any_adam_object | |
| author | Redmond, Stephen |
| author_GND | http://id.loc.gov/authorities/names/nb99183948 |
| author_facet | Redmond, Stephen |
| author_role | aut |
| author_sort | Redmond, Stephen |
| author_variant | s r sr |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | H - Social Science |
| callnumber-label | HD30 |
| callnumber-raw | HD30.213 |
| callnumber-search | HD30.213 |
| callnumber-sort | HD 230.213 |
| callnumber-subject | HD - Industries, Land Use, Labor |
| collection | ZDB-4-EBA |
| contents | Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Performance Tuning and Scalability; Reviewing basic performance tuning techniques; Removing unneeded data; Reducing the number of rows; Reducing the number of columns; Replacing text keys with numbers; Resolving synthetic keys; Reviewing the basics; Generating test data; Generating dimension values; Generating Fact table rows; Understanding how QlikView stores its data; A great primer; Looking at things from a simple level; Exporting the memory statistics for a document. Strategies to reduce the data size and improve performanceOptimizing field values and keys; Optimizing data by removing keys using ApplyMap; Optimizing performance by removing keys by joining tables; Optimizing memory by removing low cardinality fields; Testing chart performance for different load options; Turning the cache off; Examining chart calculation time for different scenarios; Optimizing performance by creating counter fields; Optimizing performance by combining fact tables?; Optimizing your numbers; Optimizing chart calculation times; The QlikView calculation engine. Creating flags for well-known conditionsSorting for well-known conditions; Using Direct Discovery; Direct Discovery restrictions; Direct Discovery syntax; Looking at an example Direct Query; Testing scalability with jMeter; Obtaining the scalability tools; Installing jMeter; Installing the scalability tools; About the scalability tools; Running an example execution; Summary; Chapter 2: QlikView Data Modeling; Reviewing basic data modeling; Associating data; Automatically associating tables; Understanding synthetic keys; Creating composite keys. Realizing that facts are calculated at the level of their tableJoining data; Understanding Join and Keep; Concatenating rows; Reviewing Concatenate; Mapping data with ApplyMap; Reviewing the basic functionality of ApplyMap; Mapping numbers; Dimensional data modeling; Differentiating between facts and dimensions; Understanding the grain; Understanding star schemas; Summing with facts; Discovering more about facts; Transaction fact tables; Periodic snapshot fact tables; Factless fact tables; Dealing with nulls in fact tables in QlikView; Designing dimension tables. Denormalizing dimensions and conformed dimensionsUnderstanding surrogate keys; Dealing with missing or late arriving dimension values; Defining the Kimball four-step dimensional design process; Selecting the business process; Declaring the grain; Identifying the dimensions; Identifying the facts; Learning some useful reusable dimension methods; Creating a calendar dimension; Unwrapping hierarchies; Creating parent associations with HierarchyBelongsTo; Creating dimensional facts; Handling slowly changing dimensions; Taking the most recently changed record using FirstSortedValue. |
| ctrlnum | (OCoLC)899291733 |
| dewey-full | 005.758 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.758 |
| dewey-search | 005.758 |
| dewey-sort | 15.758 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06434cam a2200733 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn899291733</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr unu||||||||</controlfield><controlfield tag="008">150107s2014 enka o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">UMI</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">UMI</subfield><subfield code="d">DEBBG</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">EBLCP</subfield><subfield code="d">IDEBK</subfield><subfield code="d">YDXCP</subfield><subfield code="d">E7B</subfield><subfield code="d">S4S</subfield><subfield code="d">COO</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCF</subfield><subfield code="d">B24X7</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">D6H</subfield><subfield code="d">OCLCO</subfield><subfield code="d">AGLDB</subfield><subfield code="d">ICA</subfield><subfield code="d">LIV</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VNS</subfield><subfield code="d">VTS</subfield><subfield code="d">CEF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">STF</subfield><subfield code="d">AU@</subfield><subfield code="d">UKAHL</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">NLW</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">QGK</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBB6K9071</subfield><subfield code="2">bnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018005571</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">897642122</subfield><subfield code="a">966358655</subfield><subfield code="a">1259143287</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781782173304</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1782173307</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1782173293</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781782173298</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781782173298</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)899291733</subfield><subfield code="z">(OCoLC)897642122</subfield><subfield code="z">(OCoLC)966358655</subfield><subfield code="z">(OCoLC)1259143287</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">CL0500000521</subfield><subfield code="b">Safari Books Online</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">HD30.213</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">018000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.758</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Redmond, Stephen,</subfield><subfield code="e">author.</subfield><subfield code="0">http://id.loc.gov/authorities/names/nb99183948</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Mastering QlikView :</subfield><subfield code="b">unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence /</subfield><subfield code="c">Stephen Redmond.</subfield></datafield><datafield tag="246" ind1="3" ind2="0"><subfield code="a">Unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham, UK :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">[2014]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2014</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (1 volume) :</subfield><subfield code="b">illustrations</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Professional expertise distilled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource; title from cover page (Safari, viewed December 17, 2014).</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Performance Tuning and Scalability; Reviewing basic performance tuning techniques; Removing unneeded data; Reducing the number of rows; Reducing the number of columns; Replacing text keys with numbers; Resolving synthetic keys; Reviewing the basics; Generating test data; Generating dimension values; Generating Fact table rows; Understanding how QlikView stores its data; A great primer; Looking at things from a simple level; Exporting the memory statistics for a document.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Strategies to reduce the data size and improve performanceOptimizing field values and keys; Optimizing data by removing keys using ApplyMap; Optimizing performance by removing keys by joining tables; Optimizing memory by removing low cardinality fields; Testing chart performance for different load options; Turning the cache off; Examining chart calculation time for different scenarios; Optimizing performance by creating counter fields; Optimizing performance by combining fact tables?; Optimizing your numbers; Optimizing chart calculation times; The QlikView calculation engine.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Creating flags for well-known conditionsSorting for well-known conditions; Using Direct Discovery; Direct Discovery restrictions; Direct Discovery syntax; Looking at an example Direct Query; Testing scalability with jMeter; Obtaining the scalability tools; Installing jMeter; Installing the scalability tools; About the scalability tools; Running an example execution; Summary; Chapter 2: QlikView Data Modeling; Reviewing basic data modeling; Associating data; Automatically associating tables; Understanding synthetic keys; Creating composite keys.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Realizing that facts are calculated at the level of their tableJoining data; Understanding Join and Keep; Concatenating rows; Reviewing Concatenate; Mapping data with ApplyMap; Reviewing the basic functionality of ApplyMap; Mapping numbers; Dimensional data modeling; Differentiating between facts and dimensions; Understanding the grain; Understanding star schemas; Summing with facts; Discovering more about facts; Transaction fact tables; Periodic snapshot fact tables; Factless fact tables; Dealing with nulls in fact tables in QlikView; Designing dimension tables.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Denormalizing dimensions and conformed dimensionsUnderstanding surrogate keys; Dealing with missing or late arriving dimension values; Defining the Kimball four-step dimensional design process; Selecting the business process; Declaring the grain; Identifying the dimensions; Identifying the facts; Learning some useful reusable dimension methods; Creating a calendar dimension; Unwrapping hierarchies; Creating parent associations with HierarchyBelongsTo; Creating dimensional facts; Handling slowly changing dimensions; Taking the most recently changed record using FirstSortedValue.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics.</subfield></datafield><datafield tag="546" ind1=" " ind2=" "><subfield code="a">English.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Management information systems.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85080359</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business intelligence</subfield><subfield code="x">Computer programs.</subfield></datafield><datafield tag="650" ind1=" " ind2="2"><subfield code="a">Management Information Systems</subfield><subfield code="0">https://id.nlm.nih.gov/mesh/D008331</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Systèmes d'information de gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Data Processing.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Management information systems</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Mastering QlikView (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCGXrD963CKHdxDKm9Rg8vd</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Redmond, Stephen.</subfield><subfield code="t">Mastering QlikView.</subfield><subfield code="d">Birmingham : Packt Publishing, ©2014</subfield><subfield code="z">9781782173298</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Professional expertise distilled.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2015143013</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=918168</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH27254829</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Books 24x7</subfield><subfield code="b">B247</subfield><subfield code="n">bks00093171</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest Ebook Central</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1874282</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10992760</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">918168</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis30193739</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">12185907</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn899291733 |
| illustrated | Illustrated |
| indexdate | 2024-11-27T13:26:24Z |
| institution | BVB |
| isbn | 9781782173304 1782173307 1782173293 9781782173298 |
| language | English |
| oclc_num | 899291733 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (1 volume) : illustrations |
| psigel | ZDB-4-EBA |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Professional expertise distilled. |
| series2 | Professional expertise distilled |
| spelling | Redmond, Stephen, author. http://id.loc.gov/authorities/names/nb99183948 Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / Stephen Redmond. Unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence Birmingham, UK : Packt Publishing, [2014] ©2014 1 online resource (1 volume) : illustrations text txt rdacontent computer c rdamedia online resource cr rdacarrier text file Professional expertise distilled Online resource; title from cover page (Safari, viewed December 17, 2014). Includes index. Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Performance Tuning and Scalability; Reviewing basic performance tuning techniques; Removing unneeded data; Reducing the number of rows; Reducing the number of columns; Replacing text keys with numbers; Resolving synthetic keys; Reviewing the basics; Generating test data; Generating dimension values; Generating Fact table rows; Understanding how QlikView stores its data; A great primer; Looking at things from a simple level; Exporting the memory statistics for a document. Strategies to reduce the data size and improve performanceOptimizing field values and keys; Optimizing data by removing keys using ApplyMap; Optimizing performance by removing keys by joining tables; Optimizing memory by removing low cardinality fields; Testing chart performance for different load options; Turning the cache off; Examining chart calculation time for different scenarios; Optimizing performance by creating counter fields; Optimizing performance by combining fact tables?; Optimizing your numbers; Optimizing chart calculation times; The QlikView calculation engine. Creating flags for well-known conditionsSorting for well-known conditions; Using Direct Discovery; Direct Discovery restrictions; Direct Discovery syntax; Looking at an example Direct Query; Testing scalability with jMeter; Obtaining the scalability tools; Installing jMeter; Installing the scalability tools; About the scalability tools; Running an example execution; Summary; Chapter 2: QlikView Data Modeling; Reviewing basic data modeling; Associating data; Automatically associating tables; Understanding synthetic keys; Creating composite keys. Realizing that facts are calculated at the level of their tableJoining data; Understanding Join and Keep; Concatenating rows; Reviewing Concatenate; Mapping data with ApplyMap; Reviewing the basic functionality of ApplyMap; Mapping numbers; Dimensional data modeling; Differentiating between facts and dimensions; Understanding the grain; Understanding star schemas; Summing with facts; Discovering more about facts; Transaction fact tables; Periodic snapshot fact tables; Factless fact tables; Dealing with nulls in fact tables in QlikView; Designing dimension tables. Denormalizing dimensions and conformed dimensionsUnderstanding surrogate keys; Dealing with missing or late arriving dimension values; Defining the Kimball four-step dimensional design process; Selecting the business process; Declaring the grain; Identifying the dimensions; Identifying the facts; Learning some useful reusable dimension methods; Creating a calendar dimension; Unwrapping hierarchies; Creating parent associations with HierarchyBelongsTo; Creating dimensional facts; Handling slowly changing dimensions; Taking the most recently changed record using FirstSortedValue. If you are a business application developer or a system analyst who has learned QlikView and Qlik Sense and now want to take your learning to a higher level, then this book is for you. It is assumed that you are aware of the fundamentals of QlikView and have working knowledge of development and in-memory analytics. English. Management information systems. http://id.loc.gov/authorities/subjects/sh85080359 Business intelligence Computer programs. Management Information Systems https://id.nlm.nih.gov/mesh/D008331 Systèmes d'information de gestion. COMPUTERS Data Processing. bisacsh Management information systems fast has work: Mastering QlikView (Text) https://id.oclc.org/worldcat/entity/E39PCGXrD963CKHdxDKm9Rg8vd https://id.oclc.org/worldcat/ontology/hasWork Print version: Redmond, Stephen. Mastering QlikView. Birmingham : Packt Publishing, ©2014 9781782173298 Professional expertise distilled. http://id.loc.gov/authorities/names/no2015143013 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=918168 Volltext |
| spellingShingle | Redmond, Stephen Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / Professional expertise distilled. Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Performance Tuning and Scalability; Reviewing basic performance tuning techniques; Removing unneeded data; Reducing the number of rows; Reducing the number of columns; Replacing text keys with numbers; Resolving synthetic keys; Reviewing the basics; Generating test data; Generating dimension values; Generating Fact table rows; Understanding how QlikView stores its data; A great primer; Looking at things from a simple level; Exporting the memory statistics for a document. Strategies to reduce the data size and improve performanceOptimizing field values and keys; Optimizing data by removing keys using ApplyMap; Optimizing performance by removing keys by joining tables; Optimizing memory by removing low cardinality fields; Testing chart performance for different load options; Turning the cache off; Examining chart calculation time for different scenarios; Optimizing performance by creating counter fields; Optimizing performance by combining fact tables?; Optimizing your numbers; Optimizing chart calculation times; The QlikView calculation engine. Creating flags for well-known conditionsSorting for well-known conditions; Using Direct Discovery; Direct Discovery restrictions; Direct Discovery syntax; Looking at an example Direct Query; Testing scalability with jMeter; Obtaining the scalability tools; Installing jMeter; Installing the scalability tools; About the scalability tools; Running an example execution; Summary; Chapter 2: QlikView Data Modeling; Reviewing basic data modeling; Associating data; Automatically associating tables; Understanding synthetic keys; Creating composite keys. Realizing that facts are calculated at the level of their tableJoining data; Understanding Join and Keep; Concatenating rows; Reviewing Concatenate; Mapping data with ApplyMap; Reviewing the basic functionality of ApplyMap; Mapping numbers; Dimensional data modeling; Differentiating between facts and dimensions; Understanding the grain; Understanding star schemas; Summing with facts; Discovering more about facts; Transaction fact tables; Periodic snapshot fact tables; Factless fact tables; Dealing with nulls in fact tables in QlikView; Designing dimension tables. Denormalizing dimensions and conformed dimensionsUnderstanding surrogate keys; Dealing with missing or late arriving dimension values; Defining the Kimball four-step dimensional design process; Selecting the business process; Declaring the grain; Identifying the dimensions; Identifying the facts; Learning some useful reusable dimension methods; Creating a calendar dimension; Unwrapping hierarchies; Creating parent associations with HierarchyBelongsTo; Creating dimensional facts; Handling slowly changing dimensions; Taking the most recently changed record using FirstSortedValue. Management information systems. http://id.loc.gov/authorities/subjects/sh85080359 Business intelligence Computer programs. Management Information Systems https://id.nlm.nih.gov/mesh/D008331 Systèmes d'information de gestion. COMPUTERS Data Processing. bisacsh Management information systems fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh85080359 https://id.nlm.nih.gov/mesh/D008331 |
| title | Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / |
| title_alt | Unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence |
| title_auth | Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / |
| title_exact_search | Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / |
| title_full | Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / Stephen Redmond. |
| title_fullStr | Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / Stephen Redmond. |
| title_full_unstemmed | Mastering QlikView : unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / Stephen Redmond. |
| title_short | Mastering QlikView : |
| title_sort | mastering qlikview unleash the power of qlikview and qlik sense to make optimum use of data for business intelligence |
| title_sub | unleash the power of QlikView and Qlik Sense to make optimum use of data for Business Intelligence / |
| topic | Management information systems. http://id.loc.gov/authorities/subjects/sh85080359 Business intelligence Computer programs. Management Information Systems https://id.nlm.nih.gov/mesh/D008331 Systèmes d'information de gestion. COMPUTERS Data Processing. bisacsh Management information systems fast |
| topic_facet | Management information systems. Business intelligence Computer programs. Management Information Systems Systèmes d'information de gestion. COMPUTERS Data Processing. Management information systems |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=918168 |
| work_keys_str_mv | AT redmondstephen masteringqlikviewunleashthepowerofqlikviewandqliksensetomakeoptimumuseofdataforbusinessintelligence AT redmondstephen unleashthepowerofqlikviewandqliksensetomakeoptimumuseofdataforbusinessintelligence |