Power Query and Data Modeling

with Dimitar Shutev
4.8/5
(935)

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

2 hours of content 5995 students

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 2 hours of content
  • 28 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Power Query and Data Modeling

A course by Dimitar Shutev

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 2 hours of content
  • 28 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

$99.00

Lifetime access

Buy now

$99.00

Lifetime access

Buy now
14-Day Money-Back Guarantee

What you get:

  • 2 hours of content
  • 28 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

What You Learn

  • Get an introduction to Power Query – the data preparation and transformation engine available in Microsoft’s most popular data analysis products - Power BI, Excel, Azure, and Dataverse
  • Learn fundamental data modeling skills that will help you prepare your data for analysis in Power BI
  • Be able to import data from multiple sources and take advantage of Power Query’s powerful ETL capabilities
  • Perform data modeling to transform and reshape your data
  • Learn how to connect Power Query to multiple data source: SQL DB, Rest API, csv, JSON, Google Analytics, Web, and other
  • Boost your data analyst resume by adding a highly sought-after technical skill

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

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.

Learn for Free

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

Curriculum

  • 1. Intro to Power Query
    18 Lessons 115 Min

    We will cover some of the most common data transformations inside Power Query, such as importing data from multiple sources, replacing and extracting values, merging columns, and removing columns and duplicates. You will also learn all about filters, date functions, conditional columns, pivoting and unpivoting, merging tables, parameters, query properties, data profiling, web scraping, and mathematical functions.

    What is Power Query
    2 min
    Importing Data
    6 min
    Data Types
    10 min
    Replacing Values
    5 min
    Merge Columns
    4 min
    Extract Values
    3 min
    Remove Duplicates
    2 min
    Remove Columns
    3 min
    Filters
    6 min
    Date Functions
    7 min
    Conditional Columns
    4 min
    Unpivot
    5 min
    Merge Queries
    11 min
    Parameters
    10 min
    Query Properties
    6 min
    Data Profiling
    11 min
    Web Scraping
    13 min
    Mathematical Functions
    7 min
  • 2. Data Modeling
    4 Lessons 25 Min

    Data comes in all sizes, shapes, and forms. By default, it is often disorganized, difficult to analyze, and may contain information that is not required for our reporting needs. This is why we need to perform data modeling to transform and reshape our data.

    Data modeling
    7 min
    Relationships
    7 min
    Role Level Security
    9 min
    Global Superstore report Read now
    2 min

Topics

Power Querydata preprocessingBusiness IntelligenceData modeling

Tools & Technologies

powerbi

Course Requirements

  • Highly recommended to take the Power BI course first
  • You need access to Microsoft Office 365

Who Should Take This Course?

Level of difficulty: Intermediate

  • Aspiring BI analysts, data analysts, and data scientists
  • Aspiring financial analysts, financial controllers, and business analysts who want the technical skills to satisfy their own data exploration needs
  • Everyone who wants to improve their practical Power BI skills

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Exams and certification

Meet Your Instructor

Dimitar Shutev

Dimitar Shutev

Senior Data Analyst at

5 Courses

5779 Reviews

72704 Students

Dimitar started his career as a BI developer for Rimilia, DXC Technology, and NaXex Technological Development Ltd. Then, he was hired as a Senior Data Analyst at the global travel technology company Amadeus. Currently, Dimitar works as a Senior Data Engineer at EPAM Systems. As an instructor at 365, Dimitar has demonstrated a great passion for teaching and a genuine willingness to support his students along the way. He spends a great deal of time improving the lessons of his Power BI course and is willing to go the extra mile to create practice exam questions and course exam questions.

What Our Learners Say

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.