Power Query is a unique way of transforming data in Excel and requires no programming skills. It takes seconds to update information, all at the click of one button.
BA Support have agreed to have a one stop shop to house all the Power Query solutions that have been posted and the aim is to add more.
The list of examples thus far is as follows: -
General
Betfair Historic Data Downloaded
viewtopic.php?f=83&t=28303
Power Query List of PQ Solutions
viewtopic.php?f=83&t=28345
Betdaq XSP 2023
viewtopic.php?t=29152
Horse Racing
Timeform Runners & BHB Ratings
viewtopic.php?f=31&t=22292
Jockey Stats
viewtopic.php?f=31&t=22291
Betfair Historic Results (Horses)
viewtopic.php?f=19&t=22451
Horse Racing - Daily Tips
viewtopic.php?f=19&t=22321
Horse Racing - Daily Tipster Naps Table
viewtopic.php?f=19&t=22315
Horse Racing - Daily Tips from Every UK/IRE Race
viewtopic.php?f=19&t=22310
BF Historic Horse Win Data in One Workbook
viewtopic.php?f=19&t=22451
Horse Racing - Steamers & Drifters
viewtopic.php?f=31&t=22496
Aus Racing - Horse Stall Draw Data
viewtopic.php?f=31&t=23114
Horse Racing - Daily Tipster Table
viewtopic.php?f=31&t=23178
Horse Racing - Predictor + History
viewtopic.php?f=31&t=23317
Horse Racing - Hugh Taylor Tips
viewtopic.php?f=31&t=23315
Horse Racing - In Running Rating
viewtopic.php?f=31&t=23942
Horse Racing - In-Running Stats
viewtopic.php?f=83&t=28180
Horse Racing - Combo's Last 14 Days Etc
viewtopic.php?f=83&t=28175
Horse Racing - Backed or Drifted
viewtopic.php?f=83&t=28174
Horse Racing - Hugh Taylor Results
viewtopic.php?f=83&t=28173
Football
Calculations to determine if Both Teams To Score (BTTS) Has Value Or Not
viewtopic.php?f=31&t=22275
Footy Stats Top 9 Leagues
viewtopic.php?f=31&t=22444
Premier League Top Strikers
viewtopic.php?f=31&t=22297
Results Downloader
viewtopic.php?f=83&t=28401
Other Sports
The Power of Power Query (Original Post)
viewtopic.php?f=31&t=22288
NFL Team Stats
viewtopic.php?f=19&t=22289
Greyhound Course Trap & Favourite Stats
viewtopic.php?f=31&t=22493
Snooker - All Time Stats
viewtopic.php?f=31&t=22580
Aus Greyhounds - Trap Stats
viewtopic.php?f=31&t=22583
Darts - Recent Results
viewtopic.php?f=31&t=22596
Golf - PGA Golf Stats
viewtopic.php?f=31&t=22645
Tennis - Serve Stats
viewtopic.php?f=31&t=22934
UK Lotto Draw Numbers
viewtopic.php?f=31&t=24498
Cricket - T20 Historical Results 2010-2023
viewtopic.php?f=83&t=28184
Count of Winning & Losing Streaks
viewtopic.php?f=83&t=28193
Greyhound A to Z and Tip's
viewtopic.php?f=83&t=28344
Golf - PGA Player Stats
viewtopic.php?t=29044
Golf - PGA Tournament Results
viewtopic.php?t=29093
Power Query - Example Spreadsheets (Indexed by Sport)
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Last edited by paspuggie48 on Tue Dec 01, 2020 11:29 am, edited 2 times in total.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Brilliant timing... last two days have been a head F**K!
This will help!
This will help!
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
Get the basics of how PQ 'Gets & Transforms' data and it is relatively easy ...once I showed Memphis how it worked and after he watched a few videos himself he picked it up like a duck to water...all within the last month or so and he is now developing some really good data solutions.Realrocknrolla wrote: ↑Mon Nov 30, 2020 7:51 pmBrilliant timing... last two days have been a head F**K!
This will help!
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Yeah mate, i've been reading his posts.... clever fella. I've been trying to telepathically receive his Greybot also but I'm still working on that one too.paspuggie48 wrote: ↑Mon Nov 30, 2020 8:03 pmGet the basics of how PQ 'Gets & Transforms' data and it is relatively easy ...once I showed Memphis how it worked and after he watched a few videos himself he picked it up like a duck to water...all within the last month or so and he is now developing some really good data solutions.Realrocknrolla wrote: ↑Mon Nov 30, 2020 7:51 pmBrilliant timing... last two days have been a head F**K!
This will help!
- paspuggie48
- Posts: 674
- Joined: Thu Jun 20, 2013 9:22 am
- Location: South-West
He's clever but he has some way to go yet to better his mentor
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
paspuggie48 wrote: ↑Mon Nov 30, 2020 8:16 pmHe's clever but he has some way to go yet to better his mentor
- MemphisFlash
- Posts: 2210
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i feel some BRO-mances developing, lol
- MemphisFlash
- Posts: 2210
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
You do not have the required permissions to view the files attached to this post.
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Haha, can either of you post some or DM me some youtube videos to learn from. All info welcome!
- MemphisFlash
- Posts: 2210
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
https://www.youtube.com/watch?v=BrLQmJ1Vqk4&t=32s
https://www.youtube.com/watch?v=6lBqYInBldk
https://www.youtube.com/watch?v=sLW3NbeGDy8
https://www.youtube.com/watch?v=2mR44X7PrRo
that should keep you occupied for a while. These were some of the ones i watched.
The two women are very good.
https://www.youtube.com/watch?v=6lBqYInBldk
https://www.youtube.com/watch?v=sLW3NbeGDy8
https://www.youtube.com/watch?v=2mR44X7PrRo
that should keep you occupied for a while. These were some of the ones i watched.
The two women are very good.
-
- Posts: 82
- Joined: Tue May 01, 2018 1:33 pm
Great stuff on the thread, I only recently enrolled in a power query Udemy course so very interested in this thread
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
Legend... Will crack on with these today. Alexa has been blasting out the 50's for me this morning! Put me in a right good mood!MemphisFlash wrote: ↑Mon Nov 30, 2020 10:07 pmhttps://www.youtube.com/watch?v=BrLQmJ1Vqk4&t=32s
https://www.youtube.com/watch?v=6lBqYInBldk
https://www.youtube.com/watch?v=sLW3NbeGDy8
https://www.youtube.com/watch?v=2mR44X7PrRo
that should keep you occupied for a while. These were some of the ones i watched.
The two women are very good.
- MemphisFlash
- Posts: 2210
- Joined: Fri May 16, 2014 10:12 pm
- Location: Leicester
i have 83000 mp3s all 50's related stuff on my hard drive
- Realrocknrolla
- Posts: 1903
- Joined: Fri Jun 05, 2020 7:15 pm
I bet you have the titles in a spreadsheet tooMemphisFlash wrote: ↑Tue Dec 01, 2020 10:18 ami have 83000 mp3s all 50's related stuff on my hard drive