Frequently Asked Questions

If you have any questions about Analyza, you will probably find here the right answers !

Dashboards

  • An indicator shows the response to a data request in a visual form, for example a vertical chart, or a table. The data request of an indicator is constructed by selecting data objects and by applying filters on them.

    In Analyza, a dashboard put on the same screen several indicators.

  • If you want to move an indicator, just click on the window (near the title, for example) and move your window by Drag'n Drop.

    If you want to change the color of window, click on the square icon to open the colors palet

    If you want to reduce/enlarge or view in full screen one indicator, just click on the appropriate icon. You'll have a good view of the desired data.

    And finally, if you want to remove one indicator of your dashboard : press the cross icon corresponding to the selected indicator.

    Don't forget to save these dashboard modifications in order to be visible for other users.

The indicators

  • In the left menu, click on add an indicator.
    This will display a window with two fields:
    - The folder where you want to store this indicator
    - The name of your indicator
    Once this step is completed, click on "Next".

    Then, you must set user permissions for this new indicator, you can choose between:
    Doesn't have permission (the user will not see the indicator), can view, can modify or can share.
    After that, click on "Close".

    Back in the left menu, you can see that a new folder appeared with your new indicator. Your graph doesn't represent anything yet and this is normal, we haven't assigned object (measures or dimensions) to it.

  • Choose a folder in Available Objects and click on its name.
    A dropdown list appears, displaying all Measures and/or Dimensions in this folder, these are your objects.
    Available objects are objects from your data, specifically configured for your analysis.
    Select at least one measure and one dimension to have a useful indicator.

  • In the right menu, under your objects, there are important parameters for your indicator.

    For example, you can choose its graph type :
    - Pie Chart
    - Horizontal Chart
    - Vertical Chart including Column Chart, Line Chart, Area Chart
    - Table

  • When the display typechosen for an indicator is a vertical graph, click on the graphic icon next to the name of the measure.
    For optimal viewing, you can choose to display your measurable data in Column, Line ou Area.

  • To have this choice, click on the small white triangle. The sorting type can be ‘ASC’ for ascending, or ‘DESC’ for descending.

    When the display type chosen for an indicator is a table, the order of the columns in that table depends on the order set for the selected objects.

  • In the right menu, under your objects, there are important parameters for your indicator.
    Below the type of chart drop down menu, there is a field to choose the maximum number of rows you want to display.
    This is very usefull to make some Top 3 of Bottom 10 analysis.

  • It's because you don't have permission. For more information about permission, go to the tab "Permission management".

  • To Zoom (make a Drill Down navigation), there must have only one selected dimension.
    A Drill Down is possible by clicking on a value in an indicator. It will filter on the selected value (ex:Year 2014) and display the current indicator in another more detailed dimension (ex:Months).
    Technically, a Drill Down is the combination of a dimension change and a filter application.
    A Drill Down is only possible if a "Parent > Child" hierarchy was defined in the Analyza tool data manager for the selected dimension by the user.

Filters

  • When I click on the funnel icon next to a measure in objects , a window opens with the following options :

    First you can choose the logical operator you want. This is how the filter will react with other filters (AND/OR).

    In these fields you can enter numerical values ​​but also some SQL parameters :
    - Equal to : Displays values ​​with a specific result
    - Different from : Displays a different value from a specific result
    - Less than : Displays values ​​smaller than a given number
    - Greater than: Displays values larger than a given number
    - Between : Displays the values ​​between two given numbers. Separate the two numbers with the keyword "AND"
    - Not between : To exclude the values ​​between two numbers data. Separate the two numbers with the keyword "AND"
    - A custom formula : Applies a SQL rule for MySQL, such as "* 1.21> 1000"

  • When I click on the funnel icon next to a dimension in objects, a window opens with the following options :

    First you can choose the logical operator you want. This is how the filter will react with other filters (AND/OR).

    Then you must define which element(s) you want to find on your dimensional axis.
    - In list : Select one or more values ​​from a list of available values
    - Not in list : Allows you to reject one or more values ​​from a list of available values
    - Matching pattern : Used to apply a SQL rule for MySQL to select and keep values in this dimension, for example to keep only the fifth day of each month: «%05»
    - Different from pattern : Used to apply a SQL rule for MySQL to reject values in this dimension, for example to reject every 1st month of each year: «%/01/%»
    - The max value : Select the maximum value for that dimension, from the loaded data
    - The min value : Sets the minimum value (not empty) for this dimension, from the loaded data
    - A custom formula : Applies a SQL rule for MySQL, for example, "is not null"

  • Because the measures window takes as argument just number data. So it need to be handled differently, particularly by mathematical formulas.

  • Yes you can put multiple filters on the same object, whatever if it's a measure or a dimension.

  • To edit a filter simply click on it in the center window, between the title of the indicator and the graph.
    Here, you will be able to edit your filter or remove it.

La gestion des Permissions

  • This view is divided into four tables :
    1. Repository, dashboards and indicators,
    2. Available objects and their folders,
    3. Alertes,
    4. Loads

    In each of these tables are arranged in rows the elements relating to it, you have a quick and comprehensive view of all items imported/created in Analyza.

    Your permissions column in each table has the following symbols :
    Means that you can see the item,
    Means that you can edit, modify the item
    Means that you can share the item
    Means that you can manage data (only in the "Loads" table)

    If icons are blue it means that you have the associated rights, otherwise they will be grayed out.

Data management

  • After clicking on Data management button, you will be on a slightly different interface.

    This view, for your data manager, has several options explained further in the user guide for administrators.

    As an analyst, let us focus on last loading button, which is used to view the history of all data streams imported in Analyza.

    All sources given above are filterable by column :
    Name, End Date, Time, Type, source lines, loaded lines, and state.

Export and print

  • In the bottom left menu, there is an Export button and a Print button.
    To export your data in .csv for Excel you just need to click on the right icon and get back your file in the download folder.

  • In the bottom left menu, there are two buttons : Export and Print.
    Click once on the icon of the printer. You will find a new interface suitable for printing where you can choose toPrint or to Cancel (exit).

    If you choose to continue, you will have access to a window consisting of several fields, the main parameters are :
    1. Select the printer that will do the work
    2. Choose to print all pages or a set number
    3. The number of copies
    4. Print in portrait (vertical) or landscape (horizontal)

    The Print button will end your work. You can now enjoy a nice support for your analysis!

Others...

  • to actualize your data, to be sure that your working objects are up-to-date.

  • Of course, in real time via the chat window or via the contact form available in Contact section.