目錄(119章)
倒序
- coverpage
- QlikView for Developers
- Credits
- About the Authors
- Acknowledgements
- About the Reviewer
- www.PacktPub.com
- Customer Feedback
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Chapter 1. Meet QlikView
- What is QlikView?
- Exploring data with QlikView
- The technology and components behind QlikView
- Meet HighCloud Airlines
- Summary
- Chapter 2. What's New in QlikView 12?
- How is QlikView 12 different from QlikView 11?
- What is new in the Qlik product portfolio?
- How do the products in the Qlik product portfolio fit together?
- What is new in QlikView 12 for Developers?
- Summary
- Chapter 3. Seeing is Believing
- What is a SiB?
- Preparing the workspace
- Creating the app
- Summary
- Chapter 4. Data Sources
- Using ODBC and OLE DB drivers
- Extracting data – two hands-on examples
- Loading a table file
- QVD and QVX files
- Loading an Inline table
- Summary
- Chapter 5. Data Modeling
- Dimensional data modeling
- The associative data model
- The Table Viewer window
- Summary
- Chapter 6. Styling Up
- Design requirements
- The Document Properties window
- The Sheet Properties dialog
- Setting the object properties
- Working with listboxes
- The Multi Box
- The Current Selections Box
- Adding a Bookmark Object
- Aligning and resizing sheet objects
- Creating and applying a default color map
- Summary
- Chapter 7. Building Dashboards
- User types
- Applying the DAR principle to Airline Operations
- Creating the Analysis sheet
- Creating the new Dashboard sheet
- Creating the Reports sheet
- Other charts
- Summary
- Chapter 8. Scripting
- The Script Editor
- Script statements
- Conditional functions
- Dealing with different data types
- Debugging script
- Standardizing and organizing script
- Re-using scripts
- Managing file locations and connection strings
- Summary
- Chapter 9. Data Modeling Best Practices
- Data consistency
- Reducing storage requirements
- Design challenges of data modeling
- The master calendar
- A final note on data modeling
- Summary
- Chapter 10. Basic Data Transformation
- Changing the source table structure
- Summary
- Chapter 11. Advanced Expressions
- Using variables
- Using the TOTAL qualifier
- The Aggr function
- Conditional functions
- A tip on copying expressions
- Summary
- Chapter 12. Set Analysis and Point In Time Reporting
- The magic of Set Analysis
- Point In Time Reporting
- Comparative analysis with alternate states
- Always validate
- Summary
- Chapter 13. Advanced Data Transformation
- Data architecture
- Loading data already stored in QlikView
- Aggregating data
- Sorting tables
- The Peek function
- Merging forces
- Dealing with slowly changing dimensions
- Ordering peeking and matching all at once
- Incremental loads
- Summary
- Chapter 14. More on Visual Design and User Experience
- Creating a consistent QlikView UI
- Additional interactivity
- Summary
- Chapter 15. Security
- Hidden script
- Section access
- Document-level security
- Sheet-level security
- Summary
- Index 更新時間:2021-07-09 18:58:48
推薦閱讀
- Python自然語言處理實戰(zhàn):核心技術(shù)與算法
- 單片機C語言程序設(shè)計實訓100例:基于STC8051+Proteus仿真與實戰(zhàn)
- Oracle數(shù)據(jù)庫從入門到運維實戰(zhàn)
- Visual Basic程序設(shè)計教程
- 精通Scrapy網(wǎng)絡(luò)爬蟲
- Reactive Programming With Java 9
- Mastering Apache Spark 2.x(Second Edition)
- JAVA程序設(shè)計實驗教程
- 劍指Java:核心原理與應(yīng)用實踐
- ASP.NET Core 2 Fundamentals
- C++寶典
- Node學習指南(第2版)
- 精通MySQL 8(視頻教學版)
- Getting Started with Nano Server
- Hacking Android
- Python物理建模初學者指南(第2版)
- Raspberry Pi Blueprints
- Mastering ArcGIS Server Development with JavaScript
- Natural Language Processing with Python Cookbook
- Spring MVC Cookbook
- Learning Behavior:driven Development with JavaScript
- Node.js入門指南
- UG 12.0數(shù)控編程實例教程
- Mastering Python Data Analysis
- 瘋狂Java講義(第5版)
- Vue.js 前端開發(fā) 快速入門與專業(yè)應(yīng)用
- Mastering AngularJS Directives
- Scratch 3.0少兒編程魔法課堂(全彩印+視頻教學版)
- Visual Basic程序設(shè)計與應(yīng)用教程
- 一步一步跟我學Scratch 3.0編程