Category Archives: Data Mining

Business Intelligence

Business intelligence solves the gap between IT and Business needs or top Management, How? Most of us think in technology and how to use it without thinking how to satisfy business needs with this technology this is main gap between top management and IT, so from long time ago big Software development companies start to focus on this gap by developing, enhancing or improving tools used for these needs as they know that BI applications will become the first technology in market trend as Gartner said in January 2008.

Business users see Business Intelligence through Static reports, Analytical Reports and Scorecards which can gathered in one place named dashboard to simplified decision support. If user want more than decision support let’s add data mining component to be decision making.

So how Microsoft technologies support business intelligence


Figure 1

as you can see in figure 1 from down to top

1. Start Extract Data From Heterogeneous data sources using Microsoft SQL Server Integration Service to data warehouse

2. You can build OLAP Database(Cubes) over data warehouse using Microsoft SQL Server Analysis Service

3. You can build simple reports over Data warehouse directly or over Cubes using Microsoft SQL Server Reporting Service to display report to end users

4. You can use Excel to display Data from Data warehouse or from cubes which you can then apply Pivot Tables, Pivot Charts and others

5. You can build Dashboard that includes many types of advanced reporting components like Scorecards, Analytical Reports, Strategic reports…etc using Microsoft Office Performance Point Server 2007

6. You can build also Dashboard using Microsoft Office SharePoint Server to display inside it web parts from Excels, or Performance Point Items or reporting service.

This is the simple story about BI Platform using Microsoft Technologies

You should also know that data mining is part from Microsoft Analysis Service and you can use it simply as business users from Microsoft Excel .


Tags: , , , , , , , , , , , , , ,

SQL Server 2008 Compare Edition Features

to find full comparison of key capabilities between SQL Server 2008 Enterprise, Standard, Workgroup, Web and Express editions

Just click on Microsoft


Tags: , , , ,

Be Ready for Microsoft SQL Server 2008 R2

to get more information about Microsoft SQLServer 2008 R2 you can visit SQLServer2008 R2


Tags: , , , , ,

SQLHero June Session – Microsoft Egypt

SQLHero delivered June Session in Business Intelligence Scenarios (SQL 2008)

Topic Business Intelligence Scenarios (SQL 2008)
Date June 4, 2009
Time 10:00 – 3:00
Location Microsoft, Smart Village
Presenter Ahmed Mosa
Presentation download


Tags: , , ,

Virtual Labs

you can now test SQL Server 2008 new features through virtual labs on line in Business intelligence, Data warehousing, OLTP and Application Deployments

believe me really useful


Tags: , , , ,

%d bloggers like this: