Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

AdventureWorks Database

I am new to Qlikview and was wondering if the adventureworks.xls database is available to download somewhere? I would like to try and recreate the Sales Management and Customer Analysis Demo as a tool for learning this wonderful software.

4 Replies
MVP
MVP

Re: AdventureWorks Database

I am not sure if there is a Excel file called adventureworks,  I think you are referring to the Microsoft sample / demo database that ships with their MSSQL products.

You can download the demo DB from

http://msftdbprodsamples.codeplex.com/

see also

http://blog.sqlauthority.com/2010/05/01/sql-server-what-is-adventureworks/

There is also a free version of MSSQL server (Express) which you can download from the MS site.

http://www.microsoft.com/sqlserver/en/us/editions/2012-editions/express.aspx

Hope this helps,

Stefan

Not applicable

Re: AdventureWorks Database

Thanks swuehl! I will look into those!

alan_richmond
Contributor

Re: AdventureWorks Database

Hi no-one seems to be anwering this question and its been asked in a number of places.  The Sales Management and Customer Analysis demo uses both the Adventureworks database, easy to find at codeplex but also uses Adventureworks.xls as below.  Where can we download the Adventureworks.xls?

LOAD
 
ProductCategoryID,
    
Name as ProductCategoryName
FROM
[..\Database\AdventureWorks.xls]
(
biff, embedded labels, table is ProductCategory$)
WHERE EXISTS(ProductCategoryID);

satyadev_j
Valued Contributor

Re: AdventureWorks Database

Hi,

Just want to share my thoughts here. I am always utilizing Qlik Demo in two different ways for my internal customer demonstration.

1) Create two copy of the demo, use one copy as a binary load, change the data by using mapping load and resident load which suits our customer needs.

2) If there are few tables in the demo, export those tables in excel, change the data as per customer requirement, replace the existing demo qvd/db table with newly created excel.

Of course, I have to change or add few things as well e.g logo, label, introduction but this is saving lots of my time.


Satya

Community Browser