Data Visualization in SSRS

 Data is becoming an important asset  for organizations  and data visualization is gaining immense prominence in inferring knowledge  from that data   in an easy way.Imagine you have gathered tera or peta bytes of data and the  business users cant explore the information for the  patterns and connections  in an easy timely manner,  than the effort you  make in creating  those  data stores will be of less useful to the business.

Using  Data Visualization   effectively with dash Boards and business score cards are an important aspect in gaining the strategic and and analytic  insights  of the business  at a glance.Therefore effective use of the space ,colors and the visuals play an important role in conveying the message to the users.

The key factors  when building the reports  or dashboards  are

• Use the space effectively in dashboards to include key insights   
• Use the right visualization  for observing different trends
• Make navigation easy to users and should be effective in helping the users in reaching to the data of interest
• Use the parameters as and when needed and don't make it mandatory to include parameters in every report or dashboards
• Keep  the reports simple without borders or lines  and emphasize data effectively
• Use light colors for the report  column headers

SqlServer Reporting Services  has included many new capabilities for building reports and introduced various data visualization futures starting  from sqlserver2008r2   Reporting Services.

I have built a report using Adventureworks DW 2012 

The key things in the report is the effective use of space colors and visuals,as you can see the sales trend over time is shown using  a sparkline which  shows the trend over calendar years in a single column which is a very good use of space  and i have included a indicator to show the status of sales and a pie chart to show the sales contribution to the total sales and also the report doesn't include any lines and borders in between the rows and columns.