Getting Started with Excel Understanding the Excel Interface Understanding the Menu System Understanding the Quick Access Toolbar Understanding Workbooks and Worksheets Understanding the Formula Bar Understanding the Status Bar Understanding the Navigation System of Excel Using shortcut menus and the Mini toolbar Creating new workbooks Using Save and Save as Data Generation Techniques Exploring Data Entry and Editing Techniques Entering Data with Autofill Understanding Undo and Redo Adding Comments Flash Fill Data Working on Formulas and Functions Creating Simple Formulas Copying Formulas to Adjacent Cells Working with Relative, Absolute and Mixed Referencing Using Sum and Average Using Text Functions Using Date Functions Using Lookup Functions Using Conditional Functions Using Logical Functions Data Formatting and Presentation Basic Cell Formatting Data and Table Formatting Exploring Font Styles and Effects Adjusting Row Heights and Columns Working with alignment and Wrap Text Working with Borders Using conditional formatting Creating and using tables Data Filtering and Management Filtering Data using Data Filter Advanced Filtering Techniques Organizing Data using Data Sort Custom Sorting Techniques Working With Pivot Tables Creating a Branch wise and opened by Pivot Creating a Date Wise Pivot Creating a Count of Account Types Pivot Creating a Graph out of Pivot Data

Data Transformations : Introduction to Power BI Desktop Changing Locale Connecting to a Database Basic Transformations Managing Query Groups Splitting Columns, Changing Data Types, Working with Dates Removing and Reordering Columns Conditional Columns Merge Queries Query Dependency View Transforming Less Structured Data Query Parameters Data Modelling : Managing Data Relationships Creating Calculated Columns Optimizing Models for Reporting Creating Calculated Measures Creating and Managing Hierarchies Using Calculated Tables Time Intelligence Include and Exclude features Grouping and Binning Visualizing your Data : Introduction to charts: Pie, Tree map, Combo charts, Map Visualizations, Scatter plot, Table, Matrix, Gauge, Card, Shapes, Textboxes, Images and KPI Filter (Including TopN), Date Slicer Coloring Charts Page Layout, Positioning, Aligning, Sorting Visuals and Formatting Visual Relationship Custom Hierarchies Working with PBI Service : Overview of Dashboards and Service Uploading to Power BI Service Configuring a Dashboard Dashboard Settings In-Focus Mode Pinning a Live Page Custom URL and Title Export to CSV and Excel Power BI Notifications Publishing to Web Working with Excel : Importing Excel Data using Simple Table Connecting to Excel Workbook on OneDrive for Business Pinning Excel Tables or Visuals Organization Packs, Security and Groups : Creating a Group Creating, Using and Editing a Content Pack Row Level Security Data Classification Creating and Using Custom Visuals

Data Analytics Combo

Featured Review

5.0 (2190 Ratings)

Data Analytics combo typically refers to the strategic combination of various data analytics tools, techniques, and technologies to derive valuable insights and make informed decisions from data. Data analytics involves the systematic analysis of data to uncover patterns, trends, and actionable insights.A Data Analytics combo involves using the appropriate combination of these methods and tools to extract valuable insights from data, whether it’s for business intelligence, marketing analysis, scientific research, or any other domain

0 +

Google Reviews

0 +

JustDial Reviews

Overview

The Syllabus

Curriculum Designed by Experts

ORACLE 12C SQL

SQL Basic

WEEK – 1 :

1] Introduction to Oracle DB 12c

Oracle Database 12c: Focus Areas, Fusion Middle-ware, Oracle Cloud, Services, Deployment Methods, RDBMS, Data Model, ER Diagram, Relation DB Terminology, SQL Statements and Development Environment, HR Schema Tables, DB Documentation.

2] Retrieving Data using SQL SELECT statement

Basic Select Statement, Arithmetic Expression, Defining Null values, Concatenation Operator & Literal, Duplicate Rows, Displaying table structure. Practice Overview.

3] Restricting & Sorting Data

Use of Where clause, Character Strings & Date Data, Comparison, Logical, Range, Pattern, & Other operators, Rules Precedence, Order By Clause, Substitution variables. Practice Overview

WEEK – 2 :

4] Single Row Function & Customized Output

SQL function, Single Row Function, Character/Case Functions, Number Functions, Nesting Function, Date Functions etc. Practice Overview.

5] Conversion & Conditional Expressions

Conversion Function, Implicit/Explicit Data Conversion, General Function with covering NVL, NVL2, NULLIF, COALESCE, Conditional Expression with Decode function and Case Expression. Practice Overview.

6] Reporting Aggregated Data using Group Function

Usages of Group function, Nesting Group Function, Creating Group Data, Restricting group data using Having Clause. Practice Overview.

7] Displaying Data from Multiple Tables using Join

Type of Joins, Explaining with Natural Join, Using Clause, On Clause, SQL 99 Syntax, Three-Way Join, Self Join, NonEqui Join, Inner Versus Outer Join, Cross Join etc. Practice overview.

WEEK – 3 :

8] Using Sub-queries to solve queries

Scenario to use Sub-query, Rules for Sub-queries, Type of Sub-queries, Single Row Sub-queries and Multi Row Sub-queries. Null value in Sub-query etc. Practice Overview.

SQL Advanced :

9] Using Set Operator

Set Operator Rules, Covering Set Operator as UNION, UNION ALL, INTERSECT, MINUS etc. Practice Overview.

10] Managing Tables using DML Statements

Data Manipulation Language, Covering INSERT, UPDATE, DELETE & DB Transaction control using COMMIT, ROLLBACK, SAVEPOINT. Use of For update clause in SELECT Statement.

11] Introduction to Data Definition Language

Database Object, Naming Rules, Various Data Types, CREATE TABLE statement, Constraint guidelines, Defining constraints as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY & CHECK etc. ALTER TABLE, DROP TABLE Statement. Create Table using Sub-query. Practice Overview.

WEEK – 4 :

12] Introduction to Data Dictionary Views

Data Dictionary Structure, How to use Data Dictionary, USER_OBJECTS, ALL_OBJECT, USER_CONSTRAININTS. TABLE Information, Column Information etc. Practice overview.

13] Creating Sequence, Synonyms & Indexes

Importance of Sequence, Synonyms & Indexes. Defining Sequence, Synonyms & Indexes & DROP statement etc. Practice overview.

14] Creating Views

What’s View? Advantage of Views, CRETAE Simple & Complex views, Rules for performing DML operation on views. Modifying & Removing a view etc. Practice Overview.

15] Retrieving Data by using Sub-Query

Multiple Column Sub-query, Column Comparison, Pair & Non Pair Sub-queries, Scalar Sub queries, Co-related Sub-queries, Use of WITH clause. Practice Overview.

ADVANCED EXCEL

Getting Started with Excel

Understanding the Excel Interface
Understanding the Menu System
Understanding the Quick Access Toolbar
Understanding Workbooks and Worksheets
Understanding the Formula Bar
Understanding the Status Bar
Understanding the Navigation System of Excel
Using shortcut menus and the Mini toolbar
Creating new workbooks
Using Save and Save as

Data Generation Techniques

Exploring Data Entry and Editing Techniques
Entering Data with Autofill
Understanding Undo and Redo
Adding Comments
Flash Fill Data

Working on Formulas and Functions

Creating Simple Formulas
Copying Formulas to Adjacent Cells
Working with Relative, Absolute and Mixed Referencing
Using Sum and Average
Using Text Functions
Using Date Functions
Using Lookup Functions
Using Conditional Functions
Using Logical Functions

Data Formatting and Presentation

Basic Cell Formatting
Data and Table Formatting
Exploring Font Styles and Effects
Adjusting Row Heights and Columns
Working with alignment and Wrap Text
Working with Borders
Using conditional formatting
Creating and using tables

Data Filtering and Management

Filtering Data using Data Filter
Advanced Filtering Techniques
Organizing Data using Data Sort
Custom Sorting Techniques

Working With Pivot Tables

Creating a Branch wise and opened by Pivot
Creating a Date Wise Pivot
Creating a Count of Account Types Pivot
Creating a Graph out of Pivot Data

PYTHON FOR DATA ANALYST

Introduction to Python programming

Variables, data types, operators, and expressions
Control structures (if/else, loops)
Functions, modules, and packages
Data structures in Python
Lists, tuples, dictionaries, and sets
Indexing, slicing, and manipulating data structures

Python for data analysis

Reading and writing data from various formats (CSV, Excel, JSON, SQL)
Exploratory data analysis with Pandas library
Cleaning, transforming, and aggregating data

Predictive modeling and machine learning algorithms

Visualizing data with Matplotlib and Seaborn

evaluation and selection
Working with time series data
Case studies and projects
Analyzing real-world datasets and solving data-related problems
Developing data-driven insights and recommendations.

POWER BI

Data Transformations :

Introduction to Power BI Desktop
Changing Locale
Connecting to a Database
Basic Transformations
Managing Query Groups
Splitting Columns, Changing Data Types, Working with Dates
Removing and Reordering Columns
Conditional Columns
Merge Queries
Query Dependency View
Transforming Less Structured Data
Query Parameters

Data Modelling :

Managing Data Relationships
Creating Calculated Columns
Optimizing Models for Reporting
Creating Calculated Measures
Creating and Managing Hierarchies
Using Calculated Tables
Time Intelligence
Include and Exclude features
Grouping and Binning

Visualizing your Data :

Introduction to charts: Pie, Tree map, Combo charts, Map Visualizations, Scatter plot, Table, Matrix, Gauge, Card, Shapes, Textboxes, Images and KPI
Filter (Including TopN), Date Slicer
Coloring Charts
Page Layout, Positioning, Aligning, Sorting Visuals and Formatting
Visual Relationship
Custom Hierarchies

Working with PBI Service :

Overview of Dashboards and Service
Uploading to Power BI Service
Configuring a Dashboard
Dashboard Settings
In-Focus Mode
Pinning a Live Page
Custom URL and Title
Export to CSV and Excel
Power BI Notifications
Publishing to Web

Working with Excel :

Importing Excel Data using Simple Table
Connecting to Excel Workbook on OneDrive for Business
Pinning Excel Tables or Visuals

Organization Packs, Security and Groups :

Creating a Group
Creating, Using and Editing a Content Pack
Row Level Security
Data Classification
Creating and Using Custom Visuals

Enquire Now

Why Radical Technologies

Live Online Training

Highly practical oriented training

Installation of Software On your System

24/7 Email and Phone Support

100% Placement Assistance until you get placed

Global Certification Preparation

Trainer Student Interactive Portal

Assignments and Projects Guided by Mentors

And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Live Classroom Training

Weekend / Weekdays / Morning / Evening Batches

80:20 Practical and Theory Ratio

Real-life Case Studies

Easy Coverup if you missed any sessions

PSI | Kryterion | Redhat Test Centers

Life Time Video Classroom Access ( coming soon )

Resume Preparations and Mock Interviews

And Many More Features

Course completion certificate and Global Certifications are part of our all Master Program

Self Paced Training

Self Paced Learning

Learn 300+ Courses at Your Own Time

50000+ Satisfied Learners

Course Completion Certificate

Practical Labs Available

Mentor Support Available

Doubt Clearing Session Available

Attend Our Virtual Job Fair

10% Discounted Global Certification

Course completion certificate and Global Certifications are part of our all Master Program

Like the Curriculum ? Let's Get Started

Global Certification

Radical Technologies is the leading IT certification institute in Kochi, offering a wide range of globally recognized certifications across various domains. With expert trainers and comprehensive course materials, it ensures that students gain in-depth knowledge and hands-on experience to excel in their careers. The institute’s certification programs are tailored to meet industry standards, helping professionals enhance their skillsets and boost their career prospects. From cloud technologies to data science, Radical Technologies covers it all, empowering individuals to stay ahead in the ever-evolving tech landscape. Achieve your professional goals with certifications that matter.

Upcoming BATCHES

Live Classes from IIT Faculty & Industry Experts
Certification from IHUB IIT Roorkee
Career Services (Mock Interviews, Resume Preparation)
Placement Assistance upon clearing PRT
Dedicated Learning Manage

Discount Voucher

"Register Now to Secure Your Spot in Our Featured Course !"

BOOK HERE

career services

Job Assistance
Interview Preparation
Profile Buliding

At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalized resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career. Join us and let your journey to a successful future begin with the right support.

At Radical Technologies, we ensure you’re ready to shine in any interview. Our comprehensive Interview Preparation program includes mock interviews, expert feedback, and tailored coaching sessions to build your confidence. Learn how to effectively communicate your skills, handle technical questions, and make a lasting impression on potential employers. With our guidance, you’ll walk into your interviews prepared and poised for success.

At Radical Technologies, we believe that a strong professional profile is key to standing out in the competitive IT industry. Our Profile Building services are designed to highlight your unique skills and experiences, crafting a resume and LinkedIn profile that resonate with employers. From tailored advice on showcasing your strengths to tips on optimizing your online presence, we provide the tools you need to make a lasting impression. Let us help you build a profile that opens doors to your dream career.

Radical Learning Eco-System

Exam simulator

Cloud Send Borey

Hands - on Cloud Lab

Developer Coding Ground

Testimonials

Play

Our Alumni

Online Batches Available for the Areas

Data Analytics Combo Course Certification With Training In Kochi

Q: PYTHON FOR DATA ANALYST

Introduction to Python programming Variables, data types, operators, and expressions Control structures (if/else, loops) Functions, modules, and packages Data structures in Python Lists, tuples, dictionaries, and sets Indexing, slicing, and manipulating data structures Python for data analysis Reading and writing data from various formats (CSV, Excel, JSON, SQL) Exploratory data analysis with Pandas library Cleaning, transforming, and aggregating data Predictive modeling and machine learning algorithms Visualizing data with Matplotlib and Seaborn evaluation and selection Working with time series data Case studies and projects Analyzing real-world datasets and solving data-related problems Developing data-driven insights and recommendations.

At Radical Technologies, we are committed to providing world-class Azure Data Engineer Training in Bangalore, helping aspiring data professionals master the skills needed to excel in the rapidly growing field of cloud data engineering. As the leading institute for Azure Data Engineer Course In Bangalore, we offer comprehensive, hands-on training designed to meet the demands of today’s data-driven organizations.

Our Azure Data Engineer Training Bangalore program covers every aspect of the Azure Data Engineer Syllabus, ensuring that students receive in-depth knowledge of data architecture, data processing, and data storage on Microsoft Azure. Whether you prefer attending classes in-person or via Azure Data Engineer Online Training, Radical Technologies provides flexible learning options to suit your needs.

Our Azure Data Engineering Training is renowned for its practical, real-world approach. Students have access to an industry-leading Azure Data Engineer Bootcamp, which combines theory and hands-on labs to ensure they are fully prepared for their certification exams. The Microsoft Azure Data Engineer Training is tailored to cover all key topics, from data integration to security, and is led by experienced professionals who are experts in their field.

For professionals and organizations seeking Azure Data Engineering Corporate Training, we offer tailored courses that address specific business needs. Our Azure Data Engineering Corporate Training Course ensures that teams gain practical experience in building scalable, secure, and efficient data solutions on Azure.

At Radical Technologies, our Azure Data Engineer Courses are structured to ensure that both beginners and experienced professionals alike can enhance their knowledge. The Azure Data Engineer Certification Training offered here equips students with the skills and credentials needed to stand out in a competitive job market.

Our institute also offers the Azure Data Engineer Full Course, which provides a comprehensive pathway for mastering Azure Data Engineering concepts and techniques. We take pride in being one of the top Azure Data Engineer Institutes in Bangalore, with a proven track record of helping students achieve their Azure Data Engineering Certification.

Whether you are looking for Azure Data Engineer Training Online or prefer our in-person classes in Bangalore, Radical Technologies is your trusted partner for career advancement in data engineering. Join us today to enroll in the Best Azure Data Engineer Course and kick-start your journey towards becoming a certified data engineer.