Sunday January 21st 2018

Categories

Insider

Archives

‘Business Intelligence’ Archives

SQL Server Integration Services Excel data import issue.

SQL Server Integration Services Excel data import issue.

I spent quite a time resolving the issue of Data Import from Excel Using SSIS and couldn’t find source which can help me to resolve issue. I was watching the SSIS Project Beginner Tutorial 2 By JRS on youtunbe and it showed how to resolve the issue. Basicaly we have to go Solution Explorer and right click on the Integration Services Project [...]

Marketing analytics solution has to treat simplicity as a “must-have” rather than a “nice-to-have” feature.

Marketing analytics solution has to treat simplicity as a “must-have” rather than a “nice-to-have” feature.

Data analytics can be a game changer for marketing organizations. McKinsey’s DataMatics study showed that firms in the top quartile of analytics performance were 20 times better at attracting new customers and more than five times better at retaining existing ones than firms in the bottom quartile. But many companies struggle to realize the [...]

Analysis Services tutorial, Key Performance Indicators (KPI)

Analysis Services tutorial, Key Performance Indicators (KPI)

Analysis Services tutorial, Key Performance Indicators (KPI) A Key Performance Indicators (KPI) help a business organizations define and measure progress toward meeting its goals.

Nested Data Presentation Example

Nested Data Presentation Example

In this nested data Scenario (please the picture above), Disbursements are most complex as each Disbursement can have multiple reasons and multiple methods and with each method and reason there could be associated legal entities and Individual entities. Data was stored in Sql Server with Main Table as disbursements and then associated tables of [...]

Fintrac Nested Data

Fintrac Nested Data

In this nested data Scenario (please the picture above), Disbursements are most complex as each Disbursement can have multiple reasons and multiple methods and with each method and reason there could be associated legal entities and Individual entities. Data was stored in Sql Server with Main Table as disbursements and then associated tables of [...]

Analysis Services Tutorial – Creating OLAP cube. Introduction to data warehouse

Analysis Services Tutorial – Creating OLAP cube. Introduction to data warehouse

I found this tutorial to be very helpful it explains very - how to create, manage and share OLAP cube, dimensions, measures and how to integrate relational and online analytical processing (OLAP) data for business intelligence (BI).

Turning Big Data Into Smart Data

Turning Big Data Into Smart Data

Companies are getting more data; in fact, the typical company doubles the amount of data it stores every two years. But more data isn’t necessarily a good thing. Data, after all, is inherently dumb. Getting more of it often seems to compound its lack of intellect. Plus, data brings with it some significant baggage. “All that data can [...]

Strategic Planning with the Balanced Scorecard

Strategic Planning with the Balanced Scorecard

Erica Olsen with http://OnStrategyHQ.comexplains the basic concept of the balanced scorecard and how businesses use it to monitor and guide their performance. Key Performance Indicators (both lagging and leading) are broken into 4 areas of focus: Financial, Customers, Operational and People. These indicators are monitored on a regular basis and [...]

How to Develop Key Performance Indicators (KPIs)

How to Develop Key Performance Indicators (KPIs)

Erica Olsen, COO and Co-Founder of http://OnStrategyHQ.com, explains what metrics to watch within your company and how to use them in your reporting to ensure that your strategic plan stays on track.

Quick Overview of Process Mapping

Quick Overview of Process Mapping

Recently I was reviewing quite a few videos on process mapping and came across this one which I found to be very simple and clear on this topic. - Process mapping may be seen as boring or whatever, but come learn about it today! Process mapping has the potential to stimulate change at every org out there. Also a thanks to Lee LeFever at Common [...]

 Page 4 of 161  « First  ... « 2  3  4  5  6 » ...  Last »