topic Re: Place to find some sample data sets / databases? in QlikView

Place to find some sample data sets / databases?

Tue, 27 May 2014 13:14:27 GMT

Hello to everyone!

I'm quite new to QV community and enviroment.
I have solid background knowledge in BI principles, DB and programming.

I've yet invested some time in QV, play a little with designer...but the sample data is very poor.

Can anyone give me advice or post some links, where can i get some good data samples to play with?
It would be nice to get some bigger data sets with more facts and dimensions....

Please give some advices.

Thanks in advance!

Re: Place to find some sample data sets / databases?

Tue, 27 May 2014 13:15:53 GMT

Sample Data | GeoDa Center

Re: Place to find some sample data sets / databases?

ashfaq_haseeb — Tue, 27 May 2014 13:16:53 GMT

Hi,

why don't you take free training available at Qlik.

QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik

Regards

ASHFAQ

Re: Place to find some sample data sets / databases?

tresB — Tue, 27 May 2014 13:24:09 GMT

Goto Script window of a new application. Press : Alt+I then T . You would get a sample script that generates some sample data.

Re: Place to find some sample data sets / databases?

Tue, 27 May 2014 13:28:22 GMT

Or using some script like : -

SimpleLatLong:

LOAD * INLINE [

CONTID,CONTINENT,Latitude,Longitude

1,Europe,54.525961,15.255119

2,North America,54.525961,-105.255119

3,South America,-8.783195,-55.491477

4,Asia,34.047863,100.619655

5,Africa,-8.783195,34.508523

6,Oceania,-27,133

7,Micronesia,6.887351,158.215072

];

//*********************************************

//Random Table Generator

//*********************************************

SET vRandChar = Chr(Floor(Rand() * 94) + 33); //Character

SET vRandCharU = Upper(Chr(Floor(Rand() * 26) + 65)); //Uppercase Character

SET vRandCharL = Lower(Chr(Floor(Rand() * 26) + 97)); //Lower Character

SET vRandTime = MakeTime(Floor(Rand() * ($2-$1)) + $1, Floor(Rand() *60),Floor(Rand()*60)); //Time Between $1 Hour to $2 Hour (24 Hour Notation)

MapSector:

MAPPING LOAD * INLINE [

SECTORID,SECTOR

1,Investment Banking

2,Cards

3,Retail Banking

4,Commercial Banking

];

MapContinent:

MAPPING LOAD * INLINE [

CONTID,CONTINENT

1,Europe

2,North America

3,South America

4,Asia

5,Africa

6,Oceania

7,Micronesia

];

LongMap:

MAPPING LOAD CONTID,

Longitude

RESIDENT SimpleLatLong;

LatMap:

MAPPING LOAD CONTID,

Latitude

RESIDENT SimpleLatLong;

DROP TABLE SimpleLatLong;

EmployeeDistribution:

LOAD *,

ApplyMap('MapContinent',CONTID) AS CONTINENT,

ApplyMap('LongMap',CONTID) AS Longitude,

ApplyMap('LatMap',CONTID) AS Latitude,

EMPLOYEECOUNTYEAR & CONTID AS %INFLATIONKEY,

interval(TIMESPENT,'hhhh:mm:ss')*24*5 AS AVERGAGETIMESPENT,

ROUND(COUNTOFEMPLOYEE / 100 * CEIL(RAND() * 3)) AS UNCOMPLIANT;

LOAD CEIL(RAND() * 7) AS CONTID,

ApplyMap('MapSector',CEIL(RAND() * 4)) AS SECTOR,

$(vRandCharU) & 1 AS TeamNames,

CEIL(RAND() * 400)*50 AS AVERAGESALARYGBP,

CEIL(RAND() * 4) + 2009 AS EMPLOYEECOUNTYEAR,

CEIL(RAND() * 756)*10 AS COUNTOFEMPLOYEE,

IF(CEIL(RAND() * 2)=1,'Male','Female') AS GENDER,

$(vRandTime(8,17)) AS TIMESPENT

AutoGenerate (30);

LEFT JOIN (EmployeeDistribution)

LOAD DISTINCT %INFLATIONKEY,

.03 AS INFLATIONRATE

RESIDENT EmployeeDistribution;

SET vRandChar = NULL(); //Character

SET vRandCharU = NULL(); //Uppercase Character

SET vRandCharL = NULL(); //Lower Character

Re: Place to find some sample data sets / databases?

Tue, 27 May 2014 14:33:43 GMT

Amm, it seems to simple to me. I think that is appropriate for beginners...

I'm already doing on a little more advance topics like: data model, scripting, qvd, incremental loads, set analysis,...

Extensions, specially mapping functionality is still on a future task's list

Re: Place to find some sample data sets / databases?

Tue, 27 May 2014 14:35:14 GMT

thanks a lot, at first sight looks very useful

Re: Place to find some sample data sets / databases?

Tue, 27 May 2014 17:10:29 GMT

One cool site that I use when I want to mock-up data sets is mockaroo.com. It allows you to choose the data types for each field, and populates them with realistic data.

Re: Place to find some sample data sets / databases?

Thu, 28 Apr 2016 21:56:54 GMT

Cool website. Thanks for sharing.

Re: Place to find some sample data sets / databases?

kumarravi — Mon, 18 Apr 2022 11:48:46 GMT

Hi Folks,
If you want to generate free datasets and use them for your analysis purpose.

Visit: https://www.mockaroo.com/

Here you can create data of your own choice, and create an unlimited number of rows.

I hope this helped you!