購物比價找書網找車網
FindBook  
 有 1 項符合

Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials

的圖書
Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials

作者:Gamble 
出版社:Independently Published
出版日期:2018-12-09
語言:英文   規格:平裝 / 94頁 / 27.94 x 21.59 x 0.48 cm / 普通級/ 初版
圖書選購
型式價格供應商所屬目錄
 
$ 659
博客來 博客來
商業理論與工具書
圖書介紹 - 資料來源:博客來   評分:
圖書名稱:Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials

內容簡介

Self-Service Business Intelligence

Power BI enables business users to interact with corporate information and to extract the reports and intel they need. Power BI allows users to access reports and dashboards using familiar tools and devices. Self-service BI has never been so user-friendly!

The Microsoft Power BI Step-by-Step series will show you how to create compelling visualizations and reports which provide deep insights into your data.


G Com Solutions Limited

G Com Solutions Limited provide Power BI training in Peterborough, London and throughout the UK. Details of their Power BI courses can be found at the following URL:

https: //gcomsolutions.co.uk/microsoft-power-bi-training-courses/

In this third book in the series, we focus on data cleansing and transformation. The techniques covered in this book apply both to using the Query Editor in Power BI Desktop and using Power Query to create dataflows in the Power BI service.

After having plenty of hands-on practice on cleaning and transforming data, you will learn how to leverage templates, parameters and custom functions to create reusable Power BI reporting solutions.

Introduction

Chapter 1: Power BI Dataflows vs Power BI Desktop
Data Preparation
Using a Dataflow as a Data Source
Conclusion

Chapter 2: Trim, Clean and Case
Isolating the Problem
Using the Trim Function
Using the Clean Function
Using the Replace Values Command
Using the Capitalize Each Word Command
Conclusion

Chapter 3: House Keeping and Meta Data
Renaming Items
Renaming Columns
Renaming Query Steps
Adding Descriptions to your Steps
Conclusion

Chapter 4: The Split Columns Command
Tidying up the Data
Using Split by Number of Characters
Creating Relationships
Creating a Treemap Visual
Creating a Filled Map Visual
Conclusion

Chapter 5: Removing Unwanted Rows
Removing Header Rows
Removing an Excel Table Total Row
Conclusion

Chapter 6: Replace Value and Fill Down
The Replace Values Command
Remove Errors and Replace Errors
The Fill Down Command
Conclusion

Chapter 7: The Unpivot Columns Command
What is Pivoted Data?
Importing the Data
Using UnPivot Other Columns
Creating a Bar Chart Visual
Conclusion

Chapter 8: Reordering Columns
Benefits of Changing Column Order
Moving Columns by Dragging
Moving Columns Relative to Other Columns
Conclusion

Chapter 9: Creating Custom Columns
Using Split by Delimiter
Using the Add Custom Columns Command
Conclusion

Chapter 10: Append Queries
Importing the Data
Removing the differences between columns
Using Append Queries as New
Conclusion

Chapter 11: Merge Queries
Using Merge Queries as New
Specifying the Join Kind
Conclusion

Chapter 12: Grouping Data
Benefits of Grouping Data
Adding Groupings
Adding Aggregations
Conclusion

Chapter 13: Power Query Parameters and Templates
Benefits of parameters and templates
Overview of Our Example
Creating Dynamic Titles
Creating parameters
Name and Description
Optional or Required
Parameter Type
Suggested Values
Default Value vs Current Value
Creating Parameters on the Fly
Updating a Data Source via a Parameter
Parameterizing Filter Operations
Creating a Template
Using a Template
Conclusion

Chapter 14. Power Query Custom Functions
Converting a Query to a Function
Connecting to our Example file
Creating a parameter
Invoking a Function
Using the Invoke Custom Function Command
Understanding Function Syntax
Creating a Date of Birth function
Conclusion

 

詳細資料

  • ISBN:9781791315177
  • 規格:平裝 / 94頁 / 27.94 x 21.59 x 0.48 cm / 普通級 / 初版
  • 出版地:美國
贊助商廣告
 
金石堂 - 今日66折
個人實相的本質有聲書第8輯(新版)
作者:許添盛醫師
出版社:賽斯文化
出版日期:2020-10-26
66折: $ 660 
金石堂 - 今日66折
早期課1有聲書第2輯
作者:許添盛、李宜懃
出版社:賽斯文化
出版日期:2020-04-01
66折: $ 660 
金石堂 - 今日66折
破除恐懼 有聲書
作者:許添盛
出版社:賽斯文化
出版日期:2020-08-01
66折: $ 1505 
金石堂 - 今日66折
未知的實相有聲書【第6輯】
作者:許添盛
出版社:賽斯文化
出版日期:2009-03-01
66折: $ 581 
 
金石堂 - 暢銷排行榜
九井諒子塗鴉集 白日夢時光(全)
作者:九井諒子
出版社:青文出版社股份有限公司
出版日期:2025-01-22
$ 435 
博客來 - 暢銷排行榜
失控的焦慮世代:手機餵養的世代,如何面對心理疾病的瘟疫
作者:強納森.海德特 (Jonathan Haidt)
出版社:網路與書出版
出版日期:2024-11-29
$ 379 
博客來 - 暢銷排行榜
四季戚風蛋糕專門書(博客來獨家親簽版):柔軟綿密蛋糕 X 四季更迭花草,結合戚風蛋糕與鮮奶油裝飾,探索四季獨特風味
作者:呂昇達
出版社:優品文化事業有限公司
出版日期:2025-01-15
$ 434 
金石堂 - 暢銷排行榜
你的吻有謊言的味道(9)
作者:サガミワカ
出版社:台灣東販股份有限公司
出版日期:2025-01-24
$ 111 
 
博客來 - 新書排行榜
膽大黨 16 (首刷限定版)
作者:龍幸伸
出版社:東立
出版日期:2025-01-23
$ 127 
博客來 - 新書排行榜
黃仁勳傳:輝達創辦人如何打造全球最搶手的晶片
作者:史帝芬.維特 (Stephen Witt)
出版社:天下文化
出版日期:2025-01-20
$ 395 
金石堂 - 新書排行榜
東京-臨界點- (首刷限定版)(全)
作者:ハル
出版社:東立出版社
出版日期:2025-01-22
$ 187 
博客來 - 新書排行榜
失控的焦慮世代:手機餵養的世代,如何面對心理疾病的瘟疫
作者:強納森.海德特 (Jonathan Haidt)
出版社:網路與書出版
出版日期:2024-11-29
$ 379 
 

©2025 FindBook.com.tw -  購物比價  找書網  找車網  服務條款  隱私權政策