In the previous article I’ve talked about how to extract date component like Month and quarter. We’re going to continue the other date component here

In this part, we’re going to talk about how to extract Week Number, Financial Year. Plus I also added the importance of “Mark as Table” and the trouble you’re going to run into while sorting the text-based date component.

Continue reading “CALENDAR TABLE WITH DAX Part.4”

Upgrading and Migrating to Oracle Database 12c Release 2 (

Oracle Database 12c Release 2 ( includes new features and enhancements that make it an attractive upgrade target for existing Oracle databases. Moving to Oracle Database 12c Release 2 may be part of an effort that includes moving to newly purchased server hardware, migrating to different storage architectures such as Oracle Automatic Storage Management, changing the database character set, migrating to a completely different operating system, or migrating to the Oracle Cloud.

Because upgrade and migration scenarios can differ in many ways, Oracle provides multiple methods for you to upgrade and migrate your databases to Oracle Database 12c Release 2. This white paper outlines these upgrade and migration methods. You will learn about different use cases and key factors to consider when choosing the method that best fits your requirements.

Download the whitepaper now to find out more and do check out our latest Oracle Education certification courses on our site.

Mastering the Internet of Things

IT service providers have spent the past decade striving to master managed services, cloud services and more. Now, along comes the Internet of Things – and a new wave of business opportunities and challenges.

Case studies from different IT service providers such as Axians, Dimension Data, Impetus Technologies and Presidio Inc. were compiled to provide you insights on their journey toward IoT success and key learnings along the way.

Get the case studies here.

What does it take to become Agile?

Agile is a set of principles, processes and techniques. It is an approach that can be adopted as well as being a mindset and a way of thinking. For the adoption of agile concepts into your organization culture, these elements are illustrated by ‘Tangible, Policy, Values’.

There are a few rules of cultural change that we should take note for getting started on what is often a long processes:

– Know your starting point

– Align adoption of agile to your organizations mission and strategic direction

– Pick your battles

– Use an emergent approach, piloting its adoption and using small successes to build momentum for more agile.

Download the business book to find out more.

Facebook’s 2019 World Trends

There is so much global conversation going on around Facebook’s many platforms that they are able to pull up future predictions across multiple industries just by looking at trending keywords we are all using. And that is just what they have been doing.

On 12 December 2018, Facebook released their 2019 Topics & Trends Report from Facebook IQ[1]. It details topics that may see mainstream waves come 2019 based on their findings between January 2017 and October 2018.

The key categories in this report include Beauty & Fashion, Commerce, Entertainment, Food & Drink, Mind & Body, Science & Technology, and Travel & Leisure. In order to come up with the report, Facebook worked with industry leading business intelligence experts at The Innovation Group at J. Walter Thompson Intelligence, PSFK and Stylus. Continue reading “Facebook’s 2019 World Trends”