🎯 Key Takeaways for quick navigation: 00:00 📚 The video covers the content of the DA-100 exam, which focuses on analyzing data with Microsoft Power BI. 01:16 📝 The DA-100 exam is for those who want to become data analysts, leverage data in their organization, or learn Power BI. It costs $165, lasts 2.5 hours, and requires a passing score of 70. 02:24 🤐 The speaker couldn't reveal specific exam details due to a non-disclosure agreement, but typically, the exam contains 40 to 60 questions. 03:38 🕒 The time required to prepare for the exam varies: 3-7 days for experienced users, 2-3 weeks for those in sales, finance, or IT, and 30 days for beginners. 04:25 📋 The content outline for the DA-100 exam includes preparing data, modeling data, and visualizing data. Preparing data involves getting data from various sources and analyzing it. 05:36 📊 Visualizing data in Power BI includes creating reports, dashboards, and using filters, tooltips, and bookmarks to enhance reports. 05:51 📈 Analyzing data includes enhancing reports for insights, making reports interactive, and utilizing AI functionalities in Power BI. 06:04 🚀 Deploying and maintaining deliverables covers Power BI service, workspaces, deployment pipelines, subscriptions, and scheduled refresh. 07:29 💻 Power BI Desktop is where you load, transform data, create relationships, and build visuals in the report segment. 08:00 🗄️ Power Query M is used for data transformation in Power Query Editor, while DAX is used for creating measures and calculated columns in Power BI reports. 09:27 🔄 You can load data into Power BI Desktop using either the import mode or direct query mode, each with its advantages and limitations. 11:43 🔄 Parameters in Power BI allow for dynamic filtering and switching between data sources or environments. 14:29 🔄 Power BI provides various options for connecting to different data sources, including files, databases, Power Platform, Azure, and online services. 15:23 🧼 Data quality is essential in Power BI. You can assess data quality in Power Query Editor using data preview, column quality, and column distribution. 17:03 ❓ Unique values appear only once, while distinct values represent the number of categories in a column. 19:24 🧩 You can combine data in Power Query Editor by appending or merging queries, with various join types available for merging. 21:19 🔄 Transposing moves columns to rows, pivoting changes rows into columns, and unpivoting changes columns into rows. 24:53 💼 Data types are important in Power BI, and you can change them in the Power Query Editor. Handling blanks, empty strings, and zero values is crucial. 28:37 📝 You can add or delete columns and rows in Power Query Editor using options like "Remove Columns" and "Add Custom Column." Conditional columns and custom functions are also available for adding columns. 31:03 📊 Conditional columns can be added in Power Query Editor to categorize data based on conditions, such as marking products as premium if their price is above a certain threshold. 32:30 📈 Index columns are useful for adding a row counter to your dataset, which can be handy for advanced analysis. 33:27 📋 Applied steps in Power Query Editor represent the transformations applied to data and are displayed in order of execution. 34:24 🧩 Power Query M language includes over 750 functions, but focusing on commonly used ones is more practical. 35:52 📚 The video covered topics related to preparing data, understanding differences between Power BI Desktop and Power Query Editor, import options, data profiling, and using built-in functions. 37:37 📊 Understanding relationships, cardinality, and filter propagation in Power BI is crucial for effective data modeling. 40:15 📈 Active and inactive relationships in Power BI can impact data modeling and should be managed carefully. 43:25 🔄 Cross filter direction in Power BI relationships determines how data filters propagate, affecting how visuals display information. 47:11 🧮 Power BI allows you to create calculations using measures and calculated columns to extract insights from data. 49:01 📈 Measures and calculated columns serve different purposes in Power BI, with trade-offs in terms of storage and performance. 52:43 📊 Power BI offers a wide range of DAX functions categorized by type, including statistical, logical, date, and relationship-related functions. 55:34 📊 The visualization pane in Power BI allows you to choose from various visualizations and customize them to convey data insights effectively. 56:39 📈 Power BI provides a diverse set of visualizations, including line charts, bar charts, pie charts, matrices, and many more, each suited for different data representation needs. 01:00:00 📊 Power BI dashboards are concise, one-pager views that can display selected visuals from reports, allowing users to focus on key information. 01:02:26 🔍 Filters in Power BI are essential for controlling what data is displayed in reports, allowing you to focus on specific aspects of your dataset. 01:03:08 📊 Power BI allows you to filter and evaluate top-performing stores by adding return fields and applying filters. 01:03:39 🧩 Edit interactions in Power BI visuals using filter, highlight, or none options to control how visuals impact each other. 01:05:25 📅 Use slicers to empower users to choose specific data, such as dates or categories, to analyze in Power BI. 01:07:16 🔄 Sync slicers across multiple pages in Power BI to ensure slicer effects are consistent throughout the report. 01:08:18 📚 Bookmarks in Power BI allow you to freeze and save specific visualizations for later use, helpful for presentations and complex reports. 01:09:30 📝 Tooltips provide extra information to users when hovering over visuals in a Power BI report, enhancing the user experience. 01:10:13 ⏩ Drill-through in Power BI enables users to access underlying data, offering more detailed insights into specific aspects of a report. 01:11:19 📃 Page Native Reports in Power BI allow structured document creation, typically used in a business context for invoices or other structured documents. 01:14:36 🚀 Optimize Power BI performance with six golden rules, including using measures over calculated columns and avoiding wide datasets. 01:16:03 📊 Use Power BI's Performance Analyzer to analyze load times and performance issues in your report. 01:17:38 🌐 Configure gateway connections for on-premises or cloud data sources that Power BI can't access directly. 01:18:56 🔄 Schedule data refreshes in Power BI Service, with options for daily, weekly, or monthly updates. 01:20:06 📝 Use Text Analytics in Power BI to perform sentiment analysis, keyphrase extraction, and language detection on textual data. 01:21:38 📷 Power BI's Vision feature can tag images, helping identify objects or elements within images. 01:22:06 🧠 Leverage Azure Machine Learning to incorporate custom machine learning models into your Power BI reports. 01:23:33 🔄 Schedule data refreshes during less busy times, consider data volume, and optimize data sets for better Power BI performance. 01:32:09 📊 Row Level Security: Use DAX to specify which roles can see limited data based on specified criteria, like username or user principal name. 01:34:36 🔐 Sensitivity Labels: Add sensitivity labels to data and reports to increase security awareness and prevent unauthorized sharing. 01:35:35 🚀 Promotion and Certification: Promote reports for easy access by co-workers and certify data sets that meet organizational criteria for broader use. 01:36:30 💾 Large Data Set Storage: Enable large data set storage formats for handling large data volumes, especially useful on premium capacity. 01:37:49 🏢 Workspaces: Collaborate and organize reports, data sets, and users within workspaces, each with distinct roles like admin, member, contributor, and viewer. 01:41:18 🔄 Deployment Pipelines: Use deployment pipelines to manage the development, test, and production phases of your reports or models. 01:42:40 🧮 Data Flows: Create reusable data flow processes to collect, transform, and share data sets within Power BI while controlling data source access. 01:44:00 📱 Configuring and Updating Apps: Apps allow broad distribution of content; create, configure, and set permissions for apps in Power BI service. 01:44:54 📧 Subscriptions: Set up subscriptions to receive periodic emails based on report updates, and choose frequency based on your license and report ownership. 01:46:53 📚 Exam Preparation: Practice key concepts, especially DAX functions like calculate, summarize, and group by, to prepare for the PL-300 exam. Made with HARPA AI
More context that helped me: Distinct shows how many values are in the column if you remove the duplicate, while Unique shows how many values appeared just once.
i passed the exam with this tutorial, its definitely cover most of the key concept! i only refreshed the dax methods that u suggested!! its really helped me to answer most of them!! but going to exam alone with this course, i wont recommend it, referring the documentation suggested by the instructor will definitely help! getting experienced with question bank is crucial!
I'm studying for my exam, and watching 30 mins of this video has already helped me double my scores in the practice exams. Thank you so much for sharing this knowledge!
@@ebrahimshafiei6201 I got the Pearson Vue one that was recommended by Microsoft. After taking the exam, I don't recommend it. The free exams you find online are better.
Yesterday, I have passed the exam PL-300 from first attempt. My background is purely focusing on finance and investment banking. This video helps me a lot passing the exam as recap after studying the free material on Microsoft website related to Power BI. Thanks a lot for sharing the video and I really appreciate it.
Hello Abdulmajeed, Congratulations on passing the exam! Please help me with the link for the free material on Microsoft Website related to Power BI. Thank you. I am about to start preparing for the exam
Thank you for making this video. It is very helpful. I have passed the exam. I studied from your video and praticed dump questions on Examtopics. Thanks again 😊
Thanks a lot for this Exam-centric treatise! As for the sound level issue, there is no problem on my side...it is coming out loud and clear! I sympathize with those who are facing audio-related issues...sorry for that...and to all those who have passed the Exam/Certification...Congratulations & Celebrations! Additionally, to all those who are planning to test the waters...here's to your SWEET $UCCE$$ & RESOUNDING VICTORY! Way to go all of you PBI DAs, if I may! Kudos!
Btw, it's possible to pass it with 4 days of studying and no prior experience. Fantastic video that covered a lot of what's on the test. This video plus some tutorial and hands on tinkering with the platforms is enough to get you there. Thanks again!
thanks to the author, very useful. However there are some concepts which are contradicting with power bi fundamental concepts. The one is "more rows and less columns is better". According to the DA-100 of Maslyuk, instead, to reduce the column cardinality and improve performance, we need to split, columns into two, for example, date and time to Date and Time columns, because power bi is more a columnstore database, and by splitting we remove the column cardinality. Overall, want to ay huge thanks for this material - a great summary.
Thanks for creating this overview. One remark/error though: At 1:10:00, you say you will be showing drill through, but in the report, you are actually showing the drill down feature. Drill down is different from drill through though (as can also be seen in the documentation shown at 1:10:50).
Great Video. Quick note: Subscription is not a premium function. There are parts of subscription which are, but you can subsribe yourself or others in the organisation, at least as the author.
Good job gathering all these informations and spread you knowledge. Keep the good work ^^ What is your plan with this channel are you going to upload more videos about Power BI ?
very informative thanks. can you tell me where I can get the data tables etc that you are using? It would be helpful to follow along while watching the video.
Hi Does the exam ask for steps in Power BI? What I have to click to achieve something? There are many practical examples and exercises in the learning path. Are these relevant to the test as well? Does anyone have any general tips for the Microsoft exams? Thanks
Awesome Video. I was struggling to seggregate which topic falls under which category. This made easy. Is it possible for us to get the subject material used to explain the video?
This course is amazing!!! Is the material you used in this video yours or in the public domain? If you didn't mind sharing it would be a lot of help in my studies for the DA-100 in august 21.
I would like to ask a question if anyone can help. I have no experience in data analysis. I took the google data anaytics certificate from coursera and thats about it. I want to get the microsoft certification but from what Ive seen, most of them got experience in their field. What would be the best advice to study for the certification if I have no experience.
Hi Very helpful session , it covers topics required for exam. I am about to take the exam and I have one query. Currently Iam in US. I already have an microsoft account with India details like address etc. Can I use the same account for the exam where I can pay money in Indian currency. Please advice if I can do like that.
Great content and I learned a lot; however, just work on keeping you voice at the same level. You tend start speaking at a decent level, but then slowly begin to speak too softly.
@@callfordata7378 Here's my experience with Audacity...first, I start recording for a very short duration...pause it...then I rewind and play (while looking at the audio waveform levels)...and once I am fully satisfied with this vert short recording...I proceed. I also use this very same method with Screen+voice recordings and I am very satisfied with the output quality for potential and future listeners. Moral of the story...never ever assume that it will all go fine, vis-a-vis the output quality! Do a test recording first and foremeost...and then go ahead without any qualms whatsoever. God BLESS all!
@Hoss SATOUR After doing some research, Microsoft indeed disclosed the validity of the DA-100 exam will be limited to 1 year for those who obtained their certification after June 30th, 2021. docs.microsoft.com/en-us/learn/certifications/certification-expiration-policy
@@callfordata7378 Hi i already purchase memberhip on your patreon, but i can't find the link to download the presentation. Can you help me? I already message you on patreon. Please i need it fast
@@callfordata7378 Thanks. I got the PDF. But I hope you post more new content so I can rejoin. Your presentation material is good-concise and clean. I would be interested in more PowerBI/DAX/Data Flows and other tools like SSIS, SSAS, SSRS, Azure Data Factory-Data Integration. Python, R etc. if those tools are in your realm of expertise.
Can anyone please clarify if this course sufficient to clear PL-300 as it is a new Exam and replacement of DA-100? So will this course suffice for PL-300 exam too?
Hi Rajat! I can confirm that this course will provide a solid basis to tackle the PL-300 exam, but I also advise you to watch some other videos on areas where you feel like you are lacking. For most people, this is often DAX, data modeling & data transformations.
Entire exam content is mentioned throughout this video. There’s a lot of people requesting the ppt so I created a Patreon page for this purpose. Hope this clarifies it.
Hi, I'm planning to give an exam PL300 possibly this month. My doubt is this course helpful for PL300 as well? Do DA100 and PL300 contains the same set of contents?
![Conquering PL-300: Power BI Data Analyst Certification 📈 [Full Course]](http://i.ytimg.com/vi/BDGzVpt1xCg/mqdefault.jpg)
![Conquering PL-300: Power BI Data Analyst Certification 📈 [Full Course]](/img/tr.png)
![Hands-On Power BI Tutorial 📊Beginner to Pro [Full Course] ⚡](http://i.ytimg.com/vi/5X5LWcLtkzg/mqdefault.jpg)
I passed my exam today, this video was so helpful, thank you
Woow, congrats & good luck on your Power BI jouney ;)
Hello, congratulations. I'd like to know what were your study materials?
Hi, did you go through MS documentation as well, referred any other material or was this video enough?
How tough the exam is for any non IT person. Please advise?
Congratulations, could u please share with me exam questions please? For preparing
🎯 Key Takeaways for quick navigation:
00:00 📚 The video covers the content of the DA-100 exam, which focuses on analyzing data with Microsoft Power BI.
01:16 📝 The DA-100 exam is for those who want to become data analysts, leverage data in their organization, or learn Power BI. It costs $165, lasts 2.5 hours, and requires a passing score of 70.
02:24 🤐 The speaker couldn't reveal specific exam details due to a non-disclosure agreement, but typically, the exam contains 40 to 60 questions.
03:38 🕒 The time required to prepare for the exam varies: 3-7 days for experienced users, 2-3 weeks for those in sales, finance, or IT, and 30 days for beginners.
04:25 📋 The content outline for the DA-100 exam includes preparing data, modeling data, and visualizing data. Preparing data involves getting data from various sources and analyzing it.
05:36 📊 Visualizing data in Power BI includes creating reports, dashboards, and using filters, tooltips, and bookmarks to enhance reports.
05:51 📈 Analyzing data includes enhancing reports for insights, making reports interactive, and utilizing AI functionalities in Power BI.
06:04 🚀 Deploying and maintaining deliverables covers Power BI service, workspaces, deployment pipelines, subscriptions, and scheduled refresh.
07:29 💻 Power BI Desktop is where you load, transform data, create relationships, and build visuals in the report segment.
08:00 🗄️ Power Query M is used for data transformation in Power Query Editor, while DAX is used for creating measures and calculated columns in Power BI reports.
09:27 🔄 You can load data into Power BI Desktop using either the import mode or direct query mode, each with its advantages and limitations.
11:43 🔄 Parameters in Power BI allow for dynamic filtering and switching between data sources or environments.
14:29 🔄 Power BI provides various options for connecting to different data sources, including files, databases, Power Platform, Azure, and online services.
15:23 🧼 Data quality is essential in Power BI. You can assess data quality in Power Query Editor using data preview, column quality, and column distribution.
17:03 ❓ Unique values appear only once, while distinct values represent the number of categories in a column.
19:24 🧩 You can combine data in Power Query Editor by appending or merging queries, with various join types available for merging.
21:19 🔄 Transposing moves columns to rows, pivoting changes rows into columns, and unpivoting changes columns into rows.
24:53 💼 Data types are important in Power BI, and you can change them in the Power Query Editor. Handling blanks, empty strings, and zero values is crucial.
28:37 📝 You can add or delete columns and rows in Power Query Editor using options like "Remove Columns" and "Add Custom Column." Conditional columns and custom functions are also available for adding columns.
31:03 📊 Conditional columns can be added in Power Query Editor to categorize data based on conditions, such as marking products as premium if their price is above a certain threshold.
32:30 📈 Index columns are useful for adding a row counter to your dataset, which can be handy for advanced analysis.
33:27 📋 Applied steps in Power Query Editor represent the transformations applied to data and are displayed in order of execution.
34:24 🧩 Power Query M language includes over 750 functions, but focusing on commonly used ones is more practical.
35:52 📚 The video covered topics related to preparing data, understanding differences between Power BI Desktop and Power Query Editor, import options, data profiling, and using built-in functions.
37:37 📊 Understanding relationships, cardinality, and filter propagation in Power BI is crucial for effective data modeling.
40:15 📈 Active and inactive relationships in Power BI can impact data modeling and should be managed carefully.
43:25 🔄 Cross filter direction in Power BI relationships determines how data filters propagate, affecting how visuals display information.
47:11 🧮 Power BI allows you to create calculations using measures and calculated columns to extract insights from data.
49:01 📈 Measures and calculated columns serve different purposes in Power BI, with trade-offs in terms of storage and performance.
52:43 📊 Power BI offers a wide range of DAX functions categorized by type, including statistical, logical, date, and relationship-related functions.
55:34 📊 The visualization pane in Power BI allows you to choose from various visualizations and customize them to convey data insights effectively.
56:39 📈 Power BI provides a diverse set of visualizations, including line charts, bar charts, pie charts, matrices, and many more, each suited for different data representation needs.
01:00:00 📊 Power BI dashboards are concise, one-pager views that can display selected visuals from reports, allowing users to focus on key information.
01:02:26 🔍 Filters in Power BI are essential for controlling what data is displayed in reports, allowing you to focus on specific aspects of your dataset.
01:03:08 📊 Power BI allows you to filter and evaluate top-performing stores by adding return fields and applying filters.
01:03:39 🧩 Edit interactions in Power BI visuals using filter, highlight, or none options to control how visuals impact each other.
01:05:25 📅 Use slicers to empower users to choose specific data, such as dates or categories, to analyze in Power BI.
01:07:16 🔄 Sync slicers across multiple pages in Power BI to ensure slicer effects are consistent throughout the report.
01:08:18 📚 Bookmarks in Power BI allow you to freeze and save specific visualizations for later use, helpful for presentations and complex reports.
01:09:30 📝 Tooltips provide extra information to users when hovering over visuals in a Power BI report, enhancing the user experience.
01:10:13 ⏩ Drill-through in Power BI enables users to access underlying data, offering more detailed insights into specific aspects of a report.
01:11:19 📃 Page Native Reports in Power BI allow structured document creation, typically used in a business context for invoices or other structured documents.
01:14:36 🚀 Optimize Power BI performance with six golden rules, including using measures over calculated columns and avoiding wide datasets.
01:16:03 📊 Use Power BI's Performance Analyzer to analyze load times and performance issues in your report.
01:17:38 🌐 Configure gateway connections for on-premises or cloud data sources that Power BI can't access directly.
01:18:56 🔄 Schedule data refreshes in Power BI Service, with options for daily, weekly, or monthly updates.
01:20:06 📝 Use Text Analytics in Power BI to perform sentiment analysis, keyphrase extraction, and language detection on textual data.
01:21:38 📷 Power BI's Vision feature can tag images, helping identify objects or elements within images.
01:22:06 🧠 Leverage Azure Machine Learning to incorporate custom machine learning models into your Power BI reports.
01:23:33 🔄 Schedule data refreshes during less busy times, consider data volume, and optimize data sets for better Power BI performance.
01:32:09 📊 Row Level Security: Use DAX to specify which roles can see limited data based on specified criteria, like username or user principal name.
01:34:36 🔐 Sensitivity Labels: Add sensitivity labels to data and reports to increase security awareness and prevent unauthorized sharing.
01:35:35 🚀 Promotion and Certification: Promote reports for easy access by co-workers and certify data sets that meet organizational criteria for broader use.
01:36:30 💾 Large Data Set Storage: Enable large data set storage formats for handling large data volumes, especially useful on premium capacity.
01:37:49 🏢 Workspaces: Collaborate and organize reports, data sets, and users within workspaces, each with distinct roles like admin, member, contributor, and viewer.
01:41:18 🔄 Deployment Pipelines: Use deployment pipelines to manage the development, test, and production phases of your reports or models.
01:42:40 🧮 Data Flows: Create reusable data flow processes to collect, transform, and share data sets within Power BI while controlling data source access.
01:44:00 📱 Configuring and Updating Apps: Apps allow broad distribution of content; create, configure, and set permissions for apps in Power BI service.
01:44:54 📧 Subscriptions: Set up subscriptions to receive periodic emails based on report updates, and choose frequency based on your license and report ownership.
01:46:53 📚 Exam Preparation: Practice key concepts, especially DAX functions like calculate, summarize, and group by, to prepare for the PL-300 exam.
Made with HARPA AI
More context that helped me: Distinct shows how many values are in the column if you remove the duplicate, while Unique shows how many values appeared just once.
i passed the exam with this tutorial, its definitely cover most of the key concept! i only refreshed the dax methods that u suggested!! its really helped me to answer most of them!! but going to exam alone with this course, i wont recommend it, referring the documentation suggested by the instructor will definitely help! getting experienced with question bank is crucial!
what resources you utilized and how much time (approx) it took you to learn and get certified ? Can you please share that ?
please could share the resources you utilized
@@memeee4214I found these videos that are helpful
ua-cam.com/video/6zzSnheaCCA/v-deo.html
Even though its a 2 year old video it's still perfect for revision. Thanks a lot.
I'm studying for my exam, and watching 30 mins of this video has already helped me double my scores in the practice exams. Thank you so much for sharing this knowledge!
where do you get the practice exams?
@@ebrahimshafiei6201 I got the Pearson Vue one that was recommended by Microsoft. After taking the exam, I don't recommend it. The free exams you find online are better.
@@Tas6693 where can i find free exams online ?
Yesterday, I have passed the exam PL-300 from first attempt.
My background is purely focusing on finance and investment banking.
This video helps me a lot passing the exam as recap after studying the free material on Microsoft website related to Power BI.
Thanks a lot for sharing the video and I really appreciate it.
Hello Abdulmajeed, Congratulations on passing the exam! Please help me with the link for the free material on Microsoft Website related to Power BI. Thank you. I am about to start preparing for the exam
@@olanrewajuadeniji8974 If you scroll down you will find two ways to prepare. Pick free way.
I failed my 1st exam and realized this video cover most of the topic in exam. Should come here earlier
this video is enough
Thank you for making this video. It is very helpful. I have passed the exam. I studied from your video and praticed dump questions on Examtopics. Thanks again 😊
Wooow! Great to hear that you passed the exam. Good luck on your Power BI journey!
Doesn't sound like you really learned it properly...
Hi @katie Jean , Congratulations!! need help can you share with me the dump questions?
Hi katie . Can you share with me the dumb questions
Hello mam can you please provide me link for that questions
Thanks a lot for this Exam-centric treatise! As for the sound level issue, there is no problem on my side...it is coming out loud and clear! I sympathize with those who are facing audio-related issues...sorry for that...and to all those who have passed the Exam/Certification...Congratulations & Celebrations! Additionally, to all those who are planning to test the waters...here's to your SWEET $UCCE$$ & RESOUNDING VICTORY! Way to go all of you PBI DAs, if I may! Kudos!
Great Job!!!
It is so difficult to find a material with this quality and so objective!!!
Excellent information. It felt like a quick crash course of Power BI that includes all important topics. Thanks for sharing!
Thanks!
Btw, it's possible to pass it with 4 days of studying and no prior experience. Fantastic video that covered a lot of what's on the test. This video plus some tutorial and hands on tinkering with the platforms is enough to get you there.
Thanks again!
Congrats on passing the exam & thanks for your feedback!
Hii, Can you share which other tutorials you referred to pass this exam. Thank you.
Congratulations, Which other resources did you use?
Fantastic. Key concepts I'd not gotten in other (much longer courses) covered here. Thank-you!
Hi Tijs! I cleared my Exam today!! Many thanks for this Video!!
This helped me to quickly revise most of the important concepts before the exam !!!
Woop woop! Great job
Congrats AJ, if u also have some informative material pls share as well especially exam questions
Thank you very much for this video. Today I passed the DA 100 exam. I read other sources, and this video is a good summary / recap.
hello. what other sources did you read. can you share them with me
thanks to the author, very useful. However there are some concepts which are contradicting with power bi fundamental concepts. The one is "more rows and less columns is better". According to the DA-100 of Maslyuk, instead, to reduce the column cardinality and improve performance, we need to split, columns into two, for example, date and time to Date and Time columns, because power bi is more a columnstore database, and by splitting we remove the column cardinality. Overall, want to ay huge thanks for this material - a great summary.
I also heard that more columns and fewer rows is better for speed, the author is correct
This guy used exact leaning path available in Microsoft official website.... But cool...nd informative..😊
I'm just starting to prepare for the exam, thanks for taking the time to make this video, it is very helpful!
This is an excellent video for ones who wanna go through all the features of powerbi at a glance!
Thanks a Lot ! I would take this exam this year. Hope be able to pass it with your vídeo..
Best of luck! Take some practice exams ;)
Thanks for creating this overview. One remark/error though: At 1:10:00, you say you will be showing drill through, but in the report, you are actually showing the drill down feature. Drill down is different from drill through though (as can also be seen in the documentation shown at 1:10:50).
Thank you for correcting! I’ve pinned this remark.
thank you so much for this video It saved our time and helped us to get more clarity as a beginner ❤❤❤ love from India
Productive video found after so many searches.. keep up the good work bro:)
Great Video. Quick note: Subscription is not a premium function. There are parts of subscription which are, but you can subsribe yourself or others in the organisation, at least as the author.
Thank you for clarifying!
I passed my exam today, thanks a lot for this video. I got 820
Congrats!
@@callfordata7378 hey can you recommend some sources apart from this video?
@@zubiamasood9571 Test exams at Udemy - Small cost, but very representative of the exam.
@@callfordata7378 thank you
Any cost free source of practice?
Very informative, practical and beautifully presented. Thank you so much!
thank you for this video! it's very helpful, especially for me as a beginner.
Amazing, Very useful, and beautifully presented. Thank you very much. Great summary refresher. I'm writing the exam in a week!
how did it go?
It will be really helpful if you share every diagram shown in this video.😍😍😍
worthwhile.....less content and highly informative.....looking for more such videos from your channel....
Hi Tijis welcome to UA-cam, and nice video
Thank you. One of the best go through of POWER BI :D
Thank you so much for this course. Wonderful video!!
Thank you so much, i already scheuled my exam :-D but now i am not so worried haha :-D
Super useful review of all topics... Thanks for sharing.
this is really helpful, thank you so much for making the video
great video!! covered all the important topics.. and the examtopics dump helped me clear this exam:)
Can you please share the dumps ?
@@atulnarayan3109 Can you please share the dumps?
Hi Harmanpreet,
Can you please share the dumps?
harman can you please share the dumps ..it will be relly grateful .
Thanks for an excellent video.
This is actually soo good..
Have you taken the test? If yes, what all resources did you use for preparation other than this video and how long it took you?
Great video. Thanks for the test insight.
Thanks, great course! Keep it up boyzzz
Good job gathering all these informations and spread you knowledge. Keep the good work ^^ What is your plan with this channel are you going to upload more videos about Power BI ?
Thanks Omar! Honestly, we don't know yet. Likely more videos on data analysis & process automation.
Thank you ! Job well done!
Great job thanks alot
Well done!!
very good, thank you!
Thank you. Mostly well done, but the speed is lumpy.
Thanks for your feedback!
Thank you.
Please, recommend some course with a lot of practise and for intermediate/advanced level of dax
Great job 👍
great video!
thx~!
very informative thanks. can you tell me where I can get the data tables etc that you are using? It would be helpful to follow along while watching the video.
Does this video cover topics like row level security, row and filter context and query folding?
Top! Thanks
Nice video! Please lower the music volume and increase your voice volume. Thanks!
Great material!
Thanks!
Hi
Does the exam ask for steps in Power BI? What I have to click to achieve something?
There are many practical examples and exercises in the learning path. Are these relevant to the test as well?
Does anyone have any general tips for the Microsoft exams?
Thanks
follow dumps and lots of practice
it is helpful training ...
Awesome Video. I was struggling to seggregate which topic falls under which category. This made easy. Is it possible for us to get the subject material used to explain the video?
Thanks for sharing
Thanks for the video bro, new subscriber here
Thanks!
thank you man
Is this still relevant for the new PL-300 exam?
Yes!! Check the exam outline by Microsoft and you will see a high % of overlap
Hey, did you write already? if so, how did you write it?
Please make more videos :3
Now I am going to start Data Analyst career DA100 or PL300 which is the best
This course is amazing!!!
Is the material you used in this video yours or in the public domain?
If you didn't mind sharing it would be a lot of help in my studies for the DA-100 in august 21.
Feel free to reach out to me by email (see channel info)
Hi Cid , can you Tell me about your exam experience. How is look like ? Any helpful advice ? Thank you
@@rawan1963 , Unfortunately I had to postpone my exam, I will take it next month. I'll tell you as soon as I do.
@@cidnazareth can I have your email to contact with you ?
Can you share the dumps for clearing the DA100 exam
is there a way to access the sample data to follow this course ?
I would like to ask a question if anyone can help. I have no experience in data analysis. I took the google data anaytics certificate from coursera and thats about it. I want to get the microsoft certification but from what Ive seen, most of them got experience in their field. What would be the best advice to study for the certification if I have no experience.
Hello there, thanks for this helpful video. Is it possible to share the slides in the video?
Will this video help me prepare for PL 300 ?
Hi
Very helpful session , it covers topics required for exam.
I am about to take the exam and I have one query.
Currently Iam in US. I already have an microsoft account with India details like address etc. Can I use the same account for the exam where I can pay money in Indian currency. Please advice if I can do like that.
Very helpful and great video but your volume is way too low. We can barely hear you. Thanks again. Best video on YT aside from this.
nice one
The DAX UNIQUE function you mentioned on 52:50 doesn't exist. And there are typos on the CALEND'A'R functions
Great content and I learned a lot; however, just work on keeping you voice at the same level. You tend start speaking at a decent level, but then slowly begin to speak too softly.
Thanks for that feedback!
@@callfordata7378 Here's my experience with Audacity...first, I start recording for a very short duration...pause it...then I rewind and play (while looking at the audio waveform levels)...and once I am fully satisfied with this vert short recording...I proceed. I also use this very same method with Screen+voice recordings and I am very satisfied with the output quality for potential and future listeners. Moral of the story...never ever assume that it will all go fine, vis-a-vis the output quality! Do a test recording first and foremeost...and then go ahead without any qualms whatsoever. God BLESS all!
Great. Subscribed to you channel
Welcome!
4:10 do you mean that it would take 30 days if I study 8 hours per day? (Being new to power bi)
If you take the exam after 30 June 2021, then the certification will only be valid for 1 year
Thanks for mentioning Antony!
did Microsoft say that ???
@Hoss SATOUR After doing some research, Microsoft indeed disclosed the validity of the DA-100 exam will be limited to 1 year for those who obtained their certification after June 30th, 2021. docs.microsoft.com/en-us/learn/certifications/certification-expiration-policy
@@callfordata7378 ok, thank you for the information 👍
Why so?
You are not allowed to have Power BI open during the exam right? It is multiple choice without the program
Indeed :)
Hi guys, does anyone know if this exam is like a multiple choice exam or do you have to show them that you can re-model and transform data?
thanks
Multiple choise (mostly) + case study ;)
@@callfordata7378 thank you so much
@@callfordata7378 Thank you so very much Sir!
This is for PL 300 or Both PL and DA
Do you have Data Analysis Course with MS. Excel?
can you publish the ppt presentation? make it available for us to access? Thanks.
Our Patreon membership will give you access to the presentation in .pdf format. You can find the link in the description.
@@callfordata7378 Hi i already purchase memberhip on your patreon, but i can't find the link to download the presentation. Can you help me? I already message you on patreon. Please i need it fast
@@fadhilrausyanfikr sent! Good luck
@@callfordata7378 For the pdf, is it a one time payment in Patreon?
Hi,
Can you share the ppt with all slides?
Thank you.
Is test all multiply choice or not?
Very helpful training - cant see any information of how to contact you for the resources u used in the training.
Please refer to our Patreon page - www.patreon.com/callfordata?fan_landing=true
@@callfordata7378 Hi.. To get the pdf, the patreon is one time payment or each month?
@@donjuan4you one time, feel free to cancel the subscription after receiving the pdf :)
@@callfordata7378 Thanks. I got the PDF. But I hope you post more new content so I can rejoin. Your presentation material is good-concise and clean. I would be interested in more PowerBI/DAX/Data Flows and other tools like SSIS, SSAS, SSRS, Azure Data Factory-Data Integration. Python, R etc. if those tools are in your realm of expertise.
@@donjuan4you To some extent :) I'll look into it, thanks
This exam is quite hard
On third attempt
Hi, just messaged you on patreon for the pdf! Thanks
Can u pls share the pdf of possible 🙏
May I ask for the dataset?
Thank you so much
Please could you send me the pdf?
can we get the pdf/presentation of this vedio?
Can I get the pbix file you used here?
Can anyone please clarify if this course sufficient to clear PL-300 as it is a new Exam and replacement of DA-100? So will this course suffice for PL-300 exam too?
Hi Rajat! I can confirm that this course will provide a solid basis to tackle the PL-300 exam, but I also advise you to watch some other videos on areas where you feel like you are lacking. For most people, this is often DAX, data modeling & data transformations.
So how much of the course is free and how much is paid?
Entire exam content is mentioned throughout this video. There’s a lot of people requesting the ppt so I created a Patreon page for this purpose. Hope this clarifies it.
where can i download this powerpoint？🥰
isn't 100 minutes excluding the prep time?
Hi, I'm planning to give an exam PL300 possibly this month. My doubt is this course helpful for PL300 as well? Do DA100 and PL300 contains the same set of contents?
Different exam outline but the majority of the content overlaps. See our other video on this topic.
24:29 Transpose has wrong image!