title
Power BI Interview Questions and Answers | Power BI Certification | Power BI Training | Edureka

description
( Power BI Training - https://www.edureka.co/power-bi-certification-training ) This Edureka "PowerBI Interview Questions and Answers" video will help you unravel concepts of Power BI and touch those topics that are very vital for succeeding in Power BI Interviews. This video helps you to learn following topics: 1. General Power BI Questions 2. DAX 3. Power Pivot 4. Power Query 5. Power Map 6. Additional Questions Check out our Power BI Playlist: https://goo.gl/97sJv1 Subscribe to our channel to get video updates. Hit the subscribe button above. Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka #PowerBI #PowerBIInterviewQuestions #DAXFunctions #SSBI #SSRS #PowerBIQ&A #WhatIsPowerBI #PowerBITraining #PowerBIforbeginners #PowerBITutorial #PowerBIDashboard #PowerBIDesktop #PowerBIBuildingBlocks #PowerBIComponents #PowerBIFilters #Edureka ----------------------------------------------------------------- How it Works? 1. This is a 4 Week Instructor led Online Course, 25 hours of assignment and 20 hours of project work. 2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 3. At the end of the training you will be working on a real time project for which we will provide you a Grade and a Verifiable Certificate! -------------------------------------------------------------------- About The Course Power BI is a powerful cloud-based suite of business analytics tools that make it easy to combine data from multiple sources, analyze and visualize information and share insights. Edureka's Power Bi course features easy drag and drop report authoring for advanced insights , and online web dashboards that update automatically and can be shared within seconds. You begin by learning about architecture and components of Power BI along with Power Query and Power Pivot. You will learn about Data Visualization with Power BI Desktop, Power View and Power Map. Along with the process of visualization, You will learn about Power BI Q&A and how the users can discover, explore and visualize their own enterprise. You will be introduced to the Power BI Administration for deployment of files and building dashboards in the Power BI Website. ---------------------------------------------------------------------- Who should go for this course? The Power BI training at edureka is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. For example: · Business Analysts · Business Intelligence Manager · Statisticians and Analysts · Data Scientists · Project Managers ----------------------------------------------------------------------- Why learn Power BI? Power BI helps Business Analysts, Business Intelligence Manager, Statisticians & Analysts, Project Managers and Data scientists to visualize and share insights from their organizations’ data. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information from technology staff or database administrator. Power BI provides cloud based BI services - known as Power BI Services, along with a desktop based interface - called Power BI desktop. It offers Data modelling capabilities, including data preparation, data discovery and interactive dashboards. Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc., Brillio and over 45,000 MNCs across 185 countries use Power BI For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).

detail
{'title': 'Power BI Interview Questions and Answers | Power BI Certification | Power BI Training | Edureka', 'heatmap': [{'end': 2527.246, 'start': 2460.586, 'weight': 0.95}, {'end': 2705.013, 'start': 2642.571, 'weight': 0.704}, {'end': 2828.275, 'start': 2762.617, 'weight': 0.731}, {'end': 4146.399, 'start': 4022.924, 'weight': 0.707}, {'end': 4448.815, 'start': 4385.452, 'weight': 1}, {'end': 5829.554, 'start': 5765.775, 'weight': 0.76}], 'summary': 'Covers power bi interview questions, self-service bi, power bi and excel bi integration, q&a feature, dax functions, calculated columns and measures, data modeling, and power bi features and implementations with practical examples.', 'chapters': [{'end': 239.822, 'segs': [{'end': 30.823, 'src': 'embed', 'start': 0.029, 'weight': 0, 'content': [{'end': 0.59, 'text': 'Hello everyone.', 'start': 0.029, 'duration': 0.561}, {'end': 4.795, 'text': 'Wishing you all a very good morning, good afternoon and good evening to all of you joining in from across the world.', 'start': 0.75, 'duration': 4.045}, {'end': 8.921, 'text': "And I welcome you all to today's webinar on Power BI interview questions.", 'start': 5.356, 'duration': 3.565}, {'end': 15.81, 'text': 'So the idea is to over the next one hour or so, the idea is to walk you through some of the most commonly asked interview questions in Power BI.', 'start': 9.462, 'duration': 6.348}, {'end': 21.415, 'text': "so we're going to be focusing on a lot of conceptual topics, a lot of theoretical questions and a lot of practical questions,", 'start': 16.331, 'duration': 5.084}, {'end': 25.879, 'text': 'and the idea is to not only walk you to the questions, but also to actually take you through a very,', 'start': 21.415, 'duration': 4.464}, {'end': 30.823, 'text': 'very good demonstration and just to give you a very good approach and idea on how to answer some of those questions.', 'start': 25.879, 'duration': 4.944}], 'summary': 'Webinar on power bi interview questions, covering conceptual, theoretical, and practical topics, aims to prepare candidates.', 'duration': 30.794, 'max_score': 0.029, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs29.jpg'}, {'end': 94.168, 'src': 'embed', 'start': 62.79, 'weight': 1, 'content': [{'end': 65.071, 'text': 'And obviously, what is self-service business diligence?', 'start': 62.79, 'duration': 2.281}, {'end': 66.411, 'text': 'So, needless to say, Power BI.', 'start': 65.09, 'duration': 1.321}, {'end': 71.313, 'text': 'the very fact is that Power BI is one of the most popular SSBI tools in the marketplace today.', 'start': 66.411, 'duration': 4.902}, {'end': 78.097, 'text': 'And any of you who have worked on other BI tools coming from the world of Tableau or Qlik Sense or Spotfire.', 'start': 71.853, 'duration': 6.244}, {'end': 79.497, 'text': 'You can also relate to this.', 'start': 78.397, 'duration': 1.1}, {'end': 81.359, 'text': 'So if you are asked a question what is self-service BI??', 'start': 79.517, 'duration': 1.842}, {'end': 84.601, 'text': 'I think the first approach to take is to explain what is SSBI.', 'start': 81.419, 'duration': 3.182}, {'end': 88.484, 'text': 'okay?. Now, any of you, as I said, if you have come from the world of traditional business intelligence, right?', 'start': 84.601, 'duration': 3.883}, {'end': 94.168, 'text': "If you've worked on tools like SSRS Cognos, if you come from MSBI world or if you use the business objects,", 'start': 88.504, 'duration': 5.664}], 'summary': 'Self-service bi, including power bi, is popular among bi tools like tableau and qlik sense, and is a significant trend in the marketplace.', 'duration': 31.378, 'max_score': 62.79, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs62790.jpg'}, {'end': 157.377, 'src': 'embed', 'start': 132.205, 'weight': 3, 'content': [{'end': 138.068, 'text': 'that mutual fund manager has to go back and depend on his internal IT team to go back and build that chart for him.', 'start': 132.205, 'duration': 5.863}, {'end': 144.551, 'text': 'It could be a very simple line chart, but as I said, the initial fund manager may not be that well versed in a traditional BI tool like an SSRS.', 'start': 138.108, 'duration': 6.443}, {'end': 151.214, 'text': 'Okay, So they will be depending on the internal in-house IT team, and that way the overall process will become pretty slow,', 'start': 144.731, 'duration': 6.483}, {'end': 154.556, 'text': 'because the IT team will have their own requirement gathering process.', 'start': 151.214, 'duration': 3.342}, {'end': 157.377, 'text': "They'll have their own software development framework which they'll follow,", 'start': 154.576, 'duration': 2.801}], 'summary': 'Mutual fund manager relies on internal it team for chart, causing slow process.', 'duration': 25.172, 'max_score': 132.205, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs132205.jpg'}, {'end': 194.421, 'src': 'embed', 'start': 168.404, 'weight': 2, 'content': [{'end': 175.389, 'text': 'so this is exactly where self-service bi comes in, and self-service bi is an approach to data analytics that enables business users to filter,', 'start': 168.404, 'duration': 6.985}, {'end': 180.512, 'text': 'segment, analyze their data, and this is the key, where the key is really to focus on business users,', 'start': 175.389, 'duration': 5.123}, {'end': 183.855, 'text': 'and you can either say business users or you can say end users, customers,', 'start': 180.512, 'duration': 3.343}, {'end': 188.077, 'text': 'so essentially non-technical people who are the real consumers of this particular tool.', 'start': 183.855, 'duration': 4.222}, {'end': 190.559, 'text': 'Okay, and what is the benefit of using this?', 'start': 188.357, 'duration': 2.202}, {'end': 194.421, 'text': 'And if you just compare to this scenario just I discussed just a while back now here,', 'start': 190.699, 'duration': 3.722}], 'summary': 'Self-service bi empowers business users to analyze data, benefiting non-technical consumers.', 'duration': 26.017, 'max_score': 168.404, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs168404.jpg'}], 'start': 0.029, 'title': 'Power bi and self-service bi', 'summary': 'Covers power bi interview questions and self-service bi, aiming to provide a broad understanding in a limited set of questions, and explains how self-service bi enables non-technical users to analyze data with an example of a mutual fund manager using power bi directly.', 'chapters': [{'end': 168.404, 'start': 0.029, 'title': 'Power bi interview questions', 'summary': 'Focuses on power bi interview questions, covering conceptual, theoretical, and practical topics, aiming to provide a broad understanding and real-life scenarios, within a limited set of questions, over the next one hour.', 'duration': 168.375, 'highlights': ['The chapter focuses on Power BI interview questions, covering conceptual, theoretical, and practical topics, aiming to provide a broad understanding and real-life scenarios, within a limited set of questions, over the next one hour. The summary encapsulates the central theme of the chapter, emphasizing the focus on Power BI interview questions, the broad understanding, and the limited set of questions, within a specific time frame of one hour.', "Power BI is one of the most popular SSBI tools in the marketplace today, enabling end users to build reports and projects without depending on internal IT teams, thus reducing development cycles and hindrances. This highlight provides quantifiable data by stating Power BI's popularity as one of the most SSBI tools, and the impact of enabling end users to build reports and projects without depending on internal IT teams, leading to reduced development cycles.", 'Traditional BI tools required end users to depend on internal IT teams for building reports, resulting in slow processes due to requirements gathering and software development frameworks, leading to delays in obtaining simple visualizations. This highlight outlines the inefficiencies of traditional BI tools, emphasizing the need for end users to depend on IT teams and the resulting slow processes, quantifying the impact through delays in obtaining simple visualizations.']}, {'end': 239.822, 'start': 168.404, 'title': 'Self-service bi for business users', 'summary': 'Explains the concept of self-service bi, highlighting how it enables non-technical business users to analyze data, leading to faster development cycles and increased user satisfaction, with an example of a mutual fund manager using power bi directly.', 'duration': 71.418, 'highlights': ['Self-service BI enables non-technical business users to analyze data and directly use tools like Power BI, leading to faster development cycles and increased user satisfaction. This highlights the key concept of self-service BI and its benefits, emphasizing faster development cycles and user satisfaction.', 'Traditional BI projects face challenges such as multiple iterations during requirement gathering phases, leading to dissatisfaction and delays. This highlights the inefficiencies of traditional BI projects, including multiple iterations during requirement gathering and subsequent dissatisfaction and delays.']}], 'duration': 239.793, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs29.jpg', 'highlights': ['The chapter focuses on Power BI interview questions, covering conceptual, theoretical, and practical topics, aiming to provide a broad understanding and real-life scenarios, within a limited set of questions, over the next one hour.', 'Power BI is one of the most popular SSBI tools in the marketplace today, enabling end users to build reports and projects without depending on internal IT teams, thus reducing development cycles and hindrances.', 'Self-service BI enables non-technical business users to analyze data and directly use tools like Power BI, leading to faster development cycles and increased user satisfaction.', 'Traditional BI tools required end users to depend on internal IT teams for building reports, resulting in slow processes due to requirements gathering and software development frameworks, leading to delays in obtaining simple visualizations.']}, {'end': 867.063, 'segs': [{'end': 281.926, 'src': 'embed', 'start': 252.005, 'weight': 1, 'content': [{'end': 257.286, 'text': "it's a very easy process and anybody who has basic understanding of data can create reports to build intuitive and shareable dashboards.", 'start': 252.005, 'duration': 5.281}, {'end': 260.608, 'text': 'So when you answer this question is very important to get the understanding.', 'start': 257.706, 'duration': 2.902}, {'end': 263.031, 'text': 'give the basic understanding of what are the challenges of traditional BI?', 'start': 260.608, 'duration': 2.423}, {'end': 267.556, 'text': 'What are the challenges of some of the other top AI tools and where does SSPI fit in?', 'start': 263.051, 'duration': 4.505}, {'end': 269.117, 'text': "It shouldn't be a very bland answer.", 'start': 267.836, 'duration': 1.281}, {'end': 269.718, 'text': 'just that.', 'start': 269.117, 'duration': 0.601}, {'end': 273.341, 'text': 'know what is SSBI and the power BI as an SPI tool, but try to be as broad as possible.', 'start': 269.718, 'duration': 3.623}, {'end': 275.764, 'text': 'Try to give context on where SSBI comes from.', 'start': 273.381, 'duration': 2.383}, {'end': 281.926, 'text': 'why is SSBI important and what are some of the other tools? Remember Power BI is a very small part of the whole landscape.', 'start': 276.144, 'duration': 5.782}], 'summary': 'Ssbi enables easy report creation for intuitive, shareable dashboards, addressing challenges in traditional bi and other ai tools.', 'duration': 29.921, 'max_score': 252.005, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs252005.jpg'}, {'end': 314.499, 'src': 'embed', 'start': 282.186, 'weight': 0, 'content': [{'end': 288.228, 'text': 'The BI landscape is dominated by tools like Tableau, like Spotify, like Qlik Sense in the data visualization SSBI landscape.', 'start': 282.186, 'duration': 6.042}, {'end': 292.29, 'text': "And if you talk about SSBI in analytics, there's also tools like Alteryx, which are really revolutionary.", 'start': 288.548, 'duration': 3.742}, {'end': 298.512, 'text': 'And you can take these examples and that will really get to show your depth and breadth of knowledge in the entire BI space.', 'start': 292.69, 'duration': 5.822}, {'end': 302.714, 'text': 'Okay. So moving on next question what are the parts of Microsoft sales service BI solution?', 'start': 298.832, 'duration': 3.882}, {'end': 306.875, 'text': 'So, as I mentioned, the SSBI question in the beginning was purely a very general question.', 'start': 302.754, 'duration': 4.121}, {'end': 308.976, 'text': 'Now we are being more focused on Microsoft stack.', 'start': 306.996, 'duration': 1.98}, {'end': 311.057, 'text': 'So we are focused on the entire Microsoft stack.', 'start': 309.337, 'duration': 1.72}, {'end': 314.499, 'text': 'And obviously when you talk about the Microsoft stack, we are talking about primarily two toolkits here.', 'start': 311.077, 'duration': 3.422}], 'summary': 'The bi landscape is dominated by tools like tableau, spotify, and qlik sense, with alteryx being revolutionary in ssbi analytics, and microsoft primarily using two toolkits.', 'duration': 32.313, 'max_score': 282.186, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs282186.jpg'}, {'end': 414.235, 'src': 'embed', 'start': 378.813, 'weight': 3, 'content': [{'end': 385.878, 'text': 'So whatever you have in power bi is nothing new, right? So all these components have already been there in Excel for a long time.', 'start': 378.813, 'duration': 7.065}, {'end': 389.419, 'text': 'So when you think of PowerPivot, PowerPivot was actually launched as an add-in.', 'start': 386.717, 'duration': 2.702}, {'end': 392.261, 'text': 'When you think of PowerQuery, again, PowerQuery was launched way back.', 'start': 389.659, 'duration': 2.602}, {'end': 394.903, 'text': 'PowerView is, again, a very, very integral component of Excel.', 'start': 392.381, 'duration': 2.522}, {'end': 397.684, 'text': 'So all these components were already existing in Excel.', 'start': 395.283, 'duration': 2.401}, {'end': 403.428, 'text': 'And all that Power BI Desktop did was it repackaged all these components, which they now call Power BI Desktop.', 'start': 398.025, 'duration': 5.403}, {'end': 406.35, 'text': 'But it is very important to understand that they were all already there.', 'start': 403.628, 'duration': 2.722}, {'end': 412.414, 'text': 'So the obvious question that I sometimes face from candidates is why did Power BI build a tool like that??', 'start': 406.67, 'duration': 5.744}, {'end': 414.235, 'text': 'Why did I build a tool like that??', 'start': 413.054, 'duration': 1.181}], 'summary': 'Power bi repackaged existing excel components into power bi desktop.', 'duration': 35.422, 'max_score': 378.813, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs378813.jpg'}, {'end': 523.14, 'src': 'embed', 'start': 497.197, 'weight': 5, 'content': [{'end': 502.62, 'text': 'so you should mention that it actually came from excel, and excel, by the way, is also a very, very powerful self-service bi solution.', 'start': 497.197, 'duration': 5.423}, {'end': 508.503, 'text': 'because, remember, even without the power bi components of excel, even without these excel components like power query, power view of power pivot,', 'start': 502.62, 'duration': 5.883}, {'end': 513.071, 'text': 'think of a very, very simple use case where you have a simple spreadsheet application.', 'start': 508.963, 'duration': 4.108}, {'end': 514.433, 'text': 'a business manager has a very,', 'start': 513.071, 'duration': 1.362}, {'end': 520.346, 'text': 'very simple spreadsheet application and he has some data on an excel spreadsheet and all he wants to do is create a very, very simple chart out of it.', 'start': 514.433, 'duration': 5.913}, {'end': 523.14, 'text': 'can he not use the charts function in excel?', 'start': 520.839, 'duration': 2.301}], 'summary': 'Excel is a powerful self-service bi solution, enabling simple chart creation from spreadsheet data.', 'duration': 25.943, 'max_score': 497.197, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs497197.jpg'}, {'end': 600.901, 'src': 'embed', 'start': 575.205, 'weight': 6, 'content': [{'end': 580.71, 'text': 'okay, remember, power bi, the entire architecture of power bi is a client server architecture where you have the power bi desktop,', 'start': 575.205, 'duration': 5.505}, {'end': 582.651, 'text': 'which is sitting in the middle as a client tool.', 'start': 580.71, 'duration': 1.941}, {'end': 585.934, 'text': 'so power bi desktop is where you actually do all your development stuff.', 'start': 582.651, 'duration': 3.283}, {'end': 589.477, 'text': 'okay, that is where you actually build your reports, you actually build all the cool visuals,', 'start': 585.934, 'duration': 3.543}, {'end': 595.6, 'text': 'you actually build your model right inside power bi desktop and then you publish it onto the cloud, which we call the power bi service.', 'start': 589.477, 'duration': 6.123}, {'end': 597.44, 'text': "so remember it's a client server architecture.", 'start': 595.6, 'duration': 1.84}, {'end': 600.901, 'text': 'so mention those words, mention those keywords, mention those terms.', 'start': 597.44, 'duration': 3.461}], 'summary': 'Power bi has a client-server architecture with power bi desktop for development, and reports are published to the power bi service in the cloud.', 'duration': 25.696, 'max_score': 575.205, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs575205.jpg'}, {'end': 723.253, 'src': 'embed', 'start': 694.687, 'weight': 7, 'content': [{'end': 698.85, 'text': 'you have the power query, power pivot, power view, and all these three are part of power bi desktop.', 'start': 694.687, 'duration': 4.163}, {'end': 702.553, 'text': 'So all these three you can you can just club it as part of power bi desktop and then your power map.', 'start': 699.07, 'duration': 3.483}, {'end': 708.679, 'text': 'which also is a part of our bi desktop, and then finally update our catalog management Gateway, power biq and a and power bi service,', 'start': 702.853, 'duration': 5.826}, {'end': 709.92, 'text': 'which are obviously the service components.', 'start': 708.679, 'duration': 1.241}, {'end': 714.664, 'text': 'Okay, obviously there are a few things which keep changing in the overall ecosystem.', 'start': 710.42, 'duration': 4.244}, {'end': 720.19, 'text': 'So remember one thing you have to understand in power bi is that the product is very very frequently updated.', 'start': 714.845, 'duration': 5.345}, {'end': 723.253, 'text': 'So for instance, the power bi desktop gets updated every month.', 'start': 720.31, 'duration': 2.943}], 'summary': 'Power bi includes power query, power pivot, and power view, all part of power bi desktop. power map is also part of power bi desktop, with monthly updates.', 'duration': 28.566, 'max_score': 694.687, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs694687.jpg'}, {'end': 752.923, 'src': 'embed', 'start': 727.598, 'weight': 8, 'content': [{'end': 733.546, 'text': 'and the power bi service, which obviously lives on the cloud, that shoots out updates like every week, probably multiple times a week.', 'start': 727.598, 'duration': 5.948}, {'end': 738.793, 'text': 'okay, the new features getting added every single time and the reason why i mentioned this is because of the q and a feature.', 'start': 733.546, 'duration': 5.247}, {'end': 743.278, 'text': 'remember q, and a feature for a long time has been on the service And I just mentioned a while back.', 'start': 738.793, 'duration': 4.485}, {'end': 744.418, 'text': 'the Q&A feature is in the service.', 'start': 743.278, 'duration': 1.14}, {'end': 748.42, 'text': 'It is still in the service, but then in the desktop, it has very recently been included as a preview feature.', 'start': 744.438, 'duration': 3.982}, {'end': 752.923, 'text': 'Okay. So, when you talk about these things, if you have an understanding of what are the recent updates,', 'start': 748.721, 'duration': 4.202}], 'summary': 'Power bi service updates frequently, including q&a feature in desktop as preview.', 'duration': 25.325, 'max_score': 727.598, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs727598.jpg'}], 'start': 239.822, 'title': 'Self-service bi and excel bi vs power bi', 'summary': "Emphasizes the relevance of self-service bi in the broader landscape, integration of power bi with excel bi toolkit in microsoft's bi solution, and the comparison of excel bi and power bi components including the architecture of power bi desktop as a client tool and the addition of q&a feature to power bi desktop as a preview.", 'chapters': [{'end': 449.689, 'start': 239.822, 'title': 'The power of self-service business intelligence', 'summary': "Emphasizes the self-service aspect of ssbi, its relevance in the broader bi landscape, and the integration of power bi with excel bi toolkit in microsoft's bi solution.", 'duration': 209.867, 'highlights': ["The chapter emphasizes the self-service aspect of SSBI, its relevance in the broader BI landscape, and the integration of Power BI with Excel BI toolkit in Microsoft's BI solution. The self-service aspect of SSBI is highlighted, and its significance in the broader BI landscape is emphasized, with specific mention of Power BI's integration with Excel BI toolkit in Microsoft's BI solution.", "SSBI allows business users to build reports independently, making it a win-win situation, and it's an easy process for anyone with basic data understanding to create intuitive and shareable dashboards. SSBI empowers business users to independently build reports, creating a win-win situation, and it is a user-friendly process for individuals with basic data understanding to generate intuitive and shareable dashboards.", 'The dominance of SSBI tools like Tableau, Spotify, Qlik Sense in the data visualization landscape, and the revolutionary impact of tools like Alteryx in analytics are mentioned. The prevalence of SSBI tools such as Tableau, Spotify, and Qlik Sense in the data visualization landscape is highlighted, along with the revolutionary impact of tools like Alteryx in analytics.', "The origin of Power BI from Excel's add-in components like Power Query, Power Pivot, and Power View is explained, emphasizing Power BI's evolution from Excel's existing features. The evolution of Power BI from Excel's add-in components like Power Query, Power Pivot, and Power View is detailed, highlighting Power BI's development from pre-existing features in Excel."]}, {'end': 867.063, 'start': 450.109, 'title': 'Comparison of excel bi and power bi components', 'summary': 'Explains the similarities and differences between excel bi and power bi components, emphasizing the identical features, the architecture of power bi desktop as a client tool, and the frequent updates in power bi, including the addition of q&a feature to power bi desktop as a preview.', 'duration': 416.954, 'highlights': ['The behavior of Excel BI and Power BI components are exactly the same, with very minute differences, borrowing most features from each other. The components of Excel BI and Power BI are nearly identical, with very minor differences.', 'Power BI desktop packages all components in one single solution tool, presenting it as a neater and easier-to-use solution. Power BI desktop offers a clean and efficient solution by packaging all components into a single tool.', 'Excel is also a powerful self-service BI solution, even without using Power BI components like Power Query, Power View, or Power Pivot. Excel serves as a powerful self-service BI solution, capable of creating pivot tables and charts even without Power BI components.', 'Power BI Desktop is a client tool in the client-server architecture of Power BI, used for report development and visualization, while the Power BI service is where the reports are published onto the cloud. Power BI Desktop serves as the client tool for report development, while the Power BI service is used for publishing reports to the cloud.', 'The Power BI ecosystem consists of components such as Power Query, Power Pivot, Power View, Power Map, Data Management Gateway, Power BI Q&A, and Power BI service. The Power BI ecosystem includes components like Power Query, Power Pivot, Power View, Power Map, Data Management Gateway, Power BI Q&A, and Power BI service.', 'Power BI Desktop is updated monthly, while the Power BI service receives updates weekly, with features like Q&A being included in both the service and desktop as a recent update. Power BI Desktop and service receive frequent updates, with recent additions like the Q&A feature being included in both.']}], 'duration': 627.241, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs239822.jpg', 'highlights': ["The self-service aspect of SSBI is highlighted, emphasizing its relevance in the broader BI landscape and the integration of Power BI with Excel BI toolkit in Microsoft's BI solution.", 'SSBI empowers business users to independently build reports, creating a win-win situation, and it is a user-friendly process for individuals with basic data understanding to generate intuitive and shareable dashboards.', 'The prevalence of SSBI tools such as Tableau, Spotify, and Qlik Sense in the data visualization landscape is highlighted, along with the revolutionary impact of tools like Alteryx in analytics.', "The evolution of Power BI from Excel's add-in components like Power Query, Power Pivot, and Power View is detailed, emphasizing Power BI's development from pre-existing features in Excel.", 'Power BI desktop offers a clean and efficient solution by packaging all components into a single tool, presenting it as a neater and easier-to-use solution.', 'Excel serves as a powerful self-service BI solution, capable of creating pivot tables and charts even without Power BI components.', 'Power BI Desktop serves as the client tool for report development, while the Power BI service is used for publishing reports to the cloud.', 'The Power BI ecosystem includes components like Power Query, Power Pivot, Power View, Power Map, Data Management Gateway, Power BI Q&A, and Power BI service.', 'Power BI Desktop and service receive frequent updates, with recent additions like the Q&A feature being included in both.']}, {'end': 1714.175, 'segs': [{'end': 944.324, 'src': 'embed', 'start': 910.937, 'weight': 0, 'content': [{'end': 916.521, 'text': "Okay So that's the Q&A feature that is built right inside the Power BI desktop as a preview feature.", 'start': 910.937, 'duration': 5.584}, {'end': 919.139, 'text': 'And when you answer this question.', 'start': 917.839, 'duration': 1.3}, {'end': 923.68, 'text': 'the other important thing that I do want to mention here is just giving a brief description about all these components.', 'start': 919.139, 'duration': 4.541}, {'end': 926.401, 'text': 'Remember, guys, Power Query is the ETL component of Power BI Desktop.', 'start': 923.7, 'duration': 2.701}, {'end': 927.961, 'text': "So that's an ETL component.", 'start': 926.781, 'duration': 1.18}, {'end': 932.702, 'text': "So the idea in Power Query is you're taking your data, you're connecting to various sources and you're performing a very,", 'start': 927.981, 'duration': 4.721}, {'end': 935.263, 'text': 'very basic ETL operation there inside Power Query.', 'start': 932.702, 'duration': 2.561}, {'end': 941.424, 'text': 'Right So the idea is to just perform basic data cleansing operations, because remember, data from the source is never in the right shape.', 'start': 935.363, 'duration': 6.061}, {'end': 942.524, 'text': "It's never in the right format.", 'start': 941.484, 'duration': 1.04}, {'end': 944.324, 'text': "OK, it's what we call dirty data.", 'start': 942.744, 'duration': 1.58}], 'summary': 'Power bi desktop has a q&a feature, with power query as an etl component for basic data cleansing.', 'duration': 33.387, 'max_score': 910.937, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs910937.jpg'}, {'end': 1114.284, 'src': 'embed', 'start': 1079.637, 'weight': 2, 'content': [{'end': 1085.38, 'text': 'the data goes to power pivot and power pivot is nothing but an in-memory columnar database where your data gets loaded.', 'start': 1079.637, 'duration': 5.743}, {'end': 1086.28, 'text': "okay, that's your data model.", 'start': 1085.38, 'duration': 0.9}, {'end': 1087.561, 'text': 'in other words, we call it our data model.', 'start': 1086.28, 'duration': 1.281}, {'end': 1093.027, 'text': 'So the idea is that you perform your ETL, you clean your data and then you load your data into the power pivot model.', 'start': 1087.941, 'duration': 5.086}, {'end': 1097.012, 'text': "Okay, and from there, you're going to visualize your data using power view.", 'start': 1093.267, 'duration': 3.745}, {'end': 1102.818, 'text': "Okay, that's the very very basic process that we have in the Power BI desktop the same as we have in Excel.", 'start': 1097.212, 'duration': 5.606}, {'end': 1106.563, 'text': 'Okay, if even if you use the Excel bi components, it will pretty much be the same thing.', 'start': 1102.878, 'duration': 3.685}, {'end': 1109.323, 'text': "and just to give you a brief glimpse of that, i'll not talk a lot about it.", 'start': 1106.923, 'duration': 2.4}, {'end': 1110.144, 'text': "i've opened up my excel.", 'start': 1109.323, 'duration': 0.821}, {'end': 1114.284, 'text': 'remember, i have opened up excel, but i also have the add-in components loaded.', 'start': 1110.144, 'duration': 4.14}], 'summary': 'Data is loaded into power pivot for visualization using power view in power bi or excel.', 'duration': 34.647, 'max_score': 1079.637, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs1079637.jpg'}, {'end': 1455.81, 'src': 'embed', 'start': 1426.624, 'weight': 4, 'content': [{'end': 1428.326, 'text': 'What are the sources that Power BI can connect to?', 'start': 1426.624, 'duration': 1.702}, {'end': 1430.308, 'text': 'Actually, there is infinite.', 'start': 1428.746, 'duration': 1.562}, {'end': 1433.11, 'text': 'So ideally, there are a lot of sources Power BI can connect to.', 'start': 1431.068, 'duration': 2.042}, {'end': 1435.353, 'text': 'If you go to get data, this is only from the desktop.', 'start': 1433.311, 'duration': 2.042}, {'end': 1437.995, 'text': 'From the desktop, it can connect to a wide range of sources.', 'start': 1435.893, 'duration': 2.102}, {'end': 1439.216, 'text': 'So you can go to more.', 'start': 1438.375, 'duration': 0.841}, {'end': 1442.019, 'text': 'You can just take a look at the available sources that Power BI can connect to.', 'start': 1439.236, 'duration': 2.783}, {'end': 1449.887, 'text': 'We saw an example with Excel, but you can connect to files, XML, JSON, databases, ton of databases that you have.', 'start': 1442.339, 'duration': 7.548}, {'end': 1453.769, 'text': "okay, and if you don't see anything here, you can obviously set up an odbc connection.", 'start': 1450.487, 'duration': 3.282}, {'end': 1455.81, 'text': 'very easy to set up an odbc connection also.', 'start': 1453.769, 'duration': 2.041}], 'summary': 'Power bi can connect to a wide range of sources including files, xml, json, and databases, with the ability to set up an odbc connection.', 'duration': 29.186, 'max_score': 1426.624, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs1426624.jpg'}], 'start': 867.103, 'title': 'Power bi desktop features and operations', 'summary': 'Introduces the q&a feature in power bi desktop for asking questions and visualized answers, emphasizing data cleansing in power query. it also covers etl operations, data model loading, connectivity, and excel linking with practical web data examples.', 'chapters': [{'end': 975.375, 'start': 867.103, 'title': 'Power bi desktop q&a feature', 'summary': 'Introduces the q&a feature in power bi desktop, which allows users to ask questions and receive visualized answers, and emphasizes the importance of data cleansing in the etl component, power query.', 'duration': 108.272, 'highlights': ["The Q&A feature in Power BI Desktop allows users to ask questions and receive visualized answers. Users can double click on the Q&A feature to ask questions like 'sales by region' and visualize the data as a pie chart or a table.", 'The ETL component, Power Query, focuses on performing basic data cleansing operations. Power Query helps in connecting to various sources, performing basic ETL operations, and cleaning the dirty data before using it for analysis.']}, {'end': 1714.175, 'start': 975.755, 'title': 'Power bi desktop operations', 'summary': 'Covers the basics of performing etl operations in power bi desktop, including etl steps, data model loading, data source connectivity, and content pack consumption. it emphasizes the importance of linking power bi to excel and provides practical examples of web data connectivity.', 'duration': 738.42, 'highlights': ['Power Query, Power Pivot, and Power View are fundamental steps in performing ETL operations in Power BI Desktop, followed by visualization using Power View. The ETL process involves Power Query for data transformation, Power Pivot for in-memory columnar database loading, and Power View for data visualization.', 'Power BI Desktop is closely linked to Excel, sharing similar interfaces and components, emphasizing the importance of understanding their parallel functionalities. The connection between Power BI and Excel is underscored, highlighting their similarities in interfaces and functionalities.', 'Power BI Desktop can connect to a wide range of data sources, including files, databases, web data, and content packs, with practical examples demonstrating web data connectivity and content pack consumption. Power BI Desktop offers extensive data source connectivity, exemplified by practical demonstrations of web data connectivity and content pack consumption.']}], 'duration': 847.072, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs867103.jpg', 'highlights': ['The Q&A feature in Power BI Desktop allows users to ask questions and receive visualized answers.', 'Power Query helps in connecting to various sources, performing basic ETL operations, and cleaning the dirty data before using it for analysis.', 'Power Query, Power Pivot, and Power View are fundamental steps in performing ETL operations in Power BI Desktop, followed by visualization using Power View.', 'Power BI Desktop is closely linked to Excel, sharing similar interfaces and components, emphasizing the importance of understanding their parallel functionalities.', 'Power BI Desktop can connect to a wide range of data sources, including files, databases, web data, and content packs, with practical examples demonstrating web data connectivity and content pack consumption.']}, {'end': 2451.117, 'segs': [{'end': 1769.044, 'src': 'embed', 'start': 1741.532, 'weight': 0, 'content': [{'end': 1747.274, 'text': 'okay, from the service also, you get a very robust set of options to connect to data, where you not only can connect to files, databases,', 'start': 1741.532, 'duration': 5.742}, {'end': 1754.637, 'text': 'you can connect to files from here, onedrive local files, connect to databases, issue databases, and you can also connect onto services.', 'start': 1747.274, 'duration': 7.363}, {'end': 1755.197, 'text': 'and further,', 'start': 1754.637, 'duration': 0.56}, {'end': 1762.94, 'text': "you can also connect onto your organizational content packs if you're working for an organization and you can also connect onto any organizational content packs that people in your organization have developed.", 'start': 1755.197, 'duration': 7.743}, {'end': 1769.044, 'text': 'Okay so, services are basically content packs from online services, typical online services like Bing, Salesforce and all that.', 'start': 1763.5, 'duration': 5.544}], 'summary': 'Service offers robust data connection options, including files, databases, and organizational content packs from online services like bing and salesforce.', 'duration': 27.512, 'max_score': 1741.532, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs1741532.jpg'}, {'end': 1829.614, 'src': 'embed', 'start': 1801.454, 'weight': 2, 'content': [{'end': 1803.816, 'text': 'talk about those components and then come to the building blocks.', 'start': 1801.454, 'duration': 2.362}, {'end': 1809.12, 'text': 'the building blocks, obviously, are the data sets, the visualizations, the dashboards, the tiles,', 'start': 1803.816, 'duration': 5.304}, {'end': 1815.885, 'text': 'which are some of the most fundamental things that you have in power bi, just to just to give you a brief context about what this stuff is.', 'start': 1809.12, 'duration': 6.765}, {'end': 1819.488, 'text': "so when you build your stuff in power bi desktop, obviously you're working with three main tabs.", 'start': 1815.885, 'duration': 3.603}, {'end': 1821.029, 'text': 'primarily that is the.', 'start': 1819.488, 'duration': 1.541}, {'end': 1823.73, 'text': 'obviously, the query editor is where you did your etl.', 'start': 1821.029, 'duration': 2.701}, {'end': 1826.812, 'text': "you loaded your data into the model and then you'll come to the data tab.", 'start': 1823.73, 'duration': 3.082}, {'end': 1829.614, 'text': 'data tab is where you can actually view your model tables.', 'start': 1826.812, 'duration': 2.802}], 'summary': 'Power bi consists of components like data sets, visualizations, dashboards, and tiles, with three main tabs for working and viewing model tables.', 'duration': 28.16, 'max_score': 1801.454, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs1801454.jpg'}, {'end': 1898.153, 'src': 'embed', 'start': 1870.859, 'weight': 1, 'content': [{'end': 1874.061, 'text': 'right, if you look at this particular thing that I published, I created only a single line chart.', 'start': 1870.859, 'duration': 3.202}, {'end': 1876.822, 'text': 'now I can opt to add one more visual to my report.', 'start': 1874.061, 'duration': 2.761}, {'end': 1879.183, 'text': 'so what I can do is I can look at my report here.', 'start': 1876.822, 'duration': 2.361}, {'end': 1885.446, 'text': 'and another beautiful thing about the service and again something that all of you can mention here is the editing capabilities in the service that Power BI gives you.', 'start': 1879.183, 'duration': 6.263}, {'end': 1887.607, 'text': 'so you can edit a report straight within the service.', 'start': 1885.446, 'duration': 2.161}, {'end': 1891.989, 'text': 'so the amazing feature where you get a very, very desktop like interface right within the service.', 'start': 1887.607, 'duration': 4.382}, {'end': 1898.153, 'text': "remember, however, when you mention this part, do mention that you can't build models and you can't do query editing within the service.", 'start': 1891.989, 'duration': 6.164}], 'summary': 'The power bi service allows for easy report editing, but it lacks model building and query editing capabilities.', 'duration': 27.294, 'max_score': 1870.859, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs1870859.jpg'}, {'end': 2090.089, 'src': 'embed', 'start': 2062.274, 'weight': 4, 'content': [{'end': 2067.438, 'text': 'reports, visual filters, page level filters, report level filters and real, true filters are the very, very important question.', 'start': 2062.274, 'duration': 5.164}, {'end': 2071.719, 'text': 'So typically the way to answer this question is to go back and take its scenarios.', 'start': 2067.858, 'duration': 3.861}, {'end': 2077.844, 'text': 'Now, what are the scenarios where you will implement each type of filter? So visual level filters obviously is present only at the visual level.', 'start': 2071.86, 'duration': 5.984}, {'end': 2080.446, 'text': 'So it is only you can think of it like a report level filter.', 'start': 2077.904, 'duration': 2.542}, {'end': 2083.748, 'text': "It's present only in a particular type of report particular type of chart.", 'start': 2080.545, 'duration': 3.203}, {'end': 2090.089, 'text': 'okay, so when you come back here and come back to the desktop and if you take a look at it, you will see that line chart that i built here,', 'start': 2084.326, 'duration': 5.763}], 'summary': 'Different types of filters have specific implementation scenarios, such as visual level filters present only at the visual level.', 'duration': 27.815, 'max_score': 2062.274, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2062274.jpg'}, {'end': 2323.858, 'src': 'embed', 'start': 2297.103, 'weight': 5, 'content': [{'end': 2302.826, 'text': "okay, this again came very recently and it's again a very new feature, but it's always a very, very useful feature,", 'start': 2297.103, 'duration': 5.723}, {'end': 2313.333, 'text': "because drill through reports is something that if you have worked across other tools enterprise reporting tools it's a very common feature where you click on a particular item and you want to go to another page where you're filtered with that particular item.", 'start': 2302.826, 'duration': 10.507}, {'end': 2315.014, 'text': 'okay, and this is a very, very useful case.', 'start': 2313.333, 'duration': 1.681}, {'end': 2318.276, 'text': "right, it's a very, very useful scenario where it enables you to do that right.", 'start': 2315.014, 'duration': 3.262}, {'end': 2323.858, 'text': 'so you can not only configure stuff in in one page, but you can actually configure stuff in another page.', 'start': 2318.676, 'duration': 5.182}], 'summary': 'New feature allows drill through reports for enhanced configuration and filtering.', 'duration': 26.755, 'max_score': 2297.103, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2297103.jpg'}], 'start': 1714.175, 'title': 'Power bi features and building blocks', 'summary': 'Covers the features of power bi service, including content packs and data connection options, along with the ability to edit, download, and export reports. it also explains the building blocks in power bi, such as data sets, visuals, reports, dashboards, and tiles, as well as various types of filters and their implementation scenarios.', 'chapters': [{'end': 2027.324, 'start': 1714.175, 'title': 'Power bi content packs and service features', 'summary': 'Illustrates the features of power bi service, emphasizing the content packs, data connection options, and the capabilities of the service, along with the ability to edit, download, and export reports.', 'duration': 313.149, 'highlights': ['The Power BI service offers robust data connection options including files, databases, and organizational content packs, along with editing capabilities within the service. The Power BI service provides various data connection options, such as connecting to files, databases, and organizational content packs, and also allows editing reports within the service.', "The chapter emphasizes the building blocks of Power BI, including data sets, visualizations, dashboards, and tiles, providing a holistic view of the architecture. The building blocks of Power BI, such as data sets, visualizations, dashboards, and tiles, are highlighted, offering a comprehensive understanding of the platform's architecture.", 'The capabilities of Power BI service enable users to edit reports, create multiple pages with various visuals, and download and export reports, enhancing self-service BI capabilities. The Power BI service allows users to edit reports, create multiple pages with diverse visuals, and download and export reports, showcasing its self-service BI capabilities.']}, {'end': 2451.117, 'start': 2027.624, 'title': 'Power bi building blocks and filters', 'summary': 'Explains the building blocks in power bi, including data sets, visuals, reports, dashboards, and tiles, as well as the different types of filters such as visual level filters, page level filters, report level filters, and drill through filters, and their implementation scenarios.', 'duration': 423.493, 'highlights': ['Explanation of building blocks in Power BI The transcript explains the primary building blocks in Power BI, including data sets, visuals, reports, dashboards, and tiles, and their interrelationships in creating reports and dashboards.', 'Types of filters in Power BI The discussion covers the various types of filters in Power BI, such as visual level filters, page level filters, report level filters, and drill through filters, along with detailed explanations of their implementation scenarios.', 'Implementation of drill through feature The explanation includes the implementation of the drill through feature in Power BI, providing scenarios and use cases for configuring drill through filters and the utility of this feature in enabling navigation between different pages for detailed insights.']}], 'duration': 736.942, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs1714175.jpg', 'highlights': ['The Power BI service offers robust data connection options including files, databases, and organizational content packs, along with editing capabilities within the service.', 'The capabilities of Power BI service enable users to edit reports, create multiple pages with various visuals, and download and export reports, enhancing self-service BI capabilities.', 'The chapter emphasizes the building blocks of Power BI, including data sets, visualizations, dashboards, and tiles, providing a holistic view of the architecture.', 'Explanation of building blocks in Power BI, including data sets, visuals, reports, dashboards, and tiles, and their interrelationships in creating reports and dashboards.', 'Types of filters in Power BI, such as visual level filters, page level filters, report level filters, and drill through filters, along with detailed explanations of their implementation scenarios.', 'Implementation of the drill through feature in Power BI, providing scenarios and use cases for configuring drill through filters and the utility of this feature in enabling navigation between different pages for detailed insights.']}, {'end': 3133.846, 'segs': [{'end': 2527.246, 'src': 'heatmap', 'start': 2460.586, 'weight': 0.95, 'content': [{'end': 2465.793, 'text': "you want to see all the products of that particular subcategory, and that's how you get to see all the products of that particular subcategory.", 'start': 2460.586, 'duration': 5.207}, {'end': 2467.355, 'text': "okay, so that's the idea of drill through filters.", 'start': 2465.793, 'duration': 1.562}, {'end': 2472.502, 'text': "again, it's a very, very important concept, very, very powerful feature in power bi, and it's very important that you mention that.", 'start': 2467.355, 'duration': 5.147}, {'end': 2477.316, 'text': 'okay, so those are the main types of filters that you have in power bi desktop Content packs and apps.', 'start': 2472.502, 'duration': 4.814}, {'end': 2478.237, 'text': 'I think I covered that already.', 'start': 2477.356, 'duration': 0.881}, {'end': 2480.118, 'text': 'So just skip to that right now.', 'start': 2478.417, 'duration': 1.701}, {'end': 2481.939, 'text': 'DAX, very, very important part, guys.', 'start': 2480.358, 'duration': 1.581}, {'end': 2486.642, 'text': 'And obviously DAX is a functional language, very important piece in the overall Power BI desktop stack.', 'start': 2482.059, 'duration': 4.583}, {'end': 2493.045, 'text': 'Remember in Power BI whenever you talk about Power BI and something that you guys will anyways mention when you talk about the components.', 'start': 2487.042, 'duration': 6.003}, {'end': 2494.606, 'text': 'obviously you guys talked about Power Query.', 'start': 2493.045, 'duration': 1.561}, {'end': 2497.668, 'text': 'There was an instance where I actually wrote a custom column.', 'start': 2495.026, 'duration': 2.642}, {'end': 2499.709, 'text': 'i actually added a custom column a while back.', 'start': 2497.668, 'duration': 2.041}, {'end': 2505.052, 'text': 'okay, remember that cost column i added where i tried a very simple expression called sales minus profit.', 'start': 2499.709, 'duration': 5.343}, {'end': 2507.694, 'text': "so the language behind the scenes that's being written is called m code.", 'start': 2505.052, 'duration': 2.642}, {'end': 2509.535, 'text': "okay, so it's called m code.", 'start': 2507.694, 'duration': 1.841}, {'end': 2513.237, 'text': 'so power query is equivalent to m, whereas power pivot is equivalent to tax.', 'start': 2509.535, 'duration': 3.702}, {'end': 2515.539, 'text': 'okay, the underlying language that you use in power pivot is tax,', 'start': 2513.237, 'duration': 2.302}, {'end': 2519.741, 'text': 'whereas the underlying language that you write in Power Query is essentially called M.', 'start': 2516.019, 'duration': 3.722}, {'end': 2522.983, 'text': 'And just to give you a very, very brief flavor of M what it is.', 'start': 2519.741, 'duration': 3.242}, {'end': 2527.246, 'text': 'and if you go to edit queries here, remember, all these queries are nothing but a combination of steps.', 'start': 2522.983, 'duration': 4.263}], 'summary': 'Power bi features include drill-through filters, dax language, and m code for power query and power pivot.', 'duration': 66.66, 'max_score': 2460.586, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2460586.jpg'}, {'end': 2494.606, 'src': 'embed', 'start': 2465.793, 'weight': 0, 'content': [{'end': 2467.355, 'text': "okay, so that's the idea of drill through filters.", 'start': 2465.793, 'duration': 1.562}, {'end': 2472.502, 'text': "again, it's a very, very important concept, very, very powerful feature in power bi, and it's very important that you mention that.", 'start': 2467.355, 'duration': 5.147}, {'end': 2477.316, 'text': 'okay, so those are the main types of filters that you have in power bi desktop Content packs and apps.', 'start': 2472.502, 'duration': 4.814}, {'end': 2478.237, 'text': 'I think I covered that already.', 'start': 2477.356, 'duration': 0.881}, {'end': 2480.118, 'text': 'So just skip to that right now.', 'start': 2478.417, 'duration': 1.701}, {'end': 2481.939, 'text': 'DAX, very, very important part, guys.', 'start': 2480.358, 'duration': 1.581}, {'end': 2486.642, 'text': 'And obviously DAX is a functional language, very important piece in the overall Power BI desktop stack.', 'start': 2482.059, 'duration': 4.583}, {'end': 2493.045, 'text': 'Remember in Power BI whenever you talk about Power BI and something that you guys will anyways mention when you talk about the components.', 'start': 2487.042, 'duration': 6.003}, {'end': 2494.606, 'text': 'obviously you guys talked about Power Query.', 'start': 2493.045, 'duration': 1.561}], 'summary': 'Drill through filters and dax are important in power bi.', 'duration': 28.813, 'max_score': 2465.793, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2465793.jpg'}, {'end': 2552.3, 'src': 'embed', 'start': 2527.866, 'weight': 2, 'content': [{'end': 2534.09, 'text': 'And if you want to look at just a brief idea of what is M, go to view, go to advanced editor, and you can take a look at the M query syntax here.', 'start': 2527.866, 'duration': 6.224}, {'end': 2536.832, 'text': "Okay, that's the M query syntax that is highlighted for you here.", 'start': 2534.31, 'duration': 2.522}, {'end': 2542.976, 'text': 'So remember, this is existing in Query Editor, whereas Power Pivot is something, DAX is something that exists in Power Pivot.', 'start': 2537.152, 'duration': 5.824}, {'end': 2544.517, 'text': 'So where do you see DAX?', 'start': 2543.376, 'duration': 1.141}, {'end': 2552.3, 'text': 'you can go to the modeling tab or you can just enter the modeling from here and go to new column and you can just start typing in your DAX queries here.', 'start': 2545.017, 'duration': 7.283}], 'summary': "The m query syntax is found in query editor, while dax queries are entered in power pivot's modeling tab or new column.", 'duration': 24.434, 'max_score': 2527.866, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2527866.jpg'}, {'end': 2601.344, 'src': 'embed', 'start': 2574.487, 'weight': 1, 'content': [{'end': 2582.212, 'text': "It's very important that you mention a couple of things like it's a functional language and give some examples of how Dax is related to stuff that you can do in the power pivot,", 'start': 2574.487, 'duration': 7.725}, {'end': 2588.877, 'text': 'that is, in the data model, and essentially it helps you add more meaning to your data, because your underlying data could be in a certain format,', 'start': 2582.212, 'duration': 6.665}, {'end': 2590.057, 'text': 'but there are certain kinds of calculations.', 'start': 2588.877, 'duration': 1.18}, {'end': 2595.581, 'text': "there's something kind of complex measures that you want to add, which could only be done in the power pivot layer and nowhere else.", 'start': 2590.057, 'duration': 5.524}, {'end': 2601.344, 'text': 'okay, and we look at some examples of this just in a bit of certain things that you can do only in the power pivot layer and nowhere else.', 'start': 2595.581, 'duration': 5.763}], 'summary': 'Dax in power pivot adds meaning to data with complex measures, unique to power pivot layer.', 'duration': 26.857, 'max_score': 2574.487, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2574487.jpg'}, {'end': 2642.571, 'src': 'embed', 'start': 2613.95, 'weight': 3, 'content': [{'end': 2617.675, 'text': 'Again, this goes to show the length and breadth of your overall knowledge of DAX,', 'start': 2613.95, 'duration': 3.725}, {'end': 2623.682, 'text': 'because any kind of job interviews on Power BI DAX is an integral component, because people expect you to be good in DAX.', 'start': 2617.675, 'duration': 6.007}, {'end': 2627.846, 'text': "right?. Because it's not all about the visualization layer, is not all about point and click.", 'start': 2623.682, 'duration': 4.164}, {'end': 2629.146, 'text': 'click on a visual, you get a visual.', 'start': 2627.846, 'duration': 1.3}, {'end': 2635.848, 'text': 'uh, knowing the underlying features, which is fine, but people do expect you to understand the the dax queries very, very well, and not only dax,', 'start': 2629.146, 'duration': 6.702}, {'end': 2637.829, 'text': 'even at some level the m query language also.', 'start': 2635.848, 'duration': 1.981}, {'end': 2642.571, 'text': 'you need to be good at at least at least have a basic understanding so that if there are errors you want to do some debugging,', 'start': 2637.829, 'duration': 4.742}], 'summary': 'Understanding dax and m query language is crucial for power bi job interviews.', 'duration': 28.621, 'max_score': 2613.95, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2613950.jpg'}, {'end': 2705.013, 'src': 'heatmap', 'start': 2642.571, 'weight': 0.704, 'content': [{'end': 2645.272, 'text': "at least you're able to pinpoint on on those issues.", 'start': 2642.571, 'duration': 2.701}, {'end': 2647.472, 'text': 'okay, filter function it goes hand in hand with calculate.', 'start': 2645.272, 'duration': 2.2}, {'end': 2652.374, 'text': 'basically, and this is again a very, very important component in power bi desktop and something that you will use a lot,', 'start': 2647.472, 'duration': 4.902}, {'end': 2655.135, 'text': 'and you know whether you know any other function or not.', 'start': 2652.974, 'duration': 2.161}, {'end': 2657.796, 'text': 'this is one function that you have to know and have to understand.', 'start': 2655.135, 'duration': 2.661}, {'end': 2661.198, 'text': 'okay, and calculate function basically operates in the filter context.', 'start': 2657.796, 'duration': 3.402}, {'end': 2665.64, 'text': "i'll just briefly explain to you what this is and what are some of the use cases behind using it.", 'start': 2661.198, 'duration': 4.442}, {'end': 2669.261, 'text': "so what i will do here is, i'll create a very simple table.", 'start': 2665.64, 'duration': 3.621}, {'end': 2675.184, 'text': "so what i have here is a is an example where let's say i have here okay, so i have your information.", 'start': 2669.261, 'duration': 5.923}, {'end': 2677.76, 'text': "I'll take order date and I'll take sales information.", 'start': 2675.839, 'duration': 1.921}, {'end': 2679.56, 'text': "Okay, so I'm seeing a bar chart.", 'start': 2677.96, 'duration': 1.6}, {'end': 2684.382, 'text': "I'll convert this to a table and right now what you're seeing is a very nice tabular information right now.", 'start': 2679.6, 'duration': 4.782}, {'end': 2686.923, 'text': 'What I want to know is a percentage.', 'start': 2684.903, 'duration': 2.02}, {'end': 2689.464, 'text': "Okay, so let's say the scenario is that I need to know.", 'start': 2687.324, 'duration': 2.14}, {'end': 2694.306, 'text': "Okay, right now what I'm seeing is the total sales across the total, absolute value of sales, right?", 'start': 2689.844, 'duration': 4.462}, {'end': 2698.488, 'text': 'But what if I want to quickly figure out the percentage of the total?', 'start': 2694.586, 'duration': 3.902}, {'end': 2705.013, 'text': "so, for instance, right now you're looking at quarter wise, or maybe another good example will be taking subcategory instead of taking order.", 'start': 2698.988, 'duration': 6.025}], 'summary': 'Understanding the calculate function in power bi, used for context filtering and percentage calculation.', 'duration': 62.442, 'max_score': 2642.571, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2642571.jpg'}, {'end': 2675.184, 'src': 'embed', 'start': 2645.272, 'weight': 4, 'content': [{'end': 2647.472, 'text': 'okay, filter function it goes hand in hand with calculate.', 'start': 2645.272, 'duration': 2.2}, {'end': 2652.374, 'text': 'basically, and this is again a very, very important component in power bi desktop and something that you will use a lot,', 'start': 2647.472, 'duration': 4.902}, {'end': 2655.135, 'text': 'and you know whether you know any other function or not.', 'start': 2652.974, 'duration': 2.161}, {'end': 2657.796, 'text': 'this is one function that you have to know and have to understand.', 'start': 2655.135, 'duration': 2.661}, {'end': 2661.198, 'text': 'okay, and calculate function basically operates in the filter context.', 'start': 2657.796, 'duration': 3.402}, {'end': 2665.64, 'text': "i'll just briefly explain to you what this is and what are some of the use cases behind using it.", 'start': 2661.198, 'duration': 4.442}, {'end': 2669.261, 'text': "so what i will do here is, i'll create a very simple table.", 'start': 2665.64, 'duration': 3.621}, {'end': 2675.184, 'text': "so what i have here is a is an example where let's say i have here okay, so i have your information.", 'start': 2669.261, 'duration': 5.923}], 'summary': 'Filter and calculate functions are vital components in power bi desktop, crucial to understand and use extensively.', 'duration': 29.912, 'max_score': 2645.272, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2645272.jpg'}, {'end': 2793.553, 'src': 'embed', 'start': 2762.617, 'weight': 6, 'content': [{'end': 2765.758, 'text': 'okay, there is also another revolutionary feature called measures.', 'start': 2762.617, 'duration': 3.141}, {'end': 2769.179, 'text': 'so again, there are some lot of new things that you have in power bi.', 'start': 2765.758, 'duration': 3.421}, {'end': 2771.64, 'text': "there's something called quick measures that you can also implement.", 'start': 2769.179, 'duration': 2.461}, {'end': 2776.883, 'text': "but again, remember, whenever you're doing any of this stuff, uh, behind the scenes, you are implementing, uh, dax.", 'start': 2771.64, 'duration': 5.243}, {'end': 2778.704, 'text': 'okay, you have some new quick measures.', 'start': 2776.883, 'duration': 1.821}, {'end': 2782.326, 'text': 'if i go to new quick measures, i will see a ton of stuff that i can build in power bi.', 'start': 2778.704, 'duration': 3.622}, {'end': 2786.389, 'text': 'okay, you can just take a look at this now and you can see a ton of stuff that you can do here.', 'start': 2782.326, 'duration': 4.063}, {'end': 2789.451, 'text': 'okay, and again there are a lot of these things tend to be added from time to time.', 'start': 2786.389, 'duration': 3.062}, {'end': 2790.732, 'text': 'new things can to be released.', 'start': 2789.451, 'duration': 1.281}, {'end': 2793.553, 'text': 'you can see time intelligence calculations, totals, running totals.', 'start': 2790.732, 'duration': 2.821}], 'summary': 'Power bi introduces new quick measures and time intelligence calculations.', 'duration': 30.936, 'max_score': 2762.617, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2762617.jpg'}, {'end': 2828.275, 'src': 'heatmap', 'start': 2762.617, 'weight': 0.731, 'content': [{'end': 2765.758, 'text': 'okay, there is also another revolutionary feature called measures.', 'start': 2762.617, 'duration': 3.141}, {'end': 2769.179, 'text': 'so again, there are some lot of new things that you have in power bi.', 'start': 2765.758, 'duration': 3.421}, {'end': 2771.64, 'text': "there's something called quick measures that you can also implement.", 'start': 2769.179, 'duration': 2.461}, {'end': 2776.883, 'text': "but again, remember, whenever you're doing any of this stuff, uh, behind the scenes, you are implementing, uh, dax.", 'start': 2771.64, 'duration': 5.243}, {'end': 2778.704, 'text': 'okay, you have some new quick measures.', 'start': 2776.883, 'duration': 1.821}, {'end': 2782.326, 'text': 'if i go to new quick measures, i will see a ton of stuff that i can build in power bi.', 'start': 2778.704, 'duration': 3.622}, {'end': 2786.389, 'text': 'okay, you can just take a look at this now and you can see a ton of stuff that you can do here.', 'start': 2782.326, 'duration': 4.063}, {'end': 2789.451, 'text': 'okay, and again there are a lot of these things tend to be added from time to time.', 'start': 2786.389, 'duration': 3.062}, {'end': 2790.732, 'text': 'new things can to be released.', 'start': 2789.451, 'duration': 1.281}, {'end': 2793.553, 'text': 'you can see time intelligence calculations, totals, running totals.', 'start': 2790.732, 'duration': 2.821}, {'end': 2796.055, 'text': 'uh, star rating, really cool thing, you know, star rating.', 'start': 2793.553, 'duration': 2.502}, {'end': 2797.236, 'text': "it's an amazing feature.", 'start': 2796.055, 'duration': 1.181}, {'end': 2799.517, 'text': 'so you can actually give a star rating highest value.', 'start': 2797.236, 'duration': 2.281}, {'end': 2802.279, 'text': "let's say my highest value is going to be something like 250 000.", 'start': 2799.517, 'duration': 2.762}, {'end': 2805.821, 'text': "i'll probably say okay, that's my highest value, it's my lowest value.", 'start': 2802.279, 'duration': 3.542}, {'end': 2810.625, 'text': 'i can give the number of stars and i can enter a new quick measure called star rating.', 'start': 2805.821, 'duration': 4.804}, {'end': 2813.067, 'text': "okay, and now you can see behind the scenes i've actually got dax.", 'start': 2810.625, 'duration': 2.442}, {'end': 2817.13, 'text': "so whatever you're seeing here right now is actually a pretty complicated version of dax.", 'start': 2813.067, 'duration': 4.063}, {'end': 2822.994, 'text': 'okay. so whenever you create quick measures, any of these default point and click options behind the scenes probably is actually building that dax for you.', 'start': 2817.13, 'duration': 5.864}, {'end': 2828.275, 'text': "okay, this is actually pretty complicated bit of dax that's written and the final output is actually pretty neat.", 'start': 2823.394, 'duration': 4.881}], 'summary': 'Power bi introduces new quick measures and time intelligence calculations, with a variety of functionalities and a built-in dax implementation.', 'duration': 65.658, 'max_score': 2762.617, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2762617.jpg'}, {'end': 3076.238, 'src': 'embed', 'start': 3049.624, 'weight': 5, 'content': [{'end': 3054.706, 'text': 'okay, as you can see, i was very easily able to achieve that using a very, very simple piece of dax code involving calculate.', 'start': 3049.624, 'duration': 5.082}, {'end': 3060.187, 'text': 'okay, so this is just one use case of how you use calculate very, very important dax formula, calculate and filters,', 'start': 3054.706, 'duration': 5.481}, {'end': 3062.748, 'text': 'and something that gets asked all the time in interviews, Okay.', 'start': 3060.187, 'duration': 2.561}, {'end': 3064.81, 'text': "And the best part about this is it's dynamic.", 'start': 3063.128, 'duration': 1.682}, {'end': 3066.311, 'text': "So see how I've used subcategory here.", 'start': 3064.83, 'duration': 1.481}, {'end': 3069.553, 'text': "If you want to use something else, let's say you want to use a region, you can do that as well.", 'start': 3066.351, 'duration': 3.202}, {'end': 3070.234, 'text': "So I'll take a region.", 'start': 3069.573, 'duration': 0.661}, {'end': 3076.238, 'text': "I'll remove the subcategory and see how that entire formula adjusts automatically depending on the kind of calculation you're using.", 'start': 3070.274, 'duration': 5.964}], 'summary': 'Using simple dax code involving calculate, dynamic formula adjusts automatically.', 'duration': 26.614, 'max_score': 3049.624, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3049624.jpg'}, {'end': 3149.051, 'src': 'embed', 'start': 3116.276, 'weight': 8, 'content': [{'end': 3118.418, 'text': 'Obviously, DAX is another kind of functional language.', 'start': 3116.276, 'duration': 2.142}, {'end': 3119.058, 'text': 'So variables.', 'start': 3118.438, 'duration': 0.62}, {'end': 3129.004, 'text': 'one of the most important use cases is that it can be reused multiple times so as to avoid any kind of duplication or redundancy in your overall code.', 'start': 3119.058, 'duration': 9.946}, {'end': 3131.285, 'text': 'right, there are some other examples that we have on.', 'start': 3129.004, 'duration': 2.281}, {'end': 3133.846, 'text': 'you can specify what are some of the time intelligence functions.', 'start': 3131.285, 'duration': 2.561}, {'end': 3135.947, 'text': 'again, calculate is something that you can use for this.', 'start': 3133.846, 'duration': 2.101}, {'end': 3143.169, 'text': 'so we talked about calculate all and filter, and you can obviously use them in multiple ways to go ahead and create n number of different use cases.', 'start': 3135.947, 'duration': 7.222}, {'end': 3149.051, 'text': 'okay, this is one use case i mentioned, but you can obviously use calculate to create trading x month metrics via dax.', 'start': 3143.169, 'duration': 5.882}], 'summary': 'Dax allows variables to be reused to avoid code duplication, offering flexibility and efficiency in creating multiple use cases.', 'duration': 32.775, 'max_score': 3116.276, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3116276.jpg'}], 'start': 2451.117, 'title': 'Power bi dax functions', 'summary': "Covers the significance of drill through filters, the role of dax as a functional language, and the distinction between m code and dax in power bi. it also explains the calculate function's importance, usage, and application in calculating percentage of total sales and creating dynamic measures. additionally, it demonstrates using dax to create a dynamic sales percentage measure, emphasizing the calculate function's ability to adjust dynamically based on filters and grouping.", 'chapters': [{'end': 2645.272, 'start': 2451.117, 'title': 'Power bi filters and dax queries', 'summary': 'Covers the importance of drill through filters in power bi desktop, the role of dax as a functional language, and the distinction between m code in power query and dax in power pivot, highlighting the significance of understanding dax queries and functions for job interviews in power bi.', 'duration': 194.155, 'highlights': ['Drill through filters are a very important concept and a powerful feature in Power BI desktop, emphasizing the need to understand and mention its significance in job interviews in Power BI.', 'DAX is a functional language and a vital component in the Power BI desktop stack, playing a crucial role in adding more meaning to data and enabling the creation of complex measures in the data model.', 'Understanding the difference between M code in Power Query and DAX in Power Pivot is essential, as it showcases the distinct roles of these languages in Power BI and highlights the significance of being adept in DAX queries and functions for job interviews in Power BI.', 'Having a comprehensive knowledge of DAX functions is crucial for job interviews in Power BI, as it demonstrates the depth of understanding in DAX queries and the importance of being proficient in DAX for data analysis and visualization tasks.']}, {'end': 2871.657, 'start': 2645.272, 'title': 'Understanding calculate function in power bi', 'summary': 'Explains the importance and usage of the calculate function in power bi, showcasing its application in calculating percentage of total sales and creating dynamic measures using dax.', 'duration': 226.385, 'highlights': ['The Calculate function is a crucial component in Power BI and is used extensively to calculate percentages and create dynamic measures. The Calculate function is emphasized as a vital component in Power BI, used extensively to calculate percentages and create dynamic measures.', 'Demonstration of using Calculate function to calculate the percentage of total sales and its practical application in analyzing subcategory sales. The demonstration showcases the application of the Calculate function in calculating the percentage of total sales and its practical use in analyzing subcategory sales.', 'Explanation of using Quick Measures and how it simplifies the implementation of DAX for creating complex measures. The explanation of Quick Measures simplifying the implementation of DAX for creating complex measures is highlighted as a useful feature in Power BI.']}, {'end': 3133.846, 'start': 2871.657, 'title': 'Using dax to calculate sales percentage', 'summary': 'Explains how to use dax to create a dynamic sales percentage measure in power bi, emphasizing the importance of the calculate function and its ability to adjust dynamically based on filters and grouping, with a demonstration of its flexibility using variables and time intelligence functions.', 'duration': 262.189, 'highlights': ['The importance of the calculate function and its ability to dynamically adjust based on filters and grouping in Power BI The calculate function is highlighted as a crucial DAX formula for dynamically adjusting measures based on filters and grouping, with a demonstration of its flexibility in adjusting the calculation based on different visualizations.', 'The demonstration of using variables in DAX to avoid redundancy in the code and the ability to reuse them multiple times The use of variables in DAX is explained as a way to avoid redundancy in the code and to facilitate reusability, illustrating the benefits of using variables in DAX for efficient code.', 'The explanation of time intelligence functions and their application in Power BI The chapter introduces the concept of time intelligence functions in Power BI and their application, showcasing their relevance in performing time-based calculations and analysis.']}], 'duration': 682.729, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs2451117.jpg', 'highlights': ['Drill through filters are a powerful feature in Power BI, essential to understand for job interviews.', 'DAX is vital for adding meaning to data and creating complex measures in Power BI.', 'Understanding the distinction between M code and DAX is crucial for Power BI roles.', 'Comprehensive knowledge of DAX functions is crucial for demonstrating proficiency in Power BI.', 'The Calculate function is extensively used in Power BI to calculate percentages and create dynamic measures.', 'Demonstrating the practical application of the Calculate function in analyzing subcategory sales.', 'Quick Measures simplify the implementation of DAX for creating complex measures in Power BI.', 'The Calculate function dynamically adjusts based on filters and grouping in Power BI.', 'Using variables in DAX to avoid redundancy and facilitate reusability.', 'Introduction of time intelligence functions and their application in Power BI.']}, {'end': 3636.406, 'segs': [{'end': 3162.536, 'src': 'embed', 'start': 3133.846, 'weight': 3, 'content': [{'end': 3135.947, 'text': 'again, calculate is something that you can use for this.', 'start': 3133.846, 'duration': 2.101}, {'end': 3143.169, 'text': 'so we talked about calculate all and filter, and you can obviously use them in multiple ways to go ahead and create n number of different use cases.', 'start': 3135.947, 'duration': 7.222}, {'end': 3149.051, 'text': 'okay, this is one use case i mentioned, but you can obviously use calculate to create trading x month metrics via dax.', 'start': 3143.169, 'duration': 5.882}, {'end': 3150.792, 'text': "okay, it's a non-standard calendar, for instance.", 'start': 3149.051, 'duration': 1.741}, {'end': 3152.773, 'text': 'Okay, and you can see what we are doing here.', 'start': 3151.192, 'duration': 1.581}, {'end': 3155.674, 'text': 'as a second step is, we are using all again to remove existing filters.', 'start': 3152.773, 'duration': 2.901}, {'end': 3160.555, 'text': "Okay, remember, the concept of all is you're still applying the filter context, but the only difference is in all.", 'start': 3155.974, 'duration': 4.581}, {'end': 3162.536, 'text': "what you're saying is you're removing all the filters.", 'start': 3160.555, 'duration': 1.981}], 'summary': 'Using dax, calculate can create various use cases, including trading x month metrics on a non-standard calendar.', 'duration': 28.69, 'max_score': 3133.846, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3133846.jpg'}, {'end': 3191.782, 'src': 'embed', 'start': 3166.037, 'weight': 2, 'content': [{'end': 3173.12, 'text': "And this is the part where I talk a little bit about calculated columns, and an example that I will show you guys here is related to, let's say,", 'start': 3166.037, 'duration': 7.083}, {'end': 3174.06, 'text': 'profit percentage.', 'start': 3173.12, 'duration': 0.94}, {'end': 3178.242, 'text': 'So what I will do here is I have a measure that I created here go and delete it.', 'start': 3174.401, 'duration': 3.841}, {'end': 3181.13, 'text': 'so i have a cost column.', 'start': 3179.528, 'duration': 1.602}, {'end': 3182.932, 'text': "what i will do is i'll build a calculated column.", 'start': 3181.13, 'duration': 1.802}, {'end': 3185.014, 'text': 'so you build calculated columns using the new column option.', 'start': 3182.932, 'duration': 2.082}, {'end': 3186.896, 'text': 'you build measures in the new measure option.', 'start': 3185.014, 'duration': 1.882}, {'end': 3191.782, 'text': 'so i can build calculated columns using this option here and column name will be profit percentage.', 'start': 3186.896, 'duration': 4.886}], 'summary': 'Creating a calculated column for profit percentage using cost data.', 'duration': 25.745, 'max_score': 3166.037, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3166037.jpg'}, {'end': 3338.373, 'src': 'embed', 'start': 3310.651, 'weight': 5, 'content': [{'end': 3314.514, 'text': 'if i just try to see the profit percentage using calculated columns, look at my number.', 'start': 3310.651, 'duration': 3.863}, {'end': 3318.875, 'text': 'is that even a valid number, mean 300, 000 percentage?', 'start': 3314.514, 'duration': 4.361}, {'end': 3320.076, 'text': 'is that a total profit percent?', 'start': 3318.875, 'duration': 1.201}, {'end': 3320.697, 'text': 'answer is wrong.', 'start': 3320.076, 'duration': 0.621}, {'end': 3322.479, 'text': 'that is absolutely incorrect data.', 'start': 3320.697, 'duration': 1.782}, {'end': 3329.487, 'text': "okay. so even if i want to look at this data across in a granular level, across different segments, you can see it's the same problem.", 'start': 3322.479, 'duration': 7.008}, {'end': 3333.612, 'text': 'i get very, very big numbers, which is app, which is definitely something wrong with my data.', 'start': 3329.487, 'duration': 4.125}, {'end': 3338.373, 'text': 'but the moment i take something like the measure, if i take that measure here, everything looks perfect.', 'start': 3333.612, 'duration': 4.761}], 'summary': 'Invalid profit percentage of 300,000% indicates incorrect data; granularity and measure resolve issue.', 'duration': 27.722, 'max_score': 3310.651, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3310651.jpg'}, {'end': 3372.186, 'src': 'embed', 'start': 3345.535, 'weight': 4, 'content': [{'end': 3350.277, 'text': 'and that is basically the key difference, the key conceptual difference between a calculated column and a measure.', 'start': 3345.535, 'duration': 4.742}, {'end': 3351.837, 'text': "okay, i'll come to the performance aspect.", 'start': 3350.277, 'duration': 1.56}, {'end': 3352.497, 'text': 'when to use what?', 'start': 3351.837, 'duration': 0.66}, {'end': 3357.299, 'text': 'and obviously when you answer this question on measures and calculate columns, performance aspect is also very important,', 'start': 3352.497, 'duration': 4.802}, {'end': 3359.599, 'text': 'but you should always start with the conceptual difference first.', 'start': 3357.299, 'duration': 2.3}, {'end': 3360.64, 'text': 'what is the conceptual difference?', 'start': 3359.599, 'duration': 1.041}, {'end': 3362.4, 'text': 'what is actually happening in the model?', 'start': 3360.64, 'duration': 1.76}, {'end': 3368.563, 'text': 'and what is actually happening in the model is, when you look at the calculated column, all that it is doing is it is basically summing this up.', 'start': 3362.4, 'duration': 6.163}, {'end': 3372.186, 'text': 'it is actually aggregating all the data that is already there in my model.', 'start': 3368.563, 'duration': 3.623}], 'summary': 'Calculated columns aggregate data, while measures perform calculations; consider conceptual difference and performance.', 'duration': 26.651, 'max_score': 3345.535, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3345535.jpg'}, {'end': 3563.6, 'src': 'embed', 'start': 3533.443, 'weight': 0, 'content': [{'end': 3535.704, 'text': "okay, they're actually going to be responsive to filters as well?", 'start': 3533.443, 'duration': 2.261}, {'end': 3542.966, 'text': "generally Okay, and they're recalculating every time you're changing anything in editor, the recalculating based on the aggregations that you defined.", 'start': 3535.704, 'duration': 7.262}, {'end': 3550.151, 'text': 'Okay, so couple of key things that you have to keep in mind when you talk about measures a is they are not stored in your model B is they are dynamic.', 'start': 3543.226, 'duration': 6.925}, {'end': 3554.774, 'text': "They are always calculated on the fly dynamically as and when you're building your visuals.", 'start': 3550.531, 'duration': 4.243}, {'end': 3563.6, 'text': 'And C is obviously that are particularly useful for calculating any kind of data which is pertaining to percentages or anything that represents any kind of denominator.', 'start': 3555.374, 'duration': 8.226}], 'summary': 'Measures are dynamically recalculated based on defined aggregations, useful for calculating percentages and denominators.', 'duration': 30.157, 'max_score': 3533.443, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3533443.jpg'}, {'end': 3622.999, 'src': 'embed', 'start': 3595.761, 'weight': 1, 'content': [{'end': 3599.164, 'text': 'calculate columns are not compressed and they consume more memory.', 'start': 3595.761, 'duration': 3.403}, {'end': 3602.306, 'text': 'and the reason why they consume more memory is because, as i said, they stored in the model.', 'start': 3599.164, 'duration': 3.142}, {'end': 3603.867, 'text': 'and this is where, again, measures went out.', 'start': 3602.306, 'duration': 1.561}, {'end': 3607.51, 'text': "okay, measures win, because measures are actually, they're not stored anywhere.", 'start': 3603.867, 'duration': 3.643}, {'end': 3608.59, 'text': "okay, it's more dynamic.", 'start': 3607.51, 'duration': 1.08}, {'end': 3610.552, 'text': "they're not stored anywhere, they take less storage.", 'start': 3608.59, 'duration': 1.962}, {'end': 3614.735, 'text': "and but the obvious disadvantage of a measure is that because they're not stored anywhere, because they're dynamic,", 'start': 3610.552, 'duration': 4.183}, {'end': 3620.418, 'text': 'because they calculate ad hoc on the fly, they probably put more strain on the resources right, so probably take more time to evaluate.', 'start': 3614.735, 'duration': 5.683}, {'end': 3622.999, 'text': 'so as of today, the differences are hardly you know,', 'start': 3620.418, 'duration': 2.581}], 'summary': 'Uncompressed columns consume more memory, while measures are more dynamic and take less storage but may require more time to evaluate.', 'duration': 27.238, 'max_score': 3595.761, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3595761.jpg'}], 'start': 3133.846, 'title': 'Dax calculated columns and measures', 'summary': 'Discusses using calculate, all, and calculated columns in power bi, creating a profit percentage calculated column and measure, highlighting syntax and differences. it also explains the conceptual difference between calculated columns and measures, emphasizing the dynamic nature and responsiveness to filters of measures, which are more efficient in terms of storage.', 'chapters': [{'end': 3295.359, 'start': 3133.846, 'title': 'Dax calculated columns and measures', 'summary': 'Discusses the use of calculate, all, and calculated columns in power bi, including creating a profit percentage calculated column and measure, highlighting the syntax and differences between them.', 'duration': 161.513, 'highlights': ['The chapter discusses the use of calculate, all, and calculated columns in Power BI The discussion covers the essential DAX functions and their application in Power BI.', 'Creating a profit percentage calculated column and measure The speaker demonstrates the process of creating a profit percentage calculated column and measure, emphasizing the syntax and differences between them.', 'Syntax and differences between calculated columns and measures The speaker explains the similarities and differences between creating calculated columns and measures, focusing on the syntax and the need for aggregation in measures.']}, {'end': 3636.406, 'start': 3295.359, 'title': 'Difference between calculated columns and measures', 'summary': 'Discusses the conceptual difference between calculated columns and measures in power bi, highlighting the incorrectness of calculated columns in aggregating profit percentages and emphasizing the dynamic nature and responsiveness to filters of measures, which are not stored in the model and are more efficient in terms of storage.', 'duration': 341.047, 'highlights': ['The incorrectness of calculated columns in aggregating profit percentages is emphasized, with examples showing how using calculated columns leads to incorrect data and aggregation, such as summing up all profit percentage values for a region, resulting in incorrect outputs.', 'The dynamic nature and responsiveness to filters of measures are highlighted, emphasizing that measures are not stored in the model and are always recalculated on the fly, responsive to filters and dynamically based on aggregations defined, making them more efficient in terms of storage and particularly useful for calculating percentages or any kind of data representing a denominator.', 'The comparison between calculated columns and measures in terms of memory consumption and performance is discussed, with measures being more efficient in terms of storage as they are not stored anywhere and take less storage, but may put more strain on resources and take more time to evaluate, although the performance differences are almost negligible due to recent improvements.']}], 'duration': 502.56, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3133846.jpg', 'highlights': ['The dynamic nature and responsiveness to filters of measures are highlighted, emphasizing that measures are not stored in the model and are always recalculated on the fly, responsive to filters and dynamically based on aggregations defined, making them more efficient in terms of storage and particularly useful for calculating percentages or any kind of data representing a denominator.', 'The comparison between calculated columns and measures in terms of memory consumption and performance is discussed, with measures being more efficient in terms of storage as they are not stored anywhere and take less storage, but may put more strain on resources and take more time to evaluate, although the performance differences are almost negligible due to recent improvements.', 'Creating a profit percentage calculated column and measure The speaker demonstrates the process of creating a profit percentage calculated column and measure, emphasizing the syntax and differences between them.', 'The chapter discusses the use of calculate, all, and calculated columns in Power BI The discussion covers the essential DAX functions and their application in Power BI.', 'Syntax and differences between calculated columns and measures The speaker explains the similarities and differences between creating calculated columns and measures, focusing on the syntax and the need for aggregation in measures.', 'The incorrectness of calculated columns in aggregating profit percentages is emphasized, with examples showing how using calculated columns leads to incorrect data and aggregation, such as summing up all profit percentage values for a region, resulting in incorrect outputs.']}, {'end': 4832.272, 'segs': [{'end': 3675.418, 'src': 'embed', 'start': 3636.406, 'weight': 0, 'content': [{'end': 3643.509, 'text': 'the last point that you mentioned is they can also reduce processing and refresh performance if applied on large fact tables and can make a model more difficult to maintain or support.', 'start': 3636.406, 'duration': 7.103}, {'end': 3647.443, 'text': 'okay, given that the calculated column is not present in the source system.', 'start': 3644.201, 'duration': 3.242}, {'end': 3649.544, 'text': 'that is another important point you should keep in mind.', 'start': 3647.443, 'duration': 2.101}, {'end': 3650.224, 'text': 'power pivot.', 'start': 3649.544, 'duration': 0.68}, {'end': 3655.366, 'text': 'i think we have spent a lot of time already on on power pivot, discussing the components at a very high level already.', 'start': 3650.224, 'duration': 5.142}, {'end': 3659.148, 'text': "but when you're asked a question on what is power pivot, it's very, very important to link it with dax.", 'start': 3655.366, 'duration': 3.782}, {'end': 3660.189, 'text': 'so again it is a.', 'start': 3659.148, 'duration': 1.041}, {'end': 3662.51, 'text': 'it is a discussion on one of the components of power bi.', 'start': 3660.189, 'duration': 2.321}, {'end': 3669.034, 'text': 'so i think it would be really appreciated if all of you could just spend, like you know, a minute to go over what is power bi,', 'start': 3662.51, 'duration': 6.524}, {'end': 3670.375, 'text': 'talk about the self-service aspect,', 'start': 3669.034, 'duration': 1.341}, {'end': 3675.418, 'text': "talk a little bit about some of the components of power bi and then come to talk about power pivot and the fact that it's the,", 'start': 3670.375, 'duration': 5.043}], 'summary': 'Power pivot in power bi can impact performance on large fact tables and increase maintenance complexity. understanding its relationship with dax is crucial.', 'duration': 39.012, 'max_score': 3636.406, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3636406.jpg'}, {'end': 3921.216, 'src': 'embed', 'start': 3888.701, 'weight': 3, 'content': [{'end': 3891.462, 'text': 'you know, when you try to visualize something across three different tables,', 'start': 3888.701, 'duration': 2.761}, {'end': 3894.763, 'text': "it's going to take a little bit more time compared to when you're trying to do it in one table.", 'start': 3891.462, 'duration': 3.301}, {'end': 3898.604, 'text': "okay, so there are obvious pros and cons in both approaches, but it's important to understand.", 'start': 3894.763, 'duration': 3.841}, {'end': 3902.786, 'text': 'the relationships are very, very important and mostly in power bi, as i said you,', 'start': 3898.604, 'duration': 4.182}, {'end': 3910.03, 'text': 'you mostly have these normalized scenarios where you will typically have a lot of these split out tables and you will typically have to combine them with relationships.', 'start': 3902.786, 'duration': 7.244}, {'end': 3912.212, 'text': 'okay, and why is relationships important?', 'start': 3910.03, 'duration': 2.182}, {'end': 3915.353, 'text': 'because without relationships you cannot visualize data across multiple tables.', 'start': 3912.212, 'duration': 3.141}, {'end': 3921.216, 'text': 'so, for instance, your orders here, people here returns here and if you go to my visualization layer now,', 'start': 3915.353, 'duration': 5.863}], 'summary': 'Visualizing data across multiple tables takes more time, but relationships are crucial for this in power bi.', 'duration': 32.515, 'max_score': 3888.701, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3888701.jpg'}, {'end': 4002.752, 'src': 'embed', 'start': 3972.941, 'weight': 2, 'content': [{'end': 3977.243, 'text': 'and these are some scenarios that you should actually point out when you talk about the data model and what is power pivot,', 'start': 3972.941, 'duration': 4.302}, {'end': 3978.743, 'text': 'and when you talk more about relationships.', 'start': 3977.243, 'duration': 1.5}, {'end': 3982.024, 'text': 'okay, so the x velocity in memory analytics engine is something i talked about.', 'start': 3978.743, 'duration': 3.281}, {'end': 3984.465, 'text': "that's basically the underlying engine behind power pivot.", 'start': 3982.024, 'duration': 2.441}, {'end': 3985.685, 'text': "that's something that drives power pivot.", 'start': 3984.465, 'duration': 1.22}, {'end': 3991.147, 'text': 'it can handle a huge amount of data because at the underlying layer it is nothing but a column database.', 'start': 3986.085, 'duration': 5.062}, {'end': 3996.349, 'text': 'okay, it stores data in columnar databases, and columnar database, as some of you may know,', 'start': 3991.147, 'duration': 5.202}, {'end': 4002.752, 'text': 'is a very special kind of database which is optimized for storing huge amounts of data and overall data access is very,', 'start': 3996.349, 'duration': 6.403}], 'summary': 'Power pivot uses x velocity in-memory analytics engine which can handle huge amounts of data in columnar databases.', 'duration': 29.811, 'max_score': 3972.941, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3972941.jpg'}, {'end': 4146.399, 'src': 'heatmap', 'start': 4022.924, 'weight': 0.707, 'content': [{'end': 4028.508, 'text': 'because, as i said, everything about power pivot and the in-memory engine of power pivot is based on columnar database.', 'start': 4022.924, 'duration': 5.584}, {'end': 4034.815, 'text': 'so talk about a column database, mention a bit about what it is and if you can get into those aspects of why data is fast, why access is fast,', 'start': 4028.508, 'duration': 6.307}, {'end': 4035.276, 'text': 'nothing like it.', 'start': 4034.815, 'duration': 0.461}, {'end': 4036.018, 'text': "but it's not required.", 'start': 4035.276, 'duration': 0.742}, {'end': 4038.863, 'text': "and that's getting too much advanced aspects, but that's not required.", 'start': 4036.018, 'duration': 2.845}, {'end': 4042.142, 'text': "but it's an optional thing that you can take a call on relationships.", 'start': 4038.863, 'duration': 3.279}, {'end': 4044.104, 'text': "obviously there's an option that you can set.", 'start': 4042.142, 'duration': 1.962}, {'end': 4046.205, 'text': 'you can either have one active relationship.', 'start': 4044.104, 'duration': 2.101}, {'end': 4047.886, 'text': 'you can have multiple active relationships.', 'start': 4046.205, 'duration': 1.681}, {'end': 4053.55, 'text': 'obviously, if you go to the relationship types here, one, one very, very common use case of this would be order dates, the date to date.', 'start': 4047.886, 'duration': 5.664}, {'end': 4058.553, 'text': 'i think, okay, you can have order date, uh, ship date, due date and and a very, very common use case of this is,', 'start': 4053.55, 'duration': 5.003}, {'end': 4062.135, 'text': "especially if you're dealing with role playing dimensions and this is a very, very common scenario,", 'start': 4058.553, 'duration': 3.582}, {'end': 4067.58, 'text': 'that you should mention role playing dimensions this is a term that you should mention where you can only have one active relationship.', 'start': 4062.135, 'duration': 5.445}, {'end': 4069.642, 'text': 'okay, very important that you mentioned that, guys.', 'start': 4067.58, 'duration': 2.062}, {'end': 4073.105, 'text': 'uh, with role playing dimension you can only have one active relationships.', 'start': 4069.642, 'duration': 3.463}, {'end': 4074.827, 'text': 'okay, and how do you make a relationship inactive?', 'start': 4073.105, 'duration': 1.722}, {'end': 4076.349, 'text': 'so we talked about that already.', 'start': 4074.827, 'duration': 1.522}, {'end': 4077.43, 'text': "let's say region and region related.", 'start': 4076.349, 'duration': 1.081}, {'end': 4079.031, 'text': "here it's a solid line.", 'start': 4077.43, 'duration': 1.601}, {'end': 4082.335, 'text': 'you can actually double click on that and you can make that a relationship inactive.', 'start': 4079.031, 'duration': 3.304}, {'end': 4085.418, 'text': 'click on, ok, and that is an active relationship.', 'start': 4082.335, 'duration': 3.083}, {'end': 4088.784, 'text': 'Power Query.', 'start': 4087.964, 'duration': 0.82}, {'end': 4090.425, 'text': 'I think I spent a lot of time on this already.', 'start': 4088.784, 'duration': 1.641}, {'end': 4097.926, 'text': 'So, needless to say, when you talk about Power Query, mentioned a couple of key terms ETL tool, shaping, cleansing, transforming data very,', 'start': 4090.625, 'duration': 7.301}, {'end': 4098.667, 'text': 'very important pieces.', 'start': 4097.926, 'duration': 0.741}, {'end': 4104.729, 'text': 'And also mentioned the M query bit, that every query is a combination of steps and you can build multiple queries and ultimately,', 'start': 4098.707, 'duration': 6.022}, {'end': 4105.51, 'text': 'the underlying layer.', 'start': 4104.729, 'duration': 0.781}, {'end': 4106.43, 'text': "you're writing M code.", 'start': 4105.51, 'duration': 0.92}, {'end': 4110.171, 'text': 'OK, query folding is actually another very, very important feature in power bi,', 'start': 4106.75, 'duration': 3.421}, {'end': 4113.913, 'text': "and obviously it's more of a performance enhancement question that that can get asked.", 'start': 4110.171, 'duration': 3.742}, {'end': 4115.575, 'text': 'very, very important question actually.', 'start': 4113.913, 'duration': 1.662}, {'end': 4119.837, 'text': 'that sometimes tends to get us here from a performance optimization standpoint,', 'start': 4115.575, 'duration': 4.262}, {'end': 4126.702, 'text': 'and query folding basically leads to the fact that the kind of operations that you can perform at the source get transferred to the source.', 'start': 4119.837, 'duration': 6.865}, {'end': 4130.745, 'text': "OK, so at a very basic level you can see that there's something called View Native Query.", 'start': 4127.182, 'duration': 3.563}, {'end': 4132.807, 'text': 'There will be something called View Native Query that you will see.', 'start': 4131.046, 'duration': 1.761}, {'end': 4138.471, 'text': "So if I just quickly go ahead and get some data from SQL Server here real quick, I'll try to pull in some data from SQL Server.", 'start': 4133.127, 'duration': 5.344}, {'end': 4142.296, 'text': "I think this is also the first time that you're seeing how we connect to a SQL Server.", 'start': 4138.853, 'duration': 3.443}, {'end': 4146.399, 'text': "So I give a dot as my server name and I'll try to connect to my local instance.", 'start': 4142.756, 'duration': 3.643}], 'summary': 'Power pivot and power query key aspects, role playing dimensions, and query folding for performance enhancement in power bi.', 'duration': 123.475, 'max_score': 4022.924, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4022924.jpg'}, {'end': 4138.471, 'src': 'embed', 'start': 4106.75, 'weight': 1, 'content': [{'end': 4110.171, 'text': 'OK, query folding is actually another very, very important feature in power bi,', 'start': 4106.75, 'duration': 3.421}, {'end': 4113.913, 'text': "and obviously it's more of a performance enhancement question that that can get asked.", 'start': 4110.171, 'duration': 3.742}, {'end': 4115.575, 'text': 'very, very important question actually.', 'start': 4113.913, 'duration': 1.662}, {'end': 4119.837, 'text': 'that sometimes tends to get us here from a performance optimization standpoint,', 'start': 4115.575, 'duration': 4.262}, {'end': 4126.702, 'text': 'and query folding basically leads to the fact that the kind of operations that you can perform at the source get transferred to the source.', 'start': 4119.837, 'duration': 6.865}, {'end': 4130.745, 'text': "OK, so at a very basic level you can see that there's something called View Native Query.", 'start': 4127.182, 'duration': 3.563}, {'end': 4132.807, 'text': 'There will be something called View Native Query that you will see.', 'start': 4131.046, 'duration': 1.761}, {'end': 4138.471, 'text': "So if I just quickly go ahead and get some data from SQL Server here real quick, I'll try to pull in some data from SQL Server.", 'start': 4133.127, 'duration': 5.344}], 'summary': 'Query folding in power bi is a vital performance enhancement, transferring operations to the source, such as view native query from sql server.', 'duration': 31.721, 'max_score': 4106.75, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4106750.jpg'}, {'end': 4216.417, 'src': 'embed', 'start': 4186.935, 'weight': 4, 'content': [{'end': 4189.978, 'text': "and what happens here is that i've actually got data into power bi desktop.", 'start': 4186.935, 'duration': 3.043}, {'end': 4195.199, 'text': 'now, okay, you remember, i connected to my sql server, i got it into power bi desktop and after that, whatever transformation i performed here,', 'start': 4189.978, 'duration': 5.221}, {'end': 4196.52, 'text': 'i performed this within power bi desktop.', 'start': 4195.199, 'duration': 1.321}, {'end': 4201.123, 'text': 'Okay, so, whatever transformation I did, I did it with the Power BI desktop, but using query folding.', 'start': 4196.82, 'duration': 4.303}, {'end': 4203.665, 'text': 'Power BI will actually transfer that operation to my source.', 'start': 4201.123, 'duration': 2.542}, {'end': 4205.787, 'text': 'So what is my source? My source is my SQL server.', 'start': 4204.045, 'duration': 1.742}, {'end': 4211.071, 'text': 'So, instead of performing this operation within Power BI, that is, instead of performing this in memory inside Power BI,', 'start': 4206.047, 'duration': 5.024}, {'end': 4212.552, 'text': 'I will be performing this in database.', 'start': 4211.071, 'duration': 1.481}, {'end': 4216.417, 'text': "okay, so you're transferring in memory operation to an in database operation.", 'start': 4213.132, 'duration': 3.285}], 'summary': 'Data is transformed within power bi desktop, using query folding, to perform in-database operations on the sql server.', 'duration': 29.482, 'max_score': 4186.935, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4186935.jpg'}, {'end': 4448.815, 'src': 'heatmap', 'start': 4385.452, 'weight': 1, 'content': [{'end': 4387.313, 'text': 'i think i just answered this question in this example here.', 'start': 4385.452, 'duration': 1.861}, {'end': 4390.535, 'text': "answer is absolutely yes, you can, and the best part is, you don't have to, you know.", 'start': 4387.313, 'duration': 3.222}, {'end': 4394.618, 'text': 'obviously you can do it in the graphical user interface or you can directly go and type out your query.', 'start': 4390.535, 'duration': 4.083}, {'end': 4397.359, 'text': 'you can straight away type out your sql query here.', 'start': 4394.618, 'duration': 2.741}, {'end': 4399.401, 'text': 'more customized sql query across multiple tables.', 'start': 4397.359, 'duration': 2.042}, {'end': 4401.223, 'text': 'What are query parameters?', 'start': 4400.242, 'duration': 0.981}, {'end': 4405.926, 'text': 'Query parameters are again a very, very important topic in Power BI and query parameters.', 'start': 4401.523, 'duration': 4.403}, {'end': 4410.69, 'text': 'The whole idea is that they are very similar to filters, but they are more dynamic sort of filters.', 'start': 4405.946, 'duration': 4.744}, {'end': 4413.132, 'text': 'And the way you set them is using the parameters wizard here.', 'start': 4410.89, 'duration': 2.242}, {'end': 4415.934, 'text': 'I will go back to my orders query right now.', 'start': 4413.572, 'duration': 2.362}, {'end': 4418.636, 'text': 'Go to manage parameters and set up a new parameter called region.', 'start': 4416.294, 'duration': 2.342}, {'end': 4421.558, 'text': 'so i can actually define a parameter like this.', 'start': 4419.216, 'duration': 2.342}, {'end': 4422.018, 'text': "it's a region.", 'start': 4421.558, 'duration': 0.46}, {'end': 4424.56, 'text': 'parameter type is going to be text type.', 'start': 4422.018, 'duration': 2.542}, {'end': 4429.585, 'text': "okay, so this set values is going to be, let's say, i'm going to give a list of values and when you say any, basically you get a.", 'start': 4424.56, 'duration': 5.025}, {'end': 4432.027, 'text': 'you get a text box and if you give a list of values, you get a drop down.', 'start': 4429.585, 'duration': 2.442}, {'end': 4432.947, 'text': "that's the only difference.", 'start': 4432.027, 'duration': 0.92}, {'end': 4434.048, 'text': "i'll show you both the examples.", 'start': 4432.947, 'duration': 1.101}, {'end': 4435.91, 'text': 'okay, current value is a default that you can give.', 'start': 4434.048, 'duration': 1.862}, {'end': 4438.531, 'text': "actually i'll cover can put as a central right.", 'start': 4435.91, 'duration': 2.621}, {'end': 4445.914, 'text': "so as my region parameter I've set up here and now what I can do is I can go to my orders table and see how I can filter by region.", 'start': 4438.531, 'duration': 7.383}, {'end': 4448.815, 'text': 'here in the query I can go here, I can filter by region.', 'start': 4445.914, 'duration': 2.901}], 'summary': 'In power bi, query parameters are dynamic filters, set up using the parameters wizard, enabling customized sql queries across multiple tables.', 'duration': 63.363, 'max_score': 4385.452, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4385452.jpg'}, {'end': 4418.636, 'src': 'embed', 'start': 4390.535, 'weight': 5, 'content': [{'end': 4394.618, 'text': 'obviously you can do it in the graphical user interface or you can directly go and type out your query.', 'start': 4390.535, 'duration': 4.083}, {'end': 4397.359, 'text': 'you can straight away type out your sql query here.', 'start': 4394.618, 'duration': 2.741}, {'end': 4399.401, 'text': 'more customized sql query across multiple tables.', 'start': 4397.359, 'duration': 2.042}, {'end': 4401.223, 'text': 'What are query parameters?', 'start': 4400.242, 'duration': 0.981}, {'end': 4405.926, 'text': 'Query parameters are again a very, very important topic in Power BI and query parameters.', 'start': 4401.523, 'duration': 4.403}, {'end': 4410.69, 'text': 'The whole idea is that they are very similar to filters, but they are more dynamic sort of filters.', 'start': 4405.946, 'duration': 4.744}, {'end': 4413.132, 'text': 'And the way you set them is using the parameters wizard here.', 'start': 4410.89, 'duration': 2.242}, {'end': 4415.934, 'text': 'I will go back to my orders query right now.', 'start': 4413.572, 'duration': 2.362}, {'end': 4418.636, 'text': 'Go to manage parameters and set up a new parameter called region.', 'start': 4416.294, 'duration': 2.342}], 'summary': 'Power bi allows custom sql queries, dynamic query parameters like filters, set using the parameters wizard.', 'duration': 28.101, 'max_score': 4390.535, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4390535.jpg'}, {'end': 4696.929, 'src': 'embed', 'start': 4670.447, 'weight': 7, 'content': [{'end': 4674.47, 'text': 'very important that you address the part that it is power query that is an etl tool.', 'start': 4670.447, 'duration': 4.023}, {'end': 4676.232, 'text': 'okay, power pivot is not an etl tool.', 'start': 4674.47, 'duration': 1.762}, {'end': 4678.935, 'text': 'power pivot is only used for loading data into the model.', 'start': 4676.232, 'duration': 2.703}, {'end': 4679.495, 'text': "that's it i mean.", 'start': 4678.935, 'duration': 0.56}, {'end': 4683.379, 'text': 'essentially, power pivot can only be used for performing calculations and analysis.', 'start': 4679.495, 'duration': 3.884}, {'end': 4685.982, 'text': 'okay, the whole point of power pivot is analytics.', 'start': 4683.379, 'duration': 2.603}, {'end': 4687.323, 'text': 'okay, it is not for data cleansing.', 'start': 4685.982, 'duration': 1.341}, {'end': 4690.505, 'text': 'Okay, if you want to perform data cleansing, that is not power papers rule.', 'start': 4687.743, 'duration': 2.762}, {'end': 4692.346, 'text': 'So the sort of to add in components.', 'start': 4690.525, 'duration': 1.821}, {'end': 4696.929, 'text': 'the two tools have two very different rules, and that is the thing that you to bring out in this particular question.', 'start': 4692.346, 'duration': 4.583}], 'summary': 'Power pivot is for analytics, not etl or data cleansing.', 'duration': 26.482, 'max_score': 4670.447, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4670447.jpg'}, {'end': 4730.235, 'src': 'embed', 'start': 4702.876, 'weight': 6, 'content': [{'end': 4709.081, 'text': 'obviously maps are extremely powerful in power bi desktop and if you just go to the map section, one very, very important thing, guys,', 'start': 4702.876, 'duration': 6.205}, {'end': 4713.645, 'text': "you have to keep in mind is when you're configured, especially working with maps, is to set the correct geographical type.", 'start': 4709.081, 'duration': 4.564}, {'end': 4717.168, 'text': 'so if you go to modeling, uh, you have data category, something called data category.', 'start': 4713.645, 'duration': 3.523}, {'end': 4720.69, 'text': 'it is very, very important that you, when you inherently have data like city,', 'start': 4717.168, 'duration': 3.522}, {'end': 4723.753, 'text': 'it is very important that you go to data category and set this as a city.', 'start': 4720.69, 'duration': 3.063}, {'end': 4725.433, 'text': 'okay, extremely important.', 'start': 4723.753, 'duration': 1.68}, {'end': 4730.235, 'text': "that, especially when you're working with map data, you have to set this, a geographical data type, and when you do that,", 'start': 4725.433, 'duration': 4.802}], 'summary': 'Setting correct geographical type is crucial when working with map data in power bi desktop.', 'duration': 27.359, 'max_score': 4702.876, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4702876.jpg'}], 'start': 3636.406, 'title': 'Power bi data modeling and performance impact', 'summary': 'Covers the impact of calculated columns on large fact tables, the importance of linking power pivot with dax, key aspects of data modeling in power bi including loading data and creating relationships, and connecting to sql server in power bi with a focus on query folding and efficient data filtering.', 'chapters': [{'end': 3675.418, 'start': 3636.406, 'title': 'Power pivot and its impact', 'summary': 'Highlights the impact of calculated columns on processing and refresh performance of large fact tables, the importance of linking power pivot with dax, and the request for a discussion on power bi components and self-service aspect.', 'duration': 39.012, 'highlights': ['The impact of calculated columns on processing and refresh performance of large fact tables is highlighted, along with the increased difficulty in maintaining or supporting the model.', 'Linking Power Pivot with DAX is emphasized as crucial when discussing its components and its relevance to Power BI.', 'Request for a discussion on Power BI components, self-service aspect, and Power Pivot is made, indicating the significance of understanding these in the context of the overall topic.']}, {'end': 4132.807, 'start': 3675.418, 'title': 'Power bi data modeling', 'summary': 'Discusses the key aspects of data modeling in power bi, including loading data, creating relationships, and the importance of relationships in visualizing and querying data across multiple tables, with emphasis on the underlying x velocity in memory analytics engine and columnar database storage.', 'duration': 457.389, 'highlights': ['The importance of relationships in visualizing and querying data Building relationships in Power BI is crucial for visualizing and querying data across multiple tables, enabling selection and filtering of fields from different tables for visualization.', 'The underlying x velocity in memory analytics engine and columnar database storage The x velocity in memory analytics engine in Power BI is based on columnar database storage, enabling fast data access and handling of large volumes of data, which is essential for efficient data processing and visualization.', 'Query folding as a performance enhancement feature Query folding allows operations to be performed at the source, enhancing performance by transferring operations to the source, which is essential for optimizing the performance of Power BI data queries.']}, {'end': 4832.272, 'start': 4133.127, 'title': 'Connecting to sql server and query folding in power bi', 'summary': 'Discusses connecting to sql server in power bi, demonstrating how to perform data transformations within power bi using query folding, highlighting the benefits of query folding, and explaining the use of parameters and data categories in power bi for efficient data filtering and visualization.', 'duration': 699.145, 'highlights': ['The chapter demonstrates connecting to SQL Server in Power BI and performing data transformations within Power BI using query folding, showcasing the benefits of transferring in-memory operations to in-database operations for improved performance in Power BI, with the resultant stub being returned from the underlying SQL server table, emphasizing the efficient use of resources and optimization of data retrieval.', 'The chapter explains the use of parameters in Power BI for dynamic filtering and efficient data visualization, showcasing the setup of parameters and their application in filtering data at both the query and visualization layers, highlighting the dynamic and user-friendly nature of parameters in providing prompt-based data filtering and reducing the amount of loaded data for improved performance.', 'The chapter details the importance of setting correct data categories in Power BI for efficient mapping and visualization, highlighting the significance of setting geographical data types for city, country, postal code, and state, and emphasizing the need to avoid summary for non-numeric data such as postal codes, ensuring accurate geographical representation and visualization in Power BI.', 'The chapter identifies Power Pivot as an analytics tool and Power Query as an ETL tool, highlighting their distinct roles in data analysis and data cleansing, underscoring the importance of understanding the differing functionalities of the two tools for efficient data processing and analysis in Power BI.']}], 'duration': 1195.866, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs3636406.jpg', 'highlights': ['Linking Power Pivot with DAX is crucial for understanding its components and relevance to Power BI.', 'Query folding allows operations to be performed at the source, enhancing performance by transferring operations to the source, essential for optimizing the performance of Power BI data queries.', 'The x velocity in memory analytics engine in Power BI is based on columnar database storage, enabling fast data access and handling of large volumes of data, essential for efficient data processing and visualization.', 'Building relationships in Power BI is crucial for visualizing and querying data across multiple tables, enabling selection and filtering of fields from different tables for visualization.', 'The chapter demonstrates connecting to SQL Server in Power BI and performing data transformations within Power BI using query folding, showcasing the benefits of transferring in-memory operations to in-database operations for improved performance in Power BI.', 'The chapter explains the use of parameters in Power BI for dynamic filtering and efficient data visualization, showcasing the setup of parameters and their application in filtering data at both the query and visualization layers, highlighting the dynamic and user-friendly nature of parameters in providing prompt-based data filtering and reducing the amount of loaded data for improved performance.', 'The chapter details the importance of setting correct data categories in Power BI for efficient mapping and visualization, highlighting the significance of setting geographical data types for city, country, postal code, and state, and emphasizing the need to avoid summary for non-numeric data such as postal codes, ensuring accurate geographical representation and visualization in Power BI.', 'The chapter identifies Power Pivot as an analytics tool and Power Query as an ETL tool, highlighting their distinct roles in data analysis and data cleansing, underscoring the importance of understanding the differing functionalities of the two tools for efficient data processing and analysis in Power BI.', 'The impact of calculated columns on processing and refresh performance of large fact tables is highlighted, along with the increased difficulty in maintaining or supporting the model.', 'Request for a discussion on Power BI components, self-service aspect, and Power Pivot is made, indicating the significance of understanding these in the context of the overall topic.']}, {'end': 6007.126, 'segs': [{'end': 4949.471, 'src': 'embed', 'start': 4919.142, 'weight': 0, 'content': [{'end': 4921.144, 'text': 'OK, I can look at this data across.', 'start': 4919.142, 'duration': 2.002}, {'end': 4923.327, 'text': "And now you're seeing.", 'start': 4922.686, 'duration': 0.641}, {'end': 4928.142, 'text': "And you might be wondering what's exactly happening.", 'start': 4926.381, 'duration': 1.761}, {'end': 4933.526, 'text': 'Why am I only seeing Western United States? And the reason is because if you remember, I have filters applied.', 'start': 4928.202, 'duration': 5.324}, {'end': 4937.069, 'text': "So the underlying model that I've taken, I have filters applied based on parameters.", 'start': 4933.686, 'duration': 3.383}, {'end': 4941.733, 'text': 'And again, that is something I can further configure within Power BI.', 'start': 4938.43, 'duration': 3.303}, {'end': 4945.427, 'text': 'okay, just to quickly clarify this once again, where do you set the period parameters?', 'start': 4942.384, 'duration': 3.043}, {'end': 4949.471, 'text': 'remember, parameters is something i applied just a while back and you can further look at the visualization layer.', 'start': 4945.427, 'duration': 4.044}], 'summary': 'Data analysis in power bi reveals western united states due to applied filters and parameters.', 'duration': 30.329, 'max_score': 4919.142, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4919142.jpg'}, {'end': 5099.322, 'src': 'embed', 'start': 5062.082, 'weight': 1, 'content': [{'end': 5066.166, 'text': 'gateways are that they are the interface between the cloud and the on-premise world.', 'start': 5062.082, 'duration': 4.084}, {'end': 5071.752, 'text': 'okay, so gateways are what allows you to transfer your data from on-premise sources to your azure cloud,', 'start': 5066.166, 'duration': 5.586}, {'end': 5074.155, 'text': "where your cloud server that's probably a service is hosted.", 'start': 5071.752, 'duration': 2.403}, {'end': 5076.812, 'text': 'What are the different types of refreshing data package?', 'start': 5075.051, 'duration': 1.761}, {'end': 5079.933, 'text': 'refresh model refresh tile refresh and visual container refresh.', 'start': 5076.812, 'duration': 3.121}, {'end': 5081.774, 'text': 'So this is another important question.', 'start': 5080.453, 'duration': 1.321}, {'end': 5085.156, 'text': 'So, typically, when we talk about refreshes, how many ways can you refresh the package?', 'start': 5081.834, 'duration': 3.322}, {'end': 5087.997, 'text': "refreshes basically the concept wherein, let's say,", 'start': 5085.156, 'duration': 2.841}, {'end': 5099.322, 'text': 'you have a power bi desktop file or an Excel file which you have in the service and I mean obviously the same file is there in OneDrive or SharePoint online and you want to ensure that they are both synced.', 'start': 5087.997, 'duration': 11.325}], 'summary': 'Gateways facilitate data transfer between on-premise sources and azure cloud. different types of data refreshes include model, tile, and visual container refresh.', 'duration': 37.24, 'max_score': 5062.082, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs5062082.jpg'}, {'end': 5318.479, 'src': 'embed', 'start': 5293.087, 'weight': 2, 'content': [{'end': 5298.522, 'text': 'What I want to do is I just quickly open up Excel, and so there are two things particularly that you have in excel.', 'start': 5293.087, 'duration': 5.435}, {'end': 5304.788, 'text': 'so one thing we call the power bi publisher for excel, obviously the personal gateway and the on-premise gateway, the gateways that we have.', 'start': 5298.522, 'duration': 6.266}, {'end': 5309.191, 'text': "but there's one additional component that is worth mentioning, called analyzing excel updates.", 'start': 5304.788, 'duration': 4.403}, {'end': 5311.153, 'text': "as you can see, there's something called analyzing excel update.", 'start': 5309.191, 'duration': 1.962}, {'end': 5313.195, 'text': 'so these are both add-ins that you have to install in excel.', 'start': 5311.153, 'duration': 2.042}, {'end': 5318.479, 'text': 'so analyzing excel allows you to go back and place a data set in power bi from within excel.', 'start': 5313.195, 'duration': 5.284}], 'summary': 'Excel has two add-ins: power bi publisher and analyzing excel updates, enabling data set placement in power bi.', 'duration': 25.392, 'max_score': 5293.087, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs5293087.jpg'}, {'end': 5488.721, 'src': 'embed', 'start': 5461.356, 'weight': 3, 'content': [{'end': 5467.557, 'text': 'so, uh, do mention some, some, some, some, a very, very brief about all these different tools that you have.', 'start': 5461.356, 'duration': 6.201}, {'end': 5469.077, 'text': 'how is data security implemented in power bi?', 'start': 5467.557, 'duration': 1.52}, {'end': 5475.298, 'text': 'this is actually a very, very important question, especially which pertains to row level security, rls, as you call it okay,', 'start': 5469.077, 'duration': 6.221}, {'end': 5478.979, 'text': 'and the way you do that in power bi is using the concept for roles.', 'start': 5475.298, 'duration': 3.681}, {'end': 5480.639, 'text': 'okay, so you first do this in the desktop.', 'start': 5478.979, 'duration': 1.66}, {'end': 5483.88, 'text': 'So, for instance, right now, here you can see I have data.', 'start': 5481.299, 'duration': 2.581}, {'end': 5488.721, 'text': "One of the first things I'll do probably here is remove that Parameter.", 'start': 5483.88, 'duration': 4.841}], 'summary': 'Power bi implements data security using roles and row level security (rls) in the desktop.', 'duration': 27.365, 'max_score': 5461.356, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs5461356.jpg'}, {'end': 5829.554, 'src': 'heatmap', 'start': 5765.775, 'weight': 0.76, 'content': [{'end': 5769.637, 'text': 'it only supports one to one, one too many and many to one, but many too many.', 'start': 5765.775, 'duration': 3.862}, {'end': 5772.899, 'text': 'if you have to implement, you have to implement using what we call Bridge table.', 'start': 5769.637, 'duration': 3.262}, {'end': 5778.801, 'text': 'Okay, so that is something you have to specifically replicate or create either in the model or in the power query.', 'start': 5773.139, 'duration': 5.662}, {'end': 5780.562, 'text': 'so first, create that bridge table.', 'start': 5778.801, 'duration': 1.761}, {'end': 5782.243, 'text': 'a one too many, too many to one.', 'start': 5780.562, 'duration': 1.681}, {'end': 5784.943, 'text': 'a very good example could be Authors and books.', 'start': 5782.243, 'duration': 2.7}, {'end': 5786.544, 'text': 'one author can write many books.', 'start': 5784.943, 'duration': 1.601}, {'end': 5788.845, 'text': 'one book can be written by many authors or doctors and patients.', 'start': 5786.544, 'duration': 2.301}, {'end': 5790.065, 'text': 'also a very good example.', 'start': 5788.845, 'duration': 1.22}, {'end': 5795.347, 'text': 'You know, one doctor can has treated multiple patients and one patient has been treated by multiple doctors.', 'start': 5790.065, 'duration': 5.282}, {'end': 5802.569, 'text': 'in both these cases You have to create a bridge table, Okay, and then you will set up the one to many relationships in power bi desktop.', 'start': 5795.347, 'duration': 7.222}, {'end': 5805.81, 'text': 'That is how we will typically implement this power bi published for Excel.', 'start': 5802.569, 'duration': 3.241}, {'end': 5807.391, 'text': 'We have talked about this already.', 'start': 5805.85, 'duration': 1.541}, {'end': 5809.772, 'text': 'Differences. we have briefly talked about.', 'start': 5807.391, 'duration': 2.381}, {'end': 5815.956, 'text': 'edit interactions typically work at the the visual layer of power bi, and another very, very important component,', 'start': 5809.772, 'duration': 6.184}, {'end': 5819.32, 'text': 'especially in the visualization stack, is edit interactions.', 'start': 5815.956, 'duration': 3.364}, {'end': 5820.662, 'text': 'so here this is my.', 'start': 5819.32, 'duration': 1.342}, {'end': 5822.444, 'text': "it's a very simple bar chart i have.", 'start': 5820.662, 'duration': 1.782}, {'end': 5829.554, 'text': 'i can parallelly build a line chart here and now a line chart is going to be showing my sales based on auto date.', 'start': 5822.444, 'duration': 7.11}], 'summary': 'Implement one-to-many and many-to-many relationships using bridge tables in power bi for excel.', 'duration': 63.779, 'max_score': 5765.775, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs5765775.jpg'}, {'end': 5815.956, 'src': 'embed', 'start': 5786.544, 'weight': 4, 'content': [{'end': 5788.845, 'text': 'one book can be written by many authors or doctors and patients.', 'start': 5786.544, 'duration': 2.301}, {'end': 5790.065, 'text': 'also a very good example.', 'start': 5788.845, 'duration': 1.22}, {'end': 5795.347, 'text': 'You know, one doctor can has treated multiple patients and one patient has been treated by multiple doctors.', 'start': 5790.065, 'duration': 5.282}, {'end': 5802.569, 'text': 'in both these cases You have to create a bridge table, Okay, and then you will set up the one to many relationships in power bi desktop.', 'start': 5795.347, 'duration': 7.222}, {'end': 5805.81, 'text': 'That is how we will typically implement this power bi published for Excel.', 'start': 5802.569, 'duration': 3.241}, {'end': 5807.391, 'text': 'We have talked about this already.', 'start': 5805.85, 'duration': 1.541}, {'end': 5809.772, 'text': 'Differences. we have briefly talked about.', 'start': 5807.391, 'duration': 2.381}, {'end': 5815.956, 'text': 'edit interactions typically work at the the visual layer of power bi, and another very, very important component,', 'start': 5809.772, 'duration': 6.184}], 'summary': 'Creating bridge table for one-to-many relationships in power bi.', 'duration': 29.412, 'max_score': 5786.544, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs5786544.jpg'}, {'end': 5962.376, 'src': 'embed', 'start': 5935.949, 'weight': 5, 'content': [{'end': 5939.932, 'text': 'in ssrs and power bi they seem interact very, very seamlessly.', 'start': 5935.949, 'duration': 3.983}, {'end': 5945.697, 'text': 'okay, you can build ssrs dashboards and you can very easily pin them into power bi.', 'start': 5939.932, 'duration': 5.765}, {'end': 5948.659, 'text': 'the same way i pinned an excel stuff into power bi.', 'start': 5945.697, 'duration': 2.962}, {'end': 5951.642, 'text': 'okay, so same thing happens in ssrs as well.', 'start': 5948.659, 'duration': 2.983}, {'end': 5955.565, 'text': 'okay, so indeed, there is a very, very rich interaction that happens between both.', 'start': 5951.642, 'duration': 3.923}, {'end': 5956.591, 'text': 'All right.', 'start': 5956.371, 'duration': 0.22}, {'end': 5958.793, 'text': "so that's all that we have for the session here.", 'start': 5956.591, 'duration': 2.202}, {'end': 5961.275, 'text': "Thank you once again for being a part of today's session.", 'start': 5958.933, 'duration': 2.342}, {'end': 5962.376, 'text': 'Hope all of you enjoyed it.', 'start': 5961.315, 'duration': 1.061}], 'summary': 'Ssrs and power bi seamlessly interact; ssrs dashboards can be easily pinned into power bi, similar to excel, showcasing a rich interaction between both.', 'duration': 26.427, 'max_score': 5935.949, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs5935949.jpg'}], 'start': 4833.16, 'title': 'Power bi features and implementations', 'summary': 'Covers setting geographical types for accurate data representation in maps, configuring parameters for filters, managing data refresh for performance optimization and synchronization, natural language querying tool, excel integration, role level security implementation, bridge tables for many-to-many relationships, and integration of ssrs with power bi.', 'chapters': [{'end': 5205.982, 'start': 4833.16, 'title': 'Setting geographical types in power bi', 'summary': 'Emphasizes the importance of setting geographical types accurately in power bi to ensure accurate data representation in maps, configuring parameters for filters, and managing data refresh using gateways and different types of refreshes, with a focus on performance optimization and data synchronization.', 'duration': 372.822, 'highlights': ['The importance of setting geographical types accurately in Power BI is emphasized to ensure accurate data representation in maps, with Power BI being able to recognize city names and data categories, but highlighting the usefulness in scenarios where Power BI may not accurately recognize the underlying data, thus stressing on the importance of setting data categories accurately.', 'The process of configuring parameters for filters in Power BI is explained, demonstrating the steps to set parameters such as east, west, or central to filter and display specific data, with an emphasis on user prompt and performance optimization technique.', 'The significance of managing data refresh using gateways in Power BI is highlighted, with the mention of setting up schedule refreshes, the requirement of gateways for connecting to on-premise sources, and the interface between the cloud and on-premise world, emphasizing the different types of refreshing data package, model, tile, and visual container refresh.', 'The different types of refreshing data package, model, tile, and visual container refresh in Power BI are outlined, with an explanation of how package refresh ensures synchronization of files in Power BI service with OneDrive or SharePoint online, the concept of model or data refresh, and the refresh of dashboard views to reflect data changes.']}, {'end': 5678.795, 'start': 5205.982, 'title': 'Power bi: natural language querying & excel integration', 'summary': 'Explains the natural language querying tool, power bi q&a, and its conversational feature, as well as the integration of excel with power bi, including the use of add-ins and row level security implementation through roles and dax expressions.', 'duration': 472.813, 'highlights': ['Power BI Q&A is a natural language querying tool with artificial intelligence built in, allowing for on-the-fly query results and conversational Q&A feature in the app.', 'Excel integration with Power BI includes the Power BI publisher for Excel, personal and on-premise gateways, and the ability to analyze and place a data set from Power BI within Excel using an ODC file.', 'Row level security in Power BI is implemented through roles and DAX expressions, allowing for the creation of separate roles for different regions and the configuration of filter expressions for each role to control data access.', 'The seamless integration between Excel and Power BI allows for the transfer of data from Power BI to Excel and vice versa, as well as the ability to publish Excel data to Power BI using the Power BI publisher for Excel.']}, {'end': 6007.126, 'start': 5678.795, 'title': 'Implementing role level security in power bi', 'summary': 'Discusses implementing role level security in power bi, including adding email addresses for different roles, using bridge tables for many-to-many relationships, and configuring edit interactions between visuals in power bi desktop. it also covers the integration of ssrs with power bi.', 'duration': 328.331, 'highlights': ['Implementing role level security by adding email addresses for different roles to restrict data access, such as eastern and central regions. The process involves adding email addresses for different roles to restrict data access based on region, effectively implementing role level security.', 'Utilizing bridge tables to establish many-to-many relationships, such as between authors and books or doctors and patients. Bridge tables are essential for establishing many-to-many relationships, for example, between authors and books or doctors and patients, in Power BI Desktop.', 'Configuring edit interactions between visuals in Power BI Desktop to specify how different visuals should interact with each other. Edit interactions allow users to specify how different visuals should interact with each other, providing a customized experience for data analysis in Power BI Desktop.', 'Integrating SSRS dashboards with Power BI seamlessly, enabling easy pinning of SSRS content into Power BI. SSRS dashboards seamlessly integrate with Power BI, allowing easy pinning of SSRS content into Power BI for a rich interaction between the two platforms.']}], 'duration': 1173.966, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/50DBBamXVcs/pics/50DBBamXVcs4833160.jpg', 'highlights': ['Configuring parameters for filters in Power BI, emphasizing user prompt and performance optimization technique.', 'Managing data refresh using gateways in Power BI, highlighting the different types of refreshing data package, model, tile, and visual container refresh.', 'Excel integration with Power BI, including the Power BI publisher for Excel, personal and on-premise gateways, and the ability to analyze and place a data set from Power BI within Excel using an ODC file.', 'Row level security in Power BI implemented through roles and DAX expressions, allowing for the creation of separate roles for different regions and the configuration of filter expressions for each role to control data access.', 'Utilizing bridge tables to establish many-to-many relationships, such as between authors and books or doctors and patients.', 'Integrating SSRS dashboards with Power BI seamlessly, enabling easy pinning of SSRS content into Power BI.']}], 'highlights': ['Power BI is one of the most popular SSBI tools, enabling end users to build reports without depending on IT teams.', 'Self-service BI empowers non-technical users to analyze data using tools like Power BI, leading to faster development cycles.', 'Power BI integrates with Excel BI toolkit, offering a user-friendly process for creating intuitive and shareable dashboards.', 'Power BI Desktop packages all components into a single tool, providing a neater and easier-to-use solution.', 'The Q&A feature in Power BI Desktop allows users to ask questions and receive visualized answers.', 'Power BI service offers robust data connection options, editing capabilities, and multiple page creation for enhanced BI capabilities.', 'DAX is vital for adding meaning to data and creating complex measures in Power BI.', 'Measures in Power BI are dynamically responsive to filters and aggregations, making them efficient for calculating percentages and dynamic data.', 'Query folding in Power BI enhances performance by transferring operations to the source, optimizing data queries.', 'Power Pivot and Power Query play distinct roles in data analysis and data cleansing in Power BI, emphasizing the need to understand their functionalities.', 'Configuring parameters for filters in Power BI is a user prompt and performance optimization technique.', 'Row level security in Power BI is implemented through roles and DAX expressions, allowing for the creation of separate roles for different regions.', 'Integrating SSRS dashboards with Power BI enables easy pinning of SSRS content into Power BI.']}