Tuesday, September 01, 2015 2:21:00 PM
If you work with telecommunications, it is very likely that already has come across the following request: generate a map in Google Earth (kml file) from a table with latitude, longitude and some other basic information.
This task may seem simple, but if you've tried to do it, probably realized that it is not as easy as it sounds!
Many people don't even know where to start: ask for a friend to help, do a good 'Google Search', among other efforts.
What happens is that as this... read more
Wednesday, March 26, 2014 5:46:00 PM
The reach area of each cell of the network directly affects the efficiency of the system in terms of Quality, Capacity and Coverage.
Therefore it is essential that each one be perfectly adjusted. These adjustments include changes to the configuration parameters (eg, for load balancing), and also adjustment of physical parameters.
In the latter case, the adjustment of tilts and azimuths (and sometimes height) of the antennas is a key factor in achieving the best possible results.
The... read more
Wednesday, October 30, 2013 9:03:00 AM
We're starting a new sequence of Hunter Tool tutorial. In today's tutorial we will see the module 'Hunter GE Propagation Analyzer', which deals with Performance counters collected data and plots them in Google Earth.
That way we can perform different types of analysis, as shown in detail in tutorial Analyzing Coverage with Propagation Delay - PD and Timing Advance - TA (GSM-WCDMA-LTE), whose reading is highly recommended before proceeding.
Note: as always the files from this... read more
Thursday, June 28, 2012 7:49:00 PM
Hello. We will continue the series of Hunter Tool modules, showing today the module responsible for the plot of Network Performance (KPI) in Google Earth.
Needless to say: the analysis of Performance indicators (KPI) is an essential task to evaluate any system.
As one ... read more
Friday, March 23, 2012 8:28:00 AM
Hello friends, today we will talk about a small change in our presentation way, or the methodology of Hunter tutorials, mainly due to user requests.
Until today, all tutorials were written so extensively, aiming mainly to allow an easy understanding of everything that was needed so that all users could learn how to use their own tools available, such as Microsoft Access and Google Earth.
To do this, in several tutorials, we extensively detailed the use of Access and VBA, demonstrating how we... read more
Thursday, January 12, 2012 7:25:00 PM
When you need to access a specific FTP server and download or upload one or more files, the best option is to use the standard FTP programs, like the one we recommend: Filezilla.
However, when this task has become repetitive, as when we download daily files from multiple OSS (via FTP), then it's better to automate it - less wasted time, minimize errors, etc..
And a way to automate the execution of FTP is to create a Windows application that performs the work.
Let's ... 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
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
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 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, 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 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