Data Visualization with Microsoft Power BI - Helion
ebook
Autor: Alex Kolokolov, Maxim ZelenskyISBN: 9781098152741
stron: 416, Format: ebook
Data wydania: 2024-08-29
Księgarnia: Helion
Cena książki: 194,65 zł (poprzednio: 226,34 zł)
Oszczędzasz: 14% (-31,69 zł)
The sheer volume of business data has reached an all-time high. Using visualizations to transform this data into useful and understandable information can facilitate better decision-making. This practical book shows data analysts as well as professionals in finance, sales, and marketing how to quickly create visualizations and build savvy dashboards.
Alex Kolokolov from Data2Speak and Maxim Zelensky from Intelligent Business explain in simple and clear language how to create brilliant charts with Microsoft Power BI and follow best practices for corporate reporting. No technical background is required. Step-by-step guides help you set up any chart in a few clicks and avoid common mistakes. Also, experienced data analysts will find tips and tricks on how to enrich their reports with advanced visuals.
This book helps you understand:
- The basic rules for classic charts that are used in 90% of business reports
- Exceptions to general rules based on real business cases
- Best practices for dashboard design
- How to properly set up interactions
- How to prepare data for advanced visuals
- How to avoid pitfalls with eye-catching charts
Osoby które kupowały "Data Visualization with Microsoft Power BI", wybierały także:
- Biologika Sukcesji Pokoleniowej. Sezon 2. Za 127,27 zł, (14,00 zł -89%)
- Biologika Sukcesji Pokoleniowej. Sezon I. 127,27 zł, (14,00 zł -89%)
- Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
- Podręcznik startupu. Budowa wielkiej firmy krok po kroku 93,33 zł, (14,00 zł -85%)
- Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
Spis treści
Data Visualization with Microsoft Power BI eBook -- spis treści
- Preface
- Note from Alex Kolokolov
- Note from Maxim Zelensky
- Who This Book Is For
- Managers and Nontechnical Professionals
- Data Analysts
- How This Book Is Organized
- How to Work with Practice Datasets
- Conventions Used in This Book
- Using Datasets
- OReilly Online Learning
- How to Contact Us
- Acknowledgments
- I. Classic Visuals
- 1. Power BI Interface and Chart Anatomy
- Power BI Key Elements
- Top Menu Bar
- Workspace Canvas
- View Mode Selector
- Visualizations Pane
- Data Pane
- How Power BI Builds Charts
- Format Visual
- Chart Anatomy
- Value Axis
- Category Axis
- Legend
- Shapes and Colors
- Data Labels
- Chart Title
- Responsive Mode
- Power BI Key Elements
- 2. Visualization Compass: How to Choose Charts Correctly
- Chart Choosers
- Ranking
- Number of Categories on the Chart
- The Length of Category Labels and the Chart Size
- Dynamics
- Structure
- Common Mistakes
- Line Chart for Ranking
- Bar Chart for Dynamics
- Pie Chart for Dynamics
- 3. Column and Bar Charts
- Column Chart
- Step-by-Step Guide for Column Chart
- Step 1: Enable and Adjust Data Labels
- Step 2: Disable the Y-Axis
- Step 3: Customize Category Labels on the X-Axis
- Step 4: Edit the Chart Title
- Step-by-Step Guide for the Bar Chart
- Step 1: Enable and Adjust Data Labels
- Step 2: Disable Value Axis (X-Axis)
- Step 3: Customize Category Labels on the Y-Axis
- Step 4 (Optional): Adjust Bar Height
- Step 5: Edit the Chart Title
- Data Filtration Challenges
- 1. Too Small Values in the Data Labels
- 2. Category Labels Are Not Horizontal
- 3. Charts Cross-Filtering and Highlighting
- 4. Pie and Donut Charts
- Step-by-Step Guide for Pie and Donut Charts
- Step 1: Adjust Data Labels
- Step 2: Remove the Legend
- Step 3: Adjust the Inner Radius for the Donut Chart
- Step 4: Edit Chart Title
- Common Mistakes
- Rotation
- Details (Hierarchical View)
- Timeline at the Pie or Donut
- Step-by-Step Guide for Pie and Donut Charts
- 5. Treemap
- Step-by-Step Guide for a Treemap
- Step 1: Adjust Data Labels Size
- Step 2: Display Percent of Total
- Step 3: Adjust Category Labels
- Step 4: Adjust Colors
- Step 5: Edit Chart Title
- Strengths and Weaknesses of the Treemap
- Step-by-Step Guide for a Treemap
- 6. Timeline Charts
- Date Hierarchy: How It Works
- Step-by-Step Guide for Line Chart
- Step 1: Customize Timeline on the X-Axis
- Step 2: Adjust the Y-Axis Scale
- Step 3: Add Data Labels
- Line Chart Family Features
- Area Filling
- Markers
- Apply Settings to Specific Series
- Secondary Y-Axis
- Combined Line and Column Chart
- Ribbon Chart
- 7. Tables and Matrices
- Step-by-Step Guide for a Table
- Step 1: Edit Column Headers
- Step 2: Adjust Values
- Step 3: Set Up Style and Grid
- MatrixDrill-Down Table
- Conditional Formatting
- Data Bars
- Icons and Quick Measure Calculation
- Font Color
- Cell Color / Heat Map
- Tips for Conditional Formatting
- Apply one rule per column
- Dont try to color the entire table and format all columns
- Contrast bar charts with the data labels
- Step-by-Step Guide for a Table
- 8. KPI Cards
- Step-by-Step Guide for a Card
- Step 1: Adjust Data Label (Callout Value)
- Step 2: Adjust Category Label
- Step 3: Add Contrasting Background
- How to Create Multiple Cards
- Step 4: Add Conditional Formatting
- Step 5: For Perfectionists: Put Category Label on Top
- New Card
- Step-by-Step Guide for a Card
- 9. Slicers and Filters
- Step-by-Step Guide for a Slicer by Category
- Step 1: Define Slicer Style
- Step 2: Define Selection Type
- Step 3: Slicer Formatting
- Slicer for a Range of Values and Dates
- Cross-Filtering
- Step-by-Step Guide for a Slicer by Category
- 10. Putting It All Together: Dashboard Design Tips
- Step-by-Step Guide for a Dashboard
- Step 1: Place KPI Cards on Top
- Step 2: Define Dashboard Grid
- Step 3: Adjust the Page Background
- Step 4: Customize the Color Theme
- Step 5: Check Cross-Filtering
- Step-by-Step Guide for a Dashboard
- Part I Quiz
- Answers
- II. Trusted Advanced Visuals
- 11. Funnel Chart
- Step-by-Step Guide for Funnel Chart
- Step 1: Set the Conversion Display
- Step 2: Set Values
- Step 3: Display Category Labels Without Shortening
- Step 4: Set Color-Coding
- Step 5: Title and Text Box Trick Again
- Possible Mistake
- Step-by-Step Guide for Funnel Chart
- 12. Map
- Step-by-Step Guide for Setting Up a Map
- Step 1: Allocate Data Fields
- Step 2: Add and Set Up Category Labels
- Step 3: Set Up the Bubble Size
- Step 4: Set Map Parameters
- Step 5: Give a Clear Headline
- Possible Mistakes
- 1. Bubbles Are Difficult to Compare
- 2. Data Labels Dont Display Values
- 3. Appearance of Unnecessary Pie Charts
- 4. Mistakes in the Placement of Objects
- Step-by-Step Guide for Setting Up a Map
- 13. Tornado Chart
- Possible Mistake
- AppSource Gallery
- Step-by-Step Guide for Tornado Chart
- Step 1: Set Up Data Labels
- Step 2: Adjust the Values Axis
- Step 3: Set Up the Y-AxisGroup Parameter
- Step 4: Customize Legend and Title
- Limitations of Tornado Chart by Microsoft
- One data display unit for both parts
- Violation of proportions
- Lack of legend
- Table-Based Tornado Chart
- Step 1: Set Conditional Formatting
- Step 2: Change the Left Bar Direction and the Bar Colors
- Step 3: Change the Table Style and Remove the Grid
- Step 4: Format Data Labels
- Benefits of a Tornado-Style Table
- Benefit 1
- Benefit 2
- Benefit 3
- Benefit 4
- 14. Waterfall Chart
- Data Preparation
- Step-by-Step Guide for Default Waterfall
- Step 1: Adjust Data Labels
- Step 2: Scale Y-Axis
- Step 3: Configure the X-Axis and Determine the Number of Columns
- Limitation of Standard Waterfall Chart
- Simple Waterfall
- Transforming Data with Power Query
- Step 1: Execute the Pivot Column Function
- Step 2: Select Values Column
- Step 3: Close & Apply
- Step-by-Step Guide for Simple Waterfall
- Step 1: Reposition Fields
- Step 2: Define Pillars
- Step 3: Configure Data Labels and Y-Axis
- Step 4: Adjust Category Labels for the X-Axis
- Benefits of the Simple Waterfall
- 15. Bullet Chart
- Bullet Chart Options
- How to Build a Bullet Chart
- Bullet Chart by Microsoft
- Bullet Chart by OKViz
- Step-by-Step Guide for Bullet Chart by OKViz
- Step 1: Switch Off the X-Axis and Switch On Data Labels
- Step 2: Adjust or Turn Off the Color Coding on the Scale (States)
- Step 3: Setting Up the Y-Axis
- Step 4: Setting Up Conditional Formatting
- How to Build a Vertical Bullet Chart
- Paid Version of Bullet Chart by OKViz
- 16. Gantt Chart
- Gantt Chart by Microsoft
- Simple Gantt Chart
- Hierarchical Gantt Chart
- Step-by-Step Guide for Microsofts Gantt Chart
- Step 1: Adjust the Date Type
- Step 2: Expand the Category Area
- Step 3: Add Data Labels
- Step 4: Adjust Bars: Colors and Height
- Step 5 (Optional): Remove Gridlines
- Limitations of the Gantt Chart by Microsoft
- Gantt by MAQ Software
- Step-by-Step Guide for Gantt Chart by MAQ Software
- Step 1: Configure Category Hierarchy
- Step 2: Adjust Area Proportions
- Step 3: Customize the Time Axis
- Step 4: Configure Data Labels
- Step 5: Customize Colors for Bar Formatting
- Step 6: Remove Unnecessary Elements
- Comparison of Gantt Charts
- Gantt Chart by Microsoft
- 17. Sankey Chart
- Data Preparation
- Step-by-Step Guide for Sankey Chart by Microsoft
- Step 1: Allocate Data Fields
- Step 2: Adjust Node Positions
- Step 3: Adjust Colors for Nodes and Links
- Limitation for Data Labels
- Common Mistake
- 18. Advanced KPI Cards
- Essential Criteria for a Perfect KPI Card
- Step-by-Step Guide for Multi-Target KPI
- Step 1: Define Grid
- Step 2: Adjust Alignment for Values and Category Labels
- Step 3: Adjust Values
- Step 4: Adjust Fonts
- Step 5: Set Up Conditional Formatting for Additional Measures
- Step 6: Multiplication and Background Color
- Step 7: Add a Micro VisualizationBullet Chart
- Part II Quiz
- Answers
- III. Risky Advanced Visuals
- 19. Gauges and KPIs
- Gauges
- Advanced Gauge by xViz
- Key Performance Indicator (KPI)
- 20. Scatterplots
- How to Create and Customize a Scatterplot
- Step 1: Allocate Data Fields
- Step 2: Add Category and Value for the Bubble Size
- Step 3: Add Zoom Slider
- Step 4: Add Play Axis and Animation
- Hexbin Scatterplot
- How to Create and Customize Hexbin Scatterplot
- How to Create and Customize a Scatterplot
- 21. Word Cloud
- Alternatives for Word Cloud
- Rating: Quantitative Comparison
- Structure: Part of a Whole
- Cross-Filtration
- How to Create and Customize a Word Cloud
- Step 1: Disable Text Rotation
- Step 2: Combine Split Phrases
- Step 3: Adjust Text Size
- Step 4: Limit the Amount of Text
- Step 5: Customize Chart Colors
- Another Word Cloud from AppSource
- Alternatives for Word Cloud
- 22. Decomposition Tree
- How a Decomposition Tree Works
- How to Set Up the Decomposition Tree
- Density
- Connectors
- Bars
- Category Labels, Values, and Headers
- Simple Alternatives to the Decomposition Tree
- Bar Charts with Cross-Filtering
- Matrix with Conditional Formatting
- 23. AI-Based Visuals
- Key Influencers
- Questions and Answers (Q&A)
- 24. Radar and Aster Plot
- Radar Chart by xViz
- Aster Plot by Microsoft
- 25. Chord Diagram
- How to Build a Chord Diagram
- Common Mistake
- Conclusion
- Index