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
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.
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
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
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.