Tech Tip Thursday: Dynamic Power BI reports using Parameters

Did you know that you can dynamically filter data in Power BI using parameters that are stored in an Excel workbook? In this video, Patrick from Guy in a Cube shows us how, using M Functions within Power Query and a gateway to enable data refresh. Check it out!

from Category Name https://powerbi.microsoft.com/en-us/blog/tech-tip-thursday-dynamic-power-bi-reports-using-parameters/

Marketing, Data and GDPR – What You Need to Know

In May 2018, the European Union will bring a new set of regulations into force on data privacy. The regulations have been discussed for years and will replace the current rules that are in the Data Protection Directive in the EU (the UK will need to adhere to this for any transfer of data from the EU).

GDPR - blogThese regulations will be supported by the Information Commissioner’s Office and will have a big impact on all companies that have customers in Europe. However, many marketers are either not aware of their new responsibilities, or they think compliance is solely an IT problem that won’t affect them.

What are these regulations and what do those in charge of customer data need to know?

The General Data Protection Regulation (GDPR for short) covers how personal data should handled. This includes how individuals should be informed on how their personal data will be used, how individuals provide consent for its use (“freely given, specific, informed and unambiguous” consent; so no more implied consent or opt-out), and that individuals should always have control over data about them. While much of this is not new as the EU Data Protection Directive covered this area, the GDPR adds more requirements, clarifies others and as a set of regulations provides a greater force of law.

The GDPR clarifies how to determine if information that you collect or process is personally identifiable. This provides organisations with greater clarity on what should be protected. It also clarifies that it’s not just about the information you hold, but the information that might be held downstream or in the public domain (i.e. can the combination of what you know and some other source be used to identify an individual).

There is also a category of ”sensitive personal data” that has additional requirements on the collection and processing of the data. This category requires “explicit” consent for its collection and use – a checkbox in the browser is not sufficient. As with the EU Data Protection Directive, this includes racial or ethnic origin, criminal record, membership in a trade union, political opinions, religious beliefs, and sexual preference, but in addition the GDPR adds genetic and biometric information.

Additional significant changes include the potential need for a Data Protection Officer with sufficient resources, executive access, and independence, and potentially large penalties (up to 4% of turnover or 20M Euros) for failure to comply with the GDPR.

All of these changes – and the increase in penalties – aims to minimize the use of personal information by businesses. Where this data is necessary, businesses should use techniques to minimise the risk of breach or misuse of the data. These include the use of encryption, anonymisation, and/or pseudonymisation.  Tokenisation is a form of pseudonymisation.  Anonymisation is best left to data scientists. All of these techniques are mentioned and encouraged in the GDPR.

Given how important data analytics is to marketers today, it’s critical to understand how GDPR will affect how you run analytics programmes over time.

For analytics, the availability of data is paramount. The more insight that you can get into customer behaviour, the more likely it is that you can get accurate forecasts and insights into other customers and prospects. Using this information can help with customer-experience services and recommendation services.

However, determining what is personally identifiable information and if the individuals have properly consented to it use can make this more difficult to run in practice. I always recommend that data collectors validate that they actually need to collect and process personal information, or pass it on to a third party for additional analytics. In the case of passing it on to a third party, any onward transfer requirements have to be validated to meet all necessary security and privacy requirements.

Running analytics programs

For marketers, getting initial consent on use of data is one hurdle. However, other issues such as the use of third-party data, and data deletion over time, also have to be considered. Putting the right processes in place for how you acquire and manage data should therefore be a priority.

To get this started, collaborate with your internal data privacy team. This will mean looking at your vendors to ensure that the appropriate legal language for data security and privacy is in place within your contracts. This is a requirement if you are transferring data to those vendors to process, even if they are not viewing it or sharing it.

Next, look at your approach to delivering analytics. Are you making use of marketing analytics services that take your customer data and provide results back to you? If so, you’ll have to check that they meet all these data protection requirements. Many suppliers are based outside of the EU, so be aware of the appropriate legal frameworks such as the EU-US Privacy Shield, EU model clauses, and binding corporate rules (BCR). These may change over time based upon legal decisions, such as the invalidation of the US-EU Safe Harbor framework by the European Court of Justice.

Awareness of where your data might be transferred should be a priority. It’s possible to run your own analytics services in-house, on a private cloud, or via public cloud services, so check how these options might fit with your own requirements on data privacy specifically related to requirements for onward data transfer.

Finally, be aware of how the right to remove consent for use (opt out) might affect your use of the data. Putting an appropriate plan in place, from the start, on how to remove customer records can help you in the longer term.

As more companies utilize data for helping make marketing decisions, the role of analytics will become more important. Making sure that your approach to analytics meets the necessary guidance on data security and privacy will therefore be essential.

This article was originally published in My Customer on April 25, 2017.

The post Marketing, Data and GDPR – What You Need to Know appeared first on Birst.

from Blog – Birst https://www.birst.com/blog/marketing-data-gdpr-need-know/

Tech Tip Thursday: Dynamic Power BI reports using Parameters

Did you know that you can dynamically filter data in Power BI using parameters that are stored in an Excel workbook? In this video, Patrick from Guy in a Cube shows us how, using M Functions within Power Query and a gateway to enable data refresh. Check it out!

from Microsoft Power BI Blog | Microsoft Power BI https://powerbi.microsoft.com/en-us/blog/tech-tip-thursday-dynamic-power-bi-reports-using-parameters/

New Windows 10 Devices, Microsoft China event, and more | This Week On Windows

This Week on Windows we’re getting ready for summer with some of the hottest new devices, TV show season premiers and sales on some killer apps! Plus we’ve got the latest from the big Microsoft Event in China!  Other topics discussed in this episode include:

  • New Windows 10 devices
  • IAP Sale
  • Casual Season 3 on Hulu
  • John Wick Chapter 2
  • COMING UP: Netflix/War Machine + House of Cards
  • Microsoft China event

 

from Channel 9 https://channel9.msdn.com/Shows/This-Week-On-Windows/New-Windows-10-Devices-Microsoft-China-event-and-more

Better Government Depends on Legacy Modernization

In 2016, the Government Accountability Office, a US government watchdog, published an account of the oldest government IT systems. The average age of those systems, which handle things like our nuclear forces, our weather satellites, and incidents involving hazardous materials, is 49.8 years. The oldest system, at 56 years old, is the Internal Revenue System […]

from MuleSoft Blog https://blogs.mulesoft.com/biz/industries/better-government-depends-on-legacy-modernization/

Digital Transformation: It’s not a question of “If”, but “How?”

Market, technology and legislative trends have created digital transformation needs across industry verticals. The mandate for digital transformation is clear – the question that IT leaders must answer is not “If“, but “How?“ At MuleSoft, we believe that connectivity is a core to answering that question. True transformation comes not from the implementation of any single […]

from MuleSoft Blog https://blogs.mulesoft.com/biz/industries/digital-transformation-banking-retail-healthcare/

Google Now Tracks Your Credit Card Purchases and Connects Them to Its Online Profile of You

The search giant wants to know how online ads translate into offline sales, but says it is taking steps to ensure users’ privacy isn’t breached.

from Mobile – MIT Technology Review https://www.technologyreview.com/s/607938/google-now-tracks-your-credit-card-purchases-and-connects-them-to-its-online-profile-of-you/