HUSTING's COOLBI

MAKING DATA COOL, ONE BYTE AT A TIME


1 Comment

I feel like a stock broker but with FREE access to real-time quotes in #Excel using Yahoo. #analytics #bigdata

image

Boy, does it free great writing code again and quickly producing some insights that I didn’t have before.  What do I mean by that, hasn’t stock data always been available?  Yes, but it is more of a pain to copy and past in Excel.

I can type in a stock ticker into a cell and using Yahoo Finance, I can call their API and get a table set in return that I can throw into Excel and use for some analysis.

image

Once I get this working has my data harvesting tool, then I’m moving the data into one of the predictive analytics tools to see if we can predict some stock movements.

The possibilities are endless, email me if you have any questions.

Enjoy, Patrick


Leave a comment

Attending the Microsoft Mobility Event in New York today. I look forward to showcasing Windows 8 #mobilebi #mobilebiz #spotfire

image

I can’t wait to show the best Windows 8 application at the Microsoft Mobility event tonight at the W Union Square hotel.  Spotfire Mobile Metrics was selected as one of the top apps for the event focused on mobile business intelligence in Windows 8.

I will be showing our CityGov scenario where Metrics is used to bring better collaboration and communications to city managers.  In my demonstration, I will be showing how city department managers manage recently storm related power issues.

image

From being alerted about the issue, discussing the issue in real time and drill into analytics to discovery the problem and resolution.  All done within Spotfire Mobile Metrics.

image

Any YES, it is on Windows Phone 8 too!

image

You can find out more about Spotfire Mobile Metrics at http://spotfiremetrics.com or contact me at LinkedIn.

Enjoy, Patrick


Leave a comment

Is Twitter and Excel having a BAD day or should I say week? #analytics #excel #socialmedia

image

Well, Twitter is at it AGAIN.  They have been updating their developer APIs over the past month and it has disabled our Twitter Analytics for Excel add-on.  We are researching a fix, but not sure when we’ll be able to issue an update.

Visit our Twitter for Excel  page, scroll to the bottom of the page and contact us if you are interested in receiving the update.  We’ll add you to the notification list.

image

Contact me via my LinkedIn account if you would like more information.

Enjoy, Patrick


1 Comment

Building LOB Apps for the Windows Store @ch9 – Mobile BI with http://pushbi.com #mobilebi #mydata

image

We always love it when Microsoft demos our mobile business intelligence solution, PUSHBI, to an audience and we find out later!   My lead developer, Brian, was watching the build videos on Channel 9 and came across his work being demoed at the build conference.  The guy did a great job on demoing the solution.  Check out the video link below

Source (15:18 into the video) http://channel9.msdn.com/events/build/2013/3-185

image

Thanks Microsoft, we enjoy the plugs!

Patrick


1 Comment

We Make Microsoft Excel Sing! #analytics #bigdata #mydata

image

We love Microsoft Excel and I don’t think there is anyone like my employees that can make Excel Sing like we do.

Services: http://www.extendedresults.com/services/excel_consulting.aspx

Twitter Analytics: http://www.extendedresults.com/products/twitteranalytics/

Facebook Analytics: http://www.extendedresults.com/products/facebookanalytics/

LinkedIn Analytics: http://www.extendedresults.com/products/linkedinanalytics/

Outlook and Exchange Analytics: http://www.extendedresults.com/products/calendaranalytics/


Leave a comment

Personalized Business Intelligence experience only with PUSHBI and Windows 7. #analytics #bigdata #mydata

image

With all the excitement around iPads and Windows 8, sometimes we forget that most of the businesses in the  world are still running Windows 7 or XP!  Well, at Extended Results we haven’t forgotten about how important business intelligence is on Windows 7.

Browse on over to http://pushbi.com, download the Windows 7 desktop client and then visit http://now.pushbi.com to set up a FREE 30-day account. Start delivering your business data in a better, more productive interface.   Just think 55 – 25 metrics to 25 people in 5 minutes!

image

We have some of the coolest displays that get you to the information you need to know about right away.

image

Even the historical view gives you a perspective you wouldn’t expect.  See how those numbers are performing over time.  You can see the more green the more good!

Email us if you would like to take PUSHBI for a spin for your organization.

Enjoy, Patrick


1 Comment

New self-service features with Power BI for Office 365 #WPC13 #BI

Yesterday, we talked about the bundled and rebranded suite of Power BI Office 365 and Excel 2013 tools that was announced at the Microsoft Worldwide Partner Conference 2013. This suite provides self-service Business Intelligence in the Enterprise. Today, we’ll discuss some of the new features that further simplify self-service Data Mining.

The most exciting new Power BI feature is the new Q&A query functionality, which enables natural language processing.  Any non-technical, non-power user can ask simple questions and get immediate results in the form of easy-to-understand charts or graphs.  Non-technical users don’t have to learn structured SQL (T-SQL), chase down an analyst or data scientist, or even require knowledge of the great new Power BI tools, Power Query or Power Pivot to get their results. They can simply ask, “What was my sales volume this year?”  or, “How did my sales do last quarter?” A table or chart pops up showing the data they need to see to get their questions answered.

Power BI

Mobile is all the RAGE!!  Another new Power BI feature that we’re really excited about is the Connected (Mobile) BI experience.  Until now, Power View created very dynamic and rich visualizations using Silverlight, which was only available on Intel-based Windows and Mac OS platforms. With Power BI on Office 365 and SharePoint, Power View now renders charts, graphs and visualizations with HTML5. That means where ever you go, as long as you have a smartphone, tablet or any of the variety of other mobile devices, you can get to your enterprise KPIs.  On vacation in Maui without your laptop? Not a problem with Power BI!

Source: http://blogs.office.com/b/office-news/archive/2013/07/08/announcing-power-bi-for-office-365.aspx

And last, but not least, featuring Business Intelligence in the cloud!  Power BI Sites is a new Business Intelligence collaboration platform in the cloud, which utilizes Office 365 and SharePoint.  With Power BI Sites, you’ll get workspaces in Office 365 that enable sharing and collaboration of data and insights with your customers, colleagues and employees.  Easily keep your team up to date with the latest charts and graphs as data refreshes from multiple data sources.

To learn more about Power BI for Office 365, register for the preview at Microsoft: http://www.office.com/powerbi

Follow

Get every new post delivered to your Inbox.

Join 2,179 other followers