Why I changed my mind about #PowerApps and became a fan… and why you should, too

This blog post title was initially titled ‘Why I disregarded PowerApps but now I radically changed my mind’. I changed my mind and I now think that PowerApps is a very powerful tool and basically it does a lot of the app form functions that Access does but way better. I get it now and I want to explain how I changed my mind about PowerApps.

PowerApps performs the same function as Access can do: building the business apps you need and extend or customize the apps you already use. Only, PowerApps does it way better because it has the robustness, scalability, security and performance of the Azure cloud with Office365 inbuilt in the app from the start.

In this blog post, I’ll set out where I think PowerApps fits in the business, and why it’s way better than Access. There are plenty of PowerApps templates but I hope that this post will convince you to give it a try.

TL;DR – I care about producing business-friendly solutions that are maintainable, robust, perform well, have potential for scale, and that I can hand off to an IT support team. PowerApps gives me these things. Access does not because it is not always backed up, or placed on a network so people can update it, and it is not always secured properly. So you can think about migrating your Access apps to Power Apps, for example. In this blog post, we will answer the following questions:

  • What can PowerApps do for you?
  • How do you get started with PowerApps?
  • What I’d like to see PowerApps do next

Any questions, please let me know or get in touch to schedule some time to talk further.


What can PowerApps do for you?

PowerApps allows you to design, create, use and share custom business apps with your team and organization. PowerApps installation means that you can use apps that have been shared with you, and it also means that you can create your own apps.

What kind of apps can you create? Intelligent laziness is very important! The automation of tasks means that you can focus on the activities that are more meaningful and add more value to the organization. If you are leading a team, then it means that you and your team can work wherever you happen to be, on any device.

What kind of apps can you create? Many Access forms could be redone in PowerApps since they involve data entry. Here are some examples:

  • Connect apps to your existing data, such as SharePoint, Salesforce, Dropbox, Google Drive and more
  • Create and update customer invoice, receipt and order forms
  • Create Helpdesk apps
  • Create Expense apps

As a BI person, I have spent time curing businesses from cottage industry Access databases and Access forms. Often, in my experience of rescuing Access databases and forms, I find that they proliferate through the business, usually unmonitored, untested properly and aren’t always production ready. They are often built in an ad-hoc fashion. In short, when I find some Access, I perform an internal sigh and I immediately start to mastermind it’s replacement. Access is often a the sticking plaster to solve a genuine business problem and it is quick to produce something quick. As Brent Ozar puts it, Access has Play-Doh factor. Yes, it’s an old post from Brent Ozar ( b ¦ t ) but it is still holding true.


So when I saw PowerApps at first, my reaction was ‘Oh no, it’s the new Access’. My initial vision was that developers would hate it, and I’d spend my life running around chasing after apps as well as Access to make them production ready.

So here’s what I found:

PowerApps has the IT guardian role built in

PowerApps solves the Access problem of scaleability, robustness and performance. PowerApps is built in Azure as part of Office365 so that means that Azure takes care of these factors for you. For me, this is a massive relief because I care about producing solutions that are maintainable, robust, perform well, have potential for scale, and that I can hand off to an IT support team. When I leave site, I want to leave with a job well done. I don’t intend to be there forever; it’s not what I do. So I like to enable others and bring people on a journey that they can continue without me. So what does PowerApps mean for the small business?


PowerApps for the Small Business 

PowerApps is robust and secure. If you are using Access or Excel to run your business, then you should consider PowerApps. It provides a much more robust way for small companies to track data and projects than Excel or Word because it is in the cloud so you don’t need to worry about losing or screwing up your Excel spreadsheet of inventory, orders and so on. Also, it means that you can be more confident that your data is secure because it is in the cloud, and not on a USB.

PowerApps is mobile. It is also an easy way to mobilise apps as well. The functionality is built in. This is another big win over Access, in my book. This means that PowerApps has the most value added for tracking your organization in terms of projects, budgets, and growth.

PowerApps lets IT do their job more easily. PowerApps will give your IT people an easier way to manage your business-built apps rather than having them hidden on a laptop somewhere. PowerApps lets IT do their job, of being the guardian of the data and the IT function. It’s easy to maintain, which is idea for the organic business user turned power user turned ad-hoc techie. The idea of creating databases and trying to maintain them seems like an unnecessary use of resources; however, for small businesses, PowerApps creates a database for you so you can focus on what you need to do for your organization: managing growth and delivering success.

PowerApps has Play-Doh factor but in a good way. Creating apps in PowerApps allows a business to customize its own apps, thereby streamlining business processes. For example, you can use it to track crucial business information for each customer, including contact information, addresses, order information, invoices, and payments. Since it is in the Azure cloud, team members can access and update it, so the information can stay current and secured. Since the frm is a central idea to Power Apps, this helps small businesses ensure that employees enter data accurately and consistently so your data is cleaner at source.

How do you get started with PowerApps?

At a high level, here are the steps:

  • Choose from professionally designed templates to start quickly
  • Start with a blank canvas, and customize to suit your needs
  • Add business logic and intelligence using the power of Excel-like expressions
  • Create interactive visuals and media to build unique, professional apps

PowerApps is an easy jump for the BI Developer who already knows DAX. To create more custom apps, PowerApps has some object-oriented ‘formula’ that you can change, configure and set. It also has intellisense so you are guided to program correctly.

PowerApps is constantly being updated. For information about what’s new in this release, please see this topic: https://aka.ms/powerapps-releasenotes

Email is a huge part of our lives. How can you set yourself up so you find it easily, when you need it most?

Ever had to provide email for legal evidence? If not, good… but one day, you might have to do that. How will you find it?

Email is serious stuff and you need to look after it. In this blog, I’ll explain how I set myself up with email for a balance of keeping my primary email mailbox small and archiving my email for fast retrieval when I need it. I use Microsoft Office365 archiving, Microsoft Flow and Google Drive to help put together a system I’m happy with.

logo-brightwareSo here is the back story. I used to be an Artificial Intelligence consultant for a small company called Brightware, who were eventually bought by Oracle. My focus was mainly on natural language processing in emails. The idea was that we used algorithms and a knowledge base which worked out the meaning, or the intent of the email message. The Program, known as Answer Agent, would conduct the calculations using the model I’d built.

As part of my work, I learned a lot about Microsoft Exchange and other email systems which were in vogue at the time, such as Lotus Notes, Pegasus and Mercury Transport Systems. In order to split data into training and test sets, I was usually given a huge PST file which I could split out for testing and training my models.

Even after I left the organization in 2002 after a five year stint as an AI consultant, I’ve continued to practice many of the things that I learned in that time. It was great to get fantastic consulting experience with big name companies, and the people that I was working with then, are now in senior positions now as we’ve all ‘grown up’ together. It’s very true that ‘people may not remember what you did or what you said, but they remember how you made them feel’. One contact, who hadn’t been in touch for almost 20 years, got in touch to say that he is a Director of a small AI firm and they needed some extra help with a strategic direction and Microsoft technology roadmap, so he got in touch with me to help them with their growth trajectory. It’s funny how you work closely together, don’t see each other for 20 years and when you meet, the years just roll away.

So, throughout my career, I continued to back everything up to Outlook PST archives; not just for myself, but for people who sent emails as part of my company as well. Email really is a huge part of our lives, and what we email says so much about us: the good and the bad. Having read so many emails over my life, I’m amazed what people will type and commit to email in a professional setting. Email does not belong to you; it belongs to the company, particularly if the company paid for your network, laptop, email account and your time spent reasonably during the working day sending the email. You are what you write!

You never know when it’s going to come back on you, which is where this email is going. Recently, I learned that a former employee of the client was being accused of something illegal. I was summoned to a client that I hadn’t seen for a very long time, as a witness to an internal investigation. Reading the details, I was stunned but I was happy to help, of course. The client needed to get a fair and external understanding of what had happened. I won’t go into details, but the accusation focused on illegal behaviour. Note that I was entirely innocent but I could comment and show evidence on people’s behaviour, and that was my relationship with the issue. I had not been at the client for at least a year, so I really needed to dig back in my memory.

The thing is, we tend to assume that an accusation is the same as evidence, and it is not. It’s the same with gossip; the assumption goes along the lines of ‘well so and so said it, so it must be true’ even though there is no data to support it. With gossip, people don’t tend to go back and validate its veracity over time, and it gets forgotten about but the vestiges still remain. It gets tucked into our mindset as some sort of evidence, which is likely used to support another piece of gossip as it comes our way. We don’t always see the silliness of the gossip, but we do sometimes remember that the gossiper made us feel ‘bad’ so we don’t always remember what they said or what they did, but we remember how they made us feel. So gossip, and accusations with no data, are foundless. They are not evidence.

Fortunately, accusations require proof in the legal system, and I was asked to provide evidence on the behaviour of other individuals. To my relief, I had backed up all of my emails and it was easy to go through them. I could submit them as I had been the cc recipient of some relevant conversations, and this helped to bring the issue to a close.


Credit: https://pixabay.com/en/users/193584-193584/

As a consultant, I run into toxic situations now and again, and these are the situations that help you to grow as a consultant and as a person. I like to believe that emotions should not dictate our decisions, but this can be easy to say but more difficult and challenging to put into practice. Having been an advisor in some internal company cases on racial and sexual harassment has meant that I really have to put my own experiences and feelings aside, and look at the facts. It is a sobering experience, but it means I have to rise to be the leader that I would want to be leading me if I was the focus of these investigations.

I’ve also found two other ways of backing up email using Office 365 and Google. I’m going to lay them out here, and I hope it helps.

Archiving your Email

Why does Microsoft have more than one Archive folder (it seems!), and how are they different? There is the Archive folder and the In Place Archiving functionality. Essentially, the Archive folder in Outlook 2016 is available from your devices, but the In Place Archiving isn’t available on your device in your mail client. It’s that simple. In Place Archiving is for real archive, but you can find email again easily. Plus it keeps your mailbox small, which has got to be good, right?

Archive items in Outlook 2016

The ‘Archive’ folder is accessible on the left hand side of Outlook or through the Archive button in the Delete group on the ribbon. You can move one or more messages to your Archive folder without deleting them. The main benefit is that you can still access these emails on your phone and tablet, so they are still easy to find. Here’s how you do it:

  1. Select one or more messages that you want archive, but still find if you’re looking for them on your phone etc.
  2. In the Delete group, choose Archive.One Click Archiving
  3. You can also use the Backspace key to immediately archive one or more selected messages.
  4. Your message(s) will be moved to the Archive folder. If you archive a message by mistake, go to the Archive folder and move the message back to your Inbox.

Note: The Archive button is only visible in Outlook 2016. Your Archive folder already exists, even if you’ve never used the feature before. If you can’t find it, go to File > Office Account > Update Options > Update Now.

I don’t use this feature, because when I want to archive, I really want to archive. So I use the In Place Archiving Feature instead.

In Place Archiving in Office 365

An In-Place Archive in Exchange Online in Office 365 helps people to file emails by providing additional email storage. It’s not in your device mail by default, but you can find it using Outlook or Outlook Web App.

You can view emails in your archive mailbox and move or copy messages between their primary and archive mailboxes.

Here’s a screenshot from Technet. I’ve used this screenshot since I don’t want to display my own email.


Credit: https://technet.microsoft.com/en-us/library/dn922147(v=exchg.150).aspx

You can find out more by visiting the Technet Site.

What about email attachments? Using Microsoft Flow to archive inbound documents to Google Drive

I use MIcrosoft Flow to automatically store inbound attachments to Google Drive, as a ‘cold storage’ mechanism. I use OneDrive and Google to store data. If, for some reason, I can’t access OneDrive, then I know I can find things in my cold storage.

Google Drive is a file storage and synchronization service created by Google. It allows users to store files in the cloud, share files, and edit documents, spreadsheets, and presentations with collaborators.

To find out more about the Microsoft Flow connector, click here.

You can set up a Flow quite easily, and here’s the page that will take you through the wizard for Microsoft Flow:

Here is the final flow:


I hope that helps you to see how to store email easily. You never know when you, or someone else, might need it badly.

Business Intelligence Barista: Mixing your choice of BI Coffee with Tableau, Power BI or Qlikview?

** Update at 11th March: 
This is not an advert for PivotStream and I am not endorsing their services or solution. 
To show that this blog post is not an advert for PivotStream, I will explore alternatives, which I will follow up in a future post.
In the meantime, you could look at PowerBI and Office 365 with Azure, for example. 
Any questions, please leave at the bottom of this post and I will pick them up. 
I strongly advise people to make up their own mind when choosing a solution but this is blog post discussess some of the factors that you may want to take into consideration, along with other items such as technical support and so on which I do not cover here.

Choosing a Business Intelligence is a bit like making coffee for the whole company. Everybody likes it their way, and they want it right now. Plus, everybody wants it differently. Some want a latte, a cappuccino, or a dainty little espresso so strong that you can stand your spoon in. Some want it hot, some want it with ice, or poured over ice-cream. Some are allergic to milk and nuts, so they have to have special treatment because of the constraints on them. Plus, if that wasn’t hard enough, everyone wants the sprinkles, right? They want the syrups and they might want brown sugar, white sugar, sweetener, Stevia or just plain.  They might even want the pretty little picture on the frothy coffee to make it look nice.
You get the idea, right?

So, given that everyone has different requirements, how do you go about keeping everybody happy? If you think about how hard it is to keep everyone happy when you’re just making coffee, think how hard it is to select a business Intelligence solution. Not just any solution…. the *right* solution. The one that will keep everyone happy and give them what they want. The solution that will keep the ambulance away from the door, where constraints must be met or there will be serious trouble. The solution that will keep everyone out of danger whilst making sure that the sprinkle lovers get their sprinkles, and the folks who like a chocolate covered spoon in their coffee get a little chocolate covered spoon – in milk, dark or white…

This blog is a guidepost for people who ask me the following question a lot: Which BI tool should I choose? Truthfully, chucking a large chequebook at a technology is not going to solve all your Business Intelligence problems. To be honest, that’s like buying a great big coffee machine that might look shiny, but doesn’t actually put the sprinkles on top for you. Additionally, asking consultants and teams of sales people to do a ‘beauty parade’ of BI tools may not be the answer either. Sometimes that is just a way to stave off the decision; we are doing something so we must be doing something right because we look busy.  No-no.

So, here I have taken two extremely well known technologies: Tableau and Qlikview, and put it against a Microsoft Partner PivotStream whom you may not have come across. You may have seen recently that Microsoft are offering a Power BI solution which has the Power BI tools as a standalone option. I haven’t included it here because this technology is still in Preview, and I felt it wasn’t fair to include Preview technology. Instead, I chose PivotStream because they currently offer Microsoft BI Tools hosted in the cloud right now.

Note: These are just my insights. I didn’t tell either vendor that I was going to write this, and ultimately, the opinions are mine. However, I keep getting asked the questions, and if you are looking for a BI tool and are bewildered by the options, this post is for you. I compared on a few metrics: Business Criteria; Data Visualisation Criteria and Technical Criteria

CAVEAT: Here are my thoughts below. I expect that the people who love any of these technologies with a passion will comment, and they are free to do so. I am not saying that this is sanctioned by any of the aforementioned organisations. Instead, it is just the world how I see it, and I may be wrong! If I am, please do feel free to correct me.

Ok, to business. My assessment is at the end of the tables.

Business Criteria

Business Criteria
Microsoft / Pivotstream
Time to implement
RAM Limited
Tableau: virtual RAM
Enterprise Ready
Good for small organisations who can use the cloud option. On its own, Tableau Desktop is not expensive.
Good for medium businesses who might find it more cost-effective to take more licenses. Requirements for very small teams may not be suitable or cost-effective. There is a myriad of product options and it’s not clear how the one or two person team could have a cost-effective option.
Good for SMB
Qlikview is more mature but Microsoft has a much clearer vision than previously. Tableau is demonstrably used in many large organisations, as their customer list shows.
Long-term viability
Fastest growth
Public company
Excel is widely used in the organisation so no adoption is required
Getting free online help?
Tableau forums
Qlikview LinkedIn group
Microsoft online communities
Tableau and Microsoft provide great free online help. Qlikview has its own forum which you sign up for. Tableau has the best free training videos I’ve ever seen.
Getting paid training
The costs vary depending on the courses.
Big Data Support
Above Average
yes, ODBC connectivity to HDInsight
It is on all of their roadmaps. Tableau offers a bewildering number of ways to connect to lots of data sources. However, they don’t connect to PDW very well so Microsoft wins for PDW support. It isn’t clear if QlikView support PDW or not.
Partner Network
Qlikview: 1000+ partners
Small. More direct approach.
Since PivotStream are a younger organisation, their partner network is emerging. Mainly deal direct, not via partners.

Visualisation Criteria

Visualization Criteria
Microsoft / Pivotstream
Eye Candy’ Appear
Tableau blows users away with its beautiful data visualisation. I’ve seen it – I know. It has ‘wow!’ factor.
Data Interactivity
Tableau’s interactivity has improved a lot and hits the mark for a lot of requirements. The scripting requirement in QlikView makes me a bit wary for users. Microsoft’s various reporting tools need to be aligned more, but this isn’t news to them – I am sure it will become easier to get PerformancePoint to talk to PowerView etc. in the future. Small steps in a huge task, which is a side-effect of the sheer range of reporting offerings that Microsoft have in place today.
Visual Drilldown
Very Good
I’d like to see drilldown in PowerView, for example. Excel has a neat drill down feature.
Offline Viewer
Free Tableau Reader
Personal Edition
Excel spreadsheets downloaded
Tableau and Pivotstream offer Excel downloads for offline viewing.
Analyst’s Desktop
Tableau Pro
Qlikview Desktop
Excel is familiar within the organisation.
Dashboard Support
Dashboarding methodologies can be implemented in QlikView and Tableau. Tableau has basic default KPIs but these can be manufactured easily enough. QlikView seem to be popular with finance departments and seem to talk well with them.
Web Client
Very Good
Very Good
Very Good
No real distinguishing factor here. Microsoft has Excel services and we know that business users love Excel!
Mobile Clients
Tableau and Qlikview have an edge on Microsoft for now, but the release of PowerBI for O365 is visibly getting traction and interest in the Preview.
Visual Controls
Very Good
Very Good
Very Good

Technical Criteria

Technical Criteria
Microsoft / Pivotstream
Data Integration
Very Good
Very Good
Tableau integrates easily with Google Analytics for further analysis, but this is not required at the early stages of a BI strategy. You can get extra connectors for QlikView from DataRoket
Tableau Pro
Qlikview Developer
SQL Server Business Intelligence or Excel skills
QlikView has scripting, which the organisation will need to learn. This may incur training costs. If the organisation already has strong SQL Server BI Developer skills in-house, and would not require further training..
64-bit in-RAM DB
SQL Server ‘talks’ to other systems and will output data easily to QlikView and other formats. This is not reciprocated i.e. once the data is in QlikView, it stays in QlikView.
Mapping support
Tableau has Mapping. Excel 2013 has 3D Power Map as a feature within it, and this is interesting for further, future analyses.
Local data files (text, spreadsheet etc.)
Relational databases (SQLServer, Oracle etc.)
OLAP cubes (SSAS, Essbase etc.)
Online data sources
Microsoft’s new Power Query allows you to search online and scrape datasets straight into Excel.
Multi-source access
Multi-table access
Extracted data storage
Optional (proprietary)
Data remains where it is.
Maximum capacity
Billions of rows
In-memory engine
Desktop or Server
Desktop or Server
Tableau reads SSAS and PowerPivot Cubes, but not very well. Tableau and QlikView want to suck the data into their own data models; Microsoft keeps the data where it is, where it is easily accessible by Microsoft and other vendors.
Modeling, Analytics
Below Average
Below Average
Data mining and other capabilities
Microsoft is the winner here for providing a range of modelling and analytics tools such as Tabular model, SSAS. Again, the organisation has experience in these tools so you are leveraging in-house skill sets.
Data Mining
By ‘Data Mining’, I mean true data mining e.g. building neural nets with thought put into it about avoiding jitter, bootstrapping and so on. This is not ‘what if’ scenarios but data science.
Very Good
Microsoft is the winner for multidimensional modelling
xVelocity Support
Microsoft is a pioneer in xVelocity support
PowerPivot Support
Microsoft is a pioneer in xVelocity support
yes, documentation over at the QlikView Community site.
Microsoft open their software up and have APIs available.

The detail is below, but the take-away summary of my thoughts are below:

From conversations with customers, they often want the simplest solution possible. Office365 has previously been pooh-poohed by organisations looking at BI because it introduced a lot of gubbins that people did not want or need i.e. Lync, Exchange and so on. This created a concern amongst the technical people and you can almost read their minds: if the bosses just want a reporting solution, why are they buying something with Exchange? Am I going to be out of a job? This meant that the technical folks were against it, and this reduced the likelihood of adoption or even getting Office365 solutions in the door. Plus, as a guiding principle, people do not buy stuff that they do not need. Fact. With the advent of PivotStream – who simply offer Microsoft BI in the cloud – the antagonism over some of the Office365 story went away.

What will happen to PivotStream now that Power BI in the Cloud is in the offing? I think that they will be fine because they offer one thing which is often key: control over your own cloud deployment. If your PivotStream sharepoint site goes down, then you can wade in yourself and fix it. That might be good for some but not so good for others. For me, that’s the USP.

What about Tableau? I’ve been a Tableau fan for years. It’s a little known fact that spoke at their Tableau European Conference in Amsterdam in 2011, and even had a Heineken with Stephen Few and some of the Tableau team and dataviz gurus (if you haven’t already, read Stephen’s blog. Now. ). Where I think Tableau succeed is that they are superb at what they do: data visualisation. For me, they are the hallmark and the touchstone of where dataviz wants to be, and they are constantly breaking boundaries. However, what they succeed at is something that many organisations aren’t quite ready for; breath-taking visualisations. For some, getting data in and out of Excel is a nightmare and they are simply not ready for it. For these people, Office365 or PivotStream are perfect.

What about QlikView? They are beloved of financial departments but I am not sure that they talk so well to IT departments. For me, the fact that there is scripting involved is an issue. If it is self-service Business Intelligence, it should be as easy as possible. In my opinion, they are a bit Marmite as we say in the UK; you either love them or you don’t. There is no half-way house. From my perspective, I hear both sides but I don’t really see QlikView fanboys the way that we see Tableau fanboys.
To summarise, sorting out user requirements is key. There is no wrong choice, if it is the right choice for your organisation. However, any technology is a bad choice if it isn’t the right choice for your organisation. Look past the flash, and see what is really right for you.
 /*** Late Breaking News ***/
My apologies: I put Tableau API as None but that isn’t correct.
I’ve fixed the table, and here is a pointer to the Tableau documentation on the JavaScript API. Thanks to Andy Cotgreave for the spot!
By way of apology, here is the Tableau API in action, done with the panache and fun you’d expect from a Tableau video.

/** Even Later breaking news *//

Sorry QlikView team! My humblest apologies. Apparently QlikView *DO* offer an API and you can find information on it here.  Quote from the site (I’m not repeating a sales pitch or commentary here, this is just straight from the community site)
The QlikView Software Development Kit is the home of the QlikView Software Integration toolbox. It includes sample code and the Application Programming Interfaces  (APIs).

Note: More content will be added in an ongoing basis.
In my defence, the comments at the foot the QlikView community page are riddled with comments from people who can’t find this or that, or don’t know the status of stuff, and then get supplied by links from other people. I’m guessing that I am not the only one who doesn’t find the information very easy to find on the community site then.
So here is the link http://community.qlikview.com/docs/DOC-2639 and I have updated the table.

Power Business Intelligence for Office365 – resolving the Scylla and Charbdis dilemma.

People have often complained about the fragmented methodology that seemed to accompany Microsoft technology releases. I see this as a manifestation of the Syclla and Charybdis problem – people complain if they don’t release everything as a unified whole, or complain that things take a long time to deliver. In other words, Microsoft never seem to win and seemed to be required to take one choice or another, with neither outcome pleasing everyone. I’ve commented before that it often seems that Microsoft can’t win whatever they decide to do, and here is an example blog and commentary here.

From today’s announcement, it seems as if things are coming together and Microsoft are indeed winning. This news includes a mobile business intelligence deliverable. As you know, business users love Excel and it made sense for Microsoft to put Excel at the heart of their business intelligence strategy. For those who skim read, the main point is that the Microsoft Business intelligence strategy is coming together, and now that Microsoft are delivering a user-oriented Business Intelligence solution with mobile functionality (yes, even iPad!) that hopefully a lot of the heat will have gone away and Microsoft have resolved the Scylla and Charybdis problem by producing something very special and useful for business users.

So what has been delivered? Today at the World Partner Conference, exciting news was released about this very topic, with the news that Power BI for Office 365 has been released.

Power BI for Office 365 is a self-service business intelligence solution surfaced to users through Excel and Office 365. Essentially, business users can get Excel-happy with data analysis and visualization capabilities to identify deeper business insights.  The data can be held on-premise or within a trusted cloud environment. Excel, in other words, becomes the front end for allowing business users to have fun with their data.

What does Power BI for Office 365 mean for ordinary users? With Power BI for Office 365, customers can connect to data in the cloud or extend their existing on premise data sources and systems to quickly build and deploy self-service BI solutions hosted in Microsoft’s enterprise cloud.

Power BI for Office 365 enables customers to do more with their data:

  • Analyze and present insights from data in compelling visual formats either on premises or in the cloud from Excel. 
  • Share reports and data sets online with data that is always kept up to date. 
  • Ask questions of your data using natural language search and get immediate answers through interactive tables, charts and graphs. 
  • Access and stay connected to data and reports from your mobile devices wherever you are.

I’m very happy about this announcement because it’s what customers have been waiting for. My customers have been asking for this for years, and now it is almost here, customers will see things fall into place. Excel is the way forward for Microsoft Business Intelligence: hence, PowerView, Data Explorer (now Power Query) and Geoflow (now Power Map) are now part of the Office 365 story. And what a story!

The truth is that the majority of BI work is done in Excel, and I think Microsoft are just bringing everything home to where the Business Users do most of their work. It’s about working with the Excel users, and giving people opportunities to work with other data that are outside of their internal business walls.

You can sign up for can visit http://www.office.com/powerbi on Monday, July 8 to sign up to be notified when the preview of Power BI for Office 365 is available later this summer. I’m heading over to do it now, and finally I can give my customers the answers they’ve been looking for.

Goodbye Scylla and Charybdis 🙂

Odysseus vor Scilla und Charybdis by Johann Heinrich Füssli

Office365 Getting rid of Custom Theme Images in External Sites

If you are using Office365, you probably want ‘quick and easy’ wins in order to make your external site look better. At Copper Blue Consulting, we use Office365 for our email, web hosting and our Sharepoint activity. The current blog series will look at some of our findings which we’ve used in order to improve the appearance of our Office365 site.
I know that the Copper Blue site needs some love and attention, and now that SQLBits, SQLRelay and SQLPass is out of the way, I hope that I can start to make our corporate website look, well, corporate.
First thing on the list was to get rid of the theme header logo on the top right hand side. These are automatically added when you select a theme in Sharepoint.  If you’ve set up an external website in Sharepoint, then the configuration items are quite clearly laid out in the ribbons. Here is an example here:

Themes in Office365 1

We can see that none of the themes are blank, but each has a little picture somewhere. On the Copper Blue site, I just want a plain header with a logo. Nothing more, nothing less. How do we achieve this?

When we open up the Site in Sharepoint Designer, we notice that there are custom images in the Office365 structure. I wasn’t able to delete these. However, I was able to amend the file. Therefore, I navigated to the offending image and clicked on ‘Edit File’. You can see the structure in the following image:

Themes in Office365 3

Since I couldn’t delete the image, I decided instead to simply blank it out. Here is the editor for changing the image:

Themes in Office365 4

On the right hand side, you can change the brightness. I simply made it pure white, so that it matched the header of the site. I know that this is a ‘fudge’ but it gave me a quick easy win in terms of getting rid of the annoying logo, that didn’t sit with the rest of the branding.
If anyone has other ideas on how to do this, I’d be glad to hear them. In the meantime, more adventures of Office365 will appear as I move the Copper Blue site from being very Sharepoint looking, to something that’s much more customisable. If you want to see the end result, then please do look up the Copper Blue website to have a look!