Acumen IT Training, Inc.

POWER BI

COURSE OBJECTIVES

  • Enhance skills from Excel to Advanced Excel and Power BI
  • Save 70% of daily routine time for Excel users
  • Make Manual method of data analysis to complete button click automation
  • Removing dependency.
  • Minimize usage of Excel, PowerPoint and Outlook.

COURSE OUTLINE

  • Power BI Introduction
    • What is BI
    • What is Power BI
    • Different Products of Power BI
  • Power Query – Introduction
    • How to import data into Power Query from Excel file, Csv, Text Files?
    • How to import data into Power Query from MS Access file/ SQL, Oracle?
    • How to import data into Power Query from Web, PDF, Exchange Online
  • Power Query – Data Transformation
  • Power Query – Working on data from multiple sources
  • Power Query – Appending Data
  • Power Query – I have stopped using VLOOKUP function – want to know why?

For FULL COURSE OUTLINE, please contact us.

Please contact us for the schedules and for booking a private class.

;