QlikView 11 for developers [[electronic resource] ] : develop business intelligence applications with QlikView 11 / / Miguel Garcia, Barry Harmsen
| 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
| 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
| 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 |
9781283961073
1283961075 9781849686075 1849686076 |
| 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-9910954823603321 |
García Miguel
|
||
| Birminghan, UK, : Packt Pub., 2012 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||