Data Visualization Techniques for SQL Server

Data Visualization Techniques for SQL Server Get Started

Bring yourself up to speed with our introductory content

• 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.   Continue Reading

• 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. Continue Reading

• 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. Continue Reading

Evaluate Data Visualization Techniques for SQL Server Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

• Guide to SQL business intelligence, analytics and data visualization

  This Essential Guide offers a closer look at SQL Server business intelligence features and tools that enable users to view, share and analyze data. Continue Reading

• 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

• 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. Continue Reading

Product Reviews

• Parallel Data Warehouse (PDW) POC – lessons learned

  Powered by IT Central Station

  The first version of Microsoft’s Parallel Data Warehouse is out for a while, now I had the chance to get my hands on it during a customer POC....Continue Reading

  Rating:

• 100,000x faster: gnarly queries reduced from 22 hours to 800 milliseconds

  Powered by IT Central Station

  Part I: The Pilot A/B testing is part of our company’s DNA; we test every change to our platform and games. When we were small, this was easy,...Continue Reading

  Rating:

• Vertica allows for thousands of users to run an analysis at the same time. Great aggressive compression.

  Powered by IT Central Station

  At the tech company I work , we were looking for new ways to allow end users (a couple of thousand external users)  to crunch through their...Continue Reading

  Rating:

Manage Data Visualization Techniques for SQL Server

Learn to apply best practices and optimize your operations.

• 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. Continue Reading

• 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. 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