Category: BI
-
Free and Open Source Business Intelligence Tools
18 BI free tools Seal report .Net based Opensource (github) Installation Demo Google trends analysis Birt / Knime Based on Eclipse Free open source tool Tableau Public What is Tableau? A Platform for centralize many sources of data, do analytics, publish to web. Tableau Public Allows each user 10GB of info storage. How to Videos…
-
SSRS 2019
Here you will find related issues to Ms Sql and SSRS Downloads Ms Sql Developer Express Azure Etc Install SSMS – Management studio Install SSRS – Reporting services Install Report builder Steps Create SSRS report Configure shared data source Go to SSRS configuration tool Open Web portal URL Click on New->Data source Report builder New…
-
Visual Paradigm
What is Visual Paradigm? Visual Paradigm is a powerful, cross-platform and yet easy-to-use design and management tool for IT systems Editions Comparison Download community edition
-
Big Data / NoSql
MongoDB Tutorials Tutorial 1 (guru99) Terms Quick Reference show dbs – show all dababases show collections – show all collections in database. use [db name] – switch to the specific database. db.[collection].find() – find records in the collection. db.[collection].find({email:”[email protected]”}) – find specific value db.[collection].findOne() – find one record in the collection. db.[collection].findOne({email:”[email protected]”},{password:”12345″}) – find specific…
-
Graph database
In computing, a graph database is a database that uses graph structures for semantic queries with nodes, edges and properties to represent and store data. A key concept of the system is the graph (or edge or relationship), which directly relates data items in the store. This contrasts with conventional relational databases, where links between…
-
UMLet Free UML Tool for Fast UML Diagrams
UMLet is a free, open-source UML tool with a simple user interface: draw UML diagrams fast, buildsequence and activity diagrams from plain text, export diagrams to eps, pdf, jpg, svg, and clipboard,share diagrams using Eclipse, and create new, custom UML elements. UMLet runs stand-alone or as Eclipse plug-in on Windows, OS X and Linux. http://www.umlet.com/
-
Build Beautiful Dashboards with Dashing: A Sinatra Framework – Dashing.io
Dashing, a Sinatra based framework for building beautiful dashboards. Easily create widgets with scss, html, and coffeescript. Powered by batman.js.
-
Measure Ms Sql Execution time in resolution of milliseconds
DECLARE @t1 DATETIME; DECLARE @t2 DATETIME; SET @t1 = GETDATE(); /* Put here the query to measure */; SET @t2 = GETDATE(); SELECT DATEDIFF(millisecond,@t1,@t2) AS elapsed_ms;
-
Temporary tables and Table variables – MsSQL
Temporary Tables The simple answer is yes you can. Let look at a simple CREATE TABLE statement: CREATE TABLE #Yaks ( YakID int, YakName char(30) ) Temporary tables are created in tempdb. If you run this query: CREATE TABLE #Yaks ( YakID int, YakName char(30) ) select name from tempdb..sysobjects where name like ‘#yak%’ drop…
-
BI and Data visualization tools
MS Business intelligence (SSRS , SSMS , SSIS , SSAS) Qlik Tableau Pyramid Microsoft PoweBI Google Data studio Keywords Google BI Google data studio Data visualization BI systems
-
BI SSRS / SSMS / SSAS / SSMS
BI SSRS / SSMS / SSAS / SSMS Password: nayabi2015 https://www.dropbox.com/sh/qjawz1tn033f2qn/AACgZP17vaBk4as_HwGBr4IIa?dl=0
-
w3schools.com – The world’s largest web development site
Offline version mediafire.com – w3schools.com.rar thecrazyprogrammer.com – w3schools-offline-version-download-full-website HTML HTML TutorialHTML Tag Reference CSS CSS TutorialCSS Reference JavaScript JavaScript TutorialJavaScript Reference SQL SQL TutorialSQL Reference PHP PHP TutorialPHP Reference JQuery JQuery TutorialJQuery Reference http://www.w3schools.com
-
SSIS Review Exercise: Dump Multiple Flat Files In A Folder Into A DB Table
A tutorial on creating a SSIS package that will dump the contents in a flat file into a single database table. It means that the SSIS package will insert multiply text file into database. The video demonstrates it on old version of SSIS but the concept of passing variable as flat file name is the…
