Get Job Ready with Power BI Data Analytics for All Levels.
Build, Analyze, and Visualize with Power BI and Data Analysis.
Continuing Education approved courses for Multiple Qualifications
On-Demand Courses
Individual Certificates for each Module
Courses authored by Subject Matter Experts
Shareable Certificate on LinkedIn
Want to take your data analytics skills to the next level? This course provides a complete journey from basic to advanced techniques in data transformation and visualization using Power BI and Excel. Discover how to utilize pivot tables and time-saving data analysis methods to enhance your efficiency. The course also covers critical topics in business intelligence, data mining, and mapping tools, empowering you to extract valuable insights from complex datasets. Ideal for CPAs, analysts, and data professionals, this course equips you with the skills to drive data-based decisions and transform your organization’s data landscape.
Power Query for Efficient Data Transformation and Automation.
DAX In Excel and Power BI for Advanced Data Analysis.
Interactive Dashboards to Visualize and Communicate Data Insights.
Best Practices for Managing and Merging Data in Excel.
CPAs, Data analysts, and other Professionals seeking to elevate their expertise in data transformation, visualization, and reporting techniques through Power BI, going beyond basic levels to master advanced concepts like DAX and Power Query.
Professionals and Research Analysts who want to learn how to effectively visualize and present data findings, improving their ability to communicate insights to stakeholders.
Individuals interested in improving their data literacy and analytical capabilities, regardless of their current level and want to develop a comprehensive understanding of data analytics tools and techniques to excel in today's data-driven landscape.
Handout PDFs for every ModuleGlossary/Key Terms for every ModuleQ&A directly with instructors.Data AnalystBusiness Intelligence DeveloperData ScientistExcel AnalystPower BI ConsultantEnhanced Analytical SkillsProficiency in Power BIAutomation TechniquesData Visualization MasteryModule Name
Duration
4 Hours
President , EXCEL Accountant
1.5 Hours
Owner , The Excel Trainer
2 Hours
President , EXCEL Accountant
1 Hour
Owner , The Excel Trainer
1 Hour
Owner , The Excel Trainer
1.5 Hours
FP&A Systems Lead , DEEL Canada Service Inc.
1.5 Hours
Owner , The Excel Trainer
1.5 Hours
Owner , The Excel Trainer
4 Hours
President , EXCEL Accountant
2 Hours
President , EXCEL Accountant
1 Hour
Owner , The Excel Trainer
1.5 Hours
Founder & CEO , VITTPRO
1 Hour
Owner , The Excel Trainer
3 Hours
Account Executive , BUSINESS & INT’L TRADE EDITORIAL
1 Hour
Owner , The Excel Trainer
6 Hours
Founder & CEO , VITTPRO
1 Hour
FP&A Systems Lead , DEEL Canada Service Inc.
4 Hours
Founder & CEO , VITTPRO
1 Hour
FP&A Systems Lead , DEEL Canada Service Inc.
1 Hour
Owner , The Excel Trainer
1.5 Hours
FP&A Systems Lead , DEEL Canada Service Inc.
President, EXCEL Accountant
I own an Atlanta-based training and consulting firm that helps businesses nationwide streamline accounting challenges. Our specialties include:
Our services include training, technical support, accounting automation, and problem solving. I have spoken at conferences or meetings for these organizations:
I teach over 200 live webinars annually on Microsoft Excel across roughly two-dozen training providers. I am available for in-house training or select conference engagements as well.
I am the co-author of Idiot's Guide to Introductory Accounting. I've published hundreds of freelance articles on various topics, including Lotus 1-2-3, Quattro Pro, Microsoft Excel, Microsoft Office Accounting, QuickBooks, Peachtree Accounting, and more.
I serve as the technical editor for several books in Wiley's Dummies series, including QuickBooks for Dummies, Quicken for Dummies, Peachtree for Dummies, and more.
Specialties: Microsoft Excel, Visual Basic for Applications, Sage 50, Peachtree Accounting, QuickBooks, Microsoft Office Accounting, freelance writing, training, business consulting
Account Executive, BUSINESS & INT’L TRADE EDITORIAL
Garrett Wasny, MA, CMC, CITP/FIBP, is an artificial intelligence skills advisor to accountants worldwide and Director of the forthcoming AI Accounting Future Forum. This groundbreaking platform is set to revolutionize how accounting professionals engage with artificial intelligence. A former Price Waterhouse management consultant, Garrett has authored 60+ ebooks, delivered thousands of seminars and webinars to elite accounting enterprises around the globe, and developed dozens of AI apps on accounting technology, tax and ethics topics.
FP&A Systems Lead, DEEL Canada Service Inc.
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. He also sat as an Examiner for the International English Language Testing System (or IELTS) in the 1990s. On top of these, he is an exam trainer for various high profile exams, such as GRE (or Graduate Record Examination), GMAT (or Graduate Management Admission Test), TOEFL (or Test of English as a Foreign Language), and math contests such as Euler, Gauss and Pascal. He has published books on test taking strategies.
Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada.
Lenny's motto at work is "Don’t work hard, work smart". Lenny has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
Founder & CEO, VITTPRO
Energetic, ambitious and Result-oriented professional, offering +15 years of extensive experience in Management, operations, Finance, Audit, Risk management, marketing and Customer experience.
Manish has hands-on experience in Monthly Reporting and Pnl Analysis, Budgeting and strategic planning.
Passionate for learning and development, thinking in innovative and non-traditional ways, Manish is your business partner for growth.
Manish is experienced with leading projects for change. He has led ERP implementation for 16 hotels in Htoo Group.
Manish is focused, display positive attitude and Topline growth approach towards business problems. He believes in efficiencies and lean management.
He is also on his Entrepreneurial journey and founded https://ehotelmanagementschool.com for sharing knowledge and experience via online classes and sessions. Startup also help small hotels and other startups with finance and management consulting.
Owner, The Excel Trainer
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials.
He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare, pharmaceutical and public sector.
In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
The Certified Data Analytics & Power BI Mastery course took me from basic Excel skills to confidently using Power BI for complex analyses💡. The practical exercises made it easy to grasp advanced concepts, and the supportive community was a huge bonus.
This course exceeded my expectations! The hands-on exercises made learning DAX and Power Query enjoyable and practical.👍 I now feel confident in turning complex data into compelling visual reports.
MyCPE did it again! This training will benefit my career 😎It gave me a better understanding of how Power BI functions and I hope that my new skills will help me create new projects for my company!
Certificate awarded upon the successful completion of the myCPE Advanced Certification Program is proof that user has successfully undergone the training and passed the quiz. This certificate marks completion of the said courses and learning activities and completion of the review quiz to earn continuing educational credits for specific qualification mentioned. This advance certificate program is not approved by any educational institution, training institute or regulatory body.
The Certified Data Analytics & Power BI Mastery (CDAPBM) course covers a comprehensive range of topics essential for mastering data analytics and visualization. Key areas include Power Query for data transformation, DAX for advanced calculations in Excel and Power BI, and effective data visualization techniques to create interactive reports and dashboards. Participants will also learn about pivot tables, data management, business intelligence, and data mining, all aimed at equipping them with the skills to analyze and present data in a meaningful way, ultimately enhancing their decision-making capabilities.
The Certified Data Analytics & Power BI Mastery (CDAPBM) course will be highly beneficial by equipping you with essential skills in data analytics and visualization, enhancing your ability to manage and interpret data effectively. It improves decision-making by teaching you how to present insights clearly through compelling visualizations and automated processes, saving time and reducing errors. Additionally, the certification enhances your career prospects in an increasingly data-driven job market, offers hands-on experience applicable to real-world scenarios, and connects you with a network of professionals, positioning you as an asset in your organization.
