Hugendubel.info - Die B2B Online-Buchhandlung 

Merkliste
Die Merkliste ist leer.
Bitte warten - die Druckansicht der Seite wird vorbereitet.
Der Druckdialog öffnet sich, sobald die Seite vollständig geladen wurde.
Sollte die Druckvorschau unvollständig sein, bitte schliessen und "Erneut drucken" wählen.

Beginning Power BI

E-BookPDF1 - PDF WatermarkE-Book
Englisch
Apresserschienen am28.02.20172nd ed
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




Who This Book Is For

Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data.





Dan Clark is a senior business intelligence (BI)/programming consultant specializing in Microsoft technologies. He is focused on learning new BI/data technologies and on training others how to best implement the technology. Dan has published several books and numerous articles on .NET programming and BI development. He is a regular speaker at various developer/database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. In a previous life, he was a physics teacher; he is still inspired by the wonder and awe of studying the universe and figuring out why things behave the way they do.mehr

Produkt

KlappentextAnalyze 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




Who This Book Is For

Business analysts, database administrators, developers, and other professionals looking to better understand and communicate with data.





Dan Clark is a senior business intelligence (BI)/programming consultant specializing in Microsoft technologies. He is focused on learning new BI/data technologies and on training others how to best implement the technology. Dan has published several books and numerous articles on .NET programming and BI development. He is a regular speaker at various developer/database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. In a previous life, he was a physics teacher; he is still inspired by the wonder and awe of studying the universe and figuring out why things behave the way they do.
Details
Weitere ISBN/GTIN9781484225776
ProduktartE-Book
EinbandartE-Book
FormatPDF
Format Hinweis1 - PDF Watermark
FormatE107
Verlag
Erscheinungsjahr2017
Erscheinungsdatum28.02.2017
Auflage2nd ed
SpracheEnglisch
IllustrationenXVII, 348 p. 380 illus., 370 illus. in color.
Artikel-Nr.2272749
Rubriken
Genre9200

Inhalt/Kritik

Inhaltsverzeichnis
1;Contents at a Glance;4
2;Contents;6
3;About the Author;11
4;About the Technical Reviewer;12
5;Acknowledgments;13
6;Introduction;14
7;Part I: Building Models in Power Pivot;15
7.1;Chapter 1: Introducing Power Pivot;16
7.1.1;Why Use Power Pivot?;16
7.1.2;The xVelocity In-memory Analytics Engine;17
7.1.3;Enabling Power Pivot for Excel;18
7.1.4;Exploring the Data Model Manager Interface;21
7.1.5;Summary;31
7.2;Chapter 2: Importing Data into Power Pivot;32
7.2.1;Importing Data from Relational Databases;32
7.2.2;Importing Data from Text Files;47
7.2.3;Importing Data from a Data Feed;52
7.2.4;Importing Data from an OLAP Cube;54
7.2.5;Reusing Existing Connections to Update the Model;56
7.2.6;Summary;67
7.3;Chapter 3: Data Munging with Power Query;68
7.3.1;Discovering and Importing Data;68
7.3.2;Transforming, Cleansing, and Filtering Data;71
7.3.3;Merging and Shaping Data;74
7.3.4;Grouping and Aggregating Data;78
7.3.5;Inserting Calculated Columns;80
7.3.6;Summary;88
7.4;Chapter 4: Creating the Data Model;89
7.4.1;What Is a Data Model?;89
7.4.2;Creating Table Relations;91
7.4.3;Creating a Star Schema;95
7.4.4;Understanding When to Denormalize the Data;97
7.4.5;Creating Linked Tables;98
7.4.6;Creating Hierarchies;100
7.4.7;Making a User-Friendly Model;100
7.4.8;Summary;111
7.5;Chapter 5: Creating Calculations with DAX;112
7.5.1;What Is DAX?;112
7.5.2;Implementing DAX Operators;115
7.5.3;Working with Text Functions;116
7.5.4;Using DAX Date and Time Functions;118
7.5.5;Using Informational and Logical Functions;119
7.5.6;Getting Data from Related Tables;120
7.5.7;Using Math, Trig, and Statistical Functions;121
7.5.8;Tips for Creating Calculations in Power Pivot;123
7.5.9;Summary;128
7.6;Chapter 6: Creating Measures with DAX;129
7.6.1;Measures vs. Attributes;129
7.6.2;Creating Common Aggregates;131
7.6.3;Mastering Data Context;134
7.6.4;Altering the Query Context;135
7.6.5;Using Filter Functions;137
7.6.6;Creating KPIs;142
7.6.7;Summary;153
7.7;Chapter 7: Incorporating Time Intelligence;154
7.7.1;Date-Based Analysis;154
7.7.2;Creating a Date Table;156
7.7.3;Time Period-Based Evaluations;159
7.7.4;Shifting the Date Context;160
7.7.5;Using Single Date Functions;164
7.7.6;Creating Semi-Additive Measures;165
7.7.7;Summary;173
7.8;Chapter 8: Data Analysis with Pivot Tables and Charts;174
7.8.1;Pivot Table Fundamentals;174
7.8.2;Slicing the Data;177
7.8.3;Adding Visualizations to a Pivot Table;179
7.8.4;Working with Pivot Charts;183
7.8.5;Using Multiple Charts and Tables;187
7.8.6;Using Cube Functions;189
7.8.7;Summary;198
8;Part II: Building Interactive Reports and Dashboards with Power BI Desktop;199
8.1;Chapter 9: Introducing Power BI Desktop;200
8.1.1;Setting Up the Power BI Environment;200
8.1.2;Getting, Cleaning, and Shaping Data;203
8.1.3;Creating Table Relationships;209
8.1.4;Adding Calculations and Measures;214
8.1.5;Incorporating Time-based Analysis;217
8.1.6;Summary;223
8.2;Chapter 10: Creating Reports with Power BI Desktop;224
8.2.1;Creating Tables and Matrices;224
8.2.2;Constructing Bar, Column, and Pie Charts;229
8.2.3;Building Line and Scatter Charts;236
8.2.4;Creating Map-Based Visualizations;241
8.2.5;Linking Visualizations in Power BI;246
8.2.6;Drilling Through Visualizations;250
8.2.7;Summary;256
8.3;Chapter 11: Publishing Reports and Creating Dashboards in the Power BI Portal;257
8.3.1;Creating a User-Friendly Model;257
8.3.2;Publishing Power BI Desktop Files to the Power BI Service;260
8.3.3;Adding Tiles to a Dashboard;263
8.3.4;Sharing Dashboards;268
8.3.5;Refreshing Data in Published Reports;272
8.3.6;Summary;287
8.4;Chapter 12: Creating a Complete Solution;288
8.4.1;Use Case 1: Reseller Sales Analysis;288
8.4.1.1;Load the Data;288
8.4.1.2;Create the Model;289
8.4.1.3;Create Calculated Columns;291
8.4.1.4;Create Measures;291
8.4.1.5;Create the Dashboard;293
8.4.2;Use Case 2: Sales Quota Analysis;295
8.4.2.1;Load the Data;295
8.4.2.2;Create the Model;299
8.4.2.3;Create Measures;300
8.4.2.4;Create the Report;301
8.4.3;Use Case 3: Sensor Analysis;302
8.4.3.1;Load the Data;303
8.4.4;Summary;305
8.5;Chapter 13: Advanced Topics in Power Query;306
8.5.1;Writing Queries with M;306
8.5.2;Creating and Using Parameters;309
8.5.3;Creating and Using Functions;314
8.5.4;Summary;323
8.6;Chapter 14: Advanced Topics in Power BI;324
8.6.1;Using Custom Visuals;324
8.6.2;Implementing Geo-spatial Analysis;328
8.6.3;Implementing Row-Based Security;333
8.6.4;Creating Templates and Content Packs;335
8.6.5;Summary;347
9;Index;348mehr

Autor

Dan Clark is a senior business intelligence (BI)/programming consultant specializing in Microsoft technologies. He is focused on learning new BI/data technologies and on training others how to best implement the technology. Dan has published several books and numerous articles on .NET programming and BI development. He is a regular speaker at various developer/database conferences and user group meetings and enjoys interacting with the Microsoft developer and database communities. In a previous life, he was a physics teacher; he is still inspired by the wonder and awe of studying the universe and figuring out why things behave the way they do.