Dattatrey Sindol
My name is Dattatrey Sindol (aka Datta). I am a Business Intelligence enthusiast, passionate developer, and a blogger. I started my career in November 2006 and since then I have worked on various technologies including SQL Server BI, Power BI, Microsoft Azure, & Azure HDInsight within Microsoft Stack and other Cloud & Big Data technologies outside Microsoft Stack. I am currently working as an Associate BI Architect at a leading IT Services company in India (Bangalore). More about me: http://dattatreysindol.com/aboutauthor.
I am a Microsoft Certified IT Professional (MCITP) in SQL Server Business Intelligence 2008.
You can connect with me on My Blog (http://dattatreysindol.com), or on one of these people networking sites - Twitter / LinkedIn.
2014 Awards
Big Data
- Big Data Basics - Part 1 - Introduction to Big Data (last update: 12/26/2013)
- Big Data Basics - Part 2 - Overview of Big Data Architecture (last update: 1/9/2014)
- Big Data Basics - Part 3 - Overview of Hadoop (last update: 1/30/2014)
- Big Data Basics - Part 4 - Introduction to HDFS (last update: 2/28/2014)
- Big Data Basics - Part 5 - Introduction to MapReduce (last update: 5/5/2014)
- Big Data Basics - Part 6 - Related Apache Projects in Hadoop Ecosystem (last update: 6/20/2014)
- Big Data Basics - Part 7 - Hadoop Distributions and Resources to Get Started (last update: 8/14/2014)
- Getting Started with HDInsight - Part 1 - Introduction to HDInsight (last update: 11/26/2014)
- Getting Started with HDInsight - Part 2 - Introduction to Azure HDInsight PowerShell (last update: 12/5/2014)
- Getting Started with HDInsight - Part 3 - Creating an HDInsight Cluster in Microsoft Azure Cloud (last update: 12/8/2014)
Cortana
- Introduction to Microsoft Cortana Intelligence Suite (last update: 7/8/2016)
- Overview of Big Data Stores in the Cortana Intelligence Suite (last update: 9/13/2016)
- Overview of Information Management in Cortana Intelligence Suite (last update: 8/24/2016)
- Overview of Intelligence Pillar in the Cortana Intelligence Suite (last update: 12/14/2016)
- Overview of Machine Learning and Analytics in Cortana Intelligence Suite (last update: 10/18/2016)
Indexing
- Querying SQL Server Index Statistics (last update: 6/21/2013)
Integration Services Configuration Options
- SQL Server Integration Services XML Configurations Tips and Tricks (last update: 9/3/2014)
Integration Services Connection Managers
- SQL Server Integration Services Connection Manager Tips and Tricks (last update: 10/3/2013)
Microsoft Excel Integration
- Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel (last update: 2/25/2013)
- Creating Hierarchies in PowerPivot for Excel (last update: 3/18/2013)
- Creating Linked Tables in PowerPivot for Excel (last update: 12/31/2012)
- Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel (last update: 12/26/2012)
- Introduction to Data Explorer for Excel (last update: 5/16/2013)
- Working with Columns and Properties in PowerPivot for Excel (last update: 3/8/2013)
Power BI
- Overview of Power BI Dashboards and Visualizations in the Cortana Intelligence Suite (last update: 2/21/2017)
Professional Development Interview Questions BI
- SQL Server Analysis Services Interview Questions on Dimensions, Hierarchies and Properties (last update: 5/11/2012)
- SQL Server Analysis Services Interview Questions Part II - Dimensions (last update: 4/10/2012)
- SSAS Interview Questions on Aggregations, Translations, Perspectives, and Security (last update: 8/24/2012)
- SSAS Interview Questions on Deployment, Processing, Querying, and Accessing (last update: 8/31/2012)
- SSAS Interview Questions on Measures, Actions, and Storage (last update: 7/16/2012)
- SSAS Interview Questions Part I: Questions on Basic Concepts, Data Sources, and Data Source Views (last update: 3/28/2012)
Reporting Services Analysis Services
- Cumulative Aggregates in SQL Server Reporting Services (last update: 1/20/2012)
Reporting Services Charts
- Different ways to create Custom Colors for Charts in SQL Server Reporting Services (last update: 10/31/2012)
- Handling a Large Number of Categories in a SQL Server Reporting Services Pie Chart (last update: 9/28/2012)
Reporting Services Configuration
- SQL Server Reporting Services Report Manager Tips and Tricks (last update: 9/6/2013)
Reporting Services Development
- SQL Server Reporting Services Expressions Tips and Tricks (last update: 8/8/2013)
Reporting Services Formatting
- SQL Server Reporting Services Tips and Tricks to Improve the End User Experience (last update: 8/23/2013)
Scripts
- SQL Server Row Count for all Tables in a Database (last update: 4/21/2021)
SQL Server Agent
- Querying SQL Server Agent Job Information (last update: 12/9/2011)
SQL Server Configurations
- Windows Services for SQL Server (last update: 3/23/2012)
