Practical Business Intelligence电子书

Practical Business Intelligence

Practical Business Intelligence

Credits

About the Author

About the Reviewer

www.PacktPub.com

Why subscribe?

Customer Feedback

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Downloading the color images of this book

Errata

Piracy

Questions

1. Introduction to Practical Business Intelligence

Understanding the Kimball method

Understanding business intelligence architecture

Who will benefit from this book?

Manager

Data scientist

Data analyst

Visualization developer

Working with data and SQL

Working with business intelligence tools

Power BI and Excel

D3.js

R

Python

Qlik

Tableau

Microsoft SQL Server

Downloading and installing MS SQL Server 2014

Downloading and installing AdventureWorks

Summary

2. Web Scraping

Getting started with R

Downloading and installing R

Downloading and installing RStudio

Web scraping with R

Getting started with Python

Downloading and installing Python

Downloading and installing PyCharm

Web scraping with Python

Uploading data frames to Microsoft SQL Server

Importing DiscountCodebyWeek

Importing CountryRegionBikes

Summary

3. Analysis with Excel and Creating Interactive Maps and Charts with Power BI

Getting to know your data in SQL Server

Connecting Excel to a SQL Server Table

Exploring PivotTables in Excel

Connecting Excel to SQL Statements

Exploring PivotCharts in Excel

Getting started with Microsoft Power BI

Downloading and installing Microsoft Power BI

Creating visualizations with Power BI

Publishing and sharing Microsoft BI

Summary

4. Creating Bar Charts with D3.js

Some background about the D3 architecture

Exploring HTML

Understanding CSS

Learning JavaScript

Diving into SVG

Working with a source code editor

Loading D3 templates for development

Understanding JS Bin

Downloading from D3js.org

Setting up traditional HTML components

Adding a new paragraph the traditional way

Adding a new paragraph the D3 way

Adding SVG shapes the traditional way

Adding SVG shapes the D3 way

Blending D3 and data

Visualizing hardcoded data

D3 and JavaScript functions

Reversing the y axis

Adding some color

Labeling

Fusing D3 and CSV

Preparing the CSV file

Setting up a web server

Testing the web server

Developing a bar chart with CSV data

Summary

5. Forecasting with R

Configuring an ODBC connection

Connecting R to a SQL query

Profiling dataframes in R

Creating graphs in R

Creating simple charts with plot() in R

Creating advanced charts with ggplot() in R

Creating interactive charts with plot_ly()

Time series forecasting in R

Forecasting 101

Smoothing 101

Forecasting with Holt-Winters

Formatting and publishing code using R Markdown

Getting started with R Markdown

R Markdown features and components

Executing R code inside of R Markdown

Exporting tips for R Markdown

The final output

Exporting R to Microsoft Power BI

Merging new columns to dataframes in R

Integrating R with Microsoft Power BI

Summary

6. Creating Histograms and Normal Distribution Plots with Python

Preparing a SQL Server query for human resources data

Connecting Python to Microsoft SQL Server

Starting a new project in PyCharm

Installing Python libraries manually

Establishing a connection with the PyPyODBC library

Building a SQL query inside Python

Building a dataframe with Python

Visualizing histograms in Python

Visualizing normal distribution plots in Python

Combining a histogram with a normal distribution plot

Annotating in Python

Analyzing the results

Alternative plotting libraries with Python

Publishing Jupyter Notebook

Summary

7. Creating a Sales Dashboard with Tableau

Building a sales query in MS SQL Server

Downloading Tableau

Installing Tableau

Importing data into Tableau

Exporting to a text file

Building a sales dashboard in Tableau

Building a Crosstab

Building custom calculation fields

Creating bullet graphs

Creating a KPI indicator selector

Building a sales dashboard in Tableau

Beautifying the dashboard

Connecting worksheets to dashboards

Publishing dashboard to Tableau Public

Summary

8. Creating an Inventory Dashboard with QlikSense

Getting started with QlikSense Desktop

Downloading QlikSense

Installing QlikSense

Developing an inventory dataset with SQL Server

Connecting SQL Server query to QlikSense Desktop

Developing interactive visual components with QlikSense Desktop

Building a sheet

Creating a filter pane component

Creating a custom calculation and KPI

Creating a bar chart with multiple measures

Creating a scatter plot with two measures

Publishing the inventory dashboard

Exporting to a PDF

Exporting to Qlik Cloud

Summary

9. Data Analysis with Microsoft SQL Server

Comparing tools head-to-head

Comparing the data discovery desktop applications

Data connectivity

BI maturity

Comparing the traditional programming languages

Data connectivity

Delivery

Developing views in SQL Server

Performing window functions in SQL Server

Rank functions in SQL Server

Sum functions in SQL Server

Average functions in SQL Server

Building crosstabs with case logic

Building crosstabs with pivot in SQL Server

Performing stored procedures in SQL Server

Summary