Be a Data Engineer!
Learn from anywhere at your convenience
Schedule
Starting
24th Feb’22 (Tentative)
Duration
8 weeks
Timings
7PM – 9PM (Mon-Fri)
Language
Urdu/Hindi
Instructors!
Meet the instructors of DWH & BI Course
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.
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 Details
Online Banking details will be shared by our representatives after you reserve your seat
Actual Training Price
Price for a Regular Member
PKR
30,000
Per Person
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