Course Features
Price
Study Method
Online | Self-paced
Course Format
Reading Material - PDF, article
Duration
16 hours, 55 minutes
Qualification
No formal qualification
Certificate
At completion
Additional info
Coming soon
- Share
Overview
Who is this course for?
Requirements
Career path
-
- Why Use Power Query & Power Pivot? 00:10:00
- Advanced Process for Better Dashboard Creation 00:10:00
- Course Materials 00:10:00
-
- Project Overview 00:10:00
- How to Activate Excel Power Pivot 00:10:00
- Importing Data into Power Query 00:10:00
- Transform vs Add Columns Explained 00:10:00
- Importing Multiple Tables 00:10:00
- Updating Workbook Settings for Dates & Time 00:10:00
- Checking Errors & Removing Unwanted Data 00:10:00
- Adding Index Number in Power Query 00:10:00
- Merging Queries 00:10:00
- Basic Append Queries 00:10:00
- Best Way to Append Queries Using Folder Auto Update 00:10:00
- Creating a Custom Calendar Table 00:10:00
- Creating Auto-Update Date Table 00:10:00
- Moving Data into Power Pivot from Worksheet 00:10:00
- Data Source Settings in Power Query 00:10:00
- Data View vs Diagram View 00:10:00
- Database Normalization Explained 00:10:00
- Creating Relationships in Power Pivot 00:10:00
- Editing Relationships in Power Pivot 00:10:00
- Power Pivot View vs Normal Pivot Table 00:10:00
- Power Query & Data Modelling Recap 00:10:00
- Introduction to DAX 00:10:00
- Adding DAX Calculated Column 00:10:00
- Calculated Column with IF Function 00:10:00
- Calculated Column with SWITCH Function 00:10:00
- Total Revenue with Calculated Column 00:10:00
- Introduction to DAX Measures 00:10:00
- Writing DAX in Measure Box 00:10:00
- Implicit vs Explicit Measures 00:10:00
- Creating a Separate Measures Table 00:10:00
- Calculating COGS & Gross Profit 00:10:00
- Calculating Return Rate 00:10:00
- Using ALL Function 00:10:00
- Using FILTER Function 00:10:00
- Filtering Table with DAX 00:10:00
- Marking Your Date Table 00:10:00
- YTD, MTD & QTD Time Intelligence 00:10:00
- Last Month Revenue & MoM % Change 00:10:00
- 10-Day Rolling Total 00:10:00
- 10-Day Transactional Average 00:10:00
- Best Practices for Counting in DAX 00:10:00
- Exam of Master Dynamic Excel Dashboards: Advanced Power Query, Power Pivot & DAX 00:50:00
Is this certificate recognized?
Yes, our premium certificate and transcript are widely recognized and accepted by embassies worldwide, particularly by the UK embassy. This adds credibility to your qualification and enhances its value for professional and academic purposes.
I am a beginner. Is this course suitable for me?
Yes, this course is designed for learners of all levels, including beginners. The content is structured to provide step-by-step guidance, ensuring that even those with no prior experience can follow along and gain valuable knowledge.
I am a professional. Is this course suitable for me?
Yes, professionals will also benefit from this course. It covers advanced concepts, practical applications, and industry insights that can help enhance existing skills and knowledge. Whether you are looking to refine your expertise or expand your qualifications, this course provides valuable learning.
Does this course have an expiry date?
No, you have lifetime access to the course. Once enrolled, you can revisit the materials at any time as long as the course remains available. Additionally, we regularly update our content to ensure it stays relevant and up to date.
How do I claim my free certificate?
I trust you’re in good health. Your free certificate can be located in the Achievement section. The option to purchase a CPD certificate is available but entirely optional, and you may choose to skip it. Please be aware that it’s crucial to click the “Complete” button to ensure the certificate is generated, as this process is entirely automated.
Does this course have assessments and assignments?
Yes, the course includes both assessments and assignments. Your final marks will be determined by a combination of 20% from assignments and 80% from assessments. These evaluations are designed to test your understanding and ensure you have grasped the key concepts effectively.
Is this course accredited?
We are a recognized course provider with CPD, UKRLP, and AOHT membership. The logos of these accreditation bodies will be featured on your premium certificate and transcript, ensuring credibility and professional recognition.
Will I receive a certificate upon completion?
Yes, you will receive a free digital certificate automatically once you complete the course. If you would like a premium CPD-accredited certificate, either in digital or physical format, you can upgrade for a small fee.
Course Features
Price
Study Method
Online | Self-paced
Course Format
Reading Material - PDF, article
Duration
16 hours, 55 minutes
Qualification
No formal qualification
Certificate
At completion
Additional info
Coming soon
- Share
Call Centre Training: Mastering Customer Service & Communication
Course Line239Original price was: £490.00.£14.99Current price is: £14.99.Childminding Level 8 Advanced Diploma
Course Line239Original price was: £490.00.£14.99Current price is: £14.99.
