Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag business intelligence Rss

Search for any content tagged business intelligence

   Items 1 to 20 of 66    Older >>
 

ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/11/14 (first published: 2012/06/19) | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 6,936 reads

Understanding Microsoft Power BI – Self Service Solutions

This article discusses Microsoft Power BI, different tools under the Microsoft Power BI umbrella and when each of them can be used.  Read more...
By Additional Articles 2013/11/26 | Source: Database Journal | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 3,337 reads

Big Data for SQL folks: The Technologies (Part II)

SQL Server Big Data. Is the end Near for ETL as we know is? Will RDBMs be obsolete? What is NoSQL? What is Hadoop? Big Data-the whole story.  Read more...
By Frank A. Banin 2013/11/21 | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 4,235 reads

Building Real-World Microsoft BI Dashboards Today

There is a lot of Microsoft buzz about Power BI and Excel these days, but customers need real-world, professional business intelligence solutions that meet their complex real-world requirements today. In this article, Jen Underwood shares what technologies were used to develop a dashboard solution for a Fortune Global 500 company using Microsoft Business Intelligence technologies, and why. Some of the decisions may surprise you and the lessons learned are sure to be of value.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,256 reads

Using DAX to create SSRS reports: The Basics

You can use DAX to create reports from a tabular database in SQL Server Reporting Services. To do so requires a few workarounds. Rob Sheldon describes a poorly-documented but important technique for Business Intelligence.  Read more...
By Additional Articles 2013/09/09 | Source: SimpleTalk | Category: dax
Rating:  Rate this |   Briefcase | 3,413 reads

Big Data for SQL folks: The Technologies (Part I)

Will RDBMs be obsolete? Should Data Professionals care about Big Data technologies? What is NoSQL? What is Hadoop? Big Data-the whole story.  Read more...
By Frank A. Banin 2013/06/26 | Source: SQLServerCentral.com | Category: big data
Rating: |  Discuss |   Briefcase | 13,549 reads

Merge, Metadata and the Data Mart ETL

Here's a great method for managing ETL for data marts and small data warehouses with just T-SQL.  Read more...
By Christopher Ross 2012/12/27 | Source: SQLServerCentral.com | Category: etl
Rating: |  Discuss |   Briefcase | 4,510 reads

Understanding the SQL Server 2012 BI Semantic Model (BISM)

SQL Server 2012 introduced an unified BI Semantic Model (BISM) which is based on some of the existing as well as some new technologies. This model is intended to serve as one model for all end user experiences for reporting, analytics, scorecards, dashboards, etc. In this tip, I will talk in detail about the new BISM, how it differs from earlier the earlier Unified Dimensional Model (UDM) and how BISM lays down a foundation for future.   Read more...
By Additional Articles 2012/11/27 | Source: MSSQLTips.com | Category: bism
Rating: (not yet rated)  Rate this |   Briefcase | 2,865 reads

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.  Read more...
By Additional Articles 2012/09/14 | Source: Microsoft MSDN | Category: business intelligence
Rating: (not yet rated)  Rate this |   Briefcase | 2,625 reads

Marketing Data is Exploding

The explosion of social media data has resulted in a lot more marketing data for companies. Some are using it well and some aren't, but in both cases, Steve Jones notes there are more opportunities for data professionals.  Read more...
By Steve Jones 2012/08/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 139 reads

Hard Data v Gut Feel

Data is more important than gut feel, or at least, Steve Jones thinks it should be more important. Today he talks about using data to support decisions.  Read more...
By Steve Jones 2012/07/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 127 reads

ETL Performance Auditing - Part 3: Auditing Data Warehouse Phase

Easy way to setup a comprehensive ETL Performance auditing Solution no matter how complicated your ETL setup.  Read more...
By Frank A. Banin 2014/11/14 (first published: 2012/06/19) | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 6,936 reads

Guide to MCITP: SQL Server 2008 BI Developer

A guide to the SQL Server 2008 Business Intelligence exams.  Read more...
Rating: |  Discuss |   Briefcase | 11,943 reads

Big Data

Are you prepared for Big Data? A short piece from Henrico Bekker that talks about what Big Data might mean to many people.  Read more...
By Henrico Bekker 2012/04/16 | Source: SQLServerCentral.com | Category: business intelligence
Rating: |  Discuss |   Briefcase | 453 reads

Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012

The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.   Read more...
By Additional Articles 2012/01/11 | Source: SQL Server Performance | Category: sql server 2012
Rating:  Rate this |   Briefcase | 2,809 reads

Real Time Dangers

Steve Jones notes that our expert systems might not handle every situation well, and the quest to move towards more real time decision making can involve dangers if a human is not in the loop.  Read more...
By Steve Jones 2011/11/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 115 reads

The HR Scorecard

If you are looking to gain some BI experience or tackle a project that might help your company, Steve Jones suggests you consider doing something for HR.  Read more...
By Steve Jones 2011/10/25 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 324 reads

The SQL Server BI Quiz

From MVP Jacob Sebastian, creator of the T-SQL Challenges, there is a BI quiz throughout the month of June. Enter and answer questions each day for the chance to win prizes.  Read more...
By Press Release 2011/06/02 | Source: Other | Category: contest
Rating:  Rate this |   Briefcase | 2,580 reads

Pragmatic SSAS from BI expert Stacia Misner!

Learn dimensional modeling, cube design, MDX calculations and more in this 4 day online class from Pragmatic Works featuring BI expert Stacia Misner.   Read more...
By Press Release 2011/03/21 | Source: SQLServerCentral.com | Category: training
Rating: (not yet rated) |  Discuss |   Briefcase | 1,260 reads

Skunk Works

The idea of a skunk works is to build a project that works under the radar, by a small and loosely organized group of people. Used to fuel innovation, this is an idea that you might apply to SQL Server BI projects.  Read more...
By Steve Jones 2011/01/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 137 reads
   Items 1 to 20 of 66    Older >>