CODING & ANALYTICS by Gbenga Oridupa

My major Cloud Computing players; AWS, Azure and Google. Choosing one is the most difficult task for those that wants to enter and grow in the cloud world. With the continuous growing importance of Cloud Computing services nowadays, demand is on the high side. Cloud service providers supply resources like database, applications, and storage over the internet to reduce the cost of managing and maintaining your IT systems. Services/Products offered: 1. Software as a Service (SaaS): Software as a service is a software licensing and delivery model in which software is licensed on a subscription basis and is centrally hosted. 2. Infrastructure as a Service (IaaS): Infrastructure as a service refers to online services that provide high-level APIs used to dereference various low-level details of underlying network infrastructu...

Welcome back guys. Just like i said in my previous post, getting started with Data Analysis Expressions (DAX) can be intimidating, but becoming knowledgeable will guide you through unlocking new insights into your data. I believe the following DAX functions can get you started on the right path. Let’s work through some common business scenarios. 1. FILTER: The FILTER function is used to return a subset of a table or expression, as shown below. Let’s say that you want to get a count of items sold based on specific amount range.e.g Amount between 150 and 250. We will use the COUNTROWS function (Just like the name, it counts record), which counts the number of rows in the specified table, along with the FILTER function to achieve this: Count of sales between 150 and 250 = COUNTROWS(FILTER('Sales', 'Sales'[Sales...

This is just an overview of DAX language . We will begin calculations and extensive analysis on my next post.Enjoy. What is DAX?: Data Analysis Expression(DAX) is a Functional Language currently used in Power BI Desktop ,Analysis Services Tabular and Power Pivot for Excel. It is a collection of functions that can be used to calculate and return one or more values. In DAX, functions can contain other, nested functions and value references depending on your model and key business questions to be answered. DAX includes some of the functions used in Excel formulas plus other functions designed specifically to work with relational data and perform dynamic aggregations. Why DAX?: The difficult questions raised facing a business or an organization can be simplified using DAX, to shed more light into your data. Learning how to create effective DA...

So people have been asking me to give some details on MapReduce concept. This is a very interesting topic to write about. If you have read my previous post, you would have seen my introduction to Big Data and Hadoop. Now I am going to talk about MapReduce has the heart of Hadoop. Some of you might be new to this, but do not worry, it is going to be described in a way you will quickly understand. To Java developers, it might be much easier, but if you do not have experience in java skills, you can still learn some basic java and master MapReduce. MapReduce is a programming framework that allows performance of distributed and parallel processing on large data sets in a distributed environment. I am talking massive scalability across hundreds or thousands of servers in a Hadoop cluster. Just imagine that for a second. If you see in the diagram above, we have the “Input, Map task, Reduce task ...

What is Scala?: Scala combines object-oriented and functional programming in one concise, high-level language. Scala's static types help avoid bugs in complex applications, and its JVM and JavaScript runtimes let you build high-performance systems with easy access to huge ecosystems of libraries. What is Python?: Python is an interpreted, object-oriented, high-level programming language with dynamic semantics. Its high-level built in data structures, combined with dynamic typing and dynamic binding, make it very attractive for Rapid Application Development, as well as for use as a scripting or glue language to connect existing components together. Both Python and Scala programming languages offer a lot of productivity to programmers. They are useful tools among data scientists. Most learn both languages for Apache Spark. However, majority prefer Scala to ...

Big Data! Yes, do you really know what exactly it is, and its influence to the world today?. In order to understand the term 'Big Data' , we first need to know what 'Data' is. Oxford dictionary defines 'data' as - "The quantities, characters, or symbols on which operations are performed by a computer, which may be stored and transmitted in the form of electrical signals and recorded on magnetic, optical, or mechanical recording media. " Now imagine what ‘Big Data’ is. Big Data is a term used for a collection of data sets that are large and complex, which are difficult to store and process using available database management tools or traditional data processing applications. Examples of Big Data: The following are some of the examples of 'Big Data'- The New York Stock Exchange g...

Firstly;  .NET DataProvider -- Standard Connection with username and password: Put this at the top of your code: using System.Data.SqlClient; Put this  in your code body: SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=ServerName;" + "Initial Catalog=DataBaseName;" + "User id=UserName;" + "Password=UserPassword;"; conn.Open(); Secondly;  .NET DataProvider -- Trusted Connection: Put this at the top of your code: using System.Data.SqlClient; Put this  in your code body: SqlConnection conn = new SqlConnection(); conn.ConnectionString = "Data Source=ServerName;" + "Initial Catalog=DataBaseName;" + "Integrated Security=SSPI;"; conn.Open(); Thirdly; .NET Configuration manager (Web configuration); Put this at the top of your code: using System.Web.Configuration; using System.Data.SqlClient; Put this in Web.Config: <connectionStrings > <add name="myCo...

Why would you convert lists to tuples? Let’s say you have such data which you never want to change, then you should use tuple. (tuples == immutable). They work like the array object in JavaScript. You can add items, delete items from a list; but you cannot do that to a tuple, tuples have a fixed size. Why would you convert tuples to lists? Let’s say you want to make changes to the initial tuple created, even though you know you can't modify the data directly. Therefore, you can convert them to lists and then make the change, then convert them back to tuples. (list == mutable). Examples bellow shows conversion between tuple and list and vice versa. Here is an example demonstrating the mutable nature of lists in Python: An example showing the immutable nature of tuples in Python: An example of converting between tuples and lists to edit data: Tip:  When you create a variable, some fixed memory is assigned to the variable. If it i...

Quickly, i just want to show you a simple example of creating bar and pie chart with Tkinter . Try this simple example: import tkinter as tk root = tk.Tk() root.title("Tkinter Bar and Pie Graph") #here is for bar chart............ tk.Label(root, text='Bar Chart').pack() data = [21, 20, 19, 16, 14, 13, 11, 9, 4, 3] c_width = 400 c_height = 350 c = tk.Canvas(root, width=c_width, height=c_height, bg= 'white') c.pack() #experiment with the variables below size to fit your needs y_stretch = 15 y_gap = 20 x_stretch = 10 x_width = 20 ...

Tkinter is the standard GUI library for Python . Tk was developed as a GUI extension for the Tcl scripting language by John Ousterhout . The first release was in 1991. Both Tk and Tkinter are available on most Unix platforms, Windows and Macintosh systems . Tkinter provides a powerful object-oriented interface to the Tk GUI toolkit. Tkinter consists of a number of modules.The Tk interface is provided by a binary extension module named _tkinter . Creating a GUI application using Tkinter is fast and easy. Before we go into a simple example, lets take a quick look at the following: Tkinter widgets :Tkinter provides various controls used in a GUI application. These controls are commonly called widgets; menu menubutton button checkbutton progressbar radiobutton scale canvas combobox label labelframe entry frame listbox message notebook panedwindow tk_optionMenu Tkin...