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
$4499
Unit price
/
Unavailable
AVAILABLE WITH SUPPLIER
Ships from our Auckland warehouse within 4-6 weeks
Found a better price? Request a price match
The Transformative Magic of M Code in Power Query Excel & Power BI
$4499
Unit price
/
Unavailable
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 today -
New ReleaseEmpire 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 today -
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 today -
Open 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$2999Elsewhere:$3799Unit price /UnavailableIn StockShips today -
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 today -
The Amazing Generation
A children's version of the global bestseller The Anxious Generation How can we live a happy and exciting life without a smartphone? The Anxious Generation started a world-changing conversation about the effects of smartphones and social media on young people. Now bestselling authors Jonathan Haidt and Catherine Price have teamed up to talk directly to those young people about how...Paperback$2500Elsewhere:$3000Unit price /UnavailableIn StockShips today -
The Infinity Machine
A revelatory portrait of the visionary behind Google DeepMind, the race to control the future - and what it means to win. Even in a tech world crowded with visionary leaders, Demis Hassabis is recognised as a special case. Born to working-class, immigrant parents in North London, a chess prodigy by five and wizard coder in his teens, he turned...Paperback$3499Elsewhere:$4500Unit price /UnavailableIn StockShips today -
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 today -
The 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$2400Elsewhere:$2799Unit price /UnavailableIn StockShips today -
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$3200Elsewhere:$3999Unit price /UnavailableIn StockShips today -
Little Book of Data
Data is not about number crunching. It’s about ideas. And when used properly (read: ethically), it is the problem solver of our time. Yet many savvy people seem to be in data denial: they don’t think they need to understand data, or it’s too complicated, or worse, using it is somehow unethical. As data and AI (just an accelerated way...Paperback$3400Elsewhere:$3799Unit price /UnavailableIn StockShips today -
Don’t Burn Anyone at the Stake Today
An electrifying, thought-provoking exploration of how the digital era is reshaping our world, by bestselling, Women's Prize-winning writer Naomi Alderman. What's the most useful thing you could know about your own life? In this era-defining book, developed from her groundbreaking Radio 4 essay series, Naomi Alderman turns her boundless curiosity and incisive thinking to a question that affects us all—how...Hardback$3500Elsewhere:$4500Unit price /UnavailableIn StockShips today
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.
