Data Studio

Data Studio is a next-generation reporting tool that is fast and intuitive. It is easy to use and provides a rich user interface to create and edit charts and dashboards.

Gallery Tab

The Data Studio page displays the following tabs:
  • Home tab
  • Dashboard tab
  • Charts tab
  • Gallery tab
  • Schedules tab

The Gallery tab displays a collection of pre-packaged dashboards. They are categorized as vertical-specific reports. The Gallery tab displays a preview into each of the dashboards listed on the page.

You can import all the dashboards in a category by clicking Import all, or view each dashboard and choose a specific dashboard to import by clicking the import icon next to it.

After importing the dashboard, it would appear in the Dashboards tab for review or analysis. The dashboards can be edited and deleted as required and are also customizable.

Gallery Tab

Home Tab

The Home page displays dashboards and charts created within the system. You can click each dashboard or chart to view them individually and edit them.
Home Tab
A dashboard can have a collection of one or more charts. Both dashboards and charts can be broadly customized into Favorite and Mine categories. You can click View All to see all the dashboards and charts within the network. Click the +Dashboard icon or +Chart icon to add dashboards and charts respectively.
Dashboards or charts that are viewed often can be marked as favorite by enabling the star icon as displayed in the image. Those marked appear within the Favorite tab.
Marking Favorites

You can create your own charts and dashboards and save them under the Mine tab.

Charts Tab

Charts aid in visualizing network data from as simple as a pie chart to complex network graphs. There are a variety of options to choose from, to visualize data.

The Charts tab displays all the charts created either as widgets or tables. It displays information about the owner of the chart, chart title, visualization type (such as bubble chart, pie chart, time-series chart, and so on), dataset type (such as AP inventory, applications, client info and statistics, and so on), favorites, and modification details. Every chart can be selected and deleted.
Note: Charts can be deleted or edited only by the owner. Other users can make a copy of the chart, by using the Save As option, and become an owner.
Click Bulk Select to select several charts at a time and delete them all at once. You can search for a particular chart in the search field, by title. The list of charts can also be sorted and viewed by the options recently modified, least recently modified, and in alphabetical order as well.
By clicking +Chart, you can create a new chart as shown in the image.
Creating a New Chart
After selecting the dataset of choice from the menu, you can choose one of the options under Recommended tags, Category, and Tags and click Create New Chart. A new page is displayed with two tabs - Data and Customize. From the Data tab, you can select the chart type, time, query, annotation and layers for the chart, and the analytics trends you wish to see. You can also open the left panel by clicking the table icon, which displays all the columns and calculated metrics of the dataset selected. From the Customize tab you can select the color schemes for the chart, legend, X-axis and Y-axis parameters, and tool tip options. After making these changes, click Run to view the chart that's created after processing the configuration settings.
The following example is time series chart that displays the average disk utilization both as a time-series graph and as a table, in a green color scheme. The green dots represent the predictive analysis information calculated by the system against the green circles that are markers on the graph. You can export the chart into a .json or .csv file format, and also download it as a JPG file or image. Clicking View Query displays the script that is run to fetch data for a specific chart.
Sample Chart - "New Chart for My Network"
Clicking Save displays the Save chart dialog box which also provides an option to save the chart to a dashboard. After selecting the dashboard you can either go to the dashboard where the chart is saved, or simply choose to save the chart which will be listed in the Chart tab.
Save Chart Dialogue Box
In the following example, the chart "New Chart for My Network" is added to the dashboard "APs Rx Tx dashboard".
Chart Named "New Chart for My Network" Added to Dashboard "APs Rx Tx dashboard"
New Chart also Added to the Charts Tab
The owner of the chart is provided with an option to schedule an email report from the screen while viewing it. Click a chart to view the details.
Schedule Email from Chart window
Schedule Report from Chart window
Click the icon at the top-right corner which displays the Add New Schedule window.
Adding Schedule for a Chart

In the Add New Schedule window, enter the details and configure the schedule and click Add to create a schedule for the chart. The report schedule is displayed in the Schedules tab.

Dashboard Tab

The dashboards are a collection of charts which is highly customizable according to user needs.

The Dashboard tab displays all the dashboards created either as widgets or tables (contains one or many widgets, and or charts). It displays information about the owner of the dashboard, dashboard title, status (Published or Draft), modification details and so on. Individual dashboards can be selected and deleted, or they can be selected in bulk and deleted. Only dashboard owners can edit or delete them. You can search for a particular dashboard in the search field, by title. The dashboard information can also be sorted and viewed by the options recently modified, least recently modified, and in alphabetical order. You can also filter the dashboards by using created by or owner drop-downs.

By clicking +Dashboard you can create a new dashboard as show in the image. You can edit the dashboard name and select the components and charts that you want to include to the dashboard.
Creating a New Dashboard
You can add various components to customize the appearance of the dashboard. Some of them include tabs, rows, columns, dividers, headers, and markdowns. You can also choose the charts you want to add to the dashboard and view them based on their time of creation, dataset, visualization type, and name. Charts added to the dashboard appear as a widget or tile. You can click on the chart to modify the title and also expand or contract the chart to fit within the dashboard. You can also delete a chart within the dashboard by clicking the delete icon in the widget. For more information about the chart, you can click the data source link from where the chart is included.
The following is a sample dashboard titled "APs Rx Tx dashboard", created with two tabs - one for network traffic and another for Rx and Tx values. It includes charts displaying values for Total Tx, Total Rx, a pie chart displaying the data distribution for totals APs by network traffic, and the location of APs within the globe.
Sample Dashboard - "APs Rx Tx dashboard"
Clicking Discard Changes removes changes done to the dashboard. After making all the changes to the dashboard, click Save. The dashboard is saved by default as a Draft, and listed in the Dashboard tab.
New Dashboard Added to the Dashboard Tab
The owner of the dashboard is provided with an option to schedule an email report from the screen while viewing it. Click a dashboard to view the details.
Dashboard View - Schedule Icon

Click the icon at the top-right corner which displays the Add New Schedule window. Enter the details and configure the schedule and click Add to create a report schedule for the dashboard. The schedule is displayed in the Schedules tab.

Export and Import Dashboard

Dashboards can be exported to make a copy or backup which can be imported at a later point of time. You can also share the exported file with other users who can import the dashboard into their account. From the Dashboard tab, you can export the dashboard details by clicking the icon in the Actions column. You can also use the BULK SELECT option to select and export several dashboards at a time.
Dashboards - Export and Bulk Export
To import the file, go to Settings > Import Dashboard.
Importing Dashboards

In the Import Dashboard(s) window, choose the exported dashboard file, select the database, and click Upload to import the dashboard file.

Note that the export and import is for the dashboard template only and the data is restricted based on the account and the resource group.

Schedules Tab

Reports presents a snapshots of the dashboards and charts. You can set up a schedule to send the reports by way of email to internal and external recipients at regular intervals (daily, weekly, or monthly). Only the owner of a dashboard or chart with Admin or Network Admin privileges can create a schedule of reports for the dashboard or chart. The schedules are visible to all users of the same tenant account with Admin or Network Admin privileges.
Schedules Tab
Data Studio Scheduled Reports
The Schedules tab displays the following information:
  • Status: Displays the status (successful or failed) of the scheduled report.
  • Last Run: Displays the date and time (including time zone) at which the report was last run.
  • Name: Displays the name of the report.
  • Schedule: Displays the time at which the report is scheduled to run.
  • Owners: Displays the name of the user who has created the scheduled report.
  • Active: Indicates whether the schedule is enabled or disabled. Only the owner of the scheduled report and users with Admin privileges can enable or disable the schedule.
  • Actions: Displays all the actions that you can perform on a configured schedule, as described in the following table.
    Table 1. Actions Description
    Action Icons Description
    (Execution Log) View the execution log of the scheduled report.
    (Edit) Edit the scheduled report. Only the user who created the schedule (the owner of the schedule) can edit the schedule.
    (Delete) Delete the scheduled report. Only the user who created the schedule (the owner of the schedule) can delete the schedule.

The owner of the schedule can also use the Bulk Select option to select several schedules and delete them all at once.

Creating a Schedule

Complete the following steps to create a schedule.
  1. From the web interface, go to Data Studio and select Schedules tab.
  2. Click + Schedule to create a schedule.
    The Add New Schedule dialog box is displayed.
    Add New Schedule Dialog Box
  3. Complete the following fields:
    • Name: Enter a name for the report.
    • Description: Enter a description of the report.
    • Active: Use the slide button to enable or disable the schedule.

      If the schedule is enabled, the reports will be sent to the recipient according to the schedule. If the schedule is disabled, the schedule becomes inactive and the report does not run at the configured frequency.

    • Schedule: Configure the schedule frequency to run the report (daily, weekly, or monthly).

      Selecting a daily schedule presents an option to choose the time of the day to send the report. Selecting a weekly schedule presents options to select the day of the week and time of day. Selecting a monthly schedule presents options to select the date of the month and time of day to run the schedule.

    • Timezone: Select the time zone that must be considered for the schedule.
    • Message Content: Select one of the following:
      • Dashboard: Specifies to create a schedule for a dashboard report. Select a dashboard from the list.
      • Chart: Specifies to create a schedule report for a chart report. Select a chart from the list.

        You can choose to send the chart report in the PNG or CSV formats.

    • Email: Specify the email address of the recipient to whom you want to send the report. You can enter email addresses of multiple recipients separated by commas or semicolons.
  4. Click Add to create the schedule.