Lecture 2: Importing data to Power BI

Рет қаралды 36,117

ITAAI - Accounting - Analytics - Excel - Power BI

2 жыл бұрын

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

Пікірлер: 24

@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.

@rashikakochar1713 6 ай бұрын

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

@machindrabudhwant9951 8 ай бұрын

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.

@user-lh2kc4bo4k 2 ай бұрын

Thank you very much sir. 😊

@SushilKrishnan-ge4tp Ай бұрын

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

@tienngoduy8421 Ай бұрын

Thank you

@berylterryl8948 Ай бұрын

@ITAA The file is unavailable

@Prasadiary 5 ай бұрын

In the data there is no EntryNo column.. 😕

@Kiranmai30 10 ай бұрын

Helpfull

@itaai 10 ай бұрын

Glad it helped

@jeniferrwatson562 3 ай бұрын

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 3 ай бұрын

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

@a2sirrealinspiration776 Жыл бұрын

Mast

@thatshettigargirl Ай бұрын

The file is unavailable

@itaai 27 күн бұрын

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

@arifmohiuddin1618 9 ай бұрын

Unable to download data sheet

@itaai 9 ай бұрын

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 6 ай бұрын

@@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 6 ай бұрын

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

@TIM-PK 6 ай бұрын

Thanks brother . Great work done BTW

@audreywang4318 3 ай бұрын

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