Excel in Data Warehouse
& Business Intelligence
Learn from anywhere at your convenience
Schedule
Starting
28 January, ’23
Duration
8 weeks
Timings
11AM – 4PM (Sat & Sun)
Training Mode
Online
Instructors!
Meet the instructors of DWH & BI Course
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 & Talend 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) |
| Intro to data integration |
| Talend Installation |
| Getting to know the UI |
| Examples Hands-on |
Week 8: Talend
| First ETL job |
| Files Processing |
| Understanding Properties |
| Process RDBMS |
Pricing Details
Online Banking details will be shared by our representatives after you reserve your seat
- Individual Price
-
-
PKR 30,000 Per Person
- Total charges for complete training
-
- Group of Two
-
-
PKR 27,900 Per Person
- Avail 7% off on Group of two
-
- Group of Three
-
-
PKR 27,000 Per Person
- Avail 10% off on Group of three
-
- Group of 4 or more
-
-
PKR 25,500 Per Person
- Avail 15% off on Group of 4 or more
-
Tools
Reserve your Seat
You can reserve your seat by filling the form below
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 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.