Please enable JavaScript.

Coggle requires JavaScript to display documents.

Business Analytics (Career skills (communication skills (to communicate…

- - - - based on unique (rare) resources (assets) that cannot be easily imitated, long-lived, sustainable
      - compared to competitors
    - - product/service and process innovation
      - innovation process, information, R&D investment
      - irreversible resource commitment, asset renewal
  - - - Cheap offshore labor
        hard-pressed to beat overseas competitors on product cost
      - Rivals sell similar offerings
    - - Don’t only know what your customers want
        • know how much they will pay and how to keep them loyal.
      - Don’t just track existing inventories
        • predict and prevent future inventory problems
  - - - make decisions on the formulation
      - execution of business strategies and objectives
      - 特点
        
        Integrated集成
        
        Accessible无障碍
        
        Credible可信的
        
        Timely及时
        
        Data Integrity 数据的完整性
      - source Strategic Information/ data
- - - - Get the data into the correct format for the DW
      - Type conversions, character sets, summarizing or extrapolating data to same time segments
      - Data quality issues (Spelling, incorrect fields, duplicates etc)
    - - Initial loading is done the 1st time you load the DW
      - Subsequent loading transfers new info to the DW
    - - need lots of different methods and tools
      - store the extracted data in a DBMS
      - get the data into the staging area
  - - - A central repository of data
      - Read write only to ELT processes
      - Relational (usual) or multidimensional or NoSQL databases
    - - Subsections of the data warehouse
      - report on specific areas
      - optimises metrics for the business area
  - - - Sales
      - Production
      - CRM
      - HR
      - Finance
    - - Social media
      - Stock markets
      - News
      - Currency
      - ABS
  - - - Lots of users, different expertise levels, the different complexity of queries
      - Combination of prefabricated reports
      - different methods of delivering the information,
        via lots of different sources
    - - Descriptive analytics
        
        what happen
      - Diagnostic analytics
        
        why did it happen
      - Predictive analytics
        
        what will happen
      - Prescriptive analytics
        
        how can we make it happen
    - - report writers
      - scorecards
      - dashboards
      - end-user applications
      - visualizations tools
      - modeling tools
      - data mining tools