Greetings from Corevents company,
We are in collaboration with internationally renowned Financial and Management Accounting consultant Mr. Duncan Williamson for a 2 day online + live streaming master class on "Excel Dashboarding and Power Bi" which is scheduled to be held on 04 & 05 November 2024.
At the end of the program, participants will gain an understanding of:
-
More Advanced Business Intelligence: Manually cleaning, by inspection, Using Power Query to help with data cleaning & Unpivoting data.
-
Reviewing Excel and Pivot Tables: High quality dashboards rely on a number of ideas and skills being used.
-
Critical Excel functions: In addition to exploring the most basic functions in Excel, we will explore and apply SUMIFS, SUMPRODUCT, VLOOKUP, Frequency, Data types, forecast sheet & Dynamic Array Functions.
-
Business Intelligence begins with Power BI for the Desktop: Basic visualisations, Manipulating data: some basic calculation and measures & Importing data from excel, CSV files, the web and Databases.
-
Power Pivot: Creating data models to create relationships between Excel and database tables & Power BI can be used as well as and instead of Power Pivot in this context.
-
Design Principles: Delegates are encouraged to bring along or provide links to their own dashboards or dashboards they like or dislike. This will encourage full and free discussion of the kinds of elements needed for a successful dashboard.
-
Automating Your Dashboard: Linking to various data sources through Power Query Power Pivot and Power BI, Incorporating new data automatically & auto refresh pivot tables.
-
Putting It All Together: Choosing the appropriate visualisations, Array formula alternative to SUMIFS, Rank values with Pivot Table & Formatting quickly.
-
Display Principles, Interactive Controls & Analyzing the Data and many more...
Please find attached detailed brochure of this training program.
To Register: Simply complete the last page of the program brochure and send the scan copy in reply to this email. Should there be anything further required, please do not hesitate to contact undersigned.
Best Regards,
Ameer Khan
Business Development executive
Training@corevents-global.com