Launch Your Global Career with Maersk – Placement Drive 2025 @ ZebLearn | Applications Close In 0d 0h 00h 00s

ZebLearn Certification Partners – Globally Recognized Credentials!

ZebLearn partners with leading industry experts to offer genuine, career-focused certifications in SAP training, foreign languages, and professional development courses. Earn internationally recognized credentials, enhance your career prospects, and distinguish yourself with certifications valued by the industry.

cisco
apple
esb
abode
Partner
meta
pmi
ic3
Partner
Partner
Partner
Partner
communication

Course content

About Data Warehousing program

  • Why a data warehouse?
  • What is a data warehouse?
  • The purpose of a data warehouse
  • What is Business Intelligence?
  • Data Lake or Data Warehouse?
  • Data Lake & Business Intelligence
  • Setting up Pentaho (ETL tool)
  • Demos & Hands-on
  • Pentaho for Mac M1/M2: Installation & Troubleshooting
  • Setting up PostgreSQL (Database system)
  • 3 Layers of a Data Warehouse
  • Staging area
  • Demo: Setting up the staging area
  • Data Marts
  • Staging area & Data Marts
  • Relational databases
  • In-Memory databases
  • Cubes
  • Different database systems
  • Operational Data Storage
  • What is dimensional modeling?
  • Why dimensional modeling?
  • Facts
  • Dimensions
  • Star schema
  • Snowflake schema
  • Demo: Product & Category dimension (snowflaked)
  • Facts & Dimensions (ProjectLogs)
  • Facts & Dimensions (SalesTransactions)
  • Additivity
  • Nulls in facts
  • Year-to-Date facts
  • Types of fact tables
  • Transactional fact tables
  • Periodic fact tables
  • Accumulating snapshots
  • Comparing fact table types
  • Identifying fact tables
  • Factless fact tables
  • Steps in designing fact tables
  • Surrogate Keys
  • Dimension tables
  • Date dimensions
  • Nulls in dimensions
  • Hierarchies in dimensions
  • Conformed dimensions
  • Degenerate dimensions
  • Junk dimension
  • Role-playing dimension
  • Case Study: Date dimension
  • Understanding dimensions
  • What are slowly changing dimensions?
  • Type 0 - Original
  • Type 1 - Overwrite
  • Type 2 - Additional row
  • Administrating Type 2 dimensions
  • Mixing Type 1 & Type 2
  • Type 3 - Additional attribute
  • Understanding Slowly Changing Dimensions
  • Understanding the ETL process
  • Extract
  • Initial Load
  • Delta Load
  • Load Workflow
  • Demo: Quick Intro to Pentaho
  • Demo: Setting up tables in SQL
  • Demo: Initial Load example
  • Demo: Delta Load example
  • Transforming data
  • Basic Transformations
  • Advanced Transformations
  • Demo: Planning next steps
  • Demo: Table setup & Complete Staging
  • Demo: Transform
  • Demo: Load & Validate results
  • Scheduling jobs
  • ETL tools
  • Choosing the right ETL tool
  • What is an ELT?
  • ETL vs. ELT
  • What are the common use cases?
  • Connecting the DWH to Power BI
  • Using indexes
  • B-tree indexes
  • Bitmap indexes
  • Guidelines for indexes
  • Cloud vs. on-premise
  • Benefits of cloud vs. on-premise
  • Massive parallel processing
  • Columnar storage
  • Why Should You Learn Data Warehousing Training?

    The annual salary of an Data Warehousing is $125k.

    Request more information

    What you will get at Zeblearnindia Learning?

    Zeblearnindia Learning is a premier institute offering training in SAP Online Courses, Web Designing, Data Science, Full-Stack Development, Salesforce, Workday, Machine Learning, Software Testing, and Video Editing. With the option to choose between online and offline (classroom) learning, our well-structured courses cater to students, working professionals, business owners, and entrepreneurs. Here’s what you can expect at Zeblearnindia Learning:

    •   Expert-Led Training
    •   Globally Recognized Certifications
    •   100% Job Placement Support
    •   Hands-On Learning
    •   Flexible Learning Options
    •   Affordable Course Fees
    •   Career Growth Opportunities
    best-seller-min

    () 60 Minutes WEBINAR with CERTIFICATE

    Date Time IST (GMT +5:30) Event Free Sign Up

    Explore Our Courses Across India - Flexible batches

    We are proud to offer our Data Warehousing program services across numerous states nationwide.

    Call Us
    WhatsApp
    Questions? WhatsApp us.
    Placements query?

    We use cookies to improve your experience and personalize our site. cookie policy