For many Database Administrators, Data Analysts and other IT and Business Professionals, Business Intelligence (BI) and Data Warehousing (DW) may be a new and uncharted territory with no clear path towards the destination. Others, who have already jumped head-on into the Business Intelligence journey, may be facing challenges that can potentially put their efforts at the risk of failure. For this reason I put together a presentation titled Business Intelligence: Decaffeinated Please!
In this presentation I cover terms and acronyms associated with Business Intelligence and Data Warehousing. I make a differentiation of what Business Intelligence is and what it is not. I also go over my “10 Rules of Wisdom” towards BI success based on lessons learned from personal experience as well as from insight gained from leading authors and speakers in the BI universe. The purpose of my 10 Rules of Wisdom is to serve as a guideline for anyone involved in a BI initiaive or in its planning stages.
My “10 Rules of Wisdom” for Business Intelligence Success are listed below:
- The Business Intelligence solution needs strong executive management support. Keyword: Sponsor
- The Business Intelligence solution must add value to the organization and be trustworthy.
- Always have a Business Intelligence roadmap in clear view.
- Define iterative success criteria.
- Choose the right technology based on your business and user needs.
- The BI solution needs to be understandable and documented.
- The BI solution needs to be accessible.
- The BI solution must be able to grow according to the business needs.
- The BI solution needs to adapt to new business analysis needs.
- Partner with experts in the field to help you achieve your goals.
These and other topics can be found on my PowerPoint presentation below which I continuosly enhance for my presentations for SQL Saturdays and User Groups.
(click on image to download)
Filed under: Business Intelligence, Data Warehouse, SQLServerPedia Syndication | Tagged: #sqlserver, 2005, 2008, analysis services, business intelligence, data warehouse, dba, ETL, extract, mdx, session, SQL, sqlpass, ssas, SSIS, transform, variance |
SQL Joe's Blog 
[…] This post was mentioned on Twitter by ferox and Jose Chinchilla, Jose Chinchilla. Jose Chinchilla said: Blog: Business Intelligence: Decaffeinated Please! http://bit.ly/cJSIQV with PowerPoint download […]
Great Points Joe.
We are launching our first true BI solution tomorrow using Excel and PowePivot as front end. We have 4 main facts for this launch all with measures required by the business owners. They can be sliced by 28 different dimensions. It was a great effort as all the ETL is done within SSIS, shoving in 30 million rows in 2 hours.