June 2010 - Posts

• July 8th, 2010, 6:30 PM - 8:00 PM

  Jessica M. Moss presents MDX: From WITH To WHERE! When: July 8th, 2010, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM!   Who:  Jessica M. Moss   Jessica M. Moss, an architect with Ironworks Consulting and a Microsoft SQL Server MVP, is a well-known practitioner, author, and speaker in Microsoft SQL Server business intelligence.  Jessica has created numerous data warehousing solutions for companies in the retail, internet, health services, finance, and energy industries and authored technical content for multiple magazines, websites, and the book "Microsoft SQL Server 2008 Integration Services Problem- Design-Solution".  Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences.  You can read about her work on her blog, http://www.jessicammoss.com. What:  MDX: From WITH To WHERE SQL Server Analysis Services provides a quick and easy queryable structure for your data warehouse.  You can use Analysis Services's querying language, MDX (multi-dimensional BLOCKED EXPRESSION, to retrieve data for reports, ad-hoc analysis, and dashboards!  This session will discuss the basic syntax, query-scoped calculated measures, and common functions that can be used in MDX queries.   Where:  Location: Markel Plaza 4600 Cox Road Glen Allen, VA 23060 [map] Register: Click here to register! This Months Sponsor:   Posted Jun 24 2010, 04:48 PM by fibrock with no comments

• June 10th, 2010, 6:30 PM - 8:00 PM

  Bob Lambert presents Normalize Metadata for Data Integration Analysis! When: June 10th, 2010, 6:30 PM - 8:00 PM Social Time starts at 6:00 PM!   Who:  Bob Lambert Bob Lambert, a consultant with CapTech Ventures, specializes in data management, business intelligence strategy, and system architecture. His interests encompass how IT and business get together to build and maintain business value, especially with databases and data warehousing. Recent projects have focused on real estate, health care, and financial services. Bob has authored a number of articles, most recently publications at Dr Dobbs and Information Management. What:  Normalize Metadata for Data Integration Analysis Many of today’s business applications feature dozens of interfaces feeding a central database. Interface source-to-target mapping is now common practice, but if there are many interfaces how do you make sure the work of separate teams on tight timelines dovetails smoothly and avoids the all too common death march of correction and rework? This presentation shows how normalized metadata can help coordinate team efforts, recording data requirements, the target data model, interface sources, source to target mappings, and relationships among analysis components, and enable an effective division of labor that promotes team efficiency, improves planning, and provides the best possible product for developers and testers. Where:  Location: Markel Plaza 4600 Cox Road Glen Allen, VA 23060 [map] Register: Click here to register! This Months Sponsor: Posted Jun 17 2010, 04:59 AM by fibrock with no comments