Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
  • Table Of Contents Toc
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
4.1 (14)
Buy this Book
close
close
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

4.1 (14)
By: Abolfazl Radgoudarzi, Reza Rad
Buy this Book

Overview of this book

Written in an easy-to-follow, example-driven format, there are plenty of step-by-step instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting. If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. It’s assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring the use of that component in Data Warehousing and Business Intelligence systems.
Table of Contents (14 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Time for action – heading
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Data Warehouse Design
Icon
1. Data Warehouse Design
Icon
Understanding Business Intelligence
Icon
The architecture and components of a BI system
Icon
Building the data warehouse
Icon
Summary
2
2. SQL Server Analysis Services Multidimensional Cube Development
Icon
2. SQL Server Analysis Services Multidimensional Cube Development
Icon
Why is OLAP required?
Icon
Understanding the SQL Server Analysis Services engine
Icon
Developing your first cube
Icon
Time for action – creating an Analysis Services project
Icon
Time for action – creating the first cube
Icon
Time for action – viewing the cube in the browser
Icon
Dimensions and measures
Icon
Time for action – using the Dimension Designer
Icon
Time for action – change the order of the Month attribute
Icon
Time for action – modifying the measure properties
Icon
Data Source View
Icon
Time for action – creating a Named Calculation
Icon
Time for action – using a Named Query
Icon
Using dimensions
Icon
Time for action – adding a Fact relationship
Icon
Hierarchies
Icon
Time for action – creating a hierarchy
Icon
Multidimensional eXpression, calculated members, and Named Sets
Icon
Time for action – writing an MDX query
Icon
Time for action – calculated members
Icon
Deploying and processing
Icon
Time for action – deploying an SSAS project
Icon
Time for action – processing the data
Icon
Summary
3
3. Tabular Model Development of SQL Server Analysis Services
Icon
3. Tabular Model Development of SQL Server Analysis Services
Icon
Introducing SSAS Tabular
Icon
Developing a tabular project
Icon
Time for action – creating a tabular project
Icon
Time for action – creating measures
Icon
Creating hierarchies
Icon
Time for action – creating a hierarchy from a single table
Icon
Time for action – creating a hierarchy from multiple tables
Icon
Data Analysis eXpression, calculated columns, and measures
Icon
Time for action – using time intelligence functions in DAX
Icon
Securing the data
Icon
Time for action – security in tabular
Icon
Storage modes
Icon
Time for action – creating a model with the DirectQuery storage mode
Icon
Tabular versus Multidimensional SSAS
Icon
Summary
4
4. ETL with Integration Services
chevron up
Icon
4. ETL with Integration Services
Icon
Understanding ETL and data consolidation
Icon
SQL Server Integration Services
Icon
Integration Service projects and packages
Icon
Time for action – creating your first SSIS project
Icon
The Control Flow tab
Icon
Time for action – working with Control Flow tasks
Icon
The Data Flow tab
Icon
Time for action – loading customer information from a flat file into a database table with a Data Flow Task
Icon
Containers and dynamic packages
Icon
Time for action – looping through CSV files in a directory and loading them into a database table
Icon
Deploying and executing
Icon
Time for action – deploying an SSIS project
Icon
Time for action – executing an SSIS package from a catalog
Icon
Summary
5
5. Master Data Management
Icon
5. Master Data Management
Icon
Understanding Master Data Management
Icon
Master Data Services
Icon
Time for action – configuring MDS
Icon
Comparing WebUI with the Excel Add-in
Icon
Time for action – installing Excel Add-in
Icon
Creating models and entities
Icon
Time for action – creating a model and an entity
Icon
Time for action – creating an entity with data from the Excel Add-in
Icon
Time for action – change tracking
Icon
The entity relationship
Icon
Time for action – creating a domain-based relationship
Icon
Business rules
Icon
Time for action – creating a simple business rule
Icon
Working with hierarchies
Icon
Time for action – creating a derived hierarchy
Icon
Security and permission
Icon
Time for action – permission walkthrough
Icon
Integration management
Icon
Time for action – a subscription view
Icon
Time for action – entity-based staging
Icon
Summary
6
6. Data Quality and Data Cleansing
Icon
6. Data Quality and Data Cleansing
Icon
Understanding data quality
Icon
Data Quality Services
Icon
Time for action – installing Data Quality Services
Icon
Knowledge Base Management
Icon
Time for action – creating a Knowledge Base
Icon
Knowledge discovery
Icon
Time for action – knowledge discovery
Icon
Data cleansing with Data Quality Projects
Icon
Time for action – using Data Quality Project for cleansing
Icon
Domain and composite domain rules
Icon
Time for action – composite domain rules
Icon
Synonyms and standardization
Icon
Time for action – creating synonyms and setting standardization
Icon
Matching
Icon
Time for action – matching policy
Icon
Time for action – matching projects
Icon
Integrating with MDS and SSIS
Icon
Time for action – the DQS cleansing component in SSIS
Icon
Summary
7
7. Data Mining – Descriptive Models in SSAS
Icon
7. Data Mining – Descriptive Models in SSAS
Icon
An introduction to data mining
Icon
The Microsoft Decision Tree algorithm
Icon
Time for action – creating a data mining solution with the Microsoft Decision Tree algorithm
Icon
Microsoft association rules
Icon
Time for action – the Microsoft association rule
Icon
Summary
8
8. Identifying Data Patterns – Predictive Models in SSAS
Icon
8. Identifying Data Patterns – Predictive Models in SSAS
Icon
Finding the best algorithm
Icon
Time for action – finding the best mining model with Lift Chart and Profit Chart
Icon
Predicting data with DMX
Icon
Time for action – predicting prospective bike buyers
Icon
Microsoft Time Series
Icon
Time for action – predicting future sales with Microsoft Time Series
Icon
Summary
9
9. Reporting Services
Icon
9. Reporting Services
Icon
The Reporting Services architecture
Icon
Developing a basic report
Icon
Time for action – creating our first report using SSRS
Icon
Extended report development
Icon
Time for action – adding parameters to a report
Icon
Printing and page configuration
Icon
Time for action – changing a page's properties
Icon
Sorting and grouping
Icon
Time for action – applying ordering and grouping on the data rows
Icon
Expressions
Icon
Time for action – changing the background color of data rows based on expressions
Icon
Time for action – working with charts in Reporting Services
Icon
Deploying and configuring
Icon
Time for action – deploying a report
Icon
Time for action – using Report Manager
Icon
Summary
10
10. Dashboard Design
Icon
10. Dashboard Design
Icon
The PerformancePoint service
Icon
Time for action – configuring PerformancePoint in SharePoint
Icon
Time for action – creating your first dashboard with PerformancePoint Dashboard Designer
Icon
Time for action – creating a dashboard page
Icon
Time for action – exploring on-the-fly features
Icon
Time for action – working with filters
Icon
Power View
Icon
Time for action – enabling Power View in Excel
Icon
Time for action – creating the first Power View dashboard
Icon
Time for action – geographical data visualization using Power View
Icon
Time for action – visualizing time-based information with a scatter chart
Icon
Time for action – using Filter in Power View
Icon
Summary
11
11. Power BI
Icon
11. Power BI
Icon
Self-service ETL with Power Query
Icon
Time for action – self-service ETL with Power Query
Icon
Power Map
Icon
Time for action – data visualization with Power Map
Icon
Summary
12
12. Integrating Reports in Applications
Icon
12. Integrating Reports in Applications
Icon
Designing .NET applications with reports
Icon
Time for action – installing AdventureWorks SSRS sample reports
Icon
Developing reports in a web application
Icon
Time for action – working with reports in web/Windows applications
Icon
Developing reports in a Metro application
Icon
Time for action – working with reports in Metro applications
Icon
Working with ReportViewer in a local processing mode
Icon
Time for action – designing reports and working with the local processing mode
Icon
Passing parameters to a report
Icon
Time for action – changing a report configuration with a ReportViewer Object through code behind
Icon
Using the results of a mining model in an application
Icon
Time for action – running DMX queries from a .NET application
Icon
Summary
13
Index
Icon
Index

Time for action – looping through CSV files in a directory and loading them into a database table

In this example, we will use the Foreach Loop container to loop through files in a directory, and then we will set the connection manager of the source file dynamically in the flat file source, and load the content of the source file into the destination database table. Then, we will write a log entry into the database with the name of the file and load date time. For this example, we use packages and tasks that we developed in the last two examples:

  1. Create a new SSIS package and name it Master Package. Drag-and-drop a Foreach Loop container in Control Flow.

  2. Create a variable with a string type and name it FilePath.

  3. Double-click on the Foreach Loop Container. In the Foreach Loop Container Editor, set Enumerator as Foreach File Enumerator.

  4. In the Enumerator configuration, set the source directory to the path of the directory that contains Customers CSV files. Leave other settings as they are:

  5. Go to...

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
End of Chapter 4
Next Chapter
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon