DWH and BI
Course Led by Industry Professionals!Starting
To be announced soon
Duration
8 Weeks (Mon – Fri)
Timings
07:00 PM to 09:00 PM
Remaining
Limited Seats Available
Instructors!
Meet the instructors of DWH & BI Course
Certified Data warehouse Consultant |Data Engineering Specialist at Telenor
Mr. Ammad Tahir
Mr. Ammad brings more than 5 years of strong expertise in Enterprise Data warehousing (EDW) life cycle especially in Data integration design, development, Testing, operations & reconciliations. Possess strong business knowledge of Telecommunications Industry (Technical and Business processes) & skills necessary to analyze and investigate the business issues, design solutions and implementing them. Have excellent command on data integration tools (Informatica 8.x, 9.x, GCFR and SLJM)
DWH | BI | ANALYTICS
Mr. Nabeel Waqar Wyne
He is a passionate BI & Analytics developer with Information Systems & Management degree from ‘The University of London’ and 3 years of experience in field of BI and Data Analytics. He has worked on multiple database projects while involving in design and development of database. His expertise includes Power BI, Tableau, Qlik, Hadoop and Hive.
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) |
Tools
Pricing
Following is the price for this extensive training for Data Warehouse and Business intelligence
Individual
Price for an Individual Member
Rs
30,000
per person
Group of Two
7% Discount for a group of two people
Rs
27,900
per person
Group of Three
10% Discount for a group of Three people
Rs
27,000
per person
Group of Four
15% Discount for a group of Four people
Rs
25,500
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:00 PM – 09:00 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 DWH & BI 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