Lesson series

Data Analytics program

Learn and practice data analytics with our job simulation program and become job ready. Work on a public domain project irrespective of your background. Work and gain experience using various Tools like Excel, MySQL, Python, PowerBI, Presentation, Power Query, Power Pivot etc.
  • 68 learners

    Enrolled
  • 4 hours

    Video duration
  • 27 hours

    Course duration
  • 4 Ebooks

    Free of charge

    What tools you will work with & Learn

    Advanced Excel

    • FlashFill
    • Data Validation
    • Filtering and Sorting
    • Conditional Formatting
    • Charts
    • Dashboarding
    • Vlookup
    • XLookup
    • Match & Index
    • Text Formulas
    • Date & Time Formulas
    • Statistical Formulas
    • Forecasting Formulas
    • Pivot Tables
    • Formulas

    Advanced SQL

    • Joins
    • Window Functions
    • Subqueries
    • Case Handling
    • Temp Tables
    • Indexing and Schema building
    • System Design

    Data Cleaning

  • What is Data Cleaning
  • Key aspects of Data Cleaning
  • Data Profiling
  • Methods of Data Cleaning
  • Impact of Data Cleaning
  • Where Data Cleaning is used
  • Techniques of Data Cleaning
  • Handling Missing Values
  • Data Deduplication
  • Data Deduplication - Comparison Methods
  • Duplicate Detection
  • Data Deduplication Conclusion
  • Data Standardisation

  • Frameworks of Data Standardisation
  • Data Wrangling
  • Data Standardisation
  • Data Orchestration
  • Data Blending
  • Data Cleaning
    • Data Transformation
    Data Integration
    • Data Enrichment
    • Types of Data Standardisation
    • General Data Standards
  • Frameworks of Data Standardisation
  • Data Wrangling
  • Data Standardization
  • Data Orchestration
  • Data Blending
  • PowerBI

    • Data Sources
    • Data Transformation
    • Custom Visuals
    • Drill-Through and Drill-Down
    • Bookmarks and Selections
    • Tooltips
    • Data Sensitivity Labels
    • Data Classification
    • Aggregations
    • Composite Models
    • Pivoting and Unpivoting
    • Relationships
    • Data Modeling
    • DAX
    • Row-Level Security

    Data Storytelling

    • Storytelling Frameworks
    • Why Storytelling is Important
    • Narrative Arc
    • Analogies and metaphors
    • Contextualisation
    • 5 Step Framework
    • Data Driven Framework
    • The Story-circle Framework