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 one of the leading Canadian companies that provide consultancy services for construction projects.
Mainly they needed an added CAD support team for their business with the idea of cost-effectively sharing the workload among the teams. Therefore, the in-house drafters would be able to give more attention and maximum potential to the onsite projects.
Solutions
BISTEC provided a CAD team consisting of two drafters for the Civil engineering and MEP projects.
Our drafters collaborate directly with the Consultancy firm’s engineers and communicate with them daily.
The progress and process are reviewed monthly by our CAD team.
Tools & Technology
Outcomes
There was a reduction in the cost of direct recruitment for the Engineering Consultancy Firm.
The engineering consultancy firm had very less administrative and HR work since the company didn’t have to go through the process of recruiting new staff.
The In-house drafters were able to focus more on their onsite projects.
Our customer is an Irish-based retail strategist who owns a retail consultancy and works with specialty retail chains, suppliers, and brands.
Key requirements
During the pandemic, our client identified an opportunity to support the local trade and retail business community with her expertise in retail and digital trading strategies.
She wanted to refocus and retarget her marketing efforts towards local retail and trade as well as the local councils and associations.
Our client needed help with rebuilding her social media strategy as well as the digital marketing strategy and promoting her brand among the local businesses.
Despite being active on social media she didn’t have a consistent brand online or content marketing plan to execute her revised business and marketing objectives.
Due to this, she faced the following challenges:
The content published did not have a clear focus or thought leadership area
Ad-hoc content posting on social media
No clear branding in the posts
Videos and content were not professionally edited and didn’t include the brand (logos and brand colours)
No insights into her publishing statistics to understand the engagement and reach
We helped our client with our best practices plus technologies and tools to build brand presence and promote her business among the local retail community.
Mainly by using all social media channels while using LinkedIn as one of the main marketing platforms to build and engage a relationship with her targeted audience.
Technology and Tools
Outcomes
Successfully launched two commercial forums for independent retail business owners to gain exclusive support, trading insights, and benefits.
Built a consistent brand identity and presence across all social media channels.
The number of impressions and engagement grew significantly on all social media channels within the initial 3 months.
Clear insights on the content and media with high engagement and reach on each social media platform due to the frequent analysis of the publishing stats.
Our client was able to generate leads through the new social media and branding strategy implemented through all the social media channels.
Our customer is an end-to-end Property Investment and Marketing service providing agency, based out of Melbourne, Australia.
Our customer (The managing director of the company) required lead generation and content generation services on LinkedIn for his property investment company.
The firm’s target market was Southeast Asian countries, and the target demographic was the affluent members of the society in those countries.
Correspondingly, our client had the following key requirements;
Generating leads to invest in Grit’s luxury investment properties in Australia and Sri Lanka.
Trying and improving a different online approach apart from cold emails, newsletters, and online ads.
Wanted to connect with his target demographic personally, share wealth creation and investment advice, and establish a more personable and trusted brand identity online.
Solutions
To engage with investors interested in investment advice and tips on wealth creation, BISTEC formed a highly effective marketing team that used LinkedIn as the primary marketing platform to identify the target demographic.
First of all, we focused on building brand awareness and the firm’s LinkedIn network (with the target demographic) by maintaining the company’s LinkedIn page.
Then we used his personal profile to directly connect with potential leads by sending connection requests, thank-you messages, and sharing article links among the networks. This was done to establish his brand as the property investment expert and as the face of the company.
Helped to boost the company’s brand presence and provide value by creating and publishing curated content, writing articles, and editing videos.
We also published statistics and weekly or monthly updates about the leads and the content generation services we provided.
Tools and technology
Outcomes
Our client gained sound reach and visibility among his target demographic from more than 10 Southeast Asian countries through the expansion and growth of his LinkedIn network.
The number of leads increased gradually and also, our team was able to sustain the incoming leads through the LinkedIn presence and content marketing.
Received more collaboration opportunities.
The client was able to build a brand presence, as a credible property investment expert, keen on providing valuable investment advice with the intent to help and solve problems.
