Coverart for item
The Resource Beginning power BI : a practical guide to self-service data analytics with Excel 2016 and Power BI desktop, Dan Clark

Beginning power BI : a practical guide to self-service data analytics with Excel 2016 and Power BI desktop, Dan Clark

Label
Beginning power BI : a practical guide to self-service data analytics with Excel 2016 and Power BI desktop
Title
Beginning power BI
Title remainder
a practical guide to self-service data analytics with Excel 2016 and Power BI desktop
Statement of responsibility
Dan Clark
Creator
Author
Subject
Language
eng
Member of
Cataloging source
N$T
http://library.link/vocab/creatorDate
1963-
http://library.link/vocab/creatorName
Clark, Dan
Dewey number
005.54
Illustrations
illustrations
Index
index present
LC call number
HF5548.4.M523
Literary form
non fiction
Nature of contents
dictionaries
http://library.link/vocab/subjectName
  • Business intelligence
  • Information visualization
  • Business
  • Visual analytics
Label
Beginning power BI : a practical guide to self-service data analytics with Excel 2016 and Power BI desktop, Dan Clark
Instantiates
Publication
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Building Models in Power Pivot; Chapter 1: Introducing Power Pivot; Why Use Power Pivot?; The xVelocity In-memory Analytics Engine; Enabling Power Pivot for Excel; Exploring the Data Model Manager Interface; Summary; Chapter 2: Importing Data into Power Pivot; Importing Data from Relational Databases; Importing Data from Text Files; Importing Data from a Data Feed; Importing Data from an OLAP Cube; Reusing Existing Connections to Update the Model; Summary
  • Chapter 3: Data Munging with Power QueryDiscovering and Importing Data; Transforming, Cleansing, and Filtering Data; Merging and Shaping Data; Grouping and Aggregating Data; Inserting Calculated Columns; Summary; Chapter 4: Creating the Data Model; What Is a Data Model?; Creating Table Relations; Creating a Star Schema; Understanding When to Denormalize the Data; Creating Linked Tables; Creating Hierarchies; Making a User-Friendly Model; Summary; Chapter 5: Creating Calculations with DAX; What Is DAX?; Implementing DAX Operators; Working with Text Functions; Using DAX Date and Time Functions
  • Using Informational and Logical FunctionsGetting Data from Related Tables; Using Math, Trig, and Statistical Functions; Tips for Creating Calculations in Power Pivot; Summary; Chapter 6: Creating Measures with DAX; Measures vs. Attributes; Creating Common Aggregates; Mastering Data Context; Altering the Query Context; Using Filter Functions; Creating KPIs; Summary; Chapter 7: Incorporating Time Intelligence; Date-Based Analysis; Creating a Date Table; Time Period-Based Evaluations; Shifting the Date Context; Using Single Date Functions; Creating Semi-Additive Measures; Summary
  • Chapter 8: Data Analysis with Pivot Tables and ChartsPivot Table Fundamentals; Slicing the Data; Adding Visualizations to a Pivot Table; Working with Pivot Charts ; Using Multiple Charts and Tables; Using Cube Functions ; Summary; Part II: Building Interactive Reports and Dashboards with Power BI Desktop; Chapter 9: Introducing Power BI Desktop; Setting Up the Power BI Environment; Getting, Cleaning, and Shaping Data; Creating Table Relationships; Adding Calculations and Measures; Incorporating Time-based Analysis; Summary; Chapter 10: Creating Reports with Power BI Desktop
  • Creating Tables and MatricesConstructing Bar, Column, and Pie Charts; Building Line and Scatter Charts; Creating Map-Based Visualizations; Linking Visualizations in Power BI; Drilling Through Visualizations; Summary; Chapter 11: Publishing Reports and Creating Dashboards in the Power BI Portal; Creating a User-Friendly Model; Publishing Power BI Desktop Files to the Power BI Service; Adding Tiles to a Dashboard; Sharing Dashboards; Refreshing Data in Published Reports; Summary; Chapter 12: Creating a Complete Solution; Use Case 1: Reseller Sales Analysis; Load the Data; Create the Model
Dimensions
unknown
Edition
Second edition.
Extent
1 online resource
File format
unknown
Form of item
online
Isbn
9781484225776
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other physical details
color illustrations
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
ocn974489152
Label
Beginning power BI : a practical guide to self-service data analytics with Excel 2016 and Power BI desktop, Dan Clark
Publication
Note
Includes index
Antecedent source
unknown
Carrier category
online resource
Carrier category code
cr
Carrier MARC source
rdacarrier
Color
multicolored
Content category
text
Content type code
txt
Content type MARC source
rdacontent
Contents
  • At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Part I: Building Models in Power Pivot; Chapter 1: Introducing Power Pivot; Why Use Power Pivot?; The xVelocity In-memory Analytics Engine; Enabling Power Pivot for Excel; Exploring the Data Model Manager Interface; Summary; Chapter 2: Importing Data into Power Pivot; Importing Data from Relational Databases; Importing Data from Text Files; Importing Data from a Data Feed; Importing Data from an OLAP Cube; Reusing Existing Connections to Update the Model; Summary
  • Chapter 3: Data Munging with Power QueryDiscovering and Importing Data; Transforming, Cleansing, and Filtering Data; Merging and Shaping Data; Grouping and Aggregating Data; Inserting Calculated Columns; Summary; Chapter 4: Creating the Data Model; What Is a Data Model?; Creating Table Relations; Creating a Star Schema; Understanding When to Denormalize the Data; Creating Linked Tables; Creating Hierarchies; Making a User-Friendly Model; Summary; Chapter 5: Creating Calculations with DAX; What Is DAX?; Implementing DAX Operators; Working with Text Functions; Using DAX Date and Time Functions
  • Using Informational and Logical FunctionsGetting Data from Related Tables; Using Math, Trig, and Statistical Functions; Tips for Creating Calculations in Power Pivot; Summary; Chapter 6: Creating Measures with DAX; Measures vs. Attributes; Creating Common Aggregates; Mastering Data Context; Altering the Query Context; Using Filter Functions; Creating KPIs; Summary; Chapter 7: Incorporating Time Intelligence; Date-Based Analysis; Creating a Date Table; Time Period-Based Evaluations; Shifting the Date Context; Using Single Date Functions; Creating Semi-Additive Measures; Summary
  • Chapter 8: Data Analysis with Pivot Tables and ChartsPivot Table Fundamentals; Slicing the Data; Adding Visualizations to a Pivot Table; Working with Pivot Charts ; Using Multiple Charts and Tables; Using Cube Functions ; Summary; Part II: Building Interactive Reports and Dashboards with Power BI Desktop; Chapter 9: Introducing Power BI Desktop; Setting Up the Power BI Environment; Getting, Cleaning, and Shaping Data; Creating Table Relationships; Adding Calculations and Measures; Incorporating Time-based Analysis; Summary; Chapter 10: Creating Reports with Power BI Desktop
  • Creating Tables and MatricesConstructing Bar, Column, and Pie Charts; Building Line and Scatter Charts; Creating Map-Based Visualizations; Linking Visualizations in Power BI; Drilling Through Visualizations; Summary; Chapter 11: Publishing Reports and Creating Dashboards in the Power BI Portal; Creating a User-Friendly Model; Publishing Power BI Desktop Files to the Power BI Service; Adding Tiles to a Dashboard; Sharing Dashboards; Refreshing Data in Published Reports; Summary; Chapter 12: Creating a Complete Solution; Use Case 1: Reseller Sales Analysis; Load the Data; Create the Model
Dimensions
unknown
Edition
Second edition.
Extent
1 online resource
File format
unknown
Form of item
online
Isbn
9781484225776
Level of compression
unknown
Media category
computer
Media MARC source
rdamedia
Media type code
c
Other physical details
color illustrations
Quality assurance targets
not applicable
Reformatting quality
unknown
Sound
unknown sound
Specific material designation
remote
System control number
ocn974489152

Library Locations

Processing Feedback ...