title
How to use Microsoft Power BI - Tutorial for Beginners

description
In this step-by-step tutorial video, learn how to get started using Microsoft Power BI. Power BI allows you to get insight from your business data. This is an introductory overview of Power BI to get you started. 📚 RESOURCES - Download Power BI here: https://powerbi.microsoft.com/en-us/desktop/ - Kevin Cookie Company Financial Spreadsheet: https://1drv.ms/x/s!AmxrofZZlZ-whJlAigx1zFltyTiC2g?e=e3YVTq - Wikipedia link: https://en.wikipedia.org/wiki/List_of_countries_and_dependencies_by_population - How to use Microsoft Power Automate: https://youtu.be/dDO4Y4aDYXw ⌚ TIMESTAMPS 00:00 Introduction 01:01 Download and install 03:00 Welcome screen 04:20 Sample data overview 06:00 Get data spreadsheet 07:40 Transform data from spreadsheet using Power Query Editor 10:10 Get data from web 11:25 Transform data from web using Power Query Editor 13:10 Join tables by merging queries 14:27 Overview of Power BI layout, including fields and visualizations 16:40 Insert title 17:20 Insert variety of visualizations 22:10 Insert slicer 23:30 Apply theme and change style 25:00 Save and Publish report 26:30 Share with others 27:05 Wrap up 📺 RELATED VIDEOS - Playlist with all my videos on Power BI: https://www.youtube.com/playlist?list=PLlKpQrBME6xIAUqcPjFRPsMQJhgXdJVxe 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/ 🙌 SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same) 🔽 CONNECT WITH ME - Official web site: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://discord.gg/kHuujY2pZf - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ 🎒 MY COURSES - Excel for Beginners in under 2 hours: https://kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 🔔 SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 #stratvert

detail
{'title': 'How to use Microsoft Power BI - Tutorial for Beginners', 'heatmap': [], 'summary': 'Learn microsoft power bi for data analysis, including installation, data integration from excel with flexibility, transforming data using power query editor, adding and visualizing web data, building visualizations for business decisions, and creating and sharing data visualizations and reports in power bi.', 'chapters': [{'end': 329.406, 'segs': [{'end': 58.148, 'src': 'embed', 'start': 0.169, 'weight': 0, 'content': [{'end': 0.75, 'text': 'Hi, everyone.', 'start': 0.169, 'duration': 0.581}, {'end': 1.551, 'text': 'Kevin here.', 'start': 0.89, 'duration': 0.661}, {'end': 5.616, 'text': 'Today, I want to show you how you can use Microsoft Power BI.', 'start': 1.731, 'duration': 3.885}, {'end': 9.58, 'text': 'With Power BI, you can get insights from your data.', 'start': 6.216, 'duration': 3.364}, {'end': 18.231, 'text': 'When I worked at Microsoft, I used Power BI all the time to analyze how our businesses were performing and to make decisions on that performance.', 'start': 10.241, 'duration': 7.99}, {'end': 21.324, 'text': "We're going to walk through a few different things today.", 'start': 19.343, 'duration': 1.981}, {'end': 25.127, 'text': "First off, I'm going to show you how you can both download and install Power BI.", 'start': 21.464, 'duration': 3.663}, {'end': 26.828, 'text': "It's entirely free to do.", 'start': 25.387, 'duration': 1.441}, {'end': 30.35, 'text': "Then we're going to import some sample data into Power BI.", 'start': 27.448, 'duration': 2.902}, {'end': 32.61, 'text': "We're going to create some visualizations off of it.", 'start': 30.47, 'duration': 2.14}, {'end': 37.454, 'text': 'And what good would visualizations be and reports be, unless you could show it to others?', 'start': 33.112, 'duration': 4.342}, {'end': 43.859, 'text': "We're going to save it, publish it and then share it with others so they can get access to your visualizations as well.", 'start': 37.855, 'duration': 6.004}, {'end': 50.043, 'text': 'This is going to be a high level overview of Power BI, more of a 101 or introduction.', 'start': 44.699, 'duration': 5.344}, {'end': 58.148, 'text': "If you want to see me go more in depth in Power BI, leave comments down below, leave some questions, and I'll add them to my list of videos to create.", 'start': 50.583, 'duration': 7.565}], 'summary': 'Learn how to use microsoft power bi for data analysis and visualization, including installation, data import, and sharing insights with others.', 'duration': 57.979, 'max_score': 0.169, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA169.jpg'}, {'end': 142.292, 'src': 'embed', 'start': 101.93, 'weight': 3, 'content': [{'end': 104.011, 'text': "Once you've installed it, you'll be able to launch it.", 'start': 101.93, 'duration': 2.081}, {'end': 108.794, 'text': 'Now once again, downloading Power BI Desktop is entirely free.', 'start': 104.351, 'duration': 4.443}, {'end': 110.274, 'text': "You don't need an enterprise account.", 'start': 108.914, 'duration': 1.36}, {'end': 111.455, 'text': "You don't need a commercial account.", 'start': 110.294, 'duration': 1.161}, {'end': 114.457, 'text': 'Anyone can download Power BI Desktop.', 'start': 111.675, 'duration': 2.782}, {'end': 121.961, 'text': 'The benefit of installing through the Microsoft Store is anytime Power BI updates, you automatically get those updates.', 'start': 115.057, 'duration': 6.904}, {'end': 128.024, 'text': 'Anytime any of the components change, the Microsoft Store will only download the pieces that change.', 'start': 122.401, 'duration': 5.623}, {'end': 130.366, 'text': 'So the updates should be pretty quick and easy.', 'start': 128.184, 'duration': 2.182}, {'end': 136.229, 'text': "And lastly, a nice added benefit is you don't have to be the admin logged onto your machine.", 'start': 130.786, 'duration': 5.443}, {'end': 139.511, 'text': 'You could be any user to go ahead and install Power BI Desktop.', 'start': 136.309, 'duration': 3.202}, {'end': 142.292, 'text': 'This is one way you could download and install.', 'start': 140.211, 'duration': 2.081}], 'summary': 'Power bi desktop is free to download, updates are automatic, and anyone can install it without needing an enterprise or commercial account.', 'duration': 40.362, 'max_score': 101.93, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA101930.jpg'}, {'end': 230.594, 'src': 'embed', 'start': 200.04, 'weight': 5, 'content': [{'end': 205.525, 'text': 'Up here in the top left-hand corner, the most important thing you could do to get started is to get data.', 'start': 200.04, 'duration': 5.485}, {'end': 209.856, 'text': "you can't create visualizations unless you have some data.", 'start': 206.874, 'duration': 2.982}, {'end': 212.439, 'text': "You'll also see recent sources.", 'start': 210.657, 'duration': 1.782}, {'end': 216.282, 'text': "So these are any other data sources that you've used in the past for quick access.", 'start': 212.479, 'duration': 3.803}, {'end': 222.387, 'text': "And down at the bottom, if you've ever used Power BI before, you'll also be able to get back to reports that you've created.", 'start': 216.722, 'duration': 5.665}, {'end': 230.594, 'text': 'Now over on the right hand side, Power BI provides a whole bunch of training content to get you up to speed on how to use Power BI.', 'start': 223.047, 'duration': 7.547}], 'summary': 'Get data to create visualizations in power bi; access recent sources and training content.', 'duration': 30.554, 'max_score': 200.04, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA200040.jpg'}, {'end': 283.359, 'src': 'embed', 'start': 254.06, 'weight': 6, 'content': [{'end': 258.866, 'text': 'and I want to show you how we can analyze some of the sales data for the Kevin Cookie Company.', 'start': 254.06, 'duration': 4.806}, {'end': 267.331, 'text': "Before we get the data in Power BI, I want to just give you a preview of what the data looks like so you know what we're working with today.", 'start': 259.927, 'duration': 7.404}, {'end': 271.233, 'text': 'First off, I have an Excel spreadsheet that contains a whole bunch of data.', 'start': 267.791, 'duration': 3.442}, {'end': 275.355, 'text': 'It happens to be in Excel, but this could also be in, say, a SQL database.', 'start': 271.593, 'duration': 3.762}, {'end': 279.117, 'text': 'It could be a Kusto query that I run to get this output.', 'start': 276.075, 'duration': 3.042}, {'end': 283.359, 'text': "Just think of this as some data that I'm getting, and it just happens to be an Excel spreadsheet,", 'start': 279.297, 'duration': 4.062}], 'summary': 'Analyzing sales data for kevin cookie company using power bi and excel spreadsheet.', 'duration': 29.299, 'max_score': 254.06, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA254060.jpg'}, {'end': 336.308, 'src': 'embed', 'start': 310.101, 'weight': 7, 'content': [{'end': 314.442, 'text': "We've sold a certain number of cookies in each of these markets and I've listed out how many sales.", 'start': 310.101, 'duration': 4.341}, {'end': 322.384, 'text': 'You have the revenue for each type of cookie, the cost, the overall revenue, then we have the overall cost, and then you have the profit.', 'start': 314.922, 'duration': 7.462}, {'end': 329.406, 'text': 'Then for the last few columns, we also list out the date, the month, and then also the year when these sales occurred.', 'start': 323.084, 'duration': 6.322}, {'end': 332.127, 'text': "That's a quick view of what's in this spreadsheet.", 'start': 329.906, 'duration': 2.221}, {'end': 336.308, 'text': "I'm also going to pull in one other source of data into Power BI as well.", 'start': 332.607, 'duration': 3.701}], 'summary': 'Data includes cookie sales, revenue, cost, and profit by date, month, and year.', 'duration': 26.207, 'max_score': 310.101, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA310101.jpg'}], 'start': 0.169, 'title': 'Using microsoft power bi for data analysis', 'summary': 'Provides an introduction to microsoft power bi, including installation methods, and covers analyzing sales data for kevin cookie company using an excel spreadsheet, with details on product sales, revenue, cost, and profit, and sales occurrence dates.', 'chapters': [{'end': 58.148, 'start': 0.169, 'title': 'Introduction to microsoft power bi', 'summary': 'Introduces how to use microsoft power bi to gain insights from data, including free download and installation, importing sample data, creating visualizations, and sharing reports with others.', 'duration': 57.979, 'highlights': ["Kevin used Power BI at Microsoft to analyze business performance and make decisions, emphasizing its practical use (quantifiable data: Kevin's personal experience).", 'The demonstration covers downloading and installing Power BI for free, importing sample data, creating visualizations, and sharing reports (quantifiable data: steps in the demonstration).', 'The chapter offers a high-level overview of Power BI, inviting viewers to request more in-depth content (quantifiable data: call to action for viewer engagement).']}, {'end': 232.496, 'start': 58.888, 'title': 'Installing power bi desktop', 'summary': 'Explains two methods to install power bi desktop - through the microsoft store or by downloading an exe file, emphasizing the ease and benefits of the microsoft store installation and the importance of getting data to create visualizations, and the availability of training content.', 'duration': 173.608, 'highlights': ['Power BI Desktop is entirely free to download and install, available for anyone without the need for enterprise or commercial accounts. Power BI Desktop is free for all to download and install, with no requirement for enterprise or commercial accounts, ensuring accessibility.', 'Microsoft Store installation ensures automatic updates and quick downloads of only the changed components, offering convenience and efficiency. Installing through the Microsoft Store provides automatic updates and quick downloads of only the changed components, ensuring convenience and efficiency.', 'The importance of getting data is emphasized as a prerequisite for creating visualizations in Power BI, highlighting the need to access recent sources and training content for quick access and upskilling. Emphasizing the importance of getting data as a prerequisite for creating visualizations, with a focus on quick access to recent sources and training content for upskilling.']}, {'end': 329.406, 'start': 232.496, 'title': 'Analyzing sales data for kevin cookie company', 'summary': 'Covers analyzing sales data for kevin cookie company using an excel spreadsheet containing revenue, cost, and profit data, with details on product sales, revenue, cost, and profit, and sales occurrence dates.', 'duration': 96.91, 'highlights': ['The data includes revenue, cost, and profit data for Kevin Cookie Company. The Excel spreadsheet contains revenue, cost, and profit data for the Kevin Cookie Company, including details on product sales, revenue, cost, and profit.', 'Details on product sales, revenue, cost, and profit are provided. The sales data includes information on the number of cookies sold, revenue for each type of cookie, cost, overall revenue, overall cost, and profit for the Kevin Cookie Company.', 'Information on sales occurrence dates is included. The data also lists out the date, the month, and the year when the sales occurred for the Kevin Cookie Company.']}], 'duration': 329.237, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA169.jpg', 'highlights': ["Kevin used Power BI at Microsoft to analyze business performance and make decisions, emphasizing its practical use (quantifiable data: Kevin's personal experience).", 'The demonstration covers downloading and installing Power BI for free, importing sample data, creating visualizations, and sharing reports (quantifiable data: steps in the demonstration).', 'The chapter offers a high-level overview of Power BI, inviting viewers to request more in-depth content (quantifiable data: call to action for viewer engagement).', 'Power BI Desktop is entirely free to download and install, available for anyone without the need for enterprise or commercial accounts, ensuring accessibility.', 'Microsoft Store installation ensures automatic updates and quick downloads of only the changed components, offering convenience and efficiency.', 'The importance of getting data is emphasized as a prerequisite for creating visualizations in Power BI, highlighting the need to access recent sources and training content for quick access and upskilling.', 'The data includes revenue, cost, and profit data for Kevin Cookie Company. The Excel spreadsheet contains revenue, cost, and profit data for the Kevin Cookie Company, including details on product sales, revenue, cost, and profit.', 'Details on product sales, revenue, cost, and profit are provided. The sales data includes information on the number of cookies sold, revenue for each type of cookie, cost, overall revenue, overall cost, and profit for the Kevin Cookie Company.', 'Information on sales occurrence dates is included. The data also lists out the date, the month, and the year when the sales occurred for the Kevin Cookie Company.']}, {'end': 606.267, 'segs': [{'end': 369.39, 'src': 'embed', 'start': 345.374, 'weight': 2, 'content': [{'end': 351.838, 'text': 'For my analysis in Power BI, I want to show all the countries where we have locations and I also want to align it with the population.', 'start': 345.374, 'duration': 6.464}, {'end': 358.803, 'text': 'Once again, I have a link to this spreadsheet and a link to this website URL on Wikipedia in the description,', 'start': 352.619, 'duration': 6.184}, {'end': 360.745, 'text': 'if you want to follow along with this example.', 'start': 358.803, 'duration': 1.942}, {'end': 366.389, 'text': "Now that we've taken a look at what type of data we're going to be working with, let's go ahead now and click on Get Data.", 'start': 361.145, 'duration': 5.244}, {'end': 369.39, 'text': 'This brings up the get data dialogue.', 'start': 366.929, 'duration': 2.461}], 'summary': 'Analyze countries with locations and align with population data in power bi.', 'duration': 24.016, 'max_score': 345.374, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA345374.jpg'}, {'end': 407.641, 'src': 'embed', 'start': 380.633, 'weight': 0, 'content': [{'end': 384.954, 'text': "Chances are, if you have data somewhere, you'll be able to pull it into Power BI.", 'start': 380.633, 'duration': 4.321}, {'end': 391.936, 'text': "Today, we're starting out with a simple example and we're just going to use a spreadsheet and it's an Excel spreadsheet.", 'start': 385.914, 'duration': 6.022}, {'end': 394.697, 'text': "So I'll click on Excel and then click on Connect.", 'start': 392.016, 'duration': 2.681}, {'end': 399.818, 'text': 'Next, this brings up the file picker and I see the file here on my desktop.', 'start': 395.197, 'duration': 4.621}, {'end': 402.959, 'text': "If you're following along and you downloaded the spreadsheet,", 'start': 400.139, 'duration': 2.82}, {'end': 407.641, 'text': 'feel free to navigate to where you downloaded the spreadsheet and go ahead and then click on Open.', 'start': 402.959, 'duration': 4.682}], 'summary': 'Power bi can easily connect to data sources like excel, making it accessible and user-friendly.', 'duration': 27.008, 'max_score': 380.633, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA380633.jpg'}, {'end': 537.038, 'src': 'embed', 'start': 497.113, 'weight': 3, 'content': [{'end': 501.576, 'text': "we've seen that the profitability of selling fortune cookies isn't that high,", 'start': 497.113, 'duration': 4.463}, {'end': 505.859, 'text': "and it's been distracting us from our other products and our other business lines.", 'start': 501.576, 'duration': 4.283}, {'end': 508.561, 'text': 'So I want to remove it from this analysis.', 'start': 506.319, 'duration': 2.242}, {'end': 512.604, 'text': "So I'm going to go ahead now and uncheck fortune cookie and then click on OK.", 'start': 508.621, 'duration': 3.983}, {'end': 517.107, 'text': "So now by doing these changes, I'm starting to transform the data.", 'start': 513.144, 'duration': 3.963}, {'end': 522.69, 'text': "Now when I look over at units sold, you'll see that I also have some decimals here.", 'start': 517.947, 'duration': 4.743}, {'end': 527.453, 'text': 'For United States chocolate chip cookie in one month, we sold 0.5 cookies.', 'start': 523.11, 'duration': 4.343}, {'end': 533.796, 'text': "Now that doesn't make any sense and so I want to eliminate decimals from the data analysis that we're going to do.", 'start': 527.493, 'duration': 6.303}, {'end': 537.038, 'text': "And so what I'm going to do is I'm going to click on the unit sold column.", 'start': 534.256, 'duration': 2.782}], 'summary': 'Removing fortune cookies from analysis and eliminating decimals from unit sold data.', 'duration': 39.925, 'max_score': 497.113, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA497113.jpg'}, {'end': 581.287, 'src': 'embed', 'start': 555.316, 'weight': 5, 'content': [{'end': 560.92, 'text': "So I'm gonna just double click on this column header and I'm gonna get rid of month name and we're just gonna call this column month.", 'start': 555.316, 'duration': 5.604}, {'end': 568.282, 'text': "As I go through and I make all of these changes over on the right hand side, you'll see this section called applied steps.", 'start': 561.42, 'duration': 6.862}, {'end': 572.284, 'text': "These are all the different transformations I'm making to the data.", 'start': 568.783, 'duration': 3.501}, {'end': 576.725, 'text': "So let's say that maybe I made a change and I didn't really intend to make that change.", 'start': 572.584, 'duration': 4.141}, {'end': 578.486, 'text': 'I can remove that step.', 'start': 577.166, 'duration': 1.32}, {'end': 579.646, 'text': 'So here is an example.', 'start': 578.546, 'duration': 1.1}, {'end': 581.287, 'text': 'You see this filtered row.', 'start': 580.027, 'duration': 1.26}], 'summary': 'Data transformations and steps can be edited and removed in the process.', 'duration': 25.971, 'max_score': 555.316, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA555316.jpg'}], 'start': 329.906, 'title': 'Power bi data integration and transformation', 'summary': 'Covers importing data from excel into power bi, emphasizing its flexibility in integrating data from various sources, and explains the process of transforming data in power bi using power query editor, including specific actions and steps for data transformation.', 'chapters': [{'end': 438.688, 'start': 329.906, 'title': 'Integrating data into power bi', 'summary': 'Discusses importing data from an excel spreadsheet into power bi, including the process of retrieving and selecting specific data from the spreadsheet, and emphasizes the flexibility of power bi in integrating data from various sources.', 'duration': 108.782, 'highlights': ['Power BI allows for importing data from various sources such as Excel spreadsheets, web, and SQL databases, offering flexibility and accessibility to different data repositories.', 'The process of importing data from an Excel spreadsheet into Power BI involves selecting specific data items, such as financial tables, and navigating through a data navigator interface.', 'The chapter emphasizes the importance of aligning data with the population, as demonstrated through the integration of country location data with population data from a Wikipedia article.']}, {'end': 606.267, 'start': 439.429, 'title': 'Transforming data in power bi', 'summary': 'Explains the process of transforming data in power bi using power query editor, including removing unprofitable products and decimals from the analysis, and managing applied steps for data transformation.', 'duration': 166.838, 'highlights': ['The process of removing unprofitable products, like fortune cookies, from the data analysis. The speaker explains the decision to cut the product line of fortune cookies due to its low profitability and distraction from other products and business lines.', "Converting decimals to whole numbers in the 'units sold' column for accurate data analysis. The speaker demonstrates the action of eliminating decimals from the data analysis by converting the 'units sold' column into whole numbers.", 'Managing applied steps for data transformation, including the ability to undo or remove specific transformations if unintended. The speaker discusses the applied steps section, allowing the user to review and undo specific transformations, such as filtering out fortune cookies, and the flexibility to delete a step to remove a transformation.']}], 'duration': 276.361, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA329906.jpg', 'highlights': ['Power BI offers flexibility in importing data from Excel, web, and SQL databases.', 'Importing data from Excel into Power BI involves selecting specific data items and navigating through a data navigator interface.', 'Aligning data with the population is emphasized through integrating country location data with population data from a Wikipedia article.', 'Removing unprofitable products like fortune cookies from the data analysis is demonstrated.', "Converting decimals to whole numbers in the 'units sold' column for accurate data analysis is explained.", 'Managing applied steps for data transformation, including the ability to undo or remove specific transformations if unintended, is discussed.']}, {'end': 990.153, 'segs': [{'end': 647.837, 'src': 'embed', 'start': 606.707, 'weight': 0, 'content': [{'end': 612.35, 'text': "All of this data looks pretty good now and I feel good about it and I'm ready to bring this into Power BI.", 'start': 606.707, 'duration': 5.643}, {'end': 619.653, 'text': 'One thing I want to do though before I bring this data in is I also wanted to bring in population for these different countries.', 'start': 612.89, 'duration': 6.763}, {'end': 627.056, 'text': "To do that, I'm going to go up to the top ribbon and I'm going to click on new source and this data is coming from the web.", 'start': 620.213, 'duration': 6.843}, {'end': 634.562, 'text': "Now, once again, I could click on more and that'll bring up the same data source dialog that we saw earlier, but I also see web highlighted here.", 'start': 627.257, 'duration': 7.305}, {'end': 637.145, 'text': "So I'm going to click here because that's easier to pull this up.", 'start': 634.583, 'duration': 2.562}, {'end': 639.908, 'text': 'This brings up the from web dialog.', 'start': 637.606, 'duration': 2.302}, {'end': 643.772, 'text': "And what I'm going to do here is it asks me for the URL.", 'start': 640.189, 'duration': 3.583}, {'end': 647.837, 'text': "So I'm going to go ahead and paste the Wikipedia site URL within here.", 'start': 643.812, 'duration': 4.025}], 'summary': 'Preparing to bring data into power bi, adding population data from web source.', 'duration': 41.13, 'max_score': 606.707, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA606707.jpg'}, {'end': 695.38, 'src': 'embed', 'start': 670.513, 'weight': 2, 'content': [{'end': 678.618, 'text': 'Now, this is really cool that if you find a table on some website, you can pull that in as a data source into Power BI.', 'start': 670.513, 'duration': 8.105}, {'end': 683.464, 'text': "Once I'm satisfied with this table and everything looks good, I'm going to click on OK.", 'start': 679.258, 'duration': 4.206}, {'end': 687.75, 'text': 'Over on the left-hand side now, you see that I have two different queries.', 'start': 683.824, 'duration': 3.926}, {'end': 692.076, 'text': 'One of them is my cookie sales and the other one is the Wikipedia article.', 'start': 687.89, 'duration': 4.186}, {'end': 695.38, 'text': "I'm going to right-click on this and give it a name that makes more sense.", 'start': 692.456, 'duration': 2.924}], 'summary': 'Power bi allows importing tables from websites as data sources, creating queries for analysis.', 'duration': 24.867, 'max_score': 670.513, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA670513.jpg'}, {'end': 827.847, 'src': 'embed', 'start': 801.361, 'weight': 4, 'content': [{'end': 806.303, 'text': "I'm gonna go up to merge queries And I want to connect it based on the country name.", 'start': 801.361, 'duration': 4.942}, {'end': 809.144, 'text': "So I'm going to select the country name here in my cookie sales data.", 'start': 806.323, 'duration': 2.821}, {'end': 813.965, 'text': "And then in my country populations, I'm going to connect it based on the country name.", 'start': 809.704, 'duration': 4.261}, {'end': 815.785, 'text': 'It asks me about privacy.', 'start': 814.345, 'duration': 1.44}, {'end': 817.766, 'text': "I'm going to ignore privacy checks for now.", 'start': 815.865, 'duration': 1.901}, {'end': 820.526, 'text': "This is just Kevin Cookie Company, so I'm not too worried.", 'start': 818.106, 'duration': 2.42}, {'end': 822.126, 'text': "I'll go ahead and save that.", 'start': 820.846, 'duration': 1.28}, {'end': 827.847, 'text': 'And it looks like every single row in my Kevin Cookie Company table has a match with populations.', 'start': 822.687, 'duration': 5.16}], 'summary': 'Merged queries by country name, all kevin cookie company rows matched with populations.', 'duration': 26.486, 'max_score': 801.361, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA801361.jpg'}, {'end': 888.244, 'src': 'embed', 'start': 861.642, 'weight': 5, 'content': [{'end': 866.706, 'text': "And the next thing I do now is over here in the top left-hand corner, let's click on close and apply.", 'start': 861.642, 'duration': 5.064}, {'end': 872.811, 'text': "Now that we've created our data models, Power BI drops us on a blank canvas.", 'start': 867.947, 'duration': 4.864}, {'end': 878.316, 'text': 'I want to take a moment to walk through and orient you to where we are right now.', 'start': 873.171, 'duration': 5.145}, {'end': 885.061, 'text': 'Right here in the center of the page, this big blank area, this is called the report editor.', 'start': 879.376, 'duration': 5.685}, {'end': 888.244, 'text': "This is the canvas where we're going to create all of our visuals.", 'start': 885.121, 'duration': 3.123}], 'summary': 'In power bi, after creating data models, the report editor is where visuals are created.', 'duration': 26.602, 'max_score': 861.642, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA861642.jpg'}], 'start': 606.707, 'title': 'Power bi data integration', 'summary': 'Demonstrates adding population data from the web to power bi for dynamic analysis, and covers data transformation and visualization, including merging tables and connecting population data with cookie sales data.', 'chapters': [{'end': 692.076, 'start': 606.707, 'title': 'Adding population data from web to power bi', 'summary': 'Demonstrates how to bring population data from a web source into power bi, enabling users to easily integrate external data sets into their analysis, providing an efficient and dynamic approach to enriching their visualizations.', 'duration': 85.369, 'highlights': ['Bringing in population data from a web source allows for enriching the analysis in Power BI, providing additional context and depth to visualizations.', 'The process of importing data from a web source into Power BI involves pasting the URL, navigating through the elements, and selecting the desired data, enabling a seamless integration of external data sets.', "The ability to import tables from websites directly into Power BI demonstrates the platform's flexibility and efficiency in handling diverse data sources."]}, {'end': 990.153, 'start': 692.456, 'title': 'Data transformation and visualization in power bi', 'summary': 'Covers transforming data by removing unnecessary columns, filtering specific countries, and merging tables to connect population data with cookie sales data in power bi, leading to successful data modeling and visualization.', 'duration': 297.697, 'highlights': ['The chapter focuses on transforming data by removing unnecessary columns, filtering specific countries, and merging tables to connect population data with cookie sales data in Power BI, resulting in successful data modeling and visualization.', 'The speaker demonstrates the process of merging queries and connecting tables based on the country name, ensuring that every row in the Kevin Cookie Company table has a match with populations, which is crucial for successful data analysis and visualization.', 'The chapter provides an overview of the report editor, fields, visuals, and different types of views in Power BI, offering a comprehensive understanding of the tools and functionalities available for data modeling and visualization.']}], 'duration': 383.446, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA606707.jpg', 'highlights': ['Bringing in population data from a web source enriches Power BI analysis.', 'Importing data from a web source into Power BI involves pasting the URL and selecting desired data.', "Importing tables from websites into Power BI demonstrates platform's flexibility.", 'Transforming data involves removing unnecessary columns and merging tables in Power BI.', 'Merging queries and connecting tables based on country name ensures successful data modeling.', 'Chapter provides an overview of report editor, fields, visuals, and different types of views in Power BI.']}, {'end': 1218.14, 'segs': [{'end': 1027.46, 'src': 'embed', 'start': 990.153, 'weight': 2, 'content': [{'end': 1000.576, 'text': "and so that's why those two items highlight let's go back and click into report and let's go ahead and start building some visualizations to help us make decisions based on our business data.", 'start': 990.153, 'duration': 10.423}, {'end': 1007.028, 'text': 'The first thing I want to do is I have this blank canvas and I should give a little bit of context when people look at this report.', 'start': 1001.064, 'duration': 5.964}, {'end': 1013.632, 'text': "So what I'm going to do is when I click on the home option on the ribbon, there's an option to insert a text box.", 'start': 1007.468, 'duration': 6.164}, {'end': 1017.754, 'text': "I'm going to click on that and let me insert a title for this report,", 'start': 1013.672, 'duration': 4.082}, {'end': 1021.316, 'text': "and maybe I'll go ahead and call this the Kevin Cookie Company Performance Report.", 'start': 1017.754, 'duration': 3.562}, {'end': 1022.477, 'text': 'I type in the name.', 'start': 1021.616, 'duration': 0.861}, {'end': 1027.46, 'text': "Let me make it a little larger just so it helps frame the entire report that we're going to,", 'start': 1022.657, 'duration': 4.803}], 'summary': 'Building visualizations to make decisions based on business data, starting with creating a title for the kevin cookie company performance report.', 'duration': 37.307, 'max_score': 990.153, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA990153.jpg'}, {'end': 1101.358, 'src': 'embed', 'start': 1074.102, 'weight': 0, 'content': [{'end': 1079.486, 'text': 'When I hover over the item, I see a tool tip that shows me the exact value, and when I hover over 2019,', 'start': 1074.102, 'duration': 5.384}, {'end': 1083.228, 'text': 'I see that we had a little over $2 million worth of profit.', 'start': 1079.486, 'duration': 3.742}, {'end': 1090.214, 'text': "Over on the right-hand side, let's say that I want to see the profit data not by year but I want to see it by the month.", 'start': 1083.669, 'duration': 6.545}, {'end': 1097.196, 'text': "So what I could do is I'm going to click on this dropdown and instead of doing date hierarchy, I'm going to switch it to date.", 'start': 1090.874, 'duration': 6.322}, {'end': 1101.358, 'text': 'and now this will show me the month by month and year view of what profit was like.', 'start': 1097.196, 'duration': 4.162}], 'summary': 'Hovering over 2019 reveals $2 million profit, switching to monthly view provides detailed profit data.', 'duration': 27.256, 'max_score': 1074.102, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1074102.jpg'}, {'end': 1209.39, 'src': 'embed', 'start': 1185.113, 'weight': 1, 'content': [{'end': 1193.378, 'text': 'So here it looks like North America, Canada and also France all had about the same amount of profit, while Germany and Mexico are smaller dots,', 'start': 1185.113, 'duration': 8.265}, {'end': 1195.139, 'text': 'indicating that there was less profit there.', 'start': 1193.378, 'duration': 1.761}, {'end': 1198.501, 'text': 'I could also once again, if I want to switch the type of view,', 'start': 1196, 'duration': 2.501}, {'end': 1203.564, 'text': 'I could switch it to a tree map and here I could see profit by country this way as well.', 'start': 1198.501, 'duration': 5.063}, {'end': 1209.39, 'text': 'So here once again I can see which country had the most profit all the way down to which country had the least.', 'start': 1204.184, 'duration': 5.206}], 'summary': 'North america, canada, and france had similar profit, while germany and mexico had less profit.', 'duration': 24.277, 'max_score': 1185.113, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1185113.jpg'}], 'start': 990.153, 'title': 'Visualizing business decisions', 'summary': 'Covers building visualizations for business decisions, including creating power bi report visualizations for profit analysis, such as geographical profit analysis with the highest profit recorded in 2019 being over $2 million.', 'chapters': [{'end': 1027.46, 'start': 990.153, 'title': 'Building visualizations for business decisions', 'summary': "Discusses the process of building visualizations to aid in making business decisions, starting with adding a title to a report and framing it as the 'kevin cookie company performance report'.", 'duration': 37.307, 'highlights': ["The process of adding a title 'Kevin Cookie Company Performance Report' to the blank canvas report helps to provide context for the business data (e.g., sales, revenue, etc.) being visualized.", 'The chapter emphasizes the importance of visualizations in aiding decision-making based on business data, highlighting the need to make the title of the report larger to frame the entire report effectively.']}, {'end': 1218.14, 'start': 1027.7, 'title': 'Power bi report visualization', 'summary': 'Covers creating visualizations in a power bi report, such as profit analysis by date using bar and line charts, and geographical profit analysis using map and treemap visualizations, with the highest profit recorded in 2019 being over $2 million.', 'duration': 190.44, 'highlights': ['The highest profit recorded in 2019 was a little over $2 million, with $650,000 profit in 2018. The chapter discusses the profit analysis by date, showing that in 2019, there was a little over $2 million of profit, while in 2018, there was about $650,000 of profit.', 'The map visualization indicated that North America, Canada, and France had about the same amount of profit, while Germany and Mexico had less profit. The geographical profit analysis using the map visualization showed that North America, Canada, and France had similar profit levels, while Germany and Mexico had comparatively less profit.', 'The chapter explains the process of creating visualizations, including bar and line charts for profit analysis by date, and map and treemap visualizations for geographical profit analysis. The chapter provides a detailed explanation of creating visualizations, such as bar and line charts for profit analysis by date, and map and treemap visualizations for geographical profit analysis.']}], 'duration': 227.987, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA990153.jpg', 'highlights': ['The highest profit recorded in 2019 was over $2 million, with $650,000 profit in 2018.', 'The map visualization indicated that North America, Canada, and France had about the same amount of profit, while Germany and Mexico had less profit.', "The process of adding a title 'Kevin Cookie Company Performance Report' to the blank canvas report helps to provide context for the business data being visualized.", 'The chapter emphasizes the importance of visualizations in aiding decision-making based on business data.']}, {'end': 1658.263, 'segs': [{'end': 1283.373, 'src': 'embed', 'start': 1219.181, 'weight': 7, 'content': [{'end': 1225.726, 'text': "want to do is insert a table that'll show me the population and then the units sold for that population.", 'start': 1219.181, 'duration': 6.545}, {'end': 1227.388, 'text': "So here I'm going to click on table.", 'start': 1225.766, 'duration': 1.622}, {'end': 1228.969, 'text': 'This will insert a table.', 'start': 1227.848, 'duration': 1.121}, {'end': 1234.994, 'text': "Now when I click on the visualization first without selecting any of the data, it'll simply insert a blank table.", 'start': 1229.029, 'duration': 5.965}, {'end': 1236.195, 'text': 'Let me pull it up here.', 'start': 1235.034, 'duration': 1.161}, {'end': 1241.239, 'text': 'I could easily drag and drop things around to organize my report how I see fit.', 'start': 1236.635, 'duration': 4.604}, {'end': 1244.501, 'text': "Here what I'm going to do is I'm going to pull in the population.", 'start': 1241.379, 'duration': 3.122}, {'end': 1249.086, 'text': 'So here I have a field for population, country population.', 'start': 1245.382, 'duration': 3.704}, {'end': 1250.488, 'text': "Let's go ahead and drop that in.", 'start': 1249.186, 'duration': 1.302}, {'end': 1253.511, 'text': 'And then I also want to pull in the different countries.', 'start': 1251.349, 'duration': 2.162}, {'end': 1256.735, 'text': 'Now I can see the country, the population for that country.', 'start': 1253.932, 'duration': 2.803}, {'end': 1260.94, 'text': 'The next thing I want to do is also how many units were sold for each of those countries.', 'start': 1257.075, 'duration': 3.865}, {'end': 1267.042, 'text': "Here now I have a table and let me go ahead and I'll position country first.", 'start': 1262.819, 'duration': 4.223}, {'end': 1274.607, 'text': 'So here now I could see the country, what the population of the country is, and I can also see how many units were sold for that country.', 'start': 1267.562, 'duration': 7.045}, {'end': 1281.311, 'text': "Now, a little beyond what we're going to do today, but some of the things you could do, you could also insert calculated fields.", 'start': 1275.247, 'duration': 6.064}, {'end': 1283.373, 'text': 'So you could do things like per capita.', 'start': 1281.592, 'duration': 1.781}], 'summary': 'Insert a table to display country population and units sold, enabling easy data organization and visualization.', 'duration': 64.192, 'max_score': 1219.181, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1219181.jpg'}, {'end': 1344.931, 'src': 'embed', 'start': 1321.014, 'weight': 6, 'content': [{'end': 1328.54, 'text': 'So here I could see that chocolate chip cookies generated the highest amount of profit and then the fortune cookies generated the least amount of profit.', 'start': 1321.014, 'duration': 7.526}, {'end': 1334.964, 'text': "now that i've inserted all of these different visuals into my report, it's also very easy to slice the data.", 'start': 1328.9, 'duration': 6.064}, {'end': 1342.349, 'text': "so here i can bring in a slicer, i'm going to insert that and then i'm going to drag and drop the country name on the slicer.", 'start': 1334.964, 'duration': 7.385}, {'end': 1344.931, 'text': 'so here, if i just want to view data for the united states,', 'start': 1342.349, 'duration': 2.582}], 'summary': 'Chocolate chip cookies generated highest profit, fortune cookies generated least profit. visuals inserted for easy data slicing.', 'duration': 23.917, 'max_score': 1321.014, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1321014.jpg'}, {'end': 1386.354, 'src': 'embed', 'start': 1360.339, 'weight': 4, 'content': [{'end': 1367.883, 'text': 'I could see the population and then I could also see which product was the most profitable very quickly, simply by selecting the market.', 'start': 1360.339, 'duration': 7.544}, {'end': 1374.707, 'text': 'Another way I could also slice the data is rather than inserting a slicer, I could also click into my different visuals.', 'start': 1368.363, 'duration': 6.344}, {'end': 1381.251, 'text': 'So here if I click on the map on the United States, this too also serves as a quick way to slice my data.', 'start': 1374.767, 'duration': 6.484}, {'end': 1386.354, 'text': 'So here I could just see Germany data, I could see France data, or here I could see Mexico data.', 'start': 1381.311, 'duration': 5.043}], 'summary': 'Data visualization allows quick analysis of population and profitable products by selecting markets and visuals.', 'duration': 26.015, 'max_score': 1360.339, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1360339.jpg'}, {'end': 1447.082, 'src': 'embed', 'start': 1418.65, 'weight': 5, 'content': [{'end': 1424.433, 'text': 'If I go up to the ribbon and I click on view, under themes I have all these different themes that I can apply.', 'start': 1418.65, 'duration': 5.783}, {'end': 1427.414, 'text': 'Now, maybe the executive theme would be a nice one.', 'start': 1424.933, 'duration': 2.481}, {'end': 1433.717, 'text': "so let me click on executive and here you'll notice that the colors changed and it looks a little bit more professional in my opinion.", 'start': 1427.414, 'duration': 6.303}, {'end': 1438.759, 'text': 'I can also adjust the look of my different visuals that I have within this report.', 'start': 1434.597, 'duration': 4.162}, {'end': 1447.082, 'text': 'So if I click on the visual over here under visualizations, the initial view is the field view, but here I could click on format.', 'start': 1438.799, 'duration': 8.283}], 'summary': 'Demonstrating the use of different themes and visual customizations in a report.', 'duration': 28.432, 'max_score': 1418.65, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1418650.jpg'}, {'end': 1615.849, 'src': 'embed', 'start': 1533.478, 'weight': 0, 'content': [{'end': 1536.379, 'text': 'To share the report with others, first we need to publish it.', 'start': 1533.478, 'duration': 2.901}, {'end': 1538.24, 'text': "So let's go up to the File menu.", 'start': 1536.459, 'duration': 1.781}, {'end': 1541.702, 'text': "We're going to go down to Publish, and then we're going to publish to Power BI.", 'start': 1538.38, 'duration': 3.322}, {'end': 1547.445, 'text': 'The Power BI service is what houses all of these different reports that we publish.', 'start': 1542.842, 'duration': 4.603}, {'end': 1548.506, 'text': "So I'm going to go ahead.", 'start': 1547.745, 'duration': 0.761}, {'end': 1549.827, 'text': "Let's click on Power BI.", 'start': 1548.546, 'duration': 1.281}, {'end': 1554.89, 'text': "And it says, do you want to save your changes? I'll go ahead and save the changes again before I publish.", 'start': 1550.407, 'duration': 4.483}, {'end': 1557.432, 'text': 'And then it asks me to choose a destination.', 'start': 1555.35, 'duration': 2.082}, {'end': 1560.514, 'text': "I'm going to go ahead and select my workspace.", 'start': 1557.452, 'duration': 3.062}, {'end': 1566.65, 'text': 'Look at that, it looks like it was successful at saving it to the Power BI service.', 'start': 1562.509, 'duration': 4.141}, {'end': 1573.172, 'text': 'Now what I could do is if I click on open Kevin Cookie Company report PBIX, I could open it in Power BI.', 'start': 1567.21, 'duration': 5.962}, {'end': 1575.673, 'text': "Let's go ahead and open it and see what this looks like.", 'start': 1573.532, 'duration': 2.141}, {'end': 1583.835, 'text': 'This will open up the Power BI service and here I can see my Kevin Cookie Company report on powerbi.com,', 'start': 1576.193, 'duration': 7.642}, {'end': 1589.457, 'text': 'and here too I could go ahead and filter the data, just like I did in the Power BI desktop application.', 'start': 1583.835, 'duration': 5.622}, {'end': 1596.6, 'text': 'The nice thing about putting it on the web is, if I want other people to come in and to see my visuals that I created,', 'start': 1590.137, 'duration': 6.463}, {'end': 1599.701, 'text': 'I can go up to the top right hand corner and I can click on share.', 'start': 1596.6, 'duration': 3.101}, {'end': 1604.003, 'text': 'This opens up the shared dialogue and I have all sorts of different options here.', 'start': 1600.122, 'duration': 3.881}, {'end': 1608.365, 'text': 'I can go ahead and grant access to different individuals by entering in their email address.', 'start': 1604.083, 'duration': 4.282}, {'end': 1612.147, 'text': 'I could also go ahead and I can allow them to share the report with others.', 'start': 1608.826, 'duration': 3.321}, {'end': 1615.849, 'text': 'I can let them create new content based on the underlying data sets.', 'start': 1612.547, 'duration': 3.302}], 'summary': 'Publish kevin cookie company report to power bi service and share with others', 'duration': 82.371, 'max_score': 1533.478, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1533478.jpg'}], 'start': 1219.181, 'title': 'Creating data visualizations and sharing reports in power bi', 'summary': 'Covers creating table and profit visualizations, including population and sales data, with the potential for calculated fields, customizing report appearance, and sharing reports via power bi service, including saving, publishing, opening on powerbi.com, and sharing with defined permissions.', 'chapters': [{'end': 1283.373, 'start': 1219.181, 'title': 'Creating table visualization', 'summary': "Explains how to create a table visualization in a report, allowing the display of population and units sold for different countries, and also mentions the potential for inserting calculated fields like 'per capita'.", 'duration': 64.192, 'highlights': ['The chapter explains the process of inserting a table to display population and units sold for different countries, and also mentions the ability to organize the report layout.', "It details the steps for pulling in the population and different countries' data to create a table visualization, allowing the display of the country's population and the units sold.", "The chapter briefly mentions the potential to insert calculated fields, such as 'per capita', to enhance the analysis."]}, {'end': 1513.309, 'start': 1283.373, 'title': 'Creating profit visualization report', 'summary': "Demonstrates creating a profit visualization report, showing sales by product through a bar chart, allowing for easy data slicing by country and highlighting the highest and lowest profit-generating products, with the ability to customize the report's look and feel using different themes and formats.", 'duration': 229.936, 'highlights': ['Creating a bar chart to display sales by product, revealing chocolate chip cookies as the highest profit generator and fortune cookies as the lowest. The bar chart displays sales by product, highlighting chocolate chip cookies as the highest profit generator and fortune cookies as the lowest.', 'Demonstrating the ease of data slicing by country to view profit and product performance for different markets. The report showcases the ease of slicing data by country, allowing quick insights into profit and product performance for different markets.', "Customizing the report's look and feel using different themes and formats, such as applying the executive theme and adjusting visual elements. The chapter illustrates the process of customizing the report's look and feel using different themes and formats, such as applying the executive theme and adjusting visual elements."]}, {'end': 1658.263, 'start': 1514.309, 'title': 'Sharing reports in power bi', 'summary': 'Discusses the process of publishing and sharing reports in power bi, including saving, publishing to power bi service, opening the report on powerbi.com, and sharing the report with others via email, granting access, and defining permissions.', 'duration': 143.954, 'highlights': ['The Power BI service houses the reports that are published, allowing others to view and interact with the created views.', 'The process involves publishing the report to Power BI service, selecting a destination workspace, and saving the report successfully.', 'The report can be opened on powerbi.com, allowing filtering of data similar to the Power BI desktop application.', 'The sharing process includes granting access to individuals, allowing them to share the report, create new content, and sending email notifications with included changes.', 'The chapter provides a high-level overview of using Power BI and encourages viewers to leave comments for deeper dives into specific topics and to engage with the content for future videos.']}], 'duration': 439.082, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/TmhQCQr_DCA/pics/TmhQCQr_DCA1219181.jpg', 'highlights': ['The Power BI service houses the reports that are published, allowing others to view and interact with the created views.', 'The process involves publishing the report to Power BI service, selecting a destination workspace, and saving the report successfully.', 'The report can be opened on powerbi.com, allowing filtering of data similar to the Power BI desktop application.', 'The sharing process includes granting access to individuals, allowing them to share the report, create new content, and sending email notifications with included changes.', 'Demonstrating the ease of data slicing by country to view profit and product performance for different markets. The report showcases the ease of slicing data by country, allowing quick insights into profit and product performance for different markets.', "Customizing the report's look and feel using different themes and formats, such as applying the executive theme and adjusting visual elements. The chapter illustrates the process of customizing the report's look and feel using different themes and formats, such as applying the executive theme and adjusting visual elements.", 'Creating a bar chart to display sales by product, revealing chocolate chip cookies as the highest profit generator and fortune cookies as the lowest. The bar chart displays sales by product, highlighting chocolate chip cookies as the highest profit generator and fortune cookies as the lowest.', 'The chapter explains the process of inserting a table to display population and units sold for different countries, and also mentions the ability to organize the report layout.', "It details the steps for pulling in the population and different countries' data to create a table visualization, allowing the display of the country's population and the units sold.", "The chapter briefly mentions the potential to insert calculated fields, such as 'per capita', to enhance the analysis."]}], 'highlights': ["Kevin used Power BI at Microsoft to analyze business performance and make decisions, emphasizing its practical use (quantifiable data: Kevin's personal experience).", 'The highest profit recorded in 2019 was over $2 million, with $650,000 profit in 2018.', 'The demonstration covers downloading and installing Power BI for free, importing sample data, creating visualizations, and sharing reports (quantifiable data: steps in the demonstration).', 'The process involves publishing the report to Power BI service, selecting a destination workspace, and saving the report successfully.', 'The report can be opened on powerbi.com, allowing filtering of data similar to the Power BI desktop application.', 'The importance of getting data is emphasized as a prerequisite for creating visualizations in Power BI, highlighting the need to access recent sources and training content for quick access and upskilling.', 'The chapter emphasizes the importance of visualizations in aiding decision-making based on business data.', "The process of adding a title 'Kevin Cookie Company Performance Report' to the blank canvas report helps to provide context for the business data being visualized.", 'The chapter offers a high-level overview of Power BI, inviting viewers to request more in-depth content (quantifiable data: call to action for viewer engagement).', 'The report showcases the ease of slicing data by country, allowing quick insights into profit and product performance for different markets.']}