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.
24th June, 2020
8 weeks (Mon – Fri)
07:00 PM to 09:00 PM
Limited Slots Available!
Meet the instructors of DWH & BI Course who are highly experienced!
Mr. Abbas Rizvi is a Data Enthusiast having more than 5 years of experience. He’s a Teradata 14 Certified Professional, a Certified Professional Scrum Master & a Talend Data Integration Certified Developer currently working with Teradata Global Delivery Center in the role of Data Integration Consultant. Have a great working experience of Data Warehouse design & development and good grasp on multiple ETL Tools and Techniques.
Mr. Nabeel is currently associated with Telenor as Business Intelligence Developer. He is a passionate Business Intelligence & 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.
|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)|
Real-life case studies
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