Upcoming Events

No Events on The List at This Time

 

DWH and BI Course

Led by Industry Professionals!

About DWH & BI Course

Offering an 8 Weeks extensive course getting candidates ready to become Data Warehouse and Business Intelligence Experts. 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, Power BI, and Micro Strategy. 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

Schedule

Starting

23rd Jan, 2019

Duration

8 Weeks (Mon – Fri)

Timings

07:30PM to 09:30PM

Remaining

12 Seats Left

Meet the Instructors

Meet the trainers of this course who are BI experts & are highly experienced!

qodef-fullwidth-slider

Nauman Mir

Data warehousing, Business Intelligence, Big Data, Contextual Marketing and Trainer

Mr. Nauman Mir has almost 8 years of experience in telecom industry and his key expertise include Big Data techniques, planning, development, operations, performance tuning, campaign management and information security. He has been responsible for defining and implementing Business models, data marts, OLAP/Intelligent cubes, providing data level services for different analysis for Commercial teams.

qodef-fullwidth-slider

Shoaib Khan

Business intelligence Expert

Mr. Muhammad Shoaib Khan holds a Computer engineering degree. He has vast work experience of over 6 years with Vendor & Telecom Companies. His key expertise is in domains of Business Intelligence...

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

Week 2: DWH Architecture & Design

  • Teradata Architecture
  • Data Modeling (Conceptual Data Model, 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
  • Data Science vs Business Intelligence
  • Overview of DWH & BI Certifications
  • DWH Project Distribution on Retail Industry
  • DWH Planning
  • Exercise on Conceptual Data Model
  • SLJM (ETL Framework Overview)
  • Exercise on SLJM

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
    • Statistics
    • Viewpoint Query Monitoring, Health Monitoring, Workload Management, Query Spotlight
    • Learning importance of Explain Plan & query Performance Optimization

Week 5: Reporting & Visualizations

  • Business Intelligence & its importance
  • Hands on Business Analysis (Adhoc Reporting) hours
  • Dimensional Modelling Fundamentals
  • Dimensional Modelling Design with telecom use case
  • Information Modeling for Business layer
  • Implementation of Semantic layer

Week 6: MicroStrategy

  • Micro Strategy architecture
  • Micro Strategy server setup
  • MicroStrategy schema designing
    • MSTR attributes design and development
    • MSTR Facts design and development
    • MSTR Parent child relationship
    • Heterogeneous vs homogenous mapping
  • MicroStrategy application objects
    • Reports creation
    • Metrics, Filters
    • Prompts
    • Advance type of metrics

Week 7: Tableau

  • Data preparation with Tableau
  • Data measures and metrics
  • Report generation and storytelling
  • Performing analytics on various visualizations
  • Quick table calculation
  • Types of filters
  • LODs
  • Graphs and Maps
  • Visual Analytics
  • Connectivity with web
  • Dashboards design and development

Week 8: PowerBI

  • Fixing incorrect sorts
  • Connectivity with multiple source systems
  • Online Practice on various datasets
  • Power BI Data preparation through query editor
  • Relationship Modeling –
  • Data customization using DAX
  • Report and Dashboard Designing
  • Dashboard publish over Power BI server
  • Mobile dashboard Designing

Tools

Pricing

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

Individual
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 Days: Monday – Friday

Timings: 07:30 PM to 09:30 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

 

 

 

Facebook
Twitter
LinkedIn
Instagram
X