Course Schedule and Upcoming Batches
Please take a note of the Upcoming batch schedules. Mode of course delivery is Classroom sessions by an expert Instructor.
| Flat 5% Discount for limited period | |||||
|---|---|---|---|---|---|
76,000 Enroll | 1520 Enroll |
||||
This course is open for Enrollment and Payment.
In case you want to Register now and take up this course later, you can register by clicking on " Register" section.
If you have any query, you can call/mail or send your query by clicking on " Send a Query" section.
About the Course
This course is designed to give a learner the end-to-end knowledge on Data Science, Business Intelligence, Data warehousing, Analytics, Big Data, Data Modeling, Dimensional Modeling and SQL. This course is best suited to those who want a complete exposure to these technologies and want to start or accelerate their career in this hottest field of IT.
So how is this training different from other Industry courses? Our course is refreshing and unique in its approach because we are following the two most important principles:
- We provide only industry relevant knowledge; things which are endorsed by industry veterans.
- We give tool knowledge but we also provide basic understanding behind data science and BI. We believe in providing a great foundation with theoretical aspects and then develop the usable skills by training on tools and technologies.
Most of the training courses in market are focused on BI tools only; tools are no doubt necessary to start a career in BI but they limit the growth only to a coder level. To grow in your career you would need a right foundation to build upon and acquire new knowledge and skills. A good foundation will give you an unfair advantage over other starters.
Upon successful completion of this course , you will receive a certification known as "BIWHIZ CERTIFIED BUSINESS INTELLIGENCE PROFESSIONAL".
Why is this course for you?
Beginners
If you are working in other industries and want to start your career in BI & Data Science then this course is right for you. This will give you good exposure of basic concepts and prepare you with practical working knowledge of BI tools.
Freshers
If you have just passed out of college and planning to take up promising and exciting field of BI and Data Science then this course can do wonders for you. This is all-in-one course where you learn multiple data science related subjects under one roof. We make sure that you get good exposure of these technologies with the inputs from our partner companies in BI/Data science space.
Fast Track BI & Data Science
In case you want a fast track knowledge on BI, Datawarehousing, Big Data, Analytics, Dimensional Modeling and SQL then this is the right course for you. This is all in one course suitable for fast learners. In case you want to learn these concepts in detail, you can also go for Advanced or Master level courses.
Course Objective
After completion of this course, you will be able to:
- Learn What is Business Intelligence, Data Warehousing, Analytics, Big Data, Data Modeling, Dimensional Modeling and SQL.
- Learn about Business Intelligence components, environment and Architecture.
- Learn about system flow of BI systems, User Management and Resource Management.
- Learn about BI Security, Publishing, Scheduling and Content Management.
- Learn about BI Design components, BI Quality Management and BI Testing processes.
- Learn about Data Warehousing building blocks,Master Data Management and Data Warehousing Architecture.
- Learn about Data Warehousing components ,Data Warehousing Design components and how to create a Data Warehousing Design.
- Learn about Data Governance,Data Profiling, Data Quality,Metadata, Tool Selection etc.
- Learn Machine Learning techniques - Classification, Association and Cluster Analysis.
- Learn Classification techniques like Decision Tree Classifier, Rule based classifier, Instance based classifier, Nearest neighbor classifier, Naive Bayes Classifier,Artificial Neural Networks, Support Vector Machine and Ensemble Methods.
- Learn Association techniques like Rule Mining, Naive Algorithm, Apriori Algorithm.
- Learn Cluster techniques like Computing Distance, Partition Methods (K-Means Method), Hierarchical Methods, Agglomerative method, Divisive Hierarchical method, Density based methods.
- Learn about Big Data and why is it becoming so important now days.
- Learn the basic concepts behind Hadoop's hugely successful MapReduce Architecture.
- Learn about Hadoop Architecture, Hadoop Ecosystem and Hadoop Family.
- Learn basics of Pig, Pig Latin, Hive, HiveQL, NoSQL, HBase, Zookeeper,OOZIE, HCatalog, Hadoop 2.0, MRV2 (or YARN).
- Learn basics of Data Modeling, Normalization and Entity Relationship framework.
- Learn about Conceptual Data Model, Logical Database Design and Physical Database Design.
- Learn about building blocks of Dimensional Modeling.
- Learn in detail about Dimensional Modeling.
- Learn Advanced SQL.
- Learn Advanced level knowledge on Business Intelligence and Data Warehousing Tool - Pentaho.
- Carry out an end to end project on Business Intelligence and Data Warehousing
Pre-requisites
It's good to have operating knowledge of Computers and some hands on in computer programming or databases.
Want detailed knowledge of each subject?
In case you want to learn these subjects in detail, you can go for Advanced or Master level courses.
Course Curriculum
Section A: Introduction
1) Business Intelligence, Datawarehousing, Analytics and Big Data Introduction
In this module you will get the introduction of Business Intelligence, Datawarehousing, Analytics and Big Data. You will learn, why are these technologies gaining the importance and popularity? and why is it important to gain knowledge in this domain. Also what are the most important concepts and practical exposure one should get to be able to be market ready and employable by BI companies.
2) Framework of Business Intelligence and Data Science Study
In this module you will learn about various discipline of data sciences and how are they interlinked together. You will also learn about various learning and job related opportunities and how can you transition yourself for next generation roles.
Section B: Business Intelligence
After completion of this module, you will be able to:
- Gain understanding of all Business Intelligence concepts.
- Learn about Business Intelligence components.
- Learn about Business Intelligence environment.
- Gain a good understanding of Business Intelligence Architecture and its components.
- Learn about end to end system flow of BI systems.
- Learn about User Management and BI Resource Management.
- Learn about Security, Publishing, Scheduling and Content Management.
- Learn about BI Design components and how to create a BI Design.
- Learn details about BI Quality Management and BI Testing processes.
Section C: Data Warehousing
After completion of this module, you will be able to:
- Gain understanding of all Data Warehousing concepts.
- Learn about Data Warehousing building blocks and Master Data Management.
- Gain a good understanding of Data Warehousing Architecture.
- Learn about Data Warehousing components & systems and how they function together.
- Learn about end to end system flow of Data Warehousing systems.
- Learn about Data Warehousing Design components and how to create a Data Warehousing Design.
- Learn topics like Data Governance,Data Profiling, Data Quality,Metadata, Tool Selection etc
Section D: Analytics
After completion of this module, you will be able to:
- Learn basic Probability & Statistics.
- Learn Machine Learning techniques - Classification, Association and Cluster Analysis.
- Learn Classification techniques like Decision Tree Classifier, Rule based classifier, Instance based classifier, Nearest neighbor classifier, Naive Bayes Classifier,Artificial Neural Networks, Support Vector Machine and Ensemble Methods.
- Learn Association techniques like Rule Mining, Naive Algorithm, Apriori Algorithm.
- Learn Cluster techniques like Computing Distance, Partition Methods (K-Means Method), Hierarchical Methods, Agglomerative method, Divisive Hierarchical method, Density based methods.
- Learn basics of Analytics tool- R
Section E: Big Data
After completion of this module, you will be able to:
- Learn about Big Data and why is it becoming so important now days.
- Understand the differences between data science technologies like Business Intelligence, Data Warehousing, Analytics, Big Data and how they work together in a typical data science environment.
- Learn the basic concepts behind Hadoop's hugely successful MapReduce Architecture.
- Learn about Hadoop Architecture, Hadoop Ecosystem and Hadoop Family.
- Learn basics of Pig, Pig Latin, Hive, HiveQL, NoSQL, HBase, Zookeeper.
- Learn basics of OOZIE, HCatalog, Hadoop 2.0, MRV2 (or YARN).
Section F: Data and Dimensional Data Modeling
After completion of this module, you will be able to:
- Learn basics of Data Modeling, Normalization and Entity Relationship framework.
- Learn Learn why the concept of Subtypes/Supertypes is important for Data Modeling.
- Learn about Conceptual Data Model, Logical Database Design and Physical Database Design.
- Learn about building blocks of Dimensional Modeling.
- Learn in-depth about Slowly Changing Dimensions.
- Learn about Snowflake, Outriggers, Hierarchy and Bridge Table.
- Learn about Transactions, Snapshots, and Accumulating Snapshots fact tables.
- Learn about Factless Fact Tables.
- Learn about Derived Schemas and Aggregates.
Section F: Advanced SQL
After completion of this module, you will be able to:
- Learn the basics of Database Management Systems.
- Learn Data Retrieval by SQL.
- Learn Calculations,Aliases and Functions
- Learn Sorting, Column-Based, Row-Based and Boolean Logic.
- Learn Inexact Matches like Pattern Matching & Matching by Sound.
- Learn How to Summarizing the Data.
- Learn about Inner Join, Outer Join and Self Join.
- Learn about Views.
- Learn about Set Logic and Subqueries.
- Learn how to Modify the Data.
- Learn Triggers.
- Learn Stored Procedures.
- Learn PL/SQL.
- Learn to Maintain the Tables.
- Learn Analytic Functions.
- Learn how to tune the SQL.
Section G: BI Tools
Advanced level Training on Business Intelligence and Data Warehousing Tools. A training will be provided on any of the following tools:
- Pentaho for ETL and Reporting
- SpagoBI for ETL and Reporting
- JasperSoft for Reporting
- BIRT for Reporting
- Talend for ETL
- QlikView for Reporting and Visualization
For current batches, the tool for training is Pentaho for ETL and Reporting both.
Course outline for Pentaho is as follows:
- Pentaho Introduction and Installation
- Introduction
- Installation
- Architecture
- Pentaho BI(CE vs. EE)
- Pentaho Data Integration(PDI)
- Pentaho Report Designer(PRD)
- Pentaho Metadata Editor(PME)
- Mondrian
- Pentaho Schema Workbench(PSW)
- Dashboard Capabilities
- Dealing with Repositories
- Creating Repository
- Repository Auto-Login
- Create a Connection to the DI Repository
- Deleting a Repository
- Managing Content in the DI Repository
- Dealing with ETL transformations
- Creating transformation
- Saving the Transformation
- Load Data into a Relational Database
- Retrieve Data from a Lookup File
- Various Input Steps, Various Output Steps & Transformation Steps
- Variable and Parameters
- Variable scope,Environment variables,Kettle variables,Internal variables,Setting the variables,Using the variables
- Creating parameters,Building the Parameter Query,filtering of report by using parameters
- Dealing with Jobs
- What is PDI-job, Entries, Job Orchestration & Logging
- Creating & Scheduling Jobs
- Running a job from file and repository
- Dealing with Databases
- Connecting to a database and extracting data,Changing the database connection at runtime
- Extracting data with the use of parameters
- Extracting data with query built at runtime
- Inserting or updating rows
- Deleting data
- Pentaho Reporting
- Introduction to Pentaho Reporting, Reporting architecture
- Report layout, Various Output Formats
- PRD Layout, Designing Basic Report Containing Graphical Chart and Conditional Formatting
- Data Source Connection, Query Designer, Working with Groups, Passing Parameter, Using Formula, Designing Report with Subreport
- Creating a report summary
- Previewing and saving the report
- Creating a report using different types of data sources
- Pentaho Dashboards, OLAP & Big Data
- Introduction to Pentaho Dashboards,Pentaho Dashboards Feature Details
- Introduction to Pentaho OLAP,Kettle OLAP Options
- Pentaho Big Data Overview
- Requirement Analysis
- Design
- Test planning/Test case preparation
- Coding/Development
- Unit Testing, System Testing
- Implementation
- Performance Tuning
- Retail
- Telecom
- Finance
- Banking
- Health Care
- Others
- Outstanding
- Very Good
- Good
- Average
- Unsatisfactory
- Outstanding
- Very Good
- Good
- Average
- Unsatisfactory
Section H: BI Project
An end to end BI/ETL project will be carried out. Project will be done on datasets similar to as used in the Industry. Project will include the following activities:
Project Problem will be picked from any of the domain below:
Project Assessment
Project assessment will be done by the Trainer and a grade will awarded based on the performance on project. Grading will be done on the scale of 1 to 5, 5 being the outstanding performance and 1 being the Unsatisfactory performance. Scale is as below:
Section I: Big Data (Hadoop) Project
In this module you will work on a Hadoop projects and get a first hand experience of Installing and running hadoop applications.
Project: An introduction to Hadoop with Hive and Pig
This project provides an introduction into working with big data in Hadoop and using HCatalog, Pig and Hive.
Project Assessment
Project assessment will be done by the Trainer and a grade will awarded based on the performance on project. Grading will be done on the scale of 1 to 5, 5 being the outstanding performance and 1 being the Unsatisfactory performance. Scale is as below:
Course Duration
Classroom sessions : 160 Hours
There will be daily classes conducted for the duration of two months. Each class will be of approximately four hours.Lab Work/Practicals : 80 Hours
Project work and Practicals to be completed during the course duration.
Course Work : 80 Hours
Study material of 80 hours or more will be given as a course work to be completed.
Exam : 1 Hour
A proctored exam of 1 hour will be conducted for final assessment.
Course Features
-
Classroom sessions
Live Classroom based Instructor Led classes. We give individual attention to every single learner. Case studies from real life projects.
-
Ongoing Research
Research team works hard to bring out the latest innovations and best practices of course subjects. Courses are evolving continuously; they never get stale.
-
Be More Productive
Get work related tips and perform your work more efficiently. Once you know the tricks of trade, you become more productive.
-
Industry Experts
Classes are conducted by Industry Experts. Learners gain from world class curriculum and extensive experiences of Trainers as well.
-
Learning Material
Learners get unlimited access to online and offline materials. Don't worry if you miss any class, we will be providing you a repeat class online or offline.
-
Learning Support
Learners are encouraged to ask online and offline questions. Our team of Trainers makes it a priority to answer these questions.
-
Money-back Guarantee
If you are not satisfied with the quality then take full refund within the seven days of first class. No questions will be asked.
-
Career Support
Learner's resume is reviewed and a one-to-one discussion is arranged with an expert to advice on career roadmap and job opportunities. For details, visit Career Centre
Certification
Certificate of Participation
A certificate of participation will be awarded after participating in the training program. The name of certificate is "BIWHIZ CERTIFICATE OF PARTICIPATION ON BUSINESS INTELLIGENCE PROFESSIONAL COURSE".
Certification after Completion
A certification will be issued after assessment of assignments, course work requirements, projects and a written test as per the course curriculum. After successfully completing all the requirements and passing the written test, a certification will be issued. The name of the certification is "BIWHIZ CERTIFIED BUSINESS INTELLIGENCE PROFESSIONAL".
Certificate Issuing Authority
BIWHIZ is part of the company "Business Intelligence Consultant and Services LLP". Certificates are issued by "Business Intelligence Consultant and Services LLP". This is a registered company with Ministry of Corporate Affairs, Government of India.
Sample Exam Questions
This sample is only for illustrative purpose and only basic level questions are displayed here. Actual exam questions may be completely different with different format as well. Please contact your coordinator to know more about prevailing exam format.
Fraud can be detected by?
- Logistic regression
- Naive Bayesian classifiers
- Anomaly detection algorithm
- Neural Networks
Best technique for Association Analysis?
- Bagging
- Apriori Algorithm
- Rule based classifier
- DBSCAN
Only Hadoop can handle Big Data?
- True
- False
- Yes, till so far
- Can't Say
Oozie is?
- Data Access Language
- Columnar Database
- Machine Learning Library
- Workflow scheduler
Correlated subqueries are used?
- To increase the performance
- For aggregation
- For data definition
- To increase the readability
What is MDM?
- Part of Datawarehouse
- Centralized database for Master lists
- An ETL process
- Source System
Not a delivery mechanism?
- Broadcast
- Scheduling
- Push
- Pull
What is the result of WHERE 1=0?
- Syntax Error
- Equivalent to Select *
- Returns No Rows
- Returns First Column
BI Development model?
- Agile
- Top Down
- Bottom Up
- Hub & Spoke
BI Projects are mission critical?
- Yes
- No
- Upto some extent
- Yes because they support decisions
What is Wrinkle of time?
- Data Change propagation strategy
- Expansion of Time dimension
- Summarization based on Time
- Removing Time dimension
ETL and Reporting can be parallel?
- Yes, because they are not dependent on each other
- Yes, because they connect to different databases
- No, because they are on same critical path
- No, because they are not dependent on each other
Frequently Asked Questions
-
Is this course for me? What value would it add to my career?
This course can help three types of learner. One- a person who is already working in non-BI industry and want to start a career in BI, Analytics, Big Data domain. Two- Freshers who are out of college and looking for a job oriented course which can give them the knowledge of hottest technologies. Three- a person who wants a fast track knowledge in advanced BI, Datawarehousing, Analytics, Big Data, Data Modeling, Dimensional Modeling and SQL.
-
Is it necessary to have any prior knowledge on BI and Data science?
No, as already mentioned, this course is for beginners.
-
What are the differences between Professional, Advanced and Master Certifications?
Professional course and certification is for Beginning learners. There is no single stand alone course for Advanced or Master Certifications but they are achieved by completing four courses or eight courses respectively from the list of eight Advanced courses we have.
-
What is the market value of BIWHIZ certifications?
Our course and certification creation process is based on Industry standards and best practices and there has been a major research done by BIWHIZ team to understand the exact market requirements. Courses are based on these real requirements and cater to the need of companies working in this space. These courses are validated by our Industry partners and there is a widespread acceptance for our courses in the Industry.
-
Why this course is classroom based, while most of your other courses are online?
Online courses are more suitable for a working person, a person who has got some experience, maybe not in the similar field but as they are groomed in the initial years of their career and most of them get an opportunity to interact with their co-workers remotely hence they get used to online meetings and virtual classrooms etc. However a person who is unaware of corporate culture and just starting his or her career might not feel comfortable in an online setup. Apart from technical learning they also need to learn the soft skills which plays a crucial role in finding a suitable job. We aim to give them not only the knowledge but also the skills to face work related challenges in a classroom setup.
-
Why Certification is included in the course?
This is to make sure that a learner has understood the course content and BIWHIZ has verified the knowledge level of the Learner. Certification is the proof that you have achieved a certain level of expertise on course and any authorized organization can verify that with us.
-
What if I am not able to clear the Certification exam in first attempt?
You can take extra attempts for free.
-
What is the learning support and would it be available after completing the course as well?
You can raise your queries and doubts during and post training period. All queries will be resolved by Industry experts.
-
Do you help in career related issues as well, like reviewing resume, mentoring for my career growth?
Yes, we have a panel of Industry experts who will guide and mentor you; please check Career Centre for more details.
-
Will you sell my data to Recruitment/marketing companies or will you use it for Recruitment or any other activities not related with Training?
NO, Never. Your details are highly confidential and safe with us. But If you are willing to accept any such calls then you can inform us in advance with a specific need and we will contact only for those specific requirements. For a detailed privacy policy please check Terms, Conditions & Privacy Policy.
Register Here
Please register for this course here. Even if you are not ready to Enroll now, you can register now and get an intimation about our next batch whenever it is starting.