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.
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
Pricing
Meet the Trainer
Tools & Technologies
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
- Project 1: Finance Dashboard
- Project 2: Sales Performance Dashboard
- Project 3: HR Analytics Dashboard
- Capstone Project (Client Simulation)
- Building Your Portfolio
- Resume, Interview & Freelancing Prep
- Mock-up Interviews with Industry Experts