DWH and BI - Dice Analytics

DWH and BI

Course Led by Industry Professionals!

Professional Training in Peshawar!

During the Eight (8) weeks of the course, you will learn about the different ingredients of Data Warehouse such as Dashboards, Data Modeling, Teradata and Advance SQL.

In the subsequent weekly distribution of the course, participants will have hands-on experience with different tools of the Business Intelligence such as Tableau and Power BI. In the hands-on projects, you will be able to implement your learnings throughout this course.

At the end of the course, candidates will have in-depth understanding & hands-on related to DWH & Business Intelligence.

View Course Outline Reserve Your Seat




To be announced!


8 Weeks (Saturday Classes)


10AM – 6PM


Limited Seats Available!


Meet the instructors of DWH & BI Course

Business intelligence Expert | Data Science | Trainer in Dice Analytics
Shoaib Khan

Mr. Shoaib Khan brings 7+ years of experience of BI consultancy, data modeling & visualization and currently working with telecom sector as Applied Analytics Specialist and BI Consultant and Trainer with Dice Analytics. He is certified in Teradata, Tableau, Power BI, MicroStrategy, AI and Python Programing. His key expertise comprises of end-to-end development of churn and sales prediction models, Algorithm Development and Advance Analytics.

Nabeel Waqar Wyne

He is a passionate BI & Analytics developer with Information Systems & Management degree from ‘The University of London’ and 3 years of experience in field of BI and Data Analytics. He has Worked on multiple database projects while involving in design and development of database.

Amad Iftikhar

He is a data science & BI enthusiast with extensive experience in the data science and business intelligence domain. He has worked on facial recognition based attendance system, churn prediction and credit scoring using machine learning models.

Course Outline

Week 1: DWH Essentials & SQL

Data Analytics Ecosystem
Introduction to DWH
Scorecard vs Dashboard
Databases VS RDBMS
DWH Soft Architecture & layers
Implementations of DWH
Exercise on DWH Importance
Introduction to Teradata
Hands on SQL basics
Hands on SQL Advanced
Introduction to Teradata HW Architecture
Data Science vs Business Intelligence
Overview of DWH & BI Certifications
DWH Project Distribution on Retail Industry
DWH Planning

Week 2: DWH Architecture & Design

Teradata Architecture
Data Modeling (Conceptual and Logical Data Model and Physical Data Model)
Data Quality & Automation
DWH Operations
Retentions, Compressions
Modern Data Warehouse vs Traditional

Week 3: DWH Project (ETL Development & Data Quality)

Hands on Logical Data Model
Hands on Physical data model (Staging layers)
Implementing Data Quality in ETL development
Queries/Processes Monitoring through TD Viewpoint

Week 4: DWH Project (Automations & Performance Tunig)

Hands on physical Data Model (Foundation layer)
Hands on Physical Data Model (Aggregate layer)
Building Reconciliation Mechanism across layers of DWH
ETL Automations using SLJM
Performance Tuning
Viewpoint Query Monitoring, Health Monitoring, Workload Management, Query Spotlight
Learning importance of Explain Plan & query Performance Optimization

Week 5: BI Modeling

Business Intelligence & its importance
Hands on Business Analysis (Ad hoc Reporting)
OLAP – Dimensional Modelling Fundamentals
Dimensional Modelling Design with industrial use case
Design Steps – Dimensional Modeling (Hands on)
Implementation – Dimensional Modeling (Hands on)
Slowly Changing Dimensions (SCDs) with use cases
Design and implementation of Dimensional Model on Retail Store Data (Assignment)

Week 6: PowerBI

How to Connect & Import Data from multiple Data sources
Reshaping and Transforming Data in Query Editor
Data Enrichment (New business Fields)
Data Modelling
Understanding Cardinalities
Building Interactive Visualizations on previously implemented Dimensional Model
Animated Visualization Implementation
Roll-up/Roll-Down Capabilities
Custom visualization in Power BI
Introduction to Power BI Services
Scheduling Automated Reports Refresh
Creating Dashboards & Natural Language Processing in Power BI                          Services
Sharing Dashboards All across Organization
Mobile Dashboard Design

Week 7: Advanced Power BI & Tableau Basics

Introduction to DAX Language
Creating DAX Measures
 Evaluating DAX Measures
Leverage Calculate Functions functionality
Power Function/ Divide Function
MTD, QTD and YTD Date Calculations
Business Use Case implementation in Power BI (Assignment)
Connecting with Different Data Sources in Tableau
Data preparation with Tableau
Live Vs Extract
Data Source Filters
Basic Report Creation
Understanding of Rows and Columns
Leveraging the Use of Marks Labels to enrich information in Reports
Visualization best practices with real world examples
Grouping fields in Tableau
Interactive Filters

Week 8: Advanced Tableau

Types of filters
Advanced Filter Calculations
Enhancing user interactivity thorough parameters
Maps in Tableau
Importing custom geocoding in Tableau
Visualize your data on map through spatial files
Building a Dashboard
Leveraging the use of Interactivity in Dashboards through Actions
Designing and implementation of dashboard
Designing of dashboard for mobile & Tablets
Enriching information by creating Calculated Fields
  Calculation Syntax
Date/Logic/String Calculations
Advance Calculations (LODs)
LODs real world Use cases
Visual analytics
Pareto Chart
Business Use Case implementation in Tableau (Assignment)



Following is the price for this extensive training for Data Warehouse and Business intelligence

Price for an Individual Member
Rs 25,000 per person
Group of Two
7% Discount for a group of two people
Rs 23,250 per person
Group of Three
10% Discount for a group of Three people
Rs 22,500 per person
Group of Four
15% Discount for a group of Four people
Rs 21,250 per person

Frequently Asked Questions

Who should attend the course?

Recent graduates, third year and final year students from the computer science disciplines.

Professionals from the computer science domain who want to shift the profession to Big Data Analytics.

Executives who want to build the initial knowledge about the impact of the Big Data ecosystem on organization growth.

Who are the Instructors?

What is the timing of the course?

Duration: 8 weeks

Class Day: Saturday

Timings: 10:00 AM – 06:00 PM

Can I get a job after this course?

Since our instructors are industry experts so they do train the students about practical world and also recommend the shinning students in industry for relevant positions.

How much hands-on will be performed in this course?

Since our courses are led by Industry Experts so it is made sure that content covered in course is designed with hand on knowledge of more than 70-75 % along with supporting theory.

What are the PC requirements?

For BI and DWH course, you need to have a PC with minimum 8GB RAM and ideally 16GB RAM.

Will I get a certificate after this course?

Yes, you will be awarded with a course completion certificate by Dice Analytics after a test conduction in last week of the course. We also keenly conduct an annual convocation for the appreciation and recognition of our students.

Reserve your Seat

You can reserve your seat  by filling the form below

    Are you a: 
    StudentWorking Professional