Teach Yourself VISUALLY Power BI, (An Indian Adaptation)
ISBN: 9789363869554
284 pages
For more information write to us at: acadmktg@wiley.com
Description
Master Power BI with Teach Yourself VISUALLY
Unlock the full potential of Microsoft’s powerful data visualization software with Teach Yourself VISUALLY Power BI. This comprehensive guide brings together all the essential resources needed to master both basic and advanced Power BI functions in one convenient, easy-to-use volume.
Featuring fully illustrated, step-by-step instructions and clear, high-quality screenshots, this book makes learning Power BI accessible and engaging. Whether you're just getting started or looking to refine your skills, this guide provides everything you need to navigate Power BI’s robust features with ease.
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 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 Scheme 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 Slicers 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
Case Study-1 Case Study-2 Appendix A: Power BI in Government and Tech Projects, Competitions, and Community Engagement in India Appendix B: Questions Index |