TO DAY TWO OF THE BUSINESS APPLICATION
SUMMIT AND THEATER 2. WE'RE GOING
TO BE TALKING ABOUT THE POWER PLATFORM
AND WE'RE GOING TO DO IT AROUND
THE BUBBLE OF A CASH FLOW STATEMENT.
SO GET READY TO SEE SOMETHING FAST
AND FURIOUS. SO WHAT YOU'RE GOING
TO SEE TODAY IS TWO PASSIONATE MVPS,
MR. MARIANO GOMEZ, AND MYSELF BELINDA
ALLEN A DATA PLATFORM MVP AND WE
LOVE THE POWER PLATFORM. WE'RE GOING
TO BE LOOKING AT THE CASH FLOW STATEMENT
INSIDE A POWER BI THAT OPERATE.
SO I CONVINCED MARIANO TO STEP UP
ON IT WITH ME. AND LET'S SEE. MY
LITTLE CLICKER IS NOT WANTING TO
CLICK CLICK. WE'RE ALSO GOING TO
BE DOING IT IN TAKING THIS INFORMATION
AND USING MICROSOFT FLOW, AND POWER
APPS INSIDE OF IT. AND WE'RE GOING
TO DO IT ALL IN POWERPOINT SO WE'RE
NOT DEPENDENT ON THE INTERNET SO
WE CAN GET THROUGH IT TODAY. AND
THE GOOD NEWS FOR YOU IS YOU CAN
GO TO THE SITE AND DOWNLOAD THE
ENTIRE DEMO. DOUGH YOU DON'T HAVE
TO WORRY ABOUT TAKING NOTES. I WANT
TO STEP BACK AND TALK ABOUT THE
CASH FLOW STATEMENT FOR A MINUTE.
THIS IS THE TRADITIONAL FORMAT OF
THE CASH FLOW STATEMENT. I HATE
IT. I'VE BEEN IMPLEMENTING ACCOUNTING
SYSTEMS FOR 28 YEARS. MARIANO IS
PRETTY CLOSE. >> 21. >> AND IT'S
ALWAYS BASICALLY THE SAME FORMAT
AND I THINK IT'S UTTERLY WORTHLESS.
SO I TELL PEOPLE TELL ME WHAT YOU
WANT AND I'LL BUILD IT FOR YOU.
I STOPPED AND SAID WHAT ARE WE TRYING
TO ACHIEVE WITH THE CASH FLOW STATEMENT.
WE WANT TO SEE WHERE THE MONEY IS
COMING FROM. IS IT COMING FROM REVENUE,
IS IT COMING FROM LOANS, IS IT COMING
FROM STOCK SALES, WHERE DO WE SPEND
THE MONEY AND HOW IS OUR CASH FLOW
CHANGING OVER THE COURSE OF A PERIOD
OR YEARS. ARE WE THRIVING OR ARE
WE IMPORT CASH FLOW. THE CASH FLOW
WAS INVENTED IN 1863 BY AN IRON
COMPANY WHO REALIZED HEY, ON THE
BOOKS WE'RE MAKING MONEY, BUT I
DON'T HAVE ANY MONEY TO PAY MY BILLS.
SO ENTER IN BELINDA'S VISION OF
OPERA OPERATIONAL CASH FLOW STATEMENTS.
YOU'LL NEVER GET RID OF THE OTHER
FORMAT, BANKS WANT THAT, BUT FROM
AN OPERATIONAL POINT OF VIEW, THIS
IS WHAT YOU'RE GOING TO SEE. I PUT
THIS IN A SLIDE DECK THIS IS ONE OF MY FAVORITE VISUALS TO USE FOR CASH
FLOW SO YOU CAN GO AND DOWNLOAD
IT. I ALSO PUT IN MY DAX CODE IN
TO GET A DATE TABLE SO YOU CAN GET
ACCESS TO THAT. I STRONGLY ENCOURAGE
IF YOU WANT TO DO ANY KIND OF OPERATIONAL
STUFF IN POWER BI YOU ATTEND A DAC
SESSION. THAT VISUAL I PUT IT INTO
A POWER BI REPORT AND IT'S THE CALENDAR
VISUAL. IN THE BLUE I'VE ADDED IN
THE DATE FIELD, IN THE YELLOW I'VE
ADDED IN SOMETHING CALLED NET DEBIT
AND NET CREDITS. THAT WAY IF I WANT
TO SHOW SALES AND I SHOW NET CREDIT
THE SALES WILL SHOW POSITIVE IF
THEY'RE REALLY POSITIVE. THAT'S
A BELINDA THING. AND I NARROW IT
DOWN TO JUST CASH AND I CAN SEE
ALL MY CASH RIGHT IN THERE AND I
GO THROUGH AND FORMAT IT I LIKE
TO FORMAT THE TEXT TO BE A BIGGER
FONT AND I'LL GO THROUGH AND THERE'S
A LITTLE 14 FONT THERE AND I'LL
GO INTO THE DATA COLORS AND MAKE
THEM DIVERGING AND SET THE COLORS
FOR THE HIGH AND LOW CASH. NOW VISUALLY
I CAN SEE WHAT MY CASH IS DOING.
AND THIS IS THE START OF WHERE POWER
PLATFORM BRINGS SOME VALUE INTO
OUR CASH FLOW STATEMENT. THIS IS
POWERFUL. THIS IS LOOKING IN THE
PAST, NOT LOOKING FORWARD, BUT IT'S
A PRETTY COOL TOOL TO USE. ALL RIGHT.
SO I ALSO PUT A FILTER ON IT. I'M
NOT GOING TO GET MUCH MORE INTO
THE FILTER. THERE WE GO. I PUT IN
THE PERIOD DATE AND VOILA, THERE'S
THE WHOLE STATEMENT. IF YOU WANT
TO LOOK FORWARD, YOU MIGHT WANT
TO ADD YOUR PAYABLES AND YOUR RECEIVABLES.
IF YOU ADD YOUR RECEIVABLES INTO
IT, I WOULD TAKE OFF LIKE 5 FOR
WRITE-OFFS THEN YOU CAN LOOK AT
YOUR CASH GOING FORWARD AS WELL.
THE NEXT ONE I WANT TO SHOW YOU,
HERE'S A DAX COLLIE CREATED THAT
EVALUATES IS THIS THE LAST 30 DAYS
OR NOT AND I PUT IT IN A FILTER
OR YOU COULD DO IT THIS WAY, WHERE
YOU'RE CREATING A DAX MEASURE FOR
EACH DEBIT AND CREDIT AMOUNT. AGAIN
YOU CAN DOWNLOAD THOSE SLIDES AND
GET THAT DAX CODE. I WAS IN BUSINESS
WITH MY HUSBAND FOR 20-PLUS YEARS,
ALMOST 30 YEARS, AND I GOT TIRED
OF HEARING HIM SAY WHERE DOES THE
CASH GO, WHERE DOES THE CASH GO,
WHERE DOES THE CASH GO. SO I BUILT
THIS REPORT LOOKING AT THESE ARE
THE DEBIT TRANSACTIONS IN MY SYSTEM
FOR THE BANK ACCOUNT AND WHO IT
WAS PAID TO AND WHO IT WAS RECEIVED
FROM, AND I DO THE SAME WITH ALL
THE CREDITS. SO HE'S BASICALLY LOOKING
AT GENERAL LEDGER INFORMATION, BUT
HE'S LOOKING AT IT WITH WHO'S PAID,
TO WHO IT'S PAID FROM. THIS ONE
I DID IN THE LAST 30 DAYS AND IN
THIS SAMPLE I JUST DID IT BASED
ON THE TRANSACTION DATE. BUT NORMALLY
I WILL DO THIS BASED ON THE DATE
IT WAS ENTERED IN THE SYSTEM. AND
THEN THAT WAY NOTHING GETS BY. NOBODY
COULD GO AND DATE SOMETHING 31 DAYS
AGO AND IT MISSED THE REPORT. NOW
WE CAN LITERALLY SEE WHERE THE CASH
IS COMING FROM AND WHERE THE CASH
IS GOING. SO I LOVE THIS. THIS IS
ONE OF MY FAVORITE THINGS , MY FAVORITE
REPORTS. ANOTHER DAX MEASURE YOU
COULD DO, THIS IS DONE OFF OF A
QUICK MEASURE, THIS IS WHY YOU NEED
A DATE FIELD SO YOU COULD DO YEAR
TO DATE NUMBERS, HERE IS MY YEAR
TO DATE CREDIT AND I CAN DO THE
SAME FOR DEBIT AND I DID IT OFF
OF NET DEBIT AND NET CREDIT SO I
GET THE BALANCE. AND THIS ONE I
JUST ADD IN A FILTER FOR THE YEAR
AVENUE -- OFF MY TABLE AND THEN
I'M GOING TO COME IN -- KEEP GOING,
BELINDA -- ADD IN JUST A CLUSTERED
BAR CHART. AND IN THIS I'M GOING
TO POPULATE THE MONTH, NAME FROM
MY DATE TABLE, AND THE NET DEBIT
VALUE. AND THEN I'M GOING TO GO
THROUGH AND TELL IT JUST TO LOOK
AT CASH. AS I DO THIS, I'LL DO THE
SAME THING WITH NET DEBIT FOR MY
AR AND THEN I'LL DO THE SAME THING
FOR MY SALES. BUT THIS TIME WITH
NET CREDIT. AND THEN I'LL DO THE
SAME THING FOR AP WITH CREDIT AGAIN.
AND THEN THIS TIME, ASSUMING IT'S
A DISTRIBUTION COMPANY, I'LL GRAB
MY INVENTORY ACCOUNTS OFF THE BALANCE
SHEET AND MY COST OF GOODS SOLD,
AND PUT THOSE TOGETHER. AND THEN
I DO ONE FOR MY NET PROFIT. AND
THIS ONE I DID IT A LITTLE BIT DIFFERENT.
I TOOK MY MAIN SEGMENT AND CALCULATED
WHAT ARE MY NET PROFIT FIELDS. NOW,
THE REASON WHY I DID ALL THIS, YOU
END UP WITH A RORT THAT LOOKS LIKE
THIS. YOU COULD CALL THISEPORT THAT
LOOKS LIKE THIS. YOU COULD CALL THIS
A FINANCIAL STATEMENT OR YOU CAN
CALL IT A TRUE CASH FLOW. IN THIS
PARTICULAR CASE I'M LOOKING AT MY
CASH IN APRIL, I COMPARE IT TO MY
SALES IN APRIL, CASH WENT WAY DOWN,
SALES WENT WAY UP. AR WENT UP A
LITTLE BIT, AP WENT WAY DOWN SO
IT LOOKS LIKE I PAID A LOT OF BILLS
IN AP BUT I DIDN'T BUY A LOT OF
INVENTORY SO I WANT TO GO AND INVESTIGATE
WHAT DID I BUY IN APRIL OR WHAT
DID I PAY IN APRIL. SO IT'S A GREAT
WAY TO GET SOME RELATIONAL, JUST
BY VISUALS AND WATCHING THE VISUALS.
AND THIS IS REALLY BENEFICIAL WHEN
YOU DO THE NET DEBITS NET CREDITS
NOW WHEN MY CASH IS GOING UP IT'S
GOING TO THE RIGHT NOT TO THE LEFT.
ALL RIGHT. SO DON'T FORGET THE POWER
OF THE CARD, PUTTING YOUR CASH BALANCE
ON A CARD. THAT'S INCREDIBLY POWERFUL.
I ALSO USE THAT YEAR-TO-DATE DAX
FORMULA I CREATED HERE. I'VE GOT
MY BALANCE FOR EVERY SINGLE MONTH
FOR EVERY SINGLE YEAR AND I'M GOING
TO GO THROUGH AND POPULATE THAT
ON A CLUSTERED COLUMN CHART AS WELL
SO I CAN LOOK AT IT BY YEAR AND
ALSO INCREDIBLE FORM TO USE WHEN
YOU'RE LOOKING AT CASH IS THE WATER
FLOW. SO NOW THAT I'VE GOT ALL THIS
IN AND IT'S LOOKING GOOD -- OH,
I SKIPPED SOMETHING. I CAN GO THROUGH
AND PUBLISH THIS TO THE SERVE IT'S,
THE POWER BI SERVICE. DON'T FORGET
WHEN YOU'RE LOOKING AT CASH YOU
NEED TO EVALUATE, BE ABLE TO DETERMINE
OR DISTINGUISH BEGINNING BALANCES
OR NOT. SO SOMETIMES IF YOU WANT
TO LOOK AT YEAR-TO-DATE NUMBERS
YOU NEED THE BEGINNING BALANCE,
BUT IF YOU WANT TO LOOK AT NET CHANGE
YOU WANT TO BE ABLE TO EXCLUDE THE
BEGINNING BALANCE NUMBER. SO THAT'S
IMPORTANT. SO NOW THAT I'VE GOT
ALL THAT AND I'VE PUBLISHED IT TO
THE WEB, I WANT THE SERVICE TO TELL
ME WHEN MY CASH CHANGES, EITHER
TO A CERTAIN DOLLAR AMOUNT OR DROPS
BY A PERCENT. AND YOU CAN DO NOTIFICATIONS
IN POWER BI OFF CARDS, TILES, AND
GAUGES. ANOTHER REASON TO TAKE ADVANTAGE
OF USING THAT CARD. SO I WENT IN
AND CREATED AN ALERT IN MY POWER
BIS AND LET'S MANAGE THE ALERTS
AND I'M GOING TO ADD A RULE AND
THE RULE IS IF IT GOES BELOW $25,
000 I WANT IT TO NOT ONLY NOTIFY
ME IN A SERVICE BUT SEND ME AN EMAIL.
SO I GET THE NOTIFICATION IN THE
SERVICE THAT LOOKS LIKE THIS, OR
IT COULD SEND ME AN EMAIL. BUT MR.
GOMEZ, I NOTICED WHEN I WAS SETTING
THAT UP, THAT IT SAYS MICROSOFT
FLOW. >> MICROSOFT FLOW, YEAH. >>
WOULD YOU CLICK IT AGAIN? >> ABSOLUTELY.
>> I CLICKED IT AND I GOT THIS.
AND THIS IS FLOW. SO HOW CAN I TAKE
MY NOTIFICATION OF POWER BI AND
EXTEND IT TO THE CFO, THE CONTROLLER
OR SOMEBODY ELSE? >> SO YOU GUYS
ALREADY SAW THE POWER OF THE POWER
PLATFORM JUST FROM A POWER BI STANDPOINT.
WHAT IF I TOLD YOU NOW YOU COULD
EXTEND THIS BEYOND USING MICROSOFT
FLOW AND EVEN POWER APPS? SO LET'S
TAKE IT FROM THERE. SO WITH A NEW
TRIGGER, THE NEW FLOW TRIGGER YOU
CAN NOW SET UP AN ALERT BASED ON
THOSE PARAMETERS THAT YOU SAW, BASED
ON THOSE REPORTS THAT YOU CREATED.
THE NEXT THING WE'RE GOING TO DO
IS WE'RE GOING TO HIT CONTINUE HERE.
WE'RE GOING TO ACTUALLY HAVE THIS
BEAUTIFUL TEMPLATE THAT WE'RE GOING
TO USE FOR SETTING UP OUR ALERT.
AND HERE COMES THE NEW FLOW TEMPLATE.
SO IF YOU GO TO US. FLOW. MICROSOFT.
COM YOU CAN THEN NOW BASICALLY,
WITH THAT TRIGGER, WITH THAT POWER
BI TRIGGER, SET UP A NEW NOTIFICATION
AND A NEW ALERT THAT YOU CAN PROBABLY
SEND OUT TO YOUR FINANCE TEAM BASED
ON SOME CHANGE OR SOME CONDITION
ON THAT REPORT. SO IN THIS CASE
I'VE ACTUALLY TAKEN THE ALERT FROM
THE CHECKBOOK BALANCE THAT BELINDA
JUST CREATED AND I'M GOING TO JUST
GO AHEAD AND SET UP AN ACTION, A
CUSTOM ACTION. IN THIS CASE MY CUSTOM
ACTION WOULD BE BASED ON THE OFFICE
365 OUTLOOK, RIGHT? WE'RE THEN GOING
TO MAKE SURE WE CAN SEND OUT AN
EMAIL TO SOMEBODY. AND THAT PARTICULAR
EMAIL IS GOING TO GO TO OUR FINANCE
TEAM WHEN A CHANGE IN THE CASH FLOW
CONDITION OCCURS. IN THIS PARTICULAR
CASE, WE'RE GOING TO SET UP THE
ALERT ID. WE'RE GOING TO SEND IT
TO BELINDA, ASSUMING SHE'S OUR CFO,
AND WE'RE JUST GOING TO SET UP A
NOTIFICATION THAT SAYS CASH IS LOW.
AS YOU CAN SEE, YOU ALSO HAVE EXPOSED
TO YOU ARE THE DYNAMIC CONTENT THAT
COMES FROM POWER BI. SO YOU WANT
TO TAKE THOSE INTO ACCOUNT IF YOU
WANT TO ADD MORE NOTIFICATIONS TO
YOUR ALERT. SO WE CAN ADD MORE ACTIONS.
THOSE ACTIONS IN THIS CASE I MIGHT
WANT TO SEND A NOTIFICATION OR SO
ON. SO ANYWAYS, BACK TO POWER BI,
I'M GOING TO DO SOMETHING EVEN MORE
INTERESTING. WITH THE ABILITY NOW
TO ACTUALLY PUBLISH THESE REPORTS
AS DASHBOARDS, WHAT I'M GOING TO
DO IS I'M GOING TO GO AHEAD AND
PIN THIS PARTICULAR CASH CHANGE
CALENDAR ON TO A NEW DASHBOARD.
IN THIS CASE, I'M GOING TO SET UP
THIS DASHBOARD, I'M GOING TO CALL
IT CASH CHANGE CALENDAR. AND ONCE
I PIN IT, NOW THAT BECOMES A PART
OF THE DASHBOARD LIST THAT IS THERE.
WHY DO I WANT TO DO THIS? BECAUSE
I'M COOL ENOUGH AND OUR EXECUTIVES
ACTUALLY HAVE A POWER APPS APPLICATION
THAT THEY'VE BEEN USING TO TRACK
CASH POSITIONS IN VARIOUS ACCOUNTS
THAT WE HAVE, ALSO THEY MONITOR
THE TOP FIVE CUSTOMERS THAT WE HAVE
BY SALES AND HAVE A LITTLE DISPLAY
OF CUSTOMERS -- CUSTOMER CONCENTRATION
BY TERRITORY. NOW I'VE BEEN IN CHARGE
WITH BASICALLY MODERNIZING THIS
PARTICULAR APPLICATION TO EM BED
SOME POWER BI COOLNESS INTO IT.
SO WHAT I WANT TO DO IS BASICALLY
FRONT AND CENTER, THEY ASK ME TO
YOU KNOW, CHANGE THE CUSTOMER BY
TERRITORY DISPLAY, AND INCLUDE OUR
CASH FLOW CALENDAR THAT WE JUST
CREATED IN POWER BI. WITH THAT SAID,
I BASICALLY REMOVED THAT PARTICULAR
CONTROL FROM THERE, FROM THE APPLICATION
ITSELF, AND NOW I'M GOING TO USE,
FROM THE LIST OF CONTROLS, I'M GOING
TO GO THROUGH THE POWER BI TILE
AND BASICALLY INSERT THAT PARTICULAR
POWER BI CONTROL INTO MY POWER APPS.
NOW, HERE'S THE COOLNESS. ONCE I'VE
SELECT THAT, THE NEXT THING I'VE
GOT TO DO IS CHOOSE MY WORK SPACE.
SO ASSUMING I PUBLIC TO MY WORK
SPACE, I'M GOING TO SELECT THAT
FROM THE DROP-DOWN, THE DATA CONNECTION
DROP-DOWN, AND THEN I'M GOING TO
ACTUALLY SELECT THE DASHBOARD THAT
IT WAS CREATED FROM. ONCE I SELECT
THE DASHBOARD, NOW I'VE GOT TO SELECT
THE TILE. SO ONCE THE TILE IS SELECTED,
BOOM, THE CASH FLOW CALENDAR NOW
APPEARS ON MY -- >> THIS IS WHERE
YOU GO OOH. >> THIS IS WHERE YOU
GO OOH. BECAUSE THIS SHOWS THE ACTUAL
DEEP INTEGRATION THAT APPEARS ACROSS
THE POWER PLATFORM AS A WHOLE. SO
NOW I CAN'T REALLY LEAVE THAT PARTICULAR
CONTROL THERE, SO WE'RE GOING TO
MOVE IT OUT OF THE WAY, RESIZE IT,
MAKE SURE IT'S NOW AVAILABLE FOR
DISPLAY. AND THAT BASICALLY CONCLUDES
OUR PRESENTATION FOR TODAY. WE WANT
YOU GUYS TO TAKE THIS WITH YOU,
DOWNLOAD OUR SLIDE DECK, DOWNLOAD
THE SAMPLES THAT WE HAVE AND MAKE
SURE THAT YOU PUT THIS TO PRACTICE.
BECAUSE IT'S SUPER COOL FOR YOU.