title
Power BI Full Course - Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | Edureka

description
🔥 Edureka Power BI Training (Use Code "𝐘𝐎𝐔𝐓𝐔𝐁𝐄𝟐𝟎") - https://www.edureka.co/power-bi-certification-training This Edureka video on the "Power BI Full Course" will help you understand and learn Power BI in detail. This Power BI Tutorial is ideal for both beginners as well as professionals who want to master their Power BI concepts. Below are the topics covered in this Power BI Tutorial for beginners video: 00:00 Introduction to Power BI Full Course 1:54 Business Intelligence & Data Visualization 2:35 Why Choose Power BI? 11:11 What is Power BI? 13:28 Key Benefits Power BI 15:28 Components of Power BI 18:54 Architecture of Power BI 20:54 Building Blocks of Power BI 21:34 Visualizations 22:19 Datasets 23:14 Reports 23:39 Dashboards 24:29 Tiles 25:09 Using Power BI 26:14 Getting Started with Power BI 26:31 Install Power BI Desktop 27:46 Import Data 29:18 Create & Modify a Simple Visual 30:43 Save & Publish Report 32:38 Joining Data Sources 37:28 Update & Publish report 38:09 Building & Sharing a Dashboard 39:54 Pin Visuals to a Dashboard 43:07 Introduction to Power BI Desktop 44:42 Power BI Charts 48:12 Bar Charts & Column Charts 48:47 Line Charts & Area Charts 49:47 Combination Charts & Ribbon Charts 51:22 Pie Charts, Doughnut Charts & Tree Maps 53:02 Maps on Power BI 54:37 Funnel Charts 55:42 Gauge & Cards 57:24 Tables & Matrices 58:19 R-Script Visuals 58:49 Power BI KPI 59:19 What is KPI? 59:59 When to use KPI? 1:00:29 Requirements for KPI 1:00:59 KPI Visualizations 1:08:49 Power BI Dashboard 1:08:59 What is a Dashboard? 1:09:59 Dashboard vs Report 1:14:59 Demo - Superstore 1:46:49 Power BI vs Tableau 1:47:34 Visualization 1:48:22 Cost 1:49:35 Integration 1:50:54 Data Management 1:51:58 Functionality 1:54:35 Power BI Interview Questions 3:33:47 Power BI Market Trends 🔵 Check our complete Power BI Tutorial for Beginners playlist: https://goo.gl/Ju8JLG 📢📢 𝐓𝐨𝐩 𝟏𝟎 𝐓𝐫𝐞𝐧𝐝𝐢𝐧𝐠 𝐓𝐞𝐜𝐡𝐧𝐨𝐥𝐨𝐠𝐢𝐞𝐬 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐢𝐧 𝟐𝟎𝟐𝟒 𝐒𝐞𝐫𝐢𝐞𝐬 📢📢 ⏩ NEW Top 10 Technologies To Learn In 2024 - https://www.youtube.com/watch?v=vaLXPv0ewHU 📌𝐓𝐞𝐥𝐞𝐠𝐫𝐚𝐦: https://t.me/edurekaupdates 📌𝐓𝐰𝐢𝐭𝐭𝐞𝐫: https://twitter.com/edurekain 📌𝐋𝐢𝐧𝐤𝐞𝐝𝐈𝐧: https://www.linkedin.com/company/edureka 📌𝐈𝐧𝐬𝐭𝐚𝐠𝐫𝐚𝐦: https://www.instagram.com/edureka_learning/ 📌𝐅𝐚𝐜𝐞𝐛𝐨𝐨𝐤: https://www.facebook.com/edurekaIN/ 📌𝐒𝐥𝐢𝐝𝐞𝐒𝐡𝐚𝐫𝐞: https://www.slideshare.net/EdurekaIN 📌𝐂𝐚𝐬𝐭𝐛𝐨𝐱: https://castbox.fm/networks/505?country=IN 📌𝐌𝐞𝐞𝐭𝐮𝐩: https://www.meetup.com/edureka/ 📌𝐂𝐨𝐦𝐦𝐮𝐧𝐢𝐭𝐲: https://www.edureka.co/community/ - - - - - - - - - - - - - - - - - How it Works? 1. This is a 4 Week Instructor led Online Course, 20 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 have to work on a project, based on which we will provide you a Grade and a Verifiable Certificate! - - - - - - - - - - - - - - About the Power BI 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. After the completion of Edureka's Power BI Certification Course, you will be able to: Discuss Power BI, Power Pivot, Power view, Power Map Discuss Power Query Describe Power BI Desktop Describe DAX Explain Data Visualization State Power BI Q&A and Data insights Develop Custom Visualizations Discuss Power BI Embedded Explain Power BI with SSRS Reports Discuss the concepts around Power BI Administration - - - - - - - - - - - - - - Who should go for this Power BI 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 - - - - - - - - - - - - - - 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 Full Course - Learn Power BI in 4 Hours | Power BI Tutorial for Beginners | Edureka', 'heatmap': [{'end': 8672.073, 'start': 8536.75, 'weight': 0.795}, {'end': 11387.665, 'start': 11254.826, 'weight': 1}, {'end': 12034.924, 'start': 11899.914, 'weight': 0.969}], 'summary': 'A comprehensive 11-chapter course on power bi covers data management, visualization, desktop usage, feature comparison, data analysis, dax queries, and integration, with a focus on practical insights and applications, including insights from a superstore dataset, a comparison with tableau, and employment trends such as 3% monthly job vacancy growth and an average salary of 50,000 pounds for a three-month tenure.', 'chapters': [{'end': 482.537, 'segs': [{'end': 100.604, 'src': 'embed', 'start': 74.811, 'weight': 0, 'content': [{'end': 80.535, 'text': 'will help you understand how to create interactive dashboards with the help of lot of examples and use cases.', 'start': 74.811, 'duration': 5.724}, {'end': 85.565, 'text': 'Followed by this, we have a comparison module between Power BI and Tableau.', 'start': 81.235, 'duration': 4.33}, {'end': 89.894, 'text': 'In this module you will understand the important features of both of these powerful tools.', 'start': 86.086, 'duration': 3.808}, {'end': 94.958, 'text': 'Followed by this we have the last module which is Power BI interview questions.', 'start': 90.834, 'duration': 4.124}, {'end': 100.604, 'text': "Here you'll understand the important concepts of Power BI and how you can ace a Power BI interview.", 'start': 95.439, 'duration': 5.165}], 'summary': 'Learn to create interactive dashboards with examples, compare power bi and tableau, and ace a power bi interview.', 'duration': 25.793, 'max_score': 74.811, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY74811.jpg'}, {'end': 349.535, 'src': 'embed', 'start': 256.457, 'weight': 1, 'content': [{'end': 264.341, 'text': 'this dependence on the IT Department for insights resulted in more efforts and time consumption to get the updates done.', 'start': 256.457, 'duration': 7.884}, {'end': 271.364, 'text': 'Now the second wave, which is analyst to end user, or the self-service wave.', 'start': 264.941, 'duration': 6.423}, {'end': 274.586, 'text': 'now the second wave gave analysts access to bi.', 'start': 271.364, 'duration': 3.222}, {'end': 278.928, 'text': 'Now, people with some knowledge of analytics could use bi tools.', 'start': 275.307, 'duration': 3.621}, {'end': 285.41, 'text': 'This meant more teams had the access to bi and more people could have better data insights.', 'start': 279.368, 'duration': 6.042}, {'end': 295.813, 'text': 'This is the role of the IT teams and finally the third wave which meant everyone which means the power lied in the hands of the end user.', 'start': 285.97, 'duration': 9.843}, {'end': 303.124, 'text': 'The third wave made it easier to access data and create reports and visuals to get a better business insights.', 'start': 296.243, 'duration': 6.881}, {'end': 310.126, 'text': 'the introduction of tools like power bi tableau, click view and spot fire made this transition easy.', 'start': 303.124, 'duration': 7.002}, {'end': 318.007, 'text': 'Now anybody who had a basic understanding of data could create reports to build intuitive and shareable dashboards.', 'start': 310.526, 'duration': 7.481}, {'end': 325.829, 'text': 'This was about the three waves of bi and in the third view came a very important aspect.', 'start': 318.748, 'duration': 7.081}, {'end': 335.232, 'text': 'Data visualization now data visualization is nothing but the pictorial or graphical representation of information or data.', 'start': 326.57, 'duration': 8.662}, {'end': 343.774, 'text': 'It provides insights into complex data sets by communicating the key aspects in a more intuitive and meaningful way.', 'start': 335.792, 'duration': 7.982}, {'end': 349.535, 'text': 'data visualization allies at the intersection of design, communication and information service.', 'start': 343.774, 'duration': 5.761}], 'summary': 'Shift to self-service bi empowered more teams and individuals with better data insights and visualization capabilities.', 'duration': 93.078, 'max_score': 256.457, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY256457.jpg'}], 'start': 7.062, 'title': 'Power bi and business intelligence evolution', 'summary': 'Covers the importance of power bi in data management crisis, offering a full course on power bi modules, and discusses the evolution of business intelligence through three waves, emphasizing the shift from it to end user, analyst to end user, and enabling everyone to access and create reports, highlighting the importance of data visualization.', 'chapters': [{'end': 164.558, 'start': 7.062, 'title': 'Power bi: mastering data visualization', 'summary': 'Discusses the importance of power bi in solving data management crisis, outlining a full course covering modules on power bi introduction, power bi desktop, charts, kpi indicators, dashboards, a comparison with tableau, interview questions, and market trends, emphasizing its relevance in helping organizations and individuals analyze and visualize their data.', 'duration': 157.496, 'highlights': ['Power BI is the market leader in solving data management crisis.', 'The full course covers modules on Power BI introduction, Power BI Desktop, charts, KPI indicators, dashboards, a comparison with Tableau, interview questions, and market trends.', 'Most organizations have already moved in or have plans to use business intelligence and solving their crisis.', 'Power BI is mainly aimed to help everyone analyze and visualize their data.', 'The first module covers the importance of BI, different tools, and the basic fundamentals of Power BI.']}, {'end': 482.537, 'start': 164.918, 'title': 'Evolution of business intelligence', 'summary': 'Discusses the evolution of business intelligence through three waves, emphasizing the shift from it to end user, analyst to end user, and finally enabling everyone to access and create reports. it also highlights the importance of data visualization in providing insights into complex data sets.', 'duration': 317.619, 'highlights': ['The third wave of business intelligence empowered end users to access data and create reports, leading to better business insights.', 'The second wave allowed analysts access to BI tools, expanding the number of people with better data insights.', 'Data visualization provides insights into complex data sets by communicating key aspects in a more intuitive and meaningful way, facilitating easier understanding and visualization of large amounts of complex data.']}], 'duration': 475.475, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY7062.jpg', 'highlights': ['Power BI is the market leader in solving data management crisis.', 'Most organizations have already moved in or have plans to use business intelligence and solving their crisis.', 'The full course covers modules on Power BI introduction, Power BI Desktop, charts, KPI indicators, dashboards, a comparison with Tableau, interview questions, and market trends.', 'The third wave of business intelligence empowered end users to access data and create reports, leading to better business insights.', 'The second wave allowed analysts access to BI tools, expanding the number of people with better data insights.', 'Data visualization provides insights into complex data sets by communicating key aspects in a more intuitive and meaningful way, facilitating easier understanding and visualization of large amounts of complex data.', 'Power BI is mainly aimed to help everyone analyze and visualize their data.', 'The first module covers the importance of BI, different tools, and the basic fundamentals of Power BI.']}, {'end': 2574.306, 'segs': [{'end': 1141.449, 'src': 'embed', 'start': 1119.46, 'weight': 2, 'content': [{'end': 1128.864, 'text': 'It gives you a search access list for the query to determine which users and security groups can find and use this shared query.', 'start': 1119.46, 'duration': 9.404}, {'end': 1132.466, 'text': "Now that we've seen how the components work.", 'start': 1129.624, 'duration': 2.842}, {'end': 1136.907, 'text': "Let's continue with this tutorial and understand the architecture of Power BI.", 'start': 1132.846, 'duration': 4.061}, {'end': 1141.449, 'text': "Now broadly describing, Power BI's architecture has three phases.", 'start': 1137.408, 'duration': 4.041}], 'summary': 'Power bi architecture has three phases for search access list and tutorial components.', 'duration': 21.989, 'max_score': 1119.46, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY1119460.jpg'}, {'end': 1336.444, 'src': 'embed', 'start': 1309.83, 'weight': 1, 'content': [{'end': 1319.135, 'text': 'Now some of the commonly used visualizations are map representation card visualization stacked area chart tree map and pie chart.', 'start': 1309.83, 'duration': 9.305}, {'end': 1322.757, 'text': 'Now these visualizations can be simple or complex.', 'start': 1319.815, 'duration': 2.942}, {'end': 1330.921, 'text': 'However, visualizations aim at presenting data in such a way that it gives you more insight in the context,', 'start': 1323.337, 'duration': 7.584}, {'end': 1334.603, 'text': 'which is otherwise difficult to discern from simple data files.', 'start': 1330.921, 'duration': 3.682}, {'end': 1336.444, 'text': 'Next we have data sets.', 'start': 1335.323, 'duration': 1.121}], 'summary': 'Common visualizations include map, card, stacked area chart, tree map, and pie chart. visualizations aim to provide deeper insights from data.', 'duration': 26.614, 'max_score': 1309.83, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY1309830.jpg'}, {'end': 1800.821, 'src': 'embed', 'start': 1776.755, 'weight': 4, 'content': [{'end': 1785.297, 'text': 'You can also see that there are a variety of charts available there and then in the visualization box, you will be able to make modifications to it.', 'start': 1776.755, 'duration': 8.542}, {'end': 1791.519, 'text': 'And like I said this, right here is a bar chart, but you will be able to make pie charts, column charts,', 'start': 1785.817, 'duration': 5.702}, {'end': 1796.72, 'text': 'line charts and a variety of other visualizations in power bi.', 'start': 1791.519, 'duration': 5.201}, {'end': 1800.821, 'text': 'a variety of modifications are available for visualizations to right here.', 'start': 1796.72, 'duration': 4.101}], 'summary': 'Power bi offers a range of visualizations for data analysis and modification.', 'duration': 24.066, 'max_score': 1776.755, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY1776755.jpg'}, {'end': 1960.874, 'src': 'embed', 'start': 1935.326, 'weight': 6, 'content': [{'end': 1943.671, 'text': "You'll be able to find them easily using the search bar, or you can use the functionality of defined your recent reports,", 'start': 1935.326, 'duration': 8.345}, {'end': 1949.274, 'text': 'as well as when you will be able to manipulate and share them using power bi.com interface.', 'start': 1943.671, 'duration': 5.603}, {'end': 1955.397, 'text': "We're now going to go into a part 2 which is using multiple data sets.", 'start': 1949.894, 'duration': 5.503}, {'end': 1960.874, 'text': 'So now we are going to be using multiple data sets and joining together in this section.', 'start': 1956.212, 'duration': 4.662}], 'summary': 'Using power bi.com, easily find, manipulate, and share reports, and join multiple data sets.', 'duration': 25.548, 'max_score': 1935.326, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY1935326.jpg'}, {'end': 2003.671, 'src': 'embed', 'start': 1980.273, 'weight': 0, 'content': [{'end': 1987.218, 'text': "You do the same thing that you did before you got your first data set and it's really not very different from how you did it.", 'start': 1980.273, 'duration': 6.945}, {'end': 1992.122, 'text': "You just are having some data you're working with you'll go to the get data button.", 'start': 1987.658, 'duration': 4.464}, {'end': 1995.164, 'text': "You'll push it and our demo will be using Excel.", 'start': 1992.162, 'duration': 3.002}, {'end': 1998.607, 'text': 'But remember you can pull in data from a variety of sources.', 'start': 1995.204, 'duration': 3.403}, {'end': 2003.671, 'text': "It is also good to keep in mind that they don't all have to be the same source.", 'start': 1999.087, 'duration': 4.584}], 'summary': 'Use the get data button to pull in data from various sources, including excel.', 'duration': 23.398, 'max_score': 1980.273, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY1980273.jpg'}, {'end': 2231.869, 'src': 'embed', 'start': 2206.638, 'weight': 8, 'content': [{'end': 2215.981, 'text': 'and add more visualizations into the same report using multiple canvas pages and made a couple of visualizations with power bi and right here.', 'start': 2206.638, 'duration': 9.343}, {'end': 2224.007, 'text': 'What I want is to highlight the fact that you can change the colors on your report to highlight certain things for example, Right here.', 'start': 2216.041, 'duration': 7.966}, {'end': 2231.869, 'text': "We've added some black to the columns and power bi actually gives you really strong granular control over.", 'start': 2224.027, 'duration': 7.842}], 'summary': 'Using power bi to add visualizations and customize report colors for strong granular control.', 'duration': 25.231, 'max_score': 2206.638, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY2206638.jpg'}, {'end': 2417.529, 'src': 'embed', 'start': 2392.709, 'weight': 7, 'content': [{'end': 2399.795, 'text': "the easiest way to create a dashboard is to simply click on the pin icon which you'll see on your visualization,", 'start': 2392.709, 'duration': 7.086}, {'end': 2403.017, 'text': "and we'll then give you the option to create a dashboard.", 'start': 2399.795, 'duration': 3.222}, {'end': 2406.045, 'text': "You'll also see as we show you on the screen here.", 'start': 2403.544, 'duration': 2.501}, {'end': 2409.966, 'text': "There's a plus sign next to the word dashboards in the Power BI interface.", 'start': 2406.225, 'duration': 3.741}, {'end': 2412.467, 'text': "You'll create a new dashboard there too.", 'start': 2410.367, 'duration': 2.1}, {'end': 2417.529, 'text': "Once you've created that dashboard, you can continue to pin visualizations to it.", 'start': 2413.128, 'duration': 4.401}], 'summary': 'Create dashboards easily by pinning visualizations and using the plus sign in power bi interface.', 'duration': 24.82, 'max_score': 2392.709, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY2392709.jpg'}, {'end': 2563.987, 'src': 'embed', 'start': 2536.37, 'weight': 9, 'content': [{'end': 2540.871, 'text': 'you do want to send an email notification when you share something with them.', 'start': 2536.37, 'duration': 4.501}, {'end': 2545.772, 'text': "So then they'll know that it's shared with them and they'll be able to go access it.", 'start': 2541.451, 'duration': 4.321}, {'end': 2548.158, 'text': "There's an option you can check as well.", 'start': 2546.417, 'duration': 1.741}, {'end': 2554.602, 'text': 'You can also share your dashboard once again by simply copying and pasting the URL,', 'start': 2548.638, 'duration': 5.964}, {'end': 2560.425, 'text': "once you've clicked that share button and added the person's email address or their name and shared it with them.", 'start': 2554.602, 'duration': 5.823}, {'end': 2563.987, 'text': 'Even if they lose the link or they forget about it.', 'start': 2561.066, 'duration': 2.921}], 'summary': 'Users can send email notifications when sharing content and easily share dashboards by copying and pasting the url.', 'duration': 27.617, 'max_score': 2536.37, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY2536370.jpg'}], 'start': 483.077, 'title': 'Power bi and data visualization', 'summary': 'Covers the importance and benefits of power bi, the etl process, building blocks of power bi, visualizations, reports, dashboards, and creating/sharing dashboards in power bi.', 'chapters': [{'end': 1141.449, 'start': 483.077, 'title': 'Power bi: data visualization tool', 'summary': 'Discusses the importance and benefits of power bi in data visualization, highlighting its real-time trend spotting, automatic insights search, enterprise readiness, and broad user applicability.', 'duration': 658.372, 'highlights': ['Power BI can spot Trends in real time, providing real-time information for early trend identification and issue resolution.', 'Power BI can automatically search hidden insights in seconds, enabling quick insights and immediate answers to user questions.', 'Power BI is Enterprise ready, providing secure, scalable, and reliable enterprise-grade information technology, making it important in the context of data visualization.', 'Power BI is applicable to IT professionals, developers, companies, subject matter experts, and analytics enthusiasts, making it accessible to a broad user base.']}, {'end': 1378.366, 'start': 1141.449, 'title': 'Etl process and power bi building blocks', 'summary': 'Explains the etl process, comprising data integration, processing, and presentation, and delves into the building blocks of power bi, including visualizations and data sets.', 'duration': 236.917, 'highlights': ['The ETL process involves data integration, processing, and presentation, with the data first extracted, integrated, pre-processed, and transformed before being loaded into a data warehouse, followed by visualization using Power BI.', 'Power BI building blocks consist of visualizations like graphs and charts, data sets comprising collections of information, and the ability to filter and combine data from various sources for analysis.']}, {'end': 1634.263, 'start': 1378.626, 'title': 'Power bi: visualizations, reports, and dashboards', 'summary': 'Introduces power bi features such as visualizations, reports, and dashboards, with an emphasis on creating and sharing actionable reports and dashboards for business insights, and covers topics including creating visualizations, joining data from multiple sources, building and sharing dashboards, and installing the power bi application.', 'duration': 255.637, 'highlights': ['Power BI allows creating visualizations and reports for gaining insights.', 'The difference between reports and dashboards in Power BI.', 'Installing the Power BI application and getting started.']}, {'end': 2276.856, 'start': 1634.263, 'title': 'Power bi data visualization', 'summary': 'Provides a comprehensive guide to using power bi for data visualization, including accessing and selecting data, creating visualizations, modifying and saving reports, and publishing reports to the power bi service.', 'duration': 642.593, 'highlights': ['Power BI offers a variety of data sources for pulling in data, such as Excel, SQL Server, and Access databases, providing flexibility in data selection.', 'Users can easily modify visualizations by dragging and dropping the corners, changing colors, and resizing charts, providing granular control over the appearance of visualizations.', "The process of publishing reports to the Power BI service is straightforward, involving a simple click on the 'publish' button and the option to either overwrite or rename the report for subsequent publications."]}, {'end': 2574.306, 'start': 2277.537, 'title': 'Creating & sharing power bi dashboards', 'summary': 'Explains the creation and sharing of dashboards in power bi, including the process of creating a dashboard, pinning visualizations, modifying the dashboard, and sharing it with colleagues or customers.', 'duration': 296.769, 'highlights': ['A dashboard is a type of report where visualizations from other Power BI reports are pinned to one specific place and can be updated in real time.', "The process of creating a dashboard involves clicking on the pin icon on visualizations or using the plus sign next to the 'dashboards' option in the Power BI interface.", 'Modifying dashboards involves adjusting the size of visualizations and sharing the dashboard with colleagues or customers by typing in names or email addresses and allowing email notifications.']}], 'duration': 2091.229, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY483077.jpg', 'highlights': ['Power BI can spot Trends in real time, providing real-time information for early trend identification and issue resolution.', 'Power BI can automatically search hidden insights in seconds, enabling quick insights and immediate answers to user questions.', 'Power BI is Enterprise ready, providing secure, scalable, and reliable enterprise-grade information technology, making it important in the context of data visualization.', 'Power BI is applicable to IT professionals, developers, companies, subject matter experts, and analytics enthusiasts, making it accessible to a broad user base.', 'The ETL process involves data integration, processing, and presentation, with the data first extracted, integrated, pre-processed, and transformed before being loaded into a data warehouse, followed by visualization using Power BI.', 'Power BI building blocks consist of visualizations like graphs and charts, data sets comprising collections of information, and the ability to filter and combine data from various sources for analysis.', 'Power BI offers a variety of data sources for pulling in data, such as Excel, SQL Server, and Access databases, providing flexibility in data selection.', 'Users can easily modify visualizations by dragging and dropping the corners, changing colors, and resizing charts, providing granular control over the appearance of visualizations.', "The process of publishing reports to the Power BI service is straightforward, involving a simple click on the 'publish' button and the option to either overwrite or rename the report for subsequent publications.", 'A dashboard is a type of report where visualizations from other Power BI reports are pinned to one specific place and can be updated in real time.', "The process of creating a dashboard involves clicking on the pin icon on visualizations or using the plus sign next to the 'dashboards' option in the Power BI interface.", 'Modifying dashboards involves adjusting the size of visualizations and sharing the dashboard with colleagues or customers by typing in names or email addresses and allowing email notifications.', 'Power BI allows creating visualizations and reports for gaining insights.', 'The difference between reports and dashboards in Power BI.', 'Installing the Power BI application and getting started.']}, {'end': 3488.489, 'segs': [{'end': 2667.071, 'src': 'embed', 'start': 2639.858, 'weight': 0, 'content': [{'end': 2645.022, 'text': "So let me just give you a simple overview with respect to how Power BI works, and then we'll start with respect to our session.", 'start': 2639.858, 'duration': 5.164}, {'end': 2647.584, 'text': 'Now, first you have a simple workspace.', 'start': 2645.462, 'duration': 2.122}, {'end': 2650.486, 'text': "That is the first workspace that you're seeing is the report workspace.", 'start': 2647.604, 'duration': 2.882}, {'end': 2656.608, 'text': 'This is the workspace where you will be creating the different visuals as well as creating the different reports as well.', 'start': 2650.806, 'duration': 5.802}, {'end': 2658.548, 'text': 'Then you have the data workspace.', 'start': 2657.068, 'duration': 1.48}, {'end': 2662.73, 'text': "So when you're loading a data, any data that you're working with can be viewed here.", 'start': 2658.788, 'duration': 3.942}, {'end': 2667.071, 'text': 'All the modifications that you want to perform with respect to the data can be done here.', 'start': 2662.97, 'duration': 4.101}], 'summary': 'Power bi involves creating visuals and reports in a report workspace, and performing data modifications in a data workspace.', 'duration': 27.213, 'max_score': 2639.858, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY2639858.jpg'}, {'end': 2849.331, 'src': 'embed', 'start': 2819.343, 'weight': 3, 'content': [{'end': 2827.426, 'text': 'as you can see, this player number 20, despite having the best KD ratio, does not necessarily have the best absolute number of kills.', 'start': 2819.343, 'duration': 8.083}, {'end': 2836.669, 'text': "So you can do a lot of cool stuff like this with the power bi let's move on to our basic stacked and clustered charts.", 'start': 2828.266, 'duration': 8.403}, {'end': 2849.331, 'text': 'Now this entire column gives you bar and column charts now they are of two types mainly one is the stacked chart and one is the clustered chart.', 'start': 2841.044, 'duration': 8.287}], 'summary': 'Player 20 has the best kd ratio, but not the most kills. power bi can create stacked and clustered charts.', 'duration': 29.988, 'max_score': 2819.343, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY2819343.jpg'}, {'end': 2956.004, 'src': 'embed', 'start': 2921.469, 'weight': 4, 'content': [{'end': 2923.91, 'text': 'Next we have our line and area charts.', 'start': 2921.469, 'duration': 2.441}, {'end': 2935.515, 'text': 'So these are the charts which usually show growth but you can also use an area chart to show volume in some cases here.', 'start': 2927.793, 'duration': 7.722}, {'end': 2947.459, 'text': "I'll be finding out the tick rate by plotting tick against the second on the axis will take the seconds tab and in the values will take the count of tick.", 'start': 2935.575, 'duration': 11.884}, {'end': 2956.004, 'text': 'So, for those who have a doubt, Tick rate is basically the number of times your game refreshes in a second.', 'start': 2948.679, 'duration': 7.325}], 'summary': "Line and area charts display growth and volume, with tick rate representing the game's refresh frequency.", 'duration': 34.535, 'max_score': 2921.469, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY2921469.jpg'}, {'end': 3117.371, 'src': 'embed', 'start': 3088.97, 'weight': 1, 'content': [{'end': 3091.271, 'text': "It's a big circle cut into pieces can't really miss it.", 'start': 3088.97, 'duration': 2.301}, {'end': 3099.155, 'text': 'A donut chart is essentially the same thing except for that it has a smaller circle cut out in the middle turning the filled pie into a hollow donut.', 'start': 3092.071, 'duration': 7.084}, {'end': 3104.077, 'text': "It's a visual preference mainly but there is a key difference between both of them.", 'start': 3099.995, 'duration': 4.082}, {'end': 3105.718, 'text': "Let's start with the pie chart.", 'start': 3104.717, 'duration': 1.001}, {'end': 3113.742, 'text': "In the legend I'll be putting the weapon and in the values also, I'll be putting the count of weapon.", 'start': 3107.259, 'duration': 6.483}, {'end': 3117.371, 'text': "I'll be doing the same thing for a donut chart as well.", 'start': 3114.81, 'duration': 2.561}], 'summary': 'Pie and donut charts visually represent data, with legend and count displayed.', 'duration': 28.401, 'max_score': 3088.97, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY3088970.jpg'}, {'end': 3316.176, 'src': 'embed', 'start': 3287.943, 'weight': 9, 'content': [{'end': 3290.445, 'text': "Change the color saturation while I'm here.", 'start': 3287.943, 'duration': 2.502}, {'end': 3292.546, 'text': 'Let me also explain the slicer to you people.', 'start': 3290.485, 'duration': 2.061}, {'end': 3299.851, 'text': 'Basically, a slicer slices the data according to how you need it, according to a certain field.', 'start': 3293.787, 'duration': 6.064}, {'end': 3303.013, 'text': "suppose I'm slicing data according to the absolute number of kills here.", 'start': 3299.851, 'duration': 3.162}, {'end': 3307.556, 'text': 'You can actually control the data visualization from both the sides.', 'start': 3303.673, 'duration': 3.883}, {'end': 3313.495, 'text': 'You can see the absolute number of kills in each bar between the 61st and the 104th kill.', 'start': 3308.271, 'duration': 5.224}, {'end': 3316.176, 'text': "So that's basically how a slicer works.", 'start': 3314.255, 'duration': 1.921}], 'summary': 'Explained using a slicer to slice data by absolute number of kills and control data visualization.', 'duration': 28.233, 'max_score': 3287.943, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY3287943.jpg'}], 'start': 2574.867, 'title': 'Power bi desktop and visualizations', 'summary': 'Covers installing power bi, creating reports, and using various power bi desktop charts, demonstrating charts and insights for counter-strike geo game data, and introducing a variety of visualizations in bi tools including charts, maps, and tabular visualizations.', 'chapters': [{'end': 2697.292, 'start': 2574.867, 'title': 'Power bi desktop report creation', 'summary': 'Covers the process of installing power bi, creating reports, and understanding the workspace, emphasizing the importance of creating visuals, reports, and managing relationships while discussing various power bi desktop charts.', 'duration': 122.425, 'highlights': ['The chapter emphasizes the process of installing Power BI and navigating through its various workspaces, including the report, data, and relational workspaces.', 'It mentions the significance of creating visuals and reports in the report workspace, modifying data in the data workspace, and managing relationships in the relational workspace.', 'The session will cover all the charts needed to build effective reports on the Power BI Desktop, focusing on when to appropriately use them.']}, {'end': 2979.889, 'start': 2697.933, 'title': 'Power bi charts demo', 'summary': 'Demonstrates using power bi to create bar, stacked, clustered, line, and area charts to analyze counter-strike geo game data, including player statistics and game performance indicators like tick rate, providing insights into weapon usage, game dynamics, and player performance.', 'duration': 281.956, 'highlights': ['Creating bar, stacked, and clustered charts to analyze Counter-Strike Geo game data, including player statistics and game performance indicators like tick rate.', 'Using area chart to visualize tick rate and its implications for competitive gaming.', 'Explaining the data source and its nature, acquired through various gamer tags and available through an API.']}, {'end': 3488.489, 'start': 2980.19, 'title': 'Visualizations in bi tools', 'summary': 'Introduces various visualizations in bi tools including combination chart, ribbon chart, pie chart, donut chart, tree maps, maps on bi, funnel charts, gauges, cards, kpis, and tabular visualizations, highlighting the usage and features of each.', 'duration': 508.299, 'highlights': ['Combination chart is a mix of bar and line chart, used for comparing data like KD ratio and number of kills.', 'Ribbon chart shows data relative to the maximum measure, suitable for displaying the count of weapons with respect to the type.', 'Pie chart and donut chart are compared, emphasizing the visual preference and the difference in the way data is perceived.', 'Maps on BI, including field maps and regular maps, are utilized to show data density and geographical distribution of players.', 'Slicer is explained as a tool to slice and control data visualization, allowing data segmentation based on specific fields such as absolute number of kills.', 'Gauges, cards, and KPIs are introduced as visuals to track progress, show numeric representation, and display key performance indicators with trend analysis.', 'Tabular visualizations such as tables and matrices are demonstrated for displaying and analyzing data in a structured format.']}], 'duration': 913.622, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY2574867.jpg', 'highlights': ['The chapter emphasizes installing Power BI and navigating through its workspaces.', 'Creating visuals and reports in the report workspace is significant.', 'Covering all the charts needed to build effective reports on Power BI Desktop.', 'Creating bar, stacked, and clustered charts to analyze Counter-Strike Geo game data.', 'Using area chart to visualize tick rate and its implications for competitive gaming.', 'Combination chart is used for comparing data like KD ratio and number of kills.', 'Ribbon chart shows data relative to the maximum measure, suitable for displaying the count of weapons.', 'Maps on BI are utilized to show data density and geographical distribution of players.', 'Slicer is explained as a tool to slice and control data visualization.', 'Gauges, cards, and KPIs are introduced as visuals to track progress and display key performance indicators.', 'Tabular visualizations such as tables and matrices are demonstrated for displaying and analyzing data.']}, {'end': 4490.273, 'segs': [{'end': 3624.564, 'src': 'embed', 'start': 3595.385, 'weight': 3, 'content': [{'end': 3601.87, 'text': 'Next So this is a really important question when to use a KPI so KPIs mainly answer two questions.', 'start': 3595.385, 'duration': 6.485}, {'end': 3608.071, 'text': 'A, what am I ahead or behind on? This specifically refers to a number which is your target.', 'start': 3602.546, 'duration': 5.525}, {'end': 3615.857, 'text': 'And secondly, how far ahead or behind am I? So this represents a trend which is related to the target.', 'start': 3608.531, 'duration': 7.326}, {'end': 3624.564, 'text': 'Since a KPI is based on a specific measure, it is designed to help you evaluate a current value and the status of the metric.', 'start': 3616.637, 'duration': 7.927}], 'summary': 'Kpis answer what am i ahead or behind on and how far ahead or behind am i, based on specific measures.', 'duration': 29.179, 'max_score': 3595.385, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY3595385.jpg'}, {'end': 3988.205, 'src': 'embed', 'start': 3956.54, 'weight': 0, 'content': [{'end': 3959.421, 'text': 'click on it, search for something called power KPI.', 'start': 3956.54, 'duration': 2.881}, {'end': 3967.083, 'text': 'Okay, you can see the icon appear here with other icons on your visualization pane.', 'start': 3961.321, 'duration': 5.762}, {'end': 3971.484, 'text': 'You can use it like you use any other visualization here.', 'start': 3968.963, 'duration': 2.521}, {'end': 3975.823, 'text': 'So you can just drag and drop different values on your values.', 'start': 3972.122, 'duration': 3.701}, {'end': 3988.205, 'text': 'Your axis has to be a certain date does not matter what date but it can be a period or a month, but it has to have a date then in your values field.', 'start': 3976.463, 'duration': 11.742}], 'summary': 'Using power kpi, drag and drop values for visualization with a date axis.', 'duration': 31.665, 'max_score': 3956.54, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY3956540.jpg'}, {'end': 4480.229, 'src': 'embed', 'start': 4455.326, 'weight': 2, 'content': [{'end': 4461.63, 'text': "However, in a report, here you have complete right with respect to the visualization as well as the data that you're working on.", 'start': 4455.326, 'duration': 6.304}, {'end': 4467.554, 'text': "So you can modify it, change it as per your requirements, it's completely left to you as to how you can work around with it.", 'start': 4462.03, 'duration': 5.524}, {'end': 4473.566, 'text': 'So are you guys clear with respect to both? How a report is different from a dashboard? Okay, I seem to have a question here.', 'start': 4467.954, 'duration': 5.612}, {'end': 4480.229, 'text': "Do we need to create reports for dashboards? Definitely you do, because it's from the reports that you will be going on to create a dashboard.", 'start': 4473.606, 'duration': 6.623}], 'summary': 'Reports can be modified as per requirements; they are used to create dashboards.', 'duration': 24.903, 'max_score': 4455.326, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY4455326.jpg'}], 'start': 3489.955, 'title': 'Power bi features', 'summary': 'Discusses kpi concept and application in power bi, formatting options, and differences between dashboards and reports, offering a step-by-step guide, customization, and highlighting key features and limitations, such as data sources, pinning options, and filtering capabilities.', 'chapters': [{'end': 3784.171, 'start': 3489.955, 'title': 'Understanding kpi in power bi', 'summary': 'Discusses the concept of kpi, its application in power bi, and provides a step-by-step guide to creating kpi visualization in power bi, covering key points such as the definition of kpi, its usage, and the process of creating kpi visualization.', 'duration': 294.216, 'highlights': ['KPI, or key performance indicator, is a visual cue that demonstrates the progress towards a goal, used to evaluate business objectives.', 'KPIs are used at multiple levels within organizations to evaluate success in reaching targets, both internally and externally.', "KPIs mainly answer two questions: 'What am I ahead or behind on?' and 'How far ahead or behind am I?'", 'A KPI requires a base measure, a target measure, and a threshold or goal against which the target is set.', 'Creating a KPI visualization involves starting with a column graph and then converting it into a KPI, followed by importing appropriate data and setting target goals.']}, {'end': 4137.252, 'start': 3784.271, 'title': 'Power bi formatting and visualization', 'summary': 'Covers formatting options in power bi, including sorting, kpi customization, and visualization, enabling users to enhance the display of data and create custom kpis for improved data analysis and decision-making.', 'duration': 352.981, 'highlights': ["Users can sort the months in Power BI by choosing the 'sort by column' option and selecting either fiscal month or month number, impacting the display and analysis of sales data.", 'The formatting pane in Power BI allows users to customize KPIs, including indicator display units, decimal places, trend axis, goals, color coding, and graph direction, facilitating tailored visual representation of key performance indicators.', "Users can create custom KPIs in Power BI by utilizing the 'power KPI' option from the Marketplace, enabling the display and analysis of multiple key performance indicators for enhanced decision-making.", 'Power BI offers customizable visualization options, allowing users to choose different chart types, banding types, and color schemes, providing flexibility in displaying and analyzing data for improved insights.']}, {'end': 4490.273, 'start': 4137.832, 'title': 'Power bi dashboard vs report', 'summary': 'Explains the differences between a power bi dashboard and a report, emphasizing that a dashboard is a single-page visualization presenting a summarized story to meet user requirements, while a report is more detailed and specific, allowing for data filtering, slicing, and modification. it also outlines the various features and limitations of dashboards and reports, including data sources, pinning options, filtering capabilities, alerts, customization, and the necessity of creating reports for dashboards.', 'duration': 352.441, 'highlights': ['A dashboard is a single-page visualization presenting a summarized story to meet user requirements.', 'A report is more detailed and specific, allowing for data filtering, slicing, and modification.', 'Reports give a complete idea, whereas a dashboard provides a complete overview.', 'Data filtering, slicing, and modification are possible on a report level, but not on a dashboard level.', 'Reports are essential for creating dashboards.']}], 'duration': 1000.318, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY3489955.jpg', 'highlights': ['KPIs are visual cues for evaluating business objectives.', "KPIs answer 'What am I ahead or behind on?' and 'How far ahead or behind am I?'", 'Power BI allows customization of KPIs, including indicator display units and color coding.', "Users can sort months in Power BI by choosing the 'sort by column' option.", 'A dashboard presents a summarized story, while a report allows for data filtering and modification.']}, {'end': 6383.29, 'segs': [{'end': 4861.318, 'src': 'embed', 'start': 4835.157, 'weight': 11, 'content': [{'end': 4839.5, 'text': "So what we'll do is we'll try to change the colors with respect to which they are represented.", 'start': 4835.157, 'duration': 4.343}, {'end': 4842.743, 'text': 'So for that go to the next field that is the format field.', 'start': 4839.96, 'duration': 2.783}, {'end': 4845.707, 'text': 'Now here you have the option of data colors.', 'start': 4843.705, 'duration': 2.002}, {'end': 4854.033, 'text': "Now the same size with respect to the profit scene can also be represented in a different map based system also that's called field map system.", 'start': 4846.067, 'duration': 7.966}, {'end': 4861.318, 'text': 'Wherein what actually happens is that the color intensity of each of the states is with respect to the value of profit that they make.', 'start': 4854.433, 'duration': 6.885}], 'summary': 'Change colors to represent data values in profit map.', 'duration': 26.161, 'max_score': 4835.157, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY4835157.jpg'}, {'end': 4917.16, 'src': 'embed', 'start': 4889.147, 'weight': 5, 'content': [{'end': 4892.57, 'text': 'So this basically helps me get a better idea with respect to this as well.', 'start': 4889.147, 'duration': 3.423}, {'end': 4897.094, 'text': "Now let's say if you want to go more detail, let's say the minimum or let's say the center.", 'start': 4892.83, 'duration': 4.264}, {'end': 4898.775, 'text': "Okay, I'll set it as zero.", 'start': 4897.394, 'duration': 1.381}, {'end': 4902.798, 'text': 'Okay, that means states which are not giving me negative profits are center.', 'start': 4899.115, 'duration': 3.683}, {'end': 4907.783, 'text': "Okay, states below that should get, let's say, I give them a blue color.", 'start': 4903.179, 'duration': 4.604}, {'end': 4911.826, 'text': 'Okay, center, let me give a different color, let me say yellow.', 'start': 4908.483, 'duration': 3.343}, {'end': 4915.418, 'text': 'And the maximum profit making states are in green.', 'start': 4912.816, 'duration': 2.602}, {'end': 4917.16, 'text': 'So here it starts from blue.', 'start': 4915.618, 'duration': 1.542}], 'summary': 'Analyzing profit data to categorize states by color based on profit levels.', 'duration': 28.013, 'max_score': 4889.147, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY4889147.jpg'}, {'end': 4957.854, 'src': 'embed', 'start': 4929.93, 'weight': 1, 'content': [{'end': 4934.514, 'text': 'So you can see the variation with respect to the color and how we have modulated with respect to that.', 'start': 4929.93, 'duration': 4.584}, {'end': 4939.178, 'text': 'So I hope you guys have got a simple feel of how to create a visual with respect to Power BI.', 'start': 4934.614, 'duration': 4.564}, {'end': 4941.883, 'text': 'Okay, I have another question here.', 'start': 4940.202, 'duration': 1.681}, {'end': 4944.205, 'text': 'How do you know which visual to work with??', 'start': 4942.444, 'duration': 1.761}, {'end': 4951.55, 'text': 'Okay, so, by default you get multiple kinds of visuals present in Power BI itself, and there are a lot of custom visuals as well.', 'start': 4944.525, 'duration': 7.025}, {'end': 4957.854, 'text': 'So it is completely left to you as a representator as to what form of visual that you want to represent it.', 'start': 4951.81, 'duration': 6.044}], 'summary': 'Understanding power bi visuals and their customization options.', 'duration': 27.924, 'max_score': 4929.93, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY4929930.jpg'}, {'end': 5337.084, 'src': 'embed', 'start': 5310.795, 'weight': 8, 'content': [{'end': 5319.719, 'text': 'You have Canada, Caribbean, Central Africa, Central America, Central Asia, Central US, Eastern Asia, Eastern Europe and so forth.', 'start': 5310.795, 'duration': 8.924}, {'end': 5321.58, 'text': 'So you have different regions as well.', 'start': 5319.739, 'duration': 1.841}, {'end': 5325.781, 'text': "So what we'll be doing is, so let's say I want to see it with respect to Eastern Asia.", 'start': 5321.92, 'duration': 3.861}, {'end': 5329.762, 'text': 'When I click on Eastern Asia, the visualization takes a change again here.', 'start': 5325.841, 'duration': 3.921}, {'end': 5337.084, 'text': 'So with respect to Eastern Asia, I had made 150, 000 worth sale and I had made just a profit of 30, 000.', 'start': 5330.103, 'duration': 6.981}], 'summary': 'In eastern asia, sales reached 150,000 with a profit of 30,000.', 'duration': 26.289, 'max_score': 5310.795, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY5310795.jpg'}, {'end': 5518.67, 'src': 'embed', 'start': 5490.791, 'weight': 6, 'content': [{'end': 5496.84, 'text': 'New York has almost close to $311, 000 worth sales and it has a profit of 74, 000.', 'start': 5490.791, 'duration': 6.049}, {'end': 5504.123, 'text': "So it's almost close because these regions have a huge difference with respect to sale amount, but the profit is almost same in New York.", 'start': 5496.84, 'duration': 7.283}, {'end': 5510.406, 'text': 'Okay But when you come down to this region, the next state that is following it is Washington.', 'start': 5504.624, 'duration': 5.782}, {'end': 5518.67, 'text': 'Now Washington, what is happening is that I have just 138, 000 worth sale and my profit is 33, 000.', 'start': 5510.787, 'duration': 7.883}], 'summary': 'New york has $311,000 sales with $74,000 profit, while washington has $138,000 sales with $33,000 profit.', 'duration': 27.879, 'max_score': 5490.791, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY5490791.jpg'}, {'end': 5608.29, 'src': 'embed', 'start': 5561.789, 'weight': 0, 'content': [{'end': 5565.612, 'text': 'So these become the regions which I need to concentrate more.', 'start': 5561.789, 'duration': 3.823}, {'end': 5569.235, 'text': 'Okay, that is, these are my highest priority states.', 'start': 5565.992, 'duration': 3.243}, {'end': 5573.758, 'text': "Okay, apart from that, let's say you want to add a specific trend line here.", 'start': 5569.715, 'duration': 4.043}, {'end': 5577.28, 'text': 'So for that you need to come to the analytics tab here.', 'start': 5574.158, 'duration': 3.122}, {'end': 5582.464, 'text': 'So trend line basically is a reference line that you can set, okay, based on your overall growth.', 'start': 5577.601, 'duration': 4.863}, {'end': 5585.066, 'text': 'So this is your standard sales to profit growth.', 'start': 5582.744, 'duration': 2.322}, {'end': 5589.75, 'text': 'So anything above this is definitely good for you, but anything below is not really good.', 'start': 5585.366, 'duration': 4.384}, {'end': 5592.024, 'text': "Let's say you don't want a trend line.", 'start': 5590.563, 'duration': 1.461}, {'end': 5593.584, 'text': "Let me remove this, let's come back.", 'start': 5592.044, 'duration': 1.54}, {'end': 5596.605, 'text': "Let's say you wanna add an x-axis constant line.", 'start': 5594.364, 'duration': 2.241}, {'end': 5603.648, 'text': "So let me add the value of, let's say, which are the regions that come below the x-axis value of 100, 000, okay?", 'start': 5596.865, 'duration': 6.783}, {'end': 5608.29, 'text': 'So these are the regions that I need to improve my sales.', 'start': 5605.349, 'duration': 2.941}], 'summary': 'Identifying highest priority states and sales improvement regions through trend lines and constant lines.', 'duration': 46.501, 'max_score': 5561.789, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY5561789.jpg'}, {'end': 5802.491, 'src': 'embed', 'start': 5762.321, 'weight': 3, 'content': [{'end': 5765.762, 'text': "So rather than taking the categories, what I'll take is the subcategories.", 'start': 5762.321, 'duration': 3.441}, {'end': 5767.383, 'text': 'This will give me a broader idea.', 'start': 5765.782, 'duration': 1.601}, {'end': 5771.864, 'text': "So I'll bring in the subcategories and I'll add to it the number of sales.", 'start': 5767.743, 'duration': 4.121}, {'end': 5775.606, 'text': 'So this basically is going to be represented in a table form.', 'start': 5772.264, 'duration': 3.342}, {'end': 5778.186, 'text': 'But a table form is not really helpful for me.', 'start': 5776.066, 'duration': 2.12}, {'end': 5780.867, 'text': "So what I'll do is I'll put it in a clustered bar chart.", 'start': 5778.246, 'duration': 2.621}, {'end': 5789.21, 'text': 'So when I do it in this way, it becomes a clustered bar chart giving me the different sales made by each of the subcategories.', 'start': 5781.368, 'duration': 7.842}, {'end': 5791.351, 'text': "Now what I'll do is I'll variate it a little bit.", 'start': 5789.55, 'duration': 1.801}, {'end': 5796.307, 'text': "Okay, now to this what I'll do is I'll just bring in the profits as well.", 'start': 5792.025, 'duration': 4.282}, {'end': 5799.949, 'text': "Okay, so I'll add the profit into the color saturation option.", 'start': 5796.908, 'duration': 3.041}, {'end': 5802.491, 'text': 'Okay, so this you can see has variated.', 'start': 5800.47, 'duration': 2.021}], 'summary': 'Analyzing subcategories with sales and profits in clustered bar chart.', 'duration': 40.17, 'max_score': 5762.321, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY5762321.jpg'}], 'start': 4490.633, 'title': 'Superstore data analysis and power bi visualization', 'summary': 'Introduces a superstore dataset from a us organization collected from 2011 to 2016, aiming to achieve insights on overall sales and profit performance, regional and state performance, segment performance, and revenue generated by each product category. it also covers importing an excel dataset into power bi, analyzing and visualizing the data to identify profitable states and regions, creating visuals, and analyzing sales and profit data to reveal insights into varying performance of different regions and the profitability of states within the united states, leading to the creation of multiple reports and the publication of a power bi dashboard. additionally, it discusses creating a power bi dashboard, including filtering by country, pinning visuals to the dashboard, using q&a feature to analyze data, and the cost of upgrading to power bi pro at $10 a month with a 30-day trial period.', 'chapters': [{'end': 4584.89, 'start': 4490.633, 'title': 'Superstore data analysis', 'summary': 'Introduces a superstore dataset from a us organization collected from 2011 to 2016, aiming to achieve four insights: overall sales and profit performance, regional performance, state performance, segment performance, and revenue generated by each product category.', 'duration': 94.257, 'highlights': ['The dataset is from a US organization and covers the years 2011 to 2016.', 'The main goal is to achieve four insights: overall performance, regional performance, state performance, segment performance, and revenue generated by each category of product.', 'Identifying profitable and non-profitable regions as well as the opportunity for growth in different states is a key part of the analysis.']}, {'end': 4929.29, 'start': 4585.43, 'title': 'Importing and analyzing data in power bi', 'summary': 'Covers importing an excel dataset into power bi, analyzing and visualizing the data to identify profitable states and regions, using filters and color representations to gain insights, and modifying the data operations in the query editor.', 'duration': 343.86, 'highlights': ['The chapter covers importing an Excel dataset into Power BI, analyzing and visualizing the data to identify profitable states and regions, using filters and color representations to gain insights, and modifying the data operations in the query editor.', 'Upon importing the dataset, it extracts about 200 rows to provide an overview and verify the validity of the data set, ensuring a successful loading of the data.', 'In the data workspace, users can view the complete preview of the data and perform operations using the query editor, while being able to remove unwanted or unnecessary operations performed by Power BI.', 'The process of creating sample visuals involves combining different states and their respective profits to create a geographical representation of the profits across different countries, allowing for filtering of data by country and identifying positive and negative states based on profits.', 'The visualization of profits across different states can be enhanced by changing color representations using the format tab, specifically using data colors and divergence to represent the value of profits with different color intensities.', 'The color setup can be further modified to provide a clearer understanding, such as setting specific colors for minimum, center, and maximum profits, providing a more detailed and visually informative representation of the data.']}, {'end': 5155.63, 'start': 4929.93, 'title': 'Power bi visual creation and data analysis', 'summary': 'Demonstrates how to create visuals in power bi, including selecting visual types, and then proceeds to analyze sales and profit data, identifying trends and insights, including specific figures for sales and profit in different quarters.', 'duration': 225.7, 'highlights': ['The presenter explains the process of creating visuals in Power BI, emphasizing the ability to choose from multiple visual types and customize as per requirement.', 'The chapter provides detailed insights into sales and profit figures for different quarters, including specific numbers such as sales reaching 4.3 million and profit of $500,000 in quarter four.', 'The presenter demonstrates the sorting feature in Power BI, showcasing the ability to sort data by sales or profit and adjust the order from descending to ascending.', 'The chapter emphasizes the importance of selecting the appropriate visual representation for different types of data, highlighting the effectiveness of pie charts for certain data and the limitations of bar or line charts for clear-cut visualization.']}, {'end': 5561.169, 'start': 5155.63, 'title': 'Data visualization insights', 'summary': 'Discusses the creation of data visualizations to analyze sales and profit data from 2011 to 2015, revealing insights such as the varying performance of different regions and the profitability of states within the united states.', 'duration': 405.539, 'highlights': ['The visualization combines data from different quarters, summing up sales and profit for the years 2011 to 2015, resulting in a clearer understanding of the overall performance.', 'Analyzing sales and profit with respect to different regions reveals varying performance, such as identifying regions with significant growth and those that require further investigation.', 'The creation of a scatter chart in Power BI allows for the visual representation of state-wise sales and profit data, highlighting the varying profitability of different states within the United States.']}, {'end': 6108.211, 'start': 5561.789, 'title': 'Sales analysis insights and visualization', 'summary': 'Discusses the prioritization of sales regions based on quadrant analysis, trend lines, and constant lines, followed by segment-wise performance analysis and revenue generation insights, leading to the creation of multiple reports and the publication of a power bi dashboard.', 'duration': 546.422, 'highlights': ['Prioritization of sales regions based on quadrant analysis, trend lines, and constant lines', 'Segment-wise performance analysis using clustered bar charts', 'Insights into revenue generation by category of products using line charts', 'Creation of multiple reports and publication of a Power BI dashboard']}, {'end': 6383.29, 'start': 6108.731, 'title': 'Power bi dashboard creation', 'summary': 'Discusses creating a power bi dashboard, including filtering by country, pinning visuals to the dashboard, using q&a feature to analyze data, and the cost of upgrading to power bi pro at $10 a month with a 30-day trial period.', 'duration': 274.559, 'highlights': ['The chapter discusses creating a Power BI dashboard and filtering data by country, emphasizing the importance of considering the whole profit of the United States rather than individual states.', 'It explains the process of pinning visuals to the dashboard, showcasing how to create and organize a dashboard with multiple visuals, and demonstrates the web and mobile view of the dashboard.', "It highlights the unique feature of Power BI Q&A, demonstrating how to use it to analyze data by asking questions such as 'which state has the highest sales' and 'which state has the highest profit', providing insights with corresponding values and descending order.", 'It mentions the option of upgrading to Power BI Pro at a cost of $10 a month with a 30-day trial period, enabling sharing reports and managing multiple dashboards.']}], 'duration': 1892.657, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY4490633.jpg', 'highlights': ['The dataset is from a US organization and covers the years 2011 to 2016.', 'The main goal is to achieve four insights: overall performance, regional performance, state performance, segment performance, and revenue generated by each category of product.', 'Identifying profitable and non-profitable regions as well as the opportunity for growth in different states is a key part of the analysis.', 'The chapter covers importing an Excel dataset into Power BI, analyzing and visualizing the data to identify profitable states and regions, using filters and color representations to gain insights, and modifying the data operations in the query editor.', 'The visualization of profits across different states can be enhanced by changing color representations using the format tab, specifically using data colors and divergence to represent the value of profits with different color intensities.', 'The visualization combines data from different quarters, summing up sales and profit for the years 2011 to 2015, resulting in a clearer understanding of the overall performance.', 'The creation of a scatter chart in Power BI allows for the visual representation of state-wise sales and profit data, highlighting the varying profitability of different states within the United States.', 'The chapter discusses creating a Power BI dashboard and filtering data by country, emphasizing the importance of considering the whole profit of the United States rather than individual states.', "It highlights the unique feature of Power BI Q&A, demonstrating how to use it to analyze data by asking questions such as 'which state has the highest sales' and 'which state has the highest profit', providing insights with corresponding values and descending order.", 'The chapter emphasizes the importance of selecting the appropriate visual representation for different types of data, highlighting the effectiveness of pie charts for certain data and the limitations of bar or line charts for clear-cut visualization.', 'The presenter demonstrates the sorting feature in Power BI, showcasing the ability to sort data by sales or profit and adjust the order from descending to ascending.', 'The chapter provides detailed insights into sales and profit figures for different quarters, including specific numbers such as sales reaching 4.3 million and profit of $500,000 in quarter four.', 'The presenter explains the process of creating visuals in Power BI, emphasizing the ability to choose from multiple visual types and customize as per requirement.', 'The visualization of profits across different states can be enhanced by changing color representations using the format tab, specifically using data colors and divergence to represent the value of profits with different color intensities.', 'The process of creating sample visuals involves combining different states and their respective profits to create a geographical representation of the profits across different countries, allowing for filtering of data by country and identifying positive and negative states based on profits.']}, {'end': 7111.603, 'segs': [{'end': 6438.749, 'src': 'embed', 'start': 6403.602, 'weight': 5, 'content': [{'end': 6407.784, 'text': 'and Power BI will create a data visual and give you a complete insight.', 'start': 6403.602, 'duration': 4.182}, {'end': 6419.169, 'text': 'Today we are going to discuss two of the most talked about tools in the business intelligence and data visualization Market.', 'start': 6413.502, 'duration': 5.667}, {'end': 6422.013, 'text': "Yes, I'm referring to power bi and tableau.", 'start': 6419.63, 'duration': 2.383}, {'end': 6427.419, 'text': "But before we get into the details of these two tools, let's quickly take a look at today's agenda.", 'start': 6422.553, 'duration': 4.866}, {'end': 6429.222, 'text': 'Like we always do in all of my sessions.', 'start': 6427.46, 'duration': 1.762}, {'end': 6438.749, 'text': 'Well, I would be discussing these two tools based on these parameters, that is, visualization, cost of ownership, integration, data management and,', 'start': 6430.106, 'duration': 8.643}], 'summary': 'Comparing power bi and tableau on visualization, cost, integration, and data management', 'duration': 35.147, 'max_score': 6403.602, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY6403602.jpg'}, {'end': 6541.027, 'src': 'embed', 'start': 6481.287, 'weight': 0, 'content': [{'end': 6486.011, 'text': "If you're somebody who likes the curated approach or more clean sleek kind of an approach.", 'start': 6481.287, 'duration': 4.724}, {'end': 6488.633, 'text': 'You can always go for tableau.', 'start': 6486.471, 'duration': 2.162}, {'end': 6492.656, 'text': 'Why is that because it would give you create drill-down features.', 'start': 6489.033, 'duration': 3.623}, {'end': 6494.918, 'text': 'It would give you amazing visualizations.', 'start': 6493.057, 'duration': 1.861}, {'end': 6497.58, 'text': 'So as far as visualization is concerned.', 'start': 6495.418, 'duration': 2.162}, {'end': 6501.063, 'text': 'Yes, if you ask me for my opinion, I would say tableau is a clear winner.', 'start': 6497.92, 'duration': 3.143}, {'end': 6502.892, 'text': 'Next we have cost.', 'start': 6501.832, 'duration': 1.06}, {'end': 6506.814, 'text': 'So when you take a look at cost, we have to consider something called as initial cost.', 'start': 6503.413, 'duration': 3.401}, {'end': 6511.576, 'text': 'Now, if you ask about initial costs, power bi wins why?', 'start': 6507.274, 'duration': 4.302}, {'end': 6516.198, 'text': 'because it is very cheaper compared to tableau if you compare its desktop user cost.', 'start': 6511.576, 'duration': 4.622}, {'end': 6520.38, 'text': 'if you compare its web user cost server node power bi is a winner here.', 'start': 6516.198, 'duration': 4.182}, {'end': 6525.581, 'text': 'But then this is not the only cost you should take into consideration when you talk about business intelligence.', 'start': 6520.84, 'duration': 4.741}, {'end': 6530.363, 'text': 'you have to consider other costs, costs that can be considered on the longer run.', 'start': 6525.581, 'duration': 4.782}, {'end': 6535.244, 'text': 'So are there any other parameters which we can consider for the longer and cost? Yes, definitely.', 'start': 6530.683, 'duration': 4.561}, {'end': 6541.027, 'text': 'And if you compare those parameters labor costs total cost of delivery and all those things.', 'start': 6535.724, 'duration': 5.303}], 'summary': 'Tableau excels in visualization, while power bi wins on initial cost and other long-term parameters for business intelligence.', 'duration': 59.74, 'max_score': 6481.287, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY6481287.jpg'}, {'end': 6792.919, 'src': 'embed', 'start': 6763.553, 'weight': 1, 'content': [{'end': 6766.176, 'text': 'Well as far as my personal experience is concerned.', 'start': 6763.553, 'duration': 2.623}, {'end': 6770.4, 'text': 'Tableau is little difficult to learn when you compare it with power bi.', 'start': 6766.716, 'duration': 3.684}, {'end': 6776.365, 'text': 'power bi is much easier to learn and it is for the wider applications, given the integration capabilities it has.', 'start': 6770.4, 'duration': 5.965}, {'end': 6777.706, 'text': 'but that is a personal opinion.', 'start': 6776.365, 'duration': 1.341}, {'end': 6782.931, 'text': "I don't want you to jump into that, because people who have used more tableau might find tableau easier to use.", 'start': 6777.746, 'duration': 5.185}, {'end': 6785.953, 'text': 'so that kind of boils down to your preference.', 'start': 6782.931, 'duration': 3.022}, {'end': 6789.637, 'text': 'really, if you ask me, I like power bi more when you talk about ease of use.', 'start': 6785.953, 'duration': 3.684}, {'end': 6792.919, 'text': 'I have had varying opinions for people as well.', 'start': 6790.337, 'duration': 2.582}], 'summary': 'Power bi is easier to learn and has wider applications compared to tableau, with varying opinions from users.', 'duration': 29.366, 'max_score': 6763.553, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY6763553.jpg'}, {'end': 6859.734, 'src': 'embed', 'start': 6826.532, 'weight': 6, 'content': [{'end': 6828.073, 'text': 'So these are the parameters.', 'start': 6826.532, 'duration': 1.541}, {'end': 6834.916, 'text': "I felt that we should have discussed the quite a few other parameters where these two tools can be compared and, as I've already mentioned,", 'start': 6828.153, 'duration': 6.763}, {'end': 6838.499, 'text': 'that these two tools are very neck and neck, or very close to each other.', 'start': 6834.916, 'duration': 3.583}, {'end': 6843.782, 'text': 'These are two of the most talked about tools, or the hottest tools when you talk about business intelligence,', 'start': 6838.559, 'duration': 5.223}, {'end': 6846.765, 'text': 'and it would be unfair to say this is a clear winner or that is a clear winner.', 'start': 6843.782, 'duration': 2.983}, {'end': 6848.666, 'text': 'It actually boils down to your preference.', 'start': 6846.945, 'duration': 1.721}, {'end': 6852.249, 'text': 'The best way for you to decide is to go ahead and use both of these two tools.', 'start': 6849.126, 'duration': 3.123}, {'end': 6854.931, 'text': 'Those are readily available to you and very easy to learn,', 'start': 6852.649, 'duration': 2.282}, {'end': 6859.734, 'text': 'so you can pick those and decide it on your own which tool is good for you or great for you,', 'start': 6854.931, 'duration': 4.803}], 'summary': "Comparison of two business intelligence tools. no clear winner, user's preference is key.", 'duration': 33.202, 'max_score': 6826.532, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY6826532.jpg'}], 'start': 6383.35, 'title': 'A comparison of power bi and tableau', 'summary': 'Provides a comprehensive comparison of power bi and tableau, evaluating parameters such as visualization, cost, integration, data management, ease of use, support, scalability, and infrastructure. it highlights strengths, weaknesses, and practical insights to aid decision-making, preparing the audience for power bi interview questions.', 'chapters': [{'end': 6541.027, 'start': 6383.35, 'title': 'Power bi vs tableau: a comparison', 'summary': 'Discusses a comparison between power bi and tableau based on parameters like visualization, cost, and other longer-term considerations, highlighting features like custom visuals, cost efficiency, and labor costs.', 'duration': 157.677, 'highlights': ['When comparing visualization, Power BI offers custom visuals and drag-and-drop features, making it a clear winner in this aspect for those who prefer a more customizable approach, while Tableau excels in providing curated and sleek visualizations, making it the preferred choice for those who like a clean, curated approach.', 'In terms of initial cost, Power BI is significantly cheaper compared to Tableau for desktop user cost and web user cost server node, making it more cost-effective in the short term.', 'Other longer-term cost parameters such as labor costs and total cost of delivery should also be considered when evaluating the cost effectiveness of Power BI and Tableau.']}, {'end': 6859.734, 'start': 6541.688, 'title': 'Tableau vs power bi: a comparison', 'summary': "Compares tableau and power bi in terms of affordability, integration capabilities, data management, functional parameters, ease of use, support, scalability, and infrastructure, highlighting the strengths and weaknesses of each, ultimately leaving the decision to the user's preference.", 'duration': 318.046, 'highlights': ['Tableau offers more affordable software in the longer term, making it a winner in terms of total cost of ownership.', 'Power BI excels in integration capabilities, readily integrating with various other Microsoft products, giving it an edge over Tableau in this aspect.', 'Power BI outperforms Tableau in data management, excelling in data shaping, data modeling, and analytics, making it the preferred choice for overall data management.', 'Tableau has an edge in experience due to its earlier establishment, while Power BI is catching up in terms of organizational approach for data visualization tools.', 'Power BI is considered easier to learn and more widely applicable, while Tableau is seen as more difficult to learn but offers a more curated and clean approach, leaving the choice to user preference.']}, {'end': 7111.603, 'start': 6859.734, 'title': 'Power bi interview insights', 'summary': 'Covers the comparison of power bi with other bi tools, the concept of self-service bi, and its benefits, focusing on practical examples and real-life scenarios, aiming to prepare the audience for commonly asked interview questions in power bi.', 'duration': 251.869, 'highlights': ['Power BI is one of the most popular self-service business intelligence (SSBI) tools, contrasting it with traditional BI tools like Tableau, Qlik Sense, and Spotfire.', 'The concept of self-service BI is explained as an approach that enables business users to filter, segment, and analyze data, allowing non-technical users to directly connect to data and build visualizations, leading to faster development cycles and increased control for the end users.', 'The benefits of self-service BI are outlined, emphasizing the faster development cycle, increased control for end users, and the positive impact on both end users and the IT team.']}], 'duration': 728.253, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY6383350.jpg', 'highlights': ['Power BI offers custom visuals and drag-and-drop features, making it a clear winner in visualization.', 'Power BI is significantly cheaper compared to Tableau for desktop user cost and web user cost server node.', 'Power BI excels in integration capabilities, readily integrating with various other Microsoft products.', 'Power BI outperforms Tableau in data management, excelling in data shaping, data modeling, and analytics.', 'Power BI is one of the most popular self-service business intelligence (SSBI) tools, enabling faster development cycles and increased control for end users.', 'Tableau excels in providing curated and sleek visualizations, making it the preferred choice for those who like a clean, curated approach.', 'Tableau offers more affordable software in the longer term, making it a winner in total cost of ownership.', 'Tableau has an edge in experience due to its earlier establishment, while Power BI is catching up in terms of organizational approach for data visualization tools.']}, {'end': 8601.162, 'segs': [{'end': 7380.28, 'src': 'embed', 'start': 7355.328, 'weight': 0, 'content': [{'end': 7361.611, 'text': "okay. so again, coming to the question, it's very important that you mention about excel bi, because most people will actually go back and say okay,", 'start': 7355.328, 'duration': 6.283}, {'end': 7366.713, 'text': 'microsoft, self-service bi to solution will only be power bi, which is obviously this power bi interview.', 'start': 7361.611, 'duration': 5.102}, {'end': 7368.975, 'text': "so you'll actually say only power bi, but actually it's no.", 'start': 7366.713, 'duration': 2.262}, {'end': 7374.397, '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': 7368.975, 'duration': 5.422}, {'end': 7380.28, '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': 7374.397, 'duration': 5.883}], 'summary': 'Emphasize excel bi as a powerful self-service bi solution, not just power bi.', 'duration': 24.952, 'max_score': 7355.328, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY7355328.jpg'}, {'end': 8162.967, 'src': 'embed', 'start': 8138.094, 'weight': 2, 'content': [{'end': 8143.837, 'text': "data catalog is basically azure data catalog, so it's pretty helpful for connecting to different sources, management of different sources,", 'start': 8138.094, 'duration': 5.743}, {'end': 8147.959, 'text': 'your data and management gateway, which is used for connecting to on-premises data, another very,', 'start': 8143.837, 'duration': 4.122}, {'end': 8150.641, 'text': 'very essential component with something that you set up in the service level.', 'start': 8147.959, 'duration': 2.682}, {'end': 8155.804, 'text': 'so if you go to the power bi service, basically so whatever you see i have right now is what i call the power bi service.', 'start': 8150.641, 'duration': 5.163}, {'end': 8161.967, 'text': 'So remember, guys, I talked about this in the initial session, beginning of the session, where I said this is my client development tool.', 'start': 8156.364, 'duration': 5.603}, {'end': 8162.967, 'text': 'Okay, this is probably a desktop.', 'start': 8162.087, 'duration': 0.88}], 'summary': 'Azure data catalog facilitates connection to diverse sources and on-premises data management, integral for power bi service.', 'duration': 24.873, 'max_score': 8138.094, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY8138094.jpg'}, {'end': 8228.483, 'src': 'embed', 'start': 8198.646, 'weight': 4, 'content': [{'end': 8203.486, 'text': 'remember these two types of extensions pbix stands for the power bi file, that is the power bi analysis file, and pbit,', 'start': 8198.646, 'duration': 4.84}, {'end': 8205.087, 'text': 'which stands for the power bi template file.', 'start': 8203.486, 'duration': 1.601}, {'end': 8206.668, 'text': "okay, so i'll save it for the name demo.", 'start': 8205.087, 'duration': 1.581}, {'end': 8207.248, 'text': 'click on save.', 'start': 8206.668, 'duration': 0.58}, {'end': 8208.949, 'text': 'Remember to publishing.', 'start': 8207.888, 'duration': 1.061}, {'end': 8212.451, 'text': "it is very important that you're signed in, and once you're signed in, once everything else is set up,", 'start': 8208.949, 'duration': 3.502}, {'end': 8214.593, 'text': 'you can just go back and save it in your workspace.', 'start': 8212.451, 'duration': 2.142}, {'end': 8221.639, 'text': "And once you've done that, you can just go to the service and check that your stuff has been published.", 'start': 8216.556, 'duration': 5.083}, {'end': 8228.483, 'text': 'Okay, like something very similar will be visible on your service and you can look at the report section where you can see that has been published.', 'start': 8222.3, 'duration': 6.183}], 'summary': 'Power bi files include pbix (analysis) and pbit (template). publishing requires signing in and checking the service.', 'duration': 29.837, 'max_score': 8198.646, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY8198646.jpg'}], 'start': 7111.603, 'title': 'Power bi in microsoft stack', 'summary': 'Discusses the challenges of traditional bi, the significance of ssbi, and the parts of microsoft self-service bi solution, highlighting the dominance of tools like tableau and qlik sense, and the origin and repackaging of power bi components from excel. it also covers comparisons between excel bi and power bi components, power bi desktop etl operations, understanding power bi components, and power bi data sources, providing valuable insights into the landscape and operations of power bi within the microsoft stack.', 'chapters': [{'end': 7328.702, 'start': 7111.603, 'title': 'Self-service bi landscape and microsoft stack', 'summary': 'Discusses the challenges of traditional bi, the significance of ssbi, and the parts of microsoft self-service bi solution, highlighting the dominance of tools like tableau and qlik sense, and the origin and repackaging of power bi components from excel.', 'duration': 217.099, 'highlights': ['The BI landscape is dominated by tools like Tableau, Spotify, and Qlik Sense in the data visualization SSBI landscape, with revolutionary tools like Alteryx also playing a significant role.', 'Power BI components, including PowerPivot, PowerQuery, and PowerView, originated from Excel and were repackaged into Power BI Desktop, addressing the challenges faced with different versions and editions of Excel and add-in tools.', 'The significance of mentioning Excel BI alongside Power BI is highlighted, emphasizing the extension of Power BI from the Excel add-in components and the necessity to understand the origins of Power BI.', 'The chapter emphasizes the importance of providing a broad context on where SSBI comes from, its significance, and its position within the BI landscape, stressing the need to showcase depth and breadth of knowledge in the entire BI space.', 'The process of building intuitive and shareable dashboards in SSBI is described as a win-win situation, emphasizing that anyone with basic understanding of data can create reports, showcasing its ease of use and independence from business users.']}, {'end': 7847.152, 'start': 7328.742, 'title': 'Comparison of excel bi and power bi components', 'summary': "Compares excel bi and power bi components, emphasizing that the power bi desktop components are identical to excel bi components, and highlights the importance of mentioning excel bi's powerful self-service capabilities and the frequent updates in power bi desktop and service.", 'duration': 518.41, 'highlights': ['The Power BI desktop components are exactly the same as the Excel BI components, with only very minute differences, borrowing most of the features.', 'Excel also serves as a powerful self-service BI solution, allowing simple analysis and visualization even without using Power BI components like Power Query, Power View, or Power Pivot.', 'Power BI desktop is updated monthly, while the Power BI service receives updates weekly, showcasing the frequent updates in the Power BI ecosystem.', 'The Q&A feature, initially in the Power BI service, has been included as a preview feature in the Power BI desktop, allowing users to ask questions and visualize data directly within the desktop interface.', 'Power Query in Power BI desktop serves as the ETL component, enabling basic data cleansing and transformation before analysis, emphasizing the importance of data preparation.']}, {'end': 8077.707, 'start': 7847.532, 'title': 'Power bi desktop etl operations', 'summary': 'Covers performing basic etl operations in power bi desktop, such as removing columns, adding custom columns, and setting data types, with a brief comparison to performing similar tasks in excel. it emphasizes the steps involved in etl, data loading into the power pivot data model, and visualization using power view.', 'duration': 230.175, 'highlights': ['Performing basic ETL operations in Power BI Desktop', 'Data loading into Power Pivot data model', 'Comparison of tasks between Power BI Desktop and Excel']}, {'end': 8296.639, 'start': 8078.028, 'title': 'Understanding power bi components', 'summary': 'Emphasizes the interconnectedness of power bi with excel, stresses the importance of understanding its architecture, and demonstrates the process of publishing reports to the power bi service.', 'duration': 218.611, 'highlights': ['Power BI is interconnected with Excel, and it is crucial to understand their similarities and the interconnectedness of their components.', 'The process of publishing reports to the Power BI service involves creating reports in Power BI Desktop, saving them with the .pbix extension, signing in to the service, and then sharing the reports with specific users or the entire organization.', 'Demonstration of the development and cloud environments in Power BI, including the creation and sharing of dashboards within the service.']}, {'end': 8601.162, 'start': 8296.639, 'title': 'Power bi data sources', 'summary': 'Explores the wide range of data sources power bi can connect to, including web data, databases, and online services, with the ability to easily set up odbc connections and access pre-packaged dashboards.', 'duration': 304.523, 'highlights': ['Power BI can connect to a wide variety of sources from the desktop, including web data, databases, and online services, with the ability to set up ODBC connections easily.', 'The chapter demonstrates the ease of connecting to web data, such as the example of accessing data from the money control website, showcasing the ability to quickly and efficiently extract tabular data without scripting.', 'The discussion includes the option to connect to pre-packaged dashboards, also known as content packs or apps, showcasing the ability to easily consume and utilize pre-built dashboards and reports.']}], 'duration': 1489.559, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY7111603.jpg', 'highlights': ['The BI landscape is dominated by tools like Tableau, Spotify, and Qlik Sense in the data visualization SSBI landscape, with revolutionary tools like Alteryx also playing a significant role.', 'Power BI desktop is updated monthly, while the Power BI service receives updates weekly, showcasing the frequent updates in the Power BI ecosystem.', 'Power BI can connect to a wide variety of sources from the desktop, including web data, databases, and online services, with the ability to set up ODBC connections easily.', 'The process of publishing reports to the Power BI service involves creating reports in Power BI Desktop, saving them with the .pbix extension, signing in to the service, and then sharing the reports with specific users or the entire organization.', 'The Q&A feature, initially in the Power BI service, has been included as a preview feature in the Power BI desktop, allowing users to ask questions and visualize data directly within the desktop interface.']}, {'end': 9329.441, 'segs': [{'end': 9217.69, 'src': 'embed', 'start': 9189.614, 'weight': 3, 'content': [{'end': 9194.816, 'text': 'so you can not only configure stuff in in one page, but you can actually configure stuff in another page.', 'start': 9189.614, 'duration': 5.202}, {'end': 9199.839, 'text': 'another very common scenario, another very common use case for this could be that there could be initial introduction page.', 'start': 9194.816, 'duration': 5.023}, {'end': 9204.701, 'text': "right, the initial introduction page could be like you know, you're showing the categories right, you're showing all category related information,", 'start': 9199.839, 'duration': 4.862}, {'end': 9211.367, 'text': "social technology, and you're basically showing all that, all the categories right, the categories of furniture, office supplies, technology.", 'start': 9205.345, 'duration': 6.022}, {'end': 9213.208, 'text': "so everything about the categories you're showing,", 'start': 9211.367, 'duration': 1.841}, {'end': 9217.69, 'text': 'and then your page two and the page two will actually consist of everything about the subcategories.', 'start': 9213.208, 'duration': 4.482}], 'summary': 'Configuring on multiple pages, e.g., intro page with categories and page 2 with subcategories.', 'duration': 28.076, 'max_score': 9189.614, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY9189614.jpg'}, {'end': 9278.352, 'src': 'embed', 'start': 9248.162, 'weight': 0, 'content': [{'end': 9251.223, 'text': 'i can build a pie chart here and you could build any kind of visual.', 'start': 9248.162, 'duration': 3.061}, {'end': 9253.824, 'text': 'but remember, the concept is that whatever subcategories you see.', 'start': 9251.223, 'duration': 2.601}, {'end': 9264.026, 'text': "so i'll call this a subcategory page and that is basically my initial category page and I can further build one more page called the product page.", 'start': 9253.824, 'duration': 10.202}, {'end': 9266.247, 'text': "and the product page is where I'll probably have some detailed information.", 'start': 9264.026, 'duration': 2.221}, {'end': 9270.048, 'text': "or probably I can build a bar chart here also where I'll get my product IDs.", 'start': 9266.247, 'duration': 3.801}, {'end': 9278.352, 'text': 'I mean by product names in the values axis, the sales probably go back and sort this data, sort by sales.', 'start': 9270.048, 'duration': 8.304}], 'summary': 'Ability to create visualizations, subcategories, and detailed product pages, including bar and pie charts.', 'duration': 30.19, 'max_score': 9248.162, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY9248162.jpg'}], 'start': 8601.222, 'title': 'Power bi features and connections', 'summary': "Covers the availability of content packs, diverse data connection options, power bi's building blocks, including its architecture, data sets, visualizations, dashboards, tiles, and various types of filters, providing a comprehensive understanding of power bi's capabilities and connections.", 'chapters': [{'end': 8645.827, 'start': 8601.222, 'title': 'Data connection and content packs', 'summary': 'Discusses the availability of content packs and the diverse data connection options in the service, including connections to files, databases, and organizational content packs.', 'duration': 44.605, 'highlights': ['The service provides a robust set of options to connect to data, including files from onedrive, local files, Azure databases, and various online services like bing and salesforce.', 'Users can connect to organizational content packs developed within their organization, expanding the range of available data sources.', "Content packs are available from both online services and specific to the user's organization, such as bing and salesforce for online services, and organizational-specific packs for the user's organization."]}, {'end': 9329.441, 'start': 8646.57, 'title': 'Power bi building blocks', 'summary': "Provides a holistic view of power bi's building blocks, including its architecture, data sets, visualizations, dashboards, and tiles, along with a detailed explanation of the different types of filters in power bi, such as visual level filters, page level filters, report level filters, and drill through filters and their respective scenarios.", 'duration': 682.871, 'highlights': ["The chapter provides a holistic view of Power BI's building blocks, including its architecture, data sets, visualizations, dashboards, and tiles.", 'Detailed explanation of the different types of filters in Power BI, such as visual level filters, page level filters, report level filters, and drill through filters and their respective scenarios.']}], 'duration': 728.219, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY8601222.jpg', 'highlights': ['The service offers diverse data connection options, including onedrive, local files, Azure databases, and online services like bing and salesforce.', 'Users can connect to organizational content packs, expanding the range of available data sources.', "Detailed explanation of Power BI's building blocks, covering architecture, data sets, visualizations, dashboards, and tiles.", 'Comprehensive understanding of different types of filters in Power BI, including visual level, page level, report level, and drill through filters.']}, {'end': 10956.388, 'segs': [{'end': 9723.499, 'src': 'embed', 'start': 9664.49, 'weight': 0, 'content': [{'end': 9666.031, 'text': 'uh, star rating, really cool thing.', 'start': 9664.49, 'duration': 1.541}, {'end': 9666.991, 'text': 'you know, star rating.', 'start': 9666.031, 'duration': 0.96}, {'end': 9668.192, 'text': "it's an amazing feature.", 'start': 9666.991, 'duration': 1.201}, {'end': 9670.453, 'text': 'so you can actually give a star rating highest value.', 'start': 9668.192, 'duration': 2.261}, {'end': 9673.235, 'text': "let's say my highest value is going to be something like 250 000.", 'start': 9670.453, 'duration': 2.782}, {'end': 9676.758, 'text': "i'll probably say okay, that's my highest value, it's my lowest value.", 'start': 9673.235, 'duration': 3.523}, {'end': 9681.562, 'text': 'i can give the number of stars and i can enter a new quick measure called star rating.', 'start': 9676.758, 'duration': 4.804}, {'end': 9684.004, 'text': "okay, and now you can see behind the scenes i've actually got dax.", 'start': 9681.562, 'duration': 2.442}, {'end': 9688.067, 'text': "so whatever you're seeing here right now is actually a pretty complicated version of dax.", 'start': 9684.004, 'duration': 4.063}, {'end': 9693.952, 'text': 'okay. so whenever you create quick measures, any of these default point and click options behind the scenes, power bi is actually building that dax for you.', 'start': 9688.067, 'duration': 5.885}, {'end': 9699.217, 'text': "okay, this is actually pretty complicated bit of dax that's written and the final output is actually pretty neat.", 'start': 9694.332, 'duration': 4.885}, {'end': 9701.459, 'text': "okay, you can see that that's my, that's my star rating column.", 'start': 9699.217, 'duration': 2.242}, {'end': 9702.44, 'text': "i've created.", 'start': 9701.459, 'duration': 0.981}, {'end': 9704.562, 'text': 'um, and you can see that as a top value.', 'start': 9702.44, 'duration': 2.122}, {'end': 9705.363, 'text': 'five stars here.', 'start': 9704.562, 'duration': 0.801}, {'end': 9707.685, 'text': 'uh, four stars here, one star here.', 'start': 9705.363, 'duration': 2.322}, {'end': 9709.627, 'text': "it's pretty relative depending on the type of data.", 'start': 9707.685, 'duration': 1.942}, {'end': 9713.17, 'text': 'and and the best part is that it is actually going to be dynamic.', 'start': 9709.627, 'duration': 3.543}, {'end': 9714.552, 'text': 'and what do i mean by dynamic?', 'start': 9713.17, 'duration': 1.382}, {'end': 9718.836, 'text': 'what i mean by dynamic is that this value will change depending on the underlying data.', 'start': 9714.552, 'duration': 4.284}, {'end': 9723.499, 'text': 'so essentially, if you take subcategory and if you further try to break it by region, that data will actually change.', 'start': 9718.836, 'duration': 4.663}], 'summary': 'Creating a dynamic star rating feature, with highest value set at 250,000, using a complicated dax formula in power bi.', 'duration': 59.009, 'max_score': 9664.49, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY9664490.jpg'}, {'end': 10381.556, 'src': 'embed', 'start': 10351.459, 'weight': 1, 'content': [{'end': 10355.42, 'text': 'so when i go back and remove that segment, those measures are actually getting recalculated on the fly.', 'start': 10351.459, 'duration': 3.961}, {'end': 10357.887, 'text': "So I'm actually recalculating them on the fly.", 'start': 10356.266, 'duration': 1.621}, {'end': 10363.089, 'text': "If I just go back and take something else, let's say instead of region, if I just go back and take a category, it's actually getting recalculated.", 'start': 10357.927, 'duration': 5.162}, {'end': 10366.23, 'text': 'Okay, so that is an important thing about measures that you should keep in mind.', 'start': 10363.429, 'duration': 2.801}, {'end': 10373.153, 'text': 'Okay, and that is the other reason why, when you build a measure, you can just see that in measures, because they are not calculated on the fly,', 'start': 10366.65, 'duration': 6.503}, {'end': 10374.574, 'text': "because they're actually not stored in my model.", 'start': 10373.153, 'duration': 1.421}, {'end': 10376.594, 'text': 'You have to define the aggregations here.', 'start': 10374.954, 'duration': 1.64}, {'end': 10381.556, 'text': 'Okay, they are calculated dynamically based on whatever filters you apply, whatever stuff you do.', 'start': 10376.934, 'duration': 4.622}], 'summary': 'Measures are recalculated on the fly based on filters and dynamic data, not stored in the model.', 'duration': 30.097, 'max_score': 10351.459, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY10351459.jpg'}, {'end': 10591.296, 'src': 'embed', 'start': 10563.425, 'weight': 12, 'content': [{'end': 10570.207, 'text': "quickly, data model, obviously, is the model that you, that you're building after, after you're performing the query, editing and all that stuff.", 'start': 10563.425, 'duration': 6.782}, {'end': 10573.128, 'text': "the place where you're loading all your stuff into is what we call data model,", 'start': 10570.207, 'duration': 2.921}, {'end': 10579.39, 'text': 'and data model consists of tables and obviously tables are consisting of columns and rows and essentially you have relationships.', 'start': 10573.128, 'duration': 6.262}, {'end': 10584.331, 'text': 'Okay, these are the key aspects of a data model and just to briefly explain this whole piece to you,', 'start': 10579.65, 'duration': 4.681}, {'end': 10591.296, 'text': "and what I'll do here is I will be connecting to my excel once again and I'll just be bringing in one more table.", 'start': 10584.331, 'duration': 6.965}], 'summary': 'Data model consists of tables, columns, rows, and relationships. will connect to excel to bring in one more table.', 'duration': 27.871, 'max_score': 10563.425, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY10563425.jpg'}, {'end': 10718.315, 'src': 'embed', 'start': 10692.836, 'weight': 2, 'content': [{'end': 10699.084, 'text': "that's something you can turn on and off, okay, and you can also exceed, but returns, it was not able to relate that, so I can manually do it.", 'start': 10692.836, 'duration': 6.248}, {'end': 10699.905, 'text': 'order id, just.', 'start': 10699.084, 'duration': 0.821}, {'end': 10701.345, 'text': "it's as simple as a drag and drop.", 'start': 10699.905, 'duration': 1.44}, {'end': 10703.367, 'text': 'and now we have related orders and returns as well.', 'start': 10701.345, 'duration': 2.022}, {'end': 10705.828, 'text': "it's very, very important to build relationships, guys,", 'start': 10703.367, 'duration': 2.461}, {'end': 10713.592, 'text': "and you know it's always a consideration that you have to always have to decide whether you want to keep everything in one table or you want to go back and keep things in separate tables.", 'start': 10705.828, 'duration': 7.764}, {'end': 10716.434, 'text': "it's always a very, very key question that you might get.", 'start': 10713.592, 'duration': 2.842}, {'end': 10718.315, 'text': 'so at what level do you decide?', 'start': 10716.434, 'duration': 1.881}], 'summary': 'Ability to turn on/off related orders, drag and drop simplicity, importance of building relationships, consideration of table organization.', 'duration': 25.479, 'max_score': 10692.836, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY10692836.jpg'}, {'end': 10918.837, 'src': 'embed', 'start': 10893.846, 'weight': 8, 'content': [{'end': 10899.288, 'text': 'because, as i said, everything about power pivot and the in-memory engine of power pivot is based on columnar database.', 'start': 10893.846, 'duration': 5.442}, {'end': 10905.75, 'text': 'so to 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': 10899.288, 'duration': 6.462}, {'end': 10906.951, 'text': "nothing like it, but it's not required.", 'start': 10905.75, 'duration': 1.201}, {'end': 10909.792, 'text': "and that's getting towards the advanced aspects, but that's not required.", 'start': 10906.951, 'duration': 2.841}, {'end': 10913.074, 'text': "but it's an optional thing that you can take a call on relationships.", 'start': 10909.792, 'duration': 3.282}, {'end': 10915.055, 'text': "obviously there's an option that you can set.", 'start': 10913.074, 'duration': 1.981}, {'end': 10918.837, 'text': 'you can either have one active relationship, you can have multiple active relationships.', 'start': 10915.055, 'duration': 3.782}], 'summary': 'Power pivot relies on columnar database for fast data access and supports multiple active relationships.', 'duration': 24.991, 'max_score': 10893.846, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY10893846.jpg'}], 'start': 9329.881, 'title': 'Power bi dax and filters', 'summary': 'Covers the significance of dax queries, calculate function, and usage of filters in power bi. it emphasizes the importance of dax knowledge in job interviews, dynamic measures, and the role of x velocity in-memory analytics engine in driving power pivot.', 'chapters': [{'end': 9516.209, 'start': 9329.881, 'title': 'Power bi filters and dax queries', 'summary': 'Covers the main types of filters and the significance of dax queries in power bi, emphasizing the importance of dax knowledge in job interviews and the need to understand both dax and m query language for debugging purposes.', 'duration': 186.328, 'highlights': ['The importance of DAX knowledge in job interviews', 'Significance of DAX queries in Power BI', 'Types of filters in Power BI desktop Content packs and apps', 'Understanding both DAX and M query language for debugging purposes']}, {'end': 9999.943, 'start': 9516.209, 'title': 'Understanding calculate function in power bi', 'summary': 'Introduces the importance of the calculate function in power bi, highlighting its use cases, such as calculating percentages and implementing dynamic measures. it emphasizes the significance of dax in creating calculated columns and measures, and the dynamic nature of measures, while explaining the usage of calculate function in detail.', 'duration': 483.734, 'highlights': ['The calculate function in Power BI is crucial and frequently used, as it operates within the filter context and is essential for tasks such as calculating percentages.', 'The process of using calculate function to calculate percentages is exemplified, showcasing its significance and practical application in analyzing data.', 'The dynamic nature of measures in Power BI is emphasized, underlining their ability to adjust and recalculate based on changes in visuals and filters.', 'The significance of DAX in creating calculated columns and measures is stressed, emphasizing its role in implementing complex calculations and dynamic functionalities.']}, {'end': 10411.362, 'start': 9999.943, 'title': 'Using calculate in power bi', 'summary': 'Discusses the usage of calculate function in power bi, highlighting the creation of calculated columns and measures, and the conceptual difference between them, emphasizing the need to use measures for accurate results and their dynamic nature in responding to filters.', 'duration': 411.419, 'highlights': ['The conceptual difference between calculated columns and measures in Power BI is highlighted, with measures being dynamically calculated ad hoc and responsive to filters, ensuring accurate results.', 'The importance of using measures over calculated columns for accurate results is emphasized, as measures are not stored in the model and are recalculated dynamically on the fly based on applied filters.', 'The process of creating a calculated column and a measure for profit percentage in Power BI is described, emphasizing the need for measures to obtain accurate results and the difference in their icons.']}, {'end': 10956.388, 'start': 10411.362, 'title': 'Dax measures and power pivot in power bi', 'summary': "Discusses the dynamic nature and usefulness of dax measures for calculating percentages or divisions, the advantages of using measures over calculated columns, the importance of building relationships in power bi's data model, and the role of the x velocity in-memory analytics engine in driving power pivot.", 'duration': 545.026, 'highlights': ['DAX measures are dynamic and useful for calculating percentages or divisions, offering advantages over calculated columns in terms of storage and performance.', 'Building relationships in the data model is crucial for enabling visualization of data across multiple tables in Power BI.', 'The x velocity in-memory analytics engine, underlying Power Pivot, utilizes a columnar database for efficient data storage and fast data access.']}], 'duration': 1626.507, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY9329881.jpg', 'highlights': ['The x velocity in-memory analytics engine in Power Pivot utilizes a columnar database for efficient data storage and fast data access', 'The importance of DAX knowledge in job interviews', 'The calculate function in Power BI is crucial and frequently used, operating within the filter context and essential for tasks such as calculating percentages', 'The dynamic nature of measures in Power BI, adjusting and recalculating based on changes in visuals and filters', 'The conceptual difference between calculated columns and measures in Power BI, with measures being dynamically calculated ad hoc and responsive to filters, ensuring accurate results', 'Building relationships in the data model is crucial for enabling visualization of data across multiple tables in Power BI', 'The process of using calculate function to calculate percentages is exemplified, showcasing its significance and practical application in analyzing data', 'The significance of DAX in creating calculated columns and measures, emphasizing its role in implementing complex calculations and dynamic functionalities', 'The importance of using measures over calculated columns for accurate results is emphasized, as measures are not stored in the model and are recalculated dynamically on the fly based on applied filters', 'DAX measures are dynamic and useful for calculating percentages or divisions, offering advantages over calculated columns in terms of storage and performance', 'The process of creating a calculated column and a measure for profit percentage in Power BI is described, emphasizing the need for measures to obtain accurate results and the difference in their icons', 'The significance of DAX queries in Power BI', 'Types of filters in Power BI desktop Content packs and apps', 'Understanding both DAX and M query language for debugging purposes']}, {'end': 11509.089, 'segs': [{'end': 10990.395, 'src': 'embed', 'start': 10958.91, 'weight': 2, 'content': [{'end': 10961.392, 'text': 'Power Query, I think I spent a lot of time on this already.', 'start': 10958.91, 'duration': 2.482}, {'end': 10968.879, 'text': 'So, needless to say, when you talk about Power Query, you mentioned a couple of key terms ETL tool, shaping, cleansing, transforming data very,', 'start': 10961.573, 'duration': 7.306}, {'end': 10969.639, 'text': 'very important pieces.', 'start': 10968.879, 'duration': 0.76}, {'end': 10975.705, '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': 10969.659, 'duration': 6.046}, {'end': 10976.505, 'text': 'the underlying layer.', 'start': 10975.705, 'duration': 0.8}, {'end': 10977.386, 'text': "you're writing M code.", 'start': 10976.505, 'duration': 0.881}, {'end': 10980.908, 'text': 'Query folding is actually another very, very important feature in Power BI.', 'start': 10978.247, 'duration': 2.661}, {'end': 10984.791, 'text': "And obviously, it's more of a performance enhancement question that can get asked.", 'start': 10981.108, 'duration': 3.683}, {'end': 10990.395, 'text': 'Very, very important question, actually, that sometimes tends to get us here from a performance optimization standpoint.', 'start': 10984.871, 'duration': 5.524}], 'summary': 'Power query: key terms etl, shaping, cleansing, transforming data. m query, query folding for performance optimization.', 'duration': 31.485, 'max_score': 10958.91, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY10958910.jpg'}, {'end': 11072.061, 'src': 'embed', 'start': 11039.872, 'weight': 0, 'content': [{'end': 11041.993, 'text': 'Obviously, these are things that are going to work as expected.', 'start': 11039.872, 'duration': 2.121}, {'end': 11044.994, 'text': 'Just like as we understand, steps are going to be created.', 'start': 11043.113, 'duration': 1.881}, {'end': 11047.394, 'text': 'I can go back and remove all this stuff from here.', 'start': 11045.694, 'duration': 1.7}, {'end': 11048.455, 'text': "I don't need this.", 'start': 11047.414, 'duration': 1.041}, {'end': 11050.295, 'text': 'So I kept only three columns.', 'start': 11049.055, 'duration': 1.24}, {'end': 11053.513, 'text': 'and what i can do here is further thing.', 'start': 11051.212, 'duration': 2.301}, {'end': 11055.154, 'text': 'i can actually add columns, whatever.', 'start': 11053.513, 'duration': 1.641}, {'end': 11060.916, 'text': "the idea here is to show you something called view native query, and what happens here is that i've actually got data into power bi desktop.", 'start': 11055.154, 'duration': 5.762}, {'end': 11066.218, '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': 11060.916, 'duration': 5.302}, {'end': 11067.459, 'text': 'i performed this within power bi desktop.', 'start': 11066.218, 'duration': 1.241}, {'end': 11072.061, 'text': 'Okay so, whatever transformation I did, I did it with the Power BI desktop, but using query folding.', 'start': 11067.779, 'duration': 4.282}], 'summary': 'Data transformation done in power bi desktop using query folding.', 'duration': 32.189, 'max_score': 11039.872, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11039872.jpg'}, {'end': 11162.514, 'src': 'embed', 'start': 11134.053, 'weight': 1, 'content': [{'end': 11139.614, 'text': 'So actually named all my columns here and, as we understand in as part of the sequel language, when you rename a column here,', 'start': 11134.053, 'duration': 5.561}, {'end': 11141.475, 'text': "all you're doing is actually applying an alias.", 'start': 11139.614, 'duration': 1.861}, {'end': 11144.935, 'text': "and again, as you can see, although this step I'm performing within power bi desktop,", 'start': 11141.475, 'duration': 3.46}, {'end': 11150.316, 'text': 'you know power bi desktop will just go back and offload that operation or transfer that operation back to the source.', 'start': 11144.935, 'duration': 5.381}, {'end': 11151.116, 'text': 'is the sequel server.', 'start': 11150.316, 'duration': 0.8}, {'end': 11153.417, 'text': 'If you go to view native query, you can actually check that.', 'start': 11151.136, 'duration': 2.281}, {'end': 11157.264, 'text': "okay, again, it's a very, very important piece that you should keep in mind.", 'start': 11153.877, 'duration': 3.387}, {'end': 11162.514, 'text': "if you try to do a split here, let's say i'll try to do a split here, split by delimiter, okay.", 'start': 11157.264, 'duration': 5.25}], 'summary': 'In power bi desktop, renaming columns applies an alias; operations are offloaded to the source sql server.', 'duration': 28.461, 'max_score': 11134.053, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11134053.jpg'}, {'end': 11387.665, 'src': 'heatmap', 'start': 11254.826, 'weight': 1, 'content': [{'end': 11256.387, 'text': 'can sql and power query be used together?', 'start': 11254.826, 'duration': 1.561}, {'end': 11258.249, 'text': 'i think i just answered this question in this example here.', 'start': 11256.387, 'duration': 1.862}, {'end': 11261.451, 'text': "answer is absolutely yes, you can, and the best part is, you don't have to, you know.", 'start': 11258.249, 'duration': 3.202}, {'end': 11265.554, 'text': 'obviously you can do it in the graphical user interface or you can directly go and type out your query.', 'start': 11261.451, 'duration': 4.103}, {'end': 11268.315, 'text': 'you can straight away type out your sql query here.', 'start': 11265.554, 'duration': 2.761}, {'end': 11270.357, 'text': 'more customized sql query across multiple tables.', 'start': 11268.315, 'duration': 2.042}, {'end': 11272.179, 'text': 'What are query parameters?', 'start': 11271.198, 'duration': 0.981}, {'end': 11276.863, 'text': 'Query parameters are again a very, very important topic in Power BI and query parameters.', 'start': 11272.459, 'duration': 4.404}, {'end': 11281.627, 'text': 'The whole idea is that they are very similar to filters, but they are more dynamic sort of filters.', 'start': 11276.883, 'duration': 4.744}, {'end': 11284.089, 'text': 'And the way you set them is using the parameters wizard here.', 'start': 11281.827, 'duration': 2.262}, {'end': 11287.212, 'text': 'I will go back to my orders query right now.', 'start': 11284.509, 'duration': 2.703}, {'end': 11289.574, 'text': 'Go to manage parameters and set up a new parameter called region.', 'start': 11287.232, 'duration': 2.342}, {'end': 11292.516, 'text': 'so i can actually define a parameter like this.', 'start': 11290.154, 'duration': 2.362}, {'end': 11292.957, 'text': "it's a region.", 'start': 11292.516, 'duration': 0.441}, {'end': 11295.499, 'text': 'parameter type is going to be text type.', 'start': 11292.957, 'duration': 2.542}, {'end': 11296.88, 'text': 'okay, suggested values is going to be.', 'start': 11295.499, 'duration': 1.381}, {'end': 11300.523, 'text': "let's say, i'm going to give a list of values and when you say any, basically you get a.", 'start': 11296.88, 'duration': 3.643}, {'end': 11302.965, 'text': 'you get a text box and if you give a list of values, you get a drop down.', 'start': 11300.523, 'duration': 2.442}, {'end': 11303.906, 'text': "that's the only difference.", 'start': 11302.965, 'duration': 0.941}, {'end': 11305.007, 'text': "i'll show you both the examples.", 'start': 11303.906, 'duration': 1.101}, {'end': 11306.869, 'text': 'okay, current value is a default that you can give.', 'start': 11305.007, 'duration': 1.862}, {'end': 11309.489, 'text': "actually i'll go back and put it as a central right.", 'start': 11306.869, 'duration': 2.62}, {'end': 11316.852, 'text': 'so as my region parameter 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': 11309.489, 'duration': 7.363}, {'end': 11319.753, 'text': 'here in the query, I can go here and filter by region.', 'start': 11316.852, 'duration': 2.901}, {'end': 11321.294, 'text': 'I can directly type out a value here.', 'start': 11319.753, 'duration': 1.541}, {'end': 11327.957, 'text': 'instead of doing this, what I can do is I can go to text filters, I can say equals and here I can go back and select the specific parameter type.', 'start': 11321.294, 'duration': 6.663}, {'end': 11331.325, 'text': 'okay, and this is really the amazing thing about parameters.', 'start': 11328.624, 'duration': 2.701}, {'end': 11336.188, 'text': 'so now, instead of saying equals to a particular region instead of typing out a value here,', 'start': 11331.325, 'duration': 4.863}, {'end': 11339.069, 'text': 'i can go back and say it is equal to that parameter region.', 'start': 11336.188, 'duration': 2.881}, {'end': 11342.651, 'text': 'okay, so now that filter is actually equal to that parameter region.', 'start': 11339.069, 'duration': 3.582}, {'end': 11344.732, 'text': 'okay, and what is that parameter region equal to?', 'start': 11342.651, 'duration': 2.081}, {'end': 11347.513, 'text': 'remember, that parameter region equal to was set as central.', 'start': 11344.732, 'duration': 2.781}, {'end': 11352.135, 'text': 'so now that central parameter is set to central and that is why it is filtered on central.', 'start': 11347.513, 'duration': 4.622}, {'end': 11355.897, 'text': "okay, if you go to the region, it is filtered on central right now and it's very easy to change it.", 'start': 11352.135, 'duration': 3.762}, {'end': 11361.38, 'text': 'by the way, go to edit parameters, go to edit here and see that text box comes up, because the list type was any.', 'start': 11355.897, 'duration': 5.483}, {'end': 11364.681, 'text': "it's actually set as a text box and actually go back and set it to something else, let's say east,", 'start': 11361.38, 'duration': 3.301}, {'end': 11367.963, 'text': "and now you can see it's automatically going to change it to east.", 'start': 11364.681, 'duration': 3.282}, {'end': 11370.724, 'text': "okay, that's the real beauty of using parameters generally.", 'start': 11367.963, 'duration': 2.761}, {'end': 11376.907, 'text': 'you just go back and click on that interface once to put it to reflect, just to refresh it once for it to reflect,', 'start': 11370.724, 'duration': 6.183}, {'end': 11378.048, 'text': "and now you can see it's reflecting as easy.", 'start': 11376.907, 'duration': 1.141}, {'end': 11380.889, 'text': "if you go back and set this as west, let's say, go back and set this as west.", 'start': 11378.048, 'duration': 2.841}, {'end': 11387.665, 'text': 'And if I go back to orders now, you should be able to see that now the entire thing is automatically filtered to it.', 'start': 11382.722, 'duration': 4.943}], 'summary': 'Sql and power query can be used together, and query parameters in power bi are dynamic filters with easy customization and value selection.', 'duration': 132.839, 'max_score': 11254.826, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11254826.jpg'}], 'start': 10958.91, 'title': 'Power query and parameters in power bi', 'summary': 'Discusses the importance of power query in power bi, including etl tool, shaping, cleansing, and transforming data, emphasizing query folding for performance optimization. it also demonstrates the usage of query folding and parameters, showcasing their benefits in reducing data load, enhancing performance, and dynamic filtering capability, with emphasis on common use cases and advantages.', 'chapters': [{'end': 11003.741, 'start': 10958.91, 'title': 'Understanding power query in power bi', 'summary': 'Discusses the importance of power query in power bi, highlighting key terms such as etl tool, shaping, cleansing, transforming data, and emphasizes the significance of query folding for performance optimization.', 'duration': 44.831, 'highlights': ['Power Query is essential in Power BI, emphasizing key terms like ETL tool, shaping, cleansing, and transforming data, which are crucial aspects.', 'Mention of query folding as a significant performance enhancement feature in Power BI, which optimizes operations at the source for better performance.', 'The concept of View Native Query is mentioned as a basic level understanding of the operations in Power Query.']}, {'end': 11509.089, 'start': 11004.061, 'title': 'Using parameters and query folding in power bi', 'summary': 'Demonstrates the usage of query folding and parameters in power bi, showcasing the benefits of query folding in reducing data load and enhancing performance, and the dynamic filtering capability of parameters, with emphasis on their common use cases and advantages.', 'duration': 505.028, 'highlights': ['Query folding in Power BI allows operations performed in Power BI Desktop to be transferred to the source, such as SQL Server, reducing data load and enhancing performance for operations like column removal and renaming, with a focus on the importance of query folding and its benefits in reducing unnecessary data load and improving performance.', 'The usage of parameters in Power BI enables dynamic filtering, allowing users to select and filter data based on specific criteria, showcasing the benefits of using parameters to load only the requisite amount of data, enhancing performance and user experience, with an emphasis on the advantages of dynamic filtering and the preferred parameter approach for reducing unnecessary data load.', 'The chapter also highlights common transformations in Power BI, such as changing data types, adding header rows, filtering rows, removing unnecessary columns, grouping aggregations, and splitting, emphasizing the fundamental nature and usefulness of these transformations in data preparation and analysis.']}], 'duration': 550.179, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY10958910.jpg', 'highlights': ['Query folding optimizes operations at the source for better performance.', 'Parameters in Power BI enable dynamic filtering, enhancing performance.', 'Power Query is essential in Power BI for ETL, shaping, cleansing, and transforming data.', 'Query folding reduces data load and enhances performance for operations like column removal and renaming.', 'Common transformations in Power BI include changing data types, adding header rows, and filtering rows.']}, {'end': 12925.674, 'segs': [{'end': 11637.142, 'src': 'embed', 'start': 11603.052, 'weight': 4, 'content': [{'end': 11608.915, 'text': 'okay, so now it signifies that city is actually of a data category, city which is a geographical type, and a small globe sign will come.', 'start': 11603.052, 'duration': 5.863}, {'end': 11610.116, 'text': 'i will do the same for country as well.', 'start': 11608.915, 'duration': 1.201}, {'end': 11611.857, 'text': 'do the same thing for country.', 'start': 11610.116, 'duration': 1.741}, {'end': 11617.008, 'text': "I'll do the same thing for postal code and see how postal code is actually summarized.", 'start': 11613.826, 'duration': 3.182}, {'end': 11621.331, 'text': 'So this is another thing that will happen from time to time in Power BI, which you have to fix in modeling.', 'start': 11617.128, 'duration': 4.203}, {'end': 11623.472, 'text': 'So sometimes something will be summarized.', 'start': 11621.571, 'duration': 1.901}, {'end': 11625.534, 'text': "So obviously postal code is something I don't want to summarize.", 'start': 11623.492, 'duration': 2.042}, {'end': 11626.835, 'text': "So I'll actually go to don't summarize.", 'start': 11625.574, 'duration': 1.261}, {'end': 11637.142, 'text': "Because if I give you two postal codes, 560102 and 560103, you can't, I mean, this makes no sense to say the average postal code is 560102.5.", 'start': 11627.715, 'duration': 9.427}], 'summary': 'Configuring data categories and summarization in power bi for geographical types and postal codes.', 'duration': 34.09, 'max_score': 11603.052, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11603052.jpg'}, {'end': 11703.762, 'src': 'embed', 'start': 11672.975, 'weight': 7, 'content': [{'end': 11676.365, 'text': 'I have a lot of custom visual maps where you can do a lot of cool things.', 'start': 11672.975, 'duration': 3.39}, {'end': 11680.928, 'text': "But at a basic level, obviously, you have only the kind of maps that you're seeing here right now.", 'start': 11676.685, 'duration': 4.243}, {'end': 11685.39, 'text': "I'm going to quickly go ahead and close that query because I'm connected to my SQL Server.", 'start': 11680.948, 'duration': 4.442}, {'end': 11687.111, 'text': 'It is creating a bit of issue.', 'start': 11685.63, 'duration': 1.481}, {'end': 11694.236, 'text': "Okay, so next step is I'm going to go ahead and quickly replicate and just kind of repeat what I just now did.", 'start': 11687.912, 'duration': 6.324}, {'end': 11698.118, 'text': "So I'm going to quickly go ahead and set this to city.", 'start': 11694.256, 'duration': 3.862}, {'end': 11703.762, 'text': 'Set my state to the state type.', 'start': 11701.741, 'duration': 2.021}], 'summary': 'Custom visual maps offer diverse features, but basic maps are limited. sql server connection issue encountered.', 'duration': 30.787, 'max_score': 11672.975, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11672975.jpg'}, {'end': 11807.409, 'src': 'embed', 'start': 11754.497, 'weight': 1, 'content': [{'end': 11757.759, 'text': "remember, even if you don't set it properly, power bi will still display your data properly.", 'start': 11754.497, 'duration': 3.262}, {'end': 11761.121, 'text': 'okay, but then there are certain use cases where it will not come accurately.', 'start': 11757.759, 'duration': 3.362}, {'end': 11767.031, 'text': 'okay, and i can go ahead and represent this in a map, And all I have to do is just take my country, I take my state,', 'start': 11761.121, 'duration': 5.91}, {'end': 11771.796, 'text': 'I look at my city and see how Bobby is not able to do it the best way all the time.', 'start': 11767.031, 'duration': 4.765}, {'end': 11775.64, 'text': 'So sometimes it will fail and represent this data based on sales.', 'start': 11771.836, 'duration': 3.804}, {'end': 11777.262, 'text': 'So sales is basically going to be my size.', 'start': 11775.82, 'duration': 1.442}, {'end': 11780.445, 'text': "Let's say I can further do a color saturation based on sales.", 'start': 11777.322, 'duration': 3.123}, {'end': 11783.108, 'text': 'OK, I can look at this data across.', 'start': 11781.066, 'duration': 2.042}, {'end': 11785.29, 'text': "And now you're seeing.", 'start': 11784.669, 'duration': 0.621}, {'end': 11790.105, 'text': "Right And you might be wondering what's exactly happening.", 'start': 11787.503, 'duration': 2.602}, {'end': 11795.649, 'text': 'Why am I only seeing, you know, Western United States? And the reason is because if you remember, I have filters applied.', 'start': 11790.165, 'duration': 5.484}, {'end': 11799.052, 'text': "So the underlying model that I've taken, I have filters applied based on parameters.", 'start': 11795.669, 'duration': 3.383}, {'end': 11803.696, 'text': 'OK And again, that is something I can further configure within Power BI.', 'start': 11799.693, 'duration': 4.003}, {'end': 11807.409, 'text': 'okay, just to quickly clarify this once again, where do you set the very parameters?', 'start': 11804.346, 'duration': 3.063}], 'summary': 'Power bi can display data accurately, but may fail in some use cases. filters can be configured based on parameters.', 'duration': 52.912, 'max_score': 11754.497, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11754497.jpg'}, {'end': 12034.924, 'src': 'heatmap', 'start': 11899.914, 'weight': 0.969, 'content': [{'end': 11908.462, 'text': 'then you need to have a gateway and you can actually download your gateway from here to configure it further right and you can also go to the manage gateways tab to basically go and manage your gateway.', 'start': 11899.914, 'duration': 8.548}, {'end': 11912.204, 'text': 'so if you already have a gateway installed and you want to go back and set your gateway specifically,', 'start': 11908.462, 'duration': 3.742}, {'end': 11917.496, 'text': "so this is one other place where you can go back and and check your gateway everything's working fine there, okay.", 'start': 11912.204, 'duration': 5.292}, {'end': 11920.279, 'text': "so it's important that you mention a couple of these things that obviously, yes,", 'start': 11917.496, 'duration': 2.783}, {'end': 11924.043, 'text': 'you can refresh there is something called creative refresh and also mention about gateways.', 'start': 11920.279, 'duration': 3.764}, {'end': 11928.126, 'text': 'gateways are that they are the interface between the cloud and the on-premise world.', 'start': 11924.043, 'duration': 4.083}, {'end': 11935.113, 'text': 'okay, so gateways are what allows you to transfer your data from on-premise sources to your azure cloud, where your cloud server does.', 'start': 11928.126, 'duration': 6.987}, {'end': 11936.134, 'text': 'probably a service is hosted.', 'start': 11935.113, 'duration': 1.021}, {'end': 11938.435, 'text': 'What are the different types of refreshing data?', 'start': 11937.014, 'duration': 1.421}, {'end': 11941.896, 'text': 'package refresh model refresh, tile refresh and visual container refresh.', 'start': 11938.435, 'duration': 3.461}, {'end': 11943.757, 'text': 'So this is another important question.', 'start': 11942.436, 'duration': 1.321}, {'end': 11947.139, 'text': 'So, typically, when we talk about refreshes, how many ways can you refresh the package?', 'start': 11943.797, 'duration': 3.342}, {'end': 11949.96, 'text': "refreshes basically the concept wherein, let's say,", 'start': 11947.139, 'duration': 2.821}, {'end': 11961.285, 'text': 'you have a public 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': 11949.96, 'duration': 11.325}, {'end': 11963.406, 'text': 'essentially, whatever data you have here, you have there.', 'start': 11961.285, 'duration': 2.121}, {'end': 11968.67, 'text': 'and vice versa, and that is something you do using what we call package refresh.', 'start': 11963.966, 'duration': 4.704}, {'end': 11978.358, 'text': 'okay, that ensures that whatever files you have in your power bi service is exactly in sync with what you have in the onedrive or sharepoint online.', 'start': 11968.67, 'duration': 9.688}, {'end': 11980.92, 'text': 'remember, it is not going to pull data from your source.', 'start': 11978.358, 'duration': 2.562}, {'end': 11983.542, 'text': "it's not like the typical kind of refresh that you're thinking.", 'start': 11980.92, 'duration': 2.622}, {'end': 11986.605, 'text': 'so that is basically going to be the model or data refresh.', 'start': 11983.542, 'duration': 3.063}, {'end': 11991.489, 'text': 'so the refresh that you are thinking, or the refresh that i showed you here, is basically the model or data refresh.', 'start': 11986.605, 'duration': 4.884}, {'end': 11995.654, 'text': 'okay, this is basically what we call the module or data refresh.', 'start': 11992.33, 'duration': 3.324}, {'end': 11998.998, 'text': 'okay, that is what you do using refresh now or schedule refresh.', 'start': 11995.654, 'duration': 3.344}, {'end': 12004.263, 'text': 'okay, then we have something called tile refresh, which is something that we can go to the different dashboards.', 'start': 11998.998, 'duration': 5.265}, {'end': 12009.805, 'text': 'And as we all understand in dashboards, whatever stuff that you see, remember, these are just views of the underlying reports.', 'start': 12004.483, 'duration': 5.322}, {'end': 12013.687, 'text': 'OK, and you can just click on the tiles and it will take you to the underlying report.', 'start': 12010.386, 'duration': 3.301}, {'end': 12019.029, 'text': 'So dashboards are nothing but cash sheet views of the underlying reports, which typically get refreshed every 15 minutes or so.', 'start': 12013.707, 'duration': 5.322}, {'end': 12023.871, 'text': 'OK, but if you want to specifically refresh a tile, you can go back and say refresh dashboard tiles.', 'start': 12019.369, 'duration': 4.502}, {'end': 12030.854, 'text': 'OK, that is how you refresh the dashboard views to reflect according to the data changes, which anyways get refreshed every 15 minutes.', 'start': 12024.571, 'duration': 6.283}, {'end': 12034.924, 'text': 'okay, those are the types of views refreshes that you have.', 'start': 12031.841, 'duration': 3.083}], 'summary': 'Gateways facilitate data transfer between on-premise and azure cloud. different types of refreshes include package, model, and tile refresh.', 'duration': 135.01, 'max_score': 11899.914, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11899914.jpg'}, {'end': 11961.285, 'src': 'embed', 'start': 11924.043, 'weight': 2, 'content': [{'end': 11928.126, 'text': 'gateways are that they are the interface between the cloud and the on-premise world.', 'start': 11924.043, 'duration': 4.083}, {'end': 11935.113, 'text': 'okay, so gateways are what allows you to transfer your data from on-premise sources to your azure cloud, where your cloud server does.', 'start': 11928.126, 'duration': 6.987}, {'end': 11936.134, 'text': 'probably a service is hosted.', 'start': 11935.113, 'duration': 1.021}, {'end': 11938.435, 'text': 'What are the different types of refreshing data?', 'start': 11937.014, 'duration': 1.421}, {'end': 11941.896, 'text': 'package refresh model refresh, tile refresh and visual container refresh.', 'start': 11938.435, 'duration': 3.461}, {'end': 11943.757, 'text': 'So this is another important question.', 'start': 11942.436, 'duration': 1.321}, {'end': 11947.139, 'text': 'So, typically, when we talk about refreshes, how many ways can you refresh the package?', 'start': 11943.797, 'duration': 3.342}, {'end': 11949.96, 'text': "refreshes basically the concept wherein, let's say,", 'start': 11947.139, 'duration': 2.821}, {'end': 11961.285, 'text': 'you have a public 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': 11949.96, 'duration': 11.325}], 'summary': 'Gateways enable data transfer from on-premise to azure cloud. different types of data refresh include package, model, tile, and visual container refresh.', 'duration': 37.242, 'max_score': 11924.043, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11924043.jpg'}, {'end': 12131.921, 'src': 'embed', 'start': 12103.864, 'weight': 9, 'content': [{'end': 12107.487, 'text': 'it may not be an interview question, obviously, but uh, take some time out to explore this.', 'start': 12103.864, 'duration': 3.623}, {'end': 12112.671, 'text': "on the power bi app, and in power bi cap, what they call, they don't have a feature called conversational q a.", 'start': 12107.487, 'duration': 5.184}, {'end': 12117.635, 'text': 'okay, so here is just standard q a, but if you use the app they have something called conversational q a,', 'start': 12112.671, 'duration': 4.964}, {'end': 12123.939, 'text': "where it is just like as if you're having a conversation with google assistant, something like that.", 'start': 12117.635, 'duration': 6.304}, {'end': 12126.42, 'text': "you know, just like you're having a conversation asking hey, what is the sales?", 'start': 12123.939, 'duration': 2.481}, {'end': 12127.6, 'text': "And they'll go back and respond something.", 'start': 12126.44, 'duration': 1.16}, {'end': 12130.081, 'text': 'And then you can just go back and carry on the conversation from there.', 'start': 12127.9, 'duration': 2.181}, {'end': 12131.921, 'text': "You don't have to type in a new question every time.", 'start': 12130.381, 'duration': 1.54}], 'summary': 'Power bi app lacks conversational q&a feature, unlike power bi cap which has it, resembling interaction with google assistant.', 'duration': 28.057, 'max_score': 12103.864, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY12103864.jpg'}, {'end': 12567.439, 'src': 'embed', 'start': 12540.763, 'weight': 6, 'content': [{'end': 12544.126, 'text': 'So replace because another data set with the same name is already there.', 'start': 12540.763, 'duration': 3.363}, {'end': 12546.869, 'text': 'So it will by default replace, because they both are the same names right?', 'start': 12544.146, 'duration': 2.723}, {'end': 12553.733, 'text': 'And once I do that, go back to my service now and you can go to data.', 'start': 12547.409, 'duration': 6.324}, {'end': 12559.396, 'text': 'such now you can go to manage security, to the security section here and here you should be able to add.', 'start': 12553.733, 'duration': 5.663}, {'end': 12560.576, 'text': 'you should see the rules present here.', 'start': 12559.396, 'duration': 1.18}, {'end': 12567.439, 'text': 'Okay, this is where you can basically now go back and add the email addresses of all the people and remember this further will be linked to your ad groups right?', 'start': 12560.776, 'duration': 6.663}], 'summary': 'Replace duplicate data set, manage security, add email addresses, link to ad groups.', 'duration': 26.676, 'max_score': 12540.763, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY12540763.jpg'}, {'end': 12594.393, 'src': 'embed', 'start': 12571.121, 'weight': 0, 'content': [{'end': 12578.405, 'text': 'but basically you can type email addresses of all those people who are belonging to the east role and email addresses of all the people who are beyond the central room.', 'start': 12571.121, 'duration': 7.284}, {'end': 12584.429, 'text': 'now, if anyone who is in the eastern role and if they try to view your dashboard now, they will basically be looking at only eastern data,', 'start': 12578.405, 'duration': 6.024}, {'end': 12590.131, 'text': "because i've said that filter remember region is equal to east, and if anyone who is belonging to the central role is trying to give your dashboard,", 'start': 12584.429, 'duration': 5.702}, {'end': 12591.752, 'text': 'they will look at only central data.', 'start': 12590.131, 'duration': 1.621}, {'end': 12594.393, 'text': 'okay, and that depends on what email addresses you enter here.', 'start': 12591.752, 'duration': 2.641}], 'summary': 'Filter by role and region to restrict dashboard data access.', 'duration': 23.272, 'max_score': 12571.121, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY12571121.jpg'}], 'start': 11509.089, 'title': 'Power bi features and integration', 'summary': 'Discusses power query, power pivot, setting geographical types, data refresh options, and role level security in power bi, along with their distinct roles and configurations for accurate data representation, integration with excel, and implementation of row-level security. power bi is experiencing a 3% monthly job vacancy growth with an average salary of 50,000 pounds for a three-month tenure.', 'chapters': [{'end': 11646.168, 'start': 11509.089, 'title': 'Power query and power pivot', 'summary': 'Discusses the differences between power query and power pivot, emphasizing their distinct roles in etl and analytics within power bi, and provides tips for configuring geographical data types for mapping in power bi desktop.', 'duration': 137.079, 'highlights': ['Power Pivot is not an ETL tool and is solely used for performing calculations and analysis, while Power Query serves as the ETL tool within Power BI.', 'Importance of setting correct geographical data types such as city, country, and postal code in Power BI to enable mapping functionalities.', 'Emphasizing the significance of not summarizing certain types of data, such as postal codes, in Power BI to avoid misleading results.']}, {'end': 11865.095, 'start': 11646.168, 'title': 'Setting geographical types in power bi', 'summary': 'Discusses the importance of setting geographical types correctly in power bi to ensure accurate data representation in maps, with an emphasis on the impact of data categories and the configuration of filters based on parameters.', 'duration': 218.927, 'highlights': ['The importance of setting geographical types correctly in Power BI', 'Impact of data categories on data representation', 'Configuration of filters based on parameters for data visualization']}, {'end': 12539.362, 'start': 11865.095, 'title': 'Power bi data refresh and integration with excel', 'summary': 'Explores power bi data refresh options, including package refresh, model refresh, tile refresh, and visual container refresh, emphasizing the importance of gateways for on-premise sources, and also discusses the seamless integration between power bi and excel, as well as the implementation of row-level security using roles and filters.', 'duration': 674.267, 'highlights': ['The chapter explores Power BI data refresh options, including package refresh, model refresh, tile refresh, and visual container refresh', 'Emphasizes the importance of gateways for on-premise sources', 'Discusses the seamless integration between Power BI and Excel', 'Implementation of row-level security using roles and filters in Power BI']}, {'end': 12925.674, 'start': 12540.763, 'title': 'Implementing role level security in power bi', 'summary': 'Discusses implementing role level security in power bi, including adding email addresses for role-based access, using boolean expressions, and integrating ssrs with power bi. power bi is rapidly growing in job vacancies at a rate of 3% per month, with an average salary of 50,000 pounds for a three-month tenure.', 'duration': 384.911, 'highlights': ['Power BI job vacancies growing at 3% per month', 'Average salary for Power BI professionals', 'Implementing role level security using boolean expressions', 'Integration of SSRS with Power BI']}], 'duration': 1416.585, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/3u7MQz1EyPY/pics/3u7MQz1EyPY11509089.jpg', 'highlights': ['Power BI job vacancies growing at 3% per month', 'Average salary for Power BI professionals is 50,000 pounds for a three-month tenure', 'The chapter explores Power BI data refresh options, including package refresh, model refresh, tile refresh, and visual container refresh', 'Implementation of row-level security using roles and filters in Power BI', 'Emphasizes the importance of gateways for on-premise sources', 'Integration of SSRS with Power BI', 'Power Pivot is not an ETL tool and is solely used for performing calculations and analysis, while Power Query serves as the ETL tool within Power BI', 'Importance of setting correct geographical data types such as city, country, and postal code in Power BI to enable mapping functionalities', 'Emphasizing the significance of not summarizing certain types of data, such as postal codes, in Power BI to avoid misleading results', 'Impact of data categories on data representation', 'Configuration of filters based on parameters for data visualization', 'Discussing the seamless integration between Power BI and Excel', 'Importance of setting geographical types correctly in Power BI']}], 'highlights': ['Power BI job vacancies growing at 3% per month', 'Average salary for Power BI professionals is 50,000 pounds for a three-month tenure', 'Power BI is the market leader in solving data management crisis', 'Most organizations have already moved in or have plans to use business intelligence and solving their crisis', 'Power BI can spot Trends in real time, providing real-time information for early trend identification and issue resolution', 'Power BI can automatically search hidden insights in seconds, enabling quick insights and immediate answers to user questions', 'Power BI is mainly aimed to help everyone analyze and visualize their data', 'Power BI offers custom visuals and drag-and-drop features, making it a clear winner in visualization', 'Power BI excels in integration capabilities, readily integrating with various other Microsoft products', 'Power BI outperforms Tableau in data management, excelling in data shaping, data modeling, and analytics', 'Power BI is one of the most popular self-service business intelligence (SSBI) tools, enabling faster development cycles and increased control for end users', 'Power BI desktop is updated monthly, while the Power BI service receives updates weekly, showcasing the frequent updates in the Power BI ecosystem', 'The x velocity in-memory analytics engine in Power Pivot utilizes a columnar database for efficient data storage and fast data access', 'The importance of DAX knowledge in job interviews', 'Query folding optimizes operations at the source for better performance', 'Parameters in Power BI enable dynamic filtering, enhancing performance', 'Power Query is essential in Power BI for ETL, shaping, cleansing, and transforming data', 'Power BI job vacancies growing at 3% per month', 'Average salary for Power BI professionals is 50,000 pounds for a three-month tenure']}