Book description
Prepare for Microsoft Exam 70-778-and help demonstrate your real-world mastery of Power BI data analysis and visualization. Designed for experienced BI professionals and data analysts ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level.
Focus on the expertise measured by these objectives:
- Consume and transform data by using Power BI Desktop
- Model and visualize data
- Configure dashboards, reports, and apps in the Power BI Service
This Microsoft Exam Ref:
- Organizes its coverage by exam objectives
- Features strategic, what-if scenarios to challenge you
- Assumes you have experience consuming and transforming data, modeling and visualizing data, and configuring dashboards using Excel and Power BI
Table of contents
- Cover Page
- Title Page
- Copyright Page
- Dedication Page
- Contents at a Glance
- Contents
- Acknowledgements
- About the author
- Introduction
-
Chapter 1 Consuming and transforming data by using Power BI Desktop
-
Skill 1.1: Connect to data sources
- Connect to databases, files, and folders
- Data connectivity modes
- Importing data
- DirectQuery
- Implications of using DirectQuery
- When to use DirectQuery
- Live Connection
- Connecting to Microsoft SQL Server
- Connecting to Access database
- Connecting to an Oracle database
- Connecting to a MySQL database
- Connecting to PostgreSQL database
- Connecting to data using generic interfaces
- Connecting to Text/CSV files
- Connecting to JSON files
- Connecting to XML files
- Connecting to a Folder
- Connecting to a SharePoint folder
- Connecting to web pages and files
- Connecting to Azure Data Lake Store and Azure Blob Storage
- Import from Excel
- Connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS)
- Skill 1.2: Perform transformations
- Apply business rules
- Skill 1.3: Cleanse data
- Thought experiment
- Thought experiment answers
- Chapter summary
-
Skill 1.1: Connect to data sources
-
Chapter 2 Modeling and visualizing data
- Skill 2.1: Create and optimize data models
- Skill 2.2: Create calculated columns, calculated tables, and measures
- Skill 2.3: Measure performance by using KPIs, gauges, and cards
- Skill 2.4: Create hierarchies
-
Skill 2.5: Create and format interactive visualizations
- Select a visualization type
- Configure page layout and formatting
- Configure interactions between visuals
- Configure duplicate pages
- Handle categories that have no data
- Configure default summarization and data category of columns
- Position, align, and sort visuals
- Enable and integrate R visuals
- Format measures
- Use bookmarks and themes for reports
- Skill 2.6: Manage custom reporting solutions
- Thought experiment
- Thought experiment answers
- Chapter summary
- Chapter 3 Configure dashboards, reports, and apps in the Power BI Service
- Index
- Code Snippets
Product information
- Title: Exam Ref 70-778 Analyzing and Visualizing Data by Using Microsoft Power BI
- Author(s):
- Release date: June 2018
- Publisher(s): Microsoft Press
- ISBN: 9780134857817
You might also like
book
Exam Ref DA-100 Analyzing Data with Microsoft Power BI
Prepare for Microsoft Exam DA-100 and help demonstrate your real-world mastery of Power BI data analysis …
book
Data Analysis with Microsoft Power BI
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
Exam Ref PL-300 Microsoft Power BI Data Analyst
Prepare for Microsoft Exam PL-300 and help demonstrate your real-world ability to deliver actionable insights with …
book
Data Modeling with Microsoft Power BI
Data modeling is the single most overlooked feature in the Power BI Desktop, yet it's what …