DWh & BI Professional Course

Lead by Industry Professionals!

About Course

The purpose of Business Intelligence is to support better business decision making. Essentially, Business Intelligence systems are data-driven Decision Support Systems (DSS). Business Intelligence is sometimes used interchangeably with briefing books, report and query tools and executive information systems.

Offering a broad course preparing possibility to wind up Data Warehouse and Business Intelligence Experts. Amid the Six a month and a half of the course, you will find out about the diverse elements of Data Warehouse, for example, Dashboards, Data Modeling, Teradata and Advance SQL.

In the resulting week after week conveyance of the course, members will have hands-on involvement with various apparatuses of the Business Intelligence, for example, Tableau, Power BI, and Micro Strategy. In the hands-on undertakings, you will have the capacity to execute your learning all through this course.

Who Can Join?

This course is designed for participants who want to pursue a career in business analytics and those who wants to learn new tools and technologies related to business intelligence. Business Intelligence is taking over the world due to huge amount of data so this course designed for the participants who wants to become business analysts.

OUR SUCCESS STORIES

Rukhsar Nadeem
Data Engineer

Arham Matloob
BI Developer

Inam ul Haq
Big Data Consultant

Saqib Lateef
BI Developer

Jawad Riaz
BI Developer

Saad Farooq
Laravel Developer

Schedule

calendar_today

Starting

Free Demo Class
Dec 09 ,2023

timeline

Duration

12 Weeks

access_time

Timings

Sat-Sun
12pm-4pm

event_seat

Mode

Hybrid Trainings

Pricing

person

For Individual

Rs. 30,000 ,  40,000

group

Group of 2 Persons

5% Off

group_add

Group of 3 Persons

10% Off

group_add

Group of 5 or more Persons

15% Off

MEET THE TRAINER

Mr. Faisal Adnan is an IT Professional having a diverse working history of 5+ years of competitive experience in the IT Industry with a focus on Data Analytics, Business Intelligence & Data Warehouse. He is currently providing his services at Systems Limited as Business Intelligence Consultant. Knime, Microsoft Dynamics 365, Azure Data Factory, Azure Data Lake, Microsoft Power BI, SQL Server, SSIS, Vertica, Tableau, Data Modeling, Data Visualization, Data Engineering, and BI Reporting are some of his areas of specialization. He has strong industry knowledge, and the capacity to organize, schedule, and predict commercial activities.

Faisal Adnan

BI & DWh Trainer

Tools & Technologies

No results found.

Course Outline

  • SQL Basics 
  • OLTP / OLAP 
  • DWH Architecture 
  • Implementation of DWH 
  • Introduction to SQL DWH Architecture
  • Advance SQL 
  • Business intelligence EcoSystem 
  • Logical Data Model
  • Introducing Business Intelligence 
  • The Business Value of BI 
  • The Challenges of BI 
  • Making the Business Case for BI 
  • Barriers to BI 
  • BI in the Marketplace
  • Working with Sale Industry Project
  • Working with Ecommerce Industry Project
  • Data Modeling/Transformation 
  • Normalizations 
  • Data Quality Key Factors 
  • Operations 
  • EL/TL 
  • Data Quality Checks 
  • Modern vs Traditional DWH 
  • Working with ETL Tools(Informatica/Knime/Pentaho)
  • Data warehouse Development 
  • Dimensional Modeling 
  • Working with Teradata
  • Introduction to Power BI 
  • Tabular Models 
  • Self-Service BI and PowerPivot 
  • Simple DAX & Advance DAX’s 
  • Tabular Models 
  • DAX Time Intelligence Functions
  • Final Projects
  • Interviews preparation
  • Mock-up Interviews

Reserve Your Seat