title
Power BI Tutorial for Beginners - Getting Started

description
Dive into PowerBI to analyze data with ease and create beautiful visualizations. Join the full PowerBI course: https://acad.link/powerbi Join our Academind Community on Discord for free: https://discord.gg/gxvEWGU Also check out my complete intro series: https://academind.com/learn/power-bi/understanding-the-desktop-application/ Check out all our other courses: https://academind.com/learn/our-courses ---------- • Go to https://www.academind.com and subscribe to our newsletter to stay updated and to get exclusive content & discounts • Follow @maxedapps and @academind_real on Twitter • Join our Facebook community on https://www.facebook.com/academindchannel/ See you in the videos! ---------- Academind is your source for online education in the areas of web development, frontend web development, backend web development, programming, coding and data science! No matter if you are looking for a tutorial, a course, a crash course, an introduction, an online tutorial or any related video, we try our best to offer you the content you are looking for. Our topics include Angular, React, Vue, Html, CSS, JavaScript, TypeScript, Redux, Nuxt.js, RxJs, Bootstrap, Laravel, Node.js, Progressive Web Apps (PWA), Ionic, React Native, Regular Expressions (RegEx), Stencil, Power BI, Amazon Web Services (AWS), Firebase or other topics, make sure to have a look at this channel or at academind.com to find the learning resource of your choice!

detail
{'title': 'Power BI Tutorial for Beginners - Getting Started', 'heatmap': [{'end': 1117.244, 'start': 1052.466, 'weight': 0.737}, {'end': 1302.709, 'start': 1236.001, 'weight': 0.781}, {'end': 1395.471, 'start': 1332.465, 'weight': 0.969}], 'summary': 'This tutorial series offers a comprehensive introduction to power bi, including essentials, data visualization, desktop features, and practical examples, providing a foundation for data analysis and report creation.', 'chapters': [{'end': 37.52, 'segs': [{'end': 37.52, 'src': 'embed', 'start': 1.272, 'weight': 0, 'content': [{'end': 2.132, 'text': 'Welcome to this video.', 'start': 1.272, 'duration': 0.86}, {'end': 5.894, 'text': 'On the channel you can find some videos about Power BI already.', 'start': 2.973, 'duration': 2.921}, {'end': 8.135, 'text': 'Feel free to have a look at these if you want to.', 'start': 6.214, 'duration': 1.921}, {'end': 14.398, 'text': 'But if you really want to dive deeper into the tool and get kind of a well more comprehensive introduction,', 'start': 8.695, 'duration': 5.703}, {'end': 17.559, 'text': 'then I also got a 10 hours Udemy course about Power BI.', 'start': 14.398, 'duration': 3.161}, {'end': 20.4, 'text': "It's called Power BI a complete introduction.", 'start': 17.859, 'duration': 2.541}, {'end': 23.682, 'text': 'Well and in this video I want to give you a course excerpt.', 'start': 20.721, 'duration': 2.961}, {'end': 30.971, 'text': 'This means you get the first hour, or I think the first 15 minutes to be more precise of this course, to get an idea of Power BI,', 'start': 24.102, 'duration': 6.869}, {'end': 33.995, 'text': "about the content of the course and about what you're going to learn in there.", 'start': 30.971, 'duration': 3.024}, {'end': 37.52, 'text': 'You can also find a link to the course down there in the video description.', 'start': 34.416, 'duration': 3.104}], 'summary': 'Intro to power bi with a 10-hour udemy course, offering a preview of the first 15 minutes.', 'duration': 36.248, 'max_score': 1.272, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41272.jpg'}], 'start': 1.272, 'title': 'Power bi 10-hour udemy course', 'summary': 'Provides an excerpt from a 10-hour udemy course on power bi, offering viewers the first 15 minutes to gain an understanding of the course content and what they will learn.', 'chapters': [{'end': 37.52, 'start': 1.272, 'title': 'Power bi 10-hour udemy course', 'summary': 'Provides an excerpt from a 10-hour udemy course on power bi, offering viewers the first 15 minutes to gain an understanding of the course content and what they will learn.', 'duration': 36.248, 'highlights': ['The Udemy course offers a comprehensive introduction to Power BI, spanning 10 hours.', 'Viewers are given the opportunity to access the first 15 minutes of the course for a better understanding of the content.', 'The video description includes a link to the full 10-hour course on Udemy.']}], 'duration': 36.248, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41272.jpg', 'highlights': ['The Udemy course offers a comprehensive introduction to Power BI, spanning 10 hours.', 'Viewers are given the opportunity to access the first 15 minutes of the course for a better understanding of the content.', 'The video description includes a link to the full 10-hour course on Udemy.']}, {'end': 347.065, 'segs': [{'end': 117.992, 'src': 'embed', 'start': 37.86, 'weight': 0, 'content': [{'end': 41.985, 'text': 'But for now, have fun with the excerpt and especially have fun with Power BI.', 'start': 37.86, 'duration': 4.125}, {'end': 51.311, 'text': "Let's start with the answer to the most important question first.", 'start': 47.91, 'duration': 3.401}, {'end': 56.952, 'text': 'What is Power BI actually? If you look at the homepage, you can find the following text.', 'start': 51.911, 'duration': 5.041}, {'end': 60.813, 'text': 'So Power BI is a suite of business analytics tools.', 'start': 57.772, 'duration': 3.041}, {'end': 66.594, 'text': 'It allows you to work on data, to create reports, to publish that reports and a lot more.', 'start': 61.313, 'duration': 5.281}, {'end': 69.175, 'text': 'This sounds really great.', 'start': 67.574, 'duration': 1.601}, {'end': 74.496, 'text': 'But we have to take a closer look at that to really understand how this works.', 'start': 70.295, 'duration': 4.201}, {'end': 81.184, 'text': 'So we already know that Power BI is not a single tool, but consists of multiple tools.', 'start': 75.66, 'duration': 5.524}, {'end': 83.826, 'text': 'Additionally, we have the building blocks.', 'start': 81.965, 'duration': 1.861}, {'end': 85.348, 'text': "Let's see what that is.", 'start': 84.587, 'duration': 0.761}, {'end': 92.353, 'text': 'The first tool is Power BI Desktop, the local application only available on Windows.', 'start': 86.749, 'duration': 5.604}, {'end': 97.437, 'text': 'In Power BI Desktop, we have the first building block, the datasets.', 'start': 93.474, 'duration': 3.963}, {'end': 106.468, 'text': 'Now, what is a dataset? A dataset simply describes the data or the information that you have in your data model.', 'start': 98.237, 'duration': 8.231}, {'end': 116.091, 'text': "You can either connect Power BI Desktop to predefined datasets, so you simply import the data into the data model and then you're done,", 'start': 107.568, 'duration': 8.523}, {'end': 117.992, 'text': 'or you can create your own datasets.', 'start': 116.091, 'duration': 1.901}], 'summary': 'Power bi is a suite of business analytics tools allowing creation and publication of reports, including power bi desktop with datasets for data modeling.', 'duration': 80.132, 'max_score': 37.86, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs437860.jpg'}, {'end': 291.39, 'src': 'embed', 'start': 260.555, 'weight': 3, 'content': [{'end': 263.997, 'text': 'Power BI Desktop is the tool to create new datasets in.', 'start': 260.555, 'duration': 3.442}, {'end': 265.518, 'text': "That's an important difference.", 'start': 264.477, 'duration': 1.041}, {'end': 273.941, 'text': 'However, as we can connect Power BI Service to those existing datasets and also to that created datasets in Power BI Desktop.', 'start': 266.618, 'duration': 7.323}, {'end': 277.463, 'text': 'of course we can also create visualizations and reports.', 'start': 273.941, 'duration': 3.522}, {'end': 282.926, 'text': 'But the functionality of the creation of the visualizations and of the reports?', 'start': 278.444, 'duration': 4.482}, {'end': 285.647, 'text': 'well, we know that from Power BI Desktop already right?', 'start': 282.926, 'duration': 2.721}, {'end': 291.39, 'text': 'So we will not create visualizations and reports in Power BI Service in that course.', 'start': 286.587, 'duration': 4.803}], 'summary': 'Power bi desktop creates datasets, while power bi service connects to existing and created datasets, enabling visualization and report creation.', 'duration': 30.835, 'max_score': 260.555, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4260555.jpg'}, {'end': 328.595, 'src': 'embed', 'start': 302.825, 'weight': 4, 'content': [{'end': 310.217, 'text': 'Now what else can we do in Power BI Service then? Well, we talked about the sharing and collaborating and we will learn how this works.', 'start': 302.825, 'duration': 7.392}, {'end': 315.405, 'text': 'But there is one additional building block that is only available in Power BI Service.', 'start': 310.778, 'duration': 4.627}, {'end': 317.428, 'text': 'And those are the dashboards.', 'start': 316.226, 'duration': 1.202}, {'end': 323.592, 'text': 'Now, what is a dashboard? Well, when we talk about a dashboard, simply think about a cover page.', 'start': 318.329, 'duration': 5.263}, {'end': 328.595, 'text': 'So one single page which summarizes the key facts of your report.', 'start': 324.072, 'duration': 4.523}], 'summary': 'Power bi service offers dashboards, a single page summarizing key report facts.', 'duration': 25.77, 'max_score': 302.825, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4302825.jpg'}], 'start': 37.86, 'title': 'Power bi essentials', 'summary': "Covers power bi basics, including the suite's tools and functionalities, focusing on power bi desktop and service for report creation, data analysis, and dashboard building, enabling flexible data modeling and analysis.", 'chapters': [{'end': 137.289, 'start': 37.86, 'title': 'Understanding power bi basics', 'summary': 'Introduces power bi as a suite of business analytics tools allowing data work, report creation, and publishing, with a focus on power bi desktop and the creation of datasets through queries, offering flexibility in data modeling and analysis.', 'duration': 99.429, 'highlights': ['Power BI is a suite of business analytics tools enabling data work, report creation, and publishing.', 'Power BI consists of multiple tools, with Power BI Desktop being the local application available only on Windows.', 'Datasets in Power BI Desktop describe the data or information in the data model, allowing for flexibility in data modeling and analysis.']}, {'end': 347.065, 'start': 138.337, 'title': 'Power bi: tools and functionality', 'summary': 'Introduces power bi desktop and power bi service, highlighting the building blocks, functionalities, and differences between the two tools, emphasizing the creation of datasets in power bi desktop and the exclusive availability of dashboards in power bi service.', 'duration': 208.728, 'highlights': ['Power BI Service is the tool to connect to existing datasets, while Power BI Desktop is the tool to create new datasets, creating an important distinction between the two tools.', 'Dashboards, available only in Power BI Service, serve as cover pages summarizing the key facts of a report, providing a quick overview before diving into the detailed report pages.', 'Visualizations and reports can be created in both Power BI Desktop and Power BI Service, with the functionality and interface for their creation being the same between the two tools.']}], 'duration': 309.205, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs437860.jpg', 'highlights': ['Power BI is a suite of business analytics tools enabling data work, report creation, and publishing.', 'Power BI consists of multiple tools, with Power BI Desktop being the local application available only on Windows.', 'Datasets in Power BI Desktop describe the data or information in the data model, allowing for flexibility in data modeling and analysis.', 'Power BI Service is the tool to connect to existing datasets, while Power BI Desktop is the tool to create new datasets, creating an important distinction between the two tools.', 'Dashboards, available only in Power BI Service, serve as cover pages summarizing the key facts of a report, providing a quick overview before diving into the detailed report pages.', 'Visualizations and reports can be created in both Power BI Desktop and Power BI Service, with the functionality and interface for their creation being the same between the two tools.']}, {'end': 613.053, 'segs': [{'end': 392.971, 'src': 'embed', 'start': 348.125, 'weight': 1, 'content': [{'end': 355.448, 'text': 'We have Power BI Desktop, the local application, where we can create our datasets, our visualizations, and our reports.', 'start': 348.125, 'duration': 7.323}, {'end': 361.53, 'text': 'We then publish that information to Power BI Service, the cloud solution.', 'start': 356.608, 'duration': 4.922}, {'end': 368.553, 'text': 'In there, we can also collaborate with colleagues, for example, if we want, or add dashboards to our existing data.', 'start': 362.39, 'duration': 6.163}, {'end': 371.314, 'text': 'So we have the data in the cloud.', 'start': 369.813, 'duration': 1.501}, {'end': 378.381, 'text': 'now, if we now use the third tool, power bi mobile, a mobile app, as the name says,', 'start': 372.657, 'duration': 5.724}, {'end': 388.228, 'text': 'this will allow us to access the data that we loaded to power bi service from our mobile devices, and we will also take a look at power bi mobile,', 'start': 378.381, 'duration': 9.847}, {'end': 392.971, 'text': 'of course, and see how this app works and what we can do with it.', 'start': 388.228, 'duration': 4.743}], 'summary': 'Power bi allows creating and accessing data on desktop, cloud, and mobile, enabling collaboration and visualization.', 'duration': 44.846, 'max_score': 348.125, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4348125.jpg'}, {'end': 443.765, 'src': 'embed', 'start': 417.268, 'weight': 0, 'content': [{'end': 422.891, 'text': 'And you can also embed your Power BI results into your own existing apps with Power BI embedded.', 'start': 417.268, 'duration': 5.623}, {'end': 429.314, 'text': 'Something that is rather related to your own app and not directly connected to Power BI.', 'start': 423.411, 'duration': 5.903}, {'end': 434.196, 'text': 'Because of that, we will not cover this topic as part of this course.', 'start': 430.492, 'duration': 3.704}, {'end': 437.739, 'text': 'However, with that Power BI for Developers blog,', 'start': 434.916, 'duration': 2.823}, {'end': 443.765, 'text': 'we now have an overview of the entire Power BI universe that we will talk about throughout that course.', 'start': 437.739, 'duration': 6.026}], 'summary': 'Power bi embedded allows embedding results in existing apps. developers can refer to power bi for developers blog for an overview of the entire power bi universe.', 'duration': 26.497, 'max_score': 417.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4417268.jpg'}, {'end': 527.092, 'src': 'embed', 'start': 493.71, 'weight': 4, 'content': [{'end': 499.212, 'text': 'If you press download, then the download will immediately start and then you can install Power BI Desktop,', 'start': 493.71, 'duration': 5.502}, {'end': 504.734, 'text': "but you couldn't choose your language and you can't change the language after you installed Power BI Desktop.", 'start': 499.212, 'duration': 5.522}, {'end': 507.695, 'text': 'So I would press advanced download options right here.', 'start': 505.414, 'duration': 2.281}, {'end': 515.982, 'text': 'if you then scroll down, then you can select the language you want to install power bi desktop in right here.', 'start': 509.796, 'duration': 6.186}, {'end': 527.092, 'text': 'i will now select english and press the download button and i hope you do the same and then you can simply follow the installation guide and after that we will see each other.', 'start': 515.982, 'duration': 11.11}], 'summary': 'Choose language before installing power bi desktop to avoid language selection limitations.', 'duration': 33.382, 'max_score': 493.71, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4493710.jpg'}, {'end': 568.325, 'src': 'embed', 'start': 542.72, 'weight': 5, 'content': [{'end': 547.926, 'text': 'This is not necessary at the moment as we will work locally in Power BI Desktop.', 'start': 542.72, 'duration': 5.206}, {'end': 554.313, 'text': 'We will talk about that sign-in later when we talk about Power BI Service, the cloud application.', 'start': 548.727, 'duration': 5.586}, {'end': 559.398, 'text': 'If you want to sign into Power BI Desktop right here, you can of course do that.', 'start': 555.474, 'duration': 3.924}, {'end': 564.962, 'text': 'The only thing you need to know is that you need a work or a school email address.', 'start': 560.118, 'duration': 4.844}, {'end': 568.325, 'text': 'You cannot register with a Gmail address for instance.', 'start': 565.523, 'duration': 2.802}], 'summary': 'To use power bi desktop, one needs a work or school email, not a gmail address.', 'duration': 25.605, 'max_score': 542.72, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4542720.jpg'}, {'end': 613.053, 'src': 'embed', 'start': 589.248, 'weight': 6, 'content': [{'end': 595.673, 'text': 'I only want to show you how easy to use Power BI Desktop is and how quickly you can create your first visualizations.', 'start': 589.248, 'duration': 6.425}, {'end': 600.697, 'text': "So in case you don't understand everything I'm doing right here, don't worry.", 'start': 596.574, 'duration': 4.123}, {'end': 605.641, 'text': 'We will talk about everything you see right here and about more throughout the course.', 'start': 601.358, 'duration': 4.283}, {'end': 610.265, 'text': 'So for the moment, just follow my guidance and enjoy Power BI Desktop.', 'start': 606.502, 'duration': 3.763}, {'end': 613.053, 'text': 'So back to our get data function.', 'start': 611.232, 'duration': 1.821}], 'summary': 'Learn easy and quick use of power bi desktop for creating visualizations', 'duration': 23.805, 'max_score': 589.248, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4589248.jpg'}], 'start': 348.125, 'title': 'Power bi tools and desktop introduction', 'summary': 'Covers an overview of power bi tools including desktop, service, and mobile, and also introduces the installation process and ease of use of power bi desktop.', 'chapters': [{'end': 437.739, 'start': 348.125, 'title': 'Power bi tools overview', 'summary': 'Introduces power bi desktop for local data creation and visualization, power bi service for cloud-based collaboration, and power bi mobile for accessing data on mobile devices. it also mentions power bi for developers which includes customizing visuals and embedding results into existing apps.', 'duration': 89.614, 'highlights': ['Power BI for developers allows customization of visuals and embedding results into existing apps.', 'Power BI Mobile enables access to data loaded to Power BI Service from mobile devices.', 'Power BI Service offers cloud-based collaboration and dashboard addition to existing data.', 'Power BI Desktop is used for creating datasets, visualizations, and reports.']}, {'end': 613.053, 'start': 437.739, 'title': 'Introduction to power bi desktop', 'summary': 'Introduces the process of downloading and installing power bi desktop, explaining the need for selecting language during installation and emphasizing the ease of use in creating visualizations.', 'duration': 175.314, 'highlights': ['The process of downloading and installing Power BI Desktop is explained, with an emphasis on selecting the language during installation and the limitation of changing the language after installation.', 'The option to work locally in Power BI Desktop without the need for sign-in is highlighted, with a note on the requirement of a work or school email address for signing in.', 'The ease of creating visualizations using Power BI Desktop is emphasized, with reassurance to learners about understanding the process throughout the course.']}], 'duration': 264.928, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4348125.jpg', 'highlights': ['Power BI for developers allows customization of visuals and embedding results into existing apps.', 'Power BI Service offers cloud-based collaboration and dashboard addition to existing data.', 'Power BI Mobile enables access to data loaded to Power BI Service from mobile devices.', 'Power BI Desktop is used for creating datasets, visualizations, and reports.', 'The process of downloading and installing Power BI Desktop is explained, with an emphasis on selecting the language during installation and the limitation of changing the language after installation.', 'The option to work locally in Power BI Desktop without the need for sign-in is highlighted, with a note on the requirement of a work or school email address for signing in.', 'The ease of creating visualizations using Power BI Desktop is emphasized, with reassurance to learners about understanding the process throughout the course.']}, {'end': 1227.58, 'segs': [{'end': 671.568, 'src': 'embed', 'start': 645.534, 'weight': 0, 'content': [{'end': 651.959, 'text': 'So a good data set for our first initial project would be GDP data, for instance, for different countries also.', 'start': 645.534, 'duration': 6.425}, {'end': 658.885, 'text': 'You can find data like that if you search for the IMF World Economic Outlook Database.', 'start': 652.74, 'duration': 6.145}, {'end': 660.767, 'text': 'So the second result right here.', 'start': 659.426, 'duration': 1.341}, {'end': 664.324, 'text': 'And down here we have the link that we need.', 'start': 662.082, 'duration': 2.242}, {'end': 665.444, 'text': 'Another note.', 'start': 664.924, 'duration': 0.52}, {'end': 671.568, 'text': 'At the time when I recorded that video the April 2017 version was the latest one.', 'start': 666.325, 'duration': 5.243}], 'summary': 'Initial project: gdp data from imf world economic outlook database, april 2017 version.', 'duration': 26.034, 'max_score': 645.534, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4645534.jpg'}, {'end': 751.097, 'src': 'embed', 'start': 723.491, 'weight': 1, 'content': [{'end': 732.114, 'text': "But we don't have to do this because we can now simply select the URL right there and copy it into our Power BI Desktop file.", 'start': 723.491, 'duration': 8.623}, {'end': 733.274, 'text': "Let's do this.", 'start': 732.794, 'duration': 0.48}, {'end': 738.036, 'text': 'So I now paste the URL into this field and press OK.', 'start': 734.195, 'duration': 3.841}, {'end': 747.815, 'text': 'Now the navigator opened and the navigator allows us to select the information that we want to retrieve from that web page.', 'start': 740.129, 'duration': 7.686}, {'end': 751.097, 'text': 'So the information we want to connect Power BI Desktop to basically.', 'start': 748.195, 'duration': 2.902}], 'summary': 'Easily connect power bi desktop to web data by selecting url and retrieving information.', 'duration': 27.606, 'max_score': 723.491, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4723491.jpg'}, {'end': 850.381, 'src': 'embed', 'start': 822.524, 'weight': 2, 'content': [{'end': 828.366, 'text': 'The query editor is kind of a separate tool in Power BI Desktop that allows us to prepare the data.', 'start': 822.524, 'duration': 5.842}, {'end': 832.747, 'text': 'So for instance, to delete rows or delete columns or add columns or a lot more.', 'start': 828.686, 'duration': 4.061}, {'end': 836.448, 'text': 'And then load this clean data into the data model.', 'start': 833.587, 'duration': 2.861}, {'end': 842.449, 'text': 'As we first want to prepare the data, we will click edit right here to open that query editor.', 'start': 837.468, 'duration': 4.981}, {'end': 844.49, 'text': "Now let's press that.", 'start': 843.69, 'duration': 0.8}, {'end': 850.381, 'text': 'And now you can see the query editor with our initial project data for the first time.', 'start': 845.856, 'duration': 4.525}], 'summary': "Power bi's query editor allows data preparation, including deleting/adding rows/columns, before loading into the data model.", 'duration': 27.857, 'max_score': 822.524, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4822524.jpg'}, {'end': 940.809, 'src': 'embed', 'start': 909.681, 'weight': 3, 'content': [{'end': 915.384, 'text': "The first step is we have to delete the first row, this one right here, because we don't need that information in here.", 'start': 909.681, 'duration': 5.703}, {'end': 923.316, 'text': 'The second step then is that we have to turn this second row, which will then be the first row after deleting that current first row.', 'start': 916.311, 'duration': 7.005}, {'end': 927.719, 'text': 'So we want to turn that new first row into the header, the column names.', 'start': 923.897, 'duration': 3.822}, {'end': 930.561, 'text': "So let's first delete the first row.", 'start': 928.94, 'duration': 1.621}, {'end': 940.809, 'text': 'To do this, we simply go to the home ribbon right here and then click on to remove rows right here and select remove top rows like this.', 'start': 931.382, 'duration': 9.427}], 'summary': 'The process involves deleting the first row and turning the second row into the header using the remove rows function from the home ribbon.', 'duration': 31.128, 'max_score': 909.681, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4909681.jpg'}, {'end': 1117.244, 'src': 'heatmap', 'start': 1052.466, 'weight': 0.737, 'content': [{'end': 1055.548, 'text': 'and the second column with the corresponding GDP data.', 'start': 1052.466, 'duration': 3.082}, {'end': 1056.97, 'text': 'I think so.', 'start': 1056.509, 'duration': 0.461}, {'end': 1064.496, 'text': 'And what we have to do right now is we have to turn this columns, so this year columns into rows basically.', 'start': 1057.67, 'duration': 6.826}, {'end': 1069.02, 'text': 'So the column is named year and all the rows in that column are the different years.', 'start': 1064.856, 'duration': 4.164}, {'end': 1080.152, 'text': 'To do this, we simply select the first column, the 2015 column, and now press and hold shift on the keyboard and select the last column like this.', 'start': 1070.029, 'duration': 10.123}, {'end': 1085.174, 'text': 'Now we change from the home ribbon to the transform ribbon up here.', 'start': 1081.553, 'duration': 3.621}, {'end': 1089.075, 'text': 'And now we press that unpivot columns function.', 'start': 1086.455, 'duration': 2.62}, {'end': 1092.957, 'text': 'Again, something we will talk about in detail throughout that course.', 'start': 1089.776, 'duration': 3.181}, {'end': 1096.438, 'text': 'But for the moment, we simply press that like this.', 'start': 1093.757, 'duration': 2.681}, {'end': 1107.243, 'text': 'And as you can see, we simply turned those multiple columns into one single column with the years being single rows in that column.', 'start': 1098.041, 'duration': 9.202}, {'end': 1110.223, 'text': "This was easy, right? Let's continue.", 'start': 1108.083, 'duration': 2.14}, {'end': 1117.244, 'text': 'Because we have to rename that columns now because attribute and value, not the best names probably.', 'start': 1111.503, 'duration': 5.741}], 'summary': 'Transformed multiple gdp columns into single column with years as rows.', 'duration': 64.778, 'max_score': 1052.466, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41052466.jpg'}, {'end': 1152.849, 'src': 'embed', 'start': 1126.946, 'weight': 4, 'content': [{'end': 1133.313, 'text': 'and do the same thing for the GDP column well and name it GDP like this.', 'start': 1126.946, 'duration': 6.367}, {'end': 1140.281, 'text': 'now we got that and now we should make sure that we only have rows in that GDP column where we have data for,', 'start': 1133.313, 'duration': 6.968}, {'end': 1145.406, 'text': 'because we only want to import the really important information into our data model.', 'start': 1140.281, 'duration': 5.125}, {'end': 1150.949, 'text': 'so we should take a look at that Now to see if we have any NAs in this GDP column.', 'start': 1145.406, 'duration': 5.543}, {'end': 1152.849, 'text': 'we simply click onto that arrow right here.', 'start': 1150.949, 'duration': 1.9}], 'summary': 'Filter gdp column for data integrity and completeness.', 'duration': 25.903, 'max_score': 1126.946, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41126946.jpg'}], 'start': 613.654, 'title': 'Connecting and transforming data for visualization', 'summary': 'Explains how to connect power bi desktop to web data for obtaining gdp data from the imf world economic outlook database and details the process of data cleaning and transformation, resulting in an improved data model for analysis in power bi.', 'chapters': [{'end': 890.193, 'start': 613.654, 'title': 'Connecting power bi desktop to web data', 'summary': 'Details the process of obtaining gdp data from the imf world economic outlook database via a web url, navigating through the web page to select and connect the relevant data to power bi desktop for preparation and visualization.', 'duration': 276.539, 'highlights': ['The process of obtaining GDP data from the IMF World Economic Outlook Database via a web URL is explained, with emphasis on selecting the data at current prices in US dollars and preparing the data in Power BI Desktop for visualization.', 'The chapter demonstrates the navigation through a web page to select and connect the relevant GDP data to Power BI Desktop for further data preparation and visualization.', 'The navigator allows the user to select the desired information from the web page, such as categorizing different tables and selecting the correct data to be retrieved.', 'The chapter introduces the query editor in Power BI Desktop as a tool for preparing the data, including options to delete rows, delete columns, add columns, and more, before loading the clean data into the data model.', 'The importance of understanding the process of connecting Power BI Desktop to web data for obtaining, preparing, and visualizing project data is emphasized, with assurance that the course will cover the details and functionalities of the tools involved.']}, {'end': 1227.58, 'start': 890.913, 'title': 'Data cleaning and transformation', 'summary': 'Explains the steps to clean and transform data, including deleting rows, removing unnecessary columns, and converting multiple columns into rows, resulting in the improvement of the data model for analysis in power bi.', 'duration': 336.667, 'highlights': ['The chapter explains the steps to delete the first row and turn the second row into column names, enhancing the data organization. The steps include deleting the first row to exclude unnecessary information and turning the second row into the header, improving data organization and structure.', 'Demonstrates the process of removing unnecessary columns and checking for NAs to ensure only important data is included in the model. The process involves removing unnecessary columns, checking for NAs in the GDP column, and changing the format of data to ensure only important information is included in the data model.', 'Explains the transformation of multiple columns into rows and renaming columns to improve data presentation. The process involves transforming multiple columns into a single column with corresponding rows, renaming columns to improve data presentation, and changing the format of data for accurate representation.']}], 'duration': 613.926, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs4613654.jpg', 'highlights': ['The process of obtaining GDP data from the IMF World Economic Outlook Database via a web URL is explained, with emphasis on selecting the data at current prices in US dollars and preparing the data in Power BI Desktop for visualization.', 'The chapter demonstrates the navigation through a web page to select and connect the relevant GDP data to Power BI Desktop for further data preparation and visualization.', 'The chapter introduces the query editor in Power BI Desktop as a tool for preparing the data, including options to delete rows, delete columns, add columns, and more, before loading the clean data into the data model.', 'The chapter explains the steps to delete the first row and turn the second row into column names, enhancing the data organization.', 'Demonstrates the process of removing unnecessary columns and checking for NAs to ensure only important data is included in the model.']}, {'end': 1622.534, 'segs': [{'end': 1302.709, 'src': 'heatmap', 'start': 1228.7, 'weight': 1, 'content': [{'end': 1234.642, 'text': 'Now, if you go to the transform ribbon again and press detect data type right here like this,', 'start': 1228.7, 'duration': 5.942}, {'end': 1241.844, 'text': "Then you can see that the format of the first four columns of course didn't change, because well, those are text.", 'start': 1236.001, 'duration': 5.843}, {'end': 1242.464, 'text': 'so this is fine.', 'start': 1241.844, 'duration': 0.62}, {'end': 1247.566, 'text': 'But the format of the year column changed to a whole number now, which is fine for the moment.', 'start': 1243.064, 'duration': 4.502}, {'end': 1249.447, 'text': 'And this is it.', 'start': 1248.907, 'duration': 0.54}, {'end': 1252.688, 'text': 'We now finished the work in our query editor.', 'start': 1250.187, 'duration': 2.501}, {'end': 1256.17, 'text': 'So in this data preparation step for our initial project.', 'start': 1253.049, 'duration': 3.121}, {'end': 1264.794, 'text': 'The next step now is to load that data, that clean data into the actual data model and create visualizations.', 'start': 1257.271, 'duration': 7.523}, {'end': 1272.371, 'text': 'We made a great progress in our initial project.', 'start': 1269.929, 'duration': 2.442}, {'end': 1273.952, 'text': 'Time to continue.', 'start': 1273.231, 'duration': 0.721}, {'end': 1277.795, 'text': 'So we finished the work in that query editor.', 'start': 1275.373, 'duration': 2.422}, {'end': 1286.821, 'text': 'If you want to load the data into the data model now, then you simply go to the home ribbon like this and press close and apply right here.', 'start': 1278.555, 'duration': 8.266}, {'end': 1288.162, 'text': 'If we do this.', 'start': 1287.701, 'duration': 0.461}, {'end': 1295.547, 'text': 'Then we can see that the interface changed because now we are in the actual data model.', 'start': 1290.205, 'duration': 5.342}, {'end': 1298.268, 'text': 'And again, I have to repeat myself.', 'start': 1296.667, 'duration': 1.601}, {'end': 1302.709, 'text': "You probably haven't seen it before, this interface and what you can do right here.", 'start': 1298.768, 'duration': 3.941}], 'summary': 'Transformed data types in query editor and loaded clean data into data model for initial project, making great progress.', 'duration': 49.095, 'max_score': 1228.7, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41228700.jpg'}, {'end': 1395.471, 'src': 'heatmap', 'start': 1332.465, 'weight': 0.969, 'content': [{'end': 1338.309, 'text': 'And now you can see that we have our different columns and our table actually in that data model.', 'start': 1332.465, 'duration': 5.844}, {'end': 1343.195, 'text': 'What we have to change right here is the first column, this country column.', 'start': 1339.534, 'duration': 3.661}, {'end': 1348.077, 'text': 'Why do I want to change that? Well, in this column we have countries.', 'start': 1344.036, 'duration': 4.041}, {'end': 1354.3, 'text': 'And Power BI has great functionalities to visualize country-specific data.', 'start': 1349.078, 'duration': 5.222}, {'end': 1359.042, 'text': 'But we have to tell Power BI that those are countries and not simple text.', 'start': 1355.04, 'duration': 4.002}, {'end': 1364.504, 'text': 'So to change this, we simply go to the modeling ribbon up here, like this.', 'start': 1360.062, 'duration': 4.442}, {'end': 1375.862, 'text': 'and now go to data category in this area, and if you press that, then you can see that at the moment we have uncategorized data, which is wrong,', 'start': 1365.856, 'duration': 10.006}, {'end': 1383.747, 'text': "because we should select country right here, because that's the type of data we have and we can find country right here.", 'start': 1375.862, 'duration': 7.885}, {'end': 1386.889, 'text': 'if we click that, nothing changed.', 'start': 1383.747, 'duration': 3.142}, {'end': 1388.25, 'text': "no, that's not true.", 'start': 1386.889, 'duration': 1.361}, {'end': 1390.111, 'text': 'we now have that symbol right here.', 'start': 1388.25, 'duration': 1.861}, {'end': 1391.152, 'text': 'so this seems to work.', 'start': 1390.111, 'duration': 1.041}, {'end': 1395.471, 'text': "let's finally create some visualizations right now.", 'start': 1392.21, 'duration': 3.261}], 'summary': 'In power bi, the data model is modified to categorize the country column, enabling country-specific data visualization.', 'duration': 63.006, 'max_score': 1332.465, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41332465.jpg'}, {'end': 1375.862, 'src': 'embed', 'start': 1349.078, 'weight': 0, 'content': [{'end': 1354.3, 'text': 'And Power BI has great functionalities to visualize country-specific data.', 'start': 1349.078, 'duration': 5.222}, {'end': 1359.042, 'text': 'But we have to tell Power BI that those are countries and not simple text.', 'start': 1355.04, 'duration': 4.002}, {'end': 1364.504, 'text': 'So to change this, we simply go to the modeling ribbon up here, like this.', 'start': 1360.062, 'duration': 4.442}, {'end': 1375.862, 'text': 'and now go to data category in this area, and if you press that, then you can see that at the moment we have uncategorized data, which is wrong,', 'start': 1365.856, 'duration': 10.006}], 'summary': 'Power bi can visualize country-specific data, but requires data categorization in the modeling ribbon.', 'duration': 26.784, 'max_score': 1349.078, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41349078.jpg'}, {'end': 1491.827, 'src': 'embed', 'start': 1466.7, 'weight': 3, 'content': [{'end': 1473.964, 'text': "however, this chart doesn't look good at the moment, so we have to add some more information, for instance the different years.", 'start': 1466.7, 'duration': 7.264}, {'end': 1474.885, 'text': 'to add the years.', 'start': 1473.964, 'duration': 0.921}, {'end': 1479.648, 'text': 'we simply select it right here and drag it to the axis area right there.', 'start': 1474.885, 'duration': 4.763}, {'end': 1479.908, 'text': 'like this.', 'start': 1479.648, 'duration': 0.26}, {'end': 1487.885, 'text': 'now it looks better, but i want to add more, because you remember, we also have that country data.', 'start': 1481.741, 'duration': 6.144}, {'end': 1491.827, 'text': "so why don't we also add this data to our visualization?", 'start': 1487.885, 'duration': 3.942}], 'summary': 'Improving the chart by adding years and country data for better visualization.', 'duration': 25.127, 'max_score': 1466.7, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41466700.jpg'}, {'end': 1541.913, 'src': 'embed', 'start': 1516.315, 'weight': 4, 'content': [{'end': 1522.616, 'text': 'Now scroll down in this visualizations column and select the country right here.', 'start': 1516.315, 'duration': 6.301}, {'end': 1529.462, 'text': 'now we can scroll down a little bit and change it from the basic filtering to the top end filter like this,', 'start': 1522.616, 'duration': 6.846}, {'end': 1533.886, 'text': 'and now we can simply decide that we only want to see the top right here.', 'start': 1529.462, 'duration': 4.424}, {'end': 1539.771, 'text': 'and if we click into that box right here and define the top 10, well, the top 10 by what??', 'start': 1533.886, 'duration': 5.885}, {'end': 1541.913, 'text': 'by the GDP.', 'start': 1540.512, 'duration': 1.401}], 'summary': 'Filter data to display top 10 countries by gdp.', 'duration': 25.598, 'max_score': 1516.315, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41516315.jpg'}, {'end': 1599.593, 'src': 'embed', 'start': 1573.031, 'weight': 5, 'content': [{'end': 1579.314, 'text': 'If you want to change the visualization type, you can simply do this by selecting a different visualization in this area.', 'start': 1573.031, 'duration': 6.283}, {'end': 1586.957, 'text': 'And a good visualization right here would be a world map, right? Now, the good thing is we have such a map right here.', 'start': 1580.454, 'duration': 6.503}, {'end': 1596.432, 'text': 'And if we now click that, and you of course still selected our visualization, so we click that now, now the visualization changed.', 'start': 1587.95, 'duration': 8.482}, {'end': 1599.593, 'text': 'And now we still have the annual data in here.', 'start': 1597.372, 'duration': 2.221}], 'summary': 'Change visualization to world map for better understanding of annual data.', 'duration': 26.562, 'max_score': 1573.031, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41573031.jpg'}], 'start': 1228.7, 'title': 'Visualizing data in power bi', 'summary': 'Covers data preparation, visualization, and emphasizes categorizing data, transitioning between report and data views, adding and setting filters, and changing visualization types. it also demonstrates adding country data and setting a top 10 filter by gdp.', 'chapters': [{'end': 1442.768, 'start': 1228.7, 'title': 'Data preparation and visualization in power bi', 'summary': 'Focuses on data preparation in power bi, including detecting data types, loading clean data into the data model, and creating visualizations, emphasizing the importance of categorizing data and transitioning between report and data views.', 'duration': 214.068, 'highlights': ['The chapter emphasizes the importance of categorizing data in Power BI, specifically demonstrating the process of categorizing country-specific data, highlighting its relevance for visualizations.', 'The process of loading clean data into the data model and transitioning between report and data views is explained, providing practical guidance for utilizing Power BI functionalities.', 'The significance of detecting data types and the transformation of the year column into a whole number is highlighted, underscoring the practical application of data preparation techniques in Power BI.']}, {'end': 1622.534, 'start': 1442.768, 'title': 'Visualizing data in power bi', 'summary': 'Explains how to visualize data in power bi, including adding fields to the visualization, setting filters, and changing visualization types. it also demonstrates adding country data and setting a top 10 filter by gdp.', 'duration': 179.766, 'highlights': ['Adding fields to the visualization The chapter demonstrates dragging and dropping fields such as years and country to the visualization, improving the visual representation of the data.', 'Setting a top 10 filter by GDP It explains the process of setting a filter to only display the top 10 countries by GDP, demonstrating the use of the top end filter and applying the filter to the visualization.', 'Changing visualization type to a world map It shows how to switch the visualization type to a world map, offering a better way to visualize the data and demonstrating the process of excluding years and displaying total values.']}], 'duration': 393.834, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41228700.jpg', 'highlights': ['The chapter emphasizes the importance of categorizing data in Power BI, specifically demonstrating the process of categorizing country-specific data, highlighting its relevance for visualizations.', 'The process of loading clean data into the data model and transitioning between report and data views is explained, providing practical guidance for utilizing Power BI functionalities.', 'The significance of detecting data types and the transformation of the year column into a whole number is highlighted, underscoring the practical application of data preparation techniques in Power BI.', 'Adding fields to the visualization The chapter demonstrates dragging and dropping fields such as years and country to the visualization, improving the visual representation of the data.', 'Setting a top 10 filter by GDP It explains the process of setting a filter to only display the top 10 countries by GDP, demonstrating the use of the top end filter and applying the filter to the visualization.', 'Changing visualization type to a world map It shows how to switch the visualization type to a world map, offering a better way to visualize the data and demonstrating the process of excluding years and displaying total values.']}, {'end': 2010.085, 'segs': [{'end': 1701.705, 'src': 'embed', 'start': 1670.799, 'weight': 0, 'content': [{'end': 1673.1, 'text': "We're getting started, but we're almost done.", 'start': 1670.799, 'duration': 2.301}, {'end': 1678.264, 'text': "Thereafter, we'll have a look at Power BI Desktop in detail.", 'start': 1673.9, 'duration': 4.364}, {'end': 1679.805, 'text': 'So how does it work?', 'start': 1678.704, 'duration': 1.101}, {'end': 1681.126, 'text': 'What does this tool offer?', 'start': 1679.845, 'duration': 1.281}, {'end': 1685.19, 'text': 'Before we then dive into the query editor in Power BI Desktop.', 'start': 1681.587, 'duration': 3.603}, {'end': 1687.132, 'text': 'still, how can we query data?', 'start': 1685.19, 'duration': 1.942}, {'end': 1688.413, 'text': 'How can we import data?', 'start': 1687.172, 'duration': 1.241}, {'end': 1692.396, 'text': 'And how can we manipulate or structure the data when importing it?', 'start': 1688.673, 'duration': 3.723}, {'end': 1695.159, 'text': "We'll then have a look at the data view.", 'start': 1693.217, 'duration': 1.942}, {'end': 1701.705, 'text': 'The data view allows us to still work with our data, but not in the import step, but after we import it.', 'start': 1695.579, 'duration': 6.126}], 'summary': 'Overview of power bi desktop features, including querying, importing, and manipulating data.', 'duration': 30.906, 'max_score': 1670.799, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41670799.jpg'}, {'end': 1743.25, 'src': 'embed', 'start': 1716.378, 'weight': 1, 'content': [{'end': 1724.102, 'text': 'This report view will then allow you to output reports with tables, with visuals, with measures as you will learn.', 'start': 1716.378, 'duration': 7.724}, {'end': 1726.863, 'text': 'So single values, for example, you can output.', 'start': 1724.182, 'duration': 2.681}, {'end': 1733.946, 'text': 'And that is, of course, the thing which is most interesting to your executives or things like that, where you present your data,', 'start': 1727.303, 'duration': 6.643}, {'end': 1738.068, 'text': 'where you create nice reports with the key results of your data.', 'start': 1733.946, 'duration': 4.122}, {'end': 1743.25, 'text': "Thereafter, we'll have a look at the other parts of the Power BI universe.", 'start': 1738.968, 'duration': 4.282}], 'summary': 'Learn to create reports with tables, visuals, and measures in power bi to present key results to executives.', 'duration': 26.872, 'max_score': 1716.378, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41716378.jpg'}, {'end': 1788.012, 'src': 'embed', 'start': 1759.896, 'weight': 4, 'content': [{'end': 1763.538, 'text': 'Now I will create my first module or show my first module.', 'start': 1759.896, 'duration': 3.642}, {'end': 1770.962, 'text': "In the other data sources module, I'll have a look at some other data sources than the data sources used so far in the course.", 'start': 1764.258, 'duration': 6.704}, {'end': 1775.525, 'text': "Manual will mainly work with a CSV file since it's a very common data source.", 'start': 1771.382, 'duration': 4.143}, {'end': 1783.99, 'text': 'But I will then also show you how to work with JSON data from RESTful web services and MySQL or in general SQL databases.', 'start': 1775.905, 'duration': 8.085}, {'end': 1788.012, 'text': 'Thereafter another module done by me.', 'start': 1784.79, 'duration': 3.222}], 'summary': 'Introducing various data sources such as csv, json, and sql databases in the module.', 'duration': 28.116, 'max_score': 1759.896, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41759896.jpg'}, {'end': 1854.26, 'src': 'embed', 'start': 1825.717, 'weight': 3, 'content': [{'end': 1833.822, 'text': 'So a lot of great content walking you from A to C through Power BI and giving you a very complete introduction to it.', 'start': 1825.717, 'duration': 8.105}, {'end': 1841.973, 'text': 'Throughout the course, you and Manuel are going to work with the course data set.', 'start': 1838.291, 'duration': 3.682}, {'end': 1848.977, 'text': 'And of course, this starts basic at importing it, then adjusting the import to your needs and so on.', 'start': 1842.473, 'duration': 6.504}, {'end': 1854.26, 'text': 'And therefore, the course project, the Power BI file will also change.', 'start': 1849.037, 'duration': 5.223}], 'summary': 'Complete power bi introduction with practical project work.', 'duration': 28.543, 'max_score': 1825.717, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41825717.jpg'}, {'end': 1980.134, 'src': 'embed', 'start': 1951.252, 'weight': 5, 'content': [{'end': 1956.396, 'text': 'now, with that being done, we can hit done and you see, the data is there.', 'start': 1951.252, 'duration': 5.144}, {'end': 1965.663, 'text': 'if you still experience issues, you should hit refresh preview to really force power bi to update your paths and with that, unfortunately,', 'start': 1956.396, 'duration': 9.267}, {'end': 1970.226, 'text': "you'll have to do that for all your imports here.", 'start': 1965.663, 'duration': 4.563}, {'end': 1974.83, 'text': 'i know this can be inconvenient, but this is the only way of fixing these paths.', 'start': 1970.226, 'duration': 4.604}, {'end': 1980.134, 'text': 'However, once you do have that path, the new path, copied or stored in your clipboard,', 'start': 1975.27, 'duration': 4.864}], 'summary': 'In power bi, refreshing the preview updates paths, but it can be inconvenient.', 'duration': 28.882, 'max_score': 1951.252, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41951252.jpg'}], 'start': 1622.534, 'title': 'Power bi fundamentals', 'summary': 'Provides an overview of power bi desktop functions, query editor, data view, and report view, emphasizing data manipulation and report creation. additionally, it covers collaboration, data sources, project management, custom visuals, and practical examples.', 'chapters': [{'end': 1738.068, 'start': 1622.534, 'title': 'Power bi desktop course overview', 'summary': 'Provides an overview of the course structure, including the topics covered such as power bi desktop functions, query editor, data view, and report view, emphasizing the ability to manipulate and structure data, as well as create reports with key results.', 'duration': 115.534, 'highlights': ['The course will cover topics such as Power BI Desktop functions, query editor, data view, and report view. This highlights the key topics covered in the course.', 'Emphasizes the ability to manipulate and structure data, as well as create reports with key results. This highlights the focus on data manipulation and report creation, which is essential for data analysis.', 'The visualization of data will include tables, visuals, and measures for presenting single values. This highlights the types of visualizations and outputs that will be taught in the course.']}, {'end': 2010.085, 'start': 1738.968, 'title': 'Power bi: modules and data sources', 'summary': 'Covers collaboration, data sources, and project management in power bi, including creating custom visuals and handling file paths, offering a comprehensive introduction to power bi with practical examples and solutions.', 'duration': 271.117, 'highlights': ['The chapter covers collaboration, data sources, and project management in Power BI, including creating custom visuals and handling file paths. A comprehensive overview of the topics covered in the chapter, providing a holistic understanding of the content.', 'Manual mainly works with a CSV file as a common data source, and also demonstrates working with JSON data from RESTful web services and MySQL. Demonstration of working with various data sources including CSV, JSON, and MySQL, showcasing practical examples to enrich the learning experience.', 'Detailed guidance on adjusting import paths in Power BI, including replacing absolute paths and refreshing previews to update paths automatically. Step-by-step instructions on adjusting import paths, offering practical solutions to common challenges faced by users.', "The chapter offers a comprehensive introduction to Power BI with practical examples and solutions. Emphasizing the comprehensive nature of the chapter's content and its practical applicability, enhancing the learning experience for users."]}], 'duration': 387.551, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs41622534.jpg', 'highlights': ['The course will cover topics such as Power BI Desktop functions, query editor, data view, and report view.', 'Emphasizes the ability to manipulate and structure data, as well as create reports with key results.', 'The visualization of data will include tables, visuals, and measures for presenting single values.', 'The chapter covers collaboration, data sources, and project management in Power BI, including creating custom visuals and handling file paths.', 'Manual mainly works with a CSV file as a common data source, and also demonstrates working with JSON data from RESTful web services and MySQL.', 'Detailed guidance on adjusting import paths in Power BI, including replacing absolute paths and refreshing previews to update paths automatically.', 'The chapter offers a comprehensive introduction to Power BI with practical examples and solutions.']}, {'end': 3095.751, 'segs': [{'end': 2061.873, 'src': 'embed', 'start': 2037.705, 'weight': 0, 'content': [{'end': 2043.947, 'text': "Now it's time to dive a little deeper and we will start our deep dive with the first tool, with Power BI Desktop.", 'start': 2037.705, 'duration': 6.242}, {'end': 2047.369, 'text': "Let's first take a quick look at the workflow of that tool.", 'start': 2044.688, 'duration': 2.681}, {'end': 2054.11, 'text': 'So generally we can divide Power BI Desktop or the workflow in that tool into three steps.', 'start': 2048.228, 'duration': 5.882}, {'end': 2061.873, 'text': 'The first step is the data preparation, so the connection to the source files and the cleaning of the data we imported.', 'start': 2054.831, 'duration': 7.042}], 'summary': 'Deep dive into power bi desktop workflow: 3 steps - data preparation, connection, and data cleaning.', 'duration': 24.168, 'max_score': 2037.705, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs42037705.jpg'}, {'end': 2261.941, 'src': 'embed', 'start': 2235.654, 'weight': 1, 'content': [{'end': 2242.557, 'text': 'and the actual data you import into the data model, which can be seen in the interface we are talking right now about.', 'start': 2235.654, 'duration': 6.903}, {'end': 2246.049, 'text': "After knowing this let's start with the interface.", 'start': 2243.727, 'duration': 2.322}, {'end': 2250.573, 'text': 'So basically you have four core areas.', 'start': 2246.73, 'duration': 3.843}, {'end': 2254.576, 'text': 'You have the ribbons on top, you have that left column.', 'start': 2250.993, 'duration': 3.583}, {'end': 2261.941, 'text': 'right here you have that center part where you can see the actual content of each view and you have that columns to the right.', 'start': 2254.576, 'duration': 7.365}], 'summary': 'The interface has four core areas: ribbons on top, left column, center part, and columns to the right.', 'duration': 26.287, 'max_score': 2235.654, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs42235654.jpg'}, {'end': 2916.551, 'src': 'embed', 'start': 2888.033, 'weight': 2, 'content': [{'end': 2894.075, 'text': 'In the options, we have two option types available, global options and current file options.', 'start': 2888.033, 'duration': 6.042}, {'end': 2898.236, 'text': 'The global options are set for all Power BI projects.', 'start': 2894.835, 'duration': 3.401}, {'end': 2907.103, 'text': 'the current file options, as the name says, actually are only true for the current file where you set those options.', 'start': 2899.016, 'duration': 8.087}, {'end': 2916.551, 'text': 'so this means we have to open a new power bi project which we will then use for our course project to make sure that the options are set correctly.', 'start': 2907.103, 'duration': 9.448}], 'summary': 'Power bi offers global and file-specific options for projects.', 'duration': 28.518, 'max_score': 2888.033, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs42888033.jpg'}], 'start': 2010.846, 'title': 'Power bi desktop features', 'summary': 'Provides an overview of power bi desktop workflow, interface, and options. it covers data preparation, modeling, visualization, interface areas, functionalities, ribbons, settings, and performance improvements, preparing for the first course project.', 'chapters': [{'end': 2235.654, 'start': 2010.846, 'title': 'Power bi desktop workflow overview', 'summary': 'Presents an overview of the workflow of power bi desktop, including data preparation, data modeling, and data visualization, and highlights the tools and views used in each step.', 'duration': 224.808, 'highlights': ['The workflow of Power BI Desktop is divided into three steps: data preparation, data modeling, and data visualization, with specific tools and views for each step.', 'Power BI Desktop provides the query editor for data preparation, relationship view and data view for data modeling, and report view for data visualization.', 'The chapter emphasizes the importance of understanding the interface and the actual data model in Power BI Desktop, highlighting the separate menu for the query editor and the need for detailed coverage in the next video and module.']}, {'end': 2836.781, 'start': 2235.654, 'title': 'Understanding power bi interface', 'summary': 'Explains the interface of power bi desktop, detailing the main areas including ribbons, left column, center part, and right columns, along with functionalities and views associated with each area, emphasizing on the differences in ribbons and functionalities in the query editor, and the tracking and undoing changes feature in the query settings.', 'duration': 601.127, 'highlights': ['The interface of Power BI Desktop consists of four core areas: ribbons, left column, center part, and right columns, with three main views - report view, data view, and relationship view, each offering specific functionalities and visualizations.', 'The ribbons provide different functionalities based on the selected view, with the home ribbon available in all views, the view ribbon exclusively in the report view, and the modeling ribbon mainly in the data view.', 'The query editor in Power BI Desktop presents more ribbons and functionalities compared to the data model, allowing users to track and undo changes through the applied steps table, and offering a formula bar showcasing the M language for shaping and cleaning data, with the possibility to understand the code perspective step by step.', 'The functionalities in the query editor are focused on managing queries and shaping data, with the ability to change the name of queries, track changes through applied steps, and understand the M language through the formula bar.']}, {'end': 3095.751, 'start': 2837.481, 'title': 'Power bi desktop options', 'summary': 'Introduces the power bi desktop options, including global and current file options, and demonstrates how to adjust settings for data detection, relationships, and background data loading for improved performance, preparing for the first course project in the next video.', 'duration': 258.27, 'highlights': ['The chapter covers the interface of the data model and query editor, emphasizing the importance of adjusting Power BI Desktop options before diving into the first project for improved functionality and performance.', 'The options menu in Power BI Desktop provides global and current file options, allowing adjustments to settings that impact data detection, relationships, and background data loading for enhanced control and performance.', 'Three specific adjustments are made to the current file options, including unselecting automatic data detection and relationships, and disabling background data loading for improved understanding of data and performance optimization.']}], 'duration': 1084.905, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/m1eLTtZHGs4/pics/m1eLTtZHGs42010846.jpg', 'highlights': ['The workflow of Power BI Desktop is divided into three steps: data preparation, data modeling, and data visualization, with specific tools and views for each step.', 'The interface of Power BI Desktop consists of four core areas: ribbons, left column, center part, and right columns, with three main views - report view, data view, and relationship view, each offering specific functionalities and visualizations.', 'The options menu in Power BI Desktop provides global and current file options, allowing adjustments to settings that impact data detection, relationships, and background data loading for enhanced control and performance.']}], 'highlights': ['The Udemy course offers a comprehensive introduction to Power BI, spanning 10 hours.', 'Power BI is a suite of business analytics tools enabling data work, report creation, and publishing.', 'Power BI Service offers cloud-based collaboration and dashboard addition to existing data.', 'The process of obtaining GDP data from the IMF World Economic Outlook Database via a web URL is explained, with emphasis on selecting the data at current prices in US dollars and preparing the data in Power BI Desktop for visualization.', 'The chapter emphasizes the importance of categorizing data in Power BI, specifically demonstrating the process of categorizing country-specific data, highlighting its relevance for visualizations.', 'The course will cover topics such as Power BI Desktop functions, query editor, data view, and report view.', 'The workflow of Power BI Desktop is divided into three steps: data preparation, data modeling, and data visualization, with specific tools and views for each step.']}