1. Which are the data sources and what is their schema?

For this sample we are going to use the following fictional data source:

2. What data analysis must be performed on the data?

For this sample we want to make a dashboard, which shows the grouped company sales for a specific region. We want to allow the user to specify a blank region in the case of which the report will be for all regions.

3. What display elements are needed to show the data analysis?

For this sample we will need a bar chart, the categories of which are the companies and the bar values are the sum of sales for the selected region.

4. What parameters are needed and where and how are they used?

We would need one parameter - for the selected region. The parameter fill be used to filter out the records that apply only to the selected region.

1. Add a new Choice Filter Web Part to an arbitrary SharePoint page.
2. Configure it like this:
   Filter Name: RegionName
   Options: US Europe Asia (each on new line)
   Show Empty Value: check it
   Default Value: US
3. Add a chart web part to the page (see Adding the WebParts to Pages for more info).
4. From the Choice Filter Web Part Edit Menu, choose Connections > Send Filter Values To > Nevron Chart for SharePoint
5. Run the Chart Designer
6. Go to the Chart > Pivot page
7. Drag and drop the sales field as values data grouping.
8. Drag and drop the company field as category data grouping.
9. Add a new pivot filter (from the Filters tab next the Data Groupings tab) with the following expression:
   =IF(Params!SPF_RegionName.STR = "", true, Fields!Region = Params!SPF_RegionName.STR)
   
10. Click the chart designer OK button to save the made changes and return to the page.

Now you have an interactive dashboard, which allows you to choose a region and displays the companies sales for the selected region. Initially selected is the US region.

1. Add a chart web part to an arbitrary SharePoint page (see Adding the WebParts to Pages for more info).
2. Run the chart designer.
3. Connect the chart web part to the data source. (see Connecting to a Database for more info).
4. Go to the Chart > Pivot page
5. Drag and drop the sales field as values data grouping.
6. Drag and drop the company field as category data grouping.
7. Add a new pivot filter (from the Filters tab next the Data Groupings tab) with the following expression:
   =IF(Params!RegionName.STR = "", true, Fields!Region = Params!RegionName.STR)
8. Click the chart designer OK button to save the made changes and return to the page.
9. Add a new Content Editor Web part and insert the following HTML + Java Script:

<table>
    <tbody>
        <tr>
            <td>Region Name:</td>
            <td>
                <div id="NRegionNameId"></div>
            </td>
        </tr>
    </tbody>
</table>
<script type="text/javascript">
    NInitSTRParam("NRegionNameId", "RegionName", {
        InitialValue: "US",
        RefreshMode: "auto",
        EnumValues: new Array("", "US", "Europe", "Asia") 
    });
</script>

Now you have an interactive dashboard, which allows you to choose a region and displays the companies sales for the selected region. Initially selected is the US region.