The qlik sense desktop case shows the effects of several report cases that have just been viewed and completed (if the image is not displayed normally, refresh the page again) -I personally feel that the report design process is very simple and convenient, and the report interaction is also very strong, it is easy to analyze and view data information from various dimensions. I guess many people have heard of qlikview, and we can see that qlik has ranked second in the 2014 Bi development tool ranking, Tableau in the first place, and Microsoft in the third place. Of course, both of them have unique advantages in report development, such as loading large data volumes, processing in seconds, and strong interactivity. Qlikview can also achieve Remote sharing and remote interaction, which is not a typical Nb! Qlik sense desktop was officially released in December August 2014. It is a free version and will be available in the next month. For more information about qlik sense desktop, refer to their official website. The following sections describe:
- Qlik sense desktop Installation
- Qlik sense desktop provides tutorial and how to Series
- Initial use of qlik sense Desktop
- Data Loading
- Create the first chart-line chart
- Bar Chart usage
- Pie Chart usage
Install qlik sense desktop-http://www.qlik.com/here, select objective-qlik sense desktop. If this is the first download, You need to register an account. Of course, they will call you for domestic customer service sales. On the one hand, I want to understand the background of your use of qlik sense desktop, including the company and project requirements. On the other hand, it is to promote and sell their server products and more services. The system prompts you to download and install qlik sense desktop. Currently, the downloaded qlik sense desktop version cannot be installed on Windows Server, and Windows 7 is normal. If you need to install the full version, you need to pay for it. Qlik sense desktop provides the tutorial and how to series when you choose to install the tool for qlik sense desktop, A get started video and tutorial on the http://www.qlik.com/us/explore/products/sense/desktop/get-started page, you can learn this to get started with the use of qlik sense desktop report development tools. Most videos can be watched directly, but some content or video promotion may not be visible for any reason, as shown in. But what's hard for our it male? There are technical posts everywhere in 1024, and there is no wall in our hearts! Qlik sense desktop is initially used to load data to open the qlik sense desktop tool. The interface is simple, clean, and simple. To create a new application-my first app, you can drag and drop data on this interface. You can download the test data on your own website or go to my Baidu cloud shared download link: Baidu cloud password: k613 to find these two source data files. The countries CSV file contains the country, country code, region, region size, population, and other basic information. The vehicles Excel file contains data related to automobile sales. You can drag and drop the file to read qlik sense desktop. Countries.csv file-CSV file is actually a flat file separated by commas (,). Click load data. To load the vehicles.xlsx file in the same way, you can select which columns need to be loaded or not loaded in the fields column. The data loading process is very simple, basically no additional processing operations are required, and the speed is very fast. In fact, you can also take a look at the syntax structure of Quick data load when loading data. This data source has more than the file type. You can click Create new connection. There are many options. Supports many data source connections, which can be found in the drop-down list of providers. Create the first chart-line chart create a new sheet page and click Edit to edit the chart. In this way, you can see a lot of charts in the left column, click the icon at the bottom of the list to display Sheet properties, and change the title to car sales. Drag a line chart to sheet, and add dimension is the angle of your observation data. Add measure is the aggregate data you want to view. We use year to view the aggregated data of car sales, so add dimension points to year, and add measure points to sum ([car sales]) in car sales. This is the first chart, which is very simple. Click Done and save to view the line chart. Then, you can click Save to view some interactions on the chart. At the same time, you can modify some attributes of the chart. You can see various attributes on the right panel, including dimensions, metric values, sorting, and appearance. Here, the numeric format of the measure metric value is modified. Drag and Drop a bar chart and modify the title. We want to use this bar chart to check which countries have bought cars? Dimension select country, measure select AVG car sales, and modify the label in measures. Select appearance, modify colors and legend, and select the custom mode of M. The gradient effect of the color is required according to measure. In addition, many attributes can be adjusted at the presentation, which is very convenient and simple. To use pie chart, we need to check the average sales of cars by region. For dimension, select region and AVG sales for measure. Click Save to view its effect. Qlik sense is highly interactive. You can select other charts based on car sales by country, which may change accordingly. You can also select region to move a small screen to view the content on bar chart. You can select any year to view the corresponding data. I have made several other reports, which basically do not require special reference. It feels very fast to get started. Resource Material download link: http://pan.baidu.com/s/1gd8Cwk7 password: k613
For more bi articles, see the Bi series Essays (SSIS, SSRS, SSAs, MDX, SQL Server, to help others quickly see these articles in the recommendation bar of the biwork blog.
First-generation reporting tool qlik sense desktop in 2014
