Data Analytics Training In Jaipur
Technoglobe offers the best Data Analytics training courses in Jaipur. The training program equips you with an apt understanding of data processing tools like Excel, SQL and Data Visualization tools like Tableau and PowerBI. While SQL is used to work with the data stored in the Database Management software, Tableau and PowerBI are used in analyzing it and presenting visual stories to end-users. Concepts such as Data Preparation, Data Cleansing, and Exploratory Data Analysis are explored in detail. Influential concepts like Data Mining of Structured (RDBMS) and Unstructured (Big Data) data, with the aid of real-life examples, are illustrated. Advanced Excel aids in data proficiency Concepts and it will help to reduce reduces working hours.
Technoglobe's vision is to provide high-quality education to students as well as working professionals to enhance their technical skills. With Technoglobe, you get a wide variety of career, professional, short-term & certification programs designed for the learning & industry needs of students & working professionals in the field of Information Technology.
Technoglobe's partnership with industry leaders such as Microsoft and HP also helps students obtain global certifications.
Data Analytics Course Training In Jaipur
- Introduction to Data Analytics
- Data Analytics Overview
- Importance of Data Analytics
- Types of Data Analytics
- Descriptive Analytics
- Diagnostic Analytics
- Predictive Analytics
- Prescriptive Analytics
- Benefits of Data Analytics
- Data Visualization for Decision Making
- Data Types, Measure Of central tendency, Measures of Dispersion
- Excel: Basics to Advanced
- Excel tutorial
- Text to Columns
- Concatenate
- The Concatenate Function
- The Right Function with Concatenation
- Absolute Cell References
- Data Validation
- Time and Date Calculations
- Conditional Formatting
- Exploring Styles and Clearing Formatting
- Using Conditional Formatting to Hide Cells
- Using the IF Function
- Changing the “Value if false” Condition to Text
- Pivot Tables
- Creating a Pivot Table
- Specifying PivotTable Data
- Changing a PivotTables Calculation
- Filtering and Sorting a PivotTable
- Creating a PivotChart
- Grouping Items
- Updating a PivotTable
- Formatting a PivotTable
- Using Slicers
- Charts
- Creating a Simple Chart
- Charting Non-Adjacent Cells
- Creating a Chart Using the Chart Wizard
- Modifying Charts
- Moving an Embedded Chart
- Sizing an Embedded Chart
- Changing the Chart Type
- Chart Types
- Changing the Way Data is Displayed
- Moving the Legend
- Formatting Charts
- Adding Chart Items
- Formatting All Text
- Formatting and Aligning Numbers
- Formatting the Plot Area
- Formatting Data Markers
- Pie Charts
- Creating a Pie Chart
- Moving the Pie Chart to its Own Sheet
- Adding Data Labels
- Exploding a Slice of a Pie Chart
- Data Analysis − Overview
- types of Data Analysis
- Data Analysis Process
- Working with Range Names
- Copying Name using Formula Autocomplete
- Range Name Syntax Rules
- Creating Range Names
- Creating Names for Constants
- Managing Names
- Scope of a Name
- Editing Names
- Applying Names
- Using Names in a Formula
- Viewing Names in a Workbook
- Copying Formulas with Names
- Difference between Tables and Ranges
- Create Table
- Table Name
- Managing Names in a Table
- Table Headers replacing Column Letters
- Propagation of a Formula in a Table
- Resize Table
- Remove Duplicates
- Convert to Range
- Table Style Options
- Table Styles
- Cleaning Data with Text Functions
- Removing Unwanted Characters from Text
- Extracting Data Values from Text
- Formatting Data with Text Functions
- Date Formats
- Conditional Formatting
- Sorting
- Filtering
- Lookup Functions
- Pivoting
Core Python
- Module 1 :
- Introduction To Python
- Features Of Python
- Basic Syntax ,Variable And Data Types
- Boxing & Unboxing
- Conditional Statements(If ,If- Else ,Elif-Laderif,Nested If)
- Iteration Looping Statement(Foreach,While)
- Control Statements(Pass,Break,Continue,Exit)
- Function In Python
- Module 2 :
- Python Generic Function - *Args & **Kwargs
- Python Modules & Package
- Function Returning Multiple Value
- Module 3 :
- Python Oop - Paradigm
- Class And Object - Encapsulation
- Class As Module In Python
- Constructor With __Init__
- Inheritance,Overloading,Overriding
- Advance Python
- Python partial Function
- Anonymous Functions: Lambda Operator
- Python Iterator,Generator & Decorator
- Comprehension In Python
- Global And Local Variables In Python
- Module 4 :
- Introduction To Python Special Data Types
- Python List ,Tuple,Set And Dicitonary
- Zip, Map,Filter, Reduce Functions In Python
- Python Dates Function
- Python Random Function
- Json - Http Response Type Data Handling In Python
- Python Exception Handling,Custom Exception
- Module 5 :
- Python File Handling
- Python Multithreading
- String Functions In Python
- Python Array
- Introduction Array Operations With Numpy
- Intro to matplotlib
- Intro to pandas
- Module 1 : Introduction
- Overview of Module 1: Introduction to Power BI
- Get Started with Power BI
- Overview: Power BI concepts
- Sign up for Power BI
- Overview: Power BI data sources
- Module 2 : CSV
- Upload a local CSV file
- Connect to Excel data that can be refreshed
- Connect to a sample
- Create a Report with Visualizations
- Explore the Power BI portal
- Module 3 : Viz and Tiles
- Overview: Visualizations
- Using visualizations
- Create a new report
- Create and arrange visualizations
- Format a visualization
- Create chart visualizations
- Use text, map, and gauge visualizations and save a report
- Use a slicer to filter visualizations
- Sort, copy, and paste visualizations
- Download and use a custom visual from the gallery
- Module 4 : Reports
- Modify and Print a Report
- Rename and delete report pages
- Add a filter to a page or report
- Set visualization interactions
- Print a report page
- Send a report to PowerPoint
- Module 5 : Dashboards
- Create a Dashboard
- Create and manage dashboards
- Pin a report tile to a dashboard
- Module 6 : DAX functions
- New Dax functions
- Date and time functions
- Time intelligence functions
- Filter functions
- Information functions
- Logical functions
- SQL
- Introduction to Oracle Database
- Retrieve Data using the SQL SELECT Statement
- Learn to Restrict and Sort Data
- Usage of Single-Row Functions to Customize Output
- Invoke Conversion Functions and Conditional Expressions
- Aggregate Data Using the Group Functions
- Display Data from Multiple Tables Using Joins
- Use Sub-Queries to Solve Queries
- The SET Operators
- Data Manipulation Statements
- Use of DDL Statements to Create and Manage Tables
- Other Schema Objects
- Control User Access
- Management of Schema Objects
- Manage Objects with Data Dictionary Views
- Manipulate Large Data Sets
- Data Management in Different Time Zones
- Retrieve Data Using Sub-queries
- Regular Expression Support
Power BI