talk-data.com
Activities & events
| Title & Speakers | Event |
|---|---|
|
Data Analysis with Python and Power Query in Excel
2025-07-31 · 16:00
This session demonstrates how Python integrates with Excel to analyze data directly inside spreadsheets. What you will learn: Python libraries available in Excel; Different ways to insert Python codes in Excel; Advanced charts for Data Science in Excel. |
Data Analysis with Python and Power Query in Excel
|
|
#228 Are Spreadsheets Still Relevant For Data Analysis? with Jordan Goldmeier, Author of Data Smart
2024-07-22 · 10:00
Jordan Goldmeier
– entrepreneur, consultant
@ Booz Allen Hamilton; The Perduco Group; EY; Excel TV; Wake Forest University; Anarchy Data
,
Adel
– host
@ DataFramed
Excel often gets unfair criticism from data practitioners, many of us will remember a time when Excel was looked down upon—why would anyone use Excel when we have powerful tools like Python, R, SQL, or BI tools? However, like it or not, Excel is here to stay, and there’s a meme, bordering on reality, that Excel is carrying a large chunk of the world’s GDP. But when it really comes down to it, can you do data science in Excel? Jordan Goldmeier is an entrepreneur, a consultant, a best-selling author of four books on data, and a digital nomad. He started his career as a data scientist in the defense industry for Booz Allen Hamilton and The Perduco Group, before moving into consultancy with EY, and then teaching people how to use data at Excel TV, Wake Forest University, and now Anarchy Data. He also has a newsletter called The Money Making Machine, and he's on a mission to create 100 entrepreneurs. In the episode, Adel and Jordan explore excel in data science, excel’s popularity, use cases for Excel in data science, the impact of GenAI on Excel, Power Query and data transformation, advanced Excel features, Excel for prototyping and generating buy-in, the limitations of Excel and what other tools might emerge in its place, and much more. Links Mentioned in the Show: Data Smart: Using Data Science to Transform Information Into Insight by Jordan Goldmeier[Webinar] Developing a Data Mindset: How to Think, Speak, and Understand Data[Course] Data Analysis in ExcelRelated Episode: Do Spreadsheets Need a Rethink? With Hjalmar Gislason, CEO of GRIDRewatch sessions from RADAR: AI Edition New to DataCamp? Learn on the go using the DataCamp mobile appEmpower your business with world-class data and AI skills with DataCamp for business |
DataFramed |
|
The London Excel Meetup group is coming to Munich, Germany. There will be fun, drinks, learning, and networking in a very social atmosphere. I cannot wait to meet you all. Our venue is very close to Central station so for those who can commute to Munich (or live in Munich), this is a great opportunity to attend an in-person event. Please, please RSVP on this page if you plan to attend as we need to know numbers. The plan for the evening.
This event will have multiple speakers delivering short presentations of 10-15 minutes each. You will hear from:
Alan Murray
Martin Weiss • Excel trainer, developer and consultant • Owner of the Excel blog “Tabellenexperte” (www.tabellenexperte.de) • Author (“Excel Pivot-Tabellen für Dummies“) • Microsoft Certified Excel Expert Robert Mundigl • Consultant for Data Analysis, Data Visualization, Financial Modelling, Simulation and Optimization • based in Aschheim (near Munich, Germany) • Founder and owner of Clear & Simple Analytics GmbH • Blog: ClearlyandSimply.com since 2009 • Microsoft Excel user since 1990 Sue Bayes I'm a Microsoft Certified Data Analyst Associate in Microsoft Azure and Microsoft Power BI specialising in Microsoft Power BI, Excel and Paginated Reporting. I develop reports and models using Microsoft Power BI, Microsoft Excel, R and Python and work closely with businesses to enable them to use these tools to provice strategic insight and answer those questions that give value. Giles Male Giles is a CIMA qualified modeller, and co-founder of Full Stack Modeller – a training company and global community for finance professionals. Giles is keen runner, with Comrades Ultra in South Africa on the calendar for 2024. Anders Ebro Anders Ebro is a software engineer and system designer from Exacto , working out of Copenhagen in Denmark. Anders has been developing and delivering optimized business applications built with Excel and SQL server for more than a decade. Everything from complex manufacturing forecasting to requirements management tools, or HR bonus payout, Anders has built it. An Microsoft MVP in Office since 2014, he has gladly shared, presented and helped hundreds of people learning the finer nuances of Office, VBA and SQL. Cristian Angyal
Traci Williams Traci is a trainer and consultant operating her own company Excel Ace. She loves Excel and in her training helps businesses get the most out of their spreadsheets. Enrico de Crescenzo Enrico has been a senior finance manager in several companies in Zürich Switzerland for the last decade. He's a lazy runner and an Excel (and Power BI) enthusiast. When he's not busy improving cash flow forecasting systems or implementing KPIs to monitor financial performance, he's probably teaching how to optimize and automate spreadsheets through examples of the fictitious and delicious Pizza BI. David Benaim "Excel MVP and amateur comic David Benaim merges cells with exhil-arating laughs. If you like to spreadsheet, come and get sum, or #nah, if it's out of your range." This is an in-person only event. Bis bald |
Munich Excel Event | Robert Mundigl, Anders Ebro, Sue Bayes, Martin Weiss & More
|
|
Advanced Power Query for Business Analysis | Viorel Cazacu
2023-09-14 · 16:00
Speaker: Viorel Cazacu Start Date: Thu, Sep 14th 2023 · 7:00 PM EEST Language: ROMANIAN Location: Online (link visible for attendees) =============================================================== Description: The participants will learn some advanced Power Query techniques, each exemplified with a practical business application:
=============================================================== At the end of the Meetup we'll have a Raffle with prizes offered by ETA2U: 1 FREE Voucher for a Data Related Training Live with ETA2U for one lucky winner from the Live attendees ! =============================================================== Speaker: Viorel Cazacu Head of Controlling, Inditex Romania With more than 14 years of experience in financial planning and analysis, my career has spanned diverse industries including telecommunications, banking, and retail. As the Head of Controlling at Inditex Romania, I'm privileged to oversee financial performance across all seven Inditex brands, contributing to a combined turnover exceeding 450 million EUR. My approach blends data-driven insights with a deep understanding of the business landscape, creating impact where business, finance, and technology converge. My passion for knowledge-sharing led me to provide structured training to my colleagues at Inditex, empowering them with advanced Excel, Power Query, and PowerPivot skills. My dedication to continuous learning is validated through certifications in data analysis and visualization tools, including Power BI, SQL, and Python. Beyond my corporate role, I've authored an Excel VBA eBook available on Amazon, developed a course on Udemy to empower fellow professionals in practical business analysis, and maintain a YouTube channel where I share practical insights on navigating the intricacies of data. Join me at this event to uncover the potential of Power Query and take your data skills to new heights. Connect with Viorel: |
Advanced Power Query for Business Analysis | Viorel Cazacu
|