How to organize your SQL code ?

If you’re an analyst or if you need to write quite often SQL code for deep-dive analysis or dashboard building, one thing you might consider is how you need to structure your code. Think about it. 6 months after starting deep-diving on multiple topics you’ll be literally buried by the amount of files filled up with code and finding what you wrote 3 months ago will be … quite challenging. Stakeholders will come to you or you will need to update a data extraction, an analysis: if you haven’t stored your code, you’ll spend an incredible amount of time just searching...

How to use the command line on MySQL ?

If you’ve been using the command line on Linux, there’s no doubt you would already have fallen in love with it. Convenient, easy to use and powerful – on top of giving the “nerd” effect on your colleagues. When it comes to database and tables, MySQL has a huge advantage over many of its competitors: its command line client. When most of the users barely use PhpMyAdmin or log to their database using a SQL client like workbench, for easy and simple queries, the command line interface can be quicker to use – and undoubtedly more lightweight. You will be able in the blink...

Kaggle, the place to be for data scientists

Kaggle is quite a new platform but actually pretty cool if you love data and data science. The purpose of Kaggle is to gather a community of data scientists around data analysis and prospective analysis. Firms can launch competition between analysts from all around the global who will jump in, trying to solve forecasting issues. The inscription to the website is free and quite easy to do, you can also do a Facebook connect or a Google connect. Easy then, registration doesn’t take more than 1 minute. Kaggle is also a good platform to learn how to get into Data...

How to change your display manager on Debian ?

A display manager is a graphical interface which manages everything related to your session: login, password, generally appearing at the end of the boot process. This interface is clearly more user friendly that just the command line being prompted… While just the shell prompt is ok for headless servers, a PC user will enjoy Linux via a graphical interface. If there’s a cool thing with Linux, it’s all the possibilities one can have to customize the interface. You can decide which environment you like most, find some really complete ones or very lightweight ones, it’s really up to you to decide which...

Teradata studio is worth trying

If you’ve been working using Teradata SQL assitant, you might have noticed that not only the interface is kind of “old school” but the functionalities are also quite limited. Changing the client interface is complicated, fine-tuning the colors used and finding the right balance between the colors can be tricky, auto-completion is not that fast if you have quite a huge data model. Aside this poor user interface, teradata has also a whole set of sub softwares aiming at making developers’ life easier, like fastLoad – which purpose is to make it easier to upload csv or excel files into a database....

How to change all your passwords on linux with one single command ?

If you use Linux and have your passwords written among multiple files, you might want or need to update your password from time to time for obvious security reasons. Companies generally want their employees to update their password quite frequently – or might want to do so if you think your current password might has been compromised. The downside is that you might have to go each single file and need to update manually your passwords – otherwise some cron jobs won’t run as moving forward. Manual update? You’re kidding, right? Yes. To update your password, this is super easy....

Why documentation and community really matters for softwares

When it comes to acquire and install a software, just focusing on the actual features, the price and the latest releases is clearly not enough: Community and documentation are two element that one must not overlook. So you’re curently looking for a software, hesitating between different solution. Your friends, colleagues and sales people tried to push you in one direction and in another, everytime putting the light on different features, on why the software is more powerful, why it is easier to use than the others in the same category, why this user interface is more intuitive and so on. No...

Tableau Software or Qlikview ?

The title seems to be quite provocating since both solution actually have strong partisans in both side. When you work in the data analysis field and data visualization, debates are frequent for analysts when it comes to defend which is the best solution. Analysts tend to have their own habits, sticking to the same tool for the last couple of years, and really, no one enjoy change. Change is scarying – hence the both side of it. Qlikview is a really nice tool when it comes to data manipulation and data preparation before building a visualization. Qlikview embeds a scripting engine which basically allows every...

Introducing mySoftwareGate.com

I don’t know if you’ve ever noticed how hard finding the right software was. That’s right, there litteraly thousands of softwares exisiting on the market. When you think marketing software, then you have also thousands of software available depending on each speciality: lead retention, customer on-boarding, communication, customer relationship management and so on. The list is just incredible. This is the purpose of mySoftwareGate.com: to help you find the right software for your needs. Our mission is very clear as you can see and we’ll stick to this one. As moving forward, we’ll introduce new features, new improved search functionalities, comparision features… as bigger...