Online Course free
Power Query and Data Modeling

with Dimitar Shutev

Master Microsoft’s universal data transformation tool Power Query. Become proficient in data modeling techniques to effectively analyse and visualize data

4.9

808 reviews on
Start for Free
6651 students already have enrolled
  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners

Skill level:

Intermediate

Duration:

2 hours
  • Lessons (2 hours)

CPE credits:

2.5
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of professionals must earn to maintain their licenses and stay current with regulations and best practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's official website: www.nasbaregistry.org

Accredited:

certificate

What You Learn

  • Understand Power Query’s role in Power BI, Excel, Azure, and Dataverse.
  • Learn fundamental data modeling skills for Power Query and Power BI.
  • Import data from various sources using Power Query’s ETL capabilities.
  • Perform data modeling to transform and reshape your datasets.
  • Connect Power Query to SQL DB, Rest API, CSV, JSON, and other data sources.

Topics & tools

power querydata preprocessingbusiness intelligencedata modelingdata analysispowerbi

Your instructor

Dimitar Shutev

Dimitar Shutev

Lead Software Engineer | Senior Data Analyst at EPAM Systems

Track record

Bringing real-world expertise from leading global companies

Company logo 1Company logo 2

Academic background

Bachelor's degree, Advertising and Marketing

Coventry University
Ask Dimitar a question
  • Course Overview
  • Accredited certificates
  • Career paths
  • How it works
  • Student reviews
  • Recommended courses

    • Course OVERVIEW

    Description

    CPE Credits: 2.5 Field of Study: Information Technology
    Delivery Method: QAS Self Study
    Data needs to be transformed and reshaped to meet our reporting needs. This process is called data modeling and one of the best ways to perform it is with Power Query. Power Query is a data preparation and transformation engine, originally introduced as an Excel 2010 add-on. It is widely available within Microsoft products, such as Power BI, Excel, Azure, and Dataverse. Power Query connects to multiple data sources, including SQL DB, Rest API, csv, JSON, Google Analytics, Web, etc. It provides the same user experience and data transformations regardless of the source. In this course, you will learn how to use Power Query to perform data modeling to prepare your data for analysis with BI tools like Power BI.

    Prerequisites

    • Microsoft Excel (any recent version, such as Excel 2019, 2021, or Microsoft 365)
    • Completion of an introductory Excel course is required.

    Advanced preparation

    See more

    Curriculum

    22 lessons 1 exam

    Free preview

    What is Power Query

    1.1 What is Power Query

    2 min

    Importing Data

    1.2 Importing Data

    6 min

    Data Types

    1.3 Data Types

    10 min

    Replacing Values

    1.4 Replacing Values

    5 min

    Merge Columns

    1.5 Merge Columns

    4 min

    Extract Values

    1.6 Extract Values

    3 min

    Start for free

    When I decided to transition into AI and data science, I knew I needed a hands-on learning experience. 365 Data Science provided exactly that. Coming from a different background, I appreciated how the courses broke down complex topics like Python, SQL, and machine learning into clear, manageable lessons. What stood out to me was the practical approach: working on real-world projects gave me the confidence to apply my skills beyond theory.

    Marcela A.

    Marcela A.

    Before 365: English teacher in Japan
    After 365: Business analyst | Sabre

    See all reviews

    96%

    of our students recommend

    365 Data Science.

    My journey started with Ned Krastev’s Excel course, which gave me a solid foundation I could use immediately. Joining 365 Data Science took things to the next level—mastering SQL, Power BI, and Tableau transformed how I work. I went from struggling with raw data to building interactive dashboards that influence decisions. The skills I gained made me indispensable at work and inspired me to aim higher. I’m now working toward becoming a data scientist.

    M K Junayed P.

    M K Junayed P.

    Before 365: Product development | Bikroy
    After 365: Assistant Manager (Analyst) | Green Delta Insurance PLC

    See all reviews

    9 in 10

    of our graduates landed a new AI & data job

    after enrollment

    I’ve been with 365 Data Science for about two years, starting with the Business Analyst course and now working on Data Engineering. My Excel skills improved so much they helped me land two promotions, and my coding knowledge—especially in Python—has grown dramatically. The courses go deeper, helping me understand the mechanisms behind technology. With a set schedule and commitment, the results are real. I highly recommend 365 and look forward to continuing my learning journey.

    Mattew M.

    Mattew M.

    Before 365: Mortgage Loan Officer | Movement Mortgage
    After 365: Compliance Analyst | Movement Mortgage

    See all reviews

    94%

    of AI and data science graduates

    successfully change

    or advance their careers.

    ACCREDITED certificates

    Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global institutions.

    Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities employers value most.

    Learn More
    • Institute of Analytics
    • The Association of Data Scientists
    • E-Learning Quality Network
    • European Agency for Higher Education and Accreditation
    • Global Association of Online Trainers and Examiners
    Learn More
    A LinkedIn profile mockup on a mobile screen showing Parker Maxwell, a Certified Data Analyst, with credentials from 365 Data Science listed under Licenses & Certification. A 365 Data Science Certificate of Achievement awarded to Parker Maxwell for completing the Data Analyst career track, featuring accreditation badges and a gold “Verified Certificate” seal.

    How it WORKS

    • Lessons
    • Exercises
    • Projects
    • Practice Exams
    • AI Mock Interviews

    Lessons

    Learn through short, simple lessons—no prior experience in AI or data science needed.

    Try for free

    Exercises

    Reinforce your learning with mini recaps, hands-on coding, flashcards, fill-in-the-blank activities, and other engaging exercises.

    Try for free

    Projects

    Tackle real-world AI and data science projects—just like those faced by industry professionals every day.

    Try for free

    Practice Exams

    Track your progress and solidify your knowledge with regular practice exams.

    Try for free

    AI Mock Interviews

    Prep for interviews with real-world tasks, popular questions, and real-time feedback.

    Try for free

    Student REVIEWS

    A collage of student testimonials from 365 Data Science learners, featuring profile photos, names, job titles, and quotes or video play icons, showcasing diverse backgrounds and successful career transitions into AI and data science roles.
    Join for free