Daily Sales Report - Data Extraction from multiple PDF files

No video

Daily Sales Report - Data Extraction from multiple PDF files

Рет қаралды 39,684

Күн бұрын

#PowerBIDashboard #PDFdataExtraction
Hello Friends,
In this video, you will learn how to create Daily Sales Report (DSR) in Microsoft Power BI. We have extracted and consolidated the data from multiple PDF files using Power Query. After applying the data proper transformation, we have create this visual Report.
Download the practice files from below given link:
www.pk-anexcel...
Download the Free Project Management Dashboard
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/...

Пікірлер: 42

@seema_shahabkhan 2 жыл бұрын

Good one, explained nicely, please create more videos on creating dashboards with multiple tables , focused on modeling part (creating fact and dimension tables)

@rochellerobinson939 3 жыл бұрын

Excellent course, always learning something new from you!

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@chrisfotoglidis437 3 жыл бұрын

Congratulations PK. Excellent tutorial with many concepts!!

@PKAnExcelExpert 3 жыл бұрын

Glad it was helpful!

@shashikumarsingh9620 2 жыл бұрын

Thanks

@PKAnExcelExpert 2 жыл бұрын

Most welcome

@patricktano8053 3 жыл бұрын

Merci pour ce travail. Formidable!!!!!!

@SyedMuzammilMahasanShahi 3 жыл бұрын

Very good video. Thanks for the share.

@santoshkiran5858 3 жыл бұрын

Simply brilliant 👍👍👍

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@hariradhu 3 жыл бұрын

Super awesome and excellent 👏👌

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@thanhbinhnguy1303 3 жыл бұрын

Great video. Thanks for sharing.

@PKAnExcelExpert 3 жыл бұрын

Thanks for watching!

@pradeepp476 3 жыл бұрын

Excellent. Big Fan.

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@rameshkandi 3 жыл бұрын

Too good explanation 👍👍

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@sachinbagul4476 3 жыл бұрын

Sir can you please make this type formate for Daily Production Plan vs actual in different machines and products.

@argokusumandani9773 3 жыл бұрын

Thank you sir.

@PKAnExcelExpert 3 жыл бұрын

Thanks for watching

@alexrosen8762 3 жыл бұрын

Wow! Extremely useful. Thanks :-)

@PKAnExcelExpert 3 жыл бұрын

Thanks for your valuable feedback

@shrikantthakur7127 3 жыл бұрын

Sir Excellent Can you Please make this type of Format for Avg. sale Last 3 Month and 6 Month

@anbaabdellah8022 3 жыл бұрын

Merci

@PKAnExcelExpert 3 жыл бұрын

Thanks for watching

@mayurpatel7418 2 жыл бұрын

Have you made Retailer system in excel like sales invoice, add product, add customer, profit report, all receivable, payable etc ?

@hamidshafiullah3287 3 жыл бұрын

Hello I love this dashboard however for all my measurements I am getting blank on the cards can you please help me out with why this is happening

@issac557 Жыл бұрын

How to download the data.. can't find it

@user-tb2bx3dm3q 3 жыл бұрын

Is there any simple way to make box plots using Excel .

@karikoga320 3 жыл бұрын

What happens if the Max(Date[Date] does not have a sale, this will produce a Blank, how do you adjust this to reflect the last date with sales?

@shivsingh4203 Жыл бұрын

Same day last week not working

@minalgupta189 3 жыл бұрын

Hi Why below function is not working properly giving blank result Same day in last week = CALCULATE(SUM(DSR[Sales Amount]),FILTER(calender,calender[Date] = MAX(calender[Date])-7)) please clarify it

@abhijeetrathod1893 3 жыл бұрын

sir best bank accounting software banakar do n

@bhavneshparikh8283 3 жыл бұрын

How can download this excel file?

@minalgupta189 3 жыл бұрын

Hi MTD _Sales = CALCULATE(SUM(DSR[Sales Amount]),DATESMTD(calender[Date])) why this function is not giving same result as yours? answer giving $15.91K even though for :DSR table this function is working MTD Sales = CALCULATE(SUM(DSR[Sales Amount]),DATESMTD(DSR[Date])) ans giving $305.81K please help to understand.Thanks