by Mandy Doward - 10/12/2024

Data training & consultancy news

Your data is our business! Keep up to date with the latest developments, news and offers from our thriving family run consultancy. Build your data strategy and develop your analytics expertise.

Take a look at our December newsletter here.


by - 9/12/2024

Cost Effective Microsoft Fabric Licensing Options

Microsoft Fabric pricing can be a challenging topic, especially for small businesses. The annual costs can be significant, making it difficult for many to justify the expense. However, investing in Fabric can be a smart move to future-proof your business, as it’s clear that this platform is here to stay. The advantages of a unified platform for Data Engineering, Data Science, and Data Analytics are evident.

So, how can small businesses access Fabric’s services without breaking the bank?


by Mandy Doward - 9/12/2024

How do you decide if you should migrate to Microsoft Fabric?

Microsoft Fabric is 1 year old and there is a lot of hype around it. Datalake, Data Warehouse, Data Analytics, BI, AI all integrated into one place - sounds like the perfect dream. But is it is it the right move for you?

A question that is impossible to answer wiothout some consultation, investgation and discussion.


by Mandy Doward - 25/11/2024

November 2024 Microsoft Fabric Preview Highlights

Microsoft Fabric is continually evolving and transitioning from  a data analytics platform to a fully integrated data platform.

At the time of writing - November 24th 2024 - there are 55 features in preview!

I have highlighted 3 preview features that everyone should know about:

  • Azure Data Factory item - Connect to an existing Azure Data Factory from a Fabric workspace.
  • Fabric SQL database  - transactional database in Fabric based on Azure SQL Database
  • varchar(max) and varbinary(max) support - support for these data types in Fabric Warehouse


by Mandy Doward - 2/12/2024

Happy 35th Birthday PTR!

Here at PTR HQ we recently came together from all four corners of the country to celebrate the company's 35th birthday. It was a joy to hear all the chit chat going on and see smiles on everyone's faces and a real treat to have face to face conversation rather than a Teams call.

Our journey started with data in 1989 and our passion for all things data just grew and grew, you could say data is in our blood!  Which is of course quite literally the case, since we are a family business led by myself and my brother, Ian Roberts, and started by my father, Peter Roberts, with the aim of helping companies transport, access and make sense of the growing amount of data that was emerging.

 
 


by Mandy Doward - 6/6/2024

Your Data Platform Review

If you want to get more value from your data but don't know where to start, you're not alone. According to Lenovo, 85% of organisations are not fully leveraging their data even though 80% of their leaders say data is critical to the decisions they want to make.

If you are stuck, like so many others in your situation then it’s time to take the first steps and what better way to begin than with a helping hand? Our targeted data platform review gives you an overview of what you have and a roadmap to help you reach your goals – which puts you way ahead of the crowd.
 


by Ian Roberts - 9/5/2024

5 Reasons Why Microsoft Fabric is a Game-Changer for Analytics

Did we tell you? There’s a new data platform in town and it’s called Microsoft Fabric! In this product Microsoft have brought together all the best capabilities of Azure Synapse, Azure Data Factory, and Power BI into a single, unified, cloud-based experience – empowering businesses to efficiently manage, analyze, and derive valuable insights from their data. They tell us it’s going to be a game-changer!


by - 16/4/2024

Power BI Report Design Ideas

Do you wonder how to get ideas for your report design – want to get great looking reports every time? Here are some tricks to make your life easier so you can build stylish and professional reports in Microsoft Power BI to impress your colleagues and stakeholders. So let’s get started with our Microsoft Power BI report design ideas and tips.


by - 16/4/2024

Using the Forecasting Feature in Power BI

The forecasting feature in Power BI uses machine learning algorithms to predict future values based on historical data. This helps businesses to make informed decisions, plan for future trends, and adjust strategies, leading to increased efficiency, profitability, and customer satisfaction.


by - 16/4/2024

Pivot and Unpivot Columns in Power BI

PTR is proud to provide Microsoft Power BI consultancy services to help you and your business get the most from your data but when only a quick answer will do, here is the latest in our series of bite-sized “How to” guides for Power BI, looking at the pivot functionality within Power BI.


Pages