Valence Analytics
Dedicated to Analytics and Machine Learning with R and Python
Pages
(Move to ...)
Home
R Topics
Python Topics
Links
Featured Posts
▼
Showing posts with label
adventureworks
.
Show all posts
Showing posts with label
adventureworks
.
Show all posts
Tuesday, December 10, 2013
Importing Data into a Database Engine, SQL Server 2012
›
Hello Readers! Welcome back. We need data to be able to query tables. So today we will walk through how to import data into a Database Eng...
Friday, August 16, 2013
P2.1: Loading Data from External Sources to PowerPivot
›
This post will describe how to load external data sources to PowerPivot, using examples from Chapter 2 of the Ferrari PowerPivot book . ...
Sunday, August 4, 2013
P1.5: Building a Dashboard Report Using PivotTables- Excel 2013
›
In this post you will learn how to create a dashboard displaying Total Sales, percentage Growth , and ratio of Internet and Reseller sal...
Wednesday, July 24, 2013
P1.4: Working Within PowerPivot- Excel 2013
›
Hello Reader. Here we explore the data model using PowerPivot in Excel 2013 with the Chapter 1 AdventureWorks workbook from the Ferrari Po...
Friday, July 19, 2013
P1.1: VLOOKUP and PivotTables in PowerPivot- Excel 2013
›
This post describes how to add data from other sheets using VLOOKUP , and make a PivotTable in Excel 2013 from the PivotTable workbook in ...
›
Home
View web version