Nucleon BI Studio

User Manual

 

 

 

 

 

 

 

 


 

Table of Contents

1     Welcome to BI Studio.. 4

1.1        Supported Databases and Data Sources. 4

1.2        System Requirements. 5

1.3        Database Requirements. 5

1.4        General Installation Instructions. 5

2     Getting Started.. 6

3     Project Management 7

3.1        Creating a New BI App Project 7

3.1.1         Adding a new Database Connection.. 7

4     Data Source Explorer 9

5     Tables, Collections and Views. 10

6     Reporting.. 11

7     Dashboards. 12

7.1        Dashboard Designer 12

7.1.1         Parameters. 12

8     Charting.. 13

8.1        Chart Designer 13

8.1.1         Chart Area. 13

8.1.2         Data Series. 13

8.1.3         Chart Types. 14

9     Queries. 16

10   Statistics. 17

10.1     Statistics Designer 17

10.1.1      Statistics Fields. 17

10.1.2      Statistic Expressions. 17

10.1.3      Conditions. 17

11   Power View.. 18

12   SQL and JSON Query Editor 19

12.1     Executing a script 20

12.2     Output Window.. 20

12.3     IntelliSense. 20

12.4     Code Scripts. 20

13   SQL Query Builder 22

14   LINQ Query Editor 23

14.1     Result Output 24

14.2     Linq to Entity Framework. 24

14.3     Linq to DataSet 24

15   R Statistics. 26

16   Table Data View.. 27

16.1     Data Visualizer 27

16.1.1      Image Visualizer 27

16.1.2      Text Visualizer 27

16.1.3      Chart Visualizer 27

17   Data Editor 29

18   SQL Export 31

19   Data Export 32

19.1     General Options. 32

19.2     CSV Data Export 32

20   Data Import 33

20.1     Bulk SQL Import 33

20.2     CSV Data Import 33

20.2.1      CSV Import Options. 34

21   Data Search.. 35

21.1     Advanced Data Search.. 35

21.2     And / Or Operators. 35

21.2.1      Query Fields and Values. 35

21.2.2      Text (String) Operators. 35

21.2.3      Mathematical Operators. 36

21.2.4      Date and Time Operators. 37

21.3     Full-Text Data Search.. 37

21.3.1      Fuzzy Searching.. 37

22   Data Package  Export/Import 38

22.1     Exporting Data Package. 38

22.2     Importing Data Package. 39

23   Options. 41

23.1     General Options. 41

23.1.1      List View.. 41

23.1.2      Data Paging Counter 41

23.2     User Interface Options. 41

24   Purchasing.. 42

25   Further Help.. 43

25.1     Bug Reports. 43

25.2     Feature Requests. 43

 

 

 


powered by Nucleon Software