LiveCycle Designer Links

Some quick links for those starting to work  with calculations in LiveCycle Designer forms. Looking at conducting an online seminar on calculation basics in October 2016. More soon…

Be present when listening

My pick from my Sunday breakfast watching TED Talks is Celeste Headlee: 10 ways to have a better conversation.

My takeaway is: “Be present when listening” I am aware that when listening to trainees tell me about their requirements at the start of a course, I have to resist mentally multi tasking and focus!

Let my dataset change your mindset

While I am on my data analysis kick, I have been watching data related TED talks. This talk by Hans Rosling very effectively explores using data collected over time to understand change and to correct outdated perceptions.

The tool Hans uses is  Gapminder  (follow the link to see and try the software used in this talk). Since this talk was presented some business versions of Excel now have similar functionality.

Ben Wellington: How we found the worst place to park in New York City — using big data

This is an excellent Ted talk about open data, gives practical examples and raises the need for consistent standards for data provided by Government.

There is a follow on discussion needed here about government making data public and in a form where the public can explore it and draw their own conclusions and effectively debate and discuss government plans and proposals.

If you follow this talk back to Ted, you will find a whole set of Data related talks, I recommend the one by Amy Webb.

 

Add data to you Power Pivot using Power Query in 25 minutes

Give me 25 minutes and I will show you how to add data to an existing Power Pivot using Power Query. Add data from Excel and CSV files

Lesson Two

Give me 25 minutes and I will show you how to add data to an existing Power Pivot using Power Query. Add data from Excel and CSV files.

This process is useful if you need to periodically add new data e.g. monthly.

Give me 28 minutes to introduce you to Power Pivot

Make your first step into Business Intelligence tools by using data in Excel worksheets and Power Pivot

Learn how to:
– add to data model
– create relationships
– add calculated columns
– create a pivot table
– see one approach for grouping by dates

Lesson One in a series where I aim to introduce you to the “Power Tools” for Excel 2013 and SharePoint

 

Sharing Information vs Knowledge is Power

Watching the Ted Talk: “Stanley McChrystal: The military case for sharing knowledge” started me thinking about the issues he discusses for the perspective of SharePoint trainer, a trainer and an ex public servant.

A major of theme of this talk is that “the organisation will benefit from ready access to information“.  The burned out leftie in me would extend this to “Society will benefit from ready access to information“. But for the moment lets think organisation.

One of the major potential advantages of SharePoint is to allow exchange of information across silos. For this to happen, site owners and admins need to think about permissions in terms of the organisation not just the unit or  silo they are in. If read access to content is based on the silo and reflect management structure not need or community of interest, then no benefits are gained from collaboration. Wheels are reinvented, mistakes are repeated, solutions and troubleshooting tips are not exchanged.

There are a lot of business cultural assumptions to overcome in sharing. I often get comments that as a trainer I am “giving away all my secrets” or that my YouTube channel is “giving it away for free”. In the modern world however, my secrets are not just mine. Microsoft and Adobe and third parties invest a great deal of effort in distributing information about how to use their products in every medium possible. So my “secrets” can be easily found.  This sharing by these firms makes “Knowledge is Power” obsolete and has a business benefit -Support has a cost – so organisations will use software and other tools with support resources widely available.

I can concentrate on massaging this information to give you context and value but secret it is not. Sharing what I learn also has other values for my little business.

There are other issues raised by this talk, this is just one angle.