Muutke küpsiste eelistusi

E-raamat: Beginning Microsoft Power BI: A Practical Guide to Self-Service Data Analytics

3.56/5 (17 hinnangut Goodreads-ist)
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 21-Feb-2020
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484256206
Teised raamatud teemal:
  • Formaat - EPUB+DRM
  • Hind: 61,74 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Lisa ostukorvi
  • Lisa soovinimekirja
  • See e-raamat on mõeldud ainult isiklikuks kasutamiseks. E-raamatuid ei saa tagastada.
Beginning Microsoft Power BI: A Practical Guide to Self-Service Data AnalyticsSuurem pilt
  • Formaat: EPUB+DRM
  • Ilmumisaeg: 21-Feb-2020
  • Kirjastus: APress
  • Keel: eng
  • ISBN-13: 9781484256206
Teised raamatud teemal:

DRM piirangud

  • Kopeerimine (copy/paste):

    ei ole lubatud

  • Printimine:

    ei ole lubatud

  • Kasutamine:

    Digitaalõiguste kaitse (DRM)
    Kirjastus on väljastanud selle e-raamatu krüpteeritud kujul, mis tähendab, et selle lugemiseks peate installeerima spetsiaalse tarkvara. Samuti peate looma endale  Adobe ID Rohkem infot siin. E-raamatut saab lugeda 1 kasutaja ning alla laadida kuni 6'de seadmesse (kõik autoriseeritud sama Adobe ID-ga).

    Vajalik tarkvara
    Mobiilsetes seadmetes (telefon või tahvelarvuti) lugemiseks peate installeerima selle tasuta rakenduse: PocketBook Reader (iOS / Android)

    PC või Mac seadmes lugemiseks peate installima Adobe Digital Editionsi (Seeon tasuta rakendus spetsiaalselt e-raamatute lugemiseks. Seda ei tohi segamini ajada Adober Reader'iga, mis tõenäoliselt on juba teie arvutisse installeeritud )

    Seda e-raamatut ei saa lugeda Amazon Kindle's. 

Analyze company data quickly and easily using Microsoft’s powerful data tools. Learn to build scalable and robust data models, clean and combine different data sources effectively, and create compelling and professional visuals.

Beginning Power BI is a hands-on, activity-based guide that takes you through the process of analyzing your data using the tools that that encompass the core of Microsoft’s self-service BI offering. Starting with Power Query, you will learn how to get data from a variety of sources, and see just how easy it is to clean and shape the data prior to importing it into a data model. Using Power BI tabular and the Data Analysis Expressions (DAX), you will learn to create robust scalable data models which will serve as the foundation of your data analysis. From there you will enter the world of compelling interactive visualizations to analyze and gain insight into your data. You will wrap up your Power BI journey by learning how to package and share your reports and dashboards 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 third edition covers the new and evolving features in the Power BI platform and new chapters on data flows and composite models. This book is your hands-on guide to quick, reliable, and valuable data insight.


What You Will Learn

  • Simplify data discovery, association, and cleansing
  • Build 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




Beginning-Intermediate user level
About the Author ix
About the Technical Reviewer xi
Acknowledgments xiii
Introduction xv
Chapter 1 Introducing Power BI
1(20)
Why Use Power Bl?
1(2)
The xVelocity In-Memory Analytics Engine
3(1)
Setting Up the Power Bl Environment
4(2)
Exploring the Power Bl Desktop Interface
6(14)
Summary
20(1)
Chapter 2 Importing Data into Power Bl Desktop
21(26)
Importing Data from Relational Databases
21(14)
Importing Data from Text Files
35(3)
Importing Data from a Data Feed
38(2)
Importing Data from Analysis Services
40(6)
Summary
46(1)
Chapter 3 Data Munging with Power Query
47(30)
Discovering and Importing Data
47(5)
Transforming, Cleansing, and Filtering Data
52(6)
Merging Data
58(4)
Appending Data
62(1)
Splitting Data
62(1)
Unpivoting Data
63(2)
Grouping and Aggregating Data
65(1)
Inserting Calculated Columns
66(9)
Summary
75(2)
Chapter 4 Creating the Data Model
77(28)
What Is a Data Model?
77(3)
Creating Table Relations
80(6)
Creating a Star Schema
86(1)
Understanding When to Denormalize the Data
87(2)
Making a User-Friendly Model
89(15)
Summary
104(1)
Chapter 5 Creating Calculations with DAX
105(22)
What Is DAX?
105(4)
Implementing DAX Operators
109(3)
Working with Text Functions
112(1)
Using DAX Date and Time Functions
113(2)
Using Informational and Logical Functions
115(2)
Getting Data from Related Tables
117(2)
Using Math, Trig, and Statistical Functions
119(2)
Tips for Creating Calculations in Power BI
121(4)
Summary
125(2)
Chapter 6 Creating Measures with DAX
127(24)
Measures vs. Attributes
127(2)
Creating Common Aggregates
129(3)
Mastering Data Context
132(2)
Altering the Query Context
134(1)
Using Filter Functions
135(8)
Using Variables in DAX
143(7)
Summary
150(1)
Chapter 7 Incorporating Time Intelligence
151(22)
Date-Based Analysis
151(2)
Creating a Date Table
153(3)
Time Period-Based Evaluations
156(2)
Shifting the Date Context
158(3)
Using Single Date Functions
161(2)
Creating Semi-additive Measures
163(8)
Summary
171(2)
Chapter 8 Creating Reports with Power BI Desktop
173(38)
Creating Tables and Matrices
173(6)
Constructing Bar, Column, and Pie Charts
179(8)
Building Line and Scatter Charts
187(4)
Creating Map-Based Visualizations
191(5)
Linking Visualizations in Power BI
196(5)
Drilling Through Visualizations
201(8)
Summary
209(2)
Chapter 9 Publishing Reports and Creating Dashboards in the Power BI Portal
211(36)
Creating a User-Friendly Model
211(3)
Publishing Power BI Desktop Files to the Power BI Service
214(4)
Adding Tiles to a Dashboard
218(7)
Sharing Dashboards
225(3)
Refreshing Data in Published Reports
228(17)
Summary
245(2)
Chapter 10 Introducing Power Pivot in Excel
247(30)
Setting Up the Power Pivot Environment
248(3)
Getting, Cleaning, and Shaping Data
251(7)
Creating Table Relationships
258(5)
Adding Calculations and Measures
263(3)
Incorporating Time-Based Analysis
266(10)
Summary
276(1)
Chapter 11 Data Analysis with Pivot Tables and Charts
277(28)
Pivot Table Fundamentals
278(2)
Slicing the Data
280(4)
Adding Visualizations to a Pivot Table
284(4)
Working with Pivot Charts
288(3)
Using Multiple Charts and Tables
291(3)
Using Cube Functions
294(10)
Summary
304(1)
Chapter 12 Creating a Complete Solution
305(30)
Use Case 1 Sales Quota Analysis
305(11)
Use Case 2 Reseller Sales Analysis
316(13)
Use Case 3 Sensor Analysis
329(3)
Summary
332(3)
Chapter 13 Advanced Topics in Power Query
335(20)
Writing Queries with M
335(4)
Creating and Using Parameters
339(5)
Creating and Using Functions
344(10)
Summary
354(1)
Chapter 14 Advanced Topics in Power BI Desktop
355(22)
Using Custom Visuals
355(3)
Implementing Geospatial Analysis
358(3)
Implementing Row-Based Security
361(2)
Creating Templates and Content Packs
363(12)
Summary
375(2)
Chapter 15 Advanced Topics in Power BI Data Modeling
377(26)
Direct Queries
377(1)
Using Aggregation Tables
378(6)
Implementing Dataflows
384(18)
Summary
402(1)
Index 403
Dan Clark is a senior business intelligence (BI) and programming consultant specializing in Microsoft technologies. He is focused on learning new BI and data technologies and training others  on 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 and database conferences and user group meetings and enjoys interacting with the Microsoft communities. In a previous life, Dan 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. 
Lisainfo e-raamatute kohta Lisainfo e-raamatute kohta
Püsilink: https://www.kriso.ee/db/97814842562066e.html
Märksõnad: