Platform Access

2022 My Data Summit on Power BI & Excel

In today’s growing demand for data and analytics expert, keeping up with the latest technology releases and updates on Microsoft Office and Power Platform puts you ahead of the game

Enroll Now

Here's What You'll Get

With The Course

31 self-paced sessions with Microsoft MVPs and community experts

Boost your productivity and performance

  • More than 30 Microsoft MVPs and community experts to discuss the two most widely used technologies in business processes – Microsoft Office and Power Platform
  • Help data users improve their performance and productivity.

Details Of What You Will Learn

During This Course

  • Gain a deep understanding of Microsoft's various technology tools
  • Identify appropriate application to use for certain business functions
  • Learn new tips and tricks on using Microsoft technologies from experts
  • Gain skill on how to look and utilize data
  • Master specific relevant skills: Financial Modelling, Analysis Planning, Querying, etc

This Course Module is Tailored for:

Data Analysts

Reporting Managers

Excel Users

Participants of this course must have a basic understanding of Microsoft Office and Power Platform. No other advanced preparation is needed to take this course.  


Utilize the key features Power BI

  • My Greatest Hits Of Power Query Compilation
  • Analysis Planning: The Oft-Overlooked Pillar of Effective Power BI Reporting
  • MVBA, PQ for a Simple Excel Utility
  • The Journey of Record Extraction in Excel
  • Excel Automation with Office Scripts and Power Automate
  • Azure AD for the Azure Data Services

Course Curriculum

1. Excel

  • Parameters from regular Excel to Power BI with Boriana Petrova
  • Exploring the Power of New Excel Functions with Cristiano Galvao
  • Result 10, Dificult 0 with Karen Abecia
  • VBA, PQ for a Simple Excel Utility with Victor Momoh
  • Excel features that are HOT 🔥 but dangerous 😈 !!! with Oz du Soleil
  • Scenario Modelling for better Forecasting in Excel with Danielle Stein F
  • LAMBDA - Taking Control of your Functions with Alan Murray
  • The Journey of Record Extraction in Excel with Nabil Mourad
  • Rapid Excel BI Model Development with Ken Puls
  • Excel Charts with Dynamic Arrays with Carlos Barboza
  • Excel automation with Office Scripts and Power Automate with Mark Proctor
  • The Excel Features & Skills You Need to Automate a Reporting Procedure with Celia Alves
  • Excel Tips and Tricks with Bob Umlas
  • Pivot Table Tips and Tricks with Bill Jelen
  • Manage banking transactions directly through your Excel-VBA model with Shalah Abdulla

2. Power BI

  • Financial Modelling In Power BI with Liam Bastick
  • Where is all your data with Oakley Turley
  • Analysis Planning: The Oft-Overlooked Pillar of Effective Power BI Reporting with Brian Julius
  • Power BI and Azure Databricks – A Magical Union with Pragati Jain
  • An Introduction to Tabular Editor with Matt Allington
  • R and Python in Power BI with Helen Wall
  • My Greatest Hits Of Power Query Compilation with Gašper Kamenšek
  • Power Query to Manage Your HR Data with Md. Mehanazuddin Rupom
  • Power Query Tricks beyond the User Interface with Chandeep Chhabra
  • Instructor-led training and tips for successful Power BI visualization
  • Azure ML In Power BI with Somy Ayazi

3. Other

  • Rock your data with Microsoft Lists and SharePoint with Tracy van der Schy
  • Presentation is Everything! with Claudia Buckley
  • Power your Apps in a few steps with Jasmina Ahmatovic
  • Creating More Effective Charts with Echo Swinford
  • Azure AD for the Azure Data Services with Heini Ilmarinen
  • Power Of Power Automate with Faraz Shaikh

What our Students Say

Your Instructor

Ilgar Zarbaliyev

  • Retail Store Manager with diversified experience into Textile Experience and Store Operations Specialist with multi-unit & category management experience and Data Analyst who loves to interpret and analyze data to drive growth with furnishing insights, analytics, and business intelligence needed to guide decisions.
  • MCT (Microsoft Certified Trainer), MCE (Microsoft Certified Educator), MIE Expert (Microsoft Innovative Educator Expert), MCSA: BI Reporting
  • 14 Microsoft Certificates in Azure, Dynamics 365, Excel, Power Platform Products (Power Apps, Power Automate and Power BI) & Enterprise DNA Certified
  • PL-300 Course Author (Enterprise DNA)
  • Trained Microsoft Excel, PowerPoint and 21 Century Learning Design courses to more than 800 people for the period of April 2021- November, 2022

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Frequently Asked Questions

  • How long do I have access to the course? You have access to this course as long as you have Enterprise DNA On-Demand Subscription.

  • Can I purchase a single course instead of the Enterprise DNA On-Demand? The option to purchase a single course has been discontinued. To access any of our courses, you will need to upgrade to full On-Demand Subscription here.
  • Do you offer one-off support or coaching? All support around Power BI and Enterprise DNA's online training content now occurs at the Enterprise DNA Forum. You must have an Enterprise DNA On-Demand Subscription or For Business access to receive support.

  • What if I need to train my team? We recommend exploring Enterprise DNA For Business platform. To learn more, see here.

Get full access to unparalleled training

& skill-building resourcess

For Individuals

Enterprise DNA


Empowering the most valuable data analysts to expand their analytical thinking and insight generation possibilities

For Teams

Enterprise DNA

For Business

Training, tools, and guidance to unify and upskill the data analysts in your workplace