Welcome to Lightside
- Architecture with Vision
Data warehouse and business intelligence architectures that... |
· |
leverage existing technology investment |
· |
scale vertically and horizontally to maintain performance as loads increase |
· |
can be extended to meet changing business needs |
· |
use the right tool for the job - one size doesn’t fit all |
Result: The best price-performance ratio and a roadmap for growth. |
|
- Execution with Agility
· |
an iterative methodology with immediate, tangible results |
· |
end-to-end expertise, from source data to front-end tools |
· |
effective management of people, technology, and projects |
Result: Complex projects that are on time, on budget, and meet business objectives. |
|
- Implementation with Impact
· |
systems that people enjoy using every day to make better decisions |
· |
transforming labor-intensive data gathering and reporting into “insight at your fingertips” |
· |
looking forward instead of only being able to look backward |
Result: Powerful and useful decision support. |
|
Recent Engagements
- Retail: 9 TB analysis system
· |
replaced underperforming system with hybrid SMP/MPP architecture, increased performance 12x, doubled warehouse size to 3 billion fact rows |
· |
new architecture supports 15x more concurrent users |
· |
new architecture saved over $1.5 million |
Result: Reduced out-of-stocks, reduced customer migration and defection. System paid for itself in under a year. |
Tools: Custom ETL, Netezza, MicroStrategy |
|
- Competitive intelligence: 10 TB clickstream analysis system
· |
prototyped DW/BI system in 90 days using open source tools |
· |
parallelized ETL to load millions of rows within short windows |
· |
analytic and marketing products for automotive, financial services, travel, and wireless industries |
· |
advanced predictive analytics with behavioral targeting |
Result: Competitive advantage on demand for Fortune 50 clients. |
Tools: Custom Java ETL, MySQL, Oracle, Java (J2EE) UI |
|
- CPG: analysis and forecasting system
· |
conformed complex dimensions merging multiple sources including sales, marketing, budgeting, demographics, surveys, and competitor data |
· |
high-performing cubes for forecasting, time series, product lifecycle analysis, price elasticity modeling, and trade flow analysis |
· |
automated processes saved weeks of manual effort |
Result: Breadth, depth, and power unique in the industry. |
Tools: Custom preprocessing, ETI, SAP BW, Oracle, Cognos |
|
- Insurance: enterprise data warehouse
· |
merged 40+ data marts into one authoritative, reportable warehouse |
· |
advanced data profiling improved data quality |
· |
MPP system improved performance and increased the number of supported users |
Result: Consistent, accurate reporting across the enterprise. |
Tools: Informatica, Teradata, SAS, SAS BI |
|
- Health care: executive information system
· |
dashboards, deployed over the web and Blackberries |
· |
drill down and through to get the right information |
· |
advanced pattern-of-care, revenue management, and compliance metrics |
Result: Better patient care and higher reimbursement rates. |
Tools: DTS, SQL Server, MS Analysis and Reporting Services, C# |
|
- Biopharmaceutical: enterprise reporting system
· |
extended existing warehouses to resolve complex financial and accounting issues |
· |
agile development produced results in weeks, not months |
· |
innovative architecure leveraged existing “spread-marts” |
Result: Consistent, accurate, enterprise-wide reporting. |
Tools: Informatica, Oracle Financials, Hyperion, Business Objects |
|
|