 Cert Prep - Connecting to Power BI Data/thumbnail.webp?token=Y291cnNlcy8yMDIzLzAxL1Bvd2VyIEJJIERhdGEgQW5hbHlzdCBBc3NvY2lhdGUgKFBMLTMwMCkgQ2VydCBQcmVwIC0gQ29ubmVjdGluZyB0byBQb3dlciBCSSBEYXRhL3RodW1ibmFpbC53ZWJwOjE3ODQ0NzM4ODY6NGQ3MDFmNThkMTU1MWQwZDMzZTI3ZTNiMjViZDdhM2U2ZGUyNGU5ZDRmMWY1ZTg1ODI5ZGVlZjVhYTNmZTIzNg%3D%3D)
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
Related courses
- Power BI Data Analyst Associate (PL-300) Cert Prep: Creating Reports in Power BI
- Power BI Data Analyst Associate (PL-300) Cert Prep: Cleaning, Transforming, and Loading Data in Power BI
- Power BI Data Analyst Associate (PL-300) Cert Prep: Managing Datasets in Power BI
- Power BI Data Analyst Associate (PL-300) Cert Prep: Designing and Developing a Power BI Data Model
- Power BI Data Analyst Associate (PL-300) Cert Prep: Create Model Calculations Using DAX
- Power BI Data Analyst Associate (PL-300) Cert Prep: Advanced Reporting in Power BI
- Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2025)
- Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep (2024)
Related learn paths
- Prepare for the Power BI Data Analyst Associate (PL-300) Certification
- Moving from Data Analyst to Data Scientist
- Become a Data Analyst
- Become a Business Intelligence Specialist
- Introduction to Fundamental Skills for Data Work: Data Analysis and Interpretation
- Explore a Career in Data Analysis
- Develop Your Data Analysis Skills
- Get Ahead in Business Analytics and Analysis