Table of Contents

1     Welcome to BI Studio.. 4

1.1        System Requirements. 5

1.2        Database Requirements. 5

1.3        General Installation Instructions. 5

2     Getting Started.. 6

3     Project Management 7

3.1        Creating a New Project 7

3.1.1         Adding a new Database Connection.. 7

4     Data Source Explorer 8

5     Tables, Collections, Documents and Views. 10

6     DataSets (Queries) 11

7     Reporting.. 12

8     Web Visualization.. 13

8.1        Data Visualization with HTML, CSS and Java Script 13

9     Dashboards. 14

9.1        Dashboard Designer 14

9.1.1         Parameters. 15

10   Charting.. 16

10.1     Chart Designer 16

10.1.1      Chart Area. 16

10.1.2      Data Series. 16

10.1.3      Chart Types. 17

11   Statistic Views. 18

11.1     Statistics Designer 18

11.1.1      Statistics Fields. 18

11.1.2      Statistic Expressions. 18

11.1.3      Conditions. 19

12   Cross Tables (Pivot Table) 20

13   Power Views. 21

14   Query Editor 22

14.1     Executing a script 22

14.2     Output Window.. 22

14.3     IntelliSense. 23

14.4     Code Scripts. 23

15   SQL Query Builder 24

16   Data Binding.. 25

16.1.1      Binding Expressions. 25

16.2     Data Printing.. 26

16.3     HTML Elements Binding.. 26

16.3.1      ItemsControl 27

17   C# Scripting.. 28

17.1     Result Output 30

17.2     Linq to Entity Framework. 30

17.3     Linq to DataSet 30

18   R Statistics. 32

18.1     Native R Scripts. 32

18.2     R .Net/C# Integration.. 32

19   Table Data View.. 33

19.1     Data Visualization.. 33

19.1.1      Image Visualization Component 33

19.1.2      Text Visualization Component 33

19.1.3      Chart Visualization Component 33

20   Data Editor 34

21   SQL Export 36

22   Data Export 37

22.1     General Options. 37

22.2     CSV Data Export 38

23   Data Import 39

23.1     Bulk SQL Import 39

23.2     CSV Data Import 40

23.2.1      CSV Import Options. 40

24   Data Search.. 41

24.1     Advanced Data Search.. 41

24.2     And / Or Operators. 42

24.2.1      Query Fields and Values. 42

24.2.2      Data Search Operators. 42

24.2.3      Text (String) Operators. 42

24.2.4      Mathematical Operators. 43

24.2.5      Date and Time Operators. 43

24.3     Full-Text Data Search.. 43

24.3.1      Fuzzy Searching.. 43

25   Data Package Export/Import 45

25.1     Why should I use Data Package Export/Import?. 45

25.2     Exporting Data Package. 45

25.3     Importing Data Package. 46

26   Purchasing.. 47

27   Further Help.. 48

27.1     Bug Reports. 48

27.2     Feature Requests. 48