Mastering Power View: Creating Interactive Visualizations: Question and Answer

Q.1. How to Produce Bar and Line Maps?

Ans: To produce bar and line maps, follow these steps:

• Click on the blank view.
• Drag the Category field from the field list's fields section onto the blank view. This will create a one-column table.
• Under the field list, in the fields section, drag the "Sum of Qty Served" to the one-column table to create a two-column table with "Category" and "Sum of Qty Served."
• Click on the Bar map in the Visualizations gallery to open it.
• Adjust the size of the bars by holding the edge of the map and using the sizing handle.
• Move the map to the lower-left corner of the report.
• Copy the bar map by clicking on it and selecting "Copy" from the Home menu.
• Paste the copied bar map by clicking on the blank area and selecting "Paste."
• Name the duplicate map.
• Remove the "Category" field from the Axis box and add the "Distributors" field as the axis for the duplicate map.
• Click on the Column map in the Visualizations gallery to open it.

Q.2. How to Add an Alternate Series to a Map?

Ans: To add an alternate series to a map from the Amounts table, follow these steps:

• In the fields section of the field list, click the drop-down arrow next to the "Sum of Qty Consumed" field and select "Add to Values."
• The map will now be a piled column map, with "Qty Served" and "Qty Consumed" values piled on top of each other.
• To change the display to a clustered column map, click the drop-down arrow in the Visualizations gallery and select "Clustered Column map."
• Move the map to the lower-right corner of the report.
• Resize the map by using the sizing handle in the upper-right corner to make it half as wide and as tall as the view.
• Arrange the visualizations by dragging the "Serve" bar map to the top and upper-right corner of the "Distributors" column map.

Q.3. What do you Understand by Pressing and Slicers?

Ans: To filter and punctuate data in a report, you can use pressing and slicers. Pressing a bar in the Category bar map will stress the Distributors column map to show each distributor's fruit quantity. Slicers are used to filter data in a report. To create a slicer, click on the blank view and select the "Category Drawing" option from the fields section of the field list. Click on "Slicer" under the Design tab, and it will contain filtering buttons for each item, including an image for each item. Drag the slicer to the upper-left position beneath the title, and you can see all four orders if you resize them.

Q.4. How to Produce a Slicer?

Ans: To create a slicer, follow these steps:

• Click on the blank view to remove names from visualizations.
• Select the "Category Drawing" option from the fields section of the field list under the Particulars table.
• Click on "Slicer" under the Design tab, and it will contain filtering buttons for each item, including an image for each item.
• Move the slicer to the right of the "Order Drawing" slicer and make it as tall as the view allows.
• Click on one of the orders in the "Order Drawing" slicer to filter all the visualizations on the report based on the selected order.
• To show all values again, click the "Clear Selection" icon in the upper-right corner of the slicer.

Q.5. Why do We Need a Tile Container, and How to Create it?

Ans:  A tile container is used to view multiple charts or visualizations side by side and allows for easy comparison. To create a tile container:

• Select the "Card" visualization and drag the "Drawing" field from the field list for each Card under the Fields box in the layout section.
• For each value supplied in the Drawing field, one tile gets created in the container.
• Click each of the several fruits found on the tab strip along the top of the tile container to see how the Card's information evolves.
• To make the Card higher than it is wide, drag the scaling handle on the right side of the Card.
• Drag the tile container to the upper-right corner of the report, next to the title, by hovering over the tile container's edge until the hand appears.
• Instead of clicking on the tab strip, you can drag a tile container by clicking the edge.
• To add more visualizations to the tile container, select the tile container and drag the proper handle to make it wider, then add more fields from different tables to create new visualizations in the container.

Q.6. How Can We Experiment With The Tiles?

Ans: To experiment with the tiles, select various foods from the tab strip along the top of the tile container. The Card and line chart in the tiles will change to display the values for the selected food. Clicking the cover flow option on the tile container allows you to see the bubbles even better and select different food items to view their data.

Q.7. How do We Add Slicer Filtering?

Ans: To add slicer filtering:

• Select the Bar chart visualization and move the cursor over the vertical multiples.
• Click on the filter icon in the visualization's upper-right corner to open the chart filter area.
• Click on "Sum of Qty Served" in the filters area and drag the slider's right end until the top value is 400.
• The chart's values will be modified, and the Y-axis will now have 400 as the highest number.

Q.8. What do You Understand by Bubble Charts?

Ans: Bubble charts display three measures, making them distinct from scatter charts that display only two measures. The three measures in a bubble chart include two for the X and Y axes and a third measure represented by the size of the bubbles. Bubble charts are useful for visualizing and comparing data across three dimensions.

Q.9. How to Add Category Group Colors to a Scatter or Bubble Chart?

Ans: To add category group colors to a scatter or bubble chart:

• In the Chart Fields layout section, drag the "Name" field from the Items table's fields section to the Details box.
• Drag the "Category" field from the field list's fields section to the Color box in the Chart Fields layout section.
• Now, the bubbles will be colored based on the category to which they belong.
• Click on a category name in the legend to see the items in that category highlighted in the bubble chart.

Q.10. How do We Create Small Multiples?

Ans: To create small multiples:

• Start with a blank view.
• Select the "Category" field from the Items table's fields section and drag it to the layout area of the field list's Vertical Multiples box.
• Click on the "Grid" option in the Layout tab within the Chart Tools contextual tab.
• Drag to select an area three multiples wide by two multiples tall.
• Move the multiple small containers to the lower-right corner of the view.

Q.11. How to View and Visualize Filters?

Ans: View filters and visualization filters both modify the view of a report. View filters apply to the entire report, while visualization filters only affect specific visualizations. Visualization filters are used to highlight relevant areas in other charts, remove certain items from a tile, and filter the slicers.

Q.12. How to Create a Visualization Filter?

Ans: To create a visualization filter:

• Click on the filter icon in the visualization's upper-right corner.
• Choose the measure you want to filter, and adjust the filter settings as needed, such as setting the maximum value.
• The visualization will be updated based on the applied filter.

Q.13. How to Start a Power View?

Ans: To start a Power View:

• Go to Shared Documents and click on the arrow next to it to select the shared data source you want to use.
• Click on "Create Power View Report" after selecting the data source.

Q.14. How to Create a Sample Subscriber Database?

Ans: To create a sample subscriber database:

• Open Management Studio and connect to a database engine.
• Right-click on Databases and select "New Database."
• Type "Subscribers" in the Database Name field and click "Create."
• Open a new query and paste the provided Transact-SQL clauses into the query.
• Click "Execute" to create the sample subscriber database.

Q.15. How do You Define Data Driven Subscriptions?

Ans: To define data-driven subscriptions:

• Click on "Home" and navigate to the report folder where you want to create the subscription.
• Click on "Manage" and then go to the "Subscriptions" tab.
• Click on "New Data-driven Subscription" to start the Data-Driven Subscription Wizard.
• Follow the steps in the wizard to define the description, establish a link to the subscriber data source, create a query to get subscriber information, set delivery options, configure parameter values, and schedule the subscription.

Conclusion

We have learned various techniques and steps for producing different types of maps, creating slicers, tile containers, and small multiples in Power View. We also explored how to work with bubble charts and add category group colors to visualizations. Additionally, we delved into the concepts of view and visualization filters and how to create data-driven subscriptions.

By following the detailed instructions provided in each section, users can effectively generate bar and line maps, add alternate series, and experiment with tiles to compare data visually. Slicers are demonstrated as powerful tools to filter and punctuate data in a report. Furthermore, the content covered techniques for creating small multiples to analyze data across multiple categories efficiently.

The importance and benefits of bubble charts, which allow for comparison of data across three dimensions, and how to add category group colors to improve visualization clarity. Finally, the content explains the process of creating data-driven subscriptions for automating report delivery to specific subscribers based on query results.With this comprehensive guide, users can confidently utilize Power View to analyze and present data in a visually engaging and meaningful manner, facilitating better decision-making and insights for their organizations.