---
title: 'Power BI Full Course 2026 [FREE] | Power BI Tutorial For Beginners | Power BI Training | Simplilearn'
source: 'https://youtube.com/watch?v=_ELrOWshbSo'
video_id: '_ELrOWshbSo'
date: 2026-08-08
duration_sec: 18112
---

# Power BI Full Course 2026 [FREE] | Power BI Tutorial For Beginners | Power BI Training | Simplilearn

> Source: [Power BI Full Course 2026 (FREE) | Power BI Tutorial For Beginners | Power BI Training | Simplilearn](https://youtube.com/watch?v=_ELrOWshbSo)

## Summary

This video is a comprehensive introductory tutorial on Microsoft Power BI, designed for absolute beginners. It covers the entire Power BI ecosystem, from the free Desktop application for data analysis to the cloud-based Service (Microsoft Fabric) for sharing reports. The instructor explains core concepts like data transformation, data modeling, DAX formulas, and report visualization, while also providing a step-by-step guide to installation and hands-on practice with a sample dataset.

### Key Points

- **Power BI Desktop vs. Service** [02:09] — Power BI Desktop is a free, offline application for data analysis and report creation. Power BI Service (now Microsoft Fabric) is a paid, cloud-based platform for sharing and collaborating on reports.
- **Corporate ID Requirement for Service** [09:45] — A corporate ID (not a personal Gmail or Outlook account) is required to create an account for Power BI Service / Microsoft Fabric.
- **DAX for Custom Calculations** [05:08] — DAX (Data Analysis Expressions) is a formula language used to create custom calculations (measures) in Power BI, similar to Excel formulas.
- **Data Modeling for Relationships** [11:54] — Data modeling involves creating relationships between different tables (e.g., Customer and Orders) so they can be used together in analysis.
- **ETL Process Overview** [31:21] — ETL (Extract, Transform, Load) is the process of collecting data from various sources, cleaning/transforming it, and storing it in a data warehouse. Data engineers typically handle this.
- **Descriptive vs. Predictive Analytics** [36:57] — Descriptive analytics focuses on understanding past data, while predictive analytics uses models (like ML) to forecast future outcomes.
- **Power BI Gateway for On-Premises Data** [53:22] — A Power BI Gateway is a secure bridge that allows the cloud-based Power BI Service to connect to on-premises data sources (like local files) for automatic data refresh.
- **Three Main Views in Power BI Desktop** [01:24:25] — The three main views in Power BI Desktop are Report View (for creating visuals), Table View (to see raw data), and Model View (to manage relationships).
- **Measures vs. Dimensions** [01:21:45] — Numerical columns are called measures, and categorical columns are called dimensions in Power BI.
- **Power Query Editor for Data Cleaning** [59:12] — The Power Query Editor is a free, separate application for data cleaning and transformation, included with Power BI Desktop.
- **Categorizing Geographical Data** [02:22:21] — Columns can be categorized as geographical locations (e.g., City, Country) in the Column Tools under Data Category, enabling map-based visualizations.
- **Slicers for User Interaction** [03:40:16] — Slicers are visual filters that allow end-users to interactively filter data on a report page.
- **Three Levels of Filters** [04:01:04] — The three levels of filters are: Filter on this Visual, Filter on this Page, and Filter on All Pages.

## Transcript

Useful Until It Is Cleanly Analyzed and visualized. The Real Question Is Are You're turning data into in-depth and just Looking at Numbers. With that being said, I Welcome you all to this session on Powerbi Tutorial. Where We're Going to Turn Raw
Data into powerful business dashboards. in This course, we're going to understand how Power BI Helps Businesses Analyze Data Build interactive reports, and Dashboards for Better Decision Making. We Are Also going to start with the basics of
Business Intelligence and Understanding How PowerBI Converts Raw Data Into Meaningful Visuals. After that, we will move into Power Query Editor. where we are going to Duplicates, Missing Values ​​and Formatting issues. After that, we are going
To Explore Data Modeling, Relationships Between Tables Along with Hararchies for Structured Analysis. And finally, we are Going to See How Power BI Reports Are Published and shared to support real businesses Decisions. Now before we move on, just a
Quick Info Guys, Simply Learn He's Got Professional Certificate Program in Data Analytics, Generative AI and Adda Aptive Systems in collaboration with IHFC and TIH of IIT Delhi. this program Actually Helps You Master AI Powered
Analytics Using Excel, Sequel, Python, R, PowerBI & Azure. along with Hands-on Projects and the Real World Case studies. We are also going to gain 180 Exercise, 15 plus industry Projects, and a Capstone Project
Plus access to tools like, TW, PowerBI, AWS, Azure, GenII Tools Like Chat GPT and Clot. learners are also going To receive a certificate from IHFC TIH of IIT Delhi along with job Assist Plus for Resume Support Mock
Interviews and career guidance. by the end Of This Course, You Will Just Not Understand PowerBI But You Will Also Know How to Turn Raw Data into Actionable Insights. now here is A Short Quest to Test Knowledge. what does BI stands for in Poweri? and your
Options R Business Interface, Business Intelligence, Basic Information and Business Integration? Please mention your answers in the Below the comment section. Now PowerBI Desktop Below the comment section. Now PowerBI Desktop Is An Offline Application That You Need To
Is An Offline Application That You Need To Install in your desktop in your personal System OK Its an offline application that you need to install it that you need to Install it in your system it's a PBI
Install it in your system it's a PBI Desktop PBI Desktop Is Basically Where we do the analysis, it's offline. machine write it's an offline system where we Do All the Analysis Is Used Used for performing
Used for performing All the Analysis and It Is Absolutely Free free of cost. You Don't Have to Pay Any amount for using the RBI desktop You don't have to pay any amount. it is
Absolutely free. Okay now if we're doing some analysis in Using the software if we are doing something Analysis Using the Software Okay, so we are
going to obviously we are going to learn About the Modeling and Transforming What About the Modeling and Transforming What Do I mean by that so if the first in the First Sentence We Understood the First Point That Using PBI You Will Be Able To
Connect to multiple different sources. What Do I Mean By That? Different sources you Can just think of it as an Excel file, may Be a CSV file, okay? May be a PDF File, may be a folder. So These Are Different Sources of data: where the data are sourced
In ah saved in different sources, right? Now If I Want to Connect Into a Single Now If I Want to Connect Into a Single Platform. Every date every file will have Platform. Every date every file will have A separate format each of this file will have
A Separate Format Isn't it so if I want to work on the Analysis If I Want to Generate the Insights from the data if I want to analyze the
Data I Have to Make It Into the Common Format I Have to Make It Into the Common Format right that is known as your Transformation That Is Known As Yours
Transformation. Obviously I will be Discussing that in detail as well. What Do I mean by transformation. Ok? So Here Just Right Now You Can Understand That Getting the data into a common format or me Cleaning the Data from Be You Can. cleaning the
Data Because the data in Excel file, the The format will be different. In CSP file, The Format Will Be Different in PDF File, The format will be different. Ok? And if the The format is different if we are trying to Combine It If We Have to Get It in a Same
Format So How Do We Do It By Cleaning it by combining it so that is known as your transformation so we're going to highly Focus on that as well as how do we clean the data OK Now Once We Have Cleaned the Data We Are
OK Now Once We Have Cleaned the Data We Are also going to learn about something known as also going to learn about something known as Dex Right Dex Is Nothing It Stands Dex Right Dex Is Nothing It Stands For your data analysis expression.
Expression. Now think about it when we R going for the analysis. Right? when we are going for the analysis there are in the Data We Have Certain Information. Ok? May B V
Data We Have Certain Information. Ok? May B V Are doing some analysis there are information Are doing some analysis there are information Means features. We already have some features Means features. We already have some features here okay may be we have the you know you we
already have the sales OK, we have the quantity. OK, we have the quantity. ok i have the order id as well ok i have the order id as well Order Date As Well
ok now what do i want to get if i want to do the analysis okay these are the Fields are already present now I want To go for further analysis. I Need to Create To go for further analysis. I Need to Create Some extra field may be revenue. I
Want to go for creating an extra Field. Now using the full right using the mathematical fulla i can calculate the revenue by combining you ah by
revenue by combining you ah by Combining the Quantity and the Sales. Isnt It? I can write a formula for that. Like We Do In Excel As Well. If you are aware With Excel we do that Using the existing fields and using the
Using the existing fields and using the mathematical operation we create it so that is mathematical operation we create it so that is Known as your deck in your power by ok Dex in your power BI so we're going to Learn How to Write the Ah Deux Expressions
In your Power BI as well and of course we are going to create Reports PBI is known for the visualizations right So we'll be going for creating different visuals okay we will be creating the
Reports and Finaly See This Is the Part Create Reports for Data Representation We Have Cleaned the Data We've come and got the data from the different Sources We Have Connected It and Then After That we have done some analysis we have done some
Analysis of how in the forms of in the form of some charts and graphs from the analysis Will understand ok what the person has done. Ok? So this portion is done in your PBI
Ok? So this portion is done in your PBI Desktop. This is done in your Desktop. The desktop application which we Are going to install today if you havent.
Are going to install today if you havent. Right? So This Is Your PowerBI Desktop End Once this PBI desktop is offline Application. If we're working on this, if we Are you doing the analysis in the desktop? Clients and May Be Our Piers Will Not Be
Able to get a view of the data that will be analyzed What we are what we have done so to share the analysis to publish it okay so we have to Basically publish it into the web and say into
The Cloud Right So That Others Can Contribute Others Are Able to See What Analysis is what we have generated They have to need another application for that
that is your Pabi service which is no lag, no age Pabi service which is no lag, no age service ok now a does it is known age
service ok now a does it is known age Microsoft Fabric It is known as Microsoft Fabric. Just the cloud version and web version
Just the cloud version and web version of your Power BI it's a web version of your of your Power BI it's a web version of your Power BI and Also It Is It Is Not Free Power BI and Also It Is It Is Not Free OK, this is not free.
to pay the amount it is paid Paid version desktop is absolutely free Paid version desktop is absolutely free Where we do the analysis is also one thing for Creating an account for creating an account
For creating an account in the PBI and Microsoft Fabric You Need a Corporate Microsoft Fabric You Need a Corporate ID Your normal Gmail ID Outlook ID Will Not Work You Need a Corporate ID for That. Ok? So in this course we are going to
That. Ok? So in this course we are going to Firstly for the first five seasons we are Firstly for the first five seasons we are Going to Focus on These Four Parts We Are going to focus on these four parts okay so How can we connect the data, okay, then how do
We Clean the Data How Can We Create the Dex Creating Reports All of This Things We're Going to Learn in the First Five Does on the Last Day I'm Going to Show Five Does on the Last Day I'm Going to Show You the P Microsoft Fabric that is the PBI
You the P Microsoft Fabric that is the PBI Service. so this is your this is basically a Course Objective for Now. So this is a Prereqvisit for this course. Since PBI Is Nothing But Your Advance Excel. Right? It's an advanced Excel only. expansion of
Your Excel. So that is why it is Required that you are aware with ah you know The Excels. Pivot Table and Pivot Chart. It Is Work Ah it it does work. You know PBI creating the chart. It does work on the same fundamentals
As your Pivot Charts and Pivot Tables in Your Excel. So that is why this is the Pre-visit this course that you are Aware of the Pivot Tables and Pivot Charts. Now coming to this course ah Outline. So we're going to introduce
Outline. So we're going to introduce You to the Pabi. So today that we are going to look into the today in look into today Itself. Ok? After a few minutes we are Going to look into that. we are going to Understand some terminologies and look for them.
Into the interface as well. Once we install the PBI Desktop. We're Going to Learn How to PBI Desktop. We're Going to Learn How to Connect data sources. So today we are going To connect to you know the excel file.
Yes We're Going to Learn About Data Modeling. Now the term is data modeling. So Modeling. Now the term is data modeling. So If you are aware of SQL, okay, that's the Term is very easy then. Okay, but if even if You Are Not Aware Just for the Simple Sense
When I will discuss this, I will I will go into the depths, but for now You Just Understand Right Now This One Data Modeling Part Modeling Part Okay, suppose you have this is a data coming.
from your excel file ok so it is stard as a table right now this data is stard as a table right now this data is Coming from an Excel file, okay, now this is suppose an ah table is there suppose you can Just think of it as the
Just think of it as the Customer table ok customer table then one another The Data Is There That Might Be Coming From Another Excel file which contains the orders data
Another Excel file which contains the orders data OK orders data now if I want to check OK orders data now if I want to check If I want to check the customer If I want to check the customer The customer who has ordered something now checks
Here this this customer is a separate table. This orders is a separate table. both are Excel files. But what happens? this is a Separate table. This is a separate table. Now Separate table. This is a separate table. Now If there is no connection between this two tables
If there is no connection between this two tables They will not be able to extract the Information that the customer has ordered Something. The Thing Is That The Customer Table Currenty stores the information of the Customer only. the customer details and the
Order Tables Consist of the Information of The Orders of the Order Place The Orders of the Order Place Order Details Order Date All Those Things Order Details Order Date All Those Things Now if I want to get the information, okay?
Customer who has ordered something there must be a relationship a relationship There must be a relationship between these two There must be a relationship between these two Tables That Is the Customer and the Orders OK
That is known as your data modeling. Developing the relationship. How Do We Develop It? There are multiple ways of doing it. So That is known as your data modeling. that is the Connection. Ok? So what we are going to discuss in
Details once we go to that portion. For Now You understand it is the relationship between the Two sources and two tables. Because if we want to use the data from multiple different
Sources We Have to Have a Connection. otherwise We can't use it. So this is your just in short I gave you an Explanation for the data modeling. Butt Off Of Course We're Going to Look Into That Part As well as in the upcoming sessions. ok now coming
As well as in the upcoming sessions. ok now coming to your so after the data ah data modeling We have profiling of the data. Profiling Is Nothing But Doing The Profiling Is Nothing But Doing The Analysis. Doing the analysis of the data.
Ok? Now Analysis and visualization right analysis and visualization you are doing the analysis you R Visualizing the data in the form of some You know charts graphs okay goes hand in hand now while we while doing the
Analyzing You Realize That You Will Be Requiring Some Dex expressions so you go for Dex And then again we go for Visualizing the Data Right You Have Created The Dex Field and Then You Require Sir
We need you to visualize the data. you are Going to do that. OK Now Once After OK So we have created lots of reports. We have ah we know that PBI is used for the charts and graphs and we're going to
Sure That's the Model That the Report We Created It is efficient. Ok? Because in terms of if we create Lots of Charts Right in the Same Report
It Will Be When We Try to Publish That into the web because the ultimate aim is to into the web because the ultimate aim is to Publish that into the web so that our pierce Publish that into the web so that our pierce Are able to see it right if we do so yes
Taboo is also a bi too Right So If We Do So If We Opt If We Just Go For Creating Using Lots Of AI Charts Heavy Charts We Use and Then We Publish It The Time For Refreshing The Time for You Know Publishing Will Also Be
Time for You Know Publishing Will Also Be Peacock. So we don't want that. So the chart The report we create should be true that it is. Able to deprive all the information but with the Able to deprive all the information but with the Minimal Ah with the Minimal Charts which are
Not heavy which are efficient. Right? Which R Efficient. so that is why it is required very much required that we Optimize the model performance v Optimize
Optimize the model performance v Optimize The Model Performance Create so we're going to look into that How do we optimize it and of course so Power BI Is Known for Its Interactivity and analytics okay so we're going to
Work on that we are going to publish as I Mention all the analysis we are going to do Sessions on The Last Day We're Going To Publish it. Ok? We are going to learn About How Do We Create Dashboard. Dashboards and Reports Are Different Things.
If you're coming from the You Know Taboo Background You Must Have Heard Reports End Dashboard. Ok? So We Do It In The Ah Public on. But it is not the case. in this
Case the Pabi Sorry the Tab Dashboard which You create it's the same thing with Ah of the PBI Report Right Dashboard Here in the PBI We Created
Right Dashboard Here in the PBI We Created In-the-box service and Microsoft Fabric In-the-box service and Microsoft Fabric Report We Created in the PBI Desktop OK and we're going to do the performance Advanced Analytics Right and We're Going
to learn how to do the pabi how does the PaBI Manages the Data Sets at Your Service So what we're going to look like, well, okay? So this course is aligned with your PL 300
Certification And on the last day we are also going to Discuss One of the Projects So I Am Not going to cover right now okay so and Regarding the certification, you have to Complete You Have to Join Obviously the Live
Complete You Have to Join Obviously the Live session and you have to go for the self learning Otherwise also you have to submit for Getting the Certification from Simply Learn You have to at least get one project Submitted OK Completed and Submitted so in
This Course We're Going to Learn About to Things one is your PBI desktop okay PBI Things one is your PBI desktop okay PBI Desktop and Everything Else Is Your PBI Service Which is common now day is known as Microsoft fabric okay but again remember this is a
The free version which we are going to install Today It's Absolutely Free But This Is a Today It's Absolutely Free But This Is a paid version ok it's a paid version also you paid version ok it's a paid version also you Need a corporate account for that also the
Reports We Go For Creating Reports We Go For Creating in the PaBI Desktop We Go For Creating in the PaBI Desktop And dashboard we go for creating in the Service we're going for ah creating it in the ServiceNow What is a Report What is a
dashboard we're going to look into that Later, okay, so let's discuss about it. Later, okay, so let's discuss about it. Getting Started with the Term BI SOPA BI Right what does the term BI stand for Now what does this business intelligence mean?
What does this business intelligence mean, okay? Before Coming to That's Okay So We Humans Are Also Doing Business Intelligence Right Now ok so for example ok suppose just forget About the Business Intelligence Now What is the The Decision Making Process We Humans Take Do
What is the decision-making process? Humans are doing this these ages. Ok? So, Think about it. Suppose I am taking an Example of purchasing a mobile phone. Ok?
Example of purchasing a mobile phone. Ok? Purchasing a mobile phone. First of all okay What we do? If I Decide to Purchase a Phone Most of us will decide on the Most of us will decide on the Specifications The Requirements.
Don't We Set the Requirements? If I Wish To purchase a mobile phone. To purchase a mobile phone. Yes.
We will set up the requirements like Some people may be interested in the brand ok Maybe they have been using it some People may be interested in the camera
Memory Okay, may be the memory and ah, let's say battery. Okay, may be the memory and ah, let's say battery. give me a moment
Battery OK Storage Extra Right Requirements Now the Thing Is That After We have set up the requirements what we Do What We Do We Do Start Ours Analysis: OK, we'll go for the difference.
Sources What Different Sources What Do I mean by that okay we know now a days we do Find and Do Everything Right The Reviews for Everything's OK in the Internet in the Internet
So You Will Go to Some YouTube Videos YouTube videos
Description which phone is doing good or Something Like That What Is The Requirement Is what is the requirement you should go for Right Then What We Will Do
Right Then What We Will Do We will go for some may be online websites Like Your E-commerce Website Amazon Amazon Flipkart: We will go for some anyone you know
Offline stores as well we will go for any Offline Stores As Well And Try Out The Check out the specifications there. We can also take into account. Suppose at
Particular brand phone I am using. I am Using an Apple phone right now and I am Only interested. I really like that phone And maybe I might be purchasing that only. And maybe I might be purchasing that only. So I will be taking the consideration.
You know I will be taking the consideration of My previous phone s well.
Previous phone experience and we also go for sometimes if there are some Friends right who are aware of this who have Lots of technical knowledge on the phones and this Lots of technical knowledge on the phones and this Devices We Go For Asking Our Family
Devices We Go For Asking Our Family And friends for their suggestions as well. Now what am I doing right now this YouTube Reviews Amazon Flipkart Previous
Phone Experience Family Friends These Are Nothing These Are Nothing But Your Different Data Sources Right now I'm gathering the ination right now Right now I'm gathering the ination right now I'm gathering the information isn't it
I'm gathering the information isn't it Analyzing I'm Just Gathering the Inauguration
This Is a Data Collection Method I Have Collected from different sources
Data Collection So You Can See I've Got The YouTube reviews are okay, so are the Amazon reviews. And we do that even if we do that right Unintentionally also we decided to purchase a laptop or may be we go for decide Deciding to Purchase a Phone We Do Lots of Hours
Deciding to Purchase a Phone We Do Lots of Hours Research on Our Own Rights Right After We Went For data collection since we have collected the data from multiple different sources what we go for we go for cleaning the information
Let me take a different this one. Ok. So we go for after we have gathered the information from multiple different sources. Go for Cleaning It According to Ours Requirements.
Combining the Information After That Once We Have Clean It What We Do When We Go For Have Clean It What We Do When We Go For Load the Information Into the Brain Right So That Is The Storage
Right So That Is The Storage That Is The Storage We Do We Have Gather Information from multiple different resources than we Go for cleaning the ination and then we Go for cleaning the ination and then we Go for storing the information we don't go for
Visualizing Right Whatever information is specific, okay now After That Once We Have Gathered All the Inauguration We Have Cleaned the Data Now We Go for the
analysis Now we will do all the calculations Permutations and Combinations Will Come Here All the Permutations and Combinations Will Come Weather All the Permutations and Combinations Will Come Weather If I go for this brand, okay, so it will be
Fitting my budget? All the Features I Want What Is the Budget I'm Happening? So I will What Is the Budget I'm Happening? So I will Do All This Kind of Analysis. Ok? All This Kind of Analysis. what if I'm getting better feature in this amount.
After I Have Done the Analysis, I Will Finally take the Finally take the Decision. I will finally take the decision here.
Isn't it? are we doing it even though we don't realise It even though we don't realize it, but we Aren't we doing a lot of analysis into our Aren't we doing a lot of analysis into our Brains Age Well for a Simple Workout Like This
intelligence we're doing it regularly as a Human and our ancestors were also Human and our ancestors were also Doing the Same Thing for Taking Any Decision Doing the Same Thing for Taking Any Decision for any decision they have been taking right
for any decision they have been taking right Same Way If I Talk About Your Business Same Way Same Way If I Talk About Your Business Same Way If I talk about your business, they also do the If I talk about your business, they also do the Same Thing When There Is a Problem There
Is a problem they may be in try to Improve the Business of the Particular Year Improve the Business of the Particular Year B 2026 They Want to Improve the Business Okay, so what they have to do, they have to go. for finding a solution for that how they can
Improve the Sales of This Particular Year 2026-27 by 5% may be okay for that they have To get all the earlier data and may be Earlier Details They Want to Get OK They
and all those things and they will be going For data storage in that case right when I go for this data storage so you can Just think of it like a data warehouse Just think of it like a data warehouse House
Kinds of Information Me Go For Decreasing the size.
Server Where it is storing all the infatuation and supposition You can just think of it in terms of Businesses Write It May Be Any Excel File And I'm talking about the flat files in B. Excel files, PDF files and
B. Excel files, PDF files and CSV file Excel File, PDF File, CSP File. Now Here You Can Think of It Data It's
Coming from any cloud source may be from Your AWS Your AWS Ar Okay, AWS Azure, for example, let me Just
Yes Sales Focus Similarly If I Go For This Data You Can Just Think of It May Be Any Web API The Web Spraying You Have Done OK Web API You Are Getting the Data From Any Web API You Are Getting the Data From Any Web API
Getting the data may be from SQL Server
Sources. There are multiple different sources right Now once you get the different sources of Data, you are this is your data collection. You
Have to combine these different data sources Together. And You Have to Go for Data Cleaning and combining. so what do i Mention Mention like the what is this term Data Cleaning and Combining Obviously You R Getting the data from multiple different
Sources You Have to Combine It But Before Combining it you have to get the data into the Combining it you have to get the data into the Properly Structure the Data in the Real World They will have lots of issues, okay, there will be Missing Values
Okay, there will be missing values. There, okay, there might be duplicate values. might be there Formatting issue might be there right Formatting Issues Are There So you have to clean all this data together
So you have to clean all this data together what the data you required yes okay so you First, you have to go for cleaning. And Combine the Data and Once You Are Done With It that you are going to store that information into a data warehouse so this part right
This Portion Is Whatever We Are Doing Right Now Data Collection, Data Cleaning and Combining Data Collection, Data Cleaning and Combining Data Data Storage This part is known as Data Data Storage This part is known as Your ETL
Your ETL OK that is your extract Transform End Load Extract Transform End Load End Load Extract Transform End Load And this is exactly where this is
And this is exactly where this is Exactly Where Your Data Engineers Are Exactly Where Your Data Engineers Are Work Your Data Data Engineers Right They Were Let's go for different source collections Collecting the Data and Going for Combining It
And store the data in the proper format Right Now Where Do We Work As An Right Now Where Do We Work As An analyst we work okay so as an analyst you are you going to work here Connect to the storage you're going to
Connect to this storage And then you're going to do the analysis. What Kinds of Analysis. analysis In the Forms of Some Visuals. Because once
You do the analysis, right? we don't Understand one because how we become someone needy Two if before taking the decision, right? before The taking the decision, the decision makers, the Decision makers they have to understand. OK, for how the data is. So, that it will
data analyst they will they are going to SimplifyIt. How to Buy in by Using Some Visualization by using some visualization Visualization in the terms of some in terms Visualization in the terms of some in terms of some charts graphs tables
Etra So what happens is that who are the decision? So what happens is that who are the decision? Makers Right Now Okay So This Is Where Your Makers Right Now Okay So This Is Where Your Data Analyst Will Work
They try to generate insights from the Data they try to generate the insights from Data they try to generate the insights from The data. OK now we have these decision makers Based upon the analysis based upon the analysis
It's generally The Leadership Team The Business Analyst
They are the business analysts. Business Analyst Your Senior Managers Managers There We Have the Leadership Team Like We Have the Executive
Decide what things need to be done for the business Analyst Will Inform The Data Analyst You Analyst Will Inform The Data Analyst You No, you can go for that particular data. You can go for that particular you can go For that particular web API to the data
Analyze the data which they will not table Mention the Business Analyst Will Not Mention the Data Analyst You Have to Search for Which Data and all those things. They Will Just Give You have a suggestion that you know you can try to if You want to if you're trying to get the
Trying to Get the Analysis You Can Just Use the web data from here. so there the Data analysis they will be trying to Extract the information in from the Storage of the data warehouse. If the data is not in to the proper format they will
Ask the Data Engineers to Format It and then the process will be repeated are you Getting My Point Are you getting my point? The Data Analyst
is going to use all these tools right one of The Tools Like If I Talk for the Analysis Purpose for the analysis purpose of the data Analysts they are going to use the tools like Python powerbi And how can I for get excel which is the
Best Tool for the Analysis Right Simplest Tools for Analysis in Excel You Have Tab Right so all this tills they are going to do For Doing the Analysis
Generally Data Analysts Don't Go for Ours Programming These Are the Parts of the Data Scientist to okay so whatever this roles Are you there right, I talk about business? Analyst I talked about data Analyst and Talked About Data Engineers
Analyst and Talked About Data Engineers All of them work with the past data. All of them work with the past data. Work with the Past Data Right Whatever You Have Happened in the Past If I Want to Improve The Business for This Year 2026 27 Right I Have
to understand what had happened in the Previous years right, so I'm working on The Past Data I'm Trying to Generate Insights on the Past Data OK What Had Happened in the past. So, and What Went Wrong So that we can improve this ah you know this
Year for the financial year. But if I talk About the Data Engineer's Path Is Little Bit different. So, after they have done the Analysis, right? Or may be you can go for Analysis, right? Or may be you can go for This storage, they are going for something known
This storage, they are going for something known As, they are going to apply the MLDL Models. and statistical models for generating the and statistical models for generating the Future for Predicting the Future
Future for Predicting the Future The Data Scientist They Try to Predict the The Data Scientist They Try to Predict the future so that is known as something known as Predictive Analytics
Insights from the Past Data Data OK The The Data Engineers The Data Analyst The Business analyst they work on something known as the Past data which is known as yours
Descriptive Analytics They Are Not Trying to predict the future They Are Not Trying to Predict the Future they are trying to understand what has they are trying to understand what has happened in the past yes historical data give
Try to understand what has happened in The Past But When It Comes to Data Scientist they go for applying the mathematical Models Like the Machine Learning Models Deep Learning Models You Know Now is the Agentic Models so they go for applying that they go
For Applying That to Predict the Future Okay, like they're going for some prediction. Okay, like they're going for some prediction. But they are not going for prediction
Right so the whatever we are doing right this Is Business Intelligence Right Now This Is Business Intelligence Whatever the Decision We Make r taking is backed by data okay it is r taking is backed by data okay it is Not a random decision it is back by back by
Data If I Want to Improve the Sales for the Next year for the 2026 27 I have to Next year for the 2026 27 I have to Understand what went wrong in the previous year okay so that we they are going to take some Decisions based on that and they are going to
You know implement and then it's a repetitive process
Alright, so let's go back to the slide. right now just give me a moment Okay now coming to the slide we're going to Understand again so I've just given you Understand again so I've just given you a glimpse of the
Predicting the Future. Right? You have once stranded the data and It's not the pain again that comes from a machine Learning and Machine Learning is also lots Of types are there. Ok? so what Happens in the Descriptive Analytics
We are trying to learn about the past data. So That We Can Improve the Upcoming Right? When it comes to predictive, Whatever the existing data we have, we Train It and Based Upon That We Try To Predict the Future.
Ok? Not the current data based upon the Existing data based upon the existing data we are going to predict the Future That Is Identifying the Pattern Future That Is Identifying the Pattern That's Identifying the Pattern
Those Are All Features Sur Ok Those Are All Features based upon How We Train the The Whatever You're Saying the External Factors Requirements Are the Features
Factors Requirements Are the Features nothing else So I have just given you a glimpse of it Now Just Check Here What Is Business
Intelligence, so as I mentioned, it is the Capability to Make Intelligent Business Decisions. Ok? So we're going to analyze The Thing How We Humans Do It Same Thing
Business does it and that is known as business Intelligence. What happens? that is the Intelligence. What happens? that is the The decision we take is basically back by data. back by data where the information if Something went wrong right? We want to try
To understand. OK, we have implemented a Solution. Ok? So probably last year the The sale was not good, I wanted to improve in That area. So if I try to understand That area. So if I try to understand That past data okay if I go because our
The decision is data driven and will be able to Understand it because every process we are Able to understand it. So That Ination Discovery Is Simple Here Helps You Discovery Is Simple Here Helps You Analysis in the data and also enables you
Analysis in the data and also enables you To send the right information to the right people. To send the right information to the right people. Right Information to the Right People. Ok. So here using business intelligence Right you will be able to apply some
Security is also what we're going to look for. Into the PaBI. Ok? So there is the Reports We Create Right? we are going to Create One Report. But if we share that Report with others, right? It's Not Requires that all the users will be able to
See The Entire Report. Obviously, if you have Do not apply any security they will be able to Do not apply any security they will be able to To do so. They will be able to do so. ok but If you apply security ok know only this There may be multiple departments in the
Organization Suppose I Am From the Data Science Team Data Science People Will Be Able To View only their portion of the data I can Restrict the user from other users
Looking Into the Data Science Team Data or Me B I I will not be able to look into the Finance Team Data Or May Be I Will Not Be Able to Look Into the IT Team Data Right So that security is also enabled and Provides data insights to everyone from
Any type size and source of data. So that Is This How the Business Intelligence Tools Are Is This How the Business Intelligence Tools Are Useful for. You are able to connect to an AWS Sources Where Huge Volumes of data is present you can connect to an
Excel file as well. so does not matter what What is the source of the data? You are able to once you Connect to that business intelligent Software You Will Be Able to Generate Software You Will Be Able to Generate Insights From It.
Insights From It. ok now The Market But You Can See Here Why This Power BI Is Not a Business Intelligence Tool
Because it stands for BI Power BI Is Not Because It A Stands For Bi That's why it's known as a business Intelligence Tool But It Is Known As Okay Because Intelligence Tool But It Is Known As Okay Because It is a self-service cloud-based BI
Tool Now Talking About But I Did Mention That PBI You're going to do all the analysis right in The PBI Desktop in the desktop version which
We are going to install today right and we Are also once we have done all the analysis we Have created the report we want to share it with our pierce we're going for the
Micro PBI Has Its Own Cloud That Is Known as your Microsoft fabric
So That Is Why It Is The BI Tool We Have right now okay that is why it's known as right now okay that is why it's known as Business Intelligence Also Since It Is a Business Intelligence Also Since It Is a Microsoft product ok its user interface
Is Quite Similar to Your Other Microsoft Products like your Excel and Words. Ok? So, it's a very simple end user friendly two they have mentioned drag and friendly two they have mentioned drag and Drop. But in case of your problem it is more
of a Expand and Collapse
Expand and collapse interface Okay and of course the charts in PBI Whatever Visuals We Create Right We Will Be Able to Make It We Don't Have to Do It By default, PBI is highly interactive. I Is Highly Interactive and We Will Be Able
To Create Multiple Charts Beautifully Graphs with the PBI okay now coming to the Next So why PBI so there are other tools in the
market ok so there are other BI tools so We have this PBI as I mentioned you have stable as well We have Qlik as well ok. so we have
Lots of tools in the market. we have Lots of tools in the market. But why? Power BI? First of all it's a Microsoft Product. it's a Microsoft product so which we have Been using since ages. we are already
Familiar with the Microsoft environment Like your Excel Word. Ok? So it's the The Environment Is Quite Similar to the Microsoft product. Right? and also it
Supports natural language. The Way We Are Communicating Right Now. The Way We Are Communicating Right Now The In Using English language, right? Same Way You Will Be English language, right? Same Way You Will Be Able to write your queries in the
Able to write your queries in the PowerBI as well. So they have you will be able To connect two they have mentioned 60 different Data Sources By Now Days It Is Not 60 It Data Sources By Now Days It Is Not 60 It is more than 150
Data Sources 150 Plus Data Sources Now I Tell You OK So those who are coming from the taboo Background Those Who Are Coming From The Taboo Background You Must Be Aware That Using The free version of
free version of Tab you will be able to connect to only three Data sources. You will be able to connect to Only three data sources. But that's not the Only three data sources. But that's not the Case with your PowerBI. Ok? Using the free
version you will be able to connect to more than 150 Ah data sources. Ok? also You can connect to any data life and to the
You can connect to any data life and to the Offline file stored in the local machine OK you can connect to any file store in the Google you know your Google Sheet your AWS You Will Be Able to Connect With That any server data also you can connect
to any excel file csd file for folder of course okay and since it's a Microsoft Product Rights Microsoft Products The Updates Are Happening Quite Frequently. And if I let you know The PBI The Latest Update Was Done on My Eye
Think on April 10th which is just three Days back which was just three days back. So It's Happening Quite Frequently and More Features have been updated. Ok? also it Has a simple learning curve. as I mentioned It's a Microsoft product and it
It's an advanced action. Right? It's a very Simple to learn. The only thing is that you have To practice it. You have to explore it. The More You Explore The More You Learn The PBI It's a tool ultimately. Ok? So that is why they have mentioned PBI
Ok? So that is why they have mentioned PBI Is Much Better Compared to the Other BI Tools in The Market. So obviously during the six Days You Will Learn OK How PBI Is Better. It's much simpler than your Tab or any other Tool in the market. Okay now coming to the
PaBI Architectures. So here there are Lots of architectures are there okay but we Lots of architectures are there okay but we RT - Discussing About the Offerings Here We are going to discuss the disc ah we are Going to look into this course in the PBI
Desktop as I mentioned PBI desktop is an Offline application which is available Absolutely Free We Are Going To Install It's today, okay, where we create, do all the Analysis Create the reports do the Cleaning OK in the PBI desktop then we
Cleaning OK in the PBI desktop then we Have the mobile version here We have the mobile Have the mobile version here We have the mobile Version. Now this is coming to this mobile please Version. Now this is coming to this mobile please Understand OK Once We Have Published The
Publish the report into the service And Microsoft Fabric so that other team Members are able to view it or not required it's not required that they required it's not required that they should also have the desktop with that they can
may be from their phone also if they have this pbi mobile app application they will be able to View the report that their team members have Share Again This Is Not Free Again This Is Not Free Only Desktop Is Free You Can Get the mobile application to view the
Reports You Can Use The Mobile Application To View The Reports Now Coming To The To View The Reports Now Coming To The Embedded This Is Pretty Interesting Here Okay, what happens is that in some Organizations They Already Have Their Own
cloud okay they have their own website they have their own cloud what they require is they their own cloud what they require is they Require the Benefits of the PBI OK I Need Interactive Visuals I Need to Create Dashboards and all those things but I want
to get it published instead of in the Microsoft Fabrit I Want to Publish It Microsoft Fabrit I Want to Publish It into my own server i want to publish it into my own cloud service okay for that they Don't Have to Go for the PBI Desktop
OK and the Microsoft Fabric account write Right they don't have to go for the Microsoft Right they don't have to go for the Microsoft Fabric Account They Can Go For This Model Fabric Account They Can Go For This Model That is pay as you go model
OK Where They Have to Pay Only for the Time They're using it okay so the charts okay Basically it's embedded into the organization As a word in ah is a word it ah itself Is pretty much clear embedded means you will Be Able to Use the Benefits of PowerBI
into your own you will be able to integrate That into your own application Ok Yes for external cloud if in your own Organization You Will If You Want To Get The Benefit You Have to Purchase This PowerBi
Embed and Again This Is Not Free This Is Pay As You Go, How Much You Use It You Have to Pay For That Only It's Simple Same As Like Yours Google Colab and Google Drive Right After
15GB If I Wish to Use More Space If I Need More Space in Google Drive What I have to do I have to pay the amount right Similarly, for that matter, as well as pay as you go. More You Use It There for the Amount You Want you want to use it you are going to use it for
that as well you're going to integrate the Benefits of PBI into your organization Cloud I hope I'm clear till this part
Have you mentioned it's the desktop architecture? No worries only this is the theory part then We'll be going for the installation and the hands on part okay no was about this so Do have mentioned the Pab at desktop Architecture But Actually This Is the PBI
Architecture OK We're Having the PBI Architecture Here So Please Understand Architecture Here So Please Understand Here okay using the so this desktop application so which we are also going to Install it today yourself in our system
Using the PBI desktop we are going to Connect which one we are going to install in Our system right in our offline system OK Then use once we are in once we have
installed it we will be able to connect to Multiple Different Data Sources Weather It Oracle Sales Force SQL Right You Will Be Able to Connect Do All the Analysis Once You
have connected it you will be doing all the Analysis in the Desktop and Once You Have Done The Analysis You're Going to Publish It Into The Microsoft Fabric So That Other Peoples
are also able to contribute they are able to View the Reports Right End Once You Have Publish They Will Be Able to View The reports using their desktop and The reports using their desktop and Laptop Right This Is Pretty Much Simple Here
Right Now There is a term Gateway Power BI Gateway Power BI Gateway Okay, so you can just think of it as the gateway.
as a door as a door for example think about it okay So in the Power BI service in the Power BI Service We Have Publish The Report The Report
Service We Have Publish The Report The Report Which we created ok was connected to an Offline File That Is Your Any Excel File and CSV file or any folder which is Present in inside your system which is Present in your local drive right after
Few months you have updated that data. data You have updated that data right now if you You have updated that data right now if you have updated that data ok will it Automatically reflect in the PowerBI Service report as well weather others in the.
Organization Will be able to view that report automatically One Way One Way If I and See the Thing About What I'm discussing right now, I think Have already done the analysis in the existing
Have already done the analysis in the existing You know the data set I have I have already done the Analysis I have published the report into The service okay my piers are able to view That now after a few does what happens new Data Came in the New Data Came in It Will Be
automatically write the analysis in The Desktop It Will Be Reflecting That The New Data It Will Be Reflecting That But What about the service OK what about the service it will not be Automatically Reflecting It If We Don't Do
Anything one of the way if I want that the new Data should be reflected right I have to Go for republishing it I have to go for Republishing it every time new data Gets updated into the data set present
In the local folder I have to go for Publishing It Every Time I Have to Do That But if I want, I don't want to do that every time if I don't want to publish it and if I Want to Automate the Process That Whenever There is an update on the data in the local
Drive what it should do, it should securely Connect to the drive to the data set Present in my local drive and it should be able to update itself it should be able to
Refresh Itself Then I Need to Set Up a gateway I need to set up a gateway so that the Report present in the service already publish report in the service it is able to
publish report in the service it is able to Connect to the file which is present in Connect to the file which is present in My Local Drive and Securely Republish My Local Drive and Securely Republish It Securely Refreshes the Data It Gets
automatically so that others are able to view It is not allowed without the gateway Without the Gateway Automatic Refresh Is Not Available Allowed because think about it. Ok? Think
About it. If I don't set up a gateway. Gateway as I mentioned it's basically a door. So it will securely connect to that only that particular file only to which how your
Report was created. It will securely Connect to that particular file only. Right? If There Is No Gateway, So Are You Okay With It? Giving the Access to the Cloud to Connect Giving the Access to the Cloud to Connect With all the files present in your system.
Security is breached right in that case v Don't Want That in Your Power BI Service is able to connect to all the files in my system no right i want only that particular file i want only that particular file which with which that
The report was created if I wanted to do so. That Is Done With the Help of Power Pi Gateway Power BI Gateway Securely Connects to That particular file so it's like a door it
particular file so it's like a door it like your door which allows only which Allows you to and permits you to connect to only to that particular file with which the only to that particular file with which the File report was created
Question from the Noon is that if your data Set so that's what I mentioned if your data is present in the offline file you need a you Have to set up the gateway generally what happens the organization does that okay if you Are you using an organization account you have?
That organization does that. Ok? But if Your data is already present in the U.K. Online Systems Like Your AWS, Your Google Sheets See for Connecting to That You Are
Directly connecting. you are not Directly connecting. Your IDs R Connected with it. Ok? So that is why it Will be done automatically. that will not a Problem. For the online files, for the Live files, that is not a problem. It
Will be able to do so. But this is mostly Required. The Gateways Are Mostly Organization data present in your local System. System. Am I clear?
As an analyst right when you connect to the Sales Force, That Is Mostly Not With the sales force data, right, your Organizations are going to set up the data For you. Ok? So Do You Don't Have to Worry For that?
Now coming to the components of your Desktop. Ok? So the Desktop You Will Be Desktop. Ok? So the Desktop You Will Be Having Something Known as Your Power Query Editor. Ok? So this is a tool which comes with your
Excel. So if you are aware with Excel I Hope That You Have Seen the Power Query Editor There's Well It Is The Exactly The Same Application Which is used for cleaning your data? Which is your data cleaning tool?
Comes Absolutely Free with Your PowerBI Desktop. Ok? If You Are Aware of the Power Query Editor We're Going to Focus Our Session Today Only the Power Query Editor. So Exactly The Same Power Query Editor Whatever You Have
In Excel it is the same thing that is used For your data cleaning. So This Is Again Park Query Editor It's a Separate Application It is a separate application that comes Absolutely Free with Your PBI Desktop OK
And also your Microsoft Excel Right PBI Desktop & Microsoft Excel Right PBI Desktop & Microsoft Excel Then we have the power pivot as well going for The Summarization Right in Micros in PowerBI What happens is that all the data is right.
Go for the visuals We go for the visuals And finally, you are aware of the You Know What If I want to get the aggregation may be I want To Get the Total Sales Right
Maximum sales may be what I want to get. Count of Sales Minimum Sales Everything So Count of Sales Minimum Sales Everything So This is exactly work like your ah you know That Exactly Works Like Your This One Only Your Pivot Tables Your Pivot Tables
In Excel and this is your Power View this Is Nothing But Where We Create the Visuals Where We Create the Visuals That Is Known as your
Report View OK, we're going to discuss once we get the Installation Once We Do The Installation. So Let's start with the installation. Let me please can you confirm me how many of you Have Not Installed and How Many Have You
Have Not Installed and How Many Have You Installed. How many already have it? Anyone having it? ok ok give me a moment
So those who don't have it let me share my Screen Screen
Application Write It's a Microsoft
MacBook. सो इफ यू आर यूजिंग Mac यू हैव एंड देन इंस्टॉल अह PBI इन दैट। without दैट यू विल नॉट बी एबल टू डू सो। Ok? End
For Windows users. सो बेटर इफ यू कैन यू
Mac? Anyone using Mac.
No one that's greater than that.
लुक्ड इंटू द इंस्टॉलेशन एज़ वेल। So today टू डिस्कस अबाउट डेटा क्लीनिंग। Ok? data
Power Query Editor. And It There Is Some Time We are also going to create a chart. So that will be the agenda for today's session. V have already looked in the introduction and the Installation. Now we are going to look into loading the file and also before that
Loading We Have to Understand the Interface Introduction to the Interface. Ok? So first of all I am not going to
Load Anything. I'm going to inst show you The Interface Right Now: How Does the PBI Look? The Interface Right Now: How Does the PBI Look? Like. Okay let's start. So once you if you Go once you have installed it and you can Just Go To The Search Button You Can Right
Powerbi and you will be able to double click From here also. You Can Get the PBI Desktop Open From Here. or you will be Getting a shortcut in your desktop. you can Double click and open from there as well. Anything Works. Once you open the PBI
desktop, you will be getting this is your First Screen of Your PowerBI This is Your First screen of your PowerBI. Ok? You might be getting suppose if you are opening the
PowerBI for the First Time You Will Be Getting Started Videos and Something. You can simply cross that. you can Simply cancel that. Ok? after that
you will be getting This area. So This Is You Can See the Different Data Sources Here. Ok? But we are not Going to load the files from here. We Are Not going to get going to load the files From here. Ok? Once This Is the Starting
Screen. Every Time You Open Power BI You Will be able to get this screen this Will be able to get this screen this Interface. Right? You have this data source and Interface. Right? You have this data source and Apart from that any file you work on.
Will Be Listed Out Here in the Recent Part Right in the Recent Part
Yes exactly the same thing this is Swati has Share the interface Let me show it to you all Share the interface Let me show it to you all give me a moment
Getting It for the First Time This Is What Exactly You Will Get Time This Is What Exactly You Will Get Right, this is the data source we're not going to to load the file from here right now ok And This Is the Getting Started Videos
And This Is the Getting Started Videos And from today on words if you open Any File You Work With Any Files You Will Be able to see the options here. So Currently It will be blank for you if you are doing It's for the first time.
Give me a moment. Now what you all need to do once you are in the Screen Right Once You're In Getting This Interface You Have to Click on the Blank Report. You have to click on the blank report.
those who are installing it please remember the Steps. once you click on it just you have Two click on blank report. ok just one Step Blank Report. Now this is how your interface looks like. This is how your Power BI looks like.
Ok? So those who are installing also, Please focus on my screen right now. Please focus on my screen right now. Please focus on my screen right now. Ok. I did mention one term there in Power BI.
I cross that ex you know you remember drag End drop. Instead of drag and drop End drop. Instead of drag and drop Mention about expand and Mention about expand and Collapse. Power BI is More About Expand
Collapse. Power BI is More About Expand And collapse. Ok? So towards your right. Towards your right if you check you will be Getting three pence here okay one is nonetheless
Getting three pence here okay one is nonetheless Your Data Pane One Is Your Visualization Pane Your Data Pane One Is Your Visualization Pane And one is your filter pen so there are
Now I Mention the Terms Expand and Collapse OK Expand and Collapse Check Here If I Wish to expand the data pan currently no Data date has been loaded. so you can ExpandIt. So this is your data pane. You Haven't loaded any data yet. If I don't
Haven't loaded any data yet. If I don't Want it collapse it. C I'm getting all the Visualizations. Collapse it Expand it. Collapse it Expand it. Right?
Like Any Microsoft Application You Do have the have the Tabs Here You Have The Tabs Here
Get Different-Different Groups This Is Your Clipboard Group This is your data This is Your Query This is your insert. so you are getting SmallSmallGroups Exactly Like Yours Microsoft Other Microsoft Applications Even In
Microsoft Other Microsoft Applications Even In Your Excel also you must have noticed that. Your Excel also you must have noticed that. Ok
Now how do I load the data? Shall I Proceed Everyone? Whatever You Are Here Right Now You Can See This
Get data option here right these are the Different Data Sources You Have Right We are going to load today's Excel work on Me But I Want To Show You Since Today Is Ours First class I'm going to show you I am Going to go from the very scratch right
Going to go from the very scratch right Now what are the data sources there? I mention there are 150 plus data sources. If you want to check okay what are the different Data Sources We Can Connect to You Have to Just Click on this Get Data Option. you have
Just Click on this Get Data Option. you have To Just Click on that Get Data Option. To Just Click on that Get Data Option. You can see the common data sources. Ok? You can see the common data sources. Ok? Just you have to click on the more option. I
Just you have to click on the more option. I Option. I am selecting this more option. If I click on the more option I will be If I click on the more option I will be
Can Connect To and PowerBI Desktop Can Connect to. यू कैन चेक एक्सl वर्कब इज़ There, text CSV is there, XML, Jason, फोल्डर, PDF, Verw Share पॉइंट। So
You can just check. So I'm currently in the first interface. You हैव टू गो फॉर द गेट डेटा। we are trying टू लोड दैट सैंपल सुपरस्टोर फाइल। We Are टू लोड दैट सैंपल सुपरस्टोर फाइल। We Are
Once you are in the get data you can just From here as well. गेट डाटा एक्सेल वर्क If you click on that
यू हैव टू चूज द डाटा सेट। you have to choose Ok? So I will be going to that. Browse To that path please.
गेटिंग द नेविगेटर पेन। So it is trying To establish the relationship.
You have to go for the Excel directly Totally up to you please check here you have to Go for it, I'm showing you again, please check it. out here that was just for showing what are The Data Source Process Is There You Have To Go for this get data option
Go for this get data option
however you find it easy click on so
Select The Sample Superstore Click On Open
will of course what it will do it is that Don't want that. Right? we don't want to Cancel the loading process.
Currently there are three sheets or three files That one. वी हैव ऑर्डर्स, पीपल्स एंड Returns. बट वी आर गोइंग टू लोड ओनली द ऑर्डर्स फाइल राइट नाउ। we are going to लोड ओनली द आर्डर फाइल्स। So that is why
Sheet. We have checked only this sheet. Ok? Want that. सो, व्हाट इज़ द डिफरेंस बिटवीन द लोड एंड द ट्रांसफ़ॉर्म डेटा। ok let me
द लोड एंड द ट्रांसफ़ॉर्म डेटा। ok let me tell you if I click on the load option if I Click on the load option
Ok. सो फॉर नाउ सिंस वी आर डूइंग इट फॉर Load. Simple Load Don't Go For Transform data. Just Simply Go For Loading The Data.
Click on load please. Once done let me know. R Beginners Here. So That's Why I Am Taking it slow.
Time. यू कैन सी हियर इट इज़ ट्राइंग टू Build the connection.
Expand Please click on expand
So the data pen what will it show you? It will show you the fee. The Data Pen Will Give You the fees. Right? Right? All of you clear till this part.
योर पावर बीआई इंटरफ़ेस। This is your power फील्ड्स प्रॉपर्ली। please observe the
The fields are arranged in ascending order. The fields are arranged in ascending order. The fields are arranged in ascending order.
ID Postal Code Postal Product ID So All these are arranged in ascending order From smallest to largest this is the Default Behavior of Your Data Pane the Data
Is arranged in your ascending order this is Not the Actual Order in Your Data Set It Not the Actual Order in Your Data Set It Is Not Representing the Actual Order It is representing, it is arranging the data. It is arranging the data in ascending order
also also please check here somewhere ok if you Look into the data if you observe the data Properly the Field Names You Will Be Able to Properly the Field Names You Will Be Able to Notice that somewhere the summation icon is mentioned
Notice that somewhere the summation icon is mentioned You Can See the Summation Icon Somewhere It Is You Can See the Summation Icon Somewhere It Is Missing Right You Can See In The Discount In Missing Right You Can See In The Discount In The Postal Code in the Profit in the Quantity
The Postal Code in the Profit in the Quantity In the row ID in the cells you have the In the row ID in the cells you have the Summation icon OK now you are seeing the summation icon OK that means it is a numerical column
OK that means it is a numerical column Non-age Majors All these are numeric values. All these are Numeric values ​​that are known as measures here Yes they are known as measures here these are
Numeric values ​​OK the new numeric Values ​​Where You Are Going to Do Some Kind of Aggregation Discount Postal Code OK Profit Quantity These are all numeric fields These are all numeric fields
Change it later OK the data type because it has because it is a numerical field so it has identified as summation it has Identified as summation we can go for Changing the Data Type Here I Will Show You Letter
Okay currently wherever you are seeing this summation icon wherever you are getting the Summation Icon That Means That There Is a Measure Here Right That Is a Major Here and Wherever You Are Right That Is a Major Here and Wherever You Are you are not seeing anything wherever you are not
Seeing Anything Suppose the Category Than You Have The Customer Name You Have The Order ID All Dose Do Things Right Where You Are Not Having. So those are categorical ones.
Categorical column and you can say Quantitative Values Quantitative Values Quantitative
Dimensions in the BI tools may be in Pabi and Tab Understood
Numerical columns are known as measures and Categorical columns are known as dimensions. I Hope I am clear with that.
Calendar icon in the order date in the ship Calendar icon in the order date in the ship Date You Can See a Calendar Icon Right That Is Your Date You Can See the Calendar Right That Is Your Date
You Can See the Calendar Right That Is Your Date I Hope I'm Clear
Present here. बट दिस इज़ शोइंग यू द Ascending order. This is not the proper The order that your data set actually has. Right? Also, also now if you wish to check. Right? Also, also now if you wish to check. Ok? If You Wish to Check How Your Actual
Data is present. How your actual data is present is present In the original data set. Ok? so you can go In the original data set. Ok? so you can go For clicking this.
This is known as a table view. Check the cursor please. Over there right? If you take your cursor there You will be able to see the name of it. It's the
You will be able to see the name of it. It's the Table view. Click on that. This is the original sequence of the data. This Is the original sequence of the data you Is the original sequence of the data you Have the row ID, order ID. Ok? donation
Order Date, Shift, Date, Ship Mode, Extra. Extra. It is not arranged in ascending order.
that view right to go back to that particular View You Have to Click on the Report View You have to go for the report view so this View this particular view which you are
Getting Right Now Which You Are Able to See right now this is known as your
Our Reports. That Means We Go For Creating Different Kinds of Charts and Graphs. We Create the Reports Here. V Create the reports here. Create the reports here. Ok? So this is known as your report view.
Ok? So this is known as your report view. This is none other than give me a moment. This portion. So there you can see five Views here. Just give me a moment.
If You Take Your Cursor There You Will Be Able to see that is known as the report view that is known as the Report View.
Looking at is known as the report view. The Is your table view you are able to view the Data Exactly That Is Present in Your
Data Exactly That Is Present in Your Data set this is known as your Table View Next Comes Your Model View
As I mentioned, if you are dead, you have data Coming from multiple different sources right You will be able to build the relationship here. So currently we have only one table so you are Getting Only This Table Here. you are getting This table here. And for your PL 300 right
Questions will be mostly related to this Portions only. These Three Views Only For Your PL 300 who are appearing for Microsoft Certification Exam for Data Analyst: Okay, you'll be getting from this. three views only okay so this course is
Limited to that apart from that in to so This Was the Earlier These Three Views Were This Was the Earlier These Three Views Were Only available but I think from 2025 ah Only available but I think from 2025 ah 2025 July Okay 2025 Ah July and Okay
2025 July Okay 2025 Ah July and Okay 2025 January The Dex Query View Vas The Dex Query View This is known as decks query view it was
This is known as decks query view it was Introduced OK and in July 2025 V Introduced OK and in July 2025 V have TMDL View which is known as yours
View which is known as yours Tabular model
Particular View Right TMDL for That You Should be aware with some codings. for view You should be aware of some codings. It's like a coding environment. It's
Like a coding environment. TMDL. End This is for the Dax query view you have. So you can automate the queries from there. You can go for automating the queries for This part. Ok? For but generally for the PL 300 You Get Questions From This Particular
View only. So these are the five views. You can go for writing your queries. Ok, And you can ask the queries. Generally, if I
Go for the when we go for decks I will do Discuss in detail. Ok? But some of us might Descriptive Statistics Statistics from that. You can go for the
Desk Query View. You Can Go for the Dex QueryView. But generally we go for using This three one one all ah three versions only, Three views only. Report View, Table View, ModelView. And the Dex query Also if I go for creating decks
Fields Also I Can Do It From Here Only But This Makes Our Life Much Easier It will help us in automating this. Write a Simple Query and We Will Be Able to Run the query to check ok we can go for run The Query to Check What Is Happening
You want top if you want on the details of Like Top 100 Customers You Will Be Able Like Top 100 Customers You Will Be Able To get that age well.
We will talk about that once we go there. OK now see the thing is the thing is once we Have this data right once we load the data as I mentioned real world data will have some you
No, if the raw data will have some lots of Issues May Might Be Having You Know Missing values ​​duplicate values ​​and if we under Formatting Issue Will Be There And If We Want to make some changes if we want to make Some Changes We Have to Go for Cleaning the
Data We Have to Clean the Data So Far For That we have to go for a different Application. We have to go for a different Application That Is Known As Your Power Query Application That Is Known As Your Power Query Editor which is used for your data
Cleaning and which comes absolutely free with your Power BI. Right? The Data Cleaning Tool. So For this, what you need to do, either we could How I got ah the click on the transform data And we have got here. But Now Since We Have
installed we have already loaded the data we don't have to go for loading it again from here also we can go for the Transform the Data That Is We Will Can Transform the Data That Is We Will Can Go for the Power Query Editor by clicking
Go for the Power Query Editor by clicking On the Transform Data option also we can go to the Power Query Editor So You Have This
Transform Data Option Here Click the first option is Transform Data So if you click on the transform data it Will Take You to the Power Query Editor Check
Your Excel as Well are you all getting it
so this is a different application okay this is A different application Now the thing is if you remember while Loading the file right while loading the file
Loading the file right while loading the file We Have Orders Data We Had People Table We Have Orders Data We Had People Table Right We Also Have Returns Table Right We Also Have Returns Table Returns table but we load only a single
Data That Is Your Orders Data We Load Only A single data that is your orders data now We are in the Power Query Editor We are in the Power Query Editor If I Want to Load the
Power Query Editor If I Want to Load the People Table and Return Table If I Want Want to Load the People Table and the Return Table That Is Possible From Here We Can Load It's from here. सो प्लीज चेक इट आउट इफ आई Want to load the data once you are in the power
Want to load the data once you are in the power Source option. Can you say that under the home Tab you have the New Source option.
एग्जैक्टली द सेम ऑप्शन। so you have this Excel Workbook You Have This More Also Please click on more. Please click on more.
The Box That You Got in Your Power BI Interface. The Gate Data. What does it mean? The Interface. The Gate Data. What does it mean? The Get the data you've got in your Power BI was Actually a Part of Your Power Query Editor. The Get Data dialog box which you
Got in your power bi was actually a Part of your Power Query Editor. Ok Yes. So what can you do? You can load the
Yes. So what can you do? You can load the Data. See You Have This Excel Workbook Go Data. See You Have This Excel Workbook Go For Connect.
OK Again Sample Super Store open Data in the Navigator pan I will be Selecting I Can Load the Files Together
OK I can load all the files together I am Going to Click on the People and the Returns Going to Click on the People and the Returns Just check the boxes
Done are you able to see the people orders and Returns Unstable
No I did not did you close the existing Files Ah No No No I Did Not Exist Files Ah No No No I Did Not Exist Do anything here please check here So this is my existing file where Orders data is already there right it is
Already present now what I have to do ok now what i have to do i have to do ok now what i have to do i have to Go for this new source okay you have to go For the New Source And you have to go for more options
excel workbook Connect Sample Superstock My Orders Is Already Loaded my orders are already loaded now This time I need to load only the people and the Return sir just check these boxes. I
Return sir just check these boxes. I Am not loading the orders data again because If I do so it will be duplicated. I Don't want duplicate values ​​right? Simply Click on OK. You'll be getting it here in the queries.
Kindly confirm me. Are you able to see that? See these files?
now please check here Now please check here so I am in the people's Now please check here so I am in the people's Table Please click on the People's Table
Power Query Editor Is Used for Your Data Cleaning. Now if you select check Select the people table right can you see any Issue with this data?
Properly the Power BI Say If I Talk About The Powerary Editor Also It's An Intelligent The Powerary Editor Also It's An Intelligent Tool It Is Not Able to Identify the Headers properly it is not able to identify the Headers Properly
Right Now What We Can Do By Just Simply clicking it I can go for making The header as one. So if you check the data Properly you as an analyst you have to
Properly you as an analyst you have to Understand OK you have to go through the data And you can understand okay you have regional Manager, you have reason here they are talking. About Some Region So West East Central South Here we have the person names probably this
Here we have the person names probably this Is the header this is the header right but PowerBI Is the header this is the header right but PowerBI And Power Editor is able to find that And Power Editor is able to find that right so what you can do here
First row edge header. What can we do? Just Simply Go For This Forest. Are you getting just towards your right use? First row as header. Are you able to get it? Are you able to see the option?
Are you getting this option use first row s Head
Getting Use first row as header. please Click on that. Click on that. Please click on that.
ok once you go for this you are getting the Headers You're getting the headers Just with a simple click
Can you go for control G right now that is Can you go for control G right now that is undo it Like we do in the a you know Microsoft platforms
Once I've got like updated the headers Can you go for control G? Yes, so the thing is that if I try to go
Okay, that's because whatever you're doing. Edit option here Undo option is there OK
want to undo any step okay you can see
So, whatever you step into, you do, right? It Gates recorded in the Applied Steps. It Gates recorded in the Applied Steps. So, whatever you do, right? C, we have So, whatever you do, right? C, we have Just we've just promoted the headers. But
Just we've just promoted the headers. But Types. Don't worry about that. Ok? So, if
You will be getting it. Since, there is no Option for Control C here. there is no Option for Control C here. there is no Option for Control G here. anything you Do, anything you do, all the steps are Recorded in the Applied Steps. so if you
Want to undo any steps, you have to Cancel that steps. Cancel that steps. Am I clear?
So, let's do it again. This Was Just Purpose For me showing you. Ok
You Can See Here Just Before the Headers We Are Getting ABC What Does That Mean Now okay what does that mean so these are the type of data it can store that is the data type so
This is a small data let's click on the Orders data please Orders data please Let's click on the order state please. So it becomes much more clear right now. It Becomes much more clear right now. hear you
Have one two three. Here you have ABC. So As I mentioned it is an intelligent tool. It is able to identify the type of data by The Values ​​on Its Own. Right? so you can
Click OK if you want to check what the Data Types Are Present in Your Power Query Editor What are the data types that Are present in your Power Query editor Are present in your Power Query editor You can go for simply clicking over there
Just Check Here suppose this is one two three right Click here You will be able to see all the data types that You will be able to see all the data types that are present ok ok please give are present
are present ok ok please give are present In your Power Query editor these are present In your Power Query editor these are present In Your Power Query Editor Not Power Vi power query editor You have decimal number. You have fixed decimal.
You have decimal number. You have fixed decimal. Number so one to three is referring to whole Number you have Percentage you have Date and time You have date time date time time zone Duration Text True False Binary Using Local
Majors and columns and again it's on the Power BI interface. This Is Your Power Query Power BI interface. This Is Your Power Query Editor. It's a separate application.
Ok. Now if you check here there is something non-age difference between this ok so please check here Let's go to a numerical column that is may
Let's go to a numerical column that is may Be Your Sales and Profits Let's Go for This Scroll Scroll OK you will be able to go For That or You Have Sales column For That or You Have Sales column Please go to your sales column
OK now in the sales column you're getting 1.2 You're getting 1 2 that is referring that it You're getting 1 2 that is referring that it is a decimal number right it is a decimal is a decimal number right it is a decimal Number now over there just give me a moment
If you check the decimal number ok you can see Somewhere there is two digits there somewhere After the decimal point there are four digits Somewhere There Is Three Digits Somewhere That There is one digit, this is your decimal number. But if I want to fix it, okay, suppose if I
Go for clicking this and go for fixed Decimal number. Here. If I click on this I want to change It to fixed decimal number. Click on that
It to fixed decimal number. Click on that And go for add new step. Add New Step Because if I don't I go for replace current It will be doing it here only. But I want To add a step for that. So Just Click On Add new steps.
And now see the difference. Now see the difference.
See the Difference Can You Find? Ok Check here. 1.2 is there right. Click on that Change. Ok. First Look Into the Data. once Your decimal number is present. check into the Digits after the decimal point. Somewhere You Have four digits, somewhere you have three digits,
Somewhere you have ah to digit, somewhere you have One digit. Right? This is your decimal number. One digit. Right? This is your decimal number. Now You Click Over Here And Go For Your Fixed decimal number. Go for add new step.
Go for add new step. You go for add new step. Now Check the Difference Here What Are the Changes you are getting
Kindly confirm me if you are able to Understand Till This Part Yes It Is Taking You Some Everywhere If You Check Right Everywhere If You Check It Is Consistory
Everywhere It Is Consistent Only to Digits Only to Digits Digits Only to Digits Right also one more thing if you notice you are getting another step added
another step added You're getting another step added for that
See What Is the Benefit Can't See That Option It is different okay I will let you know okay Richa so please check here what is the Benefit of adding another step okay Suppose if I go for adding another step if I I don't want to do it if I don't want to do it if
I do it in the same step this will be Replaced Okay and if I go for this. If Replaced Okay and if I go for this. If I want to delete it, it's gone. Only for This step I have done it. If you do it in the Existing, it will do it for here. I
Don't want in the existing one. So That Is Why I added a step here. I added a Why I added a step here. I added a Step here. Another step. Okay Icha?
Only Two Can't See Aswati you mention that can't see that option it Aswati you mention that can't see that option it Is different or can you please be specific What did you mention by that which option You are not able to get the fixed decimal R
You are not able to get the fixed decimal R You're Not Getting the Fixed Decimal
You can't see the escape option. OK, a new option will probably be there. You have added can you cancel that please can You cancel that suppose if I wish to go for This discount so please go for this discount
Go for fixed decimal number Are you not getting the change column type add Are you not getting the change column type add New Step Check It Out
for the wrong step okay you're going for the wrong step so what you are doing is that You are going for clicking on this filter So not filter you're going for right click You're going for right click I don't go For right clicking it. Don't go for right
Click. You have to simply click here. Aswathi please go for simply clicking Here. Just click don't go for right click. Click Just click don't go for right click. Click You will be getting it.
So Understood About the Fixed Decimal and The Decimal Number Any Confusion Till Here so we will go for a break we will go for a Long break I know that we haven't gone for that Ok
OK, is it possible for us to define the decimal places here suppose I want to three decimal numbers you can do that okay you can Do that using the M Query Language not Directly here by default it takes your Two Digits Only But If You Wish To Go For The
after decimal you want three digits for Power BI We Do Have the Ah Option for That So we'll be doing it in the Power BI not here okay here we're just going for a Better Representation This is a Data Cleaning Steps No Formatting Here That
One we can do it for your PowerBI interface As well as so, the thing is we're talking about About the efficiency. the number of steps you take Increase right? the number of steps you take
Increase What Will Happen? The Time to Load To the Power BI it will be more. So in that Cleaning also to make it efficient. Ok? We are going to add only those many steps We are going to add only those many steps Which is absolutely required. Ok? If
You want to modify anything here. If I Because by default you have seen that it is Two. By default it is two. Right? based upon the data you are using but if you wish to
Go for Writing It If You Want to Modify It Here You Have to Go For this option Advanced Editor So Can You Check We Are Just Going for click click click click click
Going for click click click click click But what is happening in the back end But what is happening in the back end Advanced Editor Click on the Advanced Editor In the back and it is getting converted to Codes. Whatever the steps you have done, you
Codes. Whatever the steps you have done, you Will be able to see the codes for that.
So this is known as am quarry. this is known as M Quarry. Like if you're aware with Excel right In Excel, Excel is where we go for clicking. In the back and it is getting converted to the Visual Basic for Applications Coding
Language Here It Is Ah Getting Converted To the em querie language I'm talking About Your Power Query Editor There Is Different Data Types We Have Seen If You Click on that you will be able to see the data Type here OK you will be able to understand
these things Right Right Now also you have you can check here one thing I'm going to show you one more important Thing Here That Is
split columns Can you see that split columns option? Can you see that split columns option? Are you getting it under the Home tab only?
ID column Just Click on That Select the Order ID column Right Click on the Split Column Now Split
column means if you check the order id column you Have you been having the first you know the state and The Country State Name Then You Have the Year And then you have some IDs and you have some
Separators. You want to split it. Split it into suppose three columns. Right You have the option for that so you can check Here There Are Different Options There Are By D Limiter by Number of Characters by Positions By Lower Case By Upper Case By
digit non digit by non a non digit to Digit so let's start with the very first One That Is By Delimiter Please select the Order ID column and go Please select the Order ID column and go For by delimiter please click on that
Now once you get this dialog box when you Select the limiter you can already see. Select the limiter you can already see. Option Hafen Selected for You It Has Identified it. Now How Do You Want To Split the data? how do you want to
Split the data? By Left Most Delimiter, Right Most Delimiter and Each Occurrence of the delimit? we have to Delimiters, right? We have to delimit. So We if we go for each occurrence of the delimiter And click on OK please go for clicking
On OK. Check What Are You Getting? Check What Are You Getting? Click on OK.
Instead of single order ID are you able to Get three order ids? Yes, are you all getting it? Now the thing is you can notice one thing.
Power Ah Power Query Editor Is So Intelligent. Not only it is does. we have Just Asked It To Split. it has Split the data and also based upon the Data Write It Has Identified the Data Type As well as it has identified the data type as
well. So You Can See Here This Is All Text. So That Is Why It Has Been Considered It as text. These are all numbers. So Whole Numbers it has considered as one to three. Numbers it has considered as one to three. Similary for this as well.
Right? Yes. Yes. Now Also If I Wish to Rename the Column If Now Also If I Wish to Rename the Column If I Wish to Rename the Column I Can Do So Just
double click okay double click and you can just Rename the column to it Rename the column may be Rename the column to it Rename the column may be Order State You Can Go for Order State Here You Can Go For
For Order Here Just Double Click and Write Like Order Here Just Double Click and Write Like The Way You Do in Excel
Steps Once You Are Done Renamed Columns Split Columns Change Type Three Steps Have Been Added. please cancel The Steps.
Tell me which one you want to try. Let's Go for number of characters.
Used to split the column. Let's go for Three. Three. Let's go for three and click on OK. Let's go for three and click on OK. Let's go for three and click on OK.
What do you get? Please If You Have Any Confusion Feel Free Please If You Have Any Confusion Feel Free To ask.
Are you able to get it? See Three Characters You're getting a split 202 split You're getting a split 202 split Zero underscore sorry not underscore halfn one Split. so for every three characters it Is splitting isn't it? repeatedly because
Is splitting isn't it? repeatedly because We have mentioned repeatedly.
If anyone if you want to go for try out anything Right side pain is not appearing for me. R You talking about the query setting sure?
You're not getting this, you're in the power queue Editor. Ok. What do you have to do? you have Editor. Ok. What do you have to do? you have To go for the View tab. You have to go for the
To go for the View tab. You have to go for the View tab. In the View tab. View tab. In the View tab. You have to go for clicking this option.
Query Settings You will be getting it back.
Now are you getting it? Ok. You go for trying any one of this and later Others, you can take it as homework
So I am not discussing regards, okay if you Want to just try it out. you can go for Trying this out as well. Keep Rose, Remove Rose, Ascending. So this is the same. This is Pretty Simple Here. Ok? So, please check Here What Are These Things? give me a
Here What Are These Things? give me a Moment. Explanatory here. Because it's the same as exactly as Excel. Because it's the same as exactly as Excel. A to G, A to G means you are arranging the
Data in ascending order. Right Ascending order for example I am selecting the order date I am Selecting the order date lets click on a Selecting the order date lets click on a Two G
OK I'm getting in ascending order First 2018 data I'm getting then I will B. Gating Okay, let me go for clicking on this. Okay, let me go for clicking on this. First I'm having 2018 then I will be
Having All the List May Be Incomplete Light Let me click on more there I will be able Let me click on more there I will be able To See All the Year Data See 2020 21 Understood similarly we will be getting 2019
as well This is your ascending order similarly we Can go for arranging the data descending Also this is pretty much clear
This is not the formula. this is exactly The Same Thing That Is Your Sea We Are Just Going for clicks. But in the back and it is Getting converted to m query. So This Is The M Query. So whatever you have done right? This is the M query for that. in the back end
This is the M query for that. in the back end That is the M query. whatever we have done That is the M query. whatever we have done This is the M query for that
Yes this is a query we are just going for Clicking It
can you tell me how many number of roses are There in this data set? How many numbers of roses are there in this data Set?
Ok. So you are able to see here You are able to see here and tell me that it Isn't it 999 plus everyday okay but this is not the
The Exact Way of Doing So If I Want to Get the count right if I wish to get the Count how do I go for that if I want to Check what is the total number of records and Every day in this data set you have to click On
On The Transform tab. You have to click on the Transform tab. Ok? And there you will be getting the option Ok? And there you will be getting the option For count. Please count the number of roses.
For count. Please count the number of roses. Please count the number of roses. Exactly. So if I go for this count rose
Give me a moment if I go for Count Rose This is the value I'm getting right now This is the value I'm getting right now That is your 9994 That is your 9994 also you check your table has been converted
To a whole number isn't it? Your table has Bean change. All your data is gone. All Yours Bean change. All your data is gone. All Yours Data is gone. How do I get it back? Data is gone. How do I get it back? How do I get it back the data?
We have to remove the step. Do not change the Type. Remove the step from here. Apply Step. Ok? Delete the step from here. Delete the step from here
Delete the step from here OK and you will be getting your data back OK and you will be getting your data back Now Clear
OK now please click on the Transform tab Click on the Transform tab again. There is an option for extract Column Edge Well. There is an option for
Column Edge Well. There is an option for Extract column. Are you able to see it? Extract column. Are you able to see it? Extract column.
There is no Control C option here. Ok? There is no Control C option here. Select the Order ID. First Select Your Order ID. Click on the Extract Column
Order ID. Click on the Extract Column Sorry extract option.
Can you see the option? Extract option. there you go for Text before the limit you go for text Before the limit is up
Yes You Will Get the Dialog Box Extract Text Before Delimiter So in this case you have to mention the Delimiter. So I am mentioning it as
Delimiter. So I am mentioning it as Hafan. I'm mentioning it as Huff and Clique Hafan. I'm mentioning it as Huff and Clique On OK.
What Is the Difference You're Getting Here? What Is the Column You're Getting Right Now in The Order ID. How many columns are there? How many columns are there?
Now the question is 21 Swati you are getting 21 columns. After you write for extracted text Before the limiter, what is the column you are Before the limiter, what is the column you are Getting only a single column right
You are getting a single column after you have used now tell me what is the difference used now tell me what is the difference Between Split Column and Text Between Split Column and Text
Split End Extract You have used split using the delimiter You have used split using the delimiter Yes in Extract What Is Happening Here Yes in Extract What Is Happening Here
The Data You're Not Getting Other Values ​​You
Happening at that time what is happening to you
Data Cleaning Steps When We Go If You Are appearing for your ah pl 300 right Are appearing for your ah pl 300 right
So let's cancel this step. Let's Cancel The Step Right Now. The Step Right Now. Let's see another column. Let's go for
Ok. Can you check out the other options for your Split column? Oh sorry. Extract column? If You Wish to Extract the First Character, Last Character, Range, Anything Character, Last Character, Range, Anything You can do it. कैन यू ट्राई इट आउट प्लीज?
Split Extract the Difference You Have to Remember this. So check here. सो यूजिंग स्प्लिट राइट
Extract Here Text Before De Limiter Now I Mention the D Limiter It Was Automatically identified by your split
बट यू कैन आल्सो स्पेसिफाई। you can also Specify where to go right so you can go For the Advanced Option and Then You Want to Go for scan for the delimiter from the
Go for scan for the delimiter from the Skip I want to skip the first delimiter Just go for one and click on ok what is
If I go for number of delimiters to skip Because there are two delimiters if I click Because there are two delimiters if I click On OK Are You Able to See the Difference Here On OK Are You Able to See the Difference Here Mansa Nar Now You're Clear Initially We Were
Only Getting the State Names But Here We Are Skipping One Right Skipping One Right We're Skipping One Right
Column If We Do Extract Delimiter Then We Need to Filter Out Specific Products Filtration I Am Not Teaching You are right now, okay, feeling I will not teach You right now, so if I go for supposing product id okay product id so you
Have If You Want to Filter Some Products You can definitely go for it. Sleep Filter The option is there. You Can Go for the Text Filters like you have in Excel. I am Not Going to Teach You Right Now. Ok? so you Have This If You Want to Filter You Can Go
For this text filter option. Delimiters You want to limit go for that. Same thing. Same thing. You go for the extract the delimiter value and go for Extracting the Value. how do you Want to get the value suppose. Right? so you
Can just go for that particular text Filters You Can Go For It If You Want To Go for particular values ​​just check on this I'm Going for the Simple Basic Filter Right Now These Two Products You Want To Check Click on OK
so these are the products these are the Products you are filtering the everyday am i Products you are filtering the everyday am i clear
Let's go to the Home tab again. Let's go to the Home Tab Again Now some options are common in the Home tab and the Transform tab as well ok like in your Excel So similarly you have group buy option here
So similarly you have group buy option here You have the group by option here, okay, suppose Now think about it, think about it, you Want to go for checking
State Wise Total Sales Total Sales You want to check for state wise total sales Right how do I go for that you can go for Grouping the Data for That You Can Go For
Grouping the data for that okay how do it do It How Do I Do It So here group by you have two types basic Group by and you have the advanced age well okay
So first we're going for the basic one in The basic you once you create on the group by You are getting this dialog box there i Want the State Right Select the State Here
Have to give a new column name, okay, so let me Give the column name You can give any column name I I go for State Wise total Suppose sales ok and in the operation here since
Suppose sales ok and in the operation here since I want to get the total I go for getting I want to get the total I go for getting Some I go for getting some and in the column you Some I go for getting some and in the column you Can Mention Sales in the Column You Can Mention
Can Mention Sales in the Column You Can Mention Sales End and Click on OK When You Are Having This State Wise Total Sails Right All the Fields Are Gone All the fields are gone you don't have the other Fields
Can you notice that, can you observe that, you don't Have the Other Fields State Twice Total Sales You Can Obviously You can get the same thing using the
Visualization in Your Power BI Age Well. So I would never recommend doing the group by over here because the same theme can be achieved in Your Power BI environment as well.
Application right? Right? It's a different Application. But if you go for you know if you Go for Group by Here You Can Not Do Further Analysis in Your Power BI
Environment Be Because You Will Be Getting Only two fields there. you will be getting Only Two Fields There and What Analysis will be will you be generating from that. Right? So, it's always ah suggested that you Don't go for group by here. Ok? So Again
I'm canceling that OK, but what happens is that when we go. For Group Buy Right When We Go For Group By the original data The original data is gone
We Don't Have the Other Fields So We Will Not Be able to go for the further analysis same thing right whatever we are doing here this Things Can Be Achieved Using Visualization
Using Some Charts in Your PowerBI So That Is why going for group by is Not Recommended Here This Power Query Editor See it's a very good application for data Clean and We're Going to Stick to the Data
Cleaning Purpose Data Cleaning Whatever Cleaning is required, we are going to do it. Cleaning is required, we are going to do it. Only That's Okay, The Analysis Part We Are Not Going to do it in the Power Query editor The analysis part we're going to do it in the
Power BI Environment I Hope I Am Clear With That Things We Have Done After We Have Cleaned It Whatever Things We Have Done We Want to Save
Whatever Things We Have Done We Want to Save There is no option for saving it here Directly OK for saving the work and Quitting Your Power Query Editor to Go Back To Your PowerBI Environment you have this option
You don't have this cancel option right you have This Option Right Now This Option Right Now Close and apply. Are you able to see that? Close and apply. Are you able to see that? Close and apply.
UC On Close and Apply You will get three options here. One Is Close And apply. So what it will do is close and Apply means it will apply the changes and
Apply means it will apply the changes and It will close your Power Query editor and It will close your Power Query editor and Take you to the Power BI environment. It Take you to the Power BI environment. It Will Save the Changes and Take You to the Power Ah
PowerBI Environment. if you go for Apply, it will just save the changes. If any Changes you have done, it will just save it. But You Will Be Still in the Power Editor Only. It Will Not Quit The Power Query Editor. End If you click on Close If you click on
Close What Will Happen Is That You Will Just Close it but not save the changes. so if you Want to Save the Changes and Quit the Power Query Editor Go for Close and Apply. End
Query Editor Go for Close and Apply. End You are back to the Powerbi environment. There was so if you check here right city Column City Column Since I Mentioned You City
Column City Column Since I Mentioned You City Column Country Column State Column Right If You Column Country Column State Column Right If You Check here they are all marked as dimensions right these are text columns but there these Are geographic locations right if I talk?
About the postal code also this is This is not a normal geographical location. This is not a normal geographical location. Major So Power Query Editor Did Not Have Any any data type to identify it as the Geographical Location But Power BI Does Power
BI is also an application right separate Applications for Where We Do the Analysis So You Can Mark This Regional Column Geographical location with the data you know
Geographical location with the data you know type so how to do so please check it out type so how to do so please check it out I can mark it right now ok simply go For in the date give me a moment let me Expand the Data Pane a Little Bit
Simply Go for Clicking Don't Check This box ok simply go for click on this City Column Citi Field Just Click On This Citi Field Citi Field Just Click On This Citi Field You Shall Be Able to See This Column Tools Here
Kindly confirm me if you are able to see That or Not Call Column Tools That or Not Call Column Tools Just Click on the City
is sorry data type is text let it be Text but data category right it's Currently Uncategorized We can categorize it to city just go for
We can categorize it to city just go for Making It City Just Click On City What Making It City Just Click On City What Is the Change You Are Able to See There Is the Change You Are Able to See There Can You See the Globe Icon
That means it's a geographical location can You do the same thing for the postal code country You do the same thing for the postal code country end state
Similarly, select the country region Check the name of the column and category make it Check the name of the column and category make it Country and Region Similar Go for the Postal Code Click Postal Code You Have The Option For Postal Code Also This Is How Power BI
Understand it, let's go for the state as Well, so every time you once close the power Query editor for the geographic location You have to do this repeat this process.
So What Is the Difference That You Can See From the Excel file When You Have an Excel Workbook and When You Have a CSV File
When You Have a CSV File A in a CSV file you can check here ah in In case of your this one in case of your excel File you were getting a navigator pen where The sheets were present because in an Excel Worksheet we can have ah work book we can
Have Multiple Sheets Where Sheet Sheets Are Present in the Navigator pen and based Upon That Sheets We Have the Option to Choose Which ever sheet we require we have Which ever sheet we require we have Able to load it right but since this is a
CSP file obviously it is a single file Only you're not getting the Navigator Navigator Pan Understand Right You Are Directly Getting This
Now There are three options as usual okay you Have the load transform data and cancel Cancel will cancel the loading process Transform Data Now Yesterday We Have Seen What we get when we click on the
Load Data It Will Take Us to the Power BI interface but whenever we're going for you No, whenever we're going for the Analyze What We Do We Have to First
Clean the Data Because Data in the Real World Will have some issues right it will not be Clean. So let's check. So we will go for the Power Query Editor Right Now. This is the Exact process we follow for all the data. First We Go for Getting the Data and Go
For transform data. So check what Happens if you click on Transform Data. So that's the only difference. That's the only Difference. Load Will Take You to the Power BI
Difference. Load Will Take You to the Power BI Data It Will Take You to the Power Query Editor. Ok? Now Editor. Ok? Now Let's check that does it require anyone like ah
You know cleaning or not. So if you check the row Id it is a okay earny one two three the डेटा टाइप इज़ करेक्ट। So first when we Go for the Data Cleaning You Have to Understand. Ok. So this is an intelligent Tool. Based Upon the Values ​​It Goes For
Tool. Based Upon the Values ​​It Goes For Not. You have to check it once. so that's Why We Are Checking Right Now Ro ID. You Can C Order ID A B C Text Correct. You have this is a date. Date correct.
So you can just go for checking. Ok? that Is the first thing we do it. So you can see it's pretty clean not an issue with this not an issue with this okay if you
Are OK with it you can simply go for close And apply for this data it's pretty Clean Data You Don't Have to Do Anything With right now ok so you can go for close end Apply You can go for close and apply now
You can go for close and apply now Cleaning In between the date format is incorrect how to fix ah a this okay so if you go for the date format okay so if you find if any Date Format
Date Format Is not correct OK if any date format is not correct you can just click on this okay generally what Happens is that if you click on this if you Go for a date; it will ideally go for the same
Format Only It Will Have The Same Format Only Even If It Is in Bibiton It's Not Working Somewhere It Is Different If You Click on the date format you will be getting Click on the date format you will be getting The Same Things.
For the geographical location right? So I came Told you whenever we have loaded the data Back into our PowerBI interface, what we Can do, we have to categorize the data into
The Geographical Location. Right? We have to categorize the data. Right? We have to categorize the data. So how do I do it? So for the City column So how do I do it? So for the City column Suppose This Is Your City column
Just Select It Right and in you will be getting the column Right and in you will be getting the column tools okay the data type is text but you tools okay the data type is text but you Can go for categorizing the data as what
Can go for categorizing the data as what City. Meaning Power BI Now Understands That This is a You Know Geographical Column
Category is not required category it is a Dimension Just Go for the Geographical One Similarly, go for country and region as well Country and Region States Postal Code
Country and Region States Postal Code Categorize It Select Categorize It Select And Go For Categorizing It This Is Country and Region Don't Go for Count OK Go for Country and Region
If you click here if you do not check this Box Do Not Check This Box Just Click Here. Now Check Weather You Are Getting It Or Not.
Do not click on the check boxes. Just Click on the fields. Just Click on the Click on the fields. Just Click on the Field name. Are you not getting it? Great. [nasal sound]
and region, postal code and also scroll Down to the States. And go for making it a state and Province.
Summarization right? Let It Be Uncategorized. Let It Be Uncategorized. Ok? Let me do one thing here instead of Summarization I will instead of count I will Go for Don't Summarize. I will go for don't
Ok? Give me a moment. Number, right? of a row. So, you don't have to Count that. So You Can Go For Don't Summarize
No aggregation, no aggregation and you go for Uncategorized Only Nothing to Change Here So now you have to go to format your Report Page
or Format Your Report page And directly you can go for the canvas And directly you can go for the canvas Background Your choice ok any color of your choice I am going for a bluish color ok and I will make
It Transparent yesterday till this part we completed yesterday
can you please explain what exactly Needs to be done in the row ID in the row ID What we have done is seen or seen is something which does not need to be counted and Aggregated right we can not ah if we can Not we should not do any kind of aggregation
We should not submit, we should not I mean a you No find the maximum of the row id right so What We're Going to Do Here in the Row ID ID In the row Id just go for don't summarize in
The Summarization Option Right This is just a kind of a roll number and Id employ Id right so you go for dont Summarize That It's Nothing Else
Is Creating the Charts Right That Is Creating the Charts Now Here Always Creating the Charts Now Here Always Remember OK Always Remember Here in This Case These are the visuals here right these are the
Visuals that are present. Your Visuals And my visuals might be a little bit Difference because of the versions we are using. If you have downloaded it yesterday, ten Visuals might be a little different. Few are the Things are common but some got upgraded.
Ok? also one of the things what I was Mentioning is wherever we're going for Creating a Chart Wherever We're Going For creating a chart doesn't matter where you are For creating a chart doesn't matter where you are Doing it in your Excel using manually you
are doing it with a pen and paper or you are Using Python and using the BI tools Every Chart Will have a chart area right the chart area
Will have a chart area right the chart area Write it will have a chart area area than You will be having some exes at
You Will Be Having a Vertical Axis Suppose Here known as the y axis and here you will Here known as the y axis and here you will B having the horizontal axis the x axis B having the horizontal axis the x axis right end in this portion
right end in this portion in this portion right The data you have will be creating what you know. The Grafs and The You Know You Know the Line The Grafs and The You Know You Know the Line charts and may be the graphs okay this is the
Portion Right Wherever You Are Getting This One Wherever you are having inside it is known Wherever you are having inside it is known As your plot area this portion is known as Your Plot Area Okay, so we're going to now create a chart.
Okay, so we're going to now create a chart. And this is common for Asati That Is The Transparency That is the transparency reduce it to 0%
That is the transparency reduce it to 0% Okay sure the thing is that we have done for all the Okay sure the thing is that we have done for all the Geographical location for country and region For State as well for Postal Court as well You Have to Segregate
You Have to Segregate So please, what did I ask you to do? What did I ask you to do if you have to go for city for city City Categorize a City Categorize a Country
City Categorize a City Categorize a Country and region categorize a postal code right Categorize a State as Well and If You Wish You can go for the row idea as well that's You can go for the row idea as well that's It If You Don't Do It You Will Not Get It
Process Alright now, I mentioned every chart will Alright now, I mentioned every chart will Have a chart area a plot area right a chart area in a plot area and this is Common for most of the charts right common
For Most of the Charts Apart From Few Suppose you don't have that thing for your ah Ah or we ah the pie charts. Ok? But now We will are we are going to discuss about
This Charts. We are going to discuss about This Charts. give me a moment this particular one okay the bar charts okay So before we proceed Let Me Confirm Are You All in the Same Page Any
Let Me Confirm Are You All in the Same Page Any Confusion Till Here Before We Do the Chart Start Doing the Chart No, if you don't, generally we apply it ok So because now this is the easiest way of Doing it in the background color is okay, but if
That You Can Totally Skip It But If You Wish To Apply just you can go for here and Apply some color. Ok? So today we will be understanding. So I keep on repeating the term report. Report report. What does the term report
Means? Right? We Will Be Able to Understand From Here as Well. OK, because it's a Data type. यू कैन चेक हियर इट्स अ Text. In the data type, please go to the Data type. Data Type, in the Column Tools, You have the data type. In the column Tools,
You have the data type. In the column Tools, Towards your left, you have the data type. Ok. So everyone that's a request. Ok. So Whenever I Am Teaching Right Try To Focus on the screen what I'm doing. I Will give you some time to do it. Ok? you can
Experiment it later. You please pay attention In the four hour class. Ok? Otherwise I have टू कीप टेकिंग अप योर स्क्रीन। So focus on what I am doing so that you are able to Learn. एंड अदर्स आर आल्सो बिकॉज़ अदर्स दे Might feel who are doing it. they might feel
Little bit disturbed. Right? so please make Sure what I'm doing focus on that What is present on the screen and then I will give you some time you can just I will give you some time you can just Try on Your Own OK
Now please check here when we go for Creating the Chart Right When We Go For Creating the Chart No Matter You're Doing It manually or you are doing it in any other manually or you are doing it in any other Software Write Every Chart OK Every
Software Write Every Chart OK Every The chart will require some categorical The chart will require some categorical Columns and Sum Numerical Values And you can say majors To Plot for the Plotting Purpose Right You
Need the Numerical Values ​​is the Best Part Of the BI tools the PaBI and may be taboo Of the BI tools the PaBI and may be taboo And culit you don't have to go for Selecting the Data First You Don't Have To Go for selecting the data first like in
Your Excel Well What We Do What We Do We First Select the Data and Go for the Insert and then go for creating the chart That's not the case in the PowerBI OK suppose That's not the case in the PowerBI OK suppose I'm going for creating a sales
Report I'm Going to Create a Sales Report from This Okay So I'm First Report from This Okay So I'm First for analyzing right now so suppose if I
I want to check for each category the sales Generated ok check here for doing so what Generated ok check here for doing so what You need to do simply check this box simply
check this box You're Getting Something Category Furnitures Office Supplies and Technology Are You All Getting It in a Tabular Form Are you getting it in a tabular form? Right now as I mentioned the charts right the
Graphs Requiring Some Numerical Measures Now we are getting all the values ​​in the category Categories Whatever That Is Present Right So now if I want to plot the chart right what I'm going to do I'm going to Select Suppose If I am looking for Category
Select Suppose If I am looking for Category Wise total sales right so for that I have to check this box check the sales box box please You're Getting the Some But You're Getting the Total Okay now check here okay so I'm just in so
If I Wish My Chart Is Selected Right Now if I wish I can increase the size okay I can resize it right now okay so This is my chart area, the white portion. are able to see but by default when you Don't Select the Chart You Will Be Getting a
Don't Select the Chart You Will Be Getting a Table OK But If You Want To Get The Visual Simply Click Let's Go for the First Forest. Let's Go for the First Chart. If You Keep your cursor over here, you will be able to See The Name That Is Tack Chart. Click on that
Please. Now my chart is created. My chart is Created. What I can do, what I can Do Right Now? The Data Pen I Don't Require It's right now, okay? So, I'm going to Collapse that. Ok? I'm going to collapse
That. So how can I do that? I will just Click on this. My data pan is form. End You Can See The Chart. You Can See The Chart. Now what do I need to do? I need to
Format this chart. One I Have to Format This chart. Now notice one thing. My Chart Is still selected. My Chart Is Still Selected. Now check your visualization pane.
Please check your visualization pane. initially You got your format your I think build Visual and You Got Format Your Report Page. Now We Are Getting What Is The Option
It's a format your of visual. it is Format Your Visual Where Your Chart Is Selected that option we get, right? it is Not the report page. It will work on the Chart Only. And apart from that have you Noticed how beautifully once we select the
Noticed how beautifully once we select the BI have automatically Designated ah y axis to the dimension Designated ah y axis to the dimension and the x axis to the sum of sales.
We are getting the aggregated value. we did Not Select Any Value Nothing. it just Did the aggregation on its own and it gave us The Value Till this part everyone is clear because now we
See my chart is selected you can see Small Grade Lines Here So That Is Why Small Grade Lines Here So That Is Why
Right. So make sure when you want to Format this particular chart please Select it. Then only you will be getting This option for format your visual. Ok This option for format your visual. Ok Let's click on that. now as I mention
please check here The Entire White Area You're Getting Right The Entire White Thing You Are Able to See This Is Your Chart Area. this portion is yours
Your Chart Area. this portion is yours Chart Area Right This is your chart area End Of course here you have y axis Here You Have x Axis
Getting the Right? And this is what you, it is yours Chart Titles. दिस इज द चार्ट टाइटल। Ok?
Chart Titles. दिस इज द चार्ट टाइटल। Ok? Now let's see let's go for formatting it. Let's go for formatting it. Ok? The
Categories Here Technology, Furniture & Office supplies. But, Can We Rightly Say What Is the exact value of the technology? How much sales have been done by the
Technology? I Can See Ya Technology The Sale is much higher than to furniture and Office supplies. But what is the exact Amount? कैन आई से सो डायरेक्टली?
No right? So for that we need the data labels for that. so that it is displaying what is the Value Here. Ok? for displaying the data
Labels in the format your visual. Now We R going to display the data labels. So Here is your format, your visual. Let's Scroll down to the data labels. Let's
Scroll down to the data labels. Please Scroll down. You will be getting an option For Data Labels. You will be getting an option Data Labels. You will be getting an option For data labels.
Right? Here you can on it you can on this toggle bar The Moment You Do So You Will Be Getting Some Number
Now I want to change the formatting of it It's too small and also the if you check the you It's too small and also the if you check the you
Expand the data labels Si Pabi Is All About Expand and Si Pabi Is All About Expand and Collapse. So you have to expand it.
And then you have to scroll down. Expand The Data Labels and You Have to Go for Ah Scrolling down. Ok? In Once You Scroll down, you'll be getting the option edge
Values. You will be getting the option for Values ​​we are on. So You Have to Expand Values ​​we are on. So You Have to Expand It. Expand the Values It. Expand the Values And here you have the option for formatting the
And here you have the option for formatting the Labels. Formatting the Labels. Kindly Confirm me if you are able to see the values Here. Expand the data labels further than you will B. Getting the Values. please expand the
B. Getting the Values. please expand the Values. than you can do you can go for increasing the Size of the fonts
You can go for an increase instead of nine. Make it 10 and 12 Make it 10 and 12 See the Value Has Increased If You Wish You Can Change The Font Style As Well there are different font styles
Well there are different font styles Like in your MS Word Similarly, you can go for changing the color of your eyes. Will Make It Black So That We Are Able To Will Make It Black So That We Are Able To View It
Also I will change the unit to thousands instead of millions okay so scroll down instead of millions okay so scroll down Scroll down to the display unit scroll Scroll down to the display unit scroll Down to the Display Display Unit
Okay, so in the display unit, you can make it. Thousands Me what if ah you want to increase after The decimal point up to three three digits.
So here I mentioned don't do it in the power Query editor right? We Can Do It in the Power BI interface. So Here You Can See It Is Limited to two digits. If You Wish You Can Make it auto. So it is currently automatic Right? You if you wish you can make it zero.
Then no ah after decimal we have zero Numbers. Ok? If You Wish You Can Make It One. After decimal we have you can see here after Decimal we have one digit. If you want to
Make it three. After decimal you have three digits. so do it Here in the Power BI interface instead of Doing It in the Power Query Editor
That is how to do it okay if you want the Values ​​inside the bar OK scroll up Values ​​inside the bar OK scroll up Scroll up there you have the option C position
Position It Automatic Right Now In the options scroll up you have the options There you have the position right now in the position it is automatic ok so just go for
Clicking on That and Where Do You Want It You Wanted Inside Center You Wanted Inside Center Get It Inside Center Get It Inside Center Now what do you want if you check here if
you check here Step by step we're going okay this Portion right the horizontal axis is in
Uniformity. There is no uniformity. And Ideally When We Go For Preparing A chart right what we do we have the same Obviously units. It is if it should Reflect the same units. So in that case We have to go to our This is your
Horizontal axis. x axis. Let's Scroll up and let's go to your x Scroll up and let's go to your x Axis. Let's scroll up and go to your x Axis. Expand your x axis please.
Expand your x-axis You are getting this minimum and maximum Ranges. Ok? सो इफ यू चेक द डिफरेंस बिटवीन योर
Ok? सो इफ यू चेक द डिफरेंस बिटवीन योर Office Supplies and Furniture If You Check the Office Supplies and Furniture If You Check the The Difference Between Office Supplies and Furniture The Difference Between Office Supplies and Furniture It Is Not Much It Is Not Much The Range Has Been
I'm talking about what this minimum is. And maximum do you know it is basically talking about this portion This portion starting from zero to 8 million right? This is the range they have
million right? This is the range they have Able to view. If we don't if we put the Ranges on our own probably we might not Be able to see the changes there. We Might Not Be able to see the changes here. So, I am
Just skipping it auto. I am just Skipping it auto. You can play with the Ranges. you can play with The Rangers and Try It Out. Ok But for now, what I'm doing right now
Going to the values ​​in the x axis go to the values ​​and the display unit instead of values ​​and the display unit instead of Auto Again Same Make It Thousands
Auto Again Same Make It Thousands Make It Thousands Increase a Bit Make It Thousands Increase a Bit And color I'm making it black
Changing anything. Let It Be Because Again Pabia Is An Intelligent Tool. it has Identified on its own, right? So, I Kept it the same. I Can Change It But What Happens? I will not be able to see the Difference between these two. It might look the same.
So, I have kept it the same. Ok? Only Thing I've done that when I expanded the values, increase the size and make the color as Black, display units as thousands. Black, display units as thousands. Three changes.
Now this sum of sales do you think it is Required Required Format this as well. From the Chart Title I will understand that this is where we are
Talking About the Sum of Sales Only Total Sales Only Sales Only If you need it, you can keep it okay if you need it You can keep it if you don't need it. can of that because again it is self
can of that because again it is self Explanatory Totally Up To You Totally Up To You because I will be providing a chart Title from the chart title We Will Be Able To understand this is category wise total Sales. So from this I don't need it. So
Sales. So from this I don't need it. So I'm Curly Putting That Off
Any Confusion Till Here We Are Done With The X Axis We Are Done With the Data Labels
Do it for the axis as well. let's do it For the axis as well.
You feel that I'm going fast you're not Able to follow does let me know. since you are Able to follow does let me know. since you are Doing it for the first time.
Do let me know immediately in the chat. If You Are able to follow.
right not right now Rajesh ok I will Explain to you that that is different.
By step. Ok? First We Got the Data Labels that we got the X axis. Now We Will be working with the y-axis. Ok? Let's Go for the y axis. scroll up Expand the y-axis. Ok? Expand the y-axis.
well Okay Mansa if you are not able to go for the Thing You Have to Go for the Undo If You Have changed it changed it Undo Works Here
We Change the Range Right We Don't Know Because We are not able to see the exact difference there Okay, so we can hear in Parkbury Editor. There is no undo but in the PBI interface there Is an undo so you can go for that Allright in the Y axis in the Y axis same
Thing We are going to increase the size of the sponge so We are going to increase the size of the sponge so That we are able to see it
Right let me just increase or decrease a little bit and here I will make it black
You can of the title as well you can of the Titles Age Well
Width Right So I Can Go for Decreasing It
And I'm putting that off the Title
The Width You Will Not Be Able to Understand Anything Right Now. But if you resize it, Right? If You Resize a Diagram, You Will Be Able to understand it better. If you resize Able to understand it better. If you resize It, you will be able to understand it better.
It, you will be able to understand it better. Ok?
OK, let's go for coloring the parts? Let's Go for Coloring the Bars Then We Will Let's Go for Coloring the Bars Then We Will Do it. Can you scroll down to the bars? can you Scroll down to the bars?
If You Wish to Change the Color of the Bars You can do it from here Right Currently If You Check Here Apply The setting to apply the setting to categories is
The setting to apply the setting to categories is Mentioned as All OK Categories as Mentioned as All and the color is blue. So that is why you Are getting the same color for all the bars. if you Want a Different Color for All the Bars You Have
You have to choose it individually and choose the color. Ok? Choose the color.
Introducing Transparency as Well Because currently the transparency is 0%.
It is possible to apply conditional Formatting Just Like Your Excel Only. Ok? बट आई विल शो यू ऑन द थर्ड डे वंस वी Go for the Table
Done Great Now After You Have Color the Bars After You Now After You Have Color the Bars After You
Lines Can You Check the Greed Lines Here Lie On the light colors can you check here On the light colors can you check here
Okay, so just go for clicking. For the grid lines so currently the color is Gray right? एंड द लाइन स्टाइल इज
Gray right? एंड द लाइन स्टाइल इज Dotted. So if you wish you can make it black. Dotted. So if you wish you can make it black. Dash See and if you want to increase the width
See and if you want to increase the width Increase the width.
Basic formatting of the chart is done only
You do have the option for coloring the plot and वाटरम्क इन द प्लॉट एरिया एज़ वेल। Ok? So
Area background. in the plot area Background You Will Be Only You Have the Option For adding an image. You Don't Have the Option For going for a tomorrow some color here. Ok? So
If you want to add a logo of your Organizations You Can Go For Adding That How So you will be getting this browse option are You are getting the plot area background Kindly confirm because I am using a Relatively Older Version
for adding a file I can go for adding a File from here so if I have any image File from here so if I have any image Suppose you don't have to do it
Only this particular portion is clear Color that is your plot area this is where the The plot area is right if I want to make it Little Bit Transparent
OK But If I Don't Want to Color the Plot area or add an image in the plot area area or add an image in the plot area Separately I want to go for I I want to Go for the background color adding a Background here instead of an image.
Ok? I can do so. So if you check your Format Your Report Page Right If You Check Your Format Your Report Page Once Your The chart is selected you will be getting to The chart is selected you will be getting to Option. Visual and General. Ok? Visual Is The
The Options You Have in the Visuals Is Specific To that particular chart you select. is specific to that particular chart you Select. But if I talk about the general it is Select. But if I talk about the general it is Common for All the Charts. it is common for all
The Charts. Ok? So let's click on the general Right now. We have looked into the visual. Right now. We have looked into the visual. Please click on the General option.
Please click on the General option. So, all Charts. All Charts General Means All Charts Charts. All Charts General Means All Charts Will Have a Chart Title Will Have a Chart Title Right All Charts Will Have a Chart Title
This Is the Default According to the Fields You have chosen this is the default name you are You have chosen this is the default name you are Getting in the Title Right If You Wish to Change The title if you want to remove it if you want to remove the title you can of that you
Don't Want the Title If You Want the Title But But not the same title. Ok? so you have to Expand that and you can go for I am Naming That As
Total sales. Right? I can increase the size. since it's a Chart Titles Make it gold.
And I'm going for the center. So Late Not Make It Bold Something Good.
What did I do? I Went to the Charts Title Change the Name OK Increase the Font Size Text Color Did Not Do Anything Alignment only made it
Tarun can you please share me a screenshot what are you getting Might Be You Are You Might Be Getting the Same Position Format Option Is There for You Right
If I want to apply a background color over here if I want to apply a Background color only to this title I can do so by for by going for this background color okay so what i will do I will go for this make it black but if I
I will go for this make it black but if I Make it black the text color is invisible Right now so what I'm going to do Text color: I will make it white
ok others are getting it tarun you are not Having It
Part Ya Tarun please share your screen
Prop Format Visual Format TMDL Or go for the format properties date Format Data Format
Format Data Format Apply setting to category Ok A Somewhere It Will Be There Header Icons Let Go for the header icons
Or You Have the Background Border Icon Here Just Go For This One Apply Some Color Here
Just Go for a Deeper Color Black or something
It's a pretty older version you're using Background OK Header Icons OK Header icons right this another one okay can you okay scroll up scroll up scroll up scroll Up the are the icons so icons are being color Scroll up format let's go click on the
Scroll up format let's go click on the Format Option
Your system please I think that's a pretty Older version you have can you please upgrade Older version you have can you please upgrade Your System Or When did you like download the Pabi it's
Pretty old actually so I do it this is My Office Laptop That I think they will not allow you to do so You need the IT permission, you can ask them or nobody ok thank you
ok thank you So Few Features Are Not Available in the Older So Few Features Are Not Available in the Older Version You Know That's Pretty Different Here
The Color in the Background We Want to Apply the color in the background right now okay so This Is Was the Title on Me Okay So Let's Go To scroll down to the effects let's
To scroll down to the effects let's And there in the effects we have the Background. You can apply any color of your
Background. You can apply any color of your Choice. You can go for applying any color of your Choice.
Once you apply the color you can check the Borders its sharp edge right where the edge is Sharp here if you wish to make it little bit you know rounded rounded shape you also
Can do so scroll down to the visual border on that okay first you have on that We will be getting a border, expand it. And you can make it round it now.
So if you unselect it you will be able to See that the edge. To the Effects Visual Border On and Then
I Can Make It Round It. You can increase the Width as well. So our basic chart formatting is done for A singles chart.
Chart So This Is Not Taboo This Is PBI V Do not create a single chart in a single Page That Is In Case Of If You Are Aware Coming from the taboo background ok ok
Then you are aware that in single page we go For a Single Chart But This Is Power BI Okay each page is a report, it should reveal some ination it should give some insights of a
particular thing if you are trying to Create a Sales Report It Should Be a Reveal Every Expectation of the Sales It Is Just Giving Us Now One Expectation That Is Category Wise Total Sales What About The Other Aspects Right So If You Want To
Go for Creating a Report You Have To Resize the chart. You have to a single page Resize the chart. You have to a single page Will combine lots of charts together. Right? Charts, graphs, extras. Ok? So, what do you need to do here? what you
Need to do here? You have to resize it. You Have to Resize the Chart Right Now Too अकोमोडेट द अदर चार्ट्स। Right? So, you can Just go for resizing it.
You can go for resizing the chart right Now.
Now, okay, now I have to as an analyst. Now I will be looking into the subcategory Wise Sales and For That I Will Be
Selecting The Second Chart The Second Chart OK I'll be selecting this chart the name Off this chart is if you're over here Stacked column chart. So this time I
Instead of selecting the fields I am Going for Selecting the Stack Column Chart Directly. Ok? But make sure please one More than anything, PowerBi is highly interactive.
More than anything, PowerBi is highly interactive. PowerBI इज़ हाइली इंटरेक्टिव। If You Select this chart. If your chart is Selected and if you click on the other chart Selected and if you click on the other chart It will get changed automatically.
Right? So make sure you don't do it. when You're creating another chart when you're Creating Another Chart Make Sure You Unselect the other chart and you click on Unselect the other chart and you click on That Chart Which You Require.
That Chart Which You Require. Understood? So you're getting it like this. Understood? So you're getting it like this. So adjust it in the proper place.
V How do we know which chart we are supposed to be? How do we know which chart we are supposed to be? You Can Use Any Chart You Can Use Any Chart Okay based upon the understanding you have Okay, so whenever I mention when you have
A category means dimension and a major right How Do You Reflect So You Can See What You Want Want to Represent Anything Right Now Suppose Categories are there bar is obviously giving
Have to go for a particular pie chart here
you can use it
यू कैन आल्सो कंबाइन इट। So in the upcoming स्टक बार चार्ट्स एज वेल। So based upon the
or probably You have not increased the width right you have not increased the width so that is why you Are not able to see it. So You Can Just Go Are not able to see it. So You Can Just Go For resizing the size of the fonts you know.
For resizing the size of the fonts you know. And you can check it out.
Increase the width to two pixels. for the Grids I increase the width to 2 pixels.
Others create sub category wise sales please for this chart for this chart Sub Category Wise Sales
Getting Exactly the Same Option But This Time What Happens is the Numerical Values will come in the y axis in the x axis you Will Be Having the Dimensions But You Haven't Have to think about it, you can just need to Select the dimensions and you have to
Select the numerical values ​​based upon The charts it will automatically place it Based upon the chart it will automatically Place it so for now what I'm doing I Have to go for selecting okay suppose let me Go for the sales.
We're creating a sales report. so you Are you trying to analyze a single thing? Sales. So you have to look into the every Aspect of that. Ok? So I'm Clicking On the Sales. So automatically it is taking Up in the y-axis. we don't have to care
Like where to put it. Right? We Are Getting the Sales Automatically Here. We are automatically getting the sales Here in the y axis. Right? Now We Have To
Go for selecting the sub category. when we Wanted to plot we have to go for checking Wanted to plot we have to go for checking This box.
So let's scroll down and let's go for All categories.
This chart I'll be using okay the basic Formatting The Basic Formatting OK Not everything but the basic formatting of this Chart Since I've Done It Here and I Am Creating a Report It's Always Good That It has a similar pattern right the similar
Pattern Specially the Background the Grid lines and all those things so if I wish to Get it the same patterns. I I M I M Not willing to do it again. I have spent So much so much time in formatting it. I Don't want to go do it again. Ok? So
Don't want to go do it again. Ok? So What can I do? Simply Click the First What can I do? Simply Click the First chart. Simply click on the first chart. chart. Simply click on the first chart. Go for the Format Painter option. go for this
Go for the Format Painter option. go for this Format Painter Option. Brush like icon. First You Select The First Chart. Click
First You Select The First Chart. Click On the Format Painter. You will notice that your On the Format Painter. You will notice that your The cursor has changed to a brush-like icon. End The cursor has changed to a brush-like icon. End Now Just Click Here.
The Bars You Have to Do It on Your Own Butt Basic Formatting Is Done
Just Like Your Microsoft Word Microsoft Products Right For if I wish to change the color of the bars and All those things. You have to do it on your
On. For example, you want to go for the Title change. Because it is giving you the Default title. You can go for changing it. You can change the you know the categories as well, the You can change the you know the categories as well, the X axis as well.
So, go to the visualization. Let's go to the Visualization and Let's Change Visualization and Let's Change The Title First. Make Sure Your Chart Is Selected Go Here Go to the General in the Title
Sub Category Wise Total Things I Am Changing the Name Age
I'm Going to Reduce the Size a Little Bit off the x axis.
So that my titles are visible properly. So I have decreased the size a little bit.
Let's go for the data labels. Let's go for the data labels. End Data Labels Position This Time I Am making it a
making it a outside and okay I think better outside and outside and okay I think better outside and Inside Instead of Going for the Inside End
And also the data labels have decreased a Little Bit
Same thing exactly the same thing we have done in the earlier chart Quite Similar The Options Are Quite Similar Here
Numbers are showing only for alternate bars No it's not showing for alternate times the Thing is that ah yo you don't have enough room For it if you decrease the size if you check here okay I will show you one thing here so Everyone we're working with on the second chart
Right if I want to ah if I want to get The Bigger Picture Right Focus on This Particular Chart on Me If I Want to Focus on This Particular chart I have this option focus mode I can click on this okay so I Will be able to view it in enlarged portion
So please check it out So you can see the bars once you click on the So you can see the bars once you click on the Focus Mode You Will Be Able to See It
Getting It It's Because of the Formatting You Are not getting it.
Just Click on Back to Report. I can Just click on back to report and I am Just click on back to report and I am Back here.
well. So generally when we have so many of you No columns and bars we go for conditional Formatting But That I Will Teach You Later Based Upon the Conditions Ah We Go for Coloring Can Dot lines. Are you talking about the grid?
Dot lines. Are you talking about the grid? Lines Rajesh?
Ok. So you can go to this format your Visual. You have this grid lines option. Ok? what you can do you can make go to This line style and make it. First You Make it dotted. Ok? You Can't Directly Remove it of course. And you can just go for
Dec. Off that. You can do that.
You can change the color of the bars. I am Keeping it same. Keeping it same. Because you know now how to do it. Ok? You Now know how to do it. Exactly the Same But Instead of the bars this time you have the
Columns. This time you have the column. so if you Wish You Have All The Settings. You We Can Go For conditional formatting. But this one I will Be teaching you in the upcoming session. Not Today Be teaching you in the upcoming session. Not Today In the next session. Ok? This One You Can Go
For if you can choose one by one and you Can go for coloring it. You Can Go One By Can go for coloring it. You Can Go One By One and you can go for coloring it.
Ok? So if you go for all and you can change Any color. You can change to any color it will Be alert for all the Columns and the Sub Categories here.
All of you are done till here shall we proceed Okay now I want you people to create
For Region Wise Don't worry about the formatting. Formatting I will teach you just go for the creation of the
I will teach you just go for the creation of the chart.
Pie Chart Is Something Which Gives You The Percentage Which Gives You the Percentage Right? What percentage of sales was done in the East Region? What percentage of sales was done in Region? What percentage of sales was done in The Ah West Region. Right? So, if I talk
About the Pie Chart, Normally Bar Charts Will give you the exact value. Ok? But Pie charts will give you the percentage. This Is your pie chart. Right? This is your pie chart. So, if I Select This Chart
or Great Swati So if I select this chart, okay, so my So if I select this chart, okay, so my
It got automatically you're getting this one but I don't want this to happen okay, so I am Changing it again I'm selecting it and Let's go for this pie chart
Okay, now in this pie chart, I'm going to Select Region and Sales. Now if you check the Select Region and Sales. Now if you check the Options here ok you check the options here Options here ok you check the options here In the pie chart there is no x and y axis
There is no x and y axis we have a Legend in the legend we're getting the region Legend in the legend we're getting the region And once we select the cells automatically It's taking up the values ​​and that How We Are Getting the Chart We Don't Have the
the x and the y axis Helping us understand what this each does Color refer to what does each color refer to ok
Color refer to what does each color refer to ok Vary Here Because the Chart Is Different Here You don't have X axis Y axis so if You Click Here This is what you are getting
Please kindly confirm are you getting the same
This One Which Is Helping Us Understand Okay, which is basically helping us. Understand what each color refers to रीजन इज़ रेफर्ड बाय व्हाट कलर। Ok? So, If You Don't Want It Here, Maybe You Can Do not remove it. Ok? Do not remove it
बिकॉज़ इट इज़ मेक्स अस अंडरस्टैंड। And We I am not removing it. But yes, instead of Placing It Here, We Can Place It Somewhere Else. सो व्हाट वी कैन डू, वी कैन गो फॉर Clicking on this legend. instead of the position As center right, I'm going for, so these
आर मेनी पोजीशंस आर देयर। May I Be going for I can increase The text size.
Right? एंड आई एम मेकिंग इट लिटिल बिट
Ok. नाउ प्लीज़ चेक हियर। This Region Right This Reason This Is a Title Is It Required This Reason This Is a Title Is It Required
Yes that's the power of Power Pi right interactive
Interactivity. All right. Now, coming to the color of the All right. Now, coming to the color of the Slices. Slices means this portion. Ok? This portion are the slices. If you want to Make it a different color. Click on the
Slices Expand and again the same thing again the same thing you can Choose the color you can choose the west region and you Can go for a color of your own you can check
Can go for a color of your own you can check Choose the East Choose the Central OK choose the South and go for a color of your On Any Colour
One color. And apart from this sea here it is Giving You the Labels Along With the Percentages. You're Getting the Numerical Values ​​along with the percentages. But if you Wish you could only get the percentages as well.
Wish you could only get the percentages as well. That also works out. For That You Have To Scroll down to these detail labels. This Time it is not data labels. It is detail Time it is not data labels. It is detail Labels. Ok? Go to this detail labels.
Where do you want the position outside? Let's go for inside. Let's go for inside. And how do you want The Label Contents? You want only the percent
The Label Contents? You want only the percent Off total. Fine.
Will Be Able to Understand the Other Charts S. Well. It's more about exploration. how you Explore? You will be able to do it for Explore? You will be able to do it for Other charts.
Okay, we have created three charts. If I Click on one chart you can see the changes in Other charts. You Can See the Changes in Others chart. chart. Right?
Pierce to view the report like this. Ok? To See the Interaction We Can Go For
Question it might be to connection if we Update information and connection to Slicers, the Charts, and the Data Will Change and refresh
Kuldeep ok now please understand here whatever What we're doing right now is basically Happening the interaction is happening on Happening the interaction is happening on It's Our Own But We Can't Ask Our Clients
to do it in that same manner right for that we're going to add a slicer we're that we're going to add a slicer we're Going to add a slicer here so here because We want a user filter for that you have this Option Check You Have the Slicer Option or Not
Click on that this is a basic slicer you have ok made my mistake have ok made my mistake So make sure no chart is selected So make sure no chart is selected
Slicer You Can Take The segment you can go for taking the segment segment you can go for taking the segment
Slicer in the Slicer You Don't Have the Option If you check here in the slicer you have the Field You Don't Have the Option for the Numerical value write you can only in the Slice you have the option either for the dimension And for your
And for your Chart It's a Filter It's Not a Chart It's a Filter It's a Filter Ok
Because probably they have introduced New. सो दिस इज़ वन स्लाइसर। This is the Second slice. व्हाट इज़ द अदर स्लाइसर यू Have you?
You can go for the basic one right now.
give me a moment On This Consumer
Same Thing
This is by default it's a vertical list. This is known as the vertical list. Ok. Expand the option in the slicer settings. Expand the option in the slicer settings.
The Style Is Vertical List. if you don't Have the If You Do What You Do You Don't Want To go for the vertical list, you have the Option Because We Have Limited Only Three Categories Here Segment. So, we can go for The tiles. You can go for the tiles.
Don't Have Lots of Customization Things Here. So you can't make it rounded borders, Different colors, different slices that is Not possible here. Ok? So, go for making it tiles. End
Ok? So, go for making it tiles. End Here, let me do one thing. in the selection I'll be going for adding one more thing That is Select All That is Select All That is Select All
Go for Corporate Consumer and Home Office And multiselect option I will turn off that And multiselect option I will turn off that of now if I even if I use the control button
of now if I even if I use the control button I will not be able to do it CIM Clicking the Control button Clicking the Control button So I have kept I have kept OK select
what did i do i have kept select all and go for and go for This One Tile That's It Now We Have to Just This One Tile That's It Now We Have to Just Increase the font size Adjust the size little
Increase the font size Adjust the size little Bit Here for the Slice
Filter. Ok? what you have to do for the Slicer? I have removed it completely. You have to go for this slicer. this is a Slicer you have. Click on it. Click on the segment.
Done. For the slicer you don't need to Fields. That Means You Don't Need The Dimensions. you don't need also along with That's a numerical field because this is not A chart. This is a filter. so you can either Use a numerical field or you can use a
Categorical field. So I'm using the Segment Here. After that I'm going for So this is the vertical list. This is one of The Style How You Represent. Right? I Want to change it. So instead of that I am Going for the vertical list. So this
Going for the vertical list. So this Limited Option Is There Right click on this Don't want the slider of that Slicer settings. Instead of the Style Age Vertical List Go for Tiles
Vertical List Go for Tiles And make the selection as Select All and Turn the multiselect with control off. thats It. Sur Got It Now. So if I click here corporate it will be Showing for Corporate. If I click on
Consumer It will be showing for consumer. Check the values ​​are changing. Check the values ​​are changing. it is interacting interacting But the user has the flexibility.
We have to add some room so that we can add Adjust Lots of Things Together You were selecting something, just select Outside Delete It and Do It Again
Outside Delete It and Do It Again Delete it and do it again
Off the filter. Go to the Values ​​and Make It Bigger.
please wait you do it please font side sur
No Do Not Select This or Now Go for the Slicer Yes Create the segment Select the Segment Select the segment from the check Box Just Check the Segment in the Data Face
Box Just Check the Segment in the Data Face Segment Data Fields Data Fields on Your Right on Your Right
Right on Your Right Segment Click on the check box Segment or Now You Are Getting It Now Click On The Consumer
Home Office Done See before we use a slicer any chart any
All of you are done till here are you able to Increase the font size
for this particular sizer Can you give me screenshots? Can you give me screenshots? so pbi got updated
will be able to do that okay so let's go Here so you have the background right click On the background there you will be able to
So you can explore that as well if you are Having that.
Let me change the color of this background Here. अदरवाइज सेम कलर इट्स शोइंग अप।
Okay, suppose I want to go to State Wise. If I wish to go for state wise there are Hughes List OK at that time we will not Be taking up tiles at that time we will Not be taking up tiles, weather we will be Taking Up Either Dropdown or Vertical List
Ok. So please select the tiles again. Sorry select the slicer again.
Select the slicer. See This Is Empty Right now. No fields added. Right? now late Right now. No fields added. Right? now late Me go for adding the state. Let Me Go For Me go for adding the state. Let Me Go For Aiding the State.
So I'll be adding state as a slice. So This time I have to slice Alabama for the This time I have to slice Alabama for the Corporate What Value I Will Be Getting.
well. Please do it. At the cities in the slice sorry at the state At the cities in the slice sorry at the state In the slice please
Once done let me know I will show you that you have
Here. You are able to analyze. So now from This Report You Are Able to Analyze It More This Report You Are Able to Analyze It More Clearly. Region South How 100% You That Is अलबामा यू फॉर द कॉर्पोरेट लेवल। so you Can Just Analyze the Data So Properly Right
Now. So once you're getting this since the Leafs is So once you're getting this since the Leafs is Bigger Here We Can Go for Changing the Bigger Here We Can Go for Changing the Vertical List to Drop Down Edge Well
c The user has the flexibility to choose from that can you do so What did I do? Option I went for the
What did I do? Option I went for the drop For a break. Ok? we will complete this Report and will go for a break. Report and will go for a break. It's a same like background.
Ok. So, let's go for increasing the values ​​as So, let's go for increasing the values ​​as Well for this. And this time slicer header I'm keeping It. स्लाइ हेडर सो दैट यूज़र्स आर एबल टू
Understand And selection also you can go for all Select all okay so that we are having this Option select all is also there
I'm good, okay, assume we've created this. Sales Report for May Month If I Want to Do the same activity for the month of June but I Don't Want to Spend the Same Time Update Don't Want to Spend the Same Time Update Data The data set is different here right if
Data The data set is different here right if Your Data Right in the Same List Otherwise How will it do it in this case we have apply the
Filters OK Where the Users Will Be Able To select the options right then we have Apply Slicers Here We Have Applied Slicers are here where the user has the Flexibility to choose the different options From here right? But if we want, okay?
Instead of from If If We Don't Want To Give the flexibility to the users. Ok? Give the flexibility to the users. Ok? So they do have the choose from this option rather We want to limit it. Instead of showing Them All The Subcategories. I want to limit it.
I have to go for the filters from the डेवलपर पॉइंट ऑफ़ व्यू। This Is The Filter Pan for that. Ok? So we're going to work On These Filters Right Now. we are going to Work on This Date Filters Right Now Instead of doing it from the visualization
Instead of doing it from the visualization This was from the visualization right so Let's
We definitely need some charts, so we are going to create some charts right now so we Will not focus more time on the formatting Part part we'll just simply spend ah We Will Just Simply Create the Chart and I Will show you the different options of the filtering
Here. Because as of now I think regarding Right is all the same thing. Alright now we have
Samples report. Right? So now let's do One thing. लेट्स चेक दिस फनल चार्ट। I Think Everyone Has This Funnel Chart With You All. Funnel Chart Please Click on That
You have the funnel chart please click on that. So this is the funnel chart. ok let's go for Dec. Where we will be able to for like suppose Where we will be able to for like suppose
For that. यू विल बी एबल टु गेट द सेल्स For that. Let's say if you check the numerical variable as sales you will be able to see the Sizes Vary According To The Sales. Ok? For example, I am taking in the
Category here. I am considering subcategories So from this chart you are able to Identify Which Chairs Have the Highest Sales
Identify Which Chairs Have the Highest Sales
Beans. What I have done I have just increased The Size. I have just increased the size so The Size. I have just increased the size so That you are able to see it. Right, you are able To view it. Now Check Here what we're going to learn we're going to
Learn on the filtering. Right? Filtering Ah Filter on the visuals. Ok? so we are Going to learn this filter. So here we have Three Types of Filtering. So This Is Filter on the visuals when your visual is Selected when your visual is selected
You can see the filtering option. Idly If No visual is selected and if you click on the Filter Right You Will Be Able To See There Are Two Kinds. Ok? There are two types of Two Kinds. Ok? There are two types of Filter. Filter on this page and Filter on
Filter. Filter on this page and Filter on All pages. Filter on This Page and Filter On All Pages. Right? Currenty No chart is selected. If your chart is selected
selected then you get another option filter on this Visuals You're getting filtered on this visual filter You're getting filtered on this visual filter On This Page Filter On All Pages Once Your
The chart is selected at that time you get The chart is selected at that time you get three ah three filters isn't it Click Page to My My Report Title Is Not shown because you have not created it.
Ok? I have created it. So That's Why I am getting it. Ok? This one I have created it. so that's Why I am getting it. So You Have to Do Why I am getting it. So You Have to Do It. All right. Now please check to understand
This First, We're Going to Learn About Filter on this visual only. Filter On This Visual But How That Works. Ok? for that I'm going to apply disrespect chart. I am Going to use another chart. For example, I I'm going for
Let's go for This One That Is Your Column and Line Chart Line End Stuck column chart please click on that
Please click on that make sure that other Chart is not selected click on this
ok check it out wether copy paste is allowed or not You don't have the option for that right if you go for this what about this
Anyways this one I was just showing it to I Think Sur. So That's Why I Have Created It. If you don't need it, you can just skip it. It as well. You Can't Delete It Required. Alright?
R Focusing on the filtering part. Ok? So everyone please select this line and Stackt column chart. please select this Line and Stuck Column Chart. Now Once You Select this okay so it's a combination of Two chart column chart also that is your bar
Chart as well as the line chart. Ok? V Can use we can use to numerical Variables for that. Ok? Suppose if you wish to check
to check For one dimension right? One Sub One Category You want to check to new you have to Numerical Necessities to Numerical Measures
using the bars and another one using the line for example State Wise Total Sales
End Total Discount Also a numerical column where as state is A dimension it's ultimately a text
right so if I want to do so please check it out once you select the chart everyone ready Shell Eye Everyone Shall I Show You Right Now All of You Are
Done with the Fernal Chart Atul Done
Select this chart I'm selecting what the State Just Select the State Because I'm going to show you the filtering So I'm Taking This Okay Now in the Column
Y axis in the column y axis if i Select Suppose Sales Let's Go for Sales End Quantity Sales I'm getting the sales in the
I'm getting the sales here in the asa columns now over here I'm clicking the quantity What is happening here you can see a statue
Column Chart Here You Are Getting a Stack Column Chart Here Right? Why? Because I wanted in the line
Same option. So, are you getting it? are you getting it Like this?
Out. This one. Select this one. कॉलम एंड लाइन एंड कॉलम
chart. Ok? Stat column chart. Click on Dec. वंस यू क्लिक ऑन दिस गो फॉर सेलेक्टिंग द स्टेट। So state is ऑटोमेटिकली टेकन इन द x एक्सिस। that is a
Dimension. That's completely fine. Now I Have two numerical columns. Right? So I came Have two numerical columns. Right? So I came Have two numerical columns. I Have Sales I have Discount. So Now This Is the Only Sales I Make
I'm getting right now. Sales is coming in Descending Order of the Sales Right Now. Now Descending Order of the Sales Right Now. Now I'm going for quantity as well. So, Quantity What Is Happening? it is Coming as a stuck column chart. Why? because
Coming as a stuck column chart. Why? because you have Columns and Axis. But One Major You Want It As A line chart. another one you want it as a
Bar chart. another one you want it as a bar chart. Right? So, what can you do? It's Totally up to you. One Major You Can Put It In The y and one major you can put it in the line.
The y and one major you can put it in the line. Ok? Suppose if you want Can go for this. Just drag it in the y axis.
Right now. This is your primary axis. This is your primary axis. Secondary axis. This axis is basically For the line chart.
Whichever measure you feel you can drag it Here. You can get the fellas also here.
Visualization These Are the BI Tools Right? The Visualization similarity will be there. Visualization similarity will be there. But PBI is much easier.
So we have to charts right now we have to Charts Right Now in This Visual
Create More Charts As Well You Know That We Can Create More Charts as Well But Now for Now for Understanding We're Keeping It Too Charts as Well Only Charts as Well Only
my first chart is selected okay my First Chart Is Selected I'm Going To This filter filter on this visual is Activated for me Enabled for me Activated for me Enabled for me Right Now Over Here You Can See the Option
Sub Category You Can See The Option Sub Category here now Will be there right I will be applying it will be restricted to this particular
visual only okay so if I click here so If you just hover over the subcategory over Here you are getting a downward arrow drop down If you click on this you will be able to get This option option filter type please check it
This option option filter type please check it up whether you are getting it or not I Repeat
Click on the dropdown and there you are Able to See Three Filters Advanced Filtration Basic filtering and top end filtering
Going for the Basic Filtering Basics Filtering is nothing but it's simply as the You can say it's a vertical list, suppose
द एक्सेसरीज़ इन्फॉर्मेशन ओनली। If I Want To get the appliances as well. To get the appliances as well. इट रिफ्लेक्टिंग इन द अदर चार्ट? normally
Chart as well.
Understood?
Sales Column Here Changes. यू कैन नॉट सी एनी चेंजेस हियर।
Filter. यू हैव टू क्लिक ऑन अप्लाई द Filter. सो दीज़ आर योर टॉप परफॉर्मिंग कैटेगरीज़। F
द यूज़र्स विल नॉट बी एबल टू सी दिस। only
ओनली सीइंग द टॉप परफॉर्मिंग कैटेगरीस। If
Elaborate mode on the distinction between the Application. Ok? The Thing Is That Slicers, right? Whatever the slicers, Those are filters only, but those are for the Users. The users have the flexibility. once you publish it right once you publish it the
once you publish it right once you publish it the Users have the option for choosing it. I Want to click on the corporate. I have the Option for choosing it from this. Right? I Go for this option and I will be able to say It. But if I go for these filters, right
From the BI architect's point of view, In that case, the users don't have the option. Once I Publish It, the Users Will Be Able to See only this portion. They will be able to see only the top five ah Top end or the top ah bottom end filters
Flexibility. Ok? I want to check the top and as well as I want to check the Bottom end. They Will Not Be Having the Options For that. So we are restricting it. Ok? What the Users Are Able to See They Are Not able to click and check here. We Are
Restricting it. for example for Example. So you can have this state here. You have this state here. Right? Now in the State you have lots of states. you have State you have lots of states. you have Lots of states. Now in the State I Am
Going for the Let's Say Instead of All I Am Going for the Top 10 and I want the Top 10 And let's say the top five But ah top 10 states with the sales. Ok?
Top 10 Performing States with the good sales. Ok? Let's Go States with the good sales. Ok? Let's Go For this. You are able to see only this Particular states.
Don't want to go for it. We No Only Need The Top Performing States Where Our Sales Are Higher. So we're getting to California, New York, Texas, Washington, Pennsylvania. New York, Texas, Washington, Pennsylvania. Getting it?
So this is not the option is available in the Slicer.
I'm Not You Has the Advanced Filtering Here. सो एडवांस फ़िल्टरिंग इफ यू आर अवेयर Of Excel Same Thing. You when you are
OK Contents are OK and Suppose Does Not There are lots of subcategories does not content it does not start with the a लेटर राइट यू अप्लाई द फ़िल्टर। So these are
लेटर राइट यू अप्लाई द फ़िल्टर। So these are The Sub Categories You Get. The Sub Categories You Get. These are the sub categories you get.
हैव डिफरेंट ऑप्शन। This is a text Right? सबैटेगरी इज़ अ टेक्स्ट। if you go For the advanced filtering in the cells, that Will be different again.
एंड सी द एडवांस फिल्टरिंग ऑप्शन। so you
End
Great
line graph Particular Chart
you selected the graph
Click on this over here suppose if you wish to Go for Top and If I Want to Get the Suppose Top three and may be Let's not go for top Let me go for the bottom three in the states
Let me go for the bottom three in the states With the vote states OK top and bottom three By Value By What You Need a Numerical Value for that drags the sales here
The Sales Here Apply the Filter and That's How You're Getting the States with the Both How You're Getting the States with the Both Sales You Can Also Go for Quantity Age Sales You Can Also Go for Quantity Age Well I should have shown you for one.
So if you want to remove the filter go for Clear Filter Shall we proceed to the filter on this Page? Shall we proceed for filter in this
Page? Shall we proceed for filter in this Page? Have not selected any chart. I have not Specific selected any chart. I Go
Specific selected any chart. I Go To this filter pane. This Time I Have Only Two options for the filters. That is filter On This Page and Filter on All Pages. Ok?
For now, let's understand that after this Page. That means if I click anything it will Be Reflecting on the Other Charts as Well. Ok? So, let's do it here. Filter on this page. In the filter on this Page, How Do I Want to Filter? Suppose I
Page, How Do I Want to Filter? Suppose I Want to filter based upon the sales? Let's Get the Sales Here. ok this time i don't have the top n when We Go For The Filter On This Page We Don't Have the option for top and we have only
Have the option for top and we have only Basic fluttering and we have advanced fluttering Clear now I am going for advance fluttering and I'm going for supposedly the same fluttering and I'm going for supposedly the same thing greater than okay so I'm going for
thing greater than okay so I'm going for C I am applying the same thing 50000 And and I'm going for less than equal to to 2 lakh apply the filter
OK Why Are We Not Getting It Just Keep It Give me a moment.
I have already applied the filter ok now let's try it out
Suppose let's try with the same thing let's Go for this may be 500000 still not working So please check it is working for you or not
Let's go for a simpler one. let's go for a Simple One. Let's Go for the Let's Say All categories here. Let's Go for the Sub Category here. Instead of the sales on this Page. Right? Let's Do It by the Sub Category Here.
Let's go for checking for the accessories Let's go for checking for the accessories Now It's Working So This Is For The Accessories It Is Showing For all the states as well see check it
For all the states as well see check it Changing
So if you wish to create a report okay Which is going to show you okay only may be For the subcategories OK only for the Subcategories That Starts With a Let's Check
Subcategories That Starts With a Let's Check You Can Fix That You Can Fix That You Can Fix That You Can Fix That You can display to the users
Be you can go for the state s well let's go for the state
And for whatever state you wish to check you can Get It
You can add more fields here. Let's Check For the category Also and subcategory As Well.
सो दिस इज़ वर्किंग फॉर द पेज लेवल। This is Working for the page level.
Check on the filter on this page please. So, This is only on this page. Yes, not both the graphs. Whatever Charts You have here, right? It will remain intact It will remain intact It will filter according to that
ऑफ अस हैव टू पेजेस। All of Us Have To Pages Right Now.
Now Go For Filter On This Page Nothing Is Happening on this page right so let's go for Happening on this page right so let's go for
Changes in this particular page but no changes
Right? सो, व्हाट वी आर ट्राइंग टू डू, वी Entire Work Book. Ok? So, multiple pages. Are there. सो, लेट्स ट्राई टु डू इट राइट
Now. सो, प्लीज़, चेक इट आउट। Here no matter, so वी हैव करेंटली टू पेज। No Matter We Have
रेस्ट्रिक्टिंग द यूजर फॉर दैट। For
The Subcategory Only. लेट्स गो फॉर एडिंग सब
Phones and storage right this is filtering The Page Yes Now Let's Check Page One
On this page will work on a particular page. But If You Have Multiple Pages in the Workbook And if you want to get into the details of It. May be in page one also you want to check For a particular detail and page to page, How many pages are there. you can go for
Filter on All Pages. Right? So, simply Get, suppose, why did I go for the Subcategory? Because subcategory is present here And Here, So You Will Be Able to Understand And Here, So You Will Be Able to Understand The Difference Here. Ok? So, let's go for
Dec. Let's Say or We Went For Sub Category Drag it here basic fluttering i vent for The This Time I Let Me Go for the Furnishing And Envelopes Copiers
And Envelopes Copiers This Is Happening Here Right Check Page One As well Copiers Furnishing Envelopes
Is Present Here Right You Will Be Able To Understand the Difference
Try it out and let me know if you're getting The Things or Not
But the thing is that category if you do, right? Since we don't have anything here, Probably, you will not be able to understand It. Ok? So, let's do it for this.
We can add the field category as well. Let's Do the category as well. Ok? So go for the Do the category as well. Ok? So go for the Category Furniture.
So category we have all categories. Let's Go For this. Both of them. So let's select For this. Both of them. So let's select You are getting everything Check It Out The Other Page As Well
This Workbook You Will Be Able to Filter That Using the Filter on All Pages
So what we have done so far right we have have looked into the filters we have Inserted the image right but what did I Mention we are going to create a multi page We're going to create a multipage report.
We're going to create a multipage report. Report Yes We Have Created Two Reports Report Yes We Have Created Two Reports It looks like a report. I have not Formatted it. यू कैन सिंपली गो फॉर एडिंग
A color. so that it looks like a report Right now. doesn't this look like a Report. So you can just go for adding anyone color. सो यू कैन गो फॉर एनी एडिंग एनी Basic color. Transparency I'm Reducing It.
Ok? सो एटलीस्ट इट लुक्स लाइक अ रिपोर्ट। Now What We Have to Do Page One and Page Two Now What We Have to Do Page One and Page Two
Now these two reports are separate reports Okay via and image like an hyperlink we
Ok
आस्क मी एंड गिव मी टू मिनट्स। I will जस्ट शेयर वन थिंग विथ यू ऑल। what we are गोइंग टू अचीव आवर अल्टीमेट गोल। I am गोइंग टू शो यू राइट नाउ। just give me a गोइंग टू शो यू राइट नाउ। just give me a Moment.
Visible to you all? Can you see it? Ok. नाउ व्हाट वी आर ट्राइंग टू अचीव Please check one thing. Ok? Please check one thing. Ok?
when i click
Right Now
You
What you need to do is create the buttons for That you have to be in the insert tab and That you have to be in the insert tab and You have to click over button. Are you getting the Insert tab? There you have the option for buttons. So let me
Go for the first I'm taking the right arrow. First I am taking the right arrow. Can go for increasing the size as well. Gate The button please. Nothing Else Right Arrow Button
No Do Once we got the button we have to get the rectangle we have to get the rectangle okay
rectangle we have to get the rectangle okay So again do one thing be in the insert tab So again do one thing be in the insert tab Only this time we are going to select The Shape Next to the button you have the shape here
Select it and go for any option of your Choice I'm selecting the second one you can Choose the first one as well I am selecting The Second One and You're Getting It Here Just The Second One and You're Getting It Here Just Drag
Step number one you have to get the button. Step Number two you have to get the rectangle.
What about others? I got one response. Are you able to get the rectangle? Great. Ok. So once you get this one, right Rectangle, once you get this rectangle, r यू गेटिंग दिस फॉर्मेट शेप ऑप्शन हियर? R
यू गेटिंग दिस फॉर्मेट शेप ऑप्शन हियर? R Are you getting the Format Shape option here?
Can you do you have the style option? do you Have the style option? In the style option the color you change it to Suppose I am changing it to grey colour. Ok?
Grey colour. यू कैन मेक इट ट्रांसपेरेंट एज well. well. लिटिल बिट ट्रांसपेरेंट। That's it.
Make it fully transparent as well. that Also works out.
again get another button from the insert tab but this time you go for The Left Arrow Button OK this time go for the
The Left Arrow Button OK this time go for the Left Arrow Button Go for the Button Left Arrow Left Arrow Button Go for the Button Left Arrow
Can make you can adjust the size the swipe is Totally Up To You
Image as Earlier Also I Have I Am
How to add an image
Ok
Adding the Image
It later. What we do? We Make It Bookmark Have to save it. बिकॉज़ दिस इज़ द शोर स्टेट।
प्लीज चेक यू आर गेटिंग ऑर नॉट। Just यू शैल बी गेटिंग दिस टू ऑप्शन। Two Pens Open for you.
Don't do anything. Whatever Selection You Have kept it same. जस्ट गो फॉर क्लिकिंग ऑन Add. सिंपली क्लिक ऑन ऐड इन द बुकमार्क्स। सिंपली क्लिक ऑन ऐड इन द बुकमार्क्स। You
सिंपली क्लिक ऑन ऐड इन द बुकमार्क्स। You डोंट हैव टू डू एनीथिंग। Just Click On Add. वी आर गोइंग टू सेव दिस स्टेट।
If I click on this button I am getting it Now if I click on this button what happens If I click on this button it shows this Object. If I click on this button it goes Object. If I click on this button it goes Right? So we have to hide the objects. V
Have to hide the object. so what you have What to Do When You Have to Go For Hiding this. Just Select This Eye Symbol Is there right? Just Click on This, Hide the
Is there right? Just Click on This, Hide the Image, Hide the Button, Hide the Shape And click on add. Only These Three Things Go for Hiding It Only These Three Things Go for Hiding It and click on add
Double Click and Rename It to Hide That's it.
You have to create two bookmarks. Show End Hyde.
Everything is done so if you don't want this Pay Right Now What You Can Do Click again in the bookmarks and the Selection pane suppose click here the Bookmarks are gone click here the selection The pain is gone. Understood?
We have created the bookmarks. Now the only The thing that is required is assignment. The thing that is required is assignment. Shall We Proceed?
This arrow, right? If I click on this button, It should show the objects. So what do you do? Just Click On The Button. You will be getting the Format button option. Isn't it? are you getting
The Format Button Option? Or the image will be gone. that's completely Fine. You select the button. You're getting the format Button option. There you have the option for action. Are you
There you have the option for action. Are you Getting the Option for Action? On the action please kindly confirm if you are Able to See the Action
Expand the Action Expand the Action Expanded There you will be getting typed
Action Type Selecting Go For lets the bookmark go for Selecting Go For lets the bookmark go for Selecting as the bookmark here select Selecting as the bookmark here select Bookmark and in the bookmark go for
Selecting As Show Because Whenever You Click On this it should show the objects for me
Ok OK, so now see whenever we publish it only. Click Fill Work Wherever We Are Doing It In the Desktop We Have to Go for Control Click. Ok? So, I will go for control. End click. You are getting this right now. It
Is showing the object. It is showing the object. Are you able to see It is showing the object. Are you able to see Who are you doing?
And go for hide. Because what should this button be? Do? This button should if you click on them that it should hide the bookmark it should hide the objects objects Right
Ok You have this button right now click on this button Right click on this button you are getting the Format button option Format button option You are getting the format button option there you
You are getting the format button option there you Have to get in on the action. You have to get in on the action. Have to get in on the action. You have to get in on the action. Right? In the action you have to select Bookmark. Now for me what should this button Do? व्हाट शुड बट दिस बटन डू? Whenever I
Click on this button it should hide. So I Am Going to select the bookmark that is hidden. Done. You have to repeat if it is show and hide.
For Control and Click it's all if you take Your cursor you can see here Control Plus Your cursor you can see here Control Plus Click to follow the link let's go for this
Bookmarks Vivek please go for your Bookmarks and Check Go to the Bookmarks And check have you created it or not have you Created bookmarks for the height
And Hide What Are the Bookmarks You Have Check It Out
See Half of the Things Are Done for Us Okay Half
व्हाट डड वी डू हियर? We First Save The Objects. सो फर्स्ट स्टेट वाज़ दिस वन
Do? वी हाइड द इमेज वी हाइड द बटन वी हाइड Bookmark.