Connecting power bi to SQL databases locally and through cloud service.

Power BI is a powerful tool designed for cleaning data ,creating reports and dashboards.It is preferred over other tools due to its ability to handle large data sets,create real-time dashboards and its beginner friendly.Power BI desktop is a free version provided by Microsoft. Main uses of Power BI Connecting data from different sources- Power BI has the ability to connect data from many sources including ;web,excel,SQL. Cleaning and transforming data-power bi is used to clean messy data making it ready to use for analysis. Data modelling-Through power bi it is possible to combine different tables with data for effective analysis. Data analysis using DAX(Data Analysis Expressions)-DAX is used to perform calculations in power bi. Data visualisation -Power BI converts data into charts,filters,slicers,graphs and reports. Reports and dashboard creation. Data automation, sharing and collaboration using Power BI service. Why companies connect Power BI to databases. Power bi's ability to hand