title
What Is Power BI? | Introduction To Power BI | Power BI Tutorial For Beginners | Simplilearn

description
🔥 Post Graduate Program In Data Science: https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=PowerBI--_DJPRrFQXI&utm_medium=DescriptionFF&utm_source=youtube 🔥IIT Kanpur Professional Certificate Course In Data Science (India Only): https://www.simplilearn.com/iitk-professional-certificate-course-data-science?utm_campaign=PowerBI--_DJPRrFQXI&utm_medium=DescriptionFF&utm_source=youtube 🔥 Data Science Bootcamp (US Only): https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=PowerBI--_DJPRrFQXI&utm_medium=DescriptionFF&utm_source=youtube 🔥Data Scientist Masters Program (Discount Code - YTBE15): https://www.simplilearn.com/big-data-and-analytics/senior-data-scientist-masters-program-training?utm_campaign=PowerBI--_DJPRrFQXI&utm_medium=DescriptionFF&utm_source=youtube 🟡 Caltech AI & Machine Learning Bootcamp (For US Learners Only) - https://www.simplilearn.com/ai-machine-learning-bootcamp?utm_campaign=PowerBI--_DJPRrFQXI&utm_medium=DescriptionFF&utm_source=youtube This video on what is Power BI will help you learn why Power BI is important, the various features of Power BI, and the components of Power BI. Then, you will learn how the architecture of Power BI works and the Power BI service. You will get an idea about how to build dashboards in Power BI. Finally, you will learn how Meijer solved its business problems using Power BI and perform a demo using Power BI. Now, let's dive into learning Power BI in detail. Below topics are explained in this Power BI tutorial: 0:00 Introduction 0:49 Why Power BI? 02:06 What is Power BI? 02:22 Features of Power BI 03:20 Components of Power BI 04:59 Power BI Service 06:15 Power BI Dashboard 06:50 Create and publish reports in Power BI Dashboard 07:22 Power BI Architecture 07:53 Power BI demo 🔥Free PowerBI Course: https://www.simplilearn.com/learn-power-bi-basics-free-course-skillup?utm_campaign=PowerBI&utm_medium=Description&utm_source=youtube Below topics are explained in this Power BI tutorial: 1. Why Power BI? 00:45 2. What is Power BI? 01:57 3. Features of Power BI 02:18 4. Components of Power BI 03:15 5. Architecture of Power BI 07:22 6. Power BI Service 04:59 7. Power BI Dashboard 06:14 8. Power BI Case Study 07:53 9. Power BI Demo 08:59 To learn more about Power BI, subscribe to our YouTube channel: https://www.youtube.com/user/Simplilearn?sub_confirmation=1 To access the slides, click here: https://www.slideshare.net/Simplilearn/what-is-power-bi-introduction-to-power-bi-power-bi-tutorial-for-beginners-simplilearn/Simplilearn/what-is-power-bi-introduction-to-power-bi-power-bi-tutorial-for-beginners-simplilearn Watch more videos on Power BI: https://www.youtube.com/playlist?list=PLEiEAq2VkUULmrMwindF_kKq9oj7eBoyU #WhatIsPowerBI #PowerBI #PowerBITutorial #PowerBITraining #PowerBISimplilearn #PoerBiIntroduction #PowerBIForBeginners #PowerBiTutorialForBeginners #Simplilearn ➡️ About Caltech Post Graduate Program In Data Science This Post Graduation in Data Science leverages the superiority of Caltech's academic eminence. The Data Science program covers critical Data Science topics like Python programming, R programming, Machine Learning, Deep Learning, and Data Visualization tools through an interactive learning model with live sessions by global practitioners and practical labs. ✅ Key Features - Simplilearn's JobAssist helps you get noticed by top hiring companies - Caltech PG program in Data Science completion certificate - Earn up to 14 CEUs from Caltech CTME - Masterclasses delivered by distinguished Caltech faculty and IBM experts - Caltech CTME Circle membership - Online convocation by Caltech CTME Program Director - IBM certificates for IBM courses - Access to hackathons and Ask Me Anything sessions from IBM - 25+ hands-on projects from the likes of Amazon, Walmart, Uber, and many more - Seamless access to integrated labs - Capstone projects in 3 domains - Simplilearn’s Career Assistance to help you get noticed by top hiring companies - 8X higher interaction in live online classes by industry experts ✅ Skills Covered - Exploratory Data Analysis - Descriptive Statistics - Inferential Statistics - Model Building and Fine Tuning - Supervised and Unsupervised Learning - Ensemble Learning - Deep Learning - Data Visualization 👉 Learn More At: https://www.simplilearn.com/post-graduate-program-data-science?utm_campaign=PowerBI--_DJPRrFQXI&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'What Is Power BI? | Introduction To Power BI | Power BI Tutorial For Beginners | Simplilearn', 'heatmap': [{'end': 74.531, 'start': 48.526, 'weight': 0.851}, {'end': 228.632, 'start': 195.422, 'weight': 0.763}, {'end': 566.797, 'start': 531.591, 'weight': 0.737}, {'end': 671.896, 'start': 617.447, 'weight': 0.865}, {'end': 752.819, 'start': 742.89, 'weight': 0.815}], 'summary': "Provides an introduction to power bi, highlighting its features such as data visualization, azure integration, and real-time analytics, and detailing its applications in business analytics and data analysis, including a case study of meijer's success with real-time analysis of 20 billion rows of data, and practical demonstrations of visualizing sales data in power bi.", 'chapters': [{'end': 472.677, 'segs': [{'end': 137.985, 'src': 'heatmap', 'start': 48.526, 'weight': 0, 'content': [{'end': 52.886, 'text': 'First, Power BI has the ability to access vast volumes of data from multiple sources.', 'start': 48.526, 'duration': 4.36}, {'end': 58.788, 'text': 'It allows you to view, analyze, and visualize huge quantities of data that cannot be opened in Excel.', 'start': 53.367, 'duration': 5.421}, {'end': 65.729, 'text': 'Some of the important data sources available in Power BI are Excel, CSV, XML, JSON, PDF, etc.', 'start': 59.168, 'duration': 6.561}, {'end': 74.531, 'text': 'Second Power BI provides an easy to use drag and drop tool with features and functionalities that allow you to copy all formatting across similar visualizations.', 'start': 66.249, 'duration': 8.282}, {'end': 77.392, 'text': 'Power BI has exceptional integration with Excel.', 'start': 75.071, 'duration': 2.321}, {'end': 81.074, 'text': 'It helps you gather, analyze, publish, and share Excel business data.', 'start': 77.893, 'duration': 3.181}, {'end': 84.696, 'text': 'Power BI helps to accelerate big data preparation with Azure.', 'start': 81.475, 'duration': 3.221}, {'end': 89.839, 'text': 'Using Power BI with Azure allows you to analyze and share vast volumes of data.', 'start': 85.197, 'duration': 4.642}, {'end': 97.924, 'text': 'Azure Data Lake can reduce the time it takes to get insights and increase collaboration between business analysts, data engineers and data scientists.', 'start': 90.36, 'duration': 7.564}, {'end': 104.548, 'text': 'Power BI allows you to get insights from data and turn insights into actions to take data-driven business decisions.', 'start': 98.464, 'duration': 6.084}, {'end': 109.251, 'text': 'Finally, Power BI allows you to perform real-time stream analytics.', 'start': 105.129, 'duration': 4.122}, {'end': 114.675, 'text': 'It fetches data from multiple sensors and social media sources to get access to real-time analytics.', 'start': 109.732, 'duration': 4.943}, {'end': 117.017, 'text': 'So you are always ready to make business decisions.', 'start': 115.015, 'duration': 2.002}, {'end': 119.037, 'text': "Now let's see what Power BI is.", 'start': 117.637, 'duration': 1.4}, {'end': 125.419, 'text': 'Power BI is a business analytics service provided by Microsoft that lets you visualize your data and share insights.', 'start': 119.558, 'duration': 5.861}, {'end': 129.821, 'text': 'It converts data from different sources to build interactive dashboards and BI reports.', 'start': 125.9, 'duration': 3.921}, {'end': 132.882, 'text': 'As you can see, we have an Excel data about sales.', 'start': 130.321, 'duration': 2.561}, {'end': 137.985, 'text': 'Using this data, Power BI helps you build different charts and graphs to visualize the data.', 'start': 133.642, 'duration': 4.343}], 'summary': 'Power bi allows access to vast data sources, easy visualization, and real-time analytics for data-driven business decisions.', 'duration': 78.817, 'max_score': 48.526, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI48526.jpg'}, {'end': 228.632, 'src': 'heatmap', 'start': 195.422, 'weight': 0.763, 'content': [{'end': 198.063, 'text': 'Let us jump into discussing the various components of Power BI.', 'start': 195.422, 'duration': 2.641}, {'end': 201.404, 'text': 'As you can see, there are six major components of Power BI.', 'start': 198.523, 'duration': 2.881}, {'end': 203.284, 'text': "Now let's discuss them one by one.", 'start': 201.844, 'duration': 1.44}, {'end': 205.065, 'text': 'First is Power Query.', 'start': 203.724, 'duration': 1.341}, {'end': 207.965, 'text': 'Power Query is the data transformation and mashup engine.', 'start': 205.485, 'duration': 2.48}, {'end': 213.447, 'text': 'It enables you to discover, connect, combine and refine data sources to meet your analysis need.', 'start': 208.365, 'duration': 5.082}, {'end': 218.088, 'text': 'It can be downloaded as an add-in for Excel or can be used as part of Power BI Desktop.', 'start': 213.987, 'duration': 4.101}, {'end': 220.289, 'text': 'Second, we have Power Pivot.', 'start': 218.488, 'duration': 1.801}, {'end': 224.67, 'text': 'Power Pivot is a data modeling technology that lets you create data models.', 'start': 220.649, 'duration': 4.021}, {'end': 228.632, 'text': 'It also allows you to establish relationships and create calculations.', 'start': 225.33, 'duration': 3.302}], 'summary': 'Power bi has six major components: power query for data transformation, and power pivot for data modeling and establishing relationships.', 'duration': 33.21, 'max_score': 195.422, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI195422.jpg'}, {'end': 388.349, 'src': 'embed', 'start': 358.543, 'weight': 4, 'content': [{'end': 360.084, 'text': 'so this is a tree map.', 'start': 358.543, 'duration': 1.541}, {'end': 361.065, 'text': "there's a pie chart.", 'start': 360.084, 'duration': 0.981}, {'end': 362.486, 'text': "there's a bar graph.", 'start': 361.065, 'duration': 1.421}, {'end': 363.187, 'text': 'below you can see.', 'start': 362.486, 'duration': 0.701}, {'end': 365.449, 'text': 'there are line charts and donor charts.', 'start': 363.187, 'duration': 2.262}, {'end': 373.691, 'text': 'It tells you the total sales that were made, the total number of units sold, the sales by product, sales by country, sales by segment and lots more.', 'start': 366.169, 'duration': 7.522}, {'end': 378.481, 'text': 'One of the key features of Power BI is creating dashboards from multiple reports and datasets.', 'start': 374.338, 'duration': 4.143}, {'end': 382.344, 'text': 'Power BI dashboard is a single page visualization to tell a story.', 'start': 379.042, 'duration': 3.302}, {'end': 388.349, 'text': 'The visualizations on a dashboard are generated from multiple reports and each report is based on one dataset.', 'start': 383.045, 'duration': 5.304}], 'summary': 'Power bi enables creation of dashboards with multiple visualizations and datasets, showcasing total sales, units sold, sales by product, country, and segment.', 'duration': 29.806, 'max_score': 358.543, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI358543.jpg'}, {'end': 468.455, 'src': 'embed', 'start': 439.624, 'weight': 5, 'content': [{'end': 442.125, 'text': "Now, let's understand the Power BI Architecture.", 'start': 439.624, 'duration': 2.501}, {'end': 445.206, 'text': 'Power BI Architecture is a service built on top of Azure.', 'start': 442.645, 'duration': 2.561}, {'end': 448.147, 'text': 'There are multiple data sources that Power BI can connect to.', 'start': 445.706, 'duration': 2.441}, {'end': 452.509, 'text': 'Power BI Desktop allows you to create reports and data visualizations on the dataset.', 'start': 448.587, 'duration': 3.922}, {'end': 457.911, 'text': 'Power BI Gateway is connected to on-premise data sources to get continuous data for reporting and analytics.', 'start': 452.769, 'duration': 5.142}, {'end': 463.873, 'text': 'Power BI services are basically the cloud services that are used to publish Power BI reports and data visualizations.', 'start': 458.411, 'duration': 5.462}, {'end': 468.455, 'text': 'Using Power BI mobile apps, you can stay connected to their data from anywhere.', 'start': 464.554, 'duration': 3.901}], 'summary': 'Power bi is built on azure, connects to multiple data sources, includes power bi desktop for creating reports, and power bi gateway for on-premise data sources. it also offers cloud services for publishing reports and data visualizations, and mobile apps for data accessibility.', 'duration': 28.831, 'max_score': 439.624, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI439624.jpg'}], 'start': 7.409, 'title': 'Power bi in business analytics', 'summary': 'Introduces power bi, emphasizing data visualization, azure integration, multiple data sources, and real-time analytics. it also covers report and dashboard creation, visualization, data source connections, and power bi services and mobile apps.', 'chapters': [{'end': 335.381, 'start': 7.409, 'title': 'Power bi: business analytics and visualization', 'summary': 'Introduces power bi, a business analytics service provided by microsoft, and highlights its key features including data visualization, integration with azure, support for multiple data sources, and real-time stream analytics.', 'duration': 327.972, 'highlights': ['Power BI provides an easy to use drag and drop tool with exceptional integration with Excel, allowing users to gather, analyze, publish, and share Excel business data.', 'Power BI allows users to accelerate big data preparation with Azure, reducing the time it takes to get insights and increasing collaboration between business analysts, data engineers, and data scientists.', 'Power BI allows users to access various data sources such as Excel, CSV, SQL Server, and web files to create interactive visualizations.', 'Power BI supports real-time stream analytics, fetching data from multiple sensors and social media sources to provide access to real-time analytics for making timely business decisions.', 'Power BI Desktop, a free software provided by Microsoft, enables users to easily build reports by accessing data without advanced report designing or query skills.', 'Power Query, a major component of Power BI, is the data transformation and mashup engine allowing users to discover, connect, combine, and refine data sources to meet analysis needs.']}, {'end': 472.677, 'start': 336.203, 'title': 'Power bi dashboard and report creation', 'summary': 'Discusses creating and publishing reports and dashboards in power bi, including features such as creating visualizations, connecting to data sources, and utilizing power bi services and mobile apps.', 'duration': 136.474, 'highlights': ['The chapter explains the process of creating a finance dashboard in Power BI, showcasing various charts and graphs such as tree map, pie chart, and bar graph, providing insights into total sales, units sold, sales by product, country, and segment.', 'It discusses the key feature of Power BI in creating dashboards from multiple reports and datasets, emphasizing the single page visualization to tell a story, and the generation of visualizations from multiple reports based on one dataset.', 'The chapter also delves into Power BI Architecture, highlighting its service built on Azure, connecting to multiple data sources, creating reports and data visualizations on the dataset using Power BI Desktop, and utilizing Power BI Gateway for continuous data from on-premise sources.', 'It also mentions the usage of Power BI services for publishing reports and data visualizations, and the availability of Power BI mobile apps for staying connected to data from anywhere, compatible with Windows, iOS, and Android platforms.']}], 'duration': 465.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI7409.jpg', 'highlights': ['Power BI supports real-time stream analytics, fetching data from multiple sensors and social media sources to provide access to real-time analytics for making timely business decisions.', 'Power BI allows users to accelerate big data preparation with Azure, reducing the time it takes to get insights and increasing collaboration between business analysts, data engineers, and data scientists.', 'Power BI provides an easy to use drag and drop tool with exceptional integration with Excel, allowing users to gather, analyze, publish, and share Excel business data.', 'Power BI allows users to access various data sources such as Excel, CSV, SQL Server, and web files to create interactive visualizations.', 'The chapter explains the process of creating a finance dashboard in Power BI, showcasing various charts and graphs such as tree map, pie chart, and bar graph, providing insights into total sales, units sold, sales by product, country, and segment.', 'The chapter also delves into Power BI Architecture, highlighting its service built on Azure, connecting to multiple data sources, creating reports and data visualizations on the dataset using Power BI Desktop, and utilizing Power BI Gateway for continuous data from on-premise sources.']}, {'end': 725.266, 'segs': [{'end': 566.797, 'src': 'heatmap', 'start': 491.823, 'weight': 0, 'content': [{'end': 495.184, 'text': 'Meijer was unable to perform ad-hoc and real-time analysis easily.', 'start': 491.823, 'duration': 3.361}, {'end': 496.564, 'text': 'So what Meijer did?', 'start': 495.724, 'duration': 0.84}, {'end': 502.526, 'text': 'was it connected Power BI to an on-premises SQL Server Analysis Services.', 'start': 496.564, 'duration': 5.962}, {'end': 505.65, 'text': 'This allowed them to refresh 20 billion rows of data in near real time.', 'start': 502.526, 'duration': 3.124}, {'end': 512.717, 'text': 'With Power BI, teams can now pull in the data faster and perform real-time analysis to derive insights from data.', 'start': 506.19, 'duration': 6.527}, {'end': 518.524, 'text': 'A bakery department inside Meijer used Power BI to compare its sales with regional performance.', 'start': 513.339, 'duration': 5.185}, {'end': 524.048, 'text': 'They analyzed where Meyer was behind the regional trends, focused on the problem and created a solution.', 'start': 519.085, 'duration': 4.963}, {'end': 531.151, 'text': 'With Power BI, they can now drill down into hourly sales and send out a sales flash to 800 Meyer business leaders.', 'start': 524.348, 'duration': 6.803}, {'end': 539.675, 'text': 'So Power BI enabled them to standardize data sources and empower store directors and team leaders to develop and track their data to ensure what they can improve.', 'start': 531.591, 'duration': 8.084}, {'end': 543.277, 'text': "Now, let's do some practical hands-on demo with Power BI.", 'start': 540.076, 'duration': 3.201}, {'end': 546.159, 'text': 'So this is how the Power BI desktop interface looks like.', 'start': 543.457, 'duration': 2.702}, {'end': 548.36, 'text': 'On the left, you have the report view.', 'start': 546.519, 'duration': 1.841}, {'end': 550.769, 'text': 'the data view and the model view.', 'start': 549.008, 'duration': 1.761}, {'end': 555.231, 'text': 'The report view is where you visualize your data with different charts and graphs to build reports.', 'start': 551.269, 'duration': 3.962}, {'end': 562.715, 'text': 'The data view allows you to view the whole data, while the model view is where you check if there are any relationships between the tables.', 'start': 555.811, 'duration': 6.904}, {'end': 566.797, 'text': 'On the right, you can see the different visualizations that you can build.', 'start': 563.435, 'duration': 3.362}], 'summary': 'Meijer connected power bi to on-premises sql server analysis services, enabling real-time analysis of 20 billion rows of data and empowering teams to derive insights and improve sales performance.', 'duration': 58.946, 'max_score': 491.823, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI491823.jpg'}, {'end': 595.463, 'src': 'embed', 'start': 570.492, 'weight': 3, 'content': [{'end': 575.754, 'text': "So here you can see there's a finance sample data that will help you draw insights about the sale of products in different countries.", 'start': 570.492, 'duration': 5.262}, {'end': 579.916, 'text': 'We will create a report to visualize different charts and graphs and analyze those sales.', 'start': 576.375, 'duration': 3.541}, {'end': 582.217, 'text': 'So let me go to my Power BI desktop.', 'start': 580.476, 'duration': 1.741}, {'end': 584.018, 'text': "First, we'll import our data.", 'start': 582.357, 'duration': 1.661}, {'end': 588.06, 'text': 'So let me go to our Get Data tab and choose Excel as my data source.', 'start': 584.418, 'duration': 3.642}, {'end': 589.24, 'text': 'I click on Excel.', 'start': 588.48, 'duration': 0.76}, {'end': 591.221, 'text': 'So here is our finance sample data.', 'start': 589.62, 'duration': 1.601}, {'end': 594.402, 'text': "We'll select sheet 1.", 'start': 592.822, 'duration': 1.58}, {'end': 595.463, 'text': 'You can see the data here.', 'start': 594.402, 'duration': 1.061}], 'summary': 'Using finance sample data to create visual reports in power bi desktop.', 'duration': 24.971, 'max_score': 570.492, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI570492.jpg'}, {'end': 671.896, 'src': 'heatmap', 'start': 617.447, 'weight': 0.865, 'content': [{'end': 619.247, 'text': 'So first let me create a text box.', 'start': 617.447, 'duration': 1.8}, {'end': 621.188, 'text': 'Let me resize it.', 'start': 620.428, 'duration': 0.76}, {'end': 626.1, 'text': 'Let me name it as Finance Dashboard.', 'start': 622.679, 'duration': 3.421}, {'end': 627.84, 'text': "We'll increase the size of the text.", 'start': 626.46, 'duration': 1.38}, {'end': 630.101, 'text': "We'll use font Consolus.", 'start': 628.221, 'duration': 1.88}, {'end': 631.061, 'text': 'Center it.', 'start': 630.561, 'duration': 0.5}, {'end': 633.422, 'text': "We'll also add a background to this.", 'start': 631.301, 'duration': 2.121}, {'end': 634.622, 'text': 'We use blue color.', 'start': 633.822, 'duration': 0.8}, {'end': 635.843, 'text': 'Change it to white.', 'start': 635.063, 'duration': 0.78}, {'end': 639.304, 'text': 'And increase the size.', 'start': 637.423, 'duration': 1.881}, {'end': 643.125, 'text': 'Now, let me first show you how you can create a matrix.', 'start': 639.904, 'duration': 3.221}, {'end': 646.086, 'text': "I'll go to Visualizations and click on Matrix.", 'start': 643.785, 'duration': 2.301}, {'end': 647.346, 'text': 'Let me resize it.', 'start': 646.546, 'duration': 0.8}, {'end': 653.781, 'text': "From the Datasheet tab, I'll select Sales and drag on to Values.", 'start': 649.878, 'duration': 3.903}, {'end': 659.666, 'text': 'So, you can see the total number of sales that were made.', 'start': 657.104, 'duration': 2.562}, {'end': 661.868, 'text': 'Now, let me do some formatting.', 'start': 660.046, 'duration': 1.822}, {'end': 671.896, 'text': "So, I'll go to the Format tab, click on Column headers, let's add a background color and let me increase the text size to 20.", 'start': 662.208, 'duration': 9.688}], 'summary': 'Created a finance dashboard with a matrix visualization showing total sales. formatted with blue and white colors, and increased text size to 20.', 'duration': 54.449, 'max_score': 617.447, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI617447.jpg'}], 'start': 473.277, 'title': 'Leveraging power bi for data analysis', 'summary': "Discusses meijer's successful use of power bi, enabling real-time analysis of 20 billion rows of data, leading to improved sales performance. it also explores how power bi empowers store directors and team leaders to develop and track data for improvements, including practical demonstrations of data visualization and analysis.", 'chapters': [{'end': 531.151, 'start': 473.277, 'title': "Meijer's power bi case study", 'summary': 'Highlights how meijer, a leading us supermarket chain, utilized power bi to enable real-time analysis, allowing the company to refresh 20 billion rows of data in near real time, leading to improved sales performance and efficient data insights.', 'duration': 57.874, 'highlights': ['Meijer connected Power BI to an on-premises SQL Server Analysis Services, enabling the refresh of 20 billion rows of data in near real time, leading to improved analysis capabilities.', 'The bakery department at Meijer utilized Power BI to compare its sales with regional performance, enabling them to drill down into hourly sales and send sales flash reports to 800 business leaders, resulting in improved sales performance and problem-solving.', "Meijer's initial dependence on its IT organization for data insights was time-consuming and inefficient, requiring waiting for IT to build every report, highlighting the need for a more efficient solution."]}, {'end': 725.266, 'start': 531.591, 'title': 'Empowering data analysis with power bi', 'summary': 'Introduces how power bi enables standardizing data sources, empowering store directors and team leaders to develop and track their data to ensure improvements. it includes a practical hands-on demo of creating a finance dashboard to visualize sales data and demonstrates the creation of multiple matrices for data analysis.', 'duration': 193.675, 'highlights': ['Power BI enables standardizing data sources and empowering store directors and team leaders to develop and track their data to ensure improvements. Power BI enabled standardization of data sources, empowering store directors and team leaders to develop and track their data for improvements.', 'Demo on creating a finance dashboard to visualize sales data. A practical hands-on demo was conducted to create a finance dashboard for visualizing sales data.', 'Creation of multiple matrices for data analysis. The demonstration included the creation of multiple matrices for data analysis to visualize and analyze the sales data.']}], 'duration': 251.989, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI473277.jpg', 'highlights': ['Meijer connected Power BI to an on-premises SQL Server Analysis Services, enabling the refresh of 20 billion rows of data in near real time, leading to improved analysis capabilities.', 'The bakery department at Meijer utilized Power BI to compare its sales with regional performance, enabling them to drill down into hourly sales and send sales flash reports to 800 business leaders, resulting in improved sales performance and problem-solving.', 'Power BI enables standardizing data sources and empowering store directors and team leaders to develop and track their data to ensure improvements.', 'Demo on creating a finance dashboard to visualize sales data. A practical hands-on demo was conducted to create a finance dashboard for visualizing sales data.']}, {'end': 1027.098, 'segs': [{'end': 752.819, 'src': 'heatmap', 'start': 742.89, 'weight': 0.815, 'content': [{'end': 748.635, 'text': "Under this, we'll drag the date column onto axis and the sales onto value.", 'start': 742.89, 'duration': 5.745}, {'end': 750.157, 'text': 'Let me expand it.', 'start': 749.276, 'duration': 0.881}, {'end': 752.819, 'text': 'So, it shows you the sales by year.', 'start': 750.617, 'duration': 2.202}], 'summary': 'Visualize sales by year using date and sales columns', 'duration': 9.929, 'max_score': 742.89, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI742890.jpg'}, {'end': 802.76, 'src': 'embed', 'start': 753.299, 'weight': 0, 'content': [{'end': 759.685, 'text': 'This is the sales that were made in 2013 and this shows you the sales that were made in 2014.', 'start': 753.299, 'duration': 6.386}, {'end': 762.926, 'text': "Now there's a drill down option which gives you more granularity.", 'start': 759.685, 'duration': 3.241}, {'end': 765.207, 'text': 'This depicts the sales by quarter.', 'start': 763.746, 'duration': 1.461}, {'end': 769.248, 'text': 'If I drill down further, you can see this shows you the sales by month.', 'start': 765.887, 'duration': 3.361}, {'end': 773.61, 'text': 'Also, you have some options like sort by and sort by sales.', 'start': 769.768, 'duration': 3.842}, {'end': 777.271, 'text': 'So you can see October month made the highest number of sales.', 'start': 774.21, 'duration': 3.061}, {'end': 782.513, 'text': 'Moving ahead, let me now create a pie chart where we will see the sales by different segments.', 'start': 778.171, 'duration': 4.342}, {'end': 785.253, 'text': "Under visualization, I'll click on pie chart.", 'start': 783.273, 'duration': 1.98}, {'end': 786.714, 'text': 'Let me first resize it.', 'start': 785.754, 'duration': 0.96}, {'end': 795.996, 'text': "Here, I'll drag the segment column onto the legend and the sales column onto the values.", 'start': 789.451, 'duration': 6.545}, {'end': 798.858, 'text': 'As you can see, we have the sales made by different segments.', 'start': 796.436, 'duration': 2.422}, {'end': 802.76, 'text': 'Government segment made the highest number of sales with 44.22%.', 'start': 799.538, 'duration': 3.222}], 'summary': 'Sales data analysis for 2013 and 2014, showing sales by quarter and month, with government segment leading at 44.22%.', 'duration': 49.461, 'max_score': 753.299, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI753299.jpg'}, {'end': 966.745, 'src': 'embed', 'start': 915.592, 'weight': 3, 'content': [{'end': 917.793, 'text': "I'll move this to the top.", 'start': 915.592, 'duration': 2.201}, {'end': 926.717, 'text': "Now from the data sheet, I'll add profit onto the values and segment onto the legend.", 'start': 918.414, 'duration': 8.303}, {'end': 934.66, 'text': 'If I expand this, you can see government segment made the highest amount of profit with 65.04%.', 'start': 928.117, 'duration': 6.543}, {'end': 937.402, 'text': "Let me resize this and we'll add a border.", 'start': 934.66, 'duration': 2.742}, {'end': 943.907, 'text': "Okay, in the final visualization, I'll show you how to create a tree map.", 'start': 939.904, 'duration': 4.003}, {'end': 947.93, 'text': 'This tree map will tell you the total amount of sales made by each product.', 'start': 944.528, 'duration': 3.402}, {'end': 950.813, 'text': "So under visualizations, I'll click on the tree map.", 'start': 948.251, 'duration': 2.562}, {'end': 952.054, 'text': 'Let me expand it.', 'start': 951.233, 'duration': 0.821}, {'end': 957.078, 'text': "I'll drag sales onto values and product onto group.", 'start': 952.894, 'duration': 4.184}, {'end': 961.061, 'text': 'So here you can see our tree map and the sales made by each product.', 'start': 957.558, 'duration': 3.503}, {'end': 963.523, 'text': 'You can see now we have our report ready.', 'start': 961.621, 'duration': 1.902}, {'end': 966.745, 'text': 'We have created two separate canvas to visualize our data.', 'start': 963.923, 'duration': 2.822}], 'summary': 'Government segment led with 65.04% profit; tree map visualized sales by product.', 'duration': 51.153, 'max_score': 915.592, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI915592.jpg'}], 'start': 725.987, 'title': 'Visualizing sales data in power bi', 'summary': 'Explains creating bar chart to visualize total sales and units sold, insights into sales by year, quarter, and month, with october recording the highest sales. it also demonstrates creating various visualizations in power bi, including a pie chart showing sales by segments, a table illustrating total sales by product, a map depicting sales by country, a donut chart showcasing profit by segment, and a tree map presenting sales by product. the government segment made the highest sales at 44.22% and the highest profit at 65.04%.', 'chapters': [{'end': 777.271, 'start': 725.987, 'title': 'Sales data visualization', 'summary': 'Explains the process of creating a bar chart to visualize total sales and units sold, providing insights into sales by year, quarter, and month, with october recording the highest number of sales.', 'duration': 51.284, 'highlights': ['The chapter explains the process of creating a bar chart to visualize total sales and units sold, providing insights into sales by year, quarter, and month, with October recording the highest number of sales.', 'The bar chart visualization displays the sales by year, with 2014 showing higher sales than 2013.', 'The drill down option provides more granularity, depicting the sales by quarter and further by month, revealing October as the month with the highest sales.']}, {'end': 1027.098, 'start': 778.171, 'title': 'Creating visualizations in power bi', 'summary': 'Demonstrates the creation of various visualizations in power bi, including a pie chart showing sales by segments, a table illustrating total sales by product, a map depicting sales by country, a donut chart showcasing profit by segment, and a tree map presenting sales by product. the government segment made the highest sales at 44.22% and the highest profit at 65.04%.', 'duration': 248.927, 'highlights': ['The government segment made the highest number of sales with 44.22% in the pie chart visualization, demonstrating the highest sales by segment.', "The government segment also made the highest amount of profit with 65.04% in the donut chart visualization, highlighting the segment's highest profitability.", 'The chapter includes the creation of various visualizations such as pie chart, table, map, donut chart, and tree map to depict sales and profit data, demonstrating the versatility of Power BI tools.', 'The demonstration also includes formatting techniques such as adding borders, resizing, and adjusting text size to enhance the visual appeal of the visualizations, providing practical insights into customizing reports in Power BI.', "The chapter concludes with a demonstration of switching themes in Power BI to enhance the dashboard's visual appeal and make the report look more attractive, emphasizing the importance of visual aesthetics in data presentation."]}], 'duration': 301.111, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/-_DJPRrFQXI/pics/-_DJPRrFQXI725987.jpg', 'highlights': ['The bar chart visualization displays the sales by year, with 2014 showing higher sales than 2013.', 'The drill down option provides more granularity, depicting the sales by quarter and further by month, revealing October as the month with the highest sales.', 'The government segment made the highest number of sales with 44.22% in the pie chart visualization, demonstrating the highest sales by segment.', "The government segment also made the highest amount of profit with 65.04% in the donut chart visualization, highlighting the segment's highest profitability.", 'The chapter includes the creation of various visualizations such as pie chart, table, map, donut chart, and tree map to depict sales and profit data, demonstrating the versatility of Power BI tools.']}], 'highlights': ['Meijer connected Power BI to an on-premises SQL Server Analysis Services, enabling the refresh of 20 billion rows of data in near real time, leading to improved analysis capabilities.', 'The bakery department at Meijer utilized Power BI to compare its sales with regional performance, enabling them to drill down into hourly sales and send sales flash reports to 800 business leaders, resulting in improved sales performance and problem-solving.', 'Power BI supports real-time stream analytics, fetching data from multiple sensors and social media sources to provide access to real-time analytics for making timely business decisions.', 'Power BI allows users to accelerate big data preparation with Azure, reducing the time it takes to get insights and increasing collaboration between business analysts, data engineers, and data scientists.', 'The drill down option provides more granularity, depicting the sales by quarter and further by month, revealing October as the month with the highest sales.', 'The government segment made the highest number of sales with 44.22% in the pie chart visualization, demonstrating the highest sales by segment.', "The government segment also made the highest amount of profit with 65.04% in the donut chart visualization, highlighting the segment's highest profitability.", 'Power BI provides an easy to use drag and drop tool with exceptional integration with Excel, allowing users to gather, analyze, publish, and share Excel business data.', 'The chapter explains the process of creating a finance dashboard in Power BI, showcasing various charts and graphs such as tree map, pie chart, and bar graph, providing insights into total sales, units sold, sales by product, country, and segment.', 'The chapter includes the creation of various visualizations such as pie chart, table, map, donut chart, and tree map to depict sales and profit data, demonstrating the versatility of Power BI tools.']}