Skip to content
View szilardev's full-sized avatar
2 followers · 0 following

Block or report szilardev

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
szilardev/README.md

Szilárd Kántor

IT Trainer & Consultant focused on practical data, automation and business intelligence solutions.

“All truths are easy to understand once they are discovered; the point is to discover them.”
— attributed to Galileo Galilei

I help companies turn messy spreadsheets, manual reports and fragmented processes into usable systems with Excel, Power BI, Power Platform, SQL and Python.

Main areas

  • Power BI, Power Query, Power Pivot
  • Excel automation with VBA
  • Power Automate and Power Apps
  • SQL and data modeling
  • Python for data analysis and machine learning basics
  • Training material, demos and practical business examples

What you will find here

This profile is a practical knowledge base for business-focused data work:

  • reusable Power Query M functions
  • Excel and Power BI helper examples
  • data cleaning and reporting automation patterns
  • SQL and Python teaching examples
  • small tools created for training and consulting scenarios

Website

👉 Website: IT training and consulting

Pinned Loading

  1. power-query-easter-calculator power-query-easter-calculator Public

    Calculates the date of Easter and related holidays (Pentecost and Good Friday).

    1 1

  2. power-query-simple-calendar power-query-simple-calendar Public

    Generate a simple calendar table in Power Query (M language)

    1 1

  3. power-query-find-and-replace power-query-find-and-replace Public

    Finds and replaces values ​​in one table based on values ​​in another table.

  4. power-query-iso-week power-query-iso-week Public

    A custom Power Query (M) function to accurately calculate the ISO 8601 week number from any date or datetime. By implementing an ordinal date-based algorithm, it perfectly handles complex year-end …

  5. power-query-time-table power-query-time-table Public

    Generates a time table in Power Query (M language).