WP_Query Object
(
    [query] => Array
        (
            [tag] => office-365
        )

    [query_vars] => Array
        (
            [tag] => office-365
            [error] => 
            [m] => 
            [p] => 0
            [post_parent] => 
            [subpost] => 
            [subpost_id] => 
            [attachment] => 
            [attachment_id] => 0
            [name] => 
            [pagename] => 
            [page_id] => 0
            [second] => 
            [minute] => 
            [hour] => 
            [day] => 0
            [monthnum] => 0
            [year] => 0
            [w] => 0
            [category_name] => 
            [cat] => 
            [tag_id] => 385
            [author] => 
            [author_name] => 
            [feed] => 
            [tb] => 
            [paged] => 0
            [meta_key] => 
            [meta_value] => 
            [preview] => 
            [s] => 
            [sentence] => 
            [title] => 
            [fields] => 
            [menu_order] => 
            [embed] => 
            [category__in] => Array
                (
                )

            [category__not_in] => Array
                (
                )

            [category__and] => Array
                (
                )

            [post__in] => Array
                (
                )

            [post__not_in] => Array
                (
                )

            [post_name__in] => Array
                (
                )

            [tag__in] => Array
                (
                )

            [tag__not_in] => Array
                (
                )

            [tag__and] => Array
                (
                )

            [tag_slug__in] => Array
                (
                    [0] => office-365
                )

            [tag_slug__and] => Array
                (
                )

            [post_parent__in] => Array
                (
                )

            [post_parent__not_in] => Array
                (
                )

            [author__in] => Array
                (
                )

            [author__not_in] => Array
                (
                )

            [ignore_sticky_posts] => 
            [suppress_filters] => 
            [cache_results] => 1
            [update_post_term_cache] => 1
            [lazy_load_term_meta] => 1
            [update_post_meta_cache] => 1
            [post_type] => 
            [posts_per_page] => 10
            [nopaging] => 
            [comments_per_page] => 50
            [no_found_rows] => 
            [order] => DESC
        )

    [tax_query] => WP_Tax_Query Object
        (
            [queries] => Array
                (
                    [0] => Array
                        (
                            [taxonomy] => post_tag
                            [terms] => Array
                                (
                                    [0] => office-365
                                )

                            [field] => slug
                            [operator] => IN
                            [include_children] => 1
                        )

                )

            [relation] => AND
            [table_aliases:protected] => Array
                (
                    [0] => wp_term_relationships
                )

            [queried_terms] => Array
                (
                    [post_tag] => Array
                        (
                            [terms] => Array
                                (
                                    [0] => office-365
                                )

                            [field] => slug
                        )

                )

            [primary_table] => wp_posts
            [primary_id_column] => ID
        )

    [meta_query] => WP_Meta_Query Object
        (
            [queries] => Array
                (
                )

            [relation] => 
            [meta_table] => 
            [meta_id_column] => 
            [primary_table] => 
            [primary_id_column] => 
            [table_aliases:protected] => Array
                (
                )

            [clauses:protected] => Array
                (
                )

            [has_or_relation:protected] => 
        )

    [date_query] => 
    [queried_object] => WP_Term Object
        (
            [term_id] => 385
            [name] => Office 365
            [slug] => office-365
            [term_group] => 0
            [term_taxonomy_id] => 385
            [taxonomy] => post_tag
            [description] => 
            [parent] => 0
            [count] => 2
            [filter] => raw
        )

    [queried_object_id] => 385
    [request] => SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1  AND ( 
  wp_term_relationships.term_taxonomy_id IN (385)
) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'expired' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'dp-rewrite-republish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 10
    [posts] => Array
        (
            [0] => WP_Post Object
                (
                    [ID] => 15344
                    [post_author] => 3
                    [post_date] => 2021-01-10 13:05:56
                    [post_date_gmt] => 2021-01-10 19:05:56
                    [post_content] => 

Leveling Up Your Business Dashboards with Microsoft Power BI & SharePoint

Microsoft Power BI is a fantastic solution for analytics that helps businesses to extract data and exchange insights within their organizations. It mainly improves productivity by showing immediate results. Using SharePoint without Power BI integration can make business analytics challenging. Doing so is not time-efficient, and it makes it difficult to fetch accurate data. It also lacks reporting visuals that make it easier to see progress. At HingePoint, we make sure you get all the advantages of Microsoft Power BI with a far more tailored approach. This tool can be integrated with Microsoft Office 365 applications, which is convenient for all employees since it is commonly the software companies use for data collection, sales reports, presentation, and more. Using immersive data visualizations, organizations can finally track their progress with this platform.

Why do we need Power BI reports and dashboards?

  1. Data Source (Fetching data in Power BI)
To fetch data from various data source can be the first and foremost challenge that can be faced in Power BI. Our approach: For fetching data of some of the services that don’t support Power BI integration, we have already used API’s of many services to get data in Power BI. (Only applicable for Services that provide API)
  1. Data Validation/ Data Structure
Another difficulty that can be faced in Power BI that is faced is Data validation. We need to have proper data structure so that Power BI can use that data appropriately. If the data structure is not as per the requirements there can be issues faced for fetching proper data as per requirements. For example, fetching data from excel that is not as per the appropriate data structure etc. Our approach: We create data structure that can be directly used in Power BI for making charts.
  1. Attractive designing (Look and Feel of reports)
This is the Key part for any Microsoft Power BI project. Attractive charts and reports as per the expectations are the foremost need of any clients. Our approach: We have already created many Power BI charts that uses color combination as per company logos, company specific needs. Bar charts, pie charts, maps, donut charts, and many more are used to make chart look more attractive.
  1.  Easy search and Filter (ease of data viewing)
Filter the data with ease is another specific requirement. Our approach: We try to maximize use of more filters so user can get ease of accessing more data easily.   5. Auto Refresh (Automatically refreshing charts) Refreshing the data automatically is one of the challenges that is faced in Power BI. Our approach: We configure Power BI desktop to provide 8-time refresh per day. Whereas in Power BI Premium has an option of hourly data refresh.

Enhancing Performance with SharePoint + Power BI

The advantages listed above play a significant role in business analytics. They can all be provided with SharePoint and Power BI integration, but with our services, you can get more to optimize Power Bi’s benefits. With HingePoint, you’ll get accurate data extraction and a more personalized platform complete with company attributes, including a high refresh rate for real-time reporting. If you have more inquiries or want to get started on enhancing your company’s performance, send us a message. We’re always here to assist you with your business needs. [caption id="attachment_15346" align="alignnone" width="822"] Example Project for Customers and Suppliers purchase and sales.[/caption] [post_title] => Leveling Up Your Business Dashboards with Microsoft Power BI & SharePoint [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => leveling-up-your-business-dashboards-with-microsoft-power-bi-and-sharepoint [to_ping] => [pinged] => [post_modified] => 2021-03-24 13:37:32 [post_modified_gmt] => 2021-03-24 18:37:32 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=15344 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [1] => WP_Post Object ( [ID] => 15197 [post_author] => 3 [post_date] => 2020-09-24 19:25:49 [post_date_gmt] => 2020-09-25 00:25:49 [post_content] =>

Building a Document Management System using Microsoft

Finding the right system to manage your documents is crucial to the success of any business. Using a Microsoft document management system can help solve the typical challenges businesses face when trying to create a scalable workflow. 

What is a document management system?

A document management system is for managing digital files such as Word, Excel, PowerPoints and more. In this era, we need secure, robust and customizable software that gives a great user experience. Switching from a legacy document management system to a newer system has the potential to improve performance and cut costs.

Typical Challenges with Legacy Document Management Systems

Does Microsoft have a Document Management System?

Yes, it does. Microsoft Office 365 provides various software solutions including SharePoint, Microsoft Dynamics and OneDrive for document management. Any of the above can be used depending on the needs of each organization. This system helps us to store, collaborate, and share the documents around different platforms. There are also different ways we can analyze the performance of the system.
  1. Security and Permission Management Many document management systems don’t offer a way for users to set restrictions on who can see certain documents. Some documents should only be able to be viewed by specific users. Members from one department may not want another department to be able to access their files. Or, one department or group of users should be able to have add/edit permission while another group has read-only permission.
  2. Search and Filter When there are a lot of folders and documents, it can be difficult to find the specific document you’re looking for. Many document management search systems aren’t configured to solve this problem.
  3. Notification and Approval Some documents, like HR policy or invoices, need approval before they can be viewed by all users. Unfortunately, most document management systems do not offer this feature.
  4. Document History Ever make changes to a document, only to need to restore the last version but were unable to? Many users cite the inability to keep the document history and restore past versions a pain point with legacy document management systems.
  5. Team Collaboration There typically isn’t a way for teams to maintain project-specific documents. Projects should be able to be assigned a team that is able to manage the documents among the team members.
  6. Maintain the Folder Structure and Naming Most document management systems will keep the same folder structure and naming conventions across the entire space. This means users aren’t able to organize or name folders in a way that makes sense to them, as those changes are reflected to every other user.

Document-Management-Office365-Hinge-Point

How Core Microsoft Applications Work Together to Support Document Management

SharePoint 

SharePoint gives your team a collaborative workspace with dashboards, calendars, tasks, notifications and updates. The SharePoint platform keeps these located in a central portal associated with company sites. You can set up a SharePoint site for each of your teams to access, with dashboards that give team and company notifications. You can also set up a corporate portal where searchable company-wide libraries and notifications live. Assign each employee a security level to allow access. 10 years ago, businesses used SharePoint for document consolidation, Skype for instant communication, and Outlook for messaging and planning. SharePoint has evolved into a robust document sharing center, with shared workspaces, storage, and presentation.

Document-Management-Sharepoint-Hinge-Point

OneDrive 

  OneDrive is an online document/file storage platform. It’s typically used by individuals and business teams who need a central location to store and access files. OneDrive’s versioning and sharing features make it easy to work together, so it’s more than just an online filing cabinet. Microsoft distinguishes between personal and business versions of the tool. OneDrive (for Business) now contains all of the original SharePoint document offerings, including workflows, auditing, templates and version control. What it does not include are your marketing resources, such as website and social media connections. The business owns the account, and each user is assigned a personal account under the business’s account. This is where individual documents can be produced and stored before they are shared with the wider company audience. OneDrive doesn’t offer the ability to publish your content on the web. While you can email links to documents, you cannot publish those documents directly to a web page from the OneDrive platform. You can make documents discoverable to your team, but you’ll need Office 365 or another CMS/website platform to publish your work publicly.

Document-Management-Onedrive-Hinge-Point  

Azure

Take advantage of fully managed file shares in the cloud that are accessible via the industry-standard Server Message Block (SMB) protocol. Mount file shares concurrently in the cloud or on-premises on Windows, Linux, and macOS. Plus, cache Azure file shares on Windows Servers with Azure File Sync for local access performance. Use premium shares for performance-sensitive, IO-intensive workloads and standard shares for reliable, general-purpose file storage  

Dynamics 365

Dynamics 365 is a cloud-based solution that offers everything you need for CRM and ERP in a single package See business and customer data in one place—across hundreds of sources—for a single, 360-degree view of your organization. Document-Management-Dynamics-Hinge-Point

Microsoft Teams 

Microsoft Teams is designed to consolidate every aspect of collaboration -- not just document management and sharing. Through Microsoft Teams, employees are able to track their instant messaging, email, calendars, projects and more.   Document-Management-Teams-Hinge-Point

Microsoft Planner

Microsoft Planner is a to-do app that comes with Office 365. It’s used for personal and teamwork planning, with a simple card-based interface. Microsoft Planner provides a hub for team members to create plans, organize and assign tasks to different users, and to check updates on progress through dashboards. It also provides a centralized place where files can be shared and visible to the whole team. As an Office 365 app, you can find Planner within your Office 365 home. Planner natively integrates with all of the other Office 365 applications, and using a tool within the Microsoft ‘ecosystem’ is very efficient. Microsoft has created a suite of apps that all complement one another and work beautifully together. Using Planner means you can easily integrate your tasks into Outlook, attach and view task documentation by linking to SharePoint, discuss a project within Teams while having your Planner open, hop onto a video call (with Teams, formerly Skype for Business), and much more  

Benefits of Using Microsoft Software for Document Management

An effective document management solution specifies the following:

  1. What kinds of documents and other content can be created in an organization
  2. What template to use for each kind of document
  3. What metadata to provide for each kind of document
  4. Where to store a document at each stage of its life cycle
  5. How to control access to a document at each stage of its life cycle
  6. How to move documents within the organization as team members contribute to the documents' creation, review, approval, publication, and disposition
Microsoft provides the best solutions for all of the above. The following are the features and benefits of using Microsoft as your DMS partner. It has provided these solutions for many years and is one of the leading companies in this field. With cloud, on-premise, or hybrid, any structure you choose, Microsoft provides a better solution. These solutions and benefits include:
  • Ability to easily find/search for the info you need
  • Mobile-friendly: Create/edit/collaborate any time, any place
  • Overall Security: More secure than an on-premises server
  • Folder and file-level security: Grant access to only the people that need it
  • Compliance-friendly
  • Version control so that there are not different iterations of a file floating around
  • File history so you can see who made what change, when
  • Easy collaboration with coworkers, contractors, and clients
  • Quick and secure sharing inside or outside of the organization
  • Integration & Compatibility: Microsoft’s solutions easily integrate into many other systems
  • Document imaging/scanning lets you save physical space by storing your files online
  • Scalable: It easily grows with your organization. You won’t be able to outgrow it as a document management solution
  • Cloud-based: You don’t have to worry about the physical security of the servers or losing all of your data when everything is in the cloud. Access the files you need anytime, anywhere you have an internet connection
  • Offline editing: if you’re going somewhere without an internet connection, you can easily take your files with you
  • Save on human resources: You won’t need as many IT staff as you would for a legacy, on-site server
 Plus, migration from legacy servers or other solutions is easy.

How HingePoint Helps Our Clients Leverage Microsoft Solutions for Their Document Management Needs

We can help you implement SharePoint as your document storage solution. We’ll design the Information Architecture (IA) based on your unique business requirements. IA covers the required site collections, subsites, document library, metadata, fields and more. [caption id="attachment_15301" align="aligncenter" width="810"]SharePoint with Document Navigation Project Example: Documents in left navigation with Tasks dashboard[/caption] Organize your files into logical categories to help you stay organized [caption id="attachment_15303" align="aligncenter" width="936"]SharePoint Document Categories Project Example: Documents Divided into Categories[/caption]   We take care of creating libraries with predefined metadata to ensure you find the content you’re looking for every time you search and filter. [caption id="attachment_15302" align="aligncenter" width="760"]Search and Filter with Metadata Project Example: Find documents easily using metadata in the search and filter[/caption]   We can implement a workflow that makes it possible to set approval and notifications on certain documents. If you need a team site for collaboration, we can create that. We can also turn that site into a template that allows you to easily create separate spaces for each client or project that keep the same basic structure. If you want to take team collaboration to another level, we can help you integrate Microsoft Teams. Your teams will be able to easily manage all documents related to a discussion in one place and find it easily in the future. [caption id="attachment_15304" align="aligncenter" width="936"]Collaborate with Microsoft Teams Project Example: Using Microsoft Teams to Collaborate on Documents[/caption] Managing documents that relate to project tasks? We can help you add Microsoft Planner to the equation to track the progress tasks. You can easily associate documents from SharePoint with your tasks and tie-in into conversations with Microsoft Teams. [caption id="attachment_15305" align="aligncenter" width="936"]Track tasks with Microsoft Planner Project Example: Tracking Team Tasks Using Microsoft Planner[/caption] Use custom forms to handle team requests and create tabs with custom reports to monitor the overall progress. [caption id="attachment_15306" align="aligncenter" width="936"]Custom Forms and Dashboards Project Example: Custom Forms and Charts to Manage Support Tickets[/caption] As you can see, there are a lot of ways you can streamline your document management processes using Microsoft tools. You can even utilize SharePoint to manage documents you are using to publish content on your website. [caption id="attachment_15307" align="aligncenter" width="936"]Website Content Management using SharePoint Project Example: Using SharePoint as a Content Management System[/caption]

What Would a Better Document Management System Look Like For You?

Does your organization still use a dated legacy document management system to manage your records? Get in touch with Hingepoint today, and see our experienced consultants can make your job easier with a system your users will love!    [post_title] => Building a Document Management System using Microsoft [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => building-a-document-management-system-using-microsoft [to_ping] => [pinged] => [post_modified] => 2021-04-01 09:16:03 [post_modified_gmt] => 2021-04-01 14:16:03 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=15197 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) ) [post_count] => 2 [current_post] => -1 [in_the_loop] => [post] => WP_Post Object ( [ID] => 15344 [post_author] => 3 [post_date] => 2021-01-10 13:05:56 [post_date_gmt] => 2021-01-10 19:05:56 [post_content] =>

Leveling Up Your Business Dashboards with Microsoft Power BI & SharePoint

Microsoft Power BI is a fantastic solution for analytics that helps businesses to extract data and exchange insights within their organizations. It mainly improves productivity by showing immediate results. Using SharePoint without Power BI integration can make business analytics challenging. Doing so is not time-efficient, and it makes it difficult to fetch accurate data. It also lacks reporting visuals that make it easier to see progress. At HingePoint, we make sure you get all the advantages of Microsoft Power BI with a far more tailored approach. This tool can be integrated with Microsoft Office 365 applications, which is convenient for all employees since it is commonly the software companies use for data collection, sales reports, presentation, and more. Using immersive data visualizations, organizations can finally track their progress with this platform.

Why do we need Power BI reports and dashboards?

  1. Data Source (Fetching data in Power BI)
To fetch data from various data source can be the first and foremost challenge that can be faced in Power BI. Our approach: For fetching data of some of the services that don’t support Power BI integration, we have already used API’s of many services to get data in Power BI. (Only applicable for Services that provide API)
  1. Data Validation/ Data Structure
Another difficulty that can be faced in Power BI that is faced is Data validation. We need to have proper data structure so that Power BI can use that data appropriately. If the data structure is not as per the requirements there can be issues faced for fetching proper data as per requirements. For example, fetching data from excel that is not as per the appropriate data structure etc. Our approach: We create data structure that can be directly used in Power BI for making charts.
  1. Attractive designing (Look and Feel of reports)
This is the Key part for any Microsoft Power BI project. Attractive charts and reports as per the expectations are the foremost need of any clients. Our approach: We have already created many Power BI charts that uses color combination as per company logos, company specific needs. Bar charts, pie charts, maps, donut charts, and many more are used to make chart look more attractive.
  1.  Easy search and Filter (ease of data viewing)
Filter the data with ease is another specific requirement. Our approach: We try to maximize use of more filters so user can get ease of accessing more data easily.   5. Auto Refresh (Automatically refreshing charts) Refreshing the data automatically is one of the challenges that is faced in Power BI. Our approach: We configure Power BI desktop to provide 8-time refresh per day. Whereas in Power BI Premium has an option of hourly data refresh.

Enhancing Performance with SharePoint + Power BI

The advantages listed above play a significant role in business analytics. They can all be provided with SharePoint and Power BI integration, but with our services, you can get more to optimize Power Bi’s benefits. With HingePoint, you’ll get accurate data extraction and a more personalized platform complete with company attributes, including a high refresh rate for real-time reporting. If you have more inquiries or want to get started on enhancing your company’s performance, send us a message. We’re always here to assist you with your business needs. [caption id="attachment_15346" align="alignnone" width="822"] Example Project for Customers and Suppliers purchase and sales.[/caption] [post_title] => Leveling Up Your Business Dashboards with Microsoft Power BI & SharePoint [post_excerpt] => [post_status] => publish [comment_status] => open [ping_status] => open [post_password] => [post_name] => leveling-up-your-business-dashboards-with-microsoft-power-bi-and-sharepoint [to_ping] => [pinged] => [post_modified] => 2021-03-24 13:37:32 [post_modified_gmt] => 2021-03-24 18:37:32 [post_content_filtered] => [post_parent] => 0 [guid] => https://www.hingepoint.com/?p=15344 [menu_order] => 0 [post_type] => post [post_mime_type] => [comment_count] => 0 [filter] => raw ) [comment_count] => 0 [current_comment] => -1 [found_posts] => 2 [max_num_pages] => 1 [max_num_comment_pages] => 0 [is_single] => [is_preview] => [is_page] => [is_archive] => 1 [is_date] => [is_year] => [is_month] => [is_day] => [is_time] => [is_author] => [is_category] => [is_tag] => 1 [is_tax] => [is_search] => [is_feed] => [is_comment_feed] => [is_trackback] => [is_home] => [is_privacy_policy] => [is_404] => [is_embed] => [is_paged] => [is_admin] => [is_attachment] => [is_singular] => [is_robots] => [is_favicon] => [is_posts_page] => [is_post_type_archive] => [query_vars_hash:WP_Query:private] => ee44bad485a396e060b32a18dda1cc00 [query_vars_changed:WP_Query:private] => [thumbnails_cached] => [stopwords:WP_Query:private] => [compat_fields:WP_Query:private] => Array ( [0] => query_vars_hash [1] => query_vars_changed ) [compat_methods:WP_Query:private] => Array ( [0] => init_query_flags [1] => parse_tax_query ) )