001454907 000__ 06494cam\a22005777i\4500
001454907 001__ 1454907
001454907 003__ OCoLC
001454907 005__ 20230314003234.0
001454907 006__ m\\\\\o\\d\\\\\\\\
001454907 007__ cr\cn\nnnunnun
001454907 008__ 230228s2023\\\\nyua\\\\o\\\\\001\0\eng\d
001454907 019__ $$a1371475133
001454907 020__ $$a9781484290132$$q(electronic bk.)
001454907 020__ $$a1484290135$$q(electronic bk.)
001454907 020__ $$z9781484290125
001454907 020__ $$z1484290127
001454907 0247_ $$a10.1007/978-1-4842-9013-2$$2doi
001454907 035__ $$aSP(OCoLC)1371297658
001454907 040__ $$aORMDA$$beng$$erda$$epn$$cORMDA$$dGW5XE$$dYDX$$dEBLCP
001454907 049__ $$aISEA
001454907 050_4 $$aQA76.3
001454907 08204 $$a006.6/8$$223/eng/20230228
001454907 1001_ $$aJolly, Jessica,$$eauthor.
001454907 24510 $$aMicrosoft Power BI Data Analyst Certification companion :$$bpreparation for exam PL-300 /$$cJessica Jolly.
001454907 250__ $$a[First edition].
001454907 264_1 $$aNew York, NY :$$bApress,$$c[2023]
001454907 300__ $$a1 online resource (392 pages) :$$billustrations
001454907 336__ $$atext$$btxt$$2rdacontent
001454907 337__ $$acomputer$$bc$$2rdamedia
001454907 338__ $$aonline resource$$bcr$$2rdacarrier
001454907 4901_ $$aCertification study companion series
001454907 500__ $$aIncludes index.
001454907 5050_ $$aIntro -- 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
001454907 5058_ $$aDesktop 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
001454907 5058_ $$aFor 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
001454907 5058_ $$aReplacing 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
001454907 5058_ $$aLoading 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
001454907 506__ $$aAccess limited to authorized users.
001454907 520__ $$aUse 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.
001454907 63000 $$aMicrosoft Power BI (Computer file)$$xExaminations$$vStudy guides.
001454907 650_0 $$aMicrosoft software$$xExaminations$$vStudy guides.
001454907 650_0 $$aBusiness$$xData processing$$xExaminations$$vStudy guides.
001454907 655_0 $$aElectronic books.
001454907 77608 $$iPrint version: $$z1484290127$$z9781484290125$$w(OCoLC)1346532680
001454907 830_0 $$aCertification study companion series.
001454907 852__ $$bebk
001454907 85640 $$3Springer Nature$$uhttps://univsouthin.idm.oclc.org/login?url=https://link.springer.com/10.1007/978-1-4842-9013-2$$zOnline Access$$91397441.1
001454907 909CO $$ooai:library.usi.edu:1454907$$pGLOBAL_SET
001454907 980__ $$aBIB
001454907 980__ $$aEBOOK
001454907 982__ $$aEbook
001454907 983__ $$aOnline
001454907 994__ $$a92$$bISE