+18077009001
sales@bilytica.ca
Contact
Facebook
Twitter
Google+
LinkedIn
Bilytica logo
Menu
  • Oracle
    • Oracle Applications
      • PeopleSoft
      • Hyperion
      • E-Business Suite
      • JD Edwards
      • Siebel
      • Database
    • EPM / BI / Integrations
      • Oracle EPM/ BI
      • Data Integration
      • Oracle Data Integrator
      • GoldenGate
    • Fusion Middleware / Linux / VM
      • Fusion Middleware
      • Oracle ADF
      • Oracle SOA Suite
      • JCAPS Services
      • Oracle Identity Management
      • Oracle WebCenter
      • Oracle BPM Services
      • Oracle Linux Renewal
    • Core Services
      • Oracle Services Excellence
      • Application Management Services
      • Upgrade & Migration Services
      • Architecture & Integration Services
      • Implementation Services
    • Migrations
      • Oracle Forms Migration
      • Stellent to UCM migration
      • SAP to Oracle Migration
      • Microsoft to Oracle Migration
      • Any ERP to Oracle Migration
  • Analytics
    • Strategy
      • Competitive Intelligence
      • Marketing Analytics
      • Sales Reporting & Analytics
      • Data Monetization Services
      • Predictive Analytics Services
      • HR Metrics & Analytics
    • Planning
      • Assessment
      • BI RoadMap Services
      • Strategy & Architecture
      • Data Governance
      • Organization Planning
      • Proof of Value Services
    • Analytics
      • Data Visualization Solutions
      • Big Data Analytics Solutions
      • BI Reporting Dashboards
      • Machine Learning
      • Advanced Analytics & Data Science
      • CRM / Salesforce Analytics
    • Data
      • Big Data Architecture
      • Lean Analytics
      • Enterprise Data Warehousing Services
      • Master Data Management
      • System Optimization
  • Services
    • Outsourcing
      • Software Development Outsourcing
      • Mobile Apps Development
      • Magento E commerce Outsourcing
      • PHP Development Outsourcing
      • Managed Services
      • On-Shore / Off Shore
      • Cloud Services
      • Recruiting & Staffing
    • Center of Excellence
      • Oracle Consulting
      • SAP Consulting
      • Cognos Consulting
      • Microsoft Consutling
      • QlikView Consulting
      • Tableau Consulting
      • Power BI Consulting
    • SharePoint Solutions
      • SharePoint Services Summary
      • Microsoft Dynamics AX 365
      • SharePoint Migration Services
      • Business Data Solutions
      • SharePoint Project Management
      • Document or Asset Management
      • Enterprise Content Management
      • Internet and Intranet sales portals
      • SharePoint Cloud solutions
      • SharePoint Mobility Solutions
      • SharePoint Apps Development
    • Microsoft Services
      • Microsoft Consulting Overview
      • ASP.Net MVC Development Outsourcing
      • Microsoft Power BI Consulting
      • Dynamics AX 365 Consulting
      • Dynamics CRM Consulting
      • Outsourced Development Center
      • Microsoft Licensing Services
  • Verticals
    • Business Solutions
      • Increase Speed to Market
      • Increase Profit & Revenue
      • Lower Costs
      • Increase Market Share
      • Add Products & Services
    • Industries
      • Pharma Analytics
      • Insurance Analytics
      • 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
    • Cloudpital ( Speciality EMR / M Health / Patient Safety )
    • PeopleQlik ( Enterprise HR /Payroll / Performance / Wellness )
    • ChecPOS ( POS / Retail / Restaurants / Quick-Service )
    • TrackQlik ( Field Force Location Intelligence )
    • Erpisto ( 40+ Vertical Ready ERP Solutions )
    • SecureQlik ( Biometric / Facial / IRIS Recognition Platform )
    • Appsout ( Enterprise Mobility / Apps / AR / VR )
    • Techlopes ( Magento Development / E commerce Services )
    • InsureQlik ( Insurance Broker Software )
  • Global Offices
    • Contact Sales
    • Bilytica Global
    • Bilytica Australia
    • Bilytica UK
    • Bilytica Turkey
    • Bilytica Saudi Arabia
    • Bilytica UAE
    • Bilytica Canada
    • Bilytica Pakistan
    • Bilytica Africa
  • Learning
    • Blog
    • Training

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

Data Analytics Blogs and News in canada

Bilytica #1 Cognos Consulting Services in Canada

Cognos Consulting Services in Canada | Roadmap Services

December 13, 2018johnsteven
Read More
Tableau Consulting Services in Canada | Multi sources in one place

Tableau Consulting Services in Canada | Multi sources in one place

November 30, 2018johnsteven
Read More
Bilytica #1 Qlikview Consulting Services in Canada

Qlikview Consulting Services in Canada | Precisely Manage Complex Data

November 29, 2018johnsteven
Read More

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

  • Pharma Analytics
  • Insurance Analytics
  • CPG Analytics
  • Supply Chain Analytics
  • Retail Analytics
  • Manufacturing Analytics

Data

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

Excellence

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

Contact Sales

Menu
WhatsApp us