Inside Insights: Data Modeling & Visualization in SAP Analytics Cloud (SAC) with Hau Ngo

In this next episode of Tech-Driven Business, Mustansir Saifuddin continues the conversation with Hau Ngo of Summerlin Analytics to discuss how to approach data modeling and visualization when using SAP Analytics Cloud (SAC). Hau first joined us for a 6-part series in 2021 to talk about SAC and what it means to enterprises as they move to the cloud. Hau and Mustansir share real-life tips on how to approach this depending on your team and company. Listen in for quick takeaways that you can put in to place today. As the tech industry moves to simpler tools, data modeling plays an even more important role.

Hau is an SAP Analytics Architect and an early adopter of SAP Analytics Cloud. In 2017, he helped a technology company in California consolidate global sales reporting across 7 different ERP systems. This effort culminated in one executive dashboard that displayed real-time information, eliminating weeks of manual coordination and data wrangling. Subsequently, Hau has presented his work at conferences such as SAPPHIRE 2019 in Orlando Florida, and has gone onward to help additional customers streamline their reporting processes and visualize the key company metrics. His experience with SAP Analytics Cloud extends to customers with various systems such as SAP Data Warehouse Cloud, BW/4HANA, and S/4HANA. 

Connect with Us:

LinkedIn:

Hau Ngo

Mustansir Saifuddin

Innovative Solution Partners 

Twitter: @Mmsaifuddin

YouTube

or learn more about our sponsor Innovative Solution Partners to schedule a free consultation.   

Episode Transcript

[00:00:06.010] - Mustansir Saifuddin

Welcome to Tech-Driven Business. Brought to you by Innovative Solution Partners. In this episode, I welcome back Hau Ngo of Summerlin Analytics listen in as he talks about the importance of balancing data modeling with visualization to get the most out of your investment in SAP analytics Cloud or SAC.

[00:00:34.110] - Mustansir Saifuddin

Hello Hau, how are you?

[00:00:37.110] - Hau Ngo

I'm doing well, Mustansir, how are you?

[00:00:39.570] - Mustansir Saifuddin

Hey, doing great, man. Welcome to Tech-Driven Business. Again, today we will talk about the balancing act they call it, especially when you talk about SAC. And you have so many different variables in terms of the data modeling part, the data visualization, and what is the right balance. That's what I want to talk about today.

[00:01:06.070] - Hau Ngo

Oh, sure, yeah. I think it gets a little bit tricky, I think now with this newer tool because you can do so much with it. Before we used to just do everything in either ABAP or BW and you just have like a table dump either in Excel or an LB grid. But now with SAC, you can still do a little bit of data modeling. You can define calculations so the lines are blurred, like where do you do which things? Right? And I think in terms of what I would suggest for a good data model in this new paradigm, I would try to have all your work done on the back end, meaning you would have all your calculations done in either S/4 or BW or Data Warehouse Cloud, and treat SAC as a read-only layer. So SAC as a reporting layer, just read what you've written and leave that. Now of course there's some give and take, some things are easier in SAC, but I think for the most part, make sure everything is done on the source system and you should be off to a good start.

[00:02:13.930] - Mustansir Saifuddin

Interesting. So what seems like a good data model in your example that you just shared? It's almost like do more of the heavy lifting on the bac