|
|
|
|
| LEADER |
06138nmm a2200481 u 4500 |
| 001 |
EB002154711 |
| 003 |
EBX01000000000000001292837 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
230404 ||| eng |
| 020 |
|
|
|a 9781484290132
|
| 050 |
|
4 |
|a QA76.3
|
| 100 |
1 |
|
|a Jolly, Jessica
|
| 245 |
0 |
0 |
|a Microsoft Power BI Data Analyst Certification companion
|b preparation for exam PL-300
|c Jessica Jolly
|
| 260 |
|
|
|a New York, NY
|b Apress
|c 2023
|
| 300 |
|
|
|a 392 pages
|b illustrations
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 505 |
0 |
|
|a 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
|
| 653 |
|
|
|a Microsoft software / Examinations / Study guides
|
| 653 |
|
|
|a Examinations / fast
|
| 653 |
|
|
|a Microsoft Power BI (Computer file) / fast
|
| 653 |
|
|
|a Microsoft software / Examinations / fast
|
| 653 |
|
|
|a Gestion / Informatique / Examens / Guides de l'étudiant
|
| 653 |
|
|
|a Logiciels Microsoft / Examens / Guides de l'étudiant
|
| 653 |
|
|
|a Business / Data processing / Examinations / Study guides
|
| 653 |
|
|
|a Microsoft Power BI (Computer file) / Examinations / Study guides
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 490 |
0 |
|
|a Certification study companion series
|
| 500 |
|
|
|a Includes index
|
| 024 |
8 |
|
|a 10.1007/978-1-4842-9013-2
|
| 776 |
|
|
|z 1484290127
|
| 776 |
|
|
|z 9781484290125
|
| 776 |
|
|
|z 9781484290132
|
| 776 |
|
|
|z 1484290135
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9781484290132/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 374
|
| 082 |
0 |
|
|a 006.6/8
|
| 082 |
0 |
|
|a 330
|
| 520 |
|
|
|a 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 of knowledge in each area. Each topic is presented with a blend of practical explanations, theory, and best practices. Power BI is more than just the Power BI Desktop or the Power BI Service. It is two distinct applications and an online service that, together, enable business users to gather, shape, and analyze data to generate and present insights. This book clearly delineates the purpose of each component and explains the key concepts necessary to use each component effectively. Each chapter provides best practices and tips to help an inexperienced Power BI practitioner develop good habits that will support larger or more complex analyses. Many business analysts come to Power BI with a wealth of experience in Excel and particularly with pivot tables. Some of this experience translates readily into Power BI concepts. This book leverages that overlap in skill sets to help seasoned Excel users overcome the initial learning curve in Power BI, but no prior knowledge of any kind is assumed, terminology is defined in non-technical language, and key concepts are explained using analogies and ideas from experiences common to any reader. After reading this book, you will have the background and capability to learn the skills and concepts necessary both to pass the PL-300 exam and become a confident Power BI practitioner
|