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

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...

Full description

Saved in:
Bibliographic Details
Main Author: Clark, Dan, 1963- (Author)
Format: eBook
Language: English
Published: Camp Hill, Pennsylvania : Apress, [2017]
Edition: Second edition.
Subjects:
Microsoft Excel (Computer file)
Microsoft PowerPivot (Computer file)
Business intelligence > Computer programs.
Information visualization > Computer programs.
Business > Data processing.
Visual analytics.
elektronické knihy
electronic books
ISBN: 9781484225776
9781484225769
Physical Description: 1 online resource (xvii, 348 pages) : color illustrations

Cover

Table of contents

LEADER 06951cam a2200589Ii 4500
001 98006
003 CZ-ZlUTB
005 20240914110938.0
006 m o d
007 cr mn|||||||||
008 170303t20172017paua o 001 0 eng d
040 |a N$T  |b eng  |e rda  |e pn  |c N$T  |d IDEBK  |d N$T  |d EBLCP  |d YDX  |d OCLCQ  |d OCLCO  |d UMI  |d UAB  |d STF  |d OSU  |d TOH  |d IOG  |d MERER  |d ESU  |d Z5A  |d OCLCQ  |d JBG  |d IAD  |d ICW  |d ICN  |d ILO  |d OTZ  |d OCLCQ  |d IAS  |d MERUC  |d VLB  |d IDB  |d JG0  |d U3W  |d NJR  |d CAUOI  |d OCLCF  |d CEF  |d KSU  |d VT2  |d OCLCQ  |d OCLCO  |d INT  |d DEBBG  |d TEFOD  |d WYU  |d OCLCQ  |d OCLCO  |d UKMGB  |d OCLCQ  |d OCLCO  |d OCLCQ  |d OCLCO  |d BRX  |d AUD  |d UKAHL  |d OL$  |d OCLCQ  |d OCLCO  |d AZU  |d UPM  |d AU@  |d DOS  |d COO  |d LIV  |d K6U  |d D6H  |d VVB  |d ERF  |d UHL  |d UKBTH  |d OCLCQ 
020 |a 9781484225776  |q (electronic bk.) 
020 |z 9781484225769 
024 7 |a 10.1007/978-1-4842-2577-6  |2 doi 
024 8 |a 9781484225776 
035 |a (OCoLC)974489152  |z (OCoLC)974688552  |z (OCoLC)974738451  |z (OCoLC)974979529  |z (OCoLC)975010272  |z (OCoLC)975082797  |z (OCoLC)975224429  |z (OCoLC)975422581  |z (OCoLC)980303805  |z (OCoLC)984855464  |z (OCoLC)994604762  |z (OCoLC)1048176593  |z (OCoLC)1066561335  |z (OCoLC)1088961987  |z (OCoLC)1103255262  |z (OCoLC)1112534897  |z (OCoLC)1112595127  |z (OCoLC)1113287351  |z (OCoLC)1113669748  |z (OCoLC)1129345702 
100 1 |a Clark, Dan,  |d 1963-  |e author. 
245 1 0 |a Beginning power BI :  |b a practical guide to self-service data analytics with Excel 2016 and Power BI desktop /  |c Dan Clark. 
246 1 |a Practical guide to self-service data analytics with Excel 2016 and Power BI desktop 
250 |a Second edition. 
264 1 |a Camp Hill, Pennsylvania :  |b Apress,  |c [2017] 
264 4 |c ©2017 
300 |a 1 online resource (xvii, 348 pages) :  |b color illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a počítač  |b c  |2 rdamedia 
338 |a online zdroj  |b cr  |2 rdacarrier 
500 |a Includes index. 
505 0 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
505 8 |a 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. 
506 |a Plný text je dostupný pouze z IP adres počítačů Univerzity Tomáše Bati ve Zlíně nebo vzdáleným přístupem pro zaměstnance a studenty 
520 |a 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. 
504 |a Includes bibliographical references. 
590 |a SpringerLink  |b Springer Complete eBooks 
630 0 0 |a Microsoft Excel (Computer file) 
630 0 0 |a Microsoft PowerPivot (Computer file) 
630 0 7 |a Microsoft Excel (Computer file)  |2 fast  |0 (OCoLC)fst01366659 
630 0 7 |a Microsoft PowerPivot (Computer file)  |2 fast  |0 (OCoLC)fst01915392 
650 0 |a Business intelligence  |x Computer programs. 
650 0 |a Information visualization  |x Computer programs. 
650 0 |a Business  |x Data processing. 
650 0 |a Visual analytics. 
655 7 |a elektronické knihy  |7 fd186907  |2 czenas 
655 9 |a electronic books  |2 eczenas 
776 0 8 |i Print version:  |a Clark, Dan.  |t Beginning Power BI : A Practical Guide to Self-Service Data Analytics with Excel 2016 and Power BI Desktop.  |d Berkeley, CA : Apress, ©2017  |z 9781484225769 
856 4 0 |u https://proxy.k.utb.cz/login?url=https://link.springer.com/10.1007/978-1-4842-2577-6  |y Plný text 
992 |c NTK-SpringerBM 
999 |c 98006  |d 98006 
993 |x NEPOSILAT  |y EIZ 

Similar Items