Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Implementing Qlik Sense

You're reading from   Implementing Qlik Sense Design, Develop, and Validate BI solutions for consultants

Arrow left icon
Product type Paperback
Published in Oct 2017
Publisher Packt
ISBN-13 9781786460448
Length 438 pages
Edition 1st Edition
Arrow right icon
Authors (2):
Arrow left icon
Kaushik Solanki Kaushik Solanki
Author Profile Icon Kaushik Solanki
Kaushik Solanki
Ganapati Hegde Ganapati Hegde
Author Profile Icon Ganapati Hegde
Ganapati Hegde
Arrow right icon
View More author details
Toc

Table of Contents (12) Chapters Close

Preface 1. Consultant - An Introduction FREE CHAPTER 2. Preparing for the Project 3. Prerequisites to Start a Project 4. Requirement Gathering 5. Architecture Design 6. Development 7. Validation, UAT and Go-Live 8. Post Go-Live 9. Avoiding Common Pitfalls 10. Knowledge Sets 11. A Real Life Case-Study

Execution of project

Now that Jim has frozen the data architecture and best fit data model, he can start the development work. He decides to start with the extraction process. (For this example, we will fetch the data from data warehouse available in Microsoft Access database.)

Extraction

First thing that Jim needs to do is to create a connection to the database. Microsoft Access database can be accessible to Qlik Sense via an ODBC driver, so he will have to create an ODBC connection to connect to the Access database.

Let us see the steps used by Jim to create an ODBC connection to the data source:

  1. Open the ODBC data source wizard.

You need to go to Control Panel | Administrative Tools | ODBC Data Source (32 Bit).

Once you...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime