Email Alerts
-
Understanding Microsoft SQL Server business intelligence options
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business intelligence capabilities. In this handbook, read about recent BI updates in SQL Server 2012. See how Mic... E-Handbook
-
Maximizing the benefits of Excel add-ins: PowerPivot and Power View
This guide explores the capabilities of the Excel plug-ins PowerPivot and Power View, offering tips for accessing valuable business intelligence data. Essential Guide
-
Reporting Services architecture: Creating high-quality reports
In this book excerpt, author and Microsoft SQL Server Reporting Services expert Brian Larson introduces features of Reporting Services. Book excerpt
-
Interactive reports highlight Microsoft SQL Server Reporting Services
Author and Reporting Services expert Brian Larson discusses features of SQL Server Reporting Services in this interview. Q&A;
-
Q&A;: Authors discuss the advantages of Microsoft Power View
In this interview, the authors of a how-to book on Power View discuss the advantages for both business and IT. Feature
-
Get going with Microsoft Power View and SharePoint
In this book excerpt, the authors explain Microsoft SQL Server Analysis Services and how to get started with Power View. Book excerpt
-
Exploring Microsoft PowerPivot and collaborative business intelligence
Learn the background of Microsoft Power View and how PowerPivot works with Microsoft Excel 2010 in part one of this book excerpt. Book excerpt
-
Intel boosts Moore's Law with SQL 2012 business intelligence
Intel is keeping Moore's Law on track with the self-service BI features of SQL 2012 business intelligence. Feature
-
Little-known features of Microsoft SQL Server 2012
When it comes to Microsoft SQL Server 2012, it's easy to think you've seen it all. Andrew Novick shows Microsoft still has surprises up their sleeve. Feature
-
SQL Server 2012 Guide
SQL Server 2012 Guide
-
Take BI up a notch with SQL Azure Reporting
Microsoft’s cloud-based SQL Azure Reporting lets companies publish and view reports without having to maintain hardware. Get an overview of the service, now in a community technology preview. Feature
- See more Essential Knowledge on Data Visualization Techniques for SQL Server
-
Microsoft unveils GeoFlow 3-D SQL Server mapping tool
Microsoft GeoFlow gives premium Excel users the ability to do 3-D mapping with SQL Server on the back end. News | 15 Apr 2013
-
SQL Server 2012, cloud, ‘big data’ driving momentum in 2012
With SQL Server 2012 coming out and the growing influence of the SQL Azure cloud and “big data,” the SQL Server landscape could see some major changes in the coming months. News | 13 Feb 2012
-
Data visualization platform reduces BI complexity -- but at a cost
Tableau Software’s lightweight business intelligence platform makes creating compelling data visualizations a breeze, but it lacks some important features. News | 22 Jul 2010
-
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. SQL Server BI
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
-
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. Tip
- See more Tips on Data Visualization Techniques for SQL Server
-
Microsoft PowerPivot
PowerPivot is a free Microsoft Excel tool that increases the capabilities of Excel's pre-existing pivot table tool by allowing users to import data from multiple sources. Definition
-
spatial data
Spatial data, also known as geospatial data, is information about a physical object that can be represented by numerical values in a geographic coordinate system. Definition
-
Microsoft GeoFlow
Microsoft GeoFlow is a three-dimensional data visualization mapping tool for Microsoft Excel. Definition
-
database
A database is a collection of information that is organized so that it can easily be accessed, managed, and updated. In one view, databases can be classified according to types of content: bibliographic, full-text, numeric, and images. (Continued...... Definition
-
SQL business intelligence takes forefront at PASS events
The Professional Association for SQL Server (PASS) will hold two SQL business intelligence events in the coming months. BI is big for SQL Server pros. Podcast
-
Customers react to Microsoft SQL Server preview
Microsoft previewed some of the features of its next SQL Server release, code-named Denali, at the PASS Summit 2010. SearchSQLServer.com got reaction from attendees. Video
-
Maximizing the benefits of Excel add-ins: PowerPivot and Power View
This guide explores the capabilities of the Excel plug-ins PowerPivot and Power View, offering tips for accessing valuable business intelligence data. Essential Guide
-
Reporting Services architecture: Creating high-quality reports
In this book excerpt, author and Microsoft SQL Server Reporting Services expert Brian Larson introduces features of Reporting Services. Book excerpt
-
Interactive reports highlight Microsoft SQL Server Reporting Services
Author and Reporting Services expert Brian Larson discusses features of SQL Server Reporting Services in this interview. Q&A;
-
Microsoft PowerPivot
PowerPivot is a free Microsoft Excel tool that increases the capabilities of Excel's pre-existing pivot table tool by allowing users to import data from multiple sources. Definition
-
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. SQL Server BI
-
SQL business intelligence takes forefront at PASS events
The Professional Association for SQL Server (PASS) will hold two SQL business intelligence events in the coming months. BI is big for SQL Server pros. Podcast
-
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. Tip
-
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. Tip
-
Q&A;: Authors discuss the advantages of Microsoft Power View
In this interview, the authors of a how-to book on Power View discuss the advantages for both business and IT. Feature
-
Get going with Microsoft Power View and SharePoint
In this book excerpt, the authors explain Microsoft SQL Server Analysis Services and how to get started with Power View. Book excerpt
- See more All on Data Visualization Techniques for SQL Server
About Data Visualization Techniques for SQL Server
Data visualization is a key aspect of business intelligence, as the proper use of data visualization techniques and tools is the best way to make reports more useful and effective. Microsoft has created many data visualization features for SQL Server – particularly in the latest versions of the company's Report Builder utility. Our data visualization topic page provides resources and tutorials for using data visualization solutions in SQL Server environments. Here you'll find detailed information on working with the various editions of Report Builder for SQL Server (most recently Report Builder 3.0), with how-tos for implementing data visualization techniques into SSRS reports.