BI

ByHariharan Rajendran

Basic Concepts of Power BI

Check my previous post about introduction to Power BI before going through this article.

Creating a report and dashboards are very easy in Power BI by simply pointing to the correct data source.

Levels in Power BI,

1. Create a dataset
2. Create a report on top of above dataset
3. Create a dashboard – Just pin a charts to display in dashboard from report.

Power BI is an application which we can use in online as well as in desktop. The steps provided in my previous article (Link) is for online version of Power BI.

To download the desktop version, click here. It has more options compare than online version.

Power BI has gateways which helps to keep the data fresh by connecting the on-premises data sources. It provides the flexibility to individuals as well as organization.

ByHariharan Rajendran

Introduction to Power BI

Power BI is one of the best visualization tool and it can be used by anyone. Initially this tool was available for office 365 SharePoint site. It was something like an add-on but now they have upgraded and it is available externally.

Power BI team from Microsoft has put their ideas and innovations to make this tool available to everyone and it is not  required much technical knowledge to use.

There are lots of improvement has been taking place from day one of power BI by Microsoft power BI team.

Steps to Use Power BI

  1. Visit https://powerbi.microsoft.com/
  2. Scroll down and look for option “Use it free”
  3. Enter work email (xxxxx@xxxx.com), it won’t support personal email
  4. Click “Use it free” and email will be received from power BI and follow the instructions.
ByHariharan Rajendran

Microsoft Visualization Tools

There are many visualization tools available from different companies.

Microsoft always concentrates more on visualization tools because visual tools are going to play a major role in the future.

What is the use of visualization tools?

visualization tools to visualize and analyze the data in an easy way. In this digitized environment, we are producing data from different kinds of machines and gadgets which are not easy to process and understand. To understand those data, we need to process first and once we get proper format, then using visualization tools, we can able to understand.

Microsoft innovations are always awesome since those are very easy to learn and use. The most famous tool from Microsoft is office tools, in that Microsoft excel is the best which can be used from very basic users to advanced users.

In excel, Microsoft added a few more options in terms of visualization. Those options are,

  1. Power Query
  2. Power View
  3. Power Map
  4. Power BI

 

ByHariharan Rajendran

Data Visualization in Microsoft Excel

Data is the most valuable asset in almost all the places.

Understanding the data is not easy for a layman. Visualization tools are playing a vital role to make the layman to understand about the data. Most of business decisions based on best data visualization.

This article speaks about simple visuals based on data about cancer statistics.

Just collected a few facts about the estimated number of new cancer cases in US 2015.

Ref: http://www.cancer.org/acs/groups/content/@editorial/documents/document/acspc-044552.pdf

DataVisual1

 

Visualization tools always helping us to see the facts very clearly. I just converted the data to graphs by using simple and effective Microsoft Excel.

Estimated New Cases for Both Male and Female:

DataVisual2

Estimated New cases for Male Vs Female:

DataVisual3

This is just to help you understand the facts about cancer diseases.

Learning Steps:

  1. Get the data from above reference link, copy and paste the data in Microsoft Excel sheet (it can be any version).
  2. Select the columns and rows and click the “Format as Table” ( Option available in Home tab & Styles section)
  3. If you want to see the chart for sites with Male, just hide the both sexes and Female columns by clicking right click on column B and D.
  4. Select the data from cell A1 to C16
  5. Go to insert tab which is next to Home on top and click the pie chart on chart section.
  6. Pie chart appeared for selected data. Try to check with other chart formats.

Read More

ByDr. SubraMANI Paramasivam

Overview of Microsoft BI Components SQL 2000 Vs 2005 – I know pretty old!

The following table presents an overview of the components of a business intelligence system, and the corresponding Microsoft SQL Server 2000 and SQL Server 2005 components.

Component SQL Server 2000 SQL Server 2005
Extract, transformation, and load Data Transformation Services (DTS) SQL Server 2005 Integration Services
Relational data warehouse SQL Server 2000 relational database SQL Server 2005 relational database
Multidimensional database SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services
Data mining SQL Server 2000 Analysis Services SQL Server 2005 Analysis Services
Managed reporting SQL Server 2000 Reporting Services SQL Server 2005 Reporting Services
Ad hoc reporting SQL Server 2005 Reporting Services
Ad hoc query and analysis Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal) Microsoft Office products (Excel, Office Web Components, Data Analyzer, SharePoint Portal)
Database development tools SQL Server 2000 Enterprise Manager, Analysis Manager, Query Analyzer, various other SQL Server 2005 Business Intelligence Development Studio (New!)
Database management tools Enterprise Manager, Analysis Manager SQL Server 2005 SQL Server Management Studio (New!)

I will get back to you in my next post. All the best for your definition PLUS hunt.

ByDr. SubraMANI Paramasivam

Microsoft Business Intelligence – available in BETA!

Finally, what we’ve all been waiting for, today the entire next wave of Microsoft Business Intelligence is available in Beta. Grab yourself a copy of Microsoft Office 2010 beta, Microsoft SharePoint Server 2010 beta, and SQL Server 2008 R2 CTP3 and try out the exciting new BI capabilities from Microsoft.

  • The new Business Intelligence capabilities in Excel 2010. Connect to an Analysis Services cube and try the new Slicers, Sparklines, Custom Sets, Write-back and more…
  • Explore the power of PowerPivot for Excel and PowerPivot for SharePoint add-ins and pull together data from across your organization or from outside the firewall, build analytic reports and share them with colleagues through SharePoint. If you’re an IT Pro don’t forget to check out the PowerPivot dashboards that give you visibility and insight into what PowerPivot applications are being built across organization.
  • Explore what SharePoint Server 2010 has to offer with PerformancePoint Services, Visio Services, and Excel Services and explore how the SharePoint platform makes the BI experience much more collaborative through tags, notes, wiki’s, etc…

Take a look at the new BI capabilities available with SQL Server in Microsoft website with Master Data Services, the new Report Builder, and more…

ByDr. SubraMANI Paramasivam

Microsoft BI – New Features

Top New Features Create high-performance Analysis Services solutions with optimized cube designers, subspace computation, and MOLAP-enabled writeback capabilities Implement enterprise-scale Reporting Services solutions through new on-demand processing and instance-based rendering Build flexible and effective reports with the new Tablix data structure and rich formatting capabilities Expand reach, and empower more users through optimized integration with the 2007 Microsoft Office system.

Boost data warehouse performance

  • Integrate large volumes of data into your data warehouse faster by using SQL Server 2008 Integration Services, and consolidate real-time data by capturing data changes
  • Increase the manageability and performance of large tables with partitioning, which enables you to manage growing volumes of data and users of your SQL Server 2008 data warehouse more efficiently

Consolidate all data for optimized reporting and analysis

  • Work with all of your data and interact the way you want through support for both relational and non-relational data, including new data types such as FILESTREAM & Spatial
  • Incorporate data from multiple sources directly into a single report
  • Use the data source view to integrate data from across the enterprise and create a Unified Dimension Model that consolidates data from heterogeneous, enterprise-wide data stores, such as SQL Server, Oracle, DB2, SAP and Teradata, to create a holistic view of your business, helping end users gain enterprise-wide insight
ByDr. SubraMANI Paramasivam

List of Business Intelligence (BI) tools

Business Intelligence (BI) tools are widely used for reporting, dashboarding and analysis. The following BI tools were thoroughly examined on 70 criteria considered important for high productivity and Business Intelligence systems that actually add value to your organization. In random order.


No. Tool Version Vendor
1. Oracle Enterprise BI Server 7.8 Oracle
2. Business Objects Enterprise XI r2 Business Objects (now SAP)
3. SAP NetWeaver BI 7.0 SAP
4. SAS Enterprise BI Server 9.1.3 SAS Institute
5. IBM Cognos TM/1 & Executive Viewer 9.1 Applix (now IBM)
6. BizzScore Suite 7.2 EFM Software
7. WebFocus 7 Information Builders
8. Excel, Performance Point, Analysis Server 2007/2005 Microsoft
9. QlikView 8.5 QlikTech
10. Microstrategy 8 Microstrategy
11. Hyperion System 9 Hyperion (now Oracle)
12. Actuate 9.1 Actuate
13. IBM Cognos Series 8 8.3 Cognos (now IBM)