Master Creative Transformation of Raw Data into Business Intelligence.
Master the Art of Reshaping Raw Data into Valuable Information.
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
Converting data into information is one of the biggest challenges of the modern time to making transformative decisions. This certification course helps you with simple solutions to convert raw data into structured meaningful formats, using Power Query and Power BI functionalities. Interactive reports, business intelligence, and reporting functionalities right from the familiar environment of Excel can prove to be a very effective tool to open the world of smart decisions.
Locating useful commands such as Append Query within Power Query.
Unpivoting unusable data to make it report-ready.
Benefits of transforming data with Power Query.
Business intelligence and reporting functionalities with Power Pivot.
This advanced certification is created keeping in mind the requirements of a successful CFO to play his role skillfully and can be path-breaking for professionals such as CPAs in key positions.
This course can provide valuable insights and pointers to professionals aspiring to take the position of a CFO.
The certification can also be helpful to Business owners, Managers, Professionals, and students in understanding the role of a CFO and learning from the same.
Handout PDFs for every ModuleGlossary/Key Terms for every modulQ&A directly with instructors.Data Strategy ConsultantBusiness Analytics ManagerData Governance SpecialistChief Data OfficerBusiness ConsultantData Integration SpecialistData ManagementAttention to detail skillsCritical thinking skillsProblem-solving skillsExcel AutomationAnalytical Thinking skillsModule Name
Duration
4 Hours
President , EXCEL Accountant
1 Hour
Owner , The Excel Trainer
1 Hour
Owner , The Excel Trainer
1.5 Hours
Owner , The Excel Trainer
1.5 Hours
Owner , The Excel Trainer
1.5 Hours
Owner , The Excel Trainer
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
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 instructor understands the key aspects of data cleaning to create information. Though I took a chance on this course, I am very happy that I did. The course has real useful information and insights to earn an advantage in the decision making if we successfully apply the learnings. I do not think it is difficult or complex to expect that. I think you will love this course as well.
I liked the examples and functionalities included for the type of the course. It was specifically useful for bad data sets. I work with this type of raw data and it usually ends up eating up much of my time. Finally, I found something feasible for my needs. Very effective. Definitely worth a try.
The speaker has a strong knowledge, experience, and explains the approach very well. The examples had a number of varieties to include multiple types of situations and complexities. I enjoyed learning with the course and I am sure it will help me solve some of my problems that I face frequently and spend a lot of time on. Thank you myCPE for this very useful course.
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.
3 Ratings
ES
Nov 20th, 2023
Overall, the courses were explained well. Content was good, perhaps you can add more content on publishing Dashboards and how to best setup different versions for different regions. That would be useful
The Power BI Certification (PBC) provides a strong perspective of using a familiar Excel environment to transform raw data into useful information. The certification covers key aspects of Power Query, and PowerBI. The certification also covers importing data from various sources, clearing and structuring the data, and leveraging the functionalities to benefit from the transformation of data. Unpivoting and segregating the data carefully to be useful and otherwise seamlessly provides simplicity in executing the data transformation process. The certification helps with the advanced functions of Power Query, DAX, and Power BI to generate multiple data sets and interactive reports and evaluate the ways of leveraging functionalities to simplify the overall process.
The Power BI Certification (PBC) helps with the key skills of segregating and transforming data sets to make strategic decisions. The certification provides a strong coverage of Power Query and Power BI in the familiar Excel environment. It promotes simplicity and convenience to save more time to take even complex decisions. Further, it also helps with creating reports and interactive reporting requirements that serve with the changing requirements, evaluation, and analysis. Thus, the Certified Data Transformation Specialist course provides a strong opportunity to make an impact in the transformative decision-making process.
