The process of using QuickBI is similar to eating Zhajiang Noodles. Technicians prepare data for business personnel in advance (steps 1 and 2). Business people drag the data they need into the dashboard or table (step 3 or 4). Finally, dashboards and reports are added to the menu to form a data portal (step 5).
In order to make big data more inclusive, QuickBI and DataV found two different solutions:
The architecture of fast BI products is shown in the following figure:
Main modules and related functions of Quick BI.
Can solve:
Recommended collocation:
RDS+fast BI
Legend:
By integrating all kinds of scattered data, a unified big data platform system is constructed, and various scenarios such as operation, commodities, traffic, shops, ordering and marketing are analyzed, from the overview of various overall indicators to the comparative analysis of hierarchical detailed indicator data, so as to realize the refined operation of data-guided business.
Can solve:
Multi-channel data cannot be integrated and analyzed.
Multi-channel operation, traffic, stores and other data are all in their own arrays, so it is impossible to integrate correlation analysis.
Data collection and management cannot be unified.
The rules of each business part are different, so it is impossible to achieve unified management and control, and the efficiency in data analysis is low.
Difficulties in self-help analysis of business personnel
Business personnel are totally dependent on IT department to analyze data, so they can't analyze flexibly according to their needs.
In the new era, it is necessary to use big data to improve the experience of member service in an all-round way. It is necessary to analyze the classification, grading, preferences and chain store operation of members, and increase the more accurate judgment on member behavior prediction.
Be able to solve
-User data extraction efficiency
From the business point of view, how to extract insights from members and their behavior data to provide better services for members;
-BI system construction cost
The system cost of traditional BI and big data construction is very high and the speed is very slow;
-Business people collaboration
The business threshold of traditional chain report analysis is very high. Due to the characteristics of chain mode, many business personnel are scattered all over the country.
The following will take you on a journey of QuickBI products with a real data analysis case as the scene.
Suppose you are a data analyst of a large Internet new retail enterprise, and your manager just got the monthly operation analysis data from 2065438 to August 2009. He found that the company's recent operation was not good, and Mao Lijiao dropped significantly in the first few months of August, and there was a risk of reaching the standard in the third quarter.
So, this task is up to you. According to the order information, traffic channel information and other related data, the key factors of the decline of enterprise gross profit in August were analyzed and shared with the team, so as to guide the decision-making and actions of relevant business departments and improve the overall gross profit of the enterprise.
Quick BI Quick Start is divided into the following steps:
When the status of the file is synchronization complete
By default, in the personal workspace, after successfully connecting to the data source by uploading a file, you will see the newly created data set under My Data Set. If not, you can create a dataset in the following ways. If the target dataset already exists, please skip this step.
Here are the metrics and dimension information for viewing the order information list.
In order to analyze the gross profit of each channel, you need to increase two indicators, gross profit and gross profit margin, to facilitate subsequent statistics.
In order to analyze the gross profit of each channel, you need to associate the order information list with the channel information dimension table through the channel ID field, so as to get the corresponding channel name and channel category, which is convenient for subsequent related data statistics.
Through the following steps, analyze the reasons for the abnormal decline of gross profit.
Enter the dashboard editing page.
In order to analyze the reasons for the decline in gross profit, you need to look at the trend of monthly gross profit and confirm which month gross profit has decreased. At the same time, it is necessary to analyze the monthly sales trend and confirm the sales situation in recent months. This paper shows the trend chart of monthly gross profit and monthly sales by line chart.
View monthly gross profit statistics
You can view the monthly trend data of gross profit amount through the line chart.
At this point, you can see that the gross profit of 20 19 in August dropped from 665400 in July to 584600.
View sales statistics
In order to further investigate the reasons for the decline in gross profit, you can view the monthly trend data of sales through line charts.