Andrew Tegethoff, Author at Perficient Blogs - Page 2 of 3

Posts by this Author

  • Topics
  • Industries
  • Partners





Andrew Tegethoff

Andy leads Perficient's Microsoft BI team. He has 16 years of IT and software experience with a primary focus on Enterprise Information Management solutions using the Microsoft Data Platform.

LinkedIn Public Profile

Posts by this author:

Getting Started with Power BI, pt. 1

If you are an Office 365 customer, then you have almost certainly heard about — if not seen — Power BI. The cloud-based analytics and collaboration platform from Microsoft has some pretty amazing features, and really extends the Microsoft BI platform not only into the cloud but into a more self-service oriented mode.   However, one […]

Read more

Why Does Data Warehousing Take So Long? Pt. 3

Last time, I posted about how BI/DW accelerator and framework tools need to be used with care, and not as a substitute for solid requirements analysis. This time, I want to debunk a misconception that can be framed by the following question: Will Agile processes speed up my BI development timeline?   I see many situations […]

Read more

Why Does Data Warehousing Take So Long? Part 2

In my last post, I wrote about BI’s reputation for being a long drawn-out process. And of course, where the market sees a vacuum…  A plethora of products and processes exist to aid with “shortcutting” BI/DW development. So this time, I want to look some common factors at play when you use the various types […]

Read more

Why Does Data Warehousing Take So Long?

A common complaint about data warehousing/BI has been time to market.   The investment in real months required to stand up analytics is just too large. Descriptions of the actual time required vary (depending on who you ask, and what their interests are) from a year to 24 months. The numbers are open to debate, but […]

Read more

Surprise! Microsoft Future Is Dependent on Data

In his July 10th email to employees, Microsoft CEO Satya Nadella mentions the word “data” no fewer than 15 times.   This simple fact serves to highlight how dealing with data is a foundational part of Microsoft’s future strategy.   When he describes a “mobile-first and cloud-first world”, Mr. Nadella is describing a world where data is ubiquitous in “the […]

Read more

Columnstore Indexes: When Should You Use Them?

When I speak to clients about In-Memory features in SQL Server, I find that Columnstore indexes just haven’t gained much traction as a marquee feature. The functionality itself is quite useful in the BI/DW realm as far as potentially boosting query performance by 1.5 to 10 times. But I think it gets overlooked because the […]

Read more

5 Common Pitfalls for Agile BI Projects

Having recently come off a string of Agile BI projects, I’ve made some observations about factors which can potentially hamstring such efforts. Great (but Unrealistic) Expectations First, Agile is not a silver bullet. It will help deal with rapidly changing requirements, and it will get “something” together, rather than “nothing”. But Agile suits some situations […]

Read more

Power View Differences between Excel 2013 and SharePoint 2013

I knew that there were differences between Power View in desktop Excel and Power View as run from SharePoint. But I recently felt the impact of this for the first time. The first confusing point I found was, the Export to Power Point function only works for reports created in Power View in SharePoint Server. […]

Read more

Big Data and the Microsoft Data Platform and You

The age of Big Data is upon us, and the age of Pervasive (or “Ambient”) Data is rapidly approaching. This means that not only the typical loosely-structured Big Data sources that we’ve become accustomed to considering, like Twitter feeds, Facebook posts, and web logs. This also means we’re dealing with the streams of data generated […]

Read more

Pervasive Data in Microsoft’s Cloud OS

As early as the beginning of this year, Microsoft began positioning their “Cloud OS” concept, based on the pillars of Windows Server and Microsoft (formerly Windows) Azure.  This perspective on the spectrum of Microsoft’s offerings casts Cloud OS as a giant next generation operating system, with all the scope and scalability that cloud computing offers. […]

Read more

New Azure VMs improve SQL Server Data Warehousing in the cloud

While poking around in Azure, looking to set up a BI Demo VM , I noticed that Microsoft had added a few SQL Server-oriented images to their catalog.   VMs labeled “SQL Server… for Data Warehousing”! There was one for SQL Server 2012 (SQL Server 2012 SP1 for Data Warehousing on WS 2012) and one for the current […]

Read more

TFS Agile Project Management Wishlist

For several months, I’ve been working on a DW/Reporting project which uses Team Foundation Server (TFS) 2012 for Agile project management.  This has been my first experience using that aspect of TFS, so I’ve been alternately surprised, annoyed, gratified, accepting — I’ve run the gamut of human emotions dealing with this tool.  I’m a longtime […]

Read more

Power BI Update

“Power BI is a compelling new offering with advanced collaborative BI capabilities –including mobile cross-platform reporting– to Office 365 SharePoint Online users.    But that’s not all.  Power BI also encompasses new tools in Excel 2013 that support streamlined self-service reporting and analytics.    Find out how you can leverage the hot new self-service BI features coming […]

Read more

Microsoft Cloud BI: SharePoint in the Cloud

Previously, we addressed the specifics of data services in Azure, and what paths might be valid for SQL Server BI.   Today, we’ll look at delivering data to users — the “last mile” of Microsoft’s cloud BI story — via SharePoint. Whenever you talk about delivery of Microsoft BI, the first point of discussion is logically […]

Read more

Microsoft Cloud BI: Azure Virtual Machines, pt 2

In the last post in this series, we looked at why Azure Machines are the most likely candidate for workable SQL Server-based cloud BI implementations.   Today, we talk turkey about actual limitations and things you need to know as you look at a potential solution in this environment. The first thing to know is that Azure […]

Read more

Microsoft Cloud BI: Azure Virtual Machines, pt. 1

In my last post in this series, I described the basics of Data Services within Microsoft’s Windows Azure public cloud platform.   Basically, we were able to somewhat exclude the majority of PaaS offerings in Azure and home in on the IaaS offering:  Azure Virtual Machines. Azure VM’s are effectively the only real path to full-fledged […]

Read more

Microsoft Cloud BI: Azure Data Services for BI?

In my first post in this series, I talked a little about the basics of cloud BI and Microsoft’s Windows Azure public cloud platform.  I gave a brief glimpse of what services Azure offers for BI.   So to begin with, let’s recap the Azure data services offerings in terms of the cloud computing models available.  Azure’s […]

Read more

Microsoft’s Power BI: just another hugely compelling feature

This article was pointed out to me by a colleague, and I found it a pretty compelling read:  How Microsoft helped this bar figure out that vodka was costing it a fortune. Of particular interest to me is the Natural Q&A feature, which is mentioned prominently. Now, my time in the data warehousing trenches tempers my […]

Read more

Microsoft Cloud BI: An Introduction

As with “All Things Cloud” for the last year or so, Cloud BI is a subject of much buzz. But if you look around, aside from a few niche vendors that have developed Software as a Service (SaaS)  and Platform as a Service (PaaS) BI packages, there’s not a lot of clear information or even thinking. Something close […]

Read more

Creating Dynamic OLAP cubes from Custom Field data, pt. 2

Last time, we discussed arriving at a BI/DW solution for the problem of source application “Custom Fields.” This time, I want to look at the OLAP design, and the mechanisms that make it work in Analysis Services.  As you may recall, we were working on designing a multi-tenant SaaS analytics application. Our greatest problem was in […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up