Immo Mohrenschildt-Senior Business Analyst/Specialist Power BI

Support for the introduction of Microsoft Power BI (Premium PPU) and transfer of business intelligence processes and reporting

• Identification, documentation and analysis of existing as well as cross-functional processes (focus on sales, logistics, controlling)
• Identification of optimization potential (goal: replacement of analysis and planning processes, identification and use of relevant data sources and relational databases, Oracle, SQL DB, etc.)
• Transfer of reporting processes from existing structures (Excel, Oracle etc.) to MS Power BI Premium (PPU)
• Coordination/interface between departments (sales, IT, controlling/finance, management) incl. “translation” between the different stakeholders and business units
• Data definition, data modeling & preparation as well as source selection for merging data from differently structured data sources
• Connection of databases via Power BI Gateway/Premium for regular and automatic report updates
• Hands-on development and implementation of analyses, reports and dashboards based on Microsoft Power BI (Power BI Desktop - DAX, MS Power Query - M, Power BI Premium per User - PPU) incl. Row Level Security (RLS concepts)
• Implementation & rollout support for management, sales and finance teams (coaching/training, documentation, development processes)

Development and transfer of business intelligence processes and reporting to Microsoft Power BI. Optimization consulting for sales processes and their management

• Identification, documentation and analysis of existing as well as cross-functional processes (focus on sales, marketing, logistics, controlling) goal: initial replacement of Cognos reports, later support for data-intensive business processes
• Identification of optimization potential (goal: replacement of analysis and planning processes, identification and use of relevant data sources and relational databases, IBM DWH/ODBC, SQL DB, Azure SQL, Snowflake, SharePoint, web applications, REST API etc.)
• FinOps analyses for the use of Power BI Premium resources incl. allocation of resource consumption and cost allocation, cost allocation to individual business units and projects
• ROI/break-even analysis of cloud services used (cost-benefit, showback/chargeback, costs/revenue generation vs. investment/development/operating costs)
• Transfer of reporting processes to MS Power BI Premium
• Governance consulting, planning, documentation and implementation support
• Coordination/interface between business units (marketing, sales, logistics, IT, controlling/finance, HR) incl. “translation” between the different stakeholders and business units
• Data definition, data modeling & preparation as well as source selection for merging data from differently structured data sources
• Connection of databases via Power BI Gateway/Premium for regular and automatic report updates
• Hands-on development and implementation of analyses, reports, forecasting tools and dashboards based on Microsoft Power BI (Power BI Desktop - DAX, MS Power Query - M, Power BI Pro, Power BI Premium) incl. Row Level Security (RLS concepts)
• Power Automate connection of Power BI reports for automated processes
• Power Apps for write-back processes from Power BI Premium to Azure SQL DB
• Analysis and provision of target-group-specific data, KPI and forecast systems, visualizations and recommendations for action
• Implementation & rollout support for management, marketing, sales, logistics and finance teams (coaching/training, documentation, development processes, governance)
• Optimization consulting for controlling, logistics, marketing and sales processes

Interim management for the Marketing & Communication area

• Marketing strategy & market positioning
• Competitor analysis
• Target group analysis
• Operational planning & implementation of marketing measures
• Optimization of marketing measures
• Budget reporting and marketing controlling
• Optimization of marketing and sales processes
• Tool development for better steering of marketing and sales measures (identification of data sources, database connection – CRM/SQL, development of reports & dashboards)

Marketing & Sponsoring Controlling

Management consulting in the areas of

• Data-based marketing controlling (management of budget and resource use, effectiveness and efficiency analysis, process analysis and optimization)
• Development and optimization of marketing and controlling processes incl. reporting
• Consulting on optimization of marketing and sales strategy (positioning and marketing strategy)

Development and conception of a marketing controlling system

• Development and conception of a marketing controlling system to optimize and manage marketing processes and marketing activities
• Definition and identification of value drivers, KPIs, evaluation methods, information sources and information gathering processes
• Analysis and optimization of internal processes
• Hands-on development and implementation of analyses, reporting and dashboards based on Microsoft Excel/VBA
• Analysis and provision of target-group-oriented data, visualizations and recommendations for action
• Support for implementation & rollout in the marketing teams (coaching, training, workshops, documentation, further development processes)
• Planning of the roll-out and implementation steps (step-by-step integration and transfer into a data capture and reporting system)
• Support for implementation & rollout

Marketing strategy process & marketing controlling

• marketing & communications strategy
• marketing controlling
• facilitation of strategy workshops

Consulting company "Mohrenschildt & Partner" with focus on

• Business Intelligence (concept, development, launch and implementation support for BI solutions)
• report & dashboard development based on modern BI systems
• business development & business planning
• marketing & sales strategy, market positioning
• operational marketing and sales management
• marketing and sales controlling
• performance review:
• performance of companies
• efficiency and effectiveness of business units (especially marketing, sales, controlling)
• efficiency and effectiveness of business processes and activities
• interim management