Business Intelligence

Technical Article

Building a Data Foundation for a BI Solution

  • Article

August 2009
Business Intelligence: Planning Your First Microsoft BI Solution
Even BI novices can learn what goes into creating a BI solution, from planning and designing a data mart to preparing data. An Adventure Works example illustrates the first steps a company can take to ensure that its BI solution supports the strategic decisions it needs to make. Stacia Misner
Business Intelligence: Building a Data Foundation for a BI Solution
See how you can design and build a data mart that uses SQL Server 2008 Integration Services to perform the extract, transform and load (ETL) processes for the Adventure Works BI solution introduced in "Planning Your First Microsoft BI Solution." Derek Comingore

2009-07-22

2,055 reads

Technical Article

KPIs in Analysis Services

  • Article

KPIs or Key Performance Indicators are one of the most important entities in driving business decisions. It can be defined as a (quantifiable) measurement used to define and measure an organization's progress in achieving business goals. KPIs for an organization are decided upon by giving careful thought to how each goal and the progress towards these goals should be measured.

2008-06-06

2,088 reads

Blogs

6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery

By

Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...

Data-driven vs. Data-informed: Let’s Acknowledge the Truth

By

This comic was retweeted into my timeline on Twitter (I refuse to call it...

Writing Parquet Files – #SQLNewBlogger

By

Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...

Read the latest Blogs

Forums

LOGON Trigger Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item LOGON Trigger Count

Invisible Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Invisible Downtime

Empowering Lakehouse Users – Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Empowering Lakehouse Users – Data...

Visit the forum

Question of the Day

LOGON Trigger Count

I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?

See possible answers