Understand The Service Azure Provides for Data Engineers

Even the most experienced data engineer can feel overwhelmed by the range of data platform technologies in Microsoft Azure. In diverse scenarios and industries, data engineers must solve complex data problems to provide business value through data. By understanding the data types and capabilities of the data platform technologies, a data engineer can pick the…

Rate this:

Data Mining Concepts in SQL SERVER 2014

Data mining is the process of discovering actionable information from large sets of data. Data mining uses mathematical analysis to derive patterns and trends that exist in data. Typically, these patterns cannot be discovered by traditional data exploration because the relationships are too complex or because there is too much data. These patterns and trends…

Rate this:

Learn Git In Simple Way

To check whether you have git install in your device in your terminal type git –version let’s talk about git init command in details. The git init command creates a new Git repository. It can be used to convert an existing, un- versioned project to a Git repository or initialize a new, empty repository. Most other Git…

Rate this:

Let’s Excel

SCENARIO VanArsdel is a company that manufactures and sells sporting goods. The company has offices in the United States (US) and several other countries. Its sales comprise of US sales and International sales. VanArsdel’s sales come from its owned manufactured products, as well as other manufacturers’ products.  Bobby is a district manager who is responsible for several…

Rate this:

Creating Mash-ups of data from multiple source in Excel

VanArsdel is a company that manufactures and sells sporting goods. The company has offices in the United States (US) and several other countries. Its sales comprise of US sales and International sales. VanArsdel’s sales come from its owned manufactured products, as well as other manufacturers’ products.  VanArsdel’s US office stores the sales data on a SQL…

Rate this:

Explore the Excel Data Model

Download and open file You should see a blank worksheet when opening the file. Open the Data Model by selecting the Manage Data Model icon from either the Data or PowerPivot tabs in Excel 2016; from the PowerPivot tab in Excel 2013; or the Power Pivot Window icon from the PowerPivot tab in Excel 2010.The…

Rate this:

Explore the Classic Excel Dashboard

Problem: VanArsdel is a company that manufactures and sells sporting goods. The company has offices in the United States (US) and several other countries. Its sales comprise of US sales and International sales. VanArsdel’s sales come from its owned manufactured products, as well as other manufacturers’ products. VanArsdel’s Canada’s office has sent you their sales…

Rate this:

Learn Data Analysis With Excel Free in Applied Way With Part wise labs(part-1)

Problem statement: You are the new marketing manager of an established Bicycle company. The company sells bicycles and accessories, such as clothing and other accessories to bikers in six countries. The company has just hired Lucky as its new Sales manager. You are tasked to introduce Lucky to the company, its product portfolio and its…

Rate this:

Device Security for cloud iot device

Security is a critical concern when deploying and managing IoT devices. Cloud IoT Core offers the following security features: Per-device public/private key authentication using JSON Web Tokens (JWTs, RFC 7519). This limits the surface area of an attack, because a compromised key would affect only a single device and not the whole fleet. JWTs are valid…

Rate this: