Ecolab is the global leader in water, hygiene, and energy technologies and services that provide clean water, safe food, abundant energy, and healthy environments. Changing global populations require companies like Ecolab to address the world’s water challenge. But using data to preserve the natural resource can be challenging. That’s why it’s important to have a team of professionals available to help. At Bitscape, we have the team you need. With years of experience and industry know-how, we can make your data transformation a reality. Contact us to find out more.
Bitscape is Microsoft Gold Competency Partner for Cloud Productivity, Cloud Platform, Data Analytics and Content and Collaboration. Bitscape’s customer centric approach ensures organizations to do more with their technology investments by improving user experience and productivity. We help customers achieve more in the digital transformation of their organizations of all sizes.
Industry: Manufacturing | Pharmaceuticals |Oil and Gas |Media Entertainment |Retail |Government
Products/Solutions: SharePoint Online |Power BI |Microsoft Flow |PowerApps |Dynamics AX Integration |ADFS / SSO
Customer is one of the largest cement manufacturer in the country with more than 6.75 million tons of annual production capacity and close to 1500 shop floor and first line worker collaboration. Customer aims to become number 1 player in the cement manufacturing brand in the country by using technology help them digitally transform the operations efficiency and which can result in to narrowing gap of hardly 2% in market share from number 1 player. Contract Labor Management System and Ticket Management System solution envisioned on top of SharePoint online where already existing corporate collaboration was happening.
Collecting data from multiple systems including legacy contract management solution, other shift data and production data from Dynamics AX ERP and ensuring all labor law, compliances and benefits are effectively monitored and rendered. Creating the fully functional regulatory driven, safety, statutory rates, medical records, contract management, shift management, workmen configuration, overtime, department mapping, workorder, bulk update attendance and fully integrated ticket management system for operational efficiency means highly efficient, no or less custom code-based
Working with functional group heads to map the processes and identifying data modeling needed from various data sources to run process workflow on SharePoint Online and create a seamless experience to achieve single source of truth available on preferred platform of SharePoint online.
The solution delivered responsive with completable to mobile devices such as Android, iPhone and iPad or tablets and other regular form factor and delivered integrated ticketing system for contract labor management which included Manage Contractor, Work order Management, Labor Management, Card Management, Attendance Management, Shift management, Wages Management, Compliance Management, Master data manipulation, Administration, Field Customization, Contractor collaboration, Leave Management
The solution delivered ensured a 360-degree view and compliance driven automation of manual processes and directly linked with production data ensured not only better productivity but also better employee satisfacation for transparent process for work and rewards.
Microsoft has a number of products that evolve over time. SQL Server 2008 is no exception. That’s why it’s time to upgrade. With SQL Server 2017, you don’t just get an update–you get in-memory performance across workloads, mission-critical high availability, end-to-end mobile BI, and in-database advanced analytics with security features. At Bitscape, we’re here to help you get the right tools for the job. Contact us to find out more.
Manufacturing | Pharmaceuticals | Oil and Gas | Media Entertainment | Retail |Government
SharePoint Online |MS Flow | Graph API |Power APP |AZURE API
Azure Web Service: SAP to SharePoint document transport |Azure DataLake |Azure Web Job
Adani Australia digitally transforms internal operations, business processes and workplace to be more agile to meet challenging business asks thanks to Microsoft PowerPlatform and Office 365.
Adani Australia is a multi-dimensional energy and infrastructure company, dedicated to delivering energy solutions for an advancing world. It owns and operates Abbot Point Terminal which has been exporting Queensland coal responsibly for more than 30 years. Adani Renewables Australia’s first solar farm Rugby Run near Moranbah will supply 65MW of renewable power in phase 1, with the capacity to expand up to 170MW. The Carmichael Project is a 27.5mtpa coal mine and 200km rail line.
Bitscape and Adani Australia, developed, designed and implemented Office 365 and PowerPlatfrom empowered commercial system and insights system to overcome this problem and help them meet business accountability and transparency at every level for internal operations.
With business and processes getting stiff requirements of transparency and processes including their business dealing with different vendors, service providers, other companies, being tracked at every level in semi-automated excel and email-based processes creates clear issues of accountability, agility and fast decision making their business need today. The processes in use had multiple challenges that included no tracking for approvals, C level approval complexity, no view of commercial processes such as invoices, payments, contracts tracking.
- Role based Dashboards i.e. Admin/ Approver/Requestor.
- Email notification at each level i.e. Approver, Requestor, HOD
- Attachment of supporting documents.
- Mobile base Approval System for CEO/CIO level user
- Role based Dashboards i.e. Admin/ Approver/Requestor.
- Automated workflow in each module.
- Insight Reporting for C level users with Power BI Dashboards.
The transformation helped Adani Australia to manage key and insights for operational efficiency. Some of the results as under
- Live tracking of Commercial request (PR to SES realised) status as well as their approvers status and comments.
- Role based Dashboards i.e. Admin/ Approver/Requestor.
- Power BI reports for Management/ CEO/ CIO.
- PDF conversion of Approved request (PR /NFA /Invoice /SES)
- Document Management of Approved Request (Knowledge Management)
- C level reporting generated on dashboards using Power BI
Industry: Manufacturing | Pharmaceuticals | Oil and Gas |Media Entertainment | Retail Government
Products/Solutions: SharePoint Online | Microsoft Power BI | MS Flow | Graph API | SQL SSRS | Power Platform
Essentra PLC digitally transforms multiple operations and gains critical insights thanks to Power BI, Flow, graph API and Microsoft software as service cloud.
Essentra is a leading global provider of essential components and solutions with four global divisions: Components, Packaging, Filters and Specialist Components. Every day Essentra produce and distribute millions of small but essential components and their international network extends to 33 countries and includes 45 principal manufacturing facilities, 30 sales and distribution operations and 4 research & development centers.
With more than 5000+ Office 365 users on Microsoft Cloud platform it partnered with Bitscape to work and leverage the platform to help them implement strategic transformation for various operations and insights needed by their strategic business units.
With the help of power platform and Microsoft O365 platform, Bitscape created multiple transformational solutions for them which included Capex Approval system, commercial system, Power BI Dashboard for Mattec System (3rd Party Manufacturing Execution system), compliance, risk mitigation and specific to business processes systems.
- Data maintained and used in MS excel and it was not manageable.
- No tracking of approvals.
- Do not get the live status of the Request i.e. Capex, Invoice Status, Payment Status, production reports.
- Lack of tracking for the approvers comments as well as status.
- No insights to Management for overall status of production of materials
- Lack of tracking for the Action owners and their comments as well as status.
- Live tracking of Capex status as well as their approvers status and comments.
- Dashboards for Admin/Approver/Requestor.
- Power BI reports for admin.
- PDF conversion of Approved capex
- Live tracking of Commercial request (CAPEX to Invoice realised) status as well as their approvers status and comments.
- Role based Dashboards i.e. Admin/ Approver/Requestor.
- PDF conversion of Approved request (Capex / PO / Invoice)
The transformation helped Essentra to manage key actions from meetings, projects, incidents, audits and monitor quality control. It provided real time visibility and status for every action within the organization or the strategic business unit along with critical insights reports for production.
And with the event that Microsoft partners from around the world await with bated breath, Microsoft Inspire, trending as #MSInspire was no less than a spectacle in every sense. While partner conferences are something that only large scale organizations put up, these events talk a great deal about the insights of the importance a vendor company is giving to its clients. With the major agenda of a sales event, these partner conferences give the clients a good sneak peek into the plans of the vendors and what their aims and goals are for the coming times. Focused on driving customer and partner engagements, MSInspire is usually setting goals for partners with a humungous limelight concentrated on recognitions and morale boosting of the inseparable part of their ecosystem. Focusing on multiple aspects that have seen a paradigm change,the graph of successful ventures is on the rise and new additions ensure that the same continues. Dynamic 365, PowerApps, AppSource, Azure Marketplace & AI were some of the key highlights of the entire 3 day hullabaloo and Vegas definitely seemed much brighter with MSInspire, as it does, year after year.
With its grandeur and exuberance soaring higher every passing year, Microsoft Inspire was a 3 days extravaganza with partners and MS geeks pouring in from all corners of the world. Hosted on the 15th, 16th and 17th July 2019, Microsoft Inspire was a huge platfom that offered immense opportunities to investors, partners and those wishing to walk the extra mile to realise the potential that technology has to offer.
With the arrivals starting on the 14th July, Microsoft had its First Time Attendee orientation sorted on the very same day and The Hub Preview by Microsoft Inspire and Microsoft Ready. Taking off with Corenote at Microsoft Inspire, the major part of Day 1 was devoted to Networking & Sessions at Microsoft Inspire followed by Social Hours with Microsoft Inspire and Microsoft Ready and Area Celebrations to conclude the day with.
“The magic happens when your teams meet our technology. We come together in a partnership” said Gavriella Schuster, Corporate VP for One Commercial Partner at MS Corp.
While the Corenote at Day1 worked towards valuing and empowering Microsoft Partners, it also drove a significant focus to democratise digital. Making the economies digital and democratizing it, part of the address by Judson Althoff, Executive VP of Worldwide Commercial Business at MS Corp was what ruled the Day1 which saw numerous attendees at the arena for the CoreNote and then some more at the various halls put up for interaction of the partners with the core teams.
Putting up ‘The Hub’, an open platform at the Mandalay Bay Convention Centre which was a rather convenient spot for the attendees to come together and build up the much required connect with Microsoft Partners from all over the world, The Hub was a gallery of opportunities for those willing to find one.
Specific Area Lounges, Connect Zone- a cafe set up to meet and discuss opportunities with other MS Partners from more than 130 countries and the Social Hours presented a plethora of options for all the attendees to reap out the maximum benefits from the MS Inspire and one could only wish for that the time did not end that soon!!
Day 2 Corenote:
While Day2 saw a multitude of featured speakers taking over the stage that come from different walks of life and have their own lives as an example to inspire, MS Inspire got an immeasurable impetus at The Hub, wherein the SMC Sales Centre was one of the numerous interactive enters and platform available for people to mingle with the like minded crowd and explore the richness of the event. Day 2 was still ruled by Networking & Sessions at Microsoft Inspire, followed by Social hours at Microsoft Ready and Microsoft Inspire which paved for various evening events later.
While Innovation, Partnership and Business Leadership remained at the core of all the activities planned at MS Inspire, the learning material available as well as the unmatched energy of the event pumped up the enthusiasm manifolds. The huge gathering comprised of not only Microsoft partners from more than 130 countries but also Microsoft senior leadership, Microsoft Solution Specialists, Microsoft Account Executives, Microsoft Channel Managers, Senior Industry Experts and many more.
The event also focused on core aspects such as being accessible to all, embracing sustainability and supporting wellness by undertaking various activities and minuscule steps such as providing sustainable food choices, giving healthy meal options, gym access and a host of other conveniences to the attendees.
A gesture of warmth to first time attendees, MS Inspire also put up the FTA program by pairing new attendees with seasoned partners who could serve as guides and mentors to sheath the new attendees by getting blinded from the extravaganza. Starting from the orientations to the post-event planning help, the FTA was no less than a boon for the newbies and definitely helped in making them comfortable and completely imbibe the essence of MS Inspire.
Day 3 Corenote:
While Day3 consisted of Microsoft Inspire and Microsoft Ready Corenotes to start the day with, strong words from Satya Nadella and Brad Smith about not only reaching out to but also at the same time empowering every organisation on the planet simultaneously creating a sustainable environment on the planet for the future generations to come touched a chord.
Day3 witnessed numerous shared stories of success and innovation from the attendees. Majority of the stalls at The Hub and even the Connect Zones saw a huge footfall with people trying to grab up as much as they could from what MS Inspire had to offer. Empowering through partnerships, collaborations and reaching out to partners from farthest of places within a couple of square inches is one of the best things MS Inspire offers to its partners. The multiple atriums and theatres hosted a significant number of sessions for the attendees to take back with them as experiences and knowledge. Business development Connections and Networking Sessions at Microsoft Inspire and Microsoft Ready still took up the major part of the day and the One Celebration was the just the perfect way to end the 3 days long exuberant affair.
The catch ups at The Hub, the discussions, key speakers’ notes, CoreNote, all added to the 3 days Gala event, numerous discussions, meetings, brainstorming and a host of other activities on the latest technologies, updates, programs and applications pertaining to services and solutions such as Cloud Management, Artificial Intelligence, Business Applications, Teamworks, Internet of Things and much more, the event wrapped up with one of the largest celebrations, or rather, the One Celebration. The event throbbed with the high energy levels of Microsoft employees and partners alike, celebrating their shared success and at the same time paving way for the year that is to come.
On Thursday, the 18th July, the day for the final see- offs, the content was concluded with the First Time Attendee workshops, some more networking sessions and Area General Sessions which worked out like more of cool down sessions to kick start the wait for the event next year!
Customization is the need of the hour and we would do anything to get that ease of customization in anything and everything that we can lay our hands on. Be it our clothes, our mobiles and accessories, our crockery or anything that we need and use in our everyday life. The addition of that personal touch makes things so much more different and it always adds to the feel good factor. But hey, then do we like to run to other people, the so- called experts for all the customization? Wouldn’t it be a tad bit more convenient and exaggerating if we were able to do things on our own rather than to find some expert every other time. Well guess what!!! MS Flow lets you do just that, and a slight bit more.
MS Flow is a recent addition to cloud based software’s by Microsoft that help end users to not only create but also customized workflows and store them for multiple usage. These process flows can range from petty operations such as storing files with a particular extension to complex programming structures based on specific algorithms. Termed as Flows, these functions can automate and customize almost everything, and the best part is that, No, you don’t need a developer to do that for you.
Drumrolls!!! It is as easy as type and click. Yes! That’s what MS Flow does for you. Setting reminders, segregating files, deleting specific file formats, creating conditional programs, sending automated mail responses, just to mention a few. Plus, being a cloud based software and compatible with other MS applications such as PowerBI, PowerApp, Office 365 and many others, MS Flow is just what one would want to make work spaces convenient and comfortable. With no technical expertise required, MS Flow really comes in handy when it comes to setting up one’s own processes and work flows to be able to manage tasks rather efficiently, not to mention, ease is an icing on the cake.
Bitscape being one of the most prominent channel partners for Microsoft in California, US, this brand new feature from Microsoft is being promoted across all Bitscape clientele and firms that have an MS environment to provide ease of functioning and move their work processes on auto mode.
Day 1 at Microsoft Inspire, Las Vegas
The 1st day at Microsoft Inspire, the largest annual meet conducted by Microsoft, year after year for its network partners to gather on one platform and review as well as ready for the next insights from Microsoft and also to broaden the community’s understanding of its services and products and brainstorm on ideas and solutions that can be offered to the customers around the globe to be able to use the available services in an increasingly efficient manner was a feast for the eyes. With the largest gathering of IT brains all across the world, the event presented the numerous partners and employees who traveled from lands near and far a plethora of opportunities than ever wherein everyone gathered in the T-Mobile Arena to hear to the world leaders talk about how Microsoft technologies and services were being channeled y the partners and global entrepreneurs to bring innovation and ease the life of customers and change business perspectives through intelligent transformation across borders.
The focus was also on the upcoming financial year 2019 on how industry specific solutions and customer centric policies and updates that would not only help acquire new customers and businesses but also help retain the previous clientele. New strategies, enhanced training methodologies and readiness opportunities for the new players that come into the market and anchor themselves with Microsoft technologies which would give them the much needed base for growth in the industry.
The evening also witnessed great insights from Gavriella Schuster, Corporate Vice president, One Commercial Partner, about programs, tools and resources that would help partners to rejuvenate as well as differentiate their business with the help of latest Microsoft technologies and updates.
Day 2nd Microsoft Inspire, Las Vegas
Corenote, about to start at 8.30 AM Pacific Time was filled with activities and similar sessions with opportunities to connect with active partner communities at the Community Hub. Shuttle services from the hotels started from as early as 6 AM. With resources available to book meeting spaces and also tools that allow booking face-to- face meetings with other attendees till a maximum 9 members per meeting. Also the meeting could be reserved for available slots at the MyInspire meeting tables or any other alternate locations. The Happy Hours in The Commons started from 5 PM to 7 PM that provided unparalleled opportunity to meet up fellow partners and Microsoft Ready Attendees.
Day 3rd Microsoft Inspire, Las Vegas
that concluded the Corenote at Las Vegas, Nevada was made all the more worth it by the address of Satya Nadella that enlightened the audience comprising of partners and employees on how Microsoft planned to harp on its mission of empowering every person and organization on the planet to achieve more using its latest technologies such as the Microsoft Intelligent Cloud and Microsoft Intelligent Edge. There were talks by Microsoft Solution area leaders who spoke about new resources and assets that aided delivery of strong Modern Life Solutions with stories from customers all around the world that showed how Microsoft 365 enabled employees to bring in more innovation and creativity into the workspace. Also, the day included details about the expansion of the Azure platform that enabled improvisation across multiple domains.
Enamoring the event were performances from Grammy Award Winner Bruno Mars at One Celebration, Las Vegas Motor Speedway which added to the quotient of entertainment, networking and fun of the event. With the event in full swing, Microsoft also added to the excitement by putting up 10 new announcements which have already started creating ripples in the market and the results of these announcements would be soon seen in numbers. The announcements put forth by Microsoft are as listed below
- New marketplace capabilities such as Integrated Partner to Partner Solutions that will help channels grow their business with sales and deployment.
- Expansion of Private Offers in Azure Marketplace that will help partners move away from standard prices, offer better buying prices to customers who in turn achieve a unique buying experience and meet their buying needs.
- Special Bootcamps and free access to the dynamic self service for partners, including business insights which would help them get a better understanding of the business apps and enable them to understand performance and stability of their business.
- Microsoft also announced advanced specialization and services for its partners that would help them go the extra mile and boost their profitability.
- The Azure Expert MSP or Managed Service Provider program which begun as a pilot program earlier this year has been introduced by Microsoft for their partners who stand out of the crowd by demonstrating extra ordinary skills in delivering consistent Managed Services in Azure
- Market Benefits Package: Helping its partners build market practices that are more targeted and help partners to select from four business packages depending on their business focus in the later part of the year.
- New Apps and Technologies for Azure: Announcements regarding the launch of Azure Data Box Disk and Azure Firewall and Azure Virtual WAN. These innovations seem quite promising when it comes to data transfer within organizations as well as compliance policies.
- Microsoft 365 Updates: Announcing the availability of Microsoft Teams collaboration app as a free version in the Office 365 suite. Also, an additional feature of Workplace Analytics was added that would help teams discover and meet challenges.
- Updates on Software as Services: Releasing updates on a lot many services from its plethora of services such as Azure IoT Central which would in turn support for Power BI and Microsoft Flow to enable real time intelligence visualization.
- Expansion of the Microsoft Library of free playbooks with two new additions to help its partners build practices in new arenas which would serve as guidelines for managing and developing cloud practices.
With technology advancing at an unprecedented pace today, it has become essential for corporations to ensure optimal security when it comes to sharing confidential corporate reports and other such information. Bitscape offers consulting services for Microsoft Power BI platform, so you can get the perfect solution to your business data analysis and sharing needs.
What is MS Power BI?
Simply speaking, the Microsoft Power BI platform allows you to share, provide access and secure reports and dashboards created by you, with other authorized users only. This is the efficient way today of providing limited/complete, access to users, depending on the level of their role.
The Microsoft Power BI security system is the perfect tool to improve your business performance. It allows you to create analytics, and get deeper insight into your market, to make smart, profitable business decisions. With the Power BI platform now you can achieve the optimal level of data security in sharing sensitive corporate dashboards and reports, like never before.
The Security in Power BI Structure
Each Power BI system consists of two clusters:
- Web Front End (WFE) – This cluster is responsible for managing the initial connection and authentication procedure for the Power BI Suite. It uses AAD authentication process for clients, and provides tokens to help connect directly with the Power BI service. The ATM (Azure Traffic Manager) is then used to direct user traffic to the nearest datacenter efficiently, using the DNS record of the clients. The Azure CDN (Content Delivery Network) is used to share the necessary non-dynamic content and files with the client/users, according to their specific geographical location.
- Back End (BE) – This cluster helps clients with authentication to successfully interact with the various Power BI services. It helps to manage user dashboards, visualizations, reports, data connection, data sets, data storage and other interactive aspects of the Power BI Suite. The user requests for access to any content or file is handles with the Gateway Role, which is the sole role that the user will interact directly with while using the Power BI service. The Gateway Role, in turn, is operated by the Azure API Management tool.
Salient Benefits of using Power BI Security
These are top three benefits that are seen when you employ MS Power BI for corporate data storage, access and security purposes:
Secure Data Storage
The restricted direct user-access through Power BI is probably the best security feature in this service suite. The Power BI security procedure allows users to interact directly only with the Gateway Role and Azure API Management, while the rest of the aspects of Power BI, such as Presentation Role, Data Role, Background Job Processing Role and Data Movement Role are out of the user’s reach.
Any form of data sent to the Power BI storage, is stored and managed using two different components:
- Azure BLOB – This stores all data uploaded by the users.
- Azure SQL Database – This stores and manages artifacts of the system and all metadata files.
This clear demarcation for user-accessibility to the different components of the Power BI allows it to effectively keep all user data and corporate information stored in MS Azure safe and completely secure.
Excellent User Authentication
The AAD (Azure Active Directory) is used by the Power BI for authenticating users, as soon as they login, as well as when requesting access to any data or content in the storage. A simple email address is needed to login to the Power BI services, as this inherently becomes your Username on the system too.
Apart from this excellent authentication procedure, the Power BI security platform also allows adding customized AAD-based security protocols, enhancing multi-tenant system security and improving your network security effectively.
Successful Service Security
Normally, users are responsible for sharing data. In case a user logs-in with their effective Username, and share any content (dataset, dashboard, etc) they are connected to within the specific data source, the shared data is not restricted by conventional restriction measures.
Only connections with SQL Server Analysis Services, through On-Premises Data Gateway, are able to cache dashboards in Power BI. If the user wishes to allow access to other users to the underlying data, then such an authentication can also be granted.
BITSCAPE has been a prominent provider of Microsoft, especially the Azure cloud-based services at a global scale. The company is renowned for offering the best and most effective IT solutions for small and large corporate clients.
Data assimilation doesn’t simply end with the report or dashboard. Bitscape offers Microsoft Power BI consulting services. With Microsoft Power BI, it is now possible to collect and process business data to provide users with excellent, versatile and truly dynamic dashboard designs.
The aim behind making the dashboard more attractive is not to make it aesthetically appealing, but rather to provide an easy-to-read interface that provides users with the relevant information easily. Bitscape can assist you with use of Power BI visual design feature, so you can make your dashboard look clean, organized and better for use by others too.
3 Tips to Design an Ideal Power BI Dashboard
The extensive Microsoft Power BI designing visuals are perfect to create dashboards that help to display the required information faster, and in a better manner, to the user.
These simple expert tips will help you to improve your Power BI Dashboard designing skills, to make it an ideal dashboard:
Tip 1 – Consider the Audience
As your aim is to provide your market audience with the most appealing and effective dashboard, before designing a Power BI dashboard, it is important to consider the target audience’s:
- Vital decision-making metrics
- Use of the particular dashboard
- Cultural/learning experience’s effect on design choice
- Need for relevant, updated and accurate information
- Choice of location for displaying the dashboard
Mainly, the dashboard works as a single point to monitor multiple aspects of the business, sort of an overview of the current business performance. A large number of datasets and reports usually combine to become the information displayed on a dashboard, which can contain a large amount of detail.
Tip 2 – Fit a story on one screen
As dashboards need to provide the relevant information in a concise manner, whenever possible, for the users, it becomes important to prioritize the information to be actually displayed on the dashboard.
Try to keep the tiles aligned, avoiding scrollbars as much as possible, and ensure that the information can be seen in the ‘Full Screen’ mode.
Tip 3 – Effectively display prominent information
The trick to make the users realize the prioritized information is to set the relevant information in a bigger or more prominent font than the others. Always ensure to provide the correct context with such prominently displayed information for better understanding.
Experts suggest that the best location to put the most important information on a dashboard is on the upper left hand corner, followed with the less prioritized information as you go lower.
Using Power BI visual design, it becomes possible to make your dashboards be impressive, accurate, organized and highly convenient for the targeted audience. Contact Bitscape to understand the true potential of Power BI visual design features.