During the Eight (8) weeks of the live training, 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 on live platforms 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.
11 AM – 3:30 PM
Meet the instructors of DWH & BI Course
Mr. Ammad has an extensive experience as a Data Science & BI enthusiast. He is currently working as Executive BI Reporting & Quality Assurance at Ufone. He has worked on several AI projects such as facial recognition based attendance system, churn prediction and credit scoring. He is a Data Warehouse, Business Intelligence, Tableau, Python & Data Science Certified Professional.
Mr. Zakaullah is a Teradata Certified Professional and has several years of experience in designing and implementation of end to end Enterprise Data Warehousing and Business Intelligence projects across multiple industries. He holds expertise in different business Intelligence and ETL tools and technologies e.g. SAP Business objects, IBM BI Cognos 10, Tableau, Oracle BI, Oracle Data Integrator and IBM DataStage.
Live Zoom Sessions
Real-life case studies
|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 price for this extensive live training on Data Warehouse & 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: Monday – Friday
Timings: 07:00 PM – 09: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.
To ensure a smooth live class, you will need to have 3GB or more internet speed.
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