Advanced Certification In

Data analytics

Opine Group is engaged in all activities related to Business Intelligence and Data Analytics. We work on complex projects and take up corporate consultancy assignments that require deep understanding of operations related data and it’s interpretation using various BI tools. To complement these activities, we have set up a School of Analytics. It provides industry- relevant training covering different aspects of BI and Analytics.
0
Months Duration
0 + Years
Trainer's Experience

Advanced Certification In

Data analytics

Opine Group is engaged in all activities related to Business Intelligence and Data Analytics. We work on complex projects and take up corporate consultancy assignments that require deep understanding of operations related data and it’s interpretation using various BI tools. To complement these activities, we have set up a School of Analytics. It provides industry- relevant training covering different aspects of BI and Analytics.
0
Months Duration
0 + Years
Trainer's Experience

Data Analytics Course Content

Fundamentals Of Analytics

Excel Analytics

SQL Server

Power BI

ETL (Extract Transform Load)

Communication Gym Membership

Data Analytics Course Review

pratiksha ghube
pratiksha ghube
Very good courses for beginners. And faculty was teaching friendly to the students. Specially thanks to kedar sir for sharing knowledge and experience with us
Aasavari Thakar
Aasavari Thakar
Learning at Opine Group has been an excellent experience. The staff is very friendly and helps you in every step of the way. It is an exceptional institute for learning about various tools of data analysis
Abhishek Thombare
Abhishek Thombare
One stop solution who wants to start their career into Data Analytics field.
Dhanesh Vadnerkar
Dhanesh Vadnerkar
It was a great learning experience and we really enjoyed the training
soham gokhale
soham gokhale
I attended a foundations course here. The teaching was fantastic and very close to actual work. The teachers are very experienced working professionals, which adds to the learning experience.
Vijayraj More
Vijayraj More
Very good courses for beginners. And faculty was teaching friendly to the students. Specially thanks to Anand Sir for sharing knowledge and experience with us
Rohit pampatwar
Rohit pampatwar
Teaching skill is good and really we took industrial experience from here
Avinash Patil
Avinash Patil
I joined opine group for SQL class. Inspite of being from non-it background, Shubhangi mam has taught SQL effectively. As the class has all concepts from basic, it is an easy learning experience for everyone.

LEARNING PATH

KNOW MORE ABOUT

THE PROGRAM

This Data Analytics advanced certification course led by the Opine Group, faculty aims at helping you master all the basic and advanced level skills that are crucial in the field of Data Analytics, Business Intelligence and Analytics.

Let’s walk through your journey at OPINE GROUP

• Business Intelligence & Data Warehouse concepts
      • Introduction to Business Intelligence – what, where and
        how?
      • Need for Business Intelligence / Analytics

• BI /DW Lifecycle
      • Real life based exercises to understand BI phases

• Requirements gathering
      • Analytics and Approach for Solution Design

• Data Modeling (Dimensional)
      • Dimensional Modeling Process and Scenario based model
        designing

• Real time hands on work to understand Data Visualization

• Analytics Demo
      • Real life demo

• Career Opportunities discussion and guidance
      • Open discussion
      • Steps to be carried out
          • Short Term
          • Long Term

• Fundamentals and Excel interface
      • Introduction to analytics, Organizational structure,
        Concepts of OLTP, OLAP, Normalization, De-normalization,
        Primary Key, Dimensions, Facts, Factless fact Foreign Key,
        VLookup, Ribbon Tabs, Formatting features, Speak Cells,
        Quick Access toolbar.

• Charts
      • Basic chart, Series, Combination charts, Dynamic chart
        ranges with Excel tables, Histogram, Treemap chart,
        Sunburst, Pie and Doughnut charts, Sparklines, Use of
        dashboard

• Pivoting
      • Pivoting – Pivot tables, Slicers and Timelines, Creating
        Pivot charts

• Excel features / Data quality
      • Auto Fill, Flash Fill, Fill Series, Use of
        formula, Recognizing formula and input cells, Adding note
        / comment, Creating custom list, Data Validation, Screen
        Tip and few shortcuts, Assignment, Excel shortcuts for
        navigation, Copying, Moving and Hiding Worksheets,
        Freeze panes and split screen, Hide and unhide, Insert and
        adjust columns and rows, Copying and pasting data

• Data Protection
      • Protecting Worksheets and specific ranges, Assignment,
        Order of precedence, Simple formulae, Excel’s Essential
        rule, Absolute and Relative referencing. 

• Excel functions
      • Range names for clarity, Referencing other Workbooks or
        Worksheets, Circular references, Combine values from two
        or more cells to one cell, Assignments, Functions like
        COUNT, COUNTA, COUNTBLANK, COUNTIFS, SUM,
        AVERAGE, SUMIFS, AVERAGEIFS, MAX and MIN (Include by
        criteria), Basic DATE functions, Time calculations.

• Data population and error handling
      • Handling formulae errors, Different types of errors, IF
        (then, else) function, VLOOKUP function, Assignment, Sort,
        Unsort, Subtotal, Filter, Remove blank cells, Fill empty cells,
        Conditional formatting. 

• Automation
      • Macro Introduction

• Conclusion
      • Project

• RDBMS
      • What is RDBMS?
      • Basic concepts of RDBMS
      • Different data types
      • KEYS concepts

• SQL Basic
      • Introduction SQL (Structured Query Language)
      • Fundamentals of SQL
      • SQL Tables, Joins, Variables

• SQL Advance
      • SQL Functions, Subqueries, Views, Rules
      • Condition based queries using various operator
      • Data Modeling
      • Different type of joins (Basic, Advance)
      • Aggregate Function
      • Windows Functions
      • Use of CTE (Common table expression) with practice
      • Hands on exercise on live projects

• Introduction to BI and need for visualization
      • BI life cycle
      • What is analysis
      • Importance of data visualization to the industry

Introduction to Power BI
      • Installation
      • Connecting to the data source
      • Elements of report windows

• Creating Visualization
      • Creating visualization such as column charts, line charts,
        pie charts, table, matrix and many more
      • Formatting the charts
      • Grouping and binning (Creating histogram)

• Filtering the data
      • Types of filters (Visualization level, page level, across page)
      • Slicers
      • Base, Advance and Limiting filters
      • Concept of internal (context) filters and internal filters

• Transformation using Dax and modeling
      • Data transformation using Dax
      • Creating new relationship
      • Create new tables in Dax
      • Creating Measures and columns in Dax

• Navigation
      • Creating dashboard pages
      • Using Hierarchies for Drill Down navigation
      • Creating drill through across pages
      • Data refresh and scheduling

• Advanced transformations
• Data cleansing techniques
• Full Load and Incremental Load
• Standard tasks
• Container tasks
• Data profiling and testing techniques
• Deployment and job scheduling

• Learn to communicate effectively in English through various
  activities.

• Business Intelligence & Data
  Warehouse concepts

      • Introduction to Business
        Intelligence – what, where and
        how?
      • Need for Business Intelligence /
        Analytics

• BI /DW Lifecycle
      • Real life based exercises to
        understand BI phases

• Requirements gathering
      • Analytics and Approach for
        Solution Design

• Data Modeling (Dimensional)
      • Dimensional Modeling Process
        and Scenario based model
        designing

• Real time hands on work to
  understand Data Visualization

• Analytics Demo
      • Real life demo

• Career Opportunities discussion
  and guidance

      • Open discussion
      • Steps to be carried out
          • Short Term
          • Long Term

• Fundamentals and Excel interface
      • Introduction to analytics,
        Organizational structure,
        Concepts of OLTP, OLAP,
        Normalization, De-normalization,
        Primary Key, Dimensions, Facts,
        Factless fact Foreign Key,
        VLookup, Ribbon Tabs, Formatting
        features, Speak Cells,
        Quick Access toolbar.

• Charts
      • Basic chart, Series, Combination
        charts, Dynamic chart ranges with
        Excel tables, Histogram, Treemap
        chart, Sunburst, Pie and Doughnut
        charts, Sparklines, Use of
        dashboard

• Pivoting
      • Pivoting – Pivot tables, Slicers and
        Timelines, Creating Pivot charts

• Excel features / Data quality
      • Auto Fill, Flash Fill, Fill Series, Use of
        formula, Recognizing formula and
        input cells, Adding note /
        comment, Creating custom list,
        Data Validation, Screen Tip and few
        shortcuts, Assignment, Excel
        shortcuts for navigation, Copying,
        Moving and Hiding Worksheets,
        Freeze panes and split screen, Hide
        and unhide, Insert and adjust
        columns and rows, Copying and
        pasting data

• Data Protection
      • Protecting Worksheets and
        specific ranges, Assignment,
        Order of precedence, Simple
        formulae, Excel’s Essential
        rule, Absolute and Relative
        referencing. 

• Excel functions
      • Range names for clarity,
        Referencing other Workbooks or
        Worksheets, Circular references,
        Combine values from two or more
        cells to one cell, Assignments,
        Functions like COUNT, COUNTA,
        COUNTBLANK, COUNTIFS, SUM,
        AVERAGE, SUMIFS, AVERAGEIFS,
        MAX and MIN (Include by criteria),
        Basic DATE functions, Time
        calculations.

• Data population and error handling
      • Handling formulae errors, Different
        types of errors, IF (then, else)
        function, VLOOKUP function,
        Assignment, Sort, Unsort, Subtotal,
        Filter, Remove blank cells, Fill
        empty cells, Conditional
        formatting. 

• Automation
      • Macro Introduction

• Conclusion
      • Project

• RDBMS
      • What is RDBMS?
      • Basic concepts of RDBMS
      • Different data types
      • KEYS concepts

• SQL Basic
      • Introduction SQL (Structured
        Query Language)
      • Fundamentals of SQL
      • SQL Tables, Joins, Variables

• SQL Advance
      • SQL Functions, Subqueries, Views,
        Rules
      • Condition based queries using
        various operator
      • Data Modeling
      • Different type of joins (Basic,
        Advance)
      • Aggregate Function
      • Windows Functions
      • Use of CTE (Common table
        expression) with practice
      • Hands on exercise on live projects

• Introduction to BI and need for
  visualization

      • BI life cycle
      • What is analysis
      • Importance of data visualization to
        the industry

Introduction to Power BI
      • Installation
      • Connecting to the data source
      • Elements of report windows

• Creating Visualization
      • Creating visualization such as
        column charts, line charts, pie
        charts, table, matrix and many
        more
      • Formatting the charts
      • Grouping and binning (Creating
        histogram)

• Filtering the data
      • Types of filters (Visualization level,
        page level, across page)
      • Slicers
      • Base, Advance and Limiting filters
      • Concept of internal (context) filters
        and internal filters

• Transformation using Dax and modeling
      • Data transformation using Dax
      • Creating new relationship
      • Create new tables in Dax
      • Creating Measures and columns in
        Dax

• Navigation
      • Creating dashboard pages
      • Using Hierarchies for Drill Down
        navigation
      • Creating drill through across pages
      • Data refresh and scheduling

• Advanced transformations
• Data cleansing techniques
• Full Load and Incremental Load
• Standard tasks
• Container tasks
• Data profiling and testing techniques
• Deployment and job scheduling

• Learn to communicate effectively in
  English through various activities.

Our Alumni works at

meet your mentors

Dr. Anand Kolharkar

30+ years of Industry Experience. Headed BI practice for IT companies. Nurtured and developed BI teams in different domains like Banking, Manufacturing, Chemical & Pharma to name a few. Worked with leading Indian and Multi-National brands. Conducted more than thousand hours of training in Corporate and Management Institutes.

Mr. Kedar Puranik

Over 30+ years of experience in multi-client, multi location delivery units. Experience in multiple solution areas including ERP, CRM, Business Intelligence & Analytics, DW, MDM, etc. Led large offshore teams and managed end-to-end delivery for global clients. Strong technology expertise in Oracle, SAP, MS-BI, Informatica, Power BI and Tableau

Mrs. Shubhangi Patni

28+ years of experience. Hands on experience on several technologies related to reporting and Data Analytics. Conducted training sessions for corporate and management institutions. Actively involved in creating working professionals through several training sessions.

Mr. Shirish Kulkarni

32+ years of experience in IT industry in various areas from development to support and maintenance projects to quality. Has worked with domestic as well as international clients. Consultation to profit organization as well as non-profit organization. Providing training in data analysis tools and techniques.

Mrs. Rashmi Tilak

28+ years of teaching experience in various colleges. Trained students of the educational institutes and guided students undergoing courses such as MCA, BBA (IB), BBA (CA) and BBA. Managed projects in IT organizations. Coordination with educational institution and Businesses for work force creation.

why opine ?

We are a group of senior Business Intelligence experts with the passion and definite objective to leverage the ever-expanding base of data and drive ‘change’ in every sphere using Business Intelligence.

With knowledge precipitated from the data, we use Business Intelligence and Analytics to enable intelligent, timely and actionable decisions and deliver greater value from same resources for you

14 YEARS experience

We are decade old organization working in BI space having combination of junior and senior BI experts.

Empowering the users

Extensive user training to demonstrate the potential of BI, earn their Buy-in and drive improvement

Our Unique Methodology

– Concept First
– Practioner Aproach
– Personalized
– Industry Centric

Register for A free counselling session