Power BI

Alexander Loth

Book - 2023

A comprehensive and fully visual guide to Microsoft Power BI. Teach Yourself VISUALLY Power BI collects all the resources you need to master the everyday use of Microsoft's powerful data visualization software and delivers them in a single, easy-to-use volume. Fully illustrated, step-by-step instructions are combined with crystal-clear screenshots that walk you through the basic and advanced functions of Microsoft Power BI. Teach Yourself VISUALLY Power BI offers the best visual learning techniques with complete source material about the interface and substance of Power BI, as well as: Stepwise guidance on working with, transforming, and processing data sources; Instructions for customizing data visualizations to create informative and... presentation-ready charts and graphs; Full-color, two-page tutorials on the more advanced features of Power BI, including app integrations and data access with DAX. The fastest, easiest way for visual learners to get a handle on Microsoft Power BI, Teach Yourself VISUALLY Power BI is a can't-miss resource, loaded with useful tips for newbies and experts alike.

Saved in:

2nd Floor Show me where

005.743/POWER/Loth
1 / 1 copies available
Location Call Number   Status
2nd Floor 005.743/POWER/Loth Checked In
Subjects
Published
Hoboken, New Jersey : John Wiley & Sons, Inc [2023]
Language
English
Main Author
Alexander Loth (author)
Item Description
"Visual--A Wiley brand"--Cover.
Includes index.
Physical Description
246 pages : color illustrations ; 24 cm
ISBN
9781119903772
  • Chapter 1. Getting Started with Power BI
  • What Is Power BI?
  • Understanding the Different Components of Power BI
  • Understanding Power BI as Part of the Power Platform
  • Install Power BI Desktop
  • Start and Pin Power BI Desktop
  • Explore the Power BI Workspace
  • Chapter 2. Connecting Power BI to Your Data
  • Grasp How Power Query Editor Works with Power BI Desktop
  • Connect Power BI Desktop to a Local File
  • Save, Close, and Open Power BI Reports
  • Start Working with the Sample Dataset
  • Connect to a Power BI Dataset
  • Connect to a SharePoint List
  • Connect to a SQL Server Database
  • Chapter 3. Cleaning and Shaping Data
  • Remove Duplicate Values
  • Replace Values in a Column
  • Split a Column Using a Delimiter
  • Group Data
  • Add a Calculated Column
  • Add an Index Column
  • Chapter 4. Modeling Data in Model View
  • Create Dimension Tables
  • Create Relationships Between Tables
  • Create a Star Schema
  • Create a Hierarchical Schema
  • Using the Properties Pane
  • Chapter 5. Creating Basic Visualizations
  • Create a Bar Chart
  • Apply Filters to Visuals
  • Format the Y-Axis of a Bar Chart
  • Format the X-Axis of a Bar Chart
  • Add and Format the Data Category of a Bar Chart
  • Move a Bar Chart's Legend and Add Gridlines
  • Add a Zoom Slider and Update Bar Colors
  • Add Data Labels to a Bar Chart
  • Add an Image to the Plot Area Background
  • Create a Line Chart or Area Chart
  • Format the Axes of a Line or Area Chart
  • Add a Legend to a Line or Area Chart
  • Move the Legend and Add Gridlines to a Line or Area Chart
  • Add a Zoom Slider and Steps to a Line or Area Chart
  • Add Data Markers and Labels to a Line or Area Chart
  • Format the Data Labels of a Line or Area Chart
  • Chapter 6. Creating Advanced Data Visualizations
  • Create and Format a Gauge Chart
  • Create and Format a KPI Visual
  • Create a Matrix Visual
  • Format a Matrix Visual
  • Format the Values and Column Headers of a Matrix Visual
  • Format the Row Headers of a Matrix Visual
  • Format the Row Subtotals and Grand Totals of a Matrix Visual
  • Format the Specific Column and Cell Elements of a Matrix Visual
  • Create a Waterfall Chart
  • Format a Waterfall Chart
  • Format the X-Axis and Legend of a Waterfall Chart
  • Add and Format Breakdowns in a Waterfall Chart
  • Create, Format, and Label a Funnel Chart
  • Create a Pie Chart or Donut Chart
  • Format a Pie Chart or Donut Chart
  • Create a Treemap Chart
  • Format a Treemap Chart
  • Chapter 7. Showing Geographic Data on Maps
  • Create a Proportional Symbol Map
  • Create a Choropleth Map
  • Add Conditional Formatting to a Choropleth Map
  • Enable Power BI's Preview Features
  • Create an Isarithmic Map
  • Create a Skyscraper Map
  • Chapter 8. Using Calculated Columns and DAX
  • Understanding DAX and Why You Should Use It
  • Add All Numbers in a Column
  • Perform Division
  • Check a Condition
  • Count the Number of Cells in a Column
  • Return the Average of All Numbers in a Column
  • Join Two Text Strings into One Text String
  • Apply Conditional Formatting In Tables
  • Chapter 9. Using Analytics and Machine Learning
  • Identify Outliers
  • Find Groups of Similar Data by Clustering
  • Create a Dataflow
  • Apply Binary Prediction with AutoML
  • Chapter 10. Creating Interactive Reports
  • Planning to Create a Report
  • Start a Report and Add a Title
  • Add Visuals to a Report
  • Add Sheers to a Report
  • Control Which Visuals and Slicers Interact
  • Enable and Control Drill-Through Actions
  • Split a Page into Sections
  • Add Bookmarks and Navigation to a Report
  • Chapter 11. Publishing Reports and Dashboards
  • Set Up a Workspace
  • Ask Questions About the Data
  • Publish a Report to the Power BI Service
  • Set Up Row-Level Security
  • Add Tiles to a Dashboard
  • Share a Dashboard
  • Schedule Data Refreshes
  • Publish a Report to the Web
  • Index