Data Analytics

Module 1         Basic Computer

• • • Basic Concept of Computer
    • English Typing
    • Hindi Typing
    • Data Entry

MS Word

• • • Font & Paragraph Formatting
    • Editing, Saving & Printing Text Documents
    • Inserting Table
    • Header & Footer
    • Smart Art
    • Page Breaks
    • Using List & Styles, Spelling & Grammar Check
    • Understanding Document Properties & Tabs
    • Mail Merge
    • Document Views & Macros
    • Saving & Protecting Sheets Documents
    • Project Work

Advanced Excel                           

• • • Introduction (MS Excel Window/Interface Parts, File Extension, How to Open/Exit.)
    • All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
    • Entering and Editing Data.
    • Inserting and Deleting Row or Column.
    • Formatting Data
    • Auto fill Lists ( Default lists & Creating new lists)
    • Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
    • Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis
    • Charts (Working With Charts)
    • Logical Functions (IF, AND, OR, NOT, IFERROR)
    • Financial Functions (PMT, PV, RATE, FV, DB)
    • Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, XLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)
    • Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)
    • Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
    • Project Work
    • and many more…

MS PowerPoint

• • • Creating & Printing Slides
    • Adding Custom Animation
    • Using Slide Transitions
    • Using Charts, Graphs & Photo Album
    • Creating Professional Presentation
    • Project Work

Internet

• • • Introduction to Internet
    • Browser Basics
    • Downloading, Searching, Surfing and Storing Data
    • Online Forms Submission
    • Online Bill Payment
    • Online Ticket Booking
    • and many more..

Module 2     

MIS Reports

• • • Types of Reports: Operational, tactical, strategic
    • Creating Reports: Templates, data collection, presentation
    • Automating Reports: Macros, scheduled reports
    • Project Work
    • and many more….

Pivot Tables

• • • Basics: Creating, designing pivot tables
    • Advanced Techniques: Grouping, calculated fields, charts
    • Insights: Analyzing data, using slicers, timelines
    • Project Work
    • and many more….

Dashboard Creation

• • • Introduction: Purpose, types of dashboards (Operational, Analytical, Strategic)
    • Excel Dashboards: Data prep, chart selection, using slicers
    • Advanced Excel: Pivot tables/charts, Power Pivot, dynamic dashboards
    • Design Principles: Layout, color usage, readability
    • SQL Integration: Pulling live data, combining with Excel for dashboards
    • Advanced Features: Real-time dashboards, automation, sharing/collaboration
    • Project Work
    • and many more….

Module 3:     SQL

• • • Create, Manage Databases and Tables
    • Insert, Update, and Delete Data in tables
    • Select with filters(where) and Sorting(Order By)
    • Use join to combine data from multiple tables
    • Use functions like Sum,Avg, Count, MIN, and MAX
    • Create table relationships with foreign key
    • And Many More…

Module 4: Power BI for Data Analytics

• • • Getting Started with Power BI
      • Importing dataset into Power B
      • Adjusting table and column name
      • Setting correct data type
      • Splitting and removing column
      • Replacing values in a column
    • Data Manipulation and Analysis
      • Text data manipulation
      • Numeric data analysis
      • Date and time manipulation
      • Conditional column
      • Grouping and aggregating
      • Joining dataset
      • Concatenating datasets
    • Data Modeling and Connection
      • Understanding data modeling
      • Creating data model in Power BI
      • Managing & editing data models
      • Data column formats & categories
      • Creating & managing hierarchies
    • Data Analysis Expressions(DAX)
      • DAX for math and statistics
      • DAX for counting categories
      • DAX for logical functions
    • Creating Dashboard

Module 5: Python and Data Visualization

• • • Understanding Data Types
    • Understanding Tuples and Lists
    • Conditionals and Functions
    • Data Cleaning
    • Data Manipulation
    • Merging and Concatenating
    • Pivot table analysis
    • Data Visualization Methods
    • Data Transformation Methods
    • Data Preprocessing
      
    • and many more…