Business Intelligence1Pearson BTEC HND in Computing(RQF)Unit 14: Business Intelligence (L5)Week 6LO3Learning Outcome 3: Demonstrate the use of business intelligence toolsand technologies.AgendaBusiness intelligence tools and techniques• Tools and techniques that support business intelligence.• Descriptive and predictive analysis, predictive modelling (e.g. forecasting andthe use of statistical models to predict and identify trends).Activity: Students to find examples of … Continue reading “use of business intelligence tools | My Assignment Tutor”
Business Intelligence1Pearson BTEC HND in Computing(RQF)Unit 14: Business Intelligence (L5)Week 6LO3Learning Outcome 3: Demonstrate the use of business intelligence toolsand technologies.AgendaBusiness intelligence tools and techniques• Tools and techniques that support business intelligence.• Descriptive and predictive analysis, predictive modelling (e.g. forecasting andthe use of statistical models to predict and identify trends).Activity: Students to find examples of how data mining techniques can be used tofind anomalies, cluster patterns and/or relationships between data sets.Business intelligence solutions• How business intelligence can address organisational problems and providesolutions.• Discussion on business intelligence solutions, to support a business process (e.g.end user requirement, systems requirement, an application) to automateprocedures.Activity: Students to start designs on a tool, program or package to perform aspecific task/provide a solution to a given problem.Business Intelligence2Business intelligence tools & techniquesExcelExcel is a very popular tool, and many, if not most,analysts are already using it. Excel is familiar even tocasual users and for this reason gets used for everythingfrom simple To Do lists to complex financial analysis.It is typically used for:• Retrieve data from a source without having query languageskills.• Analyse data (that is, group, filter, drill down)• Create pivot tables and charts with limited formatting options.• Apply complex calculations to data.Business intelligence tools & techniquesExcel ServicesExcel Services is a SharePoint service application thatenables users to share Excel workbooks in a secure,centralized location. The interface is simple for casualusers to find and access information.It is usually used to:• Enable users to share large workbooks outside of email, evento users who don’t have Excel installed.• Display data in a dashboard-like layout using a familiarinterface.• Provide casual users with collaborative workbook editing andlimited analysis capabilities in a browser environment.• Protect intellectual property in Excel workbooks.• Embed complex calculation capabilities in custom applications.Business Intelligence3Business intelligence tools & techniquesVisio ServicesVisio Services is the final SharePoint service applicationthat we cover in this book. It enables users to securelyshare Visio diagrams for viewing in a browser.It is used to:• Produce web diagrams, optionally linked to a data source, toillustrate a business process, condition, or other scenario.• Enable users to share Visio diagrams with users who don’thave Visio installed.Business SimulationBusiness Intelligence4102Business Simulation103Assembly 1: 5 minAssembly 2: 3 minAssembly 3: 5 minAssembly 4: 7 minCycle time: 20 minBusiness SimulationBusiness Intelligence5104Assembly 1: 5 minAssembly 2: 3 minAssembly 3: 5 minAssembly 4: 7 minCycle time: 12 minStation 1 Station 2Business Simulation105Assembly 1: 5min Assembly 2: 3min Assembly 3: 5min Assembly 4: 7minCycle time: 7 minStation 1 Station 2 Station 3 Station 4Business SimulationBusiness Intelligence6106Business Simulation