+61386585993
sales@bilytica.com
Contact
Facebook
Twitter
Google+
LinkedIn
bilytica-logo
  • Capabilities
    • Strategy
      • Competitive Intelligence
      • Marketing Analytics
      • Sales Analytics
      • Data Monetization
      • Predictive Analytics
      • Human Resources Analytics
    • Planning
      • Assessment Services
      • Roadmaps Services
      • Data Governance
      • Strategy & Architecture
      • Organization Planning
      • Proof of Value Services
    • Analytics
      • Data Visualization Services
      • Big Data Analytics Solutions
      • Machine Learning
      • BI Reporting Dashboards
      • Advanced Analytics & Data Science
      • CRM / Salesforce Analytics
    • Data
      • Big Data Architecture
      • Lean Analytics
      • Enterprise Data Warehousing
      • Master Data Management
      • System Optimization
    • Outsourcing
      • Software Development
      • Magento Ecommerce Services
      • Managed Services
      • On-Shore / Off Shore
      • Cloud Services
      • Recruiting & Staffing
      • Get more services..
  • Solutions
    • Business Solutions
      • Increase Speed to Market
      • Increase Profit & Revenue
      • Lower Costs
      • Increase Market Share
      • Add Products & Services
    • Industries
      • Pharma Analytics
      • BI Services
      • Retail Analytics
      • Education Analytics
      • Oil and Gas Analytics
      • Manufacturing Analytics
      • Get more…
    • Departments
      • Customer Analysis
      • Market Research
      • Web Analytics
      • Social Media & Text Analytics
      • Pricing & Sales Analytics
      • Customer Analytics
      • Fraud & Risk
      • Operations
      • Get more..
    • Approach
      • Big Data Benchmarks
      • Big Data Framework
      • Strategic Discovery
      • Big Data Approach
  • Products
    • PeopleQlik (HRMS Software)
    • CloudPital (EMR Software)
    • ChecPOS (Point of Sale Solutions)
    • Erpisto (ERP Solutions)
    • CampusQlik (School ERP)
    • Appsout (App Development)
    • Techlopes (Magento Development)
    • InsureQlik (Insurance ERP)
  • Center of Excellence
    • SAP
    • Cognos
    • Oracle
    • Microsoft
    • Tableau
    • MicroStrategy
    • QlikView
  • Training
  • Contact Us
  • Blog

Advanced Dimensional Modeling: Techniques for Practitioners

Real-world designs rarely resemble the simple star schemas found in product demos or introductory courses—a single fact table, fully additive facts, and several standard dimension tables.

This course takes you beyond fundamental principles of dimensional design, providing an extended set of techniques to address real-world complexity.

The course begins with a brief review of the core concepts of dimensional modeling. These fundamentals are then built upon in four areas: multi-star designs, alternative fact table designs, dimensional intricacy, and scaling.

This comprehensive treatment provides the breadth and depth you will need to meet your information design challenges—whether you are building a dimensional data warehouse, a Corporate Information Factory, standalone data marts, or virtual solutions.

You Will Learn

  • Why most subject areas require multiple fact tables, and how to identify them
  • When to use alternatives to the basic transaction fact table, including periodic snapshots, accumulating snapshots, and type-specific stars
  • How to cope with dimensional intricacy, using techniques such as bridge tables, mini-dimensions, time-stamped dimensions, hybrid slow changes, and other slow change options
  • Techniques to ensure your data warehouse will scale as new subject areas are added

Geared To

Geared toward professionals who need a comprehensive understanding of star schema design.

  • BI program managers
  • Business analysts
  • Data architects and modelers
  • BI architects and developers
  • Data integration architects and developers
  • Project managers
  • Database administrators
  • Power users and Business subject matter experts

Technical resources.

Harnessing the power of Bilytica Consulting Services

Seeing and Understanding your data is the key to competitive advantage in this era. See why Industry Leaders Trust Bilytica consulting solutions.

Download Presentation

Best practices for adopting secure, governed self-service analytics

Find out how Bilytica advanced analytics allows business users and IT to transform the way they used to see their valuable information.

Download White Paper

Industry Leaders Trust Bilytica

         
         
         
         
         
           

Put the most powerful analytics platform to work for your business.

CONTACT US
Contact Us

About Bilytica

We work with our clients in improving business performance, increasing profitability to reducing costs and making better use of people and resources. Since 2007, Bilytica and its brilliant team are connecting people, data and advanced analytics together.

Facebook
Twitter
Google+
LinkedIn

Analytics

  • Banking Analytics
  • CPG Analytics
  • Retail Analytics
  • Pharma Analytics
  • Insurance Analytics
  • Oil & Gas Analytics
  • Manufacturing Analytics

Data

  • Data Visualization
  • Data Analytics
  • Machine Learning
  • BI Reporting Dashboards
  • Data Warehousing
  • Competitive Intelligence

Excellence

  • SAP
  • Cognos
  • Oracle
  • Microsoft
  • Tableau
  • Microstrategy
  • QlikView

Contact Sales

WhatsApp us