SQL tips and tricks By Satya Katari

Data Warehouse Concepts have the following characteristics: Subject-Oriented : A data warehouse is subject-oriented since it provides topic-wise information rather than the overall processes of a business. Such subjects may be sales, promotion, inventory, etc. For example, if you want to analyze your company’s sales data, you need to build a data warehouse that concentrates on sales. Such a warehouse would provide valuable information like ‘who was your best customer last year?’ or ‘who is likely to be your best customer in the coming year?’ Integrated : A data warehouse is developed by integrating data from varied sources into a… Read more

OLAP stands for Online Analytical Processing. OLAP systems have the capability to analyze database information of multiple systems at the current time. The primary goal of OLAP Service is data analysis and not data processing.  OLTP stands for Online Transaction Processing. OLTP has the work to administer day-to-day transactions in any organization. The main goal of OLTP is data processing not data analysis. ONLINE TRANSACTION PROCESSING SYSTEM (OLTP) EXAMPLE: ONLINE ANALYTICAL PROCESSING SYSTEM (OLAP) EXAMPLE: DIFFERENCE BETWEEN OLTP AND OLAP Data: Transaction: Normalization: Queries: Integrity:

A data warehouse is a centralized repository of digitally stored business information used to drive reporting and data analysis. It consists of massive quantities of data extracted from numerous sources, such as relational databases, internal applications, transactional systems, and external partner systems, aggregated into unified, well-structured historical data. Data warehouse is usually populated with data from an operational database, which contains transactions. The process of populating the data warehouse is called Extract, Transform, and Load (ETL). This process cleans, transforms, and loads the data into the data warehouse. Once the data is in the data warehouse, it can be used for reporting… Read more

PaaS and SaaS are just two of the major categories of cloud computing provided by a third-party. PaaSProgrammers want to focus on code – not on building and maintaining infrastructure. That’s why platform as a service (PaaS) is so incredibly popular. Offered via a cloud service provider’s hosted infrastructure, PaaS users are traditionally able to access a software development platform via a web browser. Easy access to a suite of development tools means programmers can program – and businesses can quickly deploy new applications. SaaSSoftware as a service (SaaS) is the most commonly used option for businesses in the cloud… Read more

Here are some useful keyboard shortcuts for SQL Server Management Studio (SSMS) that can enhance your productivity: These shortcuts can save you time and make your SQL Server management tasks more efficient. 

Azure Data Factory  Azure Data Factory is an Azure service that enables you to define and schedule data pipelines to transfer and transform data. You can integrate your pipelines with other Azure services, enabling you to ingest data from cloud data stores, process the data using cloud-based compute, and persist the results in another data store. Azure Data Factory is used by data engineers to build extract, transform, and load (ETL) solutions that populate analytical data stores with data from transactional systems across the organization. Azure Synapse Analytics  Azure Synapse Analytics is a comprehensive, unified Platform-as-a-Service (PaaS) solution for data analytics that provides a… Read more

Azure Cosmos DB supports multiple application programming interfaces (APIs) that enable developers to use the programming semantics of many common kinds of data store to work with data in a Cosmos DB database. The internal data structure is abstracted, enabling developers to use Cosmos DB to store and query data using APIs with which they’re already familiar. When to use Cosmos DB Cosmos DB is a highly scalable database management system. Cosmos DB automatically allocates space in a container for your partitions, and each partition can grow up to 10 GB in size. Indexes are created and maintained automatically. There’s… Read more

Azure Blob Storage is a service that enables you to store massive amounts of unstructured data as binary large objects, or blobs, in the cloud. Blobs are an efficient way to store data files in a format that is optimized for cloud-based storage, and applications can read and write them by using the Azure blob storage API. Azure Blob Storage supports three different types of blob: Blob storage provides three access tiers, which help to balance access latency and storage cost:

What are business intelligence tools? Business Intelligence (BI) tools are a diverse set of software applications, platforms, and solutions designed to extract, transform, and present data to support data analysis, trend identification, and strategic decision-making within an organization. Capabilities of BI tools: Data integration: BI tools can connect to and consolidate data from multiple different sources, such as databases, spreadsheets, and cloud-based applications. Data transformation: since data can come in many different formats, this aspect of BI tools is crucial for improving the compatibility and usability of the data. Users can transform data by cleaning, structuring, and aggregating it. Data visualization: the bread-and-butter… Read more

Looker is a cloud-based Business Intelligence (BI) tool that helps you explore, share, and visualize data that drive better business decisions. It is now a part of the Google Cloud Platform When to Use Looker If you’re looking for customized visuals, collaborative dashboards, and a single source of truth, plus top-of-the-line customer support, Looker might be the best BI platform for you. Being fully browser-based cuts down on potential confusion as your team gets up and running, and pricing customized to your company means you get exactly what you need to meet your company’s analytics goals. When Not to Use… Read more