Kids Library Home

Welcome to the Kids' Library!

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

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

Title Beginning power BI with Excel 2013 : self-service business intelligence using Power Pivot, power view, power query, and power map / Dan Clark.

Publication Info. Berkeley, CA : Apress, 2014.
New York, NY : Distributed to the Book trade worldwide by Springer


Location Call No. OPAC Message Status
 Axe Books 24x7 IT E-Book  Electronic Book    ---  Available
Description 1 online resource : illustrations.
text txt rdacontent
computer c rdamedia
online resource cr rdacarrier
text file PDF rda
Series The expert's voice in business intelligence
Expert's voice in business intelligence.
Note Includes index.
Online resource; title from PDF title page (SpringerLink, viewed October 21, 2014).
Summary Understanding your company?s data has never been easier than with Microsoft?s new Power BI package for Excel 2013. Consisting of four powerful tools?Power Pivot, Power View, Power Query and Power Maps?Power BI makes self-service business intelligence a reality for a wide range of users, bridging the traditional gap between Excel users, business analysts and IT experts and making it easier for everyone to work together to build the data models that can give you game-changing insights into your business. Beginning Power BI with Excel 2013 guides you step by step through the process of analyzing and visualizing your data. Daniel R. Clark, an expert in BI training and a regular speaker on these topics, takes you through each tool in turn, using hands-on activities to consolidate what you?ve learned in each chapter. Starting with Power Pivot, you will create robust scalable data models which will serve as the foundation of your data analysis. Once you have mastered creating suitable data models, you will use them to build compelling interactive visualizations in Power View. It?s often necessary to combine data from disparate sources into a data model. Power Query allows you to easily discover, combine, and refine data from a variety of sources, so you can make accurate judgments with all the available information. Geographical awareness is another common requirement of data analysis. Using Power Maps you will create captivating visualizations that map your data in space and time. Beginning Power BI with Excel 2013 is your practical guide to getting maximum insight from your data, and presenting it with impact.
Contents At a Glance; Contents; About the Author; About the Technical Reviewers; Acknowledgments; Introduction; Part 1: 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: Creating the Data ModelWhat 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 4: Creating Calculations with DAX; What Is DAX?; Implementing DAX Operators; Working with Text Functions; Using DAX Date and Time Functions; Using Informational and Logical Functions; Getting Data from Related Tables; Using Math, Trig, and Statistical Functions; Tips for Creating Calculations in Power Pivot; Summary.
Chapter 5: Creating Measures with DAXMeasures versus Attributes; Creating Common Aggregates; Mastering Data Context; Altering the Query Context; Using Filter Functions; Creating KPIs; Summary; Chapter 6: 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 7: Data Analysis with Pivot Tables and Charts; Pivot Table Fundamentals; Slicing the Data; Adding Visualizations to a Pivot Table; Working with Pivot Charts.
Using Multiple Charts and TablesUsing Cube Functions; Summary; Part 2: Building Interactive Reports and Dashboards with Power View; Chapter 8: Optimizing Power Pivot Models for Power View; Visualizing Data with Power View; Creating a Basic Report; Improving the Power View Experience; Summary; Chapter 9: Creating Standard Visualizations with Power View; Creating Tables and Matrices; Constructing Bar, Column, and Pie Charts; Building Line and Scatter Charts; Creating Map-Based Visualizations; Summary; Chapter 10: Creating Interactive Dashboards with Power View.
Linking Visualizations in Power ViewUsing Tiles to Organize the Data; Filtering Groups and Views; Exposing the Dashboard; Summary; Part 3: Exploring and Presenting Data with Power Query and Power Map; Chapter 11: Data Discovery with Power Query; Discovering and Importing Data; Transforming, Cleansing, and Filtering Data; Merging and Shaping Data; Grouping and Aggregating Data; Inserting Calculated Columns; Summary; Chapter 12: Geospatial Analysis with Power Map; Preparing Data for Mapping; Creating a Map-Based Graph; Creating Heat and Region Maps; Adding Multiple Layers to a Power Map.
Subject Microsoft PowerPivot (Computer file)
Microsoft Excel (Computer file)
Microsoft Excel (Computer file) (OCoLC)fst01366659
Microsoft PowerPivot (Computer file) (OCoLC)fst01915392
Business -- Data processing.
COMPUTERS -- Desktop Applications -- Spreadsheets.
Business -- Data processing. (OCoLC)fst00842293
Genre/Form Electronic books.
Other Form: Printed edition: 9781430264453
ISBN 9781430264460 (electronic bk.)
1430264462 (electronic bk.)
1430264454 (print)
9781430264453 (print)
Standard No. 10.1007/978-1-4302-6446-0 doi
AU@ 000056023424
CHNEW 000890450
CHVBK 374491674
DEBBG BV042991197
DEBBG BV043617622
NLGGC 383022290

Available items only