Financial Modeling and Reporting with Microsoft Power BI: Build models, KPIs, and modern finance reports...

— —

Andy Clark Tom Gough

Financial Modeling and Reporting with Microsoft Power BI

Name: Financial Modeling and Reporting with Microsoft Power BI
Price: 90.51 AUD
Availability: OutOfStock
ISBN: 9781835880265

Build models, KPIs, and modern finance reports in Power BI from scratch

Andy Clark, Tom Gough, Shailan Chudasama , Marissa Thomas

$112.95 $90.51

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We will update you on expected arrival time to us. If this delay is too long, please let us know within 2 business days and we can give you options regarding cancelling or adjusting your order. More details on cancelling your order can be found in our Terms of Trade.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Packt Publishing Limited
15 May 2026

Finance; Operational research; Enterprise software; Database design & theory; Information architecture

Design powerful financial reports in Power BI by building models, measures, and dashboards tailored for real-world accounting and analytics

Key Features

Build a complete financial data model from ledgers, journals, and budgets Master DAX for income statements, KPIs, and performance analysis Learn Power BI Paginated and AI tools for printable and predictive reporting Purchase of the print or Kindle book includes a free PDF eBook

Book DescriptionFinancial Modeling and Reporting with Microsoft Power BI is the definitive guide to designing high-performance, flexible, and insightful financial reports using Power BI. This Power BI book empowers finance and BI professionals to create everything from trial balances to enterprise-wide performance dashboards with ease and precision. The book starts by helping you define your reporting goals and data sources, mapping these needs to Power BI’s capabilities. You’ll then build a core financial data model—covering ledger transactions, charts of accounts, and multi-company support. As you proceed, you’ll integrate complex DAX measures, handle foreign exchange and journal entries, and extend your model with budgeting and inventory data. Each chapter builds toward a comprehensive suite of reports, complete with visual best practices and tested metrics. You’ll learn to streamline datasets using Power Query, test for data integrity, and generate printable reports via Power BI Paginated. The final chapters dive into using AI, predictive analytics, and Microsoft Fabric to future-proof your reporting. Whether you're consolidating data across systems or evolving your reports for changing business needs, this hands-on guide ensures you’re prepared to meet the demands of modern finance.

What you will learn

Build core financial models from ledgers and accounts Create Trial Balance and Income Statements using DAX Optimize Power BI with Power Query and data transformation Add budgets, targets, and KPIs to performance dashboards Integrate inventory data for nuanced stock reporting Produce printable reports using Power BI Paginated Apply AI for report generation and predictive analytics Test, tune, and evolve reports for secure, scalable use

Who this book is forThis book is for finance professionals, accountants, financial analysts, and BI developers who want to leverage Power BI to improve, automate, and future-proof their financial reporting. Whether consolidating data from ERPs, building reports across entities, or exploring advanced Power BI features, this book equips readers with practical skills and strategic insight.

By: Andy Clark, Tom Gough, Shailan Chudasama
Foreword by: Marissa Thomas
Imprint: Packt Publishing Limited
Country of Publication: United Kingdom
Dimensions: Height: 235mm, Width: 191mm,
ISBN: 9781835880265
ISBN 10: 1835880266
Pages: 350
Publication Date: 15 May 2026
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

Table of Contents Identifying Your Reporting Needs and Data Sources The Basic Model for Financial Reporting Creating a Trial Balance and Income Statement Common DAX Measures Handling Manual Journal Entries Streamlining with Power Query Incorporating Budgets and Targets Managing Inventory Data Creating a Suite of Financial Reports Testing and Fine-Tuning Your Data Printable Financial Statements with Power BI Paginated Financial Reporting in an AI-Driven World Evolving and Maintaining Your Reports

Andy Clark is a Power BI and Data Analytics consultant with a career focused on ERP, CRM, and Business intelligence. He is the CEO of Clearly Solutions LLC, based in Houston, TX, which is a specialist consultancy with a focus on digital transformation using the Microsoft Power Platform. Andy also runs the Greater Houston Power BI User Group and regularly delivers Microsoft Fabric and Power BI training to the Houston data community. Tom Gough is a data management and analytics professional with over 25 years of industry experience, working on BI solutions across a range of industries, specializing in Power BI in all areas of business, especially in finance. Tom is based in the UK and is the Technical Director at Clearly Cloudy Ltd. In 2015, he delivered one of the first publicly available Power BI courses in the UK, and in 2018, established the first Power BI user group in Birmingham, UK. Shailan Chudasama is a business professional specialist with over 25 years of experience in business intelligence and data analytics. He has successfully delivered national and global multi-faceted projects with Microsoft, including Microsoft BI and Microsoft Dynamics. He has a background in Finance and Accounting and is a principal who has architected large-scale data and analytics solutions with the latest Microsoft offerings. A pragmatic business leader who helped establish Clearly Cloudy Limited in 2015. Shailan is based in the South East, UK. In his spare time, if he has any, he is a qualified firefighter.