購物比價找書網找車網
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折
個人實相的本質有聲書第1輯﹝2015年新版﹞
作者:許添盛主講
出版社:賽斯文化
出版日期:2015-11-16
66折: $ 660 
金石堂 - 今日66折
鋪梗力:影響力教父最新研究與技術,在開口前就說服對方
作者:羅伯特.席爾迪尼
出版社:時報文化出版企業股份有限公司
出版日期:2017-11-21
66折: $ 284 
金石堂 - 今日66折
2025ㄇㄚˊ幾手帳+桌曆套組(隨書附贈霧面PVC書套+書籤)
作者:YUKIJI
出版社:春光出版股份有限公司
出版日期:2024-11-09
66折: $ 626 
金石堂 - 今日66折
【每日讀詩詞】唐宋詞鑑賞辭典(全五卷)+【每日讀詩詞】唐宋詞鑑賞辭典【別冊】
作者:程千帆、俞平伯、施蟄存
出版社:啟動文化
出版日期:2020-11-04
66折: $ 3135 
 
博客來 - 暢銷排行榜
治癒悖論 deeper 上+下 (首刷限定版)
$ 399 
金石堂 - 暢銷排行榜
雙層壓克力吊飾《請解開故事謎底》小美男魚
作者:花於景(雷雷夥伴)
出版社:原動力文化事業有限公司
出版日期:2025-02-12
$ 270 
金石堂 - 暢銷排行榜
醫美夫妻告訴你:醫美前你必須知道的全方位關鍵知識 無痕筋膜拉提回春術、淚溝黑眼圈擦擦筆》
作者:許源津,賴暉元
出版社:耕己行銷有限公司
出版日期:2025-01-01
$ 379 
博客來 - 暢銷排行榜
請解開故事謎底【2025珍藏特裝組】
$ 594 
 
博客來 - 新書排行榜
光逝去的夏天 (5)
出版日期:2025-02-13
$ 110 
Taaze 讀冊生活 - 新書排行榜
微賤
作者:黃裕邦
出版社:時報文化出版企業股份有限公司
出版日期:2025-01-21
$ 322 
金石堂 - 新書排行榜
請調查是不是色色的身體!~新.少子化對策計畫(全)
作者:むちぱん
出版社:紳士出版
出版日期:2025-02-14
$ 333 
 

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