Excel, SQL, PowerBI

Business Analytics

Work on a public domain project "Understanding the career aspirations of GenZ"

Empty space, drag to resize
Signup and complete your application to get accepted to this program, when the 

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