Thanks for watching! If you liked this and want to learn more, check out our self-paced courses, guided projects, and create your own free personalized learning plan! 👉 mavenanalytics.io/
PQ is extremely underrated! I’m an old fart - but was tasked with quite a large excel project requiring data from 3 sources on a weekly basis - and then sending out an individual email to each person on my team containing their personal metrics. Seriously, I had never used excel. In the beginning, manually entering all the data weekly and then creating a pdf page for each metric and then emailing all the info to each operator - took me 6-7 hours on a Monday. But with age comes wisdom - started watching TH-cam videos on the weekends… Leila, Randy Austin, this channel and a few more…. Holy cow! I learned VBA coding - and then PQ. What took me 6-7 hours to do now only takes me FIVE to SIX minutes each week! I applaud all the experts in this excel field and thank them all for the excitement I get when this old dog learns a new trick!
PQ, PP and DAX are pure heaven! People at my work are stunned what I can do with it. And frankly (and I don't say that off course), it's waaaaaaaaaaaay easier than all those pesky 30 foot long formules haha.
@@ferdirosa7547 it’s funny you mention a “30 foot long formula”! My very first formula was a MASSIVELY LONG “IF” formula - had probably 25 cases in it. The following week, I stumbled across VLOOKUP… changed everything! 🤣🤣🤣
Chris, Your tutorial on Power Query, Power Pivot and DAX is by far the best I've seen in TH-cam. Just when I think I've mastered Excel, I find your videos and realize there is a LOT more to learn! Thanks for producing this tutorial. I will have to check out your other training courses.
Sir. Chris Dutton, it is so great to find you here on TH-cam! I've watched much of your work including the 4hour DAX & Power Query CPE course you offered on LinkedIn Learning, and which I must say was simply priceless! It was my baptism by fire but totally did the trick. As such, I'm now happy to report that when it comes to Data Analysis and Expressions, I am eager and ready to hold my own any day, many thanks to your incredible professorial/ teaching skills!
This is by far the best Excel tutorial I have ever seen on TH-cam, and I've seen quite a few! Learned from this while performing my real life work following all these steps. Thanks!!!
What. I work with PowerBI for a year as a Business Analyst and only NOW I see what Power Query can do? I mean, I love excel and getting really good in PowerBI and DAX but this opens up a whole new dimension! Love it!
I attended a Udemy course where you explained how to get started with Power BI. It was amazing and I learned a lot from you. I love the way you teach --> straight to the point, getting down to the most important details. I just want to say thank you for the great job you are doing. By the way, this video is great too! Thanks again!!!
After following a course in Udemy with this guy I am passionate about the way he can explain stuff! I have done other courses with Maven, but this guy has a very nice, detailed but simple way of explaining. Keep up, I will try to follow this on youtube as well.
Thank you Chris for this amazing video. I always love your contents as there is something new to learn everytime. When it comes to Excel, you are the Best Excel Wizard I ever found. I hope you keep teaching Excel for a very long time 🙏
Enjoyed working through this example using the sample data provided and was really impressed with what can be achieved in excel without necessarily needing to use Power BI. Am in the UK so had an extra step to try to work out how to change the dates in the sales file from mm-dd-yyyy to dd-mm-yyyy. Thanks for the valuable content Chris!
@@Chris-at-Maven I eventually found that it is an easy step to highlight the date column in power query editor and right click the column header and select change type - using locale to date type and locale English (United States)
I do not have a clue of all that you said, but I finished the video. I use excel all the time in my 3d job, but data is kind of interesting too. Thank you. I will try to practice, and if I find it interesting, I will come back to this video.
I perfectly understand what you mean. It is Not easy at all to get hang of it if you work with flat files (all records in one single file). Check his video on database normalization. Efficient data storage is achieved with data kept in separate related tables/lists objects. PQ and PP are tools useful in typical data analytic workflow: Extract Data from different sources, Clean/transform, Load, Modelling (combine/link), Analyse/describe (summary stats, grouping/aggregate) and Visualize/Share
Great Vid, concise, to the point without side stories. The bosses will be amazed at the efficiency. But I fear a good performance would be rewarded with more of the same. Definitely use this, BUT don't let the bosses make the same request repeatedly. The first time is ok but politely let them know this can't be a habit. You work to live, not the other way around. I am SO GLAD I no longer have to work.
I just subscribed too! Thank you for including the DAX formulas for the calculated fields. This video was easy to understand and extremely useful. Thank you for saving me so much time!!!
I like this. I don’t currently use excel this way but it would be cool for some on the fly work. Normally what I would do is use python and pandas to insert the data into my sql server and then manage the query on the back end and re-run the process when new data source files are added. I could run this code whenever new files are added to a specific folder or sharepoint… that does take more time and you need to learn Python / vba / sql.
I am an upcoming data analyst and i really enjoyed this video and have also learnt a lot from it. My question is, how do I get the data that you used, so that i can also practice by myself. Keep it up. I have also subscribed
Thank you for the video. I use Dax formula to write Text over value for monthly status. That’s very helpful for users who use the text to track the expenses against the headcount. Btw, do you know how many DAX formulas are out there?
Great video! Thank you so much for putting it together! With the help of your video, I created a file that pulls data from several tables in an ODBC which requires monthly refreshing which does take a lot of time. - Is there any way to make it so that instead of ALL tables being refreshed, only certain ones do? - Is there a way to make it so that data within a table only refreshes from a specified date? For example, if the data for the years 2018 to 2023 is never going to differ from refresh to refresh, set it up so that that specific data doesn't change but everything since 01/01/2024 refreshes? Hopefully, I'm making sense. Thanks again!
Yes in the Queries & Connections pane you can right click a query, view properties, and deselect the "Refresh this connection on Refresh All" option. As for loading only incremental data, there are a few ways you could potentially approach it depending on the context. I'd recommend searching the Microsoft Answers Forum to explore some options!
Hi Maven, Thank you so much for the great work. Can you please share the source of the data you used for the analysis? I would like to practice with them. Thank you
This was a great breakdown of connecting some seemingly disparate features. One question I have, is it better to merge tables or just create a relationship via data model? In which case would one or the other be preferred. I have a data set that requires a ton of xlookups, but feel it might be overkill by merging all the tables into one. Thanks!
Stay away from binding/merging/combining/joining tables. That is the point of database, effient data storage and management. Just relax and rely on the keys to relate the relevant tables and leave the rest with DAX to perform the relevant calculations with the concerned fields in related tables. Ocasionally you may join one single or two fields from one table ou two tables. Not all fields
@@osoriomatucurane9511 fair, I only every join a field or two from each table, not trying to create some sort of master table. But as I am using more array formulas (filter, sortby, etc.) it feels like merging queries is actually easier than using power pivot/ data model. I guess it depends on the final output
In the data set, there are different currencies. Does Excel automatically converts any other currency to USD based on the actual exchange rate at the time of opening the document?
hello, on the DAX revenue formula, how is it determining which quantity row matches the price row in the other table? also, what is the reason for a calendar table when you can use the date from the quantity table, then group in the power pivot by month if you wanted? thanks!
Good questions! For the Total Revenue formula, the RELATED function acts like a lookup, that basically traverses the relationship between the Sales and Products tables to retrieve the correct unit price for each row in the Sales table. As for the calendar table, it's much more flexible (and scalable) to have a dedicated table containing any date/time fields you might need, including ones that aren't available in the default PivotTable grouping tools. I also tend to avoid PivotTable grouping because a) it can get messy, and b) those grouped fields ONLY exist in the context of that pivot, and can't be used in other measures (this is the same reason we always recommend explicit vs. implicit measures). Hope that helps!
Thank you for this video. It provided some use full information. Will I be able to use 1 sheet with 1 data table and convert it to power query, or does this tool mostly work with multiple data sources big data type scenario. I am creating a more interactive and details budget dashboard and would like to try this if it means to improve the performance and the formula structure... cause excel formulas that i used are crazy
Thanks ,some pretty good tips , But I have some problems following 1-My Sub- categories split out in another column 11:47 2- Dax Formula always gives an error , I wish I could upload screen shots.
Thanks for this great insight I follow through but had issues with the Ordered dates in the sales sheet from the file you shared. It has errors meanwhile the one you used to demonstrate does not. Is there a reason for this?
Great and informative video! A question: Wouldn't it be possible to do all the steps in Power Query? E.g. use the 'Merge' function in PQ instead of building relations in Power Pivot. The reason I am asking is that when you merge big datasets i PQ it often gets very slow so maybe this method with using Power Pivot is a better practice - or is it more to show the different options available? Thx
Hello Sir, Thank you for your useful videos on dax. Sir, when to combine ALL function with Calculate + Filter Function together in Dax ? Could you please make a video of it in detail soon 🙏 !
I hope the course would have screencap or descriptions of what to do on each step so we don’t have to pause the video to see what we need to input on keyboards to follow the work. This is an illustration of I mean on the STEP1: Connecting data with Power Query - 04:39 - Connecting to a CSV File o Data/ Input- Sales w/s/ Transform o View/ the column quality, col distribution, col profile o home / close and load to / Only Create Connection + Add this data to the Data Mode o o Data/ Input- Product w/s/ Transform o View/ the column quality, col distribution, col profile o home / close and load to / Only Create Connection + Add this data to the Data Mode o - 05:53 - Connecting to a PDF o Select entire folder o View/ the column quality, col distribution, col profile o Col ID/ unselect Page001, Page002 o Col Date/ expand tables o Remove the other col (except col 1 -3) o Home/ Use first row as Header o Rename PROPERTIES “Stores” o home / close and load to / Only Create Connection + Add this data to the Data Mode o - 07:26 - Creating a Calendar Table o Right click “Queries & Connections”/ Duplicate sales o Delete all col except “Order_Date” o Rename col “Date” o Rename PROPERTIES “Calendar” o Add Col/ Date/ Day/ Name of Day o Add Col/ Date/ Week/ Start of Week o Add Col/ Date/ Month/ Start of Month o Add Col/ Date/ Year
Thanks for watching! If you liked this and want to learn more, check out our self-paced courses, guided projects, and create your own free personalized learning plan! 👉 mavenanalytics.io/
Can I use your course for free
as I am unemployed since long. I want to learn from you.
Hi, os cohort learning incluyes in the pro subscription maven pro?
PQ is extremely underrated! I’m an old fart - but was tasked with quite a large excel project requiring data from 3 sources on a weekly basis - and then sending out an individual email to each person on my team containing their personal metrics.
Seriously, I had never used excel. In the beginning, manually entering all the data weekly and then creating a pdf page for each metric and then emailing all the info to each operator - took me 6-7 hours on a Monday.
But with age comes wisdom - started watching TH-cam videos on the weekends… Leila, Randy Austin, this channel and a few more…. Holy cow! I learned VBA coding - and then PQ. What took me 6-7 hours to do now only takes me FIVE to SIX minutes each week!
I applaud all the experts in this excel field and thank them all for the excitement I get when this old dog learns a new trick!
PQ, PP and DAX are pure heaven! People at my work are stunned what I can do with it. And frankly (and I don't say that off course), it's waaaaaaaaaaaay easier than all those pesky 30 foot long formules haha.
@@craigwatkins2285 Impressive!
Thanks for the testimony.
@@ferdirosa7547 it’s funny you mention a “30 foot long formula”! My very first formula was a MASSIVELY LONG “IF” formula - had probably 25 cases in it. The following week, I stumbled across VLOOKUP… changed everything! 🤣🤣🤣
This is the most valuable channel I’ve subscribed to on TH-cam. Thank you!
Chris, Your tutorial on Power Query, Power Pivot and DAX is by far the best I've seen in TH-cam. Just when I think I've mastered Excel, I find your videos and realize there is a LOT more to learn! Thanks for producing this tutorial. I will have to check out your other training courses.
Thank you!
Sir. Chris Dutton, it is so great to find you here on TH-cam! I've watched much of your work including the 4hour DAX & Power Query CPE course you offered on LinkedIn Learning, and which I must say was simply priceless! It was my baptism by fire but totally did the trick. As such, I'm now happy to report that when it comes to Data Analysis and Expressions, I am eager and ready to hold my own any day, many thanks to your incredible professorial/ teaching skills!
Can you provide a link for this course?
This is by far the best Excel tutorial I have ever seen on TH-cam, and I've seen quite a few! Learned from this while performing my real life work following all these steps. Thanks!!!
Chris is truly legendary and if you haven't seen any of his full courses on Linkedin Learning etc, you really ain't seen nothing yet.
Hey, thanks. Long term excel user but not PQ PP or DAX user. Very helpful!
What. I work with PowerBI for a year as a Business Analyst and only NOW I see what Power Query can do? I mean, I love excel and getting really good in PowerBI and DAX but this opens up a whole new dimension! Love it!
I attended a Udemy course where you explained how to get started with Power BI. It was amazing and I learned a lot from you. I love the way you teach --> straight to the point, getting down to the most important details. I just want to say thank you for the great job you are doing. By the way, this video is great too! Thanks again!!!
Thank you so much!
This is the most powerful video on Data Analysis i have watched. Amazing! thank you so much
So glad to hear that - thanks for the feedback!
If you wanted to show that you know what you’re teaching, you nailed it
Fantastic overview! This was quick and thorough, exactly what I was looking for! Thank you!
Amazing mate, this is the most informative video I’ve come across about Data Analytics…a Big Thank You!
After following a course in Udemy with this guy I am passionate about the way he can explain stuff! I have done other courses with Maven, but this guy has a very nice, detailed but simple way of explaining. Keep up, I will try to follow this on youtube as well.
He is the best, BUT, Leila Gharani is defenitly number two!
I'm on 65% on your Udemy course. This feels like a good refresher for the past lessons.
This is amazing! Thankyou for sharing your knowledge!
i subscribed after watching this. ive never seen how power pivot and dax are used in excel. very helpful video.
Thanks for subscribing!
Thank you Chris for this amazing video.
I always love your contents as there is something new to learn everytime.
When it comes to Excel, you are the Best Excel Wizard I ever found.
I hope you keep teaching Excel for a very long time 🙏
Thank you very much, I appreciate it!
I found your explanations simple and easy to follow, Thanks for sharing.
Hi Chris, I did several of your courses on Udemy. These are absolutely the best tools that I use in my work daily. THANK YOU THANK YOU!
Maven Analytics?
YOU ROCK.
Mav A For PRESIDENT.
AWESOME WORK BRO.
Haha thank you!
YOU DID GREAT SIR.... WOW! AMAZING TUTORIAL, Liked and Subscribed Sir.
Enjoyed working through this example using the sample data provided and was really impressed with what can be achieved in excel without necessarily needing to use Power BI. Am in the UK so had an extra step to try to work out how to change the dates in the sales file from mm-dd-yyyy to dd-mm-yyyy. Thanks for the valuable content Chris!
Nice! Did you use Power Query's locale option, or manipulate the actual date values?
@@Chris-at-Maven I eventually found that it is an easy step to highlight the date column in power query editor and right click the column header and select change type - using locale to date type and locale English (United States)
@@Anthony50009 nice, that’s what I would have suggested trying first 👏
I am also from UK
Hands down to the best channel on YT
thank u for best project demonstration .. u made t simple .. God bless u.. would u make more project tutorials plz ?????
Great help. You really make my things easy through very interactive and easy-to-understand simulations.
Glad you found it helpful!
Wanna like this thousand times the best teacher❤️
Thank you for the feedback! :)
Nice work. Not only was the data analysist work explained well, the presentation is top notch.
Glad you liked it!
Glad you found it helpful!
It's Chris from MAVEN. What did you expect? He's an Excel Rock Star!
I'm definitely doing this course next. I'm so excited. I'm going to solve so many problems!
I do not have a clue of all that you said, but I finished the video. I use excel all the time in my 3d job, but data is kind of interesting too. Thank you. I will try to practice, and if I find it interesting, I will come back to this video.
Data rules!
I perfectly understand what you mean. It is Not easy at all to get hang of it if you work with flat files (all records in one single file). Check his video on database normalization.
Efficient data storage is achieved with data kept in separate related tables/lists objects.
PQ and PP are tools useful in typical data analytic workflow: Extract Data from different sources, Clean/transform, Load, Modelling (combine/link), Analyse/describe (summary stats, grouping/aggregate) and Visualize/Share
Thank you for making such a amazing tutorial.
Great Vid, concise, to the point without side stories. The bosses will be amazed at the efficiency. But I fear a good performance would be rewarded with more of the same. Definitely use this, BUT don't let the bosses make the same request repeatedly. The first time is ok but politely let them know this can't be a habit. You work to live, not the other way around. I am SO GLAD I no longer have to work.
tell them you worked all weekend and take Monday off 🙂
@@PatrickBateman12420 I no longerwork.
In one video i have learn alot, Thank you so much
Wow I'm blown.. learned much much..keep sharing your skills 🙏
This is just mind-blowing 🤯
Crazy powerful tools! 💪
This is Amazing, I got to know how I can swiftly use Power Tools in just 17 minutes. Thanks,
I just subscribed too! Thank you for including the DAX formulas for the calculated fields. This video was easy to understand and extremely useful. Thank you for saving me so much time!!!
Glad you found it helpful, and thanks for subscribing!
Great intro, thanks.
Fantastic! Super powerful if you know what to do!
Solid tutorial; super helpful! any additional videos on DAX specifically?
That's the best tutorial ever! So clear. Thank you!
Thank you
I like this. I don’t currently use excel this way but it would be cool for some on the fly work.
Normally what I would do is use python and pandas to insert the data into my sql server and then manage the query on the back end and re-run the process when new data source files are added. I could run this code whenever new files are added to a specific folder or sharepoint… that does take more time and you need to learn Python / vba / sql.
I just subscribed.Whoa! You are amazing
Great demo!!!
Simply Love it Chris! Thanks for showing Want more on DAX calculations thnks in advance
I am an upcoming data analyst and i really enjoyed this video and have also learnt a lot from it. My question is, how do I get the data that you used, so that i can also practice by myself.
Keep it up. I have also subscribed
Wonderful, without PowerbI, Excel itself has all facilities like PBI. Great learning today, thanks a lot.
Cannot disappoint as always. Super!
Glad you found it helpful!
This makes excel so much easier to use. I hate all the formulas. Tysm
Awesome! This is one of best educational video I have ever seen. Thank you so much.
Glad it was helpful!
Wow this was fascinating!! I never knew excel was so awesome. THANK YOU!!
It really is!
That was total AWESOMENESS!!!!!
Glad you found it helpful!
This was crazy. Good job.
Thanks Chris, I've follow you from LinkedIn course.
Excellent content and presentation. Subscribed. Interested in learning more!
As always👏 Thank you for this awesome content.
Glad you enjoy it!
Wow this is the best presentation I´ve seen from a Data Analyst on YT, you´ve just gained 1 more subscriber. Well done Sir!
Great content you’re sharing!
This tutorial is a game-changer for me! Thank you
I bought your course still i am watching it is very nice
Awesome. Thank you very much. The best teacher 🙏
Thank you!
Simple, fast and straight to the point 👏🏻👏🏻
Thank you for the video. I use Dax formula to write Text over value for monthly status. That’s very helpful for users who use the text to track the expenses against the headcount.
Btw, do you know how many DAX formulas are out there?
Great. However, I would argue that the value from DAX is being able to combine different tables for calculations ...
This is awesome. Thanks Chris
Thank you!
Amazing video, learned so much
Great work only I have problems with pdf file I am using Excel 2019 no choice to insert pdf data if changes to Excel CSV better to complete practice
Excellent work maven made this look so simple
Believe me, if you study this, it IS waaaaaaaaaaaaaaaaaaaay simpler then formulas.
Great video! Thank you so much for putting it together!
With the help of your video, I created a file that pulls data from several tables in an ODBC which requires monthly refreshing which does take a lot of time.
- Is there any way to make it so that instead of ALL tables being refreshed, only certain ones do?
- Is there a way to make it so that data within a table only refreshes from a specified date? For example, if the data for the years 2018 to 2023 is never going to differ from refresh to refresh, set it up so that that specific data doesn't change but everything since 01/01/2024 refreshes?
Hopefully, I'm making sense. Thanks again!
Yes in the Queries & Connections pane you can right click a query, view properties, and deselect the "Refresh this connection on Refresh All" option.
As for loading only incremental data, there are a few ways you could potentially approach it depending on the context. I'd recommend searching the Microsoft Answers Forum to explore some options!
@@Chris-at-Maven thanks Chris!
Thank you, Chris.
Thanks so much! This is really helpful!
Amazing 👏 thank you
Hi Maven,
Thank you so much for the great work. Can you please share the source of the data you used for the analysis? I would like to practice with them. Thank you
Link in the description!
Amazing presentation! Some great learning i got here!! Definitely following your work from now.
Amazing to see this great tutorial ♥
Thank you so much, Chris.
Great Video Maven !!!
This was a great breakdown of connecting some seemingly disparate features. One question I have, is it better to merge tables or just create a relationship via data model? In which case would one or the other be preferred. I have a data set that requires a ton of xlookups, but feel it might be overkill by merging all the tables into one. Thanks!
Stay away from binding/merging/combining/joining tables. That is the point of database, effient data storage and management. Just relax and rely on the keys to relate the relevant tables and leave the rest with DAX to perform the relevant calculations with the concerned fields in related tables.
Ocasionally you may join one single or two fields from one table ou two tables. Not all fields
@@osoriomatucurane9511 fair, I only every join a field or two from each table, not trying to create some sort of master table. But as I am using more array formulas (filter, sortby, etc.) it feels like merging queries is actually easier than using power pivot/ data model. I guess it depends on the final output
In the data set, there are different currencies. Does Excel automatically converts any other currency to USD based on the actual exchange rate at the time of opening the document?
hello, on the DAX revenue formula, how is it determining which quantity row matches the price row in the other table?
also, what is the reason for a calendar table when you can use the date from the quantity table, then group in the power pivot by month if you wanted? thanks!
Good questions! For the Total Revenue formula, the RELATED function acts like a lookup, that basically traverses the relationship between the Sales and Products tables to retrieve the correct unit price for each row in the Sales table.
As for the calendar table, it's much more flexible (and scalable) to have a dedicated table containing any date/time fields you might need, including ones that aren't available in the default PivotTable grouping tools. I also tend to avoid PivotTable grouping because a) it can get messy, and b) those grouped fields ONLY exist in the context of that pivot, and can't be used in other measures (this is the same reason we always recommend explicit vs. implicit measures).
Hope that helps!
Amazing but not as beautiful as Tableau, although its so much cheaper though. Many thanks for this mate.
Thanks Bro. you are one in a million
Great video, thanks!!
Thank you for this video. It provided some use full information. Will I be able to use 1 sheet with 1 data table and convert it to power query, or does this tool mostly work with multiple data sources big data type scenario. I am creating a more interactive and details budget dashboard and would like to try this if it means to improve the performance and the formula structure... cause excel formulas that i used are crazy
Awesome Thx for sharing
Yes💪, I did it. Thank You very much .
How to add “$” sign in front of sales number, i.e: 50.55M when I coded the 50,550,000 in format cell-> custom format -> 0.00M
Wow! so valuable is this video!😮😮 Amazing!! 🎉🎉🎉 Thanks!!
Thanks ,some pretty good tips , But I have some problems following
1-My Sub- categories split out in another column 11:47
2- Dax Formula always gives an error , I wish I could upload screen shots.
Thanks for this great insight
I follow through but had issues with the Ordered dates in the sales sheet from the file you shared.
It has errors meanwhile the one you used to demonstrate does not.
Is there a reason for this?
Great and informative video!
A question: Wouldn't it be possible to do all the steps in Power Query? E.g. use the 'Merge' function in PQ instead of building relations in Power Pivot.
The reason I am asking is that when you merge big datasets i PQ it often gets very slow so maybe this method with using Power Pivot is a better practice - or is it more to show the different options available?
Thx
You could, but generally speaking merging tables is much less performant than configuring relationships in the data model
This was awesome
Glad you enjoyed it!
Hello Sir,
Thank you for your useful videos on dax.
Sir, when to combine ALL function with Calculate + Filter Function together in Dax ?
Could you please make a video of it in detail soon 🙏 !
Use ALL when you want to override any existing filter context (like forcing a grand total calculation, for example)
Very useful tutorial,👍👍👍
Thanks for the feedback!
Thank you so much. simple and worth learning.
SumProduct will also do that DAX thing you did.
Very nice work, thanks
Thanks for the amazing video
This is one of the least understood but most powerful features in Excel
I hope the course would have screencap or descriptions of what to do on each step so we don’t have to pause the video to see what we need to input on keyboards to follow the work.
This is an illustration of I mean on the STEP1: Connecting data with Power Query
- 04:39 - Connecting to a CSV File
o Data/ Input- Sales w/s/ Transform
o View/ the column quality, col distribution, col profile
o home / close and load to / Only Create Connection + Add this data to the Data Mode
o
o Data/ Input- Product w/s/ Transform
o View/ the column quality, col distribution, col profile
o home / close and load to / Only Create Connection + Add this data to the Data Mode
o
- 05:53 - Connecting to a PDF
o Select entire folder
o View/ the column quality, col distribution, col profile
o Col ID/ unselect Page001, Page002
o Col Date/ expand tables
o Remove the other col (except col 1 -3)
o Home/ Use first row as Header
o Rename PROPERTIES “Stores”
o home / close and load to / Only Create Connection + Add this data to the Data Mode
o
- 07:26 - Creating a Calendar Table
o Right click “Queries & Connections”/ Duplicate sales
o Delete all col except “Order_Date”
o Rename col “Date”
o Rename PROPERTIES “Calendar”
o Add Col/ Date/ Day/ Name of Day
o Add Col/ Date/ Week/ Start of Week
o Add Col/ Date/ Month/ Start of Month
o Add Col/ Date/ Year
Awesome, thanks
Glad you enjoyed it!