Business - Peter Nicholson

24 Mar 2024 · 4 min read

Implementing a DW for non-tech people

Discover the essentials of building a data warehouse: aligning IT with business needs, choosing technology, and ensuring compliance. Learn key steps for success and how to bring the company along in the journey.

18 Nov 2023 · 4 min read

Keeping the Engine Running: Best Practices for Data Warehouse Maintenance

In every forward-thinking business is a data warehouse, a crucial repository for the vast amounts of data that organisations accumulate. However, much like any piece of infrastructure, a data warehouse requires regular maintenance to function optimally.

12 Nov 2023 · 4 min read

Navigating the World of Generative AI in Business: A Primer for IT Professionals

In a world where technological advancement is not just an asset but a necessity, the advent of generative AI stands as a beacon of transformative power in the business landscape.

Business

5 Nov 2023 · 2 min read

Medallion Architecture: Unmasking the Illusion of Perfection

In the digital world where data is often the lifeblood of decision-making, Medallion Architecture has emerged as a kind of 'knight in shining armour', ready to rescue organisations from the clutches of data disarray. But, not all that glitters is gold.

4 Mar 2023 · 2 min read

Mastering Window Functions: How to Calculate a Moving Average in SQL

Learn how to analyse sales trends with a moving average calculation in SQL. This powerful tool can help you identify growth opportunities and improve business performance.

20 Jan 2023 · 3 min read

Best Practices for Managing Remote Teams

In this article, we'll be exploring best practices for managing remote teams, including tips for maintaining clear communication, and building strong relationships with remote employees. Hopefully you can get something useful out of this article.

4 Jan 2023 · 2 min read

Report or Dashboard?

As a data analyst, you know the value of presenting your findings in a clear and effective way. But when it comes to choosing between a report and a dashboard, which one is the right fit for your needs?

30 Dec 2022 · 2 min read

Leaders Eat Last - Simon Sinek

Simon Sinek's book "Leaders Eat Last" explores the idea that great leaders put the needs of their team ahead of their own, and create a culture of trust and cooperation within their organisation.

24 Dec 2022 · 2 min read

How To Build An IT Department When You Don't Have One

Building an IT department from scratch can be a daunting task, but with careful planning and execution, it is possible to create a successful and effective team.

21 Dec 2022 · 2 min read

The advantages of implementing a Data Warehouse

A data warehouse is a critical tool for any business that wants to make data-driven decisions. Read about why a data warehouse should be in your business.

14 Dec 2022 · 2 min read

What is the "Infinite Game"?

The concept of the infinite game was first introduced by Simon Sinek in his book "The Infinite Game." In this book, Sinek discusses the differences between finite and infinite games and how they apply to business and leadership.

14 Dec 2022 · 2 min read

The importance of professional development and training programs

Investing in professional development and training programs for employees can be a smart business move. These programs can increase employee engagement and satisfaction, close skills gaps within an organization, and improve efficiency and productivity.

12 Dec 2022 · 4 min read

How Tasks Are Needed To Run A Data Warehouse?

The day-to-day tasks involved in managing a data warehouse can vary depending on the specific needs and requirements of the organisation.

11 Dec 2022 · 4 min read

How To Implement A Data Warehouse

If you're a business owner or IT professional looking to implement a data warehouse from scratch, you're probably wondering where to begin. In this post, we'll outline the key steps you'll need to take in order to successfully implement a data warehouse from scratch.

8 Dec 2022 · 3 min read

Using Power BI for your business

Using Power BI for a small business can help the company gain a better understanding of its data, customers, and market, and make more informed decisions.

8 Dec 2022 · 2 min read

What role does candor play in leadership?

Candor, or the quality of being open and honest, is an important trait for any leader to possess. Here are five reasons why candor is important in leadership.

7 Dec 2022 · 2 min read

Excel vs. Power BI - which one you should use

Both are powerful tools for analysing and presenting data. However, they have different strengths and capabilities, and choosing the right tool for your needs can be a challenging decision. Let's compare Excel and Power BI to help you decide which one is right for you.

3 Dec 2022 · 2 min read

Better Communication - The GPS Method

In his book "The First Minute", James Fenning has created what he calls the "GPS" method which is an easy to remember structure for creating a clear summary of a problem or idea.