This site uses cookies to deliver our services. By using this site, you acknowledge that you have read and understand our Cookie and Privacy policy. Your use of Kontext website is subject to this policy. Allow Cookies and Dismiss

Analytics & BI

Data Analytics,Big Data,Data Storage and Business Intelligence.

Subscribe

Working with SQL Server Compact 4.0 using Entity Framework 6 and ADO.NET

10923 views   0 comments last modified about 4 years ago

SQL Server Compact 4.0 (CE 4.0) is a free SQL Server embedded database ideal for building standalone and occasionally connected applications for mobile devices, desktops, Web clients and others. In one of my projects, I used it as the database for logging errors, which assumes the errors will onl...

View detail

Generate Formatted Excel Destination (Output) in SSIS Data Flow Task

8789 views   0 comments last modified about 4 years ago

SSIS (SQL Server Integration Service) provides a number of convenient tasks to enable data integration. Exporting data from database to Excel file is a common task in ETL (Extract, Transform, Load) projects. Constantly the users/customers may raise format request regarding the Excel extract. To g...

View detail

Create OLAP Project using SSAS

849 views   0 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario In the previous articles of this serial, I’ve introduced how to use SQL Server as database for online transaction proces...

View detail

Create ETL Project for Collecting Sales Data using SSIS

1711 views   0 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario For this ETL project, the requirements are listed below: Sales data will be pushed to specified shared fold...

View detail

Create Business Reports using SSRS

629 views   0 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario After the data is loaded into the database, reports can be built using SSRS (SQL Server Reporting Service). The g...

View detail

An Introduction to SQL Server Features

543 views   0 comments last modified about 5 years ago

SQL Server provides a batch of great features to build robust, high-performance and scalable data solutions. ...

View detail

Build Online Product Management Website using MVC 3 + Entity Framework + SQL Server

835 views   1 comments last modified about 5 years ago

Serial: An Introduction to SQL Server Features Case Scenario All the samples in this serial will focus on one virtual company that produces and sales mobile phone...

View detail

Hands on SQL Server 2012 Serial

261 views   0 comments last modified about 5 years ago

In this article, I am going to summarize some topics regarding SQL Server 2012 together, including T-SQL, Programing, Database Maintenance, Performance Tuning, Data Types, CLR Integration, Business Intelligence, and Applications and so on. The page will be updated continuously with new blog links.

View detail

[Hands on SQL Server 2012] Using CLR Types and Functions

228 views   0 comments last modified about 5 years ago

In this article, I am going to demonstrate how to use CLR (Common Language Runtime) data types and functions in SQL Server.

View detail
qlikview

[QlikView教程]T0 安装环境以及简单的例子

1237 views   0 comments last modified about 6 years ago

QlikView是一款在数据可视化展示方面有很大特长的BI工具,可以提供比较全面的Dashboard的制作。本文将简单阐述此工具的安装使用,并介绍一个简单的例子。在本系列中会陆续介绍QlikView的各种功能。 下载以及安装QlikView QlikView官网下载地址: Downloads 。下载后按照向导安装应用程序;建议选择全部安装所有功能。 以下为Windows64位版本的初始界面: ...

View detail