During the Eight (8) weeks of the course, you will learn about the different ingredients of Data Warehouse such as Dashboards, Data Modeling, Teradata and Advance SQL.
In the subsequent weekly distribution of the course, participants will have hands-on experience with different tools of the Business Intelligence such as Tableau and Power BI. In the hands-on projects, you will be able to implement your learnings throughout this course.
At the end of the course, candidates will have in-depth understanding & hands-on related to DWH & Business Intelligence.
8 Weeks (Saturdays)
10:00AM to 06:00PM
Limited Seats Available
Meet the instructors of DWH & BI Course
Mr. Nauman Mir has 9+ years of experience in telecom industry and his key expertise include Big Data techniques, planning, development, operations, performance tuning, campaign management and information security. He has been responsible for defining and implementing Business models, data marts, OLAP/Intelligent cubes, providing data level services for different analysis for Commercial teams.
Mr. Shoaib Khan brings 7+ years of experience of BI consultancy, data modeling & visualization and currently working with telecom sector as Applied Analytics Specialist and BI Consultant and Trainer with Dice Analytics. He is certified in Teradata, Tableau, Power BI, MicroStrategy, AI and Python Programing. His key expertise comprises of end-to-end development of churn and sales prediction models, Algorithm Development and Advance Analytics.
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.
He is a data science & BI enthusiast with extensive experience in the data science and business intelligence domain. He has worked on facial recognition based attendance system, churn prediction and credit scoring using machine learning models.
|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|
|Data Modeling (Conceptual and Logical Data Model and Physical Data Model)|
|Data Quality & Automation|
|Modern Data Warehouse vs Traditional|
|Hands on Logical Data Model|
|Hands on Physical data model (Staging layers)|
|Implementing Data Quality in ETL development|
|Queries/Processes Monitoring through TD Viewpoint|
|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|
|Viewpoint Query Monitoring, Health Monitoring, Workload Management, Query Spotlight|
|Learning importance of Explain Plan & query Performance Optimization|
|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)|
|How to Connect & Import Data from multiple Data sources|
|Reshaping and Transforming Data in Query Editor|
|Data Enrichment (New business Fields)|
|Building Interactive Visualizations on previously implemented Dimensional Model|
|Animated Visualization Implementation|
|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|
|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|
|Types of filters|
|Advanced Filter Calculations|
|Enhancing user interactivity thorough parameters|
|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|
|Enriching information by creating Calculated Fields|
|Advance Calculations (LODs)|
|LODs real world Use cases|
|Business Use Case implementation in Tableau (Assignment)|
Following is the price for this extensive training for Data Warehouse and Business intelligence
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.
Duration: 8 weeks
Class Days: Saturdays
Timings: 10:00 AM to 06:00 PM
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.
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.
For DWH & BI course, you need to have a PC with minimum 8GB RAM and ideally 16GB RAM.
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.
You can reserve your seat by filling the form below