Image

Excel

The Buyer – Selecting a Visual Analytics Vendor [Part 2]
1 month ago

The Buyer – Selecting a Visual Analytics Vendor [Part 2]

Sensational claims, frustrations, difficult questions, bizarre behavior and drama, it’s all coming up on this week’s episode of The Buyer. To recap our last episode, a bevy of more than …
Read More

Data Addict Confessions: My TO DO List
2 years ago

Data Addict Confessions: My TO DO List

I have never experienced anything like the past 15 days since the Power BI freemium announcement. Since that day, my in boxes were flooded with inquiries and huge long lists …
Read More

Tip! Embed Excel into a Web Site via OneDrive
3 years ago

Tip! Embed Excel into a Web Site via OneDrive

Here is a fun and unexpected 4th of July surprise.  Last year on this very same day I was playing with the Hortonworks Sandbox. This year while out and about, …
Read More

SAP SAPPHIRE NOW 2014
3 years ago

SAP SAPPHIRE NOW 2014

By  •  SAP

Today kicked off the annual SAP SAPPHIRE event in Orlando, Florida. Last year I attended and enjoyed it immensely. What I love about SAP SAPPHIRE is all the various solutions …
Read More

New Microsoft Office Excel on iPad Native App
3 years ago

New Microsoft Office Excel on iPad Native App

Today exciting and long-awaited news of Microsoft Office native apps for Apple iPad was finally released along with the availability of Microsoft Office in the iPad app store. I won’t …
Read More

BeyeNETWORK Prescriptive Analytics Channel Series
3 years ago

BeyeNETWORK Prescriptive Analytics Channel Series

I am happy to announce the launch of my Prescriptive Analytics Channel on BeyeNETWORK. For those of you that are unfamiliar with Prescriptive Analytics, it is a decision science area …
Read More

Power Query = the Shining Star of Power BI
3 years ago

Power Query = the Shining Star of Power BI

I have written a few times this year about Data Explorer, now called Power Query for Excel 2010 and 2013, in blogs New Data Explorer for Excel and Self-Service ETL …
Read More

Prediction, Optimization, Simulation and Prescriptive Analytics
4 years ago

Prediction, Optimization, Simulation and Prescriptive Analytics

I recently came across an impressive Excel 2013 Add-In that I recall first seeing a few years ago for an older version of Excel while in Data Mining class at …
Read More

New Data Explorer for Excel 2010 and 2013
4 years ago

New Data Explorer for Excel 2010 and 2013

I recently blogged about Self-Service ETL Tool Options. That blog was pretty much a high level summary of current market solutions in that space with links to further explore the …
Read More

Extend Excel Data Visualizations with Office Apps
4 years ago

Extend Excel Data Visualizations with Office Apps

I am truly excited about the ability to easily extend Excel with “Office Apps”. I couldn’t resist checking out this new feature to create an interactive, drillable treemap/heatmap data visualization …
Read More

FAQ: How is PowerPivot Different than Excel?
4 years ago

FAQ: How is PowerPivot Different than Excel?

I have wanted to write this post for a LOOOOONG time now.  I cannot delay this again, period.  Deep technical resources often ask me what is the difference between PowerPivot …
Read More

What-If Analytic Scenario Simulation Options
5 years ago

What-If Analytic Scenario Simulation Options

A common advanced analytic requirement is “what if” scenario modeling. How can we enable our analysts to alter certain parameters  within known contraints to test potential impact?  Well, let me …
Read More

PowerPivot Maps, Tabs, Image Overlays and Other Creative Tips
5 years ago

PowerPivot Maps, Tabs, Image Overlays and Other Creative Tips

Let’s face it, dashboard presentation design matters and you can get fancy with PowerPivot. PowerPivot can be seriously fun, functional and powerful – especially with upcoming Hadoop ODBC and Hive …
Read More

Social Analytics PowerPivot Solutions
5 years ago

Social Analytics PowerPivot Solutions

UPDATED 8/14/2013 Microsoft BI Social Analytics Solution and Technical Support Site

Social analytics enables companies to keep a constant pulse on   the marketplace by reviewing customer sentiment, likes, dislikes  and hot …
Read More

Playing with the Big Data Hadoop ODBC Driver
5 years ago

Playing with the Big Data Hadoop ODBC Driver

At PASS, Microsoft announced the upcoming TAP for a Hadoop ODBC driver.  This driver will enable integration of Apache Hadoop, Windows and Azure Hadoop flavors with various Microsoft BI products. …
Read More

Tip! SharePoint BI/Excel Services
6 years ago

Tip! SharePoint BI/Excel Services

If you have multiple pivot tables/charts in a SharePoint EWA web  part you can use a slicer as a controller to those multiple objects  and pass parameters to the slicer from …
Read More

Top