One of the benefits of the Hadoop is its ability to be configured to address a number of diverse business challenges and integrated into a variety of different enterprise information ecosystems. With proper planning these analytical big data systems have shown to be valuable assets for companies. However, without significant attention to data architecture best […]
Operations
SharePoint Forms – Living Without InfoPath
On Jan. 31, 2014, Microsoft announced the end of InfoPath Forms. This is not totally unexpected as InfoPath is an older technology that relied on programming methodologies long antiquated in a client side, HTML 5, mobile world. Since the announcement, the community has been waiting for more information from Microsoft. Some information was relayed at SPC, but nothing […]
Using GIT deploy key in Jenkins – Written By Tom Tang
This post is an introduction for who want to use Jenkins manage multiple project, using GIT as version control. Of course! We can use SSH-KEY mapping GIT server and CI server together. But that means we must use same SSH-KEY in different projects and some guys can run command “commit” and “push “commit code to […]
QlikView… QlikTech… Qlik…
Several years ago, when I started using QlikView (QlikTech’s flagship product), I had a strong preference for more traditional BI tools and platforms, mostly because I thought that QlikView was just a visualization tool. But after some first-hand experience with the tool, any bias I had was quickly dissipated and I’ve been a QlikView fan […]
SQL SERVER – Introduction to LEAD and LAG
SQL Server 2012 introduces new analytical functions LEAD () and LAG (). These functions accesses data from subsequent row (for lead) and previous row (for lag) in the same result set without the use of a self-join. The syntax for the Lead and Lag functions is: Note that: − “Partition by clause” is optional, “order […]
When to use OneDrive for Business vs. Team Sites
Now that Microsoft has allotted 25 GB per user of storage in OneDrive for Business, an interesting question has arose – “When should I use OneDrive vs. a Team Site?” This is an important question that might not arise if there wasn’t so much space available per user. And with on premise deployments, you’re probably not […]
Sales Report with Date Picker
Sales Report with Date Picker. Last week we created a generic sales report in SSRS. This week we will customize that report and display the numbers only for specific dates. Such reports are called Parameterized reports and are user friendly because the user can choose a date range for his/her reports. So, let us begin! […]
Anyone for zero commission trades?
That is what Robinhood is promising. Will this turn traditional online stockbroking on it’s head? Time will tell, but it’s worth a look. TechCruch has this covered in a recent article. Some fun facts from the article and personal experience are: It doesn’t actually cost a brokerage much money to place a trade. Yet customers […]
Adopting Agile in BI Requirement Gathering
There have been numerous discussions and even arguments in terms of a better implementation strategy in BI projects. But there is no doubt that more and more teams are adopting agile processes or spirit into the team as of its value. When we have conversations on agile methodology or agile teams we usually start […]
SPC 2014: Delivering Adaptive and Personalized Experiences
This is a wide ranging presentation on how to create the personalized experience. Ryan Sockalosky started with the business challenges and then moved into the how. You face a variety of challenges: Ease of use with familiar tools to create sites Create, reuse, and consumer content across many different devices and channels Surface the right […]
Microsoft’s Roadmap for Social: Detailed Analysis from SPC14
“Work like a network.” Spend just a few minutes at SharePoint Conference 2014 and you’re bound to hear or see this phrase sooner than later. It’s here in the keynote and it’s here in the signage. It’s here on the lips of the Yammer and Social product marketing people I had the good fortune to […]
SPC 2014: SharePoint for Any Screen Size, a Responsive Approach
Eric Overfield (@ericoverfield) and Rita Zhang gave an informative session. It was chock full of examples and example code. I couldn’t grab the code examples but a lot of the best practices and screenshots from live sites I was able to grab. They started with the three pillars of Responsive Design: Fluid Grid Must use a […]