Logical arrangement with systematic representation of the data can help guide deeper into business processes and other related operations of an enterprise.Slice and dice, cross tabulations, data pivots, data transpose can all lead to interesting facts using pixel perfect data visualization tools.Data analysis typically deals with data acquisition, data unions, create high level dimensions, natural or custom hierarchies.

Training Methodology Steps

  • Modes

    Defined in two modes
    -Online
    -Classroom

  • Experiment Learning

    Comprehensive hands on program giving you the utmost confidence you need to be better competent.

  • Reinforcement

    Periodic evaluation and assessment will help you stay aligned and forward.

  • Technology Compliant

    Our Learning Management System will help you access resources you need in pursuit of your learnings.

Course Curriculum

Week 1 - 8hrs

- An introduction to data analysis.
- Types of data analysis.
- What are data structure.
- Migrating from excel to data analysis tools.
- What different tools are available and similarity between them.
- Data analysis pipeline lifecycle.
- Looking at the dataset to understand the structure.
- Single table or multi-table.
- Understand relations and joins between tables.
- Merge data/Data union and Datablending.
- Normalized and Denormalized data.
- Model building/understand attributes of data.
- Data filters/Parameters to restrict data.
- Understand SQL and its usage in data analysis.

Week 2 - 8hrs

- Extraction to file based data to faster analysis.
- Advantages and disadvantages of file based extracts.
- Metadata management/creating new dimensions.
- Metadata management/creating new measures.
- Changing datatypes and assigning new type.
- Calculated fields to create custom fields.
- Adding several datasources to model.
- Introduction to various types of charting.
- Understand expressions and its usage.
- Types of expressions in data analysis.
- Create basic dashboard to analysis sales.
- What are crosstabs and data pivots.
- Working with detailed data.
- Data aggegation/functions to aggregate.
- Sorting and arranging the data.

Week 3 - 8hrs

- What is data grouping.?
- Difference between datasets and datagroups.
- Example on sales dashboard.
- Understand datasets involved in analysis.
- Guided analysis and drilldowns.
- Sorting data based and top and bottom performers.
- Understand nested sorts.
- Apply basic filters.
- Apply context filters.
- Working with parameters to analyse the data.
- Difference between filters and parameters.
- Understand table calculations in data analysis.

Week 4 - 8hrs

- Understand line of references.
- Create maps in dashboard.
- Use default or custom geocodes in maps.
- Understand detail and advanced calculations.
- Understand top N and bottom N analysis.
- Advanced calculations.
- What are SETS in Data.
- What is data binning and histograms.
- Forecast,Trendline and Statistics.
- Publishing and deployment to users.

Technologies Used

Our Approach

Practical Coverage

Focus on foundation and fundamentals.

Work toward specific or predefined business problems.

Create data stories to conduct meaningful analysis.

Total hands-on for a better exposure and experience.

Delivery Methods

Online

Learn the technology backed with comprehensive Learning Management System.

Classroom

Access to more interactive sessions.

Want to Know More About Our Data Analysis Program

Contact Us

FAQS