Power Query and Data Modeling
Master Microsoft’s universal data transformation tool Power Query. Become proficient in data modeling techniques to effectively analyse and visualize data
$99.00
Lifetime access
What you get:
- 2 hours of content
- 24 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
Power Query and Data Modeling
$99.00
Lifetime access
What you get:
- 2 hours of content
- 24 Downloadable resources
- World-class instructor
- Closed captions
- Q&A support
- Future course updates
- Course exam
- Certificate of achievement
$99.00
Lifetime access
What you get:
- 2 hours of content
- 24 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
1.1 What is Power Query
2 min
1.2 Importing Data
6 min
1.3 Data Types
10 min
1.4 Replacing Values
5 min
1.5 Merge Columns
4 min
1.6 Extract Values
3 min
Interactive Exercises
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.
Practice what you've learned with coding tasks, flashcards, fill in the blanks, multiple choice, and other fun exercises.
Curriculum
- 1. Intro to Power Query18 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 Query2 minImporting Data6 minData Types10 minReplacing Values5 minMerge Columns4 minExtract Values3 minRemove Duplicates2 minRemove Columns3 minFilters6 minDate Functions7 minConditional Columns4 minUnpivot5 minMerge Queries11 minParameters10 minQuery Properties6 minData Profiling11 minWeb Scraping13 minMathematical Functions7 min - 2. Data Modeling4 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 modeling7 minRelationships7 minRole Level Security9 minGlobal Superstore report Read now2 min
Topics
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.
Meet Your Instructor
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.
