1
of
1
The Transformative Magic of M Code in Power Query Excel & Power BI
A BEGINNER'S GUIDE TO MASTERING THE ART OF DATA METAMORPHOSIS TO GET JUST THE DATA STRUCTURE NEEDED TO CREATE INSIGHTFUL DATA ANALYSIS SOLUTION
Brief Description
This book is about Power Query and M Code. Power Query and the functional language M Code (M) are the heart and soul of Microsoft’s power data analysis tools: Excel, Power BI Desktop, and Dataflows. The beautiful data-driven and insightful PivotTables, Power BI solutions, and Dashboards...
Read More
Format: Paperback / softback
$8100
Unit price
/
Unavailable
International Supplier
This title is in-stock with overseas suppliers. While it is not available locally, we fly books in weekly from the US and UK to our Auckland warehouse for immediate dispatch.
AVAILABLE WITH SUPPLIER
Ships from our Auckland warehouse within 2-3 weeks
Found a better price? Request a price match
The Transformative Magic of M Code in Power Query Excel & Power BI
$8100
Unit price
/
Unavailable
Latest News
Win a Father’s Day Gift Box with Penguin!
Buy any Penguin Father's Day pick and you're in the draw to win a this...
5 Kiwi Children's Authors to Check Out
Lizzy is sharing 5 Kiwi authors who write amazing children's books - everything from picture...
The Books That Made Us Readers
The book hero team are sharing the books that made them readers!
The Making of an Accounts Hero
From childhood loans and dishwasher money to tax returns, Excel and Book Hero’s accounts, Marnie...
Play to Screen Report 13/08/26
From major casting rumours and long-awaited adaptations to new family favourites heading to the big...
See more
Book Hero Magic formatted this description to make it easier to read. While it's new and
still learning, it may not be perfect - your
feedback is welcome!
Description
This book is about Power Query and M Code.
Power Query and the functional language M Code (M) are the heart and soul of Microsoft’s power data analysis tools: Excel, Power BI Desktop, and Dataflows. The beautiful data-driven and insightful PivotTables, Power BI solutions, and Dashboards that you create usually require that you use Power Query and M Code to get, transform and load the data before you create the final reports and visuals.
For many data analysis jobs, using the SQL language to perform ETL (extract, transform, and load) is the preferred tool. Maybe even R or Python. But if you use Power BI or Excel, you better also be masterful with M Code and Power Query. Together, they give you the power to connect to multiple data sources, structuring your data with ease, and load to the worksheet, the data model in Excel or Power BI or Dataflow's Data Hub.
As an accountant, professor, data analyst, author, Excel MVP and YouTuber for about 20 years, my specialty is in telling stories with videos and books to make complicated things less complicated and to inspire you to have fun with the power you can gain over data.
Book Details
INFORMATION
ISBN: 9781615470839
Publisher: Holy Macro! Books
Format: Paperback / softback
Date Published: 01 October 2024
Country: United States
Imprint: Holy Macro! Books
Illustration: Illustrations
Audience: General / adult
DIMENSIONS
Width: 209.0mm
Height: 266.0mm
Weight: 250g
Pages: 128
About the Author
Mike "excelisfun channel" Girvin is a business instructor at Highline Community College since 2002 and a Microsoft Excel MVP since 2013. He has created over 3,200 Excel videos at YouTube. He lives in Seattle, Washington.
More from Computing & Technology
View all-
Digital Minimalism
Digital Minimalism by Cal Newport presents a revolutionary strategy for optimising your interaction with digital technology in a way that fosters productivity, focus, happiness, and creativity. Most of us recognise that our reliance on texting, Instagram, Facebook, and Twitter is not due to sheer lack of intelligence or depth, but because these platforms truly offer significant value in the form...Paperback$2400Elsewhere:$2600Unit price /UnavailableIn StockShips tomorrow -
Empire of AI
An eye-opening account of the tech arms race shaping our planet, from an award-winning journalist and AI insider to the world of Sam Altman and OpenAI. When longtime AI expert and journalist Karen Hao first began covering OpenAI in 2019, she thought they were the good guys. Founded as a nonprofit with safety enshrined as its core mission, it was...Paperback$2899Elsewhere:$3700Unit price /UnavailableIn StockShips tomorrow -
17% offOpen to Work
‘Open To Work helps you stop fearing the future and start shaping it with purpose.’ Jay Shetty‘An instantly useful guide to futureproofing your career.’ Adam Grant‘Open to Work lays out a smart and clear path to the future of work’ Brené Brown In a world where AI is transforming work at a rapid pace, Open to Work is your essential...Paperback$2500Elsewhere:$3799Unit price /UnavailableIn StockShips tomorrow -
Careless People
Shocking and darkly funny, Careless People gives you a front-row seat to the decisions that are shaping our world and the people who make them. Welcome to Facebook. Sarah Wynn-Williams, a young diplomat from New Zealand, pitched for her dream job. She saw Facebook's potential and knew it could change the world for the better. But, when she got there...Paperback$2800Unit price /UnavailableIn StockShips tomorrow -
If Anyone Builds It, Everyone Dies
The founder of the field of AI risk explains why superintelligent AI is a global suicide bomb and we must halt development immediately. AI is the greatest threat to our existence that we have ever faced. The technology may be complex but the facts are simple. We are currently on a path to build superintelligent AI. When we do, it...Paperback$3200Elsewhere:$4000Unit price /UnavailableIn StockShips tomorrow -
20% offApple
On April 1, 1976, two scruffy twentysomethings, both named Steve, founded a startup. Their goal: To bring the revolutionary power of computers to everyone. Over the next five decades, Apple reshaped the technology and cultural landscapes, introducing the public to breakthroughs like the mouse, laser printing, CD-ROM, WiFi, digital video, home networking, touchscreen phones, and tablets. Jobs’s obsessive eye for...Hardback$6400Elsewhere:$9000Unit price /UnavailableIn StockShips tomorrow -
New ReleaseThe Reverse Centaur's Guide to Life After AI
Whether you want to criticise, kill, or use AI, you have to get through the hype and uncover the real story. Start with labour: in automation theory, a centaur is a person who chooses to use technology to help them do the things that matter to them. A reverse centaur is a person who has been conscripted to serve as...Paperback$3499Unit price /UnavailableIn StockShips tomorrow -
New Releasekluge
If you and I are in the same ='entertainment venue' for this ='stand-up comedy special' and I am ='my body' and you are ='my audience' I run to you and shout your name into the dark, in the hope you are there. Yes, you='dear reader'='attentive listener'. This is a story about the end days of a tech company and its...Paperback$3299Elsewhere:$3800Unit price /UnavailableIn StockShips tomorrow -
17% offThe Bullet Journal Method
The Bullet Journal Method by Ryder Carroll is an indispensable guide to gaining control over your chaotic life using the power of a simple pen and notebook. Whether you're a seasoned planner or a beginner, this book lays out a revolutionary system that provides structure, clarity, and purpose to your everyday activities. It's not just a method of organising your...Paperback$2000Elsewhere:$2799Unit price /UnavailableIn StockShips tomorrow -
How to Win At Chess
Learn chess from International Master and YouTube's top chess teacher Levy Rozman (aka GothamChess) in this refreshing and fun guide for beginner and intermediate players. How to Win at Chess teaches you everything you need to know about the game, including all the important moves and strategies to start off strong and keep you thinking several steps ahead. Full of...Hardback$4000Elsewhere:$5000Unit price /UnavailableIn StockShips tomorrow -
Co-Intelligence
From Wharton professor and author of the One Useful Thing Substack, comes an urgent and definitive playbook for working, learning and living in the new age of AI. For fans of Kevin Kelly, Ray Kurzweil, Cal Newport, and Martin Ford. A New York Times Bestseller Co-Intelligence is the very best book I know about the ins, outs, and ethics of...Paperback$3400Elsewhere:$4000Unit price /UnavailableIn StockShips tomorrow -
New ReleaseTech Bros
The extraordinary story of Atlassian - how two university friends with a billion-dollar idea created a global tech company. In a cramped share house in inner-city Sydney, university classmates Mike Cannon-Brookes and Scott Farquhar started working together to create a $160 billion company from scratch and revolutionise the way the world works. They couldn't have been more different - Cannon-Brookes...Paperback$3199Elsewhere:$3999Unit price /UnavailableIn StockShips tomorrow
Why buy from us?
Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!
Service & Delivery
Our warehouse in Auckland holds over 100,000 books, toys, board games and puzzles in-stock so you're not waiting for your order to arrive from overseas.
Auckland Bookstore
We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.
Our Gifting Service
Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.
