Maintenance plans in SQL Server give us an easy way to organize, configure, and schedule tasks that ensure that the database engine and the databases that are hosted therein are kept in shape.
Read MorePivoting, Unpivoting, and Splitting Columns in Power BI Query Editor
For reference, Power BI is a data visualization and analytics software developed by Microsoft. Power BI can be used for static as well as interactive data visualization. Before you can create actual visualizations with Power BI, you can perform data preprocessing using Power BI Query editor.
Read MoreFormatting Data in Power BI Desktop Visualizations
Microsoft’s Power BI is a data analytics tool that can be used for interactive data visualization, using data from various sources such as relational and NoSQL databases, flat files, web servers, etc.
Read MoreImplementing Hierarchies in Power BI Desktop Visualizations
For starters, Microsoft Power BI is one of the most commonly used data analytics and visualization tools. With its help, you can import and visualize data from various sources, such as text and CSV files, relational databases, web servers, etc. Power BI comes in two flavors: Desktop and Cloud-Based Service.
Read MoreHow to Use Semantic Search in SQL Server
This article deals with the basics of Semantic Search, including a complete walkthrough of Semantic Search: starting from scratch and finishing with a ready-to-use feature.
Additionally, the readers are going to learn about some of the very useful but not generally known Search features available in SQL Server like Semantic Search, which we’ll demonstrate with some basic examples.
Read More7 Facts About SQL Server Synonyms You Should Know
Before SQL Server Synonyms appeared, everyone wished to simplify and enhance their database experience.
Imagine you have an application with a database that references another database from the same server. Then, a major reorganization forces your team to transfer the other database to another server.
There is no doubt your application will break. But what will you do in that case? Link the 2 servers and hardcode all the references (again) to point to the new server?
Read MoreData Visualization in Microsoft Power BI
Contents
- Introduction.
- How to create a table.
- How to create a Power BI pie chart.
- Creating a line chart in Power BI.
- Report creation.
- Conclusion.
Introduction
The final article will take us through Power BI Visualizations and how to create them using the data sets created previously in these series. The walkthrough will cover 3 basic Visualizations: Table, Pie Chart, and Line Chart. These will then combine to create a basic report/dashboard within Power BI.
Read MoreLoading and Managing Data within Microsoft Power BI
Contents:
- Introduction
- Importing data from Excel, SQL Server, and the Web.
- Data Manipulation Basics in Power BI.
- Managing relationships within Power BI.
- Conclusions.
Introduction
This article will cover off importing data, manipulating data, and finally managing relationships within Power BI. Again, like the previous article, this one will focus on the basic principles of using Power BI, as opposed to an in-depth walkthrough.
Read MoreIntroduction to Microsoft Power BI
This article will help you get to grips with the basics of Power BI and what it has to offer as an analytics tool. Along the way, we’ll cover the following: what Power BI is; why we need Power BI; Excel Vs Power BI; and, finally, installing Power BI.
Read MoreLearn to Perform Product Analysis with SQL Server Full-Text Search. Part 2
This article is dedicated to a slightly more complex product analysis with Full-Text Search as opposed to the first part where we looked at how to perform a basic product analysis.
Read More