|
Topic
|
Speaker
|
|
1 to 3 September 2023 : 10.00 am to 06.00 pm
|
|
Prerequisites for Microsoft Excel Power Tools and Microsoft Power BI Session:
Working knowledge of Microsoft Excel -
TOPICS COVERED
Introduction to Power Tools in Excel
Introduction to Power Query (Excel)
Getting Data from various data sources
Data Transformation
Data types in Power Query
Data Transformation (Cont.)
Data Transformation (Cont.)
Combine Multiple Queries
Combine Multiple Queries (Cont.)
Load Queries
Power Query - Troubleshooting
Error Handling in Power Query
Power Query Best Practices
Power Query Q&A
Introduction to Power Pivot (Excel)
Loading Data from various data sources
Working with Tables in Power Pivot Window
Introduction to Data Modelling (Relationships)
DAX (Data Analysis Expressions) Language
DAX (Cont.)
Time Intelligence in DAX
DAX (Cont.)
Creating Dashboard Reports and KPI
Power Pivot Best Practices
Power Pivot/DAX Q&A
Introduction to Power BI Desktop
Why Power BI when we already have Excel?
Loading Data from various data sources
Overview of Power BI Window & Query Editor in Power BI
Data Modelling in Power BI
Creating and sharing Report and Visualisation
Q&A Session
Course Wrap-up
|
|
Registration Link:
https://learning.icai.org/committee/daab_data_analytics_powerbi_mumbai/
Note
Participation Certificate will be awarded to the Participants
* The batch may be postponed if minimum number of registrations are not received.
Digital Accounting & Assurance Board
The Institute of Chartered Accountants of India
A-29, ‘ICAI Bhawan’|Sector-62 Noida 201309
E-Mail: fafp@icai.in
Website: https://learning.icai.org
For all queries related to program email us on wircevents@icai.in or can call on 022-33671424 / 17
Kindly note registration will be closed half hour before the program.
WIRC
Western India Regional Council