secret data analysis with excel examples

Secret data analysis with excel examples how to#
Secret data analysis with excel examples full#

In this step, all you need is simple SQL rather than complex programming languages. You can connect to the databases in a few clicks. Step 1: Connect to the database and import the dataįineReport supports multiple data sources, including Excel. You can query the information of specific cities, and the ‘region’ box control the ‘province’ box, the ‘province’ box control the ‘city’ box. Let’s take this dynamic report as an example, which is a typical interactive report in the business. And I will use FineReport in the tutorial because it is easiest to make interactive reports after I tried a lot of dynamic reporting tools. So, the following tutorial will focus on the interactive part of dynamic reports. And they were surprised by how easy it is to implement the real-time reporting following the tutorial. Many readers left the message that real-time reporting frees them from repetitive work.

Secret data analysis with excel examples how to#

We have talked about real-time reporting in detail in the last article, including the benefits and how to implement it. Input ‘Li’ in the text box and click ‘Query,’ all the suppliers whose name contains ‘Li’ will be listed.

Secret data analysis with excel examples full#

Dynamic conditions: If you want to filter the data in the table, you are uncertain about the specific query conditions, the dynamic conditions will help you solve your problem.įor example, you forget the supplier’s full name and only remember that it begins with ‘Li’. However, when you select query by month, the data will only be available within a specific month.Į. For example, You can query the information during any period when you choose query by day.

Dynamic display on the parameter panel: In many cases, the selected option in one drop-down box can control the options in another drop-down box. It enables the user to navigate the data from a comprehensive view of the data to a more detailed one.ĭ. Drill down: Drill down report is a common type of dynamic reports. For example, when you click the city on the map, the correlated charts will show the corresponding product analysis and customer analysis of this city.Ĭ. It builds a correlation between two charts. Parameter linkage: Linking parameters is another basic function of dynamic reports. When using multiple data sources, you can use parameters to select or input value to filter all the data you want.ī. Note: The examples above are made with FineReport.Ī.Parameter filters: Filtering with parameters is the primary function of the dynamic reports. In brief, dynamic reports are real-time reporting + interactive reports. Dynamic reports are generated based on the latest information and provide interactive features that allow end-users to do various types of data analysis with ease.

Stunning 3D map and other 3D visualization effectsĭynamic reports are not only mean the reports composed of dynamic charts.

19 categories and 50+ styles HTML charts.

Leverage Dynamic Reporting Tools to Make Your Reports Stunning