0

Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

Microsoft Power BI Data Analyst Certification Guide

You're reading from Microsoft Power BI Data Analyst Certification Guide A comprehensive guide to becoming a confident and certified Power BI professional

Product type Paperback

Published in Jun 2022

Publisher Packt

ISBN-13 9781803238562

Length 398 pages

Edition 1st Edition

Languages

DAX

Tools

Power BI

Concepts

IT Certification

Authors (2):

Edward Corcoran

Orrin Edenfield

View More author details

Table of Contents (25) Chapters

Preface

1. Part 1 – Preparing the Data

2. Chapter 1: Overview of Power BI and the PL-300 Exam FREE CHAPTER

3. Chapter 2: Connecting to Data Sources

4. Chapter 3: Profiling the Data

5. Chapter 4: Cleansing, Transforming, and Shaping Data

6. Part 2 – Modeling the Data

7. Chapter 5: Designing a Data Model

8. Chapter 6: Using Data Model Advanced Features

9. Chapter 7: Creating Measures Using DAX

10. Chapter 8: Optimizing Model Performance

11. Part 3 – Visualizing the Data

12. Chapter 9: Creating Reports

13. Chapter 10: Creating Dashboards

14. Chapter 11: Enhancing Reports

15. Part 4 – Analyzing the Data

16. Chapter 12: Exposing Insights from Data

17. Chapter 13: Performing Advanced Analysis

18. Part 5 – Deploying and Maintaining Deliverables

19. Chapter 14: Managing Workspaces

20. Chapter 15: Managing Datasets

21. Part 6 – Practice Exams

22. Chapter 16: Practice Exams

23. Other Books You May Enjoy

Appendix: Practice Question Answers

Chapter 3, Profiling the Data

Which tool is used to transform data?
1. Power Edit
2. Transform Data
3. Query Tool
4. Power Query
By default, the Power Query Editor will use how many rows of data?
1. 100 rows
2. 1,000 rows
3. 2,000 rows
4. Entire dataset
Column distribution view can be enabled by selecting the checkbox under which tab on the ribbon?
1. Tools
2. Statistics
3. View
4. Home

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at €18.99/month. Cancel anytime

Authors (4)

Edenfield

Edenfield

Orrin Edenfield has 20 years of experience designing and implementing data & analytics solutions. Orrin contributes to Microsoft certification exams as well as architecture best practices and blueprints, helping to solve BI problems using Power BI and more. A Cloud Solution Architect, Orrin helps customers solve technical obstacles and helps develop Azure platforms.

See other products by Edenfield

Orrin Edenfield

Orrin Edenfield

Orrin Edenfield has 20 years of experience designing and implementing data & analytics solutions. Orrin contributes to Microsoft certification exams as well as architecture best practices and blueprints, helping to solve BI problems using Power BI and more. A Cloud Solution Architect, Orrin helps customers solve technical obstacles and helps develop Azure platforms.

See other products by Orrin Edenfield

Corcoran

Corcoran

Ed Corcoran has spent 20 years in data warehousing and business intelligence work. A Cloud Solution Architect, Ed helps customers use Microsoft data & analytics services to solve technical obstacles and help develop customer implementation projects to ensure easy adoption. Ed also collaborates with product engineering to aid development of Microsoft products and Azure platforms.

See other products by Corcoran

Edward Corcoran

Edward Corcoran

Ed Corcoran has spent 20 years in data warehousing and business intelligence work. A Cloud Solution Architect, Ed helps customers use Microsoft data & analytics services to solve technical obstacles and help develop customer implementation projects to ensure easy adoption. Ed also collaborates with product engineering to aid development of Microsoft products and Azure platforms.

See other products by Edward Corcoran

Personalised recommendations for you

Based on your interests and search pattern

Mastering PowerShell Scripting

Mastering PowerShell Scripting

PowerShell scripts provides a convenient method for automating tasks, using them proficiently can be challenging. This all-inclusive guide begins at the basics and covers advanced concepts, equipping you with tips to become an expert in PowerShell Core 7.3 scripting.

May 2024 27h 32m

Network Automation with Nautobot

Network Automation with Nautobot

This book will help you understand why a network source of truth is needed for long-term network automation success, which will in turn save you hundreds of hours in deploying and integrating Nautobot into network automation.

May 2024 27h 12m

NGINX HTTP Server

NGINX HTTP Server

Explore the power of NGINX with this guide covering an array of essential practical topics, including securing your infrastructure with automatic TLS certificates, placing NGINX in front of your existing applications, and much more.

May 2024 8h 44m

Mastering Azure Virtual Desktop

Mastering Azure Virtual Desktop

This updated edition will help you plan an Azure Virtual Desktop Architecture, implement its infrastructure, and manage its access and security. With content aligned with the exam objectives, it'll help you ace the Microsoft AZ-140 exam.

Jul 2024 23h 56m

Learn Ansible will teach you how to write Ansible Playbooks for deploying simple apps. This updated edition covers the latest Ansible features, helping you confidently implement Ansible in your daily workflows.

May 2024 13h 48m

HashiCorp Terraform Associate (003) Exam Guide

HashiCorp Terraform Associate (003) Exam Guide

This book will help you explore HashiCorp Terraform and prepare for Associate (003) certification, from understanding core concepts to advanced modules. You'll gain hands-on expertise, troubleshoot with confidence, and more.

May 2024 11h 28m

Kubernetes – An Enterprise Guide

Kubernetes – An Enterprise Guide

Navigate the complexities of Kubernetes and fully leverage its capabilities for enterprise applications. This edition dives into advanced deployments, groundbreaking techniques, and insights that will elevate your skills and redefine your expertise.

Aug 2024 22h 44m

Atlassian DevOps Toolchain Cookbook

Atlassian DevOps Toolchain Cookbook

Master setting up a DevOps toolchain using Atlassian tools and Open DevOps as a framework with this recipe-driven guide to automated testing, integration, deployment, observability, and incident management for streamlining development processes.

Jul 2024 16h 48m

AWS Certified Developer Associate Certification and Beyond

AWS Certified Developer Associate Certification and Beyond

This is your guide to passing the challenging AWS Certified Developer – Associate certification exam and setting yourself up for a rewarding career. Through a sample project, it explains how to design, architect, and implement applications on AWS.

Jul 2024 23h 40m

Implementing GitOps with Kubernetes

Implementing GitOps with Kubernetes

This book provides step-by-step tutorials and hands-on examples for effectively implementing GitOps practices in your Kubernetes deployments. You'll learn how to automate, monitor, and secure your infrastructure for efficient application delivery.

Aug 2024 14h 48m