Power BI Reporting for Bamboo Strategic Media

Power BI Reporting for Bamboo Strategic Media

This case study explores the features & challenges of migrating from Azure Dataverse to Azure blob Storage under Microsoft Dynamics Support.

Implementation

About Client- Attendance Management System

Pioneer Institute of Professional Studies is a Part of Pioneer Group which was established in 1996. The institute is known for providing quality education and is one of the oldest private educational Institutes in Indore. Pioneer Institute is run and managed by highly qualified & experienced professionals who have an expertise in the field of education & industry.

Attendance Management System-Project Background

Peritos and Pioneer Institute of Professional Studies got together and discussed about the issues related to attendance management system for students and teachers during the Lockdown period when all classes and lectures were happening online. In order to effectively manage tracking the attendance and ensure there is visibility to both students, teachers and parents, it was decided to discuss the online and digital option to get the teachers and students to track and manage the attendance online. This was also decided to implement across all of the Pioneer Group of Schools and colleges after its 1st successful iteration.

Scope & Requirement

In the 1st Phase of the attendance management system, implementation was discussed as follows:

Teacher Mode:

Student Mode:

Implementation

Technology and Architecture

Technology

Integrations

Security:

Backup and Recovery

Cloud systems and components used in the attendance management system are secure and 99.99% SLA. We have added HA/DR mechanism to create a replica of the services

Scalability

Application is designed to scale up to 10X times the average load received in the 1st 6 months of its usage and all cloud resources are configured for auto-scaling based on the load

Cost Optimization

Alerts and notifications are configured in the attendance management system to notify if the budget is being exceeded. Peritos being a cloud partner is managing the environment for the client keeping a close watch on the cost and finding ways to optimize the same

Code Management, Deployment

Features of Attendance Management System

Challenges

Project Completion

Duration

Deliverables

Support

As part of the project implementation we provided 1 month of extended support. This includes any Major / Minor bug fixes.

Testimonial

After using the app live for a month, we took a survey of approx. 20 teachers and 50+ students on how the app performed. All he staff and students love it. Here are the survey results out of 5 Stars:

  • Ease of use *****
  • Performance ****
  • Improves productivity to track attendance *****
  • Saves Time *****

Overall: 4.75/ 5

Feedback image
The mobile app designed by Peritos has made our life much easier. Digitization of attendance using this app has led to saving of time and resources, given visibility to our students and teachers, and eliminated the possibility of errors. We are very thankful to Peritos for helping us with digitization across our multiple group companies and they are all using the same app now.
Prashant Jain
GROUP CEO PIONEER GROUP

We are now looking at the next phase of the project which involves:

  1. Ongoing Support and adding new features every Quarter with minor bug fixes
  2. Web based module to have admin be able to mass Upload teacher, students
  3. Mobile App for the students and teachers to mark attendance on the mobile phone

If You Are Looking For Similar Services? Please Get In Touch

Testimonial

Edward Yarashev
Product Manager | Tonkin + Taylor

Peritos is a team of highly skilled developers, technical experts, and delivery managers. We’ve been very impressed with their commitment. Their developers and delivery managers have conducted themselves with professionalism and diligence at all times, and the quality of the work they have performed has been excellent. Many times, they proposed better solutions, which resulted in better and faster products. Peritos is a reliable AWS Partner. You can trust and be satisfied.


(For services and support)
Richard Canny
Ultimation industries | President

“We are very happy with the results of this major IT project with Peritos Solutions. Their staff gained a good knowledge of our business and processes. They were able to work with many of our diverse team members and launch Business Central ERP on time and on budget according to our requirements. We will be using them again for future projects and additional development actions. Thank you!”


(For services and support)
Grant Peterson
Software Development Manager | Insight Software

The project was completed on time and as per the agreed budget. The communication was excellent, as was the dedication to quickly turning around the required report development. The overall experience was good, and I would definitely work with the Peritos Team again.


(For services and support)

Proud projects that
make us stand
out

Azure Cloud Consulting Services Recent Home

services

Azure Cloud Consulting Services

Automate mundane HR tasks from pre-boarding to post-retirement with our award-winning HRMS suite, driven by…

Cloud Consulting Services Recent Home

services

Cloud Consulting Services

Unlock agility, scalability, and innovation by modernizing your legacy systems through our tailored cloud solutions.…

Download our Checklist on Selecting Azure/ AWS vs Other Hosting providers Recent Home

Downloads

Download our Checklist on Selecting Azure/ AWS vs Other Hosting providers

Cloud Hosting The checklist contains the below details on how you could decide between whether…

Border detection and Image processing Recent Home

Open CV - Image processing

Border detection and Image processing

Home Category Open CV – Image processing ID card Border detection and image processing using…

Thinking about a project? Get in touch with us.

Connect with Us Today through the Details Below or Fill
Out the Form for a Prompt Response

Book Free Consultation

Guaranteed response within 8 business hours.





    Trusted by Startups and Fortune 500 companies

    07+ years of experience

    We can handle projects of all complexities.

    100+ satisfied customers

    Startups to Fortune 500, we have worked with all.

    20+ in-house team

    Top 1% industry talent to ensure your digital success.

    Executive Summary

    About Client

    Bamboo Strategic Media is an innovative strategic marketing group that uses data to grow your business, for which Peritos supported them in Power BI Reporting. Their combination of experiences in business development, education, engineering, and media creation offers our clients a unique approach to analyzing their business needs and developing robust, innovative solutions.

    https://www.bamboostrategicmedia.com/

    Location: Gainesville, Florida

    Project Background

    Microsoft PowerBI is one of most used BI Visualization tool which comes with a lot of out of visualizations. This helps BI developers in creating reports and dashboard by integrating with data source of choice. Apart from out of box visualization, BI developers can also use visualization that are available over PowerBI marketplace, which satisfies the data analysis requirements.

    Scope & Requirement

    The scope here was to create custom Power BI visualizations reports for data analysis, which was asked by the client.

    This helped client to configure icons, show visual elements on the UI. This includes:

    • Showing Icons
    • Ability to add more icons
    • Make column data configurable

    Here, you will also learn how we created a custom PowerBI visualization for the customer for their Power BI data analysis requirements. The document covers the technical details around the process we followed. We helped customer to publish this report in Power BI. Custom visualization developed and now can be controlled with highly configurable advance
    UI

    Implementation

    Technology and Architecture

    Technology 

    The migration was deployed with the below technological component
    • For Azure Dataverse- The underlying technology used was Azure SQL Database

    • For Azure Blob Storage- It supported the most popular development frameworks including Java, .NET, Python & Node.js

    Security & Compliance:

    • Tagging Policies
    • Azure config for compliance checks
    • NIST compliance 
    • Guardrails
    • Security Hub

    Backup and Recovery

    Azure Backup provided a simple, secure, cost-effective, and cloud-based backup solution to protect the business or application-critical data stored in Azure Blob in two ways- Continuous backups & Periodic backups

    Network Architecture 

    • Site to Site VPN Architecture using Transit Gateway
    • Distributed Azure Network Firewall
    • Monitoring with Cloud Watch and VPC flow logs. 

    Cost Optimization 

    • Alerts and notifications are configured in the Azure cost 

    Code Management, Deployment

    • Cloudformation scripts for creating stacksets and scripts for generating Azure services was handed over to the client  

    Challenges

    •  Discovery the relevant examples in the community for advance configurations
    • Integration of React with Power BI
    • Advance custom UI development and management the persisted configurations
    • Reverse engineering of the already built custom visualizations
    • Debugging and running the already built examples as they are outdated
    • Lack in the Power BI documentations

    Project Completion

    Duration

    Deliverables

    • To fulfil the client’s requirements, we provided the flexible and scalable solution with the help of Power BI custom visualizations.
    • We used Power BI CLI tool to create the build the custom visualizations.
    • We leveraged the power of React to for efficiently DOM manipulations.
    • TypeScript played an important role for static code analysis to make code less error prone.
    • Advance custom UI developed to manage the highly configurable system.
    • React Native code base
    • Power BI Visual icon set
    • Power BI customized dashboard with Reporting capabilities of Power BI
    • Custom Features like Vertical text, Icon Set configuration, Sort, filter, slicer and other default
      options

    Support

    To fulfil the client’s requirements, we provided the flexible and scalable solution with the
    help of Power BI custom visualizations.
    • We used Power BI CLI tool to create the build the custom visualizations.
    • We leveraged the power of React to for efficiently DOM manipulations.
    • TypeScript played an important role for static code analysis to make code less error prone.
    • Advance custom UI developed to manage the highly configurable system.

    Testimonial

    Feedback image
    Evania Fernandes
    building Manager
    ultimate property group

    Next Phase

    If You Are Looking For Similar Services? Please Get In Touch

    ×

    Table of Contents

    Sign-Up to Become a Partner with uKnowva

    Benefits for Partner

    Acquire new customers and earn Steady Monthly Revenues.

    Our commission system will provide you with Competitive Revenue Streams.

    Add value to your customer with world-class HRMS Solution.

    Leverage uKnowva – A One-Stop HR Portal by scaling to global Clientele.

    Deliver Automated HR Solutions for a holistic digital transformation of customer’s HR processes.

    Get Started