The Power of SharePoint
Do you have SharePoint Online and want to better automate and streamline your business processes? Have you heard of PowerApps, Microsoft Flow, or Power BI, but you’re not sure how to use them with SharePoint Online? You’ve come to the right place! We’ve written a paper that explores how to build out a basic project-management app based on SharePoint lists and three key technologies that integrate with SharePoint Online: PowerApps, Microsoft Flow, and Power BI. These three technologies are all part of the Microsoft business platform, which makes it easy to measure your business, act on the results, and automate your workflows.
Business scenario
In the paper, the company Contoso has a SharePoint Online site where they manage the lifecycle of projects, from request, to approval, to development, to final review. A project requestor, such as a department head, requests an IT project by adding an item to a SharePoint list. A project approver, such as an IT manager, reviews the project, and then approves it or rejects it. If approved, the project is assigned to a project manager, and additional detail is added to a second list through the same app. A business analyst reviews current and completed projects using a Power BI report embedded in SharePoint. Microsoft Flow is used to send approval email and respond to Power BI alerts. When you’re done with the paper, you will have a cool scenario like the following:
Downloading the paper
You can download the entire package, with the paper and the accompanying files, or you can download individual pieces. After you download, open spo-scenario.docx, and follow the paper. The paper describes the role of the other downloads. Before using the sample apps and report, create your own SharePoint lists and update connections in the samples. For more information, see the section "Task 1: Set up SharePoint lists" in the paper.
-
To download the entire package:
-
Go to the download page, and click or tap Download.
-
Select all the files, then click or tap Next.
-
Click or tap Save or Save As for each file.
-
To download the individual pieces, use the following links:
-
-
-
-
-
Getting started quickly
The scenario we present in the paper is simple compared to a full-blown project management and analysis app, but it still takes some time to complete all the tasks. If you just want a quick introduction to using PowerApps, Microsoft Flow, and Power BI with SharePoint, check out the following articles:
When you’re done, we hope you’ll be back to check out the full scenario. Even within the scenario, you can focus on the tasks that interest you, and complete the tasks as you have time.
Ford Uses Microsoft Cloud to Seamlessly Update Cars
By Sharon Gaudin as written on cloudfortomorrow.com
Ford Motor Co. is moving to automatically update its cars’ infotainment systems using Microsoft’s Azure cloud service.
The U.S. auto maker will begin selling some cars later this year with a computer system that can be automatically updated anytime the car connects to a Wi-Fi network. The cloud-based system is expected to be available in all of Ford’s cars by the end of 2016, according to Don Butler, Ford’s executive director of Connected Vehicle and Services.
The system — the Ford Service Delivery Network — will enable car owners to more easily get new services, even if their car is as much as 10 years old.
Ford is using cloud computing, data analytics and in-car software to change the consumer experience. Now a car’s navigation, entertainment and communication systems will be refreshable.
Previously, Ford’s infotainment system could be updated — but only by bringing the vehicle into a dealership or via a USB stick.
With a cloud-based system, updates to the car’s navigation system, contacts, audio system and center touch screen will be easier.
The updates should download seamlessly, without the driver being distracted – or even aware – of it happening.
“We couldn’t do this without the cloud,” Butler told Computerworld. “It’s really the only way to do it. Otherwise, we’d still need people to make a physical connection either at the dealer or through a stick.”
Other auto companies, including Tesla Motors, will be using over-the-air updates and cloud services to upgrade car owners’ infotainment, safety and powertrains.
Zeus Kerravala, an analyst with ZK Research, said car owners rarely update their in-car systems when they have to drive to the dealer or get a USB stick. The cloud-based service should make it easier for systems requiring updates to work.
“I think it will be something that’s expected eventually,” he said. “Using the cloud is smart as it’s the only scalable way to do real time, over-the-air updates.”
To make this work, Ford is using a hybrid cloud system, which combines the features of a private and public cloud system.
Customer-sensitive data, such as the owner’s name and address, the vehicle’s mileage, its location and how well it’s running, will be stored on a private, on-premise cloud network that was built by Ford’s IT department.
For the public cloud, Ford is using Microsoft Azure, which the company uses for software updates.
Microsoft also is supplying the connection between Ford’s private cloud and the Azure public cloud.
“It’s a flexible solution that lets us tailor it to our needs,” Butler said. “Azure allows us the ability to flex between our own data centers and public data centers. And it’s global.”
That flexibility is the reason Ford’s IT executives chose Azure, instead of another cloud provider, like IBM, Google or Amazon Web Services (AWS).
“We wouldn’t have had that kind of flexibility with AWS or Google,” Butler noted. “You use their cloud as they constructed them. With Azure, we’ve constructed and architected our own service delivery network, and Azure is a component of that network. It gives us the ability to have a solution that bridges their public cloud and our own private cloud. Azure is the plumbing that connects the two clouds.”
Ford also had already worked with Microsoft on its in-vehicle software, so the Redmond, Wash., company came to the cloud job with an understanding of the automaker’s vision and needs.
“It’s important to work with a partner that understands the environment you’re trying to operate in,” Butler said. “Microsoft had that.”
Kerravala said he’s a little surprised that Ford selected Microsoft. “I think Azure versus AWS versus Google is really in the preference of the customer,” he added. “I think most people think of Amazon as being the de facto standard of the cloud, but Azure is a solid choice, too. Azure has Microsoft support behind it and may prove to be easier to grow long term because of that.”
Ezra Gottheil, an analyst with Technology Business Research, said it makes sense for Ford to stick with Microsoft since they have a history of working together.
“As far as picking Microsoft, Ford and Microsoft have been collaborating for a long time,” he noted. “And Azure is a good platform for managing digital assets on a network. Here, it’s really two things — the Azure fabric, which is a software services platform, and the Azure service, which is Microsoft’s hosted version of the platform. Both make sense here.”
About Managed Solution
We're technology enthusiasts with a people-first approach. For over two decades, we've witnessed the profound impact that the right technology and support can have on businesses and individuals. Success, to us, is seeing our clients, partners, and team conquer challenges to achieve their greatest goals and build lasting connections. This relentless pursuit of inspiration drives us forward, pushing us to deliver innovative solutions that empower growth and lasting success.
View Services.
Visualize your VMob data in Power BI
VMob uses real-time contextual analytics to give retailers the ability to create highly personalized marketing campaigns which reach customers at the right time and place. Tracking and exploring your VMob data is easy with Power BI and the VMob content pack. Power BI retrieves your data, including User Statistics, Retail KPI and Campaign Performance, and then builds an out-of-box dashboard and reports based on that data.
This post will provide an overview on how the Power BI content pack helps users explore and monitor VMob data. For additional details on how to get started, please see the VMob content pack for Power BI help page.
Start loading the content pack by connecting to your VMob account in Power BI. Once the content pack is loaded, you’ll see a new dashboard, report and dataset in your workspace marked with an asterisk. Clicking on the tiles will drill into the 4 pages of reports built on top of the data set. For example, selecting the Redemptions by Campaign tile will load the Campaign Performance report which shows details about your campaigns for the last 30 days.
You can hover over any of the visualizations to see additional details about that specific data point. You can also leverage the filters in the report by opening the filter pane on the right.
Navigate between the report pages using the named tabs at the bottom. On each page, you can also switch to Edit Mode, to view all of the tables and fields that are included in the dataset. This mode allows you to add filters, create or modify visualizations and add new report pages. The highlighted tables in the Fields list show where the fields come from for a specific visual.
Any of the visualizations be pinned back to the dashboard to further customize it. When you pin a visual you’re prompted to choose which dashboard to pin to, allowing you to build up a dashboard with tiles from multiple different reports. Each tile can be resized or moved on your dashboards allowing for further customization.
After you initially import the data, the dashboard, reports and data set will continue to update daily. You can control the refresh schedule on the data set as well. The VMob content pack for Power BI helps you visualize and explore an initial set of metrics and reports that can be customized for your scenario.
Microsoft Makes Small Businesses ‘Data Smart’ With Power BI
By David Smith, General Manager of Worldwide SMB as written on Microsoft for Work.
Despite being the buzzword de jour for large enterprises, the concept of “Big Data” is still in its infancy with small businesses. This is because the process of capturing, storing, extracting and analyzing large quantities of data always required far too much in the way of IT resources and technical expertise for the average SMB. But just because SMBs don’t want to maintain servers, hire data scientists and pay for expensive analytics suites doesn’t mean they can’t benefit from business insights hiding in their own data.
Today Microsoft is releasing a new business analytics service designed to help the non-data-scientists among us uncover those insights and make more informed decisions about their business. It’s called Power BI, and it gives people working for companies small and large a straightforward way to analyze and visualize their information.
Power BI Brings It All Together
At its core, Power BI is a centralized hub that allows users to easily pull in, visualize and interpret the vast amount of data that their business generates on a daily basis. SMBs use a wide range of tools and services to run the different aspects of their business. By generating unified charts, graphs, maps and statistics, Power BI allows users to spot trends that would be difficult or impossible to identify by looking at an unorganized assortment of different spreadsheets and dashboards.
The greatest analytics tool on the planet is worthless if it doesn’t provide a simple and reliable way to connect with the information that matters to your small business, which is why we created content packs for Power BI. Content packs provide a way to automatically bring together data from different sources so the full picture can be analyzed in one place. And these connections extend beyond services like Excel or Dynamics CRM, so even if an SMB uses Google Analytics to track website traffic, MailChimp for email marketing campaigns and QuickBooks Online for accounting and payroll they can grab and analyze all of that data instantly (you can find the expanding list of content packs here).
We also know that small businesses aren’t always run from behind a desk. With Power BI apps for Windows, iOS and Android, users can view personalized dashboards and reports anywhere, interacting with their data in a touch-optimized experience.
Power of Data for Small Business
Say you’re the owner of a small online retail shop and you want to run a flash sale on a certain product to a specific set of customers. To do this effectively you need to have access to data that depicts your customer set to gather demographic information, online traffic that shows your most active customers, likely times to buy and historical sales data that shows you what worked well and what didn’t with the last flash sale you ran. Imagine if rather than searching each data set in its respective location and digging through everything manually, you could view all the information in one simple dashboard that illustrates trends and easy-to-spot insights, enabling fast and informed decisions about when to run the sale and who to market it to.
Best of all, you don’t need to learn a whole new set of skills to use Power BI. Power BI uses natural language query technology, which allows you to ask a question like “show me sales data from January to July.” In other words, you don’t need to be a data scientist to get at the information you need.
How Small Businesses Can Use Power BI
We’re often expounding the virtues of the cloud for small businesses because it provides the benefits of large-scale IT without the cost and complexity. Power BI is a fantastic example of exactly how the cloud is leveling the technology playing field for businesses of all sizes. A few years ago this type of solution would have been out of reach for just about every SMB. Now it can be set up in minutes with no up-front costs, making data analytics viable for even a single-person business. In fact, much of the functionality is available for free, without trial period restrictions.
Removing the price and technical hurdles means that many more small businesses will be able to capitalize on the value of analytics as a competitive tool and point of differentiation. Putting your data to use can give you a leg up on your competition. You’ll have real-time insights that allow you to adjust and adapt your business plan, so you can stay focused on what’s really driving results for your company. Basing your decisions on data not only helps you act strategically but allows you to be more in touch with your customer needs.
As an SMB, you have a lot on your plate already and exerting unnecessary time mining through endless data across multiple platforms doesn’t need to be one of them. Power BI makes your life easier and allows you to become more nimble and efficient, ultimately driving more results for your business.
