Software Archives - Bistec Global Services - Services enabled, digitally!

Monthly Archive:

Archives

Data Engineering and Business Intelligence Solutions for User Management.

November 20, 2024

Introduction

A leading international accounting firm faced major challenges in managing their Azure Active Directory data. The firm required a strong solution to accurately track and report on user activity, onboarding and offboarding processes, and Microsoft license utilization. By partnering with BISTEC, they aimed to use advanced data engineering and business intelligence solutions to improve their operational efficiency and security. 

Key Challenges

Our client had to face several critical challenges that hindered their business operations: 

  • Their organization struggled to obtain precise counts of active users and lacked visibility into daily onboarding and offboarding activities. 
  • Reports were generated manually, thereby consuming valuable time and resources and increasing the likelihood of errors.
  • Without a system for tracking user logins, our client faced difficulties in monitoring activity levels, which created potential security risks. 
  • Due to the absence of clear records regarding license allocation versus usage, inefficiencies arose, ultimately resulting in either overuse or underuse of licenses.

Our Solutions

  • We established a connection to our client’s Azure Active Directory using the Microsoft Graph API to gather data on active users, onboarding/offboarding activities, and Microsoft license usage. 
  • By using notebooks and pipelines in Microsoft Fabric, we curated and processed the data within a Medallion architecture, ensuring efficient data migration. 
  • We also developed an interactive PowerBI report that provided insights into user management metrics. It enabled our client to make accurate decisions regarding user base, activities, licensing, as well as onboard/offboard details.

These data engineering and business intelligence solutions significantly improved their operational efficiency and decision-making processes.

Tools & Technology

Data Engineering and Business Intelligence Solutions for User Management
  • Power BI: To deliver comprehensive reporting capabilities.
  • Microsoft Fabric: For seamless data integration and management. 
  • Data Factory in Fabric: To effectively plan data workflows efficiently. 
  • Fabric Notebooks: For transforming raw data into meaningful insights using PySpark. 
  • Lakehouses: To store data within a Medallion architecture. 

Outcomes

  • The new system removed the need for manual report generation and implemented automated reporting, saving significant time for the team. 
  • Improved tracking of Microsoft licenses allowed for better usage, potentially leading to cost savings.
  • Access to detailed analytics by our business intelligence solutions empowered our client company’s c-level executives to make business decisions based on comprehensive data insights.
  • Improved monitoring of user logins and onboarding/offboarding processes reduced security risks and improved operational efficiency. 
Power BI case study - data engineering and business solutions for user management

Development of Tax Management System

June 21, 2022

Overview

Our client is a technology firm that specializes in IT strategy consulting, solution delivery, data analytics, and technology infrastructure.

It is wholly owned by the government and focuses on increasing service efficiency by utilizing citizen and customer-centric systems. 

The ultimate goal was to create One Common Portal, which aims to bring different online services together onto a single platform and provide a more seamless user experience for the corporate community to manage their corporate obligations throughout the business.

Key Challenges

  • Our customer’s tax management system was quite old and was demanding a replacement,​ and they wanted to introduce a One Common Portal for their citizens.
  • Further, the users must register in multiple systems to perform the necessary statutory requirements. ​ 
  • The client wanted to enhance and streamline the tax administration process and provide self-service capabilities to taxpayers to promote tax compliance at the lowest cost.

Solutions

  • BTG provided a skilled, extended team to complement our customer’s team from system development, delivery, and deployment standpoint. 
  • Established required processes for project execution and established required DevOps processes. 
  • Established required tools and processes for team collaboration and for project execution. 
  • Requirements and solutions were studied and documented according to software development and support best practices. 

Technology and Tools

Outcomes

  • Closely collaborated with the onsite team to define the requirements, review, and provide feedback on solutions and deliveries. 
  • BTG developed cutting-edge applications to replace outgoing systems

Document Management Solution with SharePoint & Power Platform

September 14, 2021

Overview

Our client provides disability services that are required to maintain detailed documentation of their user behavior and needs, which amounts to more than 10,000 documents across the organization.

Most of the documents are required to be updated monthly before expiry.

These documents were stored from local folders to multiple software systems

Key Challenges;

  • Users were unable to search & access the documents as there were multiple storage places/systems
  • Employees did not refer to the documents as it should be in performing their duties resulting in less efficiency & effectiveness, since it was difficult to find documents.
  • Many duplicates of documents as new copies were created whenever someone could not find the required document
  • Documents were not updated as users often forgot about expiry date of the document, which resulted in nonconformities when government & other audits took place
  • Management was not able to get an overview of the documents & their health

Technology & Solutions

  • Power Apps was used as an easy interface for the users to locate, access & manage documents easily
  • Power Automate to manage document approvals & sending automatic reminders on document expiry
  • Power Bi isualizing the document overview & health via a dashboard for the management
  • SharePoint Online to store documents in a single system & providing features such as access controls, audit trails, etc.

             

Outcomes

  • Easy & secure access of documents as all the document were accessed via PowerApps interface
  • Increased document usage resulting in improved efficiency of work
  • No nonconformities during audits as documents were updated on time
  • Up to date documents as users were remaindered automatically on document

Building a successful remote team for an Australian marketing agency

October 27, 2021

Overview

Our customer is a holistic creative agency with expertise in branding, strategy, digital marketing, website development, and content creation.  was officially launched in 2015 with an in-house team and a team of trusty freelancer developers who came together to achieve the objectives of the company. 

In order to cater to this new set of needs, they needed to expand their development team. They tried to do this with local talent, but this was met with the following challenges.

Key Challenges;

  • Our customer was having a lot of trouble sourcing qualified local people with the right skill set.
  • Local freelance software developers are costly, and they are frequently found to be unreliable.
  • The business recognized that onboarding new freelancers on a regular basis was consuming a lot of their time.
  • As the demand for their client services increased , they needed to expand its development team.

Solutions

  • BISTEC initiated the process of forming an extended team by identifying the needs of the customer.
  • We developed a model that would align successfully with the company’s goals.
  • BISTEC then identified several candidates who were found to possess the skillset needed to carry out the work.
  • Formed the team with involvement of customer, right from the start with initial screening of the candidates

Outcomes

  • The involvement of our customer in the selection process resulted in choosing correct offshore team members with the required skill set & suits their culture.
  • The customer was able to expand the offering to their customers while keeping the cost at a realistic model.
  • With the all-round skills offered by BISTEC team, customer was able to venture into new business areas.

Let's talk

We love connecting

We are here to help and support you.

If you believe that we can help you or your businesses requirements - do feel free to drop your details here and don’t hesitate to give us a ring.

Connecting with us on LinkedIn works best.

  • Footer Email