Power BI Data Analyst Associate (PL-300) Cert Prep: Connecting to Power BI Data
41mIntermediate2023-01-20
Authors
Joshua Rischin
Company Director of Axium Solutions
Course details
The Power BI Data Analyst Associate certification verifies your capabilities as a data science professional to leverage the Microsoft Power BI data tool. This course is part of a larger series designed to prepare you for the Microsoft PL-300 certification exam. Join instructor Joshua Rischin as he explores the skills you need to know to get ready to tackle the official exam. Learn to connect with a wide range of data sources, including Excel files, CSV flat files, databases, cloud-based data services, and more, as well as how to review and update data properties such as permissions, field properties, and storage options. Along the way, Joshua covers best practices for identifying and resolving Power BI performance issues to help you optimize data flows and outputs.
Skills covered
Power BIBusiness AnalyticsBusiness IntelligenceData AnalysisCert PrepData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoft
Concepts
0. Introduction
- 01 - Power BI data made simple
- 02 - Getting to know Power BI
1. Sourcing Data
- 03 - Get data from a file
- 04 - Get data from a local DB
- 05 - Get data from SQL
- 06 - Get data from other applications
- 07 - Connecting with shared data
2. Configuring Data
- 08 - Working with source data settings
- 09 - Configuring Power BI storage modes
- 10 - Updating field properties
- 11 - Resolving import errors
- 12 - Fixing performance Issues
3. Advanced Data Sourcing
- 13 - Connecting to a Dataverse
- 14 - Connecting with a NoSQL database
Conclusion
- 15 - Next steps