BI Beginner: Data Explorer is a must have

Data Explorer will speed up and simplify your data analysis by at least an order of magnitude. It makes data just work for me. No fighting or struggling, it just works. Step 1. Go here and download the Data Explorer Preview for Excel 2013 or Excel 2010. Step 2. Install Data Explorer. Step 3. Start Excel. Don’t hold back, go all out and Enable Advanced Query Editing . Figure 1. Check Enable Advanced Query Editing . Step 4. Open a workbook. Step 5. Click DATA EXPLORER . Figure 2. New DATA EXPLORER…(read more)

Summary: Go here and download the Data Explorer Preview for Excel 2013 or Excel 2010.

…When you do a mouseover on any of your search results, the Preview tab shows you what the data will look like when pulled into Excel.

…Once Data Explorer was added to Excel, it took me much less than 2 minutes to search for my data, preview it, select it, import it, and then examine it further with the Navigator.

…John Paul Cook is both a Registered Nurse and a Microsoft SQL Server MVP experienced in Microsoft SQL Server and Oracle database application design, development, and implementation. … Experienced in systems integration and workflow analysis, John is passionate about combining his IT experience with his nursing background to solve difficult problems in healthcare.
read more