The new Power BI ArcGIS Maps provides
you with the ability to build beautiful maps using your data within Microsoft
Power BI. It works with all three versions of Power BI: Free, Pro and Premium.
This release to be defined by the four key updates:
Enterprise support is now generally available
With this release of Power BI, when you click on the ArcGIS Maps for Power BI visual within Power BI, you will now see three connection options:
The ArcGIS Enterprise and ArcGIS Online options are for users who have the premium app subscription and provides all the capabilities of Standard and extra capabilities, including additional geocoding, technical support, and access to mapping reference layers, and more. The Standard option is free and provides basic mapping capabilities.
Enterprise support available
ArcGIS Enterprise support was released as a public preview. This means that all ArcGIS Enterprise 10.7.1 and above users can connect to their organization’s Enterprise account and use their secure GIS data in dashboards and reports within Power BI. To get started, you would need the ArcGIS maps premium subscription, and then just connect to the ArcGIS visual within Power BI and start mapping.
Support for Multiple reference layers
The premium app users can now add multiple reference layers to a single map visualization within Power BI. A reference layer is information represented on a map. It adds context to your operational business data. For example, let’s say you have mapped your store locations in Power BI. You can now overlay it against reference layers such as income, age, competitor locations or other demographics to gain valuable insights. You can add data and layers that are published and shared online by the ArcGIS community as well as layers from your ArcGIS Online or ArcGIS Enterprise organization.
New Table of contents
A new table of contents that will help the ArcGIS Maps for Power BI users (free and premium) better visualize their data on a map. Now, when you drag data to a location field well and see it on a map, you can also see a table of contents that lists all the layers on the map and shows the features represented by the layers. This allows your report viewers to quickly understand the data that they are seeing.
PM Narendra Modi declared a three-week nationwide lockdown starting midnight Tuesday, explaining that it was the only way of breaking the Covid-19 infection cycle. This essentially extended the lockdown from most states and Union Territories to the entire country and provided a more definite timeline. “Social distancing is the only way to break the cycle of infection,” he said.
All other lockdown conditions, such as the availability of essential commodities, remain the same, the government clarified.
In
his second address to the nation on the Covid-19 outbreak, Modi told people to
stay inside their homes for 21 days, warning that if they didn’t do so the
country would be set back 21 years and families would be destroyed. His last
address was on the outbreak was on March 19.
“This is like a curfew, and far stricter than the ‘Janata Curfew’ (on March 22),” the PM said. “Seeing the present conditions, this lockdown will be for 21 days. This is to save India, save each citizen and save your family. Do not step outside your house. For 21 days, forget what is stepping outside. There is a Lakshman Rekha on your doorstep. Even one step outside your house will bring the coronavirus inside your house.”
The World Health Organization has declared the coronavirus, or COVID-19, a pandemic. It’s an uncertain time with lots of unknowns, and while we don’t have all the answers, we want to share what we do know and offer some guidance for our customers and other small businesses that may be experiencing shifts in their business.
This pandemic is affecting the health of the public, and it’s also impacting the economy. According to Google, “since the first week of February, search interest in coronavirus increased by +260% globally.” While spikes in search trends are common during events of this scale, there have also been surges in traffic for related products and topics as a direct response to the pandemic.
Over the past week, remote working has quickly gone from a company-specific arrangement to city-wide and, in some cases, statewide emergency policy as local governments across the country scramble to contain the spread of Covid-19. As of this week, major cities across the India., including Bengaluru, Delhi and Heydrabad, have either initiated or are considering the shelter-in-place mandate, urging residents to work from home and stop all nonessential travel. It may be nice to avoid commuting and work from your living room couch every once in a while, but how, in the long run, this sudden change could affect productivity, morale and even job security, is an unsettling question to both employers and employees.
“It’s nobody’s choice to work from home [in the current situation]. Day one is probably easy and nice. Day 20 can be pretty hard. And no one knows what it will be like if this goes on for two months,
Here are a few tips from Golden to make working from home successful, based on his own experience running a remote working company:
1) Establish a dedicated work space. Working from the kitchen table or couch might be easy, but setting up a dedicated desk will make you happier and more productive.
2) Establish a morning routine and stick to it. Just because you are working remotely doesn’t mean you don’t need to get ready in the morning. While some people enjoy working in their pajamas, many find that getting ready like they were going to the office helps them maintain focus and work effectively.
3) Make sure your tech works. Invest in reliable internet access and a good router, and be prepared to use your phone as a backup.
4) Create an online “small talk” space with coworkers. Create general conversation slack channels, spend some time making small talk in our video calls and meetings, and generally put an emphasis on getting to know each other
Posted in Blogs,
The new Power BI template apps enable Power BI partners to build Power BI apps with little or no coding, and deploy them to any Power BI customer. This article is an overview of the Power BI template app program. Template apps are a replacement for the current service content packs. As a Power BI partner, you create a set of out-of-the-box content for your customers and publish it yourself. You build template apps that allow your customers to connect and instantiate within their own accounts. As domain experts, they can unlock the data in a way that’s easy for their business users to consume.
The Omnichannel Insights for Dynamics 365 supporting Chat, Bot, and SMS channels is now generally available. Omnichannel dashboard helps supervisors with insights on operational metrics across different channels, queues, bots, and agents. It also uses AI to provide in-depth sentiment analysis to help supervisors take actions to improve customer satisfaction.
This template app has two dashboards and six visually rich report pages with filters for supervisors to get a summary on how their organization is engaging and connecting to their customers through Omnichannel for customer service.
The Customer Service Analytics for Dynamics 365 is now available in power BI, which provides information about the historical operational metrics and KPIs to effectively manage contact centres. With this release, you can also download the Power BI reports and customize them to your organizational needs.
Microsoft Forms Pro is an enterprise survey capability that helps businesses obtain the feedback they need to make smarter decisions. It enables you to collect feedback using surveys and connect the survey response data with the business data to obtain meaningful insights.
If you are using Forms Pro to collect customer feedback after a case is resolved in Dynamics 365 Customer Service, you can automate the feedback collection and association of survey response data and case data using Power Automate. The Forms Pro survey response data with be stored in same Dynamics 365 organization along with your business data. The Forms Pro Customer Satisfaction app will enable you to get analytics combining survey data and case data. To connect to the Dynamics 365 Customer Service instance, you will need to provide the URL for your organization and the credentials for authentication.
This app template brings together the survey feedback and Dynamics 365 Customer Service data into a 3-page report to provide great out-of-box experience for customer service managers.
The first page contains overview of the survey response data and provides metrics like NPS, NPS trend, word cloud of the customer verbatim phrases, and number of surveys invites and responses. It also provides NPS distribution with respect to the different case parameters like location, case priority, case origin, case type and product.
The second page provides an agent-centric view of the satisfaction data. This page will help customer service managers to analyse an agent’s performance based on the survey responses. They can view how the customer service agents are performing and what feedback the customers are providing about them.
The third page provides customer-centric view of the satisfaction data, which shows the satisfaction rating trend for the customers and their feedback.
Posted in BI, Tagged Power BI, Power BI New Update, Template Apps,
Azure Data Factory is a cloud-based data integration service that allows you to create data-driven workflows in the cloud for orchestrating and automating data movement and data transformation.
Azure Data Factory does not store any data itself. It allows you to create data-driven workflows to orchestrate the movement of data between supported data stores and processing of data using compute services in other regions or in an on-premise environment. It also allows you to monitor and manage workflows using both programmatic and UI mechanisms.
Azure Data Factory (ADF) is a service. It used to transform all their raw big data from relational, non-relational and other storage systems and integrate it for use with data-driven workflows to help companies map strategies, attain goals and drive business value from the data they possess.
Let’s take an example, there is an organization who have lot of data on premise. The data has store across multiple databases like oracle, MYSQL, SQL server and also, there are flat file data like nothing but log files and auditing data. As an organization of rapidly expanding the data of volume and also increase exponentially. To meet the demand of exponentially data volume that organization decide that move to data centre all databases to cloud for get all the benefits of flexibility, scalability and show on.
To transfer or perform the data to cloud the organization has follow the process:
The Data Factory service allows you to create data pipelines that move and transform data and then run the pipelines on a specified schedule (hourly, daily, weekly, etc.). This means the data that is consumed and produced by workflows is time-sliced data, and we can specify the pipeline mode as scheduled (once a day) or one time.
So, what is Azure Data Factory and how does it work? The pipelines (data-driven workflows) in Azure Data Factory typically perform the following three steps:
By using Data Factory, data migration occurs between two cloud data stores and between an on-premise data store and a cloud data store.
Copy Activity in Data Factory copies data from a source data store to a sink data store. Azure supports various data stores such as source or sinks data stores like Azure Blob storage, Azure Cosmos DB (Document DB API), Azure Data Lake Store, Oracle, Cassandra, etc. For more information about Data Factory supported data stores for data movement activities, refer to Azure documentation for Data movement activities.
Azure Data Factory supports transformation activities such as Hive, MapReduce, Spark, etc that can be added to pipelines either individually or chained with other activities. For more information about Data Factory supported data stores for data transformation activities, refer to the following Azure documentation: Transform data in Azure Data Factory.
If you want to move data to a data store that Copy Activity doesn’t support, you should use a .Net custom activity in Data Factory with your own logic for copying data. To learn more about creating and using a custom activity, see Use custom activities in an Azure Data Factory pipeline.
Posted in Blogs, Tagged Azure Data Factory,
Microsoft has unveiled a feature summary for the December update to Power BI Desktop. The highlights this month include some amazing features and bunch of them are preview features, which are not only helpful but very promising, these include customizing & exporting current themes in Power BI, the all new decomposition tree visual with a lot of formatting options, Automatic page refresh for Direct Query details, bullet charts and much more.
The formatting of new decomposition tree visual with many more formatting options this month.
The new options include.
xViz has added four new visuals to their suite. As a reminder, xViz is a package of visuals with highly advanced formatting and configuration capabilities. You can use the basic capabilities for free or purchase a license that will give you access to all the visuals for one price.
The hierarchy tree visual lets you display hierarchical data in a visually appealing tree view. This visual is similar in layout to our decomposition tree, but it allows you to compare two measures, such as budget and actual, and see the variance between them.
When your tree extends beyond the viewport, you can now continuously pan with zoom control and even a mini map to help you navigate.
You can also search for nodes with the search box in the top right, which helps when the tree is quite large.
Optionally, for each child you can also see the number of nodes that haven’t been expanded out. You can conditionally format the nodes based on the values displayed in them, and you can even control the look and precision of the values with advanced number and semantic formatting. The connector lines, the font formatting, and background and node colours can also be controlled through the formatting pane.
For example, we used hierarchy tree visual for stock Analysis report where it is describing about stock on hand (SOH) Metric. It is explaining both category and brand wise SOH. We are showing the particular category with brand name and SOH that we are analysing the highest and lowest SOH.
Posted in BI, Blogs,
