Home Core Expertise

Spotlight Module Content with Image

 

Newsflash 4

Knowledgy Solutions of Atlanta, Ga opens offices in New York!

 

Predictive Analysis with SQL Server 2008

Predictive Analysis with SQL Server 2008I've always found predictive analysis and data mining to be interesting and fun. I feel like a child walking through a cave amazed at the disoveries they are finding. So I couldn't wait to play around with the new predictive analysis tools in SQL Server 2008 Analysis Services. SSAS provides a complete data mining platform that is easy and fun to use. Organizations can use SSAS to infuse insight and prediction into everyday business decisions. The 2007 Office system uses Pervasive delivery through the Data Mining Add-Ins. These tools are a blast to use and will help you uncover knowledge hidden in your data. The comprehensive development environment and extensible range of innovative data mining algorithms combined with the enterprise-level scalability and manageability of SQL Server Analysis Services makes SQL Server 2008 an ideal and easy way to bring the benefits of predictive analysis to your enterprise. The predictive analysis capabilities of MSSQL 2008 makes it easy to incorporate intelligence into reporting, data integration, OLAP analysis, and business performance monitoring. It will help your business drive increased business agility, create a tangible competitive advantage and bottom line, grow revenues. The ability to extend the data mining technologies of SQL Server through custom algorithms and visualizations, together with the ability to embed predictive functionality into line-of-business applications makes SQL Server 2008 a powerful platform for introducing predictive analysis into existing business processes to add insight and recommendations into every operation.

 

Per-Se Technologies

DBA / Database DeveloperPer-Se Technologies (formerly Medaphis Corporation)Aug 1998 - Sept 2000DBA providing administration and security services, SQL, T-SQL and PL/SQL development, complex query development, performance analysis and SQL optimization for over 100 Oracle and SQL Server database instances reporting and ad hoc querying.
Ulti Clocks content
PDF Print E-mail

Decision Support Databases

Microsoft SQL Server 6.5-2008 (Beta) - Oracle 7–11g (Since 1999) - Microsoft Analysis Services - DB2 - Teradata - MySQL 

Extract Transform and Load Expertise (ETL)

SSIS - DTS - Sagent - Oracle Warehouse Builder - Informatica

Methodologies

OLTP / OLAP / MOLAP - Access - Warehouse - Relational - Object Oriented - GIS - Network - File - Entity Relationship (ER) - IE/IEE - IDEF1X - Dimensional - Data Flow - Function - Event - Object Role - Process - Structure - State Transition and Systems Modeling - UML - BPM - CASE - Function Hierarchies - Contextual Modeling - Fact/Qualifier Matrix

Languages/Interfaces

ANSI SQL - Transact-SQL(T-SQL) - PL/SQL - MDX - .NET Framework 1.0 - .NET Framework 2.0 - .NET Framework 3.5 - Embedded SQL - SQL-DMO - Active Server Pages (ASP) - VBScript - ActiveX - OLE and OLE Objects - OLE DB - Active Data Objects (ADO) - Remote Data Objects (RDO) - Data Access Objects (DAO) - VB.NET - XML - COM/COM+ - JDBC - ODBC - Python - Java - JavaScript - OLE - Cold Fusion - HTML XBRL - PERL - X-Query - SQL-DMO - SMO

Microsoft Specific Tool

SQL Server 6.5-2008 - SQL Server 2005 Information Services (SSIS) - SQL Server Studio Manager - SQL Server Enterprise Manager - BizTalk Server - Analysis Services - Data Transformation Services (DTS) - Notification Services - Visio - Query Analyzer - Reporting Services - Data Analyzer - Visual Studio .NET 2005 - Service Broker - Visual SourceSafe - Profiler 

Oracle Specific Tools

Oracle 7–11g - SQL+ - Procedure Builder - App Development - Database Admin - Enterprise Manager - Extended Administration - Migration - Network Admin - Data Mart Suite - Designer - Forms - Discoverer - Reports - Developer.

Other Tools

TOAD - Sagent - Computer Associates ERWin - Business Objects - Crystal Reports - Embarcadero - Red Gate - Apex SQL - Quest Central - Spotlight - WinSQL - UltraEdit - Informatica - Active Reports - Performance Monitor - Actuate - J Developer - Excel - Report Writer - Data Junction - OR Express - Crystal Reports - Rational Rose - Cognos - Ab Initio - Brio

Servers/Environments

NET Enterprise Edition - MS Internet Database Connector (IDC) - MS Internet Information Server (IIS) - All Windows O/S’s - AIX - HP-UX Sun UNIX O/S’s - Linux - FreeBSD - PalmOS - Windows CE