
What you’ll learn
- Preparing queries
- Cleansing data with Power Query
- Enhancing queries
- Creating a data model in Power Pivot
- Building relationships
- Creating Pivot Tables and Pivot Charts
- Creating Lookups
- Using DAX to link data
- Creating data model
- Creating relationship between data sources
- Analyzing data with PivotTables and PivotCharts
- Using Power Query with PowerPivot
- Refreshing Data Source
- Updating Queries
- Creating Macros
- Editing Macros
- VBA Scripting
Who this course is for:
- Beginner Business Analyst
- Beginner Data Analyst
- Beginner Data Scientist
Course Created by Bluelime Learning Solutions & Offered by Udemy
Can I download Business Data Analyst:Excel/VBA/Macros/PowerQuery/PowerPivot course?
You can download videos for offline viewing in the Android/iOS app. When course instructors enable the downloading feature for lectures of the course, then it can be downloaded for offline viewing on a desktop.Can I get a certificate after completing the course?
Yes, upon successful completion of the course, learners will get the course e-Certification from the course provider. The Business Data Analyst:Excel/VBA/Macros/PowerQuery/PowerPivot course certification is a proof that you completed and passed the course. You can download it, attach it to your resume, share it through social media.Are there any other coupons available for this course?
You can check out for more Udemy coupons @ www.coursecouponclub.comDisclosure: This post may contain affiliate links and we may get small commission if you make a purchase. Read more about Affiliate disclosure here.