Getting started with MS4BI in 9 easy steps : [Unicode] Windows & Internet

Step 1 : Basic Excel Query

Step 2 : Build MS4 Database - Consolidation of 2 Excel files

Step 3 : Build MS4 DB View

Step 4 : Query MS4 View drag & drop

Step 5 : Aggregate Reports: hierarchy

Step 6 : Pie Bar... Charts

Step 7 : Report Design : Levels & Automatic calculation

Step 8 : Basic Tab Strip & Responsive Dashboard

Step 9 : DB Administration

  
  Visualise [Unicode] Windows & Internet     
 
  Visualise [Ultra Simple]      
 
 
   Visualise  All applications

     
   Here’s how the 9 STEPS of this DEMO work

- STEP 01 : Publish an Excel file on the Web & Windows

We are going to publish and query 2 Excel files, « CHINA » and « JAPAN » on the web

with just 2 lines of MS4script code :

     
		DBconnect{Ado:"xls"}(your directory + file name);
		 Ms4_Query : web{Ado:"xls"}("SELECT *  FROM [Sheet1$]   " );

You can publish your file, select, filter and sort by column.

in 2 clicks (click on the column header, then drag and drop )
Could it be any easier? !
Visualise the Excel file as published on the internet

- STEP 02 : Build an MS4BI database

Next, we build an MS4BI database by consolidating the 2 Excel files

using 6 lines of MS4script code (+ 5 lines of SQL)

     
		   DBconnect{Ado:'xls'}(Table1);
			  IMPORT : New Ms4Db   
		      BEGIN  
        		 	  Connect DB  (your MS4BI DB tablename) etc.  , 
		    		  Create:Table('[your MS4BI DB tablename]') 
			  END  
			' SELECT   columns '  +
			' from  [sheet1 Excel1$] as a  ,[sheet2 Excel2$] as b   ' +
			' where   ...  '  );

The MS4BI database is now created.

Hey presto! Analyses, reports, charts are all available
Again, could it be any easier?
Visualise the MS4BI database

- STEP 03 : Your first analysis, using MS4BI views

From the MS4BI database, we are now going to create logical views, the first step in data analysis,

with 3 lines of MS4script (SQL commands included) :

Group the number of inhabitants by Province

     
		Ms4_SQL{Ms4DB}("CREATE VIEW  [Your View Name] AS  " +
   "SELECT   columns, sum(columnXXX/1000)  AS TOTALThousand.. " +
		"   FROM  [table MS4DB]  group by columnXXXy ");

Now you have your MS4BI views

You’re just building on your existing SQL knowledge
Nothing too hard so far, right?!
Visualise the MS4BI logical view (Group the number of inhabitants by Province

- STEP 04 : MS4BI queries; intuitive usability

Using the MS4BI database, intuitive and customised data analysis and presentation

with just 1 line of MS4script + your choice of layout!!! :

     
	 FormBts :         DrawGrid , title : "" 	use View  ("ms4LangConsolidation")

Customising dynamic output with MS4BI

Select your preferred « theme » (presentation style)
User-friendly data analysis, and yet again, the most efficient ms4script code possible!
Visualise the BTS FORM theme

# - STEP 05 : Hierarchy reports #

You just need your mouse, and nothing else, to analyse and present data in hierarchy form.

It only takes 8 lines of MS4script, 5 keywords!!! :

     
	REPORTINPUT :   DBconnect {Ms4DB}(your MS4BI DB) use View  ("['your MS4BI DB tablename']") 
    REPORTFORM:AGGREGATE , TITLE : " UNICODE : by city --> Drag & Drop : Column " 
   Option  :  BEGIN pagesize:300 ,height: 500 END OPTION  
	        AGGREGATE  BY    :     Hierarchy column  1, 2..
       	 			    
   	 	DETAIL AGGREGATE    :    
		  column1  ,                TITLE " city "  , 
		  column2   ,        		TITLE "城市"  ,
		  column3   ,         		TITLE "Population"  
		  ...
   END_REPORT ;

MS4BI reports

Powerful yet simple: Hierarchy, drag and drop, and hey presto! There’s your new hierarchy as if by magic.
Is there more efficient code than ms4script?? We doubt it.
Visualise a hierarchical report

# - STEP 06 : MS4BI charts #

This couldn’t be cooler

1 line of MS4script, 2 keywords + choice of chart type and you’re done!!! :

     
		FormPlus : theme : "blueopal"	DrawPIE , title :"" , ANGLE :120 , 
		TYPE : $STANDARD, FORMAT: "$"  use View  ("[-tablename,view--]")  ,

MS4BI charts

4 libraries are provided, and there are more to come (e-charts, js charts, flot, rickshaw,..):
MS4 BI is ready for them..
MS4BI is already looking to the future, harnessing new functionality and web libraries (MIT)!
Visualise a chart

# - STEP 07 : Report Design #

MSBI at its best!!!!

Only 10 lines of MS4script!!! :

     
	Begin_Report
		REPORTINPUT :   DBconnect { Ms4DB} ($MS4DBTMP) use View  ($ms4ViewDBtmp)  
		REPORTFORM:DESIGN  
		Group  Order  by   : level 1  ,Rlevel 2
			LinkCss :    ........
 			Start_Design :
				Totalise 
					$total01 as ...  
 	 			End_Totalise
 
			Report_Header 
				........ 	
			END_Report_Header 

				Group_Header   : 01 **Province level : 01 ,02,03 etc..
					........	
				END_Group_Header   
				Group_Header   : 02 ** CITY level : 01 ,02,03 etc..
					..........
				END_Group_Header   
  
				Group_Break : 02 ** CITY
					........
				End_Group_Break
  
			ReportTotal
				.......
 			End_ReportTotal
 
	End_Report ;

Report Design

Customised reporting, breaks and totals, automatically!!!
What more could you ask for??!
Visualise Report Design

# - STEP 08 : Responsive dashboard and Windows #

MSBI’s star feature!!!!

     
	BEGIN_DASHBOARD  
		option :
		BEGIN
		type  : $TABSTRIP , 	  	title :   ""  
		END
		TabTitle : 'My Aggregate Report  ',  Ms4Script_Import : ....... 
	  	TabTitle : 'My Excel Consolidation ', FormPlus :  DrawGrid  .......    
			FormPlus : theme : "blueopal"	DrawPIE....... 
		TabTitle : "Radar  " ,   FormPlus : theme : "bootstrap" DrawRADAR, .......   
			....      
	END_DASHBOARD ;

Dashboards

Totally Responsive (Tablet, Smartphone and of course Windows)
Minimal development time compared to other languages. This example was completed in 2 days!
Visualise Dashboard Rwd

# - STEP 10 : DB Administration #

Database management for added security …

with just one MS4 script keyword!!!.

     
			Start_Ms4BI_ADMINDB(the MS4BI DB directory); ....

Data administration by the Administrator , and visible by users.

So your Excel consolidation can become a proper database, with built-in security Visualise DB management

- So now you’re ready to follow the DEMO!

- Just click on the different steps on the left

Interested in joining us?? contact@mgplanete.com
The Mg Planete team

WEB SITE

DEMONSTRATION

Link to demos.ms4bi.com

MS4BI HELP 2022

Designer

Getting started with MS4BI in 9 easy steps : [Unicode] Windows & Internet

Step 1 : Basic Excel Query

Step 2 : Build MS4 Database - Consolidation of 2 Excel files

Step 3 : Build MS4 DB View

Step 4 : Query MS4 View drag & drop

Step 5 : Aggregate Reports: hierarchy

Step 6 : Pie Bar... Charts

Step 7 : Report Design : Levels & Automatic calculation

Step 8 : Basic Tab Strip & Responsive Dashboard

Step 9 : DB Administration

Here’s how the 9 STEPS of this DEMO work

- STEP 01 : Publish an Excel file on the Web & Windows

We are going to publish and query 2 Excel files, « CHINA » and « JAPAN » on the web

Could it be any easier? !

- STEP 02 : Build an MS4BI database

Next, we build an MS4BI database by consolidating the 2 Excel files

Again, could it be any easier?

- STEP 03 : Your first analysis, using MS4BI views

From the MS4BI database, we are now going to create logical views, the first step in data analysis,

Group the number of inhabitants by Province

Nothing too hard so far, right?!

- STEP 04 : MS4BI queries; intuitive usability

Using the MS4BI database, intuitive and customised data analysis and presentation

User-friendly data analysis, and yet again, the most efficient ms4script code possible!

You just need your mouse, and nothing else, to analyse and present data in hierarchy form.

Is there more efficient code than ms4script?? We doubt it.

This couldn’t be cooler

MS4BI is already looking to the future, harnessing new functionality and web libraries (MIT)!

MSBI at its best!!!!

What more could you ask for??!

MSBI’s star feature!!!!

Minimal development time compared to other languages. This example was completed in 2 days!

Database management for added security …

- So now you’re ready to follow the DEMO!

- Just click on the different steps on the left

DEMONSTRATION