Skip to content
Enroll Now
IT

Data Analysis

Analyse data and build reports and dashboards with Excel and Power BI.

  • DDaniyal Computer Academy Quaidabad
  • Duration: 3 Months
  • 3 sections, 12 lessons

Course Info

This course teaches you to turn spreadsheets and databases into clear reports. You work with advanced Excel first, then move into Power BI dashboards.

Exercises use realistic business data such as sales, stock and finance.

What you will learn

  • Clean and organise business data
  • Summarise data with pivot tables
  • Write advanced formulas
  • Build interactive dashboards
  • Connect and combine data sources
  • Share reports with a team

Course outline

  1. Month 1 – Advanced ExcelFormulas, lookups and pivot tables.
  2. Month 2 – Power BIImporting data, modelling and visuals.
  3. Month 3 – DashboardsComplete reports and a final project.

Course Curriculum

Excel for Analysis4 lessons
  • Lookup functions
  • Logical and text functions
  • Pivot tables and charts
  • Data validation
Power BI5 lessons
  • Importing data
  • Cleaning with Power Query
  • Data models and relationships
  • Measures and calculations
  • Building visuals
Dashboards3 lessons
  • Dashboard design
  • Filters and slicers
  • Publishing and sharing

More

Who should join

  • School and college students
  • Job seekers and career changers
  • Working professionals who want new skills
  • Freelancers and entrepreneurs

Career opportunities

  • Data Analyst
  • Reporting Analyst
  • Business Analyst
  • MIS Officer

More Courses

IT

MS Office

Master the office applications used in nearly every workplace.

DDaniyal Computer Academy Quaidabad 3 Months
More InfoEnroll Now
IT

Data Science

Learn to collect, clean, analyse and visualise data, then build simple predictive models.

DDaniyal Computer Academy Quaidabad 6 Months
More InfoEnroll Now