top of page
1planningwix.png
Event Details

Event Details

Description

This training program is designed to empower participants with the knowledge and practical skills needed to automate data processes, create visually engaging reports, and leverage digital tools for efficient decision-making. Through hands-on exercises and real-world applications, participants will gain proficiency in utilizing Microsoft Power BI.

The course is designed for learners who do not have any technical background. Microsoft Power BI is user-friendly and can easily be learned without any background in programming, statistics, or other data science platforms.


Objectives

At the end of this training, participants will be well-equipped to integrate data automation and visualization into their workflows, enabling them to produce insightful reports and support informed decision-making within their organizations. Microsoft PowerBI Desktop will be used.


More specifically, participants will be able to:

  1. Demonstrate comprehensive understanding of Microsoft Power BI, including its interface, basic functionalities, and navigation skills

  2. Display proficiency in data management and cleaning using Power BI's Power Query. They will apply these skills to effectively transform raw data into formats suitable for analysis and visualization.

  3. Create compelling visualizations and charts. This includes the application of sophisticated techniques, enhancing their capability to convey insights effectively through visual data representation.

  4. Create polished and professional reports and dashboards in Power BI. They will showcase their ability to present data insights in a visually appealing and informative manner, supporting effective decision-making within their organizations


Course Outline


Day 1: Foundation of Data Automation and Visualization


Session 1: Introduction to Data Automation

  • Understanding the role of data automation in organizational efficiency.

  • Key concepts and terminology.

  • Benefits and challenges of data automation.

Session 2: Overview of Digital Tools for Data Automation and Reporting

  • Introduction to popular tools (e.g., Microsoft Power BI, Tableau, Google Data Studio).

  • Comparative analysis of features and functionalities.

  • Focus: Microsoft Power BI.

Session 3: Data Preparation and Cleaning

  • Best practices for data cleaning and preparation.

  • Importing and connecting to data sources.

  • Hands-on exercises: Cleaning and preparing sample datasets.

Session 4: Basic Visualization Techniques

  • Introduction to fundamental data visualization concepts.

  • Creating basic charts, graphs, and tables.

  • Customizing visualizations for effective communication.


Day 2: Hands-on Workshop


Session 5: Data Preparation

Session 6: Data Structuring

Session 7: Dashboard Creation


Day 3: Advanced Data Automation and Visualization Techniques


Session 8: Advanced Visualization Techniques

  • Exploring advanced visualization options (e.g., interactive maps, advanced charts).

  • Combining multiple visualizations for comprehensive reporting.

  • Hands-on exercises on creating complex visualizations.

Session 9: Automation of Data Processes

  • Setting up automated data refresh and updates.

  • Incorporating data from live sources.

  • Ensuring data accuracy and consistency in automated processes.

Session 10: Building Interactive Dashboards

  • Design principles for creating user-friendly dashboards.

  • Building interactive and dynamic dashboards.

  • Incorporating filters and parameters for user customization.

September 18, 19 and 20, 2024

8:00am to 5:00pm

Somerset Central Salcedo Makati


(+632) 8404 9524

Speakers

Resource Speaker

Dr. Marshall Valencia

Dr. Marshall Valencia

Dr. Marshall Valencia is a social and organizational psychologist with 20 years of professional experience as an HR and organizational consultant, a trainer, and a social scientist. He is the Director for Research and Analytics of PVP and also a faculty member in the graduate program of the Psychology Department of the University of the Philippines. He was a former faculty and director for research at the Nottingham University Business School. He has published his researches and presented in scientific conferences in Italy, France, Germany, Switzerland, U.S.A., Australia, South Africa, Japan, Thailand, and Malaysia.

For more questions and clarifications:

Thanks for submitting! If you are interested contact

(+632) 8404 9524 or email us at training@pvpi.ph

bottom of page