Technologies: Power Bi, Azure , SQL Server
Involved in design and development of multiple power bi Dashboards and reports.
Architecting , Designing and developing complex SSAS database and constantly monitoring the daily schedules and provides data to the ad hoc requests from the business users.
Managing data privacy and security in Power Bi
Extensively involved in designing and developing the power bi data model using multiple Dax expressions to build calculated column and calculatedmeasures.
Power BI Desktop is a free application you install on your local computer that lets you connect to, transform, and visualize your data. With Power BI Desktop, you can connect to multiple different sources of data, and combine them (often called modeling) into a data model. Power Query
Power Query is a data transformation and data preparation engine. Power Query comes with a graphical interface for getting data from sources and a Power Query Editor for applying transformations. Because the engine is available in many products and services, the destination where the data will be stored depends on where Power Query was used. Using Power Query, you can perform the extract, transform, and load (ETL) processing of data.
Power BI service is a cloud-based business analytics and data visualization service that enables anyone to visualize and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of data through easy-to-use dashboards, interactive reports, and compelling visualizations that bring data to life. Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models.
If you would take the time investment of learning DAX, your newly acquired skill does not need to limit itself to a Power BI environment. DAX can be used in tabular Microsoft products like.
EXTRACT data from its original source
TRANSFORM data by deduplicating it, combining it, and ensuring quality, to then LOAD data into the target database
SQL Server In this tutorial, you explore how to refresh a Power BI dataset from a relational database that exists on premises in your local network. Specifically, this tutorial uses a sample SQL Server database, which Power BI must access through an on-premises data gateway (SSAS) .
When using data, most people agree that your insights and analysis are only as good as the data you are using. Essentially, garbage data in is garbage analysis out. Data cleaning, also referred to as data cleansing and data scrubbing, is one of the most important steps for your organization if you want to create a culture around quality data decision-making Data Visualization .