Business Reporting Video Lecture

Loading...

Do curso por University of Colorado System

Inteligencia de negócios, conceito, ferramentas e aplicações

362 classificações

University of Colorado System

Inteligencia de negócios, conceito, ferramentas e aplicações

362 classificações

Curso 4 de 5 em Specialization Armazenagem de Dados e Inteligência de Negócios

Esse é o quarto curso em Data warehouse para especialização em inteligencia de negócios. Preferencialmente o curso deve ser feito em sequencia. nesse curso você irá ganhar conheciento e habilidade para usar data warehouse com propositos de usa-lo em inteligencia de negócios e para trabalhar como desenvolvedor de inteligencia de negócios.Você terá a oportunidade de trabalhar com um banco de dados num ambiente de data warehouse e irá aprender a usar o MicroStrategy's Online Analytical Processing (OLAP) e Visualization capabilities para criar visualizações e painel O curso da uma visão geral de como a inteligencia de negócios pode ajudar na tomada de decisão em vários setores de negócios. Essas tecnologias tem tido um profundo impacto na estratégia coorporativa , performance, e competitividade e todos os sistemas que abrangem a tomada de decisão, sistemas de inteligencia de negócio, e visual analytics. Os modulos são organizados ao redor dos conceitos de inteligencia de negócios, ferramentas e aplicações e o uso do data warehouse para relatório de negócios e analise de processos on line, para criar visualizações e paneis e para gerenciamento de performance de negócios e descrições analiticas

Na lição

Business Intelligence Concepts and Platform Capabilities

Now that you understand the conceptual foundation of decision making and DSS, in module 2 we start by defining business intelligence (BI), BI architecture, and its components, and relate them to DSS. In lesson 2, you will learn the main components of BI platforms, their capabilities, and understand the competitive landscape of BI platforms. In lesson 3, you will learn the building blocks of business reports, the types of business reports, and the components and structure of business reporting systems . Finally in lesson 4, you will learn different types of OLAP and their applications, and comprehend the differences between OLAP and OLTP. You will need to use MicroStrategy Desktop to create effective and compelling data visualizations to analyze data and acquire insights into business practices in a peer evaluated exercise.

Business Reporting Video Lecture7:14

Conheça os instrutores

Jahangir Karimi
Professor
Information Systems University of Colorado Denver

In this lesson, we will dive deeper into business intelligence reports,

there are different types, the components of the system that produces them,

and of course, the building blocks of the reports, themselves.

As we briefly covered in the last lesson, business reports

convey specific information in order to improve managerial decisions.

They can be an informal letter or memo,

100-page document with a cover, table of contents and

executive summary, or they can be a periodic investigative report.

Business reports are either produced to inform internal audiences

like stakeholders and decision makers, or external government audiences.

The annual filing with the Securities and

Exchange Commission is an example of this latter category.

The initial business reports change depending on their audience.

But all of them can serve to communicate business activities,

ensure proper departmental functioning, provide results of analysis,

persuade others to act, and create organizational memory.

That data gets formatted into text, tables, graphs and charts.

So like, in this example, the table contains attributes and

metrics such as categories, sub categories, and

quantitative business measures, to tell us how many items were sold,

the profit margin, total revenue, and so on.

While reports can be distributed in print form or

via email, they are typically accessed via corporate intranet.

Reporting application prompts user to first select the data to be displayed,

and then filter the data according to a specific criteria,

like only sold in my store or sold in the last six months.

There are different types of business reports

depending on the type of the question you are asking.

It's standard reports like a quarterly financial reports,

answer large questions like what happened and when did it happen?

They help paint the picture, but aren't helpful for the long-term decision making.

More targeted questions such as identifying the number of hospital

patients for every diagnosis called for every day of a week

requires what is called a custom ad hoc reports.

How many of these or how often does this happen?

Ad hoc reports illuminate these type of questions.

And if that question requires a deeper investigation, such as sorting and

exploring information about different types of cell phone users and

their calling behaviors, query drilldown or

OLAP reports will allow you user to manipulate all the variables yourself.

The answer to those types of questions can be represented via dashboards,

balanced scorecards, or metrics management reports,

depending on what you are trying to present.

Dashboards present a range of performance indicators on one page,

and have both static and customizable widgets and views.

Balanced scorecards present an integrated view of a company's health,

including financial, customer, business process and

learning, and growth objectives.

A metrics management report present outcome-oriented

data based on service level agreements or key performance indicators.

Reports provide decision making support which kicks off an action and

business activity that yields data to be stored in

a data repository and ultimately reported upon.

This cycle is continual and required.

Everyone who has data to analyze has a story to tell.

The first step toward writing a great business report

is to approach your task like telling a story.

Whether it's diagnosing the reasons for manufacturing defects or

selling new ideas in a way that captures your target audience's imaginations,

stories bring life to cold, hard data and facts.

Narrative makes it easier to remember key points.

And situational context helps

an audience relate to the issues the report is describing.

As you set to create a business report of your own,

remember that having an authentic voice, using clean and

clear visuals that contain accurate data and

presenting opportunities for direct discussions,

are hallmarks of a great business report and presentation.

Creating these reports first require business activity.

After that, extract, transform, and

load processes to check the quality of the recorded transactions,

put them into the appropriate format, and insert it into desired data format.

That data is usually stored in a relational database management system

setup as a data mart, data warehouse or operational data store.

Then use queries prompts and

filters to get the information needed in a business report.

Reports are either published based on a preset schedule of events or

on-demand basis.

These will depend on the alerts and

transaction services capabilities embedded in the BI platform.

Finally, a good reporting system must assure the quality of

information delivered to its users.

Explore nosso catálogo

Registre-se gratuitamente e obtenha recomendações, atualizações e ofertas personalizadas.

O Coursera proporciona acesso universal à melhor educação do mundo fazendo parcerias com as melhores universidades e organizações para oferecer cursos on-line.

© 2018 Coursera Inc. Todos os direitos reservados.

Baixar na App Store

Baixar no Google Play