Radical Technologies | Best IT Training Institute in Pune, India
Call :+91 8055223360

DATA ANALYTICS (SQL + Advanced XL + Python For Data Analyst + Power BI )

DATA ANALYST – COMBO (SQL + Advanced XL + Python ONLINE TRAINING

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

1224 Satisfied Learners

Job Oriented Course for Data Analytics

Technologies Included in Data Analytics Course:-

  • Oracle SQL 
  • Advanced XL 
  • Python For Data Analyst
  • Power BI / Tableau

Duration of Training  :  100 hrs

Batch type  :  Weekdays/Weekends

Mode of Training  :  Classroom/Online/Corporate Training

 

Data Analytics  Training & Certification in Pune

Highly Experienced Certified Trainer with 10+ yrs Exp. in Industry

Realtime Projects, Scenarios & Assignments

 

Why Radical Technologies

100% Placement Guarantee for the Right Candidate

10+ Years Real Time Experienced Trainers

Learn from Industry Experts, Hands-on labs

Flexible Options: online, instructor-led, self-paced

14+ Years of Industry Recognitions

1 Lakh+ Students Trained

50,000+ Students Placed

Guaranteed 5+ Interview Calls

Top MNCs - Associated with 800+ Recruiters

Free Internship Project & Certification

Monthly Job Fair - Virtual as well as Physica

5000+ Reviews & Ratings

 

 

COURSE CONTENT :

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 

  1. 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

 

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

 

  1. 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

 

  1. 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

 

  1. Data Filtering and Management
  • Filtering Data using Data Filter
  • Advanced Filtering Techniques
  • Organizing Data using Data Sort
  • Custom Sorting Techniques

 

  1. 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

 

Online Batches Available for the Areas

Ambegaon Budruk | Aundh | Baner | Bavdhan Khurd | Bavdhan Budruk | Balewadi | Shivajinagar | Bibvewadi | Bhugaon | Bhukum | Dhankawadi | Dhanori | Dhayari | Erandwane | Fursungi | Ghorpadi | Hadapsar | Hingne Khurd | Karve Nagar | Kalas | Katraj | Khadki | Kharadi | Kondhwa | Koregaon Park | Kothrud | Lohagaon | Manjri | Markal | Mohammed Wadi | Mundhwa | Nanded | Parvati (Parvati Hill) | Panmala | Pashan | Pirangut | Shivane | Sus | Undri | Vishrantwadi | Vitthalwadi | Vadgaon Khurd | Vadgaon Budruk | Vadgaon Sheri | Wagholi | Wanwadi | Warje | Yerwada | Akurdi | Bhosari | Chakan | Charholi Budruk | Chikhli | Chimbali | Chinchwad | Dapodi | Dehu Road | Dighi | Dudulgaon | Hinjawadi | Kalewadi | Kasarwadi | Maan | Moshi | Phugewadi | Pimple Gurav | Pimple Nilakh | Pimple Saudagar | Pimpri | Ravet | Rahatani | Sangvi | Talawade | Tathawade | Thergaon | Wakad

Our Courses

Drop A Query

    Enquire Now


    Enquire Now










      This will close in 0 seconds

      Enquire Now & Get 10% Off!

      (Our Team will call you to discuss the Fees)

        This will close in 0 seconds

        Enquire Now










          X
          Enquire Now

          Enquire Now & Get 10% Off!

          (Our Team will call you to discuss the Fees)

             

             

            logo

            Get a Call Back from Our Career Assistance Team

                Enquire Now