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…
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…
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…
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…
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…
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…
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…
Learn Data Analysis With Excel Free in Applied Way With Part wise labs(part-2)
If are you seeing it for 1st time do check out the Ist tutorial here. Problem Statement: While your first attempt to show the company’s performance to Lucky was not bad, clearly he has a lot more requirements than what you provided. he wants to know more about the year over year sales, sliced into…
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…
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…
