Krishsoftsol

Menu
Facebook Twitter Youtube

Data Analytics

COURSE HIGHLIGHTS

  • 10+ Yrs Of Experienced Real Time Trainers
  • Competitive Course Content As Per Current Market.
  • Real Time Project End To End Will Be Covered In Every Course.
  • Course Will Be Start From Basic Level To Advanced Level
  • All The Real Time Tools Learn In The Part Of Course
  • Daily Assignments And Monitoring Your Work
  • Weekly Written Tests Will Be Conducted
  • Real Time Scenarios And Interview Questions Discussion
  • Mock Interviews With Feedback And Suggestions If Any.
  • Sharing All The Documents Used In Real Time Projects.
  • After Course Completion Also We Will Address Your Queries On Weekly Q&A Session.
  • Recordings Access For Lifetime.

Our Workflow

Data Analytics Course Content

  1. SQL
  • What is Database
  • Types of Databases
  • DBMS vs RDBMS
  • DBMS Architecture
  • Three schema Architecture
  • Install PostgreSQL
  • Install MySQL
  • Data Models
  • DBMS Language
  • ACID Properties in DBMS
  • What is SQL
  • SQL Data Types
  • SQL Operators
  • SQL Keys
  • SQL Joins
  • GROUP BY, HAVING, ORDER BY
  • Subqueries with select, insert, update, delete statements?
  • Views in SQL
  • SQL Set Operations and Types
  • SQL Triggers
  • Introduction to NoSQL Concepts
  • SQL vs NoSQL
  • Varieties of NoSQL Data Models
  1. Excel
  • Statistical Analysis using Excel
  • Business Moments
  • Graphical Techniques using Excel
  • Inferential Statistics
  • Hypothesis Testing using Excel
  • Entering and Editing Text and Formulas
  • Woking with Basic Excel Functions
  • Formatting Data in an Excel Worksheet
  • Creating Basic Charts in excel
  • Excel Functions
  • Working with an Excel List
  • List Functions
  • Data Validation
  • Pivot Tables
  • Conditional Functions
  • Lookup Functions
  • Text Based Functions
  • What-IF Tools
  • Understanding Why and How behind Excel Macros
  • VBA Variables and Operators
  • Automate Excel Formulas
  • Working with VBA Forms
  1. Tableau
  • Data Visualization Introduction and Concepts
  • Tableau Introduction and Tableau Architecture
  • Exploring Data using Tableau
  • Working with Data using Tableau including Data Extraction and Blending
  • Various Charts in Tableau (Basic to Advanced)
  • Hierarchies – Tableau Drill Down and Roll Up Features
  • Sorting – Quick Sort, Sort from Headers, Legends, Axis, Tool Bar; Sort by Fields, Nested Sort
  • Filtering – Dimension Filters, Measure Filters, Date Filters, Tableau Context Filters
  • Groups, Sets and Combined Sets
  • Reference Lines, Bands and Distribution
  • Parameters – Dynamic Parameters, Parameter Actions
  • Forecasting – Exponential Smoothing Technique
  • Data Mining Unsupervised Learning – Clustering
  • Calculated fields in Tableau, Quick Table Calculations, LOD Expressions
  • Tableau Mapping Features
  • Tableau – R Integration
  • Tableau Interactive Dashboards, Dashboard Actions, Stories
Scroll to Top