Home
Microsoft PowerPivot

Microsoft PowerPivot

Editors' Picks

Businesses set self-service BI as a priority for 2013

Mainstay issues such as poor data quality will plague businesses in 2013, but one way they're hoping to overcome hurdles is by empowering users.21 Dec 2012
SQL Server 2012 Power View: Self-service BI reporting for SharePoint

The SQL Server Power View tool enables solution providers to deliver self-service business intelligence reporting to a wide range of customers.20 Dec 2012
Map data flow from Microsoft PowerPivot to Excel, SharePoint

Microsoft PowerPivot, when used with Excel and SharePoint, lets business users manipulate data in Excel workbooks. But how do PowerPivot components fit into those environments?03 Feb 2012
Sound policy key to data quality management in Microsoft PowerPivot

Microsoft PowerPivot lets users do data analysis without IT’s help, but too much access can pose serious data quality management issues.23 Aug 2011
Putting the data to work: How to create a chart in PowerPivot

Importing Microsoft SQL Server data into PowerPivot is the first step; now you’re ready to do some reporting. Get instructions on how to populate and refine charts in PowerPivot.31 May 2011
Importing SQL Server data into PowerPivot for Excel

Microsoft PowerPivot is designed to give BI capabilities to users who lack IT’s technical know-how. The first step is importing SQL Server data, and you have to know your options.21 May 2011

More Like This

Texas utility deploys operational intelligence, improves 'on-boarding'

TXU Energy applied Vitria operational intelligence software to gain a better customer view. Careful processes selection ensured quick performance.12 Jun 2013
Match in-memory processing speed to big data analytics business need

Michael Minelli, co-author of a book on big data analytics, says in-memory analytics tools must be tied to business processes to pay off for users.24 May 2013
Eckerson: Self-service business intelligence not a give-and-go affair

In an interview, TechTarget's Wayne Eckerson explains why there's more to self-service BI success than putting tools in the hands of business users.30 Apr 2013
In-memory technology pushes analytics boundaries, boosts BI speeds

In-memory appliances amp up business intelligence performance by moving processing off of disks. But cost and other issues need to be considered.22 Apr 2013
Analytical modeling is both science and art

Models are the key to predicting outcomes to business decisions. And while math may make them tick, it also takes a certain eye -- and ear -- for what works.22 Apr 2013
Big data analytics firm offers insights into the U.S. Latino consumer

Luminar's Franklin Rios explains how his company is using Hortonworks' Hadoop distribution to deliver insights about the Latino community.22 Apr 2013
Seeking treasure from social media tracking? Follow the customer

Social media analytics tools can help companies dig into layers of online customer data in search of business gold. But a human touch is needed, too.16 Apr 2013
Business intelligence program needs long-term tending to fully blossom

The evolution of Quicken Loans' business intelligence strategy from static reporting to self-service BI holds useful lessons for other organizations.28 Mar 2013
Visual Discovery Tools: Market Segmentation and Product Positioning

This report explores the market for in-memory visualization tools, which provide speed-of-thought analysis to power users and interactive departmental dashboards to casual users. Visual discovery t...07 Mar 2013
Experts debate big data vs. SQL development

Traditional SQL databases may have lost mindshare with some app developers, but they're still the right choice for most projects, says one expert.20 Mar 2013
Microsoft BI pro demonstrates PowerPivot for Excel

Michael Tejedor, a senior product manager with the Microsoft’s business intelligence (BI) group, demonstrates the self-service BI capabilities of PowerPivot.06 Oct 2010
Mobile business intelligence applications: Not just a pretty interface

Back-end factors such as network performance and server hardware are key elements of building an effective mobile business intelligence architecture.08 Mar 2013
BI leaders need more than just technology

It takes something other than fancy tools to lead in the business intelligence arena, says TechTarget's Wayne Eckerson, pointing to the ability to direct a diverse team.19 Feb 2013
Data scientist role requires predictive analysis, expert says

Forrester's Mike Gualtieri explains how data scientists' knowledge of predictive analytics can help firms reduce risk.11 Feb 2013

More from Related TechTarget Sites

Data Management
Data Management UK
Content Management
CRM
Oracle
SAP
SQL Server

Data Management
- Events report: Information Builders Summit 2013, graph databases and more
  
  SearchDataManagement editors discuss the Information Builders user conference and two other events; topics include graph databases and 'data artists.'
- From 4GLs to HTML5 desktop apps: Bringing data to the masses
  
  Advocating wider access to data, speakers at the Information Builders Summit 2013 traced a journey from 4GL tools to HTML5 desktop apps and beyond.
- Enterprise data quality efforts in good company with MDM, governance
  
  Combining data quality initiatives with master data management and data governance programs can help ensure that data remains accurate and consistent.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Content Management
- Records management program aims to restore order to SharePoint system
  
  Mobile network operator Telenor Group is adopting information governance and records management standards to better control internal SharePoint use.
- Cloud collaboration software connects at networking company Enterasys
  
  Enterasys Networks ended up with more users than expected when it deployed a cloud-based collaboration system. But that turned out to be a good thing.
- Data value chain puts the focus on what matters most to a business
  
  In his career running data management systems for consumer goods companies, Richard Beaver has found a formula for success: the data value chain.
CRM
- The Salesforce acquisition of ExactTarget: What to expect now
  
  Salesforce's acquisition of digital marketing software firm ExactTarget is virtually a done deal. Find out what customers can expect for the future.
- CRM trends: Customer engagement, free range agents and more
  
  Fresh from the ACCE conference, Lena J. Weiner reports on multiple exciting trends in CRM, including automated and social CRM.
- Former DJ helps businesses do customer engagement like rock stars
  
  Former Houston DJ Dayna Steele wants you to know that customer engagement has more to do with rock n' roll than you might think.
Oracle
- The future of Dell Toad: Oracle DBAs can use BI, Exadata features
  
  Dell Toad is pushing itself into business intelligence and now has an edition to support Oracle's big Exadata appliance.
- Unlock the potential of the Oracle Exadata architecture
  
  Despite being almost five years old now, many implementations haven't realized all of the Oracle Exadata architecture benefits.
- The state of Dell Toad: Oracle DBAs and how they can still benefit
  
  Since Dell acquired Quest Software, maker of the Toad tool for Oracle databases and applications, some questions have arisen about what would happen.
SAP
- Food bank network delivers with SAP mobility
  
  The nation's largest network of food banks is cutting out labor-intensive paper-bound processes with the help of SAP mobile technology.
- SAP adds hybris to its SAP CRM tool set: More choices, or confusion?
  
  One expert calls SAP's purchase of hybris long overdue. Another wonders if SAP is confusing its own SAP CRM customers.
- Limit returns, SAP procurement expenses with a stability study
  
  Stability studies, which measure how different materials respond to various conditions, can save companies huge amounts of money, writes Jawad Akhtar.
SQL Server
- SQL Server 2014 'keeps up with the Joneses,' says analyst
  
  Ovum analyst Tony Baer says that most database platforms are moving toward in-memory features, and SQL Server 2014 is no different.
- SQL Server high availability: Natural enemy of virtualization?
  
  Do SQL Server high availability and virtualization go together or not? Find out if virtualization is a good option for you in this tip by Bob Sheldon.
- SQL Server 2014 due out in late 2013, in-memory OLTP a big feature
  
  Microsoft announced that the next version of its database, SQL Server 2014, will have in-memory features and be generally available in late 2013.

All Rights Reserved,Copyright 2010 - 2013, TechTarget