Tue, Oct 20 2009

Audaxx attends the TDWI Seminar in Vancouver: Data Warehousing Architectures - Choosing the Right Data Warehousing Approach 


WHO WE ARE

Martina Ponca is an IT professional and consultant working under the Audaxx Consulting Inc. umbrella in Vancouver, BC, Canada. She’s a team player and can take a role of developer, trainer or business analyst.

WHAT WE DO

My primary focus is to work with clients in need of a data warehouse, business intelligence solution or reporting solution that would allow them to make fact-based decisions using their existing data or help clients assemble new data. I specialize in development of solutions around Microsoft SQL Server (2000/2005/2008) – RDBMS, Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS). This means the development of any or all of the layers of a business intelligence (BI) stack:

Business Intelligence Stack Development

Data Layer
  • The bottom layer is the Data Foundation for a BI solution.
  • The data is stored in databases (DBMS) like Microsoft SQL Server, Oracle, etc. or data sources like Microsoft Office Excel, CSV or XML files.
  • The data can be part of CRM or ERP systems.
Discovery and Integration Layer
  • This layer might require data cleansing,
  • Integration with 3rd party applications (ERP, CRM, etc.),
  • ETL (Extract, Load, Transform data) to create operational data stores (ODS), data warehouses (DW) and data marts (DM).
Data Analytics Layer
  • Includes time calculations, OLAP, data/text mining, predictive analytics, statistical analysis, formulation of KPIs and other required metrics.
Presentation Layer
  • Creating user friendly reports (ad-hoc, analytical, production).
  • Decisions related to data visualization (for example Dundas Dashboards).
  • Development of dashboards, scorecards, alerts based on metrics defined earlier.
Delivery Layer
  • Reporting and dashboarding tools might have to be delivered to internal websites, portals like SharePoint or mobile devices.
  • Decisions around user access and security.
Support Layer
  • All the layers above should be supported by life-cycle management tools like collaboration tools, version control, QA, metadata repositories, document repositories (requirements, data mapping, process documentation), training sites, knowledge base sites, and others.