Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials Contributor(s): Gamble, Grant (Author) |
|
![]() |
ISBN: 1791315178 ISBN-13: 9781791315177 Publisher: Independently Published OUR PRICE: $11.39 Product Type: Paperback - Other Formats Published: December 2018 |
Additional Information |
BISAC Categories: - Business & Economics | Business Mathematics |
Series: Power Bi Step by Step |
Physical Information: 0.19" H x 8.5" W x 11" (0.53 lbs) 94 pages |
Descriptions, Reviews, Etc. |
Publisher Description: 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 LimitedG 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 Chapter 2: Trim, Clean and Case Chapter 3: House Keeping and Meta Data Chapter 4: The Split Columns Command Chapter 5: Removing Unwanted Rows Chapter 6: Replace Value and Fill Down Chapter 7: The Unpivot Columns Command Chapter 8: Reordering Columns Chapter 9: Creating Custom Columns Chapter 10: Append Queries Chapter 11: Merge Queries Chapter 12: Grouping Data Chapter 13: Power Query Parameters and Templates Chapter 14. Power Query Custom Functions |