The Townsend Report from the InfoStrat Division of Serenic Software

  In March 2021, InfoStrat’s parent company Sylogist acquired Municipal Accounting Systems Inc. (MAS) , a provider of student information systems and accounting solutions to K-12 public school districts. MAS was founded in 1985 and has grown to serve nearly 85% of the Oklahoma K-12 public education market with its integrated Wen-GAGE platform. This SaaS solution includes budgeting and accounting, a student portal, comprehensive student information tracking, grading and scheduling, and lunchroom administration. Wen-GAGE expands our company’s offering and customer base in K-12 dramatically, and we are excited to bring these products to other states.  

Analytics is one of the fastest growing categories of software.  Sales of products like Microsoft Power BI, Tableau, Qlik and Splunk are growing rapidly and analytics is being placed in the hands of more users than ever before.  Analytics tools make it easier to visualize and understand your data, but there is still plenty of work for us as analytics end users.  Now that we have analytics, what can we do with them?  Here are some approaches that may help you harness analytics for your business or research. Learn from others . Like writing an original song, a good place to seek inspiration is by learning the works of others. Check out reports in your industry and other industries to get ideas on new analytic approaches.  COVID-19 provided a great opportunity for analytics, especially geographic representations of case and mortality data.  You can view sources like the Johns Hopkins COVID map https://coronavirus.jhu.edu/map.html or the informationisbeautiful visualizations https://inform

Microsoft makes it easy for nonprofits to get the software they need for office productivity through grants of Microsoft 365 to eligible organizations.   Microsoft 365 is a suite which includes Windows and Office 365.  It is available in Basic, Standard, and Premium editions which contain different products: Microsoft 365 Business Basic -- Free up to 300 users Microsoft 365 Business Standard -- $3/user/mo. Microsoft 365 Business Premium -- Free up to 10 users and $5/user/mo.  You can begin the eligibility process to show that your organization meets all five of these criteria: Organization muts be a nonprofit or non-governmental organization Mission must benefit the local community Users must meet eligible categories Meet license restrictions Meet Microsoft non-discrimination qualifications Combined with the Microsoft Nonprofit Cloud that I have discussed in other posts, this offer means that Microsoft provides a broad suite of products at no or low cost. 

  If you follow this blog or have attended any webinars or other events where I present, you know that Microsoft Power Apps is growing like gangbusters and that many people are turning to Power Apps for their line of business solutions. But where should you start?  For some organizations, the best way is to choose a Dynamics 365 app such as Dynamics 365 Sales Enterprise or Customer Service and roll it out for your organization.  These off-the-shelf apps are built on Power Apps but are fully functional from the start.  You can learn Power Apps by configuring and customizing them with your own new tables, fields, workflows and reports. This is the best scenario when you have a business need that maps closely to one of these apps. Another way to start is to build a custom Power App from the group up, either as a canvas app or model-driven app.  You can purchase Power Apps for all the users who need these apps and start with one which is simple enough to build quickly. You can also start l

Last week Microsoft made many announcements on Power Apps.  One of the most important was naming  Power Fx , the unified language used in Power Apps Canvas Apps and other Power Platform products. This announcement is more than just naming a language because it unveils a long-term plan for standardizing the Power Platform stack of development tools.  April Dunnam of Microsoft provides a concise explanation in the video above, relating the announcement to the groups of products and developers who are affected by the change.  Formulas in Power Apps are based on Power Fx which uses expressions derived from Microsoft Excel. Power Fx is easier to learn than JavaScript.  It gives immediate results (or error messages) to the developer in a similar way to Excel.  The following shows functions highlighted in green which are shared by Power Fx and Excel. Source: https://powerapps.microsoft.com/en-us/blog/what-is-microsoft-power-fx/ Microsoft is targeting citizen developers or power users as a key

Recently I wrote on The Enduring Appeal of Low Code Software Development  and 6 Reasons to Choose Microsoft for your Low Code Application Platform which explain why low code development is popular and why Microsoft is especially successful among the low code application development platforms.  Like many decisions, moving to low code software involves tradeoffs, so this post is devoted to some of the considerations that may shape your decision on whether and how far to move toward low code. Performance The first tradeoff is performance.  If your goal is to squeeze every bit of performance out of a system, low code may not be the best option.  Low code platforms involve layers of abstraction and code that introduce overhead,  For extremely large data sets, intensive calculations, or real time operations, you do not see many low code systems.  Instead, the highest performance systems use full code and get as close to the data as possible to max out speed.  User Experience Low code syste