title
Power BI Tutorial For Beginners | Introduction to Power BI | Power BI Training Course | Edureka

description
πŸ”₯ Edureka Power BI Training (Use Code "π˜πŽπ”π“π”ππ„πŸπŸŽ") - https://www.edureka.co/power-bi-certification-training This Edureka "Power BI" video will help you to understand what is BI as well as Power BI (Blog: https://goo.gl/uFTDU3). Then moving on in this video we have discussed the components and building blocks of Power BI. We have also discussed lots of examples in this session. Below are the topics covered in this tutorial: 1.Why choose Power BI? 2.What is Power BI? 3.Components of Power BI 4.Architecture of Power BI 5.Building Blocks of Power BI 6.Hands On - - - - - - - - - - - - - - - - - Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV Instagram: https://www.instagram.com/edureka_learning Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka Telegram: https://t.me/edurekaupdates - - - - - - - - - - - - - - - - - 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 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 Course? The Power BI training at edureka is for all the professionals who are passionate about business intelligence, data visualization, and data analytics. For example: Business Analysts Business Intelligence Manager Statisticians and Analysts Data Scientists Project Managers - - - - - - - - - - - - - - Why learn Power BI? Power BI helps Business Analysts, Business Intelligence Manager, Statisticians & Analysts, Project Managers and Data scientists to visualize and share insights from their organizations’ data. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on any information from technology staff or database administrator. Power BI provides cloud based BI services - known as Power BI Services, along with a desktop based interface - called Power BI desktop. It offers Data modelling capabilities, including data preparation, data discovery and interactive dashboards. Cognizant, Dell, KPMG, Hitachi, Wipro, Avanade, Annik Inc., Brillio and over 45,000 MNCs across 185 countries use Power BI For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free). Customer Review: Michael Harkins, Solution Engineer-Open Source Analytics at IBM says: "The courses are top rate. The best part is live instruction, with playback. You get all the presentations and labs. Great instructions. But my favorite feature is viewing a previous class. They provide a set of videos from a previous session, so you can watch the course before you participate. This way you can get the most out of the course. Also, they are always there to answer questions, and prompt when you open an issue if you are having any trouble. Added bonus ~ you get lifetime access to the course you took!!! I have taken so many courses and then not really gotten to work with a technology until I forgot most of what was taught. Edureka lets you go back later, when your boss says "I want this ASAP!" ~ This is the killer education app... I've take two courses, and I'm taking two more. Love these guys."

detail
{'title': 'Power BI Tutorial For Beginners | Introduction to Power BI | Power BI Training Course | Edureka', 'heatmap': [{'end': 496.073, 'start': 423.917, 'weight': 1}], 'summary': 'This power bi tutorial series offers a comprehensive understanding of power bi, including its market leadership, self-service bi concepts, etl process, cloud service benefits, ssrs comparison, visualizations, quick insights demo, and data churning, with practical examples and insights from industry experts, attracting a global audience.', 'chapters': [{'end': 40.147, 'segs': [{'end': 40.147, 'src': 'embed', 'start': 0.369, 'weight': 0, 'content': [{'end': 3.411, 'text': "Hello everyone, welcome to today's webinar on Power BI.", 'start': 0.369, 'duration': 3.042}, {'end': 7.974, 'text': "In this session, we'll be discussing about various concepts of business intelligence.", 'start': 4.091, 'duration': 3.883}, {'end': 12.797, 'text': "We'll also understand why to use Power BI when we already have MSBI.", 'start': 8.655, 'duration': 4.142}, {'end': 18.261, 'text': 'Let me tell you, this session will also include a lot of practicals and examples of Power BI.', 'start': 13.658, 'duration': 4.603}, {'end': 21.663, 'text': 'Among our participants here, that is you.', 'start': 19.201, 'duration': 2.462}, {'end': 29.048, 'text': 'we have a well-rounded representation across different geographies, including India, USA, UK, Singapore, Middle East.', 'start': 21.663, 'duration': 7.385}, {'end': 32.764, 'text': 'We have Sayan De who will be taking us through the session.', 'start': 29.963, 'duration': 2.801}, {'end': 37.786, 'text': 'He has a rich experience with BI and has worked on multiple tools in BI domain.', 'start': 33.344, 'duration': 4.442}, {'end': 40.147, 'text': 'I welcome you Sayan, over to you now.', 'start': 38.306, 'duration': 1.841}], 'summary': 'Webinar on power bi with global participation and practical examples.', 'duration': 39.778, 'max_score': 0.369, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY369.jpg'}], 'start': 0.369, 'title': 'A power bi webinar', 'summary': 'Discusses the significance of power bi and features practical examples, with participation from india, usa, uk, singapore, and the middle east, led by sayan de, having extensive bi experience.', 'chapters': [{'end': 40.147, 'start': 0.369, 'title': 'Webinar on power bi', 'summary': 'Discusses the importance of power bi, including practical examples and a diverse participant representation from india, usa, uk, singapore, and the middle east, led by sayan de, who has extensive experience in bi.', 'duration': 39.778, 'highlights': ['Sayan De has extensive experience with BI and has worked on multiple tools in the BI domain.', 'The webinar includes practicals and examples of Power BI.', 'The participants represent a diverse range of geographies including India, USA, UK, Singapore, and the Middle East.']}], 'duration': 39.778, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY369.jpg', 'highlights': ['The participants represent a diverse range of geographies including India, USA, UK, Singapore, and the Middle East.', 'Sayan De has extensive experience with BI and has worked on multiple tools in the BI domain.', 'The webinar includes practicals and examples of Power BI.']}, {'end': 1289.358, 'segs': [{'end': 143.812, 'src': 'embed', 'start': 117.523, 'weight': 0, 'content': [{'end': 123.825, 'text': "Because the whole point of BI up to this point, and this is, we're at an intersection of traditional BI and modern BI.", 'start': 117.523, 'duration': 6.302}, {'end': 130.467, 'text': 'The Power BI is more into the realm of modern BI, advanced BI, where we are in a self-service BI, the way we like to call it.', 'start': 124.105, 'duration': 6.362}, {'end': 133.848, 'text': 'okay?. But then we have made a great move from the world of traditional BI.', 'start': 130.467, 'duration': 3.381}, {'end': 135.368, 'text': 'And traditional BI.', 'start': 134.308, 'duration': 1.06}, {'end': 141.17, 'text': 'we use tools like SQL Server Integration Services, SSIS, MSBI, that we call it Informatica Cognos.', 'start': 135.368, 'duration': 5.802}, {'end': 143.812, 'text': 'So these kind of softwares are difficult to use right?', 'start': 141.61, 'duration': 2.202}], 'summary': 'The intersection of traditional bi and modern bi involves a shift to self-service bi with power bi, moving away from difficult-to-use traditional bi tools such as ssis and informatica cognos.', 'duration': 26.289, 'max_score': 117.523, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY117523.jpg'}, {'end': 193.097, 'src': 'embed', 'start': 168.517, 'weight': 1, 'content': [{'end': 176.344, 'text': 'And this is where a revolution has happened around visualization and BI in general, where tools like AlterX, Power BI, ClickView, Tableau,', 'start': 168.517, 'duration': 7.827}, {'end': 183.349, 'text': 'these kind of tools have really taken the market by storm, and which is where we are slowly getting into the realm of self-service BI.', 'start': 176.344, 'duration': 7.005}, {'end': 187.993, 'text': "And the meaning of self-service BI basically means you're putting BI in the hands of the end users.", 'start': 183.589, 'duration': 4.404}, {'end': 193.097, 'text': "So the next time the management wants to build a report, They don't have to wait for the IT team to get involved.", 'start': 188.413, 'duration': 4.684}], 'summary': 'Visualization and bi tools like alterx, power bi, clickview, tableau have revolutionized the market, enabling self-service bi for end users.', 'duration': 24.58, 'max_score': 168.517, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY168517.jpg'}, {'end': 416.331, 'src': 'embed', 'start': 388.429, 'weight': 2, 'content': [{'end': 393.233, 'text': 'ETL, the E stands for extraction, the T stands for transformation, and the L stands for loading.', 'start': 388.429, 'duration': 4.804}, {'end': 395.655, 'text': "So this is the ETL that you're doing.", 'start': 394.074, 'duration': 1.581}, {'end': 401.901, 'text': "You're extracting your data, you're transforming your data, and then you're finally loading that data into a central data warehouse.", 'start': 396.096, 'duration': 5.805}, {'end': 407.265, 'text': 'Why do you need that? Because now the data is readily available with ABC to do its reporting.', 'start': 403.162, 'duration': 4.103}, {'end': 411.248, 'text': 'If you have not done the ETL, you can just imagine what challenges you will be facing.', 'start': 407.745, 'duration': 3.503}, {'end': 416.331, 'text': "So you will have some data, let's say a company, Retail Store 1 stores its data in an Excel file.", 'start': 411.508, 'duration': 4.823}], 'summary': 'Etl process involves extraction, transformation, and loading for data into a central warehouse, enabling better reporting for abc.', 'duration': 27.902, 'max_score': 388.429, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY388429.jpg'}, {'end': 496.073, 'src': 'heatmap', 'start': 423.917, 'weight': 1, 'content': [{'end': 426.799, 'text': "They just have Microsoft Office, and they'll just store their data.", 'start': 423.917, 'duration': 2.882}, {'end': 429.801, 'text': "At the end of every day, they'll record their sales in an Excel file.", 'start': 427.159, 'duration': 2.642}, {'end': 432.203, 'text': "It's a very simple method of saving data.", 'start': 430.241, 'duration': 1.962}, {'end': 438.666, 'text': "Let's say Little Outlet 2 has its data stored in SQL Server, Little Outlet 3 has an Oracle, Little Outlet 4 has a DB2, and so on and so forth.", 'start': 432.483, 'duration': 6.183}, {'end': 441.188, 'text': 'Little Outlet 5 might have some of its data stored in some flat files.', 'start': 438.706, 'duration': 2.482}, {'end': 444.289, 'text': "There's so many different kinds of sources out there.", 'start': 441.648, 'duration': 2.641}, {'end': 450.533, 'text': "We call it heterogeneous sources, the different kinds of sources of data that you have, and you're trying to pull in all those different sources.", 'start': 444.309, 'duration': 6.224}, {'end': 451.713, 'text': "You're trying to extract the data.", 'start': 450.553, 'duration': 1.16}, {'end': 457.056, 'text': "You're trying to do some transformation, and then you're trying to load the data into a common format into a SQL Server data warehouse.", 'start': 451.953, 'duration': 5.103}, {'end': 461.6, 'text': "I'm taking SQL Server because I'm just giving an example of MSBI, but it can be anything.", 'start': 457.336, 'duration': 4.264}, {'end': 468.187, 'text': 'That data warehouse, that database, it could be a SQL Server, it could be an Oracle, it could literally be anything.', 'start': 461.68, 'duration': 6.507}, {'end': 470.469, 'text': "And finally, you're doing reporting on top of it.", 'start': 468.847, 'duration': 1.622}, {'end': 476.158, 'text': "So you're using Excel, you're using SSRS, you're using Power BI, you can use ClickView, you can use Tableau and, finally,", 'start': 470.953, 'duration': 5.205}, {'end': 477.259, 'text': "you're doing reporting on top of it.", 'start': 476.158, 'duration': 1.101}, {'end': 478.68, 'text': "So that's the broad picture.", 'start': 477.539, 'duration': 1.141}, {'end': 484.125, 'text': "I don't want to get too much into the other stuff right now, but I just wanted to give you a broad picture as what ETL is.", 'start': 478.7, 'duration': 5.425}, {'end': 486.687, 'text': 'where does the broad BI story unfold?', 'start': 484.125, 'duration': 2.562}, {'end': 488.549, 'text': 'So this is how BI works in a broad way.', 'start': 486.807, 'duration': 1.742}, {'end': 493.452, 'text': 'So you do ETL, this is the extract transform load, and SSIS is one such tool.', 'start': 488.949, 'duration': 4.503}, {'end': 496.073, 'text': 'We call it SQL Server Integration Services.', 'start': 494.152, 'duration': 1.921}], 'summary': 'Data from various sources transformed and loaded into sql server data warehouse for reporting using bi tools.', 'duration': 72.156, 'max_score': 423.917, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY423917.jpg'}, {'end': 574.791, 'src': 'embed', 'start': 548.349, 'weight': 3, 'content': [{'end': 552.472, 'text': "Now the company's management can connect to that data warehouse and they can do reporting.", 'start': 548.349, 'duration': 4.123}, {'end': 554.894, 'text': 'They can easily find out how they have performed over the past one year.', 'start': 552.492, 'duration': 2.402}, {'end': 557.256, 'text': 'We call it the single version of truth.', 'start': 555.795, 'duration': 1.461}, {'end': 560.699, 'text': 'There are a lot of different terminologies that go with data warehouses.', 'start': 557.496, 'duration': 3.203}, {'end': 565.062, 'text': "Again, I won't get too much into the details of it, but then this is what we call the single version of truth.", 'start': 560.739, 'duration': 4.323}, {'end': 571.248, 'text': 'Anything and everything that has to do with company ABC is there in this data warehouse.', 'start': 565.503, 'duration': 5.745}, {'end': 572.729, 'text': 'People will not go back to..', 'start': 571.288, 'duration': 1.441}, {'end': 574.791, 'text': 'any other kind of source.', 'start': 573.229, 'duration': 1.562}], 'summary': "Company management can access a data warehouse for reporting, providing a single version of truth for company abc's performance over the past year.", 'duration': 26.442, 'max_score': 548.349, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY548349.jpg'}, {'end': 622.489, 'src': 'embed', 'start': 602.476, 'weight': 4, 'content': [{'end': 612.986, 'text': "so that's a very broad overview of BI in general that I wanted to talk about and just to quickly talk a little bit about some of the value addition that BI brings to the table.", 'start': 602.476, 'duration': 10.51}, {'end': 618.445, 'text': 'So one of the things that you have is obviously you have boosting productivity.', 'start': 615.503, 'duration': 2.942}, {'end': 622.489, 'text': "So it's great for productivity, as in I mean just as an example that I showed you,", 'start': 618.766, 'duration': 3.723}], 'summary': 'Bi boosts productivity and adds value to businesses.', 'duration': 20.013, 'max_score': 602.476, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY602476.jpg'}, {'end': 1128.8, 'src': 'embed', 'start': 1098.245, 'weight': 7, 'content': [{'end': 1104.108, 'text': 'But in the self-service BI world, with tools like Power BI coming into the market, Anyone can get into this.', 'start': 1098.245, 'duration': 5.863}, {'end': 1108.11, 'text': 'Anyone can build a quick dashboard, some basic analytical skills.', 'start': 1104.608, 'duration': 3.502}, {'end': 1113.233, 'text': 'You can start building some really cool graphics from scratch and literally in minutes.', 'start': 1108.13, 'duration': 5.103}, {'end': 1114.233, 'text': 'Literally in minutes.', 'start': 1113.573, 'duration': 0.66}, {'end': 1118.716, 'text': 'You can open up an Excel file and you can literally develop charts, maps in minutes.', 'start': 1114.253, 'duration': 4.463}, {'end': 1122.278, 'text': "I should actually say second, and I'll show you how it is in seconds.", 'start': 1119.396, 'duration': 2.882}, {'end': 1128.8, 'text': 'All right, so actionable information is a very, very important part, and this is the reason why I say better decision making.', 'start': 1123.038, 'duration': 5.762}], 'summary': 'Self-service bi tools like power bi enable quick dashboard creation in minutes, fostering better decision making.', 'duration': 30.555, 'max_score': 1098.245, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1098245.jpg'}, {'end': 1236.37, 'src': 'embed', 'start': 1210.722, 'weight': 6, 'content': [{'end': 1218.444, 'text': 'And this is where Power BI and tools like Power BI really make BI accessible to the end users, and which is why I use the term self-service BI.', 'start': 1210.722, 'duration': 7.722}, {'end': 1221.806, 'text': "It's about making BI accessible to the end users.", 'start': 1219.305, 'duration': 2.501}, {'end': 1227.507, 'text': 'Just to resume our discussion here, as I was mentioning, machine learning is a big component of Power BI.', 'start': 1222.886, 'duration': 4.621}, {'end': 1230.408, 'text': 'And again, initially, when I started off, I mentioned that.', 'start': 1227.768, 'duration': 2.64}, {'end': 1236.37, 'text': 'machine learning, data science, these are all components, these are all the broader canvas of BI.', 'start': 1230.408, 'duration': 5.962}], 'summary': 'Power bi makes bi accessible to end users, including machine learning and data science components.', 'duration': 25.648, 'max_score': 1210.722, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1210722.jpg'}], 'start': 41.567, 'title': 'Self-service bi and etl process', 'summary': 'Provides an overview of bi concepts and the shift towards modern self-service bi, discusses the revolution in bi tools, explains the etl process, and emphasizes the benefits of self-service bi, highlighting increased productivity and high roi.', 'chapters': [{'end': 135.368, 'start': 41.567, 'title': 'Introduction to power bi and bi concepts', 'summary': 'Provides an overview of bi concepts, including etl, data warehouse, and visualization tools like power bi, emphasizing the shift towards modern self-service bi.', 'duration': 93.801, 'highlights': ['The chapter discusses the broad domain of BI, covering related technologies and concepts, emphasizing the prevalence of data science and BI (Business Intelligence).', 'The instructor mentions the various BI tools in the market, including MSBI, Tableau, Spotify, Power BI, and ClickView, highlighting the diversity in visualization tools available.', 'The focus is on understanding Power BI and its capabilities, with an emphasis on making business intelligence more accessible and easy, aligning with the shift towards modern self-service BI.', "The chapter emphasizes the transition from traditional BI to modern BI, particularly highlighting Power BI's role in advanced BI and self-service BI, signaling a significant shift in the BI landscape."]}, {'end': 441.188, 'start': 135.368, 'title': 'Revolution in business intelligence', 'summary': 'Discusses the shift from traditional bi tools like cognos and ssrs to self-service bi tools like alterx, power bi, clickview, and tableau, allowing end users to easily build reports without it intervention, and explains the process of traditional bi using msbi as an example.', 'duration': 305.82, 'highlights': ['The shift from traditional BI tools to self-service BI tools Tools like AlterX, Power BI, ClickView, and Tableau have revolutionized the BI market, enabling end users to easily build reports without IT intervention, facilitating a shift towards self-service BI.', 'Explanation of traditional BI using MSBI as an example The speaker provides an overview of how traditional BI works using MSBI (Microsoft BI) as an example, explaining the process of extracting, transforming, and loading data into a central data warehouse for reporting purposes.', 'Challenges of traditional BI and the importance of ETL The enormity of the challenge in analyzing data from multiple sources is emphasized, highlighting the crucial role of ETL (extraction, transformation, loading) in making data readily available for reporting and the potential challenges faced without proper ETL processes.']}, {'end': 879.42, 'start': 441.648, 'title': 'Etl process and bi overview', 'summary': 'Explains the etl process, focusing on data extraction, transformation, and loading into a common platform like sql server data warehouse, enabling efficient reporting and data visualization for boosting productivity.', 'duration': 437.772, 'highlights': ['ETL process involves extracting data from heterogeneous sources, transforming it, and loading it into a common platform like SQL Server data warehouse for efficient reporting and visualization. Heterogeneous sources, SQL Server data warehouse', 'BI allows management to easily connect to the data warehouse for reporting and performance analysis, providing a single version of truth for company data. Single version of truth, performance analysis', 'BI contributes to boosting productivity by providing easy access to stored data, enabling quick reporting and visualization through tools like Excel and Power BI. Productivity enhancement, Excel and Power BI']}, {'end': 1289.358, 'start': 879.42, 'title': 'Benefits of self-service bi', 'summary': 'Emphasizes the use of self-service bi tools like excel and power bi to enable easy reporting and visualization of data, ultimately leading to better decision-making and high roi, while also highlighting the accessibility and machine learning capabilities of power bi.', 'duration': 409.938, 'highlights': ['Self-service BI tools like Power BI and Excel enable easy reporting and visualization of data, leading to better decision-making and high ROI. The use of self-service BI tools like Excel and Power BI is emphasized to enable easy reporting and visualization of data, ultimately leading to better decision-making and high ROI.', "The accessibility and machine learning capabilities of Power BI make BI accessible to end users and simplify complex tasks like machine learning. Power BI's accessibility and machine learning capabilities simplify complex tasks like machine learning and make BI accessible to end users.", 'Traditional BI requires IT skills and coding, while self-service BI tools like Power BI make it accessible to anyone, enabling quick dashboard and chart development in minutes. Traditional BI requires IT skills and coding, while self-service BI tools like Power BI make it accessible to anyone, enabling quick dashboard and chart development in minutes.']}], 'duration': 1247.791, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY41567.jpg', 'highlights': ["The chapter emphasizes the transition from traditional BI to modern BI, particularly highlighting Power BI's role in advanced BI and self-service BI, signaling a significant shift in the BI landscape.", 'Tools like AlterX, Power BI, ClickView, and Tableau have revolutionized the BI market, enabling end users to easily build reports without IT intervention, facilitating a shift towards self-service BI.', 'The enormity of the challenge in analyzing data from multiple sources is emphasized, highlighting the crucial role of ETL (extraction, transformation, loading) in making data readily available for reporting and the potential challenges faced without proper ETL processes.', 'BI allows management to easily connect to the data warehouse for reporting and performance analysis, providing a single version of truth for company data.', 'BI contributes to boosting productivity by providing easy access to stored data, enabling quick reporting and visualization through tools like Excel and Power BI.', 'Self-service BI tools like Power BI and Excel enable easy reporting and visualization of data, leading to better decision-making and high ROI.', "Power BI's accessibility and machine learning capabilities simplify complex tasks like machine learning and make BI accessible to end users.", 'Traditional BI requires IT skills and coding, while self-service BI tools like Power BI make it accessible to anyone, enabling quick dashboard and chart development in minutes.']}, {'end': 2426.067, 'segs': [{'end': 1355.303, 'src': 'embed', 'start': 1327.793, 'weight': 0, 'content': [{'end': 1331.856, 'text': "It's a very capable tool, but Tableau is clearly the market leader when it comes to BI.", 'start': 1327.793, 'duration': 4.063}, {'end': 1333.337, 'text': 'There are no second thoughts about it.', 'start': 1331.996, 'duration': 1.341}, {'end': 1339.842, 'text': 'Power BI is very close to catching up, but then there are capabilities that Tableau has which no BI tool in the market has today.', 'start': 1333.377, 'duration': 6.465}, {'end': 1350.296, 'text': 'Of course, Qlik Sense is a tool which is at a par, I will say, as per Gartner survey, but Power BI is catching up very, very fast, very, very fast.', 'start': 1340.242, 'duration': 10.054}, {'end': 1355.303, 'text': "When I talk about Power BI, and again, this is something that gradually we're gonna talk about in the slides also.", 'start': 1350.316, 'duration': 4.987}], 'summary': 'Tableau is the market leader in bi, with unique capabilities. power bi is catching up fast, with qlik sense at par.', 'duration': 27.51, 'max_score': 1327.793, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1327793.jpg'}, {'end': 1479.335, 'src': 'embed', 'start': 1455.019, 'weight': 1, 'content': [{'end': 1461.344, 'text': 'starting from 2010 version it started being available to Excel users as add-ins.', 'start': 1455.019, 'duration': 6.325}, {'end': 1462.324, 'text': "That's Power BI.", 'start': 1461.384, 'duration': 0.94}, {'end': 1464.126, 'text': "I mean that's where Power BI started.", 'start': 1462.324, 'duration': 1.802}, {'end': 1465.507, 'text': 'okay?. It is only very recent.', 'start': 1464.126, 'duration': 1.381}, {'end': 1471.13, 'text': 'I think in 2014 is when Power BI was launched, where Microsoft incorporated all these different add-ins.', 'start': 1465.507, 'duration': 5.623}, {'end': 1474.992, 'text': 'The historical way in which people used to build their solutions.', 'start': 1471.53, 'duration': 3.462}, {'end': 1479.335, 'text': 'Microsoft incorporated these add-ins into one product, which they called the Power BI Desktop.', 'start': 1474.992, 'duration': 4.343}], 'summary': 'Power bi was launched in 2014, incorporating add-ins into one product.', 'duration': 24.316, 'max_score': 1455.019, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1455019.jpg'}, {'end': 1670.324, 'src': 'embed', 'start': 1645.167, 'weight': 2, 'content': [{'end': 1650.991, 'text': 'And I think we have a lot of folks who have picked up, and this is where the real power of self-service BI lies.', 'start': 1645.167, 'duration': 5.824}, {'end': 1653.032, 'text': 'It really makes BI accessible to everyone.', 'start': 1651.091, 'duration': 1.941}, {'end': 1654.834, 'text': 'I mean, you may not be from a BI background.', 'start': 1653.052, 'duration': 1.782}, {'end': 1657.936, 'text': 'And the reason why I really started with traditional BI.', 'start': 1655.094, 'duration': 2.842}, {'end': 1661.318, 'text': "it's not to really discourage you, but just to give you the broader picture.", 'start': 1657.936, 'duration': 3.382}, {'end': 1663.559, 'text': 'I wanted to also involve folks who have worked in BI.', 'start': 1661.318, 'duration': 2.241}, {'end': 1670.324, 'text': "But for those who have not worked in BI, who have no understanding of BI, who don't understand what is a fact, table dimension table,", 'start': 1663.86, 'duration': 6.464}], 'summary': 'Self-service bi empowers non-bi professionals by making bi accessible to everyone.', 'duration': 25.157, 'max_score': 1645.167, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1645167.jpg'}, {'end': 1851.098, 'src': 'embed', 'start': 1824.864, 'weight': 3, 'content': [{'end': 1830.086, 'text': "It's a default feature in Power BI where you just go there and you have a prediction tab where you can just go ahead and enable it.", 'start': 1824.864, 'duration': 5.222}, {'end': 1831.587, 'text': "And that's it, linear regression done.", 'start': 1830.386, 'duration': 1.201}, {'end': 1834.328, 'text': "So it shows you exactly how much you're going to sell.", 'start': 1831.727, 'duration': 2.601}, {'end': 1835.308, 'text': 'in the next year.', 'start': 1834.768, 'duration': 0.54}, {'end': 1837.99, 'text': "Again, it's predictive analytics, it's linear regression.", 'start': 1835.489, 'duration': 2.501}, {'end': 1842.513, 'text': "there's a huge amount of mathematics that goes around it, which is of course a different domain altogether,", 'start': 1837.99, 'duration': 4.523}, {'end': 1844.594, 'text': 'but then going by a simple linear regression,', 'start': 1842.513, 'duration': 2.081}, {'end': 1851.098, 'text': "where you're just trying to kind of look at past five years data and trying to plot the next year by arriving at the y-intercept and the slope,", 'start': 1844.594, 'duration': 6.504}], 'summary': 'Power bi has a predictive feature using linear regression to forecast sales for the next year.', 'duration': 26.234, 'max_score': 1824.864, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1824864.jpg'}, {'end': 1937.351, 'src': 'embed', 'start': 1908.255, 'weight': 4, 'content': [{'end': 1909.396, 'text': 'You have to create a user account.', 'start': 1908.255, 'duration': 1.141}, {'end': 1912.859, 'text': "You can see that when I go to powerbi.microsoft.com, it's basically changed.", 'start': 1909.416, 'duration': 3.443}, {'end': 1915.941, 'text': "You can see app.powerbi.com, and now it's powerbi.microsoft.com.", 'start': 1912.879, 'duration': 3.062}, {'end': 1917.483, 'text': 'It takes you to the default link.', 'start': 1916.362, 'duration': 1.121}, {'end': 1922.847, 'text': "Click on sign in, and when you try to sign in, it'll ask you for your credentials, right?", 'start': 1917.663, 'duration': 5.184}, {'end': 1926.287, 'text': "or if you don't have it, then you can enter your work email address.", 'start': 1923.246, 'duration': 3.041}, {'end': 1930.869, 'text': 'So make sure, this is very important, you can only do it using your work email address.', 'start': 1926.307, 'duration': 4.562}, {'end': 1937.351, 'text': "It will not allow you to enter a Gmail address or an Outlook or a Hotmail or a Yahoo, that won't allow.", 'start': 1931.949, 'duration': 5.402}], 'summary': 'Creating a user account on powerbi.microsoft.com requires using a work email address, not allowing gmail, outlook, hotmail, or yahoo addresses.', 'duration': 29.096, 'max_score': 1908.255, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1908255.jpg'}, {'end': 2037.125, 'src': 'embed', 'start': 2006.661, 'weight': 5, 'content': [{'end': 2008.081, 'text': "That's my Power BI desktop client tool.", 'start': 2006.661, 'duration': 1.42}, {'end': 2011.984, 'text': 'After you develop that report, you upload that onto the Power BI service.', 'start': 2008.382, 'duration': 3.602}, {'end': 2015.206, 'text': "I'll probably give the implication of a cloud as a Power BI service.", 'start': 2012.364, 'duration': 2.842}, {'end': 2020.952, 'text': 'in the cloud and it is from that service that your dashboard is accessible to all the end users.', 'start': 2016.026, 'duration': 4.926}, {'end': 2025.377, 'text': 'Now those end users can view your dashboard in different ways.', 'start': 2021.853, 'duration': 3.524}, {'end': 2031.983, 'text': 'So they can either view your dashboard in a mobile device, or they can view your dashboard in a browser or whichever way they want to,', 'start': 2025.858, 'duration': 6.125}, {'end': 2032.484, 'text': 'they can view it.', 'start': 2031.983, 'duration': 0.501}, {'end': 2037.125, 'text': 'But broadly, the idea is that you have the Power BI desktop and you have the Power BI service.', 'start': 2032.844, 'duration': 4.281}], 'summary': 'Power bi desktop tool connects to cloud service for dashboard access.', 'duration': 30.464, 'max_score': 2006.661, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2006661.jpg'}, {'end': 2231.549, 'src': 'embed', 'start': 2206.058, 'weight': 6, 'content': [{'end': 2211.419, 'text': "You need a dedicated service, you need to control security, you need to own everything, but that's not the case in a cloud service.", 'start': 2206.058, 'duration': 5.361}, {'end': 2218.723, 'text': "So you don't own the cloud, Microsoft owns the cloud, and Microsoft has access to your data, and that really makes people nervous.", 'start': 2212.259, 'duration': 6.464}, {'end': 2228.048, 'text': "All right, so that's a very broad overview of the very basic component of Power BI, the Power BI desktop and the Power BI service.", 'start': 2219.663, 'duration': 8.385}, {'end': 2231.549, 'text': 'So to answer your question Vamshi, absolutely you can.', 'start': 2229.148, 'duration': 2.401}], 'summary': 'Cloud services lack control and ownership, causing security concerns. power bi offers comprehensive components.', 'duration': 25.491, 'max_score': 2206.058, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2206058.jpg'}, {'end': 2290.34, 'src': 'embed', 'start': 2263.538, 'weight': 7, 'content': [{'end': 2267.041, 'text': 'You click on this downloads button and you can get your Power BI desktop from here.', 'start': 2263.538, 'duration': 3.503}, {'end': 2268.783, 'text': 'So these are all free downloads.', 'start': 2267.502, 'duration': 1.281}, {'end': 2271.605, 'text': 'Once you have the service up, you can basically download this stuff for free.', 'start': 2268.843, 'duration': 2.762}, {'end': 2277.37, 'text': 'So just to briefly talk about a few of these components, so one is of course you have the Power BI desktop, which is the client tool.', 'start': 2272.085, 'duration': 5.285}, {'end': 2282.174, 'text': 'Data gateway is basically used for refreshes, scheduled refreshes.', 'start': 2277.91, 'duration': 4.264}, {'end': 2284.576, 'text': "Let's say you're connecting to an on-premise SQL server.", 'start': 2282.194, 'duration': 2.382}, {'end': 2290.34, 'text': 'Power BI, one of the great features of Power BI is it can be used to connect to a whole variety of sources.', 'start': 2284.936, 'duration': 5.404}], 'summary': 'Free downloads available for power bi desktop and data gateway. can connect to a variety of sources.', 'duration': 26.802, 'max_score': 2263.538, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2263538.jpg'}, {'end': 2417.58, 'src': 'embed', 'start': 2390.004, 'weight': 8, 'content': [{'end': 2394.025, 'text': 'When you build some reports, you will see an option where you see publish to Power BI.', 'start': 2390.004, 'duration': 4.021}, {'end': 2395.166, 'text': 'This is basically what it means.', 'start': 2394.065, 'duration': 1.101}, {'end': 2399.047, 'text': 'You can directly upload Power BI to Power BI from Excel.', 'start': 2395.306, 'duration': 3.741}, {'end': 2403.85, 'text': 'and which is where Microsoft is trying to really close the gap between Power BI and Excel.', 'start': 2399.867, 'duration': 3.983}, {'end': 2409.434, 'text': 'So, for instance, you can bring Excel dashboards to Power BI and Power BI dashboards to Excel,', 'start': 2404.31, 'duration': 5.124}, {'end': 2413.217, 'text': 'and eventually the big picture will be to make them one and the same product.', 'start': 2409.434, 'duration': 3.783}, {'end': 2417.58, 'text': "That's some of the things that I want to talk about at a very high level.", 'start': 2414.978, 'duration': 2.602}], 'summary': 'Microsoft aims to integrate power bi and excel, enabling direct upload and dashboard interchangeability.', 'duration': 27.576, 'max_score': 2390.004, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2390004.jpg'}], 'start': 1289.739, 'title': "Power bi's capabilities and market leadership", 'summary': "Discusses tableau's market leadership, power bi and tableau's capabilities, power bi's historical evolution, and its limited etl capabilities. it also covers power bi's facilitation of machine learning, its cloud-based nature, and components like power bi desktop, service, and related features.", 'chapters': [{'end': 1775.653, 'start': 1289.739, 'title': 'Power bi vs tableau: market leader and capabilities', 'summary': 'Discusses the market leadership of tableau in the bi space, the capabilities of power bi and tableau, and the historical evolution of power bi where it started as excel add-ins before being incorporated into the power bi desktop. it also highlights the limited etl capabilities of both power bi and tableau and the potential for self-service bi to make bi accessible to a broader range of users.', 'duration': 485.914, 'highlights': ['Tableau is the market leader in BI, followed by Power BI which is catching up fast. Tableau is clearly the market leader in the BI space, with Power BI catching up fast according to the Gartner survey.', "Power BI started as Excel add-ins before being incorporated into the Power BI Desktop in 2014. Power BI's historical evolution started as Excel add-ins, and in 2014, Microsoft incorporated these add-ins into one product called the Power BI Desktop.", 'Limited ETL capabilities in Power BI and Tableau with a heavy dependence on tools like Informatica and MSBI for ETL. Both Power BI and Tableau have limited ETL capabilities, leading to a heavy dependence on tools like Informatica and MSBI for ETL processes.', 'Self-service BI makes BI accessible to everyone, not just those from a traditional BI background. The potential of self-service BI is highlighted as it makes BI accessible to a broader range of users, not limited to those from a traditional BI background.']}, {'end': 1967.975, 'start': 1776.774, 'title': 'Power bi and machine learning', 'summary': 'Discusses how power bi facilitates machine learning, particularly demonstrating linear regression, predictive analytics, and the power bi mobile feature, as well as the process of accessing the power bi service and creating a user account for it.', 'duration': 191.201, 'highlights': ['Power BI enables easy machine learning capabilities such as linear regression, which allows predicting future sales based on past data without the need for coding.', 'The Power BI mobile feature allows users to build a dashboard in Power BI desktop and upload it to the Power BI service for accessibility on app.powerbi.com.', 'Accessing the Power BI service requires creating a user account using a work email address or an educational institution email, as it is specifically accessible only for organizations and educational institutions.']}, {'end': 2426.067, 'start': 1968.235, 'title': 'Overview of power bi desktop and service', 'summary': 'Provides an overview of power bi, emphasizing its cloud-based nature, the distinction from on-premise reporting tools, and limitations such as data security concerns. it also highlights the components of power bi, including power bi desktop, power bi service, and related features like data gateway and power bi for mobile.', 'duration': 457.832, 'highlights': ['Power BI is a cloud-based service, where reports are developed in Power BI Desktop and uploaded to the Power BI service in the Azure cloud for end user access, and it lacks an on-premise setup, presenting a limitation for organizations. Reports are developed in Power BI Desktop, then uploaded to the cloud-based Power BI service in the Azure cloud, which is accessible to end users. This lack of an on-premise setup is a limitation compared to other reporting tools.', 'The cloud-based nature of Power BI raises data security concerns, as organizations do not have control over the cloud infrastructure, and scheduled refreshes using Data Gateway are required for on-premise data sources. The cloud-based setup raises data security concerns, as organizations lack control over the cloud infrastructure. Scheduled refreshes using Data Gateway are necessary for on-premise data sources.', 'Power BI includes components such as Power BI Desktop for report development, Data Gateway for scheduled refreshes, and Power BI for mobile, offering a wide range of data connections including on-premise, SaaS, and Azure cloud sources. Power BI encompasses components like Power BI Desktop for report development, Data Gateway for scheduled refreshes, and Power BI for mobile. It supports various data connections, including on-premise, SaaS, and Azure cloud sources.', 'Power BI also integrates closely with Excel, allowing users to publish reports directly to Power BI from Excel and indicating a future convergence of the two products. Power BI offers close integration with Excel, enabling direct publishing of reports to Power BI from Excel, hinting at a potential convergence of the two products.']}], 'duration': 1136.328, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY1289739.jpg', 'highlights': ['Tableau is the market leader in BI, followed by Power BI which is catching up fast.', 'Power BI started as Excel add-ins before being incorporated into the Power BI Desktop in 2014.', 'Self-service BI makes BI accessible to everyone, not just those from a traditional BI background.', 'Power BI enables easy machine learning capabilities such as linear regression, allowing prediction of future sales based on past data without coding.', 'Accessing the Power BI service requires creating a user account using a work email address or an educational institution email.', 'Reports are developed in Power BI Desktop, then uploaded to the cloud-based Power BI service in the Azure cloud, which is accessible to end users.', 'The cloud-based nature of Power BI raises data security concerns, as organizations lack control over the cloud infrastructure.', 'Power BI encompasses components like Power BI Desktop for report development, Data Gateway for scheduled refreshes, and Power BI for mobile, supporting various data connections.', 'Power BI also integrates closely with Excel, allowing users to publish reports directly to Power BI from Excel.']}, {'end': 3363.301, 'segs': [{'end': 2448.423, 'src': 'embed', 'start': 2426.087, 'weight': 0, 'content': [{'end': 2433.873, 'text': "So obviously the lower upfront cost and one of the reasons why we say lower upfront cost is because you're not really investing in a complete setup.", 'start': 2426.087, 'duration': 7.786}, {'end': 2440.897, 'text': "All that you're paying for is a very nominal fee per month because you're just using the service on the cloud.", 'start': 2434.253, 'duration': 6.644}, {'end': 2444.24, 'text': "You're not really paying anything for the additional software.", 'start': 2440.958, 'duration': 3.282}, {'end': 2446.701, 'text': "And the reason is because it's a cloud service.", 'start': 2445.04, 'duration': 1.661}, {'end': 2448.423, 'text': "It's a cloud service.", 'start': 2447.522, 'duration': 0.901}], 'summary': 'Cloud service offers lower upfront cost, minimal investment in setup, and nominal monthly fee.', 'duration': 22.336, 'max_score': 2426.087, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2426087.jpg'}, {'end': 2496.181, 'src': 'embed', 'start': 2468.374, 'weight': 1, 'content': [{'end': 2471.715, 'text': 'So all you pay for is that, you pay a very nominal fee.', 'start': 2468.374, 'duration': 3.341}, {'end': 2475.396, 'text': 'I think the fee right now, it stands at $9 per user per month.', 'start': 2471.935, 'duration': 3.461}, {'end': 2481.678, 'text': "I think $9.99 per user per month, that's all you pay for getting a full license on the cloud.", 'start': 2476.096, 'duration': 5.582}, {'end': 2485.119, 'text': 'So can Power BI connect to Redshift? Absolutely yes, it can.', 'start': 2482.238, 'duration': 2.881}, {'end': 2490.261, 'text': "And I'm gonna just give you a brief idea in just in a while what the capabilities and what kind of stuff you can connect to.", 'start': 2485.359, 'duration': 4.902}, {'end': 2496.181, 'text': 'APIs for integration, I touched upon this, customization, and user-friendly, very, very user-friendly indeed.', 'start': 2491.198, 'duration': 4.983}], 'summary': 'Users pay a nominal fee of $9 per user per month for a full license on the cloud, with power bi able to connect to redshift and offering user-friendly features.', 'duration': 27.807, 'max_score': 2468.374, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2468374.jpg'}, {'end': 2555.354, 'src': 'embed', 'start': 2522.074, 'weight': 2, 'content': [{'end': 2527.356, 'text': 'So you can directly from within Cortana you can query stuff like okay, what was the sales for the past 10 days?', 'start': 2522.074, 'duration': 5.282}, {'end': 2531.018, 'text': 'I mean it literally very, very cool stuff you can do with Cortana there.', 'start': 2527.856, 'duration': 3.162}, {'end': 2532.238, 'text': 'Job trends.', 'start': 2531.698, 'duration': 0.54}, {'end': 2534.34, 'text': 'I already talked about.', 'start': 2532.238, 'duration': 2.102}, {'end': 2537.022, 'text': 'the future of Power BI is very, very bright right now.', 'start': 2534.34, 'duration': 2.682}, {'end': 2544.447, 'text': "especially, it has picked up a lot, so needless to say that it's an extremely, extremely high in demand tool in the job market today.", 'start': 2537.022, 'duration': 7.425}, {'end': 2546.308, 'text': "We've talked about this in general.", 'start': 2544.927, 'duration': 1.381}, {'end': 2553.713, 'text': "I think there's this basic visualization concepts, so aggregating data, visualizing data, sharing data, which is the Power BI service component,", 'start': 2546.308, 'duration': 7.405}, {'end': 2555.354, 'text': 'and analyzing data, which is again so.', 'start': 2553.713, 'duration': 1.641}], 'summary': 'Cortana allows querying sales data and power bi is highly in demand.', 'duration': 33.28, 'max_score': 2522.074, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2522074.jpg'}, {'end': 2636.323, 'src': 'embed', 'start': 2607.98, 'weight': 6, 'content': [{'end': 2613.745, 'text': 'This comes from the history of Power BI, basically, where these are all Excel components, Power Query, Power Pivot, Power View, and Power Map.', 'start': 2607.98, 'duration': 5.765}, {'end': 2615.287, 'text': 'By the way, Power Query.', 'start': 2614.106, 'duration': 1.181}, {'end': 2621.253, 'text': "I do want to mention one thing, that it's a very, very powerful language that it uses behind the scenes, and it's called the mQuery language.", 'start': 2615.287, 'duration': 5.966}, {'end': 2626.576, 'text': 'Okay, so M, as in Mumbai M, if we call it the M query language.', 'start': 2621.813, 'duration': 4.763}, {'end': 2627.497, 'text': "now, That's all that they call.", 'start': 2626.576, 'duration': 0.921}, {'end': 2629.118, 'text': "it is no, there's no full form for it.", 'start': 2627.497, 'duration': 1.621}, {'end': 2636.323, 'text': "Okay, and it's a very, very powerful query query language that Microsoft has to query and transform a lot of these data sources.", 'start': 2629.118, 'duration': 7.205}], 'summary': 'Power bi components are excel-based, including power query, power pivot, power view, and power map, utilizing the powerful m query language for querying and transforming data sources.', 'duration': 28.343, 'max_score': 2607.98, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2607980.jpg'}, {'end': 2689.923, 'src': 'embed', 'start': 2662.556, 'weight': 4, 'content': [{'end': 2668.918, 'text': 'So in that way, it is still a pretty, pretty good ETL tool, okay? Power BI service, Power BI Q&A.', 'start': 2662.556, 'duration': 6.362}, {'end': 2670.959, 'text': 'Power BI Q&A is a very, very good feature.', 'start': 2668.938, 'duration': 2.021}, {'end': 2671.879, 'text': "I'll show this to you again.", 'start': 2670.979, 'duration': 0.9}, {'end': 2678.28, 'text': 'So what happens is it uses natural language query, generate information about your data.', 'start': 2672.159, 'duration': 6.121}, {'end': 2683.961, 'text': 'So you can probably upload a data set into Power BI and you can ask questions like what are my sales for the past 10 months?', 'start': 2678.3, 'duration': 5.661}, {'end': 2685.722, 'text': 'And Power BI will automatically give you a report.', 'start': 2684.001, 'duration': 1.721}, {'end': 2689.923, 'text': 'Just imagine how powerful and how machine learning is working there.', 'start': 2685.882, 'duration': 4.041}], 'summary': 'Power bi has a strong etl tool, featuring a powerful q&a using natural language queries for generating data insights.', 'duration': 27.367, 'max_score': 2662.556, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2662556.jpg'}, {'end': 2877.525, 'src': 'embed', 'start': 2848.589, 'weight': 5, 'content': [{'end': 2853.232, 'text': "The first view of your Power BI desktop, you can see there's this huge collection of sources you can connect to.", 'start': 2848.589, 'duration': 4.643}, {'end': 2859.515, 'text': 'The files, all the different kinds of files, databases, Azure, online services.', 'start': 2853.872, 'duration': 5.643}, {'end': 2863.497, 'text': 'these are some of the SaaS services that you have Salesforce, Google Analytics, Facebook data.', 'start': 2859.515, 'duration': 3.982}, {'end': 2869.16, 'text': 'You can basically, if you know your Facebook ID, just put in your credentials and you can analyze your Facebook data.', 'start': 2863.797, 'duration': 5.363}, {'end': 2872.142, 'text': 'Twitter data is also there, and a lot of stuff you can do here.', 'start': 2869.68, 'duration': 2.462}, {'end': 2877.525, 'text': "So Google Analytics, let's say you have a Facebook page and you want to analyze how many hits and stuff happened.", 'start': 2873.242, 'duration': 4.283}], 'summary': 'Power bi desktop offers a wide range of sources, including facebook, google analytics, and twitter data for analysis.', 'duration': 28.936, 'max_score': 2848.589, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2848589.jpg'}, {'end': 2962.455, 'src': 'embed', 'start': 2934.593, 'weight': 8, 'content': [{'end': 2941.077, 'text': "So these are dashboards along with data sets that someone has configured for us, and all that we are doing is we're just connecting to that stuff.", 'start': 2934.593, 'duration': 6.484}, {'end': 2944.399, 'text': "And I just wanted to show you, you can see there's so much, there's so much.", 'start': 2941.477, 'duration': 2.922}, {'end': 2947.681, 'text': "So Power BI Desktop, you're trying to do it from Power BI Desktop, the options are limited.", 'start': 2944.419, 'duration': 3.262}, {'end': 2950.823, 'text': 'You still have some of the same information here, but then the options are pretty limited here.', 'start': 2947.701, 'duration': 3.122}, {'end': 2956.388, 'text': 'But then if you try to do it from the online service, from the online service you have a lot more different options.', 'start': 2951.263, 'duration': 5.125}, {'end': 2962.455, 'text': "I wanted to give you a quick example just to, so far we've been discussing and talking and talking, but then just wanted to show you something.", 'start': 2957.169, 'duration': 5.286}], 'summary': 'Comparing options for data visualization, limited in desktop, more in online service.', 'duration': 27.862, 'max_score': 2934.593, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2934593.jpg'}, {'end': 2990.873, 'src': 'embed', 'start': 2962.815, 'weight': 9, 'content': [{'end': 2965.678, 'text': 'Wanted to click on Bing and wanted to show you something really cool here.', 'start': 2962.815, 'duration': 2.863}, {'end': 2973.186, 'text': 'So Bing, when you click on get now, so what we did here was we went to services and whatever you want, you can just click on get now.', 'start': 2966.199, 'duration': 6.987}, {'end': 2975.728, 'text': 'So let me go to Bing here real quick.', 'start': 2974.207, 'duration': 1.521}, {'end': 2978.249, 'text': 'On demand analytics of internet search activity.', 'start': 2976.028, 'duration': 2.221}, {'end': 2981.81, 'text': 'Really cool stuff, and maybe you want to look up something.', 'start': 2978.869, 'duration': 2.941}, {'end': 2984.131, 'text': "I mean, I don't know, you might want to look up something.", 'start': 2982.01, 'duration': 2.121}, {'end': 2985.251, 'text': 'Maybe you want to look up Microsoft.', 'start': 2984.171, 'duration': 1.08}, {'end': 2988.532, 'text': 'You might want to know how many people search for Microsoft across the globe.', 'start': 2985.571, 'duration': 2.961}, {'end': 2990.873, 'text': 'And some really cool analytics can come up.', 'start': 2989.033, 'duration': 1.84}], 'summary': 'Bing offers on-demand analytics for internet search activity, including global search data for microsoft.', 'duration': 28.058, 'max_score': 2962.815, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2962815.jpg'}, {'end': 3104.252, 'src': 'embed', 'start': 3075.015, 'weight': 10, 'content': [{'end': 3079.598, 'text': "and let's quickly come back to the and this is what I wanted to show you basically in Power BI,", 'start': 3075.015, 'duration': 4.583}, {'end': 3083.8, 'text': 'and just open up the desktop here and you can see the three tabs, mainly the three components.', 'start': 3079.598, 'duration': 4.202}, {'end': 3085.521, 'text': 'So first is your data pane.', 'start': 3083.84, 'duration': 1.681}, {'end': 3090.184, 'text': 'is the data pane, second is the relationships pane, and the third is your report pane.', 'start': 3086.121, 'duration': 4.063}, {'end': 3096.848, 'text': "And again, it might be a little confusing for all of you initially, especially if you're starting out to understand what is a desktop,", 'start': 3090.464, 'duration': 6.384}, {'end': 3097.648, 'text': 'what is a service.', 'start': 3096.848, 'duration': 0.8}, {'end': 3104.252, 'text': 'I understand it might be a little confusing, but just remember that desktop is where you do your heavy lifting.', 'start': 3097.648, 'duration': 6.604}], 'summary': 'Power bi has three main components: data pane, relationships pane, and report pane, with the desktop being where heavy lifting is done.', 'duration': 29.237, 'max_score': 3075.015, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3075015.jpg'}, {'end': 3228.971, 'src': 'embed', 'start': 3198.3, 'weight': 11, 'content': [{'end': 3201.923, 'text': "Can we have self-service ETL? Well, it's already there in the market.", 'start': 3198.3, 'duration': 3.623}, {'end': 3204.325, 'text': "I don't know how many of you have heard about the tool called Alterix.", 'start': 3201.963, 'duration': 2.362}, {'end': 3208.008, 'text': 'Alterix is a very, very powerful ETL tool, by the way.', 'start': 3205.105, 'duration': 2.903}, {'end': 3211.431, 'text': 'I mean, just incredible in terms of its capabilities.', 'start': 3208.068, 'duration': 3.363}, {'end': 3216.856, 'text': "And I don't think, from my understanding, from my experience, I don't think there's any competition to Alterix in today's market right now.", 'start': 3211.471, 'duration': 5.385}, {'end': 3224.025, 'text': 'The adoption is very less, the adoption is very less, but then Alteryx is indeed an amazing tool, an amazing tool, yeah.', 'start': 3217.757, 'duration': 6.268}, {'end': 3228.971, 'text': 'I mean, I would definitely recommend you guys to, I mean, if you can learn it, wonderful.', 'start': 3224.666, 'duration': 4.305}], 'summary': 'Alteryx is a powerful etl tool with unmatched capabilities and minimal market competition, despite low adoption.', 'duration': 30.671, 'max_score': 3198.3, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3198300.jpg'}, {'end': 3355.836, 'src': 'embed', 'start': 3323.543, 'weight': 12, 'content': [{'end': 3325.244, 'text': 'they are basically part of the MSBI stable.', 'start': 3323.543, 'duration': 1.701}, {'end': 3330.527, 'text': "But then Power BI is a very different, it's part of the Microsoft stack, of course.", 'start': 3325.744, 'duration': 4.783}, {'end': 3335.871, 'text': "I mean, it's part of the Microsoft stack of BI tools, but then it's not really an extension of MSBI.", 'start': 3330.547, 'duration': 5.324}, {'end': 3336.891, 'text': "I won't really say that.", 'start': 3336.131, 'duration': 0.76}, {'end': 3345.489, 'text': "It's not really an extension of MSBI by any means, because here the 2016 version of a SQL Server that got released, few months back.", 'start': 3337.692, 'duration': 7.797}, {'end': 3349.712, 'text': "I don't know how many of you follow SQL Server deeply, but it's an amazing product.", 'start': 3345.509, 'duration': 4.203}, {'end': 3355.836, 'text': 'I mean if you have seen SSRS, if you have worked in SQL Server reporting services before, the capabilities that SQL Server 2016,', 'start': 3349.732, 'duration': 6.104}], 'summary': "Power bi is part of microsoft's bi stack, separate from msbi. sql server 2016 has impressive capabilities.", 'duration': 32.293, 'max_score': 3323.543, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3323543.jpg'}], 'start': 2426.087, 'title': 'Benefits of power bi and cloud services', 'summary': 'Discusses the cost benefits of using cloud services, specifically highlighting the lower upfront cost and the $9.99 per user per month for a full license on azure cloud, and the ability of power bi to connect to redshift. it also highlights the user-friendly and high demand nature of power bi, emphasizing its integration with cortana for querying and its ability to connect to various data sources. additionally, it introduces the transition from excel components to power bi desktop, showcasing the wide variety of data sources available and compares power bi with alteryx, emphasizing its self-service etl capabilities and unique position within the microsoft bi stack.', 'chapters': [{'end': 2485.119, 'start': 2426.087, 'title': 'Benefits of cloud services', 'summary': 'Discusses the cost benefits of using cloud services, specifically highlighting the lower upfront cost and the nominal fee of $9.99 per user per month for a full license on azure cloud, and the ability of power bi to connect to redshift.', 'duration': 59.032, 'highlights': ["Microsoft's Azure cloud offers a lower upfront cost, with a nominal fee of $9.99 per user per month for a full license.", 'Users do not need to invest in a complete server setup or a management team, as Microsoft maintains the Azure cloud.', 'Power BI can connect to Redshift, providing flexibility and compatibility with other services.']}, {'end': 2781.867, 'start': 2485.359, 'title': 'Power bi capabilities and features', 'summary': 'Highlights the user-friendly and high demand nature of power bi, emphasizing its integration with cortana for querying and its ability to connect to various data sources, with a focus on its powerful q&a feature and its capability to connect to saas and on-premise data sources.', 'duration': 296.508, 'highlights': ['Power BI is extremely high in demand in the job market today. Power BI is emphasized as being extremely high in demand in the job market.', 'Integration with Cortana allows users to query data directly through Cortana, making it a very user-friendly feature. Highlighting the user-friendly nature of Power BI through its integration with Cortana for querying.', 'The Q&A feature in Power BI uses natural language queries to generate reports and has a close integration with Azure. Emphasizing the powerful Q&A feature in Power BI that uses natural language queries and its integration with Azure.', "Power BI can connect to various data sources including SaaS solutions and on-premise sources, with the ability to provide real-time dashboard updates. Highlighting Power BI's capability to connect to various data sources, including SaaS and on-premise, and its ability to provide real-time dashboard updates.", "Power BI's Power Query uses a very powerful mQuery language for querying and transforming data sources, providing extensive ETL capabilities. Emphasizing the powerful mQuery language used by Power Query and its extensive ETL capabilities, highlighting its comparison with other ETL tools."]}, {'end': 3056.663, 'start': 2783.117, 'title': 'Power bi desktop overview', 'summary': 'Introduces the transition from excel components to power bi desktop, showcasing the wide variety of data sources available, including facebook, twitter, google analytics, and bing, allowing for quick and easy dashboard creation and analytics.', 'duration': 273.546, 'highlights': ['Power BI Desktop offers a wide variety of data sources including Facebook, Twitter, Google Analytics, and Bing, enabling quick dashboard creation and analytics. The Power BI Desktop provides access to a wide range of data sources such as Facebook, Twitter, Google Analytics, and Bing, allowing users to create dashboards and perform analytics efficiently.', 'Power BI Desktop enables quick and easy dashboard creation and analytics, with pre-built dashboards available for various services and the ability to connect to content packs from the online service. Users can easily create dashboards and perform analytics using pre-built dashboards for various services and connect to content packs from the online service, offering a seamless experience for data analysis.', 'Bing integration in Power BI Desktop allows for on-demand analytics of internet search activity, providing pre-built dashboards for specific search terms and displaying insights such as top languages used and geographic search patterns. The Bing integration in Power BI Desktop allows users to perform on-demand analytics of internet search activity, generating pre-built dashboards for specific search terms and displaying insights such as top languages used and geographic search patterns.']}, {'end': 3363.301, 'start': 3059.087, 'title': 'Power bi overview and comparison with alteryx', 'summary': 'Provides an overview of power bi, detailing its key components, desktop and service, and compares it with alteryx, highlighting its self-service etl capabilities and recommending it as a powerful tool. it also distinguishes power bi from microsoft bi, emphasizing its unique position within the microsoft bi stack.', 'duration': 304.214, 'highlights': ['Power BI components: The chapter explains the three main components of Power BI - data pane for extraction and transformation, relationships pane for modeling, and report pane for visualizations, emphasizing the distinction between desktop and service for heavy development and lightweight capabilities.', 'Comparison with Alteryx: The speaker distinguishes Alteryx as a powerful self-service ETL tool, recommending it for its capabilities in developing workflows and highlighting its superiority in the market with limited competition.', 'Distinguishing Power BI from Microsoft BI: The chapter clarifies that Power BI, while part of the Microsoft BI stack, is not an extension of MSBI, emphasizing its uniqueness and the advanced capabilities of SQL Server 2016.']}], 'duration': 937.214, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY2426087.jpg', 'highlights': ["Microsoft's Azure cloud offers a lower upfront cost, with a nominal fee of $9.99 per user per month for a full license.", 'Power BI can connect to Redshift, providing flexibility and compatibility with other services.', 'Power BI is extremely high in demand in the job market today.', 'Integration with Cortana allows users to query data directly through Cortana, making it a very user-friendly feature.', 'The Q&A feature in Power BI uses natural language queries to generate reports and has a close integration with Azure.', 'Power BI can connect to various data sources including SaaS solutions and on-premise sources, with the ability to provide real-time dashboard updates.', "Power BI's Power Query uses a very powerful mQuery language for querying and transforming data sources, providing extensive ETL capabilities.", 'Power BI Desktop offers a wide variety of data sources including Facebook, Twitter, Google Analytics, and Bing, enabling quick dashboard creation and analytics.', 'Power BI Desktop enables quick and easy dashboard creation and analytics, with pre-built dashboards available for various services and the ability to connect to content packs from the online service.', 'Bing integration in Power BI Desktop allows for on-demand analytics of internet search activity, providing pre-built dashboards for specific search terms and displaying insights such as top languages used and geographic search patterns.', 'The chapter explains the three main components of Power BI - data pane for extraction and transformation, relationships pane for modeling, and report pane for visualizations, emphasizing the distinction between desktop and service for heavy development and lightweight capabilities.', 'The speaker distinguishes Alteryx as a powerful self-service ETL tool, recommending it for its capabilities in developing workflows and highlighting its superiority in the market with limited competition.', 'The chapter clarifies that Power BI, while part of the Microsoft BI stack, is not an extension of MSBI, emphasizing its uniqueness and the advanced capabilities of SQL Server 2016.']}, {'end': 4054.361, 'segs': [{'end': 3389.952, 'src': 'embed', 'start': 3363.301, 'weight': 0, 'content': [{'end': 3370.806, 'text': 'Microsoft acquired Data Zen a few years back and a lot of capabilities of Data Zen that have come into SSRS product in the 2016 release.', 'start': 3363.301, 'duration': 7.505}, {'end': 3373.428, 'text': 'So in that way, they are separate products.', 'start': 3371.207, 'duration': 2.221}, {'end': 3377.31, 'text': "I mean, please understand, SSRS, It's from a very different kind of mindset.", 'start': 3373.468, 'duration': 3.842}, {'end': 3378.91, 'text': "It's tabular reporting.", 'start': 3377.91, 'duration': 1}, {'end': 3384.531, 'text': "It's more like reporting from a very reporting standpoint, not from a very exploratory standpoint.", 'start': 3379.43, 'duration': 5.101}, {'end': 3389.952, 'text': "but then, when it comes to Power BI, it's where we come to data from a very exploratory standpoint, especially analytics.", 'start': 3384.531, 'duration': 5.421}], 'summary': 'Microsoft acquired data zen, integrating its capabilities into ssrs 2016 release, emphasizing separate tabular reporting for ssrs and exploratory analytics for power bi.', 'duration': 26.651, 'max_score': 3363.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3363301.jpg'}, {'end': 3448.274, 'src': 'embed', 'start': 3417.716, 'weight': 2, 'content': [{'end': 3421.979, 'text': "I just wanted to show you a few things, and maybe later on, if you get some time, I'll touch upon it.", 'start': 3417.716, 'duration': 4.263}, {'end': 3427.703, 'text': 'This is what I wanted to start off by saying, how to easily import data into Power BI.', 'start': 3423.22, 'duration': 4.483}, {'end': 3429.764, 'text': 'This is the GDP data that I have.', 'start': 3428.103, 'duration': 1.661}, {'end': 3434.326, 'text': 'You can see this is my country-wise, year-wise GDP data that I have.', 'start': 3429.784, 'duration': 4.542}, {'end': 3437.368, 'text': 'Very simple data set.', 'start': 3435.987, 'duration': 1.381}, {'end': 3438.949, 'text': "It's a CSV file.", 'start': 3437.528, 'duration': 1.421}, {'end': 3442.151, 'text': 'I can very easily import the data into Power BI.', 'start': 3439.389, 'duration': 2.762}, {'end': 3442.651, 'text': 'How do I do that?', 'start': 3442.191, 'duration': 0.46}, {'end': 3448.274, 'text': 'In a matter of seconds, literally in a matter of seconds, I can generate Crafts and chats from it.', 'start': 3443.431, 'duration': 4.843}], 'summary': 'Demonstrates quick import of gdp data into power bi, generating charts in seconds.', 'duration': 30.558, 'max_score': 3417.716, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3417716.jpg'}, {'end': 3486.012, 'src': 'embed', 'start': 3458.784, 'weight': 3, 'content': [{'end': 3462.507, 'text': 'you can even streamline based on file or whatever other stuff you want to connect to.', 'start': 3458.784, 'duration': 3.723}, {'end': 3464.208, 'text': "So this case and it's a text or CSV file", 'start': 3462.507, 'duration': 1.701}, {'end': 3467.651, 'text': 'Yeah, so now, when you do that, you can see them get GDP.', 'start': 3464.809, 'duration': 2.842}, {'end': 3473.128, 'text': "It's trying to establish a connection to GDP And you can see that CSV file.", 'start': 3467.651, 'duration': 5.477}, {'end': 3474.368, 'text': 'it tries to get the origin.', 'start': 3473.128, 'duration': 1.24}, {'end': 3476.449, 'text': 'it tries to set the delimiter.', 'start': 3474.368, 'duration': 2.081}, {'end': 3478.47, 'text': 'You can set a custom delimiter also.', 'start': 3476.809, 'duration': 1.661}, {'end': 3480.39, 'text': 'You can see that by default the delimiter is comma.', 'start': 3478.71, 'duration': 1.68}, {'end': 3484.872, 'text': 'If I try to set something else, you can see that the preview will not work correctly.', 'start': 3480.95, 'duration': 3.922}, {'end': 3486.012, 'text': 'You can see the delimiter is comma.', 'start': 3484.892, 'duration': 1.12}], 'summary': 'Demonstrates connecting to and setting delimiter in csv file for gdp data.', 'duration': 27.228, 'max_score': 3458.784, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3458784.jpg'}, {'end': 3514.635, 'src': 'embed', 'start': 3491.977, 'weight': 4, 'content': [{'end': 3499.923, 'text': "It's a CSV file, and the data type detection basically means that, essentially, when it imports that data into Power BI, these will all be columns.", 'start': 3491.977, 'duration': 7.946}, {'end': 3502.946, 'text': 'Country, region, year, and GDP, they will all be columns.', 'start': 3500.304, 'duration': 2.642}, {'end': 3507.81, 'text': 'So, Power BI will try to predict what is the correct data type for that column.', 'start': 3502.986, 'duration': 4.824}, {'end': 3510.012, 'text': 'So, for here, for instance, it will be text.', 'start': 3507.83, 'duration': 2.182}, {'end': 3511.493, 'text': 'Here, it will, for instance, be date.', 'start': 3510.272, 'duration': 1.221}, {'end': 3512.354, 'text': 'Here, it will be a number.', 'start': 3511.573, 'duration': 0.781}, {'end': 3514.635, 'text': 'It will be a whole number or a decimal number.', 'start': 3512.754, 'duration': 1.881}], 'summary': 'In power bi, data type detection predicts column types such as text, date, and number from a csv file.', 'duration': 22.658, 'max_score': 3491.977, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3491977.jpg'}, {'end': 3778.479, 'src': 'embed', 'start': 3746.073, 'weight': 5, 'content': [{'end': 3747.174, 'text': "It's the Power Query section.", 'start': 3746.073, 'duration': 1.101}, {'end': 3748.977, 'text': 'I talked about the mQuery language.', 'start': 3747.495, 'duration': 1.482}, {'end': 3753.703, 'text': 'If you want to add custom columns and stuff, you can, of course, add a custom column.', 'start': 3749.017, 'duration': 4.686}, {'end': 3755.846, 'text': 'This is where you write the mQuery language.', 'start': 3753.723, 'duration': 2.123}, {'end': 3759.051, 'text': 'When you say add custom column, you can see custom column formula.', 'start': 3755.966, 'duration': 3.085}, {'end': 3763.056, 'text': 'and this is where you really type in the mQuery language.', 'start': 3759.631, 'duration': 3.425}, {'end': 3770.728, 'text': "So it's a completely different language and you can do a lot of stuff, typical stuff like, if else, addition operators,", 'start': 3763.457, 'duration': 7.271}, {'end': 3773.892, 'text': 'a lot of those things are similar, but then a lot of other capabilities that you have here.', 'start': 3770.728, 'duration': 3.164}, {'end': 3778.479, 'text': "All right, so once you're done here, you can come here, you can close and apply.", 'start': 3775.697, 'duration': 2.782}], 'summary': 'Power query allows adding custom columns using mquery language, offering diverse capabilities and functions.', 'duration': 32.406, 'max_score': 3746.073, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3746073.jpg'}], 'start': 3363.301, 'title': "Microsoft's ssrs and power bi capabilities", 'summary': "Compares microsoft's ssrs with power bi, discussing data zen integration, ease of data import, csv file connection, data transformation, and query editor interface.", 'chapters': [{'end': 3458.784, 'start': 3363.301, 'title': "Microsoft's ssrs and power bi capabilities", 'summary': "Discusses the integration of data zen capabilities into microsoft's ssrs product, highlighting the fundamental differences between ssrs and power bi, and demonstrates the ease of importing and visualizing data in power bi.", 'duration': 95.483, 'highlights': ["Microsoft integrated Data Zen capabilities into SSRS product in the 2016 release. This indicates the timeline of the integration and showcases Microsoft's effort to enhance SSRS with Data Zen capabilities.", 'SSRS is focused on tabular reporting, whereas Power BI emphasizes exploratory data analysis and visualization. This highlights the fundamental differences between SSRS and Power BI, providing insight into their distinct reporting approaches.', 'Demonstrates the ease of importing CSV data into Power BI and generating charts in seconds. This showcases the efficiency of Power BI in importing and visualizing data, emphasizing its user-friendly and time-saving capabilities.']}, {'end': 4054.361, 'start': 3458.784, 'title': 'Power bi: csv file connection and data transformation', 'summary': 'Explains how to establish a connection to a csv file in power bi, including setting delimiters and predicting data types based on the first 200 rows. it also elaborates on the query editor interface, renaming columns, and applying steps for data transformation.', 'duration': 595.577, 'highlights': ['Establishing connection to CSV file and setting delimiters Demonstrates the process of establishing a connection to a CSV file in Power BI, including the ability to set custom delimiters and the impact on data preview.', 'Predicting data types based on the first 200 rows Explains how Power BI predicts the correct data types for columns, such as text, date, and number, based on the initial 200 rows of the imported data.', 'Query editor interface and data transformation capabilities Details the functionalities of the query editor interface, such as renaming columns, applying steps for data transformation, and the mQuery language for custom column addition.']}], 'duration': 691.06, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY3363301.jpg', 'highlights': ["Microsoft integrated Data Zen capabilities into SSRS product in the 2016 release. This indicates the timeline of the integration and showcases Microsoft's effort to enhance SSRS with Data Zen capabilities.", 'SSRS is focused on tabular reporting, whereas Power BI emphasizes exploratory data analysis and visualization. This highlights the fundamental differences between SSRS and Power BI, providing insight into their distinct reporting approaches.', 'Demonstrates the ease of importing CSV data into Power BI and generating charts in seconds. This showcases the efficiency of Power BI in importing and visualizing data, emphasizing its user-friendly and time-saving capabilities.', 'Establishing connection to CSV file and setting delimiters Demonstrates the process of establishing a connection to a CSV file in Power BI, including the ability to set custom delimiters and the impact on data preview.', 'Predicting data types based on the first 200 rows Explains how Power BI predicts the correct data types for columns, such as text, date, and number, based on the initial 200 rows of the imported data.', 'Query editor interface and data transformation capabilities Details the functionalities of the query editor interface, such as renaming columns, applying steps for data transformation, and the mQuery language for custom column addition.']}, {'end': 5021.913, 'segs': [{'end': 4083.758, 'src': 'embed', 'start': 4054.781, 'weight': 0, 'content': [{'end': 4058.683, 'text': 'And you can get a pretty good representation here, which all countries have performed well.', 'start': 4054.781, 'duration': 3.902}, {'end': 4064.226, 'text': 'So you can do a lot of that kind of stuff, and you can see how easy it is to build a dashboard in Power BI.', 'start': 4059.984, 'duration': 4.242}, {'end': 4069.029, 'text': "It's a very simple representation and it automatically created this map.", 'start': 4065.226, 'duration': 3.803}, {'end': 4072.211, 'text': 'If you want to change this map to something else, if you want to change it to a table,', 'start': 4069.049, 'duration': 3.162}, {'end': 4075.873, 'text': "just click on a table and it'll bring up a table for you in a matter of seconds.", 'start': 4072.211, 'duration': 3.662}, {'end': 4079.095, 'text': "In order to do anything, just click on it and it'll automatically bring it up for you.", 'start': 4076.233, 'duration': 2.862}, {'end': 4083.758, 'text': 'If you want to change the data into a matrix, you want to present it in a matrix, you might want to do that.', 'start': 4079.715, 'duration': 4.043}], 'summary': 'Power bi allows easy creation of representations like maps, tables, and matrices, offering quick and simple dashboard building.', 'duration': 28.977, 'max_score': 4054.781, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4054781.jpg'}, {'end': 4278.279, 'src': 'embed', 'start': 4246.558, 'weight': 1, 'content': [{'end': 4247.199, 'text': "It's a big value.", 'start': 4246.558, 'duration': 0.641}, {'end': 4248.399, 'text': "So it's a darker color.", 'start': 4247.579, 'duration': 0.82}, {'end': 4256.901, 'text': "You can see it's a slightly lesser value, slightly lighter color, and it's a least value, so it's the lightest color in the smallest box.", 'start': 4249.059, 'duration': 7.842}, {'end': 4258.641, 'text': "That's how a tree map represents data.", 'start': 4256.941, 'duration': 1.7}, {'end': 4260.162, 'text': 'You will see a few other icons come up.', 'start': 4258.661, 'duration': 1.501}, {'end': 4261.362, 'text': 'These are drill downs.', 'start': 4260.502, 'duration': 0.86}, {'end': 4263.443, 'text': 'It can go to the next level of hierarchy.', 'start': 4261.902, 'duration': 1.541}, {'end': 4266.784, 'text': 'If you want to go down to the country level, you can do it like this.', 'start': 4263.463, 'duration': 3.321}, {'end': 4271.965, 'text': 'If you want to go down, if you want to expand down one level in the hierarchy, you can of course go down here.', 'start': 4267.184, 'duration': 4.781}, {'end': 4278.279, 'text': 'Okay, and this is how you can turn on, drill down, and if you turn on, drill down, and when you click on Central America and Caribbean,', 'start': 4272.714, 'duration': 5.565}], 'summary': 'Tree map represents data with drill downs for hierarchy navigation.', 'duration': 31.721, 'max_score': 4246.558, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4246558.jpg'}, {'end': 4363.745, 'src': 'embed', 'start': 4335.952, 'weight': 2, 'content': [{'end': 4338.533, 'text': "And again, you can see that it's grouped by region and country.", 'start': 4335.952, 'duration': 2.581}, {'end': 4344.856, 'text': 'Just to keep things simple and not to confuse you anymore, let me just say region, and I can see a simple bar chart based on regions.', 'start': 4338.813, 'duration': 6.043}, {'end': 4348.359, 'text': 'Data labels, you want to turn it on, you can see the data labels come up.', 'start': 4345.937, 'duration': 2.422}, {'end': 4353.665, 'text': 'Formatting stuff you can change, and customizations are just incredible, the kind of stuff you can do here.', 'start': 4348.399, 'duration': 5.266}, {'end': 4359.371, 'text': 'You can of course have multiple columns here, you can of course have multiple items, so probably you can have one more.', 'start': 4354.326, 'duration': 5.045}, {'end': 4361.574, 'text': 'You can probably have a map chart.', 'start': 4359.852, 'duration': 1.722}, {'end': 4363.745, 'text': 'probably have a map chart here.', 'start': 4362.725, 'duration': 1.02}], 'summary': 'The presentation features grouped data by region and country, with customizable formatting and the option for multiple columns and map charts.', 'duration': 27.793, 'max_score': 4335.952, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4335952.jpg'}, {'end': 4576.518, 'src': 'embed', 'start': 4544.053, 'weight': 3, 'content': [{'end': 4546.995, 'text': "And now when I come back here, you can see it's publishing it to Power BI service.", 'start': 4544.053, 'duration': 2.942}, {'end': 4550.058, 'text': "It's a very, very simple workflow I wanted to show you.", 'start': 4547.936, 'duration': 2.122}, {'end': 4555.002, 'text': 'I have a few other demos and really cool demonstrations I wanted to show you on a few other capabilities.', 'start': 4550.078, 'duration': 4.924}, {'end': 4557.639, 'text': "It's taking a bit of time.", 'start': 4556.698, 'duration': 0.941}, {'end': 4561.883, 'text': 'Success, so you can directly open that in the Power BI.', 'start': 4558.82, 'duration': 3.063}, {'end': 4563.085, 'text': 'Power BI means a Power BI service.', 'start': 4562.043, 'duration': 1.042}, {'end': 4565.967, 'text': 'You can directly open that, or I have it already open.', 'start': 4563.105, 'duration': 2.862}, {'end': 4568.35, 'text': "I can simply come here and it's automatically come up.", 'start': 4566.008, 'duration': 2.342}, {'end': 4570.432, 'text': 'You can see the star icon mark beside demo one.', 'start': 4568.37, 'duration': 2.062}, {'end': 4576.518, 'text': "The star icon means that I've just recently, just very recently, this is the new data set I have here.", 'start': 4571.013, 'duration': 5.505}], 'summary': 'Demonstration of publishing to power bi service with new data set.', 'duration': 32.465, 'max_score': 4544.053, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4544053.jpg'}, {'end': 4680.453, 'src': 'embed', 'start': 4652.118, 'weight': 8, 'content': [{'end': 4657.02, 'text': "Very important to note that whenever you're using Maps, you can see Maps by default uses the Bing mapping service,", 'start': 4652.118, 'duration': 4.902}, {'end': 4658.901, 'text': "so you need to make sure that you're connected to the internet.", 'start': 4657.02, 'duration': 1.881}, {'end': 4662.123, 'text': "If you're not connected to the internet, some of these capabilities will not be there.", 'start': 4658.981, 'duration': 3.142}, {'end': 4666.185, 'text': 'You need to be connected to the internet for you to be able to use the Bing mapping service.', 'start': 4662.403, 'duration': 3.782}, {'end': 4672.267, 'text': "That's a default mapping provider for Power BI, Microsoft.", 'start': 4666.885, 'duration': 5.382}, {'end': 4674.549, 'text': "I'm sure you already know Bing is a Microsoft search engine.", 'start': 4672.588, 'duration': 1.961}, {'end': 4680.453, 'text': 'All right, so this is my reports, and the final thing that you really have is your dashboards.', 'start': 4675.649, 'duration': 4.804}], 'summary': 'Bing mapping service in power bi requires internet connection for full functionality.', 'duration': 28.335, 'max_score': 4652.118, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4652118.jpg'}, {'end': 4736.047, 'src': 'embed', 'start': 4706.852, 'weight': 9, 'content': [{'end': 4708.793, 'text': 'Reports are the individual chunks that you develop.', 'start': 4706.852, 'duration': 1.941}, {'end': 4711.374, 'text': 'It is the dashboards that you share with the users.', 'start': 4709.253, 'duration': 2.121}, {'end': 4715.835, 'text': 'So next time when you share a link with the users, that link will be for the dashboards, not the reports.', 'start': 4711.834, 'duration': 4.001}, {'end': 4718.677, 'text': 'Of course they can navigate to the reports of the dashboard.', 'start': 4716.255, 'duration': 2.422}, {'end': 4720.498, 'text': 'they can navigate to the individual report pages,', 'start': 4718.677, 'duration': 1.821}, {'end': 4727.862, 'text': 'but then the stuff that you actually build and the stuff that you actually share are your dashboards.', 'start': 4720.498, 'duration': 7.364}, {'end': 4729.343, 'text': 'And the way to do that is very simple.', 'start': 4728.022, 'duration': 1.321}, {'end': 4734.726, 'text': 'you see an option for pin visual, and when you say pin visual, it will give you an option where you want to pin it.', 'start': 4729.343, 'duration': 5.383}, {'end': 4736.047, 'text': "So I'm trying to pin this particular visual.", 'start': 4734.746, 'duration': 1.301}], 'summary': 'Reports are individual chunks, dashboards are shared with users. share dashboard links, not reports.', 'duration': 29.195, 'max_score': 4706.852, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4706852.jpg'}, {'end': 4787.868, 'src': 'embed', 'start': 4761.144, 'weight': 7, 'content': [{'end': 4767.008, 'text': "Simple enough, so you can similarly come back to the report, and if you want to pin one more visual, let's say I can pin this particular visual,", 'start': 4761.144, 'duration': 5.864}, {'end': 4767.328, 'text': "and that's it.", 'start': 4767.008, 'duration': 0.32}, {'end': 4771.03, 'text': "And this time it's an existing dashboard, click on Pin, and it is pinned.", 'start': 4767.528, 'duration': 3.502}, {'end': 4776.193, 'text': "You can go to the dashboard, and you can see it's so simple, so neat, you can arrange the tiles, it's very easy to play around with.", 'start': 4771.05, 'duration': 5.143}, {'end': 4781.417, 'text': 'You get the same kind of, come back to the dashboards again.', 'start': 4777.814, 'duration': 3.603}, {'end': 4783.784, 'text': 'A lot of default settings you can set.', 'start': 4782.383, 'duration': 1.401}, {'end': 4787.868, 'text': 'I mean by default, whenever you click on a particular report on the dashboard, it takes you to the corresponding report,', 'start': 4783.864, 'duration': 4.004}], 'summary': 'Pin visuals to existing dashboard for easy access and customization.', 'duration': 26.724, 'max_score': 4761.144, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4761144.jpg'}, {'end': 4844.97, 'src': 'embed', 'start': 4813.409, 'weight': 5, 'content': [{'end': 4817.433, 'text': "I can pin the live page and again it's gonna ask me do I want to pin it in the new dashboard??", 'start': 4813.409, 'duration': 4.024}, {'end': 4819.915, 'text': 'Absolutely yes and very, very important.', 'start': 4817.853, 'duration': 2.062}, {'end': 4824.82, 'text': 'you can see here pin live page enables changes to reports to appear in the dashboard time when the page is refreshed.', 'start': 4819.915, 'duration': 4.905}, {'end': 4827.322, 'text': 'So the auto refresh functionality is maintained.', 'start': 4824.84, 'duration': 2.482}, {'end': 4834.306, 'text': "Whenever you make any kind of refresh on your reports, So let's say I pin this to my dashboard, and then I make some changes on my reports.", 'start': 4827.362, 'duration': 6.944}, {'end': 4835.647, 'text': 'And you can absolutely do that.', 'start': 4834.566, 'duration': 1.081}, {'end': 4842.069, 'text': 'You might be wondering that okay, so all this thing I got by developing in the desktop tool and I published in the Power BI service,', 'start': 4836.127, 'duration': 5.942}, {'end': 4844.97, 'text': 'but you can actually edit your report in the service.', 'start': 4842.069, 'duration': 2.901}], 'summary': 'Pin live page enables changes in reports to appear in the dashboard upon refresh, maintaining auto refresh functionality. reports can be edited in the power bi service.', 'duration': 31.561, 'max_score': 4813.409, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4813409.jpg'}], 'start': 4054.781, 'title': 'Power bi visualizations', 'summary': 'Explains the process of creating, customizing, and publishing visualizations in power bi, showcasing the interactivity and versatility of the tool, including the ability to export data to excel and generate various charts and maps, with the option to publish the created dashboard to the power bi service.', 'chapters': [{'end': 4301.496, 'start': 4054.781, 'title': 'Power bi dashboard demo', 'summary': 'Demonstrates the ease of creating and customizing visual representations in power bi, such as maps, tables, matrices, and tree maps, with the ability to perform basic and predictive analytics, and interactive drill-down functionality.', 'duration': 246.715, 'highlights': ['The ease of creating and customizing visual representations in Power BI The demonstration showcases the simplicity of building visual representations like maps, tables, matrices, and tree maps, and the ability to perform basic and predictive analytics.', 'Interactive drill-down functionality The interactive drill-down feature allows users to navigate through hierarchical data, expand and collapse levels, and visualize data at different hierarchy levels.', 'Ability to perform basic and predictive analytics Power BI enables users to conduct basic analytics and predictive analytics, such as linear regression, on the fly.']}, {'end': 4651.538, 'start': 4301.676, 'title': 'Power bi visualizations', 'summary': 'Explains the process of creating, customizing, and publishing visualizations in power bi, showcasing the interactivity and versatility of the tool, including the ability to export data to excel and generate various charts and maps, with the option to publish the created dashboard to the power bi service.', 'duration': 349.862, 'highlights': ['The option to export data into Excel files and generate various charts and maps showcases the versatility of Power BI, providing users with diverse visualization capabilities. The transcript highlights the ability to export data into Excel files and create various charts and maps within Power BI, demonstrating its versatility in data visualization.', "The process of creating and customizing visualizations, such as bar charts, line charts, and map charts, is showcased, emphasizing the tool's interactivity and automatic data filtering based on user selections. The transcript showcases the process of creating and customizing visualizations within Power BI, including bar charts, line charts, and map charts, highlighting the tool's interactivity and automatic data filtering based on user selections.", 'Demonstration of publishing the created dashboard to the Power BI service, including saving the dashboard as a .pbix file and the simple workflow involved in publishing to the Power BI service, demonstrates the seamless transition from creation to sharing of visualizations. The transcript demonstrates the process of publishing the created dashboard to the Power BI service, including saving the dashboard as a .pbix file and the simple workflow involved in publishing, showcasing the seamless transition from creation to sharing of visualizations.']}, {'end': 5021.913, 'start': 4652.118, 'title': 'Dashboard creation in power bi', 'summary': 'Discusses the process of creating dashboards in power bi, emphasizing the importance of internet connectivity for using bing mapping service, the distinction between reports and dashboards, the process of pinning visuals to dashboards, the ability to edit reports in the service, and the maintenance of interactivity in dashboards.', 'duration': 369.795, 'highlights': ['The importance of internet connectivity for using Bing mapping service It is crucial to be connected to the internet to use the Bing mapping service as it is the default mapping provider for Power BI, and without internet connectivity, some capabilities will not be available.', 'Distinction between reports and dashboards Reports are individual chunks developed, while dashboards, which are shared with users, are built by pinning items from reports and are the primary content shared with users.', "Process of pinning visuals to dashboards Users can pin visuals from reports onto dashboards by selecting 'pin visual' and specifying whether to pin to an existing dashboard or create a new one, maintaining the simplicity and ease of arranging and adding tiles.", 'Ability to edit reports in the service Users can edit reports in the Power BI service, including changing data colors, visualizations, and toggling between reading and edit page views, providing a very intuitive and user-friendly experience.', 'Maintenance of interactivity in dashboards The process of pinning the live page to the dashboard allows changes in reports to appear in the dashboard when the page is refreshed, ensuring the maintenance of interactivity, and enabling direct editing and maintenance of interactivity within the dashboard.']}], 'duration': 967.132, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY4054781.jpg', 'highlights': ['The demonstration showcases the simplicity of building visual representations like maps, tables, matrices, and tree maps, and the ability to perform basic and predictive analytics.', 'The interactive drill-down feature allows users to navigate through hierarchical data, expand and collapse levels, and visualize data at different hierarchy levels.', "The process of creating and customizing visualizations, such as bar charts, line charts, and map charts, is showcased, emphasizing the tool's interactivity and automatic data filtering based on user selections.", 'The transcript demonstrates the process of publishing the created dashboard to the Power BI service, including saving the dashboard as a .pbix file and the simple workflow involved in publishing, showcasing the seamless transition from creation to sharing of visualizations.', 'The option to export data into Excel files and generate various charts and maps showcases the versatility of Power BI, providing users with diverse visualization capabilities.', 'Users can edit reports in the Power BI service, including changing data colors, visualizations, and toggling between reading and edit page views, providing a very intuitive and user-friendly experience.', 'The process of pinning the live page to the dashboard allows changes in reports to appear in the dashboard when the page is refreshed, ensuring the maintenance of interactivity, and enabling direct editing and maintenance of interactivity within the dashboard.', "Users can pin visuals from reports onto dashboards by selecting 'pin visual' and specifying whether to pin to an existing dashboard or create a new one, maintaining the simplicity and ease of arranging and adding tiles.", 'It is crucial to be connected to the internet to use the Bing mapping service as it is the default mapping provider for Power BI, and without internet connectivity, some capabilities will not be available.', 'Reports are individual chunks developed, while dashboards, which are shared with users, are built by pinning items from reports and are the primary content shared with users.']}, {'end': 5880.729, 'segs': [{'end': 5103.594, 'src': 'embed', 'start': 5074.321, 'weight': 0, 'content': [{'end': 5078.202, 'text': 'You can do a lot of that kind of stuff, but then Quick Insights, the really interesting thing that I wanted to show you.', 'start': 5074.321, 'duration': 3.881}, {'end': 5082.624, 'text': 'So if you know nothing about reporting, if you know nothing about visualizations, you can still come here.', 'start': 5078.502, 'duration': 4.122}, {'end': 5089.447, 'text': 'You can let Power BI figure out, through its machine learning algorithms, what is the best kind of charts and graphs to use.', 'start': 5083.224, 'duration': 6.223}, {'end': 5090.848, 'text': 'Click on View Insights.', 'start': 5089.968, 'duration': 0.88}, {'end': 5091.629, 'text': 'The insights are ready.', 'start': 5090.888, 'duration': 0.741}, {'end': 5093.75, 'text': 'It usually takes time,', 'start': 5091.909, 'duration': 1.841}, {'end': 5103.594, 'text': "but here it's taking very less time because it's a very small data set and you can see that it does a fairly neat job of showing you a lot of different charts and graphs that you might want to see.", 'start': 5093.75, 'duration': 9.844}], 'summary': "Power bi's quick insights uses machine learning to generate visualizations efficiently for small datasets.", 'duration': 29.273, 'max_score': 5074.321, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY5074321.jpg'}, {'end': 5174.185, 'src': 'embed', 'start': 5145.714, 'weight': 1, 'content': [{'end': 5147.355, 'text': 'I mean, how are you guys feeling about Power BI?', 'start': 5145.714, 'duration': 1.641}, {'end': 5149.275, 'text': "And I'm sorry if I'm really stretching the session.", 'start': 5147.775, 'duration': 1.5}, {'end': 5154.857, 'text': "I think probably we'll have another 15, 20 minutes more, 15, 20 minutes more, and we're gonna wrap up the session in a while.", 'start': 5149.315, 'duration': 5.542}, {'end': 5162.417, 'text': "Are you guys enjoying it? It's very intuitive indeed, it's absolutely very interesting, and I can assure you will love it.", 'start': 5155.257, 'duration': 7.16}, {'end': 5167.54, 'text': 'Data is something you should all learn to play with, and in the world of BI, in the world of analytics,', 'start': 5163.438, 'duration': 4.102}, {'end': 5170.002, 'text': "it is less of coding and it's more of thinking.", 'start': 5167.54, 'duration': 2.462}, {'end': 5171.043, 'text': 'You gotta think.', 'start': 5170.342, 'duration': 0.701}, {'end': 5172.804, 'text': "I'm not saying that being a coder you don't have to think.", 'start': 5171.083, 'duration': 1.721}, {'end': 5174.185, 'text': 'Of course you gotta think, everyone has to think.', 'start': 5172.844, 'duration': 1.341}], 'summary': 'Discussion about power bi, emphasizing its intuitiveness and the importance of thinking in analytics.', 'duration': 28.471, 'max_score': 5145.714, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY5145714.jpg'}, {'end': 5229.014, 'src': 'embed', 'start': 5199.785, 'weight': 2, 'content': [{'end': 5205.966, 'text': "So if you just type in here, ask a question about your data, it's another brilliant, brilliant feature of Power BI.", 'start': 5199.785, 'duration': 6.181}, {'end': 5206.846, 'text': "It's a brilliant feature.", 'start': 5206.066, 'duration': 0.78}, {'end': 5212.267, 'text': "It's something that really differentiates Power BI from the rest of the tools in the market today, the natural language feature.", 'start': 5206.906, 'duration': 5.361}, {'end': 5215.668, 'text': 'You can just query your data set using English language.', 'start': 5213.048, 'duration': 2.62}, {'end': 5221.649, 'text': 'If you have your dashboard up there and if the business person is trying to view that dashboard, he knows nothing about your data.', 'start': 5216.108, 'duration': 5.541}, {'end': 5222.59, 'text': 'you can actually come back here.', 'start': 5221.649, 'duration': 0.941}, {'end': 5223.51, 'text': 'You can start typing things.', 'start': 5222.61, 'duration': 0.9}, {'end': 5229.014, 'text': "If you just click on it, It'll give you a set of options here, what all stuff you might want to search.", 'start': 5223.89, 'duration': 5.124}], 'summary': "Power bi's natural language feature allows querying data with english, setting it apart from other tools.", 'duration': 29.229, 'max_score': 5199.785, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY5199785.jpg'}, {'end': 5746.931, 'src': 'embed', 'start': 5719.162, 'weight': 4, 'content': [{'end': 5725.237, 'text': "so go here and Now I'm in the relationships pane and you can see it has automatically formed relationships.", 'start': 5719.162, 'duration': 6.075}, {'end': 5727.438, 'text': 'I did nothing, I did nothing.', 'start': 5725.417, 'duration': 2.021}, {'end': 5729.78, 'text': 'And this is where Power BI is really intelligent.', 'start': 5727.458, 'duration': 2.322}, {'end': 5730.7, 'text': 'It figures out.', 'start': 5730, 'duration': 0.7}, {'end': 5735.864, 'text': 'it looks at columns with similar names, it looks at columns with similar names, similar types,', 'start': 5730.7, 'duration': 5.164}, {'end': 5738.565, 'text': 'similar datas and it automatically creates its relationship.', 'start': 5735.864, 'duration': 2.701}, {'end': 5739.686, 'text': "You can see it's a one to many.", 'start': 5738.585, 'duration': 1.101}, {'end': 5741.928, 'text': 'The star stands for many, and the one stands for one.', 'start': 5740.086, 'duration': 1.842}, {'end': 5746.931, 'text': 'One to many, right? So one state here relates to multiple state IDs here.', 'start': 5742.008, 'duration': 4.923}], 'summary': 'Power bi automatically forms one-to-many relationships based on similar column names, types, and data.', 'duration': 27.769, 'max_score': 5719.162, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY5719162.jpg'}], 'start': 5023.373, 'title': 'Power bi features', 'summary': 'Covers power bi quick insights demo, showcasing its ability to generate visualizations and trends in a 15-20 minute session, and explores natural language query feature converting english sentences into charts, emphasizing proper data modeling for successful report generation.', 'chapters': [{'end': 5162.417, 'start': 5023.373, 'title': 'Power bi quick insights demo', 'summary': 'Introduces the power bi quick insights feature, demonstrating its capability to generate visualizations and trends based on data, making it intuitive and interesting, with a session duration of approximately 15-20 minutes.', 'duration': 139.044, 'highlights': ['Power BI Quick Insights feature can generate visualizations and trends based on data, making it intuitive and interesting The Quick Insights feature in Power BI utilizes machine learning algorithms to generate different charts and graphs based on the dataset, providing insights on trends and fluctuations in data.', 'Session duration of approximately 15-20 minutes The session is expected to last for approximately 15-20 more minutes, indicating the remaining duration of the presentation.']}, {'end': 5880.729, 'start': 5163.438, 'title': 'Power bi: natural language query and data modeling', 'summary': 'Introduces the natural language query feature in power bi, highlighting its capability to convert english sentences into charts and graphs, and emphasizes the importance of proper data modeling for successful query execution and report generation.', 'duration': 717.291, 'highlights': ["Power BI's natural language query feature can convert English sentences into charts and graphs, providing a seamless and intuitive way to represent data. The natural language query feature in Power BI allows users to type English sentences to generate charts and graphs, providing an intuitive and seamless way to represent data.", 'Proper data modeling is crucial for successful query execution, as naming conventions and semantics play a vital role in enabling Power BI to recognize and interpret data accurately. Proper data modeling with accurate naming conventions and semantics is crucial for successful query execution in Power BI, as it enables the platform to recognize and interpret data accurately.', 'The process of configuring relationships in Power BI involves promoting the first row to headers, renaming columns, and defining relationships between different tables to enable seamless data integration and report generation. Configuring relationships in Power BI involves promoting the first row to headers, renaming columns, and defining relationships between different tables to facilitate seamless data integration and report generation.']}], 'duration': 857.356, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY5023373.jpg', 'highlights': ['Power BI Quick Insights feature utilizes machine learning algorithms to generate charts and graphs based on the dataset, providing insights on trends and fluctuations in data.', 'Session duration of approximately 15-20 minutes for the presentation.', "Power BI's natural language query feature allows users to type English sentences to generate charts and graphs, providing a seamless and intuitive way to represent data.", 'Proper data modeling with accurate naming conventions and semantics is crucial for successful query execution in Power BI, enabling the platform to recognize and interpret data accurately.', 'Configuring relationships in Power BI involves promoting the first row to headers, renaming columns, and defining relationships between different tables to facilitate seamless data integration and report generation.']}, {'end': 7068.224, 'segs': [{'end': 6096.808, 'src': 'embed', 'start': 6059.375, 'weight': 0, 'content': [{'end': 6065.861, 'text': 'Not exactly complex from that point of view, but to do the same thing in an ETL tool, like even an SSIS, you have to do a lot of steps.', 'start': 6059.375, 'duration': 6.486}, {'end': 6069.504, 'text': 'You have to do something like, you have to do a unional transformation.', 'start': 6065.881, 'duration': 3.623}, {'end': 6074.068, 'text': "So it's pretty complex that way, but it's so neat, so intuitive in Power BI.", 'start': 6070.024, 'duration': 4.044}, {'end': 6077.751, 'text': 'content consolidated and content consolidated.', 'start': 6075.609, 'duration': 2.142}, {'end': 6080.493, 'text': 'you can see Africa 59 rows.', 'start': 6077.751, 'duration': 2.742}, {'end': 6082.375, 'text': 'four rows 59 rows.', 'start': 6080.493, 'duration': 1.882}, {'end': 6085.498, 'text': 'and if you go to the content consolidated, you can see there are 269 rows.', 'start': 6082.375, 'duration': 3.123}, {'end': 6088.621, 'text': 'So indeed, all the rows have been added.', 'start': 6085.678, 'duration': 2.943}, {'end': 6093.265, 'text': "You can see, yeah? Make sense? So that's what I wanted to show you in this particular example.", 'start': 6088.641, 'duration': 4.624}, {'end': 6096.808, 'text': 'And finally, the other thing that I wanted to display here is..', 'start': 6093.846, 'duration': 2.962}], 'summary': 'Power bi simplifies etl, consolidating data intuitively. africa has 59 rows, content consolidated has 269 rows.', 'duration': 37.433, 'max_score': 6059.375, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY6059375.jpg'}, {'end': 6148.964, 'src': 'embed', 'start': 6120.44, 'weight': 2, 'content': [{'end': 6124.041, 'text': 'Of course, I can remove this particular query, and then I can remove the remaining queries.', 'start': 6120.44, 'duration': 3.601}, {'end': 6131.952, 'text': 'And the final thing I wanted to show you is another concept, a very, very neat thing that you can do in Power BI.', 'start': 6125.987, 'duration': 5.965}, {'end': 6136.716, 'text': "If you try to do the same thing using some other kind of ETL tool, it'll probably take you a long time.", 'start': 6132.392, 'duration': 4.324}, {'end': 6139.398, 'text': "I'm sure you're figuring out what this data is.", 'start': 6137.316, 'duration': 2.082}, {'end': 6141.199, 'text': 'This typical example of pivoted data.', 'start': 6139.438, 'duration': 1.761}, {'end': 6148.964, 'text': "It's pivoted data where you can see that state names are listed out in the in the left-hand side is all the US states that I have,", 'start': 6141.319, 'duration': 7.645}], 'summary': 'Demonstration of efficient data manipulation in power bi, eliminating queries and showcasing time-saving capabilities compared to other etl tools.', 'duration': 28.524, 'max_score': 6120.44, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY6120440.jpg'}, {'end': 6351.574, 'src': 'embed', 'start': 6320.658, 'weight': 3, 'content': [{'end': 6323.961, 'text': 'Even if you try to do this in SSIS or any other ETL tool, it takes a lot of time.', 'start': 6320.658, 'duration': 3.303}, {'end': 6328.545, 'text': "It takes time to configure pivot and unpivot, but then it's magically simple in Power BI.", 'start': 6324.261, 'duration': 4.284}, {'end': 6331.688, 'text': 'If you want to remove some columns, go ahead and remove your columns.', 'start': 6329.586, 'duration': 2.102}, {'end': 6335.511, 'text': "You want to remove your columns here, and that's your population data.", 'start': 6331.708, 'duration': 3.803}, {'end': 6339.362, 'text': 'And once you have this stuff, it is very simple to.', 'start': 6336.957, 'duration': 2.405}, {'end': 6341.787, 'text': "you can see all these steps that I've applied here.", 'start': 6339.362, 'duration': 2.425}, {'end': 6346.096, 'text': "it's very easy to go back and save this and generate visualizations out of this.", 'start': 6341.787, 'duration': 4.309}, {'end': 6351.574, 'text': 'Go to the reports pane, click on the name, a state name.', 'start': 6347.571, 'duration': 4.003}], 'summary': 'Power bi simplifies data manipulation and visualization, saving time and effort in comparison to ssis or other etl tools.', 'duration': 30.916, 'max_score': 6320.658, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY6320658.jpg'}, {'end': 6410.422, 'src': 'embed', 'start': 6381.911, 'weight': 4, 'content': [{'end': 6383.971, 'text': 'I have an option to give a field map which is much cooler.', 'start': 6381.911, 'duration': 2.06}, {'end': 6388.233, 'text': 'it looks better, especially if I have state data.', 'start': 6383.971, 'duration': 4.262}, {'end': 6392.095, 'text': 'a field map looks much better because it gives me all the US states listed like this.', 'start': 6388.233, 'duration': 3.862}, {'end': 6396.316, 'text': 'And now if I take population here, data has a much, much better feel.', 'start': 6392.455, 'duration': 3.861}, {'end': 6402.319, 'text': 'You can come to color saturation, and essentially you get, the larger the population, you can see the better the color.', 'start': 6396.336, 'duration': 5.983}, {'end': 6409.542, 'text': "So essentially the same number that I'm having here, so it doesn't make a lot of difference from data colors and put diverging on,", 'start': 6402.839, 'duration': 6.703}, {'end': 6410.422, 'text': 'for the maximum is green.', 'start': 6409.542, 'duration': 0.88}], 'summary': 'Field map presents us states and population data with better visualization.', 'duration': 28.511, 'max_score': 6381.911, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY6381911.jpg'}, {'end': 6448.103, 'src': 'embed', 'start': 6422.168, 'weight': 6, 'content': [{'end': 6426.831, 'text': 'Again, one final thing, probably if I have to talk about a little bit here and just to give you an idea.', 'start': 6422.168, 'duration': 4.663}, {'end': 6430.113, 'text': 'you do have the concept of slicers for filtering and stuff.', 'start': 6426.831, 'duration': 3.282}, {'end': 6433.255, 'text': 'You can put some slicers, very easy way to put filtering.', 'start': 6430.153, 'duration': 3.102}, {'end': 6434.916, 'text': 'If you want to filter based on years, you can click.', 'start': 6433.275, 'duration': 1.641}, {'end': 6440.7, 'text': 'So these are my year slicers, and if I want to filter based on only 1840, so right now I can see only 1840 data.', 'start': 6435.256, 'duration': 5.444}, {'end': 6442.561, 'text': "Let's just convert this back to..", 'start': 6441.24, 'duration': 1.321}, {'end': 6445.582, 'text': 'probably a matrix that will make more sense right now.', 'start': 6443.141, 'duration': 2.441}, {'end': 6448.103, 'text': "You can see right now I'm seeing data only for 1840.", 'start': 6445.902, 'duration': 2.201}], 'summary': 'Overview of using slicers for easy data filtering, with example of filtering data for the year 1840.', 'duration': 25.935, 'max_score': 6422.168, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY6422168.jpg'}, {'end': 6609.048, 'src': 'embed', 'start': 6578.134, 'weight': 7, 'content': [{'end': 6578.974, 'text': 'and just wanted to show you.', 'start': 6578.134, 'duration': 0.84}, {'end': 6582.297, 'text': 'See the brief description of the visual, you can download your visual.', 'start': 6579.395, 'duration': 2.902}, {'end': 6586.26, 'text': 'Of course you agree, so your visual will be downloaded in your downloads folder.', 'start': 6583.238, 'duration': 3.022}, {'end': 6592.285, 'text': 'So, once that is done, what you can do is you can obviously go to R, come here,', 'start': 6587.381, 'duration': 4.904}, {'end': 6596.729, 'text': 'you can import a custom visual and now you can take your stuff from your downloads folder.', 'start': 6592.285, 'duration': 4.444}, {'end': 6600.966, 'text': "Makes sense? It's very simple to import a visual into Power BI.", 'start': 6597.441, 'duration': 3.525}, {'end': 6609.048, 'text': 'I can take my attribute slicer, and now you can see that the visual was successfully imported.', 'start': 6604.807, 'duration': 4.241}], 'summary': 'Easily import custom visuals into power bi from downloads folder.', 'duration': 30.914, 'max_score': 6578.134, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY6578134.jpg'}, {'end': 6845.284, 'src': 'embed', 'start': 6821.351, 'weight': 8, 'content': [{'end': 6829.234, 'text': 'So what you see here are the course details of something that we are gonna cover in far more detail in our regular Power BI certification training course that we are starting from 15th of March.', 'start': 6821.351, 'duration': 7.883}, {'end': 6834.958, 'text': "I would really encourage all of you to be a part of it in case you're really interested to learn more about Power BI.", 'start': 6830.675, 'duration': 4.283}, {'end': 6839.801, 'text': "I'd really encourage you guys to be a part of it and let's meet again and let's learn together.", 'start': 6835.418, 'duration': 4.383}, {'end': 6841.502, 'text': "There's DAX.", 'start': 6840.901, 'duration': 0.601}, {'end': 6843.303, 'text': 'You can see DAX data analysis expressions.', 'start': 6841.542, 'duration': 1.761}, {'end': 6845.284, 'text': "It's a completely different language altogether.", 'start': 6843.363, 'duration': 1.921}], 'summary': 'Upcoming power bi certification course starting from 15th march, covering dax data analysis expressions.', 'duration': 23.933, 'max_score': 6821.351, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY6821351.jpg'}], 'start': 5880.729, 'title': 'Power bi functions and visuals', 'summary': 'Demonstrates data churning, querying, and manipulation in power bi, resulting in 269 rows in the final consolidated query, along with the ease of unpivoting data and the usage of custom visuals, including an upcoming power bi certification training course.', 'chapters': [{'end': 6096.808, 'start': 5880.729, 'title': 'Data churning and querying in power bi', 'summary': 'Demonstrates data churning and querying in power bi, including merging queries, appending data, and visualizing the process, with a focus on simplifying complex etl processes and consolidating data from multiple sources, resulting in 269 rows in the final consolidated query.', 'duration': 216.079, 'highlights': ['The chapter demonstrates merging queries, appending data, and visualizing the process in Power BI, simplifying complex ETL processes.', 'Consolidating data from multiple sources resulted in 269 rows in the final consolidated query.', 'The process involves intricate transformations, including connecting to custom columns and merging queries to achieve a SQL union all, with a focus on Africa which had 59 rows.', 'Power BI allows for intuitive and efficient data consolidation, eliminating the need for complex ETL steps in other tools like SSIS.']}, {'end': 6422.128, 'start': 6098.871, 'title': 'Power bi data manipulation', 'summary': 'Covers the process of unpivoting data in power bi, explaining the concept and demonstrating the ease of the process compared to other etl tools, along with the source of the datasets and the visualization of the data, highlighting the efficiency and simplicity of power bi in data manipulation.', 'duration': 323.257, 'highlights': ['The process of unpivoting and pivoting data in Power BI is demonstrated, showing how it simplifies the process compared to other ETL tools, saving time and effort.', 'The source of the datasets, including gapminder.org and data.gov, is mentioned, providing insights into where to obtain relevant data for analysis and visualization.', 'The visualization of the data in Power BI, including the representation of US states in a map format and the population data, is showcased, emphasizing the effectiveness of the visualization capabilities of Power BI.', 'The adjustment and renaming of columns in Power BI for better data representation and visualization are explained, highlighting the flexibility and customization options available in the tool.']}, {'end': 7068.224, 'start': 6422.168, 'title': 'Power bi visualizations and custom visuals', 'summary': 'Explores the usage of slicers for filtering data, configuring slicer orientation, importing custom visuals from the custom visuals gallery, and the announcement of an upcoming power bi certification training course starting from 13th may, covering in-depth topics such as dax, ssrs reports, power bi embedded, custom visuals, q&a, and administration.', 'duration': 646.056, 'highlights': ['The chapter explores the usage of slicers for filtering data and configuring slicer orientation, providing a simple and effective way to filter and visualize data based on different parameters. The speaker demonstrates how slicers can be used to filter data based on years, providing a simple and effective way to visualize data for specific time periods.', 'Importing custom visuals from the Custom Visuals Gallery is explained, highlighting the availability of various visual options and the simplicity of the import process. The chapter explains the process of importing custom visuals from the Custom Visuals Gallery, showcasing the variety of visual options available and the ease of the import process.', 'Announcement of an upcoming Power BI certification training course starting from 13th May, covering in-depth topics such as DAX, SSRS reports, Power BI embedded, custom visuals, Q&A, and administration, with the speaker expressing encouragement for participation. An upcoming Power BI certification training course starting from 13th May is announced, with coverage of in-depth topics such as DAX, SSRS reports, Power BI embedded, custom visuals, Q&A, and administration, and the speaker encourages participation in the course.']}], 'duration': 1187.495, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/gqO0EiCn4cY/pics/gqO0EiCn4cY5880729.jpg', 'highlights': ['Consolidating data from multiple sources resulted in 269 rows in the final consolidated query.', 'The process involves intricate transformations, including connecting to custom columns and merging queries to achieve a SQL union all, with a focus on Africa which had 59 rows.', 'The chapter demonstrates merging queries, appending data, and visualizing the process in Power BI, simplifying complex ETL processes.', 'The process of unpivoting and pivoting data in Power BI is demonstrated, showing how it simplifies the process compared to other ETL tools, saving time and effort.', 'The visualization of the data in Power BI, including the representation of US states in a map format and the population data, is showcased, emphasizing the effectiveness of the visualization capabilities of Power BI.', 'The adjustment and renaming of columns in Power BI for better data representation and visualization are explained, highlighting the flexibility and customization options available in the tool.', 'The chapter explores the usage of slicers for filtering data and configuring slicer orientation, providing a simple and effective way to filter and visualize data based on different parameters.', 'Importing custom visuals from the Custom Visuals Gallery is explained, highlighting the availability of various visual options and the simplicity of the import process.', 'Announcement of an upcoming Power BI certification training course starting from 13th May, covering in-depth topics such as DAX, SSRS reports, Power BI embedded, custom visuals, Q&A, and administration, with the speaker expressing encouragement for participation.']}], 'highlights': ['Power BI attracts a global audience with practical examples and insights from industry experts.', 'Power BI signals a significant shift in the BI landscape towards self-service BI.', 'ETL plays a crucial role in making data readily available for reporting.', 'BI contributes to boosting productivity by providing easy access to stored data.', "Power BI's accessibility and machine learning capabilities simplify complex tasks.", 'Power BI enables easy machine learning capabilities such as linear regression.', 'Power BI integrates closely with Excel, allowing users to publish reports directly from Excel.', 'Power BI can connect to various data sources, providing real-time dashboard updates.', "Power BI's Power Query uses a very powerful mQuery language for querying and transforming data sources.", 'Power BI Desktop offers a wide variety of data sources, enabling quick dashboard creation and analytics.', 'Power BI emphasizes exploratory data analysis and visualization, showcasing its efficiency in importing and visualizing data.', 'Power BI enables the process of establishing a connection to a CSV file and setting delimiters.', 'Power BI predicts the correct data types for columns based on the initial 200 rows of the imported data.', 'The demonstration showcases the simplicity of building visual representations and performing basic and predictive analytics.', 'The interactive drill-down feature allows users to navigate through hierarchical data and visualize data at different hierarchy levels.', 'The process of publishing the created dashboard to the Power BI service is showcased, emphasizing the seamless transition from creation to sharing of visualizations.', 'Power BI Quick Insights feature utilizes machine learning algorithms to generate charts and graphs based on the dataset.', 'Proper data modeling with accurate naming conventions and semantics is crucial for successful query execution in Power BI.', 'The process involves intricate transformations, including connecting to custom columns and merging queries to achieve a SQL union all.', 'The chapter demonstrates merging queries, appending data, and visualizing the process in Power BI, simplifying complex ETL processes.', 'The process of unpivoting and pivoting data in Power BI is demonstrated, showing how it simplifies the process compared to other ETL tools.', 'The visualization of the data in Power BI, including the representation of US states in a map format and the population data, is showcased.', 'The adjustment and renaming of columns in Power BI for better data representation and visualization are explained.', 'The chapter explores the usage of slicers for filtering data and configuring slicer orientation.', 'Importing custom visuals from the Custom Visuals Gallery is explained, highlighting the availability of various visual options and the simplicity of the import process.']}