Best Data Analytics Course Training in Thane - Fees, Placements

Learners 1000+
  • Best Data Analytics Course in Thane to Learn in Online / Classroom Format and Get Certified from Best Data Analytics Training Institute QuickXpert Infotech known for Quality Training in Reasonable Fees and Placements!

  • About Data Analytics -

    Process to analyze data and represent them in meaningful readable format like charts, plots, summary reports, dashboards etc. which helps business users take business decisions is called as Data Analytics. Without business decisions business cannot survive and hence Data Analytics is Evergreen Field!

  • About Our Data Analyst Certification Course -

    Learn from SQL to advanced data analytics tools with projects under our experts. Can be learnt by both freshers and experienced to become a Data Analyst Professional!

  • Best-in-class Placement Services -

    End to end placement support until you get job for 15 months (more than sufficient). Placement process initiates in ongoing training around 75% completion (criteria apply) or bydefault on completion to help you quickly get a job.

      

    Fees / Details

  • Trainer -

    Experienced Professional, Trained Lots of Students

  • Jobs Roles Targeted -

    Data Analyst, Data Analyst Developer, Analytics Engineer, Data Engineer etc.

  • Any Pre-requisites -

    None. Any one from IT or non IT can Learn. Individual courses / customized training available.

Syllabus

Syllabus

Adv. Data Analyst Course
  • Oracle 18/21c Installation
  • Basics
    • Oracle Basics
    • Database models
    • ER Model Overview
    • Data types
    • Understanding Test Database
    • Basics Queries
    • Arithmetic and String functions
    • DML Operations - Insert, Update and Delete
    • FETCH command - Top N, Top % Rows
  • Writing Queries
  • Filters
    • DISTINCT
    • BETWEEN
    • IN
    • LIKE
    • NOT
    • NULL
    • AND, OR, NOT etc
    • Using Complex Data Filtering Techniques
  • Sorting
    • Ascending Order
    • Descending Order
    • Complex Sorting
  • Functions
    • String Functions - lower case, uppercase, substring, instring, trim etc.
    • Number Functions
    • Date Manipulation
    • Null Value Functions - NVL, NVL2, NULLIF, COALESCE
    • Conditional Expressions - Case and Decode
  • Groups
    • Basics
    • Grouping functions - AVG, MIN, MAX, COUNT, DISTINCT COUNT etc
    • Grouping Filters - HAVING
    • Rollups & Cubes
  • Joins
    • Cartesian Product
    • Equi and Non-Equi Joins
    • Left Outer Join
    • Right Outer Join
    • Full Outer Join
    • Self Join
    • Complex Queries - Joins & Groups Integration
  • SET Operators
    • Union
    • Union All
    • Intersect
    • Minus
  • Subquery
    • Single Valued Row Sub Query
    • Multi Valued Sub Query
  • Views
  • Inline Views
  • ROWID & ROWNUM
  • TOP N Analysis using Complex Inline View
  • Window (Partition By) Functions
    • Over() with summary functions
    • Partition By Queries
    • ROW_NUMBER()
    • RANK()
    • DENSE_RANK()
  • DDL
    • Tables - Create, Alter, Drop
    • Indexes - Types, Create, Drop
    • Constraints - Not Null, Primary Key, Unique Key, Foreign Key
    • Sequence
    • Synonyms
  • Foreign Keys
  • DML operations - Insert, Update & Delete
    • Insert, Update, Delete & Truncate
    • Common Operations
    • Creating Tables using queries
    • Bulk Data Inserts using Queries
  • Transactions ( T SQL)
    • Commit
    • Rollback
    • Savepoint
  • DCL - Grant & Revoke
  • Project
  • Introduction & Installation
    • Introdution
    • Installing Python
    • Installing Pycharm
    • Configurations
  • Programming Basics
    • Variables
    • Data Types
    • User Inputs
    • Unpacking
    • Boolean Practice
    • What If, Else and If, Making Decisions
    • For Loops
    • Break Continue Pass
    • Break Vs Continue Vs Pass
  • Data Structures
    • List
    • Tuple
    • Set
  • Logic Building & Programming
    • Pattern Programs
    • Prime Number
    • Fibonacci Sequence
    • Factorial
    • Recursion
    • Swap 2 Variables
  • Data Structures
    • Linear Search
    • Bubble Sort
  • Functions
    • Creating Functions
    • Functions Arguments
    • Type of Arguments
    • Keyworded Variable Length Arguments
    • Using Built in Functions
    • Global Keywords
    • Passing List to Functions
  • Anonymous Functions / Lambda
  • Filter / Map Reduce
  • Decorators
  • Modules
  • OOPs Programming
    • Modules
    • Special variable _name_
    • Class & Object
    • _init_ method
    • Constructor, Self and Comparing Objects
    • Types of Variables
    • Types of Method
    • Inner Class
    • Inheritance
    • Constructor in Inheritance
    • Introduction to Polymorphism
    • Duck Typing
    • Operators Overloading
    • Method Overloading
    • Method Overriding
    • Iterator
    • Generators
  • Exception Handling
  • File handling
  • MySQL Server Setup
    • Installing and Configuring MySQL Server
    • Creating Database
    • CRUD Operations
    • Create Tables
      • Insert
      • Update
      • Delete
  • Database Integration with Python
    • Connection to Database from Python
    • Writing functions to handle database operations
    • CRUD Operations in python
  • Web Scrapping
    • Beautiful SOUP library
    • Parsing HTML files
    • Getting Data from Any Website
  • Data Analytics (NumPy & Pandas)
    • Installing & Understanding Analytics Packages
    • NumPy Array Operations
    • Pandas Data Frame Operations
    • Data Acquisition (Import & Export)
    • Indexing
    • Selection
    • Sorting
    • Filtering
    • Group By
    • Binning
    • Concatenation
    • Merge
    • Append
    • Drop
  • Data Visualization
    • Installing Matplotlib & Seaborne libraries
    • Charts & Plots
      • Histogram
      • Scatter Plots
      • Box Plots
      • Line Chart
      • Bar Chart
      • Pie Chart etc.
  • Excel basics
  • Working with Spreadsheets
  • Preparing Data
  • Fetching Data from SQL Database
  • Excel Common Functions
    • Text Functions (Len, find, concate, trim, left, right)
    • Conditions functions (sumif, countif, averageif)
    • Date functions
    • V Lookup /H Lookup /X Lookup
    • Index match
    • Rank
    • Filter / Sort
    • Grouping Functions
      • Sum
      • Avg
      • Min
      • Max
      • Count & CountA
  • Data Validation
  • Conditional Formatting
  • Pivot Tables
  • Charts
    • Bar Chart
    • Pie Chart
    • Line Chart
    • Bubble Chart
    • Stacked Bar Chart
      • Horizontal
      • Vertical
  • What if Analysis/ Goal Seek
  • Scenario manager
  • Sheet Referencing
  • Record functionality
  • Project on Dashboards / Data Visualization
    • On Data from SQL
    • On Data from CSV files
  • Introduction to Power BI
    • What is Power BI and Why Power BI
    • Installing Power BI Desktop
    • Exploring the Power BI Workflow
    • Adjusting the settings of the Power BI Desktop
    • Comparison of Power BI vs Other Reporting Tools
  • Getting and Transforming Data with Power BI Desktop
    • Connecting to different sources
    • Connecting to multiple sources
    • Different connecting Options(DirectQuery vs Import Data Vs Live Connection)
    • Shaping and transforming data with Power Query
    • Editing,Merging,Appending queries etc
  • Advance Importing techniques without coding
  • Data cleaning & Advance data cleaning
  • Modeling with Power BI
    • Introduction to Modeling
    • Building Relational Models(Setup and Manage Relationships)
    • Creating table relationships
    • Understanding the filter flow
    • Cardinality and Cross filtering
  • DAX
    • Understanding Dax Syntax
    • Calculated Columns vs Measures
    • Common Dax functions and formulae
    • Understanding the evaluation context in DAX
  • Visualising Data with Reports
    • Creating Visualisations
    • Color & Conditional Formatting
    • Setting Sort Order
    • Scatter & Bubble Charts & Play Axis
    • Tooltips
    • Slicers, Timeline Slicers & Sync Slicers
    • Cross Filtering and Highlighting
    • Visual, Page and Report Level Filters
    • Drill Down/Up
    • Hierarchies
    • Constant Lines
    • Tables, Matrices & Table Conditional Formatting
    • KPI's, Cards & Gauges
    • Map Visualisations
    • Custom Visuals
    • Managing and Arranging
    • Drillthrough
    • Custom Report Themes
    • Grouping and Binning
    • Bookmarks & Buttons
  • Introduction to Power BI Service
    • Introduction to the Power BI Service
    • Quick Tour of Power BI Service
    • Connecting to Data from Power BI service
    • Building Blocks of Power BI Service
  • Sharing and Collaboration Tools in Power BI Service
    • Sharing and Collaboration Options Overview
    • Publish from Power BI Desktop
    • Publish Reports to Web
    • Printing and Exporting from Power BI Service
    • Sharing Reports & Dashboards
    • Workspaces (My Workspace vs App Workspace)
    • Publishing Apps in Power BI Service
    • Row Level Security in Power BI Desktop and Service
  • Power BI Gateway and Refreshing Datasets
    • Understanding Gateways in Power BI
    • Difference between Personal and On-Premise Gateway
    • Installation of Personal Gateway
    • Installation of On Premise Enterprise Gateway
    • Setting Up a Gateway in Power BI Service
    • Understanding Data Refresh(Manual vs Scheduled Refresh)
    • Troubleshooting Refreshing scenarios
  • A.I. in Power BI
  • Advance Report techniques
  • Best Practices
  • Installation and Configuration
  • Introduction to Tableau
    • Architecture
    • Data Model
    • Data Connection with single data sources
    • Data Joins
    • Live vs extract connection
    • Working with multiple data sources
    • Data Blending
    • Difference between joining and blending data
  • Tableau Interface
    • Measures and dimension
    • Shelves
    • Show me
    • Data Types
    • Default Properties
    • Marks Card
    • Page Shelf
    • Saving and sharing your work-overview
    • Difference between .twb and .twbx
    • Discrete vs Continuous
  • Date Aggregations and Date parts
    • Cross tab
    • Totals & Subtotals
  • Chart Types
    • Bar Charts & Stacked Bars
    • Pie Chart
    • Line Graph with Date
    • Line Graph without Date
    • Area charts
    • Tree Map
    • Word Cloud
    • Packed Bubble
    • Box & Whiskers Plot
    • Scatter Plots
    • Highlight tables
    • Heat maps
  • Data Visualization
    • Geographical fields
    • Map options
  • Run Time Columns
    • Calculated Fields
    • String Calculation
    • Data Calculation
    • Logical Calculation
    • Numeric Calculation
    • Parameters
    • Table Calculations
    • Level of detail
  • Data Formatting
    • Legends
    • Highlights
    • Labelling
    • Number Formats
    • Alignment
  • Advanced Functionalities
    • Sorting
    • Groups
    • Sets
    • Hierarchy
    • Reference and Trend Lines
    • Edit Axis
    • Bins
  • Filters
    • Dimension Filter
    • Measure Filter
    • Filter - Display Option
    • Context Filters
    • Relevant Filters
    • Sets in filters
    • Conditional Filters
  • Advanced Charts
    • Pareto
    • Waterfall
    • Funnel
    • Waffel Chart
  • Dashboards
    • Dashboard Objects
    • Dashboard Actions
    • URL
    • Highlight
    • Filter
    • Advanced Interactivity
    • Publish to Web
  • Report designing & exporting
  • Case Studies / Project
  • Data Visualization & Analytics
    • Data Sources
    • from SQL (MySQL)
    • from Flat Files (CSV / Excel etc.)
    • from Python
  • Pkg1 - Data Analyst - 4 months
  • Pkg2 - Adv. Data Analyst - 6 months
  • Individual courses / Customized training available

  • Upcoming Batches

  • Get Fees
  • Live Online:
  • Data Analyst - ₹26000 - ₹22000 (Limited Period)
  • Adv. Data Analyst - ₹36000 - ₹30000 (Limited Period)
  • Individual courses / Customized training available

  • Classroom - Get Fees
  • Upcoming Batches
Data Analyst Course | Data Analyst Career Path

Tools You Will Learn

Data Analytics Projects

Few of the projects covered in one of our batches

Live Online Training


✅ Online live lectures conducted on Zoom, Googlemeet etc. & not pre-recorded lectures. Live doubt solving via screen share.
✅ 100% refund if you don't understand first 2 lectures
✅ placement support until you get job for min 12 months

Limited Time Offer

0 Days
:
2 Hours
:
40 Minutes
:
20 Seconds
 
Fees

Total Discount On Full Course 5% off on Multi Course Pay
0 - 0 - 0 0
✅ Installments available
✅ Group Discounts available
✅ Please contact institute for enrollment process - contact form
Batches

Please Note : If unable to find your preferred timings, then please contact us so that we can arrange a suitable batch for you. Customized training available.

Please submit inquiry form or visit institute for Fees.

Fees / Details

Classroom Training

Please submit inquiry form or visit institute for Fees & Batches.

Fees / Details

Recorded Course

Live Batch Recording !

Get an Experience Similar to a Live Batch in Less Fees!

(watch sample lectures below)

(If video goes blank means practice time is given, for best experience watch without skipping)

Limited Time Offer

0 Days
:
2 Hours
:
40 Minutes
:
20 Seconds

Duration :- + practice time


Overview :-

Benefits:
✅ 100% Job Oriented Course
✅ Instant Activation
✅ 1 Year Access
✅ 100% Refund Policy   more ...

  

Certification

Get Certified - Get a valid course completion ISO certificate accepted in the industry.

QuickXpert Certificate Format

Why get Trained from us?

10 yrs in IT Training
ISO Certified Institute
Training from Experts
Trained Globally
100% Practical Training
Certification Course
Projects / Case Studies
Interview & CV Preparation
1000+ Companies
Placements etc.
Lots of students placed in ongoing training or within just 30 days of completion of training.

You can be the Next Placed Student

Overall 1000+ Companies for Placements
Few Mentioned Below

  • 1. Darwin Platform Group of Companies
  • 2. Expound Technivo Pvt Ltd
  • 3. Aniruddha Telemetry Systems
  • 4. Acura Solutions
  • 5. Yash Technologies
  • 6. AQM Technologies Pvt Ltd
  • 7. Dusane Infotech
  • 8. Freight Tiger
  • 9. Aeon IT Solutions Pvt. Ltd.
  • 10. AG Technologies Pvt.Ltd
  • 11. Binateit IT Services Pvt Ltd
  • 12. Arine Solutions Private Limited
  • 13. AscenWork Technologies Private Limited
  • 14. Prisma AI Corporation Pte. Ltd.
  • 15. Miscot Systems Pvt. Ltd.
  • 16. Appetals Solutions Private Limited
  • 17. Ardentia Technologies Pvt. Ltd.
  • 18. Atri technocrat
  • 19. G-Square Solutions Private Limited
  • 20. Nevpro Business Solutions(NBS) Pvt. Ltd.
  • 21. Beehive Software Services Pvt Ltd.
  • 22. BestoSEO Solutions
  • 23. Billtrace infotech Pvt Ltd
  • 24. EYECATCHERS
  • 25. Brandintelle Services
  • 26. Bristlecone
  • 27. CMOTS Internet Technologies
  • 28. Cirrius Technologies Private Limited
  • 29. Digi Midas
  • 30. Dure Technologies Pvt Ltd
  • 31. eBrandz Solutions Pvt. Ltd.
  • 32. Edelweiss Capital
  • 33. EDUSOFTERP
  • 34. DigiFinTax Solutions Private Limited
  • 35. T3 Softwares
  • 36. Big Rattle Technologies
  • 37. Eviska Infotech Pvt Ltd
  • 38. Unichem Laboratories Ltd.
  • 39. Retail Whizz Solutions Private Limited
  • 40. Focus Management Consultants Pvt ltd
  • 41. Gratitude India
  • 42. Hero MotoCorp Ltd.
  • 43. HR Mantra Software Pvt Ltd
  • 44. Ideatore Interactive Solutions Pvt. Ltd.
  • 45. iGenesis Technologies
  • 46. Impulse Digital
  • 47. Inspeero Technologies
  • 48. Intellecta Consultants
  • 49. Job Proffer.com
  • 50. Brilino Pvt Ltd
  • 51. Galentic Technologies Private Limited
  • 52. Hurix Systems Private Limited
  • 53. SECURITY SOFTWARE & SOLUTIONS LLP
  • 54. Steadfast IT Consulting Pvt Ltd
  • 55. Kores
  • 56. Genirex Intellect Team Pvt Ltd
  • 57. V2STech Solutions
  • 58. Meru Mobility Pvt Ltd
  • 59. Propellum Infotech Pvt Ltd
  • 60. BarrierBreak Solutions Pvt. Ltd.
  • 61. Eziway Global Management
  • 62. Goldimine Electrosystems Pvt. Ltd.
  • 63. Marathe Infotech Pvt. Ltd
  • 64. Master Computech Pvt. Ltd.
  • 65. Svatantra Micro Housing Finance Corporation Ltd
  • 66. Mphasis
  • 67. NDS GLOBAL
  • 68. Nebula Personalization Tech Solutions Pvt. Ltd
  • 69. Nestor Marketing
  • 70. Net Gains Technologies Pvt Ltd
  • 71. Nimap Infotech
  • 72. Open Radix Software Solutions
  • 73. Opportune Technologies Pvt Ltd
  • 74. Optimum Financial Solutions Pvt. Ltd
  • 75. Pinnacle People Solutions Pvt Ltd
  • 76. Qtech Software Pvt. Ltd
  • 77. SAAR IT Resources Pvt. Ltd
  • 78. Saba Technosoft
  • 79. Sahu Technologies
  • 80. Core Ocean Solutions LLP
  • 81. Seclore Technology Pvt Ltd
  • 82. Sitel
  • 83. SMART SIGHT INNOVATIONS
  • 84. SME MaXX
  • 85. Spider Software Pvt Ltd
  • 86. iFAST Financial India Private Limited
  • 87. Code array Technologies Pvt. Ltd
  • 88. Tata Consultancy Services
  • 89. TurtleDove Technologies
  • 90. Network Techlab (India) Pvt. Ltd
  • 91. Jyoti Plastics Works Pvt Ltd
  • 92. ALFA KPO PVT LTD
  • 93. The Oberoi Group
  • 94. ThinkApps Solutions Private Limited
  • 95. Transovative Solutions Pvt. Ltd.
  • 96. TranzDigi
  • 97. Ugam Solutions
  • 98. Virtual Splat Software Pvt. Ltd.
  • 99. Techatalyst Software Pvt. Ltd.
  • 100. Spine Technologies India Pvt. Ltd
  • 101. Innoval Digital Solutions
  • 102. Osource Global private limited
  • 103. Innovins Softtech Solutions
  • 104. Acme Services Pvt Ltd
  • 105. Fatima Consultancy Services.
  • 106. MOUNTAIN RANGE PROPERTIES & RESORTS
  • 107. ITW Playworx
  • 108. Direction Software Solutions
  • 109. Nilsen
  • 110. Vnnogile Solution
  • 111. Wcities Content Solutions India Pvt. Ltd.
  • 112. AGS Transact Technologies Ltd.
  • 113. Digite Infotech Pvt. Ltd.
  • 114. Go Digital Technology Consulting LLP
  • 115. Naaptol Online Shopping Pvt. Ltd
  • 116. Miles Software Solutions Pvt. Ltd
  • 117. Scalability Experts Solutions Pvt Ltd
  • 118. Chamunda Tech-Net Services Pvt.Ltd
  • 119. Financial Software & Systems (P) Ltd
  • 120. Mindgate Solution Pvt Ltd ((Amruta)
  • 121. Xoriant
  • 122. Wind World india Pvt ltd
  • 123. Adroit Corporate Services Pvt. Ltd
  • 124. Ambe International
  • 125. Standard Retail Pvt. Ltd
  • 126. Avhan Technologies Pvt. Ltd.
  • 127. Parle Products Pvt. Ltd.
  • 128. KANALYTICS
  • 129. Trimax IT Infrastructure & Services Limited
  • 130. Omnino Solutions Private Limited
  • 131. IVY Mobility Solution Limited
  • 132. Smart-I Electronic Systems Pvt. Ltd.  
  • 133. SySpree Digital Pvt. Limited
  • 134. Karza Technologies Private Limited
  • 135. Const Accent Pvt. Ltd.
  • 136. IDZ Digital Private Limited (Anuja Dhage)
  • 137. Synergy Technology Services Pvt. Ltd.
  • 138. Future Focus Infotech
  • 139. Brandscapes World Wide
  • 140.  Videojet Technologies India Pvt Ltd
  • 141. General Mills India Pvt Ltd
  • 142. NDS Infoserv
  • 143. Team Lease Services Limited
  • 144. Adapty Solutions Pvt. Ltd.
  • 145. Johnson Controls
  • 146. Drip Capital Services India LLP
  • 147. Greysoft
  • 148. eBorn Consulting Pvt. Ltd.
  • 149. Kama Schachter jewelry pvt ltd
  • 150. Knooviq Technologies
  • 151. METRO Cash & Carry India Private Limited
  • 152. WisdmLabs
  • 153. Save AS Web.com
  • 154. Gray Routes Technology Pvt. Ltd.
  • 155. SPINNAKER LLC
  • 156. Akbar Offshore Pvt. Ltd
  • 157. ReapMind Innovations
  • 158. Netrix Worldwide Pvt Ltd
  • 159. Ficus ventures pvt ltd
  • 160. LIVEWIRE pvt ltd
  • 161. TR Chadha & Co
  • 162. V Art Services Pvt Ltd
  • 163. GemResource
  • 164. Axioned
  • 165. way2society
  • 166. Colgate-Palmolive
  • 167. Regime Tax Solutions Pvt. Ltd
  • 168. Infoz Software Solution
  • 169. Prowess Technology Solutions LLP
  • 170. Net Connect Globle
  • 171. PBI Analytics
  • 172. Crisil An S&P Globle Company
  • 173. Connectwise LLP
  • 174. Acme Hr Consulting
  • 175. Speridian Technologies
  • 176. InnOvator Web Solutions
  • 177. Crimson Interactive
  • 178. MCX India
  • 179. InvestOnline
  • 180. Shoolin Services Group
  • 181. Mobilestyx Consulting and Solutions LLP
  • 182. Zeki Software Solutions
  • 183. Prabhudas Lilladher
  • 184. ACE Software n Web Solutions
  • 185. Connexial Digital Technology
  • 186. Kennect
  • 187. DirectusHR Services
  • 188. Impact Guru
  • 189. Experian
  • 190. ITSource Technologies Limited
  • etc.

Contact Us


Mon to Sat - 9.30am to 7.45pm & upto 5.45 pm on Sun

Call us -
+91-7506252588
+91-7276681665

Email us -
inquiry@quickxpertinfotech.com

101, 1st Floor, Prestige Chambers CHS Ltd., opp. platform 2 Thane w rly stn, behind Dr. Babasaheb Ambedkar statue, besides Maurya Hotel.

Inquire / Book Demo


FAQs

What Our Placed Students Say

You can be the Next Placed Student
Enroll > Learn > Succeed

Inquire Now Batches