Data Reflections
Discussions of data warehousing, transformation and analysis by the Business Intelligence Team at Tallan.
Tallan

July 9, 2009

Understanding Metadata Management

Filed under: Analysis Services, Data Modeling, ETL, SQL Server, Uncategorized, Warehousingbgager @ 2:18 pm

Metadata Management- Fun stuff, right?  Depending on what your relationship to an organization’s data is, it can have many different meanings. Database developers and administrators tend to focus on technical metadata, which provides descriptive information on table structures, job streams, ETL mappings, data lineage, etc.

Business users have a need for metadata as well. Attribute definitions, business rules, formulas & calculations, and system definitions provide context to your data and help turn it into real information. Often in the form of a corporate glossary or data dictionary, business metadata can provide clarity to an organization.

One of the challenges of getting your organization to buy in on the need for Metadata Management is that it is often not well understood by business stakeholders. Have you ever been in a meeting that was called because of a dispute over the definition of a business term? Have you ever seen the same field, like “Transactions” for instance, listed on two different reports with different numbers? When business terminology is ambiguous and not well documented, productivity is lost and resources are wasted trying to understand and resolve such discrepancies. It also impacts the trust your people have in your data. And it happens over and over again in the average company. These are Metadata Management issues and they are costing you money.

In an effort to describe how Metadata Management impacts your organization, we have provided some resources that we hope will help. The first is a webinar that I have presented to businesses interested in understanding Metadata Management and some of the options available when implementing a solution. It is available here. This webinar describes the differences between business and technical metadata, outlines its role in the organization, and suggests a framework for creating a metadata repository from the ground up.

We have also posted a case study that explains what can go wrong in an organization that lacks a metadata management strategy. If you are wondering how expensive this oversight can be, the paper describes a project gone wrong because of the lack of available metadata. You may find similarities in your own company.

Half the battle with Metadata Management is in understanding what metadata is and the role it plays in your organization. We hope this content will help with that understanding and get you thinking about how much more efficient you can be with better data management.In future posts, we will get more into the nuts and bolts of implementing a solution.

July 1, 2009

Upcoming MDX and Analysis Services Workshops

Filed under: Analysis ServicesAdam Worobec @ 3:04 pm

In the month of July we’re going to be holding a FREE, half-day, hands-on workshop on MDX and Analysis Services around the country.

If you’re in the Los Angeles, New York City or Hartford, CT areas, come join us. We’ll be deconstructing real-world examples and in the process explaining important things to consider in how Analysis Services handles certain expressions.

Agenda
8:30AM - 9:00AM     Registration & Breakfast
9:00AM - 12:00PM   Hands-On Workshop

Wed. 07/15/2009 - Anaheim, CA -  Click Here to Register
Wed. 07/15/2009 - Burbank, CA - Click Here to Register
Tue. 07/28/2009 - New York, NY - Click Here to Register
Wed. 07/29/2009 - Bloomfield, CT - Click Here to Register

Here are more details about the event:

Tallan and New Horizons are pleased to present a Complimentary Half-Day, Hands-On Workshop: Real-World SQL Server Analysis Services and MDX

Overview of the Workshop
MDX is the universal query language for OLAP databases, just like SQL is the lingua franca of relational databases. While SQL is widely understood and adopted, MDX has more of a steep learning curve and a lack of easy-to-follow resources. 

BI solution developers, report designers and administrators of SQL Server Analysis Services applications have many opportunities to use MDX expressions to enhance the analytic ability of an application.

What better way to master MDX than through hands-on, real world examples?

In this half-day deep dive into MDX and SQL Server Analysis Services, Tallan Senior Consultants will deconstruct a real-world reporting scenario and in the process:

  • Explain how to implement advanced time intelligence
  • Examine OLAP data structures: attributes, levels, hierarchies, dimensions, measures
  • Leverage calculated members to persist calculations within Analysis Services

Audience
This hands-on course is targeted to database developers and architects, Business Intelligence solution developers, report designers and business analysts such as financial planners, marketing analysts, and cost accountants.

The work shop will be held in fully equipped classrooms giving the attendees the opportunity to work through the examples with the instructor.

© 2008 DataReflections.Net  : : : :All rights reserved.  : : : :Tallan, Inc.