Data warehouse Resources

Share

Related resources for Data warehouse

Database, Data Warehouse, and Data Lake: A Comparative Analysis10/2/2024 4:49:26 AM. Databases handle structured, real-time transactional data. Data warehouses focus on structured, historical data for analytics. Data lakes store raw, unstructured data, which is ideal for advanced anal
Azure Synapse vs Databricks: Right Data Analytics Platform7/22/2024 8:21:30 AM. Explore the key differences between Azure Synapse Analytics and Databricks. Compare features like data warehousing, big data processing, machine learning integration, and security. Understand when to
Athena vs Redshift: Choosing the Right AWS Analytics Tool for Your Business7/10/2024 12:30:02 AM. Explore the key differences between AWS Athena and Redshift to determine the ideal analytics tool for your business. Discover their strengths in data warehousing, query performance, cost efficiency, a
Snowflake With C#.Net Core6/6/2024 11:33:25 AM. Learn to connect Snowflake with .NET using its connector for cloud-based data warehouse operations. Understand real-time scenarios, pull JSON data, and execute stored procedures through .NET Core, ens
Mirroring Snowflake Database in Fabric Warehouse4/4/2024 2:52:55 AM. In this video, I walk you through how to get started with Snowflake Database, create warehouse, database, tables and records and mirrored the database in Fabric Database for downstream analytics. If y
Fabric Lakehouse to Snowflake: Seamless Data Integration Pipeline4/3/2024 4:05:53 AM. Explore seamless data integration from Fabric Lakehouse to Snowflake Database using a robust data pipeline. This process involves extracting, transforming, and loading data efficiently, ensuring smoot
SQL Server Data Collection And Management Data Warehouse3/28/2024 10:41:49 AM. Explore the built-in SQL Server Data Collection tool for system monitoring. Learn setup steps for Management Data Warehouse, access control via roles, and monitoring data collection using SQL Agent an
Microsoft Fabric: Loading Data into Lakehouse Table3/20/2024 11:56:52 AM. A LakeHouse integrates data lakes & data warehouses, offering benefits of both. Data lakes store raw data diversely, while DataWarehouses handle structured data. LakeHouse combines both for effici
SQL CTE to Rank Sales by Products using Fabric Data Warehouse3/5/2024 5:03:37 AM. This video shows how to author Common Table Expressions in Fabric Data Warehouse to Rank Sales by Products.
What You Need to Know About Data Warehouses2/27/2024 11:41:08 AM. A data warehouse serves as a centralized data management system aimed at bolstering business intelligence (BI) tasks, particularly in the realm of analytics. It is primarily used for conducting querie
Data Pipeline to Copy Data from Azure SQL Database to Fabric Data Warehouse12/13/2023 5:03:20 AM. Moving data in-between and across different technologies is one of the jobs of data engineers. In this new video, I demoed how to create data pipeline to copy data from Azure SQL Database to Fabric Da
Fabric Data Warehouse: Save as Table and Analyze Result Functionalities11/22/2023 3:53:08 AM. In this article, we'll delve into the Microsoft Fabric Data Warehouse features: Save as Table and Analyze Result. These functionalities offer users and analysts several advantages in terms of data
Analyzing Sales Data with a Comprehensive SQL Query in Microsoft Fabric Data Warehouse11/18/2023 4:28:22 AM. This SQL query is a powerful tool for in-depth sales analysis, utilizing joins and aggregations to break down sales data by account manager, payment type, and region in Microsoft Fabric Data Warehouse
Data Pipeline to Copy Data from Data Warehouse to Lakehouse in Microsoft Fabric11/14/2023 11:21:32 AM. In this video, discover how to create a smooth pathway for data transfer from a Data Warehouse to a Lakehouse using Microsoft Fabric.
What is DirectLake in Microsoft Fabric Data Warehouse and its Benefits?11/13/2023 2:36:42 PM. This article focuses on DirectLake in Microsoft Fabric Data Warehouse and its Benefits. DirectLake is a feature of Microsoft Fabric Data Warehouse that allows analysts, engineers, and users to access
How to grant workspace permission to user to access and write DQL command in Fabric Data Warehouse10/17/2023 6:51:26 AM. This video demonstrate how to grant workspace permission to user to access and write DQL command in Fabric Data Warehouse.
Microsoft Fabric Lakehouse And How To Engineer Data Into The Lakehouse9/27/2023 11:31:10 AM. Microsoft Fabric Lakehouse is a data architecture solution offered by Microsoft that combines the capabilities of a data lake and a data warehouse, aiming to provide a unified platform for storing, ma
Maximizing Efficiency and Productivity with OneLake Data Hub8/9/2023 7:05:03 AM. Maximizing Efficiency and Productivity with OneLake Data Hub: Exploring its Top Features, Benefits and Usage
Designing and implementing a Data Warehouse: Part 37/27/2023 5:18:50 AM. This is the third article of a series of articles that I want to write in order to share my knowledge and experience in this subject matter. In this part and the next one, we will see how to implement
Designing and implementing a Data Warehouse: Part 27/25/2023 8:33:15 AM. This is the second article of a series of articles that I want to write in order to share my knowledge and experience in this subject matter.
Designing and implementing a Data Warehouse: Part 17/25/2023 8:17:37 AM. Data warehousing provides efficient storage, maintenance, and retrieval of data. This is the first article of a series of articles that I want to write in order to share my knowledge and experience in
Data Warehouse Units (DWH) In Synapse Dedicated Pool4/11/2023 7:29:56 AM. In this article, you will learn about Data Warehouse Units (DWH) in Synapse Dedicated Pool.
Azure Synapse Analytics - Best Practices To Load Data Into SQL Pool Data Warehouse 1/21/2022 2:53:23 PM. In this article, we'll learn about the best practices to follow while loading dataset into data warehouse.
Azure Synapse Analytics - Connect, Query And Delete Data Warehouse SQL Pool1/10/2022 1:57:24 PM. In this article, we'll learn to connect, query and delete data warehouse using SQL Pool and Azure Data Studio.
Data Architecture - Database Or Data Warehouse Or Data Lake9/25/2020 8:50:42 AM. This article explains the concept of Database, Data Warehouse and Data Lake and provides guidance on selecting one of them for your data requirements.
Snowflake And Its Features5/15/2020 8:45:27 AM. In this article, you will learn about Snowflake and its features.
Schedule Pause /Resume For Your Azure Data Warehouse10/3/2018 10:11:46 AM. If you want to use Azure Data Warehouse for a couple of hours/days, you can certainly do that by *AUTOMATICALLY PAUSING* your Data warehouse. This will minimize the Azure Cost to the greater extent.In
Getting Started With Microsoft Azure SQL Data Warehouse7/5/2018 9:01:04 AM. This article shows the need for Azure SQL Data Warehouse in the world and also demonstrates to create the Data Warehouse in Azure Portal.
Procure your Azure SQL Data Warehouse in 5 minutes5/16/2018 2:30:40 AM. In this video, learn how to procure your Azure SQL Data Warehouse in 5 minutes.
Let's Import Data To Azure SQL Data Warehouse Using SSIS3/21/2018 10:26:38 AM. We have already discussed many ways to import data in Azure DWH. Today I will discuss an OLD SCHOOL approach of data import by SQL Server Integration Services (SSIS). In my opinion, this is the most p
Azure Data Factory - ETL Solution To Azure DB And To Azure SQL Data Warehouse11/9/2017 11:14:42 AM. In this article we will learn how to use Azure Data Factory to Extract, Transform, Load (ETL) data especially for the data warehousing purposes.
Let's Move 'On-Prem' Data Warehouse To 'Azure SQL Data Warehouse' With Redgate Data Platform Studio (DPS)10/25/2017 7:38:10 AM. In this article we will learn how to migrate ‘On-Prem’ data warehouse to the Cloud, specifically Azure SQL Data warehouse. I will share the lessons learned and some do’s and don’ts from my experience
How To Migrate Your On-Premises / Enterprise Data Warehouse Into Azure SQL Data Warehouse9/21/2017 11:49:58 PM. I will share how you can start migrating your data into the Azure SQL Data Warehouse
Azure SQL Data Warehouse - Why Enterprises Should Now Consider It Seriously9/14/2017 12:25:53 PM. Today we will explore some of the reasons why enterprise should choose Azure SQL Data Warehouse.
Compare Azure SQL Database And Azure SQL Data Warehouse8/5/2017 1:17:53 PM. In this article, I am going to compare both Azure SQL database and Azure SQL data ware house. I was reading many articles; below is the tabular compression of both.
Introduction To Azure SQL Data Warehouse10/26/2016 5:27:51 PM. In this article, you will learn Azure SQL data warehouse is a cloud-based, scale-out database capable of processing massive volumes of data, both relational and non-relational. It is built on massivel
Understanding Microsoft's Role In Big Data And Modern Data 2/2/2016 2:26:43 AM. In this video, Microsoft big data experts delve into Microsoft’s play in the Big Data and Modern Data Warehousing workload.
Tools of Business Intelligence in QlikView5/30/2014 8:23:04 PM. This article provides an introduction to business intelligence and also describes various tools of business intelligence.

Topics