Should accountants learn data analytics?

[@VIRO1982]

she is the only reason why I could survive to learn audit...most passionate and best accounting lecturer I ever had...thanks again

[@amandalovestoaudit]

Thank you Mahavir!

[@kwrer6087]

Thanks for sharing your wonderful insights, if you like to find out more insights and tips on this topic, pls check this out too > kzbin.info/www/bejne/jXnbZomma7l0bqs

[@alialoush1198]

Do you think that accountants are going to be automated in the upcoming years with Technological advances emerging ?

[@titilope1889]

I agree 100%

[@Null-rv2rt]

@@amandalovestoaudit hye amanda is there any better option for cma usa

[@kvs123100]

Stupid stuffs get millions of views and great stuffs like this doesn't even touch 100k! Hats off for your effort! Thanks a ton!

[@elbaymammadyarov8120]

Intersts my friend, interests.

[@pkavenger9990]

i have a bachelor in Accounting and Finance and i am recently a intermediate Python developer and when i meet people who have degree in Computer science, they would be like OMG how can you learn to code when you don't have any degree in computer science. Me: "Well news flash you don't need a degree to become a software developer, you need to be a problem solver" and i know how many excel task that people do can be automate with python so easily and also through web scrapping we dont need to copy paste data in excel and then clean all the shit for hours to get what we want. My colleagues spends hours into work and I can do their job in just few minutes. Coding is hard though specially debugging is so frustrating but as an accountant we often get into situation where we cant find a transaction that's missing or other complicated troubleshooting, so its not that kind of a new situation for us. Coding is basically can be defined as "I would rather think hard for 4 hours instead manually laboring my way out of my problem for days."

[@amandalovestoaudit]

That is awesome to hear! Python does scare me but I hear such good things from my researcher colleagues who use it. Good on you for taking the initiative 👏👏👏

[@flrazvan]

Exactly, nice reply man. I am on the same road. I graduate the most prestigious university in my country Romania for accounting. What is interesting we do learn also a lot of databases at the university, in fact, Faculty is called Accounting and Information systems. As of now, because of corona Crysis, i lost my job and looking forward to a reconversion. As I was in top 10 people from my year on IT ( SQL+ MSAcccess, Excel&VBA, Prolog, VisualBasic etc) i was thinking that returning on my old passion can help me earn the money to support my family. Python is the first is coming to my mind as I saw it has some accounting application and also data analytics. Do you have some recommendation? How long it took for you to make your transformation? PS: I love accounting and tools that help doing it faster and allow a higher understanding of it.

[@pkavenger9990]

​@@flrazvan well it took a year for me to reach intermediate level. but the main thing is you need to become two person, one a problem solver and second a coder. List of books that teach coding and problem solving. 1) Think Python 2) Automate the boring stuff with Python 3) Programming Python 4) 90 Effective way to write your code 5) Fluent Python 6) Python cookbook (Best master book for experts) * Problem Solving with Algorithms and Data structure with Python Book (Must read this book for programming concepts)

[@flrazvan]

@@pkavenger9990 thanks !!

[@bongokuphiwenyembe4611]

@Pak Avenger I'm also on the same path but I'm so overwhelmed. Could you please share on your journey to learning python

[@jigarvariyavwala3999]

Amazing videos. I cleared my one of the big 4 Auditing profile interview just by watching your videos on different topics. It helped me a lot to remember things and understand them more efficiently. Thanks Amanda. 😊

[@jigarvariyavwala3999]

If you can please share your Linkedin profile so we can connect there for building future professional relationship.

[@amandalovestoaudit]

That is excellent news Jigar! If you search for Amanda White and UTS on LinkedIn - I should come up as one of the high ranking results.

[@hussainmuhammad4901]

The best and most lovable accounting teacher I have ever come across. Love from Pakistan

[@amandalovestoaudit]

Aww thank you 🙏 ☺️

[@hussainmuhammad4901]

Thanks Mam. I am an aspiring CA and your videos have come @ the right time for me. You are such a blessing mam. Need your prayers and support. Hooray accountants...:)

[@prabhatgupta7]

Ma'am , i request you bowing down to earth , please make more videos , regarding this " computer science " intervention in accounting and finance . I am currently pursuing Chartered Accountancy in india , got finals in May . I sometimes get tensed about whether i will be relevant 5-10 years down the line or not . I want to upskill but its confusing as to which specific language or course or what should be the direction of venturing into these computer sciences . I have been into internal audit in my 3 year articleship . I also have confusion as to how to choose a career line between audit and finance and pure accounts . I seem to be interested in all 3 of them . Thanks for this vid though .

[@amandalovestoaudit]

A great idea - I'm working on interviewing some really interesting people in the technology space this year - some are software vendors/companies, others in the digital and blockchain assurance area :) I'll be sure to include some recommendations on what specific areas of studies the experts recommend :)

[@1252PFC]

I am located in USA, but I always learn so much about auditing from Amanda.

[@amandalovestoaudit]

Thank you!

[@manoja.8510]

Not only Amanda ,now Manoj also loves to Audit. Thqqq so much for such fun classes .

[@amandalovestoaudit]

Love it - thanks Manoj!

[@m9rd0v]

Hi Amanda. Thank you for this and for your channel. Your videos really helped me a lot a few years ago when I was studying my post grad. I am now qualified (CA(SA)) and I can't agree with you more. Since I finished my articles, I've moved into a Sales Analyst type of role rather than a more traditional Financial Manager/Controller Role and data analytics (mostly on Excel but also through a tool called Qlikview) have become part of my daily work. It's a really exciting time to be a CA. The roles we occupy are changing and our opportunities to add value are real and substantial. If I may add one thing, perhaps stating the obvious but, what I have found with analytics is that you only see the true strength of a tool when you need to solve complex problems with it. Learning about analytics is like filling a toolbox - the more tools you have the easier it is to solve more complex problems. Thank you again. Best regards, David Cape Town

[@amandalovestoaudit]

That you David and congratulations on becoming a CA and your role! A great point about this being another tool - and one we need to combine with our understanding of business, critical thinking and problem solving. 😊

[@maricel.gallobernadas5103]

Hi Amanda, I am so thankful for all the videos you shared and continue doing, coz' of that I have a lot of more understanding and that is the reason, I just passed my exam. Thank You so much from the bottom of my heart.

[@amandalovestoaudit]

Woohoo Maricel - congratulations!!!!

[@thomaszohren8812]

7:41 Let that specific sentence just sit in while thinking about 2020

[@Talib_Husain18]

Thank you for the links to these resourceful courses, do put out more content about data analysis for Finance

[@muhammadarham7135]

Dr Amanda you are great! This video cleared many of my concerns. Thank You!

[@tatendamuza6182]

Thank you for sharing your insight. I was looking for something in pertaining to data analytics.

[@vaibhavshekhar9620]

Thank u ma'am.Please keep making such videos.

[@debojyotibanerjee2832]

Can you please upload video on internal audit and it's career prospects in north America ?

[@amandalovestoaudit]

Hi - unfortunately it isn’t an area I know much about (in terms of job prospects in North America)

[@royzoroaster4264]

Super realistik .. 👍

[@biancamacias7476]

I love this! Thank You! My latest passion is data analytics and I'm an accounting major planning to go into auditing..didn't realize these two married together are amazing! Thank you, definitely subscribed to your channel :)

[@amandalovestoaudit]

Accounting IS analytics - we should take advantage of that ☺️

[@priyankabiswas5968]

Thanks a ton Amanda for explaining everything step by step and walking us through all aspects of data analytics .. I am aspiring to pursue a career in Data Analytics and here I saw your video.. you are amazing..👍👌.. I subscribed to your channel..

[@amandalovestoaudit]

You're welcome Priyanka! Analytics and data science jobs are only going to increase as we move forward :)

[@aliasgarattar3688]

I am such a fan of yours Amanda.

[@amandalovestoaudit]

Thanks Ali ☺️

[@PositiveBeta]

Thank you for sharing 😊

[@amandalovestoaudit]

You’re welcome Bhavesh 🙏

[@Nedwin]

U can use Weka too!! It's originated in University of Waikato.

[@amandalovestoaudit]

Ooh thanks for sharing! For anyone who wants to check out Weka - www.cs.waikato.ac.nz/ml/weka/

[@buredtx]

Beautiful. Thank you for information!

[@amandalovestoaudit]

Thanks for watching Ram!

[@cocoshuimu]

Hi Amanda, very great video and lots of tools to know. I just completed my CPA Australia Program. It is currently promoting Micro-credentials, one of the subjects is data analytics. Do you reckon that I should study the course for the Micro-credentials provided from CPA or just check the free resources kindly provided from your video? Thank you so much.

[@amandalovestoaudit]

Hi - the new micro credentials from CPA Australia look fantastic - and if you have access to do them (I believe there are some discounts right now too - perhaps ask them) - they are excellent :)

[@cocoshuimu]

@@amandalovestoaudit Really? Wow yes, they are half discount but I just found out Power BI doesn't work on Macbook :/. Thank you so much for your response. Have a great day.

[@jadorecakes5268]

Fantastic, thanks so much for sharing. This has helped me a lot

[@amandalovestoaudit]

Thanks for watching :)

[@surajzope9454]

Hello Ma'am, I have just started my course in Data Analytics and I am CA final student. Since Data analytics and Data Science course has 75% same content. I want to know which certification is beneficial for me ? Thanks in advance. You are a great teacher.

[@amandalovestoaudit]

Hi Suraj I’d go with Data Analytics over Science right now ☺️

[@surajzope9454]

@@amandalovestoaudit Thank you so much Ma'am.

[@rohitsilwal]

@@surajzope9454 i am also a ca finalist(icai)..can u plz tell me where did you take the course of data analyst..

[@surajzope9454]

@@rohitsilwal I am taking the IBM certified Data Analytics course provided by simplilearn.com on EMI basis

[@charu332]

@suraj Hi...i have recently completed my CA but I don't want to do regular statutory audit. Can you guide me what are the career opportunities of CA + data analytics

[@tejasbpb4118]

Your video is really amazing. I would like to know about ,from which institution you have cleared your charted accountancy .

[@talha207]

Hi Amanda, thanks for the video. Since you love doing audit, can you shed some light how data analytics can be used in external audit?

[@lennymoremadziwabende4840]

Thank you for sharing important information. Ma'am do you also have accounting videos.

[@amandalovestoaudit]

Hi Lennymore - not a lot - the videos I do have are in this playlist kzbin.info/aero/PLpJRVR3iB5Z5QzebOfEVKzWH2bQVul6Hn

[@folasadeoyewole1564]

Thank you Amanda.

[@amandalovestoaudit]

Thank you for watching! 🙏

[@MrUmair555]

Amanda, nice video on DA.

[@darrendias8863]

Hi Coursera is offering free courses for certain institutions until feb28 2021 due to covid 19 Check with Ur institution if Ur uni is eligible for this. Hence, see if there is any programming language U are interested in.

[@amandalovestoaudit]

Thanks for sharing this great advice Darren!

[@sonalpunchihewa9273]

Should I study data science or data analytics? Im planning on shifting from my audit career to somewhere like data analytics or data scientist. but idk which to choose?

[@amandalovestoaudit]

Depends on how technical you want to get - if you love to code and go in depth - I'd say data science over data analytics 😊

[@sonalpunchihewa9273]

@@amandalovestoaudit guess I’ll go with data science then :) thanks for the response really appreciate it, also may i ask, do I need to do a separate course or something on maths since it has some elements of maths in it? P.S I’m close to conpleting my CPA exams so I have a background knowledge on all of the accounting related stuff except for deeper mathematics stuff

[@Gocool321]

@@sonalpunchihewa9273 hey, I am in same situation right now, can you suggest me if I have to choose data analytics or Data science I have 5 years of experience in audit field! I am an undergraduate!

[@mallamokshda4127]

Thanks a lot, mam😄

[@amandalovestoaudit]

You’re welcome Malla!

[@darwin6984]

can you recommend me any university doctor program good to study for audit and data analytics? i have both masters in these areas, thanks

[@monikasingh2220]

Thanks for uploading this video ....but i am just confused between Business Analytics or Data Analytics to upgrade my skills..i am already having 7 yrs of exp in accounts & MIS reporting...pls give your valuable advise

[@amandalovestoaudit]

Hi Monika - I follow this distinction from Northeastern university in the USA www.northeastern.edu/graduate/blog/data-analyst-vs-business-analyst/ I think as an accountant, business analytics is the more natural fit ☺️

[@adwaidhrajeev5133]

madam,what is the difference between management accountant and data scientist?

[@paulusamuthenu6984]

Hi Amanda, you've been in the CA industry for quite some time... other then data analytics, which other skills and courses have u seen being taken or feel serve some value in improving ones skills and and helping to branch out beyond audit and tax? Could you perhaps create a video on what you've seen CAs do beyond audit?😊

[@amandalovestoaudit]

I've seen a lot of accountants develop skills in Design Thinking and User Experience (UX) recently and move more into consulting roles. It is a great idea for a video :)

[@paulusamuthenu6984]

@@amandalovestoaudit I'm guessing it's because of how so many business activities are being computerized... will read a lil more on this. It would, was looking through your content beyond audit where u interviewed a lady in Marketing and It she was inspiring in that I'd not have thought an accountant would go for it, so yes would be great to have more of those together with the auditing content where time permits of course.

[@amandalovestoaudit]

The key is finding something that interests you - studying something just because their are jobs is less than optimal (but something we have to consider - you might love carving statues but there aren’t many jobs in that!)

[@paulusamuthenu6984]

@@amandalovestoaudit yes that's true but if anything I feel the CA/CPA offers one an option with regards to which discipline one would prefer... as in one may enjoy auditing but not so much of say Finance

[@mostafaessawy457]

Thank you Amanda for all amazing videos ... but i don't have any experience to know which better data analytics tool to learn Can you please advice me ?

[@amandalovestoaudit]

Hi Mostafa - I would start with Excel ☺️

[@mostafaessawy457]

@@amandalovestoaudit i am perfect on excel already

[@feyo.7220]

Hello Amanda. I'm considering going for my Master's next year and I'm looking at 3 courses; Digital Innovation, International Accounting and Analytics and Mngt Information & Managerial Accounting Systems. I have a BSc in Accounting already, and I want to combine Accounting with Tech, hence the reason I'm considering those courses. I'll really like to know what you think about my choice, and get some professional advice as well. Thank you.

[@amandalovestoaudit]

Hi Felicity! Great to see you here - I've replied to your Instagram message :)

[@JB-zh7yx]

Thank you for posting this! I have an English degree from Spelman College and wanting to definitely get into something more analytical...I am utilizing LinkedIn Learning until I can start pursuing community college certificates in the US for accounting and take the CPA exams. My question I have for you is: if I do not have any experience in accounting, can gaining LinkedIn Learning certificates in Excel and Accounting help me in land an entry level role in the accounting field, and will learning data analytics help bolster my resume? Thank you for the advice in the video also; so excited there's virtual opportunities like this.

[@amandalovestoaudit]

Hi Jamy - welcome and a great question. Figures from the US recently stated firms were hiring 30% less than per-COVID - the job market is really competitive right now! However, if you’re new to the field - a great idea is to try and do Community College courses in Accounting and Data Analytics - with the potential to transfer to a 4 year college afterwards. You might be lucky to get an entry level job with a community college courses - but I don’t think with just the LinkedIn Learning courses in the current environment.

[@JB-zh7yx]

​@@amandalovestoaudit Thank you for your response! That community college idea is cost effective and doable! :) I'm glad I reached out to you instead of just going forward not knowing the market. I do feel that it is very competitive anywhere right now, and to break into a new career field without any prior experience is an uphill battle with Donkey Kong being COVID at the top of that hill! I thought about starting a Master's program for non-accounting majors this year, but as good as that sounds, I'm cautious about it because of the loans I'd have to take out, especially since I haven't gotten into any accounting classes before. But I am hopeful that I'm moving in the right direction. I also sincerely appreciate you for your advice. It gives me greater perspective on my next steps for a potential career and educational pivot. One step at a time... :)

[@amandalovestoaudit]

@@JB-zh7yx of course - feel free to also PM me via my Facebook page 😊 Taking a huge college loan right now is a big risk - I'd think about waiting until after November as well - depending on who wins the US election could very well impact loans and funding for university/college degrees.

[@innamcmullen5891]

I am on my final year at university economic course. Its an expansive field, which allows to engage in various types of economic related activity. I was going to specialize in accounting, but then I became interested in data analysis. Still cannot to figure out which one to pick. Is it possible to combine an accounting with data analysis in some way?

[@shubhrangshuchakraborty2004]

Ma'am I am a Cost and Management Accountant(CMA) Finalist . Please tell me from where I can start and learn Data Analytics course from scratch .

[@kuldeepagrawal4198]

Which is the best institute for learning Data Analytics course?

[@amandalovestoaudit]

It depends on what country you are in. In Australia - one of the best courses is the Master of Data Science and Innovation at UTS.

[@kuldeepagrawal4198]

I want to learn data analytics in India. Data science would be more of engineering part.

[@ihabrizkallah5048]

Thank you so much

[@amandalovestoaudit]

You’re welcome 😊 thanks for watching!

[@maheenahmed1625]

I complete my graduation and wanted to pursue ACCA. Should I go for data analytics certification course or ACCA and then this course. Please suggest.

[@AbdulBari-zp2ts]

Hi Ma'am, your video was inspirational, I am an ACCA with 5+ years industry related finance experience, I am planning for Masters and wanted for your opinion about whether I should do MS-CIS or MBA (fin. and Marketing)? Please guide, I do not anything about IT or computers, just basic Excel that accountants normally use.

[@amandalovestoaudit]

Hi Abdul - it depends on what you are interested in - if it is IT, then the CIS is a good path. If you’re wanting to go into the business side - then a program that supports your interests is the way to go. I can’t tell you what your career goals are - and don’t pick a degree based on what jobs other people say are popular - you’ve got to be interested in it!

[@Talib_Husain18]

In the PWC course, how can I audit the course?, I'm unable to access it without paying first

[@amandalovestoaudit]

Unfortunately the PwC one isn’t free. The KPMG Inside Sherpa program is ☺️

[@MJ-ed9sl]

Great video I have been off work due to medical, returning to school and workforce after first of the year. I have undergrad degree in Business Administration. I am taking a refresher courses on excel. I am interested in accounting and analytics. Should I pursue masters degree in Strategic Leadership Business Analytics or Masters in Accounting-which includes Accounting Analytics courses in masters program? I thought possibly Human Resources with Business Analytics certification. Thank you for any advice.

[@maryamabdullahibalarabe7585]

Hello Amanda, All your videos I've watched so far have been really expository. I have bsc. Statistics, and I currently work in a mid size audit firm, pursuing a professional certificate in accountancy. However, I'm planning on doing my masters, kindly give a professional advice on best choice of course to do. Thank you

[@amandalovestoaudit]

The best course is going to be the one that helps your career aspirations. It can be very country specific too - so perhaps speak with the accounting professional body in your country.

[@Joeybadass1738]

Hey Amanda :) , hope you are well.What is your take on SQL and Python languages for Accountants?

[@amandalovestoaudit]

I used SQL a lot and I think Python is a good language for the future - especially for those who want to do more data analytics work, or analytics work to support audit. But like learning any new language - it is going to be tough!

[@andifiduccia8398]

Amanda, I can't help it that I say "big day-ta" :'( Anyway love ya thanks for the help!

[@dragoonpoweranmolsukh5713]

can u tell what will be the minimum package for people having ACCA qualification and data analytics with no experiance i.e. just graduated

[@amandalovestoaudit]

Excel knowledge is essential!

[@dragoonpoweranmolsukh5713]

@@amandalovestoaudit i asked about package

[@amandalovestoaudit]

Most firms will not have any expectations that you have experience in a specific software package besides Microsoft Office products such as Word, Excel etc. If you graduate from a Data Analytics program - then they would expect something like PowerBI, Tableau, knowing how to code Python,

[@dragoonpoweranmolsukh5713]

I mean to say I m graduated from charted accountancy program so having a certification in data analysis will increase my chances of having higher salary Although I don't have any work experience

[@Jeebus0143]

Great timing. I'm almost done my CPA and considering if I should study the CFA or get some certification in data analytics.

[@amandalovestoaudit]

Hi AL - I guess it depends on where you want your career to go - even in the area of finance where analyzing large data sets for patterns on which trading strategies can be built is a form of data analytics.

[@Jeebus0143]

@@amandalovestoaudit I am not sure where I want to go because there are so many options but I do know I don't think financial reporting is for me. I find it a bit too technical for me and I don't have a passion for it.

[@kabishaaloganadhan6736]

@@Jeebus0143 hi did u find any course?

[@andiniekaristi8385]

Your explanation makes me more understand why we (accounting students) should learn about data analysis because it is quite not relate to accounting directly. Thank you, Ma'am 🌺

[@amandalovestoaudit]

You’re welcome Arland!

[@mounirkebir868]

I thought you are 24 years old until you talked about the IDEA tool!!!!

[@amandalovestoaudit]

Lol - almost double that age! IDEA is a fantastic tool

[@mounirkebir868]

@@amandalovestoaudit Thank you for all

[@kusumaasmadi4799]

Thanks

[@amandalovestoaudit]

You're welcome :)

[@vivekashok5425]

Thanks a lot for sharing this ma'am. I recently passed my CPA exams and I am considering to pursue further education in Data Analytics. Do i need to learn the basics of coding. I am sorry if this is not a relevant question.

[@amandalovestoaudit]

Hi Vivek - congratulations on passing your exams! Most analytics courses don’t require programming knowledge as a pre-requisite. If you’re going into Data Science as opposed to Data Analytics - then yes - programming is essential ☺️

[@garvitnagpal4893]

hi amanda your video was very helpful. I'm a CA finalist and have learnt python mysql tableau machine learning but not able to get any internship that is a combination of accounts/audit/tax and data analytics/machine learning domain Can you suggest same Thanks in advance

[@amandalovestoaudit]

Hi Gavrit - perhaps it is how your CV/resume or LinkedIn is put together? Does your university offer careers advice? Have you been networking with other CAs? I’m not sure what recruiters are looking for in your country - but in Australia it is partly academics, but also showing involvement with extra curricular activities.

[@garvitnagpal4893]

@@amandalovestoaudit thanks for your reply, Actually the programming part I've learnt myself and accounting/auditing/taxation was what I cleared the exam provided by institute of chartered accountants. Right now due to covid pandemic the articleship opportunities have reduced but I was looking for something wherein I can apply my my data analytics skills in my domain

[@amandalovestoaudit]

It is tough to get a job anywhere right now 😢. The advice I have for everyone is persistence - keep improving, learning, growing your network and applying for jobs

[@garvitnagpal4893]

@@amandalovestoaudit Thanks for your reply

[@EquidusRamalo-ny4wl]

DataR analytics

[@s4sumeetmishra]

Do you think #amanda, there is scope of incorporation in ASA 315 or ASA 330 for data analytics for Assessment and responses to assessed risk .

[@amandalovestoaudit]

Hi Sumeet - absolutely! We’ve always used basic data analytics like Ratio Analysis in helping us identify risks - but we could certainly do more. In response to risks - this might mean that DA allows us to test an entire population easily to identify misstatements, or search the population for exceptions more easily - then we can manually investigate.

[@randomwalker1988]

Is she saying "dataR"?

[@marialuisalichia94]

following

[@dineshsiva2491]

Love your videos but I regret doing accounting and I highly recommend international students in Australia not to do accounting. Almost no one will hire you. I'm in my final year, HD average and I'm not even able to secure an internship even though I'm ready to work for free. The biggest regret of my life is ACCOUNTING degree in Australia :(

[@amandalovestoaudit]

Hi Dinesh - I'm sorry to hear you're having a hard time - it is extremely difficult for international students to get that first job. Have you connected with CA and CPA's mentoring programs? Please feel free to email me or message me on LinkedIn and I'd be happy to try and help you make some connections.

[@dineshsiva2491]

@@amandalovestoaudit That's really kind of you, I have sent a request on LinkedIn :)