This Business Intelligence and Data Warehousing (BI-DW) course covers data architecture skills that are increasingly critical across a broad range of technology fields. You`ll learn the basics of structured data modeling, gain practical SQL coding experience, and develop an in-depth under-standing of data warehouse design and data manipulation. You`ll have the opportunity to work with large data sets in a data warehouse environment to create dashboards and Visual Analytics. You will use of Pentaho, a leading BI tool, OLAP (online analytical processing) and Visual Insights capabilities to create dashboards and Visual Analytics. In the hands-on sessions, you`ll apply your skills to build a small, basic data warehouse, populate it with data, and create dashboards and other visualizations to analyze and communicate the data to a broad audience.
What is this course about?
In this course, you will learn exciting concepts and skills for designing data warehouses and creating data integration workflows. These are fundamental skills for data warehouse developers and administrators. You will have hands-on experience for data warehouse design and use open source products for manipulating pivot tables and creating data integration workflows. You will also gain conceptual background about maturity models, architectures, multidimensional models, and management practices, providing an organizational perspective about data warehouse development. If you are currently a business or information technology professional and want to become a data warehouse designer or administrator, this course will give you the knowledge and skills to do that. By the end of the course, you will have the design experience, software background, and organizational context that prepares you to succeed with data warehouse development projects.
This course is one the pivotal part of our four major streams of Big Data Analytics-
1. Big Data: Business Intelligence and Data Warehousing,
2. Big Data Analytics with Python
3. Advanced Big Data Analytics and Machine Learning applications,
4. Big Data Technologies.
You Will Learn How To:
1. Apply the BI Meta Model (BIMM) to turn desired outcomes into actions
2. Choose between a strategic and a tactical application of BI
3. Map operational data to a data warehouse
4. Design a BI solution for a business problem
After completion of this training course, you will be able to:
1. Evaluate an organization for data warehouse maturity and business architecture alignment
2. Create a data warehouse design and reflect on alternative design methodologies and design goals
3. Create data integration workflows using prominent open source software
4. Reflect on the role of change data, refresh constraints, refresh frequency trade-offs, and data quality goals in data integration process design
5. Perform operations on pivot tables to satisfy typical business analysis requests using prominent open source software
6. Makes it easy to access and share information
7. Improves the decision making process
8. Enables real-time analysis with quick navigation
9. Helps identify waste in the system
10. Reduces the risk of bottlenecks
11. Helps you know your business
PowerPoint Presentation,Handouts,Hands on Lab Practice,
Contents of Training:
Session 1: Introduction to Data Warehouse & Business Intelligence:
Learning Objectives - In this module, you will get an introduction of Data Warehousing and Business Intelligence with various ETL Tools and BI Tools with ERwin r9 Data Modeling.
Topics - What is Data Warehousing?, Definitions by W.H. Inmon [Top-Down Design], Ralph Kimball [Bottom-Up Design], Inmon Vs Ralph Kimball, Data Warehousing Tools, Schema Modeling Tools, CA, ERwin, Dell Toad Data Modeler, Oracle Data Modeler, ETL Tools: Informatica Power Center, Talend DI Open Studio, IBM Data Stage, SAS, Data Warehousing categories. What is BI - Business Intelligence?, BI Definition, BI Tools, Classification of BI Tools.
Session 2: Data Warehouse Architecture:
Learning Objectives - In this module, you will learn about the Data Warehouse Architecture which talks about the Various Source Systems i.e., Production Data into Relational, Flat File and various legacy system to Staging Area and finally into the Data Warehousing/Data Mart for presentation layer.
Topics - Relational Vs Analytical. What are - OLTP, OLAP, OLAP categories - MOLAP, ROLAP, HOLAP, Data Warehouse Vs Data Mart, Dependent and Independent Data Mart, Data Warehouse Architecture, Source System, ETL Extraction, Transformation. What is a cube?, Benefits of cube?, How to create the cube?, How to deploy a cube?, How to create a report using a cube?
Session 3: Data Warehouse Dimension & Fact Tables:
Learning Objectives - In this module, you will learn about different categories of Dimensional and Fact Type tables. Dimension - Slowly Changing Dimension concepts with Hierarchies and Level Attributes. Fact - Granularity for the fact data and also talks about the Measure Type.
Topics - DIMENSION TABLE - What is a Dimension Table?, Dimension table categories, FACT TABLE - What is Fact Table?, Fact Table Granularity, Fact Table categories.
Session 4: Data Modeling:
Learning Objectives - In this module, you will learn about what is Data Normalization and their 3 types of forms. Here you learn about the type of dimensional modeling, benefits, principles and characteristics
Topics - What is Data Normalization?, Data Normalization Rules - 1NF, 2NF, 3NF, Data De-Normalization, Dimensional Modeling - What is DM?, Principles, Benefits, Type and Technique.
Session 5: Building Data Warehouse with Erwin:
Learning Objectives - In this module you will see how we create a staging and target data warehouse and data marts from scratch to final. Decide the surrogate key, Dimension and Fact Tables. You also learn to generate the SQL scripts via ERwin r9.
Topics - Source System Understanding, Future Data Requirement and Understanding, Designing and Developing Dimension Table, Designing and Developing Fact Table Designing and Developing ER Model With ERwin, Designing and Developing Entity Relationship Modeling.
Session 6: Introduction to Open Source ETL Tool Talend DI Open Studio 5.x:
Learning Objectives - In this module, you will learn about the open source and commercial ETL Tools available into the market and it various comparisons. You will learn to create the flat file and relational target via Talend DI Open Studio 5.x using various Transformations.
Topics - Open source ETL Talend DI Open Studio -Difference between Licensed and Open Source ETL Tools, What are Licensed and Open Source ETL Tools, Working with ETL Transformation in Talend Open DI Studio.
Session 7: Building ETL Project With Talend DI Open Studio 5.x:
Learning Objectives - In this module, you will learn to create the actual business model and data integration jobs with management of various ETL items. You will learn how the actual ETL Projects work with BRD[Business Requirement Document] and TDD [Technical Design Document] and its uses.
Topics - Building ETL Project Talend DI Open Studio, Understanding the Data Source System which will be a future Data Requirement, Identify Business Requirement Gathering, Building the ETL Talend Technical Design Document, Building an ETL Project.
Session 8: Introduction to Data Visualization BI Tool Tableau 9.x:
Learning Objectives - In this module, you will learn about the Data Visualization Tools available in the market. You will learn to create reports and dashboards via Tableau 9.x using various functions.
Topics - Data Visualization BI Tool : Tableau 9.x-Introduction to Data Visualization with Tableau, Exploring Data Visualization with Tableau. What is Data Visualization?, Exporting Data and Working With Tableau.
Session 9: Building Data Visualization BI Project With Tableau 9.x:
Learning Objectives - In this module, you will learn to create reports and dashboards via Tableau 9.x using various advance features and functions. You also need to understand the various current and new report requirement.
Topics - Building Data Visualization BI Project With Tableau 9.x, BI Reporting Understanding, Report and Dashboard Template Document, Tableau Design and Development Database Source Connection.
Session 10: An Integrated Data Warehousing & BI Project:
Learning Objectives - This is an integrated Data Warehousing and Business Intelligence Project which starts from User Source System and Business Requirement Gathering till end of Project Development with production support strategies developments.
Topics - An Integrated Data Warehousing & BI Project, Developing a Data Warehouse and BI Project, Source System understanding today's data that will be the future data requirement, Identify the Business Requirement Gathering, Report and Dashboard Template Document, Designing and Developing Models, Designing and Developing the Staging Area, Finalizing the Dimension Modeling Type, Designing and Developing Dimension Modeling.