Hi, Everybody.......
Today is beautiful day to learn coding . so , I am coming with a coding book name "Microsoft Tabular
Modeling Cookbook" it is a nice book which teaching you coding.
Let's see the Table of Contents.................
Chapter 1: Getting Started with Excel
Introduction
Creating the model
Managing the appearance of tables and fields
Using tabular relationships to filter data
Adding fields to tables
Linking fields between tables
Creating model calculations
Chapter 2: Importing Data
Introduction
Importing data as text
Importing data from databases
Managing connections and tables
Using data feeds
Chapter 3: Advanced Browsing Features
Introduction
Sorting data
Creating hierarchies for drilldown interaction
Summing aggregates and row iteration
Parent-child hierarchies
Creating and using Key Performance Indicators
Role playing dimensions and relationships
Building ratios
Chapter 4: Time Calculations and Date Functions
Introduction
Calculating running totals – totals to date
Month, quarter, and year to date aggregations
445 dates and irregularities
Last year and prior period values
Relative Time – pivoting around measures
Moving averages and last n averages
Chapter 5: Applied Modeling
Introduction
Grouping by binning and sorting with ranks
Defining many-to-many relationships
Using the last non-empty function for stock data
Performing currency calculations
Allocating data at different levels
Chapter 6: Programmatic Access via Excel
Introduction
Connecting pivot tables and Slicers
Using cube functions
Working with worksheet events and VBA
Managing the Slicer through VBA
Chapter 7: Enterprise Design and Features
Introduction
Restoring a workbook to Analysis Services
Importing models into SQL Server Data Tools
Developing models in SQL Server Data Tools
Securing data with roles
Implementing dynamic security
Creating perspectives
Chapter 8: Enterprise Management
Introduction
Deploying models from SSDT
Deploying models with the Deployment Wizard
Creating and managing partitions
Processing the data
DirectQuery and real-time solutions
Chapter 9: Querying the Tabular Model with DAX
Introduction
Retrieving data from a single table
Using projection to combine data from different tables
Restricting data with filters and where conditions
Deriving tables and selecting top n records
Chapter 10: Visualizing Data with Power View
Introduction
Creating a Power View report
Creating and manipulating charts
Using tiles (parameters)
Using and showing images
Automating the table fields with default field sets
Working with table behavior and card control
Using maps
Using multiples (Trellis Charts)
Appendix: Installing PowerPivot and Sample Databases
Installing PowerPivot
Creating the database
Index
Lets the time to download the book................
To download the book please click the download button....................
Today is beautiful day to learn coding . so , I am coming with a coding book name "Microsoft Tabular
Modeling Cookbook" it is a nice book which teaching you coding.
Let's see the Table of Contents.................
Chapter 1: Getting Started with Excel
Introduction
Creating the model
Managing the appearance of tables and fields
Using tabular relationships to filter data
Adding fields to tables
Linking fields between tables
Creating model calculations
Chapter 2: Importing Data
Introduction
Importing data as text
Importing data from databases
Managing connections and tables
Using data feeds
Chapter 3: Advanced Browsing Features
Introduction
Sorting data
Creating hierarchies for drilldown interaction
Summing aggregates and row iteration
Parent-child hierarchies
Creating and using Key Performance Indicators
Role playing dimensions and relationships
Building ratios
Chapter 4: Time Calculations and Date Functions
Introduction
Calculating running totals – totals to date
Month, quarter, and year to date aggregations
445 dates and irregularities
Last year and prior period values
Relative Time – pivoting around measures
Moving averages and last n averages
Chapter 5: Applied Modeling
Introduction
Grouping by binning and sorting with ranks
Defining many-to-many relationships
Using the last non-empty function for stock data
Performing currency calculations
Allocating data at different levels
Chapter 6: Programmatic Access via Excel
Introduction
Connecting pivot tables and Slicers
Using cube functions
Working with worksheet events and VBA
Managing the Slicer through VBA
Chapter 7: Enterprise Design and Features
Introduction
Restoring a workbook to Analysis Services
Importing models into SQL Server Data Tools
Developing models in SQL Server Data Tools
Securing data with roles
Implementing dynamic security
Creating perspectives
Chapter 8: Enterprise Management
Introduction
Deploying models from SSDT
Deploying models with the Deployment Wizard
Creating and managing partitions
Processing the data
DirectQuery and real-time solutions
Chapter 9: Querying the Tabular Model with DAX
Introduction
Retrieving data from a single table
Using projection to combine data from different tables
Restricting data with filters and where conditions
Deriving tables and selecting top n records
Chapter 10: Visualizing Data with Power View
Introduction
Creating a Power View report
Creating and manipulating charts
Using tiles (parameters)
Using and showing images
Automating the table fields with default field sets
Working with table behavior and card control
Using maps
Using multiples (Trellis Charts)
Appendix: Installing PowerPivot and Sample Databases
Installing PowerPivot
Creating the database
Index
Lets the time to download the book................
To download the book please click the download button....................
No comments:
Post a Comment