Power BI Query Editor
Your Instructor
I am Chartered Accountant, Certified Fraud Examiner and have completed Diploma in Information System Audit (Indian equivalent exam for CISA).
I have circa 16+ years of experience into Data
Analytics, Internal Audits, External (Statutory) Audits, SOX Compliance, Risk
Assessment and Regulatory Compliance. I have audited various entities under BFSI,
Automotive Manufacturing, ITES, Infrastructure and Pharmaceuticals sectors. I
have worked circa 9 years with Big4 consultancy firms – Deloitte, Price
Waterhouse and other with Bank of New York Mellon.
I have conducted various workshops at Institute of Chartered Accountants of India. Approximately 600+ people have attended these workshops and have given extremely positive feedback
Course Curriculum
INTRODUCTION
Available in
days
days
after you enroll
IMPORT & ANALYZE EXCEL DATA INTO POWER BI
Available in
days
days
after you enroll
-
StartHow to Import Excel Data from a File – Preview (7:06)
-
StartHow to Import data from Text – Tab delimited file (3:08)
-
StartHow to Import data from Access files (3:39)
-
StartHow to Load data in the data model and check the file path changes (8:46)
-
StartHow to Import data from the CSV delimited file (4:35)
-
StartFiltering in Power Query Editor (9:08)
BUILT IN QUERY RIBBON TRANSFORMATION
Available in
days
days
after you enroll
FAQs
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
How long do I have access to the course?
How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.
What if I am unhappy with the course?
We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.