Understanding Business Intelligence for Effective Business Analysis

Business Intelligence (BI) involves utilizing techniques and tools to convert raw data into valuable insights for strategic decision-making. By analyzing unstructured data, BI helps identify new opportunities and enhance business strategies for competitive advantage and long-term success. Components of BI include operational data, data on the web, data warehouses, reports, dashboards, self-service BI, data mining, predictive analytics, and mobile solutions. Various job opportunities exist within the BI field, such as report writers, ETL developers, cube developers, data scientists, and more. Tools commonly used in Microsoft BI stack include Excel, Power Query, Power Pivot, SQL Server, SharePoint, and Power BI. Watch a demonstration of Power BI from Microsoft here: https://youtu.be/OzjpSl8ugeM

• Business Intelligence
• BI techniques
• Data analysis
• Competitive advantage
• Strategic decision-making

taman Follow

Uploaded on Sep 26, 2024 | 0 Views

Download Presentation

Please find below an Image/Link to download the presentation.

The content on the website is provided AS IS for your information and personal use only. It may not be sold, licensed, or shared on other websites without obtaining consent from the author. Download presentation by click this link. If you encounter any issues during the download, it is possible that the publisher has removed the file from their server.

Presentation Transcript

1. WHAT IS BUSINESS INTELLIGENCE? Kathi Kellenberger For Coder Girl SQL Group

2. Business intelligence (BI) is the set of techniques and tools for the transformation of raw data into meaningful and useful information for business analysis purposes. BI technologies are capable of handling large amounts of unstructured data to help identify, develop and otherwise create new strategic business opportunities. The goal of BI is to allow for the easy interpretation of these large volumes of data. Identifying new opportunities and implementing an effective strategy based on insights can provide businesses with a competitive market advantage and long-term stability.[1] DEFINITION FROM WIKIPEDIA

3. Data Operational data Data on the web Subscription Azure Marketplace, Dun and Bradstreet Master data management Data Warehouse Cubes Reports Dashboards Self-service BI Data mining Predictive analytics Mobile solutions COMPONENTS OF BI

4. Report writers ETL developers Extract, transform, load Cube developers Analysis Services Business Objects Big Data engineer Data scientists SharePoint developers and administrators JOB OPPORTUNITIES IN BI

5. DASHBOARDS Link

6. Excel Power Query Power Pivot Power View SQL Server Reporting Services (SSRS) SQL Server Integration Services (SSIS) SQL Server Analysis Services (SSAS) Multidimensional Tabular SharePoint Power BI Dashboard HD Insight TOOLS USED IN THE MICROSOFT BI STACK

7. https://youtu.be/OzjpSl8ugeM POWER BI DEMO FROM MICROSOFT