Excel

Excel

From Business Intelligence

Jump to: navigation, search

[edit] Excel Tips and Tricks

Embedding Data Warehouse Queries into your workbooks Tired of having to run a Business Objects query first, then having to cut and paste it into Excel and then apply formulas, or macros to get the format and data just right to do the actual work you need to do? There are many instance where you can easily write that Business Objects query directly in Excel

  • Learn how to use Excel MS Query
  • Learn how to link to web based data sources Excel Web Data Sources
  • User generated list of useful formulas
  • Juice Analytics' Data Transform Present (DTP) framework for structuring Excel workbooks. This is a method for structuring workbooks similar to the Model-View-Controller (MVC) pattern in software development.

[edit] Useful Excel Add-Ins

  • Data Mining Addin using Cloudcomputing (e.g. you are not required to have Reporting Services Installed - Which you alsmost certianly do not have)
  • Web Data Add-In makes it easy to use a Web page as a data source in Excel
  • Chart Tamer helps you design better charts be removing clutter from charts and focusing only on the charts that have been identified as the most useful in conveying information
  • Treemapper Add-in from MS Research. Learn more about Tree Maps at ManyEyes.
  • Tiny Maps is an open source add-in for Excel that creates sparklines, mini column graphs, and area graphs from a row of data. It generates beautiful tiny graphics that are as small as a cell and is useful for visualizing large quantities of data, such as stock prices and exchange rates.
  • Scatter Plot (XY Chart) Data Point Labler
  • Link Analysis with NodeXL in Excel 2007. NodeXL is an add-in for Office 2007 that provides social network diagram and analysis tools in the context of a spreadsheet. Additional examples of how to use this Add-In are available here
  • QI Macros - an excel add-on that helps create a variety of process and statistical analysis charts like Control Charts, Pareto Charts, Histograms, Box-and-whisker plots, Frequency plots and much, much more. (A purchase is required for this add-on.)
  • Sparklines for Excel is a free add-in for creating micrographs.
  • BonaVista Systems Microcharts is a commercial add-in for creating microcharts.
  • BonaVista Systems Chart Tamer is a commercial add-in for making more effective charts using Excel. It was developed with input from data visualization expert Stephen Few.
Retrieved from "http://webservices.itcs.umich.edu/mediawiki/Business Intelligence/index.php/Excel"