title
Business Intelligence Full Course | Business Intelligence Tutorial For Beginners | Simplilearn

description
🔥Business Analyst Masters Program (Discount Coupon - YTBE15):https://www.simplilearn.com/business-analyst-certification-training-course?utm_campaign=23AugustTubebuddyExpBA&utm_medium=DescriptionFF&utm_source=youtube 🔥Post Graduate Program In Business Analysis: https://www.simplilearn.com/pgp-business-analysis-certification-training-course?utm_campaign=BusinessIntelligence-Hg8zBJ1DhLQ&utm_medium=Descriptionff&utm_source=youtube In this Business Intelligence full course video, we’ll look at what is Business Intelligence, Who is a Business Intelligence expert, and various BI tools used. We will look at each tool in detail. 00:00:00 Basics of Business Intelligence 00:02:23 Top 5 BI Tools 00:12:31 Microsoft Excel 02:48:19 Excel Power Query 03:45:35 Power BI for Data Visualization 06:09:22 Tableau for Data Visualization 🔥Explore our FREE courses: https://www.simplilearn.com/skillup-free-online-courses?utm_campaign=BusinessIntelligence&utm_medium=Description&utm_source=youtube Dataset Links: https://drive.google.com/drive/folders/1Lhwkz7UAF6se48AvZO_vKgb72XY_NiBF https://drive.google.com/drive/folders/18BFipLUm5pUcsjmjDKGg2dBR_I6mZzPX ✅Subscribe to our Channel to learn more about the top Technologies: https://bit.ly/2VT4WtH ⏩ Check out the Business Analytics tutorial videos: https://bit.ly/3hQFfDP #BusinessIntelligence #BusinessIntelligenceTutorial #BusinessIntelligenceCourse #BusinessIntelligenceTools #BiTools #TableauTrainingForBeginners #PowerBITutorialForBeginner #Simplilearn Who Is A Business Analyst? A business analyst understands the business problems and identifies the solutions that will maximize the organization's value to its stakeholders. A business analyst is an individual who works closely with the technology team to improve the quality of the services being delivered. They ensure the customer needs are correctly interpreted and translated into application. They possess programming, SQL, and business intelligence skills to deliver data-driven solutions. ➡️ About Post Graduate Program In Business Analysis This Post Graduate Program in Business Analysis is for professionals looking to pursue a Business Analysis career, understand business analysis techniques, get hands-on experience, and for experienced analysts looking to learn the latest tools and frameworks used by Agile teams. ✅ Key Features - Certificate from Simplilearn in collaboration with Purdue University - Become eligible to be part of the Purdue University Alumni Association - Master Classes delivered by Purdue faculty - Earn 35 PDs/CDUs post completion of the CBAP® module - Harvard Business Publishing case studies of Pearson, CarMax, EvCard, etc. - Capstone from 3 domains and 14+ projects - Simplilearn Career Service helps you get noticed by top hiring companies - Get mentored and network with Business Analyst from Amazon, Microsoft, and Google ✅ Skills Covered - Business Analysis - Elicitation and Collaboration - BRD FRD and SRS Document Creation - Requirements Analysis - Planning and Monitoring - Requirements Life Cycle Management - Strategy Analysis - Wireframing - Solution Evaluation - Dashboarding - Data Visualization - Agile scrum methodology - Scrum Artifacts - Statistical Analysis using Excel - SQL Database - Python - Data analysis - Digital Transformation 👉Learn more at: https://www.simplilearn.com/pgp-business-analysis-certification-training-course?utm_campaign=BusinessIntelligence-Hg8zBJ1DhLQ&utm_medium=Description&utm_source=youtube 🔥🔥 Interested in Attending Live Classes? Call Us: IN - 18002127688 / US - +18445327688

detail
{'title': 'Business Intelligence Full Course | Business Intelligence Tutorial For Beginners | Simplilearn', 'heatmap': [{'end': 3356.784, 'start': 3010.71, 'weight': 1}], 'summary': "Tutorial covers business intelligence basics, excel functions, power bi, and tableau, highlighting data analysis, visualization, and transformation techniques, with a focus on top bi tools and their features, including sasbi, thoughtspot, qlik, and power query. it also explores real-time insights using power bi and tableau's data visualization, connection to 40 data sources, dashboard customization, and business intelligence overview.", 'chapters': [{'end': 355.32, 'segs': [{'end': 57.625, 'src': 'embed', 'start': 33.313, 'weight': 2, 'content': [{'end': 39.476, 'text': 'but before we begin, make sure to subscribe to our youtube channel and hit the bell icon to never miss an update from simply learn.', 'start': 33.313, 'duration': 6.163}, {'end': 44.381, 'text': "First, you're going to learn the basics of business intelligence and look at the top 5 BI tools.", 'start': 40, 'duration': 4.381}, {'end': 50.763, 'text': "Then you'll learn Excel, where you'll see how to use different functions to perform calculations, sort and filter data,", 'start': 44.941, 'duration': 5.822}, {'end': 53.964, 'text': 'apply conditional formatting and create pivot tables and charts.', 'start': 50.763, 'duration': 3.201}, {'end': 57.625, 'text': "You'll also understand how to use Excel Power Query.", 'start': 55.244, 'duration': 2.381}], 'summary': 'Learn basics of bi, top 5 bi tools, excel functions, power query', 'duration': 24.312, 'max_score': 33.313, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ33313.jpg'}, {'end': 125.706, 'src': 'embed', 'start': 98.504, 'weight': 0, 'content': [{'end': 101.586, 'text': 'product innovations and profit loss reports, to name a few.', 'start': 98.504, 'duration': 3.082}, {'end': 108.372, 'text': 'Companies use all of this information to make crucial decisions that can either hamper or boost their business.', 'start': 102.767, 'duration': 5.605}, {'end': 112.293, 'text': 'You might have heard of the term data is the new oil.', 'start': 109.83, 'duration': 2.463}, {'end': 113.874, 'text': 'Well, it definitely is.', 'start': 112.653, 'duration': 1.221}, {'end': 119.44, 'text': 'If organizations analyze all the available data very well, then this oil is definitely valuable.', 'start': 114.295, 'duration': 5.145}, {'end': 125.706, 'text': 'And to help organizations with this, we have business intelligence, which is more often termed as BI.', 'start': 120.641, 'duration': 5.065}], 'summary': 'Data analysis drives business decisions and boosts value; business intelligence (bi) aids in this process.', 'duration': 27.202, 'max_score': 98.504, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ98504.jpg'}], 'start': 14.403, 'title': 'Business intelligence tools and their significance', 'summary': 'Covers the basics of business intelligence, top 5 bi tools, excel functions, power bi, and tableau, emphasizing the significance of data in decision-making for businesses. it also discusses business intelligence as a technology-driven process and highlights the features of the top 5 bi tools of 2020, with a focus on thoughtspot and sasbi.', 'chapters': [{'end': 119.44, 'start': 14.403, 'title': 'Business intelligence: key technology in industries', 'summary': 'Discusses the basics of business intelligence, top 5 bi tools, excel functions, power bi, and tableau, emphasizing the significance of data in decision-making for businesses.', 'duration': 105.037, 'highlights': ['The importance of data in decision-making for businesses is emphasized, as companies utilize massive amounts of data, including internal and external business information, to make crucial decisions that can impact their business performance. Companies use massive amounts of data such as internal and external business information, customer feedback, product innovations, and profit loss reports to make crucial decisions that can impact their business performance.', "The significance of analyzing available data is stressed, likening data to the new oil and highlighting its potential value when analyzed effectively. The term 'data is the new oil' is referenced, emphasizing the potential value of data when analyzed effectively.", 'The chapter provides an overview of the topics covered, including the basics of business intelligence, top 5 BI tools, Excel functions, Power BI, and Tableau, offering a comprehensive learning path for viewers. The chapter covers the basics of business intelligence, top 5 BI tools, Excel functions, Power BI, and Tableau, providing a comprehensive learning path for viewers.']}, {'end': 355.32, 'start': 120.641, 'title': 'Business intelligence tools 2020', 'summary': 'Discusses business intelligence (bi) as a technology-driven process that converts raw data into useful information for achieving business profits, and highlights the features of the top 5 bi tools of 2020, with a focus on thoughtspot and sasbi.', 'duration': 234.679, 'highlights': ['ThoughtSpot Features ThoughtSpot provides search-driven solution, AI-powered insights, instant chart creation, scalability, availability on major cloud platforms, and user-friendly interface, and is used by Walmart, Royal Bank of Canada, 7-Eleven, and Exxon Mobil.', 'SASBI Features SAS Business Intelligence tool offers analysis, data mining, and reporting with powerful visualizations and interactive dashboards, easy use, automatic code generation, integration with open source software such as R, and data extraction and categorization for identifying and analyzing data patterns.']}], 'duration': 340.917, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ14403.jpg', 'highlights': ['Companies utilize massive amounts of data for decision-making, impacting business performance.', 'Data is likened to the new oil, emphasizing its potential value when effectively analyzed.', 'Chapter covers basics of business intelligence, top 5 BI tools, Excel functions, Power BI, and Tableau.']}, {'end': 1944.901, 'segs': [{'end': 384.406, 'src': 'embed', 'start': 357.828, 'weight': 2, 'content': [{'end': 363.732, 'text': 'SAS provides the best practices and defines the guiding principles for a secure product development lifecycle.', 'start': 357.828, 'duration': 5.904}, {'end': 369.236, 'text': 'SAS BI ensures that the products meet the business and security needs of the customers.', 'start': 364.272, 'duration': 4.964}, {'end': 373.859, 'text': 'Let us now have a look at the companies using SAS BI.', 'start': 371.037, 'duration': 2.822}, {'end': 379.503, 'text': 'We have companies like Accenture, Genpact, IQVR, and IBM to name a few.', 'start': 374.359, 'duration': 5.144}, {'end': 382.105, 'text': 'That was all about SAS BI.', 'start': 380.564, 'duration': 1.541}, {'end': 384.406, 'text': 'Let us now move on to our next tool.', 'start': 382.505, 'duration': 1.901}], 'summary': 'Sas bi ensures secure product development, used by companies like accenture and ibm.', 'duration': 26.578, 'max_score': 357.828, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ357828.jpg'}, {'end': 433.499, 'src': 'embed', 'start': 407.414, 'weight': 1, 'content': [{'end': 413.018, 'text': 'Qlik is named a leader in the 2020 Gartner Magic Quadrant for analytics and BI platforms.', 'start': 407.414, 'duration': 5.604}, {'end': 417.021, 'text': 'As you can see on your screens, this is how the interface looks like.', 'start': 413.999, 'duration': 3.022}, {'end': 419.965, 'text': 'Moving on to the features of Qlik.', 'start': 418.243, 'duration': 1.722}, {'end': 425.731, 'text': 'QlikView can do everything that an OLAP-based solution will do and much faster.', 'start': 420.986, 'duration': 4.745}, {'end': 433.499, 'text': "You can take advantage of Qlik's powerful AI and machine learning to accelerate discoveries, boost data literacy, and derive insights.", 'start': 426.371, 'duration': 7.128}], 'summary': 'Qlik is a leader in 2020 gartner magic quadrant for analytics and bi platforms, offering fast olap-based solution and powerful ai.', 'duration': 26.085, 'max_score': 407.414, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ407414.jpg'}, {'end': 580.439, 'src': 'embed', 'start': 536.993, 'weight': 0, 'content': [{'end': 547.518, 'text': 'Some of the data sources are local text files, Microsoft Excel, PDFs, JSON or databases and servers like MySQL Server, Microsoft SQL Server, etc.', 'start': 536.993, 'duration': 10.525}, {'end': 554.863, 'text': 'Tableau is an easy-to-use drag-and-drop tool which allows its users to create interactive visuals quickly.', 'start': 548.658, 'duration': 6.205}, {'end': 560.627, 'text': 'You can build different charts and graphs, dashboards and storylines with just a few clicks.', 'start': 555.503, 'duration': 5.124}, {'end': 565.071, 'text': 'In Tableau, you can gain insights that you never thought was possible.', 'start': 561.488, 'duration': 3.583}, {'end': 570.335, 'text': 'You can play with interactive visualizations and explore various data that is available,', 'start': 565.431, 'duration': 4.904}, {'end': 574.038, 'text': "and you don't need to have any specific knowledge of the insight you're looking for.", 'start': 570.335, 'duration': 3.703}, {'end': 580.439, 'text': 'Knowledge of coding is not required to work on Tableau as Tableau provides in-built table calculations.', 'start': 574.835, 'duration': 5.604}], 'summary': 'Tableau enables easy data visualization from diverse sources without coding, offering interactive insights.', 'duration': 43.446, 'max_score': 536.993, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ536993.jpg'}, {'end': 715.66, 'src': 'embed', 'start': 683.301, 'weight': 3, 'content': [{'end': 688.844, 'text': 'Firstly, it provides easy drag and drop functionality, which makes data visually appealing.', 'start': 683.301, 'duration': 5.543}, {'end': 693.266, 'text': 'It allows you to copy all formatting across similar visualizations.', 'start': 689.304, 'duration': 3.962}, {'end': 699.949, 'text': 'Power BI transforms your enterprise data into rich visuals and accurate reports for enhanced decision making.', 'start': 693.926, 'duration': 6.023}, {'end': 702.33, 'text': 'It can also be used with Azure.', 'start': 700.589, 'duration': 1.741}, {'end': 707.492, 'text': 'Using Power BI with Azure allows you to analyze and share large volumes of data.', 'start': 702.85, 'duration': 4.642}, {'end': 715.66, 'text': 'It integrates seamlessly with advanced cloud services like Azure and Cortana to provide results for the verbal data queries.', 'start': 708.032, 'duration': 7.628}], 'summary': 'Power bi enables easy data visualization and integration with azure for analyzing and sharing large volumes of data.', 'duration': 32.359, 'max_score': 683.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ683301.jpg'}, {'end': 884.709, 'src': 'embed', 'start': 838.68, 'weight': 5, 'content': [{'end': 844.805, 'text': 'now, before we move to excel, one of the question is why should we use excel?', 'start': 838.68, 'duration': 6.125}, {'end': 847.628, 'text': "So let's look at some of the points here.", 'start': 845.868, 'duration': 1.76}, {'end': 856.031, 'text': 'So Excel proves to be a great platform to perform various mathematical calculation on large data sets,', 'start': 847.648, 'duration': 8.383}, {'end': 860.472, 'text': 'which is one of the biggest requirements of various organizations these days.', 'start': 856.031, 'duration': 4.441}, {'end': 868.814, 'text': 'Various features in Excel like searching, sorting, filtering makes it easier for you to play with the data.', 'start': 861.132, 'duration': 7.682}, {'end': 876.841, 'text': 'And Excel also allows you to beautify your data and present it in the form of charts, tables and data bars.', 'start': 869.554, 'duration': 7.287}, {'end': 884.709, 'text': 'Now, when it comes to reporting, reporting, accounting and analysis can be performed with the help of Excel.', 'start': 877.842, 'duration': 6.867}], 'summary': 'Excel is essential for performing mathematical calculations on large data sets, aiding in reporting, accounting, and analysis.', 'duration': 46.029, 'max_score': 838.68, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ838680.jpg'}, {'end': 1017.777, 'src': 'embed', 'start': 992.176, 'weight': 6, 'content': [{'end': 999.886, 'text': 'which basically talks about 10 different steps in which we can learn excel And using the spreadsheet app.', 'start': 992.176, 'duration': 7.71}, {'end': 1009.598, 'text': 'So there are more than 11 sheets which we see here at the bottom end and each one gives us a simple example which we can work on.', 'start': 1000.567, 'duration': 9.031}, {'end': 1017.777, 'text': 'So, for example, if I click on add now that takes me to this page which says how do we add numbers?', 'start': 1010.219, 'duration': 7.558}], 'summary': '10 steps to learn excel and using more than 11 sheets for examples.', 'duration': 25.601, 'max_score': 992.176, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ992176.jpg'}], 'start': 357.828, 'title': 'Business intelligence tools and excel functions', 'summary': 'Provides an overview of top 3 bi tools: sas bi, qlik, and tableau, and discusses the capabilities of tableau, power bi, and excel, highlighting their features, use cases, and practical examples, including excel functions such as sumif and auto sum.', 'chapters': [{'end': 560.627, 'start': 357.828, 'title': 'Top bi tools overview', 'summary': 'Provides an overview of the top 3 business intelligence tools: sas bi, qlik, and tableau, highlighting their key features, company adoptions, and industry rankings.', 'duration': 202.799, 'highlights': ['SAS BI is used by companies like Accenture, Genpact, IQVR, and IBM. Several well-known companies, including Accenture and IBM, use SAS BI for their business and security needs.', "Qlik was named a leader in the 2020 Gartner Magic Quadrant for analytics and BI platforms. Qlik's recognition as a leader in the 2020 Gartner Magic Quadrant for analytics and BI platforms highlights its industry standing and reliability.", "Tableau can connect to 40 different data sources and handle large amounts of data easily. Tableau's capability to connect to 40 different data sources and handle large volumes of data showcases its versatility and scalability."]}, {'end': 785.484, 'start': 561.488, 'title': 'Tableau and power bi in business intelligence', 'summary': 'Discusses the capabilities of tableau and power bi, highlighting their features and use cases, and also mentions companies utilizing these tools, with a brief comparison to other bi tools.', 'duration': 223.996, 'highlights': ['Power BI provides easy drag and drop functionality, transforms enterprise data into rich visuals, and integrates with Azure for analyzing and sharing large volumes of data. Power BI offers easy drag and drop functionality and transforms enterprise data into rich visuals, facilitating enhanced decision making. It also integrates with Azure for analyzing and sharing large volumes of data.', 'Tableau provides interactive visualizations, requires no specific knowledge of coding, and is used by companies like Amazon, Ferrari, Walmart, Capgemini, and LinkedIn. Tableau offers interactive visualizations and does not require specific coding knowledge. It is utilized by prominent companies such as Amazon, Ferrari, Walmart, Capgemini, and LinkedIn.', 'Power BI ensures secure report publishing with automatic data refresh, utilized by companies like Nestle, Capgemini, Accenture, and Entity Data. Power BI ensures secure report publishing with automatic data refresh, and is employed by companies like Nestle, Capgemini, Accenture, and Entity Data.', 'Zoho Analytics is a cloud-based self-service BI and data analytics software, while Oracle BI is used for reporting and analyzing data, and Pentaho is used for creating relational and analytical reporting. Zoho Analytics is a cloud-based self-service BI and data analytics software, Oracle BI is utilized for reporting and analyzing data, and Pentaho is employed for creating relational and analytical reporting.']}, {'end': 1213.236, 'start': 786.605, 'title': 'Using excel for business', 'summary': 'Discusses the decision to use microsoft excel for business needs, highlighting its benefits such as mathematical calculations, data manipulation features, security, and various functions and formulas.', 'duration': 426.631, 'highlights': ['Excel provides a platform for various mathematical calculations on large datasets, catering to the needs of various organizations. Excel is capable of performing various mathematical calculations on large datasets, which is a significant requirement for organizations.', 'Features in Excel like searching, sorting, and filtering make it easier to manipulate data, along with the ability to present data in charts, tables, and data bars. Excel offers features such as searching, sorting, filtering, and data visualization, making data manipulation and presentation more efficient.', 'Excel is useful for reporting, accounting, analysis, task lists, calendars, goal planning worksheets, and provides good security for data through password protection. Excel is beneficial for reporting, accounting, analysis, task management, and data security with features like password protection.', 'Microsoft Excel is an application used for recording, analyzing, and visualizing data in the form of a spreadsheet, offering various functions and formulas. Microsoft Excel is an application used for recording, analyzing, and visualizing data through spreadsheets, providing a variety of functions and formulas.']}, {'end': 1944.901, 'start': 1213.236, 'title': 'Excel formulas and functions', 'summary': 'Explains various excel functions such as sumif, auto sum, filling down, splitting data, and transposing, with practical examples and shortcuts.', 'duration': 731.665, 'highlights': ['The chapter explains various Excel functions such as SUMIF, auto sum, filling down, splitting data, and transposing, with practical examples and shortcuts. The transcript covers practical examples of using Excel functions like SUMIF, auto sum, filling down, splitting data, and transposing, along with shortcuts and practical applications.', 'A practical example of using the SUMIF formula to find amounts less than 100 and getting a total of 160 is demonstrated. A practical example of using the SUMIF formula to find amounts less than 100 and getting a total of 160 is demonstrated, showcasing the application of the formula in Excel.', 'Demonstration of using auto sum as an alternative method for adding up values in Excel. The transcript demonstrates using auto sum as an alternative method for adding up values in Excel, providing a practical shortcut for summing up values.', 'The process of filling down and filling right in Excel to automatically calculate totals for different rows and columns is explained. The process of filling down and filling right in Excel to automatically calculate totals for different rows and columns is explained, offering a practical method for quickly obtaining sums.', 'The method of splitting data in Excel based on delimiters and using practical examples to illustrate the process is detailed. The transcript details the method of splitting data in Excel based on delimiters and provides practical examples to illustrate the process, showcasing the ability to organize data effectively.', 'The concept of transposing data in Excel using both shortcuts and formulas is demonstrated. The concept of transposing data in Excel using both shortcuts and formulas is demonstrated, offering practical methods for switching rows and columns.']}], 'duration': 1587.073, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ357828.jpg', 'highlights': ['Tableau can connect to 40 different data sources and handle large amounts of data easily.', 'Qlik was named a leader in the 2020 Gartner Magic Quadrant for analytics and BI platforms.', 'SAS BI is used by companies like Accenture, Genpact, IQVR, and IBM.', 'Power BI provides easy drag and drop functionality, transforms enterprise data into rich visuals, and integrates with Azure for analyzing and sharing large volumes of data.', 'Tableau provides interactive visualizations, requires no specific knowledge of coding, and is used by companies like Amazon, Ferrari, Walmart, Capgemini, and LinkedIn.', 'Excel provides a platform for various mathematical calculations on large datasets, catering to the needs of various organizations.', 'The chapter explains various Excel functions such as SUMIF, auto sum, filling down, splitting data, and transposing, with practical examples and shortcuts.', 'Features in Excel like searching, sorting, and filtering make it easier to manipulate data, along with the ability to present data in charts, tables, and data bars.']}, {'end': 3590.822, 'segs': [{'end': 2967.286, 'src': 'embed', 'start': 2912.894, 'weight': 3, 'content': [{'end': 2923.016, 'text': 'so this is a simple example of using your drop downs working with your tables, working with your sort and filter, transpose, split,', 'start': 2912.894, 'duration': 10.122}, {'end': 2926.117, 'text': 'filling up your data, adding in some data here.', 'start': 2923.016, 'duration': 3.101}, {'end': 2936.301, 'text': 'And similarly, you can use Excel for more than one use case using its inbuilt features to easily work with your data.', 'start': 2926.597, 'duration': 9.704}, {'end': 2948.672, 'text': "let's see how we can import data or bring in data into our excel from your local machine or from an external web source.", 'start': 2937.026, 'duration': 11.646}, {'end': 2955.216, 'text': 'so what we can do is we can open up a blank excel sheet and say, for example, you have been provided.', 'start': 2948.672, 'duration': 6.544}, {'end': 2962.423, 'text': 'a text file or a csv file and you would want to import that data into your excel sheet.', 'start': 2955.939, 'duration': 6.484}, {'end': 2964.264, 'text': 'that can be easily done.', 'start': 2962.423, 'duration': 1.841}, {'end': 2967.286, 'text': "so right now i've opened an excel sheet.", 'start': 2964.264, 'duration': 3.022}], 'summary': 'Excel can import data from local or web sources, allowing for versatile data manipulation and analysis.', 'duration': 54.392, 'max_score': 2912.894, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ2912894.jpg'}, {'end': 3356.784, 'src': 'heatmap', 'start': 3010.71, 'weight': 1, 'content': [{'end': 3017.358, 'text': 'if that does not show up something, so say browse for more and that basically shows you different options.', 'start': 3010.71, 'duration': 6.648}, {'end': 3022.849, 'text': "so let's basically select a folder where I have some data sets.", 'start': 3017.358, 'duration': 5.491}, {'end': 3029.211, 'text': "i'll click in here and this is basically a folder where i have some data sets.", 'start': 3022.849, 'duration': 6.362}, {'end': 3034.694, 'text': 'now let me select this particular file and i know it is a csv file.', 'start': 3029.211, 'duration': 5.483}, {'end': 3037.995, 'text': "so let's click on open now.", 'start': 3034.694, 'duration': 3.301}, {'end': 3045.478, 'text': 'if you would want to verify this, you could have gone and looked into the properties of the file and it says it is a dot csv file,', 'start': 3037.995, 'duration': 7.483}, {'end': 3047.673, 'text': 'which is what we are interested in.', 'start': 3046.072, 'duration': 1.601}, {'end': 3049.414, 'text': "so I'll take this file.", 'start': 3047.673, 'duration': 1.741}, {'end': 3050.534, 'text': "I'll say open.", 'start': 3049.414, 'duration': 1.12}, {'end': 3057.097, 'text': 'now this basically shows me the text import wizard option which says is the file delimited?', 'start': 3050.534, 'duration': 6.563}, {'end': 3063.841, 'text': "I'll say yes, click on next, so I will select comma as my delimiter.", 'start': 3057.097, 'duration': 6.744}, {'end': 3066.962, 'text': 'I can say text qualifier is none.', 'start': 3063.841, 'duration': 3.121}, {'end': 3069.023, 'text': 'now this is my data.', 'start': 3066.962, 'duration': 2.061}, {'end': 3074.906, 'text': 'so my data preview is already showing me the data is what is the data in the CSV file?', 'start': 3069.023, 'duration': 5.883}, {'end': 3080.618, 'text': 'You can click on next and then you have an option that says data format is general.', 'start': 3075.512, 'duration': 5.106}, {'end': 3082.92, 'text': 'You can go for date format.', 'start': 3081.158, 'duration': 1.762}, {'end': 3084.662, 'text': 'You can go for advanced options.', 'start': 3082.96, 'duration': 1.702}, {'end': 3086.484, 'text': "So I'll just say finish.", 'start': 3085.123, 'duration': 1.361}, {'end': 3090.929, 'text': 'And basically now this has been created here.', 'start': 3087.565, 'duration': 3.364}, {'end': 3095.554, 'text': 'So we basically have this and now I can click on.', 'start': 3091.69, 'duration': 3.864}, {'end': 3101.905, 'text': 'close. now, once you have done that, you can click on existing connections.', 'start': 3097.403, 'duration': 4.502}, {'end': 3108.028, 'text': 'it shows me the data which we have here, the connection which we have created say open,', 'start': 3101.905, 'duration': 6.123}, {'end': 3115.351, 'text': 'and then it says do you want to import this data or bring this data into existing worksheet?', 'start': 3108.028, 'duration': 7.323}, {'end': 3119.653, 'text': 'you can also say add this to a data model if you are doing some data modeling.', 'start': 3115.351, 'duration': 4.302}, {'end': 3126.416, 'text': 'so click on ok, and now this data is automatically inserted in my excel file.', 'start': 3119.653, 'duration': 6.763}, {'end': 3132.888, 'text': 'I can basically save it into this particular sheet.', 'start': 3127.006, 'duration': 5.882}, {'end': 3141.112, 'text': 'Now what we can also do is we can also start a new sheet and that does not have a data and we can get some other data from web.', 'start': 3133.149, 'duration': 7.963}, {'end': 3149.235, 'text': "So what I can do is I can go into my GitHub and let's say I would be interested in this CSV file.", 'start': 3141.672, 'duration': 7.563}, {'end': 3154.217, 'text': 'So I can select this and this is my GitHub path, a path on web.', 'start': 3149.795, 'duration': 4.422}, {'end': 3161.605, 'text': 'So I can click on draw and that basically gives me the raw path where this particular file is.', 'start': 3154.781, 'duration': 6.824}, {'end': 3168.91, 'text': 'Now you can select this, copy this particular path and here you can come back to your Excel sheet.', 'start': 3161.786, 'duration': 7.124}, {'end': 3171.072, 'text': 'We would be interested in getting the data from web.', 'start': 3169.01, 'duration': 2.062}, {'end': 3176.195, 'text': 'might be from a text file where we will have to specify the delimiters.', 'start': 3171.892, 'duration': 4.303}, {'end': 3183.941, 'text': "or let's go to web, and here i can give in the web path from where i would be interested in getting the file.", 'start': 3176.195, 'duration': 7.746}, {'end': 3188.965, 'text': "let's give the github path, which is publicly available, and then click on import.", 'start': 3183.941, 'duration': 5.024}, {'end': 3194.79, 'text': 'now, once you click on import, it tells me there are two fields data and value.', 'start': 3188.965, 'duration': 5.825}, {'end': 3199.846, 'text': 'these are within double quotes, separated by comma.', 'start': 3194.79, 'duration': 5.056}, {'end': 3202.547, 'text': "so first let's click on import.", 'start': 3199.846, 'duration': 2.701}, {'end': 3207.731, 'text': 'now, once we do this, it will basically get the data from web and put in.', 'start': 3202.547, 'duration': 5.184}, {'end': 3210.152, 'text': 'here it says existing worksheet.', 'start': 3207.731, 'duration': 2.421}, {'end': 3212.753, 'text': 'so we had already created a new worksheet.', 'start': 3210.152, 'duration': 2.601}, {'end': 3216.796, 'text': "so let's click on ok, and now you have the data coming in.", 'start': 3212.753, 'duration': 4.043}, {'end': 3221.689, 'text': 'But then this basically shows me in one particular field.', 'start': 3217.386, 'duration': 4.303}, {'end': 3227.995, 'text': 'So what we can also do is we can just do a control A that selects all my columns here.', 'start': 3222.17, 'duration': 5.825}, {'end': 3229.916, 'text': "And that's my data.", 'start': 3228.795, 'duration': 1.121}, {'end': 3234.68, 'text': 'So we can then basically filter this out.', 'start': 3230.136, 'duration': 4.544}, {'end': 3236.822, 'text': 'So we can say text to columns.', 'start': 3234.92, 'duration': 1.902}, {'end': 3239.123, 'text': "It's a delimited file.", 'start': 3237.802, 'duration': 1.321}, {'end': 3240.324, 'text': 'Click on next.', 'start': 3239.524, 'duration': 0.8}, {'end': 3245.228, 'text': 'We can select comma and let the text qualifier be quotes.', 'start': 3240.925, 'duration': 4.303}, {'end': 3248.745, 'text': 'It shows me data preview.', 'start': 3246.423, 'duration': 2.322}, {'end': 3252.929, 'text': 'click on next, so you have the general format.', 'start': 3248.745, 'duration': 4.184}, {'end': 3255.891, 'text': "it shows the destination, that's the column.", 'start': 3252.929, 'duration': 2.962}, {'end': 3257.072, 'text': 'click on, finish.', 'start': 3255.891, 'duration': 1.181}, {'end': 3262.838, 'text': 'and now your data has been split and you have the data which you have imported from web.', 'start': 3257.072, 'duration': 5.766}, {'end': 3265.46, 'text': 'so this is the data which is coming in from web.', 'start': 3262.838, 'duration': 2.622}, {'end': 3273.931, 'text': 'this is the data which came in from my local machine and similarly we can even create connection with an existing database.', 'start': 3266.246, 'duration': 7.685}, {'end': 3279.475, 'text': 'so I can basically click on connections if I would want to do that.', 'start': 3273.931, 'duration': 5.544}, {'end': 3286.34, 'text': 'so I have an option called connection here and it says where the selected connections are used.', 'start': 3279.475, 'duration': 6.865}, {'end': 3289.182, 'text': 'I can basically click on add.', 'start': 3286.34, 'duration': 2.842}, {'end': 3296.371, 'text': 'I can basically choose If I would want to get the files from network or from computer, like we did earlier.', 'start': 3289.182, 'duration': 7.189}, {'end': 3304.357, 'text': 'I can click on browse for more which should show me different other options to create connections.', 'start': 3297.171, 'duration': 7.186}, {'end': 3308.24, 'text': 'Say you would want to create a new SQL server connection.', 'start': 3304.457, 'duration': 3.783}, {'end': 3312.283, 'text': 'You can connect to a new data source coming in from different place.', 'start': 3308.76, 'duration': 3.523}, {'end': 3316.326, 'text': 'You could basically choose what kind of connection would you want.', 'start': 3312.823, 'duration': 3.503}, {'end': 3319.869, 'text': 'So these are all the different options which we can go for.', 'start': 3316.807, 'duration': 3.062}, {'end': 3323.873, 'text': 'and we can basically connect to a database.', 'start': 3320.652, 'duration': 3.221}, {'end': 3331.436, 'text': 'for example, if i have some database and say, for example, access database,', 'start': 3323.873, 'duration': 7.563}, {'end': 3337.278, 'text': 'i can see if there are some files with that particular database and i can import it.', 'start': 3331.436, 'duration': 5.842}, {'end': 3347.161, 'text': 'so similarly we can also, uh, click in here, which is new query, and that also gives you an option of getting the data from your files,', 'start': 3337.278, 'duration': 9.883}, {'end': 3350.622, 'text': 'from all these folders, from databases.', 'start': 3347.161, 'duration': 3.461}, {'end': 3356.784, 'text': 'so you can basically click here and then you can import data from a mysql database,', 'start': 3350.622, 'duration': 6.162}], 'summary': 'Imported and managed csv data in excel, also accessed and imported data from web and database.', 'duration': 346.074, 'max_score': 3010.71, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ3010710.jpg'}, {'end': 3416.811, 'src': 'embed', 'start': 3362.026, 'weight': 0, 'content': [{'end': 3372.088, 'text': 'you can go from cloud, you can get it from online services, you can get it from other sources, which says from web, from your hadoop file system,', 'start': 3362.026, 'duration': 10.062}, {'end': 3381.75, 'text': 'from active directory, from a blank query, And you can even combine queries wherein you can run a power query editor.', 'start': 3372.088, 'duration': 9.662}, {'end': 3386.973, 'text': 'you can get the data from different sources and then you can bring it into your Excel.', 'start': 3381.75, 'duration': 5.223}, {'end': 3394.797, 'text': 'So in this way, you can get your data from different sources into your Excel, into your spreadsheet,', 'start': 3387.213, 'duration': 7.584}, {'end': 3398.119, 'text': 'and then you can continue working on those data sets.', 'start': 3394.797, 'duration': 3.322}, {'end': 3404.518, 'text': 'We have already learned some basic operations which you can do in excel,', 'start': 3399.372, 'duration': 5.146}, {'end': 3415.61, 'text': "and let's implement our knowledge by working on this particular data which is coming in from housing data set now here, if we see some fields,", 'start': 3404.518, 'duration': 11.092}, {'end': 3416.811, 'text': 'we have agent.', 'start': 3415.61, 'duration': 1.201}], 'summary': 'Data from various sources can be combined and imported into excel for further analysis.', 'duration': 54.785, 'max_score': 3362.026, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ3362026.jpg'}, {'end': 3572.136, 'src': 'embed', 'start': 3536.67, 'weight': 1, 'content': [{'end': 3539.411, 'text': 'So we can start with any particular column.', 'start': 3536.67, 'duration': 2.741}, {'end': 3540.471, 'text': 'That does not matter.', 'start': 3539.511, 'duration': 0.96}, {'end': 3545.854, 'text': 'So, for example, if I look into this Excel sheet, I have my agent name.', 'start': 3540.892, 'duration': 4.962}, {'end': 3546.614, 'text': 'Select this.', 'start': 3545.914, 'duration': 0.7}, {'end': 3549.656, 'text': 'which we want in a descending order.', 'start': 3547.174, 'duration': 2.482}, {'end': 3555.982, 'text': 'so we could either do a sort and then go for descending sort z to a.', 'start': 3549.656, 'duration': 6.326}, {'end': 3562.227, 'text': 'we could also use the filter option here on the top right and we could do it,', 'start': 3555.982, 'duration': 6.245}, {'end': 3572.136, 'text': 'or i just say sort z to a and then it has arranged the data based on the agent column being in descending order.', 'start': 3562.227, 'duration': 9.909}], 'summary': 'Sorting data in excel by agent name in descending order.', 'duration': 35.466, 'max_score': 3536.67, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ3536670.jpg'}], 'start': 1944.901, 'title': 'Importing and sorting data in excel', 'summary': 'Explains how to import data into excel from both local and web sources, using the data import wizard and existing connections. it also covers sorting and filtering data, including sorting by color and applying filters, to optimize data analysis and visualization.', 'chapters': [{'end': 2315.905, 'start': 1944.901, 'title': 'Excel transpose and sort', 'summary': 'Explains how to use excel to transpose data, converting rows into columns and columns into rows, and how to sort and filter data, demonstrating sorting alphabetically by department and largest to smallest by value, with examples and step-by-step instructions.', 'duration': 371.004, 'highlights': ["Excel's capability to transpose data and convert rows into columns and columns into rows is demonstrated with step-by-step instructions, allowing users to efficiently manipulate data in Excel. The transcript provides step-by-step instructions on how to transpose data in Excel, converting rows into columns and columns into rows, demonstrating the efficiency of manipulating data in Excel.", 'The process of sorting and filtering data in Excel is explained, including sorting alphabetically by department and largest to smallest by value, showcasing the practical application of Excel for data organization and management. The chapter demonstrates the practical application of Excel for data organization and management by explaining the process of sorting and filtering data, including sorting alphabetically by department and largest to smallest by value.', "The ability to sort data based on different criteria such as department, values, date, and color is highlighted, providing users with a comprehensive understanding of the diverse sorting options available in Excel. The chapter highlights the diverse sorting options available in Excel, including sorting based on criteria such as department, values, date, and color, enhancing users' understanding of the comprehensive sorting capabilities in Excel."]}, {'end': 2912.894, 'start': 2315.905, 'title': 'Sorting, filtering and working with tables in excel', 'summary': 'Covers sorting and filtering data in excel, including sorting by color, applying filters, and using number filters to extract specific data. it also demonstrates how to work with tables, add rows and columns, perform calculations, and create drop-down lists for data validation.', 'duration': 596.989, 'highlights': ['The chapter covers sorting and filtering data in Excel, including sorting by color, applying filters, and using number filters to extract specific data. It explains how to sort data in Excel by color, apply filters, and use number filters to extract specific data based on conditions.', 'It also demonstrates how to work with tables, add rows and columns, perform calculations, and create drop-down lists for data validation. The chapter demonstrates working with tables, including adding rows and columns, performing calculations, and creating drop-down lists for data validation.']}, {'end': 3132.888, 'start': 2912.894, 'title': 'Importing data into excel', 'summary': 'Explains how to import data into excel from a local machine or external web source, using the data import wizard and existing connections feature, to easily work with different data sources.', 'duration': 219.994, 'highlights': ['You can import data into Excel using the data import wizard and existing connections feature. The speaker explains the process of importing data into Excel using the data import wizard and existing connections feature, demonstrating the steps involved.', 'The data import wizard allows selecting the delimiter, text qualifier, and data format for the imported data. The speaker demonstrates the usage of the data import wizard, highlighting the ability to choose the delimiter, text qualifier, and data format for the imported data.', 'The imported data can be added to an existing worksheet or data model in Excel. The speaker explains the options to either add the imported data to an existing worksheet or to a data model in Excel, providing flexibility in managing the imported data.']}, {'end': 3337.278, 'start': 3133.149, 'title': 'Importing data into excel', 'summary': 'Explains how to import data into excel from web and local machine, including selecting and importing data from web, splitting data using text to columns, and creating connections with an existing database.', 'duration': 204.129, 'highlights': ['The chapter explains how to import data from web and local machine into Excel. It provides a step-by-step guide on selecting and importing data from web and local machine into Excel.', "Demonstrates the process of splitting data using the 'Text to Columns' feature. It shows how to split imported data using the 'Text to Columns' feature, specifying delimiters and text qualifiers.", 'Explains the process of creating connections with an existing database. It outlines the process of creating connections with an existing database, including options to connect to different data sources and import data.']}, {'end': 3590.822, 'start': 3337.278, 'title': 'Excel data import and sorting', 'summary': 'Covers importing data from various sources into excel and sorting it based on different criteria, such as date and agent name, to optimize data analysis and visualization.', 'duration': 253.544, 'highlights': ['Importing data from various sources into Excel The chapter explains the process of importing data from MySQL databases, cloud, online services, web, Hadoop file system, and active directory into Excel, enhancing data accessibility and analysis.', 'Sorting data in Excel based on date and agent name The process of sorting data in Excel is demonstrated, including sorting the data based on the date listed in descending order and sorting the data based on agent name in descending order and area in ascending order, optimizing data visualization and analysis.', 'Utilizing Excel for data manipulation and analysis The chapter emphasizes the use of Excel for data manipulation and analysis, showcasing how to import, organize, and sort data from various sources to facilitate efficient data analysis and visualization.']}], 'duration': 1645.921, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ1944901.jpg', 'highlights': ['The chapter emphasizes the use of Excel for data manipulation and analysis, showcasing how to import, organize, and sort data from various sources to facilitate efficient data analysis and visualization.', 'The process of sorting data in Excel is demonstrated, including sorting the data based on the date listed in descending order and sorting the data based on agent name in descending order and area in ascending order, optimizing data visualization and analysis.', 'The chapter explains the process of importing data from MySQL databases, cloud, online services, web, Hadoop file system, and active directory into Excel, enhancing data accessibility and analysis.', 'The chapter demonstrates working with tables, including adding rows and columns, performing calculations, and creating drop-down lists for data validation.', 'The chapter provides a step-by-step guide on selecting and importing data from web and local machine into Excel.']}, {'end': 6351.691, 'segs': [{'end': 4367.483, 'src': 'embed', 'start': 4340.181, 'weight': 0, 'content': [{'end': 4349.711, 'text': "Well, I could have also done filtering in place and that would have replaced the data which we have, but that's not what we want.", 'start': 4340.181, 'duration': 9.53}, {'end': 4353.054, 'text': 'We would want the filtered result in a different place.', 'start': 4349.811, 'duration': 3.243}, {'end': 4356.636, 'text': 'So this is how you can do some advanced filtering.', 'start': 4353.554, 'duration': 3.082}, {'end': 4367.483, 'text': 'We can also use Excel to filter out the data in one particular column, which might be conditional or say using some numerical filters.', 'start': 4357.056, 'duration': 10.427}], 'summary': 'Advanced filtering in excel for conditional and numerical filters.', 'duration': 27.302, 'max_score': 4340.181, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ4340181.jpg'}, {'end': 4608.973, 'src': 'embed', 'start': 4582.873, 'weight': 1, 'content': [{'end': 4590.876, 'text': 'And now you have your data filtered out in a different location in the sheet, which has been filtered based on your AND condition.', 'start': 4582.873, 'duration': 8.003}, {'end': 4598.42, 'text': 'So you can filter out the data in this way, or you could just apply a filter on a column and give the conditions.', 'start': 4591.311, 'duration': 7.109}, {'end': 4602.084, 'text': "Now let's solve one more interesting problem.", 'start': 4599.601, 'duration': 2.483}, {'end': 4608.973, 'text': 'And here we would want to use Excel where we would have an AND, AND and OR condition.', 'start': 4602.585, 'duration': 6.388}], 'summary': 'Filter data in excel based on and and or conditions.', 'duration': 26.1, 'max_score': 4582.873, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ4582873.jpg'}, {'end': 6014.339, 'src': 'embed', 'start': 5985.818, 'weight': 2, 'content': [{'end': 5992.079, 'text': "so, for example, if i would want to work on countif, let's try solving this problem now.", 'start': 5985.818, 'duration': 6.261}, {'end': 5998.321, 'text': 'remember, you can answer these questions using filters and that can be an easier way.', 'start': 5992.079, 'duration': 6.242}, {'end': 6009.155, 'text': 'but then sometimes you may want to get the formulas so that you can make your spreadsheet and your calculation more dynamic in nature,', 'start': 5998.321, 'duration': 10.834}, {'end': 6014.339, 'text': 'and that will basically depend on the values in the columns or rows.', 'start': 6009.155, 'duration': 5.184}], 'summary': 'Learn how to use countif and filters to create dynamic spreadsheets.', 'duration': 28.521, 'max_score': 5985.818, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ5985818.jpg'}, {'end': 6183.102, 'src': 'embed', 'start': 6152.723, 'weight': 5, 'content': [{'end': 6159.427, 'text': 'Now, it might be looking a little confusing when I say, for example, let me clear out this filter.', 'start': 6152.723, 'duration': 6.704}, {'end': 6163.469, 'text': 'Now, we have sales greater than three.', 'start': 6160.808, 'duration': 2.661}, {'end': 6171.052, 'text': 'And we would want to find out which sales representative made a sale more than three times.', 'start': 6163.889, 'duration': 7.163}, {'end': 6183.102, 'text': 'now i could basically check for every sales representative here if they have made a sale more than three times, and what i can do is, i can just say,', 'start': 6171.052, 'duration': 12.05}], 'summary': 'Identifying sales reps with over 3 sales, streamlining analysis process.', 'duration': 30.379, 'max_score': 6152.723, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ6152723.jpg'}, {'end': 6254.277, 'src': 'embed', 'start': 6220.385, 'weight': 3, 'content': [{'end': 6221.505, 'text': "and let's check.", 'start': 6220.385, 'duration': 1.12}, {'end': 6233.629, 'text': 'so it tells me the boolean value that yes, this guy has made sales more than three times and what we can do is we can just drag and drop,', 'start': 6221.505, 'duration': 12.124}, {'end': 6237.63, 'text': 'which basically gives me the value for other sales rep.', 'start': 6233.629, 'duration': 4.001}, {'end': 6245.032, 'text': "you can always check, the value is automatically changing to this value in cell and, for example, let's go in here.", 'start': 6237.63, 'duration': 7.402}, {'end': 6246.612, 'text': 'so this is obviously two.', 'start': 6245.032, 'duration': 1.58}, {'end': 6254.277, 'text': 'so it says me false, right, and you can basically get the values for all your values.', 'start': 6246.612, 'duration': 7.665}], 'summary': "A demonstration of using a boolean value to track sales reps' performance, allowing for easy comparison and access to various data.", 'duration': 33.892, 'max_score': 6220.385, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ6220385.jpg'}], 'start': 3591.423, 'title': 'Excel data analysis', 'summary': 'Covers sorting and filtering data in excel, including custom lists and multiple criteria, using and and or conditions, inbuilt functions, and formulas. it also explains the usage of sumif, sumifs, countif, and countifs functions for dynamic data analysis, with practical examples showcasing revenue calculation, sales quantity, and item cost analysis.', 'chapters': [{'end': 4582.433, 'start': 3591.423, 'title': 'Sorting and filtering data in excel', 'summary': 'Demonstrates how to sort and filter data in excel, including sorting based on custom lists and filtering based on multiple criteria, and between specific values, and applying advanced filters.', 'duration': 991.01, 'highlights': ['The chapter demonstrates how to sort data in Excel based on custom lists, such as sorting the data according to the order of area (South County, Central, North County). The speaker explains how to sort data in Excel based on custom lists, specifically sorting the data according to the order of area (South County, Central, North County).', 'The chapter explains how to apply a filter in Excel to display specific data, such as finding all the houses in the central area and applying a regular filter by selecting the area and specifying the filter criteria. The speaker demonstrates the process of applying a filter in Excel to display specific data, using the example of finding all the houses in the central area and applying a regular filter.', 'The chapter covers advanced filtering in Excel, such as filtering based on multiple columns with different values, and applying advanced criteria to filter data and store the result in a different location. The speaker explains the process of advanced filtering in Excel, including filtering based on multiple columns with different values and applying advanced criteria to filter data and store the result in a different location.', 'The chapter demonstrates how to filter data in Excel based on specific criteria, such as displaying houses with list prices between specific values, using both the number filter and advanced filter methods. The speaker illustrates the process of filtering data in Excel based on specific criteria, such as displaying houses with list prices between specific values, using both the number filter and advanced filter methods.']}, {'end': 5043.479, 'start': 4582.873, 'title': 'Excel filtering and function usage', 'summary': 'Discusses how to filter data using and and or conditions in excel, along with using inbuilt functions and formulas for easy calculations and data analysis.', 'duration': 460.606, 'highlights': ['You can filter data in Excel using AND and OR conditions, such as finding houses in North County with a list price greater than 300,000 and three or four bedrooms. Excel allows filtering data based on multiple conditions, such as finding houses in North County with a list price greater than 300,000 and three or four bedrooms.', 'The transcript explains the process of using Excel functions like is even, is logical, subtotal, integer, sum, average, now, time, etc., for performing various data analysis and computations. The transcript provides an overview of using Excel functions like is even, is logical, subtotal, integer, sum, average, now, time, etc., for performing data analysis and computations.', 'The chapter also discusses advanced functions like sumif, sumifs, countif, and countifs in Excel for performing calculations and working with data. The chapter delves into advanced functions like sumif, sumifs, countif, and countifs in Excel for performing calculations and working with data.']}, {'end': 5411.358, 'start': 5043.479, 'title': 'Using sumif function for data analysis', 'summary': 'Explains the usage of sumif function to calculate the sum of units sold in the east region and the total revenue generated from a specific product, providing examples and the results of the calculations.', 'duration': 367.879, 'highlights': ['Explaining the usage of SUMIF function for calculating the sum of units sold in the east region The speaker demonstrates the process of using the SUMIF function to calculate the total units sold in the east region, providing a specific example and the result of the calculation, which is 691.', "Demonstrating the application of SUMIF function to find the total revenue generated from a specific product The transcript illustrates the usage of the SUMIF function to determine the total revenue generated from a specific product, in this case 'binder', and presents the result of the calculation.", 'Comparison of different methods for applying the SUMIF function The speaker compares the process of using a cell reference and directly inputting the value when applying the SUMIF function, emphasizing that both methods yield the same result and provide clarity in using the function.']}, {'end': 6351.691, 'start': 5411.598, 'title': 'Using sumifs, countif, and countifs in data analysis', 'summary': 'Explains the use of sumifs, countif, and countifs functions in excel to perform data analysis, including examples of filtering, multiple criteria, and quantification, such as finding the total revenue generated from central region where the item is a pencil, how many units were sold by sales representative john or jones with item cost greater than four, and the total number of times gil made a sale. the examples demonstrate practical applications and the usage of these functions in dynamic data analysis.', 'duration': 940.093, 'highlights': ['The chapter explains the use of SUMIFS, COUNTIF, and COUNTIFS functions in Excel to perform data analysis. The chapter introduces the use of SUMIFS, COUNTIF, and COUNTIFS functions in Excel for data analysis, providing practical applications and examples.', 'Finding the total revenue generated from central region where the item is a pencil. The chapter demonstrates using the SUMIFS function in Excel to find the total revenue generated from the central region where the item is a pencil, showcasing the practical application of the function with specific criteria.', "How many units were sold by sales representative John or Jones with item cost greater than four. The transcript illustrates using the SUMIFS function in Excel to calculate the number of units sold by sales representatives John or Jones with an item cost greater than four, showcasing the function's ability to handle multiple criteria and quantification.", 'Finding the total number of times Gil made a sale using the COUNTIF function. The chapter demonstrates using the COUNTIF function in Excel to find the total number of times Gil made a sale, providing a practical example of quantification using a specific condition.']}], 'duration': 2760.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ3591423.jpg', 'highlights': ['The chapter covers advanced filtering in Excel, such as filtering based on multiple columns with different values and applying advanced criteria to filter data and store the result in a different location.', 'You can filter data in Excel using AND and OR conditions, such as finding houses in North County with a list price greater than 300,000 and three or four bedrooms.', 'The chapter delves into advanced functions like sumif, sumifs, countif, and countifs in Excel for performing calculations and working with data.', 'The speaker demonstrates the process of using the SUMIF function to calculate the total units sold in the east region, providing a specific example and the result of the calculation, which is 691.', 'The chapter introduces the use of SUMIFS, COUNTIF, and COUNTIFS functions in Excel for data analysis, providing practical applications and examples.', 'The chapter demonstrates using the SUMIFS function in Excel to find the total revenue generated from the central region where the item is a pencil, showcasing the practical application of the function with specific criteria.', "The transcript illustrates using the SUMIFS function in Excel to calculate the number of units sold by sales representatives John or Jones with an item cost greater than four, showcasing the function's ability to handle multiple criteria and quantification.", 'The chapter demonstrates using the COUNTIF function in Excel to find the total number of times Gil made a sale, providing a practical example of quantification using a specific condition.']}, {'end': 8008.658, 'segs': [{'end': 7055.893, 'src': 'embed', 'start': 7020.736, 'weight': 1, 'content': [{'end': 7035.426, 'text': "so, for example, I will say here so we had gone for above, now we'll go for below, we'll go for format, we will choose red, we'll say okay,", 'start': 7020.736, 'duration': 14.69}, {'end': 7045.708, 'text': "we'll say now, these are basically the rules which we have created, and here it says applies to your data.", 'start': 7035.426, 'duration': 10.282}, {'end': 7048.429, 'text': 'so right now it has not been applied.', 'start': 7045.708, 'duration': 2.721}, {'end': 7055.893, 'text': 'so, for example, if i select this and then i could basically choose my area,', 'start': 7048.429, 'duration': 7.464}], 'summary': 'Creating rules for data format selection, not yet applied.', 'duration': 35.157, 'max_score': 7020.736, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ7020736.jpg'}, {'end': 7288.162, 'src': 'embed', 'start': 7259.754, 'weight': 0, 'content': [{'end': 7266, 'text': 'so you can use conditional formatting for various use cases and you can highlight the values.', 'start': 7259.754, 'duration': 6.246}, {'end': 7271.264, 'text': 'so anyone who would look at the value would automatically notice which are the higher values.', 'start': 7266, 'duration': 5.264}, {'end': 7274.007, 'text': 'which are lower values might be here.', 'start': 7271.264, 'duration': 2.743}, {'end': 7282.14, 'text': 'the revenue is getting generated or was getting generated but did not grow beyond a particular value, and so on.', 'start': 7274.007, 'duration': 8.133}, {'end': 7288.162, 'text': 'Now. similarly, you can also go in for different options.', 'start': 7282.78, 'duration': 5.382}], 'summary': 'Conditional formatting allows highlighting of values for easy recognition and analysis.', 'duration': 28.408, 'max_score': 7259.754, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ7259754.jpg'}, {'end': 7567.022, 'src': 'embed', 'start': 7496.784, 'weight': 2, 'content': [{'end': 7501.385, 'text': "so let's continue learning on using excel for various things.", 'start': 7496.784, 'duration': 4.601}, {'end': 7507.786, 'text': 'now we have learned on conditional formatting and seen how that can be very helpful.', 'start': 7501.385, 'duration': 6.401}, {'end': 7512.587, 'text': "let's learn one more feature of excel, and that's basically your data validation.", 'start': 7507.786, 'duration': 4.801}, {'end': 7526.41, 'text': 'now this can be very useful when you would want to work on validating the data which is being fed in the cells so you could limit it to basically a number between a particular value.', 'start': 7512.587, 'duration': 13.823}, {'end': 7538.204, 'text': 'You could also add some messages to it if you would want, or you could even circle invalid data or clear validation circles.', 'start': 7526.95, 'duration': 11.254}, {'end': 7545.574, 'text': 'So data validation really helps us in validating the data which is being fed in two particular fields.', 'start': 7538.705, 'duration': 6.869}, {'end': 7553.506, 'text': "Now it's a feature in excel which is mainly used to control what a user can fill in a cell.", 'start': 7547.119, 'duration': 6.387}, {'end': 7556.67, 'text': 'You can decide what type of values must be entered.', 'start': 7553.887, 'duration': 2.783}, {'end': 7567.022, 'text': 'You can also restrict user to enter only valid data and if any invalid data is entered an error message will be displayed.', 'start': 7557.371, 'duration': 9.651}], 'summary': 'Excel data validation controls and limits input, reducing errors.', 'duration': 70.238, 'max_score': 7496.784, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ7496784.jpg'}, {'end': 7849.749, 'src': 'embed', 'start': 7814.758, 'weight': 3, 'content': [{'end': 7819.399, 'text': 'now for this we can use a formula and we can select.', 'start': 7814.758, 'duration': 4.641}, {'end': 7827.481, 'text': 'well, i would want to apply this rule to all these rows, starting from c2 to c14.', 'start': 7819.399, 'duration': 8.082}, {'end': 7829.861, 'text': "so let's get into data validation.", 'start': 7827.481, 'duration': 2.38}, {'end': 7834.822, 'text': "let's look in settings and here we are choosing custom.", 'start': 7829.861, 'duration': 4.961}, {'end': 7839.084, 'text': 'now, within custom, i am choosing what is the formula.', 'start': 7834.822, 'duration': 4.262}, {'end': 7849.749, 'text': "so i'm saying is number and then i'm saying find at the rate for the rows c2 to c14.", 'start': 7839.084, 'duration': 10.665}], 'summary': "Applying a data validation formula to rows c2-c14 to find the '@' symbol.", 'duration': 34.991, 'max_score': 7814.758, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ7814758.jpg'}], 'start': 6352.451, 'title': 'Excel data analysis and conditional formatting', 'summary': 'Discusses using excel functions like countifs and conditional formatting to analyze data, with examples of finding the total number of orders and using conditional formatting to identify cells based on preset conditions, making computation and calculation more dynamic and easy to use. it also introduces the concept of conditional formatting with color scales, explains the process of setting up three color scales and formatting cells based on their values, and demonstrates how to highlight cells above and below average values. additionally, it explains how to use conditional formatting to highlight top and bottom values with specific colors, apply gradient fills, use icon sets to indicate trends in data, and extensively use conditional formatting for data identification and analysis. the chapter also covers the use of data validation in excel, emphasizing its role in controlling and validating data input, such as restricting the length of text, defining date ranges, validating email formats, and setting numerical limits for fields like salary and rank.', 'chapters': [{'end': 6708.037, 'start': 6352.451, 'title': 'Excel data analysis and conditional formatting', 'summary': 'Discusses using excel functions like countifs and conditional formatting to analyze data, with examples of finding the total number of orders and using conditional formatting to identify cells based on preset conditions, making computation and calculation more dynamic and easy to use.', 'duration': 355.586, 'highlights': ['The chapter discusses using Excel functions like COUNTIFS to find the total number of orders, with an example of finding 13 orders from the East region. Excel functions like COUNTIFS used to find the total number of orders from the East region. Example: 13 orders found from the East region.', "The chapter explains using COUNTIFS to find the number of times 'Gil' sold pencils, resulting in the identification of 'Gil' selling pencils twice. COUNTIFS used to find the number of times 'Gil' sold pencils. Result: 'Gil' sold pencils twice.", 'The chapter demonstrates using conditional formatting in Excel to differentiate data values based on certain criteria or rules, making it useful for working on huge amounts of data and easily performing data analysis. Conditional formatting in Excel used to differentiate data values based on certain criteria or rules. Useful for working on huge amounts of data and easily performing data analysis.']}, {'end': 7118.918, 'start': 6708.037, 'title': 'Conditional formatting with color scales', 'summary': 'Introduces the concept of conditional formatting with color scales, explaining the process of setting up three color scales and formatting cells based on their values, demonstrating how to highlight cells above and below average values, and finally showcasing how to find top and bottom 10 values using conditional formatting.', 'duration': 410.881, 'highlights': ['Demonstrating how to highlight cells above and below average values using conditional formatting The speaker explains the process of setting up color scales to highlight cells above and below average values, using yellow for above average and red for below average.', 'Setting up three color scales to format cells based on their values The speaker demonstrates the process of setting up a three color scale, with the lowest values in red, mid values in yellow, and the highest values in green.', 'Explaining the process of finding top and bottom 10 values using conditional formatting The speaker showcases the process of finding the top and bottom 10 values using conditional formatting, illustrating an easy way to identify these values within the dataset.']}, {'end': 7495.636, 'start': 7119.776, 'title': 'Conditional formatting in excel', 'summary': 'Explains how to use conditional formatting in excel to highlight top and bottom values with specific colors, apply gradient fills, use icon sets to indicate trends in data, and how conditional formatting is extensively used by data analysts and business intelligence teams for data identification and analysis.', 'duration': 375.86, 'highlights': ['Conditional formatting can be used to highlight top and bottom values with specific colors, making it easy to identify higher and lower values in data. The speaker demonstrates how to use conditional formatting to highlight top 10 values in blue and bottom 10 values in orange, making it easier to identify significant values in the data.', 'The chapter explains how to apply gradient fills to cells, allowing for visual representation of increasing or decreasing values. The speaker walks through the process of applying gradient fills to cells, illustrating how it can visually represent the increase or decrease in values, providing a clear indication of data trends.', 'Using icon sets in conditional formatting can help indicate trends and provide visual cues for data analysis. The speaker explains how to use icon sets in conditional formatting, showing how it can be used to visually indicate trends in data and provide visual cues for data analysis, such as indicating if values are increasing, decreasing, or stable.', 'Conditional formatting is extensively used by data analysts and business intelligence teams to identify and analyze data effectively. The transcript emphasizes the extensive use of conditional formatting by data analysts and business intelligence teams for data identification and analysis, highlighting its importance in effectively identifying, analyzing, and interpreting data.']}, {'end': 8008.658, 'start': 7496.784, 'title': 'Excel data validation', 'summary': 'Covers the use of data validation in excel, emphasizing its role in controlling and validating data input, such as restricting the length of text, defining date ranges, validating email formats, and setting numerical limits for fields like salary and rank.', 'duration': 511.874, 'highlights': ['Data validation allows controlling and validating data input, such as restricting the length of text, defining date ranges, validating email formats, and setting numerical limits for fields like salary and rank. Data validation in Excel covers a range of functionalities including restricting text length, defining date ranges, validating email formats, and setting numerical limits for fields like salary and rank.', 'Restricting the length of text input by limiting the characters in a cell, for instance, allowing only 15 characters for a name. Illustrates how to restrict the length of text input by setting a maximum character limit, such as allowing only 15 characters for a name.', 'Defining date ranges to control and validate the input of dates, for example, restricting the date of birth between 10 Jan 1990 and 30 Dec 1998. Demonstrates how to define date ranges to control and validate the input of dates, such as restricting the date of birth between specific dates.', "Validating email formats by ensuring the presence of '@' in the provided value, and displaying error alerts for invalid entries. Describes the process of validating email formats by ensuring the presence of '@' in the provided value and displaying error alerts for invalid entries.", 'Setting numerical limits for fields like salary and rank, for instance, restricting the salary to be greater than 50,000 and the rank between 100 and 200. Explains how to set numerical limits for fields like salary and rank, such as restricting the salary to be greater than 50,000 and the rank between 100 and 200.']}], 'duration': 1656.207, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ6352451.jpg', 'highlights': ['Excel functions like COUNTIFS used to find the total number of orders from the East region. Example: 13 orders found from the East region.', "The chapter explains using COUNTIFS to find the number of times 'Gil' sold pencils. Result: 'Gil' sold pencils twice.", 'Demonstrating how to highlight cells above and below average values using conditional formatting.', 'Setting up three color scales to format cells based on their values.', 'Explaining the process of finding top and bottom 10 values using conditional formatting.', 'Conditional formatting can be used to highlight top and bottom values with specific colors, making it easy to identify higher and lower values in data.', 'The chapter explains how to apply gradient fills to cells, allowing for visual representation of increasing or decreasing values.', 'Using icon sets in conditional formatting can help indicate trends and provide visual cues for data analysis.', 'Conditional formatting is extensively used by data analysts and business intelligence teams to identify and analyze data effectively.', 'Data validation in Excel covers a range of functionalities including restricting text length, defining date ranges, validating email formats, and setting numerical limits for fields like salary and rank.']}, {'end': 9099.023, 'segs': [{'end': 8234.357, 'src': 'embed', 'start': 8177.521, 'weight': 2, 'content': [{'end': 8185.549, 'text': 'so if you can check the data validation rule, i have used list and then i have said indirect f2.', 'start': 8177.521, 'duration': 8.028}, {'end': 8193.776, 'text': "so basically i'm giving in a formula which relates to the value which is in for the city Maharashtra.", 'start': 8185.549, 'duration': 8.227}, {'end': 8195.257, 'text': 'so we could do this.', 'start': 8193.776, 'duration': 1.481}, {'end': 8202.762, 'text': 'or, in a simpler way, we could do this and then just drag and drop here, so we could check for Maharashtra.', 'start': 8195.257, 'duration': 7.505}, {'end': 8204.483, 'text': 'what are the values?', 'start': 8202.762, 'duration': 1.721}, {'end': 8206.103, 'text': "let's choose a different city.", 'start': 8204.483, 'duration': 1.62}, {'end': 8209.627, 'text': 'so, for example, Kolkata, and here I will choose.', 'start': 8206.103, 'duration': 3.524}, {'end': 8215.869, 'text': 'now, since we did a drag and drop, it has basically taken the values of bangalore.', 'start': 8210.406, 'duration': 5.463}, {'end': 8217.35, 'text': "so that's not right.", 'start': 8215.869, 'duration': 1.481}, {'end': 8226.032, 'text': 'so we select this, we go into data validation and here i can either feed in the values.', 'start': 8217.35, 'duration': 8.682}, {'end': 8227.994, 'text': 'that is such as bangalore.', 'start': 8226.032, 'duration': 1.962}, {'end': 8234.357, 'text': 'i could basically say something like this kolkata, and i could say okay.', 'start': 8227.994, 'duration': 6.363}], 'summary': 'Using data validation rule to test values for different cities and correcting errors.', 'duration': 56.836, 'max_score': 8177.521, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ8177521.jpg'}, {'end': 8394.223, 'src': 'embed', 'start': 8366.03, 'weight': 1, 'content': [{'end': 8375.374, 'text': "for example, on the row end, if I just do a control and right arrow, it tells me what's my right last column.", 'start': 8366.03, 'duration': 9.344}, {'end': 8379.296, 'text': 'and if I just do a control and down arrow, it tells me there are 9994 rows.', 'start': 8375.374, 'duration': 3.922}, {'end': 8391.442, 'text': 'now i can use this and what i can do is i can basically work on insert and go to pivot table.', 'start': 8382.097, 'duration': 9.345}, {'end': 8394.223, 'text': 'now. this basically tells you need to choose the range.', 'start': 8391.442, 'duration': 2.781}], 'summary': 'Using control shortcuts reveals 9994 rows and assists in creating pivot tables.', 'duration': 28.193, 'max_score': 8366.03, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ8366030.jpg'}, {'end': 8924.679, 'src': 'embed', 'start': 8896.725, 'weight': 0, 'content': [{'end': 8900.308, 'text': 'so basically we have all the data, but we are looking at the sum of profit.', 'start': 8896.725, 'duration': 3.583}, {'end': 8902.209, 'text': "but that's not what we want.", 'start': 8900.308, 'duration': 1.901}, {'end': 8912.097, 'text': 'we are looking for top three states from each region that made the highest average profit.', 'start': 8902.209, 'duration': 9.888}, {'end': 8913.818, 'text': 'now, how do we change that?', 'start': 8912.097, 'duration': 1.721}, {'end': 8916.52, 'text': 'so here we have sum of profit.', 'start': 8913.818, 'duration': 2.702}, {'end': 8921.797, 'text': 'so i can do a right click And basically I can say summarize values by average.', 'start': 8916.52, 'duration': 5.277}, {'end': 8924.679, 'text': "So now I'm getting the average here.", 'start': 8922.377, 'duration': 2.302}], 'summary': 'Identifying top 3 states per region with highest average profit by changing data summarization to average.', 'duration': 27.954, 'max_score': 8896.725, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ8896725.jpg'}], 'start': 8009.679, 'title': 'Data validation and pivot tables in excel', 'summary': 'Explains implementing data validation in excel to restrict city names and places, allowing specific values for maharashtra cities like pune, mumbai, and nasik. it also covers using pivot tables to summarize data, pivot charts for visual representations, and pivot table analysis techniques for analyzing total sales, identifying the top states for each region with the highest average profit, and calculating the percentage contribution of each subcategory of products to total sales.', 'chapters': [{'end': 8089.091, 'start': 8009.679, 'title': 'Data validation in excel', 'summary': 'Explains how to implement data validation in excel to restrict the values of city names and places within those cities, with an example of allowing only specific values for maharashtra cities, like pune, mumbai, and nasik.', 'duration': 79.412, 'highlights': ['Implementing data validation in Excel allows restricting the values of city names and places within those cities. The speaker demonstrates using data validation in Excel to restrict the values of city names and places within those cities, with an example of only allowing specific values for Maharashtra cities.', 'Demonstrates the process of selecting list values for data validation in Excel. The speaker explains the process of selecting list values for data validation in Excel, allowing the restriction of specific values for city names and places within those cities.', 'The need to address empty cells in the data validation process for better implementation. The speaker highlights the importance of addressing empty cells in the data validation process for better implementation, indicating a more efficient approach for the restriction of values for city names and places within those cities.']}, {'end': 8394.223, 'start': 8089.091, 'title': 'Data validation and pivot tables', 'summary': 'Covers implementing data validation to restrict values in cells, demonstrated through selecting values, implementing data validation for multiple cities, using formulas to relate different city values, and providing a list of values for list validation. additionally, it discusses pivot tables as a summary of data and pivot charts as visual representations for data analysis.', 'duration': 305.132, 'highlights': ['Implementing data validation to restrict values in cells for different cities The presenter demonstrates how to implement data validation to restrict city values in cells, showcasing the process for selecting values and implementing data validation for multiple cities.', 'Using formulas to relate different city values for data validation The presenter explains using formulas, such as indirect F2, to relate different city values for data validation, providing a dynamic approach to restrict values in cells.', 'Providing a list of values for list validation The presenter shows how to provide a list of values for list validation, allowing the restriction of values in cells to specific lists, enhancing data integrity and accuracy.', 'Explaining pivot tables as a summary of data and pivot charts as visual representations The chapter explores pivot tables as a summary of data, used for grouping and deriving meaningful information, and pivot charts as visual representations for data analysis, providing a comprehensive approach to working with and analyzing data in Excel.']}, {'end': 9099.023, 'start': 8394.223, 'title': 'Pivot table analysis techniques', 'summary': 'Covers the process of creating pivot tables to analyze total sales for each category, finding the subcategory of items sold the maximum under each category, identifying the top three states for each region that made the highest average profit, and calculating the percentage contribution of each subcategory of products under each category to the total sales.', 'duration': 704.8, 'highlights': ['The chapter covers the process of creating pivot tables to analyze total sales for each category. The speaker explains the process of selecting fields, such as category and sales, to create a pivot table showing the sum of sales per category.', 'Identifying the top three states for each region that made the highest average profit. The process involves selecting fields like region, state, and profit, then changing the summary values to average, sorting the data, and filtering to display the top three states for each region based on average profit.', 'Finding the subcategory of items sold the maximum under each category. The speaker demonstrates the process of selecting fields like category, subcategory, and quantity to create a pivot table, then applying a filter using slicers to display the subcategories with the highest sales under each category.', 'Calculating the percentage contribution of each subcategory of products under each category to the total sales. The chapter explains the objective of finding the percentage contribution of each subcategory of products under each category to the total sales, indicating a focus on analyzing the sales contribution of different subcategories within each category.']}], 'duration': 1089.344, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ8009679.jpg', 'highlights': ['Using data validation in Excel to restrict city names and places within specific cities like Pune, Mumbai, and Nasik.', 'Explaining pivot tables as a summary of data and pivot charts as visual representations for data analysis.', 'Identifying the top states for each region with the highest average profit using pivot table analysis techniques.', 'Calculating the percentage contribution of each subcategory of products to total sales using pivot table analysis.']}, {'end': 10068.071, 'segs': [{'end': 9212.602, 'src': 'embed', 'start': 9185.626, 'weight': 3, 'content': [{'end': 9189.97, 'text': 'say okay, and then just close this.', 'start': 9185.626, 'duration': 4.344}, {'end': 9196.81, 'text': 'so once you have closed this, you see already the data is in Percentage.', 'start': 9189.97, 'duration': 6.84}, {'end': 9204.896, 'text': 'So now we have our data with subcategories, but we also want the data to be sorted, might be in a descending order,', 'start': 9197.41, 'duration': 7.486}, {'end': 9209.459, 'text': 'which tells which subcategory is contributing more than others.', 'start': 9204.896, 'duration': 4.563}, {'end': 9212.602, 'text': 'We can select how many subcategories we are interested in.', 'start': 9209.9, 'duration': 2.702}], 'summary': 'Closing the data shows percentage. data can be sorted by subcategory contribution in descending order.', 'duration': 26.976, 'max_score': 9185.626, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ9185626.jpg'}, {'end': 9792.102, 'src': 'embed', 'start': 9765.593, 'weight': 1, 'content': [{'end': 9771.137, 'text': "so let's go for line chart and that basically shows me the line chart.", 'start': 9765.593, 'duration': 5.544}, {'end': 9773.159, 'text': 'so we can select this.', 'start': 9771.137, 'duration': 2.022}, {'end': 9781.746, 'text': 'we can just drag and drop it here and then we can basically check if that is showing us the data.', 'start': 9773.159, 'duration': 8.587}, {'end': 9788.92, 'text': 'so if you see here this is line chart, where it has divided the regions in different colors, So we have all the regions.', 'start': 9781.746, 'duration': 7.174}, {'end': 9792.102, 'text': 'we could filter out in pivot chart a particular region.', 'start': 9788.92, 'duration': 3.182}], 'summary': 'Demonstrating the use of a line chart to display regional data.', 'duration': 26.509, 'max_score': 9765.593, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ9765593.jpg'}, {'end': 10068.071, 'src': 'embed', 'start': 10012.89, 'weight': 0, 'content': [{'end': 10018.613, 'text': 'and now we would want to basically plot a histogram with this data.', 'start': 10012.89, 'duration': 5.723}, {'end': 10028.109, 'text': 'so i can just place my cursor here, I can select this and then I can go into insert and here I have different options.', 'start': 10018.613, 'duration': 9.496}, {'end': 10038.351, 'text': 'so we can go for bar chart, we can go for insert hierarchy chart, we can go into waterfall funnel, stock surface or radar chart.', 'start': 10028.109, 'duration': 10.242}, {'end': 10039.491, 'text': 'so there are different options.', 'start': 10038.351, 'duration': 1.14}, {'end': 10045.533, 'text': 'what you have here, and we will go for a simple histogram which is two-dimensional.', 'start': 10039.491, 'duration': 6.042}, {'end': 10046.373, 'text': "let's select this.", 'start': 10045.533, 'duration': 0.84}, {'end': 10052.198, 'text': 'and here, you see, you can obviously select different regions.', 'start': 10047.034, 'duration': 5.164}, {'end': 10060.345, 'text': 'you have your years, which shows up, you have your order date and then you have your categories,', 'start': 10052.198, 'duration': 8.147}, {'end': 10064.508, 'text': 'which can be chosen for your histogram or for your bar chart.', 'start': 10060.345, 'duration': 4.163}, {'end': 10068.071, 'text': 'and that, basically, is how you use your pivot table.', 'start': 10064.508, 'duration': 3.563}], 'summary': 'Demonstration of creating a histogram using excel pivot table.', 'duration': 55.181, 'max_score': 10012.89, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ10012890.jpg'}], 'start': 9099.023, 'title': 'Using pivot tables and charts for data analysis', 'summary': 'Covers using pivot tables to analyze data, including finding percentage contributions, identifying lowest profit customers, and dividing sales data into quarterly segments. it also discusses creating pivot charts to analyze sales data by quarters, filtering data, and introducing slicers for visualization. additionally, it explains using pivot tables to find profits by year and regions, and creating histograms from the pivot table data.', 'chapters': [{'end': 9475.913, 'start': 9099.023, 'title': 'Pivot table data analysis', 'summary': 'Explains how to use a pivot table to analyze data, including finding the percentage contribution of subcategories, identifying customers with the lowest profit in the home office segment in each state, and dividing sales data into quarterly segments for the year 2016 using a slicer.', 'duration': 376.89, 'highlights': ['The chapter demonstrates how to find the percentage contribution of each subcategory to the total sales using a pivot table, allowing for sorting in descending order to identify the subcategories contributing the most. Using the pivot table, the process involves selecting the category and subcategory, setting the sales data to be displayed as a percentage of the grand total, and sorting the subcategories in descending order to identify the highest contributors.', 'It explains the process of identifying the customer with the lowest profit in the home office segment for each state using a pivot table and filtering for the lowest profit value. The method involves selecting the segment and state, finding the customer names and profit, sorting the profit values, and then filtering for the lowest profit to identify the customer with the lowest profit in the home office segment for each state.', 'The chapter also covers dividing sales data into quarterly segments for the year 2016 and utilizing the order year as a slicer. The process includes segmenting the sales data into quarterly periods for the year 2016 and using the order year as a slicer to facilitate easy filtering and analysis.']}, {'end': 9792.102, 'start': 9475.913, 'title': 'Pivot chart creation for sales data', 'summary': 'Discusses how to create a pivot chart to analyze sales data by quarters in 2016 for all regions, including filtering the data and introducing a slicer, and then plotting a line chart for visualization.', 'duration': 316.189, 'highlights': ['The process begins with selecting the data to slice and creating a pivot chart, followed by filtering the sales made in each quarter of 2016 for all regions and introducing a slicer for date-based filtering.', 'It involves selecting and arranging fields, such as quarters, years, region, and sales, to display the required data for analysis.', 'The tutorial also demonstrates how to plot a line chart to visualize the sales data for different regions by quarters in 2016, allowing for easy filtering and comparison.']}, {'end': 10068.071, 'start': 9792.803, 'title': 'Pivot table analysis and histogram creation', 'summary': 'Explains how to create a pivot table to find the profit made in each year for all categories of products in east and west regions, and then goes on to demonstrate the process of creating a histogram using the pivot table data.', 'duration': 275.268, 'highlights': ['The process of creating a pivot table to find the profit made in each year for all categories of products in east and west regions The chapter demonstrates how to use a pivot table to analyze profits made in each year for all categories of products in east and west regions, providing a practical approach for data analysis.', 'Demonstration of creating a histogram using the pivot table data The chapter illustrates the process of creating a histogram, offering insights on selecting different regions, years, and categories for visual representation of the data.']}], 'duration': 969.048, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ9099023.jpg', 'highlights': ['Using pivot tables to find percentage contribution of subcategories to total sales, allowing for sorting in descending order to identify highest contributors.', 'Identifying customer with lowest profit in home office segment for each state using pivot table and filtering for lowest profit value.', 'Dividing sales data into quarterly segments for the year 2016 and utilizing order year as a slicer for easy filtering and analysis.', 'Creating pivot chart to visualize sales data for different regions by quarters in 2016, allowing for easy filtering and comparison.', 'Using pivot table to find profit made in each year for all categories of products in east and west regions for practical data analysis.', 'Demonstrating creation of histogram using pivot table data for visual representation of data from different regions, years, and categories.']}, {'end': 12598.087, 'segs': [{'end': 10786.656, 'src': 'embed', 'start': 10757.076, 'weight': 12, 'content': [{'end': 10766.583, 'text': 'You will see that the Excel Power Query Editor has removed the first two rows and on the right you can see the steps that were applied.', 'start': 10757.076, 'duration': 9.507}, {'end': 10768.665, 'text': 'You can see it here.', 'start': 10766.603, 'duration': 2.062}, {'end': 10772.928, 'text': 'Previously we had these two rows which were redundant.', 'start': 10769.525, 'duration': 3.403}, {'end': 10779.11, 'text': 'and once we applied the step, it has removed the first two rows.', 'start': 10773.786, 'duration': 5.324}, {'end': 10786.656, 'text': "similarly, let's go down and remove the last one, two, three, four, five.", 'start': 10779.11, 'duration': 7.546}], 'summary': 'Excel power query removed 2 rows, applied steps, and removed 5 more rows.', 'duration': 29.58, 'max_score': 10757.076, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ10757076.jpg'}, {'end': 10999.549, 'src': 'embed', 'start': 10968.717, 'weight': 0, 'content': [{'end': 10977.403, 'text': 'so if you consider this venue, column, whatever is there between the two commas is the stadium city.', 'start': 10968.717, 'duration': 8.686}, {'end': 10980.905, 'text': 'for example, santiago bernabeu is in madrid.', 'start': 10977.403, 'duration': 3.502}, {'end': 10984.486, 'text': 'similarly, Wembley stadium is in London.', 'start': 10980.905, 'duration': 3.581}, {'end': 10985.726, 'text': 'San Siro is in Milan.', 'start': 10984.486, 'duration': 1.24}, {'end': 10992.728, 'text': 'So these medial values I want to extract into a new column called as stadium city.', 'start': 10986.506, 'duration': 6.222}, {'end': 10994.888, 'text': "So let's see how to do it.", 'start': 10993.648, 'duration': 1.24}, {'end': 10999.549, 'text': "So I'll click on the venue column and go to extract.", 'start': 10995.668, 'duration': 3.881}], 'summary': 'Extract stadium city from venue column into a new column.', 'duration': 30.832, 'max_score': 10968.717, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ10968717.jpg'}, {'end': 11134.868, 'src': 'embed', 'start': 11035.588, 'weight': 1, 'content': [{'end': 11041.466, 'text': 'you can see here we have text between delimiters and it has extracted the stadium city.', 'start': 11035.588, 'duration': 5.878}, {'end': 11050.532, 'text': 'Let me go ahead and rename this column as stadium city and hit enter.', 'start': 11042.487, 'duration': 8.045}, {'end': 11053.013, 'text': 'You can see the applied step here.', 'start': 11051.352, 'duration': 1.661}, {'end': 11060.057, 'text': 'Now I want to split the score column into two columns.', 'start': 11055.294, 'duration': 4.763}, {'end': 11070.644, 'text': 'So here we have the score column and The left value presents the number of goals that were scored by the winning team,', 'start': 11060.357, 'duration': 10.287}, {'end': 11076.429, 'text': 'and the right value presents the number of goals that were scored by the losing team.', 'start': 11070.644, 'duration': 5.785}, {'end': 11081.913, 'text': "So here I'll split the column into two columns as winner score and loser score.", 'start': 11077.329, 'duration': 4.584}, {'end': 11087.658, 'text': "So what I'll do is select this column and go to the home tab.", 'start': 11082.674, 'duration': 4.984}, {'end': 11091.361, 'text': 'Under the home tab, we have split column.', 'start': 11088.438, 'duration': 2.923}, {'end': 11094.023, 'text': "I'll select split column.", 'start': 11092.502, 'duration': 1.521}, {'end': 11098.332, 'text': 'and then choose by delimiter.', 'start': 11094.77, 'duration': 3.562}, {'end': 11109.059, 'text': "so automatically excel power query detects that this dash is my delimiter and i'll split at each occurrence of the delimiter.", 'start': 11098.332, 'duration': 10.727}, {'end': 11109.859, 'text': "let's click on.", 'start': 11109.059, 'duration': 0.8}, {'end': 11117.024, 'text': 'ok, now you can see the score column has been split into two.', 'start': 11109.859, 'duration': 7.165}, {'end': 11118.865, 'text': 'it has renamed the column as score.1 and score.2.', 'start': 11117.024, 'duration': 1.841}, {'end': 11134.868, 'text': "What I'll do is I'll go ahead and we'll rename this column as winner score and this will rename it to loser score.", 'start': 11123.166, 'duration': 11.702}], 'summary': 'Excel power query split score column into winner and loser scores.', 'duration': 99.28, 'max_score': 11035.588, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ11035588.jpg'}, {'end': 11553.452, 'src': 'embed', 'start': 11518.112, 'weight': 9, 'content': [{'end': 11521.794, 'text': "So I'll paste the URL here and click on OK.", 'start': 11518.112, 'duration': 3.682}, {'end': 11530.52, 'text': 'Now once I have done that, it will load a few tables onto Excel.', 'start': 11525.377, 'duration': 5.143}, {'end': 11532.681, 'text': 'You can see there are a few tables here.', 'start': 11530.54, 'duration': 2.141}, {'end': 11533.982, 'text': "I'll click on the first one.", 'start': 11532.901, 'duration': 1.081}, {'end': 11537.084, 'text': 'So we have our table here.', 'start': 11535.143, 'duration': 1.941}, {'end': 11540.466, 'text': "Now let's do some transformation to this data.", 'start': 11538.445, 'duration': 2.021}, {'end': 11544.588, 'text': 'This opens in the Power Query Editor.', 'start': 11542.947, 'duration': 1.641}, {'end': 11549.27, 'text': "Okay, I'll click on Refresh first.", 'start': 11547.509, 'duration': 1.761}, {'end': 11553.452, 'text': 'This will take some time to refresh the entire data.', 'start': 11549.29, 'duration': 4.162}], 'summary': 'Pasting url loads tables onto excel, then refreshing data takes time.', 'duration': 35.34, 'max_score': 11518.112, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ11518112.jpg'}, {'end': 11642.222, 'src': 'embed', 'start': 11615.826, 'weight': 20, 'content': [{'end': 11624.174, 'text': 'So the task that I want to do here is I want to compress all these columns, which are basically the population columns.', 'start': 11615.826, 'duration': 8.348}, {'end': 11634.698, 'text': "So I'll select my state or union territory column and go to the transform tab.", 'start': 11626.232, 'duration': 8.466}, {'end': 11637.619, 'text': 'And here I have the option to unpivot columns.', 'start': 11635.238, 'duration': 2.381}, {'end': 11642.222, 'text': "So I'll click on this dropdown and select unpivot other columns.", 'start': 11637.84, 'duration': 4.382}], 'summary': 'Task: compress population columns by selecting state/union territory column and using unpivot option.', 'duration': 26.396, 'max_score': 11615.826, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ11615826.jpg'}, {'end': 11712.611, 'src': 'embed', 'start': 11684.312, 'weight': 4, 'content': [{'end': 11689.093, 'text': 'now. this will take some time to load the data onto excel.', 'start': 11684.312, 'duration': 4.781}, {'end': 11692.434, 'text': 'alright, so we have our census data here.', 'start': 11689.093, 'duration': 3.341}, {'end': 11698.436, 'text': 'so first you can see rank 1 is Uttar Pradesh, and we have the population starting from 1951 till 2011.', 'start': 11692.434, 'duration': 6.002}, {'end': 11699.556, 'text': 'then we have for Maharashtra.', 'start': 11698.436, 'duration': 1.12}, {'end': 11705.306, 'text': 'If I scroll down, you can see the other states.', 'start': 11703.305, 'duration': 2.001}, {'end': 11707.948, 'text': "We have Tamil Nadu, Rajasthan, there's Karnataka.", 'start': 11705.346, 'duration': 2.602}, {'end': 11712.611, 'text': "If I scroll further, we have Odisha, there's Telangana, Kerala.", 'start': 11708.148, 'duration': 4.463}], 'summary': 'Census data from 1951 to 2011 for indian states: uttar pradesh ranks 1st with population, followed by maharashtra, tamil nadu, rajasthan, karnataka, odisha, telangana, and kerala.', 'duration': 28.299, 'max_score': 11684.312, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ11684312.jpg'}, {'end': 11760.937, 'src': 'embed', 'start': 11731.789, 'weight': 17, 'content': [{'end': 11737.8, 'text': "Let's continue with our demo and let's explore a few more features and functionalities of Power Query Editor.", 'start': 11731.789, 'duration': 6.011}, {'end': 11742.829, 'text': 'Now the next table we are going to use is an AdventureWorks customer table.', 'start': 11739.082, 'duration': 3.747}, {'end': 11748.507, 'text': 'Now this dataset is provided by Microsoft for practitioners who want to learn Power BI,', 'start': 11743.803, 'duration': 4.704}, {'end': 11754.111, 'text': 'Excel or similar technologies and want to do some manipulation, some calculation, some data analysis stuff.', 'start': 11748.507, 'duration': 5.604}, {'end': 11760.937, 'text': "So let me go to a new sheet and let's import the AdventureWorks customer dataset.", 'start': 11755.052, 'duration': 5.885}], 'summary': 'Exploring features of power query editor with adventureworks customer dataset provided by microsoft.', 'duration': 29.148, 'max_score': 11731.789, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ11731789.jpg'}, {'end': 11855.154, 'src': 'embed', 'start': 11814.272, 'weight': 11, 'content': [{'end': 11816.373, 'text': "So let's click on transform data.", 'start': 11814.272, 'duration': 2.101}, {'end': 11821.547, 'text': "Here we'll learn a few more features of Power Query.", 'start': 11817.765, 'duration': 3.782}, {'end': 11826.431, 'text': 'Okay, we have our data on our Power Query editor.', 'start': 11824.029, 'duration': 2.402}, {'end': 11835.717, 'text': "So first what I'll show you is let's change the prefix column, the first name column and the last name column to proper case.", 'start': 11827.311, 'duration': 8.406}, {'end': 11841.921, 'text': 'So you can see it here the prefix first name and last name columns are all in upper case.', 'start': 11836.597, 'duration': 5.324}, {'end': 11855.154, 'text': 'Now, if you want to change the values to proper case, just hit control and select the three columns and go to the transform tab.', 'start': 11842.641, 'duration': 12.513}], 'summary': 'Demonstrating how to change columns to proper case in power query.', 'duration': 40.882, 'max_score': 11814.272, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ11814272.jpg'}, {'end': 12063.387, 'src': 'embed', 'start': 12028.865, 'weight': 5, 'content': [{'end': 12041.908, 'text': "and so I'll select text between delimiters and I'll give my starting delimiter as at the rate, and my end delimiter would be dot com.", 'start': 12028.865, 'duration': 13.043}, {'end': 12042.748, 'text': "now let's click on.", 'start': 12041.908, 'duration': 0.84}, {'end': 12048.129, 'text': 'ok, so this will insert a new column to the extreme right.', 'start': 12042.748, 'duration': 5.381}, {'end': 12049.83, 'text': 'you can see we have our domain name.', 'start': 12048.129, 'duration': 1.701}, {'end': 12058.703, 'text': "let's go ahead and change the column name to domain name and hit enter.", 'start': 12050.677, 'duration': 8.026}, {'end': 12063.387, 'text': 'all right, you can see the step has been applied.', 'start': 12058.703, 'duration': 4.684}], 'summary': 'Selected text between delimiters, added new column for domain name, and renamed column successfully.', 'duration': 34.522, 'max_score': 12028.865, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12028865.jpg'}, {'end': 12125.824, 'src': 'embed', 'start': 12097.037, 'weight': 6, 'content': [{'end': 12099.258, 'text': "now let's explore those statistical features.", 'start': 12097.037, 'duration': 2.221}, {'end': 12104.32, 'text': "For this we'll be using another dataset called AdventureWorks product dataset.", 'start': 12100.319, 'duration': 4.001}, {'end': 12107.08, 'text': 'Again, this dataset is also provided by Microsoft.', 'start': 12104.48, 'duration': 2.6}, {'end': 12113.382, 'text': "So let's go to the new sheet and here I'll go to the data tab.", 'start': 12108.221, 'duration': 5.161}, {'end': 12115.522, 'text': 'Click on get data.', 'start': 12114.502, 'duration': 1.02}, {'end': 12120.523, 'text': 'Under from files, I click on text slash CSV.', 'start': 12116.622, 'duration': 3.901}, {'end': 12124.624, 'text': 'Here you can see we have AdventureWorks products.', 'start': 12121.203, 'duration': 3.421}, {'end': 12125.824, 'text': 'I click on import.', 'start': 12125.124, 'duration': 0.7}], 'summary': 'Exploring statistical features using adventureworks product dataset.', 'duration': 28.787, 'max_score': 12097.037, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12097037.jpg'}, {'end': 12223.73, 'src': 'embed', 'start': 12194.115, 'weight': 16, 'content': [{'end': 12195.336, 'text': 'You can see the value here.', 'start': 12194.115, 'duration': 1.221}, {'end': 12198.039, 'text': 'It says 293.', 'start': 12195.636, 'duration': 2.403}, {'end': 12201.603, 'text': 'Now to move back to the query editor, we have to cancel this step here.', 'start': 12198.039, 'duration': 3.564}, {'end': 12204.566, 'text': "So let's just click cancel or close.", 'start': 12201.863, 'duration': 2.703}, {'end': 12206.088, 'text': 'We are back again.', 'start': 12205.447, 'duration': 0.641}, {'end': 12207.409, 'text': 'All right.', 'start': 12207.129, 'duration': 0.28}, {'end': 12213.261, 'text': "let's say you want to calculate the average product price from the product table.", 'start': 12208.977, 'duration': 4.284}, {'end': 12219.547, 'text': 'so if i move to the right, you have a column called product price.', 'start': 12213.261, 'duration': 6.286}, {'end': 12223.73, 'text': "so let's see what is the average product price from the product table.", 'start': 12219.547, 'duration': 4.183}], 'summary': 'Value: 293, average product price calculation from product table.', 'duration': 29.615, 'max_score': 12194.115, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12194115.jpg'}, {'end': 12274.822, 'src': 'embed', 'start': 12248.334, 'weight': 8, 'content': [{'end': 12255.779, 'text': 'okay, now, if you want to find the maximum minimum product price, you can do that as well.', 'start': 12248.334, 'duration': 7.445}, {'end': 12262.363, 'text': 'so let me select my column product price and go to the transform tab.', 'start': 12255.779, 'duration': 6.584}, {'end': 12269.638, 'text': "under the transform tab We'll click on this statistic dropdown and let's say I'll select minimum.", 'start': 12262.363, 'duration': 7.275}, {'end': 12274.822, 'text': 'So this will give me the minimum product price, which is 2.29.', 'start': 12270.219, 'duration': 4.603}], 'summary': 'Using the transform tab, the minimum product price is 2.29.', 'duration': 26.488, 'max_score': 12248.334, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12248334.jpg'}, {'end': 12428.057, 'src': 'embed', 'start': 12385.335, 'weight': 7, 'content': [{'end': 12405.946, 'text': "so I'll give my new column name as discount price and my formula would be I'll select product price and click on insert and then I'll multiply this product price by 0.9.", 'start': 12385.335, 'duration': 20.611}, {'end': 12417.355, 'text': 'so this will give me my 10% discount on the product price and click on OK, you see, here we have a new column added which is discount price.', 'start': 12405.946, 'duration': 11.409}, {'end': 12428.057, 'text': "so if the product price is 34.99, if you give a 10% discount it's 31.491.", 'start': 12417.355, 'duration': 10.702}], 'summary': "Creating a new column 'discount price' by applying 10% discount formula, resulting in 31.491 for product price 34.99.", 'duration': 42.722, 'max_score': 12385.335, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12385335.jpg'}, {'end': 12598.087, 'src': 'embed', 'start': 12570.437, 'weight': 10, 'content': [{'end': 12582.524, 'text': "You see here, if I click on the date dropdown, year, month, quarter, weekday, day, everything has been shaded out and I can't access this.", 'start': 12570.437, 'duration': 12.087}, {'end': 12586.785, 'text': 'The reason is the date settings are not correct.', 'start': 12583.004, 'duration': 3.781}, {'end': 12589.505, 'text': "So we'll change the regional settings.", 'start': 12587.805, 'duration': 1.7}, {'end': 12591.365, 'text': 'Let me show you how to do it.', 'start': 12590.085, 'duration': 1.28}, {'end': 12598.087, 'text': "So we'll go to file and I'll select options and settings and go to query options.", 'start': 12592.166, 'duration': 5.921}], 'summary': 'Date settings need correction for query options access.', 'duration': 27.65, 'max_score': 12570.437, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12570437.jpg'}], 'start': 10068.071, 'title': 'Data manipulation with excel power query', 'summary': 'Covers excel power query features, data manipulation processes, data analysis techniques, and data transformation methods. it discusses handling various data sources, performing real-time updates, demonstrating examples such as pivot table filtering, data extraction from wikipedia, and manipulating data for statistical analysis on census, customer, and product data.', 'chapters': [{'end': 10648.878, 'start': 10068.071, 'title': 'Excel power query: data preparation & transformation', 'summary': 'Discusses the features and benefits of excel power query, including its ability to handle a broad range of data sources, perform real-time data updates, and provide an interactive experience for data preparation, with excel 2016 fully integrating power query on windows.', 'duration': 580.807, 'highlights': ['Excel Power Query enables connections to a broad range of data sources, including relational databases, web files, text, CSV, JSON files, and cloud data, addressing the challenge of data connections in Excel. Power Query addresses the challenge of data connections in Excel by allowing connections to multiple data sources, including relational databases, web files, text, CSV, JSON files, and cloud data.', 'Power Query facilitates real-time data updates and provides a repeatable process for updating data, addressing the previous issue of updating and refreshing data in real time in Excel. Power Query provides a repeatable process for updating data in real time, addressing the previous issue of updating and refreshing data in Excel.', 'Excel 2016 has fully integrated Power Query on Windows, whereas Excel 2010 and 2013 for Windows require Power Query as a free add-in, providing users with an integrated data preparation and transformation experience. Excel 2016 fully integrates Power Query on Windows, while Excel 2010 and 2013 for Windows require Power Query as a free add-in, offering an integrated data preparation and transformation experience.']}, {'end': 11285.572, 'start': 10649.138, 'title': 'Data manipulation in excel power query', 'summary': 'Explains the process of data manipulation using excel power query, including reducing rows, managing columns, extracting summary statistics, and creating new columns, with examples such as removing redundant rows, splitting columns, changing case to uppercase, and loading the cleaned data onto an excel sheet.', 'duration': 636.434, 'highlights': ['The process of data manipulation in Excel Power Query involves reducing rows, managing columns, transforming data, and combining tables. The home tab allows reducing rows, managing columns, sorting data, transforming data, and combining different tables.', 'Examples of data cleaning include removing redundant rows and deleting rows with null values. The process involves removing redundant rows and rows with null values, such as removing the top two rows and the last seven rows from the table.', 'Creating new columns involves extracting values from existing columns, such as extracting stadium names from the venue column and extracting stadium city based on the venue column. The process includes extracting stadium names and stadium cities from the venue column and splitting the score column into winner score and loser score columns.', 'Changing case to uppercase allows for consistent formatting of data, such as converting winner team and runners-up team values to uppercase. The transformation includes converting the winner team and runners-up team values to uppercase and loading the cleaned data onto an Excel sheet.', 'The final step involves loading the cleaned data onto an Excel sheet and performing analysis, such as finding the seasons in which the winners team scored more than three goals using a pivot table. The final step includes loading the cleaned data onto an Excel sheet and using a pivot table to find the seasons in which the winners team scored more than three goals.']}, {'end': 11553.452, 'start': 11286.232, 'title': 'Data analysis techniques', 'summary': 'Demonstrates how to filter a pivot table to show winning teams that scored more than three goals, determine the number of times real madrid won the championship, and use the power query editor to extract and load data from a wikipedia table into excel.', 'duration': 267.22, 'highlights': ['Real Madrid have won the championship 13 times. The pivot table analysis reveals that Real Madrid has won the championship 13 times.', 'Filtering pivot table to show winning teams that scored more than three goals. The demonstration includes filtering the pivot table to display winning teams that scored more than three goals in the finals.', 'Using Power Query Editor to extract and load data from Wikipedia table into Excel. The process of using the Power Query Editor to extract and load data from a Wikipedia table into Excel is illustrated.']}, {'end': 12274.822, 'start': 11553.792, 'title': 'Data transformation with power query', 'summary': 'Demonstrates data transformation using power query in excel, with highlights including removing unnecessary rows, unpivoting columns, merging columns, extracting domain names, and performing statistical analysis on datasets such as census, customer, and product data.', 'duration': 721.03, 'highlights': ['The step has been applied and all the population column from 1951 till 2011 have been unpivoted. Unpivoting population columns from 1951 to 2011 in the census dataset.', 'We have a full name column merged from the prefix, first name, and last name columns. Merging prefix, first name, and last name columns to create a full name column in the customer dataset.', 'The average product price from the product table is 714.4373. Calculating the average product price from the product table.', 'The first row in this table is not necessary at all because these are our column names. Identifying and removing unnecessary rows in the dataset.', 'Extracting domain names from email addresses in the customer dataset. Creating a new column for domain names by extracting characters from email addresses in the customer dataset.']}, {'end': 12598.087, 'start': 12274.822, 'title': 'Power query data manipulation', 'summary': 'Demonstrates using power query to manipulate data, including finding maximum product price, rounding values, adding custom columns, and preparing calendar data for manipulation in excel, with detailed steps and examples.', 'duration': 323.265, 'highlights': ['The chapter demonstrates using Power Query to manipulate data, including finding maximum product price, rounding values, adding custom columns, and preparing calendar data for manipulation in Excel, with detailed steps and examples.', 'The speaker explains how to find the maximum product price by selecting the product price column, going to the transform tab, and choosing the maximum, providing practical steps for data manipulation.', 'Detailed steps are provided for rounding the product cost and product price columns to two decimal places, demonstrating practical application of data transformation in Power Query.', 'The process of adding a discount price column by multiplying 0.9 to the product price column and rounding the new column to two decimal places is explained with a clear demonstration of the mathematical operation and its outcome for a specific product price.', 'The demonstration includes adding a new custom column for discount price, with a practical example showing the application of a 10% discount to a specific product price and rounding the result to two decimal places.', 'The chapter covers the process of preparing calendar data for manipulation in Excel using Power Query, including importing the adventureworks calendar table and transforming the data to ensure correct column names and settings for subsequent operations.', 'The speaker provides detailed guidance on navigating the query editor, including transforming data, correcting column names, and adjusting regional settings to enable access to date fields for manipulation.', 'The chapter includes practical examples and detailed instructions for performing various operations in Power Query, such as finding sum, average, count, rounding values, adding custom columns, and preparing data for manipulation in Excel, demonstrating the versatility and functionality of Power Query for data analysis and manipulation.', 'The speaker uses a practical approach to demonstrate the functionality of Power Query, providing step-by-step guidance and practical examples for data manipulation, ensuring clear understanding and application of the concepts.', 'The chapter highlights the practical application of Power Query for data manipulation and analysis, demonstrating the ability to perform diverse operations, such as finding maximum values, rounding decimal places, adding custom columns, and preparing data for further manipulation in Excel.']}], 'duration': 2530.016, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ10068071.jpg', 'highlights': ['Excel Power Query enables connections to various data sources, addressing the challenge of data connections in Excel.', 'Power Query facilitates real-time data updates and provides a repeatable process for updating data.', 'Excel 2016 fully integrates Power Query on Windows, offering an integrated data preparation and transformation experience.', 'The process of data manipulation in Excel Power Query involves reducing rows, managing columns, transforming data, and combining tables.', 'Examples of data cleaning include removing redundant rows and deleting rows with null values.', 'Creating new columns involves extracting values from existing columns and splitting the score column into winner score and loser score columns.', 'The transformation includes converting the winner team and runners-up team values to uppercase and loading the cleaned data onto an Excel sheet.', 'The pivot table analysis reveals that Real Madrid has won the championship 13 times.', 'Filtering the pivot table to display winning teams that scored more than three goals in the finals.', 'Using Power Query Editor to extract and load data from a Wikipedia table into Excel.', 'Unpivoting population columns from 1951 to 2011 in the census dataset.', 'Merging prefix, first name, and last name columns to create a full name column in the customer dataset.', 'Calculating the average product price from the product table.', 'Identifying and removing unnecessary rows in the dataset.', 'Creating a new column for domain names by extracting characters from email addresses in the customer dataset.', 'The chapter demonstrates using Power Query to manipulate data, including finding maximum product price, rounding values, adding custom columns, and preparing calendar data for manipulation in Excel.', 'Practical steps for finding the maximum product price, rounding values, adding custom columns, and preparing calendar data for manipulation in Excel.', 'Detailed steps for rounding the product cost and product price columns to two decimal places, demonstrating practical application of data transformation in Power Query.', 'The process of adding a discount price column by multiplying 0.9 to the product price column and rounding the new column to two decimal places is explained with a clear demonstration of the mathematical operation and its outcome for a specific product price.', 'The chapter covers the process of preparing calendar data for manipulation in Excel using Power Query, including importing the adventureworks calendar table and transforming the data to ensure correct column names and settings for subsequent operations.', 'Detailed guidance on navigating the query editor, including transforming data, correcting column names, and adjusting regional settings to enable access to date fields for manipulation.', 'Practical examples and detailed instructions for performing various operations in Power Query, such as finding sum, average, count, rounding values, adding custom columns, and preparing data for manipulation in Excel.', 'The practical application of Power Query for data manipulation and analysis, demonstrating the ability to perform diverse operations, such as finding maximum values, rounding decimal places, adding custom columns, and preparing data for further manipulation in Excel.']}, {'end': 13984.768, 'segs': [{'end': 12728.302, 'src': 'embed', 'start': 12690.258, 'weight': 0, 'content': [{'end': 12690.798, 'text': "I'll close this.", 'start': 12690.258, 'duration': 0.54}, {'end': 12698.453, 'text': "Now let's add a new column, say day name, start of the week and others.", 'start': 12693.41, 'duration': 5.043}, {'end': 12700.754, 'text': "So I'll select my date column.", 'start': 12699.293, 'duration': 1.461}, {'end': 12703.996, 'text': 'Go to add column.', 'start': 12702.115, 'duration': 1.881}, {'end': 12714.661, 'text': 'Here under add column, I have my option to select the day name, the week name and others.', 'start': 12705.056, 'duration': 9.605}, {'end': 12719.844, 'text': "So I'll click on this date, drop down and under day.", 'start': 12714.901, 'duration': 4.943}, {'end': 12725.34, 'text': "let's say I want to choose name of day.", 'start': 12719.844, 'duration': 5.496}, {'end': 12728.302, 'text': 'this returns the day name.', 'start': 12725.34, 'duration': 2.962}], 'summary': 'Add day name column from date column.', 'duration': 38.044, 'max_score': 12690.258, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12690258.jpg'}, {'end': 13847.435, 'src': 'embed', 'start': 13821.042, 'weight': 1, 'content': [{'end': 13825.226, 'text': 'To access Power BI Service, you need to login to app.powerbi.com.', 'start': 13821.042, 'duration': 4.184}, {'end': 13826.687, 'text': 'Now let me show you that.', 'start': 13825.746, 'duration': 0.941}, {'end': 13828.189, 'text': "I'll go to Google.", 'start': 13827.368, 'duration': 0.821}, {'end': 13834.494, 'text': "I'll open a new tab and search for app.powerbi.com.", 'start': 13829.169, 'duration': 5.325}, {'end': 13836.436, 'text': "It's loading.", 'start': 13835.975, 'duration': 0.461}, {'end': 13840.472, 'text': 'This is how the homepage of Power BI Service looks like.', 'start': 13837.831, 'duration': 2.641}, {'end': 13842.613, 'text': "I've created some dashboards on it.", 'start': 13841.093, 'duration': 1.52}, {'end': 13845.575, 'text': 'First, you need to login to app.powerbiservice.', 'start': 13843.174, 'duration': 2.401}, {'end': 13847.435, 'text': "You can see I'm logged in.", 'start': 13846.255, 'duration': 1.18}], 'summary': 'To access power bi service, login to app.powerbi.com and view the dashboards created.', 'duration': 26.393, 'max_score': 13821.042, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ13821042.jpg'}], 'start': 12600.02, 'title': 'Power query, power bi, and business intelligence', 'summary': "Covers data transformation, joining data, combining and merging data in power query, and power bi's features and functionalities including easy drag and drop tools, real-time stream analytics, and the architecture of power bi.", 'chapters': [{'end': 12986.895, 'start': 12600.02, 'title': 'Data transformation and joining data in power query', 'summary': 'Demonstrates the process of transforming date columns, including formatting, finding earliest and latest dates, and adding new columns like day name and start of the week. it also explains how to join data stored in multiple csv files and load it into excel for analysis.', 'duration': 386.875, 'highlights': ['The chapter demonstrates the process of transforming date columns, including formatting, finding earliest and latest dates, and adding new columns like day name and start of the week. The demonstration includes selecting regional settings, formatting date columns, finding earliest and latest dates, and adding new columns like day name and start of the week.', 'It also explains how to join data stored in multiple CSV files and load it into Excel for analysis. The tutorial covers the process of combining and loading data from multiple CSV files into Excel for further analysis.']}, {'end': 13499.905, 'start': 12986.895, 'title': 'Combine and merge data with power query', 'summary': 'Demonstrates how to combine and merge data in power query, including vertically combining csv files and horizontally merging tables from excel using left outer join, resulting in successfully combining five excel files and merging student and course data.', 'duration': 513.01, 'highlights': ['Power Query combines five Excel files vertically, achieving the successful combination of project1.xls, project2.xls, project3, project4, and project5.', 'Horizontal merging of student and course data is demonstrated using a left outer join, resulting in the successful merging of both tables based on a common key column, with 175 matching rows from the first table.', 'The process of importing and merging tables is explained step by step, including loading the courses table onto Power Query Editor, loading the year 11 table, and merging the two tables using the left outer join.', 'The demonstration showcases various functionalities of Power Query, such as importing a text file, plotting graphs and charts, importing data from the web, using the unpivot feature, and making calculations to the customer and products tables.', 'The chapter also includes importing a UEFA Champions League table from Wikipedia, making analysis using pivot tables, and importing a web file based on population data.']}, {'end': 13732.336, 'start': 13499.905, 'title': 'Understanding power bi and business intelligence', 'summary': 'Covers the applications of power bi and business intelligence, including its features, data sources, and components. power bi allows access to vast volumes of data, provides easy drag and drop tools, accelerates big data preparation with azure, and allows real-time stream analytics.', 'duration': 232.431, 'highlights': ["Power BI's ability to access vast volumes of data Power BI enables access to vast volumes of data from multiple sources, allowing visualization and analysis of large quantities of data that cannot be opened in Excel.", 'Integration of Power BI with Excel and Azure Power BI has exceptional integration with Excel, aiding in gathering, analyzing, publishing, and sharing Excel business data. Additionally, using Power BI with Azure accelerates big data preparation and allows analysis and sharing of vast volumes of data.', 'Real-time stream analytics with Power BI Power BI allows real-time stream analytics by fetching data from multiple sensors and social media sources, enabling timely data-driven business decisions.', "Power BI's support for multiple data sources Power BI supports various data sources such as Excel, CSV, SQL Server, and web files to create interactive visualizations, providing flexibility in data analysis.", "Power BI's custom visualization feature Power BI offers a custom library of visualizations to deal with complex data, allowing users to access visualizations that meet their specific needs."]}, {'end': 13984.768, 'start': 13732.716, 'title': 'Power bi overview', 'summary': 'Provides an overview of power bi, including its components and functionalities such as power pivot, power view, power map, power bi desktop, power q&a, power bi service, creating dashboards, publishing reports, and the architecture of power bi.', 'duration': 252.052, 'highlights': ['Power BI Service Power BI Service allows users to connect to data, create reports and dashboards, and ask questions to the data, providing a comprehensive data analysis experience.', 'Power BI Dashboard Features Power BI dashboard allows the creation of single-page visualizations called canvas with tiles pinned by report designers, enabling storytelling through multiple reports and datasets.', 'Power BI Architecture Power BI architecture is a service built on top of Azure, offering connectivity to multiple data sources, creation of reports and visualizations, and cloud services for publishing reports and data visualizations.', 'Power Pivot, Power View, and Power Map Power Pivot enables creating data models with relationships and calculations, Power View allows creating interactive charts, graphs, and visuals, while Power Map provides 3D data visualization tools for mapping data visually on Bing Maps.', 'Power BI Desktop Power BI Desktop integrates Power Query, Power Pivot, and Power View for easier development of BI and data analysis experience, providing a comprehensive solution under a single tool.']}], 'duration': 1384.748, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ12600020.jpg', 'highlights': ["Power BI's ability to access vast volumes of data from multiple sources for visualization and analysis.", "Power Query's demonstration of combining and loading data from multiple CSV files into Excel for analysis.", "Power BI's integration with Excel and Azure for gathering, analyzing, publishing, and sharing Excel business data.", "Power BI's support for real-time stream analytics by fetching data from multiple sensors and social media sources.", 'Power BI Service enabling users to connect to data, create reports and dashboards, and ask questions to the data.']}, {'end': 16732.396, 'segs': [{'end': 14271.75, 'src': 'embed', 'start': 14238.034, 'weight': 3, 'content': [{'end': 14240.255, 'text': 'The first matrix shows us the total sales that were made.', 'start': 14238.034, 'duration': 2.221}, {'end': 14244.058, 'text': 'The second matrix shows you the total units that were sold.', 'start': 14240.636, 'duration': 3.422}, {'end': 14247.801, 'text': "Now let's move ahead and create a simple bar chart.", 'start': 14244.759, 'duration': 3.042}, {'end': 14252.024, 'text': 'So under visualization, I click on clustered column chart.', 'start': 14248.281, 'duration': 3.743}, {'end': 14260.68, 'text': "Under this, we'll drag the date column onto axis and the sales onto value.", 'start': 14254.935, 'duration': 5.745}, {'end': 14262.202, 'text': 'Let me expand it.', 'start': 14260.7, 'duration': 1.502}, {'end': 14264.864, 'text': 'So it shows you the sales by year.', 'start': 14262.682, 'duration': 2.182}, {'end': 14271.75, 'text': 'This is the sales that were made in 2013 and this shows you the sales that were made in 2014.', 'start': 14265.364, 'duration': 6.386}], 'summary': 'Total sales and units, visualize in bar chart with sales by year', 'duration': 33.716, 'max_score': 14238.034, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ14238034.jpg'}, {'end': 14427.635, 'src': 'embed', 'start': 14399.088, 'weight': 2, 'content': [{'end': 14404.232, 'text': "So you can see we have our map ready and we'll drag sales on to size.", 'start': 14399.088, 'duration': 5.144}, {'end': 14408.356, 'text': 'You can see the different countries and the sales that they made.', 'start': 14405.093, 'duration': 3.263}, {'end': 14411.919, 'text': 'If I move the map you can see the sales made in the Europe region.', 'start': 14408.376, 'duration': 3.543}, {'end': 14415.251, 'text': 'Let me resize it.', 'start': 14414.471, 'duration': 0.78}, {'end': 14416.712, 'text': "I'll add a border to this.", 'start': 14415.691, 'duration': 1.021}, {'end': 14424.034, 'text': 'Now let me go ahead and create a donut chart that will show you the profit by each segment.', 'start': 14419.552, 'duration': 4.482}, {'end': 14427.635, 'text': "Under Visualizations, I'll click on Donut Chart.", 'start': 14424.654, 'duration': 2.981}], 'summary': 'Map displays sales by country, europe region highlighted. donut chart visualizes profit by segment.', 'duration': 28.547, 'max_score': 14399.088, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ14399088.jpg'}, {'end': 14834.533, 'src': 'embed', 'start': 14804.379, 'weight': 0, 'content': [{'end': 14815.008, 'text': 'It says a ua tl dot on Microsoft COM now, how do you get this kind of email, because when you talk about power bi it will expect you to have.', 'start': 14804.379, 'duration': 10.629}, {'end': 14824.44, 'text': 'A official ID and it does not take IDs, which are from common domains such as Google or Yahoo and so on.', 'start': 14815.589, 'duration': 8.851}, {'end': 14829.747, 'text': 'So this particular link gives you an idea how you can do that.', 'start': 14824.901, 'duration': 4.846}, {'end': 14834.533, 'text': 'So basically you have what is power bi basic explanation on that.', 'start': 14830.448, 'duration': 4.085}], 'summary': 'To access power bi, use official email ids, not common domains like google or yahoo.', 'duration': 30.154, 'max_score': 14804.379, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ14804379.jpg'}, {'end': 15000.209, 'src': 'embed', 'start': 14971.109, 'weight': 4, 'content': [{'end': 14979.449, 'text': 'it will guide you through the process where you can create an account, like i have done now, once you have done that.', 'start': 14971.109, 'duration': 8.34}, {'end': 14990.097, 'text': 'so, for example, we can go into my this page, which i said http slash slash app power bi dot com.', 'start': 14979.449, 'duration': 10.648}, {'end': 14994.947, 'text': 'Now, once you have created an account, you would be asked to log in.', 'start': 14991.186, 'duration': 3.761}, {'end': 15000.209, 'text': 'Now, I can click and log in here and then basically given my password.', 'start': 14995.147, 'duration': 5.062}], 'summary': 'Guidance on creating an account and logging in to power bi platform.', 'duration': 29.1, 'max_score': 14971.109, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ14971109.jpg'}, {'end': 16342.662, 'src': 'embed', 'start': 16317.957, 'weight': 5, 'content': [{'end': 16328.187, 'text': 'so, for example, i can just say apply for now, and that should basically apply the changes Which I have performed using my query editor.', 'start': 16317.957, 'duration': 10.23}, {'end': 16334.576, 'text': 'That is, I have transformed the data so that I can have selective data uploaded in my Power BI.', 'start': 16328.227, 'duration': 6.349}, {'end': 16336.258, 'text': "Now it's doing that.", 'start': 16334.836, 'duration': 1.422}, {'end': 16339.422, 'text': 'It shows me it is working on both of these data sources.', 'start': 16336.538, 'duration': 2.884}, {'end': 16341.165, 'text': 'That is, orders and returns.', 'start': 16339.482, 'duration': 1.683}, {'end': 16342.662, 'text': "so that's done.", 'start': 16341.621, 'duration': 1.041}], 'summary': 'Query editor applied changes to upload selective data in power bi from orders and returns.', 'duration': 24.705, 'max_score': 16317.957, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ16317957.jpg'}], 'start': 13985.329, 'title': "Meijer's power bi success and features", 'summary': "Details meijer's success using power bi to gain real-time insights from 20 billion rows of data, enabling departments to analyze and improve sales performance. it also covers an introduction to power bi, its features, functionalities, establishing relationships, using dax, and a quick demo. key benefits like enhanced decision making, advanced data services, and seamless integration are highlighted.", 'chapters': [{'end': 14478.787, 'start': 13985.329, 'title': "Meijer's power bi success", 'summary': 'Details how meijer utilized power bi to gain real-time insights from 20 billion rows of data, enabling departments to analyze and improve sales performance, and provides a step-by-step demonstration of creating reports and visualizations using power bi.', 'duration': 493.458, 'highlights': ['Meijer connected Power BI to an on-premises SQL Server Analysis Services cube, allowing them to refresh 20 billion rows of data in near real-time, enabling faster data pull and real-time analysis for insights.', 'The bakery department at Meijer used Power BI to compare sales with regional performance, leading to the identification of problem areas and the implementation of solutions, and the ability to drill down into hourly sales and send out sales updates to 800 business leaders.', 'The demonstration showcases the creation of various visualizations in Power BI, including matrices, bar charts, pie charts, tables, maps, donut charts, and tree maps, providing insights into sales data by segment, product, and country.', 'The Power BI desktop interface allows users to visualize data with different charts and graphs, and the data view and model view help in viewing the entire data and checking for table relationships and connections.']}, {'end': 15162.641, 'start': 14479.387, 'title': 'Power bi: basics and benefits', 'summary': 'Provides an introduction to power bi, covering the process of changing colors, exploring different themes, understanding the benefits like enhanced decision making, advanced data services, seamless integration, secure report publishing, and connecting to different data sources, as well as a guide on setting up power bi components and licensing information.', 'duration': 683.254, 'highlights': ['Enhanced decision making through transforming enterprise data into rich visuals and accurate reports The ability of Power BI to transform enterprise data into rich visuals and accurate reports enables enhanced decision making, providing rapid and accurate extraction of intelligence.', 'Seamless integration with advanced cloud services like Cortana and existing applications Power BI seamlessly integrates with advanced cloud services like Cortana and existing applications, allowing for the adoption of analytics and reporting capabilities easily, and the embedding of interactive visuals quickly.', 'Secure report publishing and automatic data refresh for multiple users Power BI provides a secure way of publishing reports with automatic data refresh, enabling multiple users to access the latest information across the organization or working community.', 'Connecting to different data sources and options for setting up Power BI components Power BI allows connection to different data sources, including Excel, CSV, JSON, PDF, and databases, and provides options for setting up Power BI components like Power BI Desktop, Server, and Mobile.', 'Licensing information for Power BI service, including pro version and premium account The licensing information for Power BI service includes details about the pro version, with limitations on features like incremental refresh, and the premium account, which is conditional based on usage requirements.']}, {'end': 15678.091, 'start': 15162.681, 'title': 'Exploring power bi features', 'summary': 'Discusses the features and functionalities of power bi, including sharing reports, anomaly detection, automation of reports, security implementation, connecting to various data sources, visualization options, data modeling, and data relationships.', 'duration': 515.41, 'highlights': ['Power BI allows connecting to various data sources such as servers, database services, folders, and different file formats, including the ability to connect to cloud services like Azure. Power BI offers extensive data connectivity options, including connecting to servers, database services, folders, and different file formats, and supports connection to cloud services like Azure.', 'The visualization pane in Power BI enables the creation of different visualizations and deriving insights from data, including the ability to create various charts, graphs, and maps. The visualization pane in Power BI provides the capability to create diverse visualizations, including charts, graphs, and maps, to derive insights from the data.', 'Data modeling in Power BI is essential for establishing relationships between multiple data sources and tables to obtain insights and information from various sources. Data modeling in Power BI is crucial for establishing relationships between multiple data sources and tables to obtain insights and information from various sources.']}, {'end': 15957.867, 'start': 15678.683, 'title': 'Establishing relationships and using dax in power bi', 'summary': 'Discusses the importance of creating a data model to establish relationships between tables using common key columns in power bi, and the use of data analysis expressions (dax) to create calculated columns and measures, providing more power to work on the data and not increasing file size.', 'duration': 279.184, 'highlights': ['Creating a data model to establish relationships between tables using common key columns By creating a data model with relationships between tables using common key columns, such as the product key, in Power BI, various types of relationships like one-to-one and one-to-many can be established to effectively connect and analyze data.', 'Use of Data Analysis Expressions (DAX) to create calculated columns and measures DAX provides a library of functions and operators to build formulas and expressions in Power BI, allowing the creation of calculated columns and measures, which do not increase file size and provide more power to work on the data.', 'Types of DAX functions available in Power BI such as date and time, logical, text, statistical, and information functions Power BI offers various types of DAX functions including date and time, logical, text, statistical, and information functions, providing the capability to work on date and time data, create filters, transform text data, perform statistical analysis, and gather information.']}, {'end': 16732.396, 'start': 15958.548, 'title': 'Power bi quick demo', 'summary': 'Covers a quick demo of using power bi, including uploading and transforming datasets, visualizing data, and creating a report, with emphasis on selective data loading and data transformation.', 'duration': 773.848, 'highlights': ['The demo includes uploading and transforming datasets, with emphasis on selective data loading and data transformation. The demo showcases the process of uploading datasets from internet sources or GitHub, transforming the data to select specific fields, and visualizing the information within the dataset.', 'The process involves selecting specific data from datasets, such as filtering for data related to the United States, and transforming the data accordingly. The presenter demonstrates selecting specific data from datasets, like filtering for information related to the United States, and then transforming the data based on the selected criteria.', 'The demo explains the use of Power Query Editor for data transformation, including changing data types and applying various transformations. The presenter explains the functionalities of Power Query Editor, including changing data types, applying transformations, and using different options like adding custom columns, removing top rows, and handling errors and duplicates.', 'The chapter demonstrates creating visualizations and reports in Power BI, such as creating tables and applying advanced filtering to visualize data. The demo illustrates creating visualizations in Power BI, including creating tables, adding data fields, and applying advanced filtering for visualizing specific data, along with formatting options for improving readability.']}], 'duration': 2747.067, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ13985329.jpg', 'highlights': ['Meijer connected Power BI to an on-premises SQL Server Analysis Services cube, allowing them to refresh 20 billion rows of data in near real-time, enabling faster data pull and real-time analysis for insights.', 'The bakery department at Meijer used Power BI to compare sales with regional performance, leading to the identification of problem areas and the implementation of solutions, and the ability to drill down into hourly sales and send out sales updates to 800 business leaders.', 'Enhanced decision making through transforming enterprise data into rich visuals and accurate reports The ability of Power BI to transform enterprise data into rich visuals and accurate reports enables enhanced decision making, providing rapid and accurate extraction of intelligence.', 'Power BI allows connecting to various data sources such as servers, database services, folders, and different file formats, including the ability to connect to cloud services like Azure. Power BI offers extensive data connectivity options, including connecting to servers, database services, folders, and different file formats, and supports connection to cloud services like Azure.', 'Creating a data model to establish relationships between tables using common key columns By creating a data model with relationships between tables using common key columns, such as the product key, in Power BI, various types of relationships like one-to-one and one-to-many can be established to effectively connect and analyze data.', 'The demo includes uploading and transforming datasets, with emphasis on selective data loading and data transformation. The demo showcases the process of uploading datasets from internet sources or GitHub, transforming the data to select specific fields, and visualizing the information within the dataset.']}, {'end': 17697.141, 'segs': [{'end': 16867.908, 'src': 'embed', 'start': 16839.208, 'weight': 0, 'content': [{'end': 16844.732, 'text': "So I've created a simple visualization using the data which I have.", 'start': 16839.208, 'duration': 5.524}, {'end': 16847.894, 'text': 'And what I can do is I can click on save.', 'start': 16845.293, 'duration': 2.601}, {'end': 16854.839, 'text': 'So that basically asks me to save this as a Power BI file, which has an extension of PBIX.', 'start': 16848.175, 'duration': 6.664}, {'end': 16858.282, 'text': 'And I can basically call it my report.', 'start': 16855.36, 'duration': 2.922}, {'end': 16861.724, 'text': "So let's say first report.", 'start': 16858.322, 'duration': 3.402}, {'end': 16867.908, 'text': 'And here I can say country or I can say state.', 'start': 16862.605, 'duration': 5.303}], 'summary': 'Created a power bi visualization with options to save as a pbix file and customize report.', 'duration': 28.7, 'max_score': 16839.208, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ16839208.jpg'}, {'end': 16967.713, 'src': 'embed', 'start': 16935.723, 'weight': 7, 'content': [{'end': 16937.906, 'text': 'so you can have different workspaces.', 'start': 16935.723, 'duration': 2.183}, {'end': 16939.408, 'text': 'i will choose the default.', 'start': 16937.906, 'duration': 1.502}, {'end': 16940.649, 'text': "that's my workspace.", 'start': 16939.408, 'duration': 1.241}, {'end': 16942.491, 'text': 'i can click on select.', 'start': 16940.649, 'duration': 1.842}, {'end': 16945.395, 'text': 'now it says publishing first report statewide.', 'start': 16942.491, 'duration': 2.904}, {'end': 16951.497, 'text': 'sales in usa to power bi can create a portrait view of your report and you can do all that stuff.', 'start': 16945.395, 'duration': 6.102}, {'end': 16958.126, 'text': 'so let it publish and then we can basically look into our power bi server.', 'start': 16951.497, 'duration': 6.629}, {'end': 16967.713, 'text': "that's our service where the information is already shared or published, I would say, which can then be shared with different sources.", 'start': 16958.126, 'duration': 9.587}], 'summary': 'Publishing first report statewide, creating portrait view in power bi, sharing with different sources.', 'duration': 31.99, 'max_score': 16935.723, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ16935723.jpg'}, {'end': 17279.864, 'src': 'embed', 'start': 17258.594, 'weight': 3, 'content': [{'end': 17267.701, 'text': 'So when I click on my workspace here, I can click on reports, and that does show me my previous report.', 'start': 17258.594, 'duration': 9.107}, {'end': 17269.781, 'text': 'it shows me the modified report.', 'start': 17267.701, 'duration': 2.08}, {'end': 17274.302, 'text': 'it gives me an option of looking at the usage metrics report.', 'start': 17269.781, 'duration': 4.521}, {'end': 17279.864, 'text': 'so say, for example, you want to click on this one and it will basically give you the usage metrics.', 'start': 17274.302, 'duration': 5.562}], 'summary': 'Access reports in workspace, view previous and modified reports, and analyze usage metrics.', 'duration': 21.27, 'max_score': 17258.594, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ17258594.jpg'}, {'end': 17424.835, 'src': 'embed', 'start': 17392.444, 'weight': 2, 'content': [{'end': 17399.225, 'text': 'it would be interesting to look at the product which we have or basically customer id.', 'start': 17392.444, 'duration': 6.781}, {'end': 17400.725, 'text': 'so we can look at customer id.', 'start': 17399.225, 'duration': 1.5}, {'end': 17407.512, 'text': 'we can look at the order id, which would be interesting to see if there is a particular order,', 'start': 17400.725, 'duration': 6.787}, {'end': 17414.213, 'text': 'what was the sales which was generated and if there were any returns which were happening on that.', 'start': 17407.512, 'duration': 6.701}, {'end': 17424.835, 'text': 'so, for example, here, when i have these, let me cut out country as a field and i will basically take order id and place it here.', 'start': 17414.213, 'duration': 10.622}], 'summary': 'Analyze customer and order data to track sales and returns.', 'duration': 32.391, 'max_score': 17392.444, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ17392444.jpg'}], 'start': 16732.396, 'title': 'Power bi data reporting', 'summary': 'Provides an overview of creating, modifying, and analyzing a power bi report, including adding data fields, applying filters, creating relationships between data sets, and formatting the report, resulting in an easily modifiable and visually appealing data report.', 'chapters': [{'end': 16811.835, 'start': 16732.396, 'title': 'Visual data analysis tool', 'summary': 'Introduces a visual data analysis tool allowing users to create reports, add filters, and export data, providing flexibility in data visualization and analysis.', 'duration': 79.439, 'highlights': ['Users can create reports, add filters, and export data, providing flexibility in data visualization and analysis.', 'The tool allows users to easily navigate through data and focus on specific fields or states for in-depth analysis.', 'The report offers the option to show data as a table and provides an export feature for the selected data.']}, {'end': 17137.294, 'start': 16811.835, 'title': 'Power bi report creation and sharing', 'summary': 'Demonstrates how to create and save a power bi report, publish it to power bi service, and share it with other users, with instructions for various options and functionalities available within power bi.', 'duration': 325.459, 'highlights': ["You can create a simple visualization using the data, save it as a Power BI file, and name it with specific details such as 'first report' and 'state wise sales in USA'. Demonstrates the process of creating a simple visualization using the data, saving it as a Power BI file, and providing specific details for naming the report.", 'After publishing the report to Power BI service, you can access it, save a different copy, embed it in a website, publish it to web, export it to PowerPoint, and perform various editing and sharing options including sharing to teams and subscribing to usage metrics report. Describes the post-publishing options such as accessing the report, saving a copy, embedding, publishing to web, exporting to PowerPoint, and editing and sharing options including sharing to teams and subscribing to usage metrics report.', 'When sharing the report, users with Power BI Pro will have access, and recipients can be granted access, allowed to build new content using the underlying data sets, and sent an email notification. Explains the sharing process, access for users with Power BI Pro, granting access to recipients, allowing content creation, and sending email notifications.']}, {'end': 17697.141, 'start': 17137.294, 'title': 'Power bi data reporting', 'summary': 'Provides an overview of creating, modifying, and analyzing a power bi report, including adding data fields, applying filters, creating relationships between data sets, and formatting the report, resulting in an easily modifiable and visually appealing data report.', 'duration': 559.847, 'highlights': ['Creating and modifying Power BI report The speaker explains the process of creating and modifying a Power BI report, including adding data fields and applying filters, resulting in a user-friendly interface for data analysis.', 'Creating relationships between data sets The process of creating relationships between data sets in Power BI is detailed, involving identifying related tables and columns, defining the relationship cardinality, and making the relationship active, resulting in accurate data representation and analysis.', 'Formatting the Power BI report The speaker demonstrates the process of formatting a Power BI report, including adjusting grid options, selecting grid colors, and rearranging columns, resulting in a visually appealing and easily understandable report layout.']}], 'duration': 964.745, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ16732396.jpg', 'highlights': ['Users can create reports, add filters, and export data, providing flexibility in data visualization and analysis.', 'The tool allows users to easily navigate through data and focus on specific fields or states for in-depth analysis.', 'The report offers the option to show data as a table and provides an export feature for the selected data.', 'After publishing the report to Power BI service, you can access it, save a different copy, embed it in a website, publish it to web, export it to PowerPoint, and perform various editing and sharing options including sharing to teams and subscribing to usage metrics report.', 'When sharing the report, users with Power BI Pro will have access, and recipients can be granted access, allowed to build new content using the underlying data sets, and sent an email notification.', 'Creating and modifying Power BI report The speaker explains the process of creating and modifying a Power BI report, including adding data fields and applying filters, resulting in a user-friendly interface for data analysis.', 'Creating relationships between data sets The process of creating relationships between data sets in Power BI is detailed, involving identifying related tables and columns, defining the relationship cardinality, and making the relationship active, resulting in accurate data representation and analysis.', 'Formatting the Power BI report The speaker demonstrates the process of formatting a Power BI report, including adjusting grid options, selecting grid colors, and rearranging columns, resulting in a visually appealing and easily understandable report layout.']}, {'end': 19032.114, 'segs': [{'end': 17827.338, 'src': 'embed', 'start': 17753.419, 'weight': 2, 'content': [{'end': 17772.525, 'text': 'so, for example, if i would just call it something like scientist id, okay, and then i can say scientist name and then basically i can say uh, domain,', 'start': 17753.419, 'duration': 19.106}, {'end': 17783.251, 'text': "and then i can say, for example, let's say year of joining and and i can keep adding the number of columns here,", 'start': 17772.525, 'duration': 10.726}, {'end': 17789.094, 'text': 'i can delete the columns right and i can give this and i can say country.', 'start': 17783.251, 'duration': 5.843}, {'end': 17790.852, 'text': "so that's it.", 'start': 17789.094, 'duration': 1.758}, {'end': 17799.619, 'text': 'and now we have created these five countries, sorry, five columns which we have given some names and we can start entering some values.', 'start': 17790.852, 'duration': 8.767}, {'end': 17815.192, 'text': "so i can basically say let this scientist id be 2234, i can give some name, so let's give peter, let's say domain, and i can say biotechnology.", 'start': 17799.619, 'duration': 15.573}, {'end': 17820.472, 'text': 'I can give year of joining 2011..', 'start': 17816.849, 'duration': 3.623}, {'end': 17822.954, 'text': 'I can say Germany as the country.', 'start': 17820.472, 'duration': 2.482}, {'end': 17827.338, 'text': "And I really don't want this particular column.", 'start': 17823.915, 'duration': 3.423}], 'summary': "Creating a data table with 5 columns for scientists' information.", 'duration': 73.919, 'max_score': 17753.419, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ17753419.jpg'}, {'end': 17988.638, 'src': 'embed', 'start': 17959.752, 'weight': 11, 'content': [{'end': 17964.573, 'text': 'so i can just say string, because we are not going to perform any computation here.', 'start': 17959.752, 'duration': 4.821}, {'end': 17966.614, 'text': 'so on the id column.', 'start': 17964.573, 'duration': 2.041}, {'end': 17970.015, 'text': "so let's say text and i'm changing it.", 'start': 17966.614, 'duration': 3.401}, {'end': 17972.596, 'text': 'so it says replace current, add a new step.', 'start': 17970.015, 'duration': 2.581}, {'end': 17975.596, 'text': 'so selected column has an existing type conversion.', 'start': 17972.596, 'duration': 3}, {'end': 17978.838, 'text': 'would you like to replace the existing conversion or preserve the existing?', 'start': 17975.596, 'duration': 3.242}, {'end': 17980.298, 'text': 'so i will say replace current.', 'start': 17978.838, 'duration': 1.46}, {'end': 17983.495, 'text': 'and now the data type has been changed.', 'start': 17980.993, 'duration': 2.502}, {'end': 17988.638, 'text': 'it is of a string and if you see, this step has got added here.', 'start': 17983.495, 'duration': 5.143}], 'summary': 'Column data type changed to string, existing conversion replaced.', 'duration': 28.886, 'max_score': 17959.752, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ17959752.jpg'}, {'end': 18062.58, 'src': 'embed', 'start': 18036.609, 'weight': 8, 'content': [{'end': 18040.793, 'text': 'you can just say transform and how do you want to change it?', 'start': 18036.609, 'duration': 4.184}, {'end': 18043.114, 'text': 'so, do you want to change it to uppercase?', 'start': 18040.793, 'duration': 2.321}, {'end': 18046.757, 'text': 'well, you can do that and changes all the values of this one.', 'start': 18043.114, 'duration': 3.643}, {'end': 18058.957, 'text': 'what I can do is I can again do a right click and I can choose basically if you would want to clean up the data or if you would want to convert to lowercase.', 'start': 18048.188, 'duration': 10.769}, {'end': 18061.379, 'text': 'you want to capitalize each word.', 'start': 18058.957, 'duration': 2.422}, {'end': 18062.58, 'text': "so let's choose that.", 'start': 18061.379, 'duration': 1.201}], 'summary': 'Demonstrating data transformation options including uppercase, lowercase, and capitalize.', 'duration': 25.971, 'max_score': 18036.609, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ18036609.jpg'}, {'end': 18191.548, 'src': 'embed', 'start': 18144.884, 'weight': 0, 'content': [{'end': 18145.385, 'text': 'We can.', 'start': 18144.884, 'duration': 0.501}, {'end': 18149.489, 'text': "basically, if you're doing some kind of change, you want to change the format here.", 'start': 18145.385, 'duration': 4.104}, {'end': 18150.17, 'text': 'You can do that.', 'start': 18149.509, 'duration': 0.661}, {'end': 18154.715, 'text': 'You can use for other things like filling up and all that.', 'start': 18150.671, 'duration': 4.044}, {'end': 18162.784, 'text': "Now I can just call it rename and let's say alias, scientist, name right?", 'start': 18155.095, 'duration': 7.689}, {'end': 18165.543, 'text': 'and i can continue adding columns.', 'start': 18163.383, 'duration': 2.16}, {'end': 18167.204, 'text': 'or i can do some transformations.', 'start': 18165.543, 'duration': 1.661}, {'end': 18172.725, 'text': 'and once you have done with these transactions now this one, if you see it, shows as integer.', 'start': 18167.204, 'duration': 5.521}, {'end': 18173.885, 'text': 'but is it an integer?', 'start': 18172.725, 'duration': 1.16}, {'end': 18176.345, 'text': 'no, this is an date format.', 'start': 18173.885, 'duration': 2.46}, {'end': 18181.006, 'text': 'so i can go for modeling and change the formats.', 'start': 18176.345, 'duration': 4.661}, {'end': 18190.488, 'text': "what i can also do is i can select this and it says it's not a decimal, it's not a fixed decimal, it is date time, it is date, it is date,", 'start': 18181.006, 'duration': 9.482}, {'end': 18191.548, 'text': 'time and time zone.', 'start': 18190.488, 'duration': 1.06}], 'summary': 'The transcript discusses data format changes and transformations, including identifying and modifying data types and formats.', 'duration': 46.664, 'max_score': 18144.884, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ18144884.jpg'}, {'end': 18381.278, 'src': 'embed', 'start': 18346.801, 'weight': 1, 'content': [{'end': 18350.845, 'text': 'so this looks good and we have it here now.', 'start': 18346.801, 'duration': 4.044}, {'end': 18357.073, 'text': 'obviously, we have not created any visualization based on this, which we can, and we can continue working on it.', 'start': 18350.845, 'duration': 6.228}, {'end': 18366.103, 'text': 'so here this is my data set, which is a small table where we have created some data and we can use it anytime now.', 'start': 18357.073, 'duration': 9.03}, {'end': 18372.75, 'text': "let's work on a bigger data set and see what kind of transformations we can do.", 'start': 18366.624, 'duration': 6.126}, {'end': 18381.278, 'text': 'we can then also see on modeling or basically using some smarter ways of working with the data.', 'start': 18372.75, 'duration': 8.528}], 'summary': 'Data set ready for visualization, aiming for bigger set with advanced transformations.', 'duration': 34.477, 'max_score': 18346.801, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ18346801.jpg'}, {'end': 18505.512, 'src': 'embed', 'start': 18474.89, 'weight': 6, 'content': [{'end': 18477.431, 'text': 'and we have some order ids.', 'start': 18474.89, 'duration': 2.541}, {'end': 18482.687, 'text': 'we have the returned if the product was returned.', 'start': 18477.431, 'duration': 5.256}, {'end': 18484.649, 'text': "so let's look at the filter here.", 'start': 18482.687, 'duration': 1.962}, {'end': 18489.694, 'text': 'so it just has yes values which we are looking at.', 'start': 18484.649, 'duration': 5.045}, {'end': 18493.278, 'text': 'so it says list may be incomplete.', 'start': 18489.694, 'duration': 3.584}, {'end': 18498.09, 'text': "let's say load more and let's see what are the filters here.", 'start': 18493.278, 'duration': 4.812}, {'end': 18503.131, 'text': 'so either there might be a product which is returned or it might be blank field.', 'start': 18498.09, 'duration': 5.041}, {'end': 18504.351, 'text': 'so that is chosen.', 'start': 18503.131, 'duration': 1.22}, {'end': 18505.512, 'text': "so that's fine.", 'start': 18504.351, 'duration': 1.161}], 'summary': 'Analyzing order data with return status filters for completeness.', 'duration': 30.622, 'max_score': 18474.89, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ18474890.jpg'}], 'start': 17697.737, 'title': 'Power bi data transformation', 'summary': "Covers power bi data loading, transformation, and data entry, with an emphasis on 'enter data' option, creating and editing columns, data type transformation, and filtering and analyzing data by country, region, and product category.", 'chapters': [{'end': 17753.419, 'start': 17697.737, 'title': 'Power bi data loading and transformation', 'summary': "Explains how to load data, perform transformations, and create multiple results in power bi, with an emphasis on the 'enter data' option for creating new data.", 'duration': 55.682, 'highlights': ['Power BI offers various options for loading and transforming data, providing flexibility in creating multiple results or data sets.', "The 'enter data' option in Power BI is suitable for scenarios with relatively fewer fields, allowing users to easily add more columns and values.", "The chapter emphasizes the process of loading data, performing transformations, and creating new data in Power BI, highlighting the 'enter data' option for efficient management of relatively less number of fields."]}, {'end': 18087.298, 'start': 17753.419, 'title': 'Data entry and transformation in power bi', 'summary': 'Discusses creating and editing columns, data entry, data type transformation, and column name formatting in power bi, showcasing examples and procedures.', 'duration': 333.879, 'highlights': ['Creating and editing columns The speaker explains the process of creating and editing columns in Power BI, allowing the addition and deletion of columns with specific names and values.', 'Data entry process The transcript demonstrates the process of entering data into the columns, providing examples such as assigning scientist IDs, names, domains, years of joining, and countries.', 'Data type transformation The speaker illustrates the transformation of data types in Power BI, showcasing the conversion of the scientist ID from integer to string and the option to modify column names.']}, {'end': 18474.89, 'start': 18087.298, 'title': 'Data transformation in power bi', 'summary': 'Discusses the process of data transformation in power bi, including changing data types, adding, duplicating, and renaming columns, formatting date and time values, and performing basic transformations before loading larger data sets.', 'duration': 387.592, 'highlights': ['Power BI allows for various data transformations, including changing data types, adding, duplicating, and renaming columns, and formatting date and time values. The transcript highlights the various data transformation capabilities in Power BI, such as changing data types, adding, duplicating, and renaming columns, and formatting date and time values.', 'The process of basic transformations before loading larger data sets is emphasized to avoid unnecessary data loading and processing. The importance of performing basic transformations before loading larger data sets is stressed to avoid unnecessary data loading and processing.', 'The option to use first row as header and the ability to preview and refresh data are mentioned as part of the data transformation process in Power BI. The transcript mentions the option to use the first row as a header and the ability to preview and refresh data as part of the data transformation process in Power BI.']}, {'end': 19032.114, 'start': 18474.89, 'title': 'Data filtering and analysis', 'summary': 'Covers the process of filtering and analyzing data, including transforming data types, filtering by country, region, and product category, and selecting specific fields for analysis.', 'duration': 557.224, 'highlights': ['The chapter covers the process of filtering and analyzing data, including transforming data types, filtering by country, region, and product category, and selecting specific fields for analysis. The chapter provides insights into the process of filtering and analyzing data, such as transforming data types, filtering by country and region, selecting specific fields for analysis, and applying advanced filtering techniques.', 'The data is filtered based on country and region, with a focus on United States and United Kingdom data. The data is filtered based on country and region, with a focus on United States and United Kingdom data, indicating a specific focus on these regions for analysis.', 'The process involves transforming data types, such as changing integers to strings for specific fields like row ID and postal code. The process involves transforming data types, such as changing integers to strings for specific fields like row ID and postal code, demonstrating the manipulation of data for analysis purposes.', 'Filtering is applied to select specific product categories, with a focus on technology-related products. Filtering is applied to select specific product categories, with a focus on technology-related products, showcasing the targeted analysis of particular product categories within the dataset.']}], 'duration': 1334.377, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ17697737.jpg', 'highlights': ['Power BI offers various options for loading and transforming data, providing flexibility in creating multiple results or data sets.', "The 'enter data' option in Power BI is suitable for scenarios with relatively fewer fields, allowing users to easily add more columns and values.", "The chapter emphasizes the process of loading data, performing transformations, and creating new data in Power BI, highlighting the 'enter data' option for efficient management of relatively less number of fields.", 'Creating and editing columns in Power BI allows the addition and deletion of columns with specific names and values.', 'The process of entering data into the columns is demonstrated, providing examples such as assigning scientist IDs, names, domains, years of joining, and countries.', 'Power BI allows for various data transformations, including changing data types, adding, duplicating, and renaming columns, and formatting date and time values.', 'The importance of performing basic transformations before loading larger data sets is stressed to avoid unnecessary data loading and processing.', 'The option to use the first row as a header and the ability to preview and refresh data are mentioned as part of the data transformation process in Power BI.', 'The chapter covers the process of filtering and analyzing data, including transforming data types, filtering by country, region, and product category, and selecting specific fields for analysis.', 'The data is filtered based on country and region, with a focus on United States and United Kingdom data, indicating a specific focus on these regions for analysis.', 'The process involves transforming data types, such as changing integers to strings for specific fields like row ID and postal code, demonstrating the manipulation of data for analysis purposes.', 'Filtering is applied to select specific product categories, with a focus on technology-related products, showcasing the targeted analysis of particular product categories within the dataset.']}, {'end': 20949.226, 'segs': [{'end': 19371.583, 'src': 'embed', 'start': 19342.177, 'weight': 1, 'content': [{'end': 19344.299, 'text': 'so you can apply any number of filters.', 'start': 19342.177, 'duration': 2.122}, {'end': 19352.807, 'text': 'now you have the filtering here, you can always click on the filter and if you want, you can just do a clear filter and the filtering will be gone.', 'start': 19344.299, 'duration': 8.508}, {'end': 19360.294, 'text': 'so you have all the data right and this is the particular data we have.', 'start': 19352.807, 'duration': 7.487}, {'end': 19365.119, 'text': 'and here i have say, for example, product name.', 'start': 19360.294, 'duration': 4.825}, {'end': 19371.583, 'text': "now i can keep the filter because i'm interested only in these values or i can filter out.", 'start': 19365.119, 'duration': 6.464}], 'summary': 'The system allows applying multiple filters and clearing them, providing flexibility in data analysis.', 'duration': 29.406, 'max_score': 19342.177, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ19342177.jpg'}, {'end': 20339.861, 'src': 'embed', 'start': 20258.792, 'weight': 0, 'content': [{'end': 20262.735, 'text': 'so i would want to call it some kind of report.', 'start': 20258.792, 'duration': 3.943}, {'end': 20270.88, 'text': "if you would want to create, okay, so let's call it as.", 'start': 20262.735, 'duration': 8.145}, {'end': 20291.739, 'text': "let's say second report, and here i will say country and technology, specific info.", 'start': 20270.88, 'duration': 20.859}, {'end': 20295.26, 'text': "let's save it.", 'start': 20291.739, 'duration': 3.521}, {'end': 20299.841, 'text': 'and now, basically, I have saved my data.', 'start': 20295.26, 'duration': 4.581}, {'end': 20312.304, 'text': "so what you can do is you can go for creating other report or basically having this information published, if that's what you want to do.", 'start': 20299.841, 'duration': 12.463}, {'end': 20320.21, 'text': 'if you want to go for visualization because right now what we are seeing is we have lot of data here, we have lot of data here.', 'start': 20312.304, 'duration': 7.906}, {'end': 20325.913, 'text': 'it shows me there are these tables or data sets which we have worked on.', 'start': 20320.21, 'duration': 5.703}, {'end': 20331.576, 'text': 'that shows me here in the models, but there is no relationship in them.', 'start': 20325.913, 'duration': 5.663}, {'end': 20339.861, 'text': "if you go into visualization, then you don't have any option or you have not created any visualizations based on this data.", 'start': 20331.576, 'duration': 8.285}], 'summary': 'Creating and saving a country and technology-specific report, with options for further visualization and publishing.', 'duration': 81.069, 'max_score': 20258.792, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ20258792.jpg'}, {'end': 20658.079, 'src': 'embed', 'start': 20629.649, 'weight': 2, 'content': [{'end': 20640.093, 'text': 'so just to add to the group by step, what we did was, if you see here I have removed the group by filter, which we just did couple of minutes back,', 'start': 20629.649, 'duration': 10.444}, {'end': 20649.396, 'text': 'and what I have done is, instead of transforming your complete data set, you can basically create a copy of it.', 'start': 20640.093, 'duration': 9.303}, {'end': 20655.336, 'text': 'so, for example, I can just do a copy and then i can come here and do a paste.', 'start': 20649.396, 'duration': 5.94}, {'end': 20658.079, 'text': "and i have done that and i'm calling it order summarized.", 'start': 20655.336, 'duration': 2.743}], 'summary': 'Demonstrated creating a copy of data set instead of transforming it, called it order summarized.', 'duration': 28.43, 'max_score': 20629.649, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ20629649.jpg'}], 'start': 19032.114, 'title': 'Data transformation and visualization', 'summary': 'Covers data transformation and aggregation, filtering and transformation techniques, transforming data in microsoft excel, and creating and grouping data for visualization, emphasizing successful transformation and analysis, and selective data loading.', 'chapters': [{'end': 19133.379, 'start': 19032.114, 'title': 'Data transformation and aggregation', 'summary': 'Discusses the process of data transformation and aggregation, including selecting, transforming, and loading data, as well as creating aggregated columns and performing calculations.', 'duration': 101.265, 'highlights': ['The process involves selecting data, performing transformations, and breaking a particular column into multiple columns if needed.', 'After applying changes, the selective data gets loaded, and one can start working on the columns and create aggregations.', 'The summation mark indicates aggregated columns that can be used for calculations and can be renamed as needed.']}, {'end': 19568.007, 'start': 19133.379, 'title': 'Data filtering and transformation', 'summary': 'Discusses data filtering and transformation techniques in power query, including text and number filtering, as well as transforming data by splitting columns and creating new measures.', 'duration': 434.628, 'highlights': ['The chapter discusses data filtering and transformation techniques in Power Query. It covers various filtering and transformation methods within Power Query to manipulate and refine data.', "Includes text and number filtering for refining data based on specific conditions. It demonstrates the use of text and number filtering, such as using 'contains' for text filtering and 'greater than' for number filtering, to refine and extract specific data.", 'Demonstrates transforming data by splitting columns and creating new measures. It showcases the process of transforming data by splitting columns, creating new measures, and using the Power Query Editor for data manipulation and refinement.']}, {'end': 20256.484, 'start': 19568.547, 'title': 'Data transformation and analysis', 'summary': 'Covers the process of transforming data in a dataset using microsoft excel, including steps like column duplication, splitting, merging, and renaming, resulting in the creation of new columns and the modification of existing ones, ultimately leading to the successful transformation and analysis of the dataset.', 'duration': 687.937, 'highlights': ['The process of transforming data involves steps like column duplication, splitting, merging, and renaming, leading to the creation of new columns and the modification of existing ones. The speaker discusses various data transformation processes such as column duplication, splitting, merging, and renaming, ultimately creating new columns and modifying existing ones to transform and analyze the dataset.', "The speaker demonstrates the use of Microsoft Excel's features to split the data based on delimiters, resulting in the creation of new columns and the removal of irrelevant data. The speaker showcases the use of Microsoft Excel's features to split the data based on delimiters, creating new columns and removing irrelevant data for effective data analysis.", 'The process also involves merging columns with the option to specify a separator and create a new merged column, demonstrating the flexibility of data manipulation within Microsoft Excel. The process includes merging columns with the option to specify a separator and create a new merged column, highlighting the flexibility of data manipulation within Microsoft Excel.', 'The speaker emphasizes the importance of applying and saving the data transformations to ensure that all changes are successfully implemented and saved in the dataset. The speaker emphasizes the significance of applying and saving the data transformations to ensure successful implementation and preservation of changes in the dataset.']}, {'end': 20578.433, 'start': 20258.792, 'title': 'Creating and grouping data for visualization', 'summary': 'Describes the process of creating a report, saving data, and grouping data based on ship mode and segment to obtain shipment wise sales, with a focus on visualization.', 'duration': 319.641, 'highlights': ['The chapter describes the process of creating a report and saving data, as well as the option to publish information. The process of creating a report and saving data is explained, with the option to publish information.', 'Demonstrates the lack of visualizations based on the available data and the need to transform and group data for visualization. The lack of visualizations based on the available data is highlighted, emphasizing the need to transform and group data for visualization purposes.', 'Details the process of transforming data, choosing fields, and performing grouping based on ship mode and segment to obtain shipment wise sales. The process of transforming data, choosing fields, and performing grouping based on ship mode and segment to obtain shipment wise sales is explained.']}, {'end': 20949.226, 'start': 20578.493, 'title': 'Data transformation and grouping', 'summary': 'Covers data transformation and grouping techniques, including creating copies of datasets, performing group by operations, and applying transformations, all while emphasizing the importance of unique groupings and enabling selective data loading.', 'duration': 370.733, 'highlights': ['Performing group by operations based on multiple fields to ensure uniqueness in grouping is essential for data analysis. The importance of having unique combinations of fields for grouping by is emphasized to ensure accurate data analysis.', 'Creating copies of datasets before applying transformations allows for selective data loading and prevents affecting the original dataset. The process of creating copies of datasets before applying transformations is highlighted as a method to enable selective data loading and prevent affecting the original dataset.', "Enabling selective data loading by unchecking 'enable load' option allows for loading only the changes related to the dataset, while keeping the original data unaffected. The option of unchecking 'enable load' to load only the changes related to the dataset is highlighted as a way to keep the original data unaffected during selective data loading."]}], 'duration': 1917.112, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ19032114.jpg', 'highlights': ['The process involves selecting data, performing transformations, and breaking a particular column into multiple columns if needed.', 'The chapter discusses data filtering and transformation techniques in Power Query, covering various filtering and transformation methods within Power Query to manipulate and refine data.', 'The process of transforming data involves steps like column duplication, splitting, merging, and renaming, leading to the creation of new columns and the modification of existing ones.', 'The chapter describes the process of creating a report and saving data, as well as the option to publish information.', 'Performing group by operations based on multiple fields to ensure uniqueness in grouping is essential for data analysis.']}, {'end': 22121.169, 'segs': [{'end': 20977.036, 'src': 'embed', 'start': 20949.226, 'weight': 3, 'content': [{'end': 20957.746, 'text': 'and this is the data might be we are focusing on right now, for doing some visualization, might be looking at sales,', 'start': 20949.226, 'duration': 8.52}, {'end': 20960.748, 'text': 'might be looking at the product name.', 'start': 20957.746, 'duration': 3.002}, {'end': 20962.469, 'text': 'so you have the product name now.', 'start': 20960.748, 'duration': 1.721}, {'end': 20971.433, 'text': "remember, you don't see any filters here right, because the filters are coming from the resultant set and your transformation.", 'start': 20962.469, 'duration': 8.964}, {'end': 20977.036, 'text': 'so if you have any filters, you would be seeing in the top row.', 'start': 20971.433, 'duration': 5.603}], 'summary': 'Focusing on sales and product visualization, filtering from resultant set.', 'duration': 27.81, 'max_score': 20949.226, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ20949226.jpg'}, {'end': 21847.17, 'src': 'embed', 'start': 21781.953, 'weight': 0, 'content': [{'end': 21788.797, 'text': 'So there are these different subcategories which we can look at such as copiers and machines have noticeably more shipping cost.', 'start': 21781.953, 'duration': 6.844}, {'end': 21790.778, 'text': 'Profit by product name.', 'start': 21789.357, 'duration': 1.421}, {'end': 21795.94, 'text': 'And you can basically look at the row ID and quantity.', 'start': 21791.818, 'duration': 4.122}, {'end': 21798.742, 'text': "So this is where you're looking at a regression analysis.", 'start': 21795.98, 'duration': 2.762}, {'end': 21801.531, 'text': "You're looking at row ID and quantity.", 'start': 21799.329, 'duration': 2.202}, {'end': 21804.373, 'text': 'So there is a correlation between row ID and quantity.', 'start': 21801.731, 'duration': 2.642}, {'end': 21808.837, 'text': 'So these are two different variables or fields which are related.', 'start': 21804.774, 'duration': 4.063}, {'end': 21813.221, 'text': "You're looking row ID by category row ID.", 'start': 21809.618, 'duration': 3.603}, {'end': 21817.965, 'text': 'So it says California has noticeably more row IDs sales.', 'start': 21813.381, 'duration': 4.584}, {'end': 21822.199, 'text': 'your profit, count of region and count of returns.', 'start': 21818.837, 'duration': 3.362}, {'end': 21826.062, 'text': 'So there is a correlation again between two different variables.', 'start': 21822.759, 'duration': 3.303}, {'end': 21828.063, 'text': 'Average of shipping costs.', 'start': 21826.882, 'duration': 1.181}, {'end': 21836.788, 'text': 'Now, we would have taken a lot of time building all these visualizations, but Power BI has already helped you in gathering all these insights.', 'start': 21828.263, 'duration': 8.525}, {'end': 21842.727, 'text': "And then you can basically select which one of these is what you're interested in.", 'start': 21837.409, 'duration': 5.318}, {'end': 21847.17, 'text': 'you can focus and look for more information based on all the fields.', 'start': 21842.727, 'duration': 4.443}], 'summary': 'Analysis reveals correlations between shipping costs, sales, and profits by product and region.', 'duration': 65.217, 'max_score': 21781.953, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ21781953.jpg'}, {'end': 22121.169, 'src': 'embed', 'start': 22088.501, 'weight': 2, 'content': [{'end': 22098.145, 'text': 'you can add maps, you can add filters, you can add quick questions, you can basically just go here and say, for example,', 'start': 22088.501, 'duration': 9.644}, {'end': 22100.906, 'text': 'you would want to ask a different question.', 'start': 22098.145, 'duration': 2.761}, {'end': 22103.567, 'text': 'now we see the fields here.', 'start': 22100.906, 'duration': 2.661}, {'end': 22105.768, 'text': 'how about looking at the shipping cost?', 'start': 22103.567, 'duration': 2.201}, {'end': 22119.027, 'text': 'right? so here i can say um, what is the uh highest shipping cost?', 'start': 22105.768, 'duration': 13.259}, {'end': 22121.169, 'text': 'and that shows me some suggestions.', 'start': 22119.027, 'duration': 2.142}], 'summary': 'The platform allows adding maps, filters, and questions, such as querying the highest shipping cost.', 'duration': 32.668, 'max_score': 22088.501, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ22088501.jpg'}], 'start': 20949.226, 'title': 'Power bi and data visualization', 'summary': 'Covers data visualization, sales analysis, and power bi features, emphasizing the impact of product names, filters, relationships between datasets, report generation, and insights generation.', 'chapters': [{'end': 20997.228, 'start': 20949.226, 'title': 'Data visualization and sales analysis', 'summary': 'Discusses the process of data visualization and sales analysis, emphasizing the importance of product names and the impact of applying filters on the resultant data set.', 'duration': 48.002, 'highlights': ['The importance of focusing on sales and product names for visualization.', 'Emphasizing the impact of filters on the resultant data set.']}, {'end': 21828.063, 'start': 20997.228, 'title': 'Power bi data transformation and visualization', 'summary': 'Demonstrates using power bi to transform data, create relationships between datasets, generate reports with filters and slicers, and publish reports with additional insights and analysis, providing a comprehensive overview of the process and its potential impact.', 'duration': 830.835, 'highlights': ['The chapter demonstrates using Power BI to transform data, create relationships between datasets, generate reports with filters and slicers, and publish reports with additional insights and analysis. The chapter covers the process of transforming and visualizing data using Power BI, including creating relationships between datasets and adding filters and slicers to reports.', 'The report shows noticeable insights, including sales by ship mode, profit by city, average shipping cost by subcategories, and correlations between variables like row ID and quantity. The report provides insights on sales by ship mode, profit by city, average shipping cost by subcategories, and correlations between variables like row ID and quantity, offering valuable analytical information.', 'The process includes steps for publishing reports with additional insights, analyzing the potential impact on existing reports, and saving reports with different filters for further analysis and sharing. The process involves publishing reports with additional insights, analyzing the potential impact on existing reports, and saving reports with different filters for further analysis and sharing, showcasing the comprehensive capabilities of Power BI.']}, {'end': 22121.169, 'start': 21828.263, 'title': 'Exploring power bi features', 'summary': 'Highlights the various features of power bi, such as gathering insights, using focus mode, analyzing subsets of data, interacting with visuals, and asking questions, ultimately enabling users to create smart visuals and generate quick insights.', 'duration': 292.906, 'highlights': ['Power BI enables users to ask questions about their data and quickly add visuals to the report, enhancing data exploration and analysis. Enables asking questions and quickly adding visuals, enhancing data exploration and analysis.', 'The feature allows users to analyze a subset of data and find insights, providing a convenient way to focus on specific information. Enables analysis of a subset of data and finding insights, providing a convenient way to focus on specific information.', 'Power BI offers options for navigating through the dataset, including features like asking questions, adding maps, filters, and creating quick visuals. Offers options for navigating through the dataset, including asking questions, adding maps, filters, and creating quick visuals.']}], 'duration': 1171.943, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ20949226.jpg', 'highlights': ['The process involves publishing reports with additional insights, analyzing the potential impact on existing reports, and saving reports with different filters for further analysis and sharing, showcasing the comprehensive capabilities of Power BI.', 'The report shows noticeable insights, including sales by ship mode, profit by city, average shipping cost by subcategories, and correlations between variables like row ID and quantity, offering valuable analytical information.', 'The importance of focusing on sales and product names for visualization.', 'Emphasizing the impact of filters on the resultant data set.', 'Power BI enables users to ask questions about their data and quickly add visuals to the report, enhancing data exploration and analysis.', 'The feature allows users to analyze a subset of data and find insights, providing a convenient way to focus on specific information.', 'Power BI offers options for navigating through the dataset, including asking questions, adding maps, filters, and creating quick visuals.']}, {'end': 23154.657, 'segs': [{'end': 22229.022, 'src': 'embed', 'start': 22200.77, 'weight': 3, 'content': [{'end': 22204.452, 'text': 'Here we will take a look at an overview of the products offered by Tableau.', 'start': 22200.77, 'duration': 3.682}, {'end': 22208.174, 'text': 'So we have Tableau Desktop, which is where you do all of your development.', 'start': 22204.872, 'duration': 3.302}, {'end': 22212.397, 'text': 'This is where you connect to and build visualizations and dashboards.', 'start': 22208.354, 'duration': 4.043}, {'end': 22220.119, 'text': "Today we'll be using Tableau Public, which is a free version of Tableau Desktop, but with some limitations, such as having no R integration,", 'start': 22212.737, 'duration': 7.382}, {'end': 22222.4, 'text': 'and it can only support up to a million rows of data.', 'start': 22220.119, 'duration': 2.281}, {'end': 22229.022, 'text': "Also, any data published here is made public, so you can't use this for private company information.", 'start': 22222.88, 'duration': 6.142}], 'summary': 'Tableau offers products like tableau desktop for development, and tableau public, a free version with limitations, supporting up to a million rows of data.', 'duration': 28.252, 'max_score': 22200.77, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ22200770.jpg'}, {'end': 22265.956, 'src': 'embed', 'start': 22237.085, 'weight': 6, 'content': [{'end': 22244.848, 'text': "There's also Tableau Online, which is a cloud-hosted version of Tableau Server, a place where you can publish your dashboards,", 'start': 22237.085, 'duration': 7.763}, {'end': 22247.669, 'text': 'and it enables you to share your dashboards in a secure way.', 'start': 22244.848, 'duration': 2.821}, {'end': 22250.71, 'text': 'Tableau Server has an option to be on-premises.', 'start': 22248.189, 'duration': 2.521}, {'end': 22258.133, 'text': "So let's just do a quick comparison between building a visualization in Excel and building one in Tableau.", 'start': 22251.35, 'duration': 6.783}, {'end': 22265.956, 'text': 'Okay, so here we have an Excel file full of data that we will soon connect to and use for some of our demonstration purposes.', 'start': 22258.813, 'duration': 7.143}], 'summary': 'Tableau online and server allow secure dashboard sharing; excel vs. tableau visualization comparison.', 'duration': 28.871, 'max_score': 22237.085, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ22237085.jpg'}, {'end': 22380.061, 'src': 'embed', 'start': 22285.266, 'weight': 0, 'content': [{'end': 22287.828, 'text': 'And here we have the beginnings of a pivot chart.', 'start': 22285.266, 'duration': 2.562}, {'end': 22291.71, 'text': 'And we can grab region and pull it into our columns.', 'start': 22288.548, 'duration': 3.162}, {'end': 22294.552, 'text': "And then we'll grab sales.", 'start': 22292.47, 'duration': 2.082}, {'end': 22297.226, 'text': 'and put it into values.', 'start': 22295.905, 'duration': 1.321}, {'end': 22301.93, 'text': 'And then we also want to look at quantity and put that into values.', 'start': 22298.547, 'duration': 3.383}, {'end': 22308.576, 'text': "And it's automatically summing up sales and quantity but you can choose if you want it to be sum or not.", 'start': 22302.331, 'duration': 6.245}, {'end': 22316.003, 'text': "And then we'll take our values and put it on rows so that we can see sales and quantity one on top of the other.", 'start': 22309.017, 'duration': 6.986}, {'end': 22318.625, 'text': "And that's the basics of a pivot chart.", 'start': 22316.023, 'duration': 2.602}, {'end': 22321.048, 'text': "Now let's do a similar thing in Tableau.", 'start': 22318.686, 'duration': 2.362}, {'end': 22329.221, 'text': 'Okay, so we have our connection to the data, and Tableau automatically splits out the dimensions from the measures.', 'start': 22322.315, 'duration': 6.906}, {'end': 22331.183, 'text': "We'll go into more depth on that later.", 'start': 22329.341, 'duration': 1.842}, {'end': 22338.709, 'text': 'But we can come and grab region and put it onto columns, and we get a similar thing, maybe a little nicer formatted.', 'start': 22331.763, 'duration': 6.946}, {'end': 22342.532, 'text': 'And then we can come and put quantity there.', 'start': 22339.129, 'duration': 3.403}, {'end': 22349.594, 'text': "If we want to add sales to it, we can double click on sales and we'll have quantity and sales one on top of the other.", 'start': 22343.829, 'duration': 5.765}, {'end': 22354.358, 'text': 'We can put sales on top by dragging quantity down in that box.', 'start': 22350.134, 'duration': 4.224}, {'end': 22357.28, 'text': 'We also have this show me dialog box,', 'start': 22354.838, 'duration': 2.442}, {'end': 22365.707, 'text': "which allows you to see what visualizations you could build using what's already on the screen or the things that you have selected.", 'start': 22357.28, 'duration': 8.427}, {'end': 22372.393, 'text': 'So right now we could quickly switch it to bar charts and now we can see quantity and sales across our region.', 'start': 22366.228, 'duration': 6.165}, {'end': 22380.061, 'text': 'with bar charts or we could switch it to stacked bars and we can see our quantity across the regions.', 'start': 22372.893, 'duration': 7.168}], 'summary': 'The transcript explains how to create pivot charts in excel and tableau, and how to visualize sales and quantity data in different formats.', 'duration': 94.795, 'max_score': 22285.266, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ22285266.jpg'}, {'end': 22920.932, 'src': 'embed', 'start': 22890.815, 'weight': 4, 'content': [{'end': 22892.996, 'text': "So it's from one to 15.", 'start': 22890.815, 'duration': 2.181}, {'end': 22898.898, 'text': 'Now, if we change it from continuous to discrete, you can see that one is a label,', 'start': 22892.996, 'duration': 5.902}, {'end': 22905.361, 'text': "two is a label and it's not an axis ranging from one to it doesn't even have 15, because there are no values under 15..", 'start': 22898.898, 'duration': 6.463}, {'end': 22907.201, 'text': 'These are just individual labels.', 'start': 22905.361, 'duration': 1.84}, {'end': 22911.123, 'text': "So we go back, it's green again, and you can see that it's an axis.", 'start': 22907.521, 'duration': 3.602}, {'end': 22914.166, 'text': 'So we have two greens on here so we have two axes.', 'start': 22911.243, 'duration': 2.923}, {'end': 22916.187, 'text': 'And change it back to discrete.', 'start': 22914.666, 'duration': 1.521}, {'end': 22920.932, 'text': 'And now we have one axis and one set of individual labels.', 'start': 22916.468, 'duration': 4.464}], 'summary': 'Changing from continuous to discrete results in 1 axis and 15 individual labels.', 'duration': 30.117, 'max_score': 22890.815, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ22890815.jpg'}], 'start': 22121.169, 'title': 'Tableau benefits and visualization basics', 'summary': "Covers tableau's ability to connect to 40 data sources, build interactive dashboards, and its leadership in gartner magic quadrant. it also provides an overview of tableau's visualization basics, dimensions, measures, and different types of visualizations available.", 'chapters': [{'end': 22580.633, 'start': 22121.169, 'title': 'Tableau overview and benefits', 'summary': 'Discusses the benefits of using tableau as a business intelligence tool, including its ability to connect to 40 data sources, build interactive dashboards with simple analytics, and its leadership in the gartner magic quadrant for the last six years.', 'duration': 459.464, 'highlights': ["Tableau can be connected to 40 different data sources. Tableau's capability to connect to 40 different data sources enhances direct access to data.", 'It can build interactive dashboards with simple analytics such as trends and forecasting. Tableau allows the creation of interactive dashboards with simple analytics, providing deeper insights into data.', "Tableau has been a leader in the Gartner Magic Quadrant for the last six years. Tableau's consistent leadership in the Gartner Magic Quadrant for six years showcases its industry recognition and reliability."]}, {'end': 22821.817, 'start': 22581.093, 'title': 'Tableau visualization basics', 'summary': "Provides an overview of tableau's visualization basics, including the identification and utilization of dimensions and measures, along with a demonstration of the show me feature and the different types of visualizations available in tableau.", 'duration': 240.724, 'highlights': ['Tableau categorizes fields into dimensions and measures, with dimensions containing qualitative details like names and dates, while measures contain quantitative values that can be aggregated, such as summing up quantities and sales. Tableau categorizes fields into dimensions and measures', 'The Show Me feature in Tableau displays various types of visualizations that can be built, providing specific field requirements for each visualization type and allowing for easy visualization creation. The Show Me feature displays various types of visualizations with specific field requirements', 'Understanding the distinction between dimensions and measures is crucial, as dimensions are typically non-numeric and used for revealing qualitative details, while measures are numeric and can be aggregated for quantitative analysis. Understanding the distinction between dimensions and measures']}, {'end': 23154.657, 'start': 22822.037, 'title': 'Understanding dimensions and measures in tableau', 'summary': 'Discusses the distinction between dimensions and measures in tableau, demonstrating how to use them in visualizations and providing insights into sorting and color representation, with a focus on sales data and region, utilizing drag and drop functionality and unlimited undos.', 'duration': 332.62, 'highlights': ['The chapter discusses the distinction between dimensions and measures in Tableau. The distinction between dimensions (qualitative) and measures (quantitative) is explained, with blue representing discrete labels and green indicating continuous labels.', 'Demonstrating how to use them in visualizations and providing insights into sorting and color representation, with a focus on sales data and region. The process of using dimensions and measures in visualizations is demonstrated, with a focus on sales data and region, and insights into sorting and color representation are provided.', "Utilizing drag and drop functionality and unlimited undos. Tableau's drag and drop functionality is highlighted, along with the benefit of unlimited undos, providing flexibility in visualization creation."]}], 'duration': 1033.488, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ22121169.jpg', 'highlights': ['Tableau can be connected to 40 different data sources, enhancing direct access to data.', 'Tableau can build interactive dashboards with simple analytics, providing deeper insights into data.', 'Tableau has been a leader in the Gartner Magic Quadrant for the last six years, showcasing its industry recognition and reliability.', 'Tableau categorizes fields into dimensions and measures, crucial for qualitative and quantitative analysis.', 'The Show Me feature in Tableau displays various types of visualizations with specific field requirements for easy visualization creation.', 'Understanding the distinction between dimensions and measures is crucial for effective data analysis.', 'The chapter discusses the distinction between dimensions and measures in Tableau, emphasizing the use of color representation and sorting for insights.', "Tableau's drag and drop functionality is highlighted, providing flexibility in visualization creation."]}, {'end': 25436.6, 'segs': [{'end': 23532.473, 'src': 'embed', 'start': 23507.668, 'weight': 2, 'content': [{'end': 23515.896, 'text': 'You can see that it sort of has a trend where things with high sales do not have high discounts, which makes sense.', 'start': 23507.668, 'duration': 8.228}, {'end': 23527.006, 'text': 'If we wanted to know what category these products all show up in, we could take category and put it onto shape.', 'start': 23516.516, 'duration': 10.49}, {'end': 23532.473, 'text': 'And now we have three different shapes that tell us the categories.', 'start': 23528.231, 'duration': 4.242}], 'summary': 'High sales correlate with low discounts; products categorized into three shapes.', 'duration': 24.805, 'max_score': 23507.668, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ23507668.jpg'}, {'end': 23920.773, 'src': 'embed', 'start': 23893.815, 'weight': 4, 'content': [{'end': 23902.261, 'text': 'Also, as we are building these visualizations, if you want to have access to this data set so that you can build along with me,', 'start': 23893.815, 'duration': 8.446}, {'end': 23908.025, 'text': 'just make a comment in the comments below, and the Simply Learn team will send you this data set.', 'start': 23902.261, 'duration': 5.764}, {'end': 23911.887, 'text': "Now we're going to take a look at creating a hierarchy in Tableau.", 'start': 23908.405, 'duration': 3.482}, {'end': 23920.773, 'text': "So we'll make a new tab and we're going to make a sheet called Sales by Product.", 'start': 23913.108, 'duration': 7.665}], 'summary': 'Building visualizations in tableau & offering access to dataset upon request', 'duration': 26.958, 'max_score': 23893.815, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ23893815.jpg'}, {'end': 24147.185, 'src': 'embed', 'start': 24118.206, 'weight': 3, 'content': [{'end': 24127.235, 'text': "And when you have big blocks of text like this, it's kind of hard to see which one has the highest because it doesn't quite stand out very quickly.", 'start': 24118.206, 'duration': 9.029}, {'end': 24133.179, 'text': 'So what we can do is take sales and drag it onto color.', 'start': 24127.855, 'duration': 5.324}, {'end': 24139.141, 'text': "Let's change our marks to a square and now it's going to color each of these.", 'start': 24133.759, 'duration': 5.382}, {'end': 24144.804, 'text': 'It colors every one of these cells based on its darkness for sales.', 'start': 24139.742, 'duration': 5.062}, {'end': 24147.185, 'text': 'This is a little bit heavy of a color.', 'start': 24145.164, 'duration': 2.021}], 'summary': 'Sales data is visualized using color coding to distinguish differences in values.', 'duration': 28.979, 'max_score': 24118.206, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ24118206.jpg'}, {'end': 24297.334, 'src': 'embed', 'start': 24271.744, 'weight': 0, 'content': [{'end': 24281.027, 'text': 'And we can see that a drop in technology is a big part of the responsibility for that drop we were seeing in quarter two of 2016.', 'start': 24271.744, 'duration': 9.283}, {'end': 24284.788, 'text': "So let's take that back off and let's take quarter back off.", 'start': 24281.027, 'duration': 3.761}, {'end': 24288.609, 'text': "And let's explore continuous dates.", 'start': 24286.348, 'duration': 2.261}, {'end': 24297.334, 'text': 'So here in dates, we have our top section of dates, and then you see it repeats, and we have the bottom section of dates.', 'start': 24289.19, 'duration': 8.144}], 'summary': 'Technology drop responsible for decrease in quarter two 2016.', 'duration': 25.59, 'max_score': 24271.744, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ24271744.jpg'}, {'end': 24592.135, 'src': 'embed', 'start': 24565.754, 'weight': 1, 'content': [{'end': 24571.376, 'text': "This is a technique that I use when I'm trying to understand how my calculated fields are working.", 'start': 24565.754, 'duration': 5.622}, {'end': 24576.058, 'text': "Try to break it down to the lowest level possible and see if it's doing what I expect.", 'start': 24571.576, 'duration': 4.482}, {'end': 24578.899, 'text': "So we've got profit and we've got sales.", 'start': 24576.879, 'duration': 2.02}, {'end': 24588.884, 'text': "Now both of them are at 0.5 or 50% and that's because profit is 8 and sales is 16 for Adam's Telephone Messaging.", 'start': 24579.26, 'duration': 9.624}, {'end': 24592.135, 'text': "Now let's take off product name.", 'start': 24589.634, 'duration': 2.501}], 'summary': "Technique for analyzing calculated fields; profit at 8, sales at 16 for adam's tele messaging.", 'duration': 26.381, 'max_score': 24565.754, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ24565754.jpg'}], 'start': 23154.677, 'title': 'Tableau visualization techniques', 'summary': 'Covers adjusting visualization size and labels, using filters for specific regions/categories, creating hierarchies for detailed analysis, understanding hierarchies and calculated fields, and building visualizations for sales and profit data in tableau, aiding in informed decision-making.', 'chapters': [{'end': 23315.619, 'start': 23154.677, 'title': 'Adjusting visualization in tableau', 'summary': 'Explains how to manually adjust the size and labels of visualizations in tableau, as well as how to change to different measures like average, with an example showing the highest average sales for a region.', 'duration': 160.942, 'highlights': ['Changing visualization size based on measure Dragging sales or profit onto size to visualize the impact on size based on different measures, demonstrating the correlation between size and sales/profit.', 'Label customization and tooltip usage Customizing labels to display specific information such as sales numbers for each region and utilizing tooltips to preview information when hovering over data points.', 'Switching from sum to average Demonstrating the process of changing the visualization from representing the sum of sales to the average of sales, resulting in a different visualization and highlighting the region with the highest average sales.', 'Customizing label format and display Exploring options to format labels, such as changing color, and selecting which values to display, such as minimum and maximum, to enhance visualization clarity and focus on specific data points.']}, {'end': 23630.801, 'start': 23316.96, 'title': 'Tableau filters and visualizations', 'summary': 'Discusses using filters to show specific regions and categories in tableau, changing the type of mark manually, creating scatter plots to analyze sales and discounts, and utilizing the highlight feature to visualize patterns in different product categories.', 'duration': 313.841, 'highlights': ["By using filters in Tableau, users can show specific regions and categories, enabling focused analysis (e.g., removing 'central' to view specific regions).", 'Changing the type of mark manually in Tableau allows for flexibility in visualizations, such as switching from a bar chart to a line chart and observing the color changes based on the selected region.', 'Creating scatter plots in Tableau enables the analysis of sales and discounts, allowing users to identify trends and outliers in the data, as well as visualize product categories using different shapes.', 'The highlight feature in Tableau facilitates visualizing patterns in different product categories, allowing users to observe the clustering and patterns of items, as well as identifying high discounted and high sales products.']}, {'end': 24168.535, 'start': 23633.34, 'title': 'Tableau visualization and hierarchy', 'summary': 'Demonstrates creating visualizations in tableau to analyze profit by subcategory and creating hierarchies to understand sales performance by category, subcategory, and product name, facilitating quick and detailed analysis of the data.', 'duration': 535.195, 'highlights': ['The chapter demonstrates creating visualizations in Tableau to analyze profit by subcategory and creating hierarchies to understand sales performance by category, subcategory, and product name. The transcript provides insights into creating visualizations in Tableau for analyzing profit by subcategory and hierarchies for understanding sales performance by category, subcategory, and product name.', 'The visualization in Tableau allows quick identification of profitable and unprofitable subcategories. The visualization in Tableau enables quick identification of profitable and unprofitable subcategories, aiding in decision-making for improving profitability.', 'Demonstrates sorting subcategories descending by profit to identify the highest draining subcategory on profit. The chapter illustrates sorting subcategories in descending order by profit to identify the subcategory causing the highest drain on profit, facilitating targeted strategies for improving profitability.', 'Provides insights into formatting visualizations in Tableau for improved clarity and presentation. Insights are provided into formatting visualizations in Tableau to enhance clarity and presentation, including tips for label rotation, title naming, currency formatting, and field label hiding.', 'The hierarchy feature in Tableau allows detailed exploration of sales data by category, subcategory, and product name, facilitating quick and detailed analysis. The hierarchy feature in Tableau enables detailed exploration of sales data by category, subcategory, and product name, supporting quick and detailed analysis for informed decision-making.']}, {'end': 24711.365, 'start': 24168.535, 'title': 'Understanding tableau hierarchies and calculated fields', 'summary': 'Delves into understanding hierarchies in tableau, particularly with dates, allowing for complex visualizations, as well as the differences between aggregated and unaggregated calculated fields, with practical examples and explanations for better comprehension.', 'duration': 542.83, 'highlights': ['Understanding Tableau hierarchies with dates The chapter provides an in-depth explanation of how Tableau hierarchies with dates work, allowing for complex visualizations and comparisons, such as quarterly analysis across different years.', 'Exploring the differences between profit ratio aggregated and unaggregated The transcript explains the difference between profit ratio aggregated and unaggregated, emphasizing the importance of understanding how data aggregation impacts calculated fields, with practical examples for clarity.', 'Practical demonstration of aggregated and unaggregated calculated fields The transcript provides a practical demonstration of the differences between aggregated and unaggregated calculated fields using a single order and product names, clarifying the impact of aggregation on calculated field results.']}, {'end': 25048.945, 'start': 24711.665, 'title': 'Building visualizations and calculated fields', 'summary': 'Outlines the process of building visualizations in tableau, including creating calculated fields for analyzing sales data by profit ratio, sales per customer, and geographical analysis using various visualizations.', 'duration': 337.28, 'highlights': ['Creating calculated fields for analyzing sales data by profit ratio and sales per customer. The chapter demonstrates the creation of calculated fields to analyze sales data by calculating profit ratio and sales per customer, providing insights into the highest number of customers and sales per customer ratio.', 'Building visualizations using Show Me feature and applying different tactics for analyzing sales by region. It explains the process of building visualizations using the Show Me feature and applying different tactics to analyze sales by region, including using tree map and adjusting color schemes to represent profitable and non-profitable data.', 'Utilizing geographical fields for analyzing sales by state and visualizing the data using maps. The chapter illustrates the use of geographical fields for analyzing sales by state, visualizing the data using maps, and adjusting the size and color of the visualizations to represent sales and profitability.']}, {'end': 25436.6, 'start': 25050.282, 'title': 'Visualizing sales and profit data', 'summary': 'Demonstrates creating bar charts and a dashboard in tableau to visualize sales and profit data by category and region, allowing for interactive filtering and analysis of specific states and products, ultimately leading to informed decision-making.', 'duration': 386.318, 'highlights': ['Creating bar charts for visualizing sales and profit data by category and region The chapter discusses the process of creating bar charts for visualizing sales and profit data by category and region, providing a visual representation of the data for informed decision-making.', 'Utilizing Tableau dashboard to analyze sales and profit data interactively The demonstration showcases the use of Tableau dashboard to interactively analyze sales and profit data, allowing for filtering by region and category, leading to a deeper understanding of the data for decision-making.', 'Interactive filtering and analysis of specific states and products The chapter illustrates the use of interactive filtering and analysis to focus on specific states and products, enabling users to identify areas of concern and make informed decisions based on the data.']}], 'duration': 2281.923, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ23154677.jpg', 'highlights': ['Creating hierarchies for detailed analysis and understanding sales performance by category, subcategory, and product name.', 'Utilizing Tableau dashboard to analyze sales and profit data interactively.', 'Creating calculated fields for analyzing sales data by profit ratio and sales per customer.', 'Understanding Tableau hierarchies with dates for complex visualizations and comparisons.', 'Using filters in Tableau to show specific regions and categories for focused analysis.', 'Building visualizations using Show Me feature and applying different tactics for analyzing sales by region.', 'Demonstrating the process of changing the visualization from representing the sum of sales to the average of sales.', 'Customizing labels to display specific information such as sales numbers for each region and utilizing tooltips to preview information when hovering over data points.', 'The hierarchy feature in Tableau enables detailed exploration of sales data by category, subcategory, and product name, supporting quick and detailed analysis for informed decision-making.']}, {'end': 26385.804, 'segs': [{'end': 25582.486, 'src': 'embed', 'start': 25555.947, 'weight': 7, 'content': [{'end': 25561.952, 'text': 'A set is a custom field that defines a subset of data based on some conditions.', 'start': 25555.947, 'duration': 6.005}, {'end': 25566.655, 'text': "So the set we're going to build is going to be based on customer name.", 'start': 25562.352, 'duration': 4.303}, {'end': 25573.42, 'text': 'So when you right click on customer name, you can come down and click create, hover on create and create a set.', 'start': 25566.915, 'duration': 6.505}, {'end': 25576.982, 'text': 'with so far, when we created a parameter and a calculated field,', 'start': 25573.42, 'duration': 3.562}, {'end': 25582.486, 'text': 'you clicked here with this down arrow and you saw create calculated field and create parameter.', 'start': 25576.982, 'duration': 5.504}], 'summary': 'Creating a set based on customer name to define subset of data.', 'duration': 26.539, 'max_score': 25555.947, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ25555947.jpg'}, {'end': 25627.912, 'src': 'embed', 'start': 25601.237, 'weight': 5, 'content': [{'end': 25607.903, 'text': "So we're going to allow them to select the top end customers and have that select our top customers by sales.", 'start': 25601.237, 'duration': 6.666}, {'end': 25616.692, 'text': 'So we want this set to include anything that is in the top however many they define by the parameter by sales.', 'start': 25608.444, 'duration': 8.248}, {'end': 25621.229, 'text': 'So you can come over here to top and change it to by field.', 'start': 25617.053, 'duration': 4.176}, {'end': 25624.75, 'text': 'We want it to be top, but not just top static 10.', 'start': 25621.669, 'duration': 3.081}, {'end': 25627.912, 'text': "We're going to click here and our parameter shows up.", 'start': 25624.75, 'duration': 3.162}], 'summary': 'Allow selection of top end customers based on sales parameter.', 'duration': 26.675, 'max_score': 25601.237, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ25601237.jpg'}, {'end': 25852.818, 'src': 'embed', 'start': 25825.322, 'weight': 2, 'content': [{'end': 25831.465, 'text': 'And we can do that by doing those steps again by dragging number of records up here and changing it to minimum again.', 'start': 25825.322, 'duration': 6.143}, {'end': 25839.37, 'text': 'Or a quick trick that I can show you is if you want to duplicate anything you have on the chart here,', 'start': 25832.186, 'duration': 7.184}, {'end': 25843.892, 'text': 'you can just hit control and then click and drag it and it will duplicate it.', 'start': 25839.37, 'duration': 4.522}, {'end': 25852.818, 'text': 'So if you wanted your number of records to also be down here onto your details or on your labels, you can control click it and then leave it there.', 'start': 25844.253, 'duration': 8.565}], 'summary': 'Demonstrates duplicating chart items and adjusting record numbers.', 'duration': 27.496, 'max_score': 25825.322, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ25825322.jpg'}, {'end': 25901.478, 'src': 'embed', 'start': 25870.828, 'weight': 1, 'content': [{'end': 25873.249, 'text': 'And this bottom one affects these.', 'start': 25870.828, 'duration': 2.421}, {'end': 25876.131, 'text': "And we'll do that by changing it to circle.", 'start': 25873.269, 'duration': 2.862}, {'end': 25878.213, 'text': 'So now each of these are a circle.', 'start': 25876.692, 'duration': 1.521}, {'end': 25880.515, 'text': "Let's take category off of color.", 'start': 25878.653, 'duration': 1.862}, {'end': 25883.317, 'text': 'And we can take sum of sales off of detail.', 'start': 25880.815, 'duration': 2.502}, {'end': 25885.498, 'text': "And let's change the color to white.", 'start': 25883.337, 'duration': 2.161}, {'end': 25893.043, 'text': "And now we're going to put this white circle on top of our pie chart by clicking here on our second measure and clicking dual axis.", 'start': 25886.239, 'duration': 6.804}, {'end': 25895.986, 'text': "And now it's got them lined up one on top of the other.", 'start': 25893.664, 'duration': 2.322}, {'end': 25897.487, 'text': 'And we have our donut chart.', 'start': 25896.286, 'duration': 1.201}, {'end': 25901.478, 'text': 'So if we want our donut slices to be a little thinner.', 'start': 25897.747, 'duration': 3.731}], 'summary': 'Transformed chart to donut with dual axis for visual clarity.', 'duration': 30.65, 'max_score': 25870.828, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ25870828.jpg'}, {'end': 26061.436, 'src': 'embed', 'start': 26032.256, 'weight': 0, 'content': [{'end': 26036.44, 'text': "Those look very similar to what we have already, so I'm going to pick a different one.", 'start': 26032.256, 'duration': 4.184}, {'end': 26040.104, 'text': 'And click Assign Palette, click Apply.', 'start': 26037.982, 'duration': 2.122}, {'end': 26048.63, 'text': 'And this allows you to make some color changes to fit your business a little bit more specifically.', 'start': 26042.247, 'duration': 6.383}, {'end': 26053.552, 'text': "Perfect Let's say we make our pies bigger.", 'start': 26049.19, 'duration': 4.362}, {'end': 26057.214, 'text': 'Increase that size.', 'start': 26053.572, 'duration': 3.642}, {'end': 26060.476, 'text': "And we'll also increase the center size.", 'start': 26057.954, 'duration': 2.522}, {'end': 26061.436, 'text': 'Oh, not that much.', 'start': 26060.576, 'duration': 0.86}], 'summary': 'Customizing color palette and adjusting pie sizes for business needs.', 'duration': 29.18, 'max_score': 26032.256, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ26032256.jpg'}], 'start': 25437.065, 'title': 'Tableau visualization techniques', 'summary': "Covers creating parameters for user interaction, sets for defining subsets of data, dual axis donut charts, and two-dimensional pie and donut charts in tableau, enabling visualization of sales data in a visually appealing manner and creating complex visualizations not available in tableau's basic options.", 'chapters': [{'end': 25783.126, 'start': 25437.065, 'title': 'Tableau dashboard parameters and sets', 'summary': 'Explains how to create parameters for user interaction, allowing them to choose the number of top customers to visualize, and how to create sets to define subsets of data based on conditions, using tableau visualization tools.', 'duration': 346.061, 'highlights': ["Parameters allow users to choose the number of top customers to visualize, with a range from 5 to 20 and a step size of 5 The parameter 'top end customers' is created, allowing users to select the number of customers they want to see within a range of 5 to 20, with a step size of 5.", 'Creating a set based on customer name to define a subset of data for top customers by sales A set is created based on customer name to define a subset of data for top customers by sales, allowing users to select top customers based on their defined parameter.', 'Demonstration of creating a pie chart in Tableau for visualization based on category and sales The process of creating a pie chart in Tableau for each category by sales is demonstrated, allowing for visualization of sales distribution across different categories and regions.']}, {'end': 26137.185, 'start': 25783.126, 'title': 'Creating dual axis donut charts', 'summary': 'Demonstrates the process of creating dual axis donut charts in tableau, utilizing techniques such as adjusting size, color, label formatting, and utilizing dual axes to visualize sales data in a visually appealing manner, ultimately creating a two-dimensional pie chart.', 'duration': 354.059, 'highlights': ['The process of creating dual axis donut charts involves adjusting the size, color, and labels of the visualizations, enabling the clear display of sales data for each segment and the donut as a whole. Sales data is visualized using dual axis donut charts.', 'Utilizing dual axes and label formatting, the chapter demonstrates the creation of a two-dimensional pie chart, allowing the display of two pie charts simultaneously or a pie chart segmented by different categories. Creation of a two-dimensional pie chart using dual axes.', 'A quick trick is shown to duplicate elements on the chart by using the control-click and drag method, providing an efficient technique for chart manipulation and duplication of visual elements. Efficient technique for duplicating chart elements is demonstrated.']}, {'end': 26385.804, 'start': 26137.765, 'title': 'Creating two-dimensional pie and donut charts in tableau', 'summary': "Discusses creating two-dimensional pie and donut charts in tableau, demonstrating the process of modifying the size, color, and labels of the charts to achieve the desired visualizations, emphasizing the ability to create complex visualizations not available in tableau's basic options.", 'duration': 248.039, 'highlights': ["The chapter demonstrates the process of modifying the size, color, and labels of the charts to achieve the desired visualizations, emphasizing the ability to create complex visualizations not available in Tableau's basic options.", 'The presenter explains the steps to replace the color by dragging the region onto the color, and also dragging region onto the thing being replaced, showcasing the flexibility of modifying chart attributes in Tableau.', 'The tutorial highlights the importance of following along with the dataset to understand the process of creating more complex visualizations, encouraging the audience to request access to the dataset and ask questions for better comprehension.']}], 'duration': 948.739, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ25437065.jpg', 'highlights': ['Parameters allow users to choose the number of top customers to visualize, with a range from 5 to 20 and a step size of 5', 'Creating a set based on customer name to define a subset of data for top customers by sales', 'Demonstration of creating a pie chart in Tableau for visualization based on category and sales', 'The process of creating dual axis donut charts involves adjusting the size, color, and labels of the visualizations', 'Utilizing dual axes and label formatting, the chapter demonstrates the creation of a two-dimensional pie chart', 'A quick trick is shown to duplicate elements on the chart by using the control-click and drag method', 'The chapter demonstrates the process of modifying the size, color, and labels of the charts to achieve the desired visualizations', 'The presenter explains the steps to replace the color by dragging the region onto the color', 'The tutorial highlights the importance of following along with the dataset to understand the process of creating more complex visualizations']}, {'end': 28003.965, 'segs': [{'end': 27598.67, 'src': 'embed', 'start': 27571.348, 'weight': 2, 'content': [{'end': 27574.129, 'text': 'There is already an indicator of who has the most sales.', 'start': 27571.348, 'duration': 2.781}, {'end': 27576.35, 'text': "And that's based on the bar height.", 'start': 27574.329, 'duration': 2.021}, {'end': 27581.152, 'text': 'So if we wanted to color it by subcategory, then each one of them gets their own color.', 'start': 27576.65, 'duration': 4.502}, {'end': 27587.455, 'text': 'We could color it by category to add to the distinction between the different categories.', 'start': 27581.212, 'duration': 6.243}, {'end': 27590.376, 'text': "So that's very clear where they start and stop.", 'start': 27587.755, 'duration': 2.621}, {'end': 27591.337, 'text': "Let's do..", 'start': 27590.857, 'duration': 0.48}, {'end': 27593.686, 'text': 'by subcategory.', 'start': 27592.645, 'duration': 1.041}, {'end': 27598.67, 'text': 'Excellent So now we have three different dashboards.', 'start': 27594.086, 'duration': 4.584}], 'summary': 'The sales data is visualized with distinct colors for subcategories, resulting in three different dashboards.', 'duration': 27.322, 'max_score': 27571.348, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ27571348.jpg'}, {'end': 27677.653, 'src': 'embed', 'start': 27653.911, 'weight': 4, 'content': [{'end': 27660.539, 'text': "If you have any questions about different sizes, what's available here, be sure to ask that in the comments below.", 'start': 27653.911, 'duration': 6.628}, {'end': 27664.684, 'text': "And let's start with pulling on our sales by region.", 'start': 27661.2, 'duration': 3.484}, {'end': 27669.049, 'text': 'So last time we pulled on a chart, we saw that it added the legend for us.', 'start': 27664.864, 'duration': 4.185}, {'end': 27674.332, 'text': 'But this time you can see it added both the legend and the filter.', 'start': 27669.83, 'duration': 4.502}, {'end': 27677.653, 'text': 'So last time we created the filters after we built the dashboard.', 'start': 27674.612, 'duration': 3.041}], 'summary': 'Sales pulled by region, added legend and filter to chart.', 'duration': 23.742, 'max_score': 27653.911, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ27653911.jpg'}, {'end': 27740.781, 'src': 'embed', 'start': 27716.052, 'weight': 0, 'content': [{'end': 27724.415, 'text': "So you can see in Tableau there's a lot of dragging, there's a lot of dropping, and a lot of resizing to get things the way you want them to be.", 'start': 27716.052, 'duration': 8.363}, {'end': 27726.256, 'text': 'Give our map more room.', 'start': 27724.675, 'duration': 1.581}, {'end': 27734.419, 'text': 'And we have a mixture over here of legends and filters.', 'start': 27727.896, 'duration': 6.523}, {'end': 27737.14, 'text': "Let's move our legends out of there.", 'start': 27734.859, 'duration': 2.281}, {'end': 27740.781, 'text': 'So we can grab this legend and come and put it on this side.', 'start': 27737.56, 'duration': 3.221}], 'summary': 'Using tableau involves dragging, dropping, and resizing elements to customize visualizations.', 'duration': 24.729, 'max_score': 27716.052, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ27716052.jpg'}, {'end': 27921.762, 'src': 'embed', 'start': 27887.367, 'weight': 1, 'content': [{'end': 27890.489, 'text': 'You saw that this did not change all the visualizations.', 'start': 27887.367, 'duration': 3.122}, {'end': 27894.252, 'text': 'We have yet to apply these filters to all the worksheets.', 'start': 27890.57, 'duration': 3.682}, {'end': 27895.673, 'text': "So let's do that right now.", 'start': 27894.552, 'duration': 1.121}, {'end': 27900.797, 'text': 'Apply to worksheets, selected worksheets, and we will click all on dashboard.', 'start': 27896.114, 'duration': 4.683}, {'end': 27902.218, 'text': 'Hit okay.', 'start': 27901.398, 'duration': 0.82}, {'end': 27905.861, 'text': "We'll do this again.", 'start': 27904.84, 'duration': 1.021}, {'end': 27913.605, 'text': 'until we have selected them all.', 'start': 27911.489, 'duration': 2.116}, {'end': 27919.421, 'text': "Great. So it's really nice.", 'start': 27918.12, 'duration': 1.301}, {'end': 27921.762, 'text': 'you get to choose what worksheets you wanted to apply to,', 'start': 27919.421, 'duration': 2.341}], 'summary': 'Applying filters to all worksheets for improved visualizations.', 'duration': 34.395, 'max_score': 27887.367, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ27887367.jpg'}], 'start': 26386.104, 'title': 'Tableau data visualization', 'summary': 'Covers creating sales and profit worksheets, interactive dashboards, dual axis charts, and sales dashboards in tableau, aiming to provide clear visualization and user-friendly analysis. it also discusses dashboard filters and their impact on data representation and scale.', 'chapters': [{'end': 26550.239, 'start': 26386.104, 'title': 'Creating sales and profit worksheets', 'summary': 'Demonstrates creating sales and profit worksheets in tableau by adjusting axis, adding labels, and customizing number formats, aiming to provide a clear visualization of sales and profit by year.', 'duration': 164.135, 'highlights': ['Creating Sales and Profit worksheets The chapter focuses on creating Sales and Profit worksheets in Tableau, demonstrating the process of setting up visualizations for sales and profit data.', 'Customizing number formats The instructor explains how to customize number formats, specifically changing the default number format to currency custom with no decimal places for a clear representation of monetary values.', 'Adding labels and legends The process of adding labels to data points and legends for different regions is demonstrated, enhancing the clarity and comprehension of the visualizations.', 'Adjusting axis for continuous year The chapter covers the process of changing the order date to a continuous year axis, ensuring a clear and coherent representation of sales and profit data over time.']}, {'end': 26866.648, 'start': 26550.78, 'title': 'Creating interactive dashboard in tableau', 'summary': 'Demonstrates creating an interactive dashboard in tableau, including adding filters, highlighting data, and applying filters to multiple worksheets, with the aim of providing a user-friendly and informative visualization for analysis and decision-making.', 'duration': 315.868, 'highlights': ['The chapter demonstrates creating an interactive dashboard in Tableau, including adding filters, highlighting data, and applying filters to multiple worksheets, with the aim of providing a user-friendly and informative visualization for analysis and decision-making.', 'The size of the dashboard is chosen to fit well on laptops, commonly used by both the presenter and customers.', 'The dashboard allows for filtering by category, and it is shown how to apply the filter to affect multiple worksheets, ensuring consistency in data representation.', 'Demonstration of adding filters for category and region, enabling users to filter out regions and select multiple values in a dropdown format for category filtering.', "The process of creating a range-based filter for continuous fields, specifically for the 'year' field, is explained, showcasing a slider for visualization."]}, {'end': 27180.974, 'start': 26867.089, 'title': 'Creating dual axis chart in tableau', 'summary': 'Demonstrates how to create dual axis charts in tableau, synchronize axes, and apply filters on a dashboard, allowing for clear visualization and comparison of overall and regional sales and profit data.', 'duration': 313.885, 'highlights': ['Demonstrating how to create dual axis charts in Tableau and synchronize axes for clear visualization and comparison The chapter explains the process of creating dual axis charts in Tableau and synchronizing axes for clear visualization and comparison of overall and regional sales and profit data.', 'Applying filters on a dashboard to visualize the impact on overall and regional data The chapter discusses applying filters on a Tableau dashboard, demonstrating the impact on overall and regional sales and profit data visualization when filters are applied.', 'Explanation of how filters affect the visualization of overall and regional data in Tableau The chapter explains how filters in Tableau affect the visualization of overall and regional sales and profit data, highlighting the impact of filters on the displayed data.', 'Customizing tooltips for clear data representation and comparison in Tableau The chapter covers the customization of tooltips in Tableau to provide clear data representation and comparison, enhancing the visualization of overall and regional sales and profit data.']}, {'end': 27794.055, 'start': 27183.955, 'title': 'Creating sales dashboard in tableau', 'summary': 'Demonstrates how to create a sales dashboard in tableau, including creating a sales by region pie chart, a sales by state filled map, and a sales by subcategory bar chart, with detailed instructions on applying quick table calculations, adding filters, and arranging the dashboard.', 'duration': 610.1, 'highlights': ['Creating Sales by Subcategory Bar Chart The chapter demonstrates how to create a bar chart for sales by subcategory, with the ability to color code by subcategory or category, and adding filters for category and date.', 'Applying Quick Table Calculations Detailed instructions are given on applying quick table calculations to show sales as a percentage of the total in the sales by region pie chart, enhancing data visualization and understanding.', 'Creating Sales by State Filled Map The process of creating a filled map based on state with color-coded states based on sales, adding labels, and applying filters for state is explained in detail.']}, {'end': 28003.965, 'start': 27794.235, 'title': 'Dashboard filters and visualizations', 'summary': 'Discusses the different types of filters for dashboards including multiple value dropdowns and their impact on visualizations, as well as the use of filters to control visualizations across worksheets and the implications on data representation and scale.', 'duration': 209.73, 'highlights': ['The chapter discusses the different types of filters for dashboards including multiple value dropdowns and their impact on visualizations The chapter provides insight into various filter types such as multiple value dropdowns and their flexibility in selecting values, impacting the visualizations.', 'The use of filters to control visualizations across worksheets and the implications on data representation and scale The chapter explains how applying filters to all the worksheets impacts the visualizations and the scale of data representation, showcasing the dynamic nature of the filters.']}], 'duration': 1617.861, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ26386104.jpg', 'highlights': ['Creating dual axis charts in Tableau and synchronizing axes for clear visualization and comparison.', 'Demonstrating how to create an interactive dashboard in Tableau, including adding filters and applying filters to multiple worksheets.', 'Creating Sales by Subcategory Bar Chart with color-coded subcategories and adding filters for category and date.', 'Customizing tooltips for clear data representation and comparison in Tableau.', 'Applying Quick Table Calculations to show sales as a percentage of the total in the sales by region pie chart.']}, {'end': 30141.183, 'segs': [{'end': 28056.972, 'src': 'embed', 'start': 28029.102, 'weight': 1, 'content': [{'end': 28033.724, 'text': "I wouldn't have known very quickly that there are some states that didn't have any storage sales.", 'start': 28029.102, 'duration': 4.622}, {'end': 28035.585, 'text': 'but now, when we click on storage, we can tell.', 'start': 28033.724, 'duration': 1.861}, {'end': 28041.707, 'text': 'I showed you before that you can control, click and and look at binders and storage and it puts those two together.', 'start': 28035.585, 'duration': 6.122}, {'end': 28047.689, 'text': 'Also in Tableau you can drag and we could select all of these.', 'start': 28042.067, 'duration': 5.622}, {'end': 28052.051, 'text': 'So we have art, binders, envelopes, fasteners, labels, paper, and storage.', 'start': 28047.969, 'duration': 4.082}, {'end': 28054.431, 'text': 'And none of those are getting sold here.', 'start': 28052.551, 'duration': 1.88}, {'end': 28056.972, 'text': "I don't know what's up with Wyoming.", 'start': 28054.451, 'duration': 2.521}], 'summary': 'Some states have no storage sales, including wyoming.', 'duration': 27.87, 'max_score': 28029.102, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28029102.jpg'}, {'end': 28103.61, 'src': 'embed', 'start': 28073.205, 'weight': 2, 'content': [{'end': 28077.526, 'text': "So let's go to sales by region, right click and click duplicate.", 'start': 28073.205, 'duration': 4.321}, {'end': 28082.908, 'text': 'Rename it to profit by region.', 'start': 28079.267, 'duration': 3.641}, {'end': 28089.026, 'text': 'Now you have to be careful whenever you go to reuse a visualization because, like I mentioned before,', 'start': 28084.42, 'duration': 4.606}, {'end': 28092.05, 'text': 'you have to make sure everywhere that sales is used.', 'start': 28089.026, 'duration': 3.024}, {'end': 28093.532, 'text': 'you have to replace it with profit.', 'start': 28092.05, 'duration': 1.482}, {'end': 28103.61, 'text': "I'm also going to drag this sheet to be more at the end here, after the sales dashboard, just to keep them separate,", 'start': 28093.912, 'duration': 9.698}], 'summary': 'Rename sales by region to profit by region, replace sales with profit, and position it after the sales dashboard.', 'duration': 30.405, 'max_score': 28073.205, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28073205.jpg'}, {'end': 28281.786, 'src': 'embed', 'start': 28254.85, 'weight': 5, 'content': [{'end': 28260.872, 'text': "oh, this is when we made it, but you don't want this one, you want this one, and it gets a little confusing.", 'start': 28254.85, 'duration': 6.022}, {'end': 28268.897, 'text': "The nice thing is when you're dragging things onto your dashboard, when you hover, you should get a little picture here of what dashboard,", 'start': 28261.072, 'duration': 7.825}, {'end': 28270.418, 'text': "what visualization you're looking at.", 'start': 28268.897, 'duration': 1.521}, {'end': 28274.381, 'text': 'It really helps you to make your decisions and not just have to do it by name.', 'start': 28270.698, 'duration': 3.683}, {'end': 28281.786, 'text': "If you're a little bit disorganized and you have all of these called Sheet 5, Sheet 7, you won't know exactly what that is right away.", 'start': 28274.561, 'duration': 7.225}], 'summary': 'Dashboard feature provides visual aids for easy decision-making and organization.', 'duration': 26.936, 'max_score': 28254.85, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28254850.jpg'}, {'end': 28442.868, 'src': 'embed', 'start': 28420.143, 'weight': 3, 'content': [{'end': 28427.993, 'text': 'And also, it stacks them on top of each other so that you can tell that for 2013 our profit was around $50,000 really quickly.', 'start': 28420.143, 'duration': 7.85}, {'end': 28436.564, 'text': 'Otherwise, we have to add that line, this line here, and it makes these lines smaller and lower, more difficult to see.', 'start': 28428.213, 'duration': 8.351}, {'end': 28440.086, 'text': 'back to our profit over time by category.', 'start': 28437.845, 'duration': 2.241}, {'end': 28442.868, 'text': "so that's some of the benefits of having an area chart.", 'start': 28440.086, 'duration': 2.782}], 'summary': 'In 2013, our profit was around $50,000, visible quickly with area chart.', 'duration': 22.725, 'max_score': 28420.143, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28420143.jpg'}, {'end': 28635.743, 'src': 'embed', 'start': 28604.915, 'weight': 0, 'content': [{'end': 28607.297, 'text': 'Now we have a filter for category and subcategory.', 'start': 28604.915, 'duration': 2.382}, {'end': 28609.78, 'text': "Here's our region one.", 'start': 28608.278, 'duration': 1.502}, {'end': 28613.063, 'text': "We have region in two places and we don't want that.", 'start': 28610.52, 'duration': 2.543}, {'end': 28615.985, 'text': 'We want it to apply to all of them.', 'start': 28614.404, 'duration': 1.581}, {'end': 28617.687, 'text': "We'll do that when we get to the dashboard.", 'start': 28616.125, 'duration': 1.562}, {'end': 28622.54, 'text': 'And we have category, year of order, date, and subcategory.', 'start': 28619.479, 'duration': 3.061}, {'end': 28626.261, 'text': "Great! Those are all the filters I wanted, so let's build our dashboard.", 'start': 28622.6, 'duration': 3.661}, {'end': 28635.743, 'text': "We'll call this our profit dashboard once I get it set to the size I want.", 'start': 28630.401, 'duration': 5.342}], 'summary': 'Filters added for category and subcategory, ready to build profit dashboard.', 'duration': 30.828, 'max_score': 28604.915, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28604915.jpg'}, {'end': 28775.481, 'src': 'embed', 'start': 28750.678, 'weight': 6, 'content': [{'end': 28757.902, 'text': 'So I recommend setting default number formatting at the beginning of your visualization.', 'start': 28750.678, 'duration': 7.224}, {'end': 28758.682, 'text': 'Really nice.', 'start': 28758.182, 'duration': 0.5}, {'end': 28765.314, 'text': 'excellent, now you can rearrange the order of these, so I like to have the date at the top.', 'start': 28760.37, 'duration': 4.944}, {'end': 28773.82, 'text': "it's sometimes hard to get it to the top, so I take it the second to the top and I drag the top one down and then category above subcategory,", 'start': 28765.314, 'duration': 8.506}, {'end': 28775.481, 'text': 'just for logical sense.', 'start': 28773.82, 'duration': 1.661}], 'summary': 'Recommend setting default number formatting at the beginning of visualization, rearranging order for logical sense.', 'duration': 24.803, 'max_score': 28750.678, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28750678.jpg'}, {'end': 28833.302, 'src': 'embed', 'start': 28801.612, 'weight': 7, 'content': [{'end': 28806.654, 'text': 'so at this point we have our overall dashboard that looks at sales and profit.', 'start': 28801.612, 'duration': 5.042}, {'end': 28810.656, 'text': 'we have our sales dashboard and we have our profit dashboard.', 'start': 28806.654, 'duration': 4.002}, {'end': 28819.2, 'text': "our profit dashboard isn't 100% complete because I forgot to make sure all of these filters apply to all of these worksheets.", 'start': 28810.656, 'duration': 8.544}, {'end': 28820.741, 'text': "so let's go ahead and do that right now.", 'start': 28819.2, 'duration': 1.541}, {'end': 28833.302, 'text': 'applied worksheets, selected worksheets all on Dashboard.', 'start': 28829.793, 'duration': 3.509}], 'summary': 'Dashboard tracks sales and profit, with incomplete profit dashboard due to missing filters.', 'duration': 31.69, 'max_score': 28801.612, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28801612.jpg'}, {'end': 29025.107, 'src': 'embed', 'start': 28993.181, 'weight': 8, 'content': [{'end': 28994.162, 'text': 'It can get pretty cool.', 'start': 28993.181, 'duration': 0.981}, {'end': 29001.585, 'text': 'Okay, but we want to link from this dashboard to one of our other dashboards and you actually do that using a filter action.', 'start': 28994.582, 'duration': 7.003}, {'end': 29007.688, 'text': "So we're going to name that action, go to sales dashboard.", 'start': 29001.605, 'duration': 6.083}, {'end': 29012.098, 'text': 'and we want it to happen when we click on our sales sheet.', 'start': 29008.556, 'duration': 3.542}, {'end': 29016.281, 'text': 'so you see right here it shows us the two sheets that are on this dashboard.', 'start': 29012.098, 'duration': 4.183}, {'end': 29019.263, 'text': "when we click on the profits dashboard, we don't want this action to occur.", 'start': 29016.281, 'duration': 2.982}, {'end': 29020.884, 'text': 'this is our go to sales dashboard.', 'start': 29019.263, 'duration': 1.621}, {'end': 29025.107, 'text': 'now you can have an action occur on hover or select.', 'start': 29020.884, 'duration': 4.223}], 'summary': 'Link dashboards using filter action on click for seamless navigation.', 'duration': 31.926, 'max_score': 28993.181, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28993181.jpg'}, {'end': 29507.18, 'src': 'embed', 'start': 29476.839, 'weight': 11, 'content': [{'end': 29481.18, 'text': 'So we can see for technology, by consumer, by corporate, by home office.', 'start': 29476.839, 'duration': 4.341}, {'end': 29483.66, 'text': 'And that is a matrix of bar charts.', 'start': 29481.7, 'duration': 1.96}, {'end': 29485.561, 'text': 'But we also want to be able to see profit.', 'start': 29483.78, 'duration': 1.781}, {'end': 29489.302, 'text': "And right now, it's making two sets of visualizations.", 'start': 29486.561, 'duration': 2.741}, {'end': 29491.142, 'text': 'But we want just one.', 'start': 29489.822, 'duration': 1.32}, {'end': 29492.483, 'text': "So let's dual axis.", 'start': 29491.182, 'duration': 1.301}, {'end': 29496.057, 'text': "and it's automatically changed it to circles.", 'start': 29493.596, 'duration': 2.461}, {'end': 29507.18, 'text': 'also, it is not synchronizing the axis now, because profit is blue and these profit is not anywhere near the same amount of sales, which makes sense.', 'start': 29496.057, 'duration': 11.123}], 'summary': 'Analyzing technology sales and profit through visualizations, aiming for synchronization.', 'duration': 30.341, 'max_score': 29476.839, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ29476839.jpg'}, {'end': 29612.712, 'src': 'embed', 'start': 29583.772, 'weight': 12, 'content': [{'end': 29589.457, 'text': 'Oh, so right now they are, it automatically added the colors based on measure names.', 'start': 29583.772, 'duration': 5.685}, {'end': 29593.841, 'text': 'Measure names is a dimension that is created by Tableau.', 'start': 29589.797, 'duration': 4.044}, {'end': 29595.743, 'text': "And it's just what it sounds like.", 'start': 29594.141, 'duration': 1.602}, {'end': 29599.126, 'text': "We're coloring it based on the different measure names.", 'start': 29595.903, 'duration': 3.223}, {'end': 29603.688, 'text': "one of them's named profit, one of them's named sales, and we know that you can come here.", 'start': 29599.466, 'duration': 4.222}, {'end': 29607.349, 'text': 'click color and hit edit colors, and it will open this dialog box.', 'start': 29603.688, 'duration': 3.661}, {'end': 29612.712, 'text': 'but you can also come here and double click on a color pops, open that dialog box.', 'start': 29607.349, 'duration': 5.363}], 'summary': 'Tableau automatically adds colors based on measure names such as profit and sales.', 'duration': 28.94, 'max_score': 29583.772, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ29583772.jpg'}, {'end': 29739.987, 'src': 'embed', 'start': 29709.908, 'weight': 13, 'content': [{'end': 29714.389, 'text': 'of top-end customers by sales, maybe we want this to say something a little bit more user-friendly.', 'start': 29709.908, 'duration': 4.481}, {'end': 29721.01, 'text': "So let's make a calculated field, and we're going to call it the top-end customers label.", 'start': 29714.449, 'duration': 6.561}, {'end': 29728.231, 'text': "And we're going to go and say if, and we're going to use our set, top-end customers by sales.", 'start': 29722.43, 'duration': 5.801}, {'end': 29739.987, 'text': "and since it's an in or out set, it treats this like if it's in top-end customers by sales, then top, We're going to do a string.", 'start': 29728.231, 'duration': 11.756}], 'summary': "Create a user-friendly 'top-end customers label' based on sales data.", 'duration': 30.079, 'max_score': 29709.908, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ29709908.jpg'}, {'end': 29975.711, 'src': 'embed', 'start': 29937.634, 'weight': 15, 'content': [{'end': 29943.736, 'text': 'Automatic, as you probably read right there, the dashboard will resize to fit any screen it is displayed on.', 'start': 29937.634, 'duration': 6.102}, {'end': 29949.438, 'text': 'That can be really handy, especially if your visualization is really dynamic and can change.', 'start': 29943.876, 'duration': 5.562}, {'end': 29957.32, 'text': 'However, some visualizations, like this visualization for example, if it gets too squished you stop being able to read things very well.', 'start': 29949.518, 'duration': 7.802}, {'end': 29960.641, 'text': 'So automatic has its definite pros and cons.', 'start': 29957.4, 'duration': 3.241}, {'end': 29975.711, 'text': "So we're going to bring on our profit and sales by segment, and it already pops up with its legend and total customers by sale.", 'start': 29966.286, 'duration': 9.425}], 'summary': 'The dashboard automatically resizes to fit any screen, with pros and cons.', 'duration': 38.077, 'max_score': 29937.634, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ29937634.jpg'}, {'end': 30067.796, 'src': 'embed', 'start': 30038.682, 'weight': 16, 'content': [{'end': 30040.463, 'text': 'So it will affect all sheets always.', 'start': 30038.682, 'duration': 1.781}, {'end': 30042.124, 'text': 'Very important to know.', 'start': 30040.983, 'duration': 1.141}, {'end': 30044.686, 'text': "Great So here's our visualization.", 'start': 30042.545, 'duration': 2.141}, {'end': 30049.31, 'text': 'Here are some of the more useful legends.', 'start': 30045.247, 'duration': 4.063}, {'end': 30050.671, 'text': "So let's..", 'start': 30049.49, 'duration': 1.181}, {'end': 30055.192, 'text': 'Make this floating and put it over by the visualization it matters for.', 'start': 30051.371, 'duration': 3.821}, {'end': 30056.673, 'text': 'We can do the same thing here.', 'start': 30055.212, 'duration': 1.461}, {'end': 30058.653, 'text': 'Floating right up here.', 'start': 30056.693, 'duration': 1.96}, {'end': 30067.796, 'text': 'Floating does not work very well, for if you were to make this an automatic dashboard so that the size changes all the time,', 'start': 30058.913, 'duration': 8.883}], 'summary': 'The importance of making visualizations floating and utilizing legends for better impact on all sheets.', 'duration': 29.114, 'max_score': 30038.682, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ30038682.jpg'}, {'end': 30141.183, 'src': 'embed', 'start': 30111.109, 'weight': 14, 'content': [{'end': 30118.753, 'text': 'And you could change it to select number of top customers or something like that.', 'start': 30111.109, 'duration': 7.644}, {'end': 30120.334, 'text': 'Give it a little more space.', 'start': 30119.333, 'duration': 1.001}, {'end': 30127.277, 'text': "And yeah, these floating ones do not shift when you shift things so it's always good to double check your floating legends.", 'start': 30121.334, 'duration': 5.943}, {'end': 30135.502, 'text': 'And this is a little bit more user friendly than the title we made for the developers.', 'start': 30130.239, 'duration': 5.263}, {'end': 30141.183, 'text': "and that's using parameters in a dashboard.", 'start': 30138.462, 'duration': 2.721}], 'summary': 'Using parameters in a dashboard for a more user-friendly interface.', 'duration': 30.074, 'max_score': 30111.109, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ30111109.jpg'}], 'start': 28003.965, 'title': 'Dashboard customization and profit analysis', 'summary': 'Discusses customizing dashboards to focus on specific regions and subcategories, identifying states with no storage sales, creating a profit dashboard, linking dashboards, and tableau dashboard design.', 'chapters': [{'end': 28254.85, 'start': 28003.965, 'title': 'Dashboard customization and profit analysis', 'summary': 'Discusses customizing dashboards to focus on specific regions and subcategories, identifying states with no storage sales, and creating a profit dashboard by duplicating sales visualizations and making necessary adjustments, with emphasis on filter management and avoiding naming conflicts.', 'duration': 250.885, 'highlights': ['The chapter discusses customizing dashboards to focus on specific regions and subcategories.', 'Identifying states with no storage sales is demonstrated by clicking on the storage category.', 'Creating a profit dashboard involves duplicating sales visualizations and making necessary adjustments, with emphasis on filter management and avoiding naming conflicts.']}, {'end': 28682.49, 'start': 28254.85, 'title': 'Creating profit dashboard with tableau', 'summary': 'Covers the process of creating a profit dashboard with tableau, including the benefits of using area charts, filters, and the visualization space, with a focus on profit by category, subcategory, and region, and the use of filters for category, year of order, date, and subcategory.', 'duration': 427.64, 'highlights': ['The benefits of using area charts for visualizing profit over time by category, including the ability to compare profits over time and by category, as well as stacking for easy comparison, with a focus on $50,000 profit in 2013. $50,000 profit in 2013', 'Utilizing filters for category, year of order, date, and subcategory to make the dashboard interactive and allowing for detailed analysis and user interaction. Usage of filters for category, year of order, date, and subcategory', 'The importance of previewing visualizations when dragging onto the dashboard, aiding in decision-making and reducing confusion. Importance of visualization preview for decision-making']}, {'end': 28992.561, 'start': 28682.81, 'title': 'Creating profit dashboard and linking dashboards', 'summary': 'Discusses creating a profit dashboard with default number formatting and rearranging the order of charts, ensuring filters work, and linking from the overall dashboard to the sales dashboard using actions.', 'duration': 309.751, 'highlights': ['Creating a profit dashboard with default number formatting and rearranging the order of charts The speaker recommends setting default number formatting at the beginning of visualization to save time and rearranging the order of charts for logical sense.', "Ensuring filters work and applying them to all worksheets It's emphasized to double check that filters work before publishing a dashboard and to ensure all filters apply to all worksheets.", 'Linking from the overall dashboard to the sales dashboard using actions The process of creating a dashboard action to link between two dashboards and the different kinds of actions such as filter action, highlight action, and go to URL action are discussed.']}, {'end': 29583.592, 'start': 28993.181, 'title': 'Linking dashboards and creating visualizations', 'summary': 'Covers creating filter actions to link dashboards, demonstrating how to apply filters and navigate between dashboards, as well as building visualizations such as a matrix of bar charts and dual axis chart for sales and profit comparison.', 'duration': 590.411, 'highlights': ['Creating filter actions to link dashboards Demonstrates the process of creating filter actions to link dashboards, allowing for easy navigation and interaction between different dashboard views.', 'Applying filters and navigating between dashboards Explains the application of filters to specific data fields and demonstrates how to navigate between dashboards by clicking on specific elements, with examples of filter behavior based on user interaction.', 'Building a matrix of bar charts and dual axis chart for sales and profit comparison Illustrates the process of creating a matrix of bar charts to visualize sales data across different segments, as well as building a dual axis chart for comparing sales and profit, including synchronizing axes and adjusting chart settings.']}, {'end': 30141.183, 'start': 29583.772, 'title': 'Tableau dashboard design', 'summary': 'Discusses the process of creating visualizations in tableau, including color selection, labeling, parameter usage, and dashboard design, highlighting the importance of user-friendly titles, parameter control, and the impact of filters on visualizations.', 'duration': 557.411, 'highlights': ['The process of creating visualizations in Tableau, including color selection, labeling, parameter usage, and dashboard design is discussed in detail, emphasizing the importance of user-friendly titles, parameter control, and the impact of filters on visualizations in a user-friendly manner.', "Explains the creation of a user-friendly title for the visualization through a calculated field, demonstrating the use of the if statement and string conversion to display 'top X customers' or 'other', enhancing user understanding and interaction with the dashboard.", 'Details the use of parameters to control changes in the visualization, such as setting the number of top customers by sales, allowing users to dynamically interact with the dashboard and gain insights based on different parameters.', 'Discusses the impact of filters on visualizations, allowing users to filter by category and segment, and highlights the considerations for automatic dashboard resizing, including the pros and cons of this feature in Tableau.', 'Provides insights into the use of legends, filters, and parameters in Tableau, explaining their impact on visualizations and the importance of considering their behavior in automatic and floating dashboard designs.']}], 'duration': 2137.218, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ28003965.jpg', 'highlights': ['The chapter discusses customizing dashboards to focus on specific regions and subcategories.', 'Identifying states with no storage sales is demonstrated by clicking on the storage category.', 'Creating a profit dashboard involves duplicating sales visualizations and making necessary adjustments, with emphasis on filter management and avoiding naming conflicts.', 'The benefits of using area charts for visualizing profit over time by category, including the ability to compare profits over time and by category, as well as stacking for easy comparison, with a focus on $50,000 profit in 2013.', 'Utilizing filters for category, year of order, date, and subcategory to make the dashboard interactive and allowing for detailed analysis and user interaction.', 'The importance of previewing visualizations when dragging onto the dashboard, aiding in decision-making and reducing confusion.', 'Creating a profit dashboard with default number formatting and rearranging the order of charts The speaker recommends setting default number formatting at the beginning of visualization to save time and rearranging the order of charts for logical sense.', "Ensuring filters work and applying them to all worksheets It's emphasized to double check that filters work before publishing a dashboard and to ensure all filters apply to all worksheets.", 'Linking from the overall dashboard to the sales dashboard using actions The process of creating a dashboard action to link between two dashboards and the different kinds of actions such as filter action, highlight action, and go to URL action are discussed.', 'Creating filter actions to link dashboards Demonstrates the process of creating filter actions to link dashboards, allowing for easy navigation and interaction between different dashboard views.', 'Applying filters and navigating between dashboards Explains the application of filters to specific data fields and demonstrates how to navigate between dashboards by clicking on specific elements, with examples of filter behavior based on user interaction.', 'Building a matrix of bar charts and dual axis chart for sales and profit comparison Illustrates the process of creating a matrix of bar charts to visualize sales data across different segments, as well as building a dual axis chart for comparing sales and profit, including synchronizing axes and adjusting chart settings.', 'The process of creating visualizations in Tableau, including color selection, labeling, parameter usage, and dashboard design is discussed in detail, emphasizing the importance of user-friendly titles, parameter control, and the impact of filters on visualizations in a user-friendly manner.', "Explains the creation of a user-friendly title for the visualization through a calculated field, demonstrating the use of the if statement and string conversion to display 'top X customers' or 'other', enhancing user understanding and interaction with the dashboard.", 'Details the use of parameters to control changes in the visualization, such as setting the number of top customers by sales, allowing users to dynamically interact with the dashboard and gain insights based on different parameters.', 'Discusses the impact of filters on visualizations, allowing users to filter by category and segment, and highlights the considerations for automatic dashboard resizing, including the pros and cons of this feature in Tableau.', 'Provides insights into the use of legends, filters, and parameters in Tableau, explaining their impact on visualizations and the importance of considering their behavior in automatic and floating dashboard designs.']}, {'end': 31163.987, 'segs': [{'end': 30169.402, 'src': 'embed', 'start': 30142.183, 'weight': 0, 'content': [{'end': 30147.125, 'text': 'Today in this video, we learned about an overview of business intelligence on Tableau.', 'start': 30142.183, 'duration': 4.942}, {'end': 30151.727, 'text': 'We talked about how to install Tableau Public and how to connect to a data source.', 'start': 30147.505, 'duration': 4.222}, {'end': 30156.388, 'text': 'We also talked about creating calculated fields like this one.', 'start': 30152.567, 'duration': 3.821}, {'end': 30159.95, 'text': 'We talked about making sets and parameters.', 'start': 30157.249, 'duration': 2.701}, {'end': 30164.211, 'text': 'We learned how to make a donut chart and a 2D donut chart.', 'start': 30160.51, 'duration': 3.701}, {'end': 30169.402, 'text': 'We learned about making dashboards and adding filters to those dashboards.', 'start': 30164.671, 'duration': 4.731}], 'summary': 'Introduced tableau for business intelligence, covering installation, data connections, calculated fields, sets, parameters, donut charts, 2d donut charts, dashboards, and filters.', 'duration': 27.219, 'max_score': 30142.183, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ30142183.jpg'}, {'end': 30273.253, 'src': 'embed', 'start': 30249.972, 'weight': 1, 'content': [{'end': 30258.24, 'text': 'Whereas an extract connection is extracted into, creates a subset of the data that improves performance.', 'start': 30249.972, 'duration': 8.268}, {'end': 30263.204, 'text': "So, when you're looking at it locally on your computer, you have an extract of that data set,", 'start': 30258.38, 'duration': 4.824}, {'end': 30269.45, 'text': "that subset of the data right on your computer or up in Tableau server, depending on where you're looking at it.", 'start': 30263.204, 'duration': 6.246}, {'end': 30273.253, 'text': 'And it does not update when the database updates.', 'start': 30269.97, 'duration': 3.283}], 'summary': 'Extract connection creates a subset of data for improved performance, not updating with database changes.', 'duration': 23.281, 'max_score': 30249.972, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ30249972.jpg'}, {'end': 30705.749, 'src': 'embed', 'start': 30676.337, 'weight': 2, 'content': [{'end': 30684.121, 'text': "Now we're going to take a look at calculations and which ones are calculated on the database side versus which are calculated on the table side.", 'start': 30676.337, 'duration': 7.784}, {'end': 30692.325, 'text': 'So here we have percentage of total sales split up by subcategory and category.', 'start': 30685.842, 'duration': 6.483}, {'end': 30697.647, 'text': 'We also have percentage of total sales along table down.', 'start': 30693.005, 'duration': 4.642}, {'end': 30705.749, 'text': 'So the difference between these two things are one of them is made using calculated field,', 'start': 30698.127, 'duration': 7.622}], 'summary': 'Analyzing calculations performed on database versus table side.', 'duration': 29.412, 'max_score': 30676.337, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ30676337.jpg'}], 'start': 30142.183, 'title': 'Tableau business intelligence overview, connections, joins, unions, table calculations, and ranking', 'summary': 'Provides an overview of tableau business intelligence, covering topics such as installing tableau public, creating calculated fields, donut charts, and dashboards. it also explains connections, joins, unions, and different types of ranking functions in tableau, emphasizing data management and visualization.', 'chapters': [{'end': 30206.238, 'start': 30142.183, 'title': 'Tableau business intelligence overview', 'summary': 'Introduces an overview of business intelligence on tableau, covering topics such as installing tableau public, creating calculated fields, making donut charts, dashboards, filters, connections between dashboards, live versus extract data sources, joins, unions, table calculations, rank functions, url actions, reference lines and bands, delay analysis, building waterfall charts, and level of detail calculations.', 'duration': 64.055, 'highlights': ['The chapter covers topics from installing Tableau Public to creating calculated fields, making donut charts, dashboards, and connecting between dashboards.', 'It also delves into topics like live versus extract data sources, joins, unions, table calculations, rank functions, URL actions, reference lines and bands, and delay analysis.', 'Additionally, the chapter explores creating a waterfall chart and level of detail calculations while making two different visualizations.']}, {'end': 30675.335, 'start': 30206.378, 'title': 'Tableau: connections, joins, and unions', 'summary': 'Covers the difference between live connection and extract connection, the process of joining data in tableau, and the options for joining including inner join, left join, right join, and full outer join, along with the concept of union for adding more data in tableau, providing insights on data management and visualization.', 'duration': 468.957, 'highlights': ['The difference between live connection and extract connection Live connection updates data based on the source, while extract connection creates a subset of data improving performance but requires manual refresh.', 'Process of joining data in Tableau Tableau allows joining of data sources based on specified columns, with options for inner join, left join, right join, and full outer join, influencing the inclusion of data in the visualization.', 'Concept of union in Tableau for adding more data Union enables the addition of more data by combining rows from different tables, providing a method for incorporating additional data into the visualization.']}, {'end': 31163.987, 'start': 30676.337, 'title': 'Table calculations and ranking in tableau', 'summary': 'Discusses the difference between database side and table side calculations in tableau, including examples of percentage of total sales and ranking using table calculations, and the pros and cons of each approach. it also covers the process of creating and using table calculations and the different types of ranking functions available in tableau.', 'duration': 487.65, 'highlights': ['The difference between database side and table side calculations in Tableau, including examples of percentage of total sales and ranking using table calculations, and the pros and cons of each approach. Difference between database side and table side calculations, examples of percentage of total sales and ranking using table calculations, pros and cons of each approach', 'Explanation of the process of creating and using table calculations and the different types of ranking functions available in Tableau. Process of creating and using table calculations, different types of ranking functions available in Tableau']}], 'duration': 1021.804, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ30142183.jpg', 'highlights': ['The chapter covers topics from installing Tableau Public to creating calculated fields, making donut charts, dashboards, and connecting between dashboards.', 'The difference between live connection and extract connection Live connection updates data based on the source, while extract connection creates a subset of data improving performance but requires manual refresh.', 'The difference between database side and table side calculations in Tableau, including examples of percentage of total sales and ranking using table calculations, and the pros and cons of each approach.']}, {'end': 33524.798, 'segs': [{'end': 31600.596, 'src': 'embed', 'start': 31570.147, 'weight': 1, 'content': [{'end': 31581.231, 'text': "So let's take sales by subcategory and look at it over top of our sales by category stacked, over top of sales by subcategory.", 'start': 31570.147, 'duration': 11.084}, {'end': 31582.772, 'text': 'so we want both of those.', 'start': 31581.231, 'duration': 1.541}, {'end': 31590.153, 'text': "let's make our dashboard automatic for testing purposes and we'll go to dashboard.", 'start': 31582.772, 'duration': 7.381}, {'end': 31592.634, 'text': "we'll click create actions.", 'start': 31590.153, 'duration': 2.481}, {'end': 31593.794, 'text': "so we're going to add an action.", 'start': 31592.634, 'duration': 1.16}, {'end': 31600.596, 'text': "it's going to be a highlight action highlight sales by subcategory.", 'start': 31593.794, 'duration': 6.802}], 'summary': 'Dashboard set up to automatically compare sales by subcategory and category.', 'duration': 30.449, 'max_score': 31570.147, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ31570147.jpg'}, {'end': 31700.147, 'src': 'embed', 'start': 31673.55, 'weight': 0, 'content': [{'end': 31677.252, 'text': "So when I clicked undo, that's when it caused the filter to go away.", 'start': 31673.55, 'duration': 3.702}, {'end': 31682.836, 'text': "So if you're going to have two things affect that sheet,", 'start': 31677.693, 'duration': 5.143}, {'end': 31690.08, 'text': "just remember that just because you navigated away from what you selected doesn't mean that what you selected goes away.", 'start': 31682.836, 'duration': 7.244}, {'end': 31691.641, 'text': 'That filter will stay there.', 'start': 31690.421, 'duration': 1.22}, {'end': 31693.503, 'text': 'And it shows up right here.', 'start': 31691.661, 'duration': 1.842}, {'end': 31696.825, 'text': 'And if we pull it off, everything goes back to normal.', 'start': 31693.523, 'duration': 3.302}, {'end': 31698.446, 'text': 'However, the action is still there.', 'start': 31696.945, 'duration': 1.501}, {'end': 31700.147, 'text': 'So when you click on it, it comes back.', 'start': 31698.726, 'duration': 1.421}], 'summary': "Clicking 'undo' caused the filter to disappear, but the action remains.", 'duration': 26.597, 'max_score': 31673.55, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ31673550.jpg'}, {'end': 31804.828, 'src': 'embed', 'start': 31775.588, 'weight': 4, 'content': [{'end': 31777.609, 'text': "that action won't transfer over.", 'start': 31775.588, 'duration': 2.021}, {'end': 31780.711, 'text': "you'll need to make a dashboard action.", 'start': 31777.609, 'duration': 3.102}, {'end': 31782.832, 'text': "so we're going to make a go to url action.", 'start': 31780.711, 'duration': 2.121}, {'end': 31784.297, 'text': "We're going to have it on menu.", 'start': 31783.336, 'duration': 0.961}, {'end': 31786.798, 'text': "We're going to call it wiki.", 'start': 31784.337, 'duration': 2.461}, {'end': 31794.723, 'text': "And it's going to only affect our new sheet, sheet 6, which we should rename.", 'start': 31788.379, 'duration': 6.344}, {'end': 31797.384, 'text': "And we're going to add a URL in here.", 'start': 31794.743, 'duration': 2.641}, {'end': 31799.045, 'text': 'So this will take us to Wikipedia.', 'start': 31797.524, 'duration': 1.521}, {'end': 31804.828, 'text': 'And then whatever you put at the end of the Wikipedia link, it will take you to that page on Wikipedia.', 'start': 31799.525, 'duration': 5.303}], 'summary': "Create a 'go to url' dashboard action for a new sheet, sheet 6, to link to wikipedia.", 'duration': 29.24, 'max_score': 31775.588, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ31775588.jpg'}, {'end': 32947.029, 'src': 'embed', 'start': 32917.836, 'weight': 3, 'content': [{'end': 32918.676, 'text': 'A level of detail.', 'start': 32917.836, 'duration': 0.84}, {'end': 32929.142, 'text': "calculation allows you to build a visualization and bring on metrics that are at a level that is different from what's shown on the visualization.", 'start': 32918.676, 'duration': 10.466}, {'end': 32941.928, 'text': 'So in order to do this, we need to create a calculated field that will show us the number of orders per customer.', 'start': 32929.841, 'duration': 12.087}, {'end': 32947.029, 'text': "even though we're not going to have our visualization be per customer.", 'start': 32943.146, 'duration': 3.883}], 'summary': 'Creating a calculated field to show number of orders per customer for visualization.', 'duration': 29.193, 'max_score': 32917.836, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ32917836.jpg'}, {'end': 33152.357, 'src': 'embed', 'start': 33117.532, 'weight': 2, 'content': [{'end': 33119.874, 'text': "And that's an introduction to level of detail.", 'start': 33117.532, 'duration': 2.342}, {'end': 33129.46, 'text': "So let's name this sheet, level of detail, LOD orders per customer.", 'start': 33120.733, 'duration': 8.727}, {'end': 33140.367, 'text': "Perfect Now let's make a new sheet and we are going to do an analysis about new customers.", 'start': 33131.521, 'duration': 8.846}, {'end': 33146.051, 'text': "So we'll call this level of detail, new customer analysis.", 'start': 33141.447, 'duration': 4.604}, {'end': 33152.357, 'text': 'So this visualization is going to be about customer acquisition over time.', 'start': 33148.635, 'duration': 3.722}], 'summary': 'Introduction to level of detail, creating sheets for lod orders per customer and new customer analysis, with focus on customer acquisition over time.', 'duration': 34.825, 'max_score': 33117.532, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ33117532.jpg'}], 'start': 31163.987, 'title': 'Tableau visualization', 'summary': 'Covers creating actions for data visualization, distinguishing worksheet and dashboard actions, and analyzing visual analytics and level of detail calculations in tableau, with demonstrations and practical applications discussed.', 'chapters': [{'end': 31264.716, 'start': 31163.987, 'title': 'Ranking options and ascending/descending order', 'summary': 'Discusses the use of ranking options and the concept of ascending and descending order, using ascii values to determine ranks, with the default being descending for sales ranking.', 'duration': 100.729, 'highlights': ['The default ranking option for sales is set to descending, indicating that the highest value is considered the best.', 'The ranking is determined based on ASCII values of the store, allowing for unique rankings even when numbers are shared.', 'The chapter explains the concept of ascending and descending order, providing a choice in how data is ranked based on user preference.']}, {'end': 31755.559, 'start': 31265.197, 'title': 'Tableau actions for data visualization', 'summary': 'Discusses creating actions in tableau for data visualization, including creating charts, using worksheet actions to filter and drill down data, applying highlight actions for interactivity, and implementing url actions to create map visualizations.', 'duration': 490.362, 'highlights': ['The chapter covers creating charts by dragging category and sales onto columns and rows, resulting in the creation of bar charts for sales by category and subcategory, with the latter displaying each subcategory in different colors.', 'The chapter explains using worksheet actions to filter and drill down data, demonstrating the process of creating a filter on select for moving from sales by category to sales by subcategory, enabling interactive filtering by category and subcategory.', 'The chapter demonstrates applying highlight actions on a dashboard to enable interactive highlighting of data points, allowing users to select and highlight specific data points or categories within the visualizations.', 'The chapter also discusses implementing URL actions to create map visualizations, showcasing the process of building a filled map based on state and color-coding it based on sales, and customizing the display of sales amount as currency.', 'The chapter emphasizes the importance of understanding the impact of navigating away from selected data points on the applied filters, highlighting how the filter stays in place unless explicitly removed, and the impact of using multiple actions on the same sheet.']}, {'end': 32553.017, 'start': 31755.559, 'title': 'Tableau worksheet and dashboard actions', 'summary': 'Discusses creating worksheet and dashboard actions in tableau, including the distinction between them, setting up a go-to url action, avoiding unintended actions, and implementing reference lines and bands for data visualization.', 'duration': 797.458, 'highlights': ['Creating a go-to URL action for a specific worksheet enables accessing external web pages like Wikipedia, enhancing data analysis and exploration. The go-to URL action is set up for a specific worksheet to link to external web pages, such as Wikipedia, providing a useful tool for accessing additional information during data analysis.', "Addressing unintended actions by ensuring that only the desired worksheet is affected, preventing automatic selection of new sheets and avoiding disruptive behavior. To prevent unintended actions, it's important to ensure that only the intended worksheet is affected and that new sheets are not automatically selected, thus avoiding disruptive behavior during data analysis.", 'Utilizing reference lines and bands in Tableau for creating visualizations, including setting up average lines and conditional formatting based on shipping analysis. The use of reference lines and bands in Tableau allows for creating visualizations, such as setting up average lines and applying conditional formatting based on shipping analysis to enhance data visualization and interpretation.']}, {'end': 33116.031, 'start': 32554.338, 'title': 'Visual analytics and level of detail calculation', 'summary': 'Introduces visual analytics with tableau, showcasing the analysis of shipment delays and the creation of a waterfall chart based on profit, followed by a demonstration of level of detail calculation to analyze customer order patterns.', 'duration': 561.693, 'highlights': ['The chapter provides an analysis of shipment delays, revealing that the District of Columbia has second class as a late shipment on average, and showcases the use of uniform axis range for comparison. District of Columbia has second class as a late shipment on average, uniform axis range for comparison', 'It demonstrates the creation of a waterfall chart based on profit using Tableau, focusing on the visualization of profit over time and the use of negative profit for gaunt bar size determination. Creation of a waterfall chart based on profit, visualization of profit over time, use of negative profit for gaunt bar size determination', 'The chapter presents the application of level of detail calculation in Tableau to analyze customer order patterns, allowing for the visualization of the number of orders per customer and the popularity of specific order quantities. Application of level of detail calculation in Tableau, visualization of number of orders per customer, popularity of specific order quantities']}, {'end': 33524.798, 'start': 33117.532, 'title': 'Level of detail analysis in tableau', 'summary': 'Covers creating visualizations for customer acquisition over time, using level of detail calculations to analyze new and existing customers, and understanding the importance of level of detail calculations in tableau for data aggregation and analysis.', 'duration': 407.266, 'highlights': ['The chapter covers creating visualizations for customer acquisition over time The tutorial demonstrates creating visualizations to track new customer acquisition over time, providing a visual representation of customer growth and trends.', 'Using level of detail calculations to analyze new and existing customers The tutorial showcases the use of level of detail calculations to differentiate between new and existing customers, enabling the analysis of customer behavior and acquisition trends.', 'Understanding the importance of level of detail calculations in Tableau for data aggregation and analysis The tutorial emphasizes the significance of level of detail calculations in Tableau for accurate data aggregation, enabling detailed analysis of customer acquisition and behavior.']}], 'duration': 2360.811, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/Hg8zBJ1DhLQ/pics/Hg8zBJ1DhLQ31163987.jpg', 'highlights': ['The chapter emphasizes the importance of understanding the impact of navigating away from selected data points on the applied filters, highlighting how the filter stays in place unless explicitly removed, and the impact of using multiple actions on the same sheet.', 'The chapter demonstrates applying highlight actions on a dashboard to enable interactive highlighting of data points, allowing users to select and highlight specific data points or categories within the visualizations.', 'The chapter covers creating visualizations for customer acquisition over time The tutorial demonstrates creating visualizations to track new customer acquisition over time, providing a visual representation of customer growth and trends.', 'The chapter presents the application of level of detail calculation in Tableau to analyze customer order patterns, allowing for the visualization of the number of orders per customer and the popularity of specific order quantities. Application of level of detail calculation in Tableau, visualization of number of orders per customer, popularity of specific order quantities', 'The chapter covers creating a go-to URL action for a specific worksheet enables accessing external web pages like Wikipedia, enhancing data analysis and exploration. The go-to URL action is set up for a specific worksheet to link to external web pages, such as Wikipedia, providing a useful tool for accessing additional information during data analysis.']}], 'highlights': ['Companies utilize massive amounts of data for decision-making, impacting business performance.', 'Data is likened to the new oil, emphasizing its potential value when effectively analyzed.', 'Tableau can connect to 40 different data sources and handle large amounts of data easily.', 'Qlik was named a leader in the 2020 Gartner Magic Quadrant for analytics and BI platforms.', 'SAS BI is used by companies like Accenture, Genpact, IQVR, and IBM.', 'Power BI provides easy drag and drop functionality, transforms enterprise data into rich visuals, and integrates with Azure for analyzing and sharing large volumes of data.', 'Excel provides a platform for various mathematical calculations on large datasets, catering to the needs of various organizations.', 'The chapter emphasizes the use of Excel for data manipulation and analysis, showcasing how to import, organize, and sort data from various sources to facilitate efficient data analysis and visualization.', 'The process of sorting data in Excel is demonstrated, including sorting the data based on the date listed in descending order and sorting the data based on agent name in descending order and area in ascending order, optimizing data visualization and analysis.', 'The chapter explains the process of importing data from MySQL databases, cloud, online services, web, Hadoop file system, and active directory into Excel, enhancing data accessibility and analysis.', 'The chapter demonstrates working with tables, including adding rows and columns, performing calculations, and creating drop-down lists for data validation.', 'The chapter covers advanced filtering in Excel, such as filtering based on multiple columns with different values and applying advanced criteria to filter data and store the result in a different location.', 'Excel functions like COUNTIFS used to find the total number of orders from the East region. Example: 13 orders found from the East region.', 'Using data validation in Excel to restrict city names and places within specific cities like Pune, Mumbai, and Nasik.', 'Explaining pivot tables as a summary of data and pivot charts as visual representations for data analysis.', 'Using pivot tables to find percentage contribution of subcategories to total sales, allowing for sorting in descending order to identify highest contributors.', 'Excel Power Query enables connections to various data sources, addressing the challenge of data connections in Excel.', "Power BI's ability to access vast volumes of data from multiple sources for visualization and analysis.", 'Meijer connected Power BI to an on-premises SQL Server Analysis Services cube, allowing them to refresh 20 billion rows of data in near real-time, enabling faster data pull and real-time analysis for insights.', 'Tableau can be connected to 40 different data sources, enhancing direct access to data.', 'Creating hierarchies for detailed analysis and understanding sales performance by category, subcategory, and product name.', 'Parameters allow users to choose the number of top customers to visualize, with a range from 5 to 20 and a step size of 5', 'Creating dual axis charts in Tableau and synchronizing axes for clear visualization and comparison.', 'The chapter covers topics from installing Tableau Public to creating calculated fields, making donut charts, dashboards, and connecting between dashboards.', 'The difference between live connection and extract connection Live connection updates data based on the source, while extract connection creates a subset of data improving performance but requires manual refresh.', 'The chapter emphasizes the importance of understanding the impact of navigating away from selected data points on the applied filters, highlighting how the filter stays in place unless explicitly removed, and the impact of using multiple actions on the same sheet.']}