Below are shortcuts and needed utils for BI and .net developer
Last Updated: May 02, 2012
Sreedhar Vankayala
Windows Shortcuts
- To launch SQL BIDS ... Window + R (run) ... deveenv
- File/Folder Properties ... Select file/folder and double click with mouse
- To launch SQL Management Studio 2005 ... Window + R (run) ... sqlwb
- To launch SQL Management Studio 2008 ... Window + R (run) ... ssms
- To start/stop the sql server using cmd: net start/stop mssqlserver
Database Modelling
- Typically used data modellers: Erwin ( http://erwin.com/ ), ER Studio ( http://www.embarcadero.com/products/er-studio), Toad ( http://www.quest.com/toad-data-modeler/)
Utils
- Microsoft System Internals: http://technet.microsoft.com/en-us/sysinternals/default
- Unix Utils for Windows: http://unxutils.sourceforge.net/
- WinMerge (open source) good for comparing. Download the add on to compare excel files
- NotePad++, Textpad - Good for text editing
Videos about learning Microsoft BI
- SQL Down Under (Podcast/Audio Show)
In my experience, I have not come across any other products (Non-Microsoft) having as good documentation as that of Microsoft BI (SQL Server BI) on SQL Server Books Online. Also, the support offered by Microsoft and the community through msdn forums is excellent.
SQL Utils
SSAS Tools
SQL Utils
SSAS Tools
What
frontend people are using for SSAS database?
Microsoft
Excel
Microsoft
Reporting Services
ProClarity
In
house build Software
Panorama
Novaview
SoftPro
CubePlayer
Business
Objects - Voyager
Strategy
Companion Analyzer
Pivotview
OLAP client
Intelligencia
Olap Controls
Cubeslice
Dundas
Controls
Radsoft
Cognos
Powerplay ...
Book: Delivering
Business Intelligence with Microsoft SQL Server 2005
Book: Microsoft DW in depth (bind given by Kimball group for VCH)
Kimball group
consulting / Kimball University (course material)
