QlikView for Ninjas
QlikView for Ninjas
The first and ultimate step to the exciting world of QlikView
About the Book
QlikView for Ninja series is a first in a series of books covering all aspects of QlikView Devlopment and designing. Subsequent series will cover advanced aspects and drill into more details of each topics. This will be the biggest of the volume in the series. Hope you will enjoy reading this book as much as I am enjoying writing it.
You can download all the datasources and upcoming scripts from the below location.
Data Sources:
https://dl.dropboxusercontent.com/u/24003637/DataSources.zip
https://dl.dropboxusercontent.com/u/24003637/AdventureWorks.zip
The real world case study data files can be downloaded from the below link.
https://www.dropbox.com/s/hhq23wzrwuxvqtc/invoice_data.zip?dl=0
Date: 04-June-2015
Link to download new-accounts.xls file
https://www.dropbox.com/s/9msdhx8a1ekyryl/new-accounts.xlsx?dl=0
Date: 14-MAY-2015
Updated Invoice file: Added field UserID
https://www.dropbox.com/s/hv0pz18um59h4uw/dbo.Invoices.qvd?dl=0
Initial examples will be based on the AdventureWorks database.
Also, to understand the data model for AdventureWorks database, you can refer the below document.
http://www.sqldatadictionary.com/AdventureWorks2012.pdf
The actual case study will be building data models and dashboards for an Invoicing Application.
NOTE: The price of this book will be revised once the book's first version is out. So, take this opportunity to grab this as an early adopter.
The draft outline of the agenda is given below.
SECTION 1 - QlikView Developer
1. Introduction
2. QlikView Development Methodology
3. Data and Scripting
4. Connect, Select and Load
5. Loading Data from SQL Server
- Executing Stored Procedures
- Reading XML Data from SQL Server
6. Loading Data from XML file
7. Loading Data from Excel and CSV files
8. Data Modelling Issues
9. Referencing external files
10. Basic Data Transformation
11. Data generation in the QlikView script
12. Scripting Best Practices
13. Master Calendar
14. Mapping Tables
15. Data Model Optimization
16. Link Tables
17. Interval Match
18. Cross Tables
19. Advanced Calculations
20. Alternate States
21. Set Analysis
22. Metadata
23. Generating QVD's
24. QlikView Security
25. Additional Load Types
26. How to use QlikView Extensions
NOTE: All the sections will be moved to another book (and all readers will get a free copy when published)
SECTION 2 - QlikView Designer (Same book or new book)
SECTION 3 - Basic Server Administration (Same book or could be new book)
SECTION 4 - Advanced Development and Tips and Tricks (Already available on leanpub.com as "QlikView Recipes")
If any section is move to a new book, the existing subscribers will get it free.
About the Authors
Table of Contents
- 1 - Introduction
- 2 - QlikView Development Methodology
- 3 - Developer Roles
-
4 - Data and Scripting
- QlikView Data Modelling
- 5 - Connect, Select and Load
- Case study - Data modelling for Invoice Management System
- 6 – Loading data
- 7 – Synthetic Keys
- 8 – Circular Reference
- 9 – Loading additional tables
- 10 – Mapping Tables
- 11 – Master Calendar
-
12 – Load Types
- Resident Load
- Inline Load
-
13 – Concatenation
- Automatic Concatenation
- NoConcatenate
- Case study requirements
- 14 – Advanced Data Transformation
-
15 – Joins and Keep
- Inner Join
- Left Join
- Right Join
- Outer Join
- Keep
- 16 – Applying ApplyMap()
- 17 – Interval Match
- SECTION 2 - Programming for QlikView Ninjas
- SECTION 3 – Tips and Tricks
- This section will contain tips and tricks from the field.
- 1 – Auto reload a QlikView Document
- Section 4 - Incremental Load
-
Appendix – A – Loading Data from Sql Server
- Loading data through SQL Server Stored Procedure
Other books by these authors
The Leanpub 60 Day 100% Happiness Guarantee
Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.
Now, this is technically risky for us, since you'll have the book or course files either way. But we're so confident in our products and services, and in our authors and readers, that we're happy to offer a full money back guarantee for everything we sell.
You can only find out how good something is by trying it, and because of our 100% money back guarantee there's literally no risk to do so!
So, there's no reason not to click the Add to Cart button, is there?
See full terms...
Earn $8 on a $10 Purchase, and $16 on a $20 Purchase
We pay 80% royalties on purchases of $7.99 or more, and 80% royalties minus a 50 cent flat fee on purchases between $0.99 and $7.98. You earn $8 on a $10 sale, and $16 on a $20 sale. So, if we sell 5000 non-refunded copies of your book for $20, you'll earn $80,000.
(Yes, some authors have already earned much more than that on Leanpub.)
In fact, authors have earnedover $14 millionwriting, publishing and selling on Leanpub.
Learn more about writing on Leanpub
Free Updates. DRM Free.
If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).
Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.
Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.
Learn more about Leanpub's ebook formats and where to read them
