Ben
DataBase & Business Intelligence Expert Solution
  Home   Services Forum Jobs References Live demo   Contacts  
Mnaouar Ben Khelifa
Email:
Password:
Remember
Subscribe?     Forgot Password ?
tunis annonces femme cherche
tunis ads weatherReferences
tunis annonces meuble
tunis annonces autotunis annonces chien Sms Equipment
tunis annonces meuble
tunis annonces autotunis annonces chien Patrick Morin
tunis annonces meuble
tunis annonces autotunis annonces chien Via-Rail
tunis annonces meuble
tunis annonces autotunis annonces chien Tree Technologies
tunis annonces meuble
tunis annonces autotunis annonces chien Montreal City
tunis annonces meuble
tunis annonces autotunis annonces chien Komunik
tunis annonces meuble
tunis annonces autotunis annonces chien Cgi
tunis annonces meuble
tunis annonces autotunis annonces chien Technology Evaluation
tunis annonces meuble
tunis annonces autotunis annonces chien Speedware
tunis annonces meuble
tunis annonces autotunis annonces chien Iata
tunis annonces meuble
tunis annonces autotunis annonces chien Canada Direct
tunis annonces meuble
tunis annonces autotunis annonces chien Tradesoft
tunis chat chien
End of Left Navigation
End of Left Navigation
End of Left Navigation
weather montreal
tunis annonces You are here: Home > References > Technology Evaluation >

Data base & business intelligence solution website
Janvier 2006- April 2007
Role: Database + BI Architect/Developer
Company name: TECNOLOGY EVALUATION.

Realization:
1-
o Designing data base diagram (ER) of 4 new projects, including tables, procedures, trigger, view,and functions
o Creation of 16 reports with SSRS
o Creation of 17 packages with SSIS
o Optimizing databases for better performance.
2-
Creation of 2 BI projects using analysis services, Cubes, ETL, Reporting services, excel pivot Table.
The first BI project was for the portfolio of the company.
The second report was for analyzing the IIS logs of 15 web sites


The steps for the BI projects are :
1-Data staging
o Using SSIS to clean and combine data
o Standardize and conform Log files to Database.
2-Data presentation (SSAS)
o Creation of a cube

3-Data access tools
Data mining modeling

Technology used:
o SQL server 2005
o Analysis services (SSAS)
o OLAP
o XML
o Reporting services (SSRS)
o Crystal reports
o Integration services(SSIS)


database solution, BI solution, provide solutions to the most complex database and BI problems

Data base & business intelligence solution website