Power BI End to End Project ( Banking Domain)

Enroll in our new batch every month. Kickstart Your Career with Our Full Stack Power BI with Microsoft Fabric Course 2024.
Get free demo classes by Registering now :- bit.ly/3IG1wmF
Datasets for practice
drive.google.c...
End to End Power BI Project - Banking Domain
We will be implementing complete Power BI Projects end to end. Right from requirement gathering to publishing the report. We will be following all the real time scenario based requirements. We will be having all follow up videos. Please do watch all videos sequentially. These videos will get to complete end to end knowledge on projects.
Once the data is gathered, next step is to clean the data, transform the data and proceed with data modelling. data cleansing becomes very important step in project. because it deals majority of issues. wat u give in, will come out. if we give clean data, we will get the best insights of business.
***********************
Live Powerbi Interview with Capgemini : • Capgemini Interview 20...
Live Powerbi Interview with EY -Round 1: • First Round Live Inter...
Live Powerbi Interview with EY -Round 1: • Live Recorded Intervie...
Interview tips and Tricks: • Power BI Tips and Tric...
Self introduction: • Self Introduction in I...
Salary Negotiation: • How to Negotiate Best ...
*************************
How are we different from others
1. 24*7 Life time Access & Support
2. Flexible Class Schedule
3. 100 % Job Guarantee
4. Mentors with +14 yrs
5. Industry Oriented Course ware
6. Life time free Course Upgrade
------------------------------
Call us on IND: 8951795123 / 8951785123 / 9916961234 to talk to our Course Advisors.
This is the 3rd video in this playlist. We will demonstrate the usage of all charts in power bi. An expert in power bi knows when to use right chart for right data. This will be very useful to build story.
#azure #microsoft #microsoftfabric #datascience #dataanalytics #powerbi #cloudcomputing
#PowerBi #DataAnalytics #BusinessIntelligence #DataVisualization #BigData #Microsoft #Analytics #DataScience #BI #SQL #Excel #AnalyticsTool #MasteringData #DataInsights #Dashboard #DataAnalysis #Tableau #DataDrivenDecisions #DataReporting #businessanalyticscourse #powerbiinterview #powerbiinterviewquestions questions #datascience

[@raw-heataviation6932]

WHAT A TRAINER, HATS OFF TO THIS LADY, EVEN THOUGH I DIDN'T MISS THE SINGLE CONTENT AND FOR 5-7 HRS I CONTINUOUSLY SAT AND WATCHED THE VIDEO AND PARALLELLY PRACTICED THE SAME. I REALLY LIKED THE VIDEO, YOU MADE MY ALL CONCEPTS CLEAR IN A SINGLE VIDEO AND MADE MY LIFE EASY TOO. THANK YOU SO MUCH

[@KSRDatavizon]

Thank you

[@ujjwalgupta7]

This is called a real time project...🙏🏻

[@KSRDatavizon]

Thank you so much, please subscribe our channel for regular updates

[@goforitXO]

I Have never seen such a humble trainer in my life , she was so sweet and explained everything from scratch , hats off to the trainer for such a beautiful lecture on project building. Even a kid with zero knowledge could have easily understood everything , we need more such people for teaching , thanks a lot , learnt more about power bi in 3 hours than i did in my entire last year 😀

[@KSRDatavizon]

thanks for feedback !!!

[@teeman4629]

Without a doubt the best power BI Video i have watch. The trainer is awesome

[@KSRDatavizon]

Thank You so much

[@jafarhussain6606]

"why this is not working" hahahaha so cute. Jokes apart, excellent video, many thanks to the team and instructor. All in one video.

[@KSRDatavizon]

Thank You !

[@hrudaysahu2977]

Beautifully explained end to end execution of the project.The way she explained and the presentation was awesome.

[@KSRDatavizon]

Thank you so much, please subscribe our channel

[@koshtinimesh8247]

Thank you for sharing this project very good understand and detail explain more gain insights about project.

[@KSRDatavizon]

Glad it was helpful!

[@sreenivas_chinni5623]

Thanks to Uma and KSR Datavizon for this very informative session... I watched this session at the right time of my journey... I am very thankful to you guys... The way she explained every topic and how she was interacting was very impressive... Best session on Power BI i ever watched... 👏👏👏👏

[@KSRDatavizon]

Thank you so much for your kind words! We're glad you found the session helpful and engaging.

[@rockjohn1563]

I had made this full project after seeing your video and I would like to thank you soo much that you made us understand the topics in a very easy way.. Thank you for all your efforts...👌👌👌

[@KSRDatavizon]

Most welcome 😊 Please subscribe our channel for regular updates

[@nimikajadav3004]

You are very nice trainer.. U mentioned each and every small concept in detailed manner. Thank you so much... Its very helpful to me... ❤❤❤

[@KSRDatavizon]

Thank you so much, Please subscribe our channel for regular updates

[@praveengovindappa6218]

What a trainer i had never seen before like this type of online class very usefully completed full course and topics greater to meet you✌👌👍

[@KSRDatavizon]

Thanks a ton

[@ArchnaVijay]

honestly amazing !!! I was badly in search of this end to end project , tons of thanks to you !!

[@KSRDatavizon]

Great to hear!

[@TataNaresh]

Wow amazing session the way uma explaining concepts is flawless enjoyed the complete session. Looking forward to more interactive sessions like this. Thank You 🤩👍

[@KSRDatavizon]

Thank you so much, Please subscribe our channel for regular updates

[@PankajSharma-jl3ec]

Mam such wholistic end to end videos are really appreciated and helpful

[@KSRDatavizon]

Glad to hear that, Please subscribe our channel, it will motives to do more videos

[@princemurali5509]

One video cleared all my doubts Thank you #KSR team 🙏🙏🙏

[@KSRDatavizon]

You are welcome

[@nikhilrana668]

Let me begin by saying this first, The video is amazing. Quick suggestion for calculating the number of active customers: The following DAX formula feels to me like a better fit. Given that it is the same table that we use for our purposes and is easy to read. = CALCULATE(count(Bank_Churn[CustomerId]),Bank_Churn[IsActiveMember] = 1) Similarly for the inactive members it can be easy to read as follows: = CALCULATE(COUNT(Bank_Churn[CustomerId]),Bank_Churn[IsActiveMember] = 0) Thank you for the amazing videos.

[@mallikarjunakonkamallikarj4764]

Nice bro good and Easy idea i got result through yours simple way DAX.

[@KSRDatavizon]

I appreciate your suggestion and I'm glad you found the video helpful!

[@renin2544]

Thanks a lot! Every minute in it was valuable. Please add many more such end to end videos.

[@KSRDatavizon]

Thank you, We will

[@pavithrakomma6549]

Sooooper helpful and clear explanation. We want more videos like this on different domains...

[@KSRDatavizon]

Sure 👍

[@ParulGulati-yz9bq]

Thanks a tonn. I have been searching for such video for long time. Thanks a million for making this. This is so informative and helpful. Cleared all my doubts. 🙏

[@KSRDatavizon]

You're welcome! I'll be expecting a million-dollar check in the mail then!, Please subscribe our channel it motivates us a lot

[@chandurock9817]

​@@KSRDatavizon mam can you provide total deccription too

[@mallikarjunakonkamallikarj4764]

Good explain i could understand with uma mam brief lecture on project Mam i request you do more complete projects in different kinds of scenarios please...You have excellent teach skills nice english communication..

[@KSRDatavizon]

We will try to do more videos

[@shubhamawale4881]

Thanks for content like this, your project helped me to understand end to end approach of how power bi works. please add more videos. your work is really appreciatable.

[@KSRDatavizon]

Thanks, will do! ASAP

[@zohaibsherazmughal2723]

Truly Insightful session, engaging and Instructor explaining the concepts in the simplest manner possible, very supportive and humble. Hats Off to you :). Also Thanks for making the premium content available for free.

[@KSRDatavizon]

Glad you enjoyed it! Please subscribe our channel for regular updates

[@niranjaniammu4478]

Hi uma… you are amazing… the way you explain. Thank you so much for your inputs… love from Poland.

[@KSRDatavizon]

You are so welcome!, please subscribe our channel for regular updates

[@estudios-sx5ut]

1,000,000 of thanks to share this treasure of power bi video. I would like to study with you, if I would have the oportunity. Again, thanks a lot.

[@KSRDatavizon]

Thanks

[@beingrishi6450]

Very valuable n informative video

[@KSRDatavizon]

Thanks a lot

[@akshaypatil8155]

51:44 why in line chart, months are not in chronological order like jan, feb, march etc......they are at random whe i try to do it

[@RajatMishra-pp7lf]

Facing the same problem.I hope you found the solution. Please help if you got the solution.

[@4nxh___]

Well-articulated , You covered end to end project with great patience, i must say you are an excellent tutor, Uma

[@KSRDatavizon]

Thank you so much, Please subscribe our channel for regular updates

[@sumijasukumaran1394]

Best project explanation in power bi

[@KSRDatavizon]

Thanks a lot

[@prachitamta4098]

Thank you so much. Your explanation is mind blowing.

[@KSRDatavizon]

You are most welcome, You are welcome! Please subscribe our channel, it motivates us

[@gauriatharv]

Thanks a tonnnn. I have been searching for such video for long time. Thanks a million for making this. This is so informative and helpful. Cleared all my doubts. 🙏🙏🙏🙏🙏

[@KSRDatavizon]

Glad it was helpful! Please subscribe our channel for regular updates, its motivate us

[@sanjaydhupadali8121]

Amazing explanation from the ksr team, Request you to make end to end project video on supply chain solutions (sales, CRM, procurement, finance, marketing, operations)

[@KSRDatavizon]

Thank you for the suggestion! We'll definitely consider creating an end-to-end project video on supply chain solutions.

[@parimalas4458]

Hi hope you are doing well This video helps us a lot and the way you explained is very detailed, and you are providing keen knowledge about Power Bi Thank you

[@KSRDatavizon]

So nice of you

[@chandrashekharv5176]

Very much appreciate for insightful project

[@KSRDatavizon]

It's my pleasure, Please share and subscribe our channel, Thank you so much for your compliment.

[@cmlibin]

very helpful end to end project, thanks from UK

[@KSRDatavizon]

You're welcome! Please subscribe our channel for regulr updates.

[@ritikagrawal9268]

Tonnes of Thanks Each concept explained in very simple manner

[@KSRDatavizon]

Thank you so much for your comment, please subscribe our channel for regular updates. it motivates us a lot

[@adityavirkar2562]

Detailed Explanation, Great Video

[@KSRDatavizon]

Glad it was helpful! Please subscribe our channel, it motivates us a lot

[@lavikolli]

Well explained. Even minor details also explained.

[@KSRDatavizon]

Thank You so much

[@manjumankoji1448]

It was very informative, Thank you so much!

[@KSRDatavizon]

Glad it was helpful!

[@SyedliyakathaliAli]

learnt Alot . Amazing project .Thanks team

[@KSRDatavizon]

Always welcome, please subscribe our channel for regular updates and it motivates us

[@Bk-cs1nr]

Awesome session from this awesome teacher ...

[@KSRDatavizon]

thank you

[@Emperor_of_dark_realm]

Awesome Trainer, Hatsoff to the session creator. This module was very engaging, interesting.

[@KSRDatavizon]

Thank you so much, Please subscribe our channel it will get motivation for us

[@nishasharma1217]

Thank you so much for the wonderful video. It's so simple to understand. Humble trainer. Hatts off..

[@KSRDatavizon]

You are most welcome

[@dilipinamdar5523]

Thank you very much for End to end project.

[@KSRDatavizon]

You are welcome! Please subscribe our channel, it motivates us

[@DATAisFuturRe]

very helpful information. well explained..thanks from DATA is FuturRe channel dedicated to Data Science

[@KSRDatavizon]

You are most welcome

[@kraghava3584]

Great session

[@KSRDatavizon]

Thank you somuch, please subscribe our channnel for regular updates and it motivates us a lot

[@Pushparaj2011]

Really a Good session. Topics well covered and very useful

[@KSRDatavizon]

thank you so much for your feedback, will make more sessions on this. please subscribe for regular updates and it motivates us a lot

[@KshitijaChilbule]

omg very deep explaination, thank you so much ma'am

[@KSRDatavizon]

Most welcome 😊, Please subscribe our channel for regular updates and it motivates us a lot

[@ajaydalvi1378]

Thankyou for this amazing project and to the point explaination!

[@KSRDatavizon]

You're very welcome! please subscribe our channel it motivates us to do more videos

[@VijayKumar-mp3bp]

Hello mam excellent explanation, while I was doing power query the Bank churn particularly the Bank doj column taken power query as text while I was changing to date or date time it is giving error in data pls resolve this .

[@KSRDatavizon]

Understanding the Issue: It seems you're encountering an error when attempting to convert the "Bank DOJ" column from text to date or date/time format in Power Query. This typically occurs when the text data is in an inconsistent or unrecognized format. Troubleshooting Steps: Inspect the Data: Check for Inconsistencies: Ensure that all values in the "Bank DOJ" column are formatted consistently (e.g., "DD/MM/YYYY", "MM/DD/YYYY"). Identify Invalid Dates: Look for any entries that might contain invalid dates (e.g., incorrect day, month, or year). Remove Extra Characters: If there are any extraneous characters (e.g., spaces, hyphens) surrounding the date, remove them using Power Query's text functions. Adjust the Data Type: Choose the Correct Format: Select the appropriate data type (date or date/time) based on the format of your data. Specify the Format: If your data is in a non-standard format, you might need to use the Text.Format function to specify the correct format. For example, if your data is in "DD/MM/YYYY" format, you could use: Code snippet Text.Format([Bank DOJ], "DD/MM/YYYY") Use code with caution. Handle Errors: Use try...otherwise: If there are invalid dates in your data, you can use the try...otherwise function to handle errors gracefully. For example: Code snippet try Text.Format([Bank DOJ], "DD/MM/YYYY") otherwise null Use code with caution. Filter Out Errors: You can also filter out rows with invalid dates using the Table.SelectRows function. Example Power Query Formula: Code snippet let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("dZAAAAAAAAgEAAAD/AAAA/gAAAAAAAAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = #table({"Bank DOJ"}, {{"01/01/2024"}}) in _t), #"Changed to Text" = Table.TransformColumns(Source, {{"Bank DOJ", Text.Type}}), #"Filtered for Errors" = Table.SelectRows(#"Changed to Text", each try Text.Format([Bank DOJ], "DD/MM/YYYY") otherwise null null), #"Added Custom Column" = Table.AddColumn(#"Filtered for Errors", "Bank DOJ (Date)", each try Date.FromText([Bank DOJ], "DD/MM/YYYY") otherwise null) in #"Added Custom Column" Use code with caution. This example assumes your data is in "DD/MM/YYYY" format. Adjust the format as needed based on your specific data. Additional Tips: If your data contains time information, you'll need to use the appropriate date/time format (e.g., "DD/MM/YYYY HH:MM:SS"). Consider using Power Query's built-in date/time functions (e.g., Date.FromText, Time.FromText) to simplify your transformations. If you're still encountering issues, provide more details about your data (e.g., sample values, expected format) for more tailored assistance. By following these steps and carefully inspecting your data, you should be able to successfully convert the "Bank DOJ" column to the desired date or date/time format in Power Query.

[@sushantchougale6818]

Thank you very much 😊. Please Bring more end to end project videos🙏🙏🙏🙏

[@KSRDatavizon]

Sure sir will do

[@thepowerofpositivethinking2593]

its very interesting

[@sarathreddy-bs9qg]

Learned almost all in one class thank you

[@KSRDatavizon]

You're welcome, please subscribe our channel for regular updates

[@nehahashmisyed1103]

Thanku mam for the wonderful session.❤

[@KSRDatavizon]

Keep watching,You are welcome, Please subscribe our channel for regular updates and its motivate us a lot

[@yakkaluruvijaysankar787]

Very useful information. Thanks for sharing this information. All my doughts were cleared. Thank you very much. Please do more videos like this.

[@KSRDatavizon]

Nice to hear

[@techhyderabad2673]

Very nice video...really helpful... But while am trying to create Exit and retain customers measures am getting total customers values... Why?

[@KSRDatavizon]

pls post your measure calculation here.. there could be filter context error

[@dwitikrushnapanda2794]

Excellent discussion. Thank You

[@KSRDatavizon]

Our pleasure!

[@syedismail1998]

Very useful project I have been following your channel since year expecting few more different projects 👍👏👏

[@KSRDatavizon]

Thank you very much

[@nikhilnikk5569]

Good explaination mam, please upload 1 more project.

[@KSRDatavizon]

Will upload soon

[@lij7886]

Plz do more videos like this, thank you soo much for such an amazing content

[@KSRDatavizon]

sure, thank you so much for your valuable feedback, Please subscribe our channel, it will motives to do more videos

[@shobhitsharma2137]

Amazing work hope will get some more in near future

[@MoonShine-bs6cl]

Its a good video, but if you would have included the Data refresh after RLS , issues y it doesn't work in desktop and powerbi service it would be great... Errors and issues also has to be explained.. It will be helpful

[@KSRDatavizon]

Thanks for the tip, please subscribe our channel for regular updates

[@pratiksonawale1997]

Amazing Trainer .

[@KSRDatavizon]

Thank you so much, please subscribe our channel for regular updates

[@seematarihal506]

Hi maam your explanation is good and i have to request you please increase when you write dax formula the screen is not visible so word not correct find out that

[@KSRDatavizon]

sure will make in future videos, thank you for letting us . please subscribe our channel for regular updates

[@kisshor1000]

Hello mam, can u upload one more new project bacuse its very helpful to us. I trid this project its very easy to learn nice and nice. Requested to you pls uplaod another new topic project

[@KSRDatavizon]

Will upload soon

[@kisshor1000]

@@KSRDatavizon ok thnks. I m doing internship now but we hv don't know abt projexlct and i saw your videos and i hav done your project bank domain so pls giv us one more project pls

[@jothiswarupmvs8785]

Thanks a lot for this kind of great content mam, Hats of to your patience levels🙂

[@KSRDatavizon]

Thanks a lot

[@avinashshinde2659]

I have question that datemaster table values are being used for analysis exit of customer, "DOJ+Tenure",should be used for churn analysis.....but DateOfJoining has been used ???

[@KSRDatavizon]

we can do either way sir.. each biz defines own way of churn

[@SAIKIRANVANKAR]

Very UseFul. thank you

[@KSRDatavizon]

You are welcome

[@karthikrao1021]

Good session that covers end to end content on a high level!!

[@KSRDatavizon]

Thank you so much for your responce, please like, share and subscribe our channel for regular updates, and it motivates us a lot.

[@abdulbasit6951]

Very well explained. you deserve million subscribers. kindly make video on telecom end to end project 😍

[@KSRDatavizon]

Thank you so much, please subscribe our channel, it motivates us to do more videos.

[@kebincui]

Excellent tutorial.Thanks for sharing 👍

[@KSRDatavizon]

Thank you so much, Please subscribe our channel for regular updates

[@krishnamurthy79]

Very Nice and clear explanation

[@KSRDatavizon]

Thanks for liking, please subscribe our channel for more videos like this

[@vijayamutyala4213]

Thank you madam...Very very good video...I can't find right end to end report with healthcare data or hospital data .Please upload one video with healthcare data analysis ...Thank you

[@janardhanrgandhi410]

Wonderful video thanks

[@KSRDatavizon]

Thank You

[@karankalimuthu8221]

hi mam, the current month exit customers and previous month exit customers on the line chart visuals are resulting incorrect Results! can you please check???

[@PraveenkumarKamtam]

the first report clustered column chart is not working as expected

[@vishnudeshmukh4749]

Hi , thanks for giving this most valuable information this cleared some of doubts, i have question that when you created new table as calculation how its automatic connect with fact table?

[@ArifKhan-qo9jw]

Bcoz same Column name. as they used fact table "Date Column" if you remember.

[@KSRDatavizon]

Yes, you can

[@sureshboddana33]

Nice madam you will complete information regarding power bi

[@KSRDatavizon]

thank you

[@POOJIASH]

Please do one video for a pharmacy project.

[@qasimjan5258]

Please also do in depth Sales Analysis like this one.

[@KSRDatavizon]

sure sir

[@melainenyuyfoninsaikila5812]

Greate video... for the SWITCH, what about using the AND out of brackets instead of the && eg Credit Type = SWITCH( TRUE(), AND(Bank_Churn[CreditScore] >= 800, Bank_Churn[CreditScore] = 740, Bank_Churn[CreditScore]

[@arianaamores7147]

Truly really cool and helpful thanks 😊 girl

[@KSRDatavizon]

You're so welcome!, please subscribe our channel, it will motivates us to do more. thank you

[@WalkBloomWorld4267]

so helpful, very nicely explained

[@KSRDatavizon]

Glad it was helpful!

[@mymourya]

Thanks Uma, well explained.

[@KSRDatavizon]

You are welcome 😊

[@jarredvoorneveld7943]

After importing the csv bank churn, the dates are mixed format. Power query gives errors when converting to date.

[@KSRDatavizon]

Converting Mixed-Format Dates in Power Query Understanding the Problem: When importing CSV data into Power Query, it's common to encounter mixed date formats, especially when the data source isn't consistent. This can lead to errors when attempting to convert the data to a date data type. Solution: Identify the Formats: Use the Text.Format function to inspect the first few rows and identify the distinct date formats present. For example: Code snippet Table.TransformColumns(YourTable, {"DateColumn"}, each Text.Format(_, "yyyy-mm-dd")) Use code with caution. Replace "yyyy-mm-dd" with the appropriate format based on your data. Create a Custom Function: If you have multiple formats or complex logic, create a custom function to handle the conversion: Code snippet let ConvertDate = (dateText as text) as datetime => if Text.StartsWith(dateText, "MM/DD/YYYY") then DateTime.FromText(dateText, "MM/DD/YYYY") else if Text.StartsWith(dateText, "DD/MM/YYYY") then DateTime.FromText(dateText, "DD/MM/YYYY") else DateTime.FromText(dateText, "YYYY-MM-DD") in ConvertDate Use code with caution. Apply the Function: Use the Table.TransformColumns function to apply the custom function to the date column: Code snippet Table.TransformColumns(YourTable, {"DateColumn"}, each ConvertDate(_)) Use code with caution. Example: Assuming your date column is named "Date" and has formats like "MM/DD/YYYY" and "DD/MM/YYYY", you could use the following code: Code snippet let Source = Csv.Document(File.Contents("YourFile.csv"), [Delimiter=","]), #"Changed Type" = Table.TransformColumns(Source, {"Date"}, each try DateTime.FromText(_, "MM/DD/YYYY") otherwise DateTime.FromText(_, "DD/MM/YYYY")), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each not IsError([Date])) in #"Filtered Rows" Use code with caution. Additional Tips: If you're unsure about the formats, you can use the Text.Format function to experiment with different formats until you find the correct ones. For more complex scenarios, you might need to use regular expressions or other advanced techniques. Consider using conditional logic or custom functions to handle edge cases or specific requirements. By following these steps, you should be able to successfully convert mixed-format dates in Power Query and avoid errors.

[@nagaradonasrinivasulu3044]

clear explanation....thank you

[@KSRDatavizon]

You are welcome

[@bhuhsan009]

UMA thank you so much .... it's really helpful..

[@KSRDatavizon]

You are most welcome, Please subscribe our channel it motivates us

[@shaikakil7957]

While loading data I'm not getting table name.. It's coming like Table 1 , Table2

[@saikumar-vt5th]

credit card holder = CALCULATE(COUNT(Bank_Churn[CustomerId]), CreditCard[Category]= "credit card holder") where wrong in this DAX formula I get blank in card visual

[@Goku919sai]

Same problem I faced

[@rightangle6453]

Same

[@KSRDatavizon]

it should not be the case.. check typo once.. and follow same process as in video

[@KSRDatavizon]

It should not be the case.. check typo once.. and follow same process as in video

[@mallikarjunakonkamallikarj4764]

Number of Creditcard holders = CALCULATE(COUNT('Bank_Churn (1)'[CustomerId]),'Bank_Churn (1)'[HasCrCard]=1)

[@UrbanWhizz]

Too good

[@KSRDatavizon]

Thank you so much

[@chandbashashaik4317]

Too Good Madam

[@KSRDatavizon]

Thanks a lot, please subscribe our channel it motivates us

[@neetasharma1440]

very nice explanation...Could you plz made one video for data security using principle function

[@KSRDatavizon]

sure, will make those video shortly . than you.

[@Introvert0696]

Datemaster = CALENDAR(FIRSTDATE(Bank_Churn[Bank DOJ]),LASTDATE(Bank_Churn[Bank DOJ])) i'm getting this error A column specified in the call to function 'FIRSTDATE' is not of type DATE. This is not supported. pls reply

[@isarivelanmani3328]

Hi thanks for the video. While i create column chart with active member vs inactive along date and month name onlu gives blank values. What is the issue? Pls help me

[@pavithrakomma6549]

Mam make a video on what key parameters we take for a businesses analysis

[@KSRDatavizon]

Sure mam will do asap

[@smitakalunge4695]

Thanks a lot, really really helpful!!

[@KSRDatavizon]

Thank you for your kind words, they mean a lot to me! Please subscribe our channel for regular updates.. and its motivates us a lot ,, thanks again

[@wingsofdream2365]

Most awaited video... Thank you so much 🙏🥰

[@KSRDatavizon]

My pleasure 😊, Please subscribe our channel, it will motives to do more videos

[@shirleyanthony8110]

Messed up the bookmark part. She wasnt clear herself what to do. ended up confusing.

[@ShivaliKeshari]

Hey could you please tell me how to collect data regarding any project. I mean how did you get these data

[@KSRDatavizon]

Collecting Data for a Project: A Comprehensive Guide Understanding Your Data Needs Before you begin collecting data, it's crucial to define your project objectives and identify the specific data points you need to achieve them. Ask yourself: What questions do you want to answer with this data? What decisions will be made based on this data? What types of data will be most relevant? Data Collection Methods Once you have a clear understanding of your data needs, you can choose appropriate collection methods. Here are some common approaches: Primary Data Collection Surveys: Create questionnaires to gather information from respondents. Online surveys, paper surveys, and in-person interviews are common methods. Interviews: Conduct structured or unstructured interviews to get detailed insights from individuals or groups. Observations: Observe people or behaviors directly to collect qualitative data. Experiments: Conduct controlled experiments to test hypotheses and gather quantitative data. Secondary Data Collection Existing Databases: Utilize databases from your organization, government agencies, research institutions, or industry associations. Published Research: Review academic papers, articles, and reports for relevant data. Online Resources: Search the internet for publicly available data sets, statistics, and reports. Data Quality and Validation Accuracy: Ensure the data is correct and free from errors. Completeness: Verify that all necessary data points are collected. Consistency: Check for inconsistencies or contradictions within the data. Reliability: Assess the trustworthiness and credibility of the data source. Validity: Confirm that the data measures what it is intended to measure. Data Cleaning and Preparation Formatting: Standardize data formats and ensure consistency. Outlier Detection: Identify and handle outliers or extreme values. Missing Data: Impute missing values or exclude them based on your analysis goals. Data Transformation: Apply necessary transformations (e.g., normalization, scaling) to prepare data for analysis. Data Analysis and Visualization Choose appropriate analysis techniques: Descriptive statistics, hypothesis testing, regression analysis, data mining, etc. Utilize data visualization tools: Create charts, graphs, and dashboards to present findings effectively. Ethical Considerations Informed Consent: Obtain informed consent from participants if collecting personal data. Data Privacy: Protect sensitive data and comply with privacy regulations. Data Security: Implement measures to safeguard data from unauthorized access. Example: If you're conducting a market research project to understand customer preferences for a new product, you might use surveys, focus groups, and social media analytics to collect data on customer demographics, needs, and buying behavior. Would you like to discuss a specific project and explore data collection methods tailored to your needs?

[@agneevash]

Thanks for sharing this video and thanks for tutor too. Extension to the question on DIRECT QUERY MODE, is there a chance that we get error in data while refreshing very frequently like every 10 minutes? If so how we clean that data? TIA

[@KSRDatavizon]

Yes, absolutely, please subscribe our channel for regular updates

[@karikoga320]

Thank you for this excellent video. Are you able to provide a template for business requirements document

[@KSRDatavizon]

Yes, soon