A for Analytics is a Leading Business Intelligence and Artificial Intelligence service provider on planet earth.
We are helping out several Fortune 500 Companies in Setting up Data Warehouse On-premise or Cloud, Data Transformation Layer, Business Intelligence layer like Tableau, Microsoft Power BI, Zoho Analytics, and Qlik. We are helping organizations in building AutoML, Custom Machine Learning Model for custom requirements.
If you are someone either from one of below two options then you need to follow us,
1. The Person wants to learn Analytics and get a highly paid job. You need to follow us to get valuable information.
2. The organization wants to Implement, Enhance, Support your Analytics, and Artificial Intelligence system in your organization to make effective data-driven decisions to increase revenue and reduce costs dramatically.
Join us by subscribing and participating in the comments with your questions.
You can visit our website - www.aforanalytic.com
Пікірлер
Thank you for the very useful video. I came across this video while looking for "how to identify whether a particular column in a fact table has been used in the existing visuals". Appreciate your advice.
Finished watching
This is very helpfull, thanks.
no explanation for sub folder
Thank you bhai Thank you Finaly 5 hr bad Salutions Mila
any idea if i want to get the total last year sales and then get the % difference from the current year monthly basis ex. LY total = 50000 CY Month = jan = 1000 feb = 2000 outcome = cy month jan = % diff
Hello, is there any way to achieve this but WITHOUT using bookmars?
Good Video dude, but i dont think you needed that 43 seconds opening sequence...
"promo sm"
Helpful video but Intro is too loud and long.
How the hell did this guy insert a second line?
I would suggest improving your presentation man!
Definitely - We will work on it soon.
It's very easy with numeric data... but can we do the same for countrows or count of text values?
Please share your questions to [email protected]
please stop making videos, u wasted 15 mins for 2 mins low quality stuff
How can i connect from 2 separate table where have date column with Date table?? TIA
awesome, many thanks
Glad you liked it!
i have a question, firts great your video congrats!!!, the question is how is the measure for de size in dax studio , i mean in MEGABYTE KBYTE ?? for example the col size is 19,67,29 what is this in MB O KB
Simple and concise.
Glad you like it
Do you know how to do the opposite? How to make it so that if the value is 0, you return blank instead?
reply email your questions to [email protected]
Ok, but now the user can click and select the shape, how can we prevent the user to select the shape?
Thanks :)
Thanks a lot
Hi, i need help to remove word city from a column having multiple names hai Eg Bhool city Kim city Right city I need to remove word city from that particular column and want ans Bhool Kim Right I tried using replace values but not working
Thank you, just what i needed.
Nice one
Bro what if the table is using the dashboard. Is there any chance to reduce
Then please try to remove all those columns which you are not using in any of your visuals and that will free up the memory size especially if they are text based columns and in general you shouldn't be having any text based columns in your fact table
This is great. Thank you!
Appreciate it! Thanks
How to compare current sales with any period in last year or any year previous year
helpful and clear but your mouse cursor is missing in the video which led me to loose attention every time, it made me to look here and there on the screen and I was lost. please, also show the cursor in your videos to attract the attention and make viewers more focused. consider this as a suggestion. All the best
Please send the link of filter panel video button
The best. It helped me to learn in few minutes what i was trying for a month.
Thank you.
Pathetic. Where is cursor/Pointer?????
Sorry mate! I didn't notice that.. will rectify that in upcoming videos. Cool things to come
Actually i was looking for the exact Topic..but the way u made this video is so diaapointing...your channel name on the video is so distracting..and with that you hide the cursor...like really...🤦🏻🤦🏻who do tutorials video without cursor..totally time waste
Hey sorry mate! We will shorten it! Thanks for feedback! Cool things to come
Thank you!!!
Appreciate it
If i select the current year(2021) in filter. it only shows 1/1/2021 to till date(07/28/2021) as a CY and 1/1/2020 to tilldate last year(07/28/2020). If i select LY (2020)in filter, it should show full year sales both in CY and PY sales. How to achieve this
Ohooooo
helpful and clear but your mouse cursor is missing in the video which led me to loose attention every time, it made me to look here and there on the screen and I was lost. please, also show the cursor in your videos to attract the attention and make viewers more focused. consider this as a suggestion. All the best
Very Helpful👍👍👍👍
(in timeline 6:06) for measure to get the difference in percentage(%) should be : Difference in Sales = DIVIDE((SUM(Orders[Sales])-[Last Year Sales]),[Last Year Sales])*100
Why no videos
We got busy with important projects and team is not in full productivity. We will come back very soon. Next plan: Real time procedure difference in Power BI and Tableau.
Thanks for the upload!
Thanks
Tried multiple times but not able to do
What is the issue you are facing?
How to add upto 5 charts using the same, it doesn't hide other charts if there are more than 2 charts
You can use the same technique to hide any number of components
I have the data in flat file, data is like every month data in separate file, so how to merge them and get this last year and current year comparison.. Pls tell the minimum time taken step
Use concatenate function to combine and add ''1" in day datepart
What if do not use date in first column of table and show by product
Can you please remove that right down twitter, KZread names. Its kind of distracting
Thanks Arun! We will definitely take your suggestion in consideration
Exactly...and that one at the top left corner too..😣
I tried this in a matrix and it still shows empty cells.
I should be showing. what is the step you followed?
@@aforanalytics9318 Batch Count = VAR _count = Count(DataTable[Machine]) RETURN IF(ISBLANK(_count),0,_count)
For matrix, it is not working for me also
@Sumeet Rathi Did you find any other solution? because it's not working for me as well.
Thanks Dude
Welcome 😊
Can this be done for matrix table? Please tell me
Yes it can be done for any kind of visualization
@@aforanalytics9318 Thankyou