by Pavan Malpani | Jul 8, 2024 | Blog, Data Warehousing, Microsoft
This article dives into the importance of resource naming conventions within Microsoft Fabric and introduces you to our Microsoft Fabric Naming Conventions framework. Additionally, we’ll explore the benefits of a well-defined naming framework and common pitfalls...
by XTIVIA | Jun 13, 2022 | Blog, Data Warehousing
Snowflake needs no introduction as it is one of the leading data management platforms on the cloud and its usage is widespread across industry verticals covering multiple use cases (Data Warehousing, Data Lake, Data Science, etc.). It is an open platform which offers...
by XTIVIA | Aug 4, 2020 | Blog, Data Warehousing
The future of data warehousing has been a popular topic in IT conversations. The outright evolution in technology has seen a recession from on-premise servers and expensive hardware to cloud-based infrastructure devoid of complicated installations. In other words, the...
by Siddhartha Gautam | Jul 23, 2019 | Blog, Business Intelligence, Data Warehousing
The typical, base-level form of access (that is, user ID/username and password) has become unsafe and outdated, especially when it comes to protecting access to high-level resources. That’s why developers have designed methods like Multi-factor Authentication...
by Siddhartha Gautam | Jul 2, 2019 | Blog, Business Intelligence, Data Warehousing
In our previous blog on Single Sign-on (SSO), we defined SSO and explained some of the many benefits it brings to the corporate table. To give a little recap: it saves time and money. That being said, we didn’t explain the nitty-gritty inner workings of SSO, the...
by Siddhartha Gautam | May 14, 2019 | Blog, Business Intelligence, Data Warehousing
With hackers around almost every corner, digital enterprise needs password protection and secure login verification. It’s not surprising information, but safely logging into applications, web resources, and other systems has been a concern for in business for...
by XTIVIA | Apr 9, 2019 | Blog, Business Intelligence, Data Warehousing
Business Intelligence (BI) and Data Warehouses (DW) go hand-in-hand, but with Microsoft Power BI the need for a DW has been questioned in the past few years. Because Power BI offers considerable storage, ETL, and reporting functions on top of its business intelligence...
by Siddhartha Gautam | Mar 9, 2017 | Blog, Business Intelligence, Data Warehousing
Performance issues are one of the primary reason and organizations are unsatisfied with their existing reports. One of the primary reason of this performance issue could be caused by report queries. Here are some of the most important thing to consider when writing...
by XTIVIA | Mar 7, 2017 | Blog, Business Intelligence, Data Warehousing
It’s been estimated that up to 60% of the effort in building a data warehouse can be spent in developing the ETL processes that are needed to copy data from source systems and transform it before loading it in to the data warehouse. Many of the ETL processes,...
by XTIVIA | Jan 7, 2016 | Blog, Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...
