Verify Your CERTIFICATE




Amity Computer Academy

Call Now : 09007850161

Data Analytics Course

(Online & Classroom Training Facility available)

Amity Computer Academy offers certified Data Analytics courses in Kolkata for Students, Professionals and Business Owners. Learn data analytics training by industry professionals to acquire extensive data analytics knowledge to become a Pro in the industry. We provide online & Classroom data analytics training courses in Kolkata and pan India platform.

 

Introduction to Data Analytics

  • Data Analytics Overview
  • Importance of Data Analytics
  • Types of Data Analytics (Descriptive, Diagnostic, Predictive, Prescriptive)
  • Benefits of Data Analytics
  • Data Visualization for Decision Making

Excel : Basics to Advanced

  • Introduction & User interface in Excel
  • Adding Process, Average, Max, Min
  • Remove error by absolute reference
  • If statement, Name Box
  • Formatting of Data, Alignment, Rotate Text, Wrap Text
  • Insert Picture, Chart
  • Find and Replace, Sorting, Auto Filter, Advance Filter
  • Calculation Between worksheet
  • Pivot Table, Subtotal, Data Validation, Conditional Formatting, Grid Lines
  • Vlookup, Hlookup, Hyperlink, Goal seek, Scenario
  • Introduction to function (Sum if, Average If, Sum Ifs, Average Ifs)
  • Update Value without Formula, Range Name
  • Left and right function, And/OR Function, Trim Function, Concatenate
  • Proper, Upper, Lower, Exact, Len, Rept Function
  • If Error Function, IFNA Function
  • Advance Vlookup Function, Choice Function, Match Function, Index Function, Transpose
  • Odd and Even function
  • Loan calculation (PV, FV, PMT, IPMT, IRR, NPER, NPV, Rate Function)
  • Macro

Corporate Excel

  • Working with Formula & Functions: General & advance functions, conditional expressions, Nested IF, Date & Time function in IF.
  • Date & Time function: Excel Date limitation, valid dates, formats.
  • Sorting & Filter: Color sort, date filter, multi-level sorting, custom sort, advance filter.
  • Working with Styles & Conditional Formatting: Dynamic ranges, function in formatting.
  • Lookup and reference function: VLookup, Hlookup, Index Match, joining Vlookup.
  • Table Management: Dynamic range, table structure.
  • Data Validation & Protection: Valid range, lists, formula-based validation, password protection.
  • Working with Professional Reports: Subtotal Report, Pivot Table customization, Calculated Field, Slicer.
  • Excel Charts: Pivot Charts, 3D Graphs, Bar and Line Chart, Secondary Axis.

SQL

  • Introduction Of Sql
  • Use Of Xampp Software (How To Create Database, Table & Write Query)
  • Basic Sql Query (Create/Drop Db, Table, Primary Key, Alter)
  • Most Important Sql (Insert, Update, Delete, Show)
  • Different Types Of Sql (Inner Join, Outer Join, Order By, Group By, Like, Union Etc.)
  • Logical Operator Sql (And, Or, Not)
  • Mathematical Expression Like Count, Sum, Average, Total, Percentage Etc.
  • How To Import & Export Table From Xampp Software

POWER Bi

Microsoft Power BI transforms your data into rich visuals that facilitate new ways of thinking about and organizing your data. Reporting & Visualisation using Power BI Desktop, Transforming data using Power Query editor, Data Modelling using Power Pivot.

  • Lesson 1 & 2: Power BI Overview: What is Power BI, Suite of Products, Updates.
  • Lesson 3: Power BI Desktop: Interface, File Types (PBIX vs PBIT), Data Sources & Types.
  • Lesson 4: Connecting to Databases: Working With CSV, TXT, Excel, Importing, Transforming, Loading Data.
  • Lesson 5: Visualisation & Reporting: Charts, Table, Matrix, Card, Map, Decomposition tree.
  • Lesson 6: Add on to Visualisation: Drill down, Page Navigation, Conditional formatting, Bookmark.
  • Lesson 7 & 8: Power Pivot & Power Query: Relationship, Star/Snowflake schema, Grouping, Split/Merge column, M query, Joins.
  • Lesson 9: DAX functions: Calculations, Measures, Text functions, Date & Time Intelligence, KPIs, Calculate and filter function.
  • Lesson 10: Power BI Service: Power BI Online, Dashboards, Mobile, Row level security (RLS).

PYTHON

Python is a high level programming language that enjoys extensive popularity among developers and Programmers. Its syntax allows concepts to be expressed in fewer lines of code.

  • Module 1: Introduction to python, editors, Scripting language, Comments, Docstring, Input from user.
  • Module 2: Tokens, Operators, Control statements, Functions, Advance Data Type (List, Tuple, Set, Map, Dictionary, String), Modules and packages.
  • Module 3: Class And Object, Constructor, Inheritance, Polymorphism, Exception Handling (try, catch, finally), Threading, File Handling (txt, xml, csv, json), Regular Expression.
  • Numpy: Create Arrays, Item Selection, Indexing, Array Mathematics & Operation.
  • Pandas & Matplotlib: Series, Data Frames, Data Collection from csv/json/html, Plotting with Matplotlib.

Open chat