Beginning power BI : a practical guide to self-service data analytics with Excel 2016 and Power BI desktop /: a practical guide to self-service data analytics with Excel 2016 and Power BI desktop. ([2017])

• Record Type: Book
• Further Information: Note: Dan Clark.
• Authors: Clark, Dan, 1963-
• 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.
• Edition: Second edition
• Publisher Details: Camp Hill, Pennsylvania : Apress
• Publication Date: 2017
• Copyright Date: 2017
• Extent: 1 online resource (xvii, 348 pages), color illustrations
• Subjects: 005.54; Business; Business intelligence -- Computer programs; Information visualization -- Computer programs; Business -- Data processing; Visual analytics; Management science; Big data; Knowledge management; Information systems; COMPUTER SCIENCE -- General; Business -- Data processing; Visual analytics; Business & Economics -- Information Management; Computers -- Online Services -- General; Knowledge management; Computer networking & communications; Business & Economics -- Industries -- Computer Industry; Business mathematics & systems; Electronic books
• Languages: English
• ISBNs: 9781484225776; 1484225775
• Related ISBNs: 9781484225769; 1484225767
• Notes: Note: Print version record.
• Access Rights: Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
• Access Usage: Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.