Microsoft Excel 2016 Business Analytics & Power BI Quick

Microsoft Excel 2016 Business Analytics & Power BI Quick Reference Guide, 2017 Ed. (4-page Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Guide)

This guide was updated in July 2018 to reflect the latest user interface.

For power users who want to bring big data onto the desktop this four page laminated quick reference provides guidance on powerful Excel 2016 and Power BI data analytic features. Step-by-step instructions are given for many data gathering, transforming, analyzing and visualizing features such as the Data Model, Query Editor and Power View. DAX functions are highlighted and Power BI Desktop is introduced. Written with Beezix's trademark focus on clarity, accuracy, and the user's perspective, this guide will be a valuable resource to improve your proficiency in using Excel 2016. This guide is suitable as a training handout, or simply an easy to use reference guide.

The following topics are covered:

Gathering Data: Excel's Data Model; Adding External Data to the Data Model; Adding Ranges to the Data Model; Adding a Folder of Files to the Data Model; Edit Existing Connections.

Transforming Data: Opening the Query Editor; Using the Query Editor to Transform; Using the Query Editor to Filter; Suggested Data Transformations; Working with Query Actions; Using the Query Editor to Merge; Using the Query Editor to Unpivot Columns; Using the Query Editor to Append; Using the Query Editor to Split Text Into Columns; Closing the Query Editor; Add Table Data to the Data Model; Defining Relationships Across Multiple Tables; Managing Relationships Within the Data Model.

Analyzing Data: Quick Analysis Using PivotTables; Creating a PivotTable from the Data Model; Adding Tables and Fields to an Existing PivotTable; Updating PivotTable Data; Analyzing with Calculated Columns and Measures; Calculating in PivotTables; Calculating in the Data Model Using DAX; Forecasting with the Forecast Sheet Wizard.

Visualizing with Power View: Adding Power View to Excel; Creating a Power View Sheet; Adding Visualizations to Power View.

Visualizing with Power BI Desktop: Installing Power BI Desktop; Gathering & Transforming Power BI Data; Managing Relationships with Power BI; Creating Calculated Columns and Measures in Power BI; Creating a Power BI Visualization (Tile); Creating Interactions between Tiles; Formatting in Power BI; Managing Power BI Reports; Sharing Power BI Desktop Reports; Publishing a Power BI Desktop Report; Adding Report Tiles to a Power BI Service Dashboard; Sharing a Power BI Service Dashboard; Resharing a Dashboard; Stop Sharing a Dashboard; Power BI Service Quick Insights; Real World Example Using Municipal Web Data.

This guide is one of multiple titles available for Excel 2016, other Excel titles are: Excel 2016 Introduction (ISBN 1939791928); Excel 2016 Charts & Sparklines (ISBN 9781939791955); Excel 2016 Functions & Formulas (ISBN 9781939791979); Excel 2016 Tables, PivotTables, Sorting, Filtering & Inquire (ISBN 9781939791962); Excel 2016 Advanced Features & Macros (ISBN 9781944684082).
Country USA
Brand NOVIIML
Manufacturer Beezix Inc
Binding Pamphlet
EANs 9781944684143
ReleaseDate 0000-00-00

Country	USA
Brand	NOVIIML
Manufacturer	Beezix Inc
Binding	Pamphlet
EANs	9781944684143
ReleaseDate	0000-00-00

Microsoft Excel 2016 Business Analytics & Power BI Quick Reference Guide, 2017 Ed. (4-page Cheat Sheet of Instructions, Tips & Shortcuts - Laminated Guide)

You might also like...