Data Analysis

Course Detail

Know how information is utilized to further develop continuous independent direction. Hero Technology Inc Information Investigation and Progressed Succeed course is a significant expansion to your tech information. Perform profound examination on information, get preferable bits of knowledge over ever, and go with information driven choices, presently!

Course Syllabus

1.1. Introduction
1.1.1. Database Study
1.1.2. Database Design
1.1.3. Implementation and loading
1.1.4. Testing and evaluation
1.1.5. Operation
1.1.6. Maintenance and evolution

1.2.1. What are the roles of Database Analyst
1.2.2. Difference between Business Analyst and Database Analyst

1.3.1. What Is a Data Warehouse?
1.3.2. Data Mart
1.3.3. Operational Data Stores
1.3.4. Characteristics of a Data Warehouse
1.3.5. Differences between Database and Data warehouse and Data Mart and ODS
1.3.6. OLTP Vs OLAP Vs DataMart Vs ODS
1.3.7. Uses and benefits of an ODS
1.3.8. ODS and Data Warehouse Design
1.3.9. OLTP v/s OLAP
1.3.10. Data Warehouse Architecture

1.4.1. Conceptual
1.4.2. Logical
1.4.3. Physical

1.6.1. Anamolies
1.6.2. 1st Normal Form
1.6.3. 2nd Normal Form
1.6.4. 3rd Normal Form

1.7.1. 5 Challenges of Working with Subject Matter Experts
1.7.2. Easy tips to work with the SMEs

Data profiling, Data cleansing

2.1. Evolution of the Database

2.2.1. Create table
2.2.2. Truncate
2.2.3. Drop Table

2.3.1. Insert
2.3.2. Update
2.3.3. Delete

2.4.1. Select Query

2.5.1. Where
2.5.2. Like
2.5.3. Order by
2.5.4. Group by
2.5.5. Having
2.5.6. Distinct

2.6.1. Aggregate Functions
2.6.1.1. Count
2.6.1.2. Max
2.6.1.3. Min
2.6.1.4. Sum
2.6.1.5. Avg

2.6.2. String Functions
2.6.2.1. Length
2.6.2.2. Lower
2.6.2.3. Upper
2.6.2.4. Ltrim
2.6.2.5. Rtrim
2.6.2.6. Reverse
2.6.2.7. Replace

2.6.3. Mescelaneous Functions
2.6.3.1. Coalesce
2.6.3.2. Nullif

2.7.1. Not null
2.7.2. Default
2.7.3. Unique
2.7.4. Primary Key
2.7.5. Foreign Key
2.7.6. Check

2.8.1. Inner join
2.8.2. Left Outer join
2.8.3. Right Outer join
2.8.4. Full Outer join
2.8.5. Self join

3.1. Business Requirement Document
3.2. Report Requirement Document
3.3. Test Case Document
3.4. Mapping Document

4.1. Aggregate
4.2. Character Map
4.3. Conditional Split without Default
4.4. Conditional Split with Default
4.5. Derived Column
4.6. Sort
4.7. Merge join

5.1. Aggregate
5.2. Character Map
5.3. Conditional Split without Default
5.4. Conditional Split with Default
5.5. Derived Column
5.6. Sort
5.7. Merge Join

6.1. Overview
6.2. Architecture
6.3. Data source connections
6.4. Joining between the tables
6.5. Measures and dimensions
6.6. Different types of charts
6.7. Filters
6.8. Groups
6.9. Sets
6.10. Parameters
6.11. Dashboards
6.12. Story Points
6.13. Super Store Workbook
6.14. World Indicator Workbook

Interview Preparation

Course FAQs

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.

The trainer is a certified consultant and has significant amount of experience in working with the technology.

Yes, we accept payments in two installments.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.

Course Testimonials

Meghna Das

It's very difficult to trust an online training programme as you don't know about the quality of skills that they offer. But, gladly Hero Technoly Inc don't compromise with the quality and instructors explain every detail with enthusiasm.

Prerana Moghe

You can't make a better decision than choosing Hero Technology Inc to gain the knowledge of Data Analytics. They will make your learning experience so smooth and soothing.

Rubina Sikhrakar

My journey with Hero Technology Inc has been a delight. They focus on the development of an individual's interpersonal skills (that is an extra gain) along with giving the subject knowledge.