QlikView 11 for developers [[electronic resource] ] : develop business intelligence applications with QlikView 11 / / Miguel Garcia, Barry Harmsen |
Autore | García Miguel |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birminghan, UK, : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (534 p.) |
Disciplina | 005.758 |
Altri autori (Persone) | HarmsenBarry |
Collana | Professional expertise distilled |
Soggetto topico |
Business intelligence
Application software |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-96107-5
1-84968-607-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Authors; Acknowledgements; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Meet QlikView; What is QlikView?; How does QlikView differ from traditional BI?; Associative user experience; Technology; Adoption path; Exploring data with QlikView; Getting QlikView; Navigating the document; Slicing and dicing your data; List-boxes; Selections in charts; Search; Bookmarking selections; Undoing selections; Changing the view; Cyclic Groups; Drill down Groups; Containers; But wait, there's more!
The technology and components behind QlikView The way the data flows; When QlikView use expands; Create content; Reload, publish, and distribute content; Consume content; Meet HighCloud Airlines; Summary; Chapter 2: Seeing is Believing; What is a SiB?; Preparing the workspace; Setting up the folder structure; Creating the QlikView document; Creating the app; The requirements; Constructing the data model; What is a data model?; Loading the fact table; Playing with listboxes; Associating additional tables; Creating the dashboard tab; Creating and positioning the filters and user controls Number of flights over time One chart and multiple analyses with cyclic expressions; Adding a time drill-down group; Top 10 routes; Summary; Chapter 3: Data Sources; Using ODBC and OLE DB drivers; Installing the drivers; Accessing custom data sources; Third-party custom connectors; Reading table files; Extracting data-two hands-on examples; Extracting data from MS Access; Configuring the driver; Creating the OLE DB connection string; Querying the database; Reloading the script; The resulting data model; Loading a table file; Specifying the file attributes; The transformation step Refining the input table The resulting script; QVD and QVX files; QVD files; QVX files; Loading an Inline table; Summary; Chapter 4: Data Modeling; Dimensional data modeling; Back in the day; Relational databases and ER modeling; Dimensional modeling; The star schema; The snowflake schema; Creating the dimensional model; Dimensional models in QlikView; The associative data model; Guidelines for table associations; How associations are created; Avoiding data model conflicts; The Table Viewer window; Table information; Field information; Table preview; Table viewer menu; Summary Chapter 5: Styling Up Design requirements; The Document Properties window; The Sheet Properties dialog; Setting the object properties; Caption colors and style; Changing the caption colors; Setting the caption font; Setting the content font; Setting the global font; Propagating the object appearance; Setting the default Sheet Object Style; Hiding captions; Working with list boxes; Adding list boxes; The List Box Properties dialog; The General tab; The Expressions tab; The Sort tab; The Presentation tab; The Number tab; The Font tab; The Layout tab; The Caption tab; The Multi Box The Current Selections Box |
Record Nr. | UNINA-9910462970303321 |
García Miguel
![]() |
||
Birminghan, UK, : Packt Pub., 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
QlikView 11 for developers [[electronic resource] ] : develop business intelligence applications with QlikView 11 / / Miguel Garcia, Barry Harmsen |
Autore | García Miguel |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birminghan, UK, : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (534 p.) |
Disciplina | 005.758 |
Altri autori (Persone) | HarmsenBarry |
Collana | Professional expertise distilled |
Soggetto topico |
Business intelligence
Application software |
ISBN |
1-283-96107-5
1-84968-607-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Authors; Acknowledgements; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Meet QlikView; What is QlikView?; How does QlikView differ from traditional BI?; Associative user experience; Technology; Adoption path; Exploring data with QlikView; Getting QlikView; Navigating the document; Slicing and dicing your data; List-boxes; Selections in charts; Search; Bookmarking selections; Undoing selections; Changing the view; Cyclic Groups; Drill down Groups; Containers; But wait, there's more!
The technology and components behind QlikView The way the data flows; When QlikView use expands; Create content; Reload, publish, and distribute content; Consume content; Meet HighCloud Airlines; Summary; Chapter 2: Seeing is Believing; What is a SiB?; Preparing the workspace; Setting up the folder structure; Creating the QlikView document; Creating the app; The requirements; Constructing the data model; What is a data model?; Loading the fact table; Playing with listboxes; Associating additional tables; Creating the dashboard tab; Creating and positioning the filters and user controls Number of flights over time One chart and multiple analyses with cyclic expressions; Adding a time drill-down group; Top 10 routes; Summary; Chapter 3: Data Sources; Using ODBC and OLE DB drivers; Installing the drivers; Accessing custom data sources; Third-party custom connectors; Reading table files; Extracting data-two hands-on examples; Extracting data from MS Access; Configuring the driver; Creating the OLE DB connection string; Querying the database; Reloading the script; The resulting data model; Loading a table file; Specifying the file attributes; The transformation step Refining the input table The resulting script; QVD and QVX files; QVD files; QVX files; Loading an Inline table; Summary; Chapter 4: Data Modeling; Dimensional data modeling; Back in the day; Relational databases and ER modeling; Dimensional modeling; The star schema; The snowflake schema; Creating the dimensional model; Dimensional models in QlikView; The associative data model; Guidelines for table associations; How associations are created; Avoiding data model conflicts; The Table Viewer window; Table information; Field information; Table preview; Table viewer menu; Summary Chapter 5: Styling Up Design requirements; The Document Properties window; The Sheet Properties dialog; Setting the object properties; Caption colors and style; Changing the caption colors; Setting the caption font; Setting the content font; Setting the global font; Propagating the object appearance; Setting the default Sheet Object Style; Hiding captions; Working with list boxes; Adding list boxes; The List Box Properties dialog; The General tab; The Expressions tab; The Sort tab; The Presentation tab; The Number tab; The Font tab; The Layout tab; The Caption tab; The Multi Box The Current Selections Box |
Record Nr. | UNINA-9910786440303321 |
García Miguel
![]() |
||
Birminghan, UK, : Packt Pub., 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
QlikView 11 for developers : develop business intelligence applications with QlikView 11 / / Miguel Garcia, Barry Harmsen |
Autore | García Miguel |
Edizione | [1st edition] |
Pubbl/distr/stampa | Birminghan, UK, : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (534 p.) |
Disciplina | 005.758 |
Altri autori (Persone) | HarmsenBarry |
Collana | Professional expertise distilled |
Soggetto topico |
Business intelligence
Application software |
ISBN |
1-283-96107-5
1-84968-607-6 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Authors; Acknowledgements; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Meet QlikView; What is QlikView?; How does QlikView differ from traditional BI?; Associative user experience; Technology; Adoption path; Exploring data with QlikView; Getting QlikView; Navigating the document; Slicing and dicing your data; List-boxes; Selections in charts; Search; Bookmarking selections; Undoing selections; Changing the view; Cyclic Groups; Drill down Groups; Containers; But wait, there's more!
The technology and components behind QlikView The way the data flows; When QlikView use expands; Create content; Reload, publish, and distribute content; Consume content; Meet HighCloud Airlines; Summary; Chapter 2: Seeing is Believing; What is a SiB?; Preparing the workspace; Setting up the folder structure; Creating the QlikView document; Creating the app; The requirements; Constructing the data model; What is a data model?; Loading the fact table; Playing with listboxes; Associating additional tables; Creating the dashboard tab; Creating and positioning the filters and user controls Number of flights over time One chart and multiple analyses with cyclic expressions; Adding a time drill-down group; Top 10 routes; Summary; Chapter 3: Data Sources; Using ODBC and OLE DB drivers; Installing the drivers; Accessing custom data sources; Third-party custom connectors; Reading table files; Extracting data-two hands-on examples; Extracting data from MS Access; Configuring the driver; Creating the OLE DB connection string; Querying the database; Reloading the script; The resulting data model; Loading a table file; Specifying the file attributes; The transformation step Refining the input table The resulting script; QVD and QVX files; QVD files; QVX files; Loading an Inline table; Summary; Chapter 4: Data Modeling; Dimensional data modeling; Back in the day; Relational databases and ER modeling; Dimensional modeling; The star schema; The snowflake schema; Creating the dimensional model; Dimensional models in QlikView; The associative data model; Guidelines for table associations; How associations are created; Avoiding data model conflicts; The Table Viewer window; Table information; Field information; Table preview; Table viewer menu; Summary Chapter 5: Styling Up Design requirements; The Document Properties window; The Sheet Properties dialog; Setting the object properties; Caption colors and style; Changing the caption colors; Setting the caption font; Setting the content font; Setting the global font; Propagating the object appearance; Setting the default Sheet Object Style; Hiding captions; Working with list boxes; Adding list boxes; The List Box Properties dialog; The General tab; The Expressions tab; The Sort tab; The Presentation tab; The Number tab; The Font tab; The Layout tab; The Caption tab; The Multi Box The Current Selections Box |
Record Nr. | UNINA-9910816703503321 |
García Miguel
![]() |
||
Birminghan, UK, : Packt Pub., 2012 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|