it en ms fi da da da da ca da en da ms hbs_lat ms ms ms en da da ms ms da es da de ro en da da da da de da da de en it da da da es da da en da da da en da sv de da en da en en en en en da pt fr fr en de en sv da da da da sv da da hbs_lat en da sv en it en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en da es en en en cs hu da da da en da ms en en en sv da fr da it de en ms ms en it da da de en en en sv da en da en da da en da da da hbs_lat da de de de el de en en tr en en en en en en en es es fi fr fr fr fr hu it it ja ko da nl nl pl pt pt ru sv th tr zh zh ar he
Partnere | Microsoft Power BI
Office 365 + Power BI
Power BI offers many advanced functions for data analytics. It is very helpful wherever there is a need to organize many data and present them in te form of transparent reports.  And our customers do not have to be an expert to use it. This is a huge advantage in comparison to te standard analysis made in Excel.
Predica built a companywide analytical reporting tool that anyone in te company, where was it implemented, can use without extensive training. It’s very intuitive and allows to build very advanced visualizations.
One of our customers, large manufacturers of pharmaceuticals in Polen, wanted to know which marketing actions are te most effective. Their distribution network covers te markets of Central and Eastern Europe, te Caucasus and Central Asia. With a long history on te market, they are a trusted partner for patients, healthcare professionals and business associates.
Conducting marketing activities on te regulated pharmaceutical market is a challenge, yet nobody can avoid it in a highly competitive environment. In this case a lot of parameters and data had to be analyzed, so easy to use tool was mostly desired.
• Sales and marketing predictive analytics, i.e. a what-if analysis that shows how different marketing activities impact sales and revenue in te short and long term.
• Recommendations on how to allocate te marketing budget and how to optimize te media plan (te way te company is cooperating with media agencies), taking into account seasonality and other factors.
• Use of external and unstructured data to understand how factors such as weather or pollen (allergen) conditions impact sales and thus should impact marketing activities.
Predica designed and developed a fully extensible platform based on Azure Machine Learning and some on-premises components, such as SQL Server Integration Services and SQL Server Master Data Services that allow our client to gather, manage and improve their internal and external data, and apply advanced analytics. We used Power BI to visualize te data to business users.
Some of te solution’s key features that allowed our client to meet te project goals included:
• Automated data loading process with tools for business users to manage master data.
• Marketing campaigns based on recommendations and what-if analysis.
• More accurate sales and revenue forecast.
Every organization is made by people. People who interact with each other – over morning coffee, in meetings during te day and at casual catch-ups in te workplace.
Nowadays, this communication also happens in electronic form, through e-mail, phone, instant messaging or social media. This form of interaction gives us a great opportunity to analyze te data and pick up additional insights.
Our customer has implemented Yammer as a social network within their organization. Once it was put in place, te questions started to rise. How are people using it? Who is te most active user on a given topic? Who is te focal point of conversations on this network?
All data is there in te form of users communicating on a platform, however, what was missing was an easy way to consume data from these interactions. Te good news for us and our customer was that there are APIs and ways to consume it through te cloud.
Te goal was to build a solution that provides insights into te company’s social network interactions.
Yammer provides a Rest API which allows us to consume its content and get all te messages and interactions from its channels. To achieve our goal, we had to find a way to:
• Ingest this data into some common database.
• Analyze this data based on assumed metrics.
• Present it to business users in an easy way.
Te Azure cloud seems to be te best tool for a job. Solutions don’t have to be complicated and always created in complex, customized ways. Instead, even elaboration applications are built on top of platform components and enhanced with some additional code and extensions. We can construct these solutions on top of platform services. Te key is that there is no need for servers – it’s just platform services and our code.
Here, we have used te following elements of te platform:
• Azure Functions: a serverless code execution piece of Azure. It allows us to execute code for data ingress in an easy and efficient way. Its purpose is to import data from data sources into te common storage
• Azure Storage: an intermediate data store for files and data which is later processed
• Logic App: te KEY element of te solution. Logic Apps implement data ingress and processing logic, and then orchestrate te entire flow.
• Azure Cognitive Services / Text analytics: used to detect te sentiment of te messages on Yammer
• Azure SQL Database: provides final storage and data warehouse where we store te information gathered from Yammer. It also takes part in data processing with stored procedures
• Power BI: offers an easy to use and navigate te presentation layer.
In te solution there is te crucial component of it –Azure Logic App
Azure Logic App is an integration platform which allows you to build complex integration workflows between different data sources and platforms with additional logic added to them.  We have built a flow we’ve built to analyze te sentiment of te messages posted on Yammer using Azure Cognitive Services.
Getting data is one thing but getting te right insight and providing it at te right time for users – that is a completely different task. Even te best data is not so useful if there is no way to analyze it easily. We understand this business need, and we have te tool to address it – Power BI. Using Power BI, we are providing easy to consume and navigate dashboards presenting data gathered from Yammer.
Se flere verdensklasseløsninger skræddersyet til din virksomhed
Vil du være Power BI-partner?
Certificerede partnere er en vigtig del af teamet! Find nye forretningsmuligheder, skab forbindelser, og del dit firmas talent og erfaring med Power BI-brugere i hele verden.
Få mere at vide
Beskyttelse af personlige oplysninger og cookies