title
Power BI Project For Beginners | Sales Insights Data Analysis Project - 5 - Build Dashboard
description
In this video, we will do some more data cleaning and build a powerful dashboard that can help us generate sales insights on the Atliq hardware business.
To download all the resource files: https://codebasics.io/resources/sales-insights-data-analysis-project
(You can find the SQL queries, setup instructions, and Power BI formula in the Readme file)
Previous video: https://www.youtube.com/watch?v=6pifKxjyHd8&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=4
Next video: https://www.youtube.com/watch?v=gDuMaJfDtS0&list=PLeo1K3hjS3utcb9nKtanhcn8jd2E0Hp9b&index=6
How to learn data analyst skills for free: https://youtu.be/x6tnVOn4st4
Machine learning tutorial playlist: https://www.youtube.com/watch?v=gmvvaobm7eQ&list=PLeo1K3hjS3uvCeTYTeyfe0-rN5r8zn9rw
Entire playlist for this project: https://www.youtube.com/playlist?list=PLeo1K3hjS3uva8pk1FI3iK9kCOKQdz1I9
Special thanks to my friend, Hemanand Vadivel (https://www.linkedin.com/in/hemanand-vadivel-0b34aab5/) who is an experienced data analyst manager working for a company in UK. He has a major contribution in this project.
Basics of DAX & Data Modelling are the two fundamental technical skills required to author Power BI reports – There are the free courses I recommend from SQLBI.com
DAX: https://www.sqlbi.com/p/introducing-dax-video-course/
Data Modelling: https://www.sqlbi.com/p/introduction-to-data-modeling-for-power-bi-video-course/
#️⃣ Social Media #️⃣
🔗 Discord: https://discord.gg/r42Kbuk
📸 Dhaval's Personal Instagram: https://www.instagram.com/dhavalsays/
📸 Instagram: https://www.instagram.com/codebasicshub/
🔊 Facebook: https://www.facebook.com/codebasicshub
📝 Linkedin (Personal): https://www.linkedin.com/in/dhavalsays/
📝 Linkedin (Codebasics): https://www.linkedin.com/company/codebasics/
📱 Twitter: https://twitter.com/codebasicshub
🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true
detail
{'title': 'Power BI Project For Beginners | Sales Insights Data Analysis Project - 5 - Build Dashboard', 'heatmap': [{'end': 735.412, 'start': 674.383, 'weight': 0.884}, {'end': 1310.458, 'start': 1280.153, 'weight': 0.846}, {'end': 2217.286, 'start': 2183.899, 'weight': 0.717}], 'summary': 'Covers data cleaning, currency cleanup, and dashboard building in power bi, including identifying and resolving currency duplications, cleaning duplicate records, building a power bi dashboard, visualizing sales data, tracking revenue by month, analyzing revenue data, and discussing power bi analytics and integration, with specific data details and adjustments mentioned for each chapter.', 'chapters': [{'end': 490.785, 'segs': [{'end': 26.209, 'src': 'embed', 'start': 0.229, 'weight': 4, 'content': [{'end': 4.312, 'text': 'in the last video we did some ETL and data cleaning in Power BI.', 'start': 0.229, 'duration': 4.083}, {'end': 12.078, 'text': "in this video we'll do a little bit more data cleaning and then we'll build our super cool Power BI dashboard.", 'start': 4.312, 'duration': 7.766}, {'end': 13.559, 'text': "so let's get started.", 'start': 12.078, 'duration': 1.481}, {'end': 15.04, 'text': 'in the last video,', 'start': 13.559, 'duration': 1.481}, {'end': 26.209, 'text': "some of you gave me a really good feedback on the data cleaning procedure and based on that feedback I will do some further more data cleaning and then we'll build our dashboard.", 'start': 15.04, 'duration': 11.169}], 'summary': 'In this video, we will do more data cleaning and then build a power bi dashboard based on feedback from the last video.', 'duration': 25.98, 'max_score': 0.229, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8229.jpg'}, {'end': 78.917, 'src': 'embed', 'start': 51.322, 'weight': 2, 'content': [{'end': 62.408, 'text': 'so when you go to mysql and run this query, select distinct currency from transaction, you are getting INR twice now.', 'start': 51.322, 'duration': 11.086}, {'end': 64.569, 'text': 'this is really really surprising.', 'start': 62.408, 'duration': 2.161}, {'end': 73.093, 'text': "what distinct query will do is it will give you unique currencies from your transaction table, but that's not what is happening here.", 'start': 64.569, 'duration': 8.524}, {'end': 78.917, 'text': "we have INR being duplicated two times, so Let's see.", 'start': 73.093, 'duration': 5.824}], 'summary': "Running 'select distinct currency from transaction' in mysql yields duplicate inr entries.", 'duration': 27.595, 'max_score': 51.322, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ851322.jpg'}, {'end': 194.942, 'src': 'embed', 'start': 110.863, 'weight': 1, 'content': [{'end': 122.373, 'text': 'okay, select count star from transaction where my transactions dot currency is equal to.', 'start': 110.863, 'duration': 11.51}, {'end': 133.02, 'text': "let's say this When you run it, you'll find that actually there are many transaction which has this currency problem.", 'start': 122.373, 'duration': 10.647}, {'end': 138.825, 'text': "One more thing I want to point out is see I'm not in my query.", 'start': 134.582, 'duration': 4.243}, {'end': 140.946, 'text': "I'm not doing sales dot transaction.", 'start': 138.865, 'duration': 2.081}, {'end': 143.889, 'text': 'In the previous tutorial I was doing sales dot transaction.', 'start': 141.307, 'duration': 2.582}, {'end': 152.465, 'text': 'here you have multiple schemas and what I did is I right click on the schema and I set that as a default schema.', 'start': 144.602, 'duration': 7.863}, {'end': 156.726, 'text': "once you set it, you don't have to write things like this.", 'start': 152.465, 'duration': 4.261}, {'end': 161.488, 'text': 'you know, in a previous tutorial we were writing sales dot, sales dot, everywhere.', 'start': 156.726, 'duration': 4.762}, {'end': 164.369, 'text': "now we don't have to write it, so it just saves you some time.", 'start': 161.488, 'duration': 2.881}, {'end': 166.05, 'text': 'so just a little tip.', 'start': 164.369, 'duration': 1.681}, {'end': 173.693, 'text': 'okay, talking about now currency Looks like this database has real problem now.', 'start': 166.05, 'duration': 7.643}, {'end': 180.376, 'text': "I'm happy that this problem occurred because in the real life these kind of issues will actually happen.", 'start': 174.573, 'duration': 5.803}, {'end': 182.757, 'text': 'And we need to tackle them.', 'start': 181.516, 'duration': 1.241}, {'end': 184.657, 'text': 'Now there are a couple of ways of tackling it.', 'start': 182.797, 'duration': 1.86}, {'end': 186.538, 'text': 'First you can go to your.', 'start': 185.038, 'duration': 1.5}, {'end': 194.942, 'text': 'Database or your Falcons engineering team and tell them you know your database has problems.', 'start': 188.699, 'duration': 6.243}], 'summary': 'Many transactions have currency problem. set default schema to save time. real-life issues need tackling.', 'duration': 84.079, 'max_score': 110.863, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8110863.jpg'}, {'end': 253.682, 'src': 'embed', 'start': 222.037, 'weight': 0, 'content': [{'end': 225.24, 'text': "This is what I'm concluding based on the situation.", 'start': 222.037, 'duration': 3.203}, {'end': 232.806, 'text': "OK, so what we'll do is we will filter any records which has INR or USD.", 'start': 225.92, 'duration': 6.886}, {'end': 250.419, 'text': 'So if you look at same thing, same thing is happening with USD where the number of records with USD are 2 and slash r are also 2.', 'start': 232.866, 'duration': 17.553}, {'end': 253.682, 'text': "Okay, let's look at those records actually.", 'start': 250.419, 'duration': 3.263}], 'summary': 'Filter records with inr or usd, 2 records with usd and slash r.', 'duration': 31.645, 'max_score': 222.037, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8222037.jpg'}], 'start': 0.229, 'title': 'Power bi data cleaning and database currency cleanup', 'summary': 'Covers further data cleaning based on feedback, including identifying and resolving currency duplications, and provides a time-saving tip for managing multiple schemas in power bi. additionally, it discusses identifying and removing duplicate currency records in a database, with 279 records of inr and 2 records of usd identified as potential duplicates, leading to a process of filtering and cleanup, ultimately resulting in a clean data set with 999+ rows.', 'chapters': [{'end': 166.05, 'start': 0.229, 'title': 'Power bi data cleaning and dashboard building', 'summary': 'Covers further data cleaning based on feedback, including identifying and resolving currency duplications, and provides a time-saving tip for managing multiple schemas in power bi.', 'duration': 165.821, 'highlights': ['Identified currency duplication issue with INR being duplicated two times in the transaction table.', 'Discovered numerous transactions affected by the currency problem.', 'Shared a time-saving tip for setting a default schema to avoid repetitive referencing in queries.']}, {'end': 490.785, 'start': 166.05, 'title': 'Database currency cleanup', 'summary': 'Discusses identifying and removing duplicate currency records in a database, with 279 records of inr and 2 records of usd identified as potential duplicates, leading to a process of filtering and cleanup, ultimately resulting in a clean data set with 999+ rows.', 'duration': 324.735, 'highlights': ['Identified 279 records with INR and 2 records with USD as potential duplicates, leading to a filtering process to remove them and resulting in a clean data set with 999+ rows.', 'Discussed the process of identifying and removing duplicate records, emphasizing the need to handle real-life database issues and the importance of tackling such problems.', 'Explained the step-by-step process of data transformation using Power BI, including removing specific values, adding filters, and normalizing data for cleanup.']}], 'duration': 490.556, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8229.jpg', 'highlights': ['Identified 279 records with INR and 2 records with USD as potential duplicates, leading to a filtering process to remove them and resulting in a clean data set with 999+ rows.', 'Discovered numerous transactions affected by the currency problem.', 'Identified currency duplication issue with INR being duplicated two times in the transaction table.', 'Shared a time-saving tip for setting a default schema to avoid repetitive referencing in queries.', 'Explained the step-by-step process of data transformation using Power BI, including removing specific values, adding filters, and normalizing data for cleanup.', 'Discussed the process of identifying and removing duplicate records, emphasizing the need to handle real-life database issues and the importance of tackling such problems.']}, {'end': 667.164, 'segs': [{'end': 517.827, 'src': 'embed', 'start': 490.785, 'weight': 0, 'content': [{'end': 500.447, 'text': 'now. uh, here also, and from this formula, i will remove this currency, because now usd is not there, we have only usd.', 'start': 490.785, 'duration': 9.662}, {'end': 500.887, 'text': 'uh, this one.', 'start': 500.447, 'duration': 0.44}, {'end': 515.105, 'text': 'Okay, and you can see that when you have USD 500, you already convert it into you, multiply it by 75 and convert it into Indian currency.', 'start': 503.157, 'duration': 11.948}, {'end': 517.827, 'text': 'Now going back to the awesome comments.', 'start': 515.385, 'duration': 2.442}], 'summary': 'Usd 500 converted to indian currency at an exchange rate of 75.', 'duration': 27.042, 'max_score': 490.785, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8490785.jpg'}, {'end': 667.164, 'src': 'embed', 'start': 606.997, 'weight': 1, 'content': [{'end': 610.579, 'text': 'Maybe based on a situation, it might be a good idea to use median value.', 'start': 606.997, 'duration': 3.582}, {'end': 616.663, 'text': "But in this situation, I will actually go to Falcon's engineering team.", 'start': 610.659, 'duration': 6.004}, {'end': 623.127, 'text': 'I will report to them that there are some transaction records where the amount is zero.', 'start': 617.364, 'duration': 5.763}, {'end': 627.849, 'text': 'Usually, if you are selling something, there will be some positive price to it.', 'start': 624.308, 'duration': 3.541}, {'end': 630.37, 'text': 'And that is not happening.', 'start': 629.25, 'duration': 1.12}, {'end': 631.911, 'text': "So I'll probably report to them.", 'start': 630.59, 'duration': 1.321}, {'end': 633.511, 'text': 'Maybe there are database issues.', 'start': 632.031, 'duration': 1.48}, {'end': 634.491, 'text': 'Maybe they will fix it.', 'start': 633.571, 'duration': 0.92}, {'end': 639.693, 'text': 'But going by median is kind of in this situation.', 'start': 636.152, 'duration': 3.541}, {'end': 642.414, 'text': "I don't think personally it's appropriate.", 'start': 639.853, 'duration': 2.561}, {'end': 653.075, 'text': 'OK, looking back and so I already took care of filtering the duplicate records based on currency.', 'start': 643.829, 'duration': 9.246}, {'end': 654.956, 'text': 'OK, great.', 'start': 654.436, 'duration': 0.52}, {'end': 659.799, 'text': 'So again, thank you very much guys for your extremely useful comments.', 'start': 655.496, 'duration': 4.303}, {'end': 667.164, 'text': 'So now at this stage your data is properly cleaned.', 'start': 660.359, 'duration': 6.805}], 'summary': "Reporting zero amount transaction records to falcon's engineering team for resolution.", 'duration': 60.167, 'max_score': 606.997, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8606997.jpg'}], 'start': 490.785, 'title': 'Currency conversion and data cleaning', 'summary': 'Discusses currency conversion using a multiplier of 75, considerations for using median value for zero sales amounts, and the process of cleaning duplicate records to ensure proper data validation.', 'chapters': [{'end': 667.164, 'start': 490.785, 'title': 'Currency conversion and data cleaning', 'summary': 'Discusses currency conversion using a multiplier of 75, considerations for using median value for zero sales amounts, and the process of cleaning duplicate records to ensure proper data validation.', 'duration': 176.379, 'highlights': ['The chapter discusses the process of cleaning duplicate records based on currency, ensuring proper data validation. (Relevance: 5)', 'The conversion of USD 500 into Indian currency involves multiplying by 75, indicating a specific conversion process. (Relevance: 4)', 'Consideration for using median value instead of filtering zero sales amounts, with a decision to report the issue to the engineering team for resolution. (Relevance: 3)']}], 'duration': 176.379, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8490785.jpg', 'highlights': ['The conversion of USD 500 into Indian currency involves multiplying by 75, indicating a specific conversion process.', 'The chapter discusses the process of cleaning duplicate records based on currency, ensuring proper data validation.', 'Consideration for using median value instead of filtering zero sales amounts, with a decision to report the issue to the engineering team for resolution.']}, {'end': 904.223, 'segs': [{'end': 735.412, 'src': 'heatmap', 'start': 674.383, 'weight': 0.884, 'content': [{'end': 679.045, 'text': 'And what this is going to do is it will apply all those transformation.', 'start': 674.383, 'duration': 4.662}, {'end': 682.327, 'text': 'And now we are going back to our Power BI dashboard.', 'start': 679.645, 'duration': 2.682}, {'end': 685.708, 'text': 'And now we will start building our dashboard.', 'start': 682.407, 'duration': 3.301}, {'end': 692.692, 'text': 'We are done with our data cleaning and ETL and now starts the most interesting part, which is building the actual dashboard.', 'start': 686.429, 'duration': 6.263}, {'end': 695.733, 'text': 'So first thing I will do is click on enter data.', 'start': 693.192, 'duration': 2.541}, {'end': 702.217, 'text': 'and enter a new table called base measures.', 'start': 697.715, 'duration': 4.502}, {'end': 704.238, 'text': 'I will explain what this is.', 'start': 702.938, 'duration': 1.3}, {'end': 714.723, 'text': 'So we are creating base measures in this table, which we will use to plot different UI elements on our dashboard.', 'start': 704.939, 'duration': 9.784}, {'end': 718.505, 'text': 'So once base measure is created, it will appear here.', 'start': 715.444, 'duration': 3.061}, {'end': 722.567, 'text': 'So you can click on three dots here and say new measure.', 'start': 718.565, 'duration': 4.002}, {'end': 727.607, 'text': 'So new measure is basically revenue.', 'start': 725.666, 'duration': 1.941}, {'end': 735.412, 'text': 'OK, and what is revenue? So revenue is a sum of our revenue column.', 'start': 728.788, 'duration': 6.624}], 'summary': 'In power bi, data cleaning and etl are done, now focusing on building the dashboard with base measures and revenue calculations.', 'duration': 61.029, 'max_score': 674.383, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8674383.jpg'}, {'end': 727.607, 'src': 'embed', 'start': 693.192, 'weight': 0, 'content': [{'end': 695.733, 'text': 'So first thing I will do is click on enter data.', 'start': 693.192, 'duration': 2.541}, {'end': 702.217, 'text': 'and enter a new table called base measures.', 'start': 697.715, 'duration': 4.502}, {'end': 704.238, 'text': 'I will explain what this is.', 'start': 702.938, 'duration': 1.3}, {'end': 714.723, 'text': 'So we are creating base measures in this table, which we will use to plot different UI elements on our dashboard.', 'start': 704.939, 'duration': 9.784}, {'end': 718.505, 'text': 'So once base measure is created, it will appear here.', 'start': 715.444, 'duration': 3.061}, {'end': 722.567, 'text': 'So you can click on three dots here and say new measure.', 'start': 718.565, 'duration': 4.002}, {'end': 727.607, 'text': 'So new measure is basically revenue.', 'start': 725.666, 'duration': 1.941}], 'summary': 'Creating a table for base measures to plot ui elements on a dashboard and adding a new measure for revenue.', 'duration': 34.415, 'max_score': 693.192, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8693192.jpg'}, {'end': 904.223, 'src': 'embed', 'start': 762.178, 'weight': 1, 'content': [{'end': 769.78, 'text': 'So the sales director of this company is interested in tracking the revenue numbers as well as sales quantity.', 'start': 762.178, 'duration': 7.602}, {'end': 774.801, 'text': 'So I will say sales quantity is equal to what?', 'start': 769.78, 'duration': 5.021}, {'end': 781.323, 'text': 'Okay, is transactions Transactions has a sales quantity column.', 'start': 775.602, 'duration': 5.721}, {'end': 790.329, 'text': 'Hit enter and now your measure is created so you can drag and drop revenue here.', 'start': 783.086, 'duration': 7.243}, {'end': 796.391, 'text': 'And here are the different visualization.', 'start': 793.95, 'duration': 2.441}, {'end': 801.593, 'text': 'So by default is showing it as a bar chart, but you can make it a card.', 'start': 796.411, 'duration': 5.182}, {'end': 805.654, 'text': 'So if you click this, it will actually show you the numbers.', 'start': 801.973, 'duration': 3.681}, {'end': 810.696, 'text': 'Now, this number is actually the sum of all the sales.', 'start': 805.774, 'duration': 4.922}, {'end': 812.177, 'text': 'So this is a total revenue.', 'start': 810.776, 'duration': 1.401}, {'end': 816.752, 'text': 'our database across all the years.', 'start': 813.61, 'duration': 3.142}, {'end': 830.399, 'text': "now, when you have any element selected, you can control the visual properties by going here, clicking on format, and let's see.", 'start': 816.752, 'duration': 13.647}, {'end': 835.602, 'text': "so for this guy, I'm going here and general.", 'start': 830.399, 'duration': 5.203}, {'end': 842.735, 'text': 'OK, so general is this will just explore different options here.', 'start': 838.268, 'duration': 4.467}, {'end': 844.938, 'text': 'So data label.', 'start': 844.077, 'duration': 0.861}, {'end': 847.361, 'text': 'So data label size.', 'start': 846.079, 'duration': 1.282}, {'end': 850.566, 'text': "Let's say I want to make it 35.", 'start': 847.441, 'duration': 3.125}, {'end': 851.888, 'text': "I'm just making it a little smaller.", 'start': 850.566, 'duration': 1.322}, {'end': 857.227, 'text': 'OK, and you can put it here.', 'start': 854.665, 'duration': 2.562}, {'end': 860.509, 'text': 'Now there is a canvas size so you see this borderline.', 'start': 857.747, 'duration': 2.762}, {'end': 862.55, 'text': 'So you click here in the empty area.', 'start': 860.549, 'duration': 2.001}, {'end': 866.592, 'text': 'Go here and if you want to change the page size.', 'start': 863.43, 'duration': 3.162}, {'end': 871.235, 'text': 'Right now 16.9 if you do 4 by 3 say it is changing.', 'start': 867.733, 'duration': 3.502}, {'end': 874.637, 'text': "So I'm keeping 16 by 9.", 'start': 873.296, 'duration': 1.341}, {'end': 880.84, 'text': "if you want to change it to custom and let's say maybe increase, let's say hide a little bit because I see some white space here.", 'start': 874.637, 'duration': 6.203}, {'end': 883.142, 'text': 'So maybe I will make it.', 'start': 881.701, 'duration': 1.441}, {'end': 894.857, 'text': "850 and this one I will make it maybe let's say 1350.", 'start': 887.152, 'duration': 7.705}, {'end': 897.258, 'text': "See now it's covering the entire canvas.", 'start': 894.857, 'duration': 2.401}, {'end': 901.921, 'text': 'Now you can do control C control V.', 'start': 898.879, 'duration': 3.042}, {'end': 904.223, 'text': 'And put this here next to this.', 'start': 901.921, 'duration': 2.302}], 'summary': 'Sales director tracks revenue and sales quantity using visualization tools for database analysis.', 'duration': 142.045, 'max_score': 762.178, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8762178.jpg'}], 'start': 667.484, 'title': 'Power bi dashboard building and customization', 'summary': 'Covers the process of building a power bi dashboard, including base measures creation, revenue and sales quantity measures definition, and various visualization types. it also discusses customizing canvas size, data labels, with specific adjustments mentioned such as data label size to 35 and canvas size to 850x1350.', 'chapters': [{'end': 830.399, 'start': 667.484, 'title': 'Building power bi dashboard', 'summary': 'Covers the process of building a power bi dashboard, including creating base measures, defining revenue and sales quantity measures, and visualizing the data with different visualization types.', 'duration': 162.915, 'highlights': ['The process starts with creating base measures for plotting different UI elements on the dashboard, including defining revenue as the sum of the revenue column and sales quantity based on the sales quantity column.', "The chapter emphasizes the importance of tracking revenue numbers and sales quantity, with specific measures created to fulfill the sales director's interest.", 'The visualization of data is demonstrated through different visualization types, such as bar chart and card, providing a comprehensive understanding of the total revenue across all the years.']}, {'end': 904.223, 'start': 830.399, 'title': 'Customizing canvas size and data labels', 'summary': 'Discusses customizing canvas size and data labels, including adjusting the size of data labels to 35, changing canvas size to 850x1350, and navigating options for page size.', 'duration': 73.824, 'highlights': ['Adjusting the size of data labels to 35.', 'Changing canvas size to 850x1350 to cover the entire canvas.', 'Navigating options for page size, including switching between 16.9 and 4 by 3.']}], 'duration': 236.739, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8667484.jpg', 'highlights': ['The process starts with creating base measures for plotting different UI elements on the dashboard, including defining revenue as the sum of the revenue column and sales quantity based on the sales quantity column.', "The chapter emphasizes the importance of tracking revenue numbers and sales quantity, with specific measures created to fulfill the sales director's interest.", 'The visualization of data is demonstrated through different visualization types, such as bar chart and card, providing a comprehensive understanding of the total revenue across all the years.', 'Adjusting the size of data labels to 35.', 'Changing canvas size to 850x1350 to cover the entire canvas.', 'Navigating options for page size, including switching between 16.9 and 4 by 3.']}, {'end': 1378.571, 'segs': [{'end': 936.893, 'src': 'embed', 'start': 906.124, 'weight': 0, 'content': [{'end': 912.568, 'text': 'And this can be a sales quantity so you can just drag and drop sales quantity here in the field section.', 'start': 906.124, 'duration': 6.444}, {'end': 919.346, 'text': 'OK, and you see we sold two millions of sales quantity so far.', 'start': 914.304, 'duration': 5.042}, {'end': 920.807, 'text': 'So this is very easy.', 'start': 919.946, 'duration': 0.861}, {'end': 927.789, 'text': 'You have visual section, you have all the fields going on here and there is a formatting here.', 'start': 920.827, 'duration': 6.962}, {'end': 931.471, 'text': 'There is analytics, you know, different options.', 'start': 928.81, 'duration': 2.661}, {'end': 936.893, 'text': "OK, now I'm going to again control C control V.", 'start': 932.531, 'duration': 4.362}], 'summary': 'Sold 2 million of sales quantity, with easy visual and analytics options.', 'duration': 30.769, 'max_score': 906.124, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8906124.jpg'}, {'end': 1053.463, 'src': 'embed', 'start': 1019.08, 'weight': 3, 'content': [{'end': 1020.14, 'text': 'And you know how to.', 'start': 1019.08, 'duration': 1.06}, {'end': 1024.364, 'text': 'So when you click on this visual element, you know where to go to format it.', 'start': 1020.461, 'duration': 3.903}, {'end': 1027.444, 'text': 'This particular option you have to use to format it.', 'start': 1024.964, 'duration': 2.48}, {'end': 1031.808, 'text': 'From x-axis, I will remove this.', 'start': 1029.046, 'duration': 2.762}, {'end': 1037.15, 'text': 'When I click on this, you see that little thing went away.', 'start': 1031.907, 'duration': 5.243}, {'end': 1042.593, 'text': 'Also from x-axis, there is this revenue label.', 'start': 1037.991, 'duration': 4.602}, {'end': 1043.454, 'text': "I don't like this.", 'start': 1042.673, 'duration': 0.781}, {'end': 1046.015, 'text': 'So I will just remove that as well.', 'start': 1043.513, 'duration': 2.502}, {'end': 1053.463, 'text': 'And from y-axis, I will also remove this customer underscore name.', 'start': 1047.779, 'duration': 5.684}], 'summary': 'The speaker explains how to format visual elements by removing specific options from the x-axis and y-axis.', 'duration': 34.383, 'max_score': 1019.08, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81019080.jpg'}, {'end': 1147.388, 'src': 'embed', 'start': 1086.04, 'weight': 1, 'content': [{'end': 1088.982, 'text': 'So when you do data label on, it will start showing these numbers.', 'start': 1086.04, 'duration': 2.942}, {'end': 1090.463, 'text': 'Now these numbers are in billion.', 'start': 1089.082, 'duration': 1.381}, {'end': 1094.466, 'text': 'So I want to change the value basically.', 'start': 1091.023, 'duration': 3.443}, {'end': 1101.672, 'text': 'So what you can do is you can say, okay, display units is millions.', 'start': 1095.227, 'duration': 6.445}, {'end': 1112.98, 'text': 'so electric sara stores gave me a revenue of 413 million dollar to a million rupees totally.', 'start': 1104.016, 'duration': 8.964}, {'end': 1120.404, 'text': 'then electristical gave me 49.64 million.', 'start': 1112.98, 'duration': 7.424}, {'end': 1126.927, 'text': 'so when you click on this, it will update all the graphs, because you have all these relationships set up.', 'start': 1120.404, 'duration': 6.523}, {'end': 1130.849, 'text': 'when you click on the same thing again, it will uncheck.', 'start': 1126.927, 'duration': 3.922}, {'end': 1132.53, 'text': 'so you go back to your previous view.', 'start': 1130.849, 'duration': 1.681}, {'end': 1147.388, 'text': 'I will do control C, control V again, and here I will say I will make the same chart, but using a quantity.', 'start': 1134.298, 'duration': 13.09}], 'summary': 'Data labels show revenue in millions and billions, with specific numbers provided for two stores.', 'duration': 61.348, 'max_score': 1086.04, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81086040.jpg'}, {'end': 1348.859, 'src': 'heatmap', 'start': 1280.153, 'weight': 2, 'content': [{'end': 1281.333, 'text': "Let's see.", 'start': 1280.153, 'duration': 1.18}, {'end': 1282.214, 'text': 'What should I do??', 'start': 1281.453, 'duration': 0.761}, {'end': 1288.554, 'text': 'slicer okay and you say list.', 'start': 1284.773, 'duration': 3.781}, {'end': 1293.335, 'text': 'so it is showing you the yours in the list.', 'start': 1288.554, 'duration': 4.781}, {'end': 1310.458, 'text': 'and once you have yours in the list, what you need to do is go here and orientation chain to horizontal.', 'start': 1293.335, 'duration': 17.123}, {'end': 1315.227, 'text': 'so now you got this four buttons for your years.', 'start': 1310.458, 'duration': 4.769}, {'end': 1337.007, 'text': "okay, so let's put this here and let's see okay, now, when you click on 2020, it will actually show you 2020 revenue.", 'start': 1315.227, 'duration': 21.78}, {'end': 1337.688, 'text': 'so how do you know?', 'start': 1337.007, 'duration': 0.681}, {'end': 1338.629, 'text': '2020 revenue is 142 million.', 'start': 1337.688, 'duration': 0.941}, {'end': 1343.954, 'text': 'You can always go to MySQL.', 'start': 1341.485, 'duration': 2.469}, {'end': 1346.038, 'text': 'OK here.', 'start': 1345.478, 'duration': 0.56}, {'end': 1348.859, 'text': 'And you can verify that.', 'start': 1347.079, 'duration': 1.78}], 'summary': 'Demonstration of data visualization tool with $142 million 2020 revenue shown', 'duration': 55.524, 'max_score': 1280.153, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81280153.jpg'}], 'start': 906.124, 'title': 'Visualizing sales data and customizing charts', 'summary': 'Demonstrates visualizing 2 million sales quantity and revenue details for specific customers and discusses updating graphs with interactivity, customizing chart titles, and tracking revenue numbers by year, with a demonstration of verifying revenue data using a mysql query.', 'chapters': [{'end': 1120.404, 'start': 906.124, 'title': 'Visualizing sales data and revenue by customer', 'summary': 'Demonstrates how to visualize sales quantity and revenue by customer, showing 2 million sales quantity and revenue details for specific customers, with formatting and data label adjustments.', 'duration': 214.28, 'highlights': ['The chapter shows how to visualize 2 million sales quantity and revenue details for specific customers, with formatting and data label adjustments.', 'Detailed steps on formatting visual elements to remove unwanted labels and customize axis for revenue visualization.', 'Explanation of data label adjustments to display revenue numbers in millions for each customer.']}, {'end': 1378.571, 'start': 1120.404, 'title': 'Updating graphs and customizing charts', 'summary': 'Discusses updating graphs with interactivity, customizing chart titles, and tracking revenue numbers by year, with a demonstration of how to verify revenue data using a mysql query.', 'duration': 258.167, 'highlights': ['Demonstrating how to update graphs with interactivity and customize chart titles', 'Tracking revenue numbers by year and verifying data using a MySQL query']}], 'duration': 472.447, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ8906124.jpg', 'highlights': ['Visualizing 2 million sales quantity and revenue details for specific customers', 'Updating graphs with interactivity and customizing chart titles', 'Tracking revenue numbers by year and verifying data using a MySQL query', 'Formatting visual elements to remove unwanted labels and customize axis for revenue visualization', 'Data label adjustments to display revenue numbers in millions for each customer']}, {'end': 1602.443, 'segs': [{'end': 1579.811, 'src': 'embed', 'start': 1499.964, 'weight': 0, 'content': [{'end': 1511.624, 'text': 'So when you do that, when you apply that format, you see, the dates are now changed to Jan 18, 18 is 2018, January 2018..', 'start': 1499.964, 'duration': 11.66}, {'end': 1512.284, 'text': 'I hope you get it.', 'start': 1511.624, 'duration': 0.66}, {'end': 1517.585, 'text': 'So similarly, if you have, you know, like April, May, whatever.', 'start': 1513.624, 'duration': 3.961}, {'end': 1519.826, 'text': 'And then when you go here.', 'start': 1518.526, 'duration': 1.3}, {'end': 1523.547, 'text': 'See now now your dashboard is much cleaner.', 'start': 1521.026, 'duration': 2.521}, {'end': 1529.668, 'text': 'So now if you want to look at revenue in the same month of January, the revenue is 25.66.', 'start': 1523.887, 'duration': 5.781}, {'end': 1533.169, 'text': 'So we saw right the 2020 revenue was 142.', 'start': 1529.668, 'duration': 3.501}, {'end': 1534.73, 'text': 'And if you want to go to January.', 'start': 1533.169, 'duration': 1.561}, {'end': 1542.742, 'text': 'January revenue is 25.66.', 'start': 1541.081, 'duration': 1.661}, {'end': 1545.504, 'text': "Okay I don't trust Power BI.", 'start': 1542.742, 'duration': 2.762}, {'end': 1546.625, 'text': 'I want to verify.', 'start': 1545.544, 'duration': 1.081}, {'end': 1548.706, 'text': 'Cool You can verify.', 'start': 1547.345, 'duration': 1.361}, {'end': 1550.508, 'text': 'SQL is your friend.', 'start': 1548.726, 'duration': 1.782}, {'end': 1562.076, 'text': 'So again here, if see the same query that we used for 2020, we are just adding a month January in the query.', 'start': 1551.889, 'duration': 10.187}, {'end': 1570.742, 'text': 'Okay So this query we are adding just a month.', 'start': 1564.357, 'duration': 6.385}, {'end': 1579.811, 'text': 'okay. so, by the way, this query is not hard.', 'start': 1574.705, 'duration': 5.106}], 'summary': 'Applying date format, revenue in january: 25.66, 2020 revenue: 142. sql query for january revenue.', 'duration': 79.847, 'max_score': 1499.964, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81499964.jpg'}], 'start': 1378.671, 'title': 'Tracking revenue by month in power bi', 'summary': 'Demonstrates how to track revenue by month in power bi, including changing date formats, filtering data by month, and verifying revenue data using sql.', 'chapters': [{'end': 1602.443, 'start': 1378.671, 'title': 'Tracking revenue by month in power bi', 'summary': 'Demonstrates how to track revenue by month in power bi, including changing date formats, filtering data by month, and verifying revenue data using sql.', 'duration': 223.772, 'highlights': ['The revenue for January 2020 was 25.66, and the total revenue for 2020 was 142.', 'Demonstrating the process of changing date formats to display months in a cleaner dashboard view.', 'Using SQL to verify revenue data and adding a month filter to the query for verification.']}], 'duration': 223.772, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81378671.jpg', 'highlights': ['The total revenue for 2020 was 142.', 'Demonstrating the process of changing date formats to display months in a cleaner dashboard view.', 'Using SQL to verify revenue data and adding a month filter to the query for verification.', 'The revenue for January 2020 was 25.66.']}, {'end': 2098.749, 'segs': [{'end': 1708.206, 'src': 'embed', 'start': 1643.079, 'weight': 0, 'content': [{'end': 1646.041, 'text': "Let's say I want to do 2019.", 'start': 1643.079, 'duration': 2.962}, {'end': 1651.925, 'text': 'How many, how much was my revenue in 2019? Well, it was more, see my business is declining, 336 million.', 'start': 1646.041, 'duration': 5.884}, {'end': 1662.855, 'text': 'So if you look at here, In the so, by the way, if you want to unselect this seed on this black box, just click again.', 'start': 1651.965, 'duration': 10.89}, {'end': 1665.897, 'text': 'It will unselect them from 2020.', 'start': 1663.095, 'duration': 2.802}, {'end': 1668.339, 'text': 'My revenue was 142 million rupees.', 'start': 1665.897, 'duration': 2.442}, {'end': 1671.901, 'text': 'I want to go to 2019.', 'start': 1669.299, 'duration': 2.602}, {'end': 1674.943, 'text': 'And I find three hundred thirty six point zero two million.', 'start': 1671.901, 'duration': 3.042}, {'end': 1682.949, 'text': 'Which is what I have here, three hundred thirty six point zero to nine rounded to whatever.', 'start': 1676.164, 'duration': 6.785}, {'end': 1689.896, 'text': 'OK So looks like the setup that I did is kind of working.', 'start': 1684.173, 'duration': 5.723}, {'end': 1695.659, 'text': 'Now we will add couple of more things so.', 'start': 1690.837, 'duration': 4.822}, {'end': 1700.001, 'text': "Let's see what we want to add.", 'start': 1697.06, 'duration': 2.941}, {'end': 1701.402, 'text': 'You know what I will do is.', 'start': 1700.361, 'duration': 1.041}, {'end': 1708.206, 'text': 'Here instead of customer, maybe I will change it to by region.', 'start': 1702.903, 'duration': 5.303}], 'summary': 'In 2019, the revenue was 336 million rupees, but in 2020, it declined to 142 million rupees.', 'duration': 65.127, 'max_score': 1643.079, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81643079.jpg'}, {'end': 1786.891, 'src': 'embed', 'start': 1743.337, 'weight': 3, 'content': [{'end': 1746.979, 'text': "So now let's verify revenue in maybe Chennai.", 'start': 1743.337, 'duration': 3.642}, {'end': 1756.46, 'text': 'So in 2020 out of 142 million, Chen gave me 2.46 million.', 'start': 1747.879, 'duration': 8.581}, {'end': 1762.606, 'text': 'So again if you want to verify that you can go to my git this page.', 'start': 1758.221, 'duration': 4.385}, {'end': 1769.012, 'text': "And it's like a similar query just I am putting a market code.", 'start': 1764.467, 'duration': 4.545}, {'end': 1780.086, 'text': 'am putting a market code of mark zero, zero one, because mark zero, zero one is chennai.', 'start': 1771.5, 'duration': 8.586}, {'end': 1783.349, 'text': 'so when you execute this, you get 2.46.', 'start': 1780.086, 'duration': 3.263}, {'end': 1786.891, 'text': 'see so 2.46, 2.46.', 'start': 1783.349, 'duration': 3.542}], 'summary': 'In 2020, chennai contributed 2.46 million out of 142 million in revenue.', 'duration': 43.554, 'max_score': 1743.337, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81743337.jpg'}, {'end': 1940.683, 'src': 'embed', 'start': 1857.204, 'weight': 2, 'content': [{'end': 1868.372, 'text': 'and here now i want to show my top five customers you know the top five customers who who are giving me the most of the business.', 'start': 1857.204, 'duration': 11.168}, {'end': 1877.998, 'text': 'i care about those a lot, so you can First of all change from market name to customer name here.', 'start': 1868.372, 'duration': 9.626}, {'end': 1879.799, 'text': 'So these are the customer.', 'start': 1878.818, 'duration': 0.981}, {'end': 1884.821, 'text': 'And now you can go to go to what? OK.', 'start': 1880.719, 'duration': 4.102}, {'end': 1887.563, 'text': 'Go to hear customer name.', 'start': 1886.022, 'duration': 1.541}, {'end': 1889.284, 'text': 'I want to.', 'start': 1888.603, 'duration': 0.681}, {'end': 1894.546, 'text': 'Select top five customer, top five customer.', 'start': 1890.964, 'duration': 3.582}, {'end': 1899.849, 'text': 'OK, but by what criteria I want to select top five customer by revenue.', 'start': 1894.566, 'duration': 5.283}, {'end': 1912.155, 'text': 'apply filter and it will show me the top five customers, top five customers by revenue.', 'start': 1903.49, 'duration': 8.665}, {'end': 1916.717, 'text': 'So again, click on this element, go here, change the title.', 'start': 1912.215, 'duration': 4.502}, {'end': 1921.5, 'text': 'OK, what is my title? OK.', 'start': 1918.378, 'duration': 3.122}, {'end': 1924.802, 'text': 'Top five customers.', 'start': 1923.301, 'duration': 1.501}, {'end': 1930.585, 'text': 'Well, by revenue.', 'start': 1929.444, 'duration': 1.141}, {'end': 1934.637, 'text': 'Whatever Top five customers.', 'start': 1933.396, 'duration': 1.241}, {'end': 1935.738, 'text': 'Okay Sounds good.', 'start': 1934.737, 'duration': 1.001}, {'end': 1940.683, 'text': 'Now see, these customer names are not visible properly.', 'start': 1936.119, 'duration': 4.564}], 'summary': 'Showing top 5 customers by revenue criteria.', 'duration': 83.479, 'max_score': 1857.204, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81857204.jpg'}], 'start': 1603.464, 'title': 'Revenue and sales dashboard analysis', 'summary': 'Involves analyzing revenue data for 2019 and 2020, showing a decline from 336 million to 142 million rupees. it also discusses optimizing a sales dashboard, including customer and product segmentation.', 'chapters': [{'end': 1823.224, 'start': 1603.464, 'title': 'Revenue analysis and data verification', 'summary': 'Involves analyzing revenue data for 2019 and 2020, showing a decline from 336 million to 142 million rupees, with detailed steps on data verification and modification, including a transition from customer-based analysis to region-based analysis.', 'duration': 219.76, 'highlights': ['The revenue declined from 336 million to 142 million rupees from 2019 to 2020.', 'Detailed steps on data verification and modification, including transition from customer-based analysis to region-based analysis.', 'Verification of revenue in Chennai showed 2.46 million rupees for 2020.', 'Explanation on how to verify market code for Chennai and emphasis on data integrity.', 'Importance of trusting data for accurate analysis and decision-making.']}, {'end': 2098.749, 'start': 1823.224, 'title': 'Sales dashboard optimization', 'summary': 'Discusses the optimization of a sales dashboard, including changing titles, selecting top customers and products by revenue, and addressing data visibility issues.', 'duration': 275.525, 'highlights': ['The chapter discusses the optimization of a sales dashboard, including changing titles, selecting top customers and products by revenue, and addressing data visibility issues.', 'The speaker emphasizes the importance of displaying the top five customers and products by revenue, indicating a focus on key business contributors.', 'The process of increasing the visibility of customer names on the dashboard is highlighted, demonstrating a practical solution to data presentation issues.', 'The speaker encounters a blank product code in the database, prompting a discussion on real-life data issues and the need for collaboration with the engineering team for resolution.']}], 'duration': 495.285, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ81603464.jpg', 'highlights': ['The revenue declined from 336 million to 142 million rupees from 2019 to 2020.', 'Detailed steps on data verification and modification, including transition from customer-based analysis to region-based analysis.', 'The chapter discusses the optimization of a sales dashboard, including changing titles, selecting top customers and products by revenue, and addressing data visibility issues.', 'Verification of revenue in Chennai showed 2.46 million rupees for 2020.', 'The speaker emphasizes the importance of displaying the top five customers and products by revenue, indicating a focus on key business contributors.']}, {'end': 2510.014, 'segs': [{'end': 2267.301, 'src': 'heatmap', 'start': 2183.899, 'weight': 1, 'content': [{'end': 2185.62, 'text': 'See why date sounds interesting.', 'start': 2183.899, 'duration': 1.721}, {'end': 2189.523, 'text': 'So I will put see why date as my why.', 'start': 2186.841, 'duration': 2.682}, {'end': 2192.926, 'text': 'Click here and click see by date.', 'start': 2190.364, 'duration': 2.562}, {'end': 2197.289, 'text': 'And it kind of shows you a nice beautiful chart.', 'start': 2193.987, 'duration': 3.302}, {'end': 2204.135, 'text': 'I like color, so I will just change the color to be OK.', 'start': 2198.71, 'duration': 5.425}, {'end': 2207.337, 'text': 'Which one is your favorite? You know, make it like very fancy.', 'start': 2204.195, 'duration': 3.142}, {'end': 2208.398, 'text': 'Make it like a rainbow.', 'start': 2207.517, 'duration': 0.881}, {'end': 2217.286, 'text': "And okay, let's remove this X and Y these unnecessary things.", 'start': 2210.34, 'duration': 6.946}, {'end': 2219.328, 'text': "Okay, so let's first change the title.", 'start': 2217.366, 'duration': 1.962}, {'end': 2222.55, 'text': 'So I will go to title title title title.', 'start': 2219.348, 'duration': 3.202}, {'end': 2229.576, 'text': 'Where is my title? Okay, this chart is nothing but a revenue trend.', 'start': 2222.81, 'duration': 6.766}, {'end': 2232.858, 'text': 'Very good.', 'start': 2231.938, 'duration': 0.92}, {'end': 2233.779, 'text': 'Good job guys.', 'start': 2232.939, 'duration': 0.84}, {'end': 2235.661, 'text': 'We are doing so good so far.', 'start': 2233.839, 'duration': 1.822}, {'end': 2239.444, 'text': "Hmm, Don't you think power bi is so cool?", 'start': 2235.681, 'duration': 3.763}, {'end': 2242.019, 'text': "it is, it's.", 'start': 2240.999, 'duration': 1.02}, {'end': 2246.301, 'text': "it's much better than our boring mysql, where you see just the numbers.", 'start': 2242.019, 'duration': 4.282}, {'end': 2251.804, 'text': 'here you know, you see charts and you see colors and you see interactivity.', 'start': 2246.301, 'duration': 5.503}, {'end': 2257.346, 'text': "okay, now i'm going to you see this cy underscore, date and revenue vertically.", 'start': 2251.804, 'duration': 5.542}, {'end': 2258.686, 'text': 'i mean i have revenue trend.', 'start': 2257.346, 'duration': 1.34}, {'end': 2262.028, 'text': 'why the heck you need all these two labels?', 'start': 2258.686, 'duration': 3.342}, {'end': 2266.34, 'text': 'hmm, So I will say x axis for x axis.', 'start': 2262.028, 'duration': 4.312}, {'end': 2267.301, 'text': "I don't need a title.", 'start': 2266.4, 'duration': 0.901}], 'summary': 'Data visualization in power bi enhances user experience and presents revenue trend effectively.', 'duration': 59.784, 'max_score': 2183.899, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ82183899.jpg'}, {'end': 2348.264, 'src': 'embed', 'start': 2301.491, 'weight': 0, 'content': [{'end': 2305.933, 'text': 'At some point I had 425 million revenue.', 'start': 2301.491, 'duration': 4.442}, {'end': 2314.738, 'text': 'Right And then now the revenue numbers are kind of declining.', 'start': 2309.035, 'duration': 5.703}, {'end': 2326.86, 'text': "So not 425, sorry, it's 42, 42 million actually.", 'start': 2320.859, 'duration': 6.001}, {'end': 2338.182, 'text': 'Yeah So if you want to verify, see January, I just want to verify that this graph is correct.', 'start': 2332.541, 'duration': 5.641}, {'end': 2343.063, 'text': "So January it's saying 25 million, see 25 after that you heard.", 'start': 2338.242, 'duration': 4.821}, {'end': 2344.363, 'text': "So let's see January.", 'start': 2343.103, 'duration': 1.26}, {'end': 2347.044, 'text': 'See January 25.', 'start': 2345.463, 'duration': 1.581}, {'end': 2348.264, 'text': 'Cool So this is correct.', 'start': 2347.044, 'duration': 1.22}], 'summary': "Revenue declined from 425 million to 42 million, with january's figure at 25 million.", 'duration': 46.773, 'max_score': 2301.491, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ82301491.jpg'}, {'end': 2491.868, 'src': 'embed', 'start': 2413.138, 'weight': 3, 'content': [{'end': 2423.644, 'text': 'but now data analyst can build this dashboard and this dashboard can be integrated into your main web page, into your mobile application.', 'start': 2413.138, 'duration': 10.506}, {'end': 2429.848, 'text': "so you know when bhavin patel, who is a atlix hardware director, when he's driving and he's on mobile app,", 'start': 2423.644, 'duration': 6.204}, {'end': 2434.031, 'text': 'and he can open this dashboard and get a quick idea of the business.', 'start': 2429.848, 'duration': 4.183}, {'end': 2436.412, 'text': 'So this is that powerful.', 'start': 2435.031, 'duration': 1.381}, {'end': 2440.537, 'text': 'So in this video, we just built the dashboard.', 'start': 2436.433, 'duration': 4.104}, {'end': 2448.725, 'text': 'In the next video, we are going to look at some few other aspects of Power BI, some cool features of Power BI.', 'start': 2441.418, 'duration': 7.307}, {'end': 2457.157, 'text': 'this file I have saved as si underscore youtube dot pbix, which I have checked into my github account.', 'start': 2450.453, 'duration': 6.704}, {'end': 2460.358, 'text': "so if you go to my github, I'm going to provide you this link.", 'start': 2457.157, 'duration': 3.201}, {'end': 2467.562, 'text': 'in the video description you will find this pbix file, so you can down, download this, open it.', 'start': 2460.358, 'duration': 7.204}, {'end': 2471.004, 'text': 'of course, you need to have a proper sql connection, only then it will work.', 'start': 2467.562, 'duration': 3.442}, {'end': 2476.258, 'text': 'But yeah, all the resources are there for you to play around.', 'start': 2472.055, 'duration': 4.203}, {'end': 2479.32, 'text': "So I hope you're liking this project so far.", 'start': 2476.658, 'duration': 2.662}, {'end': 2484.984, 'text': 'I really encourage that you guys also build this dashboard yourself.', 'start': 2480.06, 'duration': 4.924}, {'end': 2485.864, 'text': 'Everything is free.', 'start': 2485.104, 'duration': 0.76}, {'end': 2487.825, 'text': "You don't have to pay any money for it.", 'start': 2485.904, 'duration': 1.921}, {'end': 2490.387, 'text': 'There is a database available.', 'start': 2488.866, 'duration': 1.521}, {'end': 2491.868, 'text': 'Power BI is also free.', 'start': 2490.447, 'duration': 1.421}], 'summary': 'Data analyst can integrate dashboard into web or mobile app, enabling quick access to business insights.', 'duration': 78.73, 'max_score': 2413.138, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ82413138.jpg'}], 'start': 2098.769, 'title': 'Power bi analytics and integration', 'summary': "Discusses revenue trend analysis using power bi, revealing a revenue decline from 425 million to 42 million and demonstrating color customization and chart interactivity. it also covers power bi's dashboard integration, which reduces costs and facilitates real-time business insights, emphasizing the availability of free resources for hands-on learning.", 'chapters': [{'end': 2381.489, 'start': 2098.769, 'title': 'Power bi revenue trend analysis', 'summary': 'Discusses using power bi to analyze revenue trends, showcasing a declining revenue trend over the years, with a peak of 425 million decreasing to 42 million, while also demonstrating the use of color customization and chart interactivity.', 'duration': 282.72, 'highlights': ['The revenue trend shows a decline from 425 million to 42 million, with specific revenue figures for January and February.', 'Utilizing Power BI to customize colors and create interactive charts for revenue analysis.', 'Demonstration of removing unnecessary chart elements and labels for better visualization.']}, {'end': 2510.014, 'start': 2381.489, 'title': 'Power bi dashboard integration', 'summary': 'Discusses the power of power bi in enabling data analysts to build integrated dashboards for web and mobile applications, reducing costs and providing easy access to real-time business insights. it also emphasizes the availability of free resources and encourages hands-on learning.', 'duration': 128.525, 'highlights': ['The power of Power BI allows data analysts to build integrated dashboards for web and mobile applications, reducing costs and providing easy access to real-time business insights.', "The dashboard created in the video can be saved as a pbix file and accessed from the provided GitHub link, enabling viewers to download and explore the dashboard's functionalities.", 'Power BI and the necessary database are available for free, encouraging viewers to engage in hands-on learning and build the dashboard themselves.']}], 'duration': 411.245, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/pbOJVEsZKJ8/pics/pbOJVEsZKJ82098769.jpg', 'highlights': ['The revenue trend shows a decline from 425 million to 42 million, with specific revenue figures for January and February.', 'Utilizing Power BI to customize colors and create interactive charts for revenue analysis.', 'Demonstration of removing unnecessary chart elements and labels for better visualization.', 'The power of Power BI allows data analysts to build integrated dashboards for web and mobile applications, reducing costs and providing easy access to real-time business insights.', "The dashboard created in the video can be saved as a pbix file and accessed from the provided GitHub link, enabling viewers to download and explore the dashboard's functionalities.", 'Power BI and the necessary database are available for free, encouraging viewers to engage in hands-on learning and build the dashboard themselves.']}], 'highlights': ['Identified 279 records with INR and 2 records with USD as potential duplicates, leading to a filtering process to remove them and resulting in a clean data set with 999+ rows.', 'The revenue trend shows a decline from 425 million to 42 million, with specific revenue figures for January and February.', 'The revenue declined from 336 million to 142 million rupees from 2019 to 2020.', 'The process starts with creating base measures for plotting different UI elements on the dashboard, including defining revenue as the sum of the revenue column and sales quantity based on the sales quantity column.', 'Visualizing 2 million sales quantity and revenue details for specific customers', 'The total revenue for 2020 was 142.', 'The chapter discusses the optimization of a sales dashboard, including changing titles, selecting top customers and products by revenue, and addressing data visibility issues.', 'The conversion of USD 500 into Indian currency involves multiplying by 75, indicating a specific conversion process.', 'Demonstration of removing unnecessary chart elements and labels for better visualization.', "The chapter emphasizes the importance of tracking revenue numbers and sales quantity, with specific measures created to fulfill the sales director's interest."]}