TDH Presentation: Frantz Fanon

TDH
Presentation
Frantz Fanon
U n i v e r s i t y
G r o u p 4
tools to extract data
where housing
Objective
GROUP MEMBERS
1: C/SHAKUUR KUURIYA
2: HAMSE ABDI
3: SICIID CEERO
4: SUBEER
5: KHALID A/KARIIN
,
Section One.
Abdi Shakur Kuuriya
What is Data Benefits of a Data
Warehousing…….? Warehouse
•A Data Warehousing (DW) is process for 1. Enables Historical Insight. ...
collecting and managing data from varied sources 2. Enhances Conformity and Quality of Data. ...
to provide meaningful business insights. A Data 3. Boosts Efficiency. ...
warehouse is typically used to connect and anal 4. Increase the Power and Speed of Data
yze business data from heterogeneous sources. Analytics. ...
The data warehouse is the core of the BI system 5. Drives Revenue. ...
which is built for data analysis and reporting. It is a 6. Scalability. ...
blend of technologies and components which aids 7. Interoperates with On-Premise and Cloud. ...
the strategic use of data. It is electronic storage of a 8. Data Security.
large amount of information by a business which is 9. Improve Accuracy. Automating data entry
designed for query and analysis instead of processes for lengthy, repetitive tasks will help
transaction processing. It is a process of improve the accuracy of your data in the long and
transforming data into information and making it short term. ...
available to users in a timely manner to make a 10. Increase Productivity. ...
difference. 11. Improve Visibility. ...
12. Save Time. ...
13. Reduce Costs.
Abdi Shakur Kuuriya
Ask me
Any Quations,
Related for the lecture?. Thanks for
listen me.
DSA COURSE
Presentation
Section Two.
Hamse Abdi
Here is our pick of some of the best data warehouse tools
out there and what they have to offer:
1. Amazon Redshift Disadvantages of

2. Microsoft Azure
3. Google BigQuery
4. Snowflake
Data Warehousing
5. Micro Focus Vertica
6. Teradata 1. Extra Reporting
7. Amazon DynamoDB Work
8. PostgreSQL
9. Amazon RDS 2. Cost/Benefit Ratio
10.Amazon S3
11.SAP HANA
3. Data Ownership
12.MarkLogic Concerns
13.MariaDB
14.Db2 Warehouse 4. Data Flexibility
15.Exadata
16.BI360 Data Warehouse
17.Cloudera
Hamse Abdi
Ask me
Any Quations,
listen me.
DSA COURSE
Presentation
Section Three.
SICIID MAHAD
Microsoft pricing
2. Microsoft Azure “The cost for active
Google BigQuery
Azure SQL data warehouse is a cloud-based storage is $0.020 per
relational database from Microsoft. You can GB/month.
optimize it for petabyte-scale data
loading/processing and real-time reporting. The
platform has a node-based system, and it employs
massively parallel processing (MPP). The
architecture is suitable for optimizing queries for
concurrent processing. Thus, it enables you to
extract and visualize business insights much
faster.
The data warehouse is compatible with hundreds
of MS Azure resources. For example, you may
build intelligent apps with the platform's machine
learning tools. Also, the platform lets you store
different types of structured and unstructured data.
The data may come from diverse sources, such as
on-premise SQL databases and IoT devices.
SICIID MAHAD
Ask me
Any Quations,
listen me.
DSA COURSE
Presentation
Section Four.
subeer
Google BigQuery Pricing
3: Google BigQuery On-demand pricing for Google
BigQuery is $5 per TB, with 1 TB free,
every month
BigQuery is a cost-effective data warehousing tool

with built-in machine learning capabilities. You can
integrate it with Cloud ML and TensorFlow to
create powerful AI models. It can also execute
queries on petabytes of data in seconds for real-
time analytics.
This cloud-native data warehouse supports
geospatial analytics. With it, you may analyze
location-based data or discover new lines of
business.
BigQuery can separate compute and storage. So,
it enables you to scale processing and memory
resources based on business needs. Separation
lets you manage the availability, scalability, and
cost of each resource.
SUBEER
Ask me
Any Quations,
listen me.
DSA COURSE
Presentation
Section Five.
KHAALID A/KAREEN
Snowflake Pricing
4:Snowflake The average compute costs for the

Standard tier is $0.00056 per second,
per credit. The same in the Enterprise
tier is $0.0011 per second, per credit.
You may use Snowflake to set up an

enterprise-grade cloud data warehouse. With
the tool, you can analyze data from various
unstructured and structured sources. The
multi-cluster, shared architecture separates
storage from processing power. Thus, it
allows you to scale CPU resources based on
user activities. The scalability also
accelerates querying performance to deliver
actionable insights faster.
Snowflake's multi-tenant design lets you
share data across your organization in real-
time. You can do this without moving any
data.
KHAALID ABDIKAREEN
Ask me
Any Quations,
listen me.
DSA COURSE
Presentation
THANK YOU
For listen our lecture.

TDH Presentation: Frantz Fanon

Uploaded by

Copyright:

Available Formats

TDH Presentation: Frantz Fanon

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

TDH Presentation: Frantz Fanon

Uploaded by

Copyright:

Available Formats

TDH

1. Amazon Redshift Disadvantages of

BigQuery is a cost-effective data warehousing tool

4:Snowflake The average compute costs for the

You may use Snowflake to set up an

You might also like