What’s New in Office 2013 BI: Part 3 – Improved Productivity
Excel 2013 includes features that improve productivity. Here are the ones related to BI. Flash Fill Suppose that you have a list of customers with addresses. When analyzing the data, […]
Author Archive for: Prologika
Entries by Prologika - Teo Lachev
What’s New in Office 2013 BI: Part 2 – Power View Enhancements
[View:https://prologika.com/CS/cfs-file.ashx/__key/CommunityServer.Blogs.Components.WeblogFiles/blog/7762.Geography.xlsx:550:0] Power View in Office 2013 brings the following new features: Integration with Excel 2013 – Microsoft has decoupled Power View from SharePoint and included it in Excel so you […]
Office 2013 Business Intelligence Highlights
Jen Underwood wrote a great summary about what’s new in Office 13 BI. Interestingly, you’ll be able to drill down to lower location in the Power View maps, e.g. from […]
Localizing Reports in SharePoint
In a current project, international users indicated that they prefer dates and numbers to be formatted using their regional settings. Localization is a big and complicated topic and we’ve been […]
What’s New in Office 2013 BI: Part 1 – Personal BI with Excel
As you probably know by now, Microsoft unveiled the Office 2013 Technology Preview. As the portal page says, “we’ve Taken Self-Service BI to the Next Level”. Indeed, this is where […]
Formatting Calculated Members
Consider the following calculated member definition added to the script in an Analysis Services cube: CREATE MEMBER CURRENTCUBE.[Measures].[Revenue TTM] AS ([Measures].[Revenue Amount USD], [Relative Date].[TTM]), FORMAT_STRING = “Currency”, VISIBLE = […]
MS BI Guy Does Hadoop (Part 5 – The Big Picture)
Let’s recap my thoughts on Hadoop. I’ve found the case studies presented in the chapter 16 of the “Hadoop: The Definitive Guide” book very useful to understand how organizations are […]
MS Guy Does Hadoop (Part 4 – Analyzing Data)
In my previous blog, I talked about Hive. Hive provides a SQL-like layer on top of Hadoop so you don’t have write tons of MapReduce code to query Hadoop and […]
Report Timeout Quest Reloaded
A long time ago, I wrote a blog about possible reasons for Reporting Services reports to time out. This issue raised its head again; this time in SharePoint 2010 environment […]
MS Guy Does Hadoop (Part 3 – Hive)
Writing MapReduce Java jobs might be OK for simple analytical needs or distributing processing jobs but it might be challenging for more involved scenarios, such as joining two datasets. This […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
