PowerBl Formulas Course
Interactive Video Lessons | Free E-Certificate | Tutor Support
Princeton X
Summary
- Reed Courses Certificate of Completion - Free
- Tutor is available to students
Add to basket or enquire
Overview
Power BI Formulas Course: Gain mastery over Power BI formulas with our comprehensive course designed to elevate your analytical skills. Whether you're a novice or an experienced user, this course provides in-depth instruction on DAX and M code, empowering you to manipulate and analyze data efficiently. Learn to create dynamic calculations, sophisticated measures, and intricate queries to extract valuable insights from your datasets. With practical examples and hands-on exercises, you'll sharpen your proficiency in crafting powerful formulas tailored to your specific business needs. Unlock the full potential of Power BI and transform raw data into actionable intelligence with our expert-led formulas course.
Certificates
Reed Courses Certificate of Completion
Digital certificate - Included
Will be downloadable when all lectures have been completed.
Curriculum
Course media
Description
1. **Starting PowerBI**
- Introduction to PowerBI
- Understanding the interface
- Setting up data connections
2. **Viewing the Excel Data**
- Exploring data in Excel
- Understanding data structure
3. **Importing Non-formatted Data from Excel**
- Data import process
- Handling non-standard data formats
4. **Splitting & Merging Columns**
- Data transformation techniques
- Splitting and merging columns for better analysis
5. **Age Calculation in PowerQuery**
- Calculating age from birthdates
- Date functions in PowerQuery
6. **Basic Math Calculations in PowerQuery**
- Performing basic mathematical operations on data
- Applying arithmetic formulas
7. **Replacing Data in PowerQuery**
- Data cleaning and normalization
- Replacing values in the dataset
8. **Importing Formatted Tables from Excel**
- Importing structured Excel tables
- Handling formatted data import
9. **Age Part 2**
- Advanced age calculation scenarios
- Handling exceptions and edge cases
10. **More Formulas in PowerQuery**
- Advanced transformation techniques
- Custom formulas and expressions
11. **Conditional Columns in PowerQuery**
- Creating conditional logic in PowerQuery
- Filtering and adding columns based on conditions
12. **Managing Relationships in PowerBI**
- Understanding data relationships
- Establishing and managing relationships between tables
13. **Calculating Subtotals in PowerQuery**
- Subtotal calculations for aggregated data
- Grouping and summarizing data in PowerQuery
14. **Table & Matrix Visuals in PowerBI**
- Creating table and matrix visuals
- Formatting and customizing visuals
15. **Calculated Columns in PowerBI**
- Adding calculated columns to the data model
- Utilizing DAX expressions for calculated columns
16. **Measures in PowerBI**
- Introduction to measures
- Aggregating data using measures
17. **Quick Measures in PowerBI**
- Using built-in quick measures
- Simplifying complex calculations with quick measures
Each module builds upon the previous one, providing a comprehensive understanding of PowerBI formulas and functionalities for analyzing sales data effectively.
Requirements
No prior knowledge or experience required
Questions and answers
Currently there are no Q&As for this course. Be the first to ask a question.
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.