Lecture 2: Importing data to Power BI
Vložit
- čas přidán 25. 12. 2021
- Data files download link:
www.dropbox.com/scl/fi/kc5vrc...
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
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.
I want to talk to you dada, your mail id?
Your email id dada, I want to talk to you.
hello , The jncomplete data is available in the download site ,it's appearing only 7 instead of 12
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.
Thank you very much sir. 😊
Thank you
Thank you so much for the videos! I noticed the dropbox link isn't working. Could you double check that pls?
In the data there is no EntryNo column.. 😕
@ITAA The file is unavailable
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.
Please use this link:
www.dropbox.com/scl/fi/kc5vrciytz3ergrqtlz6c/Sample-Business-Data.xlsx?rlkey=dy25n1pvqf6ppiuhpmhpkfq9f&dl=0
Helpfull
Glad it helped
Mast
The file is unavailable
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
Unable to download data sheet
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.
@@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
Its all in the same Excel file, on different worksheets. @@TIM-PK
Thanks brother . Great work done BTW
@@itaai I have difficulties downloading the file. Can you give me your email so I can shoot you my email address? Thank you!