Cargando…
Microsoft Power BI Data Analyst Certification companion : preparation for exam PL-300 /
Use this book to study for the PL-300 Microsoft Power BI Data Analyst exam. The book follows the "Skills Measured" outline provided by Microsoft to help focus your study. Each topic area from the outline corresponds to an area covered by the exam, and the book helps you build a good base o...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
New York, NY :
Apress,
[2023]
|
| Colección: | Certification study companion series.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Intro
- Table of Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Part I: Prepare to Study
- Chapter 1: Exam Overview
- Why Certify?
- When Should You Take the Exam?
- What Is Reasonably Confident?
- Taking the Exam
- Signing Up
- Online or at a Testing Center?
- Choosing Your Time Block
- Marking Your Calendar
- Canceling or Rescheduling Your Exam
- The Exam Format
- General Tips for Exam Taking
- You've Passed. Now What?
- You've Failed. Now What?
- Chapter 2: PL-300 Coverage
- The Tools
- Power BI Desktop
- Desktop Updates
- Reports and Dashboards
- Power Query Editor
- The Power BI Service
- Workspaces, My workspace, and Apps
- Licensing
- Languages
- Practicing Before the PL-300
- Northwind Excel and CSV Files
- AdventureWorks Database
- What and Why?
- Part II: Prepare the Data
- Chapter 3: Get Data from Different Sources
- Getting the Data
- Entering Your Credentials
- Change Data Source Settings
- Changing Data Source Settings
- When a Data Source Moves
- Editing Permissions
- Clear Permissions
- Privacy Levels
- Selecting a Storage Mode
- Import
- Direct Query
- For Future Reference: Writing Your Own SQL Code
- Live Connection
- Using Different Data Sources
- Dataverse
- Dataflows
- Shared Dataset
- Local Dataset
- Using Folders and SharePoint Folders
- Parameters
- Defining Parameters
- Within the Power Query Editor
- In the Power BI Desktop
- Chapter 4: Clean, Transform, and Load the Data
- Accessing the Power Query Editor
- What Is the Power Query Editor?
- The M Language
- Undoing and Redoing a Step
- Naming and Documenting
- Data Quality and Distribution
- Keys and IDs
- Data Types Matter!
- For Future Reference: Query Folding
- Replacing Data
- Blanks and Nulls
- Errors
- Adding New Data
- Adding a New Column
- Adding a New Query
- Keep Only What You Need
- Combining Queries
- Append
- Merging
- Duplicating a query
- Referencing a Query
- Deleting a Query
- Working with Some Data
- Only 1000 Rows?
- For Future Reference: Future-Proofing Your Work
- Excluding and Including Columns
- Resolving Errors in Your Query
- Incorrect Data Type
- Missing or Renamed Column
- For Future Reference: Reusing Your Work
- The Advanced Editor
- Copying a Query
- Copying Parts of an M Script
- Loading Your Queries (or Not)
- A Few Tips and Tricks
- Additional Resources
- Part III: Model the Data
- Chapter 5: Design a Data Model
- Define the Tables
- Dims and Facts
- Using Fields in Visuals
- Relationships: A Model's Connective Tissue
- One-to-Many Relationship (1-Many)
- Many-to-Many Relationships (Many-Many)
- One-to-One (1-1)
- For Future Reference: Disconnected Tables
- Active and Inactive Relationships
- Star Schema
- Relationships and Directions
- Single-Direction Relationships
- Bidirectional Relationships
- Finally, Cardinality!
- Adding a Date Table