Ubuntu 17.10 TIP Install Microsoft PowerShell GMH 066

GMH-066 Ubuntu 17.10 Tip Install Powershell Install Microsofts Powershell on Ubuntu 17.10 Aadrvark. Why Powershell when Ubuntu has the power of Bash? I have been torn between where to focus my efforts on and looked at the ecosystem of both Bash and Powershell. Bash beats Powershell is sheer numbers but Powershell seems to be drawing the interest some very innovative folks.

Professionally I work in a Windows environment, my soul works in Linux. In this case, I’m bilingual and I need to speak the language of the country (Environment) I’m living in. I have written some pretty cool Powershell scripts and I’m helping others move from the Windows CMD line into Powershell.

To help me in my withdrawal from Linux, I have installed CYGwin on most windows systems and use the GIT BASH window frequently. I also use a networking tool called MobaXTerm which also has the heart of CYGWin in it. Some of the future videos in this series will have references to Powershell so installing it is important. Some folks find it difficult to dip their toes into the Linux Terminal. For many, this video is a short visit to that strange place. To others, I am boring the shit out them. I promise it will get more interesting in the future.

NOTE: In the recording of this video, the remote desktop connection from the X11VNC server kept crashing after 5-10 minutes. I had to cut out all the cuss words. You might alow notice the cursor highlighting disappears from time to time

Reference: https://austin.cady.io/install-micros…

# Install Curl sudo apt-get install curl # Import the public repository GPG keys curl https://packages.microsoft.com/keys/m… | sudo apt-key add –

# Register the Microsoft Ubuntu repository curl https://packages.microsoft.com/config… | sudo tee /etc/apt/sources.list.d/microsoft.list

# Update apt-get sudo apt-get update

# Install PowerShell sudo apt-get install -y PowerShell

# Link to Missing libicu55

NOTE: This version of the lib is for an AMD system like the one I’m using. If your system is different you may need to locate the proper lib.

# Install libicu55 using CLI package installer
sudo dpkg -i ./libicu55_55.1-7ubuntu0.3_amd64.deb

# Start Powershell pwsh

# Simple command to test PS
write-host “Hello there GeeMustHave fans.” -foregroundcolor yellow

I hope you enjoyed this video and if you liked it or my escapades then click on that LIKE button. Do this Geek a favor, SUBSCRIBE to my YouTube channel. I would really appreciate it!

Any questions or feedback are greatly appreciated.

Now… go build or code something…

YouTube: https:YouTube/c/GeekMustHave

Blog: Https://GeekMustHave.com

GitHub: https://GitHub/GeekMustHave

Facebook: https://goo.gl/QqFZgF

Twitter: https://twitter.com/hashtag/geekmusth…

Twitter: https://twitter.com/hashtag/geekmusthave



Is Tableau Right for You? 10-Point Checklist to Make the Right Decision — DZone Big Data Zone

Image result for tableau logo

If you are choosing a business intelligence tool for your analytics, you have probably heard of Tableau Software. Tableau provides desktop, server, and hosted software that allows users to connect, explore, and visualize their data. Tableau has native connectors that enable it to query relational databases, cloud databases, flat files, and spreadsheets. Interestingly, Tableau was…

Of all the business intelligence tools I’ve used, I enjoy Tableau the most.  I’ve been a Business Objects, Crystal Report developer and instructor for many years and sadly it has become obsolete.  Some of the things I do in Tableau are just not possible in Business Objects.  The runner-up for BI tool is Microsoft PowerBI.  It is still in the growing stage but, it grows every single month.

via Is Tableau Right for You? 10-Point Checklist to Make the Right Decision — DZone Big Data Zone

Business Intelligence comparisons done dirt cheap

The proliferation of business intelligence platforms, tools, and software stacks is dizzying. It seems that not a week goes by in which a new product isn’t introduced to the market, which grows ever more fragmented and confusing. Specialized business intelligence tools for cloud-based data visualization, Hadoop, text analytics, and other specific solutions for certain analyses…

It’s official I’m doing any more BI comparison posts.  I just can’t keep up.  I swear there is either new BI tool every week or a “New Features” post on an existing one.  Recently I did a comparison of a specific set of BI Tools requested by a State Agency.  The problem was the selected set of tools to review didn’t provide the best solution.  Now there are 19 websites with comparisons out the Yazoo and you don’t have to pay a consultant, or do you?   This week I have 2 favorites Tableau and Microsofts Power-BI.  I’m fickle so next week it may be something different.

via 19 Websites for Business Intelligence Tools Comparison — DZone Big Data Zone

Dashboards on the cheap, DIY with Gridster

Recently, I published an article on various JavaScript libraries for Dashboards. In this article, I am going to demonstrate how we can create a dashboard with drag-and-drop visuals and export it using JavaScript. I am going to use the Gridster library to create the dashboard. I have used this library in my projects and found it…

It takes a few libraries to create dashboards that look like


Gridster.JS is a jQuery plugin that when combined with Chart.JS to create the charts and jsPDF to snapshot the page into a PDF file you can build a custom dashboard quickly.  If you have used Tableau or Microsofts Power BI and wondered, “Could I write something like this in code for a specific solution”, me thinks the answer is “Yes”.

via Dashboard: Drag and Drop Visuals and Export Using JavaScript Libraries — DZone Web Dev Zone

Online FREE! Book: Power BI From Rookie to Rockstar


Haven’t you heard the news? Power BI Desktop released with superb features, there is a massive push in Microsoft for updating Power BI regularly and frequently which makes this product better and better each month, There are so much awesome things that you can do with Power BI, and many other reasons. I actually have to search for reasons why not Power BI!

via: Power BI Rookie to Rock Star

Microsoft is giving the other Business Intelligence vendors a run for the money.   There are still a few things Power BI is lacking but the Microsoft team is adding features “Every Month”.  When was the last time Business Objects or Microstrategy was feature updated?

You can start to learn Power-BI for free and do some pretty impressive stuff with it.  If you get to the point where you need to pay for it I think its $10 month.  Is your career worth a week of your time to learn and $10 a month?

Download this book to get started.  There are plenty of other free and “Done dirt cheap” training courses out there.



Gartner positions Microsoft as a leader in BI and Analytics Platforms for ten consecutive years


If you believe in the Magical Mystery Gartner Quadrant (MMGQ) then this news is significant.  The MMGQ may not be so important to you if your business is small to medium sized.  The important takeaway here is that Microsoft has gone from zero in the BI marketplace to 3rd or 4th n just a few years.  They are starting to address the cloud-only issue and get the self-serve option in place.  Their desktop tool is very powerful and the results can be stunning.  But just like desktop publishing didn’t make the average Joe a publisher, a good BI tool won’t make Joe a data analytics or visualization god.

Microsoft has relaunched itself with things like Power-BI, Visual Studio Code, Powershell everywhere, Windows core, SQL Server on Linux and much more.   I have gotten to see some more of the future and I can tell you to hold on it will be an exciting ride.

Tableau, Microsoft and Qlik are the three lone-remaining leaders in this year’s Magic Quadrant.

ext.jpegIf you a big follower of the “Magic Quadrant” from Gartner then this announcement from Timothy King reflects what I have been telling folks for the past year.  The BI players have changed and those providing self-service, less IT infrastructure  and desktop/web tools are winning.  There should be no surprise that Microsoft with Power-BI in here too.  Microsofts new mindset of continuous development and feature enhancements has made it viable.  Some new Microsoft announcements of SSRS 2016 support in-house Power-BI deployment was the missing component.

Microsoft ups the BI game


Microsoft is trying to give the other “on-Demand” Business Intelligence vendors a run for their money.  The enterprise folks didn’t give Power-BI a second glance when they leanered the only way to publish was to the cloud.  Cloud = Bad.   There was talk of SSRS being able to be the portal for all things Power-BI and now some if this has come true.

Microsoft has an Azure appliance that you can “play with” while Microsoft tunes things up.  I think this is going to be a look-see for me in the near future.  I will post what I find.

Power-BI, not your Grandfather’s BI anymore


When I tell customers to consider using Power-BI for doing business intelligence I typically get a “Microsoft isn’t in that marketplace”.  I hate to say this but “This isn’t your grandfathers Microsoft anymore.”.  We have been doing some pretty serious BI work with Power-BI for $10/month per user.  Blair’s article in ComputerWorld outlines some new features including Excel integration and 3D data visualisation ala “SandDance”.  Power-BI isn’t a Tableau level tool but, Microsoft doesn’t take a stock pounding when they miss a projection like Tableau has recently.  Take Microsoft Power-BI for a test drive and when you show off the results be prepared for “That’s not a Microsoft!”.