Overview of Power BI Dashboards and Visualizations in the Cortana Intelligence Suite
Learn more about Power BI dashboards and visualizations in this tip.
Dattatrey Sindol (aka Datta) is a Business Intelligence enthusiast, passionate developer, and blogger. He started his career in November 2006 and since then has 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. Currently, he is working as an Associate BI Architect at a leading IT Services company in India (Bangalore). Datta also is a Microsoft Certified IT Professional (MCITP) in SQL Server Business Intelligence 2008.
- MSSQLTips Awards: Trendsetter (25+ tips) - 2014 | Author Contender - 2014
Introduction to Azure HDInsight PowerShell
I have used PowerShell while working with the Microsoft Azure Cloud and would like to know if PowerShell can be used with HDInsight. I would also like to learn more information on how to use PowerShell for HDInsight. Can you provide some insight into the
Getting Started with HDInsight – Part 1 – Introduction to HDInsight
I have read the previous tips on Big Data Basics series of tips and have an overview of Big Data, Hadoop, and the related concepts. My current employer is more of a Microsoft shop and we use Microsoft technologies day-in and day-out. My employer is planni
SSIS XML Configurations Tips and Tricks
Package Configurations are a very powerful feature of SQL Server Integration Services (SSIS). They enable us to handle various things dynamically at run-time. In this tip, we will take a look at few Tips and Tricks on SSIS XML Package Configurations.
Big Data Basics – Part 7 – Hadoop Distributions and Resources
Explore big data basics and learn about different Hadoop distributions and how to choose the right one for your needs.
Big Data Basics – Part 6 – Related Apache Projects in Hadoop Ecosystem
I have read the previous tips in the Big Data Basics series including the storage (HDFS) and computation (MapReduce) aspects. After reading through those tips, I understand that HDFS and MapReduce are the core components of Hadoop. Now, I want to know abo
Big Data Basics – Part 5 – Introduction to MapReduce
I have read the previous tips in the Big Data Basics series including the storage aspects (HDFS). I am curious about the computation aspect of Hadoop and want to know what it is all about, how it works, and any other relevant information.
Big Data Basics – Part 4 – Introduction to HDFS
I have read the previous tips in the Big Data Basics series and I would like to know more about the Hadoop Distributed File System (HDFS). I would like to know about relevant information related to HDFS.
Big Data Basics – Part 3 – Overview of Hadoop
In this tip we do an overview of Hadoop, what it is and how it can be used to process big data.
Big Data Basics – Part 2 – Overview of Big Data Architecture
I read the tip on Introduction to Big Data and would like to know more about how Big Data architecture looks in an enterprise, what are the scenarios in which Big Data technologies are useful, and any other relevant information.
Big Data Basics – Part 1 – Introduction to Big Data
I have been hearing the term Big Data for a while now and would like to know more about it. Can you explain what this term means, how it evolved, and how we identify Big Data and any other relevant details.
SSIS Connection Manager Tips and Tricks
I have been using SQL Server Integration Services (SSIS) and I would like to know if there are any tips or tricks that can make Connection Managers more effective for developing or troubleshooting issues. In this tip we look at a few items that you shoul
SSRS Report Manager Tips and Tricks
I am new to SQL Server Reporting Services Report Manager. I need information on customizations. I have also heard about the My Reports Feature. Can you please explain that as well? Check out this tip to learn a few SQL Server Reporting Services (SSRS)
SSRS Tips and Tricks to Improve the End User Experience
In this tip, we will look at a few SQL Server Reporting Services (SSRS) Tips and Tricks to improve the end-user experience.
SSRS Expressions Tips and Tricks
Expressions are a very powerful feature of SQL Server Reporting Services (SSRS). They enable us to handle various things dynamically at run-time. In this tip, we will take a look at few Tips and Tricks on SSRS Expressions.
Querying SQL Server Index Statistics
Indexes are a great way to improve the performance of queries. However, they require regular monitoring and maintenance to ensure that the system continues to function smoothly. If indexes are not monitored regularly and appropriate action not taken then
Introduction to Data Explorer for Excel
I have been hearing about a new tool from Microsoft called Data Explorer. I would like to know what this tool is all about, how to install it, and how to get started with it.
Creating Hierarchies in PowerPivot for Excel
I want to know if it is possible to create hierarchies in PowerPivot tables similar to the hierarchies in SSAS. Also, I want to know if it is possible to create hierarchies using columns from different PowerPivot tables. In this tip we will walk through
Working with Columns and Properties in PowerPivot for Excel
I want to know if it is possible to show or hide columns in PowerPivot Tables and if it is possible to apply custom sorting on columns like sorting data in ColumnA based on data in ColumnB similar to SSAS functionality. Also, I would like to know, what ar
Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel
I have read a tip on Importing SQL Server Data from Multiple Data Sources into PowerPivot for Excel, which talks about bringing in data from two or more sources into PowerPivot and storing data from each source table/query as a separate PowerPivot table.
Creating Linked Tables in PowerPivot for Excel
I have read a tip on Importing Data from Multiple Data Sources into PowerPivot for Excel. I have data in Excel which is frequently updated and I want to know if I can consume that data from Excel in PowerPivot, while I continue to modify the data in Excel
Import SQL Data from Multiple Data Sources into PowerPivot for Excel
I have read a tip on Introduction to PowerPivot for Excel and SQL Server, which introduces us to PowerPivot add-in for Excel 2010 and also explains importing data from SQL Server into PowerPivot in brief. I want to know more about importing data into Powe
Different ways to create Custom Colors for Charts in SSRS
I recently started working with Charts in Reporting Services and while choosing the colors for charts, I see that there is a limited set of pre-defined color palettes available, and they do not meet end user needs many of the times. In this tip we look at
Handling a Large Number of Categories in a SSRS Pie Chart
When designing reports using SSRS if there are several items that need to be displayed as a Pie Chart the output sometimes gets cramped and confusing. In this tip we look at options you can use to make your charts more user friendly.