Report Building
3 Things to do when handing a Power BI report / model for Report Personalisation As a powerbi developer you know your data and your model inside out. Part of my role as an external consultant is to train people in using their reports and increasingly how to use the dataset in different scenarios and […]
COVID Dashboard
COVID 19 Summary View This is a useful summary of the steps used to create the data model for the Reports. SEE IT IN ACTION Step 1 – created a query to pull in the first data set. Created a parameter for a filename. Then changed the filename in the query to the parameter filename, and ensured that the query would dynamically […]
30DQUERY Day 29 Partitions
Share on linkedin LinkedIn Share on twitter Twitter Share on facebook Facebook This query involved taking the data and splitting it into four partitions using power query. I’ve split the data into four partitions and the query folds which means that a Power Query query generates a single query statement to retrieve and transform source […]
30DQUERY Day 30 Last day
#30DQUERY Day 30 Last day of this Challenge which makes me really sad 🙁 🙁 I have really enjoyed these challenges and a huge thank you to Alex Powers for driving the momentum. If you are interested in Power Query there is no reason why you can’t join restrespectively 30 Day Query link The final days challenge […]
Mastering DAX
So very thrilled to complete this. It’s been a real roller coaster of a journey which has involved dark rooms and rocking back and forth. What helped was also reading the book at the same time. I found working through the Demo files whilst watching the clips also helped as I could make notes and […]
Microsoft Excel – KPIs
As a Microsoft Excel Trainer and PowerBI developer I have to stay current. Fortunately for me, I love to learn and then share my knowledge with my customers. There is a real joy in teaching Excel and seeing the lightbulb moment occur, usually within minutes and usually several times! I’m following a Udemy course with […]
Microsoft Excel Data Transformation Magic
Yesterday I received an SOS from a colleague… “Sue, I’m stuck! It says it can do it but it can’t…. and I’m running out of time. I have a deadline to meet and am seeing clients all day. Why won’t it work, help!!!” . So I did. The problem was that the HR software that […]
What is Data Analytics and why should I use it?
Data Analytics gives you the Business Intelligence that allows you to: Profit Maximisation Cost Reduction Customer Retention New Customer Development Focused and targeted marketing Customer Behaviour Evaluation of Product / Service Behaviour Informed decisions Data analytics is a process of inspecting, cleansing, transforming and modelling data to discover useful information, suggesting conclusions, and […]