Using the Data Model to Create Pivot Tables: 1-Hour Tutorial!

  Рет қаралды 37,951

Simon Sez IT

Simon Sez IT

Жыл бұрын

Download the free demo file and follow along here
➡️www.simonsezit.com/article/da...
In this Microsoft Excel tutorial, we'll walk you through creating PivotTables in Excel using the Data Model. We'll teach you what a data model is all about and discuss the Power Query editor. You will also learn how to add data to the data model, create a Pivot Table and Pivot Chart from the data model, and so much more!
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30 day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
Check out our FREE 300+ hour training course playlist here ➡️
🔥 • Simon Sez IT Long Trai...
💻Watch more popular tutorials from Simon Sez IT:
✅ PivotTable training here 👉 • Pivot Tables - All you...
✅Excel 2021 Tutorials for Beginners playlist
👉 • Excel 2021/365 Trainin...
✅Microsoft Excel Long Tutorials for Beginners, Intermediate, and Advanced Learners playlist
👉 • Microsoft Excel Traini...
✅ Data Analytics training here 👉 • Data Visualization - M...
💬Stay in touch!
✅SimonSezIT.com: 👉www.SimonSezIT.com/
✅StreamSkill.com: 👉StreamSkill.com/
✅KZfaq Channel: 👉 / simonsezittraining
✅LinkedIn: 👉 / simon-sez-it
🔔Subscribe to our channel:
👉kzfaq.info...
If you enjoyed the video, please give a "thumbs up" and subscribe to the channel 👍🏽 ;-)

Пікірлер: 34
@SimonSezIT
@SimonSezIT Жыл бұрын
We have additional free Microsoft Excel training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u and here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc and Top 10 Excel Functions Training 👉 kzfaq.info/sun/PLzj7TwUeMQ3isgpmQEWFwWqFZ95Ih-AhA 🔥Check out our FREE 300+ hour training course playlist here 👉kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@neccomputercenter458
@neccomputercenter458 25 күн бұрын
So Nice to Explain the Data Model to Create a Pivot Table. I say "Wow"
@SimonSezIT
@SimonSezIT 25 күн бұрын
Thank you for your kind words! I'm glad you found the explanation helpful. 🤩
@kamleshchandel6952
@kamleshchandel6952 10 ай бұрын
You are Amazing Deb and Ur voice is Mind blowing.. ur teaching style is Unique ....❤❤ I Love Ur teaching style Deb......🎉🎉🎉🎉
@SimonSezIT
@SimonSezIT 10 ай бұрын
Thanks a ton
@anarchistnoir1049
@anarchistnoir1049 Жыл бұрын
Thank you, this was a great lesson.
@anilworldwide
@anilworldwide 7 күн бұрын
Thanks Simon !
@SimonSezIT
@SimonSezIT 5 күн бұрын
Thank you for your support! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@panduislami7832
@panduislami7832 7 ай бұрын
Thank you Miss Deb, that's really helpful
@SimonSezIT
@SimonSezIT 7 ай бұрын
Thank you so much for your kind words! I'm happy to hear that my video was helpful to you. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@CaptainBlaine
@CaptainBlaine 8 ай бұрын
Thank you for making and sharing this!
@SimonSezIT
@SimonSezIT 8 ай бұрын
Thank you for watching and taking the time to leave a comment! It means a lot to us. 😊 We have additional free tutorials for various data analysis tools and services here 👉 kzfaq.info/sun/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@PhuongNguyen-sf3dx
@PhuongNguyen-sf3dx Жыл бұрын
Its really helpful for self-taught.Thank you so much 😍😍
@SimonSezIT
@SimonSezIT Жыл бұрын
Our pleasure 😊
@ivicapetrovic5072
@ivicapetrovic5072 Жыл бұрын
Thank you for great tutorial, it will save me time in future, you have new subscriber 😀
@SimonSezIT
@SimonSezIT Жыл бұрын
Thanks for the sub! 😊 We have lots of additional Excel training if you need it ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc ➡️ kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI and Pivot Table training here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@blancatorres173
@blancatorres173 Жыл бұрын
Thank you!
@SimonSezIT
@SimonSezIT Жыл бұрын
You're welcome!
@ismaelkourouma5558
@ismaelkourouma5558 Жыл бұрын
Thanks 👏👏👏
@SimonSezIT
@SimonSezIT Жыл бұрын
Welcome 😊
@matthewchu1
@matthewchu1 Жыл бұрын
Thank you for sharing. two quick questions - 1. What if we moved the folder or file location? would this data model lost connection? 2. What if the columns of the new transaction data file are in different sequence / format , would the data model still be able to capture the respective column? i.e. need to be in the exact same format to add new files?
@onsenguy
@onsenguy Жыл бұрын
Another awesome video. 👍 Question.. assuming cleanup steps were performed in power query for the 2019 data, will those same steps automatically cleanup 2020 and 2021 as well?
@dwarfusinterruptus9314
@dwarfusinterruptus9314 Ай бұрын
the link for the "FREE" downloads takes me to a login page and then a pay to register page, and not a page to download files.
@remuslupinhp
@remuslupinhp Жыл бұрын
Can we do the same thing using merge queries? I did merge query today on another dataset but not sure if it is the same or something different. Please help me by confirming, thanks 👍
@justinhare905
@justinhare905 4 ай бұрын
Can we have the datasets for practice because I don't find it in the link you provided below.
@surajagasti2309
@surajagasti2309 3 ай бұрын
Can I add this to my resume as a project?
@SUR-NI-VARA
@SUR-NI-VARA Жыл бұрын
Excellent Practicle way of Teaching !! I follow many Excel MVP since long, However this is the first session, which has explained me the entire process of Creating a Data Model from scratch. 💯👌Defenately userful for excel ethusiast like me. Actively seeking assistance on Multi Level Pie chart overlapping of Labels, I could find the solution by adding values from cell range! and moving the labels outside the Circle ! on by one, its a time consuming effort, Is there a vba code, which can automate this process! Kindly guid me on this. Thank you in advance for your support !
@beingrishi6450
@beingrishi6450 11 ай бұрын
Exceptional but we need datasets please do share Google drive
@Tat-cx1lr
@Tat-cx1lr 8 ай бұрын
Merci jolie voix.
@SimonSezIT
@SimonSezIT 8 ай бұрын
Thanks 🤗
@loose.electricity
@loose.electricity 8 күн бұрын
Any way to actually get the free demo file and follow along? The link goes to a paid subscription page now :/
@SimonSezIT
@SimonSezIT 5 күн бұрын
Download the free demo file and follow along here ➡️www.simonsezit.com/article/data-model-pivot-tables-webinar/
@user-xs9sh5co7k
@user-xs9sh5co7k 8 ай бұрын
Too much blah.....blah😢
@ahmedalloush1781
@ahmedalloush1781 Жыл бұрын
You are awesome 👌 🤍🤍 @Ashpy
How to use Power Pivot in Excel | Full Tutorial
30:38
Kevin Stratvert
Рет қаралды 1,4 МЛН
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Summer shower by Secret Vlog
00:17
Secret Vlog
Рет қаралды 9 МЛН
Despicable Me Fart Blaster
00:51
_vector_
Рет қаралды 27 МЛН
Advanced Pivot Tables in Excel: 1-hour Excel Pivot Tables Tutorial
1:08:00
Power Pivot Tutorial & Power Query in Excel - 1-Hour Class
1:02:30
Simon Sez IT
Рет қаралды 254 М.
Creating maps based on pivot table
3:47
Karl Ernst Buddenbrock
Рет қаралды 66 М.
10 Million Rows of data Analyzed using Excel's Data Model
10:57
Access Analytic
Рет қаралды 109 М.
12 Pro PivotTable Formatting Tricks = No more UGLY PivotTables!
12:12
MyOnlineTrainingHub
Рет қаралды 328 М.
Advanced Pivot Table Techniques (to achieve more in Excel)
11:47
Leila Gharani
Рет қаралды 1,9 МЛН
Excel Data Modeling - Stop Using XLOOKUP | Learn PowerPivot
10:41
Professor Cubs
Рет қаралды 77 М.
Don't use VLOOKUP. Use Merge Table or Data Model. Power Query and Excel.
13:53
Efficiency 365 by Dr Nitin
Рет қаралды 3,9 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 432 М.
Ultimate Excel PivotTables Tutorial: Beginner to Advanced - 3.5 Hours!
3:25:48
Kumanda İle Bilgisayarı Yönetmek #shorts
0:29
Osman Kabadayı
Рет қаралды 1,9 МЛН
НОВЫЕ ФЕЙК iPHONE 🤯 #iphone
0:37
ALSER kz
Рет қаралды 247 М.
ВАЖНО! Не проверяйте на своем iPhone после установки на экран!
0:19
ГЛАЗУРЬ СТЕКЛО для iPhone и аксессуары OTU
Рет қаралды 6 МЛН