Modular Scalable Power BI, DAX, SQL, & M365 Solutions

We create automated integrated business solutions using Power BI, DAX, ODBC connections, Power Query, SQL, DAO, ADO, MS Access, and VBA Visual Basic for Applications

Access Database
Microsoft MS Access Split Database link to multi users

Common Architectures for
Microsoft Stacks in Multi-User Environments

REQUIREMENTS

Business Analysts Take Them and Programmers Receive Them

In Addition to Developing, I Offer the Optional Dimension of Interacting with Stakeholders

"Along with Microsoft Power BI and MS Access development, I provide the optional service of interacting with stakeholders to uncover their true requirements and show them what is available.

Eliciting requirements with probing questions while providing options to stakeholders speeds up development. It also lays the foundation for a greater overall level of satisfaction."

Insights via Custom DAX Measures in Power BI Visualizations
vs.
Dormant Enterprise Data

CREATE SOMETHING FROM NOTHING.

Vault Dormant Enterprise Data to New Heights

Start Vaulting Today

Vaulting dormant enterprise data is when I apply Creativity + Power  BI or Microsoft Access development to dormant legacy enterprise data.

Microsoft Access Process Improvement

I can link to your dormant enterprise data residing in an Oracle, IBM, or another system such as SQL Server, and develop Power BI or Microsoft Access to “vault” your dormant legacy enterprise data to previously unrealized heights.

For example, dormant legacy enterprise data can be leveraged in a new Microsoft Access process, such as an order update process, to automatically email updates to your customers. The dormant enterprise data gets vaulted to new heights as the new process is automated to run at scheduled times.

MS Access Process Improvement

Your customers receive a service from you and their confidence in your company will expand.

Every opportunity to communicate is an opportunity to strengthen a bond.”

— Skipp Merchant

--------

Standing in the Circle

from the Lean (Toyota) process improvement methodology...

Imagine that you are the top engineer in the nation of Japan and have just been hired by Toyota upon your graduation from the most esteemed of universities. The president of Toyota greets you on your very first day. While you walk together, you are filled with excitement as you wonder what the view will be like from your beautiful new office.

Your destination however is the production shop floor, and the president takes some chalk, draws a circle on the shop floor, and says “stand in this circle and observe”. Then he walks away.

Standing in the circle denotes involvement not separation and is a fact-finding mission  to fully understand a process.

Programming and developing are very different.

Programming has a start and a finish and can be completed from a distance.

Development is a continuous process that starts from the circle, and our experience has been that the most value comes from being on site and working directly with stakeholders.