Email the Author
You can use this page to email Rajesh Pillai and Radhika Pillai about QlikView for Ninjas.
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
I am the Co-Founder of Algorisys Technologies where we specialize in providing solutions using Open source stack inlcuding but not limited to, MS technologies, HTML5, javascript, ruby on rails, nodejs, react, angular etc. I have about 22+ years of overall software development experience covering major roles across different verticals.
My free early access tutorials are hosted at https://teachyourselfcoding.com/
I blog at https://teachyourselfcoding.com/blog
My video tutorials are at https://www.youtube.com/tekacademylabs
My LinkedIn profile is at http://in.linkedin.com/in/pillairajesh/