بزنس انٹیلی جنس کیا ہے (BI / BW)?

کاروبار کی ذہانت is transforming the data that a business stores in it’s database, اور اس کو مفید بنانے.

Typical data that is tranformed is transactional data such as sales data. For a business each individual sales data is not very useful but aggregating this data (ڈیٹا summerising) can yield some powerful results for business decision makers. مثال کے طور پر, کے 1st سہ ماہی کے لئے انفرادی فروخت کے اعداد و شمار کا تجزیہ 2013 بہت ہی مفید نہیں ہو گی لیکن اس کی فروخت کے اعداد و شمار summerised گیا تو, it would show the total sales for the period and becomes even more powerful it can be compared to the 2nd Quarter of 2013. It turn for decision makers it can become a powerful tool to increase sales, پیشن گوئی کی تخلیق اور نئے کاروبار کی حکمت عملی تیار.

Business Intelligence uses large amounts of data and can be cumbersome without the IT tools that are used to transform the data. The transactional data that BI uses can come from different sources such as transactional database such as Oracle Databases or MS SQL Servers. The data then undergoes an ETL process known as Extract. Transform and Load.
etl

Extract is the process of extracting the data from the source. Transform is changing the data into an appropiate format to store in the Data Warehouse. The Data Warehouse is the storage for the data used in BI, جو اعداد و شمار کی رپورٹنگ کے لئے تیار ہے.

company-report

ETL عمل کے بعد اکٹھا ڈیٹا, is stored in the Data Warehouse. This is the data that is analysed and presented in Reports, فیصلہ سازوں کی تشریح کرنے کے لئے تیار.

The commonly used software are SAP BI اور مائیکروسافٹ بی آئی.

جواب دیجئے