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:
Demonstrate comprehensive understanding of Microsoft Power BI, including its interface, basic functionalities, and navigation skills
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.
Create compelling visualizations and charts. This includes the application of sophisticated techniques, enhancing their capability to convey insights effectively through visual data representation.
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
Resource Speaker
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.
