This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Wolseley is the UK operating company of Ferguson plc, the world’s leading specialist distributor of plumbing and heating products. My division is known as Infrastructure, providing world class solutions within the Civils, Utilities, Power and Hire sectors. I am Infrastructure’s Senior Analyst, heading the team responsible for delivering Reporting, Analytics and Data science. Our focus is driving profitable growth through process simplification and innovation using data analytics.
In this use case, I want to share how I used Alteryx to solve my organisation’s data problems and how that transformed my wellbeing which positively changed my life. By using Alteryx it has freed up a lot of time, offered me the opportunity to join a community and operate at a completely different level. Since February, my Alteryx use has increased and resultingly, my knowledge and data skills have improved significantly. I used the time Alteryx liberated to invest in myself by revising for the core and...
Many customers strive to create a culture of analytics at their organization. Part of this process is designing a system that allows different users to collaborate in one single platform - a language as we call it. More and more, customers are turning to Alteryx to be their common language for decision making.
Vantage Data is a retail focused analytics company. We help our retail partners to better plan their inventory and staffing for their retail locations. Vantage uses Alteryx to model a number of known factors (including day of week, season, time of month, holidays etc.) and now uses real time weather forecasts to predict changes sales figures in stores - including sales figures across key categories.
Ever wonder what activities you could do in London with a time constraint? How about how to maximize the value of your fantasy football team on a budget? Join my session at Inspire to learn how prescriptive analytics and the Optimization Tool can help you find the best solution to your most pressing questions. I’ll go into more detail on the day, but to whet your appetite, here’s a little taster of what to expect.
For this episode of Alter Everything, guest host Alex Koszycki is joined by Alteryx Community stars, Mike Fratoni, Matt Desimone, and Ozzie Dembowski. All Drexel University alumni, they share a chat about their experiences navigating the higher education world, and life afterwards as they carved out their career paths in analytics.
Also be sure to take our audience engagement survey to share your listening preferences and suggestions to make Alter Everything your dream soundtrack to pair with your analytics lifestyle! *Bonus: the first 100 survey takers will be entered to win 1 of 5 pairs of Bluetooth headphones. Survey away!
Excel has a new function called XLOOKUP. It's still in beta so you may not have access to it yet. The help page includes several examples of how to use it. The attached workflow contains snippets that show how to accomplish these tasks in Designer. Three examples are explained below.
Look up employee information by employee ID number
The basic XLOOKUP functionality is included with the Filter tool...
Find next largest item
With the match_mode argument set to 1, XLOOKUP will look for an exact match, but if it can't find one will return the next larger item. To do this in Designer, we'll again start with the filter tool to narrow down the tax rates to those above the income threshold, then we'll sort by max income and choose the first record.
Sum values between range
In this example we're choosing to sum the total prices of the products between Grape and Banana inclusive. The Excel function is a bit complicated here, with a sum and two xlookup functions...
We are looking to have the next meet up in Leeds on the 12th of September. Remo has kindly offered to host and provide pizza, but before we send an invite with all the details we need your help.
If you would like the opportunity to present some work, practice a presentation in a relaxed and friendly environment or even have a problem that you would like to brain storm to the group then please get in touch so that we can add this to the agenda.
In order to make these sessions regular and as varied as possible then the continued interest and participation of you all is crucial. The momentum and interest for the last two sessions was great if you can help out in anyway that would be really helpful.
Please get in touch in the next week if you would like to participate at this and any future sessions.
