Azure Responsibilities

             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.

Key Skills

Power Bi Desktop

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.

DAX

 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.

 ETL

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

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) .

Data Cleaning

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 .