{"product_id":"power-bi-step-by-step-part-3-power-query-parameters-templates-custom-functions-power-bi-mastery-through-hands-on-tutorials-9781791315177","title":"Power BI Step-by-Step Part 3: Power Query, Parameters, Templates \u0026 Custom Functions: Power BI Mastery through hands-on Tutorials","description":"Self-Service Business Intelligence\u003cbr\u003e \u003cp\u003ePower 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!\u003c\/p\u003e\u003cp\u003eThe Microsoft Power BI Step-by-Step series will show you how to create compelling visualizations and reports which provide deep insights into your data.\u003c\/p\u003e \u003cbr\u003eG Com Solutions Limited\u003cp\u003eG 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: \u003c\/p\u003e\u003cp\u003ehttps: \/\/gcomsolutions.co.uk\/microsoft-power-bi-training-courses\/\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eIn 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.\u003c\/p\u003e\u003cp\u003eAfter 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.\u003c\/p\u003e\u003cp\u003eIntroduction\u003c\/p\u003e\u003cp\u003eChapter 1: Power BI Dataflows vs Power BI Desktop\u003cbr\u003eData Preparation\u003cbr\u003eUsing a Dataflow as a Data Source\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 2: Trim, Clean and Case\u003cbr\u003eIsolating the Problem\u003cbr\u003eUsing the Trim Function\u003cbr\u003eUsing the Clean Function\u003cbr\u003eUsing the Replace Values Command\u003cbr\u003eUsing the Capitalize Each Word Command\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 3: House Keeping and Meta Data\u003cbr\u003eRenaming Items\u003cbr\u003eRenaming Columns\u003cbr\u003eRenaming Query Steps\u003cbr\u003eAdding Descriptions to your Steps\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 4: The Split Columns Command\u003cbr\u003eTidying up the Data\u003cbr\u003eUsing Split by Number of Characters\u003cbr\u003eCreating Relationships\u003cbr\u003eCreating a Treemap Visual\u003cbr\u003eCreating a Filled Map Visual\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 5: Removing Unwanted Rows\u003cbr\u003eRemoving Header Rows\u003cbr\u003eRemoving an Excel Table Total Row\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 6: Replace Value and Fill Down\u003cbr\u003eThe Replace Values Command\u003cbr\u003eRemove Errors and Replace Errors\u003cbr\u003eThe Fill Down Command\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 7: The Unpivot Columns Command\u003cbr\u003eWhat is Pivoted Data?\u003cbr\u003eImporting the Data\u003cbr\u003eUsing UnPivot Other Columns\u003cbr\u003eCreating a Bar Chart Visual\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 8: Reordering Columns\u003cbr\u003eBenefits of Changing Column Order\u003cbr\u003eMoving Columns by Dragging\u003cbr\u003eMoving Columns Relative to Other Columns\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 9: Creating Custom Columns\u003cbr\u003eUsing Split by Delimiter\u003cbr\u003eUsing the Add Custom Columns Command\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 10: Append Queries\u003cbr\u003eImporting the Data\u003cbr\u003eRemoving the differences between columns\u003cbr\u003eUsing Append Queries as New\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 11: Merge Queries\u003cbr\u003eUsing Merge Queries as New\u003cbr\u003eSpecifying the Join Kind\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 12: Grouping Data\u003cbr\u003eBenefits of Grouping Data\u003cbr\u003eAdding Groupings\u003cbr\u003eAdding Aggregations\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 13: Power Query Parameters and Templates\u003cbr\u003eBenefits of parameters and templates\u003cbr\u003eOverview of Our Example\u003cbr\u003eCreating Dynamic Titles\u003cbr\u003eCreating parameters\u003cbr\u003eName and Description\u003cbr\u003eOptional or Required\u003cbr\u003eParameter Type\u003cbr\u003eSuggested Values\u003cbr\u003eDefault Value vs Current Value\u003cbr\u003eCreating Parameters on the Fly\u003cbr\u003eUpdating a Data Source via a Parameter\u003cbr\u003eParameterizing Filter Operations\u003cbr\u003eCreating a Template\u003cbr\u003eUsing a Template\u003cbr\u003eConclusion\u003c\/p\u003e\u003cp\u003eChapter 14. Power Query Custom Functions\u003cbr\u003eConverting a Query to a Function\u003cbr\u003eConnecting to our Example file\u003cbr\u003eCreating a parameter\u003cbr\u003eInvoking a Function\u003cbr\u003eUsing the Invoke Custom Function Command\u003cbr\u003eUnderstanding Function Syntax\u003cbr\u003eCreating a Date of Birth function\u003cbr\u003eConclusion\u003c\/p\u003e\u003cbr\u003e","brand":"Independently Published","offers":[{"title":"Default Title","offer_id":50922239262994,"sku":"9781791315177","price":10.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0831\/4771\/8930\/files\/img_fd16db9a-61b5-4847-80df-98026dc91008.jpg?v=1738926240","url":"https:\/\/surprise-castle.myshopify.com\/products\/power-bi-step-by-step-part-3-power-query-parameters-templates-custom-functions-power-bi-mastery-through-hands-on-tutorials-9781791315177","provider":"Surprise Castle","version":"1.0","type":"link"}