SQL Training Online

  • Training Courses
  • Beginner Book
  • Blog

November 12, 2012 by Joey Blue Leave a Comment

Microsoft Business Intelligence Poster

Microsoft put out a new poster to explain all of their Business Intelligence Tools and Components.  In this article, I try to break down each of the sections in the poster to help make it easier to understand.

[divider_line_dashed][/divider_line_dashed]

Introduction

Anyone who has tried to understand the full set of Microsoft Business Intelligence Tools knows that there are many pieces and it can be difficult to understand how they all fit together.

You have Microsoft SQL Server as the core, SQL Server Analysis Services as the OLAP tool (SSAS), SQL Server Reporting Services as the canned Reporting Tool (SSRS),  and SQL Server Integration Services as the ETL tool (SSIS).

Then you can also add in Sharepoint, Excel, PowerPivot, Power View, Excel Services, Report Designer, and Report Builder.

If you aren’t overwhelmed already, you can try to understand how all of this works in the Cloud with Apache Hadoop-based Services in Windows Azure, Microsoft Excel, HiveQL Queries, and Power View.

That is a lot to take in, so Microsoft put out a nice poster to help group these technologies together.

[features_box_blue width=”75%” + border=”2px”]

Download Microsoft’s Poster:

Microsoft Business Intelligence at a Glance Poster

Download Microsoft Business Intelligence at a Glance Poster

This is a big poster and they suggest that you print it on 44” x 34” paper.

[/features_box_blue]

Poster Breakdown

I thought it would be good for me to go through each section and make sure I understand what is really going on.

The rest of this article simply breaks down the poster and links to the relevant content to help in understanding this poster.

So, let’s take a look at a few of the sections.

Client Tools

These are the tools that the end-user will see.

Business Intelligence Client Tools

*The print is too small to read in this image, but you can follow along in the downloaded document.

 

Business Intelligence in Excel

Microsoft starts by mentioning the Microsoft Excel as their “Self-Service BI tool of Choice”.  Which is why you see the big circle around the X.

Business Intelligence in Excel

The key components of this piece of the diagram:

  • Flash Fill
  • Quick Analysis
  • Spreadsheet Inquire
  • Power View
  • PowerPivot
  • xVelocity in-Memory Engine
  • Office 365

SQL Server Data Tools

The SQL Server Data Tools are used to help with your Visual Studio Development and to manage the different projects.

SQL Server Data Tools

You should focus on the following:

  • SQL Server Data Tools (SSDT)
  • SSDT and TFS

 

Reporting Tools

The Reporting tools section is based in SQL Server Reporting Services (SSRS), but also adds the Power View into the mix.

Business Intelligence Reporting Tools

For this sections, the 3 parts to focus on are very apparent.  But, Power View is the newest toy.

  • Report Designer
  • Report Builder
  • Power View

 

Data Mining Add-Ins

There are some add-ins for Excel and SQL Server for data mining predictive analytics.

Business Intelligence Data Mining Add-Ins

  • Microsoft SQL Server  2012 Feature Pack
  • Microsoft SQL Server 2012 Data Mining Add-ins for Microsoft Office

 

Presentation Subsystem

Now we are moving our way toward the behind the scenes programs.

Business Intelligence Presentation Subsystem

SharePoint Server 2013

This is where the services run for Excel Services, PerformancePoint Services, Visio Services, PowerPivot for SharePoint, and Reporting Services Power View for SharePoint.

Business Intelligence SharePoint Server 2013

  • Excel Services
  • PerformancePoint Services
  • Visio Services
  • PowerPivot for Sharepoint
  • Reporting Services Power View for SharePoint

 

Audit and Control Management Server

There is an audit control system or change management system to track what is going on with your office documents in Network Shares and SharePoint libraries.

Audit and Control Management Server

  • Microsoft Audit Control and Management Server

 

Information Sources

In the context of this poster, Information Sources bring in data from multiple locations and mash it together as an Information source that the end user can consume.

Business Intelligence Information Sources

Microsoft lists 2 different source types in this section.

  1. BI Semantic Model in Analysis Services
  2. Native Mode Reporting Services

 

BI Semantic Model in Analysis Services

The BI Semantic Model in Analysis Services has two different categories in it.  Multi-Dimensional and Tabular.

Business Intelligence BI Semantic Model

Here are the main topics to understand from this portion of the diagram.

  • Multi-Dimensional SQL Server Analysis Services (SSAS)
  • Tabular SSAS
  • MDX
  • DAX
  • ROLAP vs MOLAP
  • xVelocity
  • DirectQuery Mode

 

Native Mode Reporting Services

This is the traditional SQL Server Reporting Services (SSRS).  It is the standalone version and is not the Integrated Mode that runs with SharePoint.  This means that it does not include Reporting Services Power View.

Business Intelligence Native Mode SSRS

  • Native Mode SQL Server Reporting Services

 

Data Sources

This is a grouping of Data Sources that can feed the Information Sources layer.

Business Intelligence Data Sources

Here are a few of the highlights from this section.

  • Microsoft ODBC Provider for Hive
  • Windows Azure Marketplace DataMarket
  • OData, REST and JSON from Twitter and Facebook

 

Explore, Visualize, and Control

This section is a bit of marketing, but it helps to understand Microsoft’s focus in this document.

Business Intelligence Explore, Visualize and Control

  • Explore – They want you to know about Excel’s PowerPivot, Power View, and xVelocity.
  • Visualize – They are doubling down on the new Power View, with a small focus on the flexibility with the data models.
  • Control – This is all about Self-Service for the End-User.  But, they don’t want to scare off IT, so they talk about monitoring and protecting BI assets.

 

Mobility, Cloud and Scalability

The right column is all about mobility, cloud and scalability.  Let me take it from the top to the bottom.

Mobile BI

This section is about showing that you can view BI on your mobile device.  Even the Apple iPad.

Business Intelligence Mobile BI

Here are the list of items that are claimed to be available on mobile.

  • SharePoint Performance Point Dashboards and Scorecards
  • Reporting Services on Mobile
  • Excel Services and Visio Services on Mobile

 

PowerPivot Workbooks in Office 365

This is more mobility.  You can share your Excel PowerPivot workbook up to Microsoft Office 365 and then you can use your browser to interact with it.

Business Intelligence PowerPivot in Office 365

  • PowerPivot Office 365
  • Power View Office 365

 

Farm Internal and External Access to Workbooks as a Data Source

These two images talk about the SharePoint 2013 Farm and show the technical layers involved with both the Internal and External setup.

Business Intelligence SharePoint Farm 2013

Here are a few of the topics to focus on:

  • ADOMD.NET
  • Excel Calculation Services
  • PowerPivot Web Service

 

Reporting Services Data Alerts

This section talks about the ability of Integrated Reporting Services (SharePoint mode) to alert you when data changes on a report.  The point is so that you don’t have to look at a report until something happens and then the report is pushed (emailed) to you.

Reporting Services Data Alerts

  • Reporting Services Data Alerts

 

Big Data Analytics

This section of Microsoft’s Report focuses on the Apache Hadoop-based Services in Windows Azure and how it can feed Microsoft Excel, SQL Server Database Engine, and Analysis Services.

Big Data Analytics

Without being too redundant with the rest of this blog post, here are a few links from the focus on this image.

  • Apache Hadoop-based Services in Windows Azure
  • SQL Server Analysis Services to Hive Whitepaper

 

Conclusion

Microsoft’s new Business Intelligence at a Glance Poster is a good way to become familiar with all of the parts involved with Microsoft’s BI solution.

 

Let me know what you think by commenting or sharing on twitter, facebook, google+, etc.

SQL Training Online: https://www.sqltrainingonline.com

Twitter: http://www.twitter.com/sql_by_joey

Google+: https://plus.google.com/#100925239624117719658/posts

LinkedIn: http://www.linkedin.com/in/joeyblue

Facebook: http://www.facebook.com/sqltrainingonline

Filed Under: SQL Business Intelligence Tagged With: Hadoop, Microsoft Business Intelligence, Microsoft Excel, Microsoft SQL Server, Power View, PowerPivot, SharePoint, SQL Download, SQL Server Analysis Services, SQL Server Reporting Services, Windows Azure

June 13, 2012 by Joey Blue Leave a Comment

SQL Jobs in Oracle and Microsoft SQL Server

I was browsing around Yahoo Answers and I started to answer a question about Jobs in SQL and Oracle.

It was interesting to me, so I decided to repost the answer here and elaborate a bit.

Here is the question:

What is difference between oracle and SQL I want to know about . . . ?

which type of jobs are available on oracle course and Sql
Oracle and Sql are same or different ? And tell me about types of jobs with oracle like oracle DBA or oracle developer like this . . . .

I had to interpret quite a bit about what they were wanting to know, so here is my attempt.

Oracle is a relational database.  There are other relational databases out there, like Microsoft SQL Server, MySQL, DB2, etc.

All of these relational databases use SQL to put data into and take data out of the relational databases.

Then, they have their own “programming” languages.

Oracle has their PL/SQL language that you use to write stored procedures and functions.

Microsoft SQL Server has their TSQL language that you use to write stored procedures and functions.

So now that we have defined some of the terms, what jobs are available?

An Oracle DBA (Database Administrator) would take care of database instances and make sure they keep running, they don’t run out of space, they are secure, they have redundancy where needed, and stuff along that line.  They have traditionally been paid a bit more than a Microsoft SQL Server DBA.  But, Oracle has many different “levers” you can pull to tune it, so their is quite a bit to learn to be a real good Oracle DBA.

An Oracle Developer would most likely need to learn PL/SQL.  PL/SQL allows you to write functions and stored procedures that end up as objects on the Oracle server.  You would also need to know basic SQL in order to be effective.  Basic SQL would include SELECT, INSERT, UPDATE, DELETE statements that allow you to put data into the database and get data out.

So the jobs would be Oracle DBA (takes a bit of experience unless you work as a Junior DBA under a Senior DBA.), Oracle Developer (this is the PL/SQL side), and then a regular developer that would work in .Net or Java.

The regular developer position would write programs that interface with the Oracle database, but you would use the .Net (C#/VB.Net) or Java along with SQL to interact with the database.

There are so many different positions I have seen throughout my years in IT.

Once you start a position, the lines end up getting blurred quite a bit.  You have your main responsibility, but you will end up crossing over and doing some scripting or programming.

Take a DBA for example:

They have the responsibility to make sure the database stays up and running and secure.  But, in order to do their job efficiently, they will most likely write some scripts that recompile indexes on some interval, or the script with defragment the disk, or check for errors in the logs.  They definitely need to know SQL in order to create and recompile objects.

DBA’s will also need to do some performance tuning of queries.  But, this job is also a developer’s job, so it crosses over and many times will need to be a collaborative effort.

So you can see that a DBA’s job has already crossed over to a Developer’s a little bit.

I’m going to cut it off there, but I could keep going on all day.

Let me know what you have experienced working in (or with) the IT industry but posting to the comments below.  Or, if you have some more questions please post them too.

Filed Under: SQL Jobs Tagged With: DBA, Jobs, Microsoft SQL Server, Oracle

Recent Posts

  • SQL Database Normalization – 1NF, 2NF, 3NF, and 4NF
  • SQL Joins Tutorial for Beginners – Inner Join, Left Join, Right Join, Full Outer Join – SQL Training Online
  • Zillow House Price Analysis from CSV Archive – #PowerBI 002
  • Learn Basic SQL – 1 Hour Training Course – SQL Training Online
  • Create Table Statement in SQL Server and Inserting Baseball Homerun Leader Dataset – SQL Training Online

Popular Posts

  • SQL Functions
  • SQL Jobs in Oracle and Microsoft SQL Server
  • Troubleshooting a SQL Join
Copyright © 2025 · SQLTrainingOnline.com · Consulting at EmbarkBlue.com