Courses

Explore Our Courses

Available Learning Tracks

Excel for Analytics – From formulas to dashboards
Power BI Essentials – Data modelling, DAX, and reporting
Python for Beginners – Analysis and automation foun
Tableau Starter Kit – Visual storytelling for insights

In this tutorial, we explore the essential concepts of data modeling and relationships in Power BI. Using our sample Fact Sales Data (https://docs.google.com/spreadsheets/d/1-5Eqo6HsAnNdzUW7ohmwjeM_C9ZQDgko/edit?usp=sharing&ouid=101062614066382568785&rtpof=true&sd=true) and Dimension Product Data (https://docs.google.com/spreadsheets/d/1-7hCTI33RCxUew-s1S0bmquNKaISkr2_/edit?usp=sharing&ouid=101062614066382568785&rtpof=true&sd=true), you'll learn how to create effective data models that drive accurate and insightful reports. Discover how to build relationships between your fact and dimension tables, ensure data integrity, and optimise your Power BI dashboards for better performance. This lesson is perfect for anyone looking to elevate their data analysis skills through solid data modelling practices.

🔑 Keywords: Data Modelling in Power BI, Fact and Dimension Tables, Building Relationships, Power BI Data Model, Data Integrity, Power Query, Business Intelligence, Data Analysis.

📌 Ready to master data modeling? Hit play, learn how to connect your data seamlessly, and don’t forget to subscribe for more Power BI tutorials!

Data Modeling and Relationships in Power BI | Power Query Editor—8 | Jeks Analytics

In this tutorial, we dive deep into transforming your data by creating custom columns and performing dynamic calculations in Power Query. Using our comprehensive Product Sales Data (https://docs.google.com/spreadsheets/d/1-PE4AGwIT6C2mqOGjKv3efHOYwwVEhB8/edit?usp=sharing&ouid=101062614066382568785&rtpof=true&sd=true) as a case study, you'll learn how to calculate key metrics such as profit and profit margin, even when faced with varied unit sales, price ranges, and outliers. We’ll walk you through the process of adding custom formulas to your queries, enabling you to generate insightful, actionable data for your Power BI reports.

🔑 Keywords: Custom Columns in Power Query, Calculations in Power Query, Profit Margin, Data Transformation, Power BI, Product Sales Analysis, Outlier Handling, Advanced Power Query Techniques.

📌 Ready to elevate your data transformation skills? Hit play, learn how to supercharge your datasets, and don’t forget to subscribe for more advanced Power Query tutorials!

How to Create Custom Column in Power Query | Power Query Editor—7 | Jeks Analytics

In this in-depth tutorial, we dive into one of Power Query's most powerful transformation techniques: unpivoting columns. Whether you're working with a single anchor column or handling multiple anchor columns, this lesson covers it all with clear, step-by-step demonstrations using unique datasets:

1-Anchor Dataset Link: https://docs.google.com/spreadsheets/d/1Earor6H1R6w3RsFIN44qX0bowDXJ45Fl/edit?gid=1003509453#gid=1003509453
2-Anchor Dataset Link: https://docs.google.com/spreadsheets/d/1EQjc9_nYBAEFkuduGO1lykN_bzzXzsCk/edit?gid=441059175#gid=441059175

Learn how to reshape your wide-format data into a tidy, analysis-ready structure for Power BI, and discover best practices for efficient data transformation. Perfect for data enthusiasts looking to master advanced unpivot techniques in Power Query!

🔑 Keywords: Unpivot Columns, Power Query Tutorial, Single Anchor Unpivot, Multi-Anchor Unpivot, Data Transformation, Power BI, Data Cleaning, Advanced Power Query Techniques.

📌 Don’t forget to subscribe for more Power Query lessons and elevate your data transformation skills!

How to Handle Single or Multi-Anchor Column in Power Query | Power Query Editor – 6 | Jeks Analytics

In this lesson, we focus on one of the most powerful features of Power Query: Grouping and Aggregating Data. Whether you are summarizing sales figures, calculating averages, or organizing data into categories, this tutorial has you covered!

You’ll learn:
✅ How to group data by one or multiple columns.
✅ Perform calculations like sums, averages, and counts within grouped data.
✅ Practical examples using real-world retail data (link to dataset: https://docs.google.com/spreadsheets/d/1-OBqE203ZAThnd-vBHCGUym2bNFWiNQW/edit?usp=sharing&ouid=101062614066382568785&rtpof=true&sd=true) to reinforce your understanding.

By the end of this lesson, you'll know how to turn raw datasets into meaningful summaries that drive insights for your reports and dashboards.

🔑 Keywords: Group data in Power Query, Aggregating data in Power Query, Power BI for beginners, Summarizing data in Power Query, Retail data analysis, Power Query tutorials.

📌 Don’t forget to subscribe for more Power Query lessons and take your data skills to the next level!

🌟 Explore the full Power Query playlist; the link is on the video.

Master Grouping and Aggregating Data in Power Query | Power Query Editor – 5 | Jeks Analytics

In this episode, we looked at the little exercise from Part 3 on Power Query. Whether you’re working with student scores or business data, you’ll see how simple transformations can turn raw data into meaningful insights.

You’ll learn:
✅ How to change data types and rename columns for clarity.
✅ The power of splitting and merging columns for cleaner datasets.
✅ Techniques to create conditional columns from your original data for analysis.

We’ll use student scores data to demonstrate how to transform raw tables into structured and insightful datasets as your assignment. See Link: https://docs.google.com/file/d/1-KwDXIT1F-ie5BkX_u2NmjPp8vGBEE6Q/edit?usp=docslist_api&filetype=msexcel

🔑 Keywords: Power Query data transformation, Splitting columns in Power Query, Handling dates in Power Query, Transforming student data, Power BI transformations, Data cleaning for beginners.

Assignment Solved with Power Query: Conditional Columns | Power Query Editor – 4 | Jeks Analytics

In this episode, we take a drive into data transformations with Power Query. Whether you’re working with student scores or business data, you’ll see how simple transformations can turn raw data into meaningful insights.

You’ll learn:
✅ How to change data types and rename columns for clarity.
✅ The power of splitting and merging columns for cleaner datasets.
✅ Techniques to create conditional columns from your original data for analysis.

We’ll use student scores data to demonstrate how to transform raw tables into structured and insightful datasets as your assignment. See Link: https://docs.google.com/file/d/1-KwDXIT1F-ie5BkX_u2NmjPp8vGBEE6Q/edit?usp=docslist_api&filetype=msexcel

🔑 Keywords: Power Query data transformation, Splitting columns in Power Query, Handling dates in Power Query, Transforming student data, Power BI transformations, Data cleaning for beginners.

Transforming Data with Power Query: Conditional Columns | Power Query Editor – 3 | Jeks Analytics

In this lesson, we tackle one of the most essential steps in data analytics: Data Cleaning! 🌟 Learn how to transform messy, raw datasets into polished, analysis-ready tables using the tools and features of Power Query.

You’ll learn:
✅ How to handle missing values, duplicates, and inconsistent formats.
✅ Practical steps to standardise text and numbers.
✅ Simple transformations to prepare clean, usable data for analysis.

We’ll use ChatGPT-generated messy sales data with the link: [https://docs.google.com/spreadsheets/d/1-PLZO2FcAKWQ0kAqUZE9YQxD_bZGGe01/edit?usp=sharing&ouid=101062614066382568785&rtpof=true&sd=true] to walk you through these processes step by step. By the end, you'll understand why data cleaning is crucial and how to do it effectively.

🔑 Keywords: Data cleaning in Power Query, Fix messy data, Data transformation basics, Power BI for beginners, Handling duplicates in Power Query, Standardizing data, Data cleaning tutorial.

📌 Don’t forget to subscribe for more lessons in our Power Query series!

Data Cleaning in Power Query: Handling Nulls & Duplicates | Power Query Editor – 2 | Jeks Analytics

In this tutorial, we’ll kick off our Power Query journey by exploring how to import data from different sources like Excel files, CSVs, and even web-based datasets! 🌐 Whether you're just starting out or looking to polish your data skills, this video is perfect for you.

You’ll learn:
✅ How to connect Power Query to Excel and CSV files.
✅ The steps to pull live data from a web-based source (World Population dataset).
✅ Pro tips to manage your imported data efficiently.

Master the foundation of data cleaning and transformation with Power Query and take the first step toward becoming a data superstar! 🌟

🔑 Keywords: Power Query for beginners, Import data in Power Query, Excel to Power Query, CSV data import, Web-based datasets, World population data, Power BI, and data cleaning basics.

👉 Subscribe for more tutorials, and let’s transform data like pros!

Importing Data in Power Query for Beginners | Power Query Editor – Episode 1 | Jeks Analytics

#excel #microsoftexcel #exceltips #dataconsistency #microsoftoffice #channel

Data Cleaning vs Data Transformation… What's the Difference?

Why we need your help?

We want to help to as
many as we can

Your support will bring
more energy

We always have believe in
team work

Trainings

Introduction to Data Analytics for Beginners

Getting Started with Excel

Data Transformation in Excel

Data Preparation in Power Query Editor

Power BI Dashboard for Beginners

Join Our Learning Community

Learning is better together. Join our WhatsApp group to:

Do you need help?

If you have any question,
Feel free to contact us

Connect With Us

95 FF3, App Street Avenue
NSW 96209, Canada

Opening Hours:

Mon – Fri: 8:00 am – 6:00 pm

Phone: 1800 123 4567

Email: demo@example.com

Service Request

Useful Links

City News & Updates

The latest Egovt news, articles, and resources, sent straight to your inbox every month.

Jeks Analytics © 2025. All Rights Reserved