Love Like a Sunset
for the love of data…

Mar
13

Windows10WifiSettingsTo my Windows 10 Brothers and Sisters – who likes to use their Windows 10 device on a Tether internet connection?  For a few months I’ve been blaming poor home broadband bandwidth on the kids, when it was…. moi:/   Clue was the 8Gb mobile data plan getting chewed up within weeks of end of month.   Then it was the 3rd Telstra dude, who noticed uploads unusually high.  Checked the System tray and noticed OneDrive uploading 16Gb…  Let’s tackle the first problem… mobile data plan…, in Windows 10, go to Settings, search wifi, find Change Wifi Settings, click Advanced Options, and here specify a metered connection.  Google it, Bing it, Do it, you won’t regret it.   You will need to do this on your tethered wifi connection first, but also any other wifi connections where you want to reign in bandwidth on a limited or slow connection.  Second problem, OneDrive…  Find the OneDrive icon Windows10WifiSettingsMetered.PNGstatus in your System Tray… If you see your OneDrive is uploading Gbs of data, these uploads will be limiting download capacity on the pipe.  Right click the OneDrive icon and exit.  Start it up again and let it breathe before you go to bed.

Closing note: When a wifi connection is set to metered, any app that relies on an Internet connection to update or display info might be limited in the amount of data it can download or display. You might notice these and other effects:

  • Windows Update will only download priority updates.

  • Apps downloading from the Windows Store might be paused.

  • Start screen tiles might stop updating.

  • Offline files might not sync automatically.

Feb
18

So my Surface type cover recently stopped responding right before a demo to a prospective employee about how cool Microsoft is… Tried the usual stuff, pull off the type cover, reattach, grab coffee.  Solution was to power down, then restart by holding power plus the up volume button for about 10 seconds… Continue holding as it starts… You are taken into BIOS. Exit and save the bios, then low and behold the type cover works again after restart.  Thanks to the heavily and tastefully tattooed person at Harvey Norman for this trick.  Other Type Cover tricks here… https://www.microsoft.com/surface/en-au/support/hardware-and-drivers/troubleshoot-surface-keyboards?os=windows-10

image

 

 

Jun
07

Sync your SharePoint Online Team Site with your OneDrive easily with the SYNC function in your team site.

1. Go to your Team site

2. Select the Library

3. Click the SYNC button

4. OK to Allow OneDrive

5. Select a target local folder to Sync to

Video instructions here Sync …

If that doesn’t work, go into your SharePoint Online document library, select Library and select Open with Explorer… use the explorer window pop-up to copy files to and from your SharePoint document library…

SHPOnlineOpenWithExplorer

… then get on the phone to your Mom, and come check back later.

frank

May
31

The following MYSQL query will display your WordPress post data including post metadata.   Just change the filters as required … demonstrated filters include only posts with a status of Publish and a post date less than Now.  Remember to remove the filter on post date if you are searching for Draft posts only.

SELECT posts.*, postmeta.*
    FROM wp_posts posts, wp_postmeta postmeta
    WHERE posts.ID = postmeta.post_id
    AND posts.post_status = ‘publish’
    AND posts.post_date < NOW()
    ORDER BY posts.post_date DESC
IMG_20140713_164442

 

May
26

Some commonly asked questions in this world are :

1. Is the Loch Ness monster real ?

2. Is the Bermuda Triangle really aliens ?

3. How do you get the month name from a date in a PowerPivot DAX formula ?

Get the three character abbreviation of the month name from a Date column in Powerpivot using the following derived column formula…

=FORMAT(MONTH([YOURDATECOLUMN]),”MMM”)

month

 

May
22

Maritime folklore told of the existence of rogue waves, that could appear without warning, against the prevailing current and often in perfectly clear water. Such waves were said to consist of an almost vertical wall of water, up to 98 feet in height, preceded by a trough so deep, it was referred to as “a hole in the sea”. Any ship approaching a wave of such magnitude would be unlikely to survive the extreme forces and would be sunk in a matter of minutes.

In this session we look at the some of the tools, platforms and methodologies in the current Business Intelligence movement, that can assist businesses to predict, “The Next Rogue Wave”. Whilst the next rogue wave can easily allude to the next big destructive force, the next rogue wave can also be the next big opportunity….such as the Black Swan theory, which aims to predict the opportune time to strike, concerning world financial events.

We will cover the whole data science movement, the growing opportunity of cloud analytics platforms, and the role of data governance, all designed to help businesses to be better prepared for the risks and opportunities of the unexpected, and to respond accordingly.
The demonstration will use a combination of presentation and demo time.

Onsite event details as follows, and external conference available from the link below…

27th May 2015

5:30pm for 6:00pm start

ACS Office Level 7/333 Adelaide St Brisbane

https://acs.org.au/branches/queensland/events/upcoming-events/event-details?eveID=50326271705245

 

May
16

In this data visualisation example we analyse the lyrics of the song Nothing Compares To You, to compare the amount of emotional fulfillment of life in general compared to you…. as at 7 hours and 15 days….

EmotionalFulfillment

May
04

In 1961, Dr Frank Drake presented a controversial equation…called….ummm…the Drake equation, but some critics, labelled the equation a guesstimate or even meaningless.  Yet for the SETI (Search for Extra Terrestrial Intelligence) Institute, the equation pumps to a beat, and drives the mass collection of data, to yield information relating to any of the equation’s factors.  The controversial Drake equation, aims to predict the number of extra terrestrials in the galaxy, like this :

drake

N = The number of civilizations in The Milky Way Galaxy whose electromagnetic emissions are detectable

R* = The rate of formation of stars suitable for the development of intelligent life

fp = The fraction of those stars with planetary systems

ne = The number of planets, per solar system, with an environment suitable for life

fl = The fraction of suitable planets on which life actually appears

fi = The fraction of life bearing planets on which intelligent life emerges

fc = The fraction of civilizations that develop a technology that releases detectable signs of their existence into space

L = The length of time such civilizations release detectable signals into space

If your eyes just glazed over, then try this entertaining animation, where Jill Tarter brings the Drake equation to the masses for the less mathematically focussed, describing the odds of calculating intelligent alien life.

May
01

coffee

twolove

What are the chances of life on earth ? Further, what are the chances of running into a random stranger on earth, and finding love… And further again, what are the chances of holding that love ??   In this compelling Ted talk, mathematician Hannah Fry gives her top 3 mathematically based tips for finding that special 1.

Apr
28

…”with Columbus as a vision, an occasion for a historical panorama of a continent out of his control”, and the occasion, is working with the Lumia Panorama app on Windows Phone.  Here is a quick tutorial for how to generate a panorama.

Firstly, don’t be afraid, the entry point for a panorama is a breathtaking view, breathe it in… its lost and slighted origin.  Open the Lumia Panorama app, start at the left of your horizon and hit the Camera icon – you are going to shoot left to right. See the words “hold phone steady” and you will know you have almost got this sorted.  Note the line leading out to the right…follow it until the two circles meet.  Overlay the circle, hold phone steady again, and continue to the next.

wp_ss_20150425_0084

wp_ss_20150425_0085

wp_ss_20150425_0086

When complete, you should see the words, “Creating panorama” and hopefully you don’t end up with something that looks like a scene from the sci-fi movie “Ellipse”.

wp_ss_20150425_0089

Finally, before you go and get on with the panorama thing… in the words of Christopher Columbus himself “Riches don’t make a man rich, they only make him busier”… happy panorama-ing… remember, it’s about the small things.

panormagood

 

 

Follow

Get every new post delivered to your Inbox.

Join 101 other followers

%d bloggers like this: