create account

What is Business Intelligence? by theexcelclub

View this thread on steemit.com
· @theexcelclub · (edited)
$5.10
What is Business Intelligence?
<center>http://theexcelclub.com/wp-content/uploads/2016/09/bi.png</center> <br/><h2>Business Intelligence</h2>
Business Intelligence (BI) plays a key role in the strategic planning of a business. BI Tools (technologies, apps, and processes) allow an organization to store, to discover, to gather,  to analyze and to visualize data.  This makes it possible for decision-makers at all levels of an organization to act on information.
<h2>Business Intelligence Systems</h2>
Business intelligence systems are data-driven.  They provide historical, current, and predictive views of business operations.

Most businesses collect large amounts of data.  Data at the financial transaction level, data on tenders and quotes, customers, suppliers, contracts.  Marketing data, error data, data on employees. Productivity data, manufacturing related data.  All these data sources need different software and are stored in different formats.

There are accounting packages, payroll packages, manufacturing packages.  Most of which are database driven and can be described as structured data.  And then you also have unstructured data.  Examples would include contract data on word files and in text format. Just think about the amount of data that's stored in Excel Spreadsheets throughout your organization?  And how different each of these spreadsheets is laid out.

A BI system will allow you gather all of this internal data of different sources and formats, structure it, and extract the important information to reveal insights to help a business make faster and more accurate decisions.  Sounds good right?

Organizations are not limited to internally generated data for business intelligence. They can also use external data sources and public data sources. Heard of Big data?  (if not where have you been?) Can you imagine the insights that you can gather for your organization with the use of big data?  But, you don’t have to imagine anymore because. Most BI software’s have tools that support big data. Tools that make it easy to move data, to analyze data and to visualize from Hadoop. (You can’t mention big data and not mention Hadoop. It is one of the greatest software’s used to store and process big data)
<h2>Who can Business Intelligence help?</h2>
But isn’t BI, Big data and External data sources only for large businesses?  The answer is simply no.  BI can help ordinary employees.  BI can help small businesses.  To find out how check out the next post in the series - <a href="https://theexcelclub.com/business-intelligence-case-study/">Business Intelligence - A small business case study</a>

<em>Don't want to miss out on my next post?  Sign up for my <a href="https://theexcelclub.newzenler.com/f/email-signup">newsletter</a> to get a load of Tip and trick on Excel and Business intelligence</em>

<em>Do you know we offer the Best suite of online Excel courses around...<a href="https://theexcelclub.newzenler.com/courses">check them out now</a>.....</em>
<h3><center>Take a FREE course with us</center></h3>
<a href="https://theexcelclub.newzenler.com/courses/practical-beginner-excel-365"><img src="https://theexcelclub.com/wp-content/uploads/2019/01/beginner-excel.png" alt="FREE beginner excel training" width="432" height="501" /><br/></a>

<a role="button" href="https://theexcelclub.newzenler.com/courses/practical-beginner-excel-365">
Take FREE course
</a>
<h3></h3>
<center>Best Value</center></h3>
<h4><center>Access All Areas – Unlimited Excel and Excel Power Tool Training</center></h4>
<a href="https://theexcelclub.newzenler.com/courses/access-all-areas" data-elementor-open-lightbox="">
<img src="https://theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png" sizes="(max-width: 438px) 100vw, 438px" srcset="https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?w=438 438w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=262%2C300 262w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=410%2C470 410w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=100%2C115 100w, https://i1.wp.com/theexcelclub.com/wp-content/uploads/2019/09/access-all-areas.png?resize=275%2C315 275w" alt="" width="438" height="502" /><br/> </a> <br /><center><hr/><em>Cross posted from my blog with <a href='https://wordpress.org/plugins/steempress/'>SteemPress</a> : http://theexcelclub.com/what-is-business-intelligence/ </em><hr/></center>          
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 48 others
properties (23)
post_id80,886,400
authortheexcelclub
permlinkwhatisbusinessintelligence-livwbbxw5f
categoryexcel
json_metadata{"community":"steempress","app":"steempress","image":["http:\/\/theexcelclub.com\/wp-content\/uploads\/2016\/09\/bi.png"],"tags":["excel","stem","palnet","steemleo","tutorials"],"canonical_url":"http:\/\/theexcelclub.com\/what-is-business-intelligence\/"}
created2019-10-14 20:56:03
last_update2019-10-16 09:44:15
depth0
children7
net_rshares19,023,145,616,509
last_payout2019-10-21 20:56:03
cashout_time1969-12-31 23:59:59
total_payout_value2.395 SBD
curator_payout_value2.701 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length4,548
author_reputation32,859,932,476,006
root_title"What is Business Intelligence?"
beneficiaries
0.
accountsteempress
weight1,500
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (112)
@tts ·
To listen to the audio version of this article click on the play image.
[![](https://s18.postimg.org/51o0kpijd/play200x46.png)](http://ec2-52-72-169-104.compute-1.amazonaws.com/theexcelclub__whatisbusinessintelligence-livwbbxw5f.mp3)
Brought to you by [@tts](https://steemit.com/tts/@tts/introduction). If you find it useful please consider upvoting this reply.
properties (22)
post_id80,887,330
authortts
permlinkre-whatisbusinessintelligence-livwbbxw5f-20191014t214105
categoryexcel
json_metadata{}
created2019-10-14 21:41:06
last_update2019-10-14 21:41:06
depth1
children0
net_rshares0
last_payout2019-10-21 21:41:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length361
author_reputation-2,524,772,331
root_title"What is Business Intelligence?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@cadawg ·
Thanks. Very interesting!
👍  
properties (23)
post_id80,887,444
authorcadawg
permlinkre-theexcelclub-20191014t224550327z
categoryexcel
json_metadata{"tags":["excel","stem","palnet","steemleo","tutorials"],"app":"esteem\/2.2.2-mobile","format":"markdown+html","community":"esteem.app"}
created2019-10-14 21:45:54
last_update2019-10-14 21:45:54
depth1
children0
net_rshares185,261,554
last_payout2019-10-21 21:45:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length25
author_reputation55,094,863,461,040
root_title"What is Business Intelligence?"
beneficiaries
0.
accountesteemapp
weight300
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@gungho ·
I'll take this into account when running a business. Thank you

Posted using [Partiko Android](https://partiko.app/referral/gungho)
👍  
properties (23)
post_id80,888,019
authorgungho
permlinkgungho-re-theexcelclub-whatisbusinessintelligence-livwbbxw5f-20191014t221747324z
categoryexcel
json_metadata{"app":"partiko","client":"android"}
created2019-10-14 22:17:48
last_update2019-10-14 22:17:48
depth1
children0
net_rshares184,088,753
last_payout2019-10-21 22:17:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length131
author_reputation7,170,600,970,409
root_title"What is Business Intelligence?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@cmplxty · (edited)
$0.24
It’s incredible that in today’s age, there are massive business that aren’t taking advantage of hiring business intelligence professionals. I’m taking advantage of it and learning skills for my own personal benefit but the company I work for is very large and there’s almost no highly skilled professionals for the data compilation and analytics. Looking to capitalize on the lack for sure!

I haven’t gotten a chance to look at Power BI from Microsoft but it sounds like a stronger version of power query and pivot?
👍  , , , ,
properties (23)
post_id80,888,038
authorcmplxty
permlinkre-theexcelclub-20191014t181954406z
categoryexcel
json_metadata{"tags":[],"app":"esteem\/2.2.2-mobile","format":"markdown+html","community":"esteem.app"}
created2019-10-14 22:19:54
last_update2019-10-14 22:21:30
depth1
children1
net_rshares1,232,449,921,660
last_payout2019-10-21 22:19:54
cashout_time1969-12-31 23:59:59
total_payout_value0.117 SBD
curator_payout_value0.120 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length516
author_reputation9,623,506,263,980
root_title"What is Business Intelligence?"
beneficiaries
0.
accountesteemapp
weight300
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (5)
@paulag ·
Power BI is a stronger and more powerful version of the excel power tools.  If you know how to use the power tools in excel, the transfer over is easy.  It's just a new interface you need to get use to.

BI and data are a great field to be in and now is an awesome time to capitalize :-)
👍  
properties (23)
post_id80,899,141
authorpaulag
permlinkpzes8d
categoryexcel
json_metadata{"app":"steemit\/0.1"}
created2019-10-15 09:12:18
last_update2019-10-15 09:12:18
depth2
children0
net_rshares186,442,011
last_payout2019-10-22 09:12:18
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length287
author_reputation184,784,979,742,229
root_title"What is Business Intelligence?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@lucylin ·
>What is Business Intelligence?

.... Good question - but you won't find any in these parts.
properties (22)
post_id80,888,940
authorlucylin
permlinkpze0do
categoryexcel
json_metadata{"app":"steemit\/0.1"}
created2019-10-14 23:10:42
last_update2019-10-14 23:10:42
depth1
children0
net_rshares0
last_payout2019-10-21 23:10:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length92
author_reputation22,046,179,206,361
root_title"What is Business Intelligence?"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@angelak ·
$0.23
sijfkzmaed
I am employed in a small company.  My role is accountant.  We dont have an IT department, or even an Accounts department.  I would love to be providing better insights but I dont have the time.  I have picked up a lot of tips from you on the subject.  Nice article 
👍  , , ,
properties (23)
post_id80,929,146
authorangelak
permlinkmqvrvyu6jx4xxo9
categoryexcel
json_metadata{"app":"steempress\/2.0"}
created2019-10-16 10:07:15
last_update2019-10-16 10:07:15
depth1
children0
net_rshares1,180,178,368,841
last_payout2019-10-23 10:07:15
cashout_time1969-12-31 23:59:59
total_payout_value0.114 SBD
curator_payout_value0.115 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length265
author_reputation147,910,838,816
root_title"What is Business Intelligence?"
beneficiaries
0.
accountsteempress
weight100
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (4)