Advanced Data Analytics & Visualisation Techniques for Project Management
Advanced Data Analytics & Visualizations Techniques for Project Management
|
Description: |
Learn how to quickly create automated, interactive project management summary tables, charts & reports using best practice data analysis and visualization techniques.
This session will cover: - The Golden rules for collecting & structuring data for analytics - Best practice principles for designing charts and graphs - How to create automatic project data summaries - Visualization techniques for slicing tables, charts and graphs by different criteria, e.g. by Project, by resource or by period - Creating automatic reports on separate sheets for each department, project, activity category etc.
Event Agenda: 8:00am-8:05am: Chapter Announcements 8:05am – 9:05am: Session begins - Understanding the rules of data recording & structuring for report automation - reviewing the rules and applying them to data tables - Using Pivot Table & Pivot Chart reports for data summarization – an Overview - Pivot Reporting exercise – Ex 1 – Understanding how Pivot fields work with regular raw data - Shortcut tips and tricks with Pivot Table reports - Practice dragging and dropping fields and reviewing report impact 9:06am – 10:25am: Session Contd - 7 deadly sins of Charting - What the experts say - Exercise 2 - Creating an automated chart & Pivot Table report from data table data - Optimizing file size for Pivot reports & charts - Charting techniques exercise - applying the best practice techniques - Grouping / bucketing transactional dates data to create reports 10:26am-10:40am: Break 10:41am-11:00am: Session Contd - Using slicers to create a reporting dashboard with multiple Pivot Tables / Charts from the same data source 11:01am - 12:00pm: Session Contd - Exercise 3 - Creating Pivot Table reports on separate sheets for each department, project, activity category etc with every report having the drill-down capability to the transaction details - Creating cell-sized line & column charts – a data visualization technique - Final Questions & Answers
|
|
PDU's: |
PDU: 4 Technical |
| About the Speaker |
Areef Ali
B.Sc., FCCA, CA MBA, MCT
Areef Ali is a Microsoft certified trainer, business productivity consultant, and entrepreneur. He has over twenty-seven (27) years of diverse work experience. He is a member of ICATT, and ACCA & serves on the Georgetown Chamber of Commerce & Industry Trade & Investment Committee.
He worked as an auditor with a big four accounting firm and then served as a management reporting professional in the Energy sector. He was subsequently appointed the Chief Accountant and then the Corporate Finance Head at a leading financial institution. In June 2006, Areef started his own training and consulting business.
AAABS does training and completes projects for numerous organizations, both private and public sector in MS Excel work productivity techniques, Financial/business modeling, Power BI reporting, Management reporting automation, Audit & Fraud automation techniques, and Dashboard development.
He is a Microsoft certified trainer at the Expert level in Excel and is also a certified Power BI consultant/trainer. He has trained with and hosted public seminars with many world-renowned experts including Bill Jelen - Mr. Excel & professional bodies such as the ACFE.
In April 2017, Areef launched the “AA Success Centre” - a corporate retreat, meeting, training, and events rental Centre. Areef’s aim and passion is to inspire individuals and organizations to find success.
LinkedIn Profile: https://www.linkedin.com/in/areef-ali-18a42313/
|
Cancellation and No-Show Policy: If you have made a reservation and find that you will be unable to attend, please send an email to profdev@pmisfbac.org to cancel your ticket as early as possible. All cancellations are subject to a fee. Cancellations after the event starts are subject to full charge to ensure the Chapter does not incur excessive expenses. |
It is no longer possible to register for this event
