Problem solve

Data Visualization Techniques for SQL Server

• Managing data with Enterprise Integration Management and SQL Server

  Microsoft tools for SQL Server can help build a comprehensive enterprise integration management platform.Continue Reading

• Five SQL Server 2012 business intelligence features

  The BI Semantic Model and Data Quality Services: These are two of the five SQL Server 2012 BI features that highlight this database release.Continue Reading

• SQL Server views: Creating indexes and adding base data

  SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data.Continue Reading

• SQL Server views: What they are and how to create them

  SQL Server views can help DBAs provide information to users while still controlling data access. Find out how.Continue Reading

• Power View packs ample ways of seeing SQL Server business intelligence

  Data can be viewed in any number of ways using Microsoft’s new BI tool, according to expert Robert Sheldon. But the application does have its limitations.Continue Reading

• SQL Server Power View makes BI reporting look simple

  SQL Server 2012’s business intelligence tool puts report building in users’ hands. Read this tip from expert Robert Sheldon to how to get started.Continue Reading

• Microsoft tailors BI capabilities for users, IT in SQL Server 2012

  Industry watchers weigh in on Microsoft SQL Server 2012, which offers added business intelligence capabilities for end users and IT. Features include Power View and master data management.Continue Reading

• With familiar tools, new toys, Microsoft BI stack casts wide net

  The Microsoft BI stack gains a few additions with release of SQL Server 2012, with new Excel-based Power View for business users and old standbys like Reporting Services.Continue Reading

• Weighing visual output options for SQL Server business intelligence

  A business intelligence solution can present data in a variety of ways, such as dashboards, scorecards and reports, but each form has a little something different to offer.Continue Reading

• Matrix configuration techniques for Report Builder 3.0

  There is more to setting up a matrix table than the basics. Here are some advanced techniques for tweaking your tables to best display your data.Continue Reading

• Enter the matrix with Report Builder 3.0

  Want to know what the matrix is? With SQL Server, just like the movie, it's best to see it for yourself.Continue Reading

• Creating matrix reports with Report Builder 3.0

  Matrix tables display data similar to pivot tables, but setting them up for SQL Server requires an understanding of the basic components.Continue Reading

• Adding a polygon layer to a map in Report Builder 3.0

  The first step to putting a geospatial map in an SSRS report involves creating what's known as the polygon layer. This tip explains what that means and how to get started.Continue Reading

• Finalizing maps with Report Builder 3.0

  Like an onion or parfait, maps in SQL Server Report Builder have many layers. Here you'll learn how to finish off a map by adding point and tile layers in your report.Continue Reading

• Geospatial mapping made simple with Microsoft SQL Server

  The new spatial and analytic mapping functionality in Microsoft Report Builder is a great way to generate more dynamic SSRS reports – once you know how to create them.Continue Reading