Power BI Desktop & Service | DAX | SQL Server | MS Access | VBA
CONSULTING & DEVELOPMENT

The types of Power BI and Microsoft Access projects that I encounter are either 

• New projects or 
• Existing Projects to fix, modernize, upgrade, upsize, convert, or migrate.

If your broken Power BI or Microsoft Access projects have no documentation — No problem. As long as I can get into a project or get the objects out of them, then I can handle it from there.

Microsoft Power BI Development | DAX

• ETL extract, transform, load external & legacy data. Star/Snowflake Relational Data Modeling Schemas
• STYLING: Conditional formatting, bringing into focus what is important while balancing information with white space. Slicer menus that toggle in visibility, conserving screen space
• DAX: Custom Data Analysis Expression measures. Linear regression trend identification/quantification. Moving averages, time intelligence functions, KPI reporting, Segmenting and grouping data
• Descriptive, diagnostic, and predictive analytics. “ What if” scenarios and forecasts

Microsoft Power BI Cloud Service

• Publish reports to workspaces
• Create dashboards with linked visualizations and cascading filters
• Extract iframe code for inline web page embedding
• Manage permissions & refresh schedules. 

•  Implement row level security

Existing Microsoft Access Database Applications

• Help with all versions of Access (97, 2000, 2003, 2007, 2010, 2013, 2016, 2019)
• Repair
• Upgrade
• Modernize
• Design Analysis – build onto, start over, or upsize to SQL Server

Upsize to SQL Server

• Migrate your Access database to AWS, Azure, or your network
• Stored Procedures
• Views
• Security

New Microsoft Access Database Applications

Let me help you develop your ideas and improve your processes with a professional production grade Microsoft Access application.

• Business Analysis
• Requirements Gathering and Documentation
• Microsoft Access Development and Programming
• Testing
• Deployment
• Ongoing Changes and Support

Application Features

• Split Database Architecture
• Relational Database Structural Design and Implementation
• Efficient, Fast Queries
• Security
• ODBC /ADO Connection to External Data Sources
• Dynamic Run Time Pass Through Queries
• Automatic Updates via Cloud/Server Download
• Hidden Database Object Navigation Pane
• Custom Ribbons
• Custom Menus (Access 2003)
• VBA Visual Basic for Applications/Recordset Iterations
• Modules & Macros