Resources

Explore a carefully curated collection of resources tailored to boost your data analysis skills.

From useful guides and templates to essential tools, these resources are designed to streamline your data projects and empower both beginners and seasoned professionals alike.

Web Resources

Issue #205 of Power BI Weekly, published on May 2, 2023, highlights the integration of Power BI reports within Jupyter Notebooks, bridging data science and BI development, and features articles on DAX security, dynamic formatting, and data modeling techniques.
The Devon and Cornwall Power BI User Group is a vibrant community I lead, offering regular online and in-person events that explore topics like DAX, Power Query, Microsoft Fabric, and data visualisation, with session recordings and resources available on their Meetup page, YouTube channel, and GitHub repository.
My Sessionize profile showcases a range of sessions I have delivered, including topics such as web scraping with Beautiful Soup, automating direct debit mandates with Python in Microsoft Fabric, and time-series forecasting using Prophet.
The Unpivot YouTube channel offers engaging discussions and tutorials on Excel and Power BI, focusing on data transformation techniques like unpivoting, pivoting, and transposing to enhance data analysis skills.
The Devon and Cornwall User Group YouTube channel features insightful sessions and tutorials on data analytics, Power BI, and related technologies, fostering a community of data enthusiasts in the Southwest UK.
The Unpivot YouTube channel offers engaging discussions and tutorials on Excel and Power BI, focusing on data transformation techniques like unpivoting, pivoting, and transposing to enhance data analysis skills.
This Microsoft Reactor session, I explore efficient data ingestion and pipeline orchestration in Microsoft Fabric using Dataflows Gen2 and notebooks, offering practical strategies for scalable data engineering workflows.
My Substack newsletter offers practical insights and tutorials on Power BI, Python, and Microsoft Fabric, aimed at helping data professionals enhance their analytical skills and stay updated with the latest developments in data analytics.
At SQLBits 2025, I present a session titled “Web Scraping Made Simple: Unlocking Data with Beautiful Soup,” where I demonstrate how to efficiently extract and utilise web data using Python’s Beautiful Soup library, integrating it seamlessly into Microsoft Fabric for enhanced reporting and visualisation.
The Data Céilí 2025 conference, held at Trinity College Dublin, is Ireland’s premier community-led Microsoft Data Platform event, featuring a full-day training session on June 12 and 24 one-hour sessions on June 13, covering topics like Power BI, Microsoft Fabric, Azure, SQL Server, and data engineering.
GitHub is a collaborative platform where I store, manage, and share code using version control, allowing individuals and teams to contribute to projects, track changes over time, and build software more efficiently across open-source and private repositories.

Another SQLBits 2025 post, where I will lead a full-day training session titled “Python – The Essential Swiss Army Knife for Your Data,” designed to equip attendees with practical Python skills for real-world data scenarios, focusing on core functions, libraries, and best practices to enhance data analysis and transformation capabilities.

In this Report Builder tutorial, you’ll learn how to add a table in a paginated report. Other Microsoft products, such as Excel and Word, require you to input data in each cell in a table.

In this tutorial, you’ll learn how to format data in your paginated reports in Report Builder. Report Builder is a Microsoft product that allows you to create paginated reports. A paginated report allows you to create a printable report from a Power BI data set.

After getting the data into the Report Builder, the next step is transforming these into a report. In this tutorial, you’ll learn how to create a paginated report. Specifically, you’ll learn how to add texts and images and then export your report into various document formats.

In this tutorial, you’ll learn about the different objects you can place in your paginated report and how to format them using Report Builder in Power BI. A paginated report is a report that’s designed to be printed or shared. And as the name suggests, they’re called “paginated” because they’re made to fit well on a page.

Video Resources

Here I explain that the aim of my presentation is to share an example of how using Excel helps for data validation and now how as Excel users we would be able to consume data held within Power BI and collaborate with a BI team with your Excel expertise.

In this video, I join Brian to officially rollout this new course and talk about what you can expect out of it, how to make the most out of it, and the direction we’re going for this three-part course.

On Connect Live I stream live with The Power BI Guy.

Understanding key data structure concepts is critical for any modeller who wants to efficiently perform data analysis in Power BI. Watch to hear as I cover a range of key concepts.