Best Data Analyst Certification Course
Learners 1000+
-
Best Data Analyst Course to Learn in Online / Classroom Format from Best Data Analyst 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 With Real Time Projects -
Learn from SQL to advanced data analytics tools with Real time projects (watch video below) under our experts. Can be learnt by both freshers and experienced to become a Data Analyst Professional!
Duration & Training Packages -
Data Analyst - 4 months - Get Fees
Adv. Data Analyst - 6 months - Get Fees
Single courses / customized training availableTrainer -
Exp. 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.
Upcoming Batch -
New batch at regular intervals. Upcoming Batch
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
- Analytic (Window) Functions
- Over() with summary functions
- Partition By Queries
- ROW_NUMBER()
- RANK()
- DENSE_RANK()
- 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 or Complex Inline View
- 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
- Binary 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
- Installing and Configuring MySQL Server
- Creating Database
- CRUD Operations
- Create Tables
- Insert
- Update
- Delete
- Connection to Database from Python
- Writing functions to handle database operations
- CRUD Operations in python
- Beautiful SOUP library
- Parsing HTML files
- Getting Data from Any Website
- 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
- Installing Matplotlib & Seaborne libraries
- Charts & Plots
- Histogram
- Scatter Plots
- Box Plots
- Line Chart
- Bar Chart
- Pie Chart etc.
- Working with Spreadsheets
- Preparing Manual Data
- Fetching Data From Database
- Excel Integration with SQL & Fetching Data from SQL
- Excel Common Functions
- Len
- Conditions functions
- V Lookup
- Rank
- Grouping Functions
- Sum
- Avg
- Min
- Max
- Count & CountA
- Pivot Tables
- Charts
- Bar Chart
- Pie Chart
- Line Chart
- Bubble Chart
- Stacked Bar Chart
- Horizontal
- Vertical
- Project on Dashboards / Data Visualization
- On Data from SQL
- On Data from Python
- On Data from CSV files
- 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
- 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
Tools You Will Learn
Data Analytics Projects
Real Time Projects Covered as part of our Data Analytics Training
Why get Trained from us ?
Training From Experts
Personal Attention
80% Practical
Study Material
Course Completion Certificate
Live Projects /
Case Studies
Interview Preparation
Best Placement Service
