Inc. 5000 Fastest-Growing Company in the US

inc-5000-logo
Power Platform: Not an Afterthought for D365 Planning

A successful Microsoft Dynamics 365 implementation isnโ€™t just about configuring the ERPโ€”itโ€™s about laying the foundation for future innovation. Many organizations and vendors focus solely on getting D365 live, only to run into post go-live roadblocks with analytics or portals due to process and data gaps that werenโ€™t considered during planning. ย  This is why the Power Platform must be factored into the planning of your future-state D365 environment from the start. Itโ€™s not an add-on or an afterthoughtโ€”itโ€™s an integral part of how your organization will extend, optimize, and evolve D365 to maximize long-term impact, both in the near and long term. Future-Proofing Your D365 Environment A proper D365 implementation is designed around business processes, data architecture, reporting, and integration. As Wayne Getsky famously stated, he plays to where the puck will be, not where it is. This means that Power Platform should be included in your roadmap to ensure that the system you go live with can support future-state needs: Planning for enterprise-wide analytics ensures Power BI reporting will be built on a solid data architecture designed to support the demands of AI. Define how your organization wants to communicate and collaborate via portals with customers, vendors, and partners. By designing D365 with Power Platform in mind, you ensure that the D365 ecosystem will meet the needs of the organization day one but also support the demands of future business growth, innovation, and transformation We Plan for the Future, Even When Itโ€™s Hard to See If Power Platform isnโ€™t considered early in the process, companies often run into roadblocks after go-live, realizing that their analytics and automation aspirations require rework, costly customizations, or process redesigns. ย  We donโ€™t need to define detailed requirements upfront, but during our planning process, we ask the right questions to account for future-state needsโ€”even those that may be hard for your team to envision today. By helping leadership think beyond the constraints of their current processes, we guide them in imagining how the company could operate without barriers, leveraging automation, analytics, and seamless system interactions. ย  By integrating Power Platform into your future-state D365 strategy, we eliminate obstacles before they ariseโ€”allowing your business to focus on growth and continuous improvement instead of running into walls after go-live. D365 + Power Platform = A System That Evolves With Your Business D365 is more than just an ERP or CRM systemโ€”itโ€™s a foundation for business transformation. But without Power Platform embedded into your strategy from the start, you risk creating a system that needs workarounds instead of one that enables continuous improvement. ย  At Ascent Innovations, we donโ€™t just implement D365โ€”we design future-ready solutions that ensure your analytics, automation, and process optimization efforts are fully supported from day one. ย  Want to ensure your D365 investment delivers long-term impact? Letโ€™s talk about how Power Platform can help you build a system that scales with your business. About the Author John Bruhnke has 20 years of leadership in management consulting, specializing in ERP and analytics modernization with experience leading 15 modern analytics enterprise roadmaps in manufacturing and CPG. He collaborates with executive and management teams to drive alignment on strategic goals and develop a collective vision for modernization that balances both immediate business needs and long-term strategy.

Top Skills for 2025

Hiring Managers Are Looking for These Skillsโ€”Do You Have Them? After the pandemic, the hiring process has changed substantially. Skills that used to be prioritized in job interviews, such as technical expertise, are no longer the only traits employers seek. ย  Managers today are focused on identifying foundational skills that enable employees to continuously learn, adapt, and grow. These behavioral skills form the backbone of a successful career, allowing professionals to acquire new competencies and evolve with changing business needs. ย  The best way to assess yourself from a skills perspective is to consider the things youโ€™re naturally good at and the tasks that energize you. These two components will help you identify strengths that can propel your career forward. Here are the key skills that hiring managers are looking for in todayโ€™s workplace. Curiosity Do you naturally ask questions, investigate the world around you, and seek to expand your horizons? If so, curiosity is one of your strengths. Curious professionals thrive in new situations because they see them as opportunities to learn, solve problems, and discover more efficient ways of doing things. ย  When interviewing, be ready to share an example of how your curiosity led to a breakthroughโ€”whether that was improving a process, solving a complex problem, or helping your team achieve better results. Learning Agility Are you quick to absorb new information, pivot to different challenges, and apply knowledge across a variety of situations? Learning agility is an invaluable skill, especially in todayโ€™s fast-changing work environment. Employers value candidates who can rapidly acquire and apply new skills without extensive training. ย  Be prepared to share a time when you had to quickly learn something new and how that ability helped you succeed. Growth Mindset A growth mindset is the belief that you can develop your abilities through effort and persistence. People with a growth mindset embrace challenges, viewing them as opportunities rather than obstacles. They are willing to take on unfamiliar projects because they see them as a chance to learn and improve. ย  To demonstrate this skill, highlight a time when you took on a challenging project, faced setbacks, and ultimately succeeded through perseverance. Critical Analysis Strong critical thinkers evaluate situations from multiple angles, consult different perspectives, and make informed decisions based on data and logic. This skill is particularly important in roles that require problem-solving, strategic planning, and risk assessment. ย  Employers want to see that you can break down complex challenges, identify patterns, and make sound decisions. When interviewing, be ready to discuss a time when your ability to analyze information and think critically led to a positive outcome. Collaboration Collaboration is more than just working well with othersโ€”itโ€™s about actively contributing to shared goals, adapting communication styles to different team members, and fostering an environment of trust and productivity. ย  If you thrive in team settings, be sure to highlight how your collaboration skills have helped drive results, whether in-person or in virtual environments. Business-Tech Crossover Skills The clear lines between business and technology are disappearing. Companies no longer operate with distinct technical and business silosโ€”every department relies on technology, and IT professionals must understand business priorities. ย  For technologists, this means developing business acumenโ€”understanding market dynamics, financial performance, and customer needs to align technical solutions with strategic goals. IT professionals who can communicate the value of technology in business terms will be invaluable assets to any organization. ย  For business professionals, this means developing technical acumenโ€”understanding the capabilities of modern technology, from data analytics to automation, to make informed decisions and drive innovation. Leaders who can work closely with IT teams to leverage technology for business success will stand out in the competitive job market. ย  Employers are looking for candidates who can bridge the gap between technology and business. Showcasing your ability to navigate both worlds will set you apart in todayโ€™s workforce. The Skills That Drive Long-Term Success Think of these skills as accelerators that will help you develop and grow throughout your career. Highlighting them to hiring managers demonstrates your ability to evolve, take on leadership roles, and contribute to an organizationโ€™s success. ย  More importantly, these skills will shape your personal and professional development. They help you understand yourself, leverage information effectively, tackle challenges with confidence, and collaborate with others to create meaningful impact. ย  By honing these foundational skills, you position yourself not only for your next job but for a dynamic, resilient, and fulfilling career. About the Author Saadiqa Amatul is a Business Analyst & Microsoft Dynamics Consultant at Ascent Innovations LLC. A graduate of the University of Wisconsinโ€“Madison, she is passionate about leveraging technology to drive business efficiency and innovation. In addition to her work in digital transformation, Saadiqa volunteers her time helping children with neurodevelopmental disorders develop behavioral skills. She is dedicated to continuous learning and helping organizations bridge the gap between technology and business strategy.

Unlock Business Impact Now: How Power Platform Accelerates Agile ROI for AX Users

Many organizations running Microsoft Dynamics AX know they need to modernize, but large-scale ERP upgrades require executive and equity owner buy-inโ€”which often depends on demonstrating clear, measurable business impact first. ย  The good news? You donโ€™t have to wait for a full migration to D365 to start improving performance. By leveraging Microsoft Power Platform, companies can enhance AX, streamline processes, and unlock immediate business impactโ€”creating an Agile ROI cycle that builds momentum for future modernization. Why Power Platform? Immediate Value, Minimal Disruption A full ERP upgrade takes time, planning, and investment. Meanwhile, day-to-day operations continue to struggle with inefficiencies, manual workarounds, and siloed dataโ€”slowing decision-making, profitability, and growth. ย  This is where Power Platform acts as a high-impact bridge to modernization. By integrating Power BI, Power Apps, Power Automate, and Power Pages, organizations can extend AXโ€™s capabilities and improve performanceโ€”without waiting for a complete ERP migration. ย  Instead of an all-or-nothing approach, Power Platform delivers rapid, high-value improvements that drive efficiency, visibility, and executive confidence in long-term modernization. Agile ROI: Small, High-Impact Improvements That Fund Further Modernization Our Agile ROI methodology focuses on delivering measurable business results quickly, creating a self-funding cycle for broader transformation. Phase 1: Identify Bottlenecks That Impact Performance Now Where are manual workarounds slowing execution? What critical reports are unreliable, incomplete, or time-consuming to produce? Which business processes would benefit most from automation? Phase 2: Implement Targeted Power Platform Enhancements to Deliver Immediate ROI Power BI replaces disconnected spreadsheets with real-time dashboards and trusted analytics. Power Automate eliminates manual workflows, ensuring seamless data flow across teams. Power Apps empowers teams to build custom tools that improve execution without IT bottlenecks. Power Pages & Portals enhance external collaboration, enabling self-service for customers and suppliers. Phase 3: Train and Develop Your People While Measuring Business Impact Power Platform not only delivers business valueโ€”it develops your teamโ€™s ability to work and collaborate in new ways. Employees gain a fundamental understanding of how modern processes and data integration solve business challenges, fostering cross-functional collaboration. Through hands-on participation, teams develop an informed perspective on further process improvements, preparing them for a full D365 upgrade with confidence. Phase 4: Build the Case for Broader Modernization Increased operational efficiency, reduced errors, and faster decision-making. Higher employee productivity and reduced IT burden. Real-world proof points that captivate executive and equity owner support for further investmentโ€”turning small wins into momentum for long-term transformation. By using Agile ROI, organizations demonstrate value early and often, ensuring leadership support and financial backing for larger ERP modernization initiatives. Start Generating Business Impact Now Waiting for a full D365 migration means delaying improvements that can drive results today. Power Platform allows you to enhance AX, improve performance, and prove ROIโ€”without disrupting operations. ย  At Ascent Innovations, we help organizations unlock immediate business value with Power Platform while strategically preparing for ERP modernization. Want to turn small improvements into momentum for transformation? Letโ€™s talk about how Power Platform can deliver real impactโ€”right now. About the Author John Bruhnke is Managing Director at Ascent. He has 25 years of management consulting experience focused on system implementation and, for the last 7 years, modern analytics in the manufacturing industry. He collaborates with executive and management teams to drive alignment on strategic goals and develop a collective vision for modernization that balances both immediate business needs and long-term strategy.

Unlocking Business Agility: How the Power Platform Empowers Business Users

Empower Business Teams to Build Custom Apps Back in the mid-80โ€™s, my mom brought an electric drip coffee maker up to our cabin in Minnesota. Before that, my family would use the mid-century kitchen staple: the stovetop percolator. Without getting into the details, making a decent cup of coffee in a percolator is time-consuming and requires monitoring.ย  Even then, the chances of burning the coffee, or making it too weak or too strong are high. An electric drip coffee maker is a huge improvement. Add coffee, add water and turn it on. Done. ย  My grandfather was skeptical, but he decided to try it. Then, one morning, at 5:00, he woke up my mom to say the coffee maker wasnโ€™t working. He forgot to plug it in. However, after a little bit of training he got the hang of it and, wouldnโ€™t you know it, he was a fan. The coffee maker removed several steps from the process, automated the brewing and created consistent results. ย  So why am I sharing this story about coffee makers? For years, we stuck with the same process to make coffee with varying degrees of success. Then, a new product came around to simplify the process and improve consistency. From a business operations perspective, thatโ€™s where Microsoftโ€™s Power Platform steps in. With Power Apps, Power Automate, Power BI, and Power Pages, business users get the power (pun intended) to create custom applications, automate tedious tasks, analyze real-time data, and engage with customersโ€”all with minimal coding. ย  This means teams can solve their own problems faster while IT focuses on keeping systems running smoothly. But letโ€™s not get ahead of ourselves. While these tools put power in business usersโ€™ hands, IT and partners can play a crucial role in getting the first apps into production. The Challenge: Slow, Inefficient Business Processes It starts as a one-off. Some says, โ€œLetโ€™s just put together a quick spreadsheet so we can track the data.โ€ Before you know it, thereโ€™s 7 versions with different initials, numbers and โ€œ-FINALโ€ in the file name. Endless spreadsheets, clunky email approvals, and manual data entry slow everything down. Traditional software development takes too long, and by the time IT gets around to building what you need, your business needs have already changed. ย  Whatโ€™s the fix? Give teams a way to quickly build custom applications, automate workflows, analyze data, and collaborate seamlessly without being stuck in ITโ€™s backlog. The Solution: The Power Platform Microsoftโ€™s Power Platform is a suite of four interconnected tools designed to help organizations digitally transform their operations: Power Apps lets business users create custom applications with little to no coding, integrating seamlessly with tools like Excel, SharePoint, and Dynamics 365. Power Automate takes the grunt work out of daily operations by automating repetitive tasks, ensuring smooth data flow across applications. Power BI delivers powerful business intelligence and analytics, so teams can track KPIs, monitor trends, and make data-driven decisions. Power Pages helps build secure external portals where suppliers, customers, and partners can access business data and services without complex IT intervention. Real-World Use Cases: How Supply Chain Teams Benefits Supplier Coordination & Purchase Order Approvals The Problem: Slow supplier responses and approval delays. The Fix: A Power Apps supplier portal to centralize communication, Power Automate workflows to speed up approvals, and Power BI reports to track supplier performance. The Impact: Faster decision-making, stronger supplier relationships, and fewer bottlenecks. Supplier & Customer Portals for Shipment Coordination The Problem: Disconnected communication between suppliers, customers, and logistics teams leads to shipment delays and confusion. The Fix: A Power Pages supplier and customer portal where stakeholders can track shipments, submit inquiries, and receive automated updates. Power Automate sends real-time alerts, while Power BI provides visibility into shipment performance. The Impact: Fewer delays, smoother coordination, and happier customers. Real-Time Logistics Monitoring The Problem: No clear visibility into shipment status. The Fix: A Power Apps logistics dashboard that pulls real-time shipment data, Power Automate alerts for delays, Power BI analytics for tracking performance, and Power Pages for customer and supplier inquiries. The Impact: Proactive supply chain management reduced operational risks, and better logistics performance. Building Your First Appsโ€”A Little Help Goes a Long Way Getting started with Power Platform doesnโ€™t mean teams need to figure it all out alone. IT and partners can help by: Building Your First Apps โ€“ Partners can collaborate with business teams to design and launch their first apps, solving immediate problems while teaching best practices. Training & Upskilling โ€“ Hands-on, real-world learning is invaluable, but structured training ensures long-term success. Next Steps: Transform Your Business with Power Platform The Power Platform is changing the way companies innovate, collaborate, and operate. By equipping business users with low-code development tools, automation capabilities, advanced analytics, and secure portals, companies can move faster and stay aheadโ€”without waiting on IT to solve every challenge. ย  Ready to put Power Platform to work in your business? Letโ€™s talk about how you can start automating, analyzing, and optimizing today! About the Author Matthew Newcomb is a seasoned and certified Microsoft Dynamics AX and Dynamics 365 Supply Chain Management Functional Consultant, specializing in Advanced Warehousing and Production. His extensive experience in Dynamics 365 planning and implementation projects informs his approach to enhancing Dynamics 365 environments with the Power Platform. By leveraging tools such as Power Apps, Power Automate, and Power BI, Matthew enables businesses to automate processes, build custom applications, and gain deeper insights into their operations, thereby driving efficiency and innovation.

Cross-Functional Workflow: Non-D365 Applications Need to Keep Up with D365

Implementing D365 Finance & Supply Chain is a major step in modernizing business operations, but itโ€™s not the finish lineโ€”itโ€™s just one leg of the race. If your legacy applications arenโ€™t keeping up, youโ€™re dropping the baton every time data moves between systems, undoing the speed and efficiency gains D365 was meant to provide. ย  A well-run ERP is like a relay raceโ€”each team (or system) needs to execute their part smoothly and seamlessly pass the baton to the next. If one runner is faster but the baton keeps getting fumbled, the race isnโ€™t wonโ€”itโ€™s lost in the handoffs. ย  The reality is that many companies implement D365 but fail to modernize the applications that interact with it. The result? Manual workarounds, data silos, integration issues, and inefficiencies that slow everything down. ย  If youโ€™re sensing that processes arenโ€™t flowing the way they should, itโ€™s time to look at whatโ€™s happening in the handoffs. How Legacy Applications Disrupt the Flow Process Gaps and Data Blindspots Create Bottlenecks Aging applications werenโ€™t designed to integrate with cloud-based ERP systems like D365. That means data handoffs are slow, error-prone, or reliant on manual exports and workarounds. ย  Orders get processed in D365 butย donโ€™t sync properlyย to fulfillment systems. Financial reports requireย manual data pullsย instead of real-time updates. Inventory updatesย lag behind, creating discrepancies between sales, purchasing, and warehouse teams. Every dropped handoff forces teams to run faster to make up for lost time, leading to more stress, inefficiency, and operational risk. Technical Debt Slows Down Progress Legacy applications often contain years of patches, custom scripts, and outdated code. They workโ€”until they donโ€™t ย  Performance issues and system crashes slow down operations. Security vulnerabilities create compliance risks. Custom fixes make upgrades expensive and time-consuming. If your IT team spends more time maintaining old systems than improving business processes, itโ€™s a sign the baton isnโ€™t just being droppedโ€”itโ€™s getting tangled in technical debt. User Experience: The Hidden Obstacle to Productivity A slow, outdated interface isnโ€™t just frustratingโ€”it creates real productivity losses. And as your teams adopt D365, the antiquated nature of your legacy systems becomes painfully clear. ย  D365 enables real-time visibility, but outdated systems donโ€™tย โ€“ Users are forced to manually extract and re-enter data, creating delays and errors. D365 is designed for modern workflows, but legacy apps arenโ€™tย โ€“ What once seemed like a small inefficiency now becomes a major bottleneck. D365 empowers mobile and remote teams, but legacy systems donโ€™t โ€“ If users canโ€™t access critical tools from anywhere, they revert to manual workarounds. If teams are avoiding the system or working outside of it, the technology isnโ€™t supporting themโ€”itโ€™s slowing them down. As companies modernize with D365, the gaps between whatโ€™s possible and whatโ€™s holding them back become impossible to ignore. Ensuring a Strong Handoff: Application Integration A successful D365 implementation requires more than just ERPโ€”it requires modern, well-integrated applications that keep the baton moving without friction. Disconnected applications create data silos, leading to inconsistent, outdated, or incomplete information across departments. If finance, sales, and operations arenโ€™t seeing the same numbers in real time, decision-making slows down, errors increase, and inefficiencies multiply. ย  With proper integration, data flows seamlessly across all business functions: Orders from your CRMย automatically update inventory and fulfillment in D365. Financial transactionsย sync instantly, eliminating reconciliation delays. Supplier updates reflect in procurement planning, preventing stockouts. ย  Without integration, each of these steps becomes a manual, error-prone process, forcing teams to waste time chasing down the right information instead of acting on it. If Your ERP is Fast, Your Other Systems Need to Keep Up D365 isnโ€™t an islandโ€”itโ€™s part of a larger digital ecosystem. If your legacy applications canโ€™t keep up, the business wonโ€™t move at the speed it should. Application modernization isnโ€™t about changing everything overnightโ€”itโ€™s about ensuring that the baton is passed smoothly, so your business wins the race instead of making up for lost time. If your D365 implementation isnโ€™t delivering the efficiency you expected, letโ€™s talk. Weโ€™ll help you identify whatโ€™s slowing things down and modernize the systems holding you back. About the Author Abdul Hafiz is a technology leader with 25+ years of experience in optimizing and implementing ERPs to modernize finance and operations. As a Partner at Ascent Innovations, he has led growth and delivery for 14 years. He holds a masterโ€™s degree in computer and information sciences from the University of Illinois and advises executive teams on how to modernize the enterprise to drive profitable growth.

What is Application Modernization?

The Business Case for Modernization Businesses today rely on custom-built applications to support critical operations, but many of these systems were developed years ago and struggle to keep up with modern cloud environments, AI integration, and automation needs. As technology advances, companies face a fundamental choice: modernize or fall behind. Legacy applications often introduce: Complexity and technical debt that increase maintenance costs Aging infrastructure that creates security and performance risks Poor user experience with outdated interfaces and workflows Limited AI and automation capabilities that restrict innovation ย  Ignoring these challenges leads to rising costs, security vulnerabilities, and operational inefficiencies, making it harder for businesses to compete in a digital-first world. Why Modernize Legacy Applications? Many legacy applications, particularly monolithic architectures, present significant challenges: Difficult to update due to tightly coupled systems, making feature enhancements costly High operational costs from ongoing maintenance and resource-intensive infrastructure Scalability limitations requiring entire applications to scale instead of individual components Security risks from outdated software and lack of modern compliance controls Inability to integrate AI, automation, and cloud-native capabilities ย  By modernizing applications, organizations can reduce costs, accelerate development cycles, and create more flexible, scalable systems. How to Approach Application Modernization A successful modernization strategy starts with a clear assessment of the current application landscape. Companies should categorize their applications based on: Business value โ€“ How critical is the application to operations, customer experience, or competitive advantage? Complexity and dependencies โ€“ What systems and integrations rely on this application? Potential ROI โ€“ What measurable benefits will modernization deliver? ย  Applications that are both high-value and easier to modernize are often the best starting point, while complex, deeply integrated systems may require a phased approach. Key Modernization Strategies Different applications require different modernization approaches. The four primary strategies include: Rehosting (Lift & Shift) Moves applications to the cloud with minimal modifications Improves scalability and reduces on-premises infrastructure costs Best for applications that need quick cloud migration with minimal disruption Replatforming (Migration to PaaS) Moves applications to cloud platforms with minor code adjustments Leverages managed services, auto-scaling, and high availability Retains core functionality while improving flexibility Refactoring (Cloud Optimization) Restructures applications to leverage cloud-native architectures Converts monolithic applications into microservices or containerized environments Enhances performance, scalability, and cost efficiency Rewriting (Full Rebuild) Completely redesigns applications using modern frameworks Unlocks AI-driven capabilities, automation, and future-proof technology Ideal for applications needing extensive modernization Key Technologies for Application Modernization Modernizing an application isnโ€™t just about moving it to the cloudโ€”itโ€™s about adopting the right technology stack to enhance performance, scalability, and long-term flexibility. Programming Languages: Java, .NET, Python, JavaScript (React, Angular, Vue), Go, Rust Cloud Platforms: AWS, Azure, Google Cloud, hybrid cloud environments Data & Integration: SQL & NoSQL databases, GraphQL, API-driven architectures Microservices & Containers: Kubernetes, Docker, serverless computing DevOps & Automation: CI/CD pipelines, infrastructure as code, automated testing AI & Automation: Machine learning, NLP, robotic process automation (RPA) ย  Each of these technologies plays a role in making applications more agile, scalable, and intelligent, enabling businesses to innovate faster while reducing IT overhead. Modernization is More Than Just Cloud Migration One common misconception about modernization is that it simply means moving applications to the cloud. While cloud adoption is often part of the process, modernization is about rethinking how applications functionโ€”making them more modular, efficient, and aligned with business objectives. Some organizations take a gradual transformation approach to break apart monolithic applications over time. Others may benefit from API integration strategies, allowing modern applications to interact with legacy systems without requiring immediate replacement. The Business Impact of Modern Applications A well-executed application modernization strategy delivers: Lower costs by optimizing infrastructure and reducing maintenance requirements Greater agility with faster time to market for new features and capabilities Improved security through modern compliance standards and risk management Better user experience with intuitive, high-performance applications Future-ready systems that can easily adopt AI, automation, and next-gen innovations Final Thoughts Application modernization is not just an IT initiativeโ€”itโ€™s a strategic business decision that impacts efficiency, innovation, and long-term growth. By choosing the right modernization strategy, leveraging modern architectures, and focusing on business-driven outcomes, organizations can ensure their applications remain a competitive advantage rather than a technological burden. About the Author Abdul Hafiz is a business and technology strategist with 25+ years of experience in optimizing and implementing ERPs to modernize finance and operations. As a Partner at Ascent Innovations, he has led growth and delivery for 14 years. He holds a masterโ€™s degree in computer and information sciences from the University of Illinois and advises executive teams on how to modernize the enterprise to drive profitable growth.

automate-work-while-on-the-go

In todayโ€™s, matrix management structure of the global workforce especially in newer industries, there is a need to inform and get approval of your absence (eg. vacation) so that your project managers are part of your scheduling decisions. ย  We have used an example here of a Parallel Approval workflow, multiple persons are required to approve items, in this case vacation requests. Each personโ€™s approval is independent of all other approvers. The same logic applies to Payables, Quality Assurance, Project/Service quotations, etc. ย  This flow automates an employee vacation request process that requires approval from all persons (or teams) that the employee supports regularly. Employees use a SharePoint list to request vacation. Vacation approvals are required from the employeeโ€™s direct manager, the Sales team, and the Human Resources team. Each vacation request is routed to each approver for a decision. The flow sends email with status changes and then updates SharePoint with the decisions. ย  Before you create the flow, create aย SharePoint Online list; later, weโ€™ll use this list to request approval for vacations. ย  The SharePoint Online list you create must include the following columns: Make note of the name and URL of the SharePoint Online list. We use these items later to configure theย SharePoint โ€“ When an item is created trigger. Create your flow from the blank template 1. Sign in to Microsoft Flow. 2. Select theย My flowsย tab 3. Select Create from blank 4. Select theย Create from blankย button Add a trigger 1. Enterย SharePoint into the search box. 2. Find, and then select the SharePoint โ€“ When an item is createdย trigger 3. Select the Site Addressย and theย List Nameย for the SharePoint list that your flow monitors for new items Get the manager for the person who created the vacation request 1. Selectย New step,ย and then selectย Add an action 2. Enter get managerย into theย Choose an action search box 3. Find, and then select theย Office 365 Users โ€“ Get manager (V2) action. 4. Insert the Created By Emailย token into theย User (UPN)ย box on theย Get manager card. This action gets the manager for the person who created the vacation request in SharePoint. Name and save your flow 1. Provide a name for your flow, and then select the Save icon to save the work weโ€™ve done so far. Note: Select theย Save icon periodically to save the changes to your flow. Add an approval action for immediate manager 1. Select New step,ย and then selectย Add an action The brief overviews below are real world application of this concept, and we will keep this discussion at a conceptual level to maintain client confidentiality. 2. Enterย approvalย into theย Choose an action search box. 3. Select the Approvals โ€“ Start an approval action. 4. Configure the Start an approval card to suit your needs. Note: Theย Titleย andย Assigned Toย fields are required. You can useย Markdownย to format theย Details field. Insert a parallel branch approval action for the sales team 1. Select the down arrow thatโ€™s located between the Get manager (v2)ย and theย Start an approval cards.2. Select the plus sign that shows up on the down arrow after you select it.3. Selectย Add a parallel branch4. Selectย Add an action. 5 .Search for, select, and then configure a Start an approvalย action that sends the vacation request to the sales team. See theย steps used to Add an approval action for immediate managerย if youโ€™re not sure how to add theย Start an approval action. Note: Use the sales teamโ€™s email address in theย Assigned Toย box of theย Start an approval 2ย action Insert a parallel branch approval action for the human resources team 1. Repeat the steps toย insert a parallel branch for the sales teamย to add, and then configure aย Start an approval action to send vacation requests to human resources. Note: Use the human resources teamโ€™s email address in theย Assigned To boxย of theย Start an approval 3 action. If youโ€™ve followed along, your flow should resemble this: Options after adding parallel branches After youโ€™ve added actions to parallel branches, you have two options for adding more steps to your flow: 1. Use the smallย Insert a new stepย button (the circular plus button that appears when you select any white space on a branch or the area immediately below a branch). This button adds a step to thatย specific branch. Steps you add with this button run after this specific branch completes. 2. Use the largerย New step button at the bottom of the entire workflow. Steps you add with this button run after all branches complete. In the following sections, we use the smallย Insert a new step button to perform these steps on each branch: Add a condition that checks if the vacation request was approved or rejected. Send an email that informs the employee of the decision. Update the vacation request in SharePoint with the approval decision. ย  Then, we use the largerย New step button to send an email that summarizes all decisions made on the vacation request. Continuing… Add a condition to each branch 1. Select any white space on theย Start an approval branch.2. Select the smallย Insert a new step button (the circular plus button that appears after you select the white space in the previous step).3. Selectย Add a condition from the menu that appears.4. Select the first box on theย Conditionย card, and then select theย Responseย token from theย Start an approval category in the dynamic content list. 5. Confirm the list (in the middle of the Condition card) is set toย is equal to.6. Enter Approveย (this text is case-sensitive) into the last box.7. Your condition card should now resemble this example: Note: This condition checks the response from theย Start an approval action that goes to the employeeโ€™s manager. 8. Repeat the preceding steps on theย Start an approval 2ย (the approval request to sales) andย Start an approval 3 (the approval request to human resources) branches. Add email actions to each branch Perform the following steps on theย IF YESย side of theย Conditionย branch. Note: Your flow uses these steps to send an email when the request is approved. 1. Selectย Add an actionย on theย IF YES branch of the condition. 2. Enterย send emailย into the search box on theย Choose an action card. 3. Select theย Office 365 Outlook … Read more

Business Insights for Employee Evaluations or: Why No One Cares What You Think, KAREN!

When people think of Business Insightsโ€”specifically Microsoft Power BIโ€”they typically associate it with financial or sales analysis. And why not? Money makes or breaks a business. But letโ€™s not forget that people drive sales, control costs, and manage customer satisfaction. So, how do you track people? Informally, you get vague, off-the-cuff comments (โ€œKarenโ€™s just not great at her job. Also, I think she may be keeping a cat in her file cabinet.โ€). Formally, you have lengthy peer and self-evaluationsโ€”great for self-reflection, but also a fantastic way to create anxiety as coworkers try to figure out who gave them a bad review (Iโ€™m on to you, Karen). While subjective reviews provide valuable insights, anyone who has managed a team will tell you: numbers add credibility. Thatโ€™s where Power BI steps inโ€”transforming raw data into meaningful, reportable, and actionable insights. From Spreadsheets to Smart Analytics I used to keep massive spreadsheets filled with daily order-entry counts, quotation follow-up reports, and order-expediting calls. Manually updating formulas and charts was a time-consuming headache, especially when sensitive data had to be shared selectively. I also watched others attempt similar tracking methods, only for the system to fall apart once a supervisor became too busy to maintain it. ย  Enter Microsoft Power BI. Instead of manually updating reports and wasting time on formatting, Power BI automates data pulls, updates dashboards in real time, and distributes reports efficiently. Itโ€™s faster, more accurate, and far less frustrating than maintaining endless Excel sheets. Power BI: Connecting the Dots Power BI can pull data from just about anywhere. Call logs? Pulled from a VOIP system. Quotes and follow-ups? Imported from your CRM or SQL database. Daily billing records? Integrated and matched against Accounts Receivable error reports. The data you need is probably already stored somewhere in your organizationโ€”Power BI simply connects to it and keeps it up to date with scheduled refreshes. Beyond pulling data, Power BI turns it into something useful. Instead of confronting an employee with vague complaints about billing errors, you can use Power BI to pinpoint exactly where theyโ€™re struggling and identify patterns over time. It also balances the data by highlighting areas where an employee is excelling, creating a well-rounded view of performance. With real-time dashboards, employees can track their own progress, giving them visibility into how theyโ€™re doing. From Metrics to Motivation Power BI isnโ€™t just about tracking performanceโ€”itโ€™s a tool for motivation. Setting up sales or shipping contests using weekly ratios? Done. Aligning performance data with pre-established goals? Easy. When positioned correctly, these numbers tell a much bigger story, helping employees understand where they stand and how they can improve. Managing people and evaluating performance is tough, but a good manager combines hard data with subjective feedback to help employees grow. A tool like Power BI transforms cold, abstract metrics into a visual, comprehensive representation of performanceโ€”and, in some cases, the suspiciously high cat-to-file cabinet ratio. About the Author Matthew Newcomb is an experienced and certified Microsoft Dynamics AX & 365 Trade & Logistics Functional Senior Consultant who knows that when it comes to ERP implementationsโ€”and employee performanceโ€”data makes all the difference. As a functional solution architect, business analyst, and project wrangler, he helps companies move beyond gut feelings and guesswork, using Microsoft Dynamics and Power BI to turn raw numbers into meaningful insights. Whether itโ€™s optimizing operations or tracking the mysterious disappearance of office supplies (looking at you, Karen), Matthew ensures businesses get the most out of their Microsoft solutionsโ€”without the headaches.

๐Ÿ” Annual Food Drive!

(November 3 to 17)

Weโ€™re proud to partner with the Schaumburg Township Food Pantry to support local families in need this season.

“If you can’t feed a hundred people, then just feed one”