fbpx

Upcoming Events

No Events on The List at This Time

 

Be a Data Engineer!

Learn from anywhere at your convenience

Data Warehouse & Business Intelligence.

An Industry-Expert Led Live Training

During the Eight (8) weeks of the live training, 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 on live platforms 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

Our Approach for Zoom Interactive Classes

After establishing a reputable Physical Training Model, based on our stellar records and customer earned trust we gradually progressed to establish the same reputation in the Zoom based Live Training Model. We are committed to empower you by making our trainings accessible, interactive, and well curated specifically to your objective.

live training process 2

Schedule

Starting

6th October’2021

Duration

8 weeks

Timings

7 PM – 9PM (Mon-Fri)

Language

Urdu/Hindi

Instructors!

Meet the instructors of DWH & BI Course

qodef-team-image
Principal Consultant @ RADEC Technologies Pvt. Ltd.
Mr. Abu Bakar N. Alvi

Mr. Abu Bakar has 21+ years of extensive experience of working with multi-disciplinary teams & completing challenging projects. He handled multi-million dollar projects as a Program/Project Manager in the Defense Sector. He has been working as an ICT Consultant with various organizations including the World Bank Group. He is a Microsoft Certified Data Analyst, a Microsoft Certified Trainer (MCT), Certified Project Management Professional (PMP) & Agile Certified Practitioner (PMI-ACP). He is the Youngest Professional Engineer to be awarded with the 4th highest Civil Award 'Tamgha-e-Imtiaz' by the Govt of Pakistan in 2005.

qodef-team-image
Assistant Manager BI & Analytics @ Telenor Microfinance Bank
Ms. Areesa Masood

Ms. Areesa is a Telecom Professional Credited with the 5+ years of competitive experience in IT & Commercial with focus on Data Development, Data Warehouse, Business Intelligence & Analytics and Data Science. She is currently working with Telenor Microfinance Bank as Assistant Manager BI & Analytics. She has acquired multiple certifications from KNIME, Dice & Coursera to build a strong command in the field. Her core expertise includes: Teradata SQL Assistant, PL/SQL(Oracle), IBM COGNOS, MicroStrategy, BI Reporting and Analysis, Shell Scripting, TPT utility, RDBMS, Data Modeling, Visualization, Tableau & Power BI.

Course Outline

Week 1: DWH Essentials & SQL

Data Analytics Ecosystem
Introduction to DWH
OLTP vs OLAP
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)
Normalization
Data Quality & Automation
DWH Operations
ETL/ELT/ELTL/Data Lake
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 Tuning)

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
Statistics
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
ROLAP VS MOLAP
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
Pages
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
Extensions
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)

Pricing

Following is price for this extensive live training on Data Warehouse & Business Intelligence

prices slider January 2021 a

Tools

Frequently Asked Questions

Who should attend the course?

Graduate or Masters Students with IT, CS or Business background who want to start their career in the Data Analytics domain

People who are working in the BI domain and want to advance their career in the field of Data Analytics

Executive who want to build a Data Analytics department in their start-ups/organizations

What is the timing of the course?

Duration: 8 weeks (Mon-Fri)
Timings: 7PM – 9PM

Who are the Instructors?

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 Data Warehouse & BI Professional course, you need to have a PC with minimum 4GB RAM.

What if I miss any of the lectures?

Don’t worry! We have got you covered. You shall be shared recorded lectures after each session, in case you want to revise your concepts or miss the lecture due to some personal or professional commitment.

How will this training ensure hands-on practice?

For executing the practical’s included in the DWH & BI  Training, you will set-up tool on your machine. The installation manual for tool prep will be provided to help you install and set-up the required environment.

What sort of projects will be part of this Live Training?

This Certification Training course includes multiple real-time, industry-based projects, which will hone your skills as per current industry standards and prepare you for the future career needs.

Will I get a certificate after this course?

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

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.

Reserve your Seat

You can reserve your seat  by filling the form below

     
    Are you a: 
    StudentWorking Professional

     

     

     


    ×
    X
    \