SIMS and Power BI consultant for schools. I deliver training and develop analysis systems for schools. https://nitter.cf/t.co/Jjj2xk7HbZ
North West, England
Joined January 2009
- Tweets3.2K
- Following1.4K
- Followers1.9K
- Likes1.5K
David Pott retweeted
Power BI groups allow you to group together categorical data (eg pupil behaviours) into category groups (eg severe, moderate, trivial). But the feature is well hidden and the user interface isn't the simplest to understand. #PowerBI
youtu.be/LBp48cwyCBg
David Pott retweeted
Here's an example of a heatmap in Power BI. School absence codes from the registers are are along the top, weeks and months down the side. It looks like a lot of people were on holiday (H) just before Christmas. More at schoolanalytics.co.uk #school #data #powerbi
David Pott retweeted
📈Want to learn Power BI?📊
I'm running a course for complete beginners soon:
-3 hours online training + course templates
-Covers how to get data, build a model and create visualisations
-only £99
Reply or DM me if you're interested
David Pott retweeted
Practical stuff:
3hr online course, 2hr sesh 10am-12 then 1hr Q&A at 3pm
Pbix file with all the content yours to keep.
Costs £99
David Pott retweeted
Tip for large MATs if you find a table's too big to pull through an OData feed into BI
1. Filter the query in Power Query so it's one school only
2. Open up the advanced editor and add this before 'let'
= (SchoolID as number) =>
(this turns it into a function)
David Pott retweeted
I work as a Power BI developer for multi academy trusts - if you've heard of #PowerBI but aren't sure what it is or why it's good then this a thread for you.
Power BI collects, organises and visualises data - kind of like a fancy Excel
David Pott retweeted
Spots left in my BI Development course *this Friday*. If you've used BI, know the basics but want to know how to do cool stuff then this is the course for you!
It's online 10am-12 and 3pm-4 & costs £99. DM me for more details or to book a place
David Pott retweeted
The first course is BI for Experts scheduled for Friday, 12th of March. It covers the DAX techniques needed to navigate complex relationships between subjects-classes-students and assessments and how to optimise queries with DAX Studio. Hope you can make it @DavidPott @LukeSdm
David Pott retweeted
Coming very soon - live Power BI training with me!
It would help me out loads if you could retweet and complete this 3 question survey
Thank you, Ed
David Pott retweeted
POST! AAB with 2 in facilitating subjects. Pretty interesting measure from a DAX point of view so worth checking out even if you don't deal with KS5
powerbiforschools.blogspot.c…
David Pott retweeted
Marco Russo is a leading expert on DAX so well worth a follow - I use EXCEPT to get the 4th, 5th and 6th biggest EBACC grade for A8, by combining TOPN(3,... with TOPN(6,...
Discover the DAX functions that manipulate sets. They are useful to create queries and sometimes also to author measures.
#dax #powerbi #ssas #tabular
Article+video: sqlbi.com/articles/set-funct…
David Pott retweeted
Have been asked about BI on a budget again, let's consider a MAT with decentralised data (SIMS), where each sch has a report and where those reports don't show pupil level data in visuals but do have that data in their models.
David Pott retweeted
Power BI on a budget, here are four options with Pros(P) and Cons (C)...
@Bi4Schools so we are aiming to use PowerBI much more this year. However, due to budget constraints I’m the only one with a pro license. How can I share reports/dashboard with free license users?
David Pott retweeted
Did you hear we've made our 2019 Arbor Insight Reports completely free for all schools?
With no new performance data coming out this year, kickstart your school improvement plan with free access to your ASP reports from the past 3 years
Download yours: login.arbor.sc/auth/register
David Pott retweeted
Little post! About NaN and Infinity in tables and matrices. Tldr: use the DIVIDE function
powerbiforschools.blogspot.c…
David Pott retweeted
Hi BI tribe - if you're around at 11am this am and fancy a demo and chat about BI, I'll be presenting alongside @markhodges from @CantiumSolution
This Post is from an account that no longer exists. Learn more
David Pott retweeted
BLOG! Hi BI tribe, here's a quick post about new features in BI
powerbiforschools.blogspot.c…
Covers: Decomposition Tree, hierarchy slicers, conditional F for totals & titles and organising fields into subfolders
David Pott retweeted
Please take a quick look at our Power BI solution to reporting pupil information . I've been practising my voice over!
David Pott retweeted
I am a Carpenter / Builder. I have been in business for over 13 years. I want to help the economy recover. I am #ForgottenLtd @RishiSunak @BorisJohnson @AlokSharma_RDG
David Pott retweeted
I am the director of a chilled food wholesale company, employ 4 staff, been established 28 years. We will be the companies required to help our economy recover however we are #ForgottenLtd.@MikeAmesburyMP @BorisJohnson @RishiSunak – at Helsby, England
