Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Montreal, QC

#1 - 2018 Q3 | Montreal Alteryx Meeting Recap | 2018-09-12

williamchan
10 - Fireball

Thanks to everyone who attended the Montreal Alteryx User Group Event on Sep 12th, 2018. We had a great reboot meeting at the Keyrus offices in the Old Port. Thanks @MMehdi!

 

For those who came and those who couldn’t make it, here is a recap of the event. Attached is the presentation.

 

25 people (including the leaders) from 13 companies attended the event. After a pizza and networking session at the beginning of the evening, Freddy Colina @fredcolina, Analytics Manager at Lasik MD kicked off the session by welcoming the attendees, introducing the leaders of the Montreal Alteryx User Group and showing the audience profile according to the previously sent poll:

  • 62% of the respondents have one year of less of Alteryx experience and 92% have used it between 1 and 5 years

  • 54% consider themselves intermediate or advanced users

  • 75% use MS SQL

  • 84% would like to see Use Cases and 77% would like to have hands-on sessions

  • 50% of them use Tableau

Q3-1.jpg

 

Session 1 - Use Case: Automating Dashboards with Alteryx Automation Add-On
Next, William Chan @williamchan who works for Air Canada in the Product Distribution department, showed how the airline went from Excel-based reports and “databases” to automated ETL in Alteryx and up-to-date dashboards in Power BI.

 

Q3-2.png

 

Session 2 - Simplifying Your Data Procedures: Alteryx Best Practices
After William’s session, Scott Carr @ScottyCarr, Senior Consultant from KPMG, presented a great session about the ten commandments of Alteryx Best Practices when working on big projects, namely:

  • 1. You shall have a clean and consistent folder structure
  • 2. You shall split your workflows into logical groups
  • 3. You shall consolidate and simplify your data
  • 4. You shall validate completeness of your data
  • 5. You shall use as little tools as possible
  • 6. You shall document your workflows like it was your diary
  • 7. You shall use join tool responsibly
  • 8. You shall embrace the use of macros sooner than later
  • 9. You shall cleanup your workflow (YES, THOSE BROWSES)
  • 10. You shall check warnings, errors and validate outputs

It was a great session that sparked comments from everyone in the room.

 

Q3-4.jpg

 

Alteryx, the Community

Next came Julie Hamel @JulieH, Director of Global Community at Alteryx, who showed everyone the power of the community website, the value of the Alteryx Academy and a trove of other useful resources available to novice as well as advanced users of Alteryx
The evening ended with even more networking, open discussions and tips exchange among everyone in the room.

 

Q3-5.jpg

 

We will announce the Q4 meeting date shortly!

 

Thank you.

William Chan | @williamchan | LinkedIn

Alteryx Transportation and Montreal User Group Co-Leader

Business Analyst, Distribution and Payments | Air Canada

alteryx-sig.JPG

 

4 REPLIES 4
LaurenU
Alteryx Alumni (Retired)

Thank you for sharing @williamchan! It's nice seem pictures from the meeting, I feel like I was there in person. Keep up the great work. 

williamchan
10 - Fireball

For those who attended the meeting - can you fill out this quick 2 question survey? This will help us provide better content to meet the User Group's needs.

 

Link: https://www.surveymonkey.com/r/TGBWN9X

 

nabilbeit
7 - Meteor

Great job organizing it. Could not make it but looking forward to the next one. 

 

Nabil


@williamchan wrote:

Thanks to everyone who attended the Montreal Alteryx User Group Event on Sep 12th, 2018. We had a great reboot meeting at the Keyrus offices in the Old Port. Thanks @MMehdi!

 

For those who came and those who couldn’t make it, here is a recap of the event. Attached is the presentation.

 

25 people (including the leaders) from 13 companies attended the event. After a pizza and networking session at the beginning of the evening, Freddy Colina @fredcolina, Analytics Manager at Lasik MD kicked off the session by welcoming the attendees, introducing the leaders of the Montreal Alteryx User Group and showing the audience profile according to the previously sent poll:

  • 62% of the respondents have one year of less of Alteryx experience and 92% have used it between 1 and 5 years

  • 54% consider themselves intermediate or advanced users

  • 75% use MS SQL

  • 84% would like to see Use Cases and 77% would like to have hands-on sessions

  • 50% of them use Tableau

Q3-1.jpg

 

Session 1 - Use Case: Automating Dashboards with Alteryx Automation Add-On
Next, William Chan @williamchan who works for Air Canada in the Product Distribution department, showed how the airline went from Excel-based reports and “databases” to automated ETL in Alteryx and up-to-date dashboards in Power BI.

 

Q3-2.png

 

Session 2 - Simplifying Your Data Procedures: Alteryx Best Practices
After William’s session, Scott Carr @ScottyCarr, Senior Consultant from KPMG, presented a great session about the ten commandments of Alteryx Best Practices when working on big projects, namely:

  • 1. You shall have a clean and consistent folder structure
  • 2. You shall split your workflows into logical groups
  • 3. You shall consolidate and simplify your data
  • 4. You shall validate completeness of your data
  • 5. You shall use as little tools as possible
  • 6. You shall document your workflows like it was your diary
  • 7. You shall use join tool responsibly
  • 8. You shall embrace the use of macros sooner than later
  • 9. You shall cleanup your workflow (YES, THOSE BROWSES)
  • 10. You shall check warnings, errors and validate outputs

It was a great session that sparked comments from everyone in the room.

 

Q3-4.jpg

 

Alteryx, the Community

Next came Julie Hamel @JulieH, Director of Global Community at Alteryx, who showed everyone the power of the community website, the value of the Alteryx Academy and a trove of other useful resources available to novice as well as advanced users of Alteryx
The evening ended with even more networking, open discussions and tips exchange among everyone in the room.

 

Q3-5.jpg

 

We will announce the Q4 meeting date shortly!

 

Thank you.

William Chan | @williamchan | LinkedIn

Alteryx Transportation and Montreal User Group Co-Leader

Business Analyst, Distribution and Payments | Air Canada

alteryx-sig.JPG

 


 

williamchan
10 - Fireball

Salut MTL User Group!

 

The next Montreal AUG meeting will be on Wednesday, January 16 from 5:30-7:30pm at the KPMG Tower. Details are below:

 

Agenda: https://community.alteryx.com/t5/Montreal-QC/2019-Q1-Montreal-Alteryx-User-Group-Meeting/gpm-p/34107...

Registration: https://www.eventbrite.com/e/alter-montreal-alteryx-user-group-q1-2019-meeting-registration-53013007...

 

Hope to see everyone there!

 

Happy Holidays!

 

William Chan | @WilliamChan | LinkedIn

Alteryx Transportation and Montreal User Group Co-Leader

Business Analyst, Distribution and Payments | Air Canada

alteryx-sig.JPG

Labels