In our BI Reporting series, we address several BUI reporting tools.  This blog expands on our Business Intelligence Quick Reference Guide.

Enjoy.

Step Action Details
1. Start Visio    
2. Mock up report in Visio    
3. Link shapes to database: Data?Link Data to Shapes?Microsoft SQL Server Database  
4. Select the UserView: Server, Reporting DB, appropriate UserView  
5. Enter name of Data Connection    
6. Select your Data Connector, Rows & Columns    
7. From External Data window, drag & drop item onto graphical element    

8. Use Data?Data Graphics to configure item appearance based upon its value

Save to SharePoint document library