Infokus

Before I start the tutorial, I just want to take a quick moment to think about all the lives that were lost eleven years ago today.  Being from NY (north of the city), the attack really hit close to home.  Two weekends ago I went down to the city and saw some of the new towers that theyre building.  Theyre absolutely amazing, but its unfortunate to think of the events that led us to the new construction. 

Im sure you already have already, but just take a moment to think about the lives that were lost.



Now, heres the tutorial for the week...

You can download this tutorial as a PDF by clicking this picture!

It is Friday night, and after a long week of work and thinking (about the future), I am going to have some fun using my imagination to predict the future evolution of the blog (in a light sense). While the blog might have been the ultimate online personal publishing tool a few years back, I suppose the flavor of 2009 is micro-blogging with Twitter in the lead, sweeping through every corner of the world. 10 million+ users now and growing fast. Expect it to reach 50 million+ users by year end.

While you require time and effort to maintain a blog (many never reach the second post), you cant say that of micro-blogging. So, why are micro-blogging tools such as Twitter growing in popularity around the world so fast?


WHY TWITTER?
"Simplicity has played an important role in Twitters success. People are eager to connect with other people and Twitter makes that simple. Twitter asks one question, "What are you doing?" Answers must be under 140 characters in length and can be sent via mobile texting, instant message, or the web (answered by Twitter)..."

Easy to register, easy to learn, easy to connect, easy to write, easy to converse, easy to share, easy to socialize, easy to follow, easy to promote (yourself and your company), easy to message, easy, easy, etc. Seriously, you can have so much fun with so little effort. How do you beat that?


TWIT MANIA IN 2013!
So, what comes after Twitter or micro-blogging? Molecular blogging? While 140 characters might sound simple, short, easy, and cool today, I predict that we might see tools breaking the barrier further, so here is my solution or idea. Lets just call it TWIT. Not twit (meaning wise!) :)

As time passes by, Twitter will loose its trendy edge and people will explore other simpler and easier tools, and eventually Twitter will be seen as a long-winded way to express oneself compared to the new revolution in town. what?

Yes, we are talking about TWIT and the year is 2013. People are still fond of blogging and Twitter, but TWIT has taken the world by storm. People are fed up of knowing what others are doing (who cares what you eat for breakfast?), and who has the time to write a sentence or 140 characters.

With TWIT you must say what you want within 3 words or 33 characters (Just Do It). TWIT asks one question, "What do you think?" And you better be concise and short, or the world wont be following and watching/reading/listening what you have to say. It is really up to you whether you want to post your answer using video, audio, graphics, or text (the tool can detect the words in all modes). Whatever mode you use, you are limited to 33 characters (or 3 words). Its easy, challenging and fun at the same time.

People simply love it, and by November 2013, TWIT users has smashed the billion mark. Whether you are on your IPhone Flex or old PC, TWIT users are TWITing an average of 20.5 messages a day. You want to buy a ZaidPhone, and within one search you have 1 million TWIT reflections of what people think about it. And by that time, TWIT uses an intelligent synonym analyzer and a semantic babble doodle to make humanly sense of all these short reflections via a patterned 3D visualization synthesizer (what the h......l is that!).

So, what do people love about TWIT?
People want to know what others think about this and that, and they love quick trigger answers (Much like headers or slogans). With TWIT you can find out within seconds what millions think about anything you can imagine summarized with a few words. It is amazing!

While Twitter users have thousands of followers, popular TWIT users have often millions of followers . Obama was asked, what is your secret weapon to win the 2013 election? And his answer was "TWIT of course!"


TIME TO SLEEP!
It is getting late, and I am getting sleepy (Nearly 3 am for crying out loud!), and this post needs a break. I need some more time to conceptualize a TWIT that inspires millions. Ops, then comes Rubi on hot wheels. Are the any savvy programmers who are working on a molecular blogging tool right now? Seriously, 140 characters is simply too long to be spicy in 2013. So, will TWIT outshine Twitter in 2013? Time to get back to reality, I mean sleep :)

Hi Guys,

I love experimenting/Playing with Pentaho C-Tools where it took me to explore D3 bar chart with SQL query result set...

Not a big deal in implementing it, but want to share some thing with community folks.

What will you learn in this post ?
You will get an idea on how to implement D3 bar chart.
1) Passing query output to D3 chart code.



Limitations on the Example :
1) Query and Chart is not parametrized yet.
2) Y-Axis labels are not dynamic yet.
3) Tool tip is not implemented.
4) Not tested the bootstrap support.
5)  and more.....

Readers are encouraged add your support to improve the sample of this in comment box...


Software setup :
a) C-Tools(CDE,CDF,CDA,CGG) - Version14.06.18 stable with bootstrap support.
b) Database server for a sample query - In this example postgres - foodmart database.
3) Install D3 components plug-in from market Place

 Example 1 : 

 Step 1 : Layout : Create your layout .... Row---column--Html... Span 24 for this example
 Step 2 : Data Source : 
Driver : org.postgresql.Driver
URL : jdbc:postgresql://localhost:5432/foodmart
UserName/Password : postgres/postgres
Query : query1
select distinct first_name as letter,salary as frequency from employee where salary!=20 limit 20
Step 3: Components
D3 Components - D3 component -
In properties for Custom Chart Script write below code.
Datasoruce : query1


function f(dataset){
   

    
    var data = this.cdaResultToD3Array(dataset);
   
    
    var margin = {top: 20, right: 20, bottom: 30, left: 40},
        width = this.getWidth() - margin.left - margin.right,
        height = this.getHeight() - margin.top - margin.bottom;
   
    var formatPercent = d3.format(".0%");
   
    var x = d3.scale.ordinal()
        .rangeRoundBands([0, width], .1, 1);
   
    var y = d3.scale.linear()
        .range([height, 0]);
   
    var xAxis = d3.svg.axis()
        .scale(x)
        .orient("bottom");
   
    var yAxis = d3.svg.axis()
        .scale(y)
        .orient("left")
        .tickFormat(formatPercent);
  
  
    var svg = d3.select("#"+this.htmlObject).append("svg")
        .attr("width", width + margin.left + margin.right)
        .attr("height", height + margin.top + margin.bottom)
      .append("g")
        .attr("transform", "translate(" + margin.left + "," + margin.top + ")");
       
       
 
   
    // Commenting this out, we have data already
    // d3.tsv("/pentaho/api/repos/d3ComponentLibrary/static/custom/data/data.tsv", function(error, data) {
   
      data.forEach(
                    function(d) {
                    d.frequency = +d.frequency;
                    }
      );
   
      x.domain(data.map(function(d) { return d.letter; }));
      y.domain([0, d3.max(data, function(d) { return d.frequency; })]);
   
      svg.append("g")
          .attr("class", "x axis")
          .attr("transform", "translate(0," + height + ")")
          .call(xAxis);
   
      svg.append("g")
          .attr("class", "y axis")
          .call(yAxis)
        .append("text")
          .attr("transform", "rotate(-90)")
          .attr("y", 6)
          .attr("dy", ".71em")
          .style("text-anchor", "end")
          .text("Frequency");
   
      svg.selectAll(".bar")
          .data(data)
        .enter().append("rect")
          .attr("class", "bar")
          .attr("x", function(d) { return x(d.letter); })
          .attr("width", x.rangeBand())
          .attr("y", function(d) { return y(d.frequency); })
          .attr("height", function(d) { return height - y(d.frequency); });
   
      d3.select("input").on("change", change);
   
      var sortTimeout = setTimeout(function() {
        d3.select("input").property("checked", true).each(change);
      }, 2000);
   
      function change() {
        clearTimeout(sortTimeout);
   
        // Copy-on-write since tweens are evaluated after a delay.
        var x0 = x.domain(data.sort(this.checked
            ? function(a, b) { return b.frequency - a.frequency; }
            : function(a, b) { return d3.ascending(a.letter, b.letter); })
            .map(function(d) { return d.letter; }))
            .copy();
   
        var transition = svg.transition().duration(750),
            delay = function(d, i) { return i * 50; };
   
        transition.selectAll(".bar")
            .delay(delay)
            .attr("x", function(d) { return x0(d.letter); }
           

            );
           
        transition.select(".x.axis")
            .call(xAxis)
          .selectAll("g")
            .delay(delay);
      }
    // });
   
}
NOTE :
1)  As the code is a replica of build in Example in Pentaho D3 plug-in , the code depends on 2 column result set of data.....

Step 4: Save dashboard and test the output
Image 1 : With sort enabled - For this you need to write below HTML code for the column of this chart in layout section .

<label><input type="checkbox"> Sort values</label>  


Image 2 : With sort check box disable

Example 2:

Why to wait ? Lets have a look at this static bar chart example in CDE( check this : http://jsfiddle.net/enigmarm/3HL4a/13/ )

Image 2 : Descending
Default:

To get the above static charts on CDE output... lets do this..

Hmmmm...!!! the same  code I used from http://jsfiddle.net/enigmarm/3HL4a/13/ in CDE as an experiment..

Add HTML code at Row-Column-HTML
Add Css code at : Code Sinppet Css
Add D3 chart script code at : Custom chart script for D3 component.
Save your dashboard and preview it..


Are you eager to check it in CDE ? Download the examples here 

Click Me folk...!!! :-) 


References : 
1) http://bl.ocks.org/Caged/6476579
2) http://bl.ocks.org/mbostock/raw/3885705/
3) http://bl.ocks.org/mbostock/3885304
4) http://bl.ocks.org/mbostock/raw/3885304/
5) http://jsfiddle.net/gregfedorov/Qh9X5/9/
6) http://jsfiddle.net/uedatakuya/tXPEV/light/
7) http://jsfiddle.net/weXNd/6/

Hi guys...!!!

Community Dashboard Editor is the best reporting/dash boarding  tool that I have worked. Its smart functionality made me love to work with it and exploring the things time by time.

Youll learn how to fetch different columns from result set of a single query and use them in different analysis purpose in charting.

Recently I needed to work with a single query data source(SQL) of having 3 columns result set ...
Lets say there are 3 columns A,B and C where as A column is having some category names and B and C are having some columns.

A  B   C
--------------
abc 2   4
pqr  6   8 
xyz 10 5
and etc.

From the result set A&B are on first chart and A&C are on other chart..
Now how ?????? This question leads me to check the "Data sources" section of CDE.

Follow the steps below.

1) Click on the "sqloverjndi" which  you created for your SQL query.
2)  In the properties section you can find an option called "Output options". Just click on  it.
3) Lets say you have 3 columns in your result set and these 3 columns takes index values starting from 0 to n.. i.e., A column index is 0 , B column index is 1 and for the C  value 2 is the index.

  NOTE: if you have more numbers of columns you can give as many indexes by clicking "Add" button as many times.
4)For Chart 1:
  i) Click on the chart component where you want show A& B columns ( A is category B is value)
  ii) In the properties(Click on Advanced properties) click on "Pre Execution"
  iii) Write this below code
            function f() {
                                 this.chartDefinition.readers = [
                                 {names:category, indexes: 0},
                                  {names: value, indexes: 1},
                                    {indexs: 2}
                                    ];
             } 
  Why this {indexs:2} ? if you omit this the values of index2 append to the category names... to eliminate that problem you need to write it.

 5) For Chart2 :
 Repeat the steps in in point 4)
 Slight changes in code ...

function f() {
                                 this.chartDefinition.readers = [
                                 {names:category, indexes: 0},
                                  {names: value, indexes: 1},
                                    {indexs: 2}
                                    ];
             } 

You are done with reading data from single query of 3 columns where 1&2 for one chart and 1&3 for another chart...

Save your dashboard and see the preview.

Sadakar
BI developer 
( "Learning never exhausts the mind" )

Now your Paypal account is verified and use it by sending or receiving money and Gud luck...!

An ability to transform mere pictures into masterpieces is what makes Adobe Photoshop stand out from the crowd. Yes, this photo editing software has acted as a magic wand for designers who need to play with images in order to portray them in a visually appealing manner. The versatility of Adobe photoshop has made it the number one choice of photo editors all over the world. Whether it’s about creating a terrific photo or a tantalizing graphic, Adobe photoshop is the software that’ll make things possible for you.

Also Read: Top 8 Free Alternatives to Paid Softwares
Also Read: The 12 Best Tools To Protect Your Password

Adobe Photoshop- What all it offers to photo editors?
Adobe Photoshop is a user-friendly software that brings along a number of tools that can be used for editing and enhancing pictures for a brilliant look. In addition to re-shaping photos, it also allows you to design layouts that form the backbone of an image and even an entire website. Below, Ive listed out a few major benefits that can be availed upon choosing Adobe Photoshop:

Benefit #1- An opportunity to unveil the creative side of your personality
Adobe Photoshop allows you to go beyond limits of creativity. You can explore the available features and learn the process of using them for your own designs. In a way, you can find the method of polishing your designs and uncovering your creative skills in an impressive style.




Benefit #2- An opportunity to restore old/ worn out photos
In addition to offering you the flexibility of editing new photos, Adobe Photoshop allows you to restore your old pictures, thereby refreshing your memories of the past. You can use various tools such as healing brush, patch tools, clone stamps etc. to revamp your old photos for a brand new look.




Benefit #3- An opportunity to implement graphic design projects with utmost perfection 
Apart from offering you the ability to edit photos, Adobe Photoshop enables you to create cards, posters, banners etc from scratch. You can use the tools available with this software to come up with designs that are appealing and imbibed with a creative tint. Irrespective of the purpose behind designing a photo, Adobe Photoshop lets you transform your ideas into real designs.




Benefit #4- An opportunity to collaborate graphics with text
Graphic designing projects entail a combination of graphics and text. Adobe Photoshop not only allows you to combine photos with text but also enables you to find better ways of making the final product look artistic and appealing. Tools such as Drop shadows, Strokes, bevel and emboss aid you in emphasizing the text within the graphics. These tools are used for adjusting the brightness, contrast and exposure, pertaining to the graphics and images.




Also Read: The 5 Best Softwares for Remote Assistance
Also Read: Top 5 Tools to Create Interesting Infographic

Benefit #5- An opportunity to change the color of a photo
There are times when an image tends to appear boring because of its monotonous color. With Adobe Photoshop, you can easily customize the color of your photo as per your preferences. You can change the image color, add effects and edit parts using a wide collection of gradients available with Adobe Photoshop.




Benefit #6- An opportunity to do T-Shirt designs that are “IN” today and will continue to stay in trend in the coming year 2014 as well
A customized T-Shirt is what everyone’s talking about these days. It has become a latest fashion statement among young boys and girls. Photoshop is the tool that works best for designing graphics. These graphics look brilliant when printed on T-shirts. You can easily access the internet for information on designing a graphic for T-shirts.




Benefit #7- An opportunity to correct photography ambiguities
Not everyone is a professional photographer. Those of you who aren’t satisfied with the clicked photos can avail an opportunity of correcting the same using the Adobe Photoshop features. Whether it’s about covering up poor lighting, removing marks on the photo, adjusting red eyes or darkness; Adobe Photoshop enables you to enhance the picture for an scintillating appearance.




Benefit #8- An opportunity to add a professional tint into pictures
Photoshop allows you to transform your plain photo into a professional picture. You can choose to make the image a photocopied work or a stained glass art. The Filter tool enables you to design photos that reflect your creativity to the fullest. You can convert a theme-less photo into a real piece of art.




Also Read: The 5 biggest tech myths prevailing among common man
Also Read: How to Clean Laptop Parts with Simple Household Products

Benefit #9- An opportunity to edit photos while working in Cloud Computing environment
Recently, Adobe announced the launch of its new software customized for virtual workgroups. This Photoshop version is a souvenir for everyone who’s working in a cloud computing environment. All you need to do is simply subscribe to the service and you can get going by availing the photo editing features available with the Adobe Photoshop release. 




 Conclusion
Adobe Photoshop outputs are eye-catchy and definitely here to stay. Indulging in photo editing via Adobe Photoshop will allow you to hone your designing skills with each passing day. So, in the year 2014 you’ll be able to grow your graphic designing career in a result-oriented manner by serving appealing and innovative designs via Adobe Photoshop. 

If you’ve any questions to ask or want to share your feedback/suggestions on the above post, please feel free to fill in the comments box below. 

Author Bio:

Mike Swan is a specialist Web Designer at Markupcloud Ltd. a PSD to Wordpress Conversion company. He possess a huge experience in technology domain and loves all things comes under web Design niche. He is trying to spread his intangible knowledge to maximum people he can, in order to make a parallel platform.