Create a Data Model in Excel

In this video, I'll guide you through multiple methods to create a data model in Excel. You'll learn about using the Relationships tool, creating a data model with Excel Power Query, and applying Power Pivot. Creating a data model enables powerful relationships between data points, efficient handling of large datasets, comprehensive sales analysis, and accurate reporting and forecasting. With practical examples and step-by-step instructions, you can effortlessly make a data model in your own Excel spreadsheets.
👨‍🏫 Instructor: Hadi Ul Bashar
🎥 Editor: Mohammad Ullah
✨ ⯆ Resources:
Ctl+T - To insert Table
▬ Contents of this video ▬▬▬▬▬▬▬▬▬▬
0:00 - Intro
1:06 - Using the Relationships tool
7:08 - Creating a data model with Excel Power Query
14:15 - Applying Power Pivot
📚 ⯆ DOWNLOAD the workbook here:
www.exceldemy.com/create-a-da...
🌍 ⯆ Checkout the article here:
www.exceldemy.com/create-a-da...
💻 ⯆ Similar Videos:
• How to Create a Data T...
• How to Create a Table ...
🚩 Stay connected with us on social media for more Excel tips and tricks!
Facebook: / exceldemy
Twitter: / exceldemy
LinkedIn: / exceldemy
🙋‍♂️ Stuck with an Excel formula or a VBA code? You can post your questions or upload your Excel file to get in touch with the professionals and get the solution you need.
ExcelDemy Forum: exceldemy.com/forum/
👉 If you found this video helpful, don't forget to subscribe to our channel for more Excel tutorials, tips, and tricks! Hit the subscribe button and turn on notifications, so you never miss an upload. By subscribing, you'll be supporting our channel and helping us to reach more people who can benefit from our content. Thank you for watching, and we'll see you in the next video!
🔔 ⯆ Subscribe on KZbin:
/ @exceldemy2006
#excel #exceltutorial #exceltips #exceltricks

[@BoxCarWillieC2CBUTTERFIE-nw8pj]

Finally Got PP to work. I have been working with "append" tables. This is so much easier. TY. I need the calculation option.

[@exceldemy2006]

Dear, Thanks for your questions! We are glad to hear that you finally got Power Pivot working. This video focuses on creating data models using relationships between tables. However, depending on your goal, you can use DAX formulas within Power Pivot to create calculated columns or measures after appending your data.

[@kanhaiyashaha2182]

Very well explained…but curious to know why different methods are available? Is there any extensive use of data models created through power query i.e # 2 you explained?

[@exceldemy2006]

Dear, Thanks for your compliment! Your appreciation means a lot to us. Using Power Query to create a data model is particularly beneficial when preparing and cleaning your data extensively before analysis. It helps by automatically sorting out your data and ensuring it is clean and organized. This saves you a ton of time, especially if you're dealing with big piles of data that need a lot of work. Basically, the method you choose depends on your needs. If you want something simple, go for the primary process. Try the Power Query method if you need to clean up your data before using it.

[@justinhare905]

That's great.

[@exceldemy2006]

Hello @justinhare905, Thanks for your appreciation. Please stay connected with us. Regards ExcelDemy

[@satishreddy1497]

So we can get pivot table fields by three ways

[@exceldemy2006]

Hello @satishreddy1497, There are more than 3 ways to get pivot table fields these are: 1. Drag and Drop 2. Field List Checkbox Selection 3. Pivot Table Field List Pane 4. Right-Click Menu 5. Using Field Buttons 6. Keyboard Shortcuts 7. Excel VBA Regards ExcelDemy

[@DequanHarrison]

I understand the use case for using power query for automation. But, what are the advantages and disadvantages of using Relationship tool vs PowerPivot.

[@exceldemy2006]

Hello @DequanHarrison, In the video, we skipped the theory part, sorry for that. Here are the advantages and disadvantages of using the Relationship tool vs. PowerPivot in Excel: Relationship Tool: Advantages: 1. Simple for linking tables. 2. Suitable for simple data models without complex calculations. Disadvantages: 1. Lacks advanced features for complex data analysis. 2. May not efficiently handle large datasets or complex queries. PowerPivot: Advantages: 1. Supports complex calculations, measures, and KPIs. 2. Optimized for large datasets and complex models. Disadvantages: 1. Requires more advanced knowledge to use effectively. 2. Needs the PowerPivot add-on, which might not be available in all Excel versions. Regards ExcelDemy

[@BoxCarWillieC2CBUTTERFIE-nw8pj]

Is PP closer to PowerBI ? @@exceldemy2006

[@BoxCarWillieC2CBUTTERFIE-nw8pj]

Can you create simple video on working with calculations on tables with PP?@@exceldemy2006

[@exceldemy2006]

Dear, Thanks for your queries! Yes, Power Pivot is similar to Power BI. Both use the same core technology. However, Power BI is more advanced for making interactive reports and dashboards. If you know Power Pivot, Power BI will feel familiar and more powerful.

[@HimanshuSingh-lk2my]

For algorithm

[@edmel144]

What is a peckeo?

[@exceldemy2006]

Hello @edmel144, Here, "SalesPQ" and Executives PQ" are table names. You can use any name of your convenience. These tables are used in further calculations. Regards ExcelDemy