Chapter 1: Stories with QlikView
Andy just graduated from university, and he joined an Investment Bank Company. The first day, his manager Tim talked with him. “Congratulations, Andy. I’m very welcome you join our company. First, our team manages 10 billion, we need to make it over 20 billion from 10 billion in next 4 years, and it means we need to make a profit 20% each year. So we need to find out which cities we can invest in next 4 years. Second, give me the report at the end of the day; the report includes ○1Top 10 cities populations in US; ○2top 10 fastest growth cities; ○3Top 10 Fastest growth cities in Texas State; ○4Top 10 cities populations in California State; ○5Top 10 Cities populations and Top 10 fastest growth cities in Ohio State; ○6Population and Growth in Columbus City Ohio State; ○7Compare Population and Growth - New York City VS Dallas City.”
1.1 QlikView is a Data Visualization Tool.
Andy searched and found the QlikView can help him to create his own stories quickly, below is the example for US Top 10 cities populations in 2016.
New York city 8,537,673
Los Angeles city 3,976,322
Chicago city 2,704,958
Houston city 2,303,482
Phoenix city 1,615,017
Philadelphia city 1,567,872
San Antonio city 1,492,510
San Diego city 1,406,630
Dallas city 1,317,929
San Jose city 1,025,350
1.2 Story – Top 10 Cities populations in 2016
1.3 Story – Top 10 Fastest growth cities in 2016
1.4 Story – Top 10 Fastest growth cities in Texas State
1.5 Story – Top 10 City populations in California State
1.6 Story – Top 10 City populations and Top 10 fastest growth city in Ohio State
1.7 Story – Population and Growth in Columbus City Ohio State
1.8 Story – Compare Population and Growth - New York City VS Dallas City
1.9 Above Stories from the Data Source of U.S. Census Bureau
Andy found the data source from U.S. Census Bureau website and downloaded it, and then built these stories.
1.10 Build QlikView Dashboard with stories from Data Source
1.11 The process of QliView Dashboard
Andy followed bellowed process to build the QlikView Dashboard.