This course is designed for those interested to learn how to use Power BI to pull data from various sources and create charts out of that data. Also, learn the many Power BI formulas and functions that can be used. Read more.
Tom Fragale is a computer professional w/over 30 years of experience. He is a Microsoft Certified Trainer. Available for webinars, Live Onsite Training and 1-on-1 training. He is also a published author with a book on Pivot Tables published by Wiley Publishing.
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
In today’s business world, you may need to manage large amounts of data, and then make sense of that data. It could be an overwhelming task.Â
Microsoft Power BI is a tool that helps you pull the data from many sources and make great charts out of that data. This course will show you how to start building formulas in Power BI and Power Query.
This course will cover the following:
- Starting Power BI
- Viewing the Excel data
- Importing non-formatted data from Excel
- Splitting and merging columns
- Age calculation in Power Query
- Basic math calculations in Power Query
- Replacing data in Power Query
- Importing formatted tables from Excel
- Age part 2
- More formulas in Power Query
- Conditional columns in Power Query
- Managing relationships in Power BI
- Calculating subtotals in Power Query
- Table and matrix visuals in Power BI
- Calculated columns in Power BI
- Measures in Power BI
- Quick measures in Power BI
Our Promise to You
By the end of this course, you will have learned how to use Power BI and Power Query.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about getting results using Power BI.
Course Curriculum
| Section 1 - Getting Results With Power BI | |||
| Student File | 00:00:00 | ||
| Starting Power BI | 00:00:00 | ||
| Viewing The Excel Data | 00:00:00 | ||
| Importing Non-Formatted Data From Excel | 00:00:00 | ||
| Splitting And Merging Columns | 00:00:00 | ||
| Age Calculation In Power Query | 00:00:00 | ||
| Basic Math Calculations In Power Query | 00:00:00 | ||
| Replacing Data In Power Query | 00:00:00 | ||
| Importing Formatted Tables From Excel | 00:00:00 | ||
| Age Part 2 | 00:00:00 | ||
| More Formulas In Power Query | 00:00:00 | ||
| Conditional Columns In Power Query | 00:00:00 | ||
| Managing Relationships In Power BI | 00:00:00 | ||
| Calculating Subtotals In Power Query | 00:00:00 | ||
| Table And Matrix Visuals In Power BI | 00:00:00 | ||
| Calculated Columns In Power BI | 00:00:00 | ||
| Measures In Power BI | 00:00:00 | ||
| Quick Measures In Power BI | 00:00:00 | ||
About This Course
In today’s business world, you may need to manage large amounts of data, and then make sense of that data. It could be an overwhelming task.Â
Microsoft Power BI is a tool that helps you pull the data from many sources and make great charts out of that data. This course will show you how to start building formulas in Power BI and Power Query.
This course will cover the following:
- Starting Power BI
- Viewing the Excel data
- Importing non-formatted data from Excel
- Splitting and merging columns
- Age calculation in Power Query
- Basic math calculations in Power Query
- Replacing data in Power Query
- Importing formatted tables from Excel
- Age part 2
- More formulas in Power Query
- Conditional columns in Power Query
- Managing relationships in Power BI
- Calculating subtotals in Power Query
- Table and matrix visuals in Power BI
- Calculated columns in Power BI
- Measures in Power BI
- Quick measures in Power BI
Our Promise to You
By the end of this course, you will have learned how to use Power BI and Power Query.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Get started today and learn more about getting results using Power BI.
Course Curriculum
| Section 1 - Getting Results With Power BI | |||
| Student File | 00:00:00 | ||
| Starting Power BI | 00:00:00 | ||
| Viewing The Excel Data | 00:00:00 | ||
| Importing Non-Formatted Data From Excel | 00:00:00 | ||
| Splitting And Merging Columns | 00:00:00 | ||
| Age Calculation In Power Query | 00:00:00 | ||
| Basic Math Calculations In Power Query | 00:00:00 | ||
| Replacing Data In Power Query | 00:00:00 | ||
| Importing Formatted Tables From Excel | 00:00:00 | ||
| Age Part 2 | 00:00:00 | ||
| More Formulas In Power Query | 00:00:00 | ||
| Conditional Columns In Power Query | 00:00:00 | ||
| Managing Relationships In Power BI | 00:00:00 | ||
| Calculating Subtotals In Power Query | 00:00:00 | ||
| Table And Matrix Visuals In Power BI | 00:00:00 | ||
| Calculated Columns In Power BI | 00:00:00 | ||
| Measures In Power BI | 00:00:00 | ||
| Quick Measures In Power BI | 00:00:00 | ||
Course Review
5.0
2 RatingsRelated Courses
Are you interested in higher education?
All Rights Reserved
Great Information
Excellent presentation
Great Course
This course was quick, easy, and to the point. The instructor did a great job teaching the content. I learned a lot from this course.