Enterprise Dataflows & Automation Masterclass
Master enterprise data management and automation through comprehensive hands-on training with MySQL databases, Python programming, Microsoft Power Business Intelligence, and Power Automate workflows. Build complete end-to-end solutions integrating multiple data sources, automated processing pipelines, and intelligent reporting systems. Excel in specialized enterprise dataflow skills under the guidance of industry authorities. Enroll in our comprehensive training program tailored specifically for thorough enterprise automation skill development.
- Available in:
- Malaysia
- Upcoming intakes:
- Jul 27, 2026
- Jul 27, 2026
- Jul 27, 2026
Share this course
Public Pricing
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

What you'll learn
- Install, configure, and secure MySQL databases with proper indexing strategies
- Integrate multiple data sources into cohesive enterprise reporting solutions
- Build custom workflows and approval processes with Microsoft Power Automate
- Implement governance frameworks and security policies for data management
- Design and deploy end-to-end automated data processing pipelines
- Create automated dataflows and interactive reports using Power Business Intelligence
- Develop Python scripts for data extraction, transformation, and loading processes
Why should you attend?
This comprehensive training program provides hands-on experience with enterprise-level data management and automation technologies. Participants begin with foundational database concepts using MySQL, covering installation, configuration, querying, indexing, and security implementation. The curriculum progresses through Python programming fundamentals, emphasizing data manipulation, file handling, and database connectivity for building robust data processing pipelines. The program advances into Microsoft Power Business Intelligence for creating sophisticated data visualizations and reports. Students learn to connect multiple data sources, perform complex transformations using Power Query, and build automated dataflows with scheduled refresh capabilities. Advanced modeling techniques including star schema design and Data Analysis Expressions calculations are covered extensively. Automation capabilities are explored through Microsoft Power Automate, where participants create custom workflows, implement approval processes, and integrate with Microsoft 365 applications. External system integration through Application Programming Interfaces and gateway connections enables comprehensive enterprise automation solutions. The final phase focuses on advanced dataflow concepts, governance frameworks, and security implementations. Students complete a capstone project integrating all learned technologies into a complete enterprise solution, demonstrating practical application of MySQL database management, Python data processing, Power Business Intelligence reporting, and Power Automate workflow automation in a real-world scenario.
Course Syllabus
Day 1 - MySQL Database Fundamentals
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Day 2 - Python Data Processing
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 2
Day 3 - Power BI Analytics
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 3
Day 4 - Power Automate Workflows
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 4
Day 5 - Integration & Final Project
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 5
Ratings and Reviews
Instructor
Instructor
Instructor
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally.
Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications.
Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges.
As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels.
Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
Instructor
Instructor Reviews
Tasmeea Rahman
Data Analytics & Engineering Training Specialist"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."
"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."
"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."
Mohammad Mehdi Lotfinejad
Chief Data Officer & Data Science Trainer"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."
"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."
"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."
FAQ
Frequently Asked Questions About This Course
- Public pricing: applies for individuals signing up from different companies.
- Corporate pricing: applies if a company wants to have an intake for its employees only.
- Training provider pricing: applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.
We will keep you updated on the status of the intake after you enroll.
Courses you may like
Why should you attend?
This comprehensive training program provides hands-on experience with enterprise-level data management and automation technologies. Participants begin with foundational database concepts using MySQL, covering installation, configuration, querying, indexing, and security implementation. The curriculum progresses through Python programming fundamentals, emphasizing data manipulation, file handling, and database connectivity for building robust data processing pipelines. The program advances into Microsoft Power Business Intelligence for creating sophisticated data visualizations and reports. Students learn to connect multiple data sources, perform complex transformations using Power Query, and build automated dataflows with scheduled refresh capabilities. Advanced modeling techniques including star schema design and Data Analysis Expressions calculations are covered extensively. Automation capabilities are explored through Microsoft Power Automate, where participants create custom workflows, implement approval processes, and integrate with Microsoft 365 applications. External system integration through Application Programming Interfaces and gateway connections enables comprehensive enterprise automation solutions. The final phase focuses on advanced dataflow concepts, governance frameworks, and security implementations. Students complete a capstone project integrating all learned technologies into a complete enterprise solution, demonstrating practical application of MySQL database management, Python data processing, Power Business Intelligence reporting, and Power Automate workflow automation in a real-world scenario.
What you'll learn
- Install, configure, and secure MySQL databases with proper indexing strategies
- Integrate multiple data sources into cohesive enterprise reporting solutions
- Build custom workflows and approval processes with Microsoft Power Automate
- Implement governance frameworks and security policies for data management
- Design and deploy end-to-end automated data processing pipelines
- Create automated dataflows and interactive reports using Power Business Intelligence
- Develop Python scripts for data extraction, transformation, and loading processes
Course Syllabus
Day 1 - MySQL Database Fundamentals
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 1
Day 2 - Python Data Processing
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 2
Day 3 - Power BI Analytics
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 3
Day 4 - Power Automate Workflows
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 4
Day 5 - Integration & Final Project
Short Break
15 minsRecap and Q&A
15 minsLunch
1 hourShort Break
15 minsRecap and Q&A
15 minsEnd of Day 5
Instructor Reviews
Tasmeea Rahman
Data Analytics & Engineering Training Specialist"Tasmeea was an excellent teacher. Very pleasant, willing to assist and answer concerns, and continuously asked how she could assist more. She made the course enjoyable as well as informative."
"Thank you so much for your invaluable guidance. I really enjoyed it and appreciated how much fun you made it! I feel much more equipped to cope with difficult challenges."
"The training was both fascinating and beneficial. Many members of the staff commented on how useful it was. Tasmeea delivers the topic with authority, wit, and passion."
Mohammad Mehdi Lotfinejad
Chief Data Officer & Data Science Trainer"Mehdi and I worked on several projects with company such as Petronas , Shell and CIMB Regional ETC. I must say Mehdi's training was highly appreciated by our clients as he was able to exhibit in full display his vast knowledge as a Data professional. I would highly recommend him to anyone looking for a top tier training expert."
"Not only knowledgeable but also having hands dirty on what he knows Friendly and building networks quickly."
"I had the pleasure of working with Mehdi together on some high-level initiatives such as the Petronas data scientist program and Shell's project to become a data-driven organization. During these projects, Mehdi received numerous accolades for his ability to share his knowledge and mentor up-and-coming data scientists. Based on our shared experiences, I have no hesitation in recommending Mehdi for any project or position he may be considered for."
Share this course
Public Pricing
Corporate Pricing
Pax:
Training Provider Pricing
Pax:
Features
Target Audience
Methodologies
Subsidies

Ratings and Reviews
Instructors
Dr. Esther Suria Kala is a highly accomplished ICT consultant and corporate trainer with nearly 30 years of extensive experience in information technology, project management, and organizational development. As the founder of Angel Software Solutions, she has established herself as a versatile and dedicated professional who delivers cutting-edge training solutions across Malaysia and internationally.
Her academic credentials are exceptional, including a PhD in Psychology with a focus on Human Behaviour and Human Resources, an MBA in Finance, and degrees in both Computer Science and Human Resources. Currently pursuing a second PhD in IT Information Security, Dr. Esther demonstrates an unwavering commitment to continuous learning and staying at the forefront of technological advancement. Her educational foundation is complemented by an impressive array of professional certifications, including Microsoft Certified Trainer (MCT), CISSP, ITIL, SAP Certified Associate, Certified Cyber Security Professional, Data Scientist, AI Engineering, and ECBA certifications.
Dr. Esther's technical expertise spans an extensive range of domains, from traditional programming languages like Java, C++, and PHP to modern technologies including Python, AI coding, machine learning, RPA, and IR 4.0 microservices. She is proficient in database management systems including Microsoft SQL Server and Oracle, web development frameworks, and enterprise solutions like SAP Crystal Reports and SharePoint Server. Her knowledge extends to cybersecurity, ethical hacking, network administration, and data analytics, making her uniquely qualified to address both technical and strategic business challenges.
As a trainer, Dr. Esther excels in bridging the gap between technical complexity and practical application. She delivers comprehensive training programs for both IT and non-IT professionals, covering everything from software development and cloud computing to soft skills such as digital marketing, business analysis, customer service, and project management. Her ability to communicate effectively in both English and Bahasa Malaysia enables her to connect with diverse audiences across different organizational levels.
Her impressive client portfolio includes leading organizations such as Maybank, Telekom Malaysia, Malaysian Airlines, Tenaga Nasional Berhad, Bank Negara, Ministry of Education, Ministry of Finance, and numerous multinational corporations. This extensive experience across banking, telecommunications, government, aviation, and technology sectors demonstrates her adaptability and deep understanding of varied industry requirements. Recognized with the Outstanding Achievement Award in Information Technology from University Malaya in 2013, Dr. Esther continues to empower organizations through innovative training solutions that drive digital transformation and professional excellence.
Courses you may like
FAQ
Frequently Asked Questions About This Course
- Public pricing: applies for individuals signing up from different companies.
- Corporate pricing: applies if a company wants to have an intake for its employees only.
- Training provider pricing: applies only for other training providers looking to hire our trainers and use our content. Our content has a licensing fee.
We will keep you updated on the status of the intake after you enroll.
Our Offers
Academy for Trainers Academy for Trainers
Teach what you love. Abundent Academy gives you the tools you need to run your own trainings! We provide you with the platform, the students, the materials, and the support you need to succeed!
- Higher trainer payouts
- Ready-made course materials
- Student management system
- AI digital marketing assistant
Academy for Corporates Academy for Corporates
Get unlimited access to all of Abundent Academy's carefully curated courses for your team, all organized according to learning paths and roles! Perfect for companies looking to upskill their workforce and stay ahead in the tech industry.
- Carefully curated courses
- Role-based learning paths
- Team progress tracking
- Gap Identification and Analysis
Academy for Partners Academy for Partners
White-label IT training delivery for training providers. We become your behind-the-scenes delivery arm so you can say yes to more clients without hiring more trainers.
- Expand your training catalog
- 40+ expert trainers ready
- White-label delivery
- You keep client relationships