- Видео 14
- Просмотров 37 472
Syed Ali Mahmood
Добавлен 15 сен 2020
Advance Ratio Analysis (With Scenarios).
This video is continuation of previous video (Dynamic Dashboard of IS and BS Ratios using DAX).
Просмотров: 372
Видео
Dynamic Dashboard of IS and BS Ratios using DAX.
Просмотров 7412 года назад
In this video, a dashboard of Income Statement (IS) and Balance Sheet (BS) ratios is created using simple DAX measures.
Use of Time Intelligence in Power BI
Просмотров 1422 года назад
In this video, a simple dashboard (of different periods) is prepared with the help of Time Intelligence Codes.
Data Modeling in Power BI
Просмотров 1482 года назад
In this video, basic data modeling is explained by creating relationships between multiple data tables/sheets.
Actuals Vs Budgets Analysis in Power Query.
Просмотров 19 тыс.3 года назад
In this video, I will be sharing with you the amazing Group By feature in Power Query. With the help of Group By, I have grouped different columns and perform an operation to get the desired result in a new column. In the end, I used simple DAX measures to prepare ACTUAL Vs BUDGET variance analysis and prepared some visuals.
Use of DATEADD function to generate time comparisons in P&L.
Просмотров 2973 года назад
DATEADD is a Power BI time intelligence function that we can use to generate time comparisons over a range of different time frames. DATEADD allows us to compare a measure to any time period, such as day, month, or quarter. Just by making a few tweaks in the formula, like changing the number of months or replacing month with quarter, we can easily have the data we are looking for. In simple ter...
How to fetch additional TB data in P&L report created by PBI.
Просмотров 9493 года назад
To fetch additional year’s data in the same P&L, all we need to do is to simply create duplicates of power queries and then upload the additional year’s trial balance by giving the new file path. Finally, DAX Time Intelligence function 'SamePeriodLastYear' will be used to get data of prior year.
Trial Balance to P&L in Power BI.
Просмотров 15 тыс.3 года назад
We can easily prepare a P&L by simply establishing connection with the trial balance. It requires some data transformation, modeling and DAX measures to present numbers in an easy to understand format.
Creating a Calendar Table using Calendar Auto function in DAX.
Просмотров 2293 года назад
One of the easiest ways of creating a calendar table is using Calendar() function in DAX. The Calendar function is a very simple function with just two input parameters; start date, and end date. The output of the Calendar function is a table with one column which includes all dates between the start and end date, with one day at each row. In this video, I created a date/calendar table with thi...
Sales Dashboard - with Prior Year Data using DAX and Time Intelligence in Power BI
Просмотров 1483 года назад
This video is extension of my last video and here I used a new DAX Measure ‘SAMEPERIODLASTYEAR’. This measure “Returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.” Sales PY = CALCULATE( [Total Sales], SAMEPERIODLASTYEAR( Dates[Date])) Costs PY = CALCULATE( [Total Costs], SAMEPERIODLASTYEAR( Dates[Dat...
Creation of Sales Dashboard using DAX and Time Intelligence in Power BI.
Просмотров 6993 года назад
This video explains Data modeling, Relationships, DAX and Time Intelligence measures leading to creation of a simple Sales Dashboard of a retail company.
Consolidation of multiple sheets in a single excel file (using folder option)
Просмотров 723 года назад
In Power BI, we can consolidate multiple sheets in a single excel file using folder option. All we need to do is just to make sure that all the sheets are symmetrical. Here, symmetrical means the number of columns and column heading should be same. However, we can have as many number of rows we want. This consolidation option is very useful for organizations where the daily, weekly, monthly and...
Power BI & Power Query - changes in source file
Просмотров 913 года назад
One of the most unique advantages of Power BI (PBI) is that it has significantly reduced the repetitive tasks and laborious work of users. Once the connection is established, the user just need to upload the updated source file to get the updated results, and there is no need to repeat the same steps of data formatting which have already been performed. Here is my second screencast in which I e...
Power BI - Introduction
Просмотров 2393 года назад
This video will help you understand the basics of Power BI. I have explained some theoretical aspects along with the practical demonstration of working on Power Query and then creating visuals. Below are the topics covered: - What is Power BI (Theory). - Power Query Functions and Connectivity (Theory). - Connection with Data (single excel sheet) with the help of Power Query and generating visua...
Can you also show how to present the same data hierarchial please? Thank you!
Very simply and nicely explained.
why multiply by -1 in the measure
I think instead to import two data set one for budget and one for actual, it could be import only one and then a copy of the same could be make through applied steps. At back end there will be one file and the model will be lighter then the method you applied sir
Your Variance % measure is incorrect. The denominator should be Budget not Actual
Your workings are great can we get thr the DAX forlulas and working files please....
Can we get the working files please
Great !! Anyway that we can calculate gross Profit , Operating Profit Net Profit etc ?
Excellent Bro Jazak Allah Khair Greeting from Yemen I hope you can share empty files
Hi Syed, one question why do I get the actual and budgeted sales in the Same column ?
brother can you share the practise file
Please provide exercise file
Salaam can you share the source data Sayed Bhai
Why did you need to add the "Type" columns?
can you share us the DAX formulas please
The P&L is not complete with sub totals - Gross Profit, Operating Profit, Profit Before Tax etc. Lets see if you have a great idea on how to get those in.
Thanks Syed, the sharing is useful and easy to follow
🌷 𝓟Ř𝔬𝓂𝔬𝐒ϻ
Thanks a lot Sir, Really helpful and easy to understand.
So good , where can i get xl file?
Thank you for sharing ! this is so helpful!
Mashaa Allah Good job Mr , Sayed can you provide data sheet to achive the goal appreciate your support .
please share pbix and dataset
please share bi and dataset
How to create a mapping table to map another table like you did in this video!
You did a great job in a very very simplest way Bravo! Keep shining
Can you give me this data
Sir, Can u please data set
the variance column is not adding correctly
Sir can you suggest me which institute provide us to power bi financials practical training about income statement, balance sheet etc.
I would check and let you know.
Assalamalakum bhaijan, thanks for making video on p&l sir can get the data set to practice along with u... My email id Is hszuheb@gmail.com It will be great help Thanks in advance
It possible to elaborate income statements? ,
Bro , would you please give data set file
I would check and revert.
Thanks, very helpful. waiting for more related to BI financials
Congrats, you made life easier for a lot of people.
Very Good. I can understand that your language was a challenge for you but you did a good job. Congrats
Very well presented! Easy to understand!
Glad it was helpful!
Very well, brief n to the point.. Easy to understand especially for beginners.
Glad you liked it