Kids Library Home

Welcome to the Kids' Library!

Search for books, movies, music, magazines, and more.

Available items only
Record 9 of 146
Previous Record Next Record
Author Clark, Dan, 1963- author.

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

Publication Info. Camp Hill, Pennsylvania : Apress, [2017]


Location Call No. OPAC Message Status
 Axe Books 24x7 IT E-Book  Electronic Book    ---  Available
Edition Second edition.
Description 1 online resource (xvii, 348 pages) : color illustrations
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
Note Includes index.
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.
Note Print version record.
Summary Analyze your company's data quickly and easily using Microsoft's latest tools. Build scalable and robust data models to work from. Learn to clean and combine different data sources effectively. Create compelling visualizations and share them with your colleagues. Author Dan Clark takes you through each topic using step-by-step activities and plenty of screen shots to help familiarize you with the tools. This second edition includes new material on advanced uses of Power Query, along with the latest user guidance on the evolving Power BI platform. Beginning Power BI is your hands-on guide to quick, reliable, and valuable data insight. What You Will Learn: Simplify data discovery, association, and cleansing Create solid analytical data models Create robust interactive data presentations Combine analytical and geographic data in map-based visualizations Publish and share dashboards and reports.
Subject Microsoft Excel (Computer file)
Microsoft PowerPivot (Computer file)
Microsoft Excel (Computer file) (OCoLC)fst01366659
Microsoft PowerPivot (Computer file) (OCoLC)fst01915392
Business intelligence -- Computer programs.
Information visualization -- Computer programs.
Business -- Data processing.
Visual analytics.
Knowledge management.
Computer networking & communications.
Business mathematics & systems.
Business -- Data processing. (OCoLC)fst00842293
Visual analytics. (OCoLC)fst01743387
Genre/Form Electronic book.
Electronic books.
Other Form: Print version: Clark, Dan. Beginning Power BI : A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop. Berkeley, CA : Apress, 2017 9781484225769
ISBN 9781484225776 (electronic bk.)
1484225775 (electronic bk.)
Standard No. AU@ 000061156180
GBVCP 1004860137
UKMGB 019127086

Available items only