Big Data Series

Big Data – Series 1 – Part 2 – Traditional Data vs Big Data

This video is part of the series: Introduction to Big Data. In this video, we will look into the details regarding the sources of Big Data and how the data is stored and utilized. The information is intentionally kept at a very high-level to make the content simple and understandable to the audience. (Click Heading for more)

Big Data Series

Big Data: Series 1 Part 1 – Introduction to Big Data

Introduction to Big Data: This video is an attempt to provide a high-level view of Big Data. I hope you enjoy the content.Click YouTube Link or Heading to Watch.. https://youtu.be/PdBajE0yiKQ

Modern Data Architecture

Data Architecture – Series 1 Part 1 – Data Architecture Introduction

Data Architecture refers to the art and science of building data structures and the process of building enterprise data structures. In this series of videos, you can learn the elements of data-architecture as an Introduction.

Productivity Tips

Productivity Tips – Time management

Time management is the most important factor for Productivity. There are only 24 hours in a day for everyone Some people make the time productive and the others not that much. In this video let us see some tips and tricks how to make use of the time in a timely and productive way

Productivity Tips

Productivity Tips – Mindfulness

Mindfulness is the psychological process of purposely bringing one's attention to experiences occurring in the present moment without judgment, which one develops through the practice of meditation and through other training.

Python

5 Python Conditional Statement 4 – If..else..elif

If..else..elif If..else..elif : code if person_age < 4: ticket_price = 0elif person_age < 18: ticket_price = 5elif person_age < 65: ticket_price = 10else: ticket_price = 5 Python does not require an else block at the end of an if-elif chain. Sometimes an else block is useful; sometimes you can avoid using.

Python

5 Python Conditional Statements 3 – Condition operators or symbols

Condition symbols or operators Operators evaluation: 1) == Equal to operator - True when matches - False when don't match.CASE == CASE (matches and True in this case)Name = 'Vijay'Name == 'vijay' (False)Age = 18Age == 18 (True) 2) != not equal to operator - True when matches - False when don't match. CASE !=… Continue reading 5 Python Conditional Statements 3 – Condition operators or symbols

Python

5 Python Conditional statements 2 – Simple If..else

simple If..else statement Simple If..else statement: code cities = ['LA', 'Chicago', 'kansas city', 'columbia','Boston'] for city in cities: if city == 'Boston': print(city.upper()) else: print(city.title()) Results: La Chicago Kansas City Columbia BOSTON if statement is an expression that can be evaluated as True or False and is called a conditional test. If a conditional test… Continue reading 5 Python Conditional statements 2 – Simple If..else

Python

5 Python Condition Statements 1 – Intro

Python Conditional Evaluation Programming often involves examining a set of conditions and deciding which action to take based on those conditions. Python’s if statement allows you to examine the current state of a program and respond appropriately to that state. Programming Statements: If...elif...else If..Else statements can be used with:VariablesListsArraysand more....

Python

4 Python List – Pointing to the same List

Pointing to a list Assigning the a variable to a List - Code BOTH VARIABLES POINTING TO THE SAME LIST Any changes made to list appears same in both variables now VAR1 = VAR2 - there is no : used in this case print("Copying list from one to another") my_favorite_foods = ['pizza', 'rice', 'cake'] friends_favorite_foods… Continue reading 4 Python List – Pointing to the same List

Python

4 Python List – Appending to a list

Appending Appending: Code #APPENDING TO LIST print("Copying list from one to another") my_favorite_foods = ['pizza', 'rice', 'cake'] friends_favorite_foods = my_favorite_foods[:] #APPEND print("Append new food items") my_favorite_foods.append('fruits') friends_favorite_foods.append('ice cream') Print print("My favorite foods are:") print(my_favorite_foods) print("\nMy friend's favorite foods are:") print(friends_favorite_foods) Results: Append new food items My favorite foods are: ['pizza', 'rice', 'cake', 'fruits', 'ice cream']… Continue reading 4 Python List – Appending to a list

Python

4 Python Lists – Copying Lists

Copying List COPYING LIST code print("Copying list from one to another") my_favorite_foods = ['pizza', 'rice', 'cake'] friends_favorite_foods = my_favorite_foods[:] print("My favorite foods are:") print(my_favorite_foods) print("\nMy friend's favorite foods are:") print(friends_favorite_foods) Results: Copying list from on to another My favorite foods are: ['pizza', 'rice', 'cake'] My friend's favorite foods are: ['pizza', 'rice', 'cake']

Python

4 Python List – Slicing the List

SLICING a LIST code players = ['Vijay', 'Mohan', 'Vasu', 'Sai', 'Chandika','Shreya'] print("Here are the three players from 2ND PLAYER ONWARDS on my team:") print(players[1:4]) players = ['Vijay', 'Mohan', 'Vasu', 'Sai', 'Chandika','Shreya'] print("Here are the FIRST THREE players on my team:") print(players[0:3]) players = ['Vijay', 'Mohan', 'Vasu', 'Sai', 'Chandika','Shreya'] print("Here are the FIRST FOUR players on… Continue reading 4 Python List – Slicing the List

Python

4 Python LIST – Looping through a slice

Python LIST Looping Through a SLICE print("Looping through SLICE code") players = ['Vijay', 'Mohan', 'Vasu', 'Sai', 'Chandika','Shreya'] print("Here are the first three players on my team:") for player in players[:3]: print(player.title()) Results Looping through SLICE code Here are the first three players on my team: Vijay Mohan Vasu

Big Data Series

Traditional DBMS vs Big data

Traditional processing VS Real time In traditional relational database management systems, data was often moved to computational space for processing. In Big Data space bringing the computation to where data is located. So, everything is real-time. A key feature of these types of real-time notifications is that they enable real-time actions. However, using such a capability would require you to… Continue reading Traditional DBMS vs Big data

Big Data Series

IOT: Internet of things

Big Data - IOT Big data generated by machines. It's everywhere and there's a lot. If you look at all sources of big data, machine data is the largest source of big data. This complex data sensing capability smart and called as smart data. A smart phone gives you a way to track many things,… Continue reading IOT: Internet of things

Big Data Series

Big data: source and value.

Big Data Technologies The main sources of Big Data are data generated by machines, people, and organisations.Machine generated data we refer to data generated from real time sensors in industrial machinery or vehicles that logs that track user behaviour online, environmental sensors or personal health trackers, and many other sense data resources.Human generated data, we… Continue reading Big data: source and value.

Relational Data Warehouse

6. Introduction to DWBI – Goals of Data Warehouse

Building a Data warehouse Purpose & Goals of Data Warehouse Purpose & Goals of Data Warehouse: Focus on fundamentals before delving into details of modeling and implementation. Listen to the Business and understand the goals and current pain points in reporting the business needs. The Data warehouse must make the organizational information readily available and… Continue reading 6. Introduction to DWBI – Goals of Data Warehouse

Relational Data Warehouse

5. Introduction to DW&BI – ETL Extract Transform and Load

ETL – Extract Transform & Load Extract Transform and Load: ETL means Extract, Transform, and Load. ETL is a process combined with technology. Using this process data is extracted from all sources, and depending on the user requirements the data is transformed for reporting needs, and finally, data loaded into the Data warehouse. ETL is… Continue reading 5. Introduction to DW&BI – ETL Extract Transform and Load

Relational Data Warehouse

4.Introduction to DW & BI – DWBI Cycle

DWBI Cycle Data Warehousing and Business Intelligence: A real Business Intelligence passes through a Data warehouse and utilizes the data-stored for information, knowledge, and plans that produce effective business actions. So, Business Intelligence is a combination of process, technology, and a tool. Means Business Intelligence encompasses Data warehouse, Tools, and Visual knowledge management. Among all,… Continue reading 4.Introduction to DW & BI – DWBI Cycle

Relational Data Warehouse

3.Introduction to DW&BI – Kimball or Inmon Model

Data warehouse - Kimball or Inmon model. The following information provides an understanding of the basics of two different approach in Data warehouse modeling: History of Data Warehouse: In 1990 Inmon wrote a book "Building the Data Warehouse." Inmon defines an architecture for the collection of disparate sources into detailed, time variant data store (The… Continue reading 3.Introduction to DW&BI – Kimball or Inmon Model

Relational Data Warehouse

2.Introduction to DW&BI – Why DWBI?

Why DWBI Executives and Manager managing business challenged for new avenues to improve the business and economic conditions. The challenge is to do more with less and to make better decisions in a competitive industry. DWBI environment provides access to actionable data to act in a short time. The impressive reputation of DWBI in the… Continue reading 2.Introduction to DW&BI – Why DWBI?

Relational Data Warehouse

1.Introduction to DW & BI – What is Data Warehouse & Business Intelligence

Introduction to Data Warehouse and Business Intelligence What is a Data Warehouse? Defining a Data warehouse is very simple. A data warehouse is a data repository were all relevant Enterprise data is stored and provides as a single source for the Enterprise reports, analysis, and presentation through ad-hoc reports, canned reports, portals, and dashboards. What is… Continue reading 1.Introduction to DW & BI – What is Data Warehouse & Business Intelligence

Big Data Series

SSDB – Part 13. ETL – Connecting Foreign Keys to Surrogate Keys

Connecting Foreign Keys to Surrogate Keys

Big Data Series

SSDB – Part 12. ETL – Creating Date Lookup Tables

Creating Date Lookup Tables

Big Data Series

SSDB – Part 11. ETL – Redefining Nullable Values for Enhanced Reporting

Redefining Nullable Values for Enhanced Reporting: CLICK to Continue Reading.......

Big Data Series

SSDB – Part 10. ETL – Combining Data from Multiple Tables

Combining data from multiple tables: CLICK to continue reading....

Big Data Series

SSDB – Part 9. ETL – Reformatting Data to Make it More Readable

Reformatting Data to Make it More Readable.....CLICK to Continue reading..........

Big Data Series

SSDB – Part 8. ETL – Converting Data types for consistency

Converting Data Types for consistency:......... READ/VIEW VIDEO.................

Big Data Series

TSQL – Part 1(d) – Working with NULLS

NULL is used to indicate an unknown or missing value. NULL is not equivalent to zero or an empty string.
Arithmetic or string.

CLICK to READ ....

Big Data Series

TSQL – Part 1(c) – Data Types

Transact-SQL supports a wide range of data types, which can be broadly categorized as exact numeric, approximate numeric, character, date/time, binary, and other.

CLICK TO READ...................

Big Data Series

TSQL – Part 1(b) – SELECT statement

Use the SELECT statement to retrieve a rowset of data from tables and views in a database..

CLICK TO READ --------------

Big Data Series

TSQL – Part 1(a) – Introduction to Transact SQL

Transact-SQL is an essential skill for database professionals and developers working with Microsoft SQL Server.

CLICK to READ -----------------

Big Data Series

SSDB – Part 4. ETL – Slowly Changing Dimension SCD Type 2 and 3

Extract Transform and Load using SQL server database stored procedure.

Big Data Series

Big data Lifecycle

Big Data Life Cycle http://www.technologyreview.com/view/539566/securing-the-big-data-life-cycle/