Sign-In
Cart
Power BI Step-by-Step Part 3: Power Query, Parameters, Templates & Custom Functions: Power BI Mastery through hands-on Tutorials
Paperback
Series: Power Bi Step-By-Step, Book 3
Currently unavailable to order
Please enter your email and a message will be sent to you when this product becomes available on our website.
ISBN13: 9781791315177
Publisher: Independently Published
Published: Dec 9 2018
Pages: 94
Weight: 0.53
Height: 0.19 Width: 8.50 Depth: 11.00
Language: English
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
Also in
Business General
Crucial Conversations Tools for Talking When Stakes Are High, Second Edition
Switzler, Al
Grenny, Joseph
Patterson, Kerry
Paperback
The Pig and I: The Tale of Our Relationship with a Beast We Eat
Endresen, Kristoffer Hattleland
Hardcover
Inspired: Understanding Creativity: A Journey Through Art, Science, and the Soul
Richtel, Matt
Hardcover
Quiet Girls Can Run the World: Owning Your Power When You're Not the Alpha in the Room
Holman, Rebecca
Paperback
Climb: Taking Every Step with Conviction, Courage, and Calculated Risk to Achieve a Thriving Career and a Successful Life
Gadsden-Williams, Michelle
Brown, Carolyn M.
Paperback
The Token: Common Sense Ideas for Increasing Diversity in Your Organization
Farmer, Crystal Byrd
Paperback
Paris Chic & Trendy: Designers' Studios, Hip Boutiques, Vintage Shops
Ribes-Tiphaine, Adrienne
Paperback
The Let Them Theory: A Life-Changing Tool That Millions of People Can't Stop Talking about
Robbins, Mel
Robbins, Sawyer
Hardcover
The Reverse Centaur's Guide to Life After AI: How to Think about Artificial Intelligence--Before It's Too Late
Doctorow, Cory
Paperback
The Risk Worth Taking: A Story of Breaking Free and Trading for a Life You Love
Ijeoma, Teri
Hardcover
Unreasonable Hospitality: The Remarkable Power of Giving People More Than They Expect
Guidara, Will
Hardcover
Hbr's 10 Must Reads on Managing Yourself, Updated and Expanded (Featuring How Will You Measure Your Life? by Clayton M. Christensen)
Review, Harvard Business
Drucker, Peter F.
Gallo, Amy
Paperback
The Retire Sooner Method: The 5 Secrets Behind America's Happiest (and Unhappiest) Retirees
Moss, Wes
Hardcover
Hbr's 10 Must Reads on Mental Toughness, Updated and Expanded (Featuring How to Stop Worrying about What Other People Think of You by Michael Gervais)
Review, Harvard Business
Gervais, Michael
Duckworth, Angela L.
Paperback
1873: The Rothschilds, the First Great Depression, and the Making of the Modern World
Ahamed, Liaquat
Hardcover
The Goal: 40th Anniversary Edition: A Process of Ongoing Improvement
Cox, Jeff
Goldratt, Eliyahu M.
Paperback
How to Be a Rich Old Lady: Your Guide to Easy Investing, Building Wealth, and Creating the Wild, Beautiful Life You Want
Holden, Amanda
Hardcover
Take Breaks, Work Better: Measure Impact, Not Hours, and Transform Your Profitability
Briggs, John
Paperback
Surrender to Lead: The Counterintuitive Approach to Driving Extraordinary Results
Terry, Joe
Kriegel, Jessica
Hardcover
Money Unlocked: How to Make It, Keep It and Multiply It: The New York Times Bestseller
Lee, John
Paperback
Crucial Conversations: Tools for Talking When Stakes Are High
Patterson, Kerry
Grenny, Joseph
McMillan, Ron
Paperback
The Freedom-Based Business Method: Reset, Systemize, and Realign Your Business to Live a Life of Harmony
Ellis, Natalie
Hardcover
The Courage to Commit: Embrace the Radical Power of Sticking with Something
Johnson, Shawn
East, Andrew
Hardcover
Hbr's 10 Must Reads on Leadership, Updated and Expanded (Featuring Begin with Trust by Frances X. Frei and Anne Morriss)
Review, Harvard Business
Edmondson, Amy C.
Ibarra, Herminia
Paperback
Who Moved My Cheese?: An A-Mazing Way to Deal with Change in Your Work and in Your Life
Johnson, Spencer
Hardcover
How We Could: The Framework to Lead Without Drama, Build Alignment, and Call Teams to Greatness
Dorr, Alex
Hardcover
The Infinity Machine: Demis Hassabis, Deepmind, and the Quest for Superintelligence
Mallaby, Sebastian
Hardcover
The Daily Stoic: 366 Meditations on Wisdom, Perseverance, and the Art of Living
Holiday, Ryan
Hanselman, Stephen
Hardcover
Dummies Guide to Starting Your Own Business: Essential Steps to Launching and Scaling a Successful Small Business Venture
Press, Essywrites
Paperback
7-Figure Educator: Turn Your Experience as an Educator Into Income, Impact, and Freedom
Jordan-Thomas, Erica
Paperback
The Millionaire Next Door: The Surprising Secrets of America's Wealthy
Danko, William D., PH. D.
Stanley, Thomas J., PH. D.
Paperback
What the Heck Is Eos?: A Complete Guide for Employees in Companies Running on EOS
Wickman, Gino
Bouwer, Tom
Hardcover
The Overthinker's Guide to Making Decisions: How to Make Decisions Without Losing Your Mind
Nguyen, Joseph
Hardcover
The Coaching Habit: Say Less, Ask More, and Change the Way You Lead Forever
Stanier, Michael Bungay
Paperback
Confidence (HBR Emotional Intelligence Series)
Review, Harvard Business
Kanter, Rosabeth Moss
Chamorro-Premuzic, Tomas
Paperback
Get Scalable: The Operating System Your Business Needs To Run and Scale Without You
Deiss, Ryan
Paperback
Stop Asking for Referrals: Build a Magnetic Business Through Intentional Care & Real Relationships
McNally, Flor de Maria
Paperback
The Mom Test: How to talk to customers & learn if your business is a good idea when everyone is lying to you
Fitzpatrick, Rob
Paperback
I Will Teach You to Be Rich: No Guilt. No Excuses. Just a 6-Week Program That Works (Second Edition)
Sethi, Ramit
Paperback
Never Split the Difference: Negotiating as If Your Life Depended on It
Voss, Chris
Raz, Tahl
Hardcover
Hábitos Atómicos: Cambios Pequeños, Resultados Extraordinarios / Atomic Habits
Clear, James
Paperback
A Guide to the Project Management Body of Knowledge (Pmbok(r) Guide) -- Eighth Edition and the Standard for Project Management
Project Management Institute
Paperback
Building Great Businesses: Create Momentum, Overcome Setbacks, and Scale with Confidence
Becker, Scott
Hardcover
Influence and Persuasion (HBR Emotional Intelligence Series)
Review, Harvard Business
Morgan, Nick
Cialdini, Robert B.
Paperback
Twenty Minutes Is the New Hour: The Ambitious Woman's Guide to Doing Less and Achieving More
Hauser, Fran
Hardcover
A Little More Social: How Small Choices Create Unexpected Happiness, Health, and Connection
Epley, Nicholas
Hardcover
Mindful Listening (HBR Emotional Intelligence Series)
Hougaard, Rasmus
Zenger, Jack
Review, Harvard Business
Paperback
Take It Personal: How to Succeed by Building Relationships and Playing the Long Game
Grutman, David
Hardcover
Expecting Better: Why the Conventional Pregnancy Wisdom Is Wrong--and What You Really Need to Know
Oster, Emily
Paperback
Getting to Yes: Negotiating Agreement Without Giving in
Fisher, Roger
Ury, William
Patton, Bruce
Paperback
Atlas of the Heart: Mapping Meaningful Connection and the Language of Human Experience
Brown, Brené
Hardcover
Crucial Accountability: Proven Skills to Build Trust, Address Disappointment, and Get Results, Third Edition
Patterson, Kerry
Grenny, Joseph
Hale, Justin
Hardcover
Power and Impact (HBR Emotional Intelligence Series)
Review, Harvard Business
Cable, Dan
Bregman, Peter
Paperback
The Everywhere Millionaire: Who Is Really Rich in America and How They Got There
Zidar, Owen
Zwick, Eric
Hardcover
The Way of Excellence: A Guide to True Greatness and Deep Satisfaction in a Chaotic World
Stulberg, Brad
Hardcover
Happiness (HBR Emotional Intelligence Series)
McKee, Annie
Gilbert, Daniel
Review, Harvard Business
Paperback
Feedback That Works: How to Build and Deliver Your Message, Second Edition
Center for Creative Leadership
Paperback
Here Comes the Sun: A Last Chance for the Climate and a Fresh Chance for Civilization
McKibben, Bill
Hardcover
Mindfulness (HBR Emotional Intelligence Series)
Langer, Ellen
Goleman, Daniel
Review, Harvard Business
Paperback
Hbr's 10 Must Reads on Strategy, Updated and Expanded (Featuring the Five Competitive Forces That Shape Strategy by Michael E. Porter)
Review, Harvard Business
Porter, Michael E.
Kim, W. Chan
Paperback
Hbr's 10 Must Reads on High Performance, Updated and Expanded (Featuring Nine Things Successful People Do Differently by Heidi Grant)
Review, Harvard Business
Grant, Heidi
Goleman, Daniel
Paperback
7 Rules of Power: Surprising--But True--Advice on How to Get Things Done and Advance Your Career
Pfeffer, Jeffrey
Paperback
The Wisdom and Wealth Solution: Unlocking the Secrets of Happiness, Purpose, and Financial Security with Living360
Ansari, Feroz
Hardcover
The Algorithm: The Hypergrowth Formula That Transformed Tesla, Lululemon, General Motors, and Spacex
McNeill, Jon
Hardcover
Hbr's 10 Must Reads on Managing People, Updated and Expanded (Featuring Are You a Good Boss--Or a Great One? by Linda A. Hill and Kent Lineback)
Review, Harvard Business
Goleman, Daniel
Hill, Linda A.
Paperback
The Phoenix Project: A Novel about It, Devops, and Helping Your Business Win
Behr, Kevin
Spafford, George
Kim, Gene
Paperback
Bonfire of the Murdochs: How the Epic Fight to Control the Last Great Media Dynasty Broke a Family -- And the World
Sherman, Gabriel
Hardcover
Beyond Belief: The Science-Backed Way to Stop Limiting Yourself and Achieve Breakthrough Results
Eyal, Nir
Hardcover