Marka dadka intooda badan ay ka fekeraan falanqaynta xogta, waxay ku fekeraan inay wax ka beddelaan oo ku falanqeeyaan xogta qalab sida Microsoft Excel^{(like Microsoft Excel)} . Xaqiiqdu waxay tahay in falanqaynta xogtu ay ka kooban tahay qalabyo kala duwan iyo habab badan oo kala duwan si loo maareeyo loona fahmo sheekada ay xogtu sheegayso.

Waa maxay falanqaynta xogta? Falanqaynta xogta^(Data) waxaa loo isticmaalaa si aad u kala duwan haddii aad ka hadlayso xogta ganacsiga, xogta wax soo saarka, xogta suuq-geynta, ama xogta gaarka ah ee warshadaha iyo ganacsiga aad shaqeyso.

Maqaalkan, waxaad ku baran doontaa dhinacyada kala duwan ee falanqaynta xogta, waxa ay ula jeedaan, iyo sida guud ahaan loogu isticmaalo guddiga.

Xog ururinta^{(Data Collection)}

Marxaladda ugu horreysa ee falanqayn kasta oo xog ah waa xog ururin. Tani waxay si fudud uga dhigan tahay ururinta xogta dhammaan ilaha haya macluumaadka aad u baahan tahay.

Xogta waxaa ku jiri kara mid kasta oo ka mid ah kuwan soo socda iyo in ka badan:

• Xakamaynta mishiinada wax soo saarka
• Qof gacanta ku galinaya xogta kombayutarka
• Dareemayaasha cabbira heerkulka, cadaadiska, iyo in ka badan
• ^{(Cloud based)}Ilaha xogta ku salaysan Cloud
• Macluumaadka laga helo intarneedka sida cimilada ama xogta xogta dawladda
• Database-yada^(Databases) lagu keydiyo shabakadaada shirkadda

Caqabadda ugu weyn ee hay'addo badan ayaa ah inay ogaadaan qalabka farsamada ee la heli karo si ay u ururiyaan macluumaadkaas. Inta badan software-ka ayaa looga baahan yahay inuu ku xidho qalabkaas fog ama isha xogta ka dibna u soo jiid kaydinta gudaha ama nidaamka taariikhyahan xogta.

Meelahan kaydinta waxaa badanaa loo yaqaan "bakhaar xogta".

Marka macluumaadka lagu ururiyo bakhaarka xogta ee ururka dhexdiisa, qalab kala duwan ayaa loo isticmaali karaa si loo sameeyo falanqaynta xogta dhabta ah.

Sirdoonka Ganacsiga^{(Business Intelligence)}

Marka xogta la ururiyo, tallaabada xigta waa go'aaminta waxa lagu samaynayo dhammaan xogtaas. Marka ay timaado sirta ganacsiga, xogta loo baahan yahay waa in ay ka caawisaa ururka in uu sameeyo go'aamo ganacsi oo wanaagsan.

Warbixinnada Sirdoonka^{(Intelligence)} Ganacsiga (BI) iyo dashboard-yadu waxay caawiyaan maamulayaasha iyo hoggaamiyeyaasha kale ee ganacsiga inay si wanaagsan u fahmaan isbeddellada oo ay u helaan fikrado dhinacyada kala duwan ee ganacsiga ah. 

Dhinacyadan waxaa ka mid ah:

• Baahiyaha silsiladda sahayda ama xaddidaadaha
• Kharashka oo la dhimo
• Horumarinta iibka
• Baahida iyo dhaqamada macmiilka
• Odoroska iibka mustaqbalka ama baahida suuqa
• Saadka iyo dhoofinta

Ururinta xogta dhammaan nidaamyadan kala duwan ee ururkiina oo dhan waxay kuu oggolaanaysaa inaad dhisto xidhiidh ka dhexeeya macluumaadka laga yaabo inaan hore u suurtoobin.

Sirdoonka wax soo saarka^{(Manufacturing Intelligence)}

Dhibaatada marka ay timaado ururinta xogta hababka wax soo saarka ayaa ah in inta badan ay jiraan wax badan oo ka mid ah.

Haddii aad ka fikirto wax soo saarka caadiga ah, mishiin kasta oo ku yaala sagxada dukaanka ayaa ururisa daraasiin ilaa boqol dhibcood oo xog ah oo ay ku jiraan:

• Heerkulka iyo cadaadiska
• Qaybo ama alaab la sameeyay
• Wax cayriin ah oo la isticmaalo
• Qaybo xun ayaa la xoqay
• Tirinta cilladaha iyo qaylo-dhaanta

Xaaladaha intooda badan, qalabka wax soo saarka waxaa si toos ah u isticmaala isticmaalka kontaroolaha macquulka ah ee barnaamijka ( PLC ). Qalabkani maaha oo kaliya inay ku shaqeeyaan sida loo qorsheeyay, laakiin sidoo kale waxay ururiyaan oo ururiyaan xogta qalabkaas.

Helitaanka xogta PLC^(PLCs) -yada waxay ku lug leedahay software ku shaqeeya server-ka isla shabakadda PLC^(PLCs) -yada . Waxaa jira iibiyeyaal badan oo qoray software si ay xogta uga soo saaraan maamulayaashaas oo ay galaan taariikhyahan xogta ama kaydka xogta.

Hogaamiyayaasha taariikhyahanada xogta ee aaggan waxaa ka mid ah:

• OSIsoft : Shirkaddani waxay jirtay muddo tobanaan sano ah, waxaana ku jira "isku-dhafka" ama darawallada kuwaas oo ka heli kara xogta ku dhawaad ​​nooc kasta oo processor, dareemayaal, ama database.
• Factorytalk : Hogaamiyaha wakhtiga dheer ee iswada Rockwell Automation ayaa soo saaray taariikhyahan xogeed iyaga u gaar ah oo lagu magacaabo Factorytalk si ay uga caawiyaan macaamiishooda xog ururinta mishiinada. 
• Aveva : Horey loogu yiqiin Wonderware , AVEVA Historian wuxuu ballan qaadayaa inuu bixiyo "helitaanka furan" ee xogta mashiinka sida xogta habka, alaarmiga, dhacdooyinka, iyo in ka badan.
• Iconics : Ciyaartoyga yar ee suuqa taariikhyahanka xogta, sameeyayaasha Iconics waxay ballan qaadayaan inay bixiyaan "khariif xawli sare leh" si xalinta xogta la kaydiyo u dhigma wixii markii hore ka dhacay mashiinka.

Ku dhowaad dhammaan bixiyayaasha software-ka waxaa ku jira qalabyada falanqaynta xogta si ay ula socdaan xalalkooda taariikhyahan. Doorashada xog ururinta saxda ah iyo xalka falanqaynta ee xaruntaada wax soo saarka runtii waxay kuxirantahay kontaroolayaasha aad isticmaasho, sida aad rabto inaad u kaydiso xogta, iyo inta aad diyaar u tahay inaad kharash garayso.

Sawirka Xogta

Qalabka ugu caansan ee ururinta, falanqaynta, iyo sawirida xogta ganacsiga waa Microsoft PowerBI .

PowerBI waa qalab muuqaal awood leh oo ay bixiso Microsoft kaas oo kuu ogolaanaya inaad ka soo qaadato xogta ilo xogeedyo kala duwan. Waxaad markaa kala gooyn kartaa oo aad jarjari kartaa xogta oo dhan jaantusyada pie iyo bar, garaafyada laynka, miisaska, iyo in ka badan.

Awoodda isku-darka xogta laga helay ilo xogo kala duwan waxay kuu ogolaanaysaa inaad hesho xidhiidh aan hore suurtogal u ahayn. Tani waa sixirka falanqaynta xogta casriga ah. Waxay ku siinaysaa awoodda lagu helo aragtiyo aan waligood ka hor suurtogal ahayn ka hor qalab kuu ogolaanaya inaad sawirto xogta ilo badan.

PowerBI maaha abka kaliya ee awooda in lagu maamulo laguna sawiro xogta habkan. Dhab ahaantii, waxaa jira suuq u koraya oo loogu talagalay qalabkan oo kaliya. 

Aaladaha muuqalka xogta ee hormuudka ka ah maanta waxaa ka mid ah:

• Metabase : Xalka il furan (free) kaas oo naftiisa u oggolaanaya in dadka ku jira ururkaaga ay "su'aalo weydiiyaan oo ay xogta ka bartaan".
• Tableau : Waa goob xog-ururin caan ah oo loo isticmaalo warshado badan oo kala duwan. Isku^{(Connectivity)} xidhka ilo xogo kala duwan ayaa la heli karaa.
• Whatagraph : Caan ka ah wakaaladaha suuq geynta sababtoo ah way fududahay in la soo saaro warbixino si fudud loo fahmi karo. Qalabku waxa ku jira soo saarista warbixin toos ah oo si toos ah ayuu iimayl ugu diri karaa qof kasta.
• JasperReports : Tani waa xal kale oo ka-warbixineed il furan. Awooddu waxay ka timaadaa awoodda lagu soo saari karo warbixinnada qaabab badan oo kala duwan sida dukumeenti daabacan, PDFs , iyo warbixinnada ku saleysan shabakadda.

Doorashada aad go'aansato inaad raacdo runtii waxay kuxirantahay maalgashiga adiga ama ururkaagu aad rabto inaad sameyso. Mahadsanid waxaa jira fursado wanaagsan oo il furan oo la heli karo haddii taasi tahay meesha aad u baahan tahay inaad ka bilowdo.

Macdanta Xogta

Mid ka mid ah farsamooyinka cusub ee falanqaynta xogta ugu awoodda badan waa wax loo yaqaan macdanta xogta.

Macdanta xogtu^(Data) waxay diiradda saartaa adeegsiga qaabaynta tirakoobka si ay uga soo saarto jaantusyada iyo isbeddellada laga soo saaro mug weyn oo xog ah si loo saadaaliyo isbeddellada mustaqbalka. 

Codsiyada samayn kara falanqaynta tirakoobka macdanta xogta waa kuwo aad u khaas ah oo badanaa waxay u baahan yihiin in lagu habeeyo codsiga ama xaaladda gacanta.

Noocyada falanqaynta xogta macdanta waxaa ka mid ah:

• Falanqaynta Xogta Sahanka^{(Exploratory Data Analysis)} ( EDA ): Tani waxay ku lug leedahay raadinta qaababka xogta si loo aqoonsado isbeddellada cusub ama loo barto macluumaad cusub.
• Falanqaynta Xogta La Xaqiijiyay^{(Confirmatory Data Analysis)} ( CDA : Tani waxay ku lug leedahay adeegsiga dhammaan xogta la ururiyay si loo isku dayo loona go'aamiyo in isku xirnaanta la tuhunsan yahay ay run yihiin.

Qaar ka mid ah aaladaha software-ka macdan qodista hormuudka ka ah ee laga heli karo suuqa maanta waxaa ka mid ah:

• Macdanta degdega ah^{(Rapid Miner)} : Waa hab aad u wanaagsan oo ah habka falanqaynta saadaalinta il furan oo ku qoran Java . Waxay awood u leedahay barashada mashiinka, falanqaynta saadaalinta, iyo macdanta qoraalka.
• Sisense : Software-ka shatiga leh ee loogu talagalay sirta ganacsiga, oo awood u leh in uu kor u qaado ururada waaweyn. Waxa ku jira qayb warbixineed oo heersare ah.
• Oracle : Mid ka mid ah magacyada hormuudka ka ah warshadaha xogta, Oracle wuxuu bixiyaa sifada macdan qodista gudaha SQL taasoo u ogolaanaysa ururadu inay isticmaalaan xogta lagu kaydiyay xogta Oracle .
• IBM Cognos : Software-kani waxa uu awood u leeyahay in uu farsameeyo tiro badan oo xog ah si loo aqoonsado isbeddellada muhiimka ah. Kuwaas waxaa loo isticmaali karaa in lagu soo saaro warbixinnada maamulka ama kuwa kale.
• SAS : Magac kale oo weyn oo ku jira warshadaha xogta, Nidaamka Falanqaynta Tirakoobka^{(Statistical Analysis System)} ( SAS ) ayaa si gaar ah loogu talagalay in lagu miinada, maareeyo, iyo xitaa cusboonaysiinta xogta ku salaysan natiijooyinka falanqaynta.

Sida aad arki karto, waxaa jira wajiyo badan oo loo adeegsado falanqaynta xogta iyo qalabka aad u baahan tahay inaad isticmaasho runtii waxay kuxirantahay waxaad rajaynayso inaad ka barato xogtaas.

Horumarka falanqaynta xogtu way sii socotaa sannad kasta, shirkad kasta ama urur kasta oo rajaynaya inuu ku sii jiro warshadahooda waxay u baahan yihiin inay ku sii jiraan waxa ugu sarreeya qalabka falanqaynta xogta ee la heli karo iyo inay u adeegsadaan awooddooda ugu fiican.

What Is Data Analysis And The Best Tools To Use

When mоst people think of data analysis, they think of manipulating and analyzing data in a tool like Microsoft Excel. The reality is that data analysis encompasses a wide range of tools and a lot of different methods to manipulate and understand the story that the data tells.

What is data analysis? Data analysis is used very differently if you’re talking about business data, manufacturing data, marketing data, or data specific to the industry and business that you operate.

In this article, you’ll learn about the different aspects of data analysis, what they mean, and how they’re generally used across the board.

Data Collection

The first stage of any data analysis is data collection. This simply means gathering data from all of the sources that hold information you need.

Data can include any of the following and more:

• Manufacturing machinery controllers
• Someone manually entering data into a computer
• Sensors that measure temperature, pressure, and more
• Cloud based data sources
• Information from the internet like weather or government databases
• Databases housed on your company network

A major challenge for a lot of organizations is figuring out what technical tools are available to gather that information. Most of the time software is required to connect to that remote device or data source and then pull them into an internal database or data historian system.

These storage areas are often referred to as a “data warehouse”.

Once information is collected into a data warehouse inside an organization, various tools can be used to conduct the actual data analysis.

Business Intelligence

Once data is collected, the next step is deciding what to do with all that data. When it comes to business intelligence, the required data should help an organization make better business decisions.

Business Intelligence (BI) reports and dashboards help managers and other business leaders better understand trends and gain insights into various aspects of the business. 

These aspects include:

• Supply chain needs or limitations
• Reducing costs
• Improving sales
• Customer needs and behaviors
• Predicting future sales or market demands
• Logistics and shipping

Gathering data from all of these different systems throughout your organization lets you build connections between information that may never have been possible before.

Manufacturing Intelligence

The difficulty when it comes to gathering data from manufacturing processes is that usually there’s just so much of it.

If you think about a typical manufacturing facility, every single machine on the shop floor collects dozens to hundred of data points that include:

• Temperatures and pressures
• Parts or product made
• Raw material used
• Bad parts scrapped
• Malfunction counts and alarms

In most cases, manufacturing equipment is automated by the use of a programmable logic controller (PLC). These devices not only run the equipment according to how they’re programmed, but they also collect and gather data from that equipment.

Getting data out of those PLCs involves software that runs on a server on the same network as those PLCs. There are many vendors that have written software to get data out of those controllers and into a data historian or a database.

The data historian leaders in this area include:

• OSIsoft: This company has been around for decades, and includes “integrators” or drivers that can get data out of almost any kind of processor, sensor, or database.
• Factorytalk: Long time automation leader Rockwell Automation produced their own data historian called Factorytalk to help their customers collect data from machine processors. 
• Aveva: Formerly known as Wonderware, the AVEVA Historian promises to provide “open access” to machine data like process data, alarms, events, and more.
• Iconics: A smaller player in the data historian marketplace, the makers of Iconics promise to provide “high-speed archiving” so the stored data resolution matches what originally occurred on the machine.

Nearly all of these software providers include data analysis tools to go along with their data historian solution. Choosing the right data collection and analytics solution for your manufacturing facility really depends on the controllers you use, how you want to store the data, and how much you are willing to spend.

Data Visualization

The most popular tool for collecting, analyzing, and visualizing business data is Microsoft PowerBI.

PowerBI is a powerful visualization tool offered by Microsoft that lets you bring in data from many different data sources. You can then slice and dice the data across various pie and bar charts, line graphs, tables, and more.

The ability to combine information from various data sources lets you find correlations that wouldn’t have been possible before. This is the magic of modern data analysis. It provides the ability to gain insights that were never before possible before tools that let you visualize data from many sources.

PowerBI isn’t the only app with the ability to manipulate and visualize data in this way. In fact, there’s a growing market for just these types of tools. 

The leading data visualization tools today include:

• Metabase: An open-source (free) solution that touts itself as letting people in your organization “ask questions and learn from data”.
• Tableau: A popular data visualization platform used across many different industries. Connectivity with many different data sources is available.
• Whatagraph: Popular among marketing agencies because it’s easy to produce easy-to-understand reports. The tool includes automated report generation and can automatically email those to anyone.
• JasperReports: This is another open-source reporting solution. It’s power comes from the ability to output reports in many different formats like printed documents, PDFs, and web-based reports.

The option you decide to go with really depends on the investment you or your organization wants to make. Thankfully there are excellent open-source options available if that’s where you need to start.

Data Mining

One of the most powerful new data analysis techniques is something called data mining.

Data mining focuses on using statistical modeling to pull patterns and trends out of a large volume of data in order to predict future trends. 

The applications that can perform data mining statistical analysis are highly specialized and often need to be customized to the application or situation at hand.

Types of data mining analysis include:

• Exploratory Data Analysis (EDA): This involves searching for patterns in data in order to identify new trends or learn new information.
• Confirmatory Data Analysis (CDA: This involves using all of the collected data to try and determine whether suspected correlations are true.

Some of the leading data mining software tools available on the market today include:

• Rapid Miner: An excellent open-source predictive analysis system written in Java. It’s capable of machine learning, predictive analysis, and text mining.
• Sisense: Licensed software tailored for business intelligence, with the ability to scale up for large organizations. It includes an excellent reporting module.
• Oracle: One of the leading names in the data industry, Oracle offers data mining feature within SQL that lets organizations use data stored in an Oracle database.
• IBM Cognos: This software is capable of processing large volumes of data to identify important trends. These can be used to generate reports for management or others.
• SAS: Another big name in the data industry, Statistical Analysis System (SAS) was specifically designed to mine, manage, and even update data based on analytical results.

As you can see, there are many facets to data analysis and the tools you need to use really depends on what you hope to learn from that data.

Advancements in data analysis continue to advance every year, and any company or organization that hopes to stay ahead in their industry needs to stay on top of what data analysis tools are available and to use them to their fullest potential.

Related posts

• Xcode for Windows (8 Qalabka ugu Wanaagsan ee lagu Sameeyo IOS Apps ee PC)

• Waa maxay Adeegga Wicida Shirka ugu Fiican - Apps-ka ugu Wanaagsan marka la barbardhigo

• 5-ta Apps ee ugu Fiican ee Shaandhaynta Iftiin Buluugga ah ee loogu talagalay Windows, Mac iyo Linux

• 4-ka ugu Wacan ee Soo Gudbinta Barnaamijyada Software-ka iyo Sida Loo Isticmaalo

• 10ka Qarsoon ee ugu Fiican Chrome (2022)

• Turjumaada Google iyo Turjumaada Bing - Keebaa Wanaagsan?

• 8 Barnaamijyada Software-ka ee bilaashka ah ee 8 ee ugu Wanaagsan si loogu beddelo Sawirrada Qoraal

• Waxyaabaha ay tahay inaad tixgeliso ka hor intaadan abuurin Wiki adiga kuu gaar ah

• 19-ka ugu Wanaagsan ee Keyboard Keyboard Powershell

• Soo kabashada Faylka Microsoft ee Windows ma shaqeeyaa? Waanu Tijaabnay.

• Parser-ka Iimayl-ka Zapier: 3 Hab oo Hal-abuur leh oo Loo Isticmaalo

• Tababarka Qorsheeyaha Microsoft: Wax kasta oo aad u baahan tahay inaad ogaato

• Sida loo Isticmaalo Maamulaha Xidhmada Windows si loo rakibo Barnaamijyada Windows

• Isbedelka IFTTT ugu fiican

• 5 Goobaha ugu Badbaadsan ee APK ee lagu soo dejiyo Apps Android

• Waa maxay Microsoft Power Automate iyo Qaababka bilaashka ah ee la soo dejiyo

• Tifaftirayaasha Markdown-ka ee Bilaashka ah ee ugu Fiican

• 5 Apps oo la qaadi karo oo aad rabto in aad ku haysato USB stick

• 7-da Aaladaha ugu Fiican ee ka saarida Bloatware ee Daaqadaha

• Sida loo hubiyo in heerkulka CPU-gaagu uu aad u sarreeyo