This training session will run from 16-18 September 2020, 2:00PM – 5:00PM
Fee is 5000PHP + VAT per participant
This live webinar is focused on time intelligence features of the Data Analysis eXpression (DAX) and is intended to provide capabilities that would otherwise be very difficult to produce. Understanding the basic principle of time intelligence requires the creation of the calendar date table, a date table which will provide the anchor for evaluating randomly occurring dates in date type columns of fact tables. By doing this, users can then align fact or transaction table with the calendar table. From here on user participants are expected to be able to perform running total computations, for various perspectives such as cumulative month to date, cumulative quarter to date, and cumulative year to date, to name a few business case scenarios.
Other capabilities to be taken up in this webinar includes capabilities to perform comparative reports, such as month to month (MoM), quarter on quarter (QoQ), and/or year on year (YoY) comparative analysis capabilities. There’s also the advanced feature of parameters which enables users to move back and forth in time where totals actively change their values, based on the parameters passed using Time Intelligence capabilities.
To attend this training course, participants are expected to have completed the introduction to Microsoft Power BI Data Visualization and Data Analysis eXpression.
Event DetailsLocation: ZoomDate: September 16, 2020 - September 18, 2020Time: 2:00 pm - 5:00 pm
Admission FeesMember Fee: 5600 PHPGuest Fee: 5600 PHP
Omar F. Abesamis
IT consultant, Trainer, Web developer and Enterprise Resource Planning (ERP) application practitioner
Mr. Abesamis has over 40+ years of experience as an IT consultant, web developer, and Enterprise Resource Planning (ERP) application practitioner. Over the years, he has provided best-practice consulting arrangements for clients in both the private and government sector.
The range of applications he has developed and implemented covers financial management, accounting, inventory, procurement, manufacturing, point-of-sale, and operations. He has also done work in distribution and logistics, human resource with payroll and time and attendance.
Omar has conducted IT training workshops and seminars to people on various disciplines for organizations like the Asian Development Bank, PruLife UK, Champ Cargosystems, Citibank N.A., Citytrust, SolidBank, Philippine Trade Training Center(PTTC), Super-K Drugstores, Zuellig Pharma Colgate Palmolive Philippines, Medicard Philippines, TOTAL Philippines to name a few.
Among the trainings conducted by Mr. Abesamis are Advanced MS Excel Capabilities, Effective Project Management Using MS Office Project, Developing Project User Requirements, Creating Dynamic Web-based Time and Attendance(TA) and Human Resource (HR) Systems Using PHP/MySQL, to name a few.