About Us

Data Analyst Program

Data analysis is the process of cleaning, interpreting, and converting information into actionable insights by detecting patterns, relationships, and gaps in everything from a customer’s online activity to a marketing campaign’s results.2 Before the digital age, businesses made decisions on perceived customer behavior and a product’s popularity. Now, however, companies across the board constantly gather qualitative data and quantitative data. There’s digital and physical approaches to data collection to provide valuable insight on how customers interact with a business. A data analyst or data scientist—human, artificial intelligence, or a combination of both—transfers these raw data into business recommendations. It can go in a fresh direction with the data visualization tools available to employees or updating existing products

My SQL


  • ⦿ Installation & Configuration
  • ⦿ Using Tool - MySQL Workbench
  • ⦿ Design Database / Constraints
  • ⦿ Indexes / CRUD Operations
  • ⦿ Select Queries / Functions
  • ⦿ Groups / Joins/ Views & Inline Views
  • ⦿ Subquery/Create Complex Queries
  • ⦿ Creating Professional ER Diagram

Excel Analytics


  • ⦿ Working with Spreadsheets
  • ⦿ Preparing Manual Data
  • ⦿ Fetching Data From Database
  • ⦿ Excel Common Functions
  • ⦿ Pivot Tables
  • ⦿ Charts
  • ⦿ Project on Dashboards
  • ⦿ Data Visualization


Tableau


  • ⦿ Tableau Interface
  • ⦿ Date Aggregations and Date Parts
  • ⦿ Data Visualization & Formatting
  • ⦿ Run Time Columns
  • ⦿ Advanced Functionalities
  • ⦿ Filters /Advanced Charts
  • ⦿ Dashboards

Python Programming


  • ⦿ Programming Basics
  • ⦿ Functions / OOps Programming
  • ⦿ Exception Handling
  • ⦿ MySQL Server Setup
  • ⦿ Database Integration with Python
  • ⦿ Web Scrapping
  • ⦿ Matplotlib & Seaborn - Visualization


Power Bi


  • ⦿ Power Bi Introduction
  • ⦿ Power Query
  • ⦿ Creating Power BI Reports
  • ⦿ Reports Visualisation & Properties
  • ⦿ Charts & Maps Reports Properties
  • ⦿ DAX Expression
  • ⦿ Visualization & Dashboard

Eternal HighTech WhatsApp