An Engineer’s View
Beware the Objection Removers
What Does the Central Team Do?
Avoid DW/BI Isolation
Implementation Analysis & Paralysis
Kimball Lifecycle in a Nutshell
Think Critically When Applying Best Practices
Eight Guidelines for Low Risk Enterprise Data Warehousing.
Requirements Gathering Dos and Don’ts
Surprising Value of Data Profiling
Organizing around Business Processes
Focus on Business Processes
Identifying Business Processes
Business Process Decoder Ring
Relationship between Strategic Business Initiatives and Business Processes.
Making the Case for Dimensional Modeling
Is ER Modeling Hazardous to DSS?
A Dimensional Modeling Manifesto
Enterprise Data Warehouse Bus Architecture
Divide and Conquer, The Matrix
The Matrix Revisited
Drill Down into a Detailed Bus Matrix
Integration Instead of Centralization
Integration for Real People Data Stewardship : The First Step to Quality And Consistency
To Be or Not To Be Centralized
Contrast with the Corporate Information Factory
Differences of Opinion
Don’t Support Business Intelligence with a Normalized EDW.
Basics of Dimensional Modeling
Fact Tables and Dimension Tables
Drilling Down, Up, and Across
Myths about Dimensional Modeling
Fables and Facts.
Granularity, Declaring the Grain, Keep to the Grain in Dimensional Modeling
Types of Fact Tables
Factless Fact Tables
Sound Like Jumbo Shrimp
Parent-Child Fact Tables
Patterns to Avoid When Modeling Header/Line
Fact Table Keys and Degenerates
Fact Table Surrogate Keys
Reader Suggestions on Fact Table Surrogate Keys
Miscellaneous Fact Table Design Patterns
Put Your Fact Tables on a Diet
Keeping Text Out of the Fact Table
Dealing with Nulls in a Dimensional Model.
Dimension Table Keys
Keep Your Keys Simple
Date and Time Dimension Considerations
It’s Time for Time
Surrogate Keys for the Time Dimension
Time Dimension Tables
Smart Date Keys to Partition Fact Tables
Handling All the Dates
Miscellaneous Dimension Patterns
Data Warehouse Role Models
Mystery Dimensions, De-Clutter with Junk Dimensions
Showing the Correlation Between Dimensions
Causal (Not Casual) Dimensions
Resist Abstract Generic Dimensions
Accurate Counting with a Dimensional Supplement
Slowly Changing Dimensions
Perfectly Partitioning History with Type SCD
Many Alternate Realities, Monster Dimensions
When a Slowly Changing Dimension Speeds Up
When Do Dimensions Become Dangerous?
Slowly Changing Dimensions Are Not Always as easy as.
Snowflakes, Outriggers, and Bridges
A Trio of Interesting Snowflakes
Help for Dimensional Modeling
Managing Bridge Tables
The Keyword Dimension
Dealing with Hierarchies
Maintaining Dimension Hierarchies
Help for Hierarchies
Five Alternatives for Better Employee Dimensional Modeling
Users and Group
Hands on with Live Example
Our Dimensional Data Modeling course covers all the topics that are required to clear Dimensional Data Modeling certification. Trainer will share Dimensional Data Modeling certification guide, Dimensional Data Modeling certification sample questions, Dimensional Data Modeling certification practice questions.
Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.
The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.
The trainer is a certified consultant and has significant amount of experience in working with the technology.
Yes, we accept payments in two installments.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.
User Reviews on popular courses
I took .NET training from Mindmajix. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with Mindmajix.
Thank You for the sessions that helped me gaining knowledge in Spotfire training. Trainer's experience helped me to get the detailed information regarding the key concepts and challenging tasks in real-time. Thanks once again.
Perfect sessions to know all the key concepts of Spotfire certification training. Thanks to the support team as well. Thanks to Mindmajix.
Servicenow training offered by MindMajix is excellent, and you clear Servicenow certification very easily after attending this training, and also you will get the real time view of the Servicenow.
The ServiceNow Course and trainer knowledge are so excellent and satisfied me. The pdf documents which are provided by the trainer are so helpful.
Mindmajix ServiceNow certification course is the best one, I have attended by far. It covered all the topics exactly what I was hoping for.
This was the first time I opted for training in ServiceNow and I was completely blown away by the training I got from Mindmajix. The training program was very well organized and all the required contents were covered in a proper manner. This training had given me tremendous confidence to secure a job. I really appreciate this training from Mindmajix.