Teach Yourself Visually Power Bi
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, New Jersey :
John Wiley & Sons, Inc
[2023]
|
| Colección: | Teach yourself visually.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009752739106719 |
Tabla de Contenidos:
- Cover
- Title Page
- Copyright Page
- Table of Contents
- 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
- Install Power BI Desktop
- Start and Pin Power BI Desktop
- Start and Pin Power BI Desktop
- Start Power BI Desktop
- Pin Power BI Desktop
- Explore the Power BI Workspace
- Explore the Power BI Workspace (continued)
- 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
- Connect Power BI Desktop to a Local File
- Save, Close, and Open Power BI Reports
- Save, Close, and Open Power BI Reports
- Save and Close a Report
- Open a Report
- Start Working with the Sample Dataset
- Start Working with the Sample Dataset
- Open the Sample Dataset in Power Query Editor
- Check the Data Type of Each Column
- Change the Data Type of a Column
- Start Working with the Sample Dataset (continued)
- Start Working with the Sample Dataset (continued)
- View the Column Distribution and Column Quality
- Correct Errors
- Connect to a Power BI Dataset
- Connect to a Power BI Dataset
- Connect to a SharePoint List
- Connect to a SharePoint List
- Connect to a SharePoint List (continued)
- Connect to a SharePoint List (continued)
- Connect to a SQL Server Database
- Connect to a SQL Server Database
- Connect to a SQL Server Database (continued)
- Connect to a SQL Server Database (continued)
- Chapter 3 Cleaning and Shaping Data
- Remove Duplicate Values
- Remove Duplicate Values
- Replace Values in a Column
- Replace Values in a Column
- Split a Column Using a Delimiter
- Split a Column Using a Delimiter
- Group Data
- Group Data
- Add a Calculated Column.
- Add a Calculated Column
- Add an Index Column
- Add an Index Column
- Chapter 4 Modeling Data in Model View
- Create Dimension Tables
- Create Dimension Tables
- Create a Dimension Column for Segments
- Create Dimension Tables (continued)
- Create Dimension Tables (continued)
- Create a Dimension Table for Countries
- Create Relationships Between Tables
- Create Relationships Between Tables
- Create Relationships Between Tables (continued)
- Create Relationships Between Tables (continued)
- Create a Star Schema
- Create a Star Schema
- Create a Hierarchical Schema
- Create a Hierarchical Schema
- Lay Out the Tables for a Parent‐Child Hierarchical Schema
- Create a Hierarchical Schema (continued)
- Create a Hierarchical Schema (continued)
- Create the Relationships Between the Tables
- Create a Hierarchical Schema (continued)
- Create a Hierarchical Schema (continued)
- Using the Properties Pane
- Configure Table Properties
- Configure Column Properties
- Chapter 5 Creating Basic Visualizations
- Create a Bar Chart
- Create a Bar Chart
- Apply Filters to Visuals
- Apply Filters to Visuals
- Apply a Filter
- Remove a Filter
- Format the Y-Axis of a Bar Chart
- Format the Y‐Axis of a Bar Chart
- Format the X-Axis of a Bar Chart
- Format the X‐Axis of a Bar Chart
- Add and Format the Data Category of a Bar Chart
- Add and Format the Data Category of a Bar Chart
- Move a Bar Chart's Legend and Add Gridlines
- Move a Bar Chart's Legend and Add Gridlines
- Move the Legend
- Add Gridlines
- Add a Zoom Slider and Update Bar Colors
- Add a Zoom Slider and Update Bar Colors
- Add a Zoom Slider
- Update Bar Colors
- Add Data Labels to a Bar Chart
- Add Data Labels to a Bar Chart
- Add an Image to the Plot Area Background
- Add an Image to the Plot Area Background
- Create a Line Chart or Area Chart.
- Create a Line Chart or Area Chart
- Format the Axes of a Line or Area Chart
- Format the Axes of a Line or Area Chart
- Add a Legend to a Line or Area Chart
- Add a Legend to a Line or Area Chart
- Add a Legend
- Format a Legend
- Move the Legend and Add Gridlines to a Line or Area Chart
- Move the Legend and Add Gridlines to a Line or Area Chart
- Move the Legend
- Add Gridlines
- Add a Zoom Slider and Steps to a Line or Area Chart
- Add a Zoom Slider and Steps to a Line or Area Chart
- Add a Zoom Slider
- Add Steps to a Line Chart or Area Chart
- Add Data Markers and Labels to a Line or Area Chart
- Add Data Markers and Labels to a Line or Area Chart
- Add Data Markers
- Add Data Labels
- Format the Data Labels of 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 Gauge Chart
- Create and Format a Gauge Chart (continued)
- Create and Format a Gauge Chart (continued)
- Create and Format a KPI Visual
- Create a KPI Visual
- Create and Format a KPI Visual (continued)
- Create and Format a KPI Visual (continued)
- Create a Matrix Visual
- Create a Matrix Visual
- Format a Matrix Visual
- Format a Matrix Visual
- Format the Values and Column Headers of a Matrix Visual
- Format the Values and Column Headers of a Matrix Visual
- Format the Row 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 Row Subtotals and Grand Totals of a Matrix Visual
- Format the Specific Column and Cell Elements of a Matrix Visual
- Format the Specific Column and Cell Elements of a Matrix Visual
- Create a Waterfall Chart
- Create a Waterfall Chart
- Format a Waterfall Chart
- Format a Waterfall Chart.
- Format the X-Axis and Legend of a Waterfall Chart
- Format the X‐Axis and Legend a Waterfall Chart
- Add and Format Breakdowns in a Waterfall Chart
- Add and Format Breakdowns in a Waterfall Chart
- Create, Format, and Label a Funnel Chart
- Create, Format, and Label a Funnel Chart
- Create, Format, and Label a Funnel Chart (continued)
- Create, Format, and Label a Funnel Chart (continued)
- Create a Pie Chart or Donut Chart
- Create a Pie Chart or Donut Chart
- Format a Pie Chart or Donut Chart
- Format a Pie Chart or Donut Chart
- Create a Treemap Chart
- Create a Treemap Chart
- Format a Treemap Chart
- Format a Treemap Chart
- Chapter 7 Showing Geographic Data on Maps
- Create a Proportional Symbol Map
- Create a Proportional Symbol Map
- Create a Choropleth Map
- Create a Choropleth Map
- Add Conditional Formatting to a Choropleth Map
- Add Conditional Formatting to a Choropleth Map
- Enable Power BI's Preview Features
- Enable Power BI's Preview Features
- Create an Isarithmic Map
- Create an Isarithmic Map
- Create a Skyscraper 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
- Add All Numbers in a Column
- Perform Division
- Perform Division
- Check a Condition
- Check a Condition
- Count the Number of Cells in a Column
- Count the Number of Cells in a Column
- Return the Average of All Numbers in a Column
- Return the Average of All Numbers in a Column
- Join Two Text Strings into One Text String
- Join Two Text Strings into One Text String
- Apply Conditional Formatting in Tables
- Apply Conditional Formatting in Tables
- Apply Conditional Formatting in Tables (continued)
- Apply Conditional Formatting in Tables (continued)
- Chapter 9 Using Analytics and Machine Learning
- Identify Outliers.
- Identify Outliers
- Find Groups of Similar Data by Clustering
- Find Groups of Similar Data by Clustering
- Create a Dataflow
- Create a Dataflow
- Create a Dataflow (continued)
- Create a Dataflow (continued)
- Apply Binary Prediction with AutoML
- Apply Binary Prediction with AutoML
- Apply Binary Prediction with AutoML (continued)
- Apply Binary Classification with AutoML (continued)
- Chapter 10 Creating Interactive Reports
- Planning to Create a Report
- Start a Report and Add a Title
- Start a Report and Add a Title
- Add Visuals to a Report
- Add Visuals to a Report
- Add Visuals to a Report (continued)
- Add Visuals to a Report (continued)
- Add Slicers to a Report
- Add a Slicer to a Report
- Control Which Visuals and Slicers Interact
- Control Which Visuals and Sliders Interact
- Enable and Control Drill-Through Actions
- Enable and Control Drill‐Through Actions
- Enable and Control Drill-Through Actions (continued)
- Enable and Control Drill‐Through Actions (continued)
- Split a Page into Sections
- Split a Page into Sections
- Split a Page into Sections (continued)
- Split a Page into Sections (continued)
- Add Bookmarks and Navigation to a Report
- Add Bookmarks to a Report
- Add Bookmarks to a Report
- Add Bookmarks and Navigation to a Report (continued)
- Add Bookmarks and Navigation to a Report (continued)
- Add Page Navigation to a Report
- Chapter 11 Publishing Reports and Dashboards
- Set Up a Workspace
- Set Up a Workspace
- Ask Questions About the Data
- Ask Questions About the Data
- Publish a Report to the Power BI Service
- Publish a Report to the Power BI Service
- Set Up Row-Level Security
- Set Up Row‐Level Security
- Add Tiles to a Dashboard
- Add Tiles to a Dashboard
- Share a Dashboard
- Share a Dashboard
- Schedule Data Refreshes
- Schedule Data Refreshes.
- Publish a Report to the Web.
