welcome to python life YouTube channel what is power bi why you should use power bi and components of power bi on a topic screenshot so first of all power bi and so what is power bi Microsoft Microsoft power bi is a data visualization platform used primarily for business intelligence purpose designer to be used by the business professionals with varying levels of data knowledge power bi dashboards is capable of reporting and visualizing data in a wide range of different styles including graphs Maps charts and Scatter Plots and more so power bi and today is nothing but a business intelligence tool so power bi anti-interest data visualization tool for example company data or School data or college data um foreign foreign foreign presentation history so that is Hindi and social activities so that is nothing but a report so dashboard different data sources comprehensive foreign foreign functions creatures and different types of charts so in a different type of functions so this is the main availability second Point entry we can create more number of and a different number of functions and visuals visual sentence 1200 different functions so that is the main advantage so this is the second point and next one is cheapest tool data connectivity different data sources different data sources so in a different 100 different data sources CSV and SharePoint Outlook and different websites so that is nothing but a fourth Point data connectivity and next 25th pointer recognized by God now so this is the fifth point is 1200 different functions and 280 different charts under different functions and different charts that is the main advantage and third point data connectivity foreign foreign power period and power query data catalog data management Gateway power bi question and answer and power bi services [Music] it enables you to discover connect combine and refine data sources to meet your analysis need it can be downloaded as an add info Excel or can be used as a part of the power bi desktop foreign foreign foreign data modeling technique that lets you create data models establish relationships and create calculations it uses data analysis expression language to model simple and complex data and the entity is so this is the second two and next in the third tool Power view Power view until um Excel SharePoint SQL server and power bi it lets you create in interactive charts graphs maps and other visuals that bring your data to life it can connect to data sources and filter data for each data visualization element or the entire report 200 250 plus charts for example charts it it lets you create interactive charts graphs maps and other visuals foreign services you create workspaces where you and your colleagues can collaborate on reports and dashboards collaborate users services foreign it is an integrated development tool for power query power pivot and Power view let's view build Advanced queries models and reports with power bi desktop it is easy to Advance your skills in PA and your experience in data analytics is tool tool so next to my name is used to visualize geospatial data in 3D mode based on geographical location the data can be highlighted geographical locations can be a country state city or state address to get the best visualization power Maps works with the Bing Maps based on the geographical latitude or longitude or a country state city or state street address data foreign foreign query is for example capital of uttar Pradesh is this is nothing but a power question and answer so this is the seventh two questions and answers language processing until subscribe my channel so it is 72. so my name is so components is Allah services foreign a particular country load print the population is so these are the seven components classes thank you what happened to python life YouTube channel my name is AI services and power bi desktop and power map power question and answer so in a different components is foreign foreign foreign different organizations foreign the extracted information can be directly imported to power bi or a live service link is established to receive it if you directly import the data in power bi it will only be compressed up to 1 GB suppose that you can only run live queries on your Chunky data sets different data sources like Excel sheets data sources transforming the data before visualizing the data rows or columns following that certain rules will be applied to transform and load the data sets into the warehouses so my name is sorry visualizations foreign s presented in the form of crops foreign foreign so foreign thank you welcome to python life YouTube channel previous classes foreign [Applause] foreign languages important selecting a language below will dynamically change the complete page content to the language download foreign process almost complete in the foreign I accept the terms in the license agreement checkbox we have to change our path change is foreign so it will take some time normally installation process finish on it is foreign power b i power bi desktop open system is thank you welcome to python life YouTube channel basic charts this is the first one called enchantmentary and second one it is stacked column chart and third one pie chart next one donut chart and next final chart and ribbon chart so these are the six different charts in power ba these are the basic six different charts in power behind chapter 2 so first one is Papa b i desktop so open it is foreign or other websites are different types content foreign foreign foreign foreign foreign foreign foreign chart so it is small multiples of tool tips foreign foreign [Music] foreign foreign foreign foreign like background color is foreign foreign foreign so sample Superstore file foreign foreign thank you [Music] foreign hmm so same are they call them the second one stacked columns is [Music] low um and a y axis low sales previous classes foreign foreign until it's located foreign distributed values so if for example X exercise column chart so is so this is nothing but a stacked column chart s is foreign four different colors foreign foreign foreign foreign [Music] thank you welcome to python life YouTube channel is can contain more than one data series each data series is that you plot in a donut chart add sharing to the Chart so you don't need slots so that is show values across multiple stages in a process for example you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline dating from multiple stages different different stages so that is nothing but a final chart and next one is you can create a ribbon charts to visualize the data and quickly discover which data category has the highest rank ribbon charts are effective at showing rank changes with the highest range always displayed on the top for each time period is so that is foreign foreign foreign foreign first Donuts details so first order so my name is foreign foreign foreign foreign so 80 tablespoon Channel and Tool tips from foreign welcome color any options so this is nothing but a final chart say the funnel shape so it is it is foreign foreign foreign foreign foreign foreign [Music] foreign 0.25 um thank you welcome to python life YouTube channel when we create a visualization and exploring data sometimes we focus on specific data also we want to remove a specific point because we don't want to focus on them now we select one or more options and right clicks to include or explore points in your visual so my name is include and exclude any options specifically some specific data and selection include and exclude any options data foreign foreign foreign and y axis me sales name y-axis for different regions include and exclude any options foreign foreign foreign foreign you know more sub categories opportunity foreign foreign foreign remove filter included so excluded western region is categories west region is foreign filter Ed include and exclude any options thank you welcome to python life YouTube channel data and Export to CSP files select the visual select more options and export data so my name is so foreign data from Excel workbook same with a sample Superstore and I finally open chest scenario is foreign ers transform data cancer is foreign together foreign thank you so much foreign foreign so a storage subcategories foreign foreign foreign options foreign foreign Click Change foreign foreign the map is a kind of vision part of power bi visualization software using this visual we can show Geographic based or location data values on respective areas of the map according to the location name some geographical data types country States city pin code postal code latitude longitude different geographical data types so practical subscribe data sources foreign foreign foreign foreign [Music] bubble size low foreign since Sunday is a different states some foreign foreign um California is so places and some places foreign longitude so by using geographical data types so class name is so thank you foreign foreign Odessa and next Lord previous classroom s [Music] how much foreign and Tool tips so orders located Play Store listen please foreign play slow ly United States it is Central Asia foreign foreign foreign foreign foreign thank you welcome to python life YouTube channel map with pie chart and formatting Maps classes foreign foreign foreign foreign foreign foreign foreign [Music] foreign foreign foreign foreign foreign and uh bubble size Nano says foreign I wanted to say many different States United States alone states with colors foreign foreign foreign [Music] foreign foreign foreign foreign Church Colorado like either font value saving while this color area and background different formats you change so is thank you welcome to python life YouTube channel background changes in map and how to create India map so a rental topics foreign foreign [Music] I don't know my name is [Music] [Music] foreign foreign foreign default foreign and deepen it next to Darkness is different styles foreign foreign state names and population States and union territories with population is States and union territories and it's identity estimated population in 2023. foreign snap foreign until now foreign population is foreign foreign visualization able to visualization is just a normal grid containing related data in row sign columns it can have headers and only rows users can create tables in reports and cross highlights element within it table they can also select individual cells row sign columns foreign different aggregations so these are the four Concepts in table so first how to create a simple table and format foreign foreign [Music] foreign foreign thank you foreign foreign the first right hand side 290 sub categories and next time and next profit is foreign largest to two smallest values foreign profit descending order foreign foreign [Music] Channel foreign foreign good day foreign horizontal green foreign foreign foreign black students horizontal lines vertical lines foreign header background color change alternating rows first alternating rows children and Alternate different different colors and extend a flashy Rose ampliences foreign thank you welcome to python life YouTube channel previous classes aggregation so it two concepts foreign foreign after that sale so and profiter um quantity increase columns is different options foreign URL so these are the four different options foreign you would for example sales three different anti three numerical columns and importantly texture in the text column so these are the three numerical columns apply settings to series foreign foreign font color font colors Hindi light colors colony sum of quantity 290 High quantity foreign foreign [Music] [Music] foreign foreign average foreign foreign foreign foreign foreign foreign and next episode [Music] different options foreign [Music] counter distincter standard deviation variance or medium is average so average you know maximum maximum profit maximum profit aggregations foreign [Music] foreign [Music] new church foreign [Music] duplicate values are displayed and not and created a matrix makes it easier to display data meaningfully across multiple dimensions foreign foreign foreign so next to Glasgow is third fourth fifth topics foreign already thank you foreign foreign foreign foreign 15. apply foreign foreign [Music] foreign foreign foreign foreign delete them delete it is Central regions foreign so format your visuals different options different foreign foreign foreign three different icons and it is foreign foreign [Music] foreign foreign thank you welcome to python life YouTube channel and conditions foreign [Music] thank you foreign first of all my Matrix my name is foreign foreign foreign [Music] sub categories [Music] absolutely foreign foreign foreign [Music] foreign foreign foreign foreign foreign foreign foreign foreign foreign expand all down in one level quarter Wonder quarter two elements each one day month January February [Music] thank you foreign foreign foreign foreign foreign categories Furniture office supplies and Technology previous classes at a time foreign foreign foreign continue and background now foreign YouTube apply to labels apply to labels any options foreign Nano so blue is apply to label subtotal scan totals font size foreign foreign foreign and then text color is nothing but font color texture is so apply to labels foreign foreign Violet and background color chassis light pink apply to label an entire label any options foreign foreign foreign foreign Harry Potter Millions foreign foreign foreign [Music] Nano foreign foreign foreign foreign thank you welcome to pythony's YouTube channel mattresses questions foreign practical news foreign foreign security challenge line chart available foreign foreign foreign foreign furniture foreign foreign [Music] foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign welcome to python life YouTube channel is so get the data from Excel workbook sample Superstore and a final name is load out tonight options foreign foreign foreign foreign so back is foreign each region each region is foreign so this is nothing but the areas so that is nothing but a area chart s foreign foreign [Music] foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign only so it is foreign foreign foreign 15 though foreign thank you welcome to python life YouTube channel foreign foreign [Music] foreign foreign foreign foreign foreign foreign foreign [Music] filter foreign foreign foreign foreign foreign foreign now three different categories office suppliers technology and Furniture so if three different categories foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign 14. it is thank you foreign foreign remember foreign foreign foreign y-axis y-axis simple waterfalls increasingly indications foreign foreign foreign foreign foreign [Music] 2016. even subscribe [Music] until like breakdown please each and every year look category device technology and office supplies foreign foreign foreign foreign foreign foreign Central and Chase local eastern central South different regions foreign data label Center is East Asia 43 case 43k money sales and fourth position foreign foreign foreign foreign foreign sales sales so either price of actual sales price of the actual sales foreign foreign foreign on each Channel is foreign foreign New Field s um so is Etc a Target profit and infinity foreign Target profit profit card profit so some foreign and twice of profit and 2572k so foreign Nino Channel foreign foreign price of twice of actual sales 943 Target sales is foreign foreign foreign foreign foreign so first of all what are the cards and filters are nothing but indicators it may be a text text or numbers or date anything until text format so a foreign filter on visual sixth one filter and Page seventh one filter on all pages and eighth 180 foreign foreign foreign foreign thank you foreign foreign foreign foreign so April third one foreign foreign location knowledge and latitude or longitude and bubble Sizer a lot different options your location is foreign thank you foreign foreign foreign foreign foreign foreign foreign third one third one is foreign same visual border so rounded corners foreign foreign zero seven 27118 specific Ally says Hindi character foreign particular Channel is second one thank you thank you welcome to python life YouTube channel previous classes different types foreign foreign highest quantity foreign foreign text foreign foreign foreign ers second slope highest sales is foreign foreign on this visual options foreign first now says foreign category subcategory [Music] three options foreign foreign quantity quantities foreign format your Visual Studio options foreign ers foreign so highest sales highest sales indicator first sub category this is the highest highest profit challenge foreign foreign foreign foreign pointed in apply filter so in the third position is thank you Allah so radius changes so first foreign Nano so we're gonna order foreign foreign foreign foreign highest sales equal to 80 2014 Rojo um 2014 year low quarter one low March 18th 2014 water Wonder March 18th higher sales highest sales diary my next highest profit highest profit is equals to subscribe [Music] subscribe now 2016 a quarter for October 2. 2016. water for October 2. um foreign foreign foreign foreign [Music] sales me foreign foreign on this page and filters on all pages first option to add data fills here any options different options multiple options so foreign foreign and extinctive the second one is [Music] foreign customized text options apply important exercise foreign October 2016. foreign and the profitable foreign foreign foreign foreign [Music] [Music] foreign foreign foreign foreign [Music] views customized current themes texture apply Focus mode [Music] episode foreign foreign YouTube [Music] Channel is foreign [Music] foreign foreign [Music] changing top three positions candy foreign foreign foreign foreign [Music] opportunity foreign foreign so first foreign available on time foreign filter on visual filter on page filter on all pages one by one Channel two options a filter on this page and filter on all pages foreign 7 25 .46 is customized themes now foreign foreign foreign [Music] category now Technologies foreign [Music] foreign foreign foreign foreign corporate corporate selections foreign thank you welcome to python life YouTube channel filter on this page and filter on all pages filter on this page on a topic couldn't show them our topic finished filter on all pages topics get the data from Excel workbook sample Superstore on a final cut a filter on this pageant entry of a particular page visuals filter on all pages until multiple pages filter on all pages option subscribe foreign foreign foreign segment and a column name is foreign foreign foreign foreign foreign foreign normally foreign foreign Channel Trinity state name is [Music] foreign and page 2. 0 foreign [Music] foreign [Music] foreign foreign foreign filter on all pages foreign foreign filter on all pages technology sub categories technology phones changes foreign foreign foreign and next page training foreign foreign [Music] so economic database foreign foreign foreign foreign segment name foreign foreign foreign foreign foreign foreign click on opportunity foreign endogrado my name is Hindi Channel s foundations training foreign [Music] foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign technology foreign multiple multiple categories is categories foreign foreign soy banana erase furniture foreign foreign now remote thank you the internet drag and drop system ATA drag and drop Chestnut Alabama different cities foreign [Music] foreign foreign foreign foreign suppliers sales Dragon doctor subscribe my channel title title so it is foreign foreign foreign foreign multiple States multiple States foreign foreign chasing font color and size also and it is foreign multiple options foreign thank you welcome to python life YouTube channel foreign foreign foreign foreign foreign foreign two so much slices foreign available online foreign foreign foreign relative date related so four years six years situations last seven years last seven years last seven years data is [Music] foreign foreign hierarchy foreign foreign YouTube Channel foreign only entry vertical list YouTube foreign foreign YouTube foreign light pink size foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign Ty quantity customized current themes and increase the font size one two Nano foreign foreign quantity quantities Max quantity so in between 1 to 14. customer name signed with sales three foreign [Music] 1 to 40. multiple options in time it is foreign foreign shapes images foreign foreign three open Facebook Instagram images Jason subscribe foreign foreign income Facebook foreign Instagram Instagram foreign foreign foreign foreign [Music] picture images foreign 28 foreign foreign foreign foreign and shapes and images foreign [Music] border color foreign foreign foreign foreign foreign shapes so everything is foreign foreign foreign currently so now um foreign foreign so back buttons foreign data analysis expression Dax stands for data analysis Expressions data analysis expression is a programming language that is used to throw out Microsoft power bi for creating calculated columns measures and custom tables it is a collection of functions operators and constants that can be used in a formula or expression to kindly plate and return one or more values so first of all itax functions function stands for data analysis expression foreign functioning foreign content order films foreign foreign foreign model video data is transform data types so whenever a basic date and profit quick measure new column and new table so my name is foreign day day day 1 is equals to decadente day and you could order is just order any questions foreign foreign Manta laws order date functions foreign foreign foreign function so close changing so if a DNA interchange is foreign create foreign foreign functions product ID and profit so is few lines foreign name um foreign foreign birthday tonight so much foreign text now ship mode conversations foreign lower customer name just customer n a m a just a column name is foreign foreign foreign three left side is foreign so are they Karma in the number of characters number of characters on the first three characters so on the coming characters foreign right column name so column name into product ID so product ID comma any number of characters content is foreign foreign foreign remove um downloads text sample foreign foreign foreign foreign so get the data from Excel workbook sample please so open channel unwanted spaces Nemo new table sorry unwanted spaces foreign foreign foreign [Music] [Music] function according to same text so texture foreign combiner [Music] text s concatenation functions foreign [Music] foreign [Music] foreign [Music] texture to data sub category and percent three data categories foreign foreign calculations foreign foreign foreign foreign [Music] transformed Transformer and add column view tools help so themes so foreign foreign [Music] foreign multiply my channel one minus foreign foreign the hotel sales total sales profit minus sales so total sales foreign foreign foreign foreign foreign percentage percentage of cellular different options calculations foreign foreign menu in purchase minus 25 minus 55 minus 124 so even they could have lost values if a function is foreign [Music] logical one data so foreign [Music] foreign foreign foreign [Music] profit status is logical one data foreign foreign braces Tuesday s next to 180 if error functions Infinity foreign foreign divided by logical discount s today foreign foreign foreign Nano [Music] so then already downloaded downloads logical samples names foreign foreign difference foreign so load um foreign foreign foreign greater than 80 logical to 80 physics condition 1980 s physics physics foreign foreign [Music] foreign foreign names so logical to logical to data table name is two same and the physics foreign foreign foreign foreign same subscribe so get the data from Excel workbook previous classes Japan Channel foreign data View options so ready foreign foreign foreign foreign control C ities [Music] column under new column application difference foreign foreign foreign foreign foreign foreign foreign let's go foreign [Music] foreign only foreign zero three billions of billions foreign foreign foreign sales into 0.2 value in any kind of multiplication sales foreign foreign measures foreign thank you welcome to python life YouTube channel calculated columns versus measures implicit words foreign [Music] sample Superstore and a filing already finally made a previous classes [Music] foreign foreign foreign sales underscore M any channel and some function your JC sum of orders of sales color formula so orders of sales so close the braces children day 2.30 Millions available children delete distinct standard deviation ovariance or medium you know different options Hindi song foreign [Music] count of orders of sales interches foreign foreign foreign [Music] foreign foreign foreign foreign [Music] foreign foreign foreign technology profit technology with the help of late functions technology Nano 2017 at a particular year is foreign 17 profit is equal to calculator orders of profit Karma is here comma and taker 2017 particularly order date is foreign foreign foreign [Music] foreign profit is equals to same calculator so some of orders of profit foreign [Music] foreign foreign YouTube foreign foreign Columns of multiple tables if the column headings are the same across tables then Auto detects the relationship between the tables using these columns we can match the tables as well foreign foreign foreign foreign foreign foreign names get the data from you know sales honey so it is CSV connection on device data subscribe get the data CSV files is to connect foreign foreign so in the product production table so products subscribe color product size product styler and the cost and the price only products is foreign and continent is foreign foreign tables relationships foreign but if backside at the back side relationships but [Music] um foreign foreign foreign foreign foreign foreign foreign [Music] foreign foreign and empty related related and a functions products sales product is foreign [Music] foreign okay relationships foreign foreign [Music] foreign foreign foreign already subscribe so if it is foreign foreign sixth row s um foreign [Music] foreign thank you foreign only because foreign foreign Hindi is within fraction of seconds YouTube Concepts foreign foreign foreign population foreign foreign intake group a group initiated trending transform data subscribe places so it is children foreign foreign foreign Hindi combinations aggregations foreign [Music] foreign average of 10 cities foreign foreign foreign foreign foreign [Music] foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign foreign [Music] I think but foreign foreign foreign foreign data types foreign Valero calculations [Music] time foreign thank you foreign foreign foreign foreign foreign thank you