Thursday, January 12, 2012 7:25:00 PM
Today we saw how you can build a 'FTP Client' application using Excel, Access and VBA.
As advantages of a custom application like this, we highlight the possibility of automation of repetitive tasks - and therefore unnecessary, or at least capable of being improved.
...
read more
Monday, December 19, 2011 11:21:00 AM
The conversion of Coordinates to Addresses is an issue that arouses interest from many areas, not just Telecom.
//
And one reason is that this mapping is increasingly present in our day-to-day, for example when we receive a list of Addresses, and we need to make such a coverage analysis at each point.
There are several ways to obtain this conversion from a manual to fully automated type. But when we don't have a standard procedure to obtain these data, we ended up wasting a...
read more
Friday, December 09, 2011 12:57:00 PM
Microsoft Office Excel without any doubt is one of the most used program when we need to do Data Presentations such as charts and graphs.
//
When Data are showed in tables, a feature also commonly used are the filters, to limit the records of the table based on certain criteria.
The Excel Filter options are already good, but we can always do a little better, especially in the issue of improving the the user experience and interactivity.
For example: we can quickly filter...
read more
Thursday, October 27, 2011 2:55:00 PM
There's no doubt the main objective of Telecommunications Engineers is to get the best possible performance of the system, in terms of Call Quality, Dropped and Block Rates, QoS and Data Speed, Availability of the Network or any other indicator.
//
With the Excellence of Performance, it's easier to increase the customer base and also increase its satisfaction. You can also do a better resources management - OPEX and CAPEX, that can be translated into significant gains also in ...
read more
Thursday, September 29, 2011 6:59:00 PM
Frequency Planning and Neighbor List Verification are two major tasks required to ensure an efficiently Optimized Network.
//
This analysis can be done in several ways, and one of them is by checking geo-referenced plots, where possible problems of 'Interference' or 'Missing Neighbors' can be easily identified.
Google Earth is a good place for this type of inspection, but Mapinfo also has its advantages - especially in terms of interactivity (eg it is easier to create an...
read more
Monday, September 19, 2011 9:17:00 PM
One advantage of working with an organized and integrated modules - such as the methodology suggested by Hunter - is the gain that this scenario provides. Let's begin to understand how this works with the module 'Hunter Updater'.
//
Currently we have the main databases with our information (Network, Parameters, and Performance).
And we also have a number of other external tools we use in every way, in daily work, and the data update for them is crucial to the outcome of the...
read more
Wednesday, September 07, 2011 9:42:00 AM
Moving forward in the creation of our entire System for our Network Monitoring and Analysis, today we'll see the next step: defining the KPI Base Tables.
//
These tables are extremely important, as it will be from it we'll create several applications, using algorithms and intelligence. From these tables, we easily create charts and dashboards, reports, and all that is necessary for a quick and efficient analysis, always following our simplified methodology.
Note: Again,...
read more
Monday, August 29, 2011 3:36:00 PM
Network Performance Monitoring is certainly one of the most important activity in the daily work for all people involved. So we're beginning today several tutorials related to Performance / KPI, this big challenge, whatever the area of Telecom & IT.
//
When we improve the Performance, we also improved customer satisfaction - reducing its complaints. In addition, we maximize revenue (fewer drops, fewer blockages, fewer failures: more calls, more quality, more...
read more
Sunday, August 07, 2011 9:52:00 PM
One of the most important tasks for an efficient control of a cellular network is to ensure that all of its Configuration Parameters (GSM, UMTS, LTE ...) are properly adjusted.
//
Any one parameter, incorrectly configured can cause real damage to the Performance, and therefore to Customer Satisfaction. And the time it takes to find such a problem is unnecessary - since the problem could be easily and quickly found by an efficient and automatic algorithm.
The causes for...
read more
Thursday, July 21, 2011 3:14:00 PM
With the plot of the network information (sites and cells) in a geo-referenced way, we can greatly benefit from an easier and more intuitive visualization of it, and it also helps identify problems such as misdirected cells (azimuths).
//
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic translator, with only a final and...
read more
Thursday, June 16, 2011 6:13:00 PM
After several tutorials to familiarize with the Hunter methodology, let's continue now with more practical applications, ready to use on a daily basis.
//
Today we see the application responsible for creating KMZ files from text files or Microsoft Excel spreadsheets, exported from any commercial Drive Test Software.
Who knows the power of custom tools will be amazed how, with a little creativity, we have simple solutions but they leave nothing to be desired in relation to...
read more
Monday, May 16, 2011 8:23:00 PM
One of the keys to the success of all activities of the Network is to collect all information of the configuration parameters (GSM, UMTS, LTE ...) on a single and updated database.
//
From this base (parameters database) we can accomplish a lot of actions, with benefits of several types: audit parameters, accurate reporting, plotting to Google Earth and Mapinfo, updating other databases and other tools such as drive test etc..
If you're reading this tutorial, you probably...
read more
Friday, May 06, 2011 2:23:00 PM
Let's talk today about organization, especially the documentation of sites in a cellular network. Quite simply, let's see how this information can work to our advantage.
//
We like and agree with a famous phrase used in IT: "Every non-hierarchical structure tends to become obsolete."
But what does this have to do with me? Let's talk a little more about it, and then you decide for yourself whether the suggested practices apply to you, or you can help.
So here we go.
...
read more
Monday, April 18, 2011 8:21:00 PM
At first glance, this is a subject that seems to be not so important, or at least not have much relationship with Telecom and IT.
//
But then answer the following question: "If your boss asks you to do a draft, an outline of the installation of a site on the rooftop of a building, how would you get it? What are the minimum information that such a design should contain?"
So, even if it seems a simple matter, it's worth talking a little about it. Even if only to remind...
read more
Friday, March 11, 2011 11:44:00 AM
Returning to post blog entries in telecomHall Blog for Telecom and IT developers, let's start with small suggestions - procedures - of work that simplify our day to day.
//
This tutorial is fast and simple, but serves to resume the development in this section.
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic translator,...
read more
Thursday, November 18, 2010 3:37:00 PM
Hello everybody. As we all know, due to the numerous problems encountered in the development methodology telecomHall, I stopped sending macros, code, files, etc.. Of course, I have suspended the accounts of all subscribers until then, they are no longer charged for anything more.
//
However, many of you asked me to continue, even though he was just teaching some algorithms, standard procedures, etc.. And I've had articles ready for publishing weekly. Anyway, the tool, or...
read more
Tuesday, July 27, 2010 8:00:00 PM
Hello The tutorial today is slightly different from those you have been following. It is time we present in our news portal.
//
So today we'll learn a new feature available on our website: The Forums!
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic translator, with only a final and 'quick' review). We apologize and we...
read more
Tuesday, July 20, 2010 8:00:00 PM
Let's enjoy that we already have some KPI's in our tables, and have a little review on how to use this kidn of data in Mapinfo.
//
In our today's tutorial, we'll learn how to work with georeferenced data for KPI's, an excellent way to display reports and allowing a quick inspection of the network.
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we ...
read more
Tuesday, July 13, 2010 8:00:00 PM
When we talk about or KPI in Performance Analysis, what immediately comes to mind? While the answer to this question is particular to each person, we can think of a general answer in a report: a table, chart, map or even a combination of all.
//
No matter what the format of this report is, it is correct to state that it serves to tell us a comparison of indicators. This comparison may be on a fixed value, or on a different magnitude, among others. These are the 'algorithms'...
read more
Tuesday, July 06, 2010 8:00:00 PM
We have already learned how to plot the information of coverage (Signal Level) of any network - GSM, UMTS or any other technology - based on data from a text file on Google Earth. We have also seen how interfaces can be easily created in Access to interact with applications.
//
Today we go a bit further, and learn how to plot the data for Best Server of any network, and now we start to use user interfaces, always seeking a better user experience - even if those users be...
read more
Tuesday, June 29, 2010 8:00:00 PM
We've already learned some applications using System Hunter, mainly using VBA and Access and Excel. Except that until now, we need to run any of it - for example Hunter GE Network, which plots the network information sectors in Google Earth - we neede to use methods not so friendly, like running macros directly in the program interface or the VBE environment.
//
But when we talk about applications, the first thing that comes to mind is an interface, does not it? Okay, the way ...
read more
Tuesday, June 22, 2010 8:00:00 PM
The KPI is a major part in any cellular network. And the same skills to analyze, therefore, a major task for us who work in this area. So, let's see a little of both today: more theoretical knowledge that we will use from now on in several modules that work with KPI Hunter, and a little Access database, specifically to learn to work with data in tables and queries.
//
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and...
read more
Tuesday, June 15, 2010 8:00:00 PM
Hello! If you are following all the tutorials, you've seen that we can represent our network through geo-referencing tools such as Mapinfo and Google Earth, and also that with this kind of tools we can perform tasks such as analysis of drive tests. But there are other important ways to evaluate a network, one, probably the main one, is through the analysis of statistics, and this is what we'll start seeing today.
//
Start? Yes, start, because the analysis of statistics is a...
read more
Tuesday, June 08, 2010 8:00:00 PM
As we mentioned before, Drive Test is important for a more complete analysis of the network. The various post-processing tools available have a complete set for this analysis, but sometimes our work can be much simplified, and why not, sometimes getting a better result.
//
This is particularly the case for the custom processing of drive test - we can not even have the power of algorithms and details of some software, but we got results surprisingly simple and efficient. Today ...
read more
Tuesday, June 01, 2010 8:00:00 PM
We already learned some important concepts for Network plotting data on Google Earth. Today we will improve a little our application (Hunter GE Network) in order to achieve a more professional result and that allows to work with layers of various technologies.
//
In addition, we will learn what styles are and how they are used in a simple way to achieve amazing results, not only for the purpose that we see today, but also in creating thematic maps on whatever the application...
read more
Tuesday, May 25, 2010 8:00:00 PM
One of the applications we use a lot from now on in several modules of the Hunter is sending e-mails. Whether to send the result of an analysis, a periodic report, a check of parameters, or any other purpose, sending automated e-mail saves us considerable time in formatting, minimizes errors, among other advantages that we will soon.
//
So, let's take a break location based on modules, which mainly use Mapinfo and Google Earth, and return to work a little harder with Access...
read more
Tuesday, May 18, 2010 8:00:00 PM
The representation of sectors across our network of lines as we have seen is sufficient for several tests. However, it is sometimes more interesting to work with symbols instead of simple lines, such as the sector represented by a symbol like a rose petal. Today we will create our first program Mapbasic - where we'll see how this is done.
//
Note: Almost all tutorials have related files, which are sent to Subscribers.
If you are a Subscriber, please check the received ...
read more
Tuesday, May 11, 2010 8:00:00 PM
Databases: If you have not used, believe, will use! Are very important as an adjunct to many tasks of analysis and reporting.
//
For example, in a report with the municipalities more offenders dropped calls can make a table. But we can make a thematic map. Which is better? Note the picture below and draw your own conclusions.
Databases are also essential tools for predicting how the Asset3g Aircom or x-Wizard of Optimi. In the prediction tools, the databases are the way ...
read more
Tuesday, May 04, 2010 8:00:00 PM
The analysis of drive test are key to any kind of telecom professional, either in the implementation of data collection or just in the analysis. Although through the analysis of KPI's you can identify problems like dropped calls, the drive tests allow a deeper analysis in the field. Identifying areas of each sector of coverage, interference, among others.
//
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish....
read more
Tuesday, April 27, 2010 8:00:00 PM
In the previous tutorial, we had our first contact with Mapinfo and Mapbasic. We had a brief introduction to Mapinfo, and also how to use Mapbasic - your programming language without having Mapbasic installed. Although soon we will see a series of programs Mapbasic, today we will take the opportunity and not let us use the Mapbasic itself, through the interface of your program. Alternatively, we learn a new concept that can be learned and that we also use a lot, not only with the MapInfo:...
read more
Tuesday, April 20, 2010 8:00:00 PM
The geo-referenced analysis are widely used in the field of Telecom and IT. Up to now use some programs Access and Google Earth to facilitate the acquisition of geo-referenced data, but there are several other tools as good as these, and also widely used. This is the case for example of MapInfo, which still uses SQL and also has its own language automation - the Mapbasic. Today we will have our first contact with him, and some tips for using the program. Later we will return to using Google...
read more
Tuesday, April 13, 2010 8:00:00 PM
The data from our network - sites and sectors - are already automatically plotted on Google Earth, so good. But the presentation of data can be much better. We saw how to change the characteristics of sectors and sites manually through the interface of the program. Today we will learn how to make a series of improvements that can be done to make this data much more organized and presentable.
//
Note: All telecomHall articles are originally written in Portuguese. Following...
read more
Tuesday, April 06, 2010 8:00:00 PM
Plot the data from our network of sites on Google Earth has been the beginning, and we had our first contact with the way this is done. Equally or more important that information from websites is the information sector, however, is viewing the sectors of our BTS's.
//
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is short, maybe you find some typos (sometimes we just use the automatic...
read more
Tuesday, March 30, 2010 8:00:00 PM
It's a fact and nobody can deny today's extreme importance of Google and the tools that are part of it. And one of these tools is Google Earth, a really great help to our area of Telecom and IT, although it is used for numerous other applications. But generally people use only a small part of its potential, as individual users. However, knowing a few secrets, you will stand out easily.
//
Note: All telecomHall articles are originally written in Portuguese. Following we...
read more
Tuesday, March 23, 2010 8:00:00 PM
Ready to start? So here we go. This is the first contact with the practical development. We will start our system from scratch, from the network data to the tools designed to be used in it. Surely it would be a long journey, because there are undoubtedly a lot to explore. But we also believe will be increasingly productive and rewarding for all. So let's not waste time, and start.
//
Note: All telecomHall articles are originally written in Portuguese. Following we translate ...
read more
Tuesday, March 16, 2010 8:00:00 PM
Before we begin our project, it is essential to understand some concepts and definitions, which are widely used, and which will serve as the basis for the commencement of work involving telecommunications, IT and Programming. From this point, we apply the methodology of teaching telecomHall, removing any doubts and are preparing to proceed.
//
Note: All telecomHall articles are originally written in Portuguese. Following we translate to English and Spanish. As our time is...
read more
