Lecture 2: Importing data to Power BI

Data files download link:
www.dropbox.co...
Course link: bit.ly/3HLXSGm
Accountants and Finance professionals have to prepare and analyze financial statements and finance data almost every single day. But, modern data analysis require sophisticated computer programs to handle large volumes of data and to unlock the hidden information in this data.
This video series is to help you learn to use the most powerful data analysis and business intelligence program, Power BI, prepare financial statements and perform analytics to unlock the hidden patterns in the data.
What is Power BI:
Power BI is the world number 1 Business Intelligence tool. If you need to analyze data, Power BI will be the easiest, most comprehensive, and most recognized software program. And, it has a free version!
Topics Covered:
Introduction to Power BI
Preparing basic analytics and visualizations in Power BI
Preparing Profit & Loss Statement
Full course on Udemy also covers the following:
Preparing Balance Sheet
Preparing Cash Flow Statement
Preparing Statement of Changes in Equity
Calculating key Financial Ratios
Preparing Financial Dashboards
Course link: bit.ly/3HLXSGm
#Profit&Loss #BalanceSheet #FinancialReporting #FinancialAnalysis
#PowerBI #DAX #Accounting #Bookkeeping #FinancialStatements #IFRS #IncomeStatement
#ProfitandLossStatement

[@bhupeshsharma9872]

It seems that the data files are not available now. Throwing error while clicking on the link.

[@snehayadavbpylbpbkdi1758]

yaaa same with me

[@NourMohamed-mx9bg]

Managed financial operations, including budgeting and statement preparation. Maintained records, handled accounts, and conducted audits. Supported operational efficiency, customer service, and team coordination. Contributed to cost reduction and improved financial accuracy.

[@deyscube577]

I want to talk to you dada, your mail id?

[@deyscube577]

Your email id dada, I want to talk to you.

[@machindrabudhwant9951]

Hi.. Nice Explanation.. Could you please upload the final dashboard to see how it looks like? also there is "EntryNo." Column is missing from Table_GL in the dataset which you provided so if possible could you please add into it it will be helpful. Thanks.

[@syedtahirbukhari8377]

Good watching from Kashmir make dax

[@SushilKrishnan-ge4tp]

Thank you so much for the videos! I noticed the dropbox link isn't working. Could you double check that pls?

[@rashikakochar1713]

hello , The jncomplete data is available in the download site ,it's appearing only 7 instead of 12

[@uttammondal-m4s]

Unable to download data sheet.

[@IinIndiana-u3x]

Thank you very much sir. 😊

[@davidvilca4271]

how to download data, please.

[@MOHAMMADSHAKIB-d8d]

@irfan, I just wanted to quickly understand the major differences between KZbin tutorials and Udemy courses.

[@itaai]

@@MOHAMMADSHAKIB-d8d we share the first 25% of the course on KZbin. Udemy courses have this 25% plus remaining 75%.

[@Prasadiary]

In the data there is no EntryNo column.. 😕

[@tienngoduy8421]

Thank you

[@snehayadavbpylbpbkdi1758]

Can someone help me with dataset. I'm unable to download.It's throwing the error

[@itaai]

Please use link link: www.dropbox.com/scl/fi/kc5vrciytz3ergrqtlz6c/Sample-Business-Data.xlsx?rlkey=dy25n1pvqf6ppiuhpmhpkfq9f&st=wt6pf7en&dl=0

[@berylterryl8948]

@ITAA The file is unavailable

[@jeniferrwatson562]

Hello ITAAI i am unable to download the dataset it show each and every time error if possible plz share it on google drive that may work or mail the all relevant dataset so i further proceed with your videos it will be really helpful for me.

[@itaai]

Please use this link: www.dropbox.com/scl/fi/kc5vrciytz3ergrqtlz6c/Sample-Business-Data.xlsx?rlkey=dy25n1pvqf6ppiuhpmhpkfq9f&dl=0

[@mostafatawfeik534]

@@itaai Thank you

[@shruthihn2604]

Dowload file is not availeble

[@itaai]

Please use link link: www.dropbox.com/scl/fi/kc5vrciytz3ergrqtlz6c/Sample-Business-Data.xlsx?rlkey=dy25n1pvqf6ppiuhpmhpkfq9f&st=wt6pf7en&dl=0

[@Anshika_rajput_333]

how to download data

[@itaai]

Please download here: www.dropbox.com/scl/fi/kc5vrciytz3ergrqtlz6c/Sample-Business-Data.xlsx?rlkey=dy25n1pvqf6ppiuhpmhpkfq9f&st=xsooi0e3&dl=0

[@Kiranmai30]

Helpfull

[@itaai]

Glad it helped

[@thatshettigargirl]

The file is unavailable

[@itaai]

Please use this link to download the file: www.dropbox.com/scl/fi/kc5vrciytz3ergrqtlz6c/Sample-Business-Data.xlsx?rlkey=dy25n1pvqf6ppiuhpmhpkfq9f&e=1&st=agwa7qug&dl=0

[@a2sirrealinspiration776]

Mast

[@arifmohiuddin1618]

Unable to download data sheet

[@itaai]

Hi, I just double checked, the file is available at this link for downloading. www.dropbox.com/scl/fi/kc5vrciytz3ergrqtlz6c/Data-student-file.xlsx?dl=0&rlkey=nti14p5gkv21gstxes004g74y f you are still facing the problem, please share your email address so that I can email it to you.

[@TIM-PK]

@@itaai i did get the file ,but it seems to be a different chart of accounts and there i only one file , kindly upload the GL , Territory file and updated COA

[@itaai]

Its all in the same Excel file, on different worksheets. @@TIM-PK

[@TIM-PK]

Thanks brother . Great work done BTW

[@audreywang4318]

@@itaai I have difficulties downloading the file. Can you give me your email so I can shoot you my email address? Thank you!